Skip to content
Related Articles

Related Articles

Percentile rank of a column in a Pandas DataFrame

View Discussion
Improve Article
Save Article
  • Last Updated : 17 Aug, 2020
View Discussion
Improve Article
Save Article

Let us see how to find the percentile rank of a column in a Pandas DataFrame. We will use the rank() function with the argument pct = True to find the percentile rank.

Example 1 :




# import the module
import pandas as pd 
  
# create a DataFrame 
data = {'Name': ['Mukul', 'Rohan', 'Mayank'
                 'Shubham', 'Aakash'],
        'Location' : ['Saharanpur', 'Meerut', 'Agra'
                      'Saharanpur', 'Meerut'],
        'Pay' : [50000, 70000, 62000, 67000, 56000]} 
df = pd.DataFrame(data)  
  
# create a new column of percentile rank
df['Percentile Rank'] = df.Pay.rank(pct = True)
  
# displaying the percentile rank
display(df) 

Output :

Example 2 :




# import the module
import pandas as pd 
  
# create a DataFrame 
ODI_runs = {'name': ['Tendulkar', 'Sangakkara', 'Ponting'
                      'Jayasurya', 'Jayawardene', 'Kohli'
                      'Haq', 'Kallis', 'Ganguly', 'Dravid'], 
            'runs': [18426, 14234, 13704, 13430, 12650
                     11867, 11739, 11579, 11363, 10889]} 
df = pd.DataFrame(ODI_runs)  
  
# create a new column of percentile rank
df['Percentile Rank'] = df.runs.rank(pct = True)
  
# displaying the percentile rank
display(df) 

Output :


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!