/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

38 votes177 views2 answers
Python extract thefile name from relative path
Python
0 vote195 views2 answers
Sns countplot show count
Python
0 vote190 views1 answer
List of python keywords
Python
7 votes185 views2 answers
Pygame keyboard input
Python
1 vote183 views1 answer
Read csv python pandas without id
Python
0 vote141 views2 answers
Adding objects to existing legend
Python
0 vote222 views1 answer
Invalid Python Environment: Python is unable to find Maya's Python modules
Python
1 vote169 views1 answer
Pip rm library
Python
7 votes187 views4 answers
From django.contrib import messages
Python
0 vote185 views1 answer
Python requests cannot find existing url
Python