给定这样一个完全分类的数据框
import pandas as pd
data = {"Name": ["Dakota", "Joe", "Dakota", "Alex", "Dakota"],
"Activities":["Chess", "Bowling", "Chess", "Swimming", "Chess"],
"Gender": ["Male", "Male", "Male", "Female", "Female"]}
df = pd.DataFrame.from_dict(data)
我想算出每行出现几次这样的次数
Dakota Chess Male: 2
Dakota Chess Female: 1
Joe Bowling Male: 1
Alex Female Swimming: 1
df.groupby(by = ['Name','Activities','Gender'])['Gender']。count()
姓名活动性别
亚历克斯游泳女1
达科他国际象棋女1男2
乔·保龄球男1
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句