duckplyr: Tight Integration of duckdb with R and the tidyverse
summary
duckplyr turns dplyr pipelines into a single DuckDB query so R code runs end-to-end inside DuckDB with data frame in, data frame out, using multi‑threaded execution and Arrow integration. Benchmarks show a 1.7 GB NYC taxi example drops from about eight seconds in dplyr to 1.8 seconds and more complex queries that took ~20s fall under 2s. Tests reuse ~3,500 dplyr cases, CRAN impact assessed for ~4,000 packages; custom R functions and nested/list columns remain work in progress and row‑order preservation is optional.
AI-written summary · about
chapters (6)
related talks
15mGet Your Ducks in a Row with Databases
34mData Wrangling with DuckDB
30mDuckDB: Bringing analytical SQL directly to your Python shell
27mIn Process Analytical Data Management with DuckDB
58mData Wrangling [for Python or R] Like a Boss With DuckDB
33mData preparation and analytics on your laptop with DuckDB
40mDuckDB beyond the notebook
25mProcessing Biggish Data with DuckDB and Python