sorting - pandas groupby sort descending order

Question

pandas groupby will by default sort. But I'd like to change the sort order. How can I do this?

I'm guessing that I can't apply a sort method to the returned groupby object.

question from:https://stackoverflow.com/questions/27018622/pandas-groupby-sort-descending-order

Answer 1

Do your groupby, and use reset_index() to make it back into a DataFrame. Then sort.

grouped = df.groupby('mygroups').sum().reset_index()
grouped.sort_values('mygroups', ascending=False)