Python pandas，分组 groupby()，分组后的聚合函数，交叉表 crosstab()

 

demo.py（分组，groupby()，分组后的聚合函数）：

import pandas as pd


my_list = [{"name":"zhangsan","age":18, "province":"jiangsu"}, {"name":"lisi", "age":19, "province":"henan"}, {"name":"xiaohong", "age":18, "province":"henan"}, {"name":"wangwu", "age":18, "province":"jiangsu"}]
df = pd.DataFrame(my_list)
print(df)
'''
   age      name province
0   18  zhangsan  jiangsu
1   19      lisi    henan
2   18  xiaohong    henan
3   18    wangwu  jiangsu
'''


# 分组
grouped = df.groupby(by="province")  # 根据"province"列分组
print(type(grouped))  # <class 'pandas.core.groupby.generic.DataFrameGroupBy'>  可以遍历

for i,j in grouped:
    print(i)  # henan    jiangsu
    print(j