pandas实现各品类销量排行

import pandas as pd
import numpy as np


dd = pd.read_csv('./ddbb_20.txt',sep='\t',keep_default_na=False,na_values="0")
bb = pd.read_csv('./bbbb_2020.txt',sep='\t',keep_default_na=False,na_values="0")


dd_n=dd.merge(bb,how='left',on='订单编号')
#dd_n.to_excel('./dd_n.xlsx',sheet_name='2020')
dd_n.rename(columns={'买家实际支付金额':'20总金额','购买数量':'20总销量'},inplace=True)



dd_result=dd_n.pivot_table(index=['产品部位','产品类别','产品'],
                                     values=['20总金额','20总销量'],
                                     aggfunc={'20总金额':sum,'20总销量':sum})


dd_sum=pd.DataFrame(dd_n.groupby(by=['产品部位'])['20总金额'].sum()).reset_index()

#dd_mb=dd_result.loc[['面部','眼周','眼部','颈部','鼻部']]
#dd_mb.to_excel('./dd_mb.xlsx',sheet_name='2020')
dd_sum.rename(columns={'20总金额':'部位总销'},inplace=True)
dd_sum


dd_result=dd_result.reset_index()
dd_merge=pd.merge(dd_result,dd_sum,on=['产品部位'],how='left')
dd_merge=dd_merge.sort_values(by=['部位总销','20总金额'],ascending=False)

dd_merge=dd_merge.set_index(['产品部位','部位总销','产品类别','产品'])
dd_merge