请问各位，我用pandas做数据透视表，语言都是按照书上写的，如下：
import os
import xlwings as xw
import pandas as pd
full_path = 'D:\'
app = xw.App(visible=False, add_book=False)
workbook = app.books.open(os.path.join(full_path,'副本例子.xlsx'))
sheet_list = workbook.sheets
try:
for i in sheet_list:
t_values = i.range('A1').expand('table').options(pd.DataFrame).value
if t_values.empty:
continue
pivot_table = pd.pivot_table(t_values, values='金额', index=['当前状态'], columns=['姓名'], aggfunc='sum', fill_value=0, margins=False)
i.range('R1').value = pivot_table
workbook.save()
finally:
workbook.close()
app.quit()
但是报错为：
Traceback (most recent call last):
File "D:/数据透视表.py", line 13, in
pivot_table = pd.pivot_table(t_values, values='金额', index=['当前状态'], columns=['姓名'], aggfunc='sum', fill_value=0, margins=False)
File "D:\lib\site-packages\pandas\core\reshape\pivot.py", line 106, in pivot_table
sort,
File "D:\lib\site-packages\pandas\core\reshape\pivot.py", line 141, in __internal_pivot_table
raise KeyError(i)
KeyError: '金额'
请问是因为索引key没设好吗？ 要怎么补全达到效果呢？谢谢！！