Icon

KNIME_​challenge20_​solution

KNIME_challenge20_solution
Challenge 20: Patient Network DaysLevel: HardDescription: You work for a hospital and they have data for each time a patient was seen. In this challenge, you will calculate the difference between each time a patient was seenexcluding weekends (called "network days"). Once you calculate the network days, calculate the average network days per patient. For the challenge, experiment with the input andoutput below. 1)+---------+------------+--------------+--------------------+| Patient | Date | Network Days | Mean |+---------+------------+--------------+--------------------+| Aline | 11-01-2022 | ? | 23.333333333333332 || Aline | 12-02-2022 | 24.0 | 23.333333333333332 || Aline | 25-02-2022 | 10.0 | 23.333333333333332 || Aline | 15-04-2022 | 36.0 | 23.333333333333332 || Victor | 05-02-2022 | ? | 13.333333333333332 || Victor | 25-02-2022 | 15.0 | 13.333333333333332 || Victor | 15-03-2022 | 13.0 | 13.333333333333332 || Victor | 30-03-2022 | 12.0 | 13.333333333333332 |+---------+------------+--------------+--------------------+ staticpatient datalag datelag patientcalcnetwork daysincl. end datecalc meanper patientjoin meantidy table Table Creator Lag Column Lag Column Python Script(Labs) GroupBy Joiner Table Manipulator Challenge 20: Patient Network DaysLevel: HardDescription: You work for a hospital and they have data for each time a patient was seen. In this challenge, you will calculate the difference between each time a patient was seenexcluding weekends (called "network days"). Once you calculate the network days, calculate the average network days per patient. For the challenge, experiment with the input andoutput below. 1)+---------+------------+--------------+--------------------+| Patient | Date | Network Days | Mean |+---------+------------+--------------+--------------------+| Aline | 11-01-2022 | ? | 23.333333333333332 || Aline | 12-02-2022 | 24.0 | 23.333333333333332 || Aline | 25-02-2022 | 10.0 | 23.333333333333332 || Aline | 15-04-2022 | 36.0 | 23.333333333333332 || Victor | 05-02-2022 | ? | 13.333333333333332 || Victor | 25-02-2022 | 15.0 | 13.333333333333332 || Victor | 15-03-2022 | 13.0 | 13.333333333333332 || Victor | 30-03-2022 | 12.0 | 13.333333333333332 |+---------+------------+--------------+--------------------+ staticpatient datalag datelag patientcalcnetwork daysincl. end datecalc meanper patientjoin meantidy table Table Creator Lag Column Lag Column Python Script(Labs) GroupBy Joiner Table Manipulator

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: MMU
Created at: 2022-06-08
On NodePit since: 2022-06-10
Last update: 2024-05-02
Created with KNIME version: v4.5.2
Tags: justknimeitjustknimeit-20

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

Try NodePit Runner!