Customer prediction with H2O in KNIME

The purpose of this workflow is to showcase the ease of use of the H2O functionalities from within KNIME. As a real world usecase we chose the "Restaurant Visitor Forecasting" competition on Kaggle.com: https://www.kaggle.com/c/recruit-restaurant-visitor-forecasting

The workflow contains the following steps:
- Data preparation: Reading, cleaning, joining data and feature creation
- Creation of a local H2O context and transformation of a KNIME data table into an H2O frame
- Modeling of three different models including cross validation and parameter optimization
- Selection of the best model
- Deployment: Converting the H2O model into an H2O MOJO and doing the prediction for the Kaggle competition

Feel free to create some more features and try additional parameters in the optimization loop to improve your predictions.

For legal reasons we are not allowed to ship the dataset from Kaggle with our workflow. To get access to the data you have to sign in to Kaggle and accept the conditions of participation for the competetion. Afterwards you can download the data, save it in the data folder of this KNIME project and run the workflow.

External resources

• Solving a Kaggle challenge with KNIME and H2O
• Kaggle competition