5 Minute Analysis
Olympics, Rising Competition and Equality
This blog post explores and analyzes the data using PivotBillions, available freely on docker.
Exploring the Kaggle historical Olympic athletic data in real-time, filtering the data, and pivoting the data in various ways to understand the trends in participation by country and by sex over time.
You can now see the columns and types of the dataset and modify them as you see fit. You can also view or change which column or columns are set as primary keys. When you are done viewing or modifying the data structure to be imported, click Import.
After the data has been quickly imported you can now see and access all 271,116 rows of the data.
By hovering over each column name you can sort the data by that column, view that column’s distribution over all of the data, filter by the data in that column, or rename that column. Let’s filter all of the data by season.
All of the data is immediately filtered to data regarding the Olympic Summer Season.
Now that we’ve separated the seasons, let’s reorganize our data to dive into gender equality.
Pivot Billions now quickly reorganizes your data by gender, country, and Olympic games for the summer season. It also provides counts of the occurrence of each unique combination of these attributes in the data. You can sort by a column or filter the data. Here we’ll add a filter to restrict the data to just that of the United States.
You can see the filter immediately applied and the data reduced from 6,408 unique combinations to just the 52 unique combinations for the United States Team.
We’ll now interactively view the data.
It is pretty clear that there is a rising trend of female participation and equality in the US Olympic Team during the summer season. It is also worth noting that the 2016 Summer Games were the first games with higher female participation than male for the US Team.
Now that we’ve discovered rising equality for the US Team, let’s reorganize our data to take a look at each country’s participation in the Olympics.
Over the years there has definitely been a large increase in the countries participating in the Olympics, though in recent Summer Games the increase has been minor. We can easily view the total participants for each Team by hovering over any of these data points or we can switch the graph type to continue to interact with and explore the data.
All of our analysis so far has been based off the summer season. Pivot Billions makes updating our analysis to reflect the winter season extremely easy.
That’s it! All of our data, pivots, and analyses are automatically updated to reflect only the Olympic Winter Season.
By scrolling down on your page you can see the updated analyses:
We can still see our trends in increased gender equality and olympic participation; however, the US Winter Team still has some room to improve to reach full gender equality.