Unite multiple columns into one by pasting strings together

Usage

# S3 method for class 'RPolarsDataFrame'
unite(data, col, ..., sep = "_", remove = TRUE, na.rm = FALSE)

# S3 method for class 'RPolarsLazyFrame'
unite(data, col, ..., sep = "_", remove = TRUE, na.rm = FALSE)

Arguments

data: A Polars Data/LazyFrame
col: The name of the new column, as a string or symbol.
...: Any expression accepted by dplyr::select(): variable names, column numbers, select helpers, etc.
sep: Separator to use between values.
remove: If TRUE, remove input columns from the output Data/LazyFrame.
na.rm: If TRUE, missing values will be replaced with an empty string prior to uniting each value.

Examples

test <- polars::pl$DataFrame(
  year = 2009:2011,
  month = 10:12,
  day = c(11L, 22L, 28L),
  name_day = c("Monday", "Thursday", "Wednesday")
)

# By default, united columns are dropped
unite(test, col = "full_date", year, month, day, sep = "-")
#> shape: (3, 2)
#> ┌───────────┬────────────┐
#> │ name_day  ┆ full_date  │
#> │ ---       ┆ ---        │
#> │ str       ┆ str        │
#> ╞═══════════╪════════════╡
#> │ Monday    ┆ 2009-10-11 │
#> │ Thursday  ┆ 2010-11-22 │
#> │ Wednesday ┆ 2011-12-28 │
#> └───────────┴────────────┘
unite(test, col = "full_date", year, month, day, sep = "-", remove = FALSE)
#> shape: (3, 5)
#> ┌──────┬───────┬─────┬───────────┬────────────┐
#> │ year ┆ month ┆ day ┆ name_day  ┆ full_date  │
#> │ ---  ┆ ---   ┆ --- ┆ ---       ┆ ---        │
#> │ i32  ┆ i32   ┆ i32 ┆ str       ┆ str        │
#> ╞══════╪═══════╪═════╪═══════════╪════════════╡
#> │ 2009 ┆ 10    ┆ 11  ┆ Monday    ┆ 2009-10-11 │
#> │ 2010 ┆ 11    ┆ 22  ┆ Thursday  ┆ 2010-11-22 │
#> │ 2011 ┆ 12    ┆ 28  ┆ Wednesday ┆ 2011-12-28 │
#> └──────┴───────┴─────┴───────────┴────────────┘

test2 <- polars::pl$DataFrame(
  name = c("John", "Jack", "Thomas"),
  middlename = c("T.", NA, "F."),
  surname = c("Smith", "Thompson", "Jones")
)

# By default, NA values are kept in the character output
unite(test2, col = "full_name", everything(), sep = " ")
#> shape: (3, 1)
#> ┌──────────────────┐
#> │ full_name        │
#> │ ---              │
#> │ str              │
#> ╞══════════════════╡
#> │ John T. Smith    │
#> │ Jack NA Thompson │
#> │ Thomas F. Jones  │
#> └──────────────────┘
unite(test2, col = "full_name", everything(), sep = " ", na.rm = TRUE)
#> shape: (3, 1)
#> ┌─────────────────┐
#> │ full_name       │
#> │ ---             │
#> │ str             │
#> ╞═════════════════╡
#> │ John T. Smith   │
#> │ Jack  Thompson  │
#> │ Thomas F. Jones │
#> └─────────────────┘