Package: thinkr 0.16

Vincent Guyader

thinkr:Tools for Cleaning Up Messy Files

Some tools for cleaning up messy 'Excel' files to be suitable for R. People who have been working with 'Excel' for years built more or less complicated sheets with names, characters, formats that are not homogeneous. To be able to use them in R nowadays, we built a set of functions that will avoid the majority of importation problems and keep all the data at best.

Authors:Vincent Guyader [aut, cre], Sébastien Rochette [aut], ThinkR [cph]

thinkr_0.16.tar.gz
thinkr_0.16.zip(r-4.5)thinkr_0.16.zip(r-4.4)thinkr_0.16.zip(r-4.3)
thinkr_0.16.tgz(r-4.4-any)thinkr_0.16.tgz(r-4.3-any)
thinkr_0.16.tar.gz(r-4.5-noble)thinkr_0.16.tar.gz(r-4.4-noble)
thinkr_0.16.tgz(r-4.4-emscripten)thinkr_0.16.tgz(r-4.3-emscripten)
thinkr.pdf |thinkr.html✨
thinkr/json (API)

# Installthinkr in R:

install.packages('thinkr',repos = c('https://thinkr-open.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/thinkr-open/thinkr/issues

On CRAN:

hacktoberfest thinkr-not-maintained

26 exports 30 stars 2.68 score 131 dependencies 334 downloads

Last updated 2 years agofrom:d3b41640ce

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

Dependencies:askpass assertthat base64enc brew brio bslib cachem callr cli clipr colorspace commonmark cpp11 crayon credentials crul curl desc devtools diffobj digest downlit dplyr ellipsis evaluate fansi farver fastmap fontawesome fontBitstreamVera fontLiberation fontquiver fs gdtools generics gert gfonts ggplot2 gh gitcreds glue gtable highr htmltools htmlwidgets httpcode httpuv httr httr2 ini isoband jquerylib jsonlite knitr labeling later lattice lazyeval lifecycle lubridate magrittr MASS Matrix memoise mgcv mime miniUI munsell nlme officer openssl pillar pkgbuild pkgconfig pkgdown pkgload praise prettyunits processx profvis promises ps purrr R6 ragg rappdirs rcmdcheck RColorBrewer Rcpp rematch2 remotes rlang rmarkdown roxygen2 rprojroot rstudioapi rversions rvg sass scales sessioninfo shiny sourcetools stringi stringr sys systemfonts testthat textshaping tibble tidyr tidyselect timechange tinytex triebeard urlchecker urltools usethis utf8 uuid vctrs viridisLite waldo whisker withr xfun xml2 xopen xtable yaml zip

Functions related to Excel

Rendered fromUsing-excel_names-functions.Rmdusingknitr::rmarkdownon Jun 17 2024.

Last update: 2021-07-14
Started: 2021-07-14

tools

Rendered fromtools.Rmdusingknitr::rmarkdownon Jun 17 2024.

Last update: 2021-07-14
Started: 2021-03-09

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
delete .test file in testthat folder	.efface_test
not in	%ni%
Save all ggplot in a pptx	all_ggplot_to_pptx
Transform a vector into numeric if meaningful, even with bad decimal, space or %	as_mon_numeric
Clean levels label	clean_levels
clean_names	clean_names
Clean character vector	clean_vec
return R instruction to create levels	dput_levels
Get position or excel name of column	excel_col excel_names excel_to_ncol ncol_to_excel
find pattern in name's dataset	find_name
transform the excel numeric date format into POSIXct	from_excel_to_posixt
like gsub but keep a factor as factor	gsub2
Predicate for charater vector full of figures	is_full_figures
Predicate for full NA vector	is_full_na
is a factor a likert scale	is_likert
does this vector only contains 0 and 1	is.01
does this vector only contains 1 and 2	is.12
return TRUE if this look like a number	look_like_a_number
make.unique improvement	make_unique
peep the pipeline	peep
Replace pattern everywhere in a data.frame	replace_pattern
export a data.frame to csv	save_as_csv
set a given coltype to each column in a data.frame	set_col_type