Icon

JKISeason3-6_​tark

Visualizing Top Football Teams in History

Level: Medium

Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into football history with a data challenge. Today you are asked to create a data app that allows users to check, for any timeframe, what the top three teams with the most football victories were. Who are the top three teams of all time? And who were the top three teams in the 1980s?

Author: Michele Bassa

Datasets: Football Data in the KNIME Community Hub

URL: JKISeason3-6 https://www.knime.com/just-knime-it?pk_vid=f1a9625dd14a14c5171698895027e10b
URL: Dataset https://hub.knime.com/-/spaces/-/~5HAA3T665N_vR9Ga/
URL: This challenge thread https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511

Combine home_victoryand away_victory into asingle column. Determine the winner andloser for home and awaybased on the scoredifference. Processing time data. Node 2Node 3Extract yearshomevictory -> 1draw- > 0.5loss -> 0awayvictory -> 1draw- > 0.5loss -> 0Year -> DecadesNode 2443CSV Reader String to Date&Time Extract Date&TimeFields Rule Engine Rule Engine String Manipulation Component Metanode Combine home_victoryand away_victory into asingle column. Determine the winner andloser for home and awaybased on the scoredifference. Processing time data. Node 2Node 3Extract yearshomevictory -> 1draw- > 0.5loss -> 0awayvictory -> 1draw- > 0.5loss -> 0Year -> DecadesNode 2443CSV Reader String to Date&Time Extract Date&TimeFields Rule Engine Rule Engine String Manipulation Component Metanode

Nodes

Extensions

Links