Package: duckplyr 0.99.99.9905
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:
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')) |
Bug tracker:https://github.com/tidyverse/duckplyr/issues
Pkgdown:https://duckplyr.tidyverse.org
analyticsdataframedplyrduckdbperformance
Last updated 4 hours agofrom:3bda67553e. Checks:OK: 7. Indexed: yes.
Target | Result | Date |
---|---|---|
Doc / Vignettes | OK | Dec 21 2024 |
R-4.5-win | OK | Dec 21 2024 |
R-4.5-linux | OK | Dec 21 2024 |
R-4.4-win | OK | Dec 21 2024 |
R-4.4-mac | OK | Dec 21 2024 |
R-4.3-win | OK | Dec 21 2024 |
R-4.3-mac | OK | Dec 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
Readme and manuals
Help Manual
Help page | Topics |
---|---|
Anti join | anti_join.duckplyr_df |
Order rows using column values | arrange.duckplyr_df |
Configuration options | config |
Count the observations in each group | count.duckplyr_df |
Keep distinct/unique rows | distinct.duckplyr_df |
Execute a statement for the default connection | duck_exec |
Read Parquet, CSV, and other files using DuckDB | duck_csv duck_file duck_json duck_parquet |
Return SQL query as duck_tbl | duck_sql |
duckplyr data frames | as_duck_tbl duck_tbl is_duck_tbl |
Explain details of a tbl | explain.duckplyr_df |
Fallback to dplyr | fallback fallback_purge fallback_review fallback_sitrep fallback_upload |
Keep rows that match a condition | filter.duckplyr_df |
Flight data | flights_df |
Full join | full_join.duckplyr_df |
Return the First Parts of an Object | head.duckplyr_df |
Inner join | inner_join.duckplyr_df |
Intersect | intersect.duckplyr_df |
Retrieve details about the most recent computation | last_rel |
Left join | left_join.duckplyr_df |
Forward all dplyr methods to duckplyr | methods_overwrite methods_restore |
Create, modify, and delete columns (duckplyr) | mutate.duckplyr_df |
Relational implementer's interface | new_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 expressions | new_relexpr relexpr_comparison relexpr_constant relexpr_function relexpr_reference relexpr_set_alias relexpr_window |
Verbs not implemented in duckplyr | not-supported |
Extract a single column | pull.duckplyr_df |
Change column order | relocate.duckplyr_df |
Rename columns | rename.duckplyr_df |
Right join | right_join.duckplyr_df |
Keep or drop columns using their names and types | select.duckplyr_df |
Semi join | semi_join.duckplyr_df |
Set diff | setdiff.duckplyr_df |
Show stats | stats_show |
Summarise each group down to one row | summarise.duckplyr_df |
Symmetric difference | symdiff.duckplyr_df |
Create, modify, and delete columns | transmute.duckplyr_df |
Union of all | union_all.duckplyr_df |