top of page
learn_data_science.jpg

Data Scientist Program

 

Free Online Data Science Training for Complete Beginners.
 


No prior coding knowledge required!

Writer's pictureAbu Bin Fahd

Pandas Technique: Sorting Dataset


import pandas as pd
import numpy as np

Read Dataset

df = pd.read_csv('Srt_dta.csv')
df

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)')

Sorting in descending value

To sort in descending order, we need to specify ascending=False

df.sort_values('Weight(kg)', ascending=False)

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)'])

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])


0 comments

Recent Posts

See All

Comments


bottom of page