Read Multiple Excel Files at Once

pandas_reading03.py

import pandas as pd
import os

# Create list of files
file_path = '/Desktop/Files/'
files = [os.path.join(file_path, file) for file in os.listdir(file_path)]

# Join DataFrames Using pd.concat()
df = pd.concat([pd.read_excel(file) for file in files], ignore_index=True)
print(df.head())

# Returns:
#    Day  Month  Year  Name  Amount
# 0    1      2  2023   Nik     117
# 1    2      2  2023  Jane     103
# 2    3      2  2023  Kate     135
# 3    4      2  2023  Evan     195
# 4    5      2  2023   Nik     178