我嘗試多次運行此程序，但現(xiàn)有的excel文件未更新。有人可以指導我完成正確的過程嗎？感謝您的幫助！import pandas as pdimport openpyxl as plmanifest_df = pd.read_excel(r'C:\Users\dhruvjadhav\PycharmProjects\Alpha\PassengerManifest.xlsx')manifest_df['Current Balance'] = manifest_df['Balance'] - manifest_df['Fare']print(manifest_df)filename = (r'C:\Users\dhruvjadhav\PycharmProjects\Alpha\PassengerManifest.xlsx')wb = pl.load_workbook(filename)ws = wb.worksheets[0]for ws in wb.worksheets: print(ws.title)with pd.ExcelWriter("PassengerManifest.xlsx", engine="openpyxl", mode="a") as writer: manifest_df.to_excel(writer, sheet_name="ws.title")writer.save()
1 回答
狐的傳說
TA貢獻1804條經(jīng)驗 獲得超3個贊
如果要更新現(xiàn)有 Excel，可以使用以下代碼。只需要熊貓。
import pandas as pd
# read the xlsx file
manifest_df = pd.read_excel(r'C:\Users\dhruvjadhav\PycharmProjects\Alpha\PassengerManifest.xlsx')
# perform arithmentic operation
manifest_df['Current Balance'] = manifest_df['Balance'] - manifest_df['Fare']
# write again the excel file
manifest_df.to_excel(r'C:\Users\dhruvjadhav\PycharmProjects\Alpha\PassengerManifest.xlsx', index=False)
就是這樣
添加回答
舉報
0/150
提交
取消