remove duplicated rows and convert it to list or tuple

I have dataframe as follows (Name is index):

my goal is to remove duplicate and convert the column year to tuple or list, like below

how can I do that efficiently since my df has more than 800,000 rows

>Solution :

Use np.unique on groupby. Assuming Name is already the index:

>>> df.groupby(level=0).agg(np.unique)
      Age          year
Name                   
Jack   18          2018
Nick   19          2019
Tom    20  [2020, 2021]