Icon

20230220 Pikairos How to Exclude Numerical Columns with NaN values

This workflow shows how to filter out columns with at least one NaN value in their rows. The workflow answers the question asked by Vani_26 in forum thread number 62126.

The workflow achieves the task by converting first the NaN values into Missing Values and then using a -Missing Value Column Filter- node to filter out columns with Missing Values.

Convert NaNto Missing ValuesFilter Columnswith Missing ValuesSplit Columnsbased onReference Columnsin 2nd Input PortThis componentis just here toSimulate yourColumns withMissing ValuesMath Formula(Multi Column) Missing ValueColumn Filter ReferenceColumn Splitter Generate Dummy Columnswith NaN Values Convert NaNto Missing ValuesFilter Columnswith Missing ValuesSplit Columnsbased onReference Columnsin 2nd Input PortThis componentis just here toSimulate yourColumns withMissing ValuesMath Formula(Multi Column) Missing ValueColumn Filter ReferenceColumn Splitter Generate Dummy Columnswith NaN Values

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: Molina
Created at: 2023-02-20
On NodePit since: 2023-02-20
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: Math Formula (Multi Column)Reference Column Splitter

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

Try NodePit Runner!