How to sort pandas data frame using values from several columns?

by

DataFrame.sort is deprecated; use DataFrame.sort_values.

>>> df.sort_values(['c1','c2'], ascending=[False,True])
   c1   c2
0   3   10
3   2   15
1   2   30
4   2  100
2   1   20
>>> df.sort(['c1','c2'], ascending=[False,True])
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/ampawake/anaconda/envs/pseudo/lib/python2.7/site-packages/pandas/core/generic.py", line 3614, in __getattr__
    return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'sort'

More Related Contents:

  1. how to sort pandas dataframe from one column
  2. Why does my Pandas DataFrame not display new order using `sort_values`?
  3. Sort a pandas dataframe series by month name
  4. Find the unique values in a column and then sort them
  5. Python – Delete duplicates in a dataframe based on two columns combinations?
  6. Pandas DataFrame sort by categorical column but by specific class ordering
  7. Sorting by absolute value without changing the data
  8. Multi Index Sorting in Pandas
  9. How to sort a dataFrame in python pandas by two or more columns?
  10. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  11. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  12. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  13. Conditionally fill column values based on another columns value in pandas
  14. pandas concat generates nan values
  15. Remove duplicate rows from Pandas dataframe where only some columns have the same value
  16. Normalize columns of a dataframe
  17. Pandas Groupby and Sum Only One Column
  18. Quickest way to make a get_dummies type dataframe from a column with a multiple of strings
  19. “unstack” a pandas column containing lists into multiple rows [duplicate]
  20. Pandas Replace NaN with blank/empty string
  21. How to check whether a pandas DataFrame is empty?
  22. Python pandas Filtering out nan from a data selection of a column of strings
  23. Copy pandas dataframe to excel using openpyxl
  24. How to drop unique rows in a pandas dataframe?
  25. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  26. Remove row with null value from pandas data frame
  27. How do you remove the column name row when exporting a pandas DataFrame?
  28. Remove ends of string entries in pandas DataFrame column
  29. Collapsing rows in a Pandas dataframe if all rows have only one value in their columns
  30. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it

Leave a Comment