KENDRIYA VIDYALAYA MHOW

A Project Report on:

OLYMPIC ANALYSIS SYSTEM.

Submitted By:
Name: VIKASH SHARMA.
Class: XII A.
Roll No: 12137.

Under the Guidance of:

Mrs.Manisha Dubey
PGT (Computer Science)
Kendriya Vidyalaya Mhow

INDEX
1. Certificate.
2. Declaration.
3. Acknowledgement.
4. Preface.

5. Objective of Project.

6. Requirement and Analysis.

7. Coding and programs.

8. Output Screens.

9. Limitations of Project and conclusion .

10. References.

CERTIFICATE
This is to certify that VIKASH SHARMA of class XIIA, has
prepared the report on the project entitled ‘OLYMPIC
ANALYSIS SYSTEM’. The report is the result of his
effort and endeavors. The report is found worthy of
acceptance as final project report for the subject of
Informatics Practices (065) of class XII under the
CBSE curriculum 2020-21. He has prepared the report
under my guidance.

Mrs Manisha Dubey

PGT(Computer Science)
K. V. Mhow

DECLERATION

I hereby declare that the project work entitled

‘OLYMPIC ANALYSIS SYSTEM’ submitted to
Department of Informatices Practices, KV Mhow
is prepared by me. All the coding and Project
report is result of my personal effort.

Name: VIKASH SHARMA

Class: XIIA
Roll No: 12137

Acknowledgement

I would like to express a deep sense of thanks & gratitude to my

project guide Mrs. Manisha Dubey Mam, for guiding me
immensely through the course of the project. She always
evinced keen interest in my work. Her constructive advice
&constant motivation has been responsible for the successful
completion of this project.
My sincere thanks go to Mrs. Pooja Srivastava ,Our principal
Mam, for her co-ordination in extending every possible support
and IT infrastructure for the completion of this project.
I also thanks to my parents for their motivation & support. I must
thanks to my classmates for their timely help &support for
compilation of this project.
Last but not the least, I would like to thank all those who had
helped directly or indirectly towards the completion of this
project .

Name: VIKASH SHARMA

Class: XII-A

PREFACE.

The sole reason of making this project is to celebrate

India’s best ever Olympic performance in Tokyo Olympics
2020.
The purpose of this project was to develop the Management
Information System (MIS) and to automate the record
keeping me medals with respective countries. It mainly
consists of computerized database, a collection of inter
related tables/CSV files, capable to produce different reports
according to the user. Using Application program (Python)
or front-end, we can store, manage, retrieve all information
in proper way. The software being simple in design and
working, does not require any prerequisite training to
users, and can be used as a powerful tool for
automating our “Olympic Analysis System”. To make
analysis much easier a user friendly interface was used
to keep records of countries in most detailed and
coordinated manner.
OBJECTIVE OF PROJECT :

The main objective of the project including the following:

*Goals to be achieved by this project?

Answer: This Analysis system is capable of analysing performance of

all countries in Olympic, Number of medal won, Number of times
country participated in Olympics visually as well as in tabular form.

* How it will be helpful to people associated to the work?

Answer: It helps us to answer question such as:

•What effect does the host country have in the medals won at the
Olympics?

•Is the performance of countries in Olympics games affected by the

economic factors of the country?

•Is the performance of countries in Olympics games affected by the

economic factors of the country?

REQUIREMENT AND ANALYSIS :

a)Aim:
To Develop Olympic Games Analysis System.

b)Front End:
a.) Sublime Text Editor.
b.) Microsoft Code Studio.
c.) Python 3.8.2.

c) Back End: My SQL Server 5.1.

d)Operating System: Windows 10.

e)Minimum Hardware and Software Requirements:

a.) x86 64-bit CPU (Intel / AMD architecture).
b.) 4 GB RAM.
c.) 5 GB free disk space.

f) Open Source Software being used:

a.) Python 3.8.2.
i.] Pandas.
ii.] Matplotlib.

PYTHON LIBRARIES USED

(PANDAS)
-Pandas is a high-level data manipulation tool
developed by Wes McKinney. It is built on the Numpy
package and its key data structure is called the Data
Frame. Data Frames allow you to store and manipulate
tabular data in rows of observations and columns of
variables.

<MATPLOTLIB>

-The Matplotlib Python library, developed by John

Hunter and many other contributors, is used to create
highquality graphs, charts, and figures. The library is
extensive and capable of changing very minute details
of a figure.

<ABOUT OLYMPICS>
 INTRODUCTION.

