Icon

JKISeason2-5-tark

Challenge 05: Rank Countries by Air Quality and Water Pollution
Level: Easy

Description: Earth Day just passed and we need to raise awareness for air quality and water pollution. In this context, you decide to explore a 2020 dataset in which users voted about air quality and water pollution for a number of different cities. The scale for air quality goes from 0 (bad quality) to 100 (top quality), and the scale for water pollution also goes from 0 (no pollution) to 100 (extreme pollution). Your task is to rank and visualize the top 10 countries twice with different criteria: first, based on how bad the air quality is; and second, based on how polluted the water is.

Expand the componentNode 1(By country)medianmeancity countscity counts(median and mean)Air QualityWater QualityAscendingby meanthen by medianDescendingby meanthen by medianFilter by the num of citiesFilter by the num of citiesNode 13Node 14(All the coutries)medianmeancity countsMean and Medianall the countriesNode 24Node 26Node 27Node 33Node 36Node 37Node 38Air QuallityWater Quallityinput valuefor filtering Node 42Node 44CSV Reader GroupBy GroupBy Column Filter Column Filter Sorter Sorter Row Filter Row Filter Column Rename Column Rename GroupBy Table View Column Appender Unpivoting Cell Splitter Column Rename Column Resorter Column Rename Pivoting Table View Table View Integer Widget RefreshButton Widget Component CSV Reader Expand the componentNode 1(By country)medianmeancity countscity counts(median and mean)Air QualityWater QualityAscendingby meanthen by medianDescendingby meanthen by medianFilter by the num of citiesFilter by the num of citiesNode 13Node 14(All the coutries)medianmeancity countsMean and Medianall the countriesNode 24Node 26Node 27Node 33Node 36Node 37Node 38Air QuallityWater Quallityinput valuefor filtering Node 42Node 44CSV Reader GroupBy GroupBy Column Filter Column Filter Sorter Sorter Row Filter Row Filter Column Rename Column Rename GroupBy Table View Column Appender Unpivoting Cell Splitter Column Rename Column Resorter Column Rename Pivoting Table View Table View Integer Widget RefreshButton Widget Component CSV Reader

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: seavi
Created at: 2023-05-01
On NodePit since: 2023-05-02
Last update: 2024-11-21
Created with KNIME version: v4.6.0
Tags: JKISeason2-5Just KNIME It

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

Try NodePit Runner!