Exploratory Data Analysis on Olympic Dataset

Overview

This repository contains the exploratory data analysis (EDA) conducted on the Olympic dataset using SQL. The dataset consists of information about individual athletes participating in Olympic events, including details such as athlete's name, age, height, weight, team, NOC, games, sports, events, and medals.

Queries Solved

1. How many Olympic games have been held?
2. List down all Olympics games held so far.
3. Mention the total number of nations that participated in each Olympic game.
4. Which year saw the highest and lowest number of countries participating in the Olympics?
5. Which nation has participated in all of the Olympic games?
6. Identify the sport played in all summer Olympics.
7. Which sports were played only once in the Olympics?
8. Fetch the total number of sports played in each Olympic game.
9. Fetch details of the oldest athletes to win a gold medal.
10. Find the ratio of male and female athletes who participated in all Olympic games.
11. Fetch the top 5 athletes who have won the most gold medals.
12. Fetch the top 5 athletes who have won the most medals (gold/silver/bronze).
13. Fetch the top 5 most successful countries in the Olympics (defined by the number of medals won).
14. List down total gold, silver, and bronze medals won by each country.
15. List down total gold, silver, and bronze medals won by each country corresponding to each Olympic game.
16. Identify which country won the most gold, most silver, and most bronze medals in each Olympic game.
17. Identify which country won the most gold, most silver, most bronze medals, and the most medals in each Olympic game.
18. Which countries have never won a gold medal but have won silver/bronze medals?
19. In which sport/event, India has won the highest number of medals?
20. Break down all Olympic games where India won a medal for Hockey and the number of medals in each Olympic game.

Instructions

1. Dataset: The dataset used for this analysis is available in the athlete_events.csv file.
2. Queries: SQL queries used for analysis are provided in the SQL script file.
3. Notebooks: Jupyter notebooks or SQL notebooks used for analysis can be found in the notebooks directory.

Usage

Clone the repository and explore the provided SQL script to understand the analysis steps and findings.

License

This project is licensed under the MIT License.

Acknowledgements

• Dataset Source: Kaggle - 120 years of Olympic history: athletes and results

Feel free to contribute, suggest improvements, or report issues.