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.


the peep function allow you to "have a look" inside a dplyr workflow

library(thinkr)
library(dplyr)
data(iris)
iris %>% peep(head,summary) %>% plot
iris %>% peep_("head","summary") %>% plot
iris %>% peep(funs(head(.,n=2),summary(.,maxsum=2))) %>% plot
iris %>% peep(funs(summary(.,maxsum=2))) %>% plot

clean_names allow to cean dirty names

library(thinkr)
library(dplyr)
data(iris)
 
iris %>% head
iris %>% clean_names() %>% head
iris %>% clean_names() %>% head

Installation

# install.packages("devtools")
devtools::install_github("ThinkRstat/ThinkR")

News

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("thinkr")

0.15 by Vincent Guyader, 10 months ago


https://github.com/Thinkr-open/thinkr


Report a bug at https://github.com/Thinkr-open/thinkr/issues


Browse source code at https://github.com/cran/thinkr


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


Documentation:   PDF Manual  


GPL-3 license


Imports assertthat, crayon, devtools, dplyr, ggplot2, lazyeval, lubridate, magrittr, officer, purrr, readr, rvg, stats, stringi, stringr, tidyr, utils

Suggests covr, testthat


See at CRAN