Merge Excel Files with Python
Level: Real-World
Project Brief
Your task for this project is to merge Excel files using Python.
Step by Step Instructions
Download these two Excel files and place them in a directory named “excel_files”. The Excel files look like this:
And here is the other file:
2. Write a Python script that merges all the Excel files (in this case two) of the “excel_files” directory.
Expected Output
Keep reading with a 7-day free trial
Subscribe to Daily Python Projects to keep reading this post and get 7 days of free access to the full post archives.