According to historical records, the first ancient Olympic

Games can be traced back to 776 BC. They were dedicated
to the Olympian gods and were staged on the ancient plains
of Olympia. They continued for nearly 12 centuries and still
continuing.

<THE GAME AND THE RELIGION>

The Olympic Games were closely linked to the religious
festivals of the cult of Zeus, but were not an integral part of
a rite. Indeed, they had a secular character and aimed to
show the physical qualities and evolution of the
performances .

<ABOUT OUR ANALYSIS SYSTEM>

This Analysis system is capable of analyzing performance

of all countries in Olympic, No. of medal won, No. of times
country participated in Olympics visually as well as in
tabular form. And it also helps to answer question such as:
•What effect does the host country have in the medals
won at the Olympics?

•Is the performance of countries in Olympics games

affected by the economic factors of the country?
•Is the age of winning Olympics changing?
<USES OF OUR PROJECT>

This program can be used to analyze the performance of different

countries in Olympics till now. This program can also be used for a
predictive model as to which country is likely to fetch the highest
number of gold in a particular sports category (just an example), etc.
This project consists of various graphs to analyze and represent data
which helps the user to draw a comparison between, and having a
glimpse of, different groups. It also helps get analyzed information in
a structured format making it easy to understand.

<HYPOTHESIS>
In this project of python programming function was used to make it
look more attractive and beautiful and connectivity of Python and
MySQL was much easier to understand in this way of programming.

Features:
1. Free from technical errors.
2. Time Saving.
3. Reduces manual work.
4. Data is analyzed through various methods – sort(), group
by, mean, median, mode etc.
5. Visualized data, e.g. Bar Chart, Pie Chart, Histogram etc.
6. User – friendly interface.
<DEMAND IN REAL WORLD>
It gives detailed analysis of the following:
1. Countries VS Total Medal
2. Countries VS Total no. of times participated (In Summer
& Winter)
3. Countries VS Total no. of Gold Medals.
4. Countries VS Total no. of Silver Medals.
5. Countries VS Total no. of Bronze Medals.
6. Distribution of Gold, Silver & Bronze Medals.
7. Country wise Gold, Silver & Bronze Medals.
8. Countries VS Total no. of Medals (In Summer & Winter)
Number of Countries (Gold, Silver and Bronze Medals)

<BUILT-IN FUNCTION USED>

<PANDAS>
1. read_csv(): This function is used to read data from csv files to form a
dataframe.
2. head(): Head function is used to fetch n number of rows from Pandas
object.
3. tail(): Tail function returns last n rows from Pandas object.
4. append(): The append method adds an item to the end of the list.

5. drop(): drop function is used to drop specified labels from rows and
columns
6. rename(): Rename function is used to change name of any row or
column.
7. min(): Min function finds out the minimum value from given set of
data.
8. max(): Max function finds out the maximum value from given set of
data.
9. sort(): Sort function arranges value in Pandas object ascending and
descending order.
10. info(): Info Function is used to print a concise summary of dataframe.

<MATPLOTLIB>
1. bar(): It is used to plot a bar chart in matplotlib for a given set of data.
2. hist(): Hist function allows us to create and plot histogram for a given
set of data.
3. xlabel(): It is used to set label for X axis.
4. ylabel(): It is used to set label for Y axis.
5. title(): Title function is used to add title to the plot.
6. show(): It is used at the end to show plot as per given specification.
-CODING AND PROGRAMS.
<DATABASE AND TABLE DESIGN >
<OUTPUT SCREENS>
#1
#2
#3

#4
#5
<LIMITATIONS>
Despite being best efforts of the developer, the
following limitations and functional boundaries are
visible, which limits the scope of this application.
1. The software can store records and produce
reports in pre-designed format in soft copy.
There is no facility to produce customized
reports.
2. This is an offline project.
The module or function can be designed and
embedded to handle the user need in future. Any
part of the project can be modified without much
effort.

<CONCLUSION>
Python is one of the simplest programming
languages that are used for variety of applications.
We can also focus on the areas for regular updates
and version advancements in future of this project.
Completing this project I have received a lot of useful
knowledge.
REFERENCES
 Book Used: SUMITRA ARORA
Informatics Practices Python, Class 12.
 www.python4csip.com
 www.stackoverflow.com
 www.github.com
 www.w3schools.com
 www.cbse.nic.in
 www.geeksforgreeks.com

Prepared By: VIKASH SHARMA

<THANK YOU>