Icon

ITSCM774_​TEAM7_​DELIV2

ID was unique so removedduplicates with ID Replace missing values: Academic Interest 1/2 -> UNK Contact Code 1 -> UNK IRSchool -> 0 telecq -> 0 avg_income -> mean distance -> mean sex -> mode ethnicity -> UNK satscore-> mean Replace Y/N with 1/0 for InState Check and Replace Outliers for income, distance, & satscore Address inconsistency with init span Create variable binary for if took sat Log transformation on avg income Imp.DATA_SETStatistics on whole setY/N to Binaryreplace missinginstate to numericConvert InStateReplace outliers 1.5 IQRinit_span < 0Remove dups. on IDif sat > 0 then 1 Else 0box plotspre outliersbox plots post outliersverify missingvaluesnormalized histogramlog transformation File Reader Statistics Table Creator Missing Value Cell Replacer Category To Number Numeric Outliers Rule Engine DuplicateRow Filter Rule Engine Box Plot Box Plot Statistics Statistics Math Formula ID was unique so removedduplicates with ID Replace missing values: Academic Interest 1/2 -> UNK Contact Code 1 -> UNK IRSchool -> 0 telecq -> 0 avg_income -> mean distance -> mean sex -> mode ethnicity -> UNK satscore-> mean Replace Y/N with 1/0 for InState Check and Replace Outliers for income, distance, & satscore Address inconsistency with init span Create variable binary for if took sat Log transformation on avg income Imp.DATA_SETStatistics on whole setY/N to Binaryreplace missinginstate to numericConvert InStateReplace outliers 1.5 IQRinit_span < 0Remove dups. on IDif sat > 0 then 1 Else 0box plotspre outliersbox plots post outliersverify missingvaluesnormalized histogramlog transformationFile Reader Statistics Table Creator Missing Value Cell Replacer Category To Number Numeric Outliers Rule Engine DuplicateRow Filter Rule Engine Box Plot Box Plot Statistics Statistics Math Formula

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: 19047
Created at: 2021-10-15
On NodePit since: 2021-10-16
Last update: 2024-11-23
Created with KNIME version: v4.4.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!