quantile_node {rquery}

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