Solutions to "Just KNIME It!" Challenge 28 - Season 2

:boom: New Wednesday, new Just KNIME It! challenge! :boom:

:bar_chart: This week we’ll focus on our Python integration for the first time to create a custom visualization chart: a stacked funnel plot.

:nerd_face: You’ll be surprised at how simple it is to leverage this integration to further personalize your solutions – if you want to!

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason2-28.

:sos: Need help with tags? To add tag JKISeason2-28 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. :slight_smile: Let us know if you have any problems!

1 Like

Find herewith my submission on current week challenge on funnel plotting through plotly express.

flow

4 Likes

Here’s my “solution.” Since I know next to nothing about writing Python, I took the coward’s way out and embedded one of the Plotly scripts in the Python View node. Took me a little while to figure out that when you do that you have to remove the input port.

4 Likes

Hi all,
Here is my solution.
This solution allows the selection of columns to be aggregated.

7 Likes

Hello everyone,

Here is my solution: I implemented component where user may select columns for data, category and the color. It is also possible to provide opacity and select the type of plot — funnerl or funnel area. I tested my component on the data from JK2-1 and JK2-26 — the ones that refer mostly to some kind of sales of financial data.


5 Likes

Hi all,

This is my solution. I had a trouble about kaleido package in my python environment…
But it was solved according to the link below.

5 Likes

Hello everyone, this is my solution.
I have also designed it as a configurable visualization component.

My characteristic is that after assembling all the data, the meta information of the data is extracted in Python, not externally.

5 Likes

Hi, KNIMEr :partying_face: :partying_face: :partying_face:

Here are my notes on the funnel chart for your reference

To explain the funnel chart, I will focus on Toronto’s data, which can be understood through word of mouth.

  1. The first row of the figure (40, Potential customers) is the absolute number of cells corresponding to the Toronto column in the table, the Potential customers row

  2. The second row of the figure, 40% of the initial, is obtained by dividing the absolute number by the first line of Toronto (referred to as the initial) Website vitit.(haha :grin:, the typo vitit is obtained by copying the original data of @sryu ). This is calculated as 40/100 = 40%.

  3. The third line in the figure is how much data was leaked from the previous funnel row, which is calculated as 40/60 = 66.7%.

  4. The fourth row of the figure, 16% of the total, refers to 40/(100+60+40+30+20) = 16%. However, I am not entirely sure about the meaning of this particular figure in the context of funnel charts. (100+60+40+30+20) This addition doesn’t feel practical enough…

4 Likes

A simple one done up by following the instructions / challenge

Funnel

Workflow & Code

4 Likes

Heeellloooooo my crazy KNIMERS!!!

Here is my solution:

And here, my article about it: Python & KNIME, recursos iliminatos para analistas de datos: Plotly | Funnel Chart

See you soon!!!

4 Likes

Hi Everyone :slight_smile:

This week I have used example data from the curation process of chemical datasets to demonstrate the funnel plot:

Over a series of curation steps, we lose molecules until we are left with clean, standardised chemical structures or descriptors to use in the next steps of our methodologies.

I have dealt with the data in two different orientations:

First:

Second:

Does anyone know why my value of 9799 is written as 9.799K when none of the other values are?

Here is my workflow on the hub:

Best wishes
Heather

4 Likes

:sparkles: As always on Tuesdays, here’s our solution to last week’s Just KNIME It! challenge :sparkles:

:blush: We’re happy to see that even those who do not know Python were able to tackle this challenge! :exploding_head: Very telling of how straightforward it is to use the Python integration in KNIME!

:star2: See you tomorrow for our second to last challenge this season!

3 Likes

Hi :slight_smile: Where can i download your workflow :smiley: ?

Hi, @Loknica07 :smiley: you can get it here: C28 – KNIME Community Hub

Thanks a lot. I got some mistake here. Do you know what extension i actually need?

hi @Loknica07

From your Console, it seems that pandas did not install successfully. I used Conda Environment Propagation to create a conda environment called plotly, with pandas, plotly, py4j, pyarrow installed, and then passed this environment to the Python View node.

As you can see from your diagram, Conda Environment Propagation shows a green sign, indicating that it ran successfully, but from the Python View node, the environment was not set up successfully. (Not sure why.)

Maybe you can delete the Conda Environment Propagation node, set this configuration of Python View as shown in the image below, and try it again? (plotly is installed by default in the new version of KNIME)

Thank you so much! I will try it!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.