Pandas group by and sorting by values within the group

Question

After running XGBoost and getting the prediction, I need to sort the ranks withing the based on group id. I've tried several methods but was unsuccessful.

My data:

id     hotel_id   rank
1       5         2
1       3         3
1       4         1
2       23        4
2       12        2
2       62        3
2       22        1

This would be the outcome after group_by and sorting based on rank. It's important that the id remains unchanged.

id     hotel_id   rank
1       4         1
1       5         2
1       3         3
2       22        1
2       12        2
2       62        3
2       23        4

That works @QuangHoang thanks. I am probably just titled and not thinking straight. Can you post your answer so I can approve it? — Robert, May 08 '20 at 15:26

score 1 · Accepted Answer · answered May 08 '20 at 15:27

1

I believe this is just sort_values:

df.sort_values(['id','rank'])

Output:

   id  hotel_id  rank
2   1         4     1
0   1         5     2
1   1         3     3
6   2        22     1
4   2        12     2
5   2        62     3
3   2        23     4

answered May 08 '20 at 15:27

Quang Hoang

146,074
10
56
74

Pandas group by and sorting by values within the group

1 Answers1