R to Table

Converts a data frame from an R workspace into a KNIME data table. The result data is returned at the data out-port. Please, use the variable name knime.out for the data frame.

More details about R:
http://www.r-project.org/
Short-refcard.pdf

Options

R Snippet

R Script

The R commands to run. The data frame that should appear at the output is expected to be stored in knime.out.

The node also allows to access and modify flow variables. You can access all flow variables at knime.flow.in and please add all new or modified flow variables to the list at knime.flow.out.

Examples

Take the input "data" and send it to the output:

knime.out <- data.frame(data)

Read the data from the file defined by the flow variable fname:

data <- read.table(knime.flow.in[["fname"]])

Compute students t-test and store the p-value in the flow variable p.value:

h <- t.test(knime.in["d"])
knime.flow.out <- list(p.value = h[["p.value"]])

Flow Variable List

The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).

Templates

Category - Title

A categorized list of R script templates. The apply button at the left will replace the R script and guide you to the R Snippet tab.

Please use "Create Template..." button on the R Snippet tab to add the current R script to the list of templates.

Advanced

NaNs

Convert NaN and +/-Infinity output to missing cells. Enable this for backwards compatibility with the behavior before version 2.10.

Overwrite default path to R home

Check this option to select a path to the home of a R installation that is different from the path configured on the R preference page. The path must point to the root folder of the R installation tree.

Input Ports

R Input

Output Ports

Data Table Output

Views

R Std Output

The text sent to standard out during the execution of R executable as well as the text of the .Rout file generated by R.

R Error Output

The text sent to standard error during the execution of R executable as well as the text of the .Rout file generated by R. (If it appears in gray, it's the output of a previously failing run which is preserved for your trouble shooting.)

Best Friends (Incoming)

• Table to R (31 %) 
• R To R (21 %) 
• Add Table To R (19 %) 
• R Source (Workspace) (16 %) 
• R Learner (7 %) 
• Show all 41 recommendations

Best Friends (Outgoing)

• Joiner (10 %) 
• CSV Writer (7 %) Streamable
• R Snippet (5 %) 
• R View (Table) (4 %) 
• Column Filter (4 %) Streamable
• Show all 240 recommendations

Workflows

• 05_​Predict_​DepartureDelays_​with_​MicrosoftR (KNIME Hub) 
• CalibraCurve-v.2.0.knwf 1 (KNIME Hub) 
• CV tonini (KNIME Hub) 
• kn_​automl_​h2o_​classification_​python (KNIME Hub) 
• kn_​automl_​h2o_​classification_​python_​vtreat (KNIME Hub) 
• Show all 20 workflows

Installation

To use this node in KNIME, install KNIME Interactive R Statistics Integration from the following update site:

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.