Icon

Annual MAE comparison

Pre-processing - Convert weather data type to string - Join product data and weather data - Reserve 90% of the rows for model training and remaining for model testing Score the ModelEvaluate predictions Train a ModelTree Learner for training Data Reading Two files: Product "Boulette -Imbiss, Pack= 30 St.170g" +Weather data Reserve 90% of the rows for model training and remaining for model testingJoin product data and weather dataAdjust data typeAdjust data typeProduct dataWeather dataFiltering columswithout useLearning on Menge kgTesting knowledge onMenge kgResultspredictionvs.original dataAdjust datatype"Schneeböhe"column includes "-", in need fora string replacerto convert themto 0Resultspredictionvs.original dataLearning on Menge kgTesting knowledge onMenge kg"Datum" toDate&TimetypeCopies column values from preceding rows into the current rowSort by"Datum" Reserve 90% of the rows for model training and remaining for model testingTesting knowledge onMenge kgLearning on Menge kgResultspredictionvs.original data Reserve 90% of the rows for model training and remaining for model testingWeather dataAdjust datatype"Schneeböhe"column includes "-", in need fora string replacerto convert themto 0Join product data and weather dataAdjust data typeAdjust data typeProduct dataFiltering columswithout useWeather dataAdjust datatype"Schneeböhe"column includes "-", in need fora string replacerto convert themto 0Join product data and weather dataAdjust data typeAdjust data typeProduct dataFiltering columswithout use" Jahr" fromInteger toString"Jahr" fromInteger toString"Jahr" fromInteger toStringNode 182Node 183Node 184Node 185Node 186Node 188Node 189Node 190Node 192Node 194Node 195 Forward FeatureSelection Partitioning Joiner Date&Time to String Date&Time to String Excel Reader Excel Reader Column Filter Simple RegressionTree Learner Simple RegressionTree Predictor Numeric Scorer String To Number String Replacer Numeric Scorer Gradient Boosted TreesLearner (Regression) Gradient Boosted TreesPredictor (Regression) String to Date&Time Lag Column Sorter Partitioning Gradient Boosted TreesPredictor (Regression) Gradient Boosted TreesLearner (Regression) Numeric Scorer Partitioning Excel Reader String To Number String Replacer Joiner Date&Time to String Date&Time to String Excel Reader Column Filter Excel Reader String To Number String Replacer Joiner Date&Time to String Date&Time to String Excel Reader Column Filter Bar Chart Line Plot Number To String Bar Chart Line Plot Number To String Bar Chart Line Plot Number To String Column Appender Column Filter Column Filter Column Filter Column Appender Bar Chart Column Rename Column Rename Column Rename Math Formula Math Formula Math Formula Pre-processing - Convert weather data type to string - Join product data and weather data - Reserve 90% of the rows for model training and remaining for model testing Score the ModelEvaluate predictions Train a ModelTree Learner for training Data Reading Two files: Product "Boulette -Imbiss, Pack= 30 St.170g" +Weather data Reserve 90% of the rows for model training and remaining for model testingJoin product data and weather dataAdjust data typeAdjust data typeProduct dataWeather dataFiltering columswithout useLearning on Menge kgTesting knowledge onMenge kgResultspredictionvs.original dataAdjust datatype"Schneeböhe"column includes "-", in need fora string replacerto convert themto 0Resultspredictionvs.original dataLearning on Menge kgTesting knowledge onMenge kg"Datum" toDate&TimetypeCopies column values from preceding rows into the current rowSort by"Datum" Reserve 90% of the rows for model training and remaining for model testingTesting knowledge onMenge kgLearning on Menge kgResultspredictionvs.original data Reserve 90% of the rows for model training and remaining for model testingWeather dataAdjust datatype"Schneeböhe"column includes "-", in need fora string replacerto convert themto 0Join product data and weather dataAdjust data typeAdjust data typeProduct dataFiltering columswithout useWeather dataAdjust datatype"Schneeböhe"column includes "-", in need fora string replacerto convert themto 0Join product data and weather dataAdjust data typeAdjust data typeProduct dataFiltering columswithout use" Jahr" fromInteger toString"Jahr" fromInteger toString"Jahr" fromInteger toStringNode 182Node 183Node 184Node 185Node 186Node 188Node 189Node 190Node 192Node 194Node 195 Forward FeatureSelection Partitioning Joiner Date&Time to String Date&Time to String Excel Reader Excel Reader Column Filter Simple RegressionTree Learner Simple RegressionTree Predictor Numeric Scorer String To Number String Replacer Numeric Scorer Gradient Boosted TreesLearner (Regression) Gradient Boosted TreesPredictor (Regression) String to Date&Time Lag Column Sorter Partitioning Gradient Boosted TreesPredictor (Regression) Gradient Boosted TreesLearner (Regression) Numeric Scorer Partitioning Excel Reader String To Number String Replacer Joiner Date&Time to String Date&Time to String Excel Reader Column Filter Excel Reader String To Number String Replacer Joiner Date&Time to String Date&Time to String Excel Reader Column Filter Bar Chart Line Plot Number To String Bar Chart Line Plot Number To String Bar Chart Line Plot Number To String Column Appender Column Filter Column Filter Column Filter Column Appender Bar Chart Column Rename Column Rename Column Rename Math Formula Math Formula Math Formula

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Jannis
Created at: 2022-01-03
On NodePit since: 2022-02-25
Last update: 2024-11-24
Created with KNIME version: v4.5.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!