Icon

03 Row and Column Filtering

03 Row and Column Filtering
Exercise: Column Filtering1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Exclude the non-string columns- manually- by including only string type columns Exercise: Row Filtering1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Filter out rows where the internet service is missing3) Extract rows where - the internet service is DSL and monthly charge is between 20 and 50 (both included)- the internet service is Fiber optic- the contract ends with "Year"5) How many adults are- using Fiber optic? 3,096- DSL? 2,421- DSL and monthly charge between 20 and 50? 773- with yearly contract? 3,168 telco-customer-churn.csvexclude missinginternet serviceinternet service= Fiber Opticscontractendswithyearinternet service= DSLmonthly chargesbetween20 and 50exclude non-string columnsby type selectionexclude non-string columnsmanuallytelco-customer-churn.csv CSV Reader Row Filter Row Filter Row Filter Row Filter Row Filter Column Filter Column Filter CSV Reader Exercise: Column Filtering1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Exclude the non-string columns- manually- by including only string type columns Exercise: Row Filtering1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Filter out rows where the internet service is missing3) Extract rows where - the internet service is DSL and monthly charge is between 20 and 50 (both included)- the internet service is Fiber optic- the contract ends with "Year"5) How many adults are- using Fiber optic? 3,096- DSL? 2,421- DSL and monthly charge between 20 and 50? 773- with yearly contract? 3,168 telco-customer-churn.csvexclude missinginternet serviceinternet service= Fiber Opticscontractendswithyearinternet service= DSLmonthly chargesbetween20 and 50exclude non-string columnsby type selectionexclude non-string columnsmanuallytelco-customer-churn.csv CSV Reader Row Filter Row Filter Row Filter Row Filter Row Filter Column Filter Column Filter CSV 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: 2022-02-26
Last update: 2024-05-05
Created with KNIME version: v4.5.1
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!