You want to sort a pandas dataframe by multiple columns.
To sort a dataframe in pandas we use the sort_values() method.
Let’s read a dataset to work with.
import pandas as pd url = "https://raw.githubusercontent.com/bprasad26/lwd/master/data/clothing_store_sales.csv" df = pd.read_csv(url) df.head()
Let’s say you want to sort the dataframe by Age and Net Sales. To do that, you will pass the name of the columns in a list to the by parameter.
df.sort_values(by=['Age', 'Net Sales'])
And if you want to sort the dataframe by a column in ascending order and another column in descending order, you will write.
df.sort_values(by=['Age', 'Net Sales'], ascending=[True, False])
Here, we sorted the Age column in ascending order and the Net Sales in descending order.