Icon

Air_​02

Task 1: Filter rows1. Read the population, life expectancy, and travel advisory data by executing the providedreader nodes2. Filter the population data to countries in Europe3. Filter the life expectancy data to countries/regions where the overall life expectancy is atleast 80 years4. Filter the travel advisory data to the safest countries (Level 1: Exercise normalprecautions) Task 4: Evaluate mathematical expressions and apply rules1. Read the population data by executing the provided Excel Reader node2. Create a new column "Change" by subtracting the population values in 2018 from thepopulation values in 20193. Convert the absolute population change values into percentages: Divide them by the populationvalues in 2018. Multiply the result by 100.4. Create a categorical column with two values "increasing"/"decreasing" based on whether thechange is positive or negative airlines.xlsxPopulationairlines.xlsxLife_expectancyConvert change topercentageAdd Direction columnbased on +/- changeoverall life expectancy >=80EuropeCreate Changecolumnairlines.xlsxPopulation Excel Reader Excel Reader Math Formula Rule Engine Row Filter Row Filter Math Formula Excel Reader Task 1: Filter rows1. Read the population, life expectancy, and travel advisory data by executing the providedreader nodes2. Filter the population data to countries in Europe3. Filter the life expectancy data to countries/regions where the overall life expectancy is atleast 80 years4. Filter the travel advisory data to the safest countries (Level 1: Exercise normalprecautions) Task 4: Evaluate mathematical expressions and apply rules1. Read the population data by executing the provided Excel Reader node2. Create a new column "Change" by subtracting the population values in 2018 from thepopulation values in 20193. Convert the absolute population change values into percentages: Divide them by the populationvalues in 2018. Multiply the result by 100.4. Create a categorical column with two values "increasing"/"decreasing" based on whether thechange is positive or negative airlines.xlsxPopulationairlines.xlsxLife_expectancyConvert change topercentageAdd Direction columnbased on +/- changeoverall life expectancy >=80EuropeCreate Changecolumnairlines.xlsxPopulation Excel Reader Excel Reader Math Formula Rule Engine Row Filter Row Filter Math Formula Excel 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: lisah
Created at: 2023-01-21
On NodePit since: 2023-01-23
Last update: 2024-05-01
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!