Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Missing Value
NodeNode / Manipulator

Missing Value

Manipulation Column Transform
Drag & drop
Like
Copy short link

This node helps handle missing values found in cells of the input table. The first tab in the dialog (labeled "Default") provides default handling options for all columns of a given type. These settings apply to all columns in the input table that are not explicitly mentioned in the second tab, labeled "Individual". This second tab permits individual settings for each available column (thus, overriding the default). To make use of this second approach, select a column or a list of columns which needs extra handling, click "Add", and set the parameters. Click on the label with the column name(s), will select all covered columns in the column list. To remove this extra handling (and instead use the default handling), click the "Remove" button for this column.
Options marked with an asterisk (*) will result in non-standard PMML. If you select such an option, the warning label in the dialog will become red and a warning will be shown during execution of the node. Non-standard PMML uses extensions that cannot be read by other tools than Knime.

Node details

Input ports
  1. Type: Table
    Input table
    Table with missing values
Output ports
  1. Type: Table
    Output table
    Table with replaced missing values
  2. Type: PMML
    PMML Transformations
    Table with PMML documenting the missing value replacement

Extension

The Missing Value node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    knime > Education > Self-Paced Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 08 Regression Model
  2. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    malgorzatagirda > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 08 Regression Model
  3. Go to item
    HW2Q1
    mserdar > Public > HW2Q1
  4. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    deborah_santos > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 08 Regression Model
  5. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    sawskyowl > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 08 Regression Model
  6. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    cfds > Public > L1-DS-Basics > Exercises > 08 Regression Model
  7. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    cfds > L1-DS-Basics > L1-DS-Basics > Exercises > 08 Regression Model
  8. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    teekay > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 08 Regression Model
  9. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    data24 > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 08 Regression Model
  10. Go to item
    08 Regression Model
    R-squared Error metric Linear regression
    Exercise for training a model for numeric prediction. Train and apply a linear regression…
    ramneek_kalra > Public > Exercises > 08 Regression Model
  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