Solutions to "Just KNIME It!" Challenge 15 - Season 3

:sun_with_face: Hi, folks! We’re coming back today with an easier Just KNIME It! challenge to match the leisurely Summer vibes! :beach_umbrella:

:tophat: This week you’ll wear the social scientist hat to better understand how childcare works in the European Union. :baby: :baby_bottle: How do different countries handle childcare throughout the years?

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-15.

:sos: Need help with tags? To add tag JKISeason3-15 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!

2 Likes

Find herewith my submission - though for ranking order bump chart can be a better way over year while herein i just used donut chart for single year . There are many missing values in dataset while for latest year many of
data values missing thus trend of 2023 may not be a true representation ( or i am missing something) .



5 Likes

Hi @alinebessa :wave: :slightly_smiling_face:

This morning Jakarta time, I’ve completed the solution for this week’s Just KNIME It! challenge. You can check it out through this link.

6 Likes

Here’s my solution. I took “overall trend” literally to mean EU trend. Includes linear trend line.

1

4 Likes

Here’s my solution - an interactive dashboards with 3 visuals:

  1. Rank Bumb chart showing the top 10 development over time
    2/3) line chart showing a) YoY Increase for each country and b) the 3 year moving average YoY increase for each country.

Countries to be displayed for 2/3 can be selected via combobox

WF:

4 Likes

Hello everyone, this is my solution.

In KNIME 5.3.1, some functions of the “Row Filter” node cannot be used. So I called the node of the old version. – row filter//deprecated

2 Likes

My solution to the challange:

Every time I work on a workflow I think I know how to do, I find new useful nodes. That is why these challenges are so brilliant, they force me to try new nodes, approaches :slight_smile:

6 Likes

Hello everyone,
Here’s my solution. All the line plots for each country were output as images in a table view. Iceland, France, and Malta appear to show an increasing trend.Thanks.



4 Likes

Hellow everyone,
This is my solution.

image

In this time, I created a dashboard to display line charts showing changes over time in each country.

4 Likes

Hi all,
Here is my solution.

Choropleth Map was used to visualize trends.



2 Likes

Hi all,
Here is my solution.

I have tried using Morphing between Map and Bar chart.
However, an error is displayed and I would like to know the solution.

6 Likes

This is SO cool!! Kudos!

2 Likes

This is my solution.

I used moving average and calculated the difference for EU27.

Here are the average values.

Also used gespatial view with average values.

1 Like

:baby: We just posted our solution to last week’s Just KNIME It! challenge!

:baby_bottle: It looks like, if we discount the lingering effects of the COVID-19 pandemic, there is a rising trend in the percentages of people relying on childcare services in the EU. Let’s see how this evolves in the next couple of years! :chart_with_upwards_trend:

:memo: We’ll be back tomorrow for a more complex data puzzle to hone your text mining skills. :robot: See you then!

1 Like

Hello Everyone,
Please find my solution for the submitted challenge.
I only considered the datasets for which OBS_FLAG was missing. This resulted in 608 rows of data versus 627 rows in the original dataset.
I estimated the average mean for the OBS_VALUE for each country to estimate the countries with most and least ChildCare.
Childcare is MOST COMMON in Denmark
Childcare is LEAST COMMON in Turkey (Turkiye)

The overall increasing or decreasing trend has been estimated using a Linear Regression Learner and using the Co-Eff parameter for each country to understand the trend over the declared time periods.

Overall EU/Euro Area seems to have a flat growth. Even though Denmark registers the highest mean pct of childcare, Luxembourg registers the highest co-efficient indicating a significant increase in ChildCare. Interestingly, Denmark and UK have registered the lowest trends clocking a negative co-efficient indicating a declining trend over the declared period which is also visible through the yearly trends plotted in the component view.
Scatter Plot

The complete KNIME workflow is available at the below link.


Best Regards,
nilotpalc

2 Likes

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