Refining Data Table Using a Set of Formulas

A tool for refining data frame with formulas.


This package provides an easy way to refine data table. For example, you want to apply complex formulas such as (yen.dollar + dollar.yen) / (yen.exchange.rate) to data table? Maintaining those formulas can be hard, and oftenly maintained in Excel sheet, not R code. The package aims to solve this difficulty, and you can refine any data table with a formula table.

You can install this package from github with

devtools::install_github("zedoul/refnr")

You can refine a data table as follows:

head(iris)
 
#>     Sepal.Length Sepal.Width Petal.Length Petal.Width Species
#>   1          5.1         3.5          1.4         0.2  setosa
#>   2          4.9         3.0          1.4         0.2  setosa
#>   3          4.7         3.2          1.3         0.2  setosa
#>   4          4.6         3.1          1.5         0.2  setosa
#>   5          5.0         3.6          1.4         0.2  setosa
#>   6          5.4         3.9          1.7         0.4  setosa
 
library(refnr)
formulas <- rbind(c(Name = "Length",
                    Formula = "Sepal.Length + Petal.Length"),
                  c(Name = "Width",
                    Formula = "Sepal.Width + Petal.Width"))
res <- refnr(iris, formulas)
head(res)
 
#>    Length Width
#>  1    6.5   3.7
#>  2    6.3   3.2
#>  3    6.0   3.4
#>  4    6.1   3.3
#>  5    6.4   3.8
#>  6    7.1   4.3

News

Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("refnr")

0.1.0 by Kim Seonghyun, 3 years ago


https://github.com/zedoul/refnr


Report a bug at https://github.com/zedoul/refnr/issues


Browse source code at https://github.com/cran/refnr


Authors: Kim Seonghyun [aut, cre]


Documentation:   PDF Manual  


Apache License 2.0 | file LICENSE license


Suggests testthat


See at CRAN