Icon

Group 6 KNIME final workflow

Exploration
Pre-processing
Data partitioning and sampling
Feature preparation
Random forest training
Gradient boosting validation and important metrics
Decision tree training
Logistic regression training
Gradient boosting training
Random forest validation and important metrics
Decision tree validation and important metrics
Logistic regression validation and important metrics
Comparing the performance metrics of the models
Champion model testing and important metrics
Instructions on how to use the nodes in the four "[Model name] validation and important metrics" boxes. 1. These boxes contain all the necessary nodes to evalute the performance of a model. Hence, you still need to do all the work of preparation, training, and so on. 2. You need to make sure the "[Model Name] Predictor" nodes are set up as follows (so that the metanode that computes the F2 score can read them): Gradient Boosted Trees Predictor: - Tick all boxes in the Prediction Settings menu.- The prediction column name is "Prediction (GB)".- The suffix for proability columns is "GB". Decision Tree Predictor:- Maximum number of stored patterns is 20,000. - Tick all boxes in the Options menu. - The prediction column name is "Prediction (DT)"- The suffix for probability columns is "DT". Random Forest Predictor:- Tick all boxes in the Prediction settings menu except "Use soft voting".- The prediction column name is "Prediction (RF)".- The suffix for proability columns is "RF". Logistic Regression Predictor: - Tick all boxes in the Settings menu.- The prediction column name is "Prediction (LR)".- The suffix for probability columns is "LR".
If you encounter a problem with the meta node for F2 score, open it and follow the instructions. Do not take for granted that the Lift chart, ROC curve, and Scorer nodes are properly set.
If you encounter a problem with the meta node for F2 score, open it and follow the instructions. Do not take for granted that the Binary Classification Inspector and Line Plot (JavaScript) nodes are properly configured.
Upload the score data set to predict the missing target variable with the champion model.
Feature preparation
Do not train the model again: use the trained champion model to predict new data.
Make sure to prepare the data in the exact same way as the other partitions. Do not sample and partition this data set. Do not train the model again: use the trained champion model to predict new data.
Make sure that the Binary Classification Inspector node only includes: - "Gradient boosting" - "Random forest" - "Decision tree" - "Logistic regression"
Selecting best F2 cut-off
Top k Row Filter
Lift Chart (JavaScript) (legacy)
Joiner
ROC Curve (JavaScript) (legacy)
Gradient Boosted Trees Predictor
Generating F2
Precision & Recall
ROC Curve (JavaScript) (legacy)
Lift Chart (JavaScript) (legacy)
Statistics
Adjust prediction based on cutoff value of your champion AI model
Column Expressions (legacy)
Scorer (JavaScript)
Gradient Boosted Trees Predictor
Number to String
Linear Correlation
Box Plot (JavaScript) (legacy)
Confusion matrix and ROC
Binary Classification Inspector
Scorer (JavaScript)
Column Filter
Scorer (JavaScript)
Scorer (JavaScript)
Rule Engine
select top 3 models based on f2 score
Top k Row Filter
Scorer (JavaScript)
Missing Value
Normalizer
auto_claims.csv (Data set for training, validation, and testing)
CSV Reader
auto_claims_score.csv (Data set for scoring)
CSV Reader
SMOTE
Create an Excel file with the model's outputs
Excel Writer
Selecting best F2 cut-off
Top k Row Filter
Lift Chart (JavaScript) (legacy)
Validation
Logistic Regression Predictor
Missing Value
Math Formula
ROC Curve (JavaScript) (legacy)
Normalizer
Lift & Gain table
RowID
Validation
Gradient Boosted Trees Predictor
Rule Engine
Validation
Random Forest Predictor
Column Filter
Rule Engine
Math Formula
lift chart
Line Plot (JavaScript) (legacy)
Generating F2
Precision & Recall
Rule Engine
Lift Chart (JavaScript) (legacy)
Table Partitioner
Selecting best F2 cut-off
Top k Row Filter
Number to String
ROC Curve (JavaScript) (legacy)
Histogram
Table Partitioner
Logistic Regression Learner
Generating F2
Precision & Recall
Gradient Boosted Trees Learner
Decision Tree Learner
Random Forest Learner
Extract Header & Transpose
Sert Color
Binary Classification Inspector
Replace P (fraud =1) with model name
Column Renamer
Generating F2
Precision & Recall
Selecting best F2 cut-off
Top k Row Filter
Lift Meta node
Precision & Recall
Lift Chart (JavaScript) (legacy)
Validation
Decision Tree Predictor
Joiner
ROC Curve (JavaScript) (legacy)
Joiner

Nodes

Extensions

Links