Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Numeric Outliers
NodeNode / Manipulator

Numeric Outliers

Analytics Statistics
Drag & drop
Like
Copy short link

This node detects and treats the outliers for each of the selected columns individually by means of interquartile range (IQR) .

To detect the outliers for a given column, the first and third quartile (Q 1 , Q 3 ) is computed. An observation is flagged an outlier if it lies outside the range R = [Q 1 - k(IQR), Q 3 + k(IQR)] with IQR = Q 3 - Q 1 and k >= 0. Setting k = 1.5 the smallest value in R corresponds, typically, to the lower end of a boxplot's whisker and largest value to its upper end.
Providing grouping information allows to detect outliers only within their respective groups.

If an observation is flagged an outlier, one can either replace it by some other value or remove/retain the corresponding row.

Missing values contained in the data will be ignored, i.e., they will neither be used for the outlier computation nor will they be flagged as an outlier.

Node details

Input ports
  1. Type: Table
    Input data
    Numeric input data to evaluate + optional group information
Output ports
  1. Type: Table
    Treated table
    Data table where outliers were either replaced or rows containing outliers/non-outliers were removed
  2. Type: Table
    Summary
    Data table holding the number of members, i.e., non-missing values and outliers as well as the lower and upper bound for each outlier groups
  3. Type: Outlier
    Numeric outliers model
    Model holding the permitted interval bounds for each outlier group and the outlier treatment specifications

Extension

The Numeric Outliers node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Numeric Outliers simple example
    IQR Numeric Outliers Outlier
    This node shows how KNIME can identify outliers using the standard approach with Interqua…
    scottf > Public > ForumWorkflows > 2020 > 01 > Numeric_Outliers_Simple_Example
  2. Go to item
    ITSCM774-_Assignment 3
    petersonsm99 > ITSCM 774 Team 1 > Assignment 3 > Assignment 3 - questions 2 & 3
  3. Go to item
    2019_03_08_PMMLCompare
    iris > Public > 02_ForumExamples > 2019_03_08_PMMLCompare
  4. Go to item
    Dimensionality Reduction & Outlier Detection
    TheGuideBook Outliers Outlier detection
    +6
    This workflow processes the adult dataset, containing people demographics, by eliminating…
    knime > Academic Alliance > Guide to Intelligent Data Science > Example Workflows > Chapter6 > 01_Column_Row_Filtering
  5. Go to item
    Histogram
    tana > Public > Histogram
  6. Go to item
    KNIME_training_2
    KNIME Ebook - basic
    barbora > Public > KNIME_training_folder > KNIME_training_2
  7. Go to item
    Segmenting Consumers
    adm > Public > Workflows > Data Analytics Made Easy > Chapter 5 > Segmenting Consumers
  8. Go to item
    COV771-Iris
    vitorhugoma > Public > COV771-Iris
  9. Go to item
    Just KNIME it 29
    Justknimeit-29
    berti093 > Public > Just KNIME it 29
  10. Go to item
    Statistics, data distribution, outliers and data normalization
    Univariate Visualization Visualize
    +16
    This exercise goes through statistics, data distribution, outilers and different scales. …
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_10.2020 > L4-DV Codeless Data Exploration and Visualization - Exercises > solutions > 03. Box Plot and Statistics - solution
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits