rquery (version 0.5.0)

quantile_node: 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)

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

Value

table of quantiles

Details

This is a non_sql_node, so forces the materialization of the calculation prior to it losing narrowing optimizations.

See Also

quantile_cols, rsummary, non_sql_node