Icon

Challenge 3 -justknimeit-3

Read CDC_cancer_2017.csvNode 2group by cancer siteand sexExtract Female StatisticsArrange Sum in Descending orderExclude "All invasivecancer sites combined"RenamerowsSelect top5 rowsWrite values to csv fileExtract Male StatisticsExclude "All invasivecancer sites combined"Arrange Sum in Descending orderRenamerowsSelect top5 rowsWrite values to csv fileRemove leading "."Group by StateLeft Inner joinbased on statecolumnNormalize bycalculatingRatio of incidents relative topopulationArrange Normalizedvalues in descending orderFilter out thethe row with the maximum ratioi.e. PennsylvaniaRename RowsCSV Reader Excel Reader GroupBy Row Filter Sorter Row Filter RowID Row Filter CSV Writer Row Filter Row Filter Sorter RowID Row Filter CSV Writer String Manipulation GroupBy Joiner Math Formula Sorter Row Filter RowID Read CDC_cancer_2017.csvNode 2group by cancer siteand sexExtract Female StatisticsArrange Sum in Descending orderExclude "All invasivecancer sites combined"RenamerowsSelect top5 rowsWrite values to csv fileExtract Male StatisticsExclude "All invasivecancer sites combined"Arrange Sum in Descending orderRenamerowsSelect top5 rowsWrite values to csv fileRemove leading "."Group by StateLeft Inner joinbased on statecolumnNormalize bycalculatingRatio of incidents relative topopulationArrange Normalizedvalues in descending orderFilter out thethe row with the maximum ratioi.e. PennsylvaniaRename RowsCSV Reader Excel Reader GroupBy Row Filter Sorter Row Filter RowID Row Filter CSV Writer Row Filter Row Filter Sorter RowID Row Filter CSV Writer String Manipulation GroupBy Joiner Math Formula Sorter Row Filter RowID

Nodes

Extensions

Links