Pandas DataFrame: sort_values() function

DataFrame - sort_values() function

The sort_values() function is used to sort by the values along either axis.


DataFrame.sort_values(self, by, axis=0, ascending=True, inplace=False, kind='quicksort', na_position='last')


Name Description Type/Default Value Required / Optional
by       Name or list of names to sort by.
  • if axis is 0 or ‘index’ then by may contain index levels and/or column labels
  • if axis is 1 or ‘columns’ then by may contain column levels and/or index labels
Changed in version 0.23.0: Allow specifying index or column level names.

str or list of str Required
axis     Axis to be sorted. {0 or ‘index’, 1 or ‘columns’}
Default Value: 0
ascending     Sort ascending vs. descending. Specify list for multiple sort orders. If this is a list of bools, must match the length of the by. bool or list of bool
Default Value: True
inplace   If True, perform operation in-place. bool
Default Value: False
kind   Choice of sorting algorithm. See also ndarray.np.sort for more information. mergesort is the only stable algorithm. For DataFrames, this option is only applied when sorting on a single column or label. {‘quicksort’, ‘mergesort’, ‘heapsort’}
Default Value: ‘quicksort’
na_position   Puts NaNs at the beginning if first; last puts NaNs at the end. {‘first’, ‘last’}
Default Value: ‘last’

Returns: sorted_obj - DataFrame or None DataFrame with sorted values if inplace=False, None otherwise.


Download the Pandas DataFrame Notebooks from here.

Previous: DataFrame - pivot_table() function
Next: DataFrame - nlargest() function

Share this Tutorial / Exercise on : Facebook and Twitter