使用pandas在数据透视表中添加第二页边距

import pandas as pd
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows
from openpyxl.styles import Side, Border

# 假设已有一个名为df的数据框
pivot_table = pd.pivot_table(df, values='value', index='index', columns='columns', aggfunc='sum')

# 创建一个Excel工作簿
wb = Workbook()
ws = wb.active

# 将数据透视表转换为行数据
for r in dataframe_to_rows(pivot_table, index=True, header=True):
    ws.append(r)

# 设置第二页边距
ws.page_margins.left = 0.5
ws.page_margins.right = 0.5
ws.page_margins.top = 0.5
ws.page_margins.bottom = 0.5

# 保存Excel文件
wb.save('pivot_table.xlsx')