现在有多个excel 文件，需要对其进行合并
import pandas as pd path=‘‘ list1=[] #save data data=pd.read_excel(path,dtype=object) #read excel list1.append(data) write = pd.ExcelWriter(path +‘.xlsx‘) pd.concat(list1).to_excel(write, ‘sheet_name‘, index=False) # merge data and save excel write.save()
原文：https://www.cnblogs.com/zwp-627/p/11734449.html