Exploratory Data Analysis: 120 Years of Olympics History - Python Web App
This is an Exploratory Data Analysis project to analyze the modern Olympic Games, including all the Games from Athens 1896 to Rio 2016. This analysis provides an opportunity to ask questions about how the Olympics have evolved over time, including questions about the participation and performance of women, different nations, and different sports and events.
The dataset is collected from here. The dataset contains two files: athlete_events.csv and noc_regions.csv.
The file athlete_events.csv contains 271116 rows and 15 columns. Each row corresponds to an individual athlete competing in an individual Olympic event (athlete events). The columns are:
- ID - Unique number for each athlete
- Name - Athlete's name
- Sex - M or F
- Age - Integer
- Height - In centimetres
- Weight - In kilograms
- Team - Team name
- NOC - National Olympic Committee 3-letter code
- Games - Year and season
- Year - Integer
- Season - Summer or Winter
- City - Host city
- Sport - Sport
- Event - Event
- Medal - Gold, Silver, Bronze, or NA
The file noc_regions.csv contains 230 rows and 3 columns. Each row corresponds to an individual region. The columns are:
- NOC (National Olympic Committee 3 letter code)
- region
- notes
This project is deployed on Streamlit Community Cloud. You can access the web app here.
Note: All the graphs and charts are interactive. You can hover over the graphs and charts to get more information. You can also download the graphs and charts in png format.
The web app provides a brief overview of the dataset. It provides users to choose between 4 options to explore the dataset. The options are:
- Medal Tally
- Overall Analysis
- Country-wise Analysis
- Athlete-wise Analysis
This section provides the medal tally of all the countries that have participated in the Olympics. The medal tally is displayed in a table format. The table can also be filtered by selecting the Country Name and Year from the dropdown list.
This section provides the overall analysis of the Olympics. It provides information like:
- Top Statistics of the Olympics (Edition, Hosts, Sports, Events, Nations, Athletes)
- No. of countries participating in the Olympics over the years (Line Graph)
- No. of events organized over the years (Line Graph)
- No. of athletes participating over the years (Line Graph)
- Correlation between the no of Events for each and every Sport w.r.t Year (Heatmap)
- Table of top 15 athletes who have won the most number of medals in the Olympics. This table can also be filtered by selecting the Sports Name from the dropdown list.
This section provides a country-wise analysis of the Olympics. It contains a dropdown list where user can select Country Name, based on that the section will display the following information:
- Medal Tally over the years for that country (Line Graph)
- In which sport does the country excel the most (Heatmap)
- Top 10 athletes of that country (Table)
This section provides an athlete-wise analysis of the Olympics.
- Distribution of Age of the athletes for Winning Medals (Curves)
- Distribution of Age w.r.t Sports only who have won Gold Medals (Curves)
- Gender Ratio with Height vs Weight of the Athletes. Here users can select a Sport as per their choice from the dropdown list. (Scatter Plot)
- Men Vs Women Participation Over the Years (Line Graph)
- Clone the repository using
git clone https://github.com/Mohitur669/Olympic-Data-Analysis-WebApp.gitin the terminal - Install the required libraries (mentioned in requirements.txt)
- Run the command
streamlit run app.pyto run the app locally - The web app will open in the browser
I am Mohd Mohitur Rahaman, and currently, I am pursuing MCA from KIIT University, Bhubaneswar. Talking about my previous educational background, I did my BSC in Mathematics at Malda College.
If you have any feedback, you can make the changes and create a pull request or, please reach out to me at here or LinkedIn.