Icon

03 Row and Column Filtering

03 Row and Column Filtering
Exercise: Column Filtering1) Read the life expectancy data from the SQLite database by executing the nodes below2) Exclude the Rank column- manually- by including only string and double type columns Exercise: Row Filtering1) Read the population, life expectancy, and travel advisory data by executing the readernodes below2) Filter the population data to countries in Europe. Which country in Europe has the mostinhabitants in 2019? Which country has the least? 3) Filter the life expectancy data to countries/regions where the overall life expectancy is atleast 80 years. How many countries/regions are they?4) Filter the travel advisory data to the safest countries (Level 1: Exercise normalprecautions). Was your home country safe to travel to in October 2020? Demographics.sqliteLifeExpectancydemographics.xlsx(population)demographics.xlsx(life_expectancy)travel_advidories.csvNode 31Node 32Node 33manualInclude SQLite Connector DB Table Selector Excel Reader Excel Reader DB Reader CSV Reader Row Filter Row Filter Row Filter Column Filter Column Filter Exercise: Column Filtering1) Read the life expectancy data from the SQLite database by executing the nodes below2) Exclude the Rank column- manually- by including only string and double type columns Exercise: Row Filtering1) Read the population, life expectancy, and travel advisory data by executing the readernodes below2) Filter the population data to countries in Europe. Which country in Europe has the mostinhabitants in 2019? Which country has the least? 3) Filter the life expectancy data to countries/regions where the overall life expectancy is atleast 80 years. How many countries/regions are they?4) Filter the travel advisory data to the safest countries (Level 1: Exercise normalprecautions). Was your home country safe to travel to in October 2020? Demographics.sqliteLifeExpectancydemographics.xlsx(population)demographics.xlsx(life_expectancy)travel_advidories.csvNode 31Node 32Node 33manualIncludeSQLite Connector DB Table Selector Excel Reader Excel Reader DB Reader CSV Reader Row Filter Row Filter Row Filter Column Filter Column Filter

Nodes

Extensions

Links