R Scripts

R is an open source programming language and software environment for statistical computing that is supported by the R Foundation for Statistical Computing. R is an interpreted language. The interpreter executes the program directly, translating each statement into a sequence of one or more subroutines already compiled into machine code.

Script Interface

Scripts are written in R. Every script must contain:

dataSetMatrixInput
dataSetMatrixOutput

Where dataSetMatrixInput is an R-matrix converted from the input Data Table.

  • All Iotellect numeric data types (e.g. integer, double or long) and Date type are converted to the R double type.
  • All Iotellect string and color types are converted to the R character type.
  • Every nested Data Table will be converted into a nested R matrix.

During transformation of a Data Table into R-matrix, all column names remain the same. In an R-matrix, number of rows and columns correspond the number of Data Table records and fields respectively.

The result of execution must be assigned to dataSetMatrixOutput.

Usage of some R-libraries may cause an unpredictable behavior during script execution.

Script Template

When a new script is created, its text is not empty. It contains an auto-generated code with two variables:

dataSetMatrixInput #Input Parameters (Matrix)

dataSetMatrixOutput = dataSetMatrixInput #Output Parameters (Matrix)

To execute R scripts your OS should have "R_HOME" environment variable. Also Windows users should set "PATH" variable to contain the path to specific R version binary files.

R Linux Integration Guide

Use this instruction for download and install R. For communication between the Iotellect and R additional libraries should be installed. Use this instruction to install and prepare rJava.

To configure R before installation, use command: R CMD javareconf.

Copy "libjri.so" file from "$R_HOME/library/jri/" into Iotellect Server "lib" directory.

Script Example

R Script Example:

dataSetMatrixInput #Input Parameters (Matrix)
dp = double(5)
dp[1] = 1
dp[2] = 2
dp[3] = 3
dp[4] = 4
dp[5] = 5
strs = c("str1", "str2", "str3")
rMatrix = matrix(list(),nrow = 1,ncol = 2)
rMatrix[[1,1]] = dp
rMatrix[[1,2]] = strs
colnames(rMatrix) = c("numericField","characterField")
df = as.data.frame(rMatrix)
dataSetMatrixOutput = rMatrix #Output Parameters (Matrix)

Was this page helpful?