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.

Input Ports

: Table from which columns are filtered.

Output Ports

: Table without selected columns matching the criterion regarding missing values.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland

Plugin version: 5.3.3.v202410291553

On NodePit since: 2024-07-09

Last update: 2024-11-21

KNIME versions: Since v3.6

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

Try NodePit Runner!