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.
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
:
::install_github("DillonHammill/rhandsontable") devtools
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.
dialog
box,
browser
or RStudio viewer
pane)read.csv()
)write.csv()
)bslib
packagedataSelect
moduledataFilter
moduleA 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
<- data_edit(mtcars,
mtcars_new save_as = "mtcars_new.csv")
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.
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.
If you use DataEditR in your work, please cite the package as follows:
citation("DataEditR")
#>
#> To cite package 'DataEditR' in publications use:
#>
#> Dillon Hammill (2022). DataEditR: An Interactive Editor for Viewing,
#> Entering, Filtering & Editing Data. R package version 0.1.5.
#> 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 = {2022},
#> note = {R package version 0.1.5},
#> url = {https://github.com/DillonHammill/DataEditR},
#> }