Interactive Column Filter

Based on the "official" Interactive Column Filter" https://hub.knime.com/knime/spaces/Examples/latest/00_Components/Guided%20Analytics/Interactive%20Column%20Filter~tMMYYJy4AK3mv4u-
However if the correlation can be calculated, then it will be shown as missing instead of 100%

This Component creates an interactive view to filter and select columns for your model based on the relevance of the columns to the ground truth specified. It also captures the user specified columns by means of integrated deployment.

SET COLUMN RELEVANCE FILTER
Column Relevance is an overall metric summarizing the metrics belows. Use the slider to select the input features based on their Overall Column Relevance.
The additional metrics calculated automatically and used to determine Overall Column Relevance include:

- ID/Noise Test: measures how likely the column is a representation used to identify each row in your table. Row identifiers are uninformative for your model and should be removed.

- Constant Value: Test measures how often the column contains the exact same value. Columns with just a constant value also carry no information. You should avoid using them.

- Missing Value Test: measures the percentage of missing values in a column over the entire dataset. You should remove features with a percentage of missing values too high.

By using the slider, columns can be excluded from model training based on their column relevance. Furthermore you can use the linear correlation between each column and the column to predict to refine your input set.

- Correlation with Target: measures the linear correlation with the column the model will predict: Income. It is important to keep in mind if a feature is highly or poorly correlated. If you have high correlation (close to + or - 100%) this will help the model to achieve a good performance, unless the column has too many unique values (e.g. an high ID/Noise Test). If instead you have low correlation (close to 0%), you might exclude the feature in exchange for a faster training of the model. Be aware that very highly correlated columns can also be the result of the target column.

MANUALLY SELECT COLUMNS
You can use the Column Relevance Filter - but you don't have to. Alternatively, you can remove individual columns manually in the Data Explorer table in the lower part of this page. This table allows you to explore both numeric and nominal columns. Clicking on a column name will provide additional information about the data in that column, for example statistics and histogram showing their distribution. Remember that the final set of columns to be excluded will be the unique set produced by both the Column Relevance Filter and the Manually Select Columns.

Options

Target Column:
Select with this setting which column you want to predict and should not be interactively excluded by the user.

Input Ports

Icon
Data with input feature columns and ground truth for your model.

Output Ports

Icon
Data interactively filtered by the user.
Icon
Workflow captured with integrated deployment to automatically re-exclude those same columns in other workflows or branches of this same workflow.

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2022-09-24
Last update: 2024-04-26
Created with KNIME version: v4.5.1

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

Try NodePit Runner!