Icon

Air_​03

Task 1: Aggregate data with the GroupBy node1. Read the life expectancy data by executing the provided Excel Reader node2. Calculate the number of countries by rank3. Calculate the minimum and maximum overall life expectancy in the data Task 2: Aggregate data with the Pivoting node1. Read the population data by executing the provided metanode2. Create a pivot table that shows the number of countries by the UN continental region anddirection. (The direction indicates if the population is increasing or decreasing.) Task 3: Join tables1. Read the population, life expectancy, geo coordinates, and travel advisories data by executing the providedreader nodes2. Join all tables based on the names of the countries. Use inner join.3. Edit the following country names in the travel advisories table manually with the Table Editor node: (Thespelling in the other tables is shown in brackets)- The Gambia (Gambia)- Guinea Bissau (Guinea-Bissau)- The Bahamas (Bahamas) airlines.xlsxPopulationairlines.xlsxLife_expectancyManual manipulationMin and max life expectancyCount by RankNumber of countriesby continent and directiongeo_coordinates.tableInner join on country nameInner join on country nameInner join on country nameairlines.xlsxLife_expectancyNode 44 Excel Reader Excel Reader Table Editor GroupBy GroupBy Pivoting Population data Table Reader Joiner Joiner Joiner Excel Reader Excel Reader Task 1: Aggregate data with the GroupBy node1. Read the life expectancy data by executing the provided Excel Reader node2. Calculate the number of countries by rank3. Calculate the minimum and maximum overall life expectancy in the data Task 2: Aggregate data with the Pivoting node1. Read the population data by executing the provided metanode2. Create a pivot table that shows the number of countries by the UN continental region anddirection. (The direction indicates if the population is increasing or decreasing.) Task 3: Join tables1. Read the population, life expectancy, geo coordinates, and travel advisories data by executing the providedreader nodes2. Join all tables based on the names of the countries. Use inner join.3. Edit the following country names in the travel advisories table manually with the Table Editor node: (Thespelling in the other tables is shown in brackets)- The Gambia (Gambia)- Guinea Bissau (Guinea-Bissau)- The Bahamas (Bahamas) airlines.xlsxPopulationairlines.xlsxLife_expectancyManual manipulationMin and max life expectancyCount by RankNumber of countriesby continent and directiongeo_coordinates.tableInner join on country nameInner join on country nameInner join on country nameairlines.xlsxLife_expectancyNode 44Excel Reader Excel Reader Table Editor GroupBy GroupBy Pivoting Population data Table Reader Joiner Joiner Joiner Excel Reader 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-11-14
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!