[Groupby & apply - Single Line] #pandas #groupby #apply

Pandas - groupby and transform

import pandas as pd

df = pd.DataFrame([
    [123, 'abc'],
    [123, 'abc'],
    [456, 'def'],
    [123, 'abc'],
    [123, 'abc'],
    [456, 'def'],
    [456, 'def'],
    [456, 'def'],
], columns = ['userid', 'name'])

df1 = df.sort_values('userid').groupby('userid')['name'].apply(lambda df: df.reset_index(drop = True)).unstack()
print(df1)