Package: rqdatatable 1.3.3

John Mount

rqdatatable: 'rquery' for 'data.table'

Implements the 'rquery' piped Codd-style query algebra using 'data.table'. This allows for a high-speed in memory implementation of Codd-style data manipulation tools.

Authors:John Mount [aut, cre], Win-Vector LLC [cph]

rqdatatable_1.3.3.tar.gz
rqdatatable_1.3.3.zip(r-4.5)rqdatatable_1.3.3.zip(r-4.4)rqdatatable_1.3.3.zip(r-4.3)
rqdatatable_1.3.3.tgz(r-4.4-any)rqdatatable_1.3.3.tgz(r-4.3-any)
rqdatatable_1.3.3.tar.gz(r-4.5-noble)rqdatatable_1.3.3.tar.gz(r-4.4-noble)
rqdatatable_1.3.3.tgz(r-4.4-emscripten)rqdatatable_1.3.3.tgz(r-4.3-emscripten)
rqdatatable.pdf |rqdatatable.html✨
rqdatatable/json (API)
NEWS

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

Peer review:

Bug tracker:https://github.com/winvector/rqdatatable/issues

On CRAN:

11 exports 37 stars 2.90 score 3 dependencies 2 dependents 128 scripts 1.5k downloads

Last updated 1 years agofrom:66838f888a. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKSep 13 2024
R-4.5-winOKSep 13 2024
R-4.5-linuxOKSep 13 2024
R-4.4-winOKSep 13 2024
R-4.4-macOKSep 13 2024
R-4.3-winOKSep 13 2024
R-4.3-macOKSep 13 2024

Exports:as.data.tableex_data_tableex_data_table_parallelex_data_table_steplayout_to_blocks_data_tablelayout_to_rowrecs_data_tablemake_dt_lookup_by_columnrbindlist_data_tablerq_df_funciton_noderq_df_grouped_funciton_nodeset_rqdatatable_as_executor

Dependencies:data.tablerquerywrapr

Grouped Sampling

John Mount

Rendered fromGroupedSampling.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2018-06-14
Started: 2018-06-14

Logistic Example

John Mount

Rendered fromlogisticexample.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2022-01-22
Started: 2018-05-30

R mapping

John Mount

Rendered fromR_mapping.Rmdusingknitr::rmarkdownon Sep 13 2024.

Last update: 2019-06-23
Started: 2019-06-22

Readme and manuals

Help Manual

Help pageTopics
'rqdatatable': Relational Query Generator for Data Manipulation Implemented by data.tablerqdatatable-package rqdatatable
Execute an 'rquery' pipeline with 'data.table' sources.ex_data_table
Execute an 'rquery' pipeline with 'data.table' in parallel.ex_data_table_parallel
default non-impementation.ex_data_table_step.default
Implement drop columns.ex_data_table_step.relop_drop_columns
Implement extend/assign operator.ex_data_table_step.relop_extend
Natural join.ex_data_table_step.relop_natural_join
Direct non-sql (function) node, not implemented for 'data.table' case.ex_data_table_step.relop_non_sql
Replace NAs.ex_data_table_step.relop_null_replace
Order rows by expression.ex_data_table_step.relop_order_expr
Reorder rows.ex_data_table_step.relop_orderby
Implement projection operator.ex_data_table_step.relop_project
Rename columns.ex_data_table_step.relop_rename_columns
Implement drop columns.ex_data_table_step.relop_select_columns
Select rows by condition.ex_data_table_step.relop_select_rows
Implement set_indicatoroperator.ex_data_table_step.relop_set_indicator
Direct sql node.ex_data_table_step.relop_sql
Build a data source description.ex_data_table_step.relop_table_source
Theta join (database implementation).ex_data_table_step.relop_theta_join
Bind tables together by rows.ex_data_table_step.relop_unionall
Lookup by column function factory.make_dt_lookup_by_column
Helper to build data.table capable non-sql nodes.rq_df_funciton_node
Helper to build data.table capable non-sql nodes.rq_df_grouped_funciton_node
Set rqdatatable package as default rquery executorset_rqdatatable_as_executor