dataframe groupby分别为每列聚合

Question

我想对dataframegroupby对象的每一列使用不同的聚合函数

按某些字段对数据帧进行分组并聚合某些列

def aggregation(df):
  quorum = df.groupby("itemId")[['Xmin','Ymin', 'Xmax', 'Ymax']].median().reset_index()
return quorum


I want to make aggregation min() for 'Xmin','Ymin' fields and max() for 'Xmax', 'Ymax' ones. But don't know how to write desirable code...

Answer 1

def aggregation(df):
    return df[['itemId','Xmin','Ymin', 'Xmax', 'Ymax']].groupby("itemId").agg({'Xmin':'min','Ymin':'min','Xmax':'max','Ymax':'max'}

其中Xmin、Ymin Xmax、Ymax是各自的列名