The Tokyo2020 Olympics ended on the 8th August and it’s always interesting to see the final results table with the winners. Looking at the list, it’s easy to notice that countries with money are at the top, which is not really a surprise as these countries are able to invest more into sports.
In my curiosity, I wondered what the data actually showed, i.e., the correlation between the medals won by a country and its annual GDP. This also gave me a chance to learn some new data exploration techniques.
I created a Tableau Dashboard looking at the trend between the medals won and the annual GDPs of countries, for the 2020, 2016 and 2012 Summer Olympics. The Dashboard can be found HERE.
Looking at the 2020, 2016 and 2012 Summer Olympics:
– We can see a clear trend, correlation between the number of medals won and the annual GDP. This same trend is visible even when looking at the GDP per Capita, though I did include this in the Dashboard.
– The visualization also shows the distribution of the medals won across the countries and the continents. From here we see that the USA and China lead in the numbers.
Data collection and cleaning
GDP data and the Olympic results were collected into an Excel Workbook, with different sheets containing the GDP data as it was in the respective Olympic year, and the Olympic results were recorded in three separate Sheets. Python’s Pandas was utilized to clean the data, and combine them into a format that I could easily import and use with Tableau.
Cleaning the data involved resolving some country information, for example in the Tokyo 2020 Olympics, Russia was not officially participating, but they had a team there under the name Russian Olympic Committee (ROC). GDP data is usually not recorded for Great Britain, but the United Kingdom.
Data sources:
Annual GDP data: 2021, 2016, and 2012
Olympic data: 2021, 2016, and 2012
About me: http://myriammunezero.com/
#continouslearning #dataanalysis #data #visualization #python #Tableau #excel #actualizedlife