Icon

06 Aggregations

06 Aggregations - Solution
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? not applicable from lab data Average changeby continentMin and max life expectancyCount by Airline IDNumber of countriesby continent and directionAirlinesGroupBy GroupBy GroupBy Pivoting Population data CSV Reader 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? not applicable from lab data Average changeby continentMin and max life expectancyCount by Airline IDNumber of countriesby continent and directionAirlinesGroupBy GroupBy GroupBy Pivoting Population data CSV Reader

Nodes

Extensions

Links