python - How to reshape dataframe if they have same index?

Question

If I have a dataframe like

df= pd.DataFrame(['a','b','c','d'],index=[0,0,1,1])

   0
0  a
0  b
1  c
1  d

How can I reshape the dataframe based on index like below i.e

df= pd.DataFrame([['a','b'],['c','d']],index=[0,1])

  0  1
0  a  b
1  c  d

Answer 1

Let's use set_index, groupby, cumcount, and unstack:

df.set_index(df.groupby(level=0).cumcount(), append=True)[0].unstack()

Output:

   0  1
0  a  b
1  c  d