python - 按列分组并将另一列的值分散到其他列中

Question

我有当前的数据框，我正在尝试按 Name 分组并传播 weight 的值进入列并计算每次出现的次数。谢谢!

df = pd.DataFrame({'Name':['John','Paul','Darren','John','Darren'],
'Weight':['Average','Below Average','Above Average','Average','Above Average']})

期望的输出:

Answer 1

试试 pandas crosstab :

pd.crosstab(df.Name, df.Weight)

Weight  Above Average   Average Below Average
Name            
John           0           2        0
Paul           0           0        1
Darren         2           0        0