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

Get n-largest 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-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.




# importing pandas module 
import pandas as pd 
    
# making data frame 
  
df.head(10)


Code #1: Getting 5 largest Age




# 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




# 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




# 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:

RELATED ARTICLES

2 COMMENTS

Most Popular

Dominic
32714 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7088 POSTS0 COMMENTS
Nicole Veronica
12228 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12310 POSTS0 COMMENTS
Shaida Kate Naidoo
7204 POSTS0 COMMENTS
Ted Musemwa
7470 POSTS0 COMMENTS
Thapelo Manthata
7190 POSTS0 COMMENTS
Umr Jansen
7171 POSTS0 COMMENTS