/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 vote110 views1 answer
Accept user input in python
Python
0 vote54 views1 answer
Install eric6 python ide ubuntu 20.04
Python
0 vote100 views1 answer
Python time-stamp conversion
Python
5 votes101 views4 answers
Install python venv install
Python
0 vote104 views1 answer
Lucky number codechef solution
Python
5 votes108 views1 answer
Run every minute python
Python
1 vote95 views1 answer
From time import sleep, time
Python
15 votes100 views3 answers
Remove word from string in python
Python
0 vote59 views1 answer
Python word encode asci
Python
0 vote126 views1 answer
Get nonzero min numpy
Python