Home / Questions / 516662
Accepted
AlejandroR
Asked: 2022-07-24 04:55:07 +0800 CST 2022-07-24 04:55:07 +0800 CST

sort results from highest to lowest of a query launched to a dataframe

  • 772

I am trying to get a kpi sorted from highest to lowest. I get them from the following:

df_partidos.groupby(['home']).agg({'away_score':[np.sum]}).head(10)

I would like to get the results of this kpi sorted from highest to lowest.

I have been looking with:

.sort_values( inplace=True, ascending=False)

But I haven't got any results. If someone can give me a hand

python

1 Answers

  1. Best Answer

    Good day,

    You can use df.sort_values()to sort ascending or descending with one or multiple columns

    Inside the method sort_values()you must assign the column in the argumentby

    df_partidos.sort_values(by=['col1'])

    If you want to sort descending you must use

    df_matches.sort_values(by='col1', ascending=False)

    If you want to sort with multiple columns then you should use a column array inby

    df_partidos.sort_values(by=['col1', 'col2'])

    Full documentation is here

    • 1