import pandas as pd
import glob
def GetFile(fname):
df = pd.read_excel(fname)
# 记录文件名
df['File'] = fname
# 设置 "File" 列为索引
return df.set_index(['File'])
df_list = [GetFile(fname) for fname in glob.glob(r"E:\指数*.xlsx")]
big_df = pd.concat(df_list)
import glob
def GetFile(fname):
df = pd.read_excel(fname)
# 记录文件名
df['File'] = fname
# 设置 "File" 列为索引
return df.set_index(['File'])
df_list = [GetFile(fname) for fname in glob.glob(r"E:\指数*.xlsx")]
big_df = pd.concat(df_list)