PYTHON--pandas实现分类汇总

import pandas as pd
import os
import os.path
import csv

x=pd.read_csv('./output/test.csv')

x1=x.groupby(['Date_ID','erbs']).agg({'RRC_chenggongshu':sum,'RRC_qingqiushu':sum,'pmPdcpPktLostUlQci1':sum,'UL Packet Loss Rate_fenmu':sum})  #####按DATE_ID,ERBS分类统计各项指标

x1.insert(2,'rrc_tot',(x1['RRC_chenggongshu']/x1['RRC_qingqiushu']*100).round(3))  ####插入统计项
x1.insert(5,'plk_ul',(x1['pmPdcpPktLostUlQci1']/x1['UL Packet Loss Rate_fenmu']*100).round(3))

x1.to_csv('test.csv')