Data types | Verbs | Functions within verbs | Parentheses | Comparison operators | Basic arithmetics | Math functions | Logical operators | Branching and conversion | String manipulation | Date manipulation | Aggregation | Shifting | Ranking | Special cases | Contributing | Known incompatibilities | Output order stability | sum() | Empty vectors in aggregate functions | min() and max() for logical input | n_distinct() and multiple arguments | is.na() and NaN values | Row names | Other differences
This package is considered a duplicate. The official version of this package is found at:https://tidyverse.r-universe.dev/duckplyr
Package: duckplyr 1.2.1.9901
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_1.2.1.9901.tar.gz
duckplyr_1.2.1.9901.zip(r-4.7)duckplyr_1.2.1.9901.zip(r-4.6)duckplyr_1.2.1.9901.zip(r-4.5)
duckplyr_1.2.1.9901.tgz(r-4.6-any)duckplyr_1.2.1.9901.tgz(r-4.5-any)
duckplyr_1.2.1.9901.tar.gz(r-4.7-any)duckplyr_1.2.1.9901.tar.gz(r-4.6-any)
duckplyr_1.2.1.9901.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
duckplyr/json (API)
| # Install 'duckplyr' in R: |
| install.packages('duckplyr', repos = c('https://cynkra.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/tidyverse/duckplyr/issues
Pkgdown/docs site:https://duckplyr.tidyverse.org
analyticsdataframedplyrduckdbperformance
Last updated from:2a89e3d23e. Checks:9 OK. Indexed: no.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 244 | ||
| source / vignettes | OK | 211 | ||
| linux-release-x86_64 | OK | 258 | ||
| macos-release-arm64 | OK | 169 | ||
| macos-oldrel-arm64 | OK | 190 | ||
| windows-devel | OK | 261 | ||
| windows-release | OK | 240 | ||
| windows-oldrel | OK | 289 | ||
| wasm-release | OK | 120 |
Exports:%>%as_duckdb_tibbleas_duckplyr_dfas_duckplyr_tibbleas_tblcompute_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_duckdbread_tbl_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
Translations
Last update: 2025-11-26
Started: 2024-12-14
Memory protection: controlling automatic materialization
Introduction | Eager and lazy computation | Example | Comparison | Prudence | Concept | Enforcing DuckDB operation | From stingy to lavish | Thrift | File ingestion and custom limits | Conclusion
Last update: 2025-09-16
Started: 2025-02-01
Interoperability with DuckDB and dbplyr
Introduction | From duckplyr to dbplyr | Call arbitrary functions in duckplyr | Conclusion
Last update: 2025-04-17
Started: 2025-04-11
Large data
Introduction | To duckplyr | From files | From DuckDB | Materialization | To files | Memory usage | The big picture
Last update: 2025-04-11
Started: 2025-01-27
Fallback to dplyr
Introduction | DuckDB mode | Relation objects | Help from dplyr | Enforce DuckDB operation | Configure fallbacks | Conclusion
Last update: 2025-04-11
Started: 2025-02-01
Selective use of duckplyr
Introduction | External data with explicit qualification | Restoring dplyr methods | Own data | In other packages
Last update: 2025-04-11
Started: 2024-12-14
Telemetry
Last update: 2025-02-07
Started: 2025-01-27
Implementer's interface
Last update: 2025-01-27
Started: 2025-01-27
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Anti join | anti_join.duckplyr_df |
| Order rows using column values | arrange.duckplyr_df |
| Convert a duckplyr frame to a dbplyr table | as_tbl |
| Force conversion to a data frame | collect.duckplyr_df |
| Compute results to a CSV file | compute_csv compute_csv.data.frame compute_csv.duckplyr_df |
| Compute results to a Parquet file | compute_parquet compute_parquet.data.frame compute_parquet.duckplyr_df |
| 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 filter_out.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 CSV files using DuckDB | read_csv_duckdb |
| Read files using DuckDB | read_file_duckdb |
| Read JSON files using DuckDB | read_json_duckdb |
| Read Parquet files using DuckDB | read_parquet_duckdb |
| Return SQL query as duckdb_tibble | read_sql_duckdb |
| Read a table from a DuckDB database file | read_tbl_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 |
| Subset rows using their positions | slice_head.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 |
