Icon

Solution1

Solution 1

Solution 1


• exclude rows where marital-status is missing.
• On the remaining rows:
• extract rows where marital-status = "Never-married"
• extract rows where marital-status = "Divorced" AND 20 <= age <= 40 AND workclass
starts with "S"
• remove column "marital-status
• keep only column "marital-status"
• keep only String columns using a Column Filter node and then only column "marital-status"
using a Reference Column Filter node

reading adult.csvremove missing marital-status rowsmarital-status = "Never-married"remove "marital-status"only "marital-status"combine with reference tablereference Tableonly string columnsworkclassstart with Smarital-status =" Divorced" age <= 40 age >= 20File Reader Row Filter Row Filter Column Filter Column Filter ReferenceColumn Filter Table Creator Column Filter Row Filter Row Filter Row Filter reading adult.csvremove missing marital-status rowsmarital-status = "Never-married"remove "marital-status"only "marital-status"combine with reference tablereference Tableonly string columnsworkclassstart with Smarital-status =" Divorced" age <= 40 age >= 20File Reader Row Filter Row Filter Column Filter Column Filter ReferenceColumn Filter Table Creator Column Filter Row Filter Row Filter Row Filter

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: byasar
Created at: 2020-04-11
On NodePit since: 2020-04-24
Last update: 2024-04-25
Created with KNIME version: v4.1.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!