Script to find the excel files from the same directory plus folders in the same directory, and checks the column names and then if there are same columns then merge the data according to the similar columns and also keeps the unique columns in the merged file.
- Install required Packages from
requirements.txt - Your files should be placed in the same directory or any folders containing the files in
the directory where the
main.pyfile is located. Script will look for them and then will process them. - The files startswith
mergedas afilenamewill be skipped. - Run script using command
python main.py - Output will be a merged excel file with current date and time like
merged_2022-09-17_12-43-47.xlsx
Give a ⭐️ if this project helped you!