Tools for Cleaning Up Messy Files
Save all ggplot in a pptx
Transform a vector into numeric if meaningful, even with bad decimal, ...
Clean levels label
clean_names
Clean character vector
delete .test file in testthat folder
return R instruction to create levels
Get position or excel name of column
find pattern in name's dataset
transform the excel numeric date format into POSIXct
not in
like gsub but keep a factor as factor
does this vector only contains 0 and 1
does this vector only contains 1 and 2
Predicate for charater vector full of figures
Predicate for full NA vector
is a factor a likert scale
return TRUE if this look like a number
make.unique improvement
peep the pipeline
Pipe operator
Replace pattern everywhere in a data.frame
export a data.frame to csv
set a given coltype to each column in a data.frame
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.