Python script to format 100+ excel files into one file

Job ID: 30955241

Budget: $50 – $120 USD

I have around 100 excel files.

I want to create a python script which will loop through these files and put everything into one tab in one excel file.

Attached is an example of the tow input files and what the export file should look like. Each of the excel files has a name and date, I would like this added into the excel as a column.
Related categories: Python Data Processing Excel Data Analytics