python分多个excel,在python中一起附加多个Excel文件（xlsx）

import pandas as pd

import os

import glob

all_data = pd.DataFrame()

for f in glob.glob("output/test*.xlsx")

df = pd.read_excel(f)

all_data = all_data.append(df, ignore_index=True)

I want to put multiple xlsx files into one xlsx. the excel files are in the output/test folder. The columns are the same, in all but I want concat the rows. the above code doesn't seem to work

解决方案

Let all_data be a list.

all_data = []

for f in glob.glob("output/test/*.xlsx"):

all_data.append(pd.read_excel(f))

Now, call pd.concat:

df = pd.concat(all_data, ignore_index=True)

Make sure all column names are the same, otherwise this solution won't work.

You could also use a map version of the for loop above:

g = map(pd.read_excel, glob.glob("output/test/*.xlsx"))

df = pd.concat(list(g), ignore_index=True)

Or the list comprhension method as shown in the other answer.