Package index • duckplyr

Using duckplyr

duckdb_tibble() as_duckdb_tibble() is_duckdb_tibble(): duckplyr data frames

read_parquet_duckdb() read_csv_duckdb() read_json_duckdb() read_file_duckdb(): Read Parquet, CSV, and other files using DuckDB

read_sql_duckdb() experimental: Return SQL query as duckdb_tibble

dplyr verbs

Computing and materializing data

compute(<duckplyr_df>): Compute results

compute_parquet() compute_csv(): Compute results to a file

collect(<duckplyr_df>): Force conversion to a data frame

pull(<duckplyr_df>): Extract a single column

explain(<duckplyr_df>): Explain details of a tbl

Verbs that affect rows

arrange(<duckplyr_df>): Order rows using column values

distinct(<duckplyr_df>): Keep distinct/unique rows

filter(<duckplyr_df>): Keep rows that match a condition

head(<duckplyr_df>): Return the First Parts of an Object

Verbs that affect columns

mutate(<duckplyr_df>): Create, modify, and delete columns

transmute(<duckplyr_df>): Create, modify, and delete columns

select(<duckplyr_df>): Keep or drop columns using their names and types

rename(<duckplyr_df>): Rename columns

relocate(<duckplyr_df>): Change column order

Grouping and summarising verbs

count(<duckplyr_df>): Count the observations in each group

summarise(<duckplyr_df>): Summarise each group down to one row

Verbs that work with multiple tables

left_join(<duckplyr_df>): Left join

right_join(<duckplyr_df>): Right join

inner_join(<duckplyr_df>): Inner join

full_join(<duckplyr_df>): Full join

semi_join(<duckplyr_df>): Semi join

anti_join(<duckplyr_df>): Anti join

intersect(<duckplyr_df>): Intersect

union(<duckplyr_df>): Union

union_all(<duckplyr_df>): Union of all

setdiff(<duckplyr_df>): Set difference

symdiff(<duckplyr_df>): Symmetric difference

Unsupported verbs

unsupported: Verbs not implemented in duckplyr

Using duckplyr for all data frames

methods_overwrite() methods_restore(): Forward all dplyr methods to duckplyr

Datasets

flights_df(): Flight data

Configuration, telemetry, and internals

config: Configuration options

fallback_sitrep() fallback_config() fallback_review() fallback_upload() fallback_purge(): Fallback to dplyr

stats_show(): Show stats

last_rel(): Retrieve details about the most recent computation

db_exec(): Execute a statement for the default connection

Relational operations and expressions

new_relational() rel_to_df() rel_filter() rel_project() rel_aggregate() rel_order() rel_join() rel_limit() rel_distinct() rel_set_intersect() rel_set_diff() rel_set_symdiff() rel_union_all() rel_explain() rel_alias() rel_set_alias() rel_names(): Relational implementer's interface

new_relexpr() relexpr_reference() relexpr_constant() relexpr_function() relexpr_comparison() relexpr_window() relexpr_set_alias(): Relational expressions