Icon

Challenge 6 -justknimeit 6

Challenge 6: Media Selection Analysis.This flow was used to solve the challenge which required the following:1. Replace the codes (0,1,2,3) used to represent responders selection with (Printed Newspapers, Online Newspapers, Radioor Television, Social media)2, Create an interactive dashboard to show the user selection analysisSolutionThe flow produced a csv file (NewsSources_mapped.csv) which replaced the numbers with catalogue valuesCharts were used to show the selection partern using visualisation tools within KNIME and one provided by datawrapper.comKindly copy these links and paste on your browsers to view the two interactive charts from datawrapper.comChart 1 - https://datawrapper.dwcdn.net/mZCE4/1/ Chart 2 - https://datawrapper.dwcdn.net/NV0Op/1/Both shows thatThe highest media sources viewed by responders is a combination of (Online Newspapers and Social Media) these wasselected by 266 respondersThe least media sources viewed by responders is (Printed Newspapers) this was selected by 11 responders ReadNewsSources.csvread sourceDictionary.tableSplit Sourcesinto three columnsConvert datatype tosuit analysisinsert dictionary elements as variablesRun iterationfor all rows (3000)Replace codeswith dictionary valuesChange ColumnnamesVisualisation using Knime tools (Bar ChartCombine Selection by each responderinto a single columnAggregatecommon selectionOutput of task 1Visualisation using Knime tools (Sunburst)Output of task 2 for visualisation CSV Reader Table Reader Cell Splitter Number To String Table Row ToVariable Loop Start Loop End String Manipulation(Multi Column) Column Rename Bar Chart Column Combiner GroupBy CSV Writer Sunburst Chart CSV Writer Flow Output Cleanup(Manipulation) Challenge 6: Media Selection Analysis.This flow was used to solve the challenge which required the following:1. Replace the codes (0,1,2,3) used to represent responders selection with (Printed Newspapers, Online Newspapers, Radioor Television, Social media)2, Create an interactive dashboard to show the user selection analysisSolutionThe flow produced a csv file (NewsSources_mapped.csv) which replaced the numbers with catalogue valuesCharts were used to show the selection partern using visualisation tools within KNIME and one provided by datawrapper.comKindly copy these links and paste on your browsers to view the two interactive charts from datawrapper.comChart 1 - https://datawrapper.dwcdn.net/mZCE4/1/ Chart 2 - https://datawrapper.dwcdn.net/NV0Op/1/Both shows thatThe highest media sources viewed by responders is a combination of (Online Newspapers and Social Media) these wasselected by 266 respondersThe least media sources viewed by responders is (Printed Newspapers) this was selected by 11 responders ReadNewsSources.csvread sourceDictionary.tableSplit Sourcesinto three columnsConvert datatype tosuit analysisinsert dictionary elements as variablesRun iterationfor all rows (3000)Replace codeswith dictionary valuesChange ColumnnamesVisualisation using Knime tools (Bar ChartCombine Selection by each responderinto a single columnAggregatecommon selectionOutput of task 1Visualisation using Knime tools (Sunburst)Output of task 2 for visualisation CSV Reader Table Reader Cell Splitter Number To String Table Row ToVariable Loop Start Loop End String Manipulation(Multi Column) Column Rename Bar Chart Column Combiner GroupBy CSV Writer Sunburst Chart CSV Writer Flow Output Cleanup(Manipulation)

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: demol
Created at: 2022-03-03
On NodePit since: 2022-03-04
Last update: 2024-04-27
Created with KNIME version: v4.5.1

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

Try NodePit Runner!