quantile_cols: Compute quantiles of specified columns (without...

In rquery: Relational Query Generator for Data Manipulation at Scale

Compute quantiles of specified columns (without interpolation, needs a database with window functions).

Description

Compute quantiles of specified columns (without interpolation, needs a database with window functions).

Usage

quantile_cols(
  db,
  incoming_table_name,
  ...,
  probs = seq(0, 1, 0.25),
  probs_name = "quantile_probability",
  cols = rq_colnames(db, incoming_table_name),
  qualifiers = NULL
)

Arguments

db	database connection
incoming_table_name	name of table to compute quantiles of
...	force later arguments to bind by name
probs	numeric, probabilities to compute quantiles of
probs_name	character name for probability column
cols	character, columns to compute quantiles of
qualifiers	optional named ordered vector of strings carrying additional db hierarchy terms, such as schema.

Value

data.frame of quantiles

See Also

quantile_node, rsummary

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