e_table_aggregate: Aggregate a set of variables by another set of variables with...

In erikerhardt/erikmisc: Erik Erhardt's miscellaneous functions for solving complex data analysis workflows

Aggregate a set of variables by another set of variables with a specific function

Description

Aggregate a set of variables by another set of variables with a specific function

Usage

e_table_aggregate(
  dat,
  var_names_by,
  var_names_aggregate,
  func_aggregate = list(sum),
  .groups = c("drop", "keep")[1]
)

Arguments

dat	data.frame or tibble
var_names_by	list of variable names to group by
var_names_aggregate	list of variable names to aggregate
func_aggregate	a function (e.g., sum) to aggregate all variables by, or a list of functions to aggregate each variable by
.groups	drops or keeps groups

Value

aggregated data

Examples

e_table_aggregate(
    dat                 = dat_mtcars_e
  , var_names_by        = c("cyl")
  , var_names_aggregate = c("disp", "hp", "drat")
  , func_aggregate      = mean
  )
e_table_aggregate(
    dat                 = dat_mtcars_e
  , var_names_by        = c("cyl", "am")
  , var_names_aggregate = c("disp", "hp", "drat", "wt", "qsec")
  , func_aggregate      = list(sum, sum, mean, mean, sum)
  )

# assign variables and functions in a list
list_aggregate_var_func <-
  list(
    `disp` = sum
  , `hp`   = sum
  , `drat` = mean
  , `wt`   = mean
  , `qsec` = sum
  )
e_table_aggregate(
    dat                 = dat_mtcars_e
  , var_names_by        = c("cyl", "am")
  , var_names_aggregate = list_aggregate_var_func |> names()
  , func_aggregate      = list_aggregate_var_func
  )

erikerhardt/erikmisc documentation built on April 17, 2025, 10:48 a.m.