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()`	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

Reference

Using duckplyr

dplyr verbs

Computing and materializing data

Verbs that affect rows

Verbs that affect columns

Grouping and summarising verbs

Verbs that work with multiple tables

Unsupported verbs

Using duckplyr for all data frames

Datasets

Configuration, telemetry, and internals

Relational operations and expressions