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: Coding
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
Read from File
This is a simple way to handle reading from an excel file be it csv or xlsx. The function takes a filepath and determines the type, be it .csv or .xlsx. From this it is able to process the file according to the type. If it is a .csv then it will look for the … Continue reading Read from File
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
Read from Excel
One of the first things that you learn from using Python is how easy it is for Python to read from Excel files be it .CSV or XLSX. The issue is knowing which function within Python libraries and there are many libraries you can use to read either the CSV or the XLSX file format. … Continue reading Read from Excel