Skip to content

cs__exclude

Select all columns except those matching the given columns, datatypes, or selectors

Description

Select all columns except those matching the given columns, datatypes, or selectors

Usage

cs__exclude(...)

Arguments

\<dynamic-dots\> Column names to exclude.

Details

If excluding a single selector it is simpler to write as !selector instead.

Value

A Polars selector

See Also

cs for the documentation on operators supported by Polars selectors.

Examples

library("polars")

df <- pl$DataFrame(
  aa = 1:3,
  ba = c("a", "b", NA),
  cc = c(NA, 2.5, 1.5)
)

# Exclude by column name(s):
df$select(cs$exclude("ba", "xx"))
#> shape: (3, 2)
#> ┌─────┬──────┐
#> │ aa  ┆ cc   │
#> │ --- ┆ ---  │
#> │ i32 ┆ f64  │
#> ╞═════╪══════╡
#> │ 1   ┆ null │
#> │ 2   ┆ 2.5  │
#> │ 3   ┆ 1.5  │
#> └─────┴──────┘
# Exclude using a column name, a selector, and a dtype:
df$select(cs$exclude("aa", cs$string(), pl$Int32))
#> shape: (3, 1)
#> ┌──────┐
#> │ cc   │
#> │ ---  │
#> │ f64  │
#> ╞══════╡
#> │ null │
#> │ 2.5  │
#> │ 1.5  │
#> └──────┘