Icon

03_​Outlier_​Detection

Outlier Detection - exercise
Exercise: Outlier DetectionSome houses might be special cases in terms of size, price, and the year when they were sold or built. Let's clean the data from thesehouses in order to build a better model!1) Remove houses that have a sales price lying outside the interquartile range of all sales prices (Numeric Outlier node)- Select the "SalePrice" column- Set the interquartile range parameter to 1.52) Optional: Remove the 5 % of the houses that are the most extreme in terms of size (Normalizer and Rule-based Row Filter nodes)- Normalize the "Lot Area" column using z-score- Filter out houses whose normalized lot size is outside the range [-1.96, 1.96] Numeric Outliers Optional: Outliers in Distribution Tails Read AmesHousing.csv Missing ValueHandling Preprocessing CSV Reader Exercise: Outlier DetectionSome houses might be special cases in terms of size, price, and the year when they were sold or built. Let's clean the data from thesehouses in order to build a better model!1) Remove houses that have a sales price lying outside the interquartile range of all sales prices (Numeric Outlier node)- Select the "SalePrice" column- Set the interquartile range parameter to 1.52) Optional: Remove the 5 % of the houses that are the most extreme in terms of size (Normalizer and Rule-based Row Filter nodes)- Normalize the "Lot Area" column using z-score- Filter out houses whose normalized lot size is outside the range [-1.96, 1.96] Numeric Outliers Optional: Outliers in Distribution Tails Read AmesHousing.csv Missing ValueHandling Preprocessing CSV 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: Emilio Silvestri
Created at: 2019-11-29
On NodePit since: 2022-11-15
Last update: 2024-04-27
Created with KNIME version: v4.6.1
Tags: data manipulationpreprocessingoutlier detectionz-scoreDBSCANclustereducation

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

Try NodePit Runner!