Introduction
This is the third week of the Bootcamp at Side Hustle. So far it has been a learning curve for me which I can say has been worthwhile.
My next task for the Bootcamp was to work on a Football world cup analysis from 1930 to 2022.
As usual, the first step was the sourcing of the dataset. Which was a bit of a challenge especially in finding the right dataset for the analysis. I ended up sourcing for four datasets containing information from 1930 to 2022. Each datasets had similarities in terms of year and hosts but were different in their focus. All datasets used for this analysis were sourced from Kaggle.
The next step was to devise a means of combining each datasets. This I did with the aid of the merge queries in the home tab. After merging the datasets and including columns I needed, the next step was to transform the dataset.
Transformation included removal of duplicate rows, changing column titles, changing data types, and adding columns.
FIFA World Cup Analysis
FIFA World Cup Analysis Dashboard 1
From the dashboard above, from 1930 to 2022, the total world cup attendance was 44million, 22 world cup have been played with 492 teams participating. Overall, 964 matches have been played in all 22 world cups.
Looking at the world cup attendance per year, there has been a steady rise in attendance from 1930 to 2022. The highest world cup attendance ever recorded was in 1994. Also in 1994, we also see the highest average attendance.
In the chart containing the top five stadium by attendance, Maracãnã Stadium, Rīo de Janeiro topped the list followed by Estadio Azteca, Mexico city.
FIFA World Cup Dashboard 2
In the second dashboard above, the first chart shows nine counties have won the world cup title including Brazil, Italy, Argentina, France, Germany, Uruguay, West Germany, England and Spain. Brazil has the highest numbers of wins (Five times) in the world cup followed by Italy (four times) and Argentina (three times).
The next chart shows the top five attendance by matches. The match between Brazil and Uruguay had the highest attendance.
The last chart shows the top 10 goal scorers. Just Fontaine had the highest goals scored (13 goals) followed by Sandor Kocsis (11 goals), Gerd Müller (10 goals) and Eusébio (9 goals). Ademir, Guillermo Stabile, Kylian Mbappe and Ronaldo all had 8 goals. Grzegorz Lato and Leonidas each scored 7 goals.
In summary, the highest attendance ever recorded was in 1994. Also, by stadium, the highest attendance was in Macarana Stadium in Rio de Janeiro. Brazil is the only country to have won the world cup title five times.
End of documentation...