FIFA Rankings And International Matches 1992-2022

Context

This dataset is done with visualization purposes in mind.
I searched for datasets linking FIFA Matches and Rankings, but I could not find any, so I decided to compile my own.
I created a linking table (fifa_teams.csv) and used it to clean, stadardize and link the matches (fifa_matches.csv) and rankings (fifa_rankigns.csv)

---

Content

FIFA Matches

The matches are strictly men's full internationals and the data does not include Olympic Games or matches where at least one of the teams was the nation's B-team, U-23 or a league select team.

fifa_matches.csv includes the following columns:

date - date of the match
home_team - the name of the home team
away_team - the name of the away team
home_score - full-time home team score including extra time, not including penalty-shootouts
away_score - full-time away team score including extra time, not including penalty-shootouts
tournament - the name of the tournament
city - the name of the city/town/administrative unit where the match was played
country - the name of the country where the match was played
neutral - TRUE/FALSE column indicating whether the match was played at a neutral venue

note: the shootout games are not included. You can find them in the original dataset from kaggle, linked below

FIFA Rankings

fifa_rankings.csv includes the following columns:

team — country full name
country_abrv — country abbreviation
rank — current country rank
total_points — current total points
previous_points — total points in last rating
rank_change — how rank has changed since the last publication
confederation — FIFA confederations
rank_date — date of rating calculation

Also I took the creative liberty to inherit the matches and rankings for a few countries that are now former FIFA, since they split:
- Yugoslavia to Serbia
- Serbia and Montenegro to Serbia
- Netherlands Antilles to Curaçao

This was done solely for the purpose of having standard naming with the Matches and Rankings of current FIFA countries, in order to visualize everything under the country.
This decision was also fueled by the fact that FIFA decided to inherit the points, rank and FIFA position of those former countries in this manner.

FIFA Teams

fifa_team.csv includes the following columns:

team - the name of the football team
code - the FIFA code associated with the team
country - the sovereign country associated with the particular team (for example, England, Wales, etc are part of the UK)
confederation - the FIFA confederation the team is part of

---

References

The original International Matches dataset:

• (kaggle) International football results from 1872 to 2022: https://www.kaggle.com/datasets/martj42/international-football-results-from-1872-to-2017

The original FIFA Rankings dataset:

• (kaggle) FIFA World Ranking 1992 - 2022: https://www.kaggle.com/datasets/cashncarry/fifaworldranking

These together were cleaned and standardized using the fifa_teams dataset which I compiled myself in order to have a reference table which I then used to create relationships between the tables

The FIFA Teams dataset:

• (wikipedia) The creation of fifa_teams.csv, and my personal project involving Exploratory Data Analysis is found in my Github