dbplot (version 0.3.3)

db_compute_boxplot: Returns a dataframe with boxplot calculations

Description

Uses very generic dplyr code to create boxplot calculations. 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_spark

It currently only works with Spark, Hive, and SQL Server connections.

Note that this function supports input tbl that already contains grouping variables. This can be useful when creating faceted boxplots.

Usage

db_compute_boxplot(data, x, var, coef = 1.5)

Arguments

data

A table (tbl), can already contain additional grouping vars specified

x

A discrete variable in which to group the boxplots

var

A continuous variable

coef

Length of the whiskers as multiple of IQR. Defaults to 1.5

Examples

# NOT RUN {
mtcars %>%
  db_compute_boxplot(am, mpg)
# }