我需要我的 df['Name'] 列中每個名稱的累積總和,但是當列中出現新名稱時,我需要重置計數。我將如何在熊貓中實作這一點?我用, 等嘗試了各種方法df.cumsum,但都df.rolling沒有成功。
Name
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Devonta Freeman
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
Antonio Brown
期望輸出:
Name Count
Devonta Freeman 1
Devonta Freeman 2
Devonta Freeman 3
Devonta Freeman 4
Devonta Freeman 5
Devonta Freeman 6
Devonta Freeman 7
Devonta Freeman 8
Devonta Freeman 9
Devonta Freeman 10
Devonta Freeman 11
Devonta Freeman 12
Devonta Freeman 13
Devonta Freeman 14
Devonta Freeman 15
Antonio Brown 1
Antonio Brown 2
Antonio Brown 3
Antonio Brown 4
Antonio Brown 5
Antonio Brown 6
Antonio Brown 7
Antonio Brown 8
Antonio Brown 9
Antonio Brown 10
Antonio Brown 11
Antonio Brown 12
Antonio Brown 13
Antonio Brown 14
Antonio Brown 15
Antonio Brown 16
Antonio Brown 17
uj5u.com熱心網友回復:
您正在尋找cumcount.
df['Count'] = df.groupby('Name').cumcount()
輸出:
>>> df
Name Count
0 Devonta Freeman 1
1 Devonta Freeman 2
2 Devonta Freeman 3
3 Devonta Freeman 4
4 Devonta Freeman 5
5 Devonta Freeman 6
6 Devonta Freeman 7
7 Devonta Freeman 8
8 Devonta Freeman 9
9 Devonta Freeman 10
10 Devonta Freeman 11
11 Devonta Freeman 12
12 Devonta Freeman 13
13 Devonta Freeman 14
14 Devonta Freeman 15
15 Antonio Brown 1
16 Antonio Brown 2
17 Antonio Brown 3
18 Antonio Brown 4
19 Antonio Brown 5
20 Antonio Brown 6
21 Antonio Brown 7
22 Antonio Brown 8
23 Antonio Brown 9
24 Antonio Brown 10
25 Antonio Brown 11
26 Antonio Brown 12
27 Antonio Brown 13
28 Antonio Brown 14
29 Antonio Brown 15
30 Antonio Brown 16
31 Antonio Brown 17
轉載請註明出處,本文鏈接:https://www.uj5u.com/gongcheng/388027.html
