{"repo":"tidyverse/duckplyr","free":true,"listed":false,"github":"https://github.com/tidyverse/duckplyr","clone":"git clone https://github.com/tidyverse/duckplyr.git","description":"A drop-in replacement for dplyr, powered by DuckDB for speed.","language":"R","stars":395,"topics":["dplyr","duckdb","analytics","dataframe","performance","r"],"license":null,"category":"analytics","readme_excerpt":"duckplyr A drop-in replacement for dplyr, powered by DuckDB for speed . dplyr is the grammar of data manipulation in the tidyverse. The duckplyr package will run all of your existing dplyr code with identical results, using DuckDB where possible to compute the results faster. In addition, you can analyze larger-than-memory datasets straight from files on your disk or from the web. If you are new to dplyr, the best place to start is the data transformation chapter in R for Data Science . Installation Install duckplyr from CRAN with: You can also install the development version of duckplyr from R-universe: Or from GitHub with: Drop-in replacement for dplyr Calling library(duckplyr) overwrites dplyr methods, enabling duckplyr for the entire session. The following code aggregates the inflight delay by year and month for the first half of the year. We use a variant of the nycflights13::flights dataset, where the timezone has been set to UTC to work around a current limitation of duckplyr, see vignette(\"limits\") . The result is a plain tibble: Nothing has been computed yet. Querying the number of rows, or a column, starts the computation: Note that, unlike dplyr, the results are not ordered, see ?config for details. However, once materialized, the results are stable: If a computation is not supported by DuckDB, duckplyr will automatically fall back to dplyr. Restart R, or call duckplyr::methods restore() to revert to the default dplyr implementation. Analyzing larger-than-memory da","default_branch":null,"files":null,"tree":[],"storefront":"/r/tidyverse","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tidyverse/duckplyr/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}