Python——pd.pivot_table

import pandas as pd
import time
import datetime
from dateutil.relativedelta import relativedelta
import numpy as np

now = datetime.datetime.now()   #现在的时间
last_d_0 = now + relativedelta(days = -1)  # 前 1 天——今天
last_d_1 = now + relativedelta(days = -3)  # 前 3 天—— 昨天业绩的前两天（今日）
last_d_2=  now + relativedelta(days = -4)  # 前 4 天—— 昨天业绩的前三天（昨日）
last_d_3 = now + relativedelta(days = -9)  # 前 9 天—— 前一周
last_d_4 = now + relativedelta(days= -16)  # 前 16天—— 前两周
last_d_5 = last_d_1+ relativedelta(months= -1)  #  前一月
last_d_6 = last_d_2+ relativedelta(months= -2)  #  前两月

today = datetime.datetime.strftime(now,'%Y%m%d')
last_d_0 = datetime.datetime.strftime(last_d_0,'%Y%m%d')
last_d_1 = datetime.datetime.strftime(last_d_1,'%Y-%m-%d')
last_d_2 = datetime.datetime.strftime(last_d_2,'%Y-%m-%d')
last_d_3 = datetime.datetime.strftime(last_d_3,'%Y-%m-%d')
last_d_4 = datetime.datetime.strftime(last_d_4,'%Y-%m-%d')
last_d_5 = datetime.datetime.strftime(last_d_5,'%Y-%m-%d')
last_d_6 = datetime.datetime.strftime(last_d_6,'%Y-%m-%d')

path = 'D:/众结资料/1日常工作内容/每日销售开发业绩(Python)/'+last_d_0+'/自定义sku报表本月.xlsx'
print(path)
path1 = 'D:/众结资料/1日常工作内容/每日销售开发业绩(Python)/'+last_d_0+'/自定义sku报表上月.xlsx'
path2 = '自定义sku报表本月.xlsx'

fh =