Merge excel files with multiple rows of headers in Python-CodePudding

Home > Enterprise > Merge excel files with multiple rows of headers in Python

Merge excel files with multiple rows of headers in Python

Time：09-28

I have multiple excel files as follows (you may download test data from

Updated result with the updated code of @jezrael:

CodePudding user response：

You can avoid remove MultiIndex, convert first column to DatetimeIndex and append to list of DataFrames, for join use