How to build a stacking regressor in Knime?

[HY_Z]

The regressor may have a few base models, such as a linear regressor, a tree model…

Any existing workflow can be referred to?

[Daniel_Weikert]

I am not aware of a workflow example but in general i assume you first do predictions for the individual models then use column appender (or similar to combine the predictions and then use another linear learner with the predictions as features and the original target column for your prediction
br

[mlauber71]

@HY_Z H2O.ai Automl would support stacked models. You can use the KNIME node:

H2O AutoML for Regression – knime

Or you could use the packages wrapped with a R or Python node in KNIME which gives you more flexibility concerning the settings:

H2O.ai AutoML in KNIME for regression problems

H2O.ai Automl - a powerful auto-machine-learning framework wrapped with KNIME It features various models like Random Forest or XGBoost along with Deep Learning. It has wrappers for R and Python but also could be used from KNIME. The results will be written to a folder and the models will be stored in MOJO format to be used in KNIME (as well as on a Big Data cluster via Sparkling Water). One major parameter to set is the running time the model has to test various models and do some hyperparam…

[HY_Z]

thanks for the info. Unluckily I dont have H2O.auto ML.

[HY_Z]

thanks for the idea. Will try.

[mlauber71]

@HY_Z

Unluckily I dont have H2O.auto ML.

Well you have if you install the KNIME H2O Machine Learning Integration – KNIME Community Hub with the H2O AutoML Learner (Regression) – KNIME Community Hub

https://docs.knime.com/latest/analytics_platform_installation_guide/index.html#_installing_extensions_and_integrations

[HY_Z]

thanks. will check. does that mean we can use H2O extension node even when we dont have H2O model?

[mlauber71]

@HY_Z I am not 100% sure I understand what you are asking. YOu can use the H2O.ai implementation in KNIME and build models and use them. H2O also does have a commercial product the models of which would not be compatible to be used with the free version.

Maybe you check the examples and try to describe in more details what you want to do.

[HY_Z]

@mlauber71: Thanks a lot. I download one example which uses H2O auto.ml and have a try just now. Amazing, my own data can be linked to the H2O.automl learner node and the regression model can be built.

will continue to try the stacking regression function.

[mlauber71]

@HY_Z

Amazing, my own data can be linked to the H2O.automl learner node and the regression model can be built.

Amazing, isn’t it handling and analysing data and building models and so on is the whole point about knime.

If you want to learn more about knime and machine learning you might want to check these resources.

Knime-based machine learning course?

First there is the ML learning part of the official course of KNIME Then you could check out the KNIME press if you like more reading about things: This entry could also be relevant for you. It will also point you to the (free) Udemy course which also has a part on machine learning: Then well I will point you to two entries about some automatic machine learning with the help of KNIME and R or Python an H2O.ai since I think this will become more relevant in the future and you would have a…

Machine Learning Meta Collection (with KNIME) – mlauber71

[HY_Z]

@mlauber71 thanks for the explanation. The meta collection is with a lot of topics. will go through. thank you.