/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

2 votes240 views1 answer
Python print show special characters
Python
6 votes215 views2 answers
Numpy random int
Python
0 vote241 views1 answer
Django is .get lazy
Python Django
0 vote219 views1 answer
Find total no of true in a list in python
Python
0 vote222 views4 answers
How to open a dataset in netcdf4
Python
0 vote227 views1 answer
How to import matplotlib.pyplo in python
Python
0 vote231 views1 answer
Reverse relationship in django for one to one field for usage in Django rest serializer
Python
0 vote280 views1 answer
Huggingface transformers change download path
Python
13 votes193 views1 answer
Install python2.7 ubuntu
Python
-1 vote242 views1 answer
Harihar kaka class 10 questions
Python