Icon

KNIME_​challenge7_​solution

KNIME_challenge7_solution
Challenge 7: Women in GovernmentLevel: MediumDescription: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 by the United NationsDevelopment Programme: Human Development Reports. The purpose of this report is to “ensure women's full and effective participation and equal opportunities for leadershipat all levels of decision-making in political, economic and public life.” Since this is a real dataset there will be missing values, and we expect you to augment the data via yourown creativity. In particular, we ask that you not only report country specific data but also continent data. The true challenge here will be how you transform this incomplete datasetinto one or more visualizations, and which visualizations you deem appropriate for this challenge. Challenge outline is as follows:Download the dataset and decide the most efficient way to bring it into KNIMEAdd a continent column using whatever method you think is most efficientVisualize the data (the KNIME solution will visualize both country and continent related data) Impute value from simple average of neighbouring countries Get continent and neighbouring countries fromhttps://restcountries.com/ If not neighbour values available,then take continent avg. Workflow Inside of Component (displayed here for KNIME Hub inspection) Append back into 1 table Node "borrowed" fromhttps://kni.me/w/grHmwo1F0xiQPdO7 Node 2Node 6Node 7RESTcountryNode 9Node 10Node 12Node 15Node 17Node 18Node 19Node 20Node 21Node 23Node 24Node 25Node 27Google Charts - Geo ChartNode 35Node 37Node 39Node 40Node 41 CSV Reader GET Request Column Expressions Variable Creator Row Splitter JSON Path String To Number Ungroup Cell Splitter Joiner Column Expressions GroupBy GroupBy Joiner Rule-basedRow Splitter Concatenate Color Manager GenericJavaScript View Bubble Chart(Plotly) Bar Chart Viz Component Input Component Output Column Filter Challenge 7: Women in GovernmentLevel: MediumDescription: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 by the United NationsDevelopment Programme: Human Development Reports. The purpose of this report is to “ensure women's full and effective participation and equal opportunities for leadershipat all levels of decision-making in political, economic and public life.” Since this is a real dataset there will be missing values, and we expect you to augment the data via yourown creativity. In particular, we ask that you not only report country specific data but also continent data. The true challenge here will be how you transform this incomplete datasetinto one or more visualizations, and which visualizations you deem appropriate for this challenge. Challenge outline is as follows:Download the dataset and decide the most efficient way to bring it into KNIMEAdd a continent column using whatever method you think is most efficientVisualize the data (the KNIME solution will visualize both country and continent related data) Impute value from simple average of neighbouring countries Get continent and neighbouring countries fromhttps://restcountries.com/ If not neighbour values available,then take continent avg. Workflow Inside of Component (displayed here for KNIME Hub inspection) Append back into 1 table Node "borrowed" fromhttps://kni.me/w/grHmwo1F0xiQPdO7 Node 2Node 6Node 7RESTcountryNode 9Node 10Node 12Node 15Node 17Node 18Node 19Node 20Node 21Node 23Node 24Node 25Node 27Google Charts - Geo ChartNode 35Node 37Node 39Node 40Node 41 CSV Reader GET Request Column Expressions Variable Creator Row Splitter JSON Path String To Number Ungroup Cell Splitter Joiner Column Expressions GroupBy GroupBy Joiner Rule-basedRow Splitter Concatenate Color Manager GenericJavaScript View Bubble Chart(Plotly) Bar Chart Viz Component Input Component Output 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: MMU
Created at: 2022-02-16
On NodePit since: 2022-03-10
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: justknimeitjustknimeit-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!