Pandas分组运算（groupby）

import pandas as pd
df = pd.DataFrame([[1, 1, 2], [1, 2, 3], [2, 3, 4]], columns=["A", "B", "C"])
print(df)

g = df.groupby(‘A‘).mean()   # 按A列分组(groupby)，获取其他列的均值
print(g)

m = df.groupby(‘A‘)
n = m[‘B‘].mean()
print(n)

import pandas as pd 
import numpy as np

df = pd.DataFrame({"Name":["Alice", "Bob", "Mallory", "Mallory", "Bob" , "Mallory"],
                   "City":["Seattle", "Seattle", "Portland", "Seattle", "Seattle", "Portland"],
                   "Val":[4,3,3,np.nan,np.nan,4]})
print(df)

a = df.groupby(["Name", "City"], as_index=False)[‘Val‘].count()
print(a)

b = df.groupby(["Name", "City"])[‘Val‘].size().reset_index(name=‘Size‘)
print(b)