I have a pandas DataFrame like so
week player_a player_b
1 True True
1 True False
1 False False
2 False True
2 False False
2 True False
我希望能够按照每周统计每位玩家的True和False数量,但我似乎无法将其转化为方便的pandas groupby或pivot table操作。所需结果如下:
week True False
player
1 player_a 2 1
player_b 1 2
2 player_a 1 2
player_b 1 2