Unite multiple columns into one by pasting strings together
Convenience function to paste together multiple columns into one.
Analogous to tidyr::unite.
unite(.data, united_colname, ..., sep = "_", remove = FALSE, na2char = FALSE)
.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 |
na2char |
If |
A data.table
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","")Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.