這個問題在這里已經有了答案: Pandas group-by and sum (9 個回答) 昨天關閉。
對此相當陌生,不知道如何以更好的方式提出問題,但是-這是我的資料(我也不明白如何在代碼中輸入...)
Date Sex Cases
20200103 Female 1
20200103 Female 1
20200103 Female 2
20200103 Male 0
20200103 Male 1
20200104 Female 2
20200104 Female 1
20200104 Male 2
20200104 Male 1
我如何合并具有相同日期和性別的那些(并將案例添加在一起),所以它看起來像這樣:
Date Sex Cases
20200103 Female 3
20200103 Male 1
20200104 Female 3
20200104 Male 3
uj5u.com熱心網友回復:
df = df.groupby(['Date', 'Sex'], as_index=False).sum()
輸出:
>>> df
Date Sex Cases
0 20200103 Female 4
1 20200103 Male 1
2 20200104 Female 3
3 20200104 Male 3
轉載請註明出處,本文鏈接:https://www.uj5u.com/qiye/362569.html
