如何使用pandas将多个透视表插入到工作簿的一个工作表中

import pandas as pd
from openpyxl import load_workbook

# 创建透视表1
pivot_table1 = pd.pivot_table(data, values='value', index='index1', columns='column1', aggfunc='sum')

# 创建透视表2
pivot_table2 = pd.pivot_table(data, values='value', index='index2', columns='column2', aggfunc='mean')

# 加载工作簿
book = load_workbook('workbook.xlsx')

# 选择要写入的工作表
writer = pd.ExcelWriter('workbook.xlsx', engine='openpyxl')
writer.book = book

# 将透视表1写入工作表
pivot_table1.to_excel(writer, sheet_name='Sheet1', startrow=0, startcol=0)

# 将透视表2写入工作表
pivot_table2.to_excel(writer, sheet_name='Sheet1', startrow=pivot_table1.shape[0]+2, startcol=0)

# 保存工作簿
writer.save()