{ "_id": "6ab3c22d3d719c1f84093894", "Package": "basetable", "Title": "Fast and Memory-Efficient Base R Table Manipulation", "Version": "1.4.2", "Authors@R": "person(\"Imad\", \"El Badisy\", email = \"elbadisyimad@gmail.com\", role = c(\"aut\", \"cre\"))", "Description": "A tabular data manipulation, exploration and validation\ntoolkit with a base R-style interface (subset, transform,\naggregate, merge, split) and no external computation\ndependency. Grouping, joins, ordering, filtering, reshaping and\ndelimited-file reading run in a bundled 'C++' engine that uses\nmultiple threads for the heavier operations. Grouped reducers\naccumulate in compiled code without materialising intermediate\ncolumns, so grouped aggregation and counting allocate close to\nnothing. Results are returned as an ordinary data frame with a\nlight 'basetable' class.", "License": "MIT + file LICENSE", "URL": "https://github.com/ielbadisy/basetable", "BugReports": "https://github.com/ielbadisy/basetable/issues", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "SystemRequirements": "C++17", "Repository": "https://ielbadisy.r-universe.dev", "Date/Publication": "2026-09-23 09:51:58 UTC", "RemoteUrl": "https://github.com/ielbadisy/basetable", "RemoteRef": "HEAD", "RemoteSha": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-09-23 12:01:13 UTC", "User": "root" }, "Author": "Imad El Badisy [aut, cre]", "Maintainer": "Imad El Badisy ", "_user": "ielbadisy", "_type": "src", "_file": "basetable_1.4.2.tar.gz", "_fileid": "https://r2.ropensci.org/7289901174eefed14057d76258a6cd6afc8dcd73827aaf8b9f015d9c89cf34c5", "_filesize": 1229815, "_sha256": "7289901174eefed14057d76258a6cd6afc8dcd73827aaf8b9f015d9c89cf34c5", "_expires": "2027-01-01T12:12:27.000Z", "_created": "2026-09-23T12:01:13.000Z", "_published": "2026-09-23T12:12:29.834Z", "_jobs": [ { "job": 107170950555, "time": 139, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "10748446448" }, { "job": 107170950577, "time": 175, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10748606122" }, { "job": 107170950565, "time": 121, "config": "linux-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10748144238" }, { "job": 107170950708, "time": 130, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10748139327" }, { "job": 107170950491, "time": 136, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "10748139939" }, { "job": 107170950497, "time": 274, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10747434851" }, { "job": 107170950608, "time": 106, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10748607538" }, { "job": 107170950739, "time": 357, "config": "macos-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10747779715" }, { "job": 107169767959, "time": 217, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "10747903066" }, { "job": 107170950484, "time": 108, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "10748456303" }, { "job": 107170950603, "time": 283, "config": "windows-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "10748845507" }, { "job": 107170950581, "time": 172, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "10748386801" }, { "job": 107170950636, "time": 136, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "10747394731" }, { "job": 107170950562, "time": 273, "config": "windows-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "10748920867" }, { "job": 107170950610, "time": 137, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "10748626030" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051", "_status": "success", "_upstream": "https://github.com/ielbadisy/basetable", "_commit": { "id": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "author": "Imad EL BADISY ", "committer": "GitHub ", "message": "Merge pull request #128 from ielbadisy/feat/nest-unnest\n\nAdd nest() and unnest() for nested tables", "time": 1790157118 }, "_maintainer": { "name": "Imad El Badisy", "email": "elbadisyimad@gmail.com", "login": "ielbadisy", "description": "PhD, Research Engineer in Biostatistics | Health Data Scientist", "uuid": 52789515 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2.0", "role": "Depends" }, { "package": "parallel", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "bench", "role": "Suggests" }, { "package": "collapse", "role": "Suggests" }, { "package": "data.table", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "scales", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "tidyr", "role": "Suggests" } ], "_owner": "ielbadisy", "_selfowned": true, "_usedby": 5, "_updates": [ { "week": "2026-13", "n": 1 }, { "week": "2026-18", "n": 1 }, { "week": "2026-29", "n": 82 }, { "week": "2026-30", "n": 6 }, { "week": "2026-34", "n": 5 }, { "week": "2026-35", "n": 79 }, { "week": "2026-36", "n": 16 }, { "week": "2026-37", "n": 6 }, { "week": "2026-38", "n": 3 }, { "week": "2026-39", "n": 2 } ], "_tags": [ { "name": "v1.0.0", "date": "2026-08-29" } ], "_topics": [ "base-r", "cpp", "data-frame", "data-manipulation", "data-table", "data-wrangling", "dataframe", "high-performance", "multithreading", "rcpp-alternative", "tabular-data", "cpp" ], "_stars": 2, "_contributors": [ { "user": "ielbadisy", "count": 389, "uuid": 52789515 } ], "_userbio": { "uuid": 52789515, "type": "user", "name": "Imad EL BADISY ", "followers": 17, "description": "PhD, Research Engineer in Biostatistics | Health Data Scientist" }, "_downloads": { "count": 248, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/basetable" }, "_devurl": "https://github.com/ielbadisy/basetable", "_searchresults": 1, "_rbuild": "4.6.1", "_assets": [ "extra/basetable.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/ielbadisy/basetable", "_realowner": "ielbadisy", "_cranurl": true, "_releases": [ { "version": "1.3.2", "date": "2026-09-12" }, { "version": "1.4.1", "date": "2026-09-14" }, { "version": "1.4.2", "date": "2026-09-18" } ], "_exports": [ "adddays", "addedrows", "addmonths", "addweeks", "addyears", "aggregate", "antimerge", "applyby", "applycols", "as_basetable", "assert_cols", "assert_key", "assertcols", "assertcomplete", "assertkey", "assertnames", "assertrange", "assertrows", "asserttype", "assertunique", "assertvalues", "betweendates", "blanktona", "btread", "btwrite", "cardinality", "casewhen", "ceilingdate", "center", "changedcols", "changedrows", "classes", "cleannames", "collapselevels", "collapsetext", "collapsevalues", "colnames", "common_names", "commonnames", "compact", "compare", "compareschema", "completegrid", "constants", "containstext", "convertcols", "count", "countmatch", "crossmerge", "cumavg", "cumcount", "cumedist", "datediff", "dateseq", "day", "denserank", "describe", "difference", "diffrows", "dims", "drop", "duplicated_keys", "duplicatekeys", "duplicatenames", "duplicaterows", "emptycols", "emptyrows", "endswith", "equaldata", "equalrows", "expandlevels", "expandrows", "extract", "extractall", "extractbetween", "extractint", "extractnum", "fillboth", "filldown", "fillup", "firstby", "firstcols", "firstrows", "floordate", "foldr", "freq", "headtail", "hour", "intersectrows", "invalidrows", "invalidvalues", "is_basetable", "isalpha", "isalphanumeric", "isblank", "isemail", "isintegertext", "isnumerictext", "isurl", "joinrelationship", "jointext", "keepmissing", "lagvalue", "lastby", "lastcols", "lastrows", "leadvalue", "left", "locate", "locateall", "lower", "lump", "map", "matchedkeys", "matchestext", "merge", "middle", "minute", "missingindicator", "missingness", "missingrows", "month", "move", "naif", "nato", "natoblank", "ncols", "nearestmerge", "nearesttext", "nest", "nonequimerge", "normalizeencoding", "normalizeunicode", "nrows", "omitmissing", "orderrows", "outofrange", "overlapmerge", "padcenter", "padleft", "padright", "parsecurrency", "parsedate", "parsedatetime", "parsefailures", "parseint", "parselogical", "parsenum", "parsepercent", "percentchange", "percentrank", "pick", "preview", "profile", "propcount", "quantilegroup", "quarter", "rangemerge", "rbindfill", "recode", "removeaccents", "removeall", "removedrows", "removeduplicates", "removetext", "renamecols", "renamewith", "reorderlevels", "repairnames", "replaceall", "replacecols", "replacetext", "replacevalues", "replacewhere", "rescale", "reverse", "right", "rollapply", "rollingmerge", "rollmax", "rollmean", "rollmedian", "rollmin", "rollprod", "rollsd", "rollsum", "rollvar", "rounddate", "rowall", "rowany", "rowapply", "rowcount", "rowfirst", "rowlast", "rowmax", "rowmin", "rownames", "rownumber", "sameschema", "samplefrac", "samplerows", "second", "semimerge", "sentencecase", "separate", "setthreads", "similartext", "split", "splitfirst", "splitlast", "splittext", "squish", "stack", "standardize", "startswith", "subset", "summaries", "summarytab", "textdist", "textlen", "titlecase", "tolong", "towide", "transform", "transliterate", "transpose", "traverse", "trim", "truncate", "types", "unionrows", "uniquerows", "uniques", "unite", "unmatchedkeys", "unnest", "unstack", "updatemerge", "upper", "week", "weekday", "winsorize", "within", "year", "yearday" ], "_help": [ { "page": "basetable-package", "title": "Base-Faithful Tabular Data Tools", "topics": [ "basetable-package", "basetable" ] }, { "page": "adddays", "title": "Add days to a date", "topics": [ "adddays" ] }, { "page": "addedrows", "title": "Rows present in 'new' but not in 'old'", "topics": [ "addedrows" ] }, { "page": "addmonths", "title": "Add months to a date", "topics": [ "addmonths" ] }, { "page": "addweeks", "title": "Add weeks to a date", "topics": [ "addweeks" ] }, { "page": "addyears", "title": "Add years to a date", "topics": [ "addyears" ] }, { "page": "aggregate", "title": "Aggregate values by group", "topics": [ "aggregate" ] }, { "page": "antimerge", "title": "Anti-join two tables", "topics": [ "antimerge" ] }, { "page": "applyby", "title": "Apply a function to each group", "topics": [ "applyby" ] }, { "page": "applycols", "title": "Apply a function to selected columns", "topics": [ "applycols" ] }, { "page": "as_basetable", "title": "Coerce an object to a basetable", "topics": [ "as_basetable", "as_basetable.basetable", "as_basetable.data.frame", "as_basetable.default" ] }, { "page": "assert_cols", "title": "Validation and schema helpers", "topics": [ "assert_cols", "assert_key", "common_names", "duplicated_keys" ] }, { "page": "assertcols", "title": "Assert that columns exist (alias)", "topics": [ "assertcols" ] }, { "page": "assertcomplete", "title": "Assert that there are no missing values", "topics": [ "assertcomplete" ] }, { "page": "assertkey", "title": "Assert that a key is unique (alias)", "topics": [ "assertkey" ] }, { "page": "assertnames", "title": "Assert that required column names are present", "topics": [ "assertnames" ] }, { "page": "assertrange", "title": "Assert that a column falls within a numeric range", "topics": [ "assertrange" ] }, { "page": "assertrows", "title": "Assert that a row-wise condition holds for every row", "topics": [ "assertrows" ] }, { "page": "asserttype", "title": "Assert that a column has an expected class", "topics": [ "asserttype" ] }, { "page": "assertunique", "title": "Assert that selected columns are unique", "topics": [ "assertunique" ] }, { "page": "assertvalues", "title": "Assert that a column only contains allowed values", "topics": [ "assertvalues" ] }, { "page": "betweendates", "title": "Test whether a date falls within a range", "topics": [ "betweendates" ] }, { "page": "blanktona", "title": "Recode blank strings to 'NA'", "topics": [ "blanktona" ] }, { "page": "btread", "title": "Read a delimited text file", "topics": [ "btread" ] }, { "page": "btwrite", "title": "Write a data frame to a delimited text file", "topics": [ "btwrite" ] }, { "page": "cardinality", "title": "Distinct-value count (or proportion) per column", "topics": [ "cardinality" ] }, { "page": "casewhen", "title": "Multi-branch selection by condition", "topics": [ "casewhen" ] }, { "page": "ceilingdate", "title": "Round a date up to a unit", "topics": [ "ceilingdate" ] }, { "page": "center", "title": "Center a vector at its mean", "topics": [ "center" ] }, { "page": "changedcols", "title": "Compare the columns of two tables", "topics": [ "changedcols" ] }, { "page": "changedrows", "title": "Rows whose key appears in both tables", "topics": [ "changedrows" ] }, { "page": "classes", "title": "Column classes", "topics": [ "classes" ] }, { "page": "cleannames", "title": "Clean column names to a unique, syntactic form", "topics": [ "cleannames" ] }, { "page": "collapselevels", "title": "Collapse factor levels into named groups", "topics": [ "collapselevels" ] }, { "page": "collapsetext", "title": "Collapse a vector into a single string", "topics": [ "collapsetext" ] }, { "page": "collapsevalues", "title": "Collapse values into named groups", "topics": [ "collapsevalues" ] }, { "page": "colnames", "title": "Column names", "topics": [ "colnames" ] }, { "page": "commonnames", "title": "Column names shared by two tables", "topics": [ "commonnames" ] }, { "page": "compact", "title": "Drop NULL elements from a list", "topics": [ "compact" ] }, { "page": "compare", "title": "Compare tables", "topics": [ "compare" ] }, { "page": "compareschema", "title": "Compare the schemas of two tables", "topics": [ "compareschema" ] }, { "page": "completegrid", "title": "Complete a table grid", "topics": [ "completegrid" ] }, { "page": "constants", "title": "Columns with a single distinct non-missing value", "topics": [ "constants" ] }, { "page": "containstext", "title": "Test for a pattern match anywhere in the string", "topics": [ "containstext" ] }, { "page": "convertcols", "title": "Convert selected columns with a function", "topics": [ "convertcols" ] }, { "page": "count", "title": "Count rows by group", "topics": [ "count" ] }, { "page": "countmatch", "title": "Count pattern matches per string", "topics": [ "countmatch" ] }, { "page": "crossmerge", "title": "Cartesian join two tables", "topics": [ "crossmerge" ] }, { "page": "cumavg", "title": "Cumulative mean", "topics": [ "cumavg" ] }, { "page": "cumcount", "title": "Cumulative row counter", "topics": [ "cumcount" ] }, { "page": "cumedist", "title": "Cumulative empirical distribution", "topics": [ "cumedist" ] }, { "page": "datediff", "title": "Difference between two dates", "topics": [ "datediff" ] }, { "page": "dateseq", "title": "Sequence of dates", "topics": [ "dateseq" ] }, { "page": "day", "title": "Extract the day of month", "topics": [ "day" ] }, { "page": "denserank", "title": "Dense rank of a vector", "topics": [ "denserank" ] }, { "page": "describe", "title": "Column descriptions", "topics": [ "describe" ] }, { "page": "difference", "title": "Lagged difference", "topics": [ "difference" ] }, { "page": "diffrows", "title": "Set difference of rows", "topics": [ "diffrows" ] }, { "page": "dims", "title": "Table dimensions", "topics": [ "dims" ] }, { "page": "drop", "title": "Drop columns", "topics": [ "drop" ] }, { "page": "duplicatekeys", "title": "Duplicated key combinations", "topics": [ "duplicatekeys" ] }, { "page": "duplicatenames", "title": "Duplicated column names", "topics": [ "duplicatenames" ] }, { "page": "duplicaterows", "title": "Rows involved in a duplicate", "topics": [ "duplicaterows" ] }, { "page": "emptycols", "title": "Columns that are entirely blank or missing", "topics": [ "emptycols" ] }, { "page": "emptyrows", "title": "Rows that are entirely blank or missing", "topics": [ "emptyrows" ] }, { "page": "endswith", "title": "Test whether strings end with a pattern", "topics": [ "endswith" ] }, { "page": "equaldata", "title": "Compare two tables for equality", "topics": [ "equaldata" ] }, { "page": "equalrows", "title": "Compare two tables' rows for equality", "topics": [ "equalrows" ] }, { "page": "expandlevels", "title": "Add levels to a factor", "topics": [ "expandlevels" ] }, { "page": "expandrows", "title": "Repeat rows in a table", "topics": [ "expandrows" ] }, { "page": "extract", "title": "Extract the first pattern match", "topics": [ "extract" ] }, { "page": "extractall", "title": "Extract all pattern matches", "topics": [ "extractall" ] }, { "page": "extractbetween", "title": "Extract text between two markers", "topics": [ "extractbetween" ] }, { "page": "extractint", "title": "Extract an integer value from text", "topics": [ "extractint" ] }, { "page": "extractnum", "title": "Extract a numeric value from text", "topics": [ "extractnum" ] }, { "page": "fillboth", "title": "Fill missing values both forward and backward within groups", "topics": [ "fillboth" ] }, { "page": "filldown", "title": "Fill missing values downward", "topics": [ "filldown" ] }, { "page": "fillup", "title": "Fill missing values upward", "topics": [ "fillup" ] }, { "page": "firstby", "title": "First row within each group", "topics": [ "firstby" ] }, { "page": "firstcols", "title": "Move columns to the front", "topics": [ "firstcols" ] }, { "page": "firstrows", "title": "First 'n' rows", "topics": [ "firstrows" ] }, { "page": "floordate", "title": "Round a date down to a unit", "topics": [ "floordate" ] }, { "page": "foldr", "title": "Fold a vector or list from the right", "topics": [ "foldr" ] }, { "page": "freq", "title": "Frequency table", "topics": [ "freq" ] }, { "page": "headtail", "title": "Head and tail rows", "topics": [ "headtail" ] }, { "page": "hour", "title": "Extract the hour", "topics": [ "hour" ] }, { "page": "intersectrows", "title": "Set intersection of rows", "topics": [ "intersectrows" ] }, { "page": "invalidrows", "title": "Rows that fail a condition", "topics": [ "invalidrows" ] }, { "page": "invalidvalues", "title": "Rows whose value is not in the allowed set", "topics": [ "invalidvalues" ] }, { "page": "is_basetable", "title": "Test whether an object is a basetable", "topics": [ "is_basetable" ] }, { "page": "isalpha", "title": "Test for alphabetic-only strings", "topics": [ "isalpha" ] }, { "page": "isalphanumeric", "title": "Test for alphanumeric-only strings", "topics": [ "isalphanumeric" ] }, { "page": "isblank", "title": "Test for blank (missing or empty) values", "topics": [ "isblank" ] }, { "page": "isemail", "title": "Test whether text looks like an email address", "topics": [ "isemail" ] }, { "page": "isintegertext", "title": "Test whether text looks like an integer", "topics": [ "isintegertext" ] }, { "page": "isnumerictext", "title": "Test whether text looks numeric", "topics": [ "isnumerictext" ] }, { "page": "isurl", "title": "Test whether text looks like a URL", "topics": [ "isurl" ] }, { "page": "joinrelationship", "title": "Cardinality of a join key relationship", "topics": [ "joinrelationship" ] }, { "page": "jointext", "title": "Concatenate values element-wise", "topics": [ "jointext" ] }, { "page": "keepmissing", "title": "Keep rows with missing values", "topics": [ "keepmissing" ] }, { "page": "lagvalue", "title": "Lag a vector", "topics": [ "lagvalue" ] }, { "page": "lastby", "title": "Last row within each group", "topics": [ "lastby" ] }, { "page": "lastcols", "title": "Move columns to the back", "topics": [ "lastcols" ] }, { "page": "lastrows", "title": "Last 'n' rows", "topics": [ "lastrows" ] }, { "page": "leadvalue", "title": "Lead a vector", "topics": [ "leadvalue" ] }, { "page": "left", "title": "First 'n' characters", "topics": [ "left" ] }, { "page": "locate", "title": "Position of the first pattern match", "topics": [ "locate" ] }, { "page": "locateall", "title": "Positions of all pattern matches", "topics": [ "locateall" ] }, { "page": "lower", "title": "Convert to lower case", "topics": [ "lower" ] }, { "page": "lump", "title": "Lump infrequent values into \"Other\"", "topics": [ "lump" ] }, { "page": "map", "title": "Map over vectors and lists", "topics": [ "map" ] }, { "page": "matchedkeys", "title": "Rows of 'x' whose key is present in 'y'", "topics": [ "matchedkeys" ] }, { "page": "matchestext", "title": "Test for a full-string pattern match", "topics": [ "matchestext" ] }, { "page": "merge", "title": "Merge two tables", "topics": [ "merge" ] }, { "page": "middle", "title": "Substring between two positions", "topics": [ "middle" ] }, { "page": "minute", "title": "Extract the minute", "topics": [ "minute" ] }, { "page": "missingindicator", "title": "Add missingness indicators", "topics": [ "missingindicator" ] }, { "page": "missingness", "title": "Summarize missing values by column or row", "topics": [ "missingness" ] }, { "page": "missingrows", "title": "Return rows with missing values", "topics": [ "missingrows" ] }, { "page": "month", "title": "Extract the month", "topics": [ "month" ] }, { "page": "move", "title": "Move columns before or after another column", "topics": [ "move" ] }, { "page": "naif", "title": "Recode matching values to 'NA'", "topics": [ "naif" ] }, { "page": "nato", "title": "Replace 'NA' with a value", "topics": [ "nato" ] }, { "page": "natoblank", "title": "Replace 'NA' with an empty string", "topics": [ "natoblank" ] }, { "page": "ncols", "title": "Number of columns", "topics": [ "ncols" ] }, { "page": "nearestmerge", "title": "Nearest-key join", "topics": [ "nearestmerge" ] }, { "page": "nearesttext", "title": "Nearest string match", "topics": [ "nearesttext" ] }, { "page": "nest", "title": "Nest rows into a list-column of tables", "topics": [ "nest" ] }, { "page": "nonequimerge", "title": "Merge two tables using non-equi (inequality) conditions", "topics": [ "nonequimerge" ] }, { "page": "normalizeencoding", "title": "Normalize text encoding to UTF-8", "topics": [ "normalizeencoding" ] }, { "page": "normalizeunicode", "title": "Normalize Unicode text", "topics": [ "normalizeunicode" ] }, { "page": "nrows", "title": "Number of rows", "topics": [ "nrows" ] }, { "page": "omitmissing", "title": "Drop rows with missing values", "topics": [ "omitmissing" ] }, { "page": "orderrows", "title": "Order rows by one or more columns", "topics": [ "orderrows" ] }, { "page": "outofrange", "title": "Rows whose value falls outside a range", "topics": [ "outofrange" ] }, { "page": "overlapmerge", "title": "Merge tables on overlapping intervals", "topics": [ "overlapmerge" ] }, { "page": "padcenter", "title": "Pad text on both sides", "topics": [ "padcenter" ] }, { "page": "padleft", "title": "Pad text on the left", "topics": [ "padleft" ] }, { "page": "padright", "title": "Pad text on the right", "topics": [ "padright" ] }, { "page": "parsecurrency", "title": "Parse a currency string as a number", "topics": [ "parsecurrency" ] }, { "page": "parsedate", "title": "Parse text as dates, trying multiple formats", "topics": [ "parsedate" ] }, { "page": "parsedatetime", "title": "Parse text as date-times, trying multiple formats", "topics": [ "parsedatetime" ] }, { "page": "parsefailures", "title": "Rows where parsing failed", "topics": [ "parsefailures" ] }, { "page": "parseint", "title": "Parse text as integers", "topics": [ "parseint" ] }, { "page": "parselogical", "title": "Parse text as logicals", "topics": [ "parselogical" ] }, { "page": "parsenum", "title": "Parse text as numbers", "topics": [ "parsenum" ] }, { "page": "parsepercent", "title": "Parse a percentage string as a number", "topics": [ "parsepercent" ] }, { "page": "percentchange", "title": "Period-over-period percent change", "topics": [ "percentchange" ] }, { "page": "percentrank", "title": "Percentile rank of a vector", "topics": [ "percentrank" ] }, { "page": "pick", "title": "Select columns", "topics": [ "pick" ] }, { "page": "preview", "title": "Compact table preview", "topics": [ "preview" ] }, { "page": "profile", "title": "Compact variable profile", "topics": [ "profile" ] }, { "page": "propcount", "title": "Grouped counts with proportions", "topics": [ "propcount" ] }, { "page": "quantilegroup", "title": "Bin a vector into quantile groups", "topics": [ "quantilegroup" ] }, { "page": "quarter", "title": "Extract the calendar quarter", "topics": [ "quarter" ] }, { "page": "rangemerge", "title": "Merge two tables by a range condition", "topics": [ "rangemerge" ] }, { "page": "rbindfill", "title": "Row-bind tables, filling missing columns", "topics": [ "rbindfill" ] }, { "page": "recode", "title": "Recode values by lookup (alias)", "topics": [ "recode" ] }, { "page": "removeaccents", "title": "Strip accents from text", "topics": [ "removeaccents" ] }, { "page": "removeall", "title": "Remove text matching a pattern (alias)", "topics": [ "removeall" ] }, { "page": "removedrows", "title": "Rows present in 'old' but not in 'new'", "topics": [ "removedrows" ] }, { "page": "removeduplicates", "title": "Remove duplicate rows, optionally by key", "topics": [ "removeduplicates" ] }, { "page": "removetext", "title": "Remove text matching a pattern", "topics": [ "removetext" ] }, { "page": "renamecols", "title": "Rename columns", "topics": [ "renamecols" ] }, { "page": "renamewith", "title": "Rename columns with a function", "topics": [ "renamewith" ] }, { "page": "reorderlevels", "title": "Reorder factor levels", "topics": [ "reorderlevels" ] }, { "page": "repairnames", "title": "Repair column names", "topics": [ "repairnames" ] }, { "page": "replaceall", "title": "Recode values by lookup (alias)", "topics": [ "replaceall" ] }, { "page": "replacecols", "title": "Replace selected columns with new values", "topics": [ "replacecols" ] }, { "page": "replacetext", "title": "Replace a pattern with replacement text", "topics": [ "replacetext" ] }, { "page": "replacevalues", "title": "Recode values by lookup", "topics": [ "replacevalues" ] }, { "page": "replacewhere", "title": "Replace values in selected columns where a condition holds", "topics": [ "replacewhere" ] }, { "page": "rescale", "title": "Rescale a vector to a new range", "topics": [ "rescale" ] }, { "page": "reverse", "title": "Reverse row order", "topics": [ "reverse" ] }, { "page": "right", "title": "Last 'n' characters", "topics": [ "right" ] }, { "page": "rollapply", "title": "Rolling window apply", "topics": [ "rollapply" ] }, { "page": "rollingmerge", "title": "Rolling join two tables", "topics": [ "rollingmerge" ] }, { "page": "rollmax", "title": "Rolling maximum", "topics": [ "rollmax" ] }, { "page": "rollmean", "title": "Rolling mean", "topics": [ "rollmean" ] }, { "page": "rollmedian", "title": "Rolling median", "topics": [ "rollmedian" ] }, { "page": "rollmin", "title": "Rolling minimum", "topics": [ "rollmin" ] }, { "page": "rollprod", "title": "Rolling product", "topics": [ "rollprod" ] }, { "page": "rollsd", "title": "Rolling standard deviation", "topics": [ "rollsd" ] }, { "page": "rollsum", "title": "Rolling sum", "topics": [ "rollsum" ] }, { "page": "rollvar", "title": "Rolling variance", "topics": [ "rollvar" ] }, { "page": "rounddate", "title": "Round a date to the nearest unit", "topics": [ "rounddate" ] }, { "page": "rowall", "title": "Row-wise 'all()' across columns", "topics": [ "rowall" ] }, { "page": "rowany", "title": "Row-wise 'any()' across columns", "topics": [ "rowany" ] }, { "page": "rowapply", "title": "Apply a function row-wise", "topics": [ "rowapply" ] }, { "page": "rowcount", "title": "Count matches of a value across columns, per row", "topics": [ "rowcount" ] }, { "page": "rowfirst", "title": "First non-missing value across columns, per row", "topics": [ "rowfirst" ] }, { "page": "rowlast", "title": "Last non-missing value across columns, per row", "topics": [ "rowlast" ] }, { "page": "rowmax", "title": "Row-wise maximum across columns", "topics": [ "rowmax" ] }, { "page": "rowmin", "title": "Row-wise minimum across columns", "topics": [ "rowmin" ] }, { "page": "rownames", "title": "Row names", "topics": [ "rownames" ] }, { "page": "rownumber", "title": "Row position", "topics": [ "rownumber" ] }, { "page": "sameschema", "title": "Test whether two tables share the same column names", "topics": [ "sameschema" ] }, { "page": "samplefrac", "title": "Sample a fraction of rows without replacement", "topics": [ "samplefrac" ] }, { "page": "samplerows", "title": "Sample 'n' rows without replacement", "topics": [ "samplerows" ] }, { "page": "second", "title": "Extract the second", "topics": [ "second" ] }, { "page": "semimerge", "title": "Semi-join two tables", "topics": [ "semimerge" ] }, { "page": "sentencecase", "title": "Convert to sentence case", "topics": [ "sentencecase" ] }, { "page": "separate", "title": "Split one column into several", "topics": [ "separate" ] }, { "page": "setthreads", "title": "Set basetable thread count for the session", "topics": [ "setthreads" ] }, { "page": "similartext", "title": "Nearest string match (alias)", "topics": [ "similartext" ] }, { "page": "split", "title": "Split a table by groups", "topics": [ "split" ] }, { "page": "splitfirst", "title": "First piece after splitting on a separator", "topics": [ "splitfirst" ] }, { "page": "splitlast", "title": "Last piece after splitting on a separator", "topics": [ "splitlast" ] }, { "page": "splittext", "title": "Split text on a separator", "topics": [ "splittext" ] }, { "page": "squish", "title": "Trim and collapse internal whitespace", "topics": [ "squish" ] }, { "page": "stack", "title": "Stack columns", "topics": [ "stack" ] }, { "page": "standardize", "title": "Standardize a vector to mean 0, SD 1", "topics": [ "standardize" ] }, { "page": "startswith", "title": "Test whether strings start with a pattern", "topics": [ "startswith" ] }, { "page": "subset", "title": "Core data manipulation operations", "topics": [ "reshape", "subset", "transform" ] }, { "page": "summaries", "title": "Named grouped summaries", "topics": [ "summaries" ] }, { "page": "summarytab", "title": "Table 1-style descriptive summary", "topics": [ "summarytab" ] }, { "page": "textdist", "title": "Pairwise string distances", "topics": [ "textdist" ] }, { "page": "textlen", "title": "Character length", "topics": [ "textlen" ] }, { "page": "titlecase", "title": "Convert to title case", "topics": [ "titlecase" ] }, { "page": "tolong", "title": "Reshape columns into key/value rows", "topics": [ "tolong" ] }, { "page": "towide", "title": "Reshape rows into columns", "topics": [ "towide" ] }, { "page": "transliterate", "title": "Transliterate text to ASCII", "topics": [ "transliterate" ] }, { "page": "transpose", "title": "Transpose a table", "topics": [ "transpose" ] }, { "page": "traverse", "title": "Traverse a list of arguments", "topics": [ "traverse" ] }, { "page": "trim", "title": "Trim leading and trailing whitespace", "topics": [ "trim" ] }, { "page": "truncate", "title": "Truncate text with an ellipsis", "topics": [ "truncate" ] }, { "page": "types", "title": "Column types", "topics": [ "types" ] }, { "page": "unionrows", "title": "Set union of rows", "topics": [ "unionrows" ] }, { "page": "uniquerows", "title": "Unique rows, in memory or straight off a delimited file", "topics": [ "uniquerows" ] }, { "page": "uniques", "title": "Count of distinct values per column", "topics": [ "uniques" ] }, { "page": "unite", "title": "Combine several columns into one", "topics": [ "unite" ] }, { "page": "unmatchedkeys", "title": "Distinct keys of 'x' absent from 'y'", "topics": [ "unmatchedkeys" ] }, { "page": "unnest", "title": "Expand list-columns back into rows", "topics": [ "unnest" ] }, { "page": "unstack", "title": "Unstack a table", "topics": [ "unstack" ] }, { "page": "updatemerge", "title": "Update rows from another table", "topics": [ "updatemerge" ] }, { "page": "upper", "title": "Convert to upper case", "topics": [ "upper" ] }, { "page": "week", "title": "Extract the week of year", "topics": [ "week" ] }, { "page": "weekday", "title": "Extract the weekday name", "topics": [ "weekday" ] }, { "page": "winsorize", "title": "Winsorize a vector at given quantiles", "topics": [ "winsorize" ] }, { "page": "within", "title": "Modify a table within an environment", "topics": [ "within" ] }, { "page": "year", "title": "Extract the year", "topics": [ "year" ] }, { "page": "yearday", "title": "Extract the day of year", "topics": [ "yearday" ] } ], "_readme": "https://github.com/ielbadisy/basetable/raw/HEAD/README.md", "_rundeps": [], "_sysdeps": [ { "shlib": "libstdc++", "package": "libstdc++6", "source": "gcc", "version": "16-20260322-1ubuntu1", "name": "c++", "homepage": "http://gcc.gnu.org/", "description": "GNU Standard C++ Library v3" } ], "_vignettes": [ { "source": "functions-reference.Rmd", "filename": "functions-reference.html", "title": "basetable: A Complete Function Reference", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Core verbs", "Subsetting rows and columns: subset()", "Picking and dropping columns: pick(), drop()", "Creating and modifying columns: transform(), within()", "Renaming columns: renamecols()", "Aggregation and grouping", "Grouped summaries: aggregate()", "Counting rows: count(), propcount()", "Named summaries with summaries()", "Splitting into groups: split() and applyby()", "First/last row per group: firstby(), lastby()", "Joining tables", "Standard joins: merge()", "Semi- and anti-joins: semimerge(), antimerge()", "Key-matching helpers: matchedkeys(), unmatchedkeys(), joinrelationship()", "Cross joins: crossmerge()", "Rolling and nearest-key joins: rollingmerge(), nearestmerge()", "Interval overlap joins: overlapmerge()", "Updating values from another table: updatemerge()", "Conditional joins: nonequimerge(), rangemerge()", "Set operations and table comparison", "Row-level set operations: unionrows(), intersectrows(), diffrows()", "Comparing two tables: equalrows(), equaldata(), sameschema(), compareschema(), changedcols()", "Comparing two snapshots of the same table: addedrows(), removedrows(), changedrows()", "Row/column binding: rbindfill(), cbind()", "Reshaping", "Long and wide formats: tolong(), towide()", "Base R reshape, stack, and unstack: reshape(), stack(), unstack()", "Splitting and combining text columns: separate(), unite()", "Transposing: transpose()", "Exploration and EDA", "Shape and types: dims(), types(), nrows(), ncols()", "Peeking at data: headtail(), preview()", "Descriptive statistics: describe(), profile()", "Frequency tables: freq()", "Table 1-style summaries: summarytab()", "Missingness: missingness()", "Comparing two tables at a glance: compare()", "Data cleaning and validation", "Assertions that stop on failure: assert*()", "Finding rows/values that fail a check: invalidrows(), invalidvalues(), outofrange()", "Missing-data helpers: missingrows(), keepmissing(), omitmissing(), missingindicator()", "Filling in missing combinations: completegrid(), expandrows()", "Recoding values: naif(), nato(), blanktona(), natoblank(), replacevalues(), replacewhere(), replacecols()", "Deduplication: uniquerows(), removeduplicates(), duplicaterows(), duplicatekeys(), duplicatenames()", "Column-name hygiene: cleannames(), repairnames(), renamewith(), commonnames()", "Filling in missing values within groups: filldown(), fillup(), fillboth()", "Row and column utilities", "Column metadata: colnames(), rownames(), classes(), uniques(), cardinality(), constants(), emptycols()", "Finding blank rows: emptyrows()", "Reordering columns: move(), firstcols(), lastcols()", "Row subsets: firstrows(), lastrows(), samplerows(), samplefrac(), reverse()", "Sorting rows: orderrows()", "Row position helpers: rownumber()", "Row-wise reductions across columns: rowmin(), rowmax(), rowany(), rowall(), rowcount(), rowfirst(), rowlast(), rowapply()", "Applying a function to selected columns: applycols(), convertcols()", "String manipulation", "Whitespace and case: trim(), squish(), lower(), upper(), titlecase(), sentencecase(), textlen()", "Substrings and padding: left(), right(), middle(), truncate(), padleft(), padright(), padcenter()", "Pattern matching: containstext(), matchestext(), startswith(), endswith(), countmatch(), locate(), locateall()", "Extraction: extract(), extractall(), extractnum(), extractint(), extractbetween()", "Replace and remove: replacetext(), removetext(), removeall(), replaceall()", "Split and join: splittext(), splitfirst(), splitlast(), jointext(), collapsetext()", "Blank and encoding helpers: isblank(), removeaccents(), normalizeunicode(), normalizeencoding(), transliterate()", "String distance and similarity: textdist(), nearesttext(), similartext()", "Classification predicates: isalpha(), isalphanumeric(), isnumerictext(), isintegertext(), isemail(), isurl()", "Recoding and grouping values: recode(), collapsevalues(), casewhen(), collapselevels(), lump(), reorderlevels(), expandlevels()", "Parsing text into typed values", "Dates and times", "Extracting components", "Arithmetic and sequences: adddays(), addweeks(), addmonths(), addyears(), datediff(), dateseq(), betweendates()", "Rounding dates: floordate(), ceilingdate(), rounddate()", "Numeric transforms and rolling windows", "Rescaling and standardizing: rescale(), standardize(), center(), winsorize()", "Binning: quantilegroup()", "Period-over-period change and rank: percentchange(), percentrank(), denserank()", "Cumulative helpers: cumcount(), cumedist(), cumavg()", "Lag/lead and differencing: difference(), lagvalue(), leadvalue()", "Rolling window functions: rollmean(), rollsum(), rollmin(), rollmax(), rollmedian(), rollsd(), rollvar(), rollprod(), rollapply()", "Functional helpers", "Closing notes" ], "created": "2026-08-24 11:24:23", "modified": "2026-08-30 13:40:40", "commits": 8 }, { "source": "benchmarking.Rmd", "filename": "benchmarking.html", "title": "Benchmarks", "engine": "knitr::rmarkdown", "headings": [ "Running the benchmark", "A raw bench::mark result", "Summary table", "Speed", "Memory", "Reading the results" ], "created": "2026-07-18 16:08:42", "modified": "2026-09-23 09:14:44", "commits": 17 }, { "source": "data-manipulation.Rmd", "filename": "data-manipulation.html", "title": "Data manipulation", "engine": "knitr::rmarkdown", "headings": [ "A compact pipeline", "Values from the calling function", "Grouped summaries", "Joins", "Validation in a pipeline", "Explicit package calls" ], "created": "2026-03-25 10:23:25", "modified": "2026-08-28 21:27:32", "commits": 5 }, { "source": "exploration.Rmd", "filename": "exploration.html", "title": "Exploration", "engine": "knitr::rmarkdown", "headings": [], "created": "2026-03-25 10:23:25", "modified": "2026-04-29 09:29:47", "commits": 2 }, { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting started", "engine": "knitr::rmarkdown", "headings": [ "The canonical compact core", "Namespaces stay explicit" ], "created": "2026-03-25 10:23:25", "modified": "2026-08-30 12:23:19", "commits": 6 } ], "_score": 6.8750612633917, "_indexed": true, "_nocasepkg": "basetable", "_universes": [ "ielbadisy" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.4.2", "date": "2026-09-23T12:03:44.000Z", "distro": "resolute", "arch": "aarch64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/9606c2b6f5425cce4b91d1f498b37aaca8107d3b55256069a81a368c3ce79bb4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.7.0", "os": "linux", "version": "1.4.2", "date": "2026-09-23T12:04:25.000Z", "distro": "resolute", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/56b8475bc2ee17790cb3319c56154d61afdf0567171c15c4ee0eb77577ed12e3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.1", "os": "linux", "version": "1.4.2", "date": "2026-09-23T12:03:37.000Z", "distro": "resolute", "arch": "aarch64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/931294074e0d8a268424da8cfb8ab5e2a8bd3917dc155776685bf94c00ed3e7c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.1", "os": "linux", "version": "1.4.2", "date": "2026-09-23T12:03:59.000Z", "distro": "resolute", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/64ed7518450f34c6d98e8adc40bf4ed575516c3dcd6167490eacff26a694012c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.5.3", "os": "mac", "version": "1.4.2", "date": "2026-09-23T12:06:33.000Z", "arch": "aarch64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/fe166364b2be73496c95d41e8babc0e0e0462e4d935969e14d49efe3c46db48c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.5.3", "os": "mac", "version": "1.4.2", "date": "2026-09-23T12:05:27.000Z", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/ed82c6f0d4bfe912a57a9b80eb292dc556aeb03eb2955a522d6391545b6803a2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.1", "os": "mac", "version": "1.4.2", "date": "2026-09-23T12:11:30.000Z", "arch": "aarch64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/48f3e70444a99439a670c47f47acfd0752b370bfe3da69a917b6ea8a0ee3df50", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.1", "os": "mac", "version": "1.4.2", "date": "2026-09-23T12:08:16.000Z", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/31640c27cbf7e8b5950a7b5ca6713fff768d20d6d863cd86039d25ee48577e0b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.0", "os": "wasm", "version": "1.4.2", "date": "2026-09-23T12:03:47.000Z", "arch": "emscripten", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/5b66444dfb9f02bb785a788d4fa9892e915d64cdaf91ab66cac542bdc4593cfc", "status": "success", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.7.0", "os": "win", "version": "1.4.2", "date": "2026-09-23T12:07:55.000Z", "arch": "aarch64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/57ad7c0381d27241d7393f20a1a764da521f7109d59843c1ad06020468de3b56", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.7.0", "os": "win", "version": "1.4.2", "date": "2026-09-23T12:03:11.000Z", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/869658e8cd7821f104ab4cc1670a93ab6f2a02a7826cf1fc6f311c85e3ddf99d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.5.3", "os": "win", "version": "1.4.2", "date": "2026-09-23T12:03:14.000Z", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/5fb1a448309a8d2bb94cca6e6cdb810af8aee49c35e6201429ca98a323173fef", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.1", "os": "win", "version": "1.4.2", "date": "2026-09-23T12:08:09.000Z", "arch": "aarch64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/28eff8b620afd40ee51a04675b20604c51080674c7b0f4d52ef42f1b8f520725", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" }, { "r": "4.6.1", "os": "win", "version": "1.4.2", "date": "2026-09-23T12:03:10.000Z", "arch": "x86_64", "commit": "a2150c3e8ebdcbbf714422fb1de0329a21bc0c54", "fileid": "https://r2.ropensci.org/8ad1f806f46a4e87db89cf582eda351da73234fa97747895b40129e06d8233e7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ielbadisy/actions/runs/35857571051" } ] }