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

alinebessa · October 18, 2023, 2:30pm

New Wednesday, new Just KNIME It! challenge!

This week we close our second season with an open-ended challenge on data apps to visualize the musical production of many artists. I know… we will miss you too…

… But we will come back next year for a new season touching on a variety of data science and analytics topics once again!

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-30. If you want to see your name on the leaderboard, make sure to work on the challenges until next Tuesday. We will stop the clock and identify the winners right after that.

Need help with tags? To add tag JKISeason2-30 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!

lelloba · October 18, 2023, 9:22pm

Hello everyone,

it’s a pity I’ve lost most of this second season, but I’m trying to recover
Here is my submission to the challenge. Since it’s the last one, I tried to personalise it a little bit.

Italy is full of dialects. And with “full” I don’t just mean they change from region to region (Sardinian, Sicilian, Lombard, Tuscan, just to mention some) but from city to city, village to village.

In this challenge I included my dialect, called Talamùn (Talamonese in Italian), which is a variant of the Northern Lombard dialect and it’s specific of my village (less than 5.000 inhabitants). If you go to the next village, some words, grammar and expressions change and you might not be fully understand.

In this sense, if you want to add your own language or dialect to this workflow, as long as you fill the Excel file correctly, the flow will add a new language to the available ones.

Have a nice day,
Raffaello

rfeigel · October 18, 2023, 11:42pm

Can’t find the input files in your workflow.

rfeigel · October 19, 2023, 12:08am

Error when executing:

lelloba · October 19, 2023, 7:13am

Hello @rfeigel,

you miss the language Excel file. I should have mentioned it in my previous message, but I have uploaded it in my Season 2 folder on the hub.

Thank you for telling me!

Raffaello

HaveF · October 20, 2023, 4:57am

Hi, there

Finally! Finally we finished it!

Thank you @alinebessa! For your company throughout the journey! Thanks to the other KNIME staff members I couldn’t name in the Season 2 Challenge!

Also Thanks participants for sharing your knowledge and brains throughout the process!

This is the GIF of my last challenge, you can find the workflow here, you can find instructions about it here.

I’m also translating and polishing the questions and the official answers for Chinese readers. Even those who did not participate in the second season of activities can easily choose some topics to practice at any time.

Thank you and goodbye!

HeatherPikairos · October 20, 2023, 8:13am

Hi @alinebessa

The hub is down for maintenance right now so I can’t get access to the files. Would you be able to share them on here please?

Edit: seems to be accessible again now

Thanks a lot
Heather

HeatherPikairos · October 20, 2023, 3:58pm

Hi Everyone

Wow the last challenge! Thank you @alinebessa, KNIME and my fellow JustKNIMEIT participants… what an interesting 30 weeks we’ve had!

For the final challenge, I used the languages file as a hint to decide what info/charts to create. The user can select their language and then view information about the most prolific artists (most songs) using the Tile View, a bar chart and a pie chart.

I have a bit of an issue displaying the bar chart and pie chart when the language is in German, but I’m not sure why. Maybe the umlaut in the column name. I will keep investigating

You can find my workflow on the hub here:

Thanks again
Heather

sryu · October 21, 2023, 3:11pm

Hi all,
This is my solution.

I have created a table displaying the top 20 artists, ranked by the number of tracks they released each year. Each artist is represented by a unique color in the table cells. To make it easier for users to locate their favorite artists, only selected artists are highlighted. This solution also supports language selection.

I have successfully completed JKISeason 2. I am deeply grateful for the numerous insights gained from the participants and the official solutions.

tark · October 22, 2023, 12:55pm

Hello everyone,
Here’s my solution. I’ve created a component displaying a transition in audio features in the provided track data.
I’ve learned a lot and had a great time through JKISeason2. I’m grateful to all the participants and the JKI organizers.

AnilKS · October 22, 2023, 5:22pm

Find herewith my submission for last challenge for the season …this is a Dejavu feel of 66 days of data though. Sample language is arabic while used a translator component by armin for this.

Artem · October 24, 2023, 5:00am

Hello everyone.

Here is my solution. As I did not have much time I implemented the app that shows the charts based on the highest/lowest parameters of the song of the artist. It is still interactive though. I also decided to check if there are several songs with the same name that come from different artists.

By the way I found some problems in the data too. For example check Norma Jean - you would surprised - just compare song “Memphis will be laid to waste” with other songs from this artist.

