Icon

02 Cleaning and Standardization

Task 1: Row Filtering Task 2: Column Filtering Note: I am using adult_education.table from the Lab Exercisefor this task since no other table was provided. Task 3: Data Transformation Filter out rows where the InternetService is missingDSLWorkclass starts with "F"No InternetWA_Fn-UseC_-Telco-Customer-Churn.csvExclude education and IDmanuallyExclude education and IDby type selectionRead adult_education.tableCreate status: High/LowReplace "-"by "" in the nativecontract column"Difference" column (total charges - monthly charges)Complete the same tasks as above Row Filter Row Filter Row Filter Row Filter CSV Reader Column Filter Column Filter Table Reader Rule Engine String Manipulation Math Formula Column Expressions Task 1: Row Filtering Task 2: Column Filtering Note: I am using adult_education.table from the Lab Exercisefor this task since no other table was provided. Task 3: Data Transformation Filter out rows where the InternetService is missingDSLWorkclass starts with "F"No InternetWA_Fn-UseC_-Telco-Customer-Churn.csvExclude education and IDmanuallyExclude education and IDby type selectionRead adult_education.tableCreate status: High/LowReplace "-"by "" in the nativecontract column"Difference" column (total charges - monthly charges)Complete the same tasks as above Row Filter Row Filter Row Filter Row Filter CSV Reader Column Filter Column Filter Table Reader Rule Engine String Manipulation Math Formula Column Expressions

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: Administrator
Created at: 2023-02-21
On NodePit since: 2023-02-26
Last update: 2024-04-27
Created with KNIME version: v4.7.0

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

Try NodePit Runner!