Challenge 27 - Exploring World Cup Datasets
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
URL: This challenge is based on this blog post. https://www.knime.com/just-knime-it?utm_term=&utm_content=&utm_campaign=EVGL-Just-KNIME-It&utm_medium=social&utm_source=linkedin&hss_channel=lcp-692207#:~:text=This%20challenge%20is%20based%20on%20this%20blog%20post.
Nodes
- Joiner2 ×
- CSV Reader1 ×
- Date&Time-based Row Filter1 ×
- Duplicate Row Filter1 ×
- Excel Reader1 ×
- Show all 9 nodes
Extensions
Links
- No links available