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.
2
-
1df.sort_values(['A', 'B'], ascending=[True, False])Michael– Michael2020-09-05 20:51:05 +00:00Commented Sep 5, 2020 at 20:51
-
Thanks, it works beautifully.fatdragon– fatdragon2020-09-05 20:58:49 +00:00Commented Sep 5, 2020 at 20:58
Add a comment
|
1 Answer
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)
