将同一个文件夹下的xlsx文件读取:
import os import pandas as pd path = r'./path of file' for i in os.listdir(path): df = pd.read_excel(os.path.join(path,i))