How can I get Pandas to add an incrementing suffix to a value based on occurrences

Question

I would like to add a prefix that inclemently counts number of occurrences of values in a column.

INPUT

OUTPUT

Thanks for your help!

user_13138364 · Answer

You can generate the sequences with a groupby-cumcount and append:

df = pd.DataFrame({'A': [1234567, 1234568, 1234567, 1234565, 1234567, 1234567, 1234568, 1234565]})

df.A.astype(str) + '#' + df.groupby('A').cumcount().add(1).astype(str)

Output:

0    1234567#1
1    1234568#1
2    1234567#2
3    1234565#1
4    1234567#3
5    1234567#4
6    1234568#2
7    1234565#2
dtype: object

How can I get Pandas to add an incrementing suffix to a value based on occurrences

1 Answers