Get n-smallest values from a particular column in Pandas DataFrame

Get n-largest values from a particular column in Pandas DataFrame

Last Updated : 18 Dec, 2018

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-largest 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-largest values from a particular column in Pandas DataFrame.

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("https://media.geeksforgeeks.org/wp-content/uploads/nba.csv") 

df.head(10)

Code #1: Getting 5 largest Age

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("nba.csv") 

# five largest values in column age
df.nlargest(5, ['Age'])

Output:

Code #2: Getting 10 maximum weights

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("nba.csv") 

# Ten largest values in column Weight
df.nlargest(10, ['Weight'])

Output:

Code #3: Getting 10 maximum salary

Python3 1==

# importing pandas module 
import pandas as pd 
  
# making data frame 
df = pd.read_csv("nba.csv") 

# five largest values in column Salary
df.nlargest(5, ['Salary'])

Output:

Get n-smallest values from a particular column in Pandas DataFrame

S

Shivam_k

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Pandas Exercises and Programs

Pandas is an open-source Python Library that is made mainly for working with relational or labelled data both easily and intuitively. This Python library is built on top of the NumPy library, providing various operations and data structures for manipulating numerical data and time series. Pandas is

Different ways to create Pandas Dataframe

It is the most commonly used Pandas object. The pd.DataFrame() function is used to create a DataFrame in Pandas. There are several ways to create a Pandas Dataframe in Python.Example: Creating a DataFrame from a DictionaryPythonimport pandas as pd # initialize data of lists. data = {'Name': ['Tom',