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

External resources

• This challenge is based on this blog post.