Python:Files - Revision history

Hdridder: /* Filehandling and metadata */

2026-05-03T10:16:12Z

Filehandling and metadata

← Older revision		Revision as of 10:16, 3 May 2026
Line 100:		Line 100:
	;Walking a directory tree and fetching file information		;Walking a directory tree and fetching file information
	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>
	def do_dir(directory:		def do_dir(directory):
	with os.scandir(directory) as it:		with os.scandir(directory) as it:
	for entry in it:		for entry in it:

Hdridder: /* Filehandling and metadata */

2025-08-20T20:03:01Z

Filehandling and metadata

← Older revision		Revision as of 20:03, 20 August 2025
Line 98:		Line 98:
	:<code>statinfo.st_size</code> has the filesize in bytes.		:<code>statinfo.st_size</code> has the filesize in bytes.

	;Walking a ~~direcotry~~ tree and fetching file information		;Walking a directory tree and fetching file information
	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>
	def do_dir(directory:		def do_dir(directory:

Hdridder: /* Basics */

2025-05-20T12:49:30Z

Basics

← Older revision		Revision as of 12:49, 20 May 2025
Line 2:		Line 2:

	=Basics=		=Basics=
	;~~dirname,~~basename = path.split('/')		;basename = path.split('/')[-1]
	:Get the filename from a path		:Get the filename from a path
			;dirname = re.sub('/[^/]+/$', '/', path)
			:Get the directory name from a path
	;glob.glob(filespec)		;glob.glob(filespec)
	:Return a [[Python:DataTypes#list\|list]] of files matching 'filespec'.		:Return a [[Python:DataTypes#list\|list]] of files matching 'filespec'.

Hdridder: /* Filehandling and metadata */

2025-05-20T12:40:47Z

Filehandling and metadata

← Older revision		Revision as of 12:40, 20 May 2025
Line 83:		Line 83:
	;os.unlink(filename)		;os.unlink(filename)
	:Remove file or symbolic link		:Remove file or symbolic link

			;shutil.copy(source, destination)
			:Copy file from source to destination, destination can be both a file or a directory
			;shutil.copyfile(source, destination)
			:Copy file from source to destination, both as full path
			;shutil.move(source, destination)
			:Move file from source to destination, destination can be both a file or a directory

	;statinfo = os.stat(filename)		;statinfo = os.stat(filename)

Hdridder: /* Reading */

2025-05-20T09:50:01Z

Reading

← Older revision		Revision as of 09:50, 20 May 2025
Line 169:		Line 169:
	=[[XLS\|Excel files]]=		=[[XLS\|Excel files]]=
	==Reading==		==Reading==
	Excel-files is basically a zip-file with some specific content and they can be handled like that. [[Pandas]] has a build in ability to read excel into a dataframe. Whenever possible use that, else check [[XLS]].		Excel-files is basically a zip-file with some specific content and they can be handled like that. [[Pandas#Reading_Data]] has a build in ability to read excel into a dataframe. Whenever possible use that, else check [[XLS]].

	==Writing==		==Writing==

Hdridder: /* Basics */

2025-05-20T09:22:54Z

Basics

← Older revision		Revision as of 09:22, 20 May 2025
Line 2:		Line 2:

	=Basics=		=Basics=
			;dirname,basename = path.split('/')
			:Get the filename from a path
	;glob.glob(filespec)		;glob.glob(filespec)
	:Return a [[Python:DataTypes#list\|list]] of files matching 'filespec'.		:Return a [[Python:DataTypes#list\|list]] of files matching 'filespec'.
Line 15:		Line 17:
	;fh = open (filename,"r")		;fh = open (filename,"r")
	:open filename for read and return the filehandle fh. Use w for write, a for append.		:open filename for read and return the filehandle fh. Use w for write, a for append.
			;fh.write(line)
			:Write line to file opened on filehandle f1.
			:NOTE: you have to make sure the line-end is in the line too.
	;fh.close()		;fh.close()
	:Close the file for filehandle fh.		:Close the file for filehandle fh.
			;sys.stdout.write(<string>)
			:Write to standard output

	Code example:		Code example:
Line 49:		Line 55:
	</syntaxhighlight>		</syntaxhighlight>

			==Other ways of reading==
	;f1.read(size)		;f1.read(size)
	:Return 'size' bytes from the file as [[Python:Strings\|string]]. If size is omitted or 0 the entire file is returned.		:Return 'size' bytes from the file as [[Python:Strings\|string]]. If size is omitted or 0 the entire file is returned.
Line 72:		Line 79:
	<codeblock>		<codeblock>
	</syntaxhighlight>		</syntaxhighlight>

	~~;f1.write(line)~~
	~~:Write line to file opened on filehandle f1~~

	~~;sys.stdout.write(<string>)~~
	~~:Write to standard output~~

	~~;basename = filepath.split('/')[-1]~~
	~~:Get the filename from a path~~

	=Filehandling and metadata=		=Filehandling and metadata=

Hdridder: /* Reading */

2025-05-15T06:34:26Z

Reading

← Older revision		Revision as of 06:34, 15 May 2025
Line 171:		Line 171:
	=[[XLS\|Excel files]]=		=[[XLS\|Excel files]]=
	==Reading==		==Reading==
	Excel-files is basically a zip-file with some specific content and they can be handled like that. [[Pandas]] has a build in ability to read excel into a dataframe~~, if~~ possible use that.		Excel-files is basically a zip-file with some specific content and they can be handled like that. [[Pandas]] has a build in ability to read excel into a dataframe. Whenever possible use that, else check [[XLS]].

	==Writing==		==Writing==
	Below writes a list of lists to excel		Below writes a list of lists to excel

Hdridder: /* Writing */

2025-05-01T07:54:26Z

Writing

← Older revision		Revision as of 07:54, 1 May 2025
Line 176:		Line 176:
	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>
	import xlsxwriter		import xlsxwriter
			import json

	def main():		def main():
	workbook = xlsxwriter.Workbook(excelfilename, {'nan_inf_to_errors': True})		workbook = xlsxwriter.Workbook(excelfilename, {'nan_inf_to_errors': True})

	header = ['Column1', '~~Column1~~']		header = ['Column1', 'Column2']

	writeworkbook(workbook, worksheetname, alist, header)		writeworkbook(workbook, worksheetname, alist, header)
Line 186:		Line 187:
	workbook.close()		workbook.close()
	return		return


	def writeworkbook(workbook, worksheetname, outlist, header):		def writeworkbook(workbook, worksheetname, outlist, header):
Line 199:		Line 201:
	columnno = 0		columnno = 0
	for column in row:		for column in row:
	columnwidths[columnno] = max(columnwidths[columnno], len(str(column)))		try:
			columnwidths[columnno] = max(columnwidths[columnno], len(str(column)))
			except KeyError:
			# The rows may have variable length
			columnwidths[columnno] = len(str(column))
	columnno += 1		columnno += 1

Line 208:		Line 214:
	worksheet.write_row(wsindex, 0, header)		worksheet.write_row(wsindex, 0, header)
	for row in outlist:		for row in outlist:
			columnno = 0
			for column in row:
			if type(column) in (list, tuple, dict):
			row[columnno] = str(column)
			columnno += 1
	wsindex += 1		wsindex += 1
	worksheet.write_row(wsindex, 0, row)		worksheet.write_row(wsindex, 0, row)

	return		return


	main()		main()

Hdridder: /* Basics */

2024-10-30T15:00:16Z

Basics

← Older revision		Revision as of 15:00, 30 October 2024
Line 60:		Line 60:
	:If there are no files on the commandline read standard input		:If there are no files on the commandline read standard input
	:You can pass other arguments too but you have to remove them from sys.argv before you start reading fileinput		:You can pass other arguments too but you have to remove them from sys.argv before you start reading fileinput
			;fileinput.filename()
			:The name of the we are working on

	<syntaxhighlight lang=python>		<syntaxhighlight lang=python>
	import fileinput		import fileinput

Hdridder: /* Read an Excel file */

2023-12-12T15:29:04Z

Read an Excel file

@@ Line 166: / Line 166: @@
-=[[XLS|Read an Excel file]]=
+=[[XLS|Excel files]]=
-Excel-files is basically a zip-file with some specific content.
+==Reading==
 =Read from standard input and keyboard=