Package: table.express 0.4.2

table.express: Build 'data.table' Expressions with Data Manipulation Verbs

A specialization of 'dplyr' data manipulation verbs that parse and build expressions which are ultimately evaluated by 'data.table', letting it handle all optimizations. A set of additional verbs is also provided to facilitate some common operations on a subset of the data.

Authors:Alexis Sarda-Espinosa [cre, aut]

table.express_0.4.2.tar.gz
table.express_0.4.2.zip(r-4.5)table.express_0.4.2.zip(r-4.4)table.express_0.4.2.zip(r-4.3)
table.express_0.4.2.tgz(r-4.4-any)table.express_0.4.2.tgz(r-4.3-any)
table.express_0.4.2.tar.gz(r-4.5-noble)table.express_0.4.2.tar.gz(r-4.4-noble)
table.express_0.4.2.tgz(r-4.4-emscripten)table.express_0.4.2.tgz(r-4.3-emscripten)
table.express.pdf |table.express.html✨
table.express/json (API)

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

Peer review:

Bug tracker:https://github.com/asardaes/table.express/issues

On CRAN:

5.81 score 65 stars 8 scripts 390 downloads 45 exports 17 dependencies

Last updated 2 years agofrom:e7864291f9. Checks:OK: 7. Indexed: yes.

TargetResultDate
Doc / VignettesOKNov 02 2024
R-4.5-winOKNov 02 2024
R-4.5-linuxOKNov 02 2024
R-4.4-winOKNov 02 2024
R-4.4-macOKNov 02 2024
R-4.3-winOKNov 02 2024
R-4.3-macOKNov 02 2024

Exports::=!!!!!%>%%T>%anti_joinarrangechaincontainsdistinctEagerExprBuilderend_exprends_witheverythingExprBuilderfilterfilter_onfilter_sdframe_appendfull_joingroup_byinner_joinkey_bylast_colleft_joinmatchesmax_bymin_bymutatemutate_joinmutate_sdnest_exprnum_rangeone_oforder_byright_joinselectsemi_joinstart_exprstarts_withsummarisesummarizetransmutetransmute_sdwhere

Dependencies:clidata.tabledplyrfansigenericsgluelifecyclemagrittrpillarpkgconfigR6rlangtibbletidyselectutf8vctrswithr

Joining verbs for data.table

Rendered fromjoins.Rmdusingknitr::rmarkdown_notangleon Nov 02 2024.

Last update: 2021-11-30
Started: 2019-06-20

Using table.express

Rendered fromtable.express.Rmdusingknitr::rmarkdown_notangleon Nov 02 2024.

Last update: 2022-08-24
Started: 2019-05-12

Readme and manuals

Help Manual

Help pageTopics
Building 'data.table' expressions with data manipulation verbstable.express-package table.express
Arrange rowsarrange-table.express arrange.data.table arrange.ExprBuilder
Chainchain chain.ExprBuilder
Rows with distinct combinations of columnsdistinct-table.express distinct.data.table distinct.ExprBuilder
Eager frame expression builderEagerExprBuilder
End and evaluate expressionend_expr end_expr.ExprBuilder
Frame expression builderExprBuilder
Find rows with extrema in specific columnsextrema_by max_by max_by.data.table max_by.ExprBuilder min_by min_by.data.table min_by.ExprBuilder
Filter with secondary indicesfilter_on filter_on.data.table filter_on.ExprBuilder
Filter subset of datafilter_sd filter_sd.data.table filter_sd.ExprBuilder
Filter rowsfilter-table.express filter.data.table filter.ExprBuilder
Append expressions to the frameframe_append
Grouping clausesgroup_by-table.express group_by.data.table group_by.ExprBuilder
Joining verbsanti_join.data.table anti_join.ExprBuilder full_join.data.table full_join.ExprBuilder inner_join.data.table inner_join.ExprBuilder joins left_join.data.table left_join.ExprBuilder mutate_join mutate_join.data.table mutate_join.EagerExprBuilder mutate_join.ExprBuilder right_join.data.table right_join.ExprBuilder semi_join.data.table semi_join.ExprBuilder
Set key to group bykey_by key_by.data.table key_by.ExprBuilder
Mutate subset of datamutate_sd mutate_sd.data.table mutate_sd.EagerExprBuilder mutate_sd.ExprBuilder
Add or update columnsmutate-table.express mutate.data.table mutate.EagerExprBuilder mutate.ExprBuilder
Nest expressions as a functional chainnest_expr
Order by clauseorder_by order_by-table.express order_by.data.table order_by.ExprBuilder
Select clauseselect-table.express select.data.table select.EagerExprBuilder select.ExprBuilder
Start expressionstart_expr start_expr.data.table
Summarize columnssummarise.data.table summarise.EagerExprBuilder summarise.ExprBuilder summarize-table.express summarize.data.table summarize.EagerExprBuilder summarize.ExprBuilder
Transmute subset of datatransmute_sd transmute_sd.data.table transmute_sd.EagerExprBuilder transmute_sd.ExprBuilder
Compute new columnstransmute-table.express transmute.data.table transmute.EagerExprBuilder transmute.ExprBuilder
Where clausewhere where-table.express where.data.table where.ExprBuilder