python-多sheet合并
import pandas as pd #合并多个sheet data = pd.read_excel('C:\\数据分析\\个人实操\\python数据视图\\实操3-财务多sheet合并\\财务费用.xlsx',None) cols = list(data.keys()) newdata =pd.DataFrame() for i in cols: df= data[i] newdata=pd.concat([newdata,df]) newdata.to_excel('C:\\Users\\Administrator\\Desktop\\财务合并数据.xlsx',index=False)
效果如下: