且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Pandas DataFrame计算重复行并填写列

更新时间:2022-12-10 07:38:36

使用

Use the cumcount method after grouping by Gender:

df = pd.DataFrame({'Gender':['Male','Male','Female','Female','Female']})   
df['Occurrence'] = df.groupby('Gender').cumcount() + 1
print(df)

   Gender  Occurrence
0    Male           1
1    Male           2
2  Female           1
3  Female           2
4  Female           3

计数从0开始,所以我在其中添加了+ 1.

Counts start with 0 so I added a + 1 there.