/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 vote337 views1 answer
Print convert hex as string ascii
Python
0 vote357 views1 answer
Python make an object hashable
Python
18 votes798 views4 answers
Py to exe converter online
Python
0 vote322 views1 answer
Oauthlib python error
Python
13 votes332 views1 answer
Selenium webdriver python
Python
0 vote361 views1 answer
How do I merge two dictionaries in a single expression (taking union of dictionaries)?
Python
0 vote355 views1 answer
Concatenate dataframes using one column
Python
10 votes324 views1 answer
Enumerate zip python
Python
-1 vote339 views1 answer
Import http response in django
Python
1 vote371 views1 answer
Choromap = go.Figure(data=[data], layout = layout)
Python