介绍
agg() 一般搭配groupby()使用,可以对分组的结果,同时应用多个函数
例子:
import pandas as pd
df = pd.read_csv("SELL.csv", index_col=[0])
# 对列Sell_No分组
dfgb=df.groupby(by='Sell_No')
# 分组后取列 _Time最后一个值(last)、Prices、Sell_price、Sell_Vol求平均值(mean),对Volume、Amount、Freq求和(sum)
dfgb.agg({"_Time":"last","Prices":"mean","Volume":"sum","Sell_price":"mean","Sell_Vol":"mean","Amount":"sum","Freq":"sum"})