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.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…