Skip to content

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

Source code

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  │
#> └──────┘