unite.tbl: Unite multiple columns into one by pasting strings together

In nhsbsa-data-analytics/addressMatchR: This package matches address

Unite multiple columns into one by pasting strings together

Description

Convenience function to paste together multiple columns into one in a {dbplyr} lazy table.

Usage

unite.tbl(data, col, ..., sep = "_", remove = TRUE, na.rm = FALSE)

Arguments

data	A {dbplyr} lazy table.
col	The name of the new column, as a string or symbol. This argument is passed by expression and supports quasiquotation (you can unquote strings and symbols). The name is captured from the expression with rlang::ensym() (note that this kind of interface where symbols do not represent actual objects is now discouraged in the tidyverse; we support it here for backward compatibility).
...	<tidy-select> Columns to unite
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.

Value

The data frame, with additional column created

Note

https://stackoverflow.com/a/76013501/8519200

Examples

## Not run: 
df -> unite.tbl(
  united_col,
  col_1, col_2,
  sep = " ", remove = FALSE, na.rm = TRUE
)

## End(Not run)

nhsbsa-data-analytics/addressMatchR documentation built on June 16, 2024, 6:03 a.m.