[FIXED] Export/Read Multiple Excel(xls) workbooks to one DataFrame

Issue

I need to export/read 3months of excel files into one DataFrame. Files are named "EOD RATES 01.06.2022.xls" date changes with each excel file. Need to capture the excels using pandas

Solution

If need join all excel files use:

import glob


files = glob.glob('folder/*.xls')
df = pd.concat([pd.read_excel(f) for f in files], ignore_index=True)
print (df)

Answered By - jezrael