INFORMATICS
PRACTISES
Project
Olympics Medals vs
GDP – Exploratory
Data Analysis
Project Report
NAME:- Shreeja Bose
CLASS:-12th D
ROLL NO.:-40
SCHOOL:-MPVM
Guided by:-Mr. Rakesh Pathak
INDEX
S NO. TOPIC PAGE NO.
ACKNOWLEDGEMENT
I WOULD LIKE TO EXPRESS MY SINCERE GRATITUDE TO MR.
RAKESH PATHAK, MY PROJECT GUIDE, FOR PROVIDING
CONTINUOUS SUPPORT, CONSTRUCTIVE FEEDBACK, AND
VALUABLE GUIDANCE THROUGHOUT THE DEVELOPMENT OF
THIS EXPLORATORY DATA ANALYSIS PROJECT TITLED
OLYMPICS MEDALS VS GDP – A COMPARATIVE
EXPLORATORY STUDY.
I AM ALSO THANKFUL TO THE FACULTY MEMBERS OF *MPVM*,
WHO HAVE HELPED BUILD A STRONG FOUNDATION IN DATA
SCIENCE CONCEPTS, ENABLING ME TO SUCCESSFULLY
COMPLETE THIS ACADEMIC PROJECT.
I EXTEND MY APPRECIATION TO THE CREATORS OF PUBLICLY
AVAILABLE DATASETS AND PYTHON LIBRARIES SUCH AS
*PANDAS, NUMPY, MATPLOTLIB, AND SEABORN*, WHICH WERE
ESSENTIAL TOOLS IN ANALYZING AND VISUALIZING DATA.
FINALLY, I THANK MY FAMILY AND CLASSMATES WHOSE
ENCOURAGEMENT PLAYED A SIGNIFICANT ROLE IN
COMPLETING THIS PROJECT EFFECTIVELY.
CERTIFICATE
This is to certify that Shreeja Bose, of MPVM, has successfully
completed the project titled:
### Olympics Medals vs GDP – Exploratory Data
Analysis###
under the guidance of Mr. Rakesh Pathak as part of the
academic requirements for the course.
This project is original, and all work has been carried out
independently.
INTERNAL SIGNATURE EXTERNAL SIGNATURE
------------------------------------------- -------------------------------------------
INTRODUCTION
The performance of countries in the Olympic Games has always been an
important indicator of national strength, sports development, and international
presence. Similarly, *Gross Domestic Product (GDP)* is a widely used
measure of economic prosperity. Understanding the relationship between
*economic capability* and *Olympic success* can provide meaningful insights
into the interplay between wealth, sports infrastructure, and national priorities
This study attempts to answer key questions such as:
* Do richer countries win more Olympic medals?
* Does higher GDP correlate with more athlete participation?
* Is sports diversity influenced by economic resources?
* How do demographic features of athletes compare across nations?
To address these questions, this project performs a complete Exploratory Data
Analysis (EDA) using:
* A *global GDP dataset (2020–2025)*
* A curated *Olympics athletes dataset (sample_100)*
The datasets were cleaned, merged, processed, and analyzed using Python.
Multiple visualizations were generated, including scatter plots, bar charts, heatmaps,
distribution plots, and trend graphs. The merged insights reveal the true statistical
relationship between GDP and Olympic success.
The EDA approach helps reveal hidden patterns, detect anomalies, uncover
correlations, and derive meaningful conclusions.
PROJECT OBJECTIVES
PRIMARY OBJECTIVES
1. TO ANALYZE GDP TRENDS OF COUNTRIES
BETWEEN 2020–2025.
2. TO STUDY OLYMPIC ATHLETE DEMOGRAPHICS,
SPORTS CATEGORIES, AND MEDAL DISTRIBUTION.
3. TO MERGE GDP AND OLYMPICS DATASETS FOR
CROSS-DOMAIN INSIGHTS.
4. TO EXPLORE THE RELATIONSHIP BETWEEN:
* GDP AND TOTAL MEDALS
* GDP AND ATHLETE PARTICIPATION
* GDP AND SPORTS DIVERSITY
* GDP AND DEMOGRAPHIC AVERAGES (AGE,
HEIGHT, WEIGHT)
Secondary Objectives
1. To visualize univariate and bivariate patterns
in both datasets.
2. To detect missing values and outliers.
3. To build an academic-grade EDA pipeline with
data cleaning, preprocessing, and visualization.
4. To interpret each chart and extract meaningful
observations.
5. To present insights supported by statistical
evidence.
Exploratory Data Analysis
Exploratory Data Analysis (EDA) is the initial stage of data exploration
where analysts summarize, visualize, and understand patterns within a
dataset. It helps to:
* Validate assumptions
* Detect inconsistencies or missing values
* Reveal underlying structure
* Identify relationships between variables
* Guide further advanced modeling
Types of EDA Used:-
1. *Univariate Analysis*
Analysis of a single variable (e.g., Age distribution, GDP distribution).
2. *Bivariate Analysis*
Studying relationships between two variables (e.g., GDP vs Medals).
3. *Multivariate Analysis*
Correlation heatmaps and multi-variable relationships.
4. *Missing Data Analysis*
Heatmaps and numerical summaries to identify incomplete data.
5. *Time-Series Trend Analysis*
Observing changes in GDP across multiple years.
EDA is essential for ensuring data quality and building meaningful insights.
System Requirements
Hardware Requirements:- Software Requirements:-
MINIMUM SOFTWARE PURPOSE
COMPONENTS
REQUIREMENT
Programming
Python 3.8+
language
Processor Dual-Core CPU
Jupyter Notebook Development
RAM 4 GB (8 GB recommended) / VS Code environment
Storage 500 MB free space Pandas Data analysis
Graphics Standard 2D graphics support
Numerical
NumPy
computations
OS Windows / Linux / macOS
Matplotlib Visualization
Statistical
Seaborn
visualization
PDF generation
ReportLab
(final output)
About the Dataset
This project uses *two datasets*, as referenced in your uploaded files:
* GDP Dataset (2020–[Link])
* Olympics Dataset (sample_100.csv)
Both datasets were analyzed extensively in the log output:
And processed using the Python script:
Sources
* *GDP Dataset:* Publicly aggregated World
Bank/IMF-style data
* *Olympics Dataset:* A curated sample of
athlete data containing demographic and
performance variables
Size & Duration
* *GDP Dataset:* 196 countries, 6 years
(2020–2025)
* *Olympics Dataset:* 100 athletes, ranging
between years 1896–2016
Description of Columns:-
### *GDP Dataset Columns*###
COLUMN DISCRIPTION
Country Name of the country
2020–2025 GDP values (in million USD)
NOC Mapped Olympic country code
Growth_2020_2023 Percentage GDP growth
### *Olympics Dataset Columns*###
COLUMN DISCRIPTION
ID Athelete ID
Name Athelete Name
Sex Gender
Age,Height,Weight Demographics
Team,NOC Country representation
Sports, Event Sports categories
Medal Gold/Silver/Bronze/None
Season Summer/Winter
Year Olympic year