Sorting on two columns using Pandas

Question

I have the following dataframe (this is a sample there are many rows)

      Student ID        avg
0       205842      68.333333
1       280642      74.166667

I want to sort by decreasing average percentage grade, and, if equal the Increasing Student ID.

I have been able to sort with one parameter like below, however I'm unsure how to sort with two as I want

df_pct_scores.sort_values(by='avg', ascending=False)

df_pct_scores.sort_values(by=['avg','ID'], ascending=False) please try this — Talha Anwar
– Talha Anwar, Commented Feb 8, 2020 at 3:38
Thanks for your input, however - aren't both of these sorting by descending? The second value 'ID' I want to be ascending — TC1111
– TC1111, Commented Feb 8, 2020 at 3:39
Does this answer your question? How to sort a dataFrame in python pandas by two or more columns? — Zoie
– Zoie, Commented Feb 8, 2020 at 4:00

Lucas Damian · Accepted Answer · 2020-02-08 04:16:08Z

1

Please see if this works:

df_pct_scores.sort_values(by = ['avg','ID'], ascending=[False, True])

Lucas Damian

1781 gold badge2 silver badges12 bronze badges

answered Feb 8, 2020 at 3:54

Suman Dey

1616 bronze badges

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

1 Answer 1