unite: Unite multiple columns into one by pasting strings together

In tidyft: Fast and Memory Efficient Data Operations in Tidy Syntax

Unite multiple columns into one by pasting strings together

Description

Convenience function to paste together multiple columns into one. Analogous to tidyr::unite.

Usage

unite(.data, united_colname, ..., sep = "_", remove = FALSE, na2char = FALSE)

Arguments

.data	A data frame.
united_colname	The name of the new column, string only.
...	A selection of columns. If want to select all columns, pass "" to the parameter. See example.
sep	Separator to use between values.
remove	If TRUE, remove input columns from output data frame.
na2char	If FALSE, missing values would be merged into NA, otherwise NA is treated as character "NA". This is different from tidyr.

Value

A data.table

See Also

unite,separate

Examples

df <- CJ(x = c("a", NA), y = c("b", NA))
df

# Treat missing value as NA, default
df %>% unite("z", x:y, remove = FALSE)
# Treat missing value as character "NA"
df %>% unite("z", x:y, na2char = TRUE, remove = FALSE)
# the unite has memory, "z" would not be removed in new operations
# here we remove the original columns ("x" and "y")
df %>% unite("xy", x:y,remove = TRUE)

# Select all columns
iris %>% as.data.table %>% unite("merged_name",".")

tidyft documentation built on Sept. 30, 2024, 9:40 a.m.