Icon

KNIME_​Challenge7_​Women_​in_​Govt

Challenge 7:In this challenge you will create one or more visualizations to inspect the percentual share of seats held by women inlocal government, as reported by the United Nations Development Programme: Human Development Reports. Thepurpose of this report is to “ensure women's full and effective participation and equal opportunities for leadership at alllevels 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 your own creativity. In particular, we ask that you not only report country specificdata but also continent data. The true challenge here will be how you transform this incomplete dataset into one or morevisualizations, 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) Share of seatsheld by womenin local govtdataHDI Rank,Pct Women(could not change inCSV Reader)AuthenticateConnect to availablesheetsCountries & Continents(source: https://statisticstimes.com/geography/countries-by-continents.php)Node 8Hard codemissed join countriesRe-joinall rowswith ContinentsNode 13DescendingbyPctPct Womenin Local Govtby Continentwith each CountryContinents CSV Reader String To Number GoogleAuthentication Google SheetsConnection Google SheetsReader Joiner Rule Engine Concatenate GroupBy Bar Chart(JFreeChart) Sorter Bubble Chart(Plotly) Color Manager Challenge 7:In this challenge you will create one or more visualizations to inspect the percentual share of seats held by women inlocal government, as reported by the United Nations Development Programme: Human Development Reports. Thepurpose of this report is to “ensure women's full and effective participation and equal opportunities for leadership at alllevels 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 your own creativity. In particular, we ask that you not only report country specificdata but also continent data. The true challenge here will be how you transform this incomplete dataset into one or morevisualizations, 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) Share of seatsheld by womenin local govtdataHDI Rank,Pct Women(could not change inCSV Reader)AuthenticateConnect to availablesheetsCountries & Continents(source: https://statisticstimes.com/geography/countries-by-continents.php)Node 8Hard codemissed join countriesRe-joinall rowswith ContinentsNode 13DescendingbyPctPct Womenin Local Govtby Continentwith each CountryContinentsCSV Reader String To Number GoogleAuthentication Google SheetsConnection Google SheetsReader Joiner Rule Engine Concatenate GroupBy Bar Chart(JFreeChart) Sorter Bubble Chart(Plotly) Color Manager

Nodes

Extensions

Links