Icon

03 Row and Column Filtering

03 Row and Column Filtering
Exercise: Column Filtering1) Read the adult_education.table file by executing the Table Reader node2) Exclude the "education-num" column- manually- by including only string type columns Exercise: Row Filtering1) Read the adult.csv file by executing the File Reader node2) Filter out rows where the marital status is missing3) Extract rows where - the marital status is divorced- the marital status is never married and age is between 20 and 40 (both included)- the workclass starts with "S"5) How many adults are- divorced?- never married?- never married and between 20 and 40 years old?- with work class State-gov, Self-emp-not-inc, or Self-emp-inc? Read adult.csvRead adult_education.table File Reader Table Reader Exercise: Column Filtering1) Read the adult_education.table file by executing the Table Reader node2) Exclude the "education-num" column- manually- by including only string type columns Exercise: Row Filtering1) Read the adult.csv file by executing the File Reader node2) Filter out rows where the marital status is missing3) Extract rows where - the marital status is divorced- the marital status is never married and age is between 20 and 40 (both included)- the workclass starts with "S"5) How many adults are- divorced?- never married?- never married and between 20 and 40 years old?- with work class State-gov, Self-emp-not-inc, or Self-emp-inc? Read adult.csvRead adult_education.table File Reader Table Reader

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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2021-04-25
Last update: 2024-05-03
Created with KNIME version: v4.2.3
Tags: row filtercolumn filter

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

Try NodePit Runner!