quantile function
The quantile function returns the specified quantile of the column, evaluated within groups defined by the group parameter if required. A column of weights can also be defined.
Quantiles are cut points dividing a range of probability distribution into intervals with equal probabilities.
Function and parameters
quantile(column, quant, group, weights)
Parameter | Description |
---|---|
column | It identifies the column to which you want to apply the formula. The column parameter is mandatory. |
quant | It is the percentile. The quant parameter is mandatory. |
group | It allows you to group the results by a certain column. |
weights | It defines the importance of a certain attribute. |
Example
The following example uses the HR-employee-attrition dataset.
Description | Screenshot |
---|---|
| |
In this case, the results don’t change. |