Icon

JKISeason2-27_​sryu_​ver2

Challenge 27: Exploring World Cup Datasets
Level: Medium

Description: 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

results.csvteams.xlsx2021-2022home_teamaway_teamFIFA* Turn on the "Sort lexicographically" checkboxhome ⇔ awayRemove matches between same confederationsCSV Reader Excel Reader String to Date&Time Date&Time-basedRow Filter Joiner DuplicateRow Filter Joiner Row Filter Pivoting Missing Value Table View (Labs) Concatenate Column Rename Rule-basedRow Filter results.csvteams.xlsx2021-2022home_teamaway_teamFIFA* Turn on the "Sort lexicographically" checkboxhome ⇔ awayRemove matches between same confederationsCSV Reader Excel Reader String to Date&Time Date&Time-basedRow Filter Joiner DuplicateRow Filter Joiner Row Filter Pivoting Missing Value Table View (Labs) Concatenate Column Rename Rule-basedRow Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: sryus
Created at: 2023-09-29
On NodePit since: 2023-09-30
Last update: 2024-09-16
Created with KNIME version: v4.7.4
Tags: JKISeason2-27

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!