Solutions to “Just KNIME It!” Challenge 26 - Season 3

alinebessa · November 6, 2024, 1:32pm

Another Wednesday, another Just KNIME It! challenge!

Everybody loves pizza, but how about pizza with pineapple slices? Or with marshmallow? Let’s dive into the world of pizza with a data challenge this week, and discover which toppings are the most unusual. Buon appetito!

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 JKISeason3-26 .

Need help with tags? To add tag JKISeason3-26 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. Let us know if you have any problems!

rfeigel · November 6, 2024, 1:35pm

Link points to Challenge 25.

ScottF · November 6, 2024, 3:54pm

I checked and it’s updated now

rfeigel · November 7, 2024, 5:00am

Here’s my solution. As usual, nothing fancy.

MartinDDDD · November 7, 2024, 12:09pm

Here’s my solution.

Challenge was really to get the logic right to create all pairs of ingredients (i.e. I interpreted as pair = combination of any two Ingredients) amd also to make sure that pair x,y is treated as pair y,x…

Keen to see if this can be solved more efficiently than the route I went for…

Link to WF:

McReady · November 8, 2024, 5:41pm

I tried to make it as short as possible. So here is my way to go:

Technically, the “Sorter” and the “Row Filter” node could also be taken out, they are there for reading comfort only. Opening the last node and sort it manually would lead to the same result, only starting with an empty cell and 0 ingredients.

RBre · November 8, 2024, 10:46pm

Hello, here is my solution for this challenge.
Not as short as the already posted solutions but with similar results.

jproudfoot111 · November 9, 2024, 4:02am

Couldn’t decide between Pie chart or Donut chart …

jm1950sjr · November 9, 2024, 7:01am

Hi all,
Here is my solution.

I counted the number of ingredients that were detected only once, as indicated in the “unique_ingredients_count” column. In the table view, unique Ingredients were highlighted in yellow.

sryu · November 9, 2024, 10:11am

Hi all,
Here is my simple solution. I created this workflow using as few nodes as possible.

tark · November 9, 2024, 4:26pm

Hi all,
I used the association rule learner node to get frequent item sets. The left table shows popular ingredients, and the right one lists rare ones. Mozzarella is popular, while artichokes and avocado are rare. With combinations of three ingredients, Mozzarella, Pepperoni, and Tomato Sauce form the ‘golden trio.’ The Loop Special stands out due to three rare ingredients (Giardiniera, Italian beef, and Mozzarella sticks), as shown in the heatmap of the ingredient frequencies.

sryu · November 9, 2024, 4:50pm

@tark
Excellent solution !

berti093 · November 9, 2024, 8:31pm

My solution to the challenge:

I just twisted a little on the methodology and asked AI, what is the most uncommon ingredient (of course I did the analysis regarding the data as well).

It’s so a food for thought how everyone has (sometimes very) different approach for the same challange

ktafvelin · November 10, 2024, 8:36am

Hi all,
Beginner here - this is my solution to the challenge after a lot of discussion with K-AI. I hope it’s uploaded correctly, otherwise let me know.

Link to workflow