Icon

06 Aggregations

06 Aggregations
Exercise: Aggregations1.1) Read the life expectancy data by executing the Excel Reader node below1.2) Calculate the number of countries by rank. Which rank is shared by 5 countries?1.3) Calculate the minimum and maximum overall life expectancy in the data2.1) Read the population data by executing the metanode below2.2) Calculate the average change of population in each UN continental region. Is theaverage change negative in any continental region?2.3) Create a pivot table that shows the number of countries by UN continental region anddirection. In how many countries in Europe is the population increasing? Exercise: Aggregations1.3) Calculate the minimum and maximum overall life expectancy in the data I coudn't figure out the best way to translate these instructions into this data, so I instead did a few countsand other aggregations How would I go about finding the average amount of airports held by a country?as in, "on average countries have x number of airports" Did I do it correctly? Airports DataNumber of Airports Worldwide?Average Amount of Airports in a Country? CSV Reader GroupBy GroupBy Exercise: Aggregations1.1) Read the life expectancy data by executing the Excel Reader node below1.2) Calculate the number of countries by rank. Which rank is shared by 5 countries?1.3) Calculate the minimum and maximum overall life expectancy in the data2.1) Read the population data by executing the metanode below2.2) Calculate the average change of population in each UN continental region. Is theaverage change negative in any continental region?2.3) Create a pivot table that shows the number of countries by UN continental region anddirection. In how many countries in Europe is the population increasing? Exercise: Aggregations1.3) Calculate the minimum and maximum overall life expectancy in the data I coudn't figure out the best way to translate these instructions into this data, so I instead did a few countsand other aggregations How would I go about finding the average amount of airports held by a country?as in, "on average countries have x number of airports" Did I do it correctly? Airports DataNumber of Airports Worldwide?Average Amount of Airports in a Country? CSV Reader GroupBy GroupBy

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-05-03
Created with KNIME version: v4.5.0
Tags: aggregategroupbypivot

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

Try NodePit Runner!