/Python/Unique id on duplicate ids values pandas

Unique id on duplicate ids values pandas

import pandas as pd
import numpy as np
data = {'Name':['Tom', 'Tom', 'Jack', 'Terry'], 'Age':[20, 21, 19, 18]} 
df = pd.DataFrame(data)

nth = ['First', 'Second', 'Third', 'Fourth']

def prefix(d):
    n = len(d)
    if n > 1:
        return d.radd([nth[i] for i in range(n)])
    else:
        return d

df.assign(Name=df.groupby('Name').Name.transform(prefix))

          Name  Age
0     FirstTom   20
1    SecondTom   21
2         Jack   19
3        Terry   18

Similar codes

1 vote105 views1 answer
Check the input format of a date python
Python
6 votes131 views4 answers
Pandas read csv without header
Python
6 votes125 views4 answers
Print all elements in list python
Python
1 vote122 views1 answer
Animations text terminal python
Python
1 vote137 views1 answer
Returns the first n rows
Python
1 vote140 views1 answer
Python print os platform
Python
0 vote127 views1 answer
Can only use .str accessor with string values!
Python
0 vote119 views1 answer
Python change font in 1 line
Python
0 vote150 views1 answer
Django url patterns static
Python Django
2 votes133 views2 answers
How to Add a Title to Seaborn Plots
Python