{ "_id": "6ac0af1491601a2ad29974cc", "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://asardaes.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-10-03 07:25:59 UTC", "User": "root" }, "Author": "Alexis Sarda-Espinosa [cre, aut]", "Maintainer": "Alexis Sarda-Espinosa ", "_user": "asardaes", "_type": "src", "_file": "table.express_0.4.2.tar.gz", "_fileid": "https://r2.ropensci.org/1455436863d8f1acf7f3e60b72fa1554a1cb766da500dda0dfec382479fd0a7b", "_filesize": 271970, "_sha256": "1455436863d8f1acf7f3e60b72fa1554a1cb766da500dda0dfec382479fd0a7b", "_expires": "2027-01-11T07:30:22.000Z", "_created": "2026-10-03T07:25:59.000Z", "_published": "2026-10-03T07:30:28.692Z", "_jobs": [ { "job": 111155513151, "time": 121, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11267784419" }, { "job": 111155513203, "time": 114, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11267604598" }, { "job": 111155513213, "time": 216, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11267233311" }, { "job": 111155513177, "time": 158, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11267369842" }, { "job": 111155036049, "time": 178, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11268133818" }, { "job": 111155513118, "time": 101, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11267784444" }, { "job": 111155513188, "time": 84, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11267379747" }, { "job": 111155513179, "time": 78, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11268064012" }, { "job": 111155513194, "time": 86, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11267409890" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892", "_status": "success", "_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", "description": "", "uuid": 7768461 }, "_distro": "resolute", "_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": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 66, "_contributors": [ { "user": "asardaes", "count": 338, "uuid": 7768461 } ], "_userbio": { "uuid": 7768461, "type": "user", "name": "Alexis Sardá", "followers": 51 }, "_downloads": { "count": 341, "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": 10, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/readme.html", "extra/readme.md", "extra/table.express.html" ], "_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": true, "_nocasepkg": "table.express", "_universes": [ "asardaes" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.2", "date": "2026-10-03T07:27:48.000Z", "distro": "resolute", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/3e364c307b5fd51777d11c9036bdf0dd6155d4afc255fb282079b6bb4d62ae2f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.6.1", "os": "linux", "version": "0.4.2", "date": "2026-10-03T07:27:44.000Z", "distro": "resolute", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/e82d9ea46db07f3679faa61dc9687d91aff2fda1b63e9f254f309d9b63da29ba", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.5.3", "os": "mac", "version": "0.4.2", "date": "2026-10-03T07:28:56.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/fa5fb577eacaf92a1fbfaaea122325e6f49e9b3d80e9825d1d712ab77263d87b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.6.1", "os": "mac", "version": "0.4.2", "date": "2026-10-03T07:28:10.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/d33434e799335153b65d8ea8f7ed60afad555b956bc955582b138830f9459cfb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.2", "date": "2026-10-03T07:28:32.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/294c1fcf8bfea22c827fcce9ce24548689cc350b20c87de3aae5f17103017315", "status": "success", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.7.0", "os": "win", "version": "0.4.2", "date": "2026-10-03T07:27:04.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/e8a47a15754fc462b2defa8ba56900a757dd555467611ee56bbeb08c1940ef7a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.5.3", "os": "win", "version": "0.4.2", "date": "2026-10-03T07:26:59.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/a4acaa2ffda7012bbe2d4f55602605b27e3b931d195c0a02f1f3f3958f0cafb5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" }, { "r": "4.6.1", "os": "win", "version": "0.4.2", "date": "2026-10-03T07:27:07.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "https://r2.ropensci.org/6a99e86226615954a0c244277fd549a0119922652bb83fa2cf132fef0e13b124", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/37106158892" } ] }