3-Groupby分组统计--数据分析

3-Groupby分组统计

In [2]:

import pandas as pd

df = pd.DataFrame({'Key':['A','B','C','A','B','C','A','B','C'],

                  'data':[0,5,10,5,10,15,10,15,20]})

df

Out[2]:

	Key	data
0	A	0
1	B	5
2	C	10
3	A	5
4	B	10
5	C	15
6	A	10
7	B	15
8	C	20

groupby() 分组：根据key字段进行分组，对ABC分别进行求和运算

In [6]:

df.groupby('Key').sum()

Out[6]:

	data
Key
A	15
B	30
C	45

numpy类型使用groupby

In [7]:

import numpy as np

df.groupby('Key').aggregate(np.sum)

Out[7]:

	data
Key
A	15
B	30
C	45

根据Sex进行分组，分别计算Age平均值

In [8]:

df = pd.read_csv('C:/JupyterWork/data/titanic.csv')

In [10]:

df.groupby('Sex')['Age'].mean()

Out[10]:

Sex
female    27.915709
male      30.726645
Name: Age, dtype: float64

In [11]:

df.groupby('Sex')['Survived'].mean()

Out[11]:

Sex
female    0.742038
male      0.188908
Name: Survived, dtype: float64

In [ ]:

​