Solutions to "Just KNIME It!" Challenge 33

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

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

6 Likes

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

2 Likes

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?

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

2 Likes

Please see my solution for Challenge 33

Result:

2 Likes

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

2 Likes

Hi,

here is my solution:

2 Likes

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

2 Likes

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

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

2 Likes

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.

2 Likes

My take on challenge -33

2 Likes

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

2 Likes

Hope you enjoyed the process! :slight_smile:

2 Likes

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

1 Like

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

I can’t find the data in your workflow.

Hi @rfeigel,

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

Data: Link for Medical Procedures Dataset

1 Like

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.

BR

2 Likes