/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 vote154 views1 answer
Get indexes where value is na pandas
Python
0 vote160 views1 answer
For an HTML output, you don’t need an additional library. It simply goes like this:
Python
8 votes168 views1 answer
Show more columns / rows of a Pandas DataFrame
Python
31 votes167 views4 answers
Python convert list of strings to list of integers
Python
1 vote185 views2 answers
Define symmetry
Python
1 vote145 views1 answer
Selenium select element by id
Python
3 votes153 views1 answer
Width and height of pil image
Python
1 vote135 views1 answer
How to scroll down to end of page in selenium python
Python
1 vote149 views1 answer
Open administrator command prompt using python
Python
0 vote193 views1 answer
How to insert a placeholder text in django modelform
Python Django