Multi Index Sorting in Pandas

by

When sorting by a MultiIndex you need to contain the tuple describing the column inside a list*:

In [11]: df.sort_values([('Group1', 'C')], ascending=False)
Out[11]: 
  Group1       Group2      
       A  B  C      A  B  C
2      5  6  9      1  0  0
1      1  0  3      2  5  7
3      7  0  2      0  3  5

* so as not to confuse pandas into thinking you want to sort first by Group1 then by C.

Note: Originally used .sort since deprecated then removed in 0.20, in favor of .sort_values.

More Related Contents:

  1. Select rows in pandas MultiIndex DataFrame
  2. how to sort pandas dataframe from one column
  3. Construct pandas DataFrame from items in nested dictionary
  4. Converting a Pandas GroupBy output from Series to DataFrame
  5. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  6. Why does my Pandas DataFrame not display new order using `sort_values`?
  7. selecting from multi-index pandas
  8. How to flatten a hierarchical index in columns
  9. Sort a pandas dataframe series by month name
  10. Find the unique values in a column and then sort them
  11. Turn Pandas Multi-Index into column
  12. Python – Delete duplicates in a dataframe based on two columns combinations?
  13. Pandas DataFrame sort by categorical column but by specific class ordering
  14. Filling in date gaps in MultiIndex Pandas Dataframe
  15. Sorting by absolute value without changing the data
  16. Sum columns by level in a pandas MultiIndex DataFrame
  17. How to sort pandas data frame using values from several columns?
  18. Pandas conditional creation of a series/dataframe column
  19. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  20. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  21. Error: pandas hashtable keyerror
  22. Remove unwanted parts from strings in a column
  23. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  24. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  25. python/pandas: convert month int to month name
  26. How to check if a column exists in Pandas
  27. Max and Min date in pandas groupby
  28. How to open and convert sqlite database to pandas dataframe
  29. Set value on an entire column of a pandas dataframe
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment