Forum
I’ve been using KNIME to Extract and transform PostgreSQL data but I find the KNIME graphics capabilities clunky and have been told I can integrate R (ggplot2 library) into my workflow. I’ve found a couple of resources (i.e. https://hub.knime.com/knime/spaces/Examples/latest/07_Scripting/02_R/01_Example_of_R_Snippet ) but am looking for the KNIME node that will read the database to get me started (accessing the DB).
Jeff
For the general access to a database you could use the KNIME DA Nodes:
https://docs.knime.com/2019-06/db_extension_guide/index.html
Then I have a few more examples of graphics using R and Python you might find useful.
R - multiple graphics
You could determine a local path and then tell R to save various graphics in a row. I attached an example workflow that does that. You might use that as a starter.
The R View shows one plot but saves more than one. I tried that with just a R scrip node but it gave me an error message.
library(ggplot2)
https://www.andrewheiss.com/blog/2016/12/08/save-base-graphics-as-pseudo-objects-in-r/
var_name_pdf_file <- paste0(knime.flow.in[[“var_path_graphic”]], “rplot.pdf”)
var_name_png_file <- paste0…
R - Venn Gram - Export graphics to PNG
I toyed around with Stephan Kolassa’s “Data Scientis Venn Diagram” and R. And I could bring it to PNG, although I do not claim to have fully grasped to construct a VennGram from scratch. Maybe it can serve as an inspiration …
The list of steps to compile Rserve on MacOS is in the blog entry .
[image]
kn_example_venn_gram.knwf (554.3 KB)
R - Heatmaps with Dendrograms
Python - some graphics from the Iris data set
2 Likes
ipazin
October 16, 2019, 1:47pm
3
Hi there @reichmaj ,
I know KNIME is missing some visualizations and features in existing ones but what is clunky about them?
Br,
Ivan
I simply am more comfortable with and like the power of R’s ggplot2
system
Closed
April 16, 2020, 8:52am
5
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.