{ "_id": "6a102d0bacfb0bcc41c937e5", "Package": "thinkr", "Title": "Tools for Cleaning Up Messy Files", "Version": "0.16", "Authors@R": "c(\nperson(\"Vincent\", \"Guyader\", , \"vincent@thinkr.fr\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0003-0671-9270\")),\nperson(\"Sébastien\", \"Rochette\", , \"sebastien@thinkr.fr\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-1565-9313\")),\nperson(\"ThinkR\", role = \"cph\")\n)", "Description": "Some tools for cleaning up messy 'Excel' files to be\nsuitable for R. People who have been working with 'Excel' for\nyears built more or less complicated sheets with names,\ncharacters, formats that are not homogeneous. To be able to use\nthem in R nowadays, we built a set of functions that will avoid\nthe majority of importation problems and keep all the data at\nbest.", "License": "GPL-3", "URL": "https://github.com/Thinkr-open/thinkr", "BugReports": "https://github.com/Thinkr-open/thinkr/issues", "VignetteBuilder": "knitr", "Encoding": "UTF-8", "RoxygenNote": "7.2.0", "Config/pak/sysreqs": "libcairo2-dev cmake libfontconfig1-dev\nlibfreetype6-dev libfribidi-dev git make libharfbuzz-dev\nlibgit2-dev libicu-dev libjpeg-dev libpng-dev libtiff-dev\nlibuv1-dev libwebp-dev libxml2-dev libssl-dev libx11-dev\nzlib1g-dev", "Repository": "https://thinkr-open.r-universe.dev", "Date/Publication": "2022-08-22 13:16:17 UTC", "RemoteUrl": "https://github.com/ThinkR-open/thinkr", "RemoteRef": "HEAD", "RemoteSha": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-13 06:01:55 UTC", "User": "root" }, "Author": "Vincent Guyader [aut, cre] (ORCID:\n),\nSébastien Rochette [aut] (ORCID:\n),\nThinkR [cph]", "Maintainer": "Vincent Guyader ", "MD5sum": "1fab24f399e8091a35127ba1e2d383ec", "_user": "thinkr-open", "_type": "src", "_file": "thinkr_0.16.tar.gz", "_fileid": "d125396543db3206450703593585cbd7b76d9e2c8a70465fe45416494f0eaa78", "_filesize": 205761, "_sha256": "d125396543db3206450703593585cbd7b76d9e2c8a70465fe45416494f0eaa78", "_created": "2026-05-13T06:01:55.000Z", "_published": "2026-05-22T10:16:43.271Z", "_distro": "noble", "_jobs": [ { "job": 77359974714, "time": 177, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "6962765242" }, { "job": 77359974859, "time": 164, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "6962760821" }, { "job": 77359974772, "time": 129, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "6962753135" }, { "job": 77359974706, "time": 121, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "6962751515" }, { "job": 77359974304, "time": 213, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "6962724017" }, { "job": 77359974303, "time": 137, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7158142184" }, { "job": 77359974602, "time": 112, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "6962749516" }, { "job": 77359974987, "time": 120, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "6962751380" }, { "job": 77359974607, "time": 120, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "6962751340" } ], "_buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/ThinkR-open/thinkr", "_commit": { "id": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "author": "vincent ", "committer": "vincent ", "message": "update code_of_conduct link\n", "time": 1661174177 }, "_maintainer": { "name": "Vincent Guyader", "email": "vincent@thinkr.fr", "login": "vincentguyader", "uuid": 10470699, "orcid": "0000-0003-0671-9270" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 3.1", "role": "Depends" }, { "package": "assertthat", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "devtools", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "ggplot2", "role": "Imports" }, { "package": "lazyeval", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "magrittr", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "officer", "role": "Imports" }, { "package": "rvg", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "withr", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" } ], "_owner": "thinkr-open", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_topics": [ "hacktoberfest", "thinkr-not-maintained" ], "_stars": 28, "_contributors": [ { "user": "vincentguyader", "count": 34, "uuid": 10470699 }, { "user": "statnmap", "count": 25, "uuid": 21193866 }, { "user": "benjaminlouis", "count": 6, "uuid": 40994689 }, { "user": "amillanfl", "count": 3, "uuid": 66634226 }, { "user": "arthurdata", "count": 3, "uuid": 35060481 }, { "user": "davidgohel", "count": 1, "uuid": 4331618 }, { "user": "romainfrancois", "count": 1, "uuid": 2625526 }, { "user": "mauthier", "count": 1, "uuid": 18634131 } ], "_userbio": { "uuid": 19155426, "type": "organization", "name": "ThinkR", "description": "R Engineering, training, and consulting" }, "_downloads": { "count": 274, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/thinkr" }, "_devurl": "https://github.com/thinkr-open/thinkr", "_searchresults": 46, "_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/thinkr.html", "manual.pdf" ], "_homeurl": "https://github.com/thinkr-open/thinkr", "_realowner": "thinkr-open", "_cranurl": true, "_releases": [ { "version": "0.11", "date": "2018-02-20" }, { "version": "0.13", "date": "2018-06-21" }, { "version": "0.15", "date": "2020-07-07" }, { "version": "0.16", "date": "2022-08-22" } ], "_exports": [ ".efface_test", "%>%", "%ni%", "all_ggplot_to_pptx", "as_mon_numeric", "clean_levels", "clean_names", "clean_vec", "dput_levels", "excel_col", "excel_to_ncol", "find_name", "from_excel_to_posixt", "gsub2", "is_full_figures", "is_full_na", "is_likert", "is.01", "is.12", "look_like_a_number", "make_unique", "ncol_to_excel", "peep", "replace_pattern", "save_as_csv", "set_col_type" ], "_help": [ { "page": "dot-efface_test", "title": "delete .test file in testthat folder", "topics": [ ".efface_test" ] }, { "page": "grapes-ni-grapes", "title": "not in", "topics": [ "%ni%" ] }, { "page": "all_ggplot_to_pptx", "title": "Save all ggplot in a pptx", "topics": [ "all_ggplot_to_pptx" ] }, { "page": "as_mon_numeric", "title": "Transform a vector into numeric if meaningful, even with bad decimal, space or %", "topics": [ "as_mon_numeric" ] }, { "page": "clean_levels", "title": "Clean levels label", "topics": [ "clean_levels" ] }, { "page": "clean_names", "title": "clean_names", "topics": [ "clean_names" ] }, { "page": "clean_vec", "title": "Clean character vector", "topics": [ "clean_vec" ] }, { "page": "dput_levels", "title": "return R instruction to create levels", "topics": [ "dput_levels" ] }, { "page": "excel_names", "title": "Get position or excel name of column", "topics": [ "excel_col", "excel_names", "excel_to_ncol", "ncol_to_excel" ] }, { "page": "find_name", "title": "find pattern in name's dataset", "topics": [ "find_name" ] }, { "page": "from_excel_to_posixt", "title": "transform the excel numeric date format into POSIXct", "topics": [ "from_excel_to_posixt" ] }, { "page": "gsub2", "title": "like gsub but keep a factor as factor", "topics": [ "gsub2" ] }, { "page": "is_full_figures", "title": "Predicate for charater vector full of figures", "topics": [ "is_full_figures" ] }, { "page": "is_full_na", "title": "Predicate for full NA vector", "topics": [ "is_full_na" ] }, { "page": "is_likert", "title": "is a factor a likert scale", "topics": [ "is_likert" ] }, { "page": "is.01", "title": "does this vector only contains 0 and 1", "topics": [ "is.01" ] }, { "page": "is.12", "title": "does this vector only contains 1 and 2", "topics": [ "is.12" ] }, { "page": "look_like_a_number", "title": "return TRUE if this look like a number", "topics": [ "look_like_a_number" ] }, { "page": "make_unique", "title": "make.unique improvement", "topics": [ "make_unique" ] }, { "page": "peep", "title": "peep the pipeline", "topics": [ "peep" ] }, { "page": "replace_pattern", "title": "Replace pattern everywhere in a data.frame", "topics": [ "replace_pattern" ] }, { "page": "save_as_csv", "title": "export a data.frame to csv", "topics": [ "save_as_csv" ] }, { "page": "set_col_type", "title": "set a given coltype to each column in a data.frame", "topics": [ "set_col_type" ] } ], "_pkglogo": "https://github.com/ThinkR-open/thinkr/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/ThinkR-open/thinkr/raw/HEAD/README.md", "_rundeps": [ "askpass", "assertthat", "base64enc", "brew", "brio", "bslib", "cachem", "callr", "cli", "clipr", "commonmark", "cpp11", "crayon", "credentials", "curl", "desc", "devtools", "diffobj", "digest", "downlit", "dplyr", "ellipsis", "evaluate", "fansi", "farver", "fastmap", "fontawesome", "fontBitstreamVera", "fontLiberation", "fontquiver", "fs", "gdtools", "generics", "gert", "ggplot2", "gh", "gitcreds", "glue", "gtable", "highr", "htmltools", "htmlwidgets", "httpuv", "httr2", "ini", "isoband", "jquerylib", "jsonlite", "knitr", "labeling", "later", "lazyeval", "lifecycle", "lubridate", "magrittr", "memoise", "mime", "miniUI", "officer", "openssl", "otel", "pak", "pillar", "pkgbuild", "pkgconfig", "pkgdown", "pkgload", "praise", "prettyunits", "processx", "profvis", "promises", "ps", "purrr", "R6", "ragg", "rappdirs", "rcmdcheck", "RColorBrewer", "Rcpp", "rlang", "rmarkdown", "roxygen2", "rprojroot", "rstudioapi", "rversions", "rvg", "S7", "sass", "scales", "sessioninfo", "shiny", "sourcetools", "stringi", "stringr", "sys", "systemfonts", "testthat", "textshaping", "tibble", "tidyr", "tidyselect", "timechange", "tinytex", "urlchecker", "usethis", "utf8", "uuid", "vctrs", "viridisLite", "waldo", "whisker", "withr", "xfun", "xml2", "xopen", "xtable", "yaml", "zip" ], "_vignettes": [ { "source": "Using-excel_names-functions.Rmd", "filename": "Using-excel_names-functions.html", "title": "Functions related to Excel", "engine": "knitr::rmarkdown", "headings": [ "excel_names : dealing with column names and position number" ], "created": "2021-07-14 07:57:26", "modified": "2021-07-14 07:57:26", "commits": 1 }, { "source": "tools.Rmd", "filename": "tools.html", "title": "tools", "engine": "knitr::rmarkdown", "headings": [ "replace_pattern(): Replace all occurencies of a pattern by replacement", "is_likert(): Verify levels of a factor vector" ], "created": "2021-03-09 10:23:28", "modified": "2021-07-14 07:32:29", "commits": 2 } ], "_score": 6.955013903038051, "_indexed": true, "_nocasepkg": "thinkr", "_universes": [ "thinkr-open", "vincentguyader" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.16", "date": "2026-05-13T06:04:36.000Z", "distro": "noble", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "09751a41295aed7b07725ef576b354f4e4408824192d5aadbb96ad46cad60898", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.6.0", "os": "linux", "version": "0.16", "date": "2026-05-13T06:04:17.000Z", "distro": "noble", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "08208ca1bc38da4af4fb7accffa2f217c70495682b153ab2e7a8ef0ed5dd6f67", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.5.3", "os": "mac", "version": "0.16", "date": "2026-05-13T06:03:50.000Z", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "56db4f079ce853be363560d8f34fa14d0dbd02ff47c09cb0961db28b8df2c8fd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.6.0", "os": "mac", "version": "0.16", "date": "2026-05-13T06:03:43.000Z", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "044079d0fcfe031af441ce6c9f5b7e98a896689b1c9bd04980e73fa9ef46c7f4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.7.0", "os": "win", "version": "0.16", "date": "2026-05-13T06:03:16.000Z", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "0a8b1ad40da85c6f083e07a0b32935aab47de01b7334a001bed1bf277c64f7f6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.5.3", "os": "win", "version": "0.16", "date": "2026-05-13T06:03:25.000Z", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "2037747e9827ffa59f852d2759c44a69d10006439531f6c8f710fcc91113a95e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.6.0", "os": "win", "version": "0.16", "date": "2026-05-13T06:03:17.000Z", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "e8838d2ed4db7e638d503a338c3ed1444fecb0643de9c6349684009d16723986", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" }, { "r": "4.6.0", "os": "wasm", "version": "0.16", "date": "2026-05-22T10:16:24.000Z", "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099", "fileid": "a7865e783d9bb718f5bd8342f3069555a1841fdb15e5e7554fa591863a3117d6", "status": "success", "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/25781326710" } ] }