Missing Value Column Filter

The node tests each selected column for missing values and removes the column if it meets the specified condition about the number of missing values. Each column that is not selected for the test is passed on to the output unconditionally.

Options

Input columns

Select the columns to test for missing values.

Remove columns

Specify the threshold for the removal of selected columns.

• With at least one missing value: Remove the column if it contains at least one missing value.
• With only missing values: Remove the column if it contains only missing values.
• By percentage of missing values: Remove the column if it contains at least the configured percentage of missing values.
• By number of missing values: Remove the column if it contains at least the configured number of missing values.

Threshold percentage (equal or more than %)

Selected columns with at least this percentage of missing values are filtered out.

Threshold number (equal or more than)

Selected columns with at least this number of missing values are filtered out.

Views

This node has no views

Workflows

• 00 Data GenerationKNIME Hub
• 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
• 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
• 00_xplan sf dbconv-insert via xport-AccountKNIME Hub
• 01 Train a Feed Forward Neural NetworkKNIME Hub
• Show all 557 workflows

Links

• put an xml and csv file togehterby armingrudd on 2019-07-16

  forum.knime.com/p/65637
• excluding columns with ‘NaN’by aworker on 2023-02-20

  forum.knime.com/p/194186
• Keep only cells with value in a table with multiple columnsby armingrudd on 2019-04-29

  forum.knime.com/p/59672
• Filter out categorical fieldsby HansS on 2019-07-14

  forum.knime.com/p/65351
• Automating Column Selection based on Statistics node output?by HansS on 2022-05-16

  forum.knime.com/p/157019

Developers