Skip to content Skip to sidebar Skip to footer

Pandas Groupby Cumulative Count

How do I do a cumcount on two groupings, id and name? For example I have: id name 1 name1 1 name1 1 name2 2 name3 2 name3 2 name3 And I would like it to look like:

Solution 1:

You can use groupby.cumcount:

df['cumcount'] = df.groupby(['id', 'name']).cumcount() + 1

df
#  id   name    cumcount
#0  1   name1   1
#1  1   name1   2
#2  1   name2   1
#3  2   name3   1
#4  2   name3   2
#5  2   name3   3

Post a Comment for "Pandas Groupby Cumulative Count"