Icon

03_​DB_​Modelling

03 DB Modelling Exercise Solution
Missing Values Strategy: 03_Modelling This workflow implements a predictor for the COW class of the newCensus.sqlite dataset. 1. It connects to the newCensus.sqlite database (SQLite) to read the ss13pme table 2. filters data through in-database manipulation 3. trains and applies a decision tree to fix COW values where missing newCensus.sqliteselect * from ss13pmeremovePUMA* &PWGTP*COW is not NULLCOW is NULLremove COWimport all rows where COW is NOT NULLCOW to stringimport all rows whereCOW is NULLpredict COWappend predictedCOW column SQLite Connector DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter DB Reader Number To String DB Reader DecisionTree Learner Decision TreePredictor Missing Values Strategy: 03_Modelling This workflow implements a predictor for the COW class of the newCensus.sqlite dataset. 1. It connects to the newCensus.sqlite database (SQLite) to read the ss13pme table 2. filters data through in-database manipulation 3. trains and applies a decision tree to fix COW values where missing newCensus.sqliteselect * from ss13pmeremovePUMA* &PWGTP*COW is not NULLCOW is NULLremove COWimport all rows where COW is NOT NULLCOW to stringimport all rows whereCOW is NULLpredict COWappend predictedCOW columnSQLite Connector DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter DB Reader Number To String DB Reader DecisionTree Learner Decision TreePredictor

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: koetter
Created at: 2015-07-31
On NodePit since: 2020-04-22
Last update: 2024-04-20
Created with KNIME version: v4.3.0
Tags: Big DataEducation

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

Try NodePit Runner!