In nuhorchak/RClean: RClean, An Interactive Data Cleaning Tool

knitr::opts_chunk$set(echo = TRUE)

library(knitr)
library(readxl)

Section 1 Basic Information

1.1 Name

RClean

1.2 Title

RCleaner, an interactive data cleaning tool provides users the dynamic ability to import and clean data. At its core, it provides R users functionality similar to that of Microsoft Excel with regards to preparation of a dataset for analysis.

1.3 Description

1.3A Features

Utilizing R to import and clean data is often a time consuming task. Without preparation of the dataset in excel or other software, R users must use scripts or command line R code for this task. The Interactive Data Cleaning tool will afford users the ability to do the following:

• Initialize RCleaner gadget with a dataset
• Visually inspect the dataset called into the gadget
• Select data columns to remove
• Select data rows to remove
• Provide the ability to rename columns in the dataframe
• Provide the option to scale the data.
• Provide the option to mean center the data
• Provide the ability to encode nominal data to numerical data

1.3B End users

This analytic is being developed for those users in need of hasty data cleaning or those who would otherwise not wish to spend a large amount of time writing code to prepare data for analysis. Typical users will have working knowledge of R, however prefer the point and click abilities of Microsoft Excel or other similar software.

1.3C Required knowledge/skills

Users must be able to navigate R studio and understand how to use an R Gadget. In addition, they should be aware of the types of data contained in the dataset to be analyzed, whether numerical or categorical, such that they are aware of the application of some functions of this analytic tool.

1.3D Statistical methods utilized

• Mean center data
• Scale Data
• Generate indicator variables

1.3E R Packages utilized

This analytic will utilize the following existing R packages:

• shiny
• DT
• shinythemes
• markdown
• dummies

1.4 End user access

End users will call this gadget from the associated R package

1.5 Security concerns

None

1.6 Design constraints

Currently, the gadget only handles DF, matrix or tibble like objects with 2 or more columns. Single vectors are not handled.

Section 2 Delivery and Schedule Information

2.1 Feature Review

features <- read_excel("inst/features.xlsx")

kable(features, format = "markdown", booktabs = T, padding = 0)

nuhorchak/RClean documentation built on May 31, 2019, 2:50 p.m.