Pandas Technique: Sorting Dataset
![](https://static.wixstatic.com/media/7db382_061765f637434b479d057ec7f9d018de~mv2.jpg/v1/fill/w_300,h_300,al_c,q_80,enc_avif,quality_auto/7db382_061765f637434b479d057ec7f9d018de~mv2.jpg)
import pandas as pd
import numpy as np
Read Dataset
df = pd.read_csv('Srt_dta.csv')
df
![](https://static.wixstatic.com/media/7db382_451f2aee6e734e19ae670ad24b78f86d~mv2.png/v1/fill/w_468,h_249,al_c,q_85,enc_avif,quality_auto/7db382_451f2aee6e734e19ae670ad24b78f86d~mv2.png)
Sorting
Pandas sort_values() function sorts a data frame in Ascending or Descending order of passed Column. It's different than the sorted Python function since it cannot sort a data frame and particular column cannot be selected.
df.sort_values('Weight(kg)')
![](https://static.wixstatic.com/media/7db382_cb5281ea55634cd78de63ae9c612607f~mv2.png/v1/fill/w_486,h_254,al_c,q_85,enc_avif,quality_auto/7db382_cb5281ea55634cd78de63ae9c612607f~mv2.png)
Sorting in descending value
To sort in descending order, we need to specify ascending=False
df.sort_values('Weight(kg)', ascending=False)
![](https://static.wixstatic.com/media/7db382_568fe255ad064b969bc85b792ccc0fbc~mv2.png/v1/fill/w_456,h_252,al_c,q_85,enc_avif,quality_auto/7db382_568fe255ad064b969bc85b792ccc0fbc~mv2.png)
Sorting by multiple variables
Call pandas.DataFrame.sort_values(by, ascending) with by as a list of column names to sort the rows in the DataFrame object based on the columns specified.
df.sort_values(['Weight(kg)', 'Height(cm)'])
![](https://static.wixstatic.com/media/7db382_b0c55f9650b64658a9bb2c7eb262ece8~mv2.png/v1/fill/w_464,h_243,al_c,q_85,enc_avif,quality_auto/7db382_b0c55f9650b64658a9bb2c7eb262ece8~mv2.png)
Sorting by multiple variables
Call pandas. DataFrame. sort_values(by, ascending) with by as a list of column names to sort the rows in the DataFrame object based on the columns specified in by . Set ascending to a tuple of booleans corresponding to the columns in by , where True sorts in ascending order and False sorts in descending order.
df.sort_values(['Weight(kg)', 'Height(cm)'], ascending=[True, False])
![](https://static.wixstatic.com/media/7db382_b8a9d1570d66499c8552467e7a220716~mv2.png/v1/fill/w_462,h_239,al_c,q_85,enc_avif,quality_auto/7db382_b8a9d1570d66499c8552467e7a220716~mv2.png)
Comments