{ "_id": "6a108b71acfb0bcc41cb329c", "Package": "table.express", "Type": "Package", "Title": "Build 'data.table' Expressions with Data Manipulation Verbs", "Description": "A specialization of 'dplyr' data manipulation verbs that\nparse and build expressions which are ultimately evaluated by\n'data.table', letting it handle all optimizations. A set of\nadditional verbs is also provided to facilitate some common\noperations on a subset of the data.", "Version": "0.4.2", "Date": "2023-04-02", "Authors@R": "c(\nperson(\"Alexis\", \"Sarda-Espinosa\", role=c(\"cre\", \"aut\"), email=\"alexis.sarda@gmail.com\")\n)", "BugReports": "https://github.com/asardaes/table.express/issues", "License": "MPL-2.0", "URL": "https://asardaes.github.io/table.express/,\nhttps://github.com/asardaes/table.express", "Language": "en-US", "Encoding": "UTF-8", "RoxygenNote": "7.2.3", "Roxygen": "list(markdown = TRUE)", "VignetteBuilder": "knitr", "Collate": "'DELIMITERS-chain.R' 'DELIMITERS-end_expr.R'\n'DELIMITERS-start_expr.R' 'R6-ExprBuilder.R'\n'R6-EagerExprBuilder.R' 'UTILS-frame_append.R' 'UTILS-joins.R'\n'UTILS-misc.R' 'UTILS-nest_expr.R' 'UTILS-tidyselect.R'\n'VERBS-anti_join.R' 'VERBS-arrange.R' 'VERBS-distinct.R'\n'VERBS-filter.R' 'VERBS-filter_on.R' 'VERBS-filter_sd.R'\n'VERBS-full_join.R' 'VERBS-group_by.R' 'VERBS-inner_join.R'\n'VERBS-key_by.R' 'VERBS-left_join.R' 'VERBS-max_by.R'\n'VERBS-min_by.R' 'pkg.R' 'VERBS-mutate.R' 'VERBS-mutate_join.R'\n'VERBS-mutate_sd.R' 'VERBS-order_by.R' 'VERBS-right_join.R'\n'VERBS-select.R' 'VERBS-semi_join.R' 'VERBS-summarize.R'\n'VERBS-transmute.R' 'VERBS-transmute_sd.R' 'VERBS-where.R'", "Repository": "https://fastverse.r-universe.dev", "Date/Publication": "2023-04-02 21:59:41 UTC", "RemoteUrl": "https://github.com/asardaes/table.express", "RemoteRef": "HEAD", "RemoteSha": "e7864291f91fa68abbf7c82396d275122453106d", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-05 06:26:44 UTC", "User": "root" }, "Author": "Alexis Sarda-Espinosa [cre, aut]", "Maintainer": "Alexis Sarda-Espinosa ", "MD5sum": "8065b6063f215dd3c0097aef6e8491c4", "_user": "fastverse", "_type": "src", "_file": "table.express_0.4.2.tar.gz", "_fileid": "04572b9666fe03400e635bd1059d180d0bd6c2b5f736ffe87c8e105aac794f65", "_filesize": 272145, "_sha256": "04572b9666fe03400e635bd1059d180d0bd6c2b5f736ffe87c8e105aac794f65", "_created": "2026-05-05T06:26:44.000Z", "_published": "2026-05-22T16:59:29.464Z", "_distro": "noble", "_jobs": [ { "job": 77425709451, "time": 136, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6800009783" }, { "job": 77425709385, "time": 128, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6800007321" }, { "job": 77425709352, "time": 82, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6799998015" }, { "job": 77425709470, "time": 108, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6800002984" }, { "job": 77425709258, "time": 181, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6799981837" }, { "job": 77425708750, "time": 102, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7166034154" }, { "job": 77425709366, "time": 89, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6799999481" }, { "job": 77425709553, "time": 144, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6800010411" }, { "job": 77425709635, "time": 111, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6800003857" } ], "_buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/asardaes/table.express", "_commit": { "id": "e7864291f91fa68abbf7c82396d275122453106d", "author": "asardaes ", "committer": "asardaes ", "message": "Bump version\n", "time": 1680472781 }, "_maintainer": { "name": "Alexis Sarda-Espinosa", "email": "alexis.sarda@gmail.com", "login": "asardaes", "uuid": 7768461 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.2.0", "role": "Depends" }, { "package": "methods", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "data.table", "version": ">= 1.9.8", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "rlang", "version": ">= 0.3.1", "role": "Imports" }, { "package": "tidyselect", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rex", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "asardaes", "_selfowned": false, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 66, "_contributors": [ { "user": "asardaes", "count": 338, "uuid": 7768461 } ], "_userbio": { "uuid": 105517888, "type": "organization", "name": "fastverse", "description": "An Extensible Suite of High-Performance and Low-Dependency Packages for Statistical Computing and Data Manipulation in R" }, "_downloads": { "count": 279, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/table.express" }, "_devurl": "https://github.com/asardaes/table.express", "_pkgdown": "https://asardaes.github.io/table.express/", "_searchresults": 8, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/readme.html", "extra/readme.md", "extra/table.express.html", "manual.pdf" ], "_homeurl": "https://github.com/asardaes/table.express", "_realowner": "asardaes", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2019-05-31" }, { "version": "0.1.1", "date": "2019-06-04" }, { "version": "0.2.0", "date": "2019-07-05" }, { "version": "0.3.0", "date": "2019-08-02" }, { "version": "0.3.1", "date": "2019-09-07" }, { "version": "0.3.2", "date": "2021-12-01" }, { "version": "0.3.3", "date": "2021-12-08" }, { "version": "0.4.0", "date": "2022-04-02" }, { "version": "0.4.1", "date": "2022-08-24" }, { "version": "0.4.2", "date": "2023-04-03" } ], "_exports": [ ":=", "!!", "!!!", "%>%", "%T>%", "anti_join", "arrange", "chain", "contains", "distinct", "EagerExprBuilder", "end_expr", "ends_with", "everything", "ExprBuilder", "filter", "filter_on", "filter_sd", "frame_append", "full_join", "group_by", "inner_join", "key_by", "last_col", "left_join", "matches", "max_by", "min_by", "mutate", "mutate_join", "mutate_sd", "nest_expr", "num_range", "one_of", "order_by", "right_join", "select", "semi_join", "start_expr", "starts_with", "summarise", "summarize", "transmute", "transmute_sd", "where" ], "_help": [ { "page": "table.express-package", "title": "Building 'data.table' expressions with data manipulation verbs", "topics": [ "table.express-package", "table.express" ] }, { "page": "arrange-table.express", "title": "Arrange rows", "topics": [ "arrange-table.express", "arrange.data.table", "arrange.ExprBuilder" ] }, { "page": "chain", "title": "Chain", "topics": [ "chain", "chain.ExprBuilder" ] }, { "page": "distinct-table.express", "title": "Rows with distinct combinations of columns", "topics": [ "distinct-table.express", "distinct.data.table", "distinct.ExprBuilder" ] }, { "page": "EagerExprBuilder", "title": "Eager frame expression builder", "topics": [ "EagerExprBuilder" ] }, { "page": "end_expr", "title": "End and evaluate expression", "topics": [ "end_expr", "end_expr.ExprBuilder" ] }, { "page": "ExprBuilder", "title": "Frame expression builder", "topics": [ "ExprBuilder" ] }, { "page": "extrema_by", "title": "Find rows with extrema in specific columns", "topics": [ "extrema_by", "max_by", "max_by.data.table", "max_by.ExprBuilder", "min_by", "min_by.data.table", "min_by.ExprBuilder" ] }, { "page": "filter_on", "title": "Filter with secondary indices", "topics": [ "filter_on", "filter_on.data.table", "filter_on.ExprBuilder" ] }, { "page": "filter_sd", "title": "Filter subset of data", "topics": [ "filter_sd", "filter_sd.data.table", "filter_sd.ExprBuilder" ] }, { "page": "filter-table.express", "title": "Filter rows", "topics": [ "filter-table.express", "filter.data.table", "filter.ExprBuilder" ] }, { "page": "frame_append", "title": "Append expressions to the frame", "topics": [ "frame_append" ] }, { "page": "group_by-table.express", "title": "Grouping clauses", "topics": [ "group_by-table.express", "group_by.data.table", "group_by.ExprBuilder" ] }, { "page": "joins", "title": "Joining verbs", "topics": [ "anti_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" ] }, { "page": "key_by", "title": "Set key to group by", "topics": [ "key_by", "key_by.data.table", "key_by.ExprBuilder" ] }, { "page": "mutate_sd", "title": "Mutate subset of data", "topics": [ "mutate_sd", "mutate_sd.data.table", "mutate_sd.EagerExprBuilder", "mutate_sd.ExprBuilder" ] }, { "page": "mutate-table.express", "title": "Add or update columns", "topics": [ "mutate-table.express", "mutate.data.table", "mutate.EagerExprBuilder", "mutate.ExprBuilder" ] }, { "page": "nest_expr", "title": "Nest expressions as a functional chain", "topics": [ "nest_expr" ] }, { "page": "order_by-table.express", "title": "Order by clause", "topics": [ "order_by", "order_by-table.express", "order_by.data.table", "order_by.ExprBuilder" ] }, { "page": "select-table.express", "title": "Select clause", "topics": [ "select-table.express", "select.data.table", "select.EagerExprBuilder", "select.ExprBuilder" ] }, { "page": "start_expr", "title": "Start expression", "topics": [ "start_expr", "start_expr.data.table" ] }, { "page": "summarize-table.express", "title": "Summarize columns", "topics": [ "summarise.data.table", "summarise.EagerExprBuilder", "summarise.ExprBuilder", "summarize-table.express", "summarize.data.table", "summarize.EagerExprBuilder", "summarize.ExprBuilder" ] }, { "page": "transmute_sd", "title": "Transmute subset of data", "topics": [ "transmute_sd", "transmute_sd.data.table", "transmute_sd.EagerExprBuilder", "transmute_sd.ExprBuilder" ] }, { "page": "transmute-table.express", "title": "Compute new columns", "topics": [ "transmute-table.express", "transmute.data.table", "transmute.EagerExprBuilder", "transmute.ExprBuilder" ] }, { "page": "where-table.express", "title": "Where clause", "topics": [ "where", "where-table.express", "where.data.table", "where.ExprBuilder" ] } ], "_readme": "https://github.com/asardaes/table.express/raw/HEAD/README.md", "_rundeps": [ "cli", "data.table", "dplyr", "generics", "glue", "lifecycle", "magrittr", "pillar", "pkgconfig", "R6", "rlang", "tibble", "tidyselect", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "joins.Rmd", "filename": "joins.html", "title": "Joining verbs for data.table", "engine": "knitr::rmarkdown_notangle", "headings": [ "Basic joins", "Expression chaining", "Mutating join", "Rolling joins", "Non-equi joins", "Self joins" ], "created": "2019-06-20 22:15:17", "modified": "2021-11-30 20:08:57", "commits": 12 }, { "source": "table.express.Rmd", "filename": "table.express.html", "title": "Using table.express", "engine": "knitr::rmarkdown_notangle", "headings": [ "Preliminaries", "Expression delimiters", "Arranging rows", "Selecting columns", "Transmuting columns", "Summarizing columns", "Mutating columns", "Filtering rows", "Using keys or secondary indices", "Modifying subset of data", "Data manipulation by group", "Distinct combinations of columns", "Lazy considerations", "Nesting expressions", "Automatic expression chaining", "Explicit chaining", "Eager verbs", "As simple as possible" ], "created": "2019-05-12 19:55:42", "modified": "2022-08-24 21:46:57", "commits": 44 } ], "_score": 5.819543935541869, "_indexed": false, "_nocasepkg": "table.express", "_universes": [ "fastverse" ], "_indexurl": "https://asardaes.r-universe.dev/table.express", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.2", "date": "2026-05-05T06:28:59.000Z", "distro": "noble", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "61f4bc58616975b263cc6fbe59f00318a8512331709a20afc150e35f54c7cd70", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.6.0", "os": "linux", "version": "0.4.2", "date": "2026-05-05T06:28:47.000Z", "distro": "noble", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "49e635352c4962c7d73cbb61ab6bffb9bbaba8b7bdc9b83131b747284d404ff3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.5.3", "os": "mac", "version": "0.4.2", "date": "2026-05-05T06:28:11.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "bcf65b25dec5c1397375b89b785af6cd9d268a10aee9ff5e0e834a70b271a83b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.6.0", "os": "mac", "version": "0.4.2", "date": "2026-05-05T06:28:29.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "d16c37f933a565d8d51ada07a508b4efcabfc209735d15afc1f80141454c6696", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.7.0", "os": "win", "version": "0.4.2", "date": "2026-05-05T06:28:01.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "4fd02e84fa608ca67353c4137e230749ba931b94a91a3a0301503db4e7c5c185", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.5.3", "os": "win", "version": "0.4.2", "date": "2026-05-05T06:28:54.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "a7da83213f76fa006bf0a3bc77b9dd1a7fdbf251921e1061d37757b496b680b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.6.0", "os": "win", "version": "0.4.2", "date": "2026-05-05T06:28:22.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "a18f21500bcddbe9558ef0abf805549ab3755fa8ff8965f8364f14a44c5cacdd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.2", "date": "2026-05-22T16:59:14.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "a7795e3f1528bf4b2bcc8974f54d3dd73ea850bbac75937dcf4c0aa69e1a6ea9", "status": "success", "buildurl": "https://github.com/r-universe/fastverse/actions/runs/25361204436" } ] }