Get n-smallest values from a particular column in Pandas DataFrame
Pandas DataFrame is two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns).
Let’s see how can we can get n-smallest values from a particular column in Pandas DataFrame.
Observe this dataset first. We’ll use ‘Age’, ‘Weight’ and ‘Salary’ columns of this data in order to get n-smallest values from a particular column in Pandas DataFrame.
# importing pandas module import pandas as pd # making data frame df.head(10) |
chevron_right
filter_none
Code #1: Getting 5 smallest Age
# importing pandas module import pandas as pd # making data frame df = pd.read_csv("nba.csv") df.nsmallest(5, ['Age']) |
chevron_right
filter_none
Output:
Code #2: Getting 10 minimum weights
# importing pandas module import pandas as pd # making data frame df = pd.read_csv("nba.csv") df.nsmallest(10, ['Weight']) |
chevron_right
filter_none
Output:
Code #3: Getting 10 minimum salary
# importing pandas module import pandas as pd # making data frame df = pd.read_csv("nba.csv") df.nsmallest(5, ['Salary']) |
chevron_right
filter_none
Output:
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.
