Icon

Exploring World Cup Datasets

There has been no title set for this workflow's metadata.

We explore World Cup datasets in this challenge, with the goal of seeing how many games under FIFA were played between different confederations in the last year (between 2021-2022). We have two files, results.csv and shootouts.csv, from which we need the year when the games were played. We also have a third file, teams.xlsx, detailing teams and to which confederation they belong. The output table should look something like this
AFC UEFA CONCACAF
AFC 34 67 89
UEFA 67 65 12
CONCACAF 89 12 36

This challenge is based on this blog post.

URL: Just KNIME It! https://www.knime.com/just-knime-it
URL: Blog Post https://medium.com/low-code-for-advanced-data-science/fifa-world-cup-rating-teams-with-knime-9d84d9d3c70a

resultsshootoutsteamsdatedateunique matchin year 2021+ confcountry+ confmatrixsamedifferent confswap confhome away0inter confCSV Reader CSV Reader Excel Reader String to Date&Time String to Date&Time Column Renamer Column Renamer Concatenate DuplicateRow Filter Date&Time-basedRow Filter Joiner DuplicateRow Filter Joiner Pivot Sorter ReferenceColumn Resorter Rule-basedRow Splitter Column Renamer Concatenate Missing Value Excel Writer resultsshootoutsteamsdatedateunique matchin year 2021+ confcountry+ confmatrixsamedifferent confswap confhome away0inter confCSV Reader CSV Reader Excel Reader String to Date&Time String to Date&Time Column Renamer Column Renamer Concatenate DuplicateRow Filter Date&Time-basedRow Filter Joiner DuplicateRow Filter Joiner Pivot Sorter ReferenceColumn Resorter Rule-basedRow Splitter Column Renamer Concatenate Missing Value Excel Writer

Nodes

Extensions

Links