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:
id name cumcount
1 name1 1
1 name1 2
1 name2 1
2 name3 1
2 name3 2
2 name3 3
Basically a running tally for each name in an id.