import pandas as pd
from pandas import ExcelWriter
trans=pd.read_csv('HMIS-DICR-2011-12-Manipur-Bishnupur.csv')
df=trans[["April 10-11","May 10-11","June 10-11","July 10-11","August 10-11","September 10-11","October 10-11","November 10-11","December 10-11","January 10-11","February 10-11","March 10-11","April 11-12","May 11-12","June 11-12","July 11-12","August 11-12","September 11-12","October 11-12","November 11-12","December 11-12","January 11-12","February 11-12","March 11-12"]]
writer1 = ExcelWriter('manipur1.xlsx')
df.to_excel(writer1,'Sheet1',index=False)
writer1.save()
此代码成功地将数据写入工作表1,但如何将来自不同excel文件(如下所述)的另一数据框(df)的数据追加到现有工作表(sheet1)“manipur1”excel文件中
例如: 我的数据帧如下:
trans=pd.read_csv('HMIS-DICR-2013-2014-Manipur-Bishnupur.csv')
df=trans[["April 12-13","May 12-13","June 12-13","July 12-13","August 12-13","September 12-13","October 12-13","November 12-13","December 12-13","January 12-13","February 12-13","March 12-13","April 13-14","May 13-14","June 13-14","July 13-14","August 13-14","September 13-14","October 13-14","November 13-14","December 13-14","January 13-14","February 13-14","March 13-14"]]
在将现有数据加载到pandas中、追加新数据并再次保存连接的数据框时,只能将新数据追加到现有的excel文件。
若要保留应保持不变的现有工作表,需要遍历整个工作簿并处理每个工作表。要更改和追加的工作表在
to_update
字典中定义。但是,现有excel中的任何布局/格式都将丢失。如果要保留格式,可以使用openpyxl,但这比较复杂。
相关问题 更多 >
编程相关推荐