pandas数据分析之agg同时对多个列表使用不同功能函数

    name	            date      race age	signs_of_mental_illness	flee
0	Tim Elliot	        02/01/15	A	53.0	True	Not fleeing
1	Lewis Lee Lembke	02/01/15	W	47.0	False	Not fleeing
2	John Paul Quintero	03/01/15	H	23.0	False	Not fleeing
3	Matthew Hoffman	    04/01/15	W	32.0	True	Not fleeing
4	Michael Rodriguez	04/01/15	H	39.0	False	Not fleeing

• 对数据根据种族分组后，每一列数据(数字类型 和 bool类型)进行求和和平均值data.groupby('race').agg(['sum', 'mean'])

    age	                signs_of_mental_illness
    sum 	mean	    sum	       mean
race				
A	1391.0	36.605263	10.0	0.256410
B	19266.0	31.635468	95.0	0.153722
H	13627.0	32.995157	85.0	0.200946
N	944.0	30.451613	8.0	0.258065
O	926.0	33.071429	7.0	0.250000
W	47736.0	40.046980	382.0	0.318068

• 对数据分组后，对指定的列分别进行不同的运算data.groupby('race').agg( { 'age':['min', 'sum'], 'signs_of_mental_illness':['mean', 'sum'] } )

    age	            signs_of_mental_illness
    min 	sum	    mean	    sum
race				
A	15.0	1391.0	0.256410	10.0
B	13.0	19266.0	0.153722	95.0
H	14.0	13627.0	0.200946	85.0
N	19.0	944.0	0.258065	8.0
O	18.0	926.0	0.250000	7.0
W	6.0	47736.0	0.318068	382.0