Icon

Challenge 33 - Medical Procedure Prices

Challenge 33 - Medical Procedure Prices
Challenge 33: Medical Procedure Prices Description: In America the prices of medical procedures can vary greatly, so savvy Americans tend to shoparound for a good deal. In this challenge you will take the role of a data journalist trying to investigate pricedifferences among medical procedures. 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 investigation is not uniform and requires inspection in order to be properlyread and processed. For simplicity, compare all average charges for the 25 most common outpatient procedures performed byhospitals from the Kaiser Foundation Hospitals and Sutter Hospitals only. For Kaiser Foundation, the relevantdata 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. READ DATA & PROCESS TABS CALCULATE TOP 5PROCEDURES ListFiles in FoldersKeep Kaiser &Sutter HospitalsPath to Stringto FilterKeep relevantFilesStd. Deviationby ProcedureTop 5Procedures byStd. Deviation List Files/Folders Rule-basedRow Filter Path to String Rule-basedRow Filter GroupBy Top k Selector Process file Tabs Challenge 33: Medical Procedure Prices Description: In America the prices of medical procedures can vary greatly, so savvy Americans tend to shoparound for a good deal. In this challenge you will take the role of a data journalist trying to investigate pricedifferences among medical procedures. 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 investigation is not uniform and requires inspection in order to be properlyread and processed. For simplicity, compare all average charges for the 25 most common outpatient procedures performed byhospitals from the Kaiser Foundation Hospitals and Sutter Hospitals only. For Kaiser Foundation, the relevantdata 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. READ DATA & PROCESS TABS CALCULATE TOP 5PROCEDURES ListFiles in FoldersKeep Kaiser &Sutter HospitalsPath to Stringto FilterKeep relevantFilesStd. Deviationby ProcedureTop 5Procedures byStd. Deviation List Files/Folders Rule-basedRow Filter Path to String Rule-basedRow Filter GroupBy Top k Selector Process file Tabs

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: USER
Created at: 2022-09-11
On NodePit since: 2022-09-21
Last update: 2024-11-23
Created with KNIME version: v4.5.0
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!