Icon

Julie's workflow

Data Preparation External Data Integration Model Evaluation Modeling Modelling Model Evaluation Reading data Convert String to DoubleStatistical OverviewNode 4Node 5Node 6Node 7Insert Month and Day of Week as Columns Remove columnsthat contain morethan 50% missing valuesSet missing values:(1) string to "unknown"(2) number to the mean(3) type date&timeremove rows that have missing values Restrict to rows with DC 79Convert String to DateConvert String to TimeJoint the datasetsbased on last date columnWeather datasetConvert String to TimePartition the data into a training set (70%) and test setNode 59Predicted Cycle TImeSubset data ofactual and predicted cycle time (LR)Line PlotNode 63Node 64Node 65Node 66Calculate accuracyfor decision treeSubset data of actualand predicted cycle time (RF)Line PlotScore the regression predictionSubset data ofactual and predicted cycle time (LR)Line PlotScore the regression predictionScore the regression predictionReplace Missing Values for the Booleans "Rejected","LZV", "Conveyor", "Fast Lane" and "Promo" with "False"Remove rows with cycle time between 0 and 5Node 79String value "Rejected" to BooleanRemove rows with cycle time between 0 and 5Only include the Short bin rowsNode 83Node 84Partition the data into a training set (70%) and test setNode 86Node 87Node 88Node 89Primary School Holiday dataJoint the datasetsbased on last date columnNode 92Node 93Calculate accuracyfor decision treeCalculate accuracyfor decision tree Excel Reader String To Number Statistics Box Plot (local) ConditionalBox Plot Scatter Plot(local) Linear Correlation Extract Date&TimeFields Missing ValueColumn Filter Missing Value Row Filter String to Date&Time String to Date&Time Joiner Excel Reader String to Date&Time Partitioning Linear RegressionLearner RegressionPredictor Column Filter Line Plot (local) Simple RegressionTree Learner Simple RegressionTree Predictor Random Forest Learner(Regression) Random Forest Predictor(Regression) Scorer (deprecated) Column Filter Line Plot (local) Numeric Scorer Column Filter Line Plot (local) Numeric Scorer Numeric Scorer Missing Value Row Filter Numeric Binner String Manipulation Row Filter Row Filter DecisionTree Learner Decision TreePredictor Partitioning Decision TreePredictor DecisionTree Learner Scorer Scorer Excel Reader Joiner Statistics Linear Correlation Scorer (deprecated) Scorer (deprecated) Data Preparation External Data Integration Model Evaluation Modeling Modelling Model Evaluation Reading data Convert String to DoubleStatistical OverviewNode 4Node 5Node 6Node 7Insert Month and Day of Week as Columns Remove columnsthat contain morethan 50% missing valuesSet missing values:(1) string to "unknown"(2) number to the mean(3) type date&timeremove rows that have missing values Restrict to rows with DC 79Convert String to DateConvert String to TimeJoint the datasetsbased on last date columnWeather datasetConvert String to TimePartition the data into a training set (70%) and test setNode 59Predicted Cycle TImeSubset data ofactual and predicted cycle time (LR)Line PlotNode 63Node 64Node 65Node 66Calculate accuracyfor decision treeSubset data of actualand predicted cycle time (RF)Line PlotScore the regression predictionSubset data ofactual and predicted cycle time (LR)Line PlotScore the regression predictionScore the regression predictionReplace Missing Values for the Booleans "Rejected","LZV", "Conveyor", "Fast Lane" and "Promo" with "False"Remove rows with cycle time between 0 and 5Node 79String value "Rejected" to BooleanRemove rows with cycle time between 0 and 5Only include the Short bin rowsNode 83Node 84Partition the data into a training set (70%) and test setNode 86Node 87Node 88Node 89Primary School Holiday dataJoint the datasetsbased on last date columnNode 92Node 93Calculate accuracyfor decision treeCalculate accuracyfor decision tree Excel Reader String To Number Statistics Box Plot (local) ConditionalBox Plot Scatter Plot(local) Linear Correlation Extract Date&TimeFields Missing ValueColumn Filter Missing Value Row Filter String to Date&Time String to Date&Time Joiner Excel Reader String to Date&Time Partitioning Linear RegressionLearner RegressionPredictor Column Filter Line Plot (local) Simple RegressionTree Learner Simple RegressionTree Predictor Random Forest Learner(Regression) Random Forest Predictor(Regression) Scorer (deprecated) Column Filter Line Plot (local) Numeric Scorer Column Filter Line Plot (local) Numeric Scorer Numeric Scorer Missing Value Row Filter Numeric Binner String Manipulation Row Filter Row Filter DecisionTree Learner Decision TreePredictor Partitioning Decision TreePredictor DecisionTree Learner Scorer Scorer Excel Reader Joiner Statistics Linear Correlation Scorer (deprecated) Scorer (deprecated)

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: marienguyen
Created at: 2023-05-15
On NodePit since: 2023-05-22
Last update: 2024-04-28
Created with KNIME version: v4.7.2

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

Try NodePit Runner!