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: data
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
Scraping By!!!
A simple function that was set up to get a table from a web page using the read HTML function from the HTML5Lib library in Python. The function is able to obtain the table from the web page given the web page url. The default setting is for the function to return the first table … Continue reading Scraping By!!!
Get Data!!!
The next step of the code would be to, given the file path, determine if it is a csv or a dot xlsx file. This was done using the split function in Python whereby it was split using the dot as the character that would determine where the string would be split. This works under … Continue reading Get Data!!!
Get Data!!!
The first part of this coding project would be to select the language in this case I choose to use Python not just because of the extensive libraries but the general ease of use and overall large community of online support. The first part of this little foray into using Python to get data would … Continue reading Get Data!!!