Sort pandas dataframe within groups

Question

I have a dataframe:

>>> df
     Category  Score
0        A      1
1        A      2
2        A      3
3        B      5
4        B      9

I expect the output: Sorting Score within Category.

>>> df
     Category  Score
2        A      3
1        A      2
0        A      1
4        B      9
3        B      5

Any ideas?

Zero · Accepted Answer · 2016-05-02 08:25:21Z

2

Use sort_values by mention order.

In [17]: df.sort_values(by=['Category', 'Score'], ascending=[True, False])
Out[17]:
  Category  Score
2        A      3
1        A      2
0        A      1
4        B      9
3        B      5

answered May 2, 2016 at 8:25

Zero

77.4k22 gold badges153 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sort pandas dataframe within groups

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related