Unite one or more columns in group_name-group_level format

Unites targeted table columns into group_name-group_level columns.

Usage

uniteGroup(x, cols = character(0), keep = FALSE, ignore = c(NA, "overall"))

Arguments

x

Tibble or dataframe.

cols

Columns to aggregate.

keep

Whether to keep the original columns.

ignore

Level values to ignore.

Value

A tibble with the new columns.

Examples

x <- dplyr::tibble(
  variable = "number subjects",
  value = c(10, 15, 40, 78),
  sex = c("Male", "Female", "Male", "Female"),
  age_group = c("<40", ">40", ">40", "<40")
)

x |>
  uniteGroup(c("sex", "age_group"))
#> # A tibble: 4 × 4
#>   variable        value group_name        group_level   
#>   <chr>           <dbl> <chr>             <chr>         
#> 1 number subjects    10 sex &&& age_group Male &&& <40  
#> 2 number subjects    15 sex &&& age_group Female &&& >40
#> 3 number subjects    40 sex &&& age_group Male &&& >40  
#> 4 number subjects    78 sex &&& age_group Female &&& <40