Icon

03 Row and Column Filtering

Exercise for 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 reader nodes below2) Filter the population data to countries in Europe. Which country in Europe has the most inhabitants in 2019? Whichcountry has the least? Russia/Vatican City3) Filter the life expectancy data to countries/regions where the overall life expectancy is at least 80 years. How manycountries/regions are they? 33 countries/regions4) Filter the travel advisory data to the safest countries (Level 1: Exercise normal precautions). Was your home countrysafe to travel to in October 2020? No Demographics.sqliteLifeExpectancydemographics.xlsx(population)demographics.xlsx( life_expectancy)travel_advidories.csvEuropeoverall life expectancy>= 80countries w/Level 1: Exercise normal precautionsExclude Rank (manually)Exclude Rank (include strings and doubles)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 reader nodes below2) Filter the population data to countries in Europe. Which country in Europe has the most inhabitants in 2019? Whichcountry has the least? Russia/Vatican City3) Filter the life expectancy data to countries/regions where the overall life expectancy is at least 80 years. How manycountries/regions are they? 33 countries/regions4) Filter the travel advisory data to the safest countries (Level 1: Exercise normal precautions). Was your home countrysafe to travel to in October 2020? No Demographics.sqliteLifeExpectancydemographics.xlsx(population)demographics.xlsx( life_expectancy)travel_advidories.csvEuropeoverall life expectancy>= 80countries w/Level 1: Exercise normal precautionsExclude Rank (manually)Exclude Rank (include strings and doubles)SQLite 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

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-04-20
On NodePit since: 2023-04-14
Last update: 2024-05-01
Created with KNIME version: v4.7.0
Tags: row filtercolumn filterdata manipulation

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

Try NodePit Runner!