如何将Excel工作簿中的多个电子表格合并为pandas数据帧？

import pandas as pd
import openpyxl

workbook = openpyxl.load_workbook('your_workbook.xlsx')

sheet_names = workbook.sheetnames

df = pd.DataFrame()

for sheet_name in sheet_names:
    sheet = workbook[sheet_name]
    data = sheet.values
    cols = next(data)[1:]
    data = list(data)
    idx = [r[0] for r in data]
    data = (islice(r, 1, None) for r in data)
    df_temp = pd.DataFrame(data, index=idx, columns=cols)
    df = pd.concat([df, df_temp], axis=1)

workbook.close()