Olympics
This project presents an examination of Olympic
data sourced from Kaggle. The key variables under consideration in this
analysis are Sex, Teams, NOC, Year,
Sport, and Medal. The focus of this study is directed
towards the collective performance of teams rather than individual
athletes.
The analysis will delve into the relationship between Medal and NOC, providing insights into the overall performance of countries.
During the data cleaning process, Sex and Medal were converted into categorical factors to facilitate a more effective analysis.
| ID | Name | Sex | Age | Team | NOC | Year | City | Sport |
|---|---|---|---|---|---|---|---|---|
| 1 | A Dijiang | M | 24 | China | CHN | 1992 | Barcelona | Basketball |
| 2 | A Lamusi | M | 23 | China | CHN | 2012 | London | Judo |
| 3 | Gunnar Nielsen Aaby | M | 24 | Denmark | DEN | 1920 | Antwerpen | Football |
| 4 | Edgar Lindenau Aabye | M | 34 | Denmark/Sweden | DEN | 1900 | Paris | Tug-Of-War |
| 5 | Christine Jacoba Aaftink | F | 21 | Netherlands | NED | 1988 | Calgary | Speed Skating |
The chart illustrates the distribution of medals—gold, silver, and bronze—across various years. The data indicates a general upward trend in medal counts over the years. Notably, there are gaps in the information, suggesting instances where no data was collected for certain years. Around 1990, there is a noticeable decrease in medal counts for specific years. This decline might be attributed to the Winter Olympics, as many countries tend to participate less in the Winter Games compared to the Summer Olympics.
How has the distribution of gold, silver, and bronze medals changed over the years?
This bar plot illustrates the nations that consistently secured the highest medal counts each year.
Which countries have historically dominated the Olympics in terms of total medals won? Create a bar plot.
Medals and Sports
Compare the medal counts for different sports. Which sports tend to have the most medals awarded?
Gold
| Sport | Medal | n |
|---|---|---|
| Swimming | Gold | 1099 |
| Rowing | Gold | 978 |
| Gymnastics | Gold | 791 |
Sliver
| Sport | Medal | n |
|---|---|---|
| Swimming | Silver | 993 |
| Rowing | Silver | 977 |
| Gymnastics | Silver | 746 |
Bronze
| Sport | Medal | n |
|---|---|---|
| Rowing | Bronze | 990 |
| Swimming | Bronze | 956 |
| Gymnastics | Bronze | 719 |
Visualize the age distribution of athletes participating in the Olympics. Are there any trends over time?
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 10.00 21.00 24.00 25.56 28.00 97.00 9474Heatmap
Create a heatmap to show which countries perform well in specific sports. Are there any patterns?
Heatmap that shows medal count of countries throughout time in specific sports.
GOLD
SILVER
BRONZE
Track the gender distribution of athletes over the years. Has there been an increase in female participation?
Olympic performace over multiple editions
Plot the winning trends of a specific country’s Olympic performance over multiple editions.
Analyze the host country’s performance in the Olympics they hosted. How does it compare to their performance in other editions?
Looking at twenty counties with the highest medal counts, I will be taking the top 5 countries and comparing them to each other when they are hosting.
The URS, representing the Soviet Union, participated in the Olympics from 1952 to 1988. Despite their relatively brief presence at the Games, they remain the top country in terms of total medals achieved.
FRA
France hosted the Summer Olympics in London in 1900 and 1924, and the Winter Olympics in Grenoble in 1968.
GBR
The Summer Olympics were hosted by Great Britain in London during the years 1908, 1948, and 2012.
GER
Germany hosted the Summer Olympics in Berlin in 1936 and Munich in 1972, as well as the Winter Olympics in Garmisch-Partenkirchen in 1936.
USA
The United States has been the host for numerous Summer and Winter Olympic Games across different cities and years. Notable locations include St. Louis in 1904 (Summer), Los Angeles in 1932 (Summer) and 1984 (Summer), Lake Placid in 1932 (Winter) and 1980 (Winter), Atlanta in 1996 (Summer), Salt Lake City in 2002 (Winter), Squaw Valley in 1960 (Winter), and Melbourne in 1956 (Summer), where it co-hosted with Australia.
URRS
The Union of Soviet Socialist Republics (USSR) was a federation consisting of multiple socialist republics, including Russia, Ukraine, Belarus, Uzbekistan, Kazakhstan, Georgia, Azerbaijan, Armenia, Moldova, Kyrgyzstan, Tajikistan, and Turkmenistan. Following the collapse of the USSR, only Russia has hosted the Olympic Games. Subsequently, Russia is the sole successor to have hosted the Olympic Games, organizing the Summer Olympics in Moscow in 1980 and the Winter Olympics in Sochi in 2014.