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? Rank 161.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 the averagechange negative in any continental region? No, the change is positive for all regions.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? 30 countries demographics.xlsx(life_expectancy)number of countries by rankmin/max for overalllife expectancyavg change of pop.for UN continental region# of countries byUN region and direction Excel Reader Population data GroupBy GroupBy GroupBy Pivoting 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? Rank 161.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 the averagechange negative in any continental region? No, the change is positive for all regions.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? 30 countries demographics.xlsx(life_expectancy)number of countries by rankmin/max for overalllife expectancyavg change of pop.for UN continental region# of countries byUN region and direction Excel Reader Population data GroupBy GroupBy GroupBy Pivoting

Nodes

Extensions

Links