Learn R Programming

duckplyr (version 1.0.1)

select.duckplyr_df: Keep or drop columns using their names and types

Description

This is a method for the dplyr::select() generic. See "Fallbacks" section for differences in implementation. Select (and optionally rename) variables in a data frame, using a concise mini-language that makes it easy to refer to variables based on their name (e.g. a:f selects all columns from a on the left to f on the right) or type (e.g. where(is.numeric) selects all numeric columns).

Usage

# S3 method for duckplyr_df
select(.data, ...)

Arguments

.data

A data frame, data frame extension (e.g. a tibble), or a lazy data frame (e.g. from dbplyr or dtplyr). See Methods, below, for more details.

...

<tidy-select> One or more unquoted expressions separated by commas. Variable names can be used as if they were positions in the data frame, so expressions like x:y can be used to select a range of variables.

Fallbacks

There is no DuckDB translation in select.duckplyr_df()

  • with no expression,

  • nor with a selection that returns no columns.

These features fall back to dplyr::select(), see vignette("fallback") for details.

See Also

Examples

Run this code
library(duckplyr)
select(mtcars, mpg)

Run the code above in your browser using DataLab