How to sort 2 columns in a Dataframe, one sorted in descending order and the other in alphabetical order corresponding to the 1st column

Question

Dataframes looks something like

Names            Rank
Michael            8
David              6
Christopher        6
Brian              5
Amanda             3
Heather            8
Sarah              2
Rebecca            4

Expected O/P

Names         Rank
Heather        8
Michael        8
Christopher    6
David          6
Brian          5
Rebecca        4
Amanda         3
Sarah          2

Here, I need to first sort the rank column in descending order and then the Name column in alphabetical order.

My code :

df = df.sort_values(['Name'],ascending = True)
df = df.'Name'.sort_values(['Rank'],ascending = False)
df

This code gives me on the sorted rank but the Name column doesn't get sorted.

Does this answer your question? [How to sort a dataframe by multiple column(s)](https://stackoverflow.com/questions/1296646/how-to-sort-a-dataframe-by-multiple-columns) — ababuji, May 17 '20 at 12:20

score 0 · Accepted Answer · answered May 17 '20 at 16:58

0

df = df.sort_values(['Rank', 'Name'],ascending = [False, True])

answered May 17 '20 at 16:58

Darakhsha

1
1

How to sort 2 columns in a Dataframe, one sorted in descending order and the other in alphabetical order corresponding to the 1st column

1 Answers1