/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 vote253 views1 answer
Find all text in site python
Python
0 vote332 views1 answer
Django import Response
Python Django
0 vote284 views1 answer
Simple example of printing a C version of a SymPy expression:
Python
0 vote291 views1 answer
How to convert each string to a category or int in python dataframe
Python
0 vote272 views1 answer
Compter des valeur consecutives en python
Python
0 vote273 views1 answer
Python input text in file
Python
0 vote283 views1 answer
How to set beutfull tkinter button
Python
0 vote280 views1 answer
How do variables work in python
Python
1 vote279 views1 answer
Dataframe drop rows by column value
Python
4 votes286 views2 answers
Pandas replace values with only whitespace to null
Python