Tutorials References Exercises Videos Menu
Website Get Certified Pro NEW

Pandas DataFrame sort_values() Method

❮ DataFrame Reference


Sort the DataFrame by age:

import pandas as pd

data = {
  "age": [50, 40, 30, 40, 20, 10, 30],
  "qualified": [True, False, False, False, False, True, True]
df = pd.DataFrame(data)

newdf = df.sort_values(by='age')
Try it Yourself »

Definition and Usage

The sort_values() method sorts the DataFrame by the specified label.


dataframe.sort_values(by, axis, ascending, inplace, kind, na_position, ignore_index, key)


The parameters are keyword arguments.

Parameter Value Description
by String
List of strings
Required. Specify labels to sort by. Either index level(s) or column label(s). Or, if the axis is 1 or 'columns' this values specify column level(s) or index label(s)
axis 0
Optional. Default 0. Specifies the axis to sort by
ascending True
Optional, default True. Specifies whether to sort ascending (0 -> 9) or descending (9 -> 0)
inplace True
Optional, default False. Specifies whether to perform the operation on the original DataFrame or not, if not, which is default, this method returns a new DataFrame
kind 'quicksort'
Optional, default 'quicksort'. Specifies the sorting algorithm
na_position 'first'
Optional, default 'last'. Specifies how to handle NULL values. 'first' means put them first, 'last' means put them last.
ignore_index True
Optional, default False. Specifies whether to ignore index or not. If True the original indexes are ignored, and replaced by 0, 1, 2 etc.
key Function Optional, specify a function to be executed before the sorting

Return Value

A DataFrame with the sorted result, or None if the inplace parameter is set to True.

❮ DataFrame Reference