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

在将现有数据加载到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

file_name = 'manipur1.xlsx'

excel_reader = pd.ExcelFile(file_name)

# write and update

excel_writer = pd.ExcelWriter(file_name)

for sheet in excel_reader.sheet_names:

sheet_df = excel_reader.parse(sheet)

append_df = to_update.get(sheet)

if append_df is not None:

sheet_df = pd.concat([sheet_df, append_df], axis=1)

sheet_df.to_excel(excel_writer, sheet, index=False)

excel_writer.save()

但是，现有excel中的任何布局/格式都将丢失。如果要保留格式，可以使用openpyxl，但这比较复杂。