Package: duckplyr 0.99.99.9918
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:
duckplyr_0.99.99.9918.tar.gz
duckplyr_0.99.99.9918.zip(r-4.5)duckplyr_0.99.99.9918.zip(r-4.4)duckplyr_0.99.99.9918.zip(r-4.3)
duckplyr_0.99.99.9918.tgz(r-4.4-any)duckplyr_0.99.99.9918.tgz(r-4.3-any)
duckplyr_0.99.99.9918.tar.gz(r-4.5-noble)duckplyr_0.99.99.9918.tar.gz(r-4.4-noble)
duckplyr_0.99.99.9918.tgz(r-4.4-emscripten)duckplyr_0.99.99.9918.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 site:https://duckplyr.tidyverse.org
analyticsdataframedplyrduckdbperformance
Last updated 4 hours agofrom:0bc93b3937. Checks:7 OK. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Jan 19 2025 |
| R-4.5-win | OK | Jan 19 2025 |
| R-4.5-linux | OK | Jan 19 2025 |
| R-4.4-win | OK | Jan 19 2025 |
| R-4.4-mac | OK | Jan 19 2025 |
| R-4.3-win | OK | Jan 19 2025 |
| R-4.3-mac | OK | Jan 19 2025 |
Exports:%>%as_duckdb_tibbleas_duckplyr_dfas_duckplyr_tibblecompute_csvcompute_parquetdb_execdf_from_csvdf_from_filedf_from_parquetdf_to_parquetduckdb_tibbleduckplyr_df_from_csvduckplyr_df_from_fileduckplyr_df_from_parquetduckplyr_executefallback_configfallback_purgefallback_reviewfallback_sitrepfallback_uploadflights_dfis_duckdb_tibbleis_duckplyr_dflast_relmethods_overwritemethods_restorenew_relationalnew_relexprread_csv_duckdbread_file_duckdbread_json_duckdbread_parquet_duckdbread_sql_duckdbrel_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 |
| Force conversion to a data frame | collect.duckplyr_df |
| Compute results to a file | compute_csv compute_file compute_parquet |
| Compute results | compute.duckplyr_df |
| Configuration options | config |
| Count the observations in each group | count.duckplyr_df |
| Execute a statement for the default connection | db_exec |
| Keep distinct/unique rows | distinct.duckplyr_df |
| duckplyr data frames | as_duckdb_tibble duckdb_tibble is_duckdb_tibble |
| Explain details of a tbl | explain.duckplyr_df |
| Fallback to dplyr | fallback fallback_config 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 | 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 |
| Extract a single column | pull.duckplyr_df |
| Read Parquet, CSV, and other files using DuckDB | read_csv_duckdb read_file_duckdb read_json_duckdb read_parquet_duckdb |
| Return SQL query as duckdb_tibble | read_sql_duckdb |
| 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 difference | 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 |
| Union | union.duckplyr_df |
| Verbs not implemented in duckplyr | unsupported |
