Icon

04 Data Transformation

Exercise for transforming data.

Perform data transformations with the Rule Engine, Math Formula, and String Manipulation nodes, or alternatively, with the Column Expressions node.










Exercise: Data Transformation1) Read the adult.csv file by executing the CSV Reader node2) Create a new column "work-status" with the value "full-time" if the weekly working hours are >=40 and "part-time"otherwise3) Replace the hyphen in "United-States" by a space character in the "native-country" column4) Create a new column "year-of-birth" by substracting the age number from 1994, which is the year when the datawere collected 5) OPTIONAL: Replicate the tasks 3 & 4 with the Column Expressions node6) Take a look at the first row in the data table (ID 177) after completing the data transformation operations. What is thework status, native country, and year of birth of this person? Customer Data.CSVCreates Column "Long-term customer"Contract column, replace "-" with "" Same tasks as aboveTax Amount Column CSV Reader Rule Engine String Manipulation Column Expressions Math Formula Exercise: Data Transformation1) Read the adult.csv file by executing the CSV Reader node2) Create a new column "work-status" with the value "full-time" if the weekly working hours are >=40 and "part-time"otherwise3) Replace the hyphen in "United-States" by a space character in the "native-country" column4) Create a new column "year-of-birth" by substracting the age number from 1994, which is the year when the datawere collected 5) OPTIONAL: Replicate the tasks 3 & 4 with the Column Expressions node6) Take a look at the first row in the data table (ID 177) after completing the data transformation operations. What is thework status, native country, and year of birth of this person? Customer Data.CSVCreates Column "Long-term customer"Contract column, replace "-" with "" Same tasks as aboveTax Amount Column CSV Reader Rule Engine String Manipulation Column Expressions Math Formula

Nodes

Extensions

Links