/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 vote237 views2 answers
2)Write a function that checks whether a number is in a given range (inclusive of high and low) python
Python
0 vote224 views1 answer
Pandas reemplazar nan por cero
Python
2 votes229 views2 answers
Python primera letra mayuscula
Python
1 vote235 views1 answer
Create dictionary key and values from lists
Python
0 vote257 views1 answer
Django save object in view
Python Django
1 vote218 views2 answers
Pandas merge two columns from different dataframes
Python
-3 votes226 views2 answers
Multiplication table python
Python
0 vote229 views1 answer
F readlines python not working
Python
0 vote222 views2 answers
Remove empty lines from file python
Python
0 vote220 views1 answer
Mean first passage time markov chain python
Python