Icon

jefleisc-knime_​challenge-27

challenge-27

Universal donors

Description: You have a dataset containing information on US citizens who donated blood in the last year,including addresses and blood types. The O- blood type, also known as "universal donor", is one of the mostvaluable blood types in the world because it can be transfused to nearly any person. Your goal here is to help agroup of researchers find the number of citizens with O- blood type per US state. Unfortunately, the addresscolumn comes in a single line, so to extract the state information you will have to perform some data wrangling.They also asked you to create a choropleth map of the US to visualize the results. Initial Data Cleaning More Data Prep Visualizations Read:blood_data.csvParse AddressStep 2 of 2Task 2Viz 1Pivot data tomake itreadableRemove unneededcolumnsTask 1Viz 1Rejoin dataafter piviotingCalculate %of O- by StateClean columnnames for vizReviewdatasetPrepare datasetfor Choropleth MapTask 1Viz 3Select Top 10Universal DonorstatesSort byCount & StateTask 1Viz 2 Task 1Viz 4Initial viewof datasetParse AddressStep 1 of 2 CSV Reader String Manipulation Choropleth Map Pivoting Column Filter Table View Joiner Math Formula Column Rename Data Explorer Column Rename Bar Chart Top k Selector Sorter ParallelCoordinates Plot Tag Cloud Data Explorer Regex Split Description: You have a dataset containing information on US citizens who donated blood in the last year,including addresses and blood types. The O- blood type, also known as "universal donor", is one of the mostvaluable blood types in the world because it can be transfused to nearly any person. Your goal here is to help agroup of researchers find the number of citizens with O- blood type per US state. Unfortunately, the addresscolumn comes in a single line, so to extract the state information you will have to perform some data wrangling.They also asked you to create a choropleth map of the US to visualize the results. Initial Data Cleaning More Data Prep Visualizations Read:blood_data.csvParse AddressStep 2 of 2Task 2Viz 1Pivot data tomake itreadableRemove unneededcolumnsTask 1Viz 1Rejoin dataafter piviotingCalculate %of O- by StateClean columnnames for vizReviewdatasetPrepare datasetfor Choropleth MapTask 1Viz 3Select Top 10Universal DonorstatesSort byCount & StateTask 1Viz 2 Task 1Viz 4Initial viewof datasetParse AddressStep 1 of 2 CSV Reader String Manipulation Choropleth Map Pivoting Column Filter Table View Joiner Math Formula Column Rename Data Explorer Column Rename Bar Chart Top k Selector Sorter ParallelCoordinates Plot Tag Cloud Data Explorer Regex Split

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: jf2557
Created at: 2022-07-27
On NodePit since: 2022-07-29
Last update: 2024-04-27
Created with KNIME version: v4.6.1
Tags: justknimeit-27

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

Try NodePit Runner!