{ "_id": "6a141bc1acfb0bcc41d3d6d3", "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-05-25 09:48:00 UTC", "User": "root" }, "Author": "Alexis Sarda-Espinosa [cre, aut]", "Maintainer": "Alexis Sarda-Espinosa ", "MD5sum": "6a1fa75f23d79828ad1066804964b3c5", "_user": "asardaes", "_type": "src", "_file": "table.express_0.4.2.tar.gz", "_fileid": "e14c4f590a5865fb1f203cb9d3c63c00d8ed656b3c8ee5ffde13b9b2a196fd54", "_filesize": 270761, "_sha256": "e14c4f590a5865fb1f203cb9d3c63c00d8ed656b3c8ee5ffde13b9b2a196fd54", "_created": "2026-05-25T09:48:00.000Z", "_published": "2026-05-25T09:52:01.555Z", "_distro": "noble", "_jobs": [ { "job": 77691171147, "time": 135, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7195836068" }, { "job": 77691171151, "time": 134, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7195835909" }, { "job": 77691171121, "time": 179, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7195840125" }, { "job": 77691171128, "time": 200, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7195841973" }, { "job": 77690828730, "time": 158, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7195800328" }, { "job": 77691171115, "time": 94, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7195825437" }, { "job": 77691171165, "time": 100, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7195827977" }, { "job": 77691171150, "time": 93, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7195825424" }, { "job": 77691171174, "time": 93, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7195825389" } ], "_buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462", "_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", "description": "", "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": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 66, "_contributors": [ { "user": "asardaes", "count": 338, "uuid": 7768461 } ], "_userbio": { "uuid": 7768461, "type": "user", "name": "Alexis Sardá" }, "_downloads": { "count": 254, "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": true, "_nocasepkg": "table.express", "_universes": [ "asardaes" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.2", "date": "2026-05-25T09:50:05.000Z", "distro": "noble", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "5a6e33ed7f85e19e7f6675a2e99c85f0aad8744b0fcabee34493acc49e024d66", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.6.0", "os": "linux", "version": "0.4.2", "date": "2026-05-25T09:50:04.000Z", "distro": "noble", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "e772466ddf68c428344091d93d472f48240a09520b396f5407b14c3558a601c4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.5.3", "os": "mac", "version": "0.4.2", "date": "2026-05-25T09:50:27.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "951986cecf5610d6e391a96e7e8f1c967d657269af8512939468bba656fff928", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.6.0", "os": "mac", "version": "0.4.2", "date": "2026-05-25T09:50:31.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "124dacf48d02c059755e48b8f95cf48759373b1e471a6e0f734eab1abddd4b3b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.2", "date": "2026-05-25T09:49:51.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "0193d7a375293d66046e53a2009ccdc71a72a06a088b324311b98b0bceea2ad1", "status": "success", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.7.0", "os": "win", "version": "0.4.2", "date": "2026-05-25T09:49:23.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "ef03b3d3f4ac9dd932ed04dc8f4e3566927a30db0f75db22407a4911f2cfa82e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.5.3", "os": "win", "version": "0.4.2", "date": "2026-05-25T09:49:15.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "f2f2fb88363497d66ff462d3d834e7747afba4da7b1d052fea7c6502efbf5255", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" }, { "r": "4.6.0", "os": "win", "version": "0.4.2", "date": "2026-05-25T09:49:16.000Z", "commit": "e7864291f91fa68abbf7c82396d275122453106d", "fileid": "bec0482be01c2959ff7d31feb959b911a8332f9788c0f0f4b97a4576a9b2926e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/asardaes/actions/runs/26394181462" } ] }