DataEditR

Project Status: Active – The project has reached a stable, usable state and is being actively developed. Lifecycle: stable R build status CRAN status CRAN_Download_Badge

Manual data entry and editing in R can be tedious, especially if you have limited coding experience and are accustomed to using software with a Graphical User Interface (GUI). DataEditR is an R package built on shiny and rhandsontable that makes it easy to interactively view, enter, filter and edit data. If you are new to DataEditR visit https://dillonhammill.github.io/DataEditR/ to get started.

Installation

DataEditR can be installed from CRAN:

install.packages("DataEditR")

The development version of DataEditR can be installed directly from GitHub:

library(devtools)
install_github("DillonHammill/DataEditR")

To ensure that DataEditR works as expected, you will also need to install my fork of rhandsontable:

devtools::install_github("DillonHammill/rhandsontable")

Usage

DataEditR ships with a series of shiny modules, namely dataInput, dataSelect, dataFilter, dataEdit and dataOutput which have been wrapped up into a single function called data_edit() to create an interactive data editor. You can use data_edit() as a standalone application, or include the relevant modules within your own shiny applications. Alternatively, DataEditR also ships with an RStudio add-in should you prefer to interact with it in this way.

General features:

Data editing features:

A quick demonstration of some of these features can be seen below, where we use data_edit() to make changes to the mtcars dataset and save the result to a new csv file:

# Load required packages
library(DataEditR)

# Save output to R object & csv file
mtcars_new <- data_edit(mtcars,
                        save_as = "mtcars_new.csv")

Credits

DataEditR is built using the fantastic rhandsontable package. DataEditR makes use of many features for entering and editing data, but rhandsontable has support for much more sophisticated interactive representations of data should you need them. The user interface of DataEditR has been inspired by the editData package which is a great alternative to DataEditR.

Code of Conduct

Please note that the DataEditR project is released with a Contributor Code of Conduct. By contributing to this project, you agree to abide by its terms.

Citation

If you use DataEditR in your work, please cite the package as follows:

citation("DataEditR")
#> 
#> To cite package 'DataEditR' in publications use:
#> 
#>   Dillon Hammill (2021). DataEditR: An Interactive Editor for Viewing,
#>   Entering, Filtering & Editing Data. R package version 0.1.3.
#>   https://github.com/DillonHammill/DataEditR
#> 
#> A BibTeX entry for LaTeX users is
#> 
#>   @Manual{,
#>     title = {DataEditR: An Interactive Editor for Viewing, Entering, Filtering & Editing Data},
#>     author = {Dillon Hammill},
#>     year = {2021},
#>     note = {R package version 0.1.3},
#>     url = {https://github.com/DillonHammill/DataEditR},
#>   }