add_grps: Collapse variable into groups and sum

In camille-s/camiller: Lots of convenience functions

Description

Collapse variable into groups and sum

Usage

add_grps(
  .data,
  grp_list,
  group = group,
  value = estimate,
  moe = NULL,
  estimate = NULL
)

Arguments

.data	A data frame; will honor grouping
grp_list	A named list of groups to collapse group into
group	Bare column name giving groups in data; will be converted to factor
value	Bare column name of values. Replaces estimate argument, but (for now) still defaults to a column named estimate
moe	Bare column name of margins of error; if supplied, MOEs of sums will be included in output
estimate	Soft deprecated; use value. Bare column name of estimates or values

Value

A data frame/tibble with sums of estimate. Retains grouping columns

Examples

edu_list <- list(ages25plus = 1, less_than_high_school = 2:16,
    high_school = 17:18, some_college_or_aa = 19:21, bachelors_plus = 22:25)

edu_detail %>%
  dplyr::group_by(name) %>%
  add_grps(edu_list, group = variable, value = estimate, moe = moe)

edu_detail %>%
  dplyr::group_by(name) %>%
  add_grps(list(total = "ages25plus",
      aa_or_bach = c("Associate's degree", "Bachelor's degree"),
      bachelors_plus = c("Bachelor's degree", "Master's degree",
                         "Professional school degree", "Doctorate degree")),
    value = estimate, group = variable, moe = moe)

camille-s/camiller documentation built on Jan. 22, 2022, 6:50 a.m.