{
  "_id": "6a5471139b92047c28d5994e",
  "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-07-12 08:34:08 UTC",
    "User": "root"
  },
  "Author": "Vincent Guyader [aut, cre] (ORCID:\n<https://orcid.org/0000-0003-0671-9270>),\nSébastien Rochette [aut] (ORCID:\n<https://orcid.org/0000-0002-1565-9313>),\nThinkR [cph]",
  "Maintainer": "Vincent Guyader <vincent@thinkr.fr>",
  "_user": "thinkr-open",
  "_type": "src",
  "_file": "thinkr_0.16.tar.gz",
  "_fileid": "https://r2.ropensci.org/019f271e7db37e567a5d922b43e487c4ab5a4ef0756aeeb494bfb6b63641795b",
  "_filesize": 205998,
  "_sha256": "019f271e7db37e567a5d922b43e487c4ab5a4ef0756aeeb494bfb6b63641795b",
  "_expires": "2026-10-20T08:38:09.000Z",
  "_created": "2026-07-12T08:34:08.000Z",
  "_published": "2026-07-13T05:01:07.245Z",
  "_jobs": [
    {
      "job": 86737621266,
      "time": 200,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8258055446"
    },
    {
      "job": 86737620677,
      "time": 196,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8269509875"
    },
    {
      "job": 86737621094,
      "time": 127,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8258046554"
    },
    {
      "job": 86737621228,
      "time": 147,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8258048739"
    },
    {
      "job": 86737621077,
      "time": 235,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8258030428"
    },
    {
      "job": 86737621349,
      "time": 149,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "8258049518"
    },
    {
      "job": 86737621247,
      "time": 130,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "8258047349"
    },
    {
      "job": 86737621409,
      "time": 131,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "8258047466"
    },
    {
      "job": 86737621467,
      "time": 106,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "8258043724"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122",
  "_status": "success",
  "_upstream": "https://github.com/ThinkR-open/thinkr",
  "_commit": {
    "id": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
    "author": "vincent <vincent@thinkr.fr>",
    "committer": "vincent <vincent@thinkr.fr>",
    "message": "update code_of_conduct link\n",
    "time": 1661174177
  },
  "_maintainer": {
    "name": "Vincent Guyader",
    "email": "vincent@thinkr.fr",
    "login": "vincentguyader",
    "description": "Founder @ThinkR-open ",
    "uuid": 10470699,
    "orcid": "0000-0003-0671-9270"
  },
  "_distro": "resolute",
  "_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": 27,
  "_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",
    "followers": 258,
    "description": "R Engineering, training, and consulting"
  },
  "_downloads": {
    "count": 285,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/thinkr"
  },
  "_devurl": "https://github.com/thinkr-open/thinkr",
  "_searchresults": 48,
  "_rbuild": "4.6.1",
  "_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",
    "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.9577030415488315,
  "_indexed": true,
  "_nocasepkg": "thinkr",
  "_universes": [
    "thinkr-open",
    "vincentguyader"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.16",
      "date": "2026-07-12T08:37:02.000Z",
      "distro": "resolute",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/b3b435a96d8c0862dfdfd8bf853e3c311be86880da7d0438e7a622f85e90c920",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.16",
      "date": "2026-07-13T05:00:09.000Z",
      "distro": "resolute",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/2eac0181518bd6ad37a31120df04df0add0377403585f66b67b632588bc29add",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.16",
      "date": "2026-07-12T08:35:55.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/29e988df839ee5e5e1e65d767342f2dbfca090190a41f42eb123a88be0945be8",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.16",
      "date": "2026-07-12T08:36:10.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/edf7b8774bce8122b00edda11259cedb98f16713b86d8e92dee1d50dd3bd99d3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.16",
      "date": "2026-07-12T08:36:54.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/cdb7a1ccc1448b0861d0b6d88378c351f1b435f678092384918baf166457c396",
      "status": "success",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.16",
      "date": "2026-07-12T08:35:48.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/999e45036c45f3c011cf738104788005045ff0b664462f3d73e48163503a8277",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.16",
      "date": "2026-07-12T08:35:48.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/58e9f5f806c4947cb9d649dfb8163b3db7b660a2a46ef15150cdb70edf5e4680",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.16",
      "date": "2026-07-12T08:35:22.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "https://r2.ropensci.org/eb5073137bd0c4aade739331983770544570f594616335e1e2548ec92642416b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/29185942122"
    }
  ]
}