README.md
In KevinRPan/handy: Commonly Used Functions For Handling Data

handy

The handy package is an R toolbox of commonly used functions for working with data.

This package aims to reduce repetitive data cleaning code into easy to use functions compatible with tidy data philosophy.

The user can use the devtools package to install the development version:

## devtools is required
library(devtools)
install_github("kevinrpan/handy")

Note: Windows users need devtools to install this way.

There are common steps that a data analyst faces:

Import (messy) data
Clean messy data
Describe cleaned data
Plot cleaned data
Model data
Write output tables

This package aims to facilitate this basic data handling.

These functions are ones that I've found handy.

| handy Function | Use Case | Description | |-------------------|--------------|----------------------| | clean_names | Clean Data | Normalize variable names of a data.frame to snake_case | | title_names | Clean Data | Normalize variable names of a data.frame to Title Case | | remove_columns | Clean Data | Removes columns that are either missing or non-unique | | add_mean_row | Describe Data | Add a mean row to a data.frame of numeric values | | add_total_row | Describe Data | Add a total row to a data.frame of numeric values | | check_variables | Describe Data | Calculate % missing and number of unique values for all variables | | %p% | Shorthand | Allow string concatenation by piping | | cs | Shorthand | Makes a character vector without quotes | | named_list | Shorthand | Makes a named list using object names | | multiplot | Plotting | Arrange multiple plots | | scale_x_human | Plotting | Scales ggplot axis to easily readable K, M, B, etc. | | scale_y_human | Plotting | Scales ggplot axis to easily readable K, M, B, etc. | | write_excel | Write Output | Write a list of data.frames in R to named sheets in an Excel workbook | | write_regression_to_excel | Write Output | Write a list of data.frames in R to named sheets in an Excel workbook |