pandas生意参谋数据处理

import os 
import pandas as pd


hhye = os.listdir(r'C:\Users\18352\Desktop\Python\read_Excel\01-天猫行业数据分析')
for k in range(len(hhye)):
    wwdu =  os.listdir(r'C:\Users\18352\Desktop\Python\read_Excel\01-天猫行业数据分析\{}'.format(hhye[k]))
    for j in range(len(wwdu)):
        path = r'C:\Users\18352\Desktop\Python\read_Excel\01-天猫行业数据分析\{}\{}'.format(hhye[k],wwdu[j])
        dfs = []
        shop = os.listdir(r'C:\Users\18352\Desktop\Python\read_Excel\01-天猫行业数据分析\{}\{}'.format(hhye[k],wwdu[j]))
        for i in range(len(shop)):
            df0 = pd.read_csv(r'C:\Users\18352\Desktop\Python\read_Excel\01-天猫行业数据分析\{}\{}\{}'.format(hhye[k],wwdu[j],shop[i]),encoding='utf-8')
            df0['月份'] = shop[i].split('-')[0]
            dfs.append(df0)
        
        df = pd.concat(dfs)
        df.replace(regex={',':''},inplace = True)
        df['交易金额'] = df['交易金额'].astype('int')
    #    ss = df.pivot_table(index=['品牌信息','软件品名'],columns=['月份'],values=['交易金额','交易增长幅度','支付转化率'],aggfunc='sum')
        if j == 1:
            pi = df.pivot_table(index=[df.columns[0],df.columns[1],df.columns[3]],columns=['月份'],values=['交易金额'],aggfunc='sum',margins=True)
        else:
            pi = df.pivot_table(index=df.columns[0],columns=['月份'],values=['交易金额'],aggfunc='sum',margins=True)
        pi1 = pi.sort_values(('交易金额', 'All'), ascending=False)
        pi1 = pi1.drop(index='All')
    
        pi1.to_excel(r'C:\Users\18352\Desktop\Python\read_Excel\数据汇总结果\{}-{}.xlsx'.format(path.split('\\')[-2],path.split('\\')[-1].split('-')[1]))