各位 新年好，有一表格在原始資料末端添加了統計資料，代碼運行后發現原始資料的第一列（訂單號）被修改為0且列內資料洗掉了，請問如何在在原始資料末端添加了統計資料后，原始資料保持不變，代碼如下：
from openpyxl import load_workbook
import pandas as pd
import numpy as np
df = pd.read_excel("訂單表格.xlsx",sheet_name='sheet1',engine='openpyxl')
book = load_workbook("訂單表格.xlsx")
writer = pd.ExcelWriter("訂單表格.xlsx", engine='openpyxl')
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
# 訂單總數
data1 = df['訂單號'].count()
# 營收總金額(元)
data2 = np.sum(df['實際支付價格'])
stotal1 =["訂單總數：",data1,"營收總金額(元)：",data2,]
df = df.append(stotal1)
df.to_excel(writer, sheet_name='sheet1', startcol=0, startrow=0, index=False,header=True)
wbsheet = book['sheet1']
namelist = 'sheet1'
writer.save()
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/260763.html
上一篇：自動問卷出錯是怎么回事呢？