Icon

03_​DB_​Modelling

03 DB Modelling Exercise
Exercise: 03_DB_Modelling We start from 2 data sets extracted from the ss13pme table in the newCensus.sqlite database. 1. Train a decision tree on COW where COW is NOT NULL 2. apply decision tree to predict COW value on rows with MISSING COW value 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 NULL SQLite Connector DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter DB Reader Number To String DB Reader Exercise: 03_DB_Modelling We start from 2 data sets extracted from the ss13pme table in the newCensus.sqlite database. 1. Train a decision tree on COW where COW is NOT NULL 2. apply decision tree to predict COW value on rows with MISSING COW value 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 NULLSQLite Connector DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter DB Reader Number To String DB Reader

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-27
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!