How to sort multiple columns with different orders in pandas?

Question

How do I sort a data frame using multiple columns such that each column is sorted in different order? For example, the primary sort key is column 'A' in ascending order and secondary sort key is column 'B' in descending order.

df.sort_values(['A', 'B'], ascending=[True, False]) – Michael Sep 05 '20 at 20:51 — Michael, Sep 05 '20 at 20:51
Thanks, it works beautifully. – fatdragon Sep 05 '20 at 20:58 — fatdragon, Sep 05 '20 at 20:58

score 0 · Answer 1 · answered Sep 05 '20 at 20:52

0

The method df.sort_values has a parameter ascending wich can be a boolean or a list of booleans.

df.sort_values(['A', 'B'], ascending=[True, False], inplace=True)

answered Sep 05 '20 at 20:52

RichieV

5,103
2
11
24

How to sort multiple columns with different orders in pandas?

1 Answers1