Pandas Dataframe Ordering And Sorting Of Column Values

I was wondering if someone knows a good way on how to sort a pandas dataframe in the following way: a) I have the following randomly sorted data with an id that appears multiple ti

Solution 1:

First sort by id and label, then use cumcount to create an index representing 1,2,3 groups, then sort on index and by labels.

df_out = df.sort_values(by=['id','label'])\
  .set_index(df.groupby('id').cumcount())\
  .sort_index()\
  .sort_values(by='label')

Output:

   id  label
0   1      0
0   2      0
0   3      0
1   1      0
1   2      0
1   3      0
2   3      0
2   1      1
2   2      1