python - 循环附加excel工作表不起作用

Question

我试图附加这张纸，但最后只显示第一张纸

xls = pd.ExcelFile('MyFile.xlsx')


for sheetname in xls.sheet_names:
    sheetname = pd.read_excel('MyFile.xlsx', sheet_name = sheetname, header=[8,9])
    sheetname.drop(sheetname.tail(3).index,inplace=True)
    out_df = sheetname.append(sheetname)

标签： pythonexcelpandas

Answer 1

见下文：

xls = pd.ExcelFile('MyFile.xlsx')

for sheetname in xls.sheet_names:
    sheetname = pd.read_excel('MyFile.xlsx', sheet_name = sheetname, header=[8,9])
    sheetname.drop(sheetname.tail(3).index,inplace=True)
    out_df = out_df.append(sheetname)
    # -------^^^^^^

更正标记