Квантильный и децильный ранг столбца в Pandas-Python

Опубликовано: 27 Марта, 2022

Let’s see how to find the Quantile and Decile ranks of a column in Pandas. We will be using the qcut() function of the pandas module.

pandas.qcut()

Pandas library’s function qcut() is a Quantile-based discretization function. This means that it discretize the variables into equal-sized buckets based on rank or based on sample quantiles.

Syntax : pandas.qcut(x, q, labels=None, retbins: bool = False, precision: int = 3, duplicates: str = ‘raise’)
Parameters :
x : 1d ndarray or Series.
q : Number of quantiles. For example, 10 refers to deciles and 4 refers to quantiles.
labels : Used as labels for the resulting bins. If it is set as False, it returns only integer indicators of the bins. If True, then it raises an error. By default, it is set to None.
retbins : (Optional) It is a boolean which returns the (bins, labels) when set to True.
precision : (Optional) The precision at which to store and display the bins labels.
duplicates : (Optional) If bin edges are not unique, raise ValueError or drop non-uniques.

Quantile Rank

Алгоритм:

Import pandas and numpy modules.
Create a dataframe.
Use pandas.qcut() function, the Score column is passed, on which the quantile discretization is calculated. And q is set to 4 so the values are assigned from 0-3
Print the dataframe with the quantile rank.

# importing the modules
import pandas as pd
import numpy as np
    
# creating a DataFrame
df = {"Name" : ["Amit", "Darren", "Cody", "Drew",
                "Ravi", "Donald", "Amy"],
      "Score" : [50, 71, 87, 95, 63, 32, 80]}
df = pd.DataFrame(df, columns = ["Name", "Score"])
  
# adding Quantile_rank column to the DataFrame
df["Quantile_rank"] = pd.qcut(df["Score"], 4,
                               labels = False)
  
# printing the DataFrame
print(df)

Output :

Decile Rank

Algorithm :

Import pandas and numpy modules.
Create a dataframe.
Use pandas.qcut() function, the Score column is passed, on which the quantile discretization is calculated. And q is set to 10 so the values are assigned from 0-9
Print the dataframe with the decile rank.

# importing the modules
import pandas as pd
import numpy as np
    
# creating a DataFrame
df = {"Name" : ["Amit", "Darren", "Cody", "Drew",
                "Ravi", "Donald", "Amy"],
      "Score" : [50, 71, 87, 95, 63, 32, 80]}
df = pd.DataFrame(df, columns = ["Name", "Score"])
  
# adding Decile_rank column to the DataFrame
df["Decile_rank"] = pd.qcut(df["Score"], 10,
                            labels = False)
  
# printing the DataFrame
print(df)

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. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course

Python

Квантильный и децильный ранг столбца в Pandas-Python

pandas.qcut()

Quantile Rank

Decile Rank

РЕКОМЕНДУЕМЫЕ СТАТЬИ