{
  "_id": "6a2bdbffba420f1ac0cbfc22",
  "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-06-12 10:10:51 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>",
  "MD5sum": "fd6d517f5fd1672808219dc7a1a7162a",
  "_user": "thinkr-open",
  "_type": "src",
  "_file": "thinkr_0.16.tar.gz",
  "_fileid": "602c332ece45608ba2900cb59e5ecd55f964b718ef9624deccd604f68e4c064e",
  "_filesize": 205972,
  "_sha256": "602c332ece45608ba2900cb59e5ecd55f964b718ef9624deccd604f68e4c064e",
  "_created": "2026-06-12T10:10:51.000Z",
  "_published": "2026-06-12T10:14:23.307Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 81006123905,
      "time": 170,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7588872446"
    },
    {
      "job": 81006123850,
      "time": 171,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7588872415"
    },
    {
      "job": 81006123949,
      "time": 103,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7588850618"
    },
    {
      "job": 81006123868,
      "time": 106,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7588851417"
    },
    {
      "job": 81005523967,
      "time": 223,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7588816997"
    },
    {
      "job": 81006123834,
      "time": 136,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7588860702"
    },
    {
      "job": 81006123865,
      "time": 113,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7588853644"
    },
    {
      "job": 81006124035,
      "time": 141,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7588862890"
    },
    {
      "job": 81006123872,
      "time": 111,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7588853291"
    }
  ],
  "_buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_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"
  },
  "_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": 219,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/thinkr"
  },
  "_devurl": "https://github.com/thinkr-open/thinkr",
  "_searchresults": 48,
  "_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",
    "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.973497308732064,
  "_indexed": true,
  "_nocasepkg": "thinkr",
  "_universes": [
    "thinkr-open",
    "vincentguyader"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.16",
      "date": "2026-06-12T10:13:22.000Z",
      "distro": "noble",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "38135410a65b9d40ca1278430ec1dd7dee0c01077cd7ba5cc8a05e0aadfaf61b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.16",
      "date": "2026-06-12T10:13:22.000Z",
      "distro": "noble",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "25f98a6abaa9235262cdb7c8448e952464ebb96cd770c88705c4fa58b9595525",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.16",
      "date": "2026-06-12T10:12:26.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "0a298bf94fbba0c977c84ad9155ef7d97682bdaf58349afed0715b04c5b5bf1f",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.16",
      "date": "2026-06-12T10:12:28.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "5552867e1d018b24f03825fd0428014c9d0b294ee6aa15e58b15c9ab0e1584f9",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.16",
      "date": "2026-06-12T10:13:25.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "7c27a8f3bf5be017d0f251e025af15e570b360e61ee6e287edb3775ab8f81848",
      "status": "success",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.16",
      "date": "2026-06-12T10:12:10.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "4d46b386bfd50d550759fe2676bd9ff8253118ab031f7659bf88d4b73a28bed3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.16",
      "date": "2026-06-12T10:12:34.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "e9d8ab0a771de94bb969c6912d6421b293fa4749c6e86eed089879d0bf69534e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.16",
      "date": "2026-06-12T10:12:14.000Z",
      "commit": "d3b41640cebc476bd814e4a65e30e5d238d7c099",
      "fileid": "796a2d3b905e67c7c4d00d6b890baa401593b8a6ff5fe93957bf86bae5e4604b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/thinkr-open/actions/runs/27409062019"
    }
  ]
}