Icon

Just KNIME It _​ Challenge 007

Just KNIME It _ Challenge 007
Just KNIME It! - Challenge 7: Women in Government Description: In this challenge you will create one or more visualizations to inspect the percentual share of seats held by women in local government, as reported bythe United Nations Development Programme: Human Development Reports. The purpose of this report is to “ensure women's full and effectiveparticipation and equal opportunities for leadership at all levels of decision-making in political, economic and public life.” Since this is a real dataset therewill be missing values, and we expect you to augment the data via your own creativity. In particular, we ask that you not only report country specific databut also continent data. The true challenge here will be how you transform this incomplete dataset into one or more visualizations, and whichvisualizations you deem appropriate for this challenge. Challenge outline is as follows: 1.- Download the dataset and decide the most efficient way to bring it into KNIME 2.- Add a continent column using whatever method you think is most efficient 3.- Visualize the data (the KNIME solution will visualize both country and continent related data). KNIME Challengeprovided data Retrieve latest datafrom 'unstats.un.org'statistical Server Collect continentinformation from ISO3166 standard List of countries withinIndicator 5.5.1 (2) Add a continent column using whatever method you think is most efficient:Collect geographical information (1) DATASET: decide the most efficient way to bring it into KNIMEData query (latest data) from 'unstats.un.org' statistical Server (3) Visualize the data (the KNIME solution will visualize both country and continent related data):Generate dashboards and charts. Share of seats held by women in local government (%).csvat 'Current workflow data area'Exclude Header Top 6 RowsThis data won't be used further in the challengeURL:https://unstats.un.org/ [...] /5.5.1/Data Indicator 5.5.1, Series : Proportion of elected seats held by women in deliberative bodies of local government (%) SG_GEN_LOCGELSISO-3166-Countries-with-Regional-CodesJSON from:https://github.com/lukesquery valuesfrom JSONungroup column listsretrieve data from web servicequery valuesfrom JSONungroup column listsURL:https://unstats.un.org/ [...] /5.5.1/GeoAreasretrieve data from web servicequery valuesfrom JSONColumn Clean Upungroup column listsColumn Clean UpDiscriminate Countries fromgrouping RegionsCountry Query ListConvert geoAreaCodesto 3 charactersGenerate PathsList Generate Pages' PathsLoop Start by Data Pages (Country)Node 322Column Clean UpValues to NumericYear to IntegerArrange data by Country >> YearRank years with dataSelect latestyear dataSelect andkeep most recent data ONLYNode 335Node 336Merge unstats SDG-data with geo-dataEmpties ExcludedResort DataInteractive Dashboard that shows:The proportion of seats held by women in (a) national parliaments, currently as at 1 January of reportingyear, is currently measured as the number of seats held by women members in single or lower chambersof national parliaments, expressed as a percentage of all occupied seats.Round 2 deciman digits CSV Reader Row Filter Table Creator JSON Reader JSON Path Ungroup GET Request JSON Path Ungroup Table Creator GET Request JSON Path Column Filter Ungroup Column Filter Joiner Joiner Format geoAreaCodes Cross Joiner String Manipulation Table Row ToVariable Loop Start Loop End(deprecated) Column Filter String To Number Math Formula Sorter Rank GroupBy Joiner ConstantValue Column ConstantValue Column Joiner Rule-basedRow Filter Sorter Dashboard Math Formula Just KNIME It! - Challenge 7: Women in Government Description: In this challenge you will create one or more visualizations to inspect the percentual share of seats held by women in local government, as reported bythe United Nations Development Programme: Human Development Reports. The purpose of this report is to “ensure women's full and effectiveparticipation and equal opportunities for leadership at all levels of decision-making in political, economic and public life.” Since this is a real dataset therewill be missing values, and we expect you to augment the data via your own creativity. In particular, we ask that you not only report country specific databut also continent data. The true challenge here will be how you transform this incomplete dataset into one or more visualizations, and whichvisualizations you deem appropriate for this challenge. Challenge outline is as follows: 1.- Download the dataset and decide the most efficient way to bring it into KNIME 2.- Add a continent column using whatever method you think is most efficient 3.- Visualize the data (the KNIME solution will visualize both country and continent related data). KNIME Challengeprovided data Retrieve latest datafrom 'unstats.un.org'statistical Server Collect continentinformation from ISO3166 standard List of countries withinIndicator 5.5.1 (2) Add a continent column using whatever method you think is most efficient:Collect geographical information (1) DATASET: decide the most efficient way to bring it into KNIMEData query (latest data) from 'unstats.un.org' statistical Server (3) Visualize the data (the KNIME solution will visualize both country and continent related data):Generate dashboards and charts. Share of seats held by women in local government (%).csvat 'Current workflow data area'Exclude Header Top 6 RowsThis data won't be used further in the challengeURL:https://unstats.un.org/ [...] /5.5.1/Data Indicator 5.5.1, Series : Proportion of elected seats held by women in deliberative bodies of local government (%) SG_GEN_LOCGELSISO-3166-Countries-with-Regional-CodesJSON from:https://github.com/lukesquery valuesfrom JSONungroup column listsretrieve data from web servicequery valuesfrom JSONungroup column listsURL:https://unstats.un.org/ [...] /5.5.1/GeoAreasretrieve data from web servicequery valuesfrom JSONColumn Clean Upungroup column listsColumn Clean UpDiscriminate Countries fromgrouping RegionsCountry Query ListConvert geoAreaCodesto 3 charactersGenerate PathsList Generate Pages' PathsLoop Start by Data Pages (Country)Node 322Column Clean UpValues to NumericYear to IntegerArrange data by Country >> YearRank years with dataSelect latestyear dataSelect andkeep most recent data ONLYNode 335Node 336Merge unstats SDG-data with geo-dataEmpties ExcludedResort DataInteractive Dashboard that shows:The proportion of seats held by women in (a) national parliaments, currently as at 1 January of reportingyear, is currently measured as the number of seats held by women members in single or lower chambersof national parliaments, expressed as a percentage of all occupied seats.Round 2 deciman digits CSV Reader Row Filter Table Creator JSON Reader JSON Path Ungroup GET Request JSON Path Ungroup Table Creator GET Request JSON Path Column Filter Ungroup Column Filter Joiner Joiner Format geoAreaCodes Cross Joiner String Manipulation Table Row ToVariable Loop Start Loop End(deprecated) Column Filter String To Number Math Formula Sorter Rank GroupBy Joiner ConstantValue Column ConstantValue Column Joiner Rule-basedRow Filter Sorter Dashboard Math Formula

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: RE90273
Created at: 2022-03-09
On NodePit since: 2022-03-13
Last update: 2024-04-30
Created with KNIME version: v4.5.1
Tags: justknimeit-7

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

Try NodePit Runner!