...
- If a row contains a missing or null value, it is not factored into the calculation. If the entire column contains no values, the function returns a null value.
- When used in a
pivot transform, the function is computed for each instance of the value specified in the group parameter. See Pivot Transform.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | pivot value:percentile(myScores, 25, linear) group:postal_code limit:1 |
|---|
|
percentile(myScores, 25, linear) |
...
- Literal values are not supported as inputs.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String (column reference) | precipitationIn |
num_percentile
Integer literal value indicating the percentile that you wish to compute. Input value must be
...
between 1
...
and 100, inclusive.
- Column or function references are not supported.
- Multiple columns and wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | Integer | 55 |
...
Method of interpolation between each discrete value. The list of support methods is the following:
| Interpolation method | Description |
|---|
linear | Percentiles are calculated between two discrete values in a linear fashion. |
exclusive | Excludes 0 and 1 from calculation of percentiles. |
inclusive | Includes 0 and 1 from calculation of percentiles. |
lower | Use the lower value when the computed value falls between two discrete values. |
upper | Use the upper value when the computed value falls between two discrete values. |
midpoint | Use the midpoint value when the computed value falls between two discrete values. |
| Required? | Data Type | Example Value |
|---|
| Yes | Enum | linear |
Example - Percentile functions
...
