when we need to write script or automate our work the first thing that came into our mind is that how we can deal with files to store our result or to read stored data.

so in this brief intro about how you can deal with files in python  I hope this articale  will help you 

we will cover all things that you'll need to start working with files 

fileHandlerName : this is the name of the object that will contain all attributes(functions) that we will need to perform any operation on this file  (eg. read , write , readlines ...) 

open() : will open the specified file and return the handler object with specified mode.

file path : here we need some explain to this parameter which this always the path related to where is the terminal that you run this python so if you don't need to have a relative path then you need to specify the full path but we can do this with a lot of ways 

let's explain some of these ways. 

we can do this as we say "hard coded " so it will be never changed  EX :  "e:/Files_Test/test.c" 

or we can path it to the terminal as argument :

but here we need to import sys library to use its attributes : 

so we can use it like this  : open ( sys.argv[1] , "r")

or if you need to use it as a parient path so you can use it as following  : open (rf"{sys.argv[1]}/test.c")

or from importing os libarary 

os.getcwd() : this will return current working directory 

as you see a lot of ways to do the same thing this will add to you a lot of flexibility to development your script 

we can control the position of the cursor using  FileHandlerName.seek(0 , 0 ) so we can navigate in file using this method ]

seek take two arguments ( Offset , Position )

Offset : the position of where the cursor in the line 

Position : take 3 values ( 0 : file beginning , 1 : current line , 2 : end of file )

now  we learnt the basics of how to( open , read and write ) data into specific file 

so if you need some advanced information about python with files you can take a look on the following some commands such ( copy , move , delete , rename ) 

but these commands need some methods from os library 

to delete file :  os.remove("FilePath")

to reanme file : os.rename("OldName" , "NewName")

to move file :  move files we need to import "shutil" library and use move( source , Dist.) function  or with os library we can use os.rename with the same parameters  

to copy file from location to another location we all from shutil library we can use copy function with the same parameters as move() function or we can create a new file in required location and copy the content from the source into destination  

to list all content in specific directory you can use this method  os.listdir("then the directory ")

Libraries to work with Word and Excel files ?

first working with Excel Files:

we need first to install openpyxl library

wb = load_workbook(r"File Path" , data_only = True)

sheet = wb["Sheet Name "]  # here we need sheet as object 

search_event_description_in_row_index( "sheet" , String , row_index ) 

Sheet.cell(row=Row_Index , column= Column_index).value  # to get the stored value in specific index 

how to parse word document as text 

we need to install dox2txt library 

object_name - docx2txt.process(rf"word doc path " )

another way to work with word documents with formating 

we need to install docx library 

doc = docx.Document("Document path " ) 

then if we need to access any table in this word file 

all_tables = doc.tables

for table in range ( 0 , len(all_tables)): #loop over all tables 

for row in range ( 0 , len(all_tables[table].rows)): # loop over each row in given table

for cell  in range(0 , range(0 , len(all_tables[table].row.cells[column].text: # loop over each cell in given table row