Icon

20230929 Pikairos JustKNIMEIt Season 2 Challenge 27 Exploring World Cup Datasets

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

Challenge 27: Exploring World Cup DatasetsWe explore World Cup datasets in this challenge, with the goal of seeing how many games under FIFA were played between differentconfederations in the last year (between 2021-2022). We have two files, results.csv and shootouts.csv, from which we need the year whenthe games were played. We also have a third file, teams.xlsx, detailing teams and to which confederation they belong. The output tableshould look something like this AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36 ResultsTeamsConvertDate fromString to DateFormatKeep FIFAMatchesKeep Rows20210101- 20221231Join Confederationto Home TeamJoin Confederationto Away TeamGroup By:ConfederationPivot:Confederation (away)Aggregation:CountReplaceMissing Valueswith 0Check forDuplicate RowsCheck forDuplicate RowsView ResultsKeep RowsWhere theConfederations arenot the SameSwitch the Namesof the ConfederationColumnsConcatenateRows CSV Reader Excel Reader String to Date&Time Row Filter Date&Time-basedRow Filter Joiner Joiner Pivoting Missing Value DuplicateRow Filter DuplicateRow Filter Table View (Labs) Rule-basedRow Filter Column Rename Concatenate Challenge 27: Exploring World Cup DatasetsWe explore World Cup datasets in this challenge, with the goal of seeing how many games under FIFA were played between differentconfederations in the last year (between 2021-2022). We have two files, results.csv and shootouts.csv, from which we need the year whenthe games were played. We also have a third file, teams.xlsx, detailing teams and to which confederation they belong. The output tableshould look something like this AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36 ResultsTeamsConvertDate fromString to DateFormatKeep FIFAMatchesKeep Rows20210101- 20221231Join Confederationto Home TeamJoin Confederationto Away TeamGroup By:ConfederationPivot:Confederation (away)Aggregation:CountReplaceMissing Valueswith 0Check forDuplicate RowsCheck forDuplicate RowsView ResultsKeep RowsWhere theConfederations arenot the SameSwitch the Namesof the ConfederationColumnsConcatenateRows CSV Reader Excel Reader String to Date&Time Row Filter Date&Time-basedRow Filter Joiner Joiner Pivoting Missing Value DuplicateRow Filter DuplicateRow Filter Table View (Labs) Rule-basedRow Filter Column Rename Concatenate

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: LAMBERT
Created at: 2023-09-29
On NodePit since: 2023-10-03
Last update: 2024-11-21
Created with KNIME version: v4.7.4
Tags: JKISeason2-27Pivoting

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

Try NodePit Runner!