Hub
Pricing About
WorkflowWorkflow

Challenge 20 - Patient Network Days - Solution

JustknimeitJustknimeit-20Lag-columnHardMedical care
+1
knime profile image
Draft Latest edits on 
Mar 4, 2024 11:26 PM
Drag & drop
Like
Download workflow
Workflow preview
Challenge 20 - Patient Network Days - Solution 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 seen excluding weekends (called "network days"). Once you calculate the network days, calculate the average network days per patient. For the challenge, experiment with the input and output below. Input Patient          Date Aline             11/01/2022 Aline             12/02/2022 Aline             25/02/2022 Aline             15/04/2022 Victor            05/02/2022 Victor            25/02/2022 Victor            15/03/2022 Victor            30/03/2022 Output Patient          Date              Network Days          Mean Aline             11/01/2022    ?                              23.333 Aline             12/02/2022    24                            23.333 Aline             25/02/2022    10                            23.333 Aline             15/04/2022    36                            23.333 Victor            05/02/2022    ?                              13.333 Victor            25/02/2022    15                            13.333 Victor            15/03/2022    13                            13.333 Victor            30/03/2022    12                            13.333 Note: if you simply use the Date&Time Difference node, you will mix patient data/dates and will also end up counting weekends. Bonus Challenge: Create a solution without using loops.
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.2.1
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime profile image
    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime profile image
    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.2.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits