An RStudio Addin for Editing A ‘data.frame’ (original) (raw)

editData

The ‘editData’ is an RStudio addin for editing a ‘data.frame’ or a ‘tibble’. Many RStudio users want to edit a data.frame. With this ‘editData’ package, you can delete, add or update a ‘data.frame’ without coding. You don’t have to use Microsoft excel or a csv editor any more to edit data. You can get resultant data as a ‘tibble’ or as a ‘data.frame’. You can read a csv file in the disk and save it as a csv format.

Install package

You can install editData package from CRAN.

install.packages("editData")

You can install the developmental version of editDatapackage from github.

#install.packages("devtools")
devtools::install_github("cardiomoon/editData")

After install this editData package you can see theeditData addin in RStudio’s addins. (See the second plot).

Usage: As an RStudio Add-in

This addin can be used to interactively manipulate adata.frame or a tibble. The intended way to use this is as follows:

1. Highlight a symbol naming a data.frame or atibble in your R session, e.g. mtcars(1).

1. Execute this addin(arrow), to interactively manipulate it.

1. You can select and unselect a row by clicking a row in dataTable. You can delete the selected row(1), add a new row(2) or edit a row(3).

You can enter data name(4) to edit, upload a CSV or excel or RDS file(5) and download the edited data as a csv(6) or xlsx(7) or RDS (8)file.

1. If you press the edit button you can see this window. You can edit individual cell. You can delete the row or update the data. Or you can edit cell by double-click.

1. Alternatively, you can edit a cell by double-click.

1. By default, the sampleData included in theeditData package is selected. The sex andbloodType column are factor variables. AselectInput is assigned for a column of class factor.

1. A dateInput is assigned for a column of classdate.

Usage: As a regular function

You can use the editData() function as a regular function, e.g. in a command line.

require(editData)
result <- editData(mtcars)

The resultant ‘tibble’ or ‘data.frame’ is assigned to the objectresult.

Usage: As a shiny module

The editData package is made of modularized shiny functions. You can use the modularized editableDTUI() andeditableDT() functions in your shiny app. In this package, I have included three examples in the inst folder. You can run these examples with one of the following codes.

shiny::runApp(system.file('example',package='editData'))
shiny::runApp(system.file('multipleData',package='editData'))
shiny::runApp(system.file('multipleFiles',package='editData'))