Icon

KNIME_​Model

Read data.csvTemperature DataRead Temperature.csvRead Holidays.csvAdd month namesAv. monthly temp.2014-2015Group by yearPivot on monthCalculate meansSort on monthYear filterUsage DataYear filterGroup by yearPivot on monthCalculate meansLookup tablefor month numberto name conversionAdd month namesMonthly elec. usage2014-2015Sort on monthCalculate sum of usage per 24 hoursCombine day, month & yearDay, month & year to stringDay, month & year to stringDay, month & year to stringCombine day, month & yearCombine day, month & yearConvert to dateConvert to dateConvert to dateData w/ holiday & temp. infoTemp. data 2014-2015Temp. column2014-2015Model learnerModel predictorSimple regression tree plotRow ID's holidays 2014-2015Data with holiday columnPattern of dataModel learnerModel predictorPolynomial regression plotData 2014-2015 w/ max elec. valueLookup tablefor month numberto name conversionTesting regressiontreeTesting polynomialregressionSplit in train/test dataCSV Reader File Reader CSV Reader CSV Reader Cell Replacer GroupBy Bar Chart(JFreeChart) Pivoting Column Resorter Row Filter File Reader Row Filter Pivoting Table Creator Cell Replacer GroupBy Bar Chart(JFreeChart) Column Resorter Column Aggregator Column Combiner Number To String Number To String Number To String Column Combiner Column Combiner String to Date&Time String to Date&Time String to Date&Time Column Appender Rule-basedRow Filter Column Filter Simple RegressionTree Learner Simple RegressionTree Predictor Scatter Plot Joiner Rule Engine Scatter Plot PolynomialRegression Learner RegressionPredictor Scatter Plot Column Aggregator Table Creator Numeric Scorer Numeric Scorer X-Partitioner Read data.csvTemperature DataRead Temperature.csvRead Holidays.csvAdd month namesAv. monthly temp.2014-2015Group by yearPivot on monthCalculate meansSort on monthYear filterUsage DataYear filterGroup by yearPivot on monthCalculate meansLookup tablefor month numberto name conversionAdd month namesMonthly elec. usage2014-2015Sort on monthCalculate sum of usage per 24 hoursCombine day, month & yearDay, month & year to stringDay, month & year to stringDay, month & year to stringCombine day, month & yearCombine day, month & yearConvert to dateConvert to dateConvert to dateData w/ holiday & temp. infoTemp. data 2014-2015Temp. column2014-2015Model learnerModel predictorSimple regression tree plotRow ID's holidays 2014-2015Data with holiday columnPattern of dataModel learnerModel predictorPolynomial regression plotData 2014-2015 w/ max elec. valueLookup tablefor month numberto name conversionTesting regressiontreeTesting polynomialregressionSplit in train/test dataCSV Reader File Reader CSV Reader CSV Reader Cell Replacer GroupBy Bar Chart(JFreeChart) Pivoting Column Resorter Row Filter File Reader Row Filter Pivoting Table Creator Cell Replacer GroupBy Bar Chart(JFreeChart) Column Resorter Column Aggregator Column Combiner Number To String Number To String Number To String Column Combiner Column Combiner String to Date&Time String to Date&Time String to Date&Time Column Appender Rule-basedRow Filter Column Filter Simple RegressionTree Learner Simple RegressionTree Predictor Scatter Plot Joiner Rule Engine Scatter Plot PolynomialRegression Learner RegressionPredictor Scatter Plot Column Aggregator Table Creator Numeric Scorer Numeric Scorer X-Partitioner

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: s164579
Created at: 2020-03-04
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.1.1

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

Try NodePit Runner!