Collapse data by values of a categorical variable

Collapse values in a categorical variable into one defined level

Usage

collapse_cat(data, var, levels, new_level, name = NULL)

Arguments

data

a dataframe to collapse

var

a string of the name of the categorical variable to collapse

levels

a character vector of the levels to be collapsed

new_level

a string for the new level

name

a name for the new variable

Value

the original dataframe containing a new column of the collapsed variable with tidyverse code attached

See also

code

Author

Zhaoming Su

Examples

collapsed <- collapse_cat(iris,
    var = "Species",
    c("versicolor", "virginica"),
    new_level = "V"
)
cat(code(collapsed))
#> iris |> dplyr::mutate(Species.coll = forcats::fct_collapse(Species, V = c(   "versicolor", "virginica")), .after = Species)
tail(collapsed)
#>     Sepal.Length Sepal.Width Petal.Length Petal.Width   Species Species.coll
#> 145          6.7         3.3          5.7         2.5 virginica            V
#> 146          6.7         3.0          5.2         2.3 virginica            V
#> 147          6.3         2.5          5.0         1.9 virginica            V
#> 148          6.5         3.0          5.2         2.0 virginica            V
#> 149          6.2         3.4          5.4         2.3 virginica            V
#> 150          5.9         3.0          5.1         1.8 virginica            V