Code: Select all
import os
import pandas as pd
data_folder='C:\\Users\\hhhh\Desktop\\test'
df = []
for file in os.listdir(data_folder):
if file.endswith('.xlsx'):
print('Loading file {0}...'.format(file))
df.append(pd.read_excel(os.path.join(data_folder , file), sheet_name='sheet1'))