Icon

justKnimeit-33

justKnimeit-33
Challenge 33: Medical Procedure PricesDescription: In America the prices of medical procedures can vary greatly, so savvy Americans tend to shop around for a gooddeal. In this challenge you will take the role of a data journalist trying to investigate price differences among medicalprocedures. More specifically, you want to find the top 5 procedures that show the largest variety in terms of pricing fromhospital to hospital (in statistics, you would call this high standard deviation). The data you have at hand for this investigationis not uniform and requires inspection in order to be properly read and processed. For simplicity, compare all averagecharges for the 25 most common outpatient procedures performed by hospitals from the Kaiser Foundation Hospitals andSutter Hospitals only. For Kaiser Foundation, the relevant data is in Excel files with "...Common25..." in their names; for Sutter,the relevant Excel files contain "...CDM_All..." in their names. Beware of hidden sheets. Kaiser HospitalsSutter HospitalsNode 59Node 60Node 63Node 64 List Files/Folders List Files/Folders Get and Clean Data Find Top 5Procedures Get and Clean Data Find Top 5Procedures Concatenate Table View Challenge 33: Medical Procedure PricesDescription: In America the prices of medical procedures can vary greatly, so savvy Americans tend to shop around for a gooddeal. In this challenge you will take the role of a data journalist trying to investigate price differences among medicalprocedures. More specifically, you want to find the top 5 procedures that show the largest variety in terms of pricing fromhospital to hospital (in statistics, you would call this high standard deviation). The data you have at hand for this investigationis not uniform and requires inspection in order to be properly read and processed. For simplicity, compare all averagecharges for the 25 most common outpatient procedures performed by hospitals from the Kaiser Foundation Hospitals andSutter Hospitals only. For Kaiser Foundation, the relevant data is in Excel files with "...Common25..." in their names; for Sutter,the relevant Excel files contain "...CDM_All..." in their names. Beware of hidden sheets. Kaiser HospitalsSutter HospitalsNode 59Node 60Node 63Node 64 List Files/Folders List Files/Folders Get and Clean Data Find Top 5Procedures Get and Clean Data Find Top 5Procedures Concatenate Table View

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: eyilmaz35
Created at: 2022-09-09
On NodePit since: 2022-09-11
Last update: 2024-11-21
Created with KNIME version: v4.6.1
Tags: justKnimeit-33

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

Try NodePit Runner!