Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • knime
  • Spaces
  • Just KNIME It!
  • Challenge 20 - Patient Network Days - Solution
WorkflowWorkflow

Challenge 20 - Patient Network Days - Solution

Justknimeit Justknimeit-20 Lag-column

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
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

Used extensions & nodes

Created with KNIME Analytics Platform version 4.5.2
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

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

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

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

Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits