Package: duckplyr 0.99.99.9905

Kirill Müller

duckplyr: A 'DuckDB'-Backed Version of 'dplyr'

A drop-in replacement for 'dplyr', powered by 'DuckDB' for performance. Offers convenient utilities for working with in-memory and larger-than-memory data while retaining full 'dplyr' compatibility.

Authors:Hannes Mühleisen [aut], Kirill Müller [aut, cre], Posit Software, PBC [cph, fnd]

duckplyr_0.99.99.9905.tar.gz
duckplyr_0.99.99.9905.zip(r-4.5)duckplyr_0.99.99.9905.zip(r-4.4)duckplyr_0.99.99.9905.zip(r-4.3)
duckplyr_0.99.99.9905.tgz(r-4.4-any)duckplyr_0.99.99.9905.tgz(r-4.3-any)
duckplyr_0.99.99.9905.tar.gz(r-4.5-noble)duckplyr_0.99.99.9905.tar.gz(r-4.4-noble)
duckplyr_0.99.99.9905.tgz(r-4.4-emscripten)duckplyr_0.99.99.9905.tgz(r-4.3-emscripten)
duckplyr.pdf |duckplyr.html
duckplyr/json (API)
NEWS

# Install 'duckplyr' in R:
install.packages('duckplyr', repos = c('https://tidyverse.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/tidyverse/duckplyr/issues

Pkgdown:https://duckplyr.tidyverse.org

On CRAN:

analyticsdataframedplyrduckdbperformance

10.29 score 294 stars 162 scripts 1.1k downloads 54 exports 22 dependencies

Last updated 4 hours agofrom:3bda67553e. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKDec 21 2024
R-4.5-winOKDec 21 2024
R-4.5-linuxOKDec 21 2024
R-4.4-winOKDec 21 2024
R-4.4-macOKDec 21 2024
R-4.3-winOKDec 21 2024
R-4.3-macOKDec 21 2024

Exports:%>%as_duck_tblas_duckplyr_dfas_duckplyr_tibbledf_from_csvdf_from_filedf_from_parquetdf_to_parquetduck_csvduck_execduck_fileduck_jsonduck_parquetduck_sqlduck_tblduckplyr_df_from_csvduckplyr_df_from_fileduckplyr_df_from_parquetduckplyr_executefallback_purgefallback_reviewfallback_sitrepfallback_uploadflights_dfis_duck_tblis_duckplyr_dflast_relmethods_overwritemethods_restorenew_relationalnew_relexprrel_aggregaterel_aliasrel_distinctrel_explainrel_filterrel_joinrel_limitrel_namesrel_orderrel_projectrel_set_aliasrel_set_diffrel_set_intersectrel_set_symdiffrel_to_dfrel_union_allrelexpr_comparisonrelexpr_constantrelexpr_functionrelexpr_referencerelexpr_set_aliasrelexpr_windowstats_show

Dependencies:cachemclicollectionsDBIdplyrduckdbfastmapgenericsgluejsonlitelifecyclemagrittrmemoisepillarpkgconfigR6rlangtibbletidyselectutf8vctrswithr

Use of duckplyr in other packages

Rendered fromdevelopers.Rmdusingknitr::rmarkdownon Dec 21 2024.

Last update: 2024-12-19
Started: 2024-12-14

Translations

Rendered fromlimits.Rmdusingknitr::rmarkdownon Dec 21 2024.

Last update: 2024-12-14
Started: 2024-12-14

Readme and manuals

Help Manual

Help pageTopics
Anti joinanti_join.duckplyr_df
Order rows using column valuesarrange.duckplyr_df
Configuration optionsconfig
Count the observations in each groupcount.duckplyr_df
Keep distinct/unique rowsdistinct.duckplyr_df
Execute a statement for the default connectionduck_exec
Read Parquet, CSV, and other files using DuckDBduck_csv duck_file duck_json duck_parquet
Return SQL query as duck_tblduck_sql
duckplyr data framesas_duck_tbl duck_tbl is_duck_tbl
Explain details of a tblexplain.duckplyr_df
Fallback to dplyrfallback fallback_purge fallback_review fallback_sitrep fallback_upload
Keep rows that match a conditionfilter.duckplyr_df
Flight dataflights_df
Full joinfull_join.duckplyr_df
Return the First Parts of an Objecthead.duckplyr_df
Inner joininner_join.duckplyr_df
Intersectintersect.duckplyr_df
Retrieve details about the most recent computationlast_rel
Left joinleft_join.duckplyr_df
Forward all dplyr methods to duckplyrmethods_overwrite methods_restore
Create, modify, and delete columns (duckplyr)mutate.duckplyr_df
Relational implementer's interfacenew_relational rel_aggregate rel_alias rel_distinct rel_explain rel_filter rel_join rel_limit rel_names rel_order rel_project rel_set_alias rel_set_diff rel_set_intersect rel_set_symdiff rel_to_df rel_union_all
Relational expressionsnew_relexpr relexpr_comparison relexpr_constant relexpr_function relexpr_reference relexpr_set_alias relexpr_window
Verbs not implemented in duckplyrnot-supported
Extract a single columnpull.duckplyr_df
Change column orderrelocate.duckplyr_df
Rename columnsrename.duckplyr_df
Right joinright_join.duckplyr_df
Keep or drop columns using their names and typesselect.duckplyr_df
Semi joinsemi_join.duckplyr_df
Set diffsetdiff.duckplyr_df
Show statsstats_show
Summarise each group down to one rowsummarise.duckplyr_df
Symmetric differencesymdiff.duckplyr_df
Create, modify, and delete columnstransmute.duckplyr_df
Union of allunion_all.duckplyr_df