import pandas as pd
pd1=pd.read_csv(r'路径',encoding = 'gb2312')
pd2=pd.pivot_table(pd1,index=['BUSI_NAME'],values=['USER_ID'],columns=['CREATE_OP_ID'],aggfunc=[len],fill_value='/',margins=True)
pd3=pd2.transpose().sort_values(by=['All'],ascending=False).transpose()
pd3.to_excel(r'C:\Users\Administrator\Desktop\table01.xlsx')