Unite Multiple Columns into One — df

Paste together multiple columns into one. Wrapper arround unite() that supports standard and non standard evaluation.

df_unite(data, col, ..., vars = NULL, sep = "_", remove = TRUE, na.rm = FALSE)

df_unite_factors(
  data,
  col,
  ...,
  vars = NULL,
  sep = "_",
  remove = TRUE,
  na.rm = FALSE
)

Arguments

data	a data frame
col	the name of the new column as a string or a symbol.
...	a selection of columns. One or more unquoted expressions (or variable names) separated by commas.
vars	a character vector containing the column names of interest.
sep	Separator to use between values.
remove	If `TRUE`, remove input columns from output data frame.
na.rm	If `TRUE`, missing values will be remove prior to uniting each value.

Functions

df_unite: Unite multiple columns into one.
df_unite_factors: Unite factor columns. First, order factors levels then merge them into one column. The output column is a factor.

Examples

# Non standard evaluation
head(ToothGrowth) %>%
 df_unite(col = "dose_supp", dose, supp)
#>    len dose_supp
#> 1  4.2    0.5_VC
#> 2 11.5    0.5_VC
#> 3  7.3    0.5_VC
#> 4  5.8    0.5_VC
#> 5  6.4    0.5_VC
#> 6 10.0    0.5_VC

# Standard evaluation
head(ToothGrowth) %>%
 df_unite(col = "dose_supp", vars = c("dose", "supp"))
#>    len dose_supp
#> 1  4.2    0.5_VC
#> 2 11.5    0.5_VC
#> 3  7.3    0.5_VC
#> 4  5.8    0.5_VC
#> 5  6.4    0.5_VC
#> 6 10.0    0.5_VC