# Solutions to “Just KNIME It!” Challenge 07 - Season 2

**URL:** <https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844>\
**Category:** Just KNIME It!\
**Tags:** justknimeit\
**Created:** [May 10, 2023, 2:06pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844 "2023-05-10T14:06:30Z")\
**Posts on this page:** 13\
**Page:** 2

<div class="post-metadata">

**Author:** ![MoLa\_Data](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mola_data/32/58742_2.png) [@MoLa\_Data](https://forum.knime.com/u/MoLa_Data)\
**Post date:** [May 14, 2023, 8:59pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/23 "2023-05-14T20:59:43Z")

</div>

Hi Crazy KNIMErs 🤪.

No me quedé muy contento 🫤con mi solución, y la he mejorado un poquito este fin de semana. ☺

![JustKnimeIt2-7(3)](https://forum-cdn.knime.com/uploads/default/original/3X/3/3/334b8467043aa7fc38dafa0fac796c0594963934.gif)

> **[JKISeason2-7 Ángel Molina – mola\_data](https://hub.knime.com/mola_data/spaces/Public/latest/JKISeason2-7%20%C3%81ngel%20Molina(2)~7KwsTgDOujyNG8go)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

Saludos!

---

<div class="post-metadata">

**Author:** ![MoLa\_Data](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mola_data/32/58742_2.png) [@MoLa\_Data](https://forum.knime.com/u/MoLa_Data)\
**Post date:** [May 14, 2023, 9:14pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/24 "2023-05-14T21:14:30Z")

</div>

Ps: source of Python Code: [Drawing a Pass Map in Python - FC Python](https://fcpython.com/visualisation/drawing-pass-map-python) 👌

---

<div class="post-metadata">

**Author:** ![elimisael](https://forum-cdn.knime.com/user_avatar/forum.knime.com/elimisael/32/63413_2.png) [@elimisael](https://forum.knime.com/u/elimisael)\
**Post date:** [May 14, 2023, 11:14pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/25 "2023-05-14T23:14:20Z")

</div>

Hello Community,

I saw many exciting solutions and someone very interested supported by the use of Python programming to draw a Soccer Field.

I developed my solution based on the flows published for other members.

I share the following carpet: [JKISeason2-7 – KNIME Community Hub](https://hub.knime.com/elimisael/spaces/Public/latest/Just%20Knime%20It/Season%2002/JKISeason2-7/JKISeason2-7%20ver%201.5), this contains the same solution showed in different presentations.

All have the following information based on both teams, full stats from the data source and only the information relevant to the passes, grouped by each halftime.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/c/6c1e3a02d684d123a9281e78892c7b77510c01b5.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/e/ced20ba440e02d12ba703e5ecce2c143f05688cc.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/5/a5c7f611f3e2ff975d3af2726c3dad4a0c3d07a5.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/c/ec7a961798b1b197fa644b49868d42e7d8eab76f.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/6/365f9087df4ec823edcc5a128722a27c017d4290.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/6/366985c2d50d9818a3c463d73e790c5db8ab0f7f.png)

---

<div class="post-metadata">

**Author:** ![HeatherPikairos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/a88e4f/32.png) [@HeatherPikairos](https://forum.knime.com/u/HeatherPikairos)\
**Post date:** [May 15, 2023, 8:10am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/26 "2023-05-15T08:10:10Z")

</div>

Thanks @l6fader! I’m glad you found it useful! I was learning too 🙂

---

<div class="post-metadata">

**Author:** ![Leo\_Wynter](https://forum-cdn.knime.com/user_avatar/forum.knime.com/leo_wynter/32/79708_2.png) [@Leo\_Wynter](https://forum.knime.com/u/Leo_Wynter)\
**Post date:** [May 15, 2023, 9:03am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/27 "2023-05-15T09:03:39Z")

</div>

My solution to Challenge 7

> **[7\_Passes\_JKISeason2-7 – leo\_wynter](https://hub.knime.com/leo_wynter/spaces/Public/latest/7_Passes_JKISeason2-7~6Zsx-CtmS0D1f6SM)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

---

<div class="post-metadata">

**Author:** ![HaveF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/havef/32/1124_2.png) [@HaveF](https://forum.knime.com/u/HaveF)\
**Post date:** [May 15, 2023, 4:19pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/28 "2023-05-15T16:19:35Z")

</div>

Hi, KNIMEr, 🥳 🥳 🥳

Here is mine

 ![vis](https://forum-cdn.knime.com/uploads/default/original/3X/6/9/69b61358fb780f50b9bae5823399ae8dd71496be.png)

## Points worth mentioning

- I chose a slider to control the time frame.
- Well, in addition to the visualisation of Manchester City’s successful passes, I also showed the failed passes, as well as Manchester United’s passes. This is because I believe that the success or failure of one team’s pass is closely related to that of the other. Only the passes are shown here.

## Another thoughts

- Matplotlib is a relatively slow solution.
- 2D Density Plot is a great visual solution in this scenario.
- The sunburst chart is also great.
- Obviously there are many factors that influence the success of the pass. In addition to the pass, there are many other types of data, but it is a pity that there is not so much time to analyse them.

> **[C07 – havef](https://hub.knime.com/havef/spaces/Public/Just_KNIME_It/S2/C07~4czfofE_hWIsCgWy/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

Best,  
HaveF

---

<div class="post-metadata">

**Author:** ![HaveF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/havef/32/1124_2.png) [@HaveF](https://forum.knime.com/u/HaveF)\
**Post date:** [May 16, 2023, 3:47am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/29 "2023-05-16T03:47:14Z")

</div>

I wrote a relatively detailed analysis post in Chinese. If you are interested, you can [take a look(maybe use translator?)](https://www.havef.fun/blog/knime-football-passes-analysis).

---

<div class="post-metadata">

**Author:** ![kowisoft](https://forum-cdn.knime.com/user_avatar/forum.knime.com/kowisoft/32/3295_2.png) [@kowisoft](https://forum.knime.com/u/kowisoft)\
**Post date:** [May 16, 2023, 5:59am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/30 "2023-05-16T05:59:26Z")

</div>

Dear KNIMErs,

alright, here’s my solution. Looking at the submissions so far, it feels a little bit “lame” because I have now soccer field visualized etc 😉

Learned again a lot about re-executing when making changes in this little dashboard and also used some Auto-Binner functionality to bin some “match times” and the Euclidean Distance (aka movements in the 2D space rather than just from A to B) 🙂

Never thought I actually will like mathematics again _hahaha_ 😃

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/0/80dcc155c7ecfa9e2888f1a3aab74f96247f2742.png)

> **[JKISeason2-7 - kowisoft - Mapping Successful Football Passes – kowisoft](https://hub.knime.com/kowisoft/spaces/Public/latest/Just%20KNIME%20It/Season%202/JKISeason2-7%20-%20kowisoft%20-%20Mapping%20Successful%20Football%20Passes~9WZaJkShAahWBOL3)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

Cheers

---

<div class="post-metadata">

**Author:** ![HeatherPikairos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/a88e4f/32.png) [@HeatherPikairos](https://forum.knime.com/u/HeatherPikairos)\
**Post date:** [May 16, 2023, 2:04pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/32 "2023-05-16T14:04:17Z")

</div>

Hi Everyone 🙂

I just want to share an updated version of my workflow (in case anyone enjoyed the video!) because I had an issue generating a full video in AVI format and I have now received a solution from @gab1one on the forum:

> [@Image Writer AVI Format](https://forum.knime.com/t/image-writer-avi-format/66941/3):
>
> Hi @HeatherPikairos, The AVI exporter seems to not work correctly when you set a lower framerate. I recommend you to try the NativeQT format. In my experiments with your workflow, it seemed to work correctly. best, Gabriel

The NativeQT format in -Image Writer- successfully generates the full video 🙂

I have also added a little bit extra at the end of the workflow to compress the video and delete the original version in the data folder:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/8/88e8b4521e1b2dacb34990c289bb8b685dcf1001.png)

The original link to the hub workflow should work but I’ll share again:

> **[20230511 Pikairos JustKNIMEIt Season 2 Challenge 7 Mapping Successful...](https://hub.knime.com/heatherpikairos/spaces/Public/Just%20KNIME%20It/Season%202/20230511%20Pikairos%20JustKNIMEIt%20Season%202%20Challenge%207%20Mapping%20Successful%20Football%20Passes~bLLwnru4LjtyVI3E/current-state)**
>
> By visually analyzing successfully completed passes from football match data, it is possible to obtain valuable information about a team's performance. This ca…

Just for fun, I made a video with the passes of both teams in different colours, you can watch it here:

[![](https://img.youtube.com/vi/I-Nd48NWq3A/maxresdefault.jpg "20230516 Pikairos JKISeason2 7 Video") ](https://www.youtube.com/watch?v=I-Nd48NWq3A)

Best wishes  
Heather

---

<div class="post-metadata">

**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\
**Post date:** [May 16, 2023, 2:08pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/33 "2023-05-16T14:08:27Z")

</div>

🤓 As always on Tuesdays, here’s our solution to last week’s challenge! 🤓

> **[Mapping Successful Football Passes – knime](https://hub.knime.com/knime/spaces/Just%20KNIME%20It!/latest/Challenge%207%20-%20Mapping%20Successful%20Football%20Passes~xW19SwR6-vdieTqa)**
>
> By visually analyzing successfully completed passes from football match data, it is possible to obtain valuable information about a team's performance. This ca…

⚽ Since this was an easy challenge, we kept the solution very simple and didactic, relying on a heat map that is quick to build with the 2D Density Plot (Plotly) node. As you can see, most of Manchester City’s successful passes are initiated from the center of the field.

💥 Once again your incredible solutions AMAZE us! 🤯 This year it seems like you folks are really going the extra mile and really exploring how KNIME can be used. We are so happy! This really means a lot to us. 😊

See you tomorrow for a new challenge!

---

<div class="post-metadata">

**Author:** ![l6fader](https://forum-cdn.knime.com/user_avatar/forum.knime.com/l6fader/32/53149_2.png) [@l6fader](https://forum.knime.com/u/l6fader)\
**Post date:** [May 17, 2023, 1:51am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/34 "2023-05-17T01:51:47Z")

</div>

@HeatherPikairos @gab1one  
I found this solution to be very cool (as i mentioned above) and immediately tried adapting it to a real use case in my regular job. I generate the PNGs by converting from SVGs generated by the generic javascript node. What i find is that when i use the PNG to ImgPlus node, the image loses resolution and the colors really get messed up. Do either of you know how to overcome this?

---

<div class="post-metadata">

**Author:** ![HeatherPikairos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/a88e4f/32.png) [@HeatherPikairos](https://forum.knime.com/u/HeatherPikairos)\
**Post date:** [May 17, 2023, 7:53am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/35 "2023-05-17T07:53:57Z")

</div>

Hi @l6fader thanks again for the comment about my workflow 🙂  
Unfortunately as I am a newbie in this area I cannot help to answer your query, but hopefully @gab1one can 🙂

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [August 15, 2023, 7:54am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844/36 "2023-08-15T07:54:15Z")

</div>

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

[Previous page](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-07-season-2/66844.md?page=1)
