db_compute_count: Aggregates over a discrete field

In edgararuiz/dbplot: Simplifies Plotting Data Inside Databases

Description

Uses very generic dplyr code to aggregate data. Because of this approach, the calculations automatically run inside the database if 'data' has a database or sparklyr connection. The 'class()' of such tables in R are: tbl_sql, tbl_dbi, tbl_sql

Usage

db_compute_count(data, x, ..., y = n())

Arguments

data	A table (tbl)
x	A discrete variable
...	A set of named or unamed aggregations
y	The aggregation formula. Defaults to count (n)

Examples

# Returns the row count per am
mtcars %>%
  db_compute_count(am)

# Returns the average mpg per am
mtcars %>%
  db_compute_count(am, mean(mpg))

# Returns the average and sum of mpg per am
mtcars %>%
  db_compute_count(am, mean(mpg), sum(mpg))

edgararuiz/dbplot documentation built on Feb. 9, 2020, 10:21 p.m.