Icon

04 Numbers Strings and Rules

04 Numbers Strings and Rules
Exercise: Numbers, Strings, and Rules1.1) Read the airlines data by executing the CSV Reader node below1.2) Change Name to all upper case.1.3) Replace country of "United States" with "USA"1.4) Complete the tasks above with the Column Expressions node2.1) Read the airports data by executing CSV Reader node below2.2) Calculate the mean of the Altitudes2.3) Convert the absolute altitude change values into percentages: divide them by the altitudemean values and multiply the result by 100.2.4) Create a categorical column of North American timezones airlines.csvUpper case Namereplace United States w/ USAsame tasks as abovecalculate the meanof altitudealtitude over the meandetermine North Americantimezonesairports.csv CSV Reader String Manipulation String Manipulation Column Expressions Math Formula Math Formula Rule Engine CSV Reader Exercise: Numbers, Strings, and Rules1.1) Read the airlines data by executing the CSV Reader node below1.2) Change Name to all upper case.1.3) Replace country of "United States" with "USA"1.4) Complete the tasks above with the Column Expressions node2.1) Read the airports data by executing CSV Reader node below2.2) Calculate the mean of the Altitudes2.3) Convert the absolute altitude change values into percentages: divide them by the altitudemean values and multiply the result by 100.2.4) Create a categorical column of North American timezones airlines.csvUpper case Namereplace United States w/ USAsame tasks as abovecalculate the meanof altitudealtitude over the meandetermine North Americantimezonesairports.csv CSV Reader String Manipulation String Manipulation Column Expressions Math Formula Math Formula Rule Engine 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-10-09
On NodePit since: 2022-01-24
Last update: 2024-04-27
Created with KNIME version: v4.5.0
Tags: data manipulationtransformationrule enginemath formulastring manipulationcolumn 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!