python - set unique index's on a dataframe

Question

I have the current dataframe and I want to set the index to Id and GroupNumber and have them as a unique value in the Index. However, when I set the index the last index still gets duplicated (GroupNumber in my case).

df = pd.DataFrame({'Id':['A','A','A','A','A'],
'GroupNumber': [5,5,5,5,5],
'Name': ['John','Paul','George','Anthony','David'],
'Weight':['Average','Below Average','Above Average','Average','Above Average'],
'Height':['Tall','Short','Average','Tall','Average']})

df = df.set_index(['Id','GroupNumber'])

Desired Output:

Answer 1

You could do something like this:

df = df.set_index(['Id','GroupNumber'], append=True).reorder_levels([1,2,0])

Output:

                     Name         Weight   Height
Id GroupNumber                                   
A  5           0     John        Average     Tall
               1     Paul  Below Average    Short
               2   George  Above Average  Average
               3  Anthony        Average     Tall
               4    David  Above Average  Average