Getting summary.lm output from R into Report

[DieBuergschaft]

Hey there,

 

I'm trying for quite a while now to get the results of a linear regression done with R into a report. But the R snippet just accepts data.frames as an output and not the summary.lm.

 

is there another node that I have overseen so far which can solve this problem? Or a way to get the text from the "View R Std Output" into a report?

 

Best regards

[marco_ghislanzoni]

Hi,

it turns out it is possible by using the R capture.output() function and then type-casting its output to a data frame.

For example, assuming your input table has a X and Y columns, you can use an R Snippet node with this code:

  knime.out <- as.data.frame(capture.output(summary.lm(lm(knime.in$"Y" ~ knime.in$"X"))))

It will generate as output a KNIME table with each row being a line of the output of the summary.lm function. Once you have this table you can send it to a report easily with the Data to Report node. In the report you can display it as a Table. See the screenshot below. It actually looks pretty neat!

Cheers,
Marco.

• capture.png

[DieBuergschaft]

Hey Marco

Thank you very much for your answer! It was very helpful for me and works fine!

Best regards

DieBürgschaft