Solutions to "Just KNIME It!" Challenge 33

Resources Just KNIME It!
1

This thread is for posting solutions to “Just KNIME It!” Challenge 33. Learn how to perform statistical comparisons across medical procedure prices to make smarter decisions! :stethoscope: :xray:

Here is the challenge: Just KNIME It!

Feel free to link your solution from KNIME Hub as well!

And as always, if you have an idea for a challenge we’d love to hear it! :heart_eyes: Tell us all about it here.

Season 1 of “Just KNIME It!” is slowly coming to an end: we’ll wrap up on October 26!

6 Likes
2

We have a special surprise coming for our last challenge… stay tuned!

6 Likes
3

Proposed solution with no scripted nodes.

Top deviated medical procedures: //
//
Laparoscopic Cholecystectomy
Excision, Breast Lesion
Carpal Tunnel Surgery
Arthroscopy, Knee, with meniscectomy (medial or lateral)
Colonoscopy, with lesion removal, by snare technique

3 Likes
4

Thank you for providing the interesting Challenge.
I am having trouble getting access to the “Link for Medical Procedures Dataset” as I am denied access and cannot get the data. I get the following message.
“Error 1009”, “The owner of this website (data.chhs.ca.gov) has banned the country or region your IP address is in (JP) from accessing this website.”

Could you please suggest another way to obtain the data?

5

Thanks for your solution, @Zglub, and welcome to Just KNIME It! :smiling_face:

2 Likes
6

Please see my solution for Challenge 33

image
image2006×486 52.3 KB

Result:

image
image1896×203 107 KB

2 Likes
7

The website is region locked, you may use VPN routing to the USA to download the data

2 Likes
8

Hi,

here is my solution:

Bildschirmfoto vom 2022-09-09 22-07-47
Bildschirmfoto vom 2022-09-09 22-07-472022×224 34.3 KB

Bildschirmfoto vom 2022-09-09 22-02-17
Bildschirmfoto vom 2022-09-09 22-02-171351×111 21.7 KB

2 Likes
9

Thanks for your advice.
I have obtained the files and will now try this challenge.

2 Likes
10

Hi everyone,
here is my solution.
I create two similar workflows for Kaiser and Sutter Hospitals and added a table view for results.

3 Likes
11

Thanks to your help, this is my solution.
Please note that the instructions are written in Japanese.

2 Likes
12

Here’s my solution. The complete data set is too large to upload to the Hub in the workflow. I’ve provided instructions in the workflow for a workaround.

REF Challenge 33 rev 1 jpg
REF Challenge 33 rev 1 jpg1794×514 148 KB

Final Chart
Final Chart1865×703 258 KB

2 Likes
13

My take on challenge -33

2 Likes
14

Hi, here is my solution, that is the biggest workflow I’ve ever made.

image
image996×320 22.4 KB

2 Likes
15

Hope you enjoyed the process! :slight_smile:

2 Likes
16

I enjoyed it, it was much fun, thanks!! :smiley:

1 Like
17

And as always on Tuesdays, here’s the solution for the #justknimeit challenge 33! We know this was a tough one but we’re happy to see all of your solutions :clap::star_struck:
Hope you enjoyed it and see you tomorrow for a new challenge! :smiling_face_with_three_hearts:

2 Likes
18

I can’t find the data in your workflow.

19

Hi @rfeigel,

The data must be downloaded. It is too large to put in the workflow.

Data: Link for Medical Procedures Dataset

1 Like
20

Hello KNIMErs,

Here is my solution to #justknimeit-33 :

KNIME Hub > gonhaddock > Spaces > Just_KNIME_It > Just KNIME It _ Challenge 033

My result differs slightly after a tidy-up for duplicated $CPT Codes$ and standardization of $Procedure$'s descriptions.

image
image1756×1051 165 KB

BR

2 Likes