quantile_node: Compute quantiles over non-NULL values (without...

In rquery: Relational Query Generator for Data Manipulation at Scale

Compute quantiles over non-NULL values (without interpolation, needs a database with window functions).

Description

Please see https://github.com/WinVector/rquery/blob/master/extras/Summary_Example.md for an example.

Usage

quantile_node(
  source,
  cols = NULL,
  ...,
  probs_name = "quantile_probability",
  probs = seq(0, 1, 0.25),
  tmp_name_source = wrapr::mk_tmp_name_source("qn"),
  temporary = TRUE,
  qualifiers = NULL
)

Arguments

source	source to select from (relop or data.frame).
cols	character, compute quantiles for these columns (NULL indicates all columns).
...	force later arguments to be bound by name
probs_name	character, column name to write probs in.
probs	numeric quantiles to compute
tmp_name_source	wrapr::mk_tmp_name_source(), temporary name generator.
temporary	logical, if TRUE use temporary tables
qualifiers	optional named ordered vector of strings carrying additional db hierarchy terms, such as schema.

Details

This is a non_sql_node, so please see non_sql_node for some of the issues for this node type.

Value

table of quantiles

See Also

quantile_cols, rsummary, non_sql_node

rquery documentation built on Aug. 20, 2023, 9:06 a.m.