Separate a character column into multiple columns based on a substring

Currently, splitting a column on a position is not possible.

Usage

# S3 method for class 'polars_data_frame'
separate(data, col, into, sep = " ", remove = TRUE, ...)

# S3 method for class 'polars_lazy_frame'
separate(data, col, into, sep = " ", remove = TRUE, ...)

Arguments

data

A Polars Data/LazyFrame

col

Column to split

into

Character vector containing the names of new variables to create. Use NA to omit the variable in the output.

sep

A regular expression that is used to split the column.

remove

If TRUE, remove input column from output data frame.

...

Dots which should be empty.

Examples

# Split at each dot
test <- polars::pl$DataFrame(x = c(NA, "x.y", "x.z", "y.z"))
separate(test, x, into = c("foo", "foo2"), sep = "\\.")
#> shape: (4, 2)
#> ┌──────┬──────┐
#> │ foo  ┆ foo2 │
#> │ ---  ┆ ---  │
#> │ str  ┆ str  │
#> ╞══════╪══════╡
#> │ null ┆ null │
#> │ x    ┆ y    │
#> │ x    ┆ z    │
#> │ y    ┆ z    │
#> └──────┴──────┘

# Split on any number of whitespace
test <- polars::pl$DataFrame(x = c(NA, "x y", "x  y", "x y  z"))
separate(test, x, into = c("foo", "foo2"), sep = "\\s+")
#> shape: (4, 2)
#> ┌──────┬──────┐
#> │ foo  ┆ foo2 │
#> │ ---  ┆ ---  │
#> │ str  ┆ str  │
#> ╞══════╪══════╡
#> │ null ┆ null │
#> │ x    ┆ y    │
#> │ x    ┆ y    │
#> │ x    ┆ y    │
#> └──────┴──────┘