Icon

Just KNIME It Challenge 3

Just KNIME It Challenge 3
Node 1Node 2Rows must contain at leastCancer Sites, (Sex or Sex Code), States and Countto fullfil the requirements.NOTE: We could replace missing Count with 0, butsince we are only interested in highest numbers(most requent and highest rate), we can just ignore them,hence why they are being filtered outClean up StatesNode 6Node 7Node 8I chose to do aLEFT JOIN in casewe have some Statesthat do not match.(It turned out that allStates match)Calculatepercentage ofpopulationNode 13Get total Countper States(1) Top-5 most frequent cancertypes occurring in females(2) Top-5 most frequent cancertypes occurring in males(3) US state with highest cancer incidence rate(that is, the highest number of cancer casesnormalized by the size of its population)CSV Reader Excel Reader Rule-basedRow Filter String Manipulation GroupBy Top k Selector Top k Selector Joiner Math Formula Top k Selector GroupBy Column Filter Column Filter Column Filter Node 1Node 2Rows must contain at leastCancer Sites, (Sex or Sex Code), States and Countto fullfil the requirements.NOTE: We could replace missing Count with 0, butsince we are only interested in highest numbers(most requent and highest rate), we can just ignore them,hence why they are being filtered outClean up StatesNode 6Node 7Node 8I chose to do aLEFT JOIN in casewe have some Statesthat do not match.(It turned out that allStates match)Calculatepercentage ofpopulationNode 13Get total Countper States(1) Top-5 most frequent cancertypes occurring in females(2) Top-5 most frequent cancertypes occurring in males(3) US state with highest cancer incidence rate(that is, the highest number of cancer casesnormalized by the size of its population)CSV Reader Excel Reader Rule-basedRow Filter String Manipulation GroupBy Top k Selector Top k Selector Joiner Math Formula Top k Selector GroupBy Column Filter Column Filter 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: bruno
Created at: 2022-02-09
On NodePit since: 2022-02-11
Last update: 2024-05-01
Created with KNIME version: v4.5.1
Tags: #justknimeit-3

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

Try NodePit Runner!