So this simply combines multiple files into one data set and outputs it onto 1 sheet In an entirely new Excel file. The the basic explanation of it is that it uses Pandas accelerator to read the file name using the Open PYXL engine. The read from file is a custom function that takes the … Continue reading Combine Excel Files
Tag: pdf reader
Make a Folder
This code is a very simple function that checks the folder path and determines if it exists or not. If it does then largely nothing happens, however if it detects that the folder path does ot exist then is will create one. def makeFolder(folderpath): if os.path.exists(folderpath): return print("Path Exists") else: os.makedirs(folderpath) print("Path does not exist … Continue reading Make a Folder
PDF Reader
The PDF reader came about as a result of wanting to be able to cycle through a series of PDF invoices each invoice with a standard layout which meant pattern recognition across each of the PDF files would be fairly easy. It is imperative to note that because we standardized layout of each PDF invoice … Continue reading PDF Reader