0

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
Improve this question
3
  • df.groupby('id').cumcount()+1 Commented May 8, 2020 at 15:14
  • 3
    df.sort_values(['id','rank'])? Commented May 8, 2020 at 15:14
  • That works @QuangHoang thanks. I am probably just titled and not thinking straight. Can you post your answer so I can approve it? Commented May 8, 2020 at 15:26

1 Answer 1

Reset to default
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
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.