python使表格增加一列_如何在python中使用panda在现有excel工作表中追加列

最新推荐文章于 2024-08-19 15:54:04 发布

weixin_39997795

最新推荐文章于 2024-08-19 15:54:04 发布

阅读量5.5k

点赞数

文章标签： python使表格增加一列

本文链接：https://blog.csdn.net/weixin_39997795/article/details/111446605

版权

本文介绍如何在Python中使用pandas库向现有Excel工作表追加列。通过加载现有数据，定义要更新的工作表，读取Excel文件，然后使用ExcelWriter将新数据与现有工作表合并，实现数据的追加。注意，此方法会丢失原有的Excel格式，如需保留格式，可能需要结合openpyxl进行操作。

摘要由CSDN通过智能技术生成

在将现有数据加载到pandas中、追加新数据并再次保存连接的数据框时，只能将新数据追加到现有的excel文件。

若要保留应保持不变的现有工作表，需要遍历整个工作簿并处理每个工作表。要更改和追加的工作表在to_update字典中定义。# get data to be appended

trans=pd.read_csv('HMIS-DICR-2011-12-Manipur-Bishnupur.csv')

df_append = 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"]]

# define what sheets to update

to_update = {"Sheet1": df_append}

# load existing data