So far it was quite a journey and I would like to thank Knime people who organized JK-competition as well regular folks here, I have learnt a lot from you!

tomljh · October 24, 2023, 11:46am

Hello everyone, this is my solution.

The last challenge, I was stumped.In order to ensure completion within the agreed time, I submitted an unsatisfactory version.

To prevent omissions, I must thank everyone. Thank you very much. I have learned many good ideas during this process.

All the best

alinebessa · October 25, 2023, 1:43pm

Wow! I did not know that Italy had so many dialects! Lovely!

alinebessa · October 25, 2023, 1:50pm

Hi, folks!

Coming here one day after the usual because I was at a KNIME event yesterday.

I’d like to thank you all for participating of JKI this season. It was really fun to organize it, and we learned A LOT from you. It was also very beautiful to see how your solutions kept getting better, and how you were so generous and helpful with one another. This spirit of collaboration is at the core of KNIME, and we are honored to have you as part of our community.

Stay tuned for a few announcements about this season soon, and yes: we will have a season 3 next year!

Our sincerest THANK YOU,
Aline on behalf of the KNIME Team

gonhaddock · October 29, 2023, 11:33pm

Hello KNIMErs

A little late but I didn’t want to miss the last challenge of JKI S02. This is my take, and I am not presenting very elaborate graphs due to lack of time, but I am happy with the analytical workflow.

I couldn’t follow the challenges regularly due to workload, and some (few of them) were left in draft… In any case, thanks to the KNIME team, and to all the knimer participants from whom we always learn techniques and tricks.

Keep it knim(e)ing until the next JKI’s season

l6fader · November 6, 2023, 3:26pm

Hi All,
I confess it’s been a while since my last solution… Its good to be back!
I was late getting started and after looking through the work you all have done, I am very impressed with what i see. So now how to do something different…?
I have been working to improve a Venn-Scatter diagram I made so that it will except any data set, not just a chemistry-focused table. What better place to share it than here, with this cool challenge.

You can find the workflow here:

An example of how the Component looks is here:

The Venn-Scatter hybrid visualized the overlap of three parameters for each artist… Here i selected “energy”, “danceability” and “tempo” for the sets and decided i would want to target artists with high scores for each of these parameters for my play list by setting the filters to have high min values.

In order to visualize which two artists meet my criteria, there is a tooltip that displays the artists name and the values of these metrics:

Ideally, the image would display an album cover, for example, but that was not something i could pull together.

Hope you find this useful.
L

alinebessa · November 6, 2023, 4:33pm

This looks so cool! I never thought of using a Venn diagram to visualize this type of data!

Thiemo.Kellner · December 30, 2023, 4:30pm

Hi there

I finally and proudly present my go on the challenge.

Firstly, I developed it with the modern UI so, annotation boxes are sized for that. In the classic view, well, it is not really readable.

Then, as others have, I have put in my dialect as preselection. Have fun with it. Maybe you want to guess where it belongs to.

[Edit]
To me, my development workstation is rather powerful, having 24 GB of RAM. So, I developed the workflow to run entirely in memory. However, on my laptop when I presented my solution to my wife, I had to reduce the amount of data (facilities in the meta node for the entities) and make the group bys of the component run on disc instead of memory.

Last but not least, as I am quite new to creating other workflows than those of the courses, I was quite often having a glance at other solutions. Many thanks to the creators of them. The insights have been helpful. Having that said, my work probably has not much “finesse”. Please bear with me.

Further more, I have come across some questions while doing so. I probably should compile independent posts. I documented them, however, in orange annotations. If you feel the urge to reply to those questions, I would be happy to listen.

I could not make sense out of the artist data file, so I ignored it and compiled the information from the tracks and songs file. I had to wrangle the data quite a bit, but did not want to spend endless hours for the “perfect” solution. E.g. some songs do not have the artist’s id. So I plainly invented those, even though there might have been other songs with the same artist name and its id. Another thing is, that in my end data, some of the artists seem to share the same id. I did not investigate into that. It might be faulty data, it might be faulty implementation on my side. Please bear with me.

My UI is quite overloaded and anything else but elegant. I changed the layout a bit, but I am also sure, I should be able to make it better. Once again, I did not want to invest more time into this work. Here, some gruesome details.

hapisnake · January 30, 2024, 8:38am

When will be season 3 or can I participate in previous season 1 and 2?