/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 vote208 views1 answer
Python compine multiple lists
Python
0 vote221 views1 answer
Python enum declare
Python
4 votes205 views2 answers
Django template for range
Python
2 votes252 views1 answer
Dataframe from two series
Python
25 votes198 views3 answers
Pyperclip
Python
6 votes188 views1 answer
Pd.set_option('display.max_columns', 200) pd.set_option('display.max_rows', 100)
Python
1 vote258 views1 answer
Calcutalte average python
Python
0 vote216 views1 answer
Automatic stationary conversion
Python
0 vote204 views1 answer
Python eliminar elementos de un diccionario
Python
0 vote198 views1 answer
Install python3 centos 7.8
Python