Icon

04 Data Transformation

04 Data Transformation
Exercise: Data Transformation1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Create a new column "MonthlyChargeCategory" with the value "<50" if the MonthlyCharge is <50, with the value ">100" if the MonthlyCharge is>100 otherwise "50-100"3) Create a new column "NumMonths" with the value of 1 for "Monthly", 12 for "One year" and 24 for "Two year" from the "Contract" column.4) Replace "Month-to-month" as "Monthly" in the "Contract" column5) Create a new column "ContractCost" by multiplying the MonthlyCharge with NumMonths.6) OPTIONAL: Replicate the tasks 3 & 4 with the Column Expressions node telco-customer-churn.csvcreate "MonthlyChargeCategory" columnreplace "Month-to-month" w/ "Monthly"create "ContractCost"columnreplace "Month-to-month" w/ "Monthly"and create "ContractCost" columncreate "NumMonths"column CSV Reader Rule Engine String Manipulation Math Formula Column Expressions Rule Engine Exercise: Data Transformation1) Read the telco-customer-churn.csv file by executing the CSV Reader node2) Create a new column "MonthlyChargeCategory" with the value "<50" if the MonthlyCharge is <50, with the value ">100" if the MonthlyCharge is>100 otherwise "50-100"3) Create a new column "NumMonths" with the value of 1 for "Monthly", 12 for "One year" and 24 for "Two year" from the "Contract" column.4) Replace "Month-to-month" as "Monthly" in the "Contract" column5) Create a new column "ContractCost" by multiplying the MonthlyCharge with NumMonths.6) OPTIONAL: Replicate the tasks 3 & 4 with the Column Expressions node telco-customer-churn.csvcreate "MonthlyChargeCategory" columnreplace "Month-to-month" w/ "Monthly"create "ContractCost"columnreplace "Month-to-month" w/ "Monthly"and create "ContractCost" columncreate "NumMonths"column CSV Reader Rule Engine String Manipulation Math Formula Column Expressions Rule Engine

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-04-28
Created with KNIME version: v4.5.1
Tags: rule enginestring manipulationmath formulacolumn expressions

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

Try NodePit Runner!