/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

0 vote193 views1 answer
The grandest staircase of them all foobar solution
Python
1 vote165 views1 answer
If a number times a number is true python
Python
0 vote213 views1 answer
Type object 'SparkContext' has no attribute '_jsc'
Python
0 vote155 views1 answer
Python search list by value
Python
0 vote166 views1 answer
Django multi column index
Python
0 vote173 views3 answers
Click on button tag with only class selenium python
Python
1 vote189 views1 answer
Export_excel file python
Python
-1 vote141 views1 answer
Image analysis python
Python
0 vote178 views1 answer
Pandas save dataframe with list
Python
1 vote156 views1 answer
Using-len-for-text-but-discarding-spaces-in-the-count
Python