import pandas as pd
df=pd.DataFrame()
i=1
for file in os.listdir():
dfi=pd.read_excel(file,header=0)
df=pd.concat([df,dfi])
print('第%s个文件合并完成!'%i)
i+=1
import pandas as pd
df=pd.DataFrame()
i=1
for file in os.listdir():
dfi=pd.read_excel(file,header=0)
df=pd.concat([df,dfi])
print('第%s个文件合并完成!'%i)
i+=1