合并多个excel文件

def GetFile(filename):
    df = pd.read_excel(filename)
    # 记录文件名
    df['File'] = filename
    
    # 将‘File’设置为索引
    return df.set_index(['File'])

df_list = [GetFile(filename) for filename in glob.glob(r"F:\导航直接办理明细\流程办理\业务受理专区日志查询*.xls")]
big_list = pd.concat(df_list)