DAV PUBLICSCHOOL, JASOLA VIHAR

SESSION: 2024-25

INFORMATICS PRACTICES
CLASS XIIPROJECT
ON
SWIMMING ATHLETES

NAME:KHUSHYALI
[Link].: 14696616
 ACKNOWLEDGEMENT

It would bemy utmost pleasure tothank my

Informatics Practices teacher Ms. Jaity
Kautilya for giving me this knowledgeable
topic "SWIMMING ATHLETES"and supporting
me during the course of this project. I would
also like tothank myparents and God for
encouraging me and giving me strength to
complete this project on time.
 Hardware and Software Requirements
. Processors: Intel Atom° processor or Intel° Core"" i3
processor.

" Disk space: 1 GB.

Operating systems: Windows* 7 or later, macOS, and Linux.
Python* versions: 2.7.X, 3.6.X.
Google Colab

CSVFile:
Swimming Athlete Table

File Home Insert Page Layout Formulas Data Review View Developer Help 9 Search

X Cut Calibri General

Paste
E Copy -
Format Painter BIU -A === Merge &Center q-%A
Clipboard Font Ahgnment Nunber

D25

A R C H
1 Athlete Age Country Year Sport Gold Meda<s Silver Medals Bronze Medals
2 Michael Phelps 23 United States 2008 Swimming 0 0
3 Michael Phelps 19 United States 2004 Swimming 6 2
4Michael Phelps 27 United States 2012 Swimmipg 4 2
5 Natalie Coughlin 25 United States 2008 Swiprming 2 3
6 Alicia Coutts 24 Australia 2012,Swimming 3
7 Missy Franklin 17 United States 2912 Swimming 4 1

8Ryan Lochte 27 United States 2012 Swimming 2 2

9 Allison Schmitt 22 United States 2012 Swimming 3 1 1

10 Natalie Coughlin 21 Unitedslates 2004 Swimming 1
11 lan Thorpe 17 Arstralia 2000 Swimming 3 2
12 Dara Torres 33 United States 2000 Swimming 2 0 3
13 Sun Yang 20 China 2012 Swimming 2 1 1
14 Kirsty Coventry 24 Zimbabwe 2008 Swimming 1 3 0
15 Libby Lenton-Trickett 23 Australia 2008 Swimming 2 1 1
16 Ryan Lochte 24 United States 2008 Swimming 2 2

17 Inge de Bruijn 30 Netheriands 2004 Swimming 1 1 2

18 Petria Thomas 28 Australia 2004 Swimming 3 1

19 lan Thorpe 21 Australia 2004 Swimming 2 1

20 Inge de Bruijn 27 Netherlands 2000 Swimming 3 1

21 Gary Hall Jr. 25 United States 2000 Swimming 2 1 1
22
23
24
25
26
27
28
29
SwimmingAthletes
Ready

o Type here to search

Coding:
#Swimming Athletes
import pandas as pd
import [Link] as plt
# Main Menu
data/SwimmingAthletes1 . csy",index c
resultpd. read csv("/content /sample
ol=0)
while (True) :
print("Main Menu )
print ("1. Display Records ")
print ("2. Working on Records ")
print ("3. Working on Columns ")
print ("4. Search specific row/ column")
print ("5. Data Visualization")
print ("6. Exit")
ch=int (input ("Enter your choice"))
if ch=1:
while (True) :
print ("Display Records Menu")
print ("1. Top 5 Resords ")
print ("2. Bottom 5 Records")
print ("3. Specific number of records ffom the top")
print ("4. Specific number of records from the bottom")
print ("5. Particular Detail")
print ("6. Display Complete etails")
print ("7. Exit")
ch3=int (input ("Enter hoice"))
i f ch3==1 :
print ([Link] ())
elif ch3==2 :
print ([Link] 0)
e l i f ch3==3:
n=int (input ("Enter how many records you want to display from the
top") )
print (result. head (n) )
e l i f ch3==4:
n=int (input ("Enter how many records you want to display from the
botton ") )
print ([Link] (n))
elif ch3==5 :
st=input ("Enter Athlete name for which you want to see the detai
ls")
print ([Link] [st] )
elif ch3-6:
print ("Complete Details")
print (result)
e l i f ch3==7:
 break

elif c h 2 :
while (True) :
Records Menu")
print ("Working on
record")
print ("l. Insert a
specific record")
print ("2. Delete a
specific record")
print ("3, Update a
print ("4. Exit")
choice") )
ch4-int (input ("Enter
if ch4 l:
Athlete name")
a-input ("Enter
b=int (input ("Enter Age:"))
c=input ("Enter Country:
")
d=int (input ("Enter Year"))
e=input ("Enter Sport ")
number of Gold Medal "))
f=int (input ("Enter
g=int (input ("Enter number
of Silver medal"))
h=int (input ("Enter number
of Bronze medal") )
[Link] [a]=[b,C, d, e, f,g, h)
inserted")
print ("Data success fully
elif ch4==2:
name whose data needs Xo be deleted")
a=input ("Enter Athlete
[Link] ( [a),inplace=True)
deleted")
print ("Data success fully
elif ch4 ==3:
name")
a-input ("Enter Athlete
b=int (input ("Enter Age:"))
c=input ("Enter Count ry:")
d=int (input ("Enter Year )
e=input ("Enter Sport ")
Gold Medal ") )
f=int (input ("Enter Aumber of
Silver medal") )
g=int (input ("Enter number of
Bron ze medal "))
h=int (input (WEnter number of
result. loc[a]= [b, c,d, e,f,g, h)
print ("Data success fully updated")
elif ch4==4:
break
e l i f ch==3:

while (True) :
Menu")
print ("Working on Columns
data")
print ("1. Insert a new column
print ("2. Delete a specific column")
print ("3. Exit")
ch5=int (input ("Enter choice") )
if ch5 ==1:
print ("Enter details")
h=input ("Enter column/heading name")
 detweval (input ("Enter details corresponding to all items: (enclo
sed in [)"))
result [h] pd. Series(data=det, index=[Link])
print ("Column inserted")
elif ch52:
a=input ("Enter column name which needs to be deleted")
result. drop( [a),axis=1, inplace=False)
print ("Co lumn Temporary deleted" )
elif ch5==3:
break

elif ch==4:
while (True) :
print ("Search Menu")
print ("1. Search for the details of a specific Athlete")
print ("2. Search details of a specific as per a specific column he
ading")
print ("3. Exit")
ch6-int (input ("Enter choice"))
if ch6==1:
st=input ("Enter the Athlete name whose details you want to see")
print (result . loc [st] )
elif ch6==2:
col=input ("Enter column/heading name whose details you warnt to s
ee")
print (result [col])
elif ch6==3:
break

elif ch==5:
while (True) :
print ("Data Visuali zationMenu")
print ("1. Line Plot"))
print ("2. VerticalBar Plot")
print ("3. Horizontal Bar Plot")
print ("4. Histogram'")
print ("5. Exit")
ch7=int (input ("Enter choice") )
if ch7==1:
[Link] (kind='line')
[Link] ()
elif ch7==2 :
[Link] (kind='bar')
[Link]()
elif ch7==3:
result .plot (kind= 'barh')
[Link] ()
elif ch==4:
[Link] (kind='hist ')
[Link] ()
 elif ch5:
break
else:
break

Output Screens:

t ocolatb reseorch gogiecom drive/thsieE rcfydktHo32 hFctsrolfouPuyyenl

+ Code 4 Tot
EFles
1. Display Records
orkang on Kecords
4. Search specific rowj colunn
sample deta 5. Data Visualízation
6. Exit
R AEADME md Enter your ch0icel
[Link] Di splay Records Menu
1. Top 5 Resords
anscombe json
celifornia housing test csv records from the
california_housing_ [Link] 4. Specific number of records from the bott
bottom
5. Particular Det ail
mnist test. csv 6. Display Complete details
7. Exit
mnisttrain_smallesv
Enter choice1
[Link] Ag Country Silver Nedals Rronze Medals
[Link] Athlete
Michael Phelps United States
Michae) Phelos 19 United States
Michael Phelps 27 United States
Natalie Coughlin 25 United States
Alicia (outts Australia

5 rows
Displav Bec
1. Top5 Resords
2. Bottom 5 Records
3. Specific nunber of records from the top
4. Specific nunber of records from the bottom
5. Particul ar Detail
splay Complete details

Fnter choice2
7568 GE araiabie Age Country *.. Silver Medals Bronze Medals
211a12sapiexis clotheszs R airline xs R excel-soreacsheetxs 0 semgle csv file-forcs sample datahockey tip Show ait

D Tyue here to search

113
ENG
10-02-2021
Poectont-Colatoratcr
X
[Link]/1hastE-y0 xovyydkfHo32 stfc4solloPKluvyyerni
X 4 Code + Text RAM 1
Files
Disk
AEnter choice2
Aye Country ... SKer Medals Bronze Medals
Athlete
Jnge de Bruijn Netherlands
2
Petna honas 28 Australia
B sample data
1
[Link] Inge de Bruijo 22 Nel

[Link]
Gary Hall 3r. 25 Unisá States 1

R [Link] (5 rows x 7 col umns

R calfornia_housing test csv Display RecordsMenu
Top S Kesords
calfornia_housing train .csv 2. BottoB3 Records
nst_lestcsw r o the top
4. 85eLifis onlert s
records from the bottom
mnist train [Link] Particular Detail
[Link] 6. 0isplay Complete details
7. Exit
satngiedatasafety csv Enter choice3
Enter how nany records you wänt to display from the top1
Age Country . Silver Medals Bronze Medals
Athlete
Michael Pielps 3 United States.
[1 ros x/ col unns
Display Records Menu
Top 5 Resords
2. Buttom 5 Records
er ef records from the ton
records tron the botton
S. Particalar Detail
Display Conplet details
7. Lxit
Leter choice4
Dk 75 68 GR aaie nter hca nany records you nant to disglay fron the
bat tom)
2Tlwelesegea airtine ad
excelsoreasheets sanple datahockezt Shoe a
D ype here to search
ENG
10-02202)
 teter ces
bes

ing

6. Disp)ay Coelete etails

heek
Conplete betaits

P hee ath

Dode4 Text
Fles
Enter choicee
Cosplete Details
Age Country Silver Hedals Bronze Medals

Phe Les 23 nited States

amcke,uta Michae) Pules lted States
Michael Phelps 27 nited States
README m Natalie Coughlie 25 ni ted States
Swiigkihiest c
ansconbejon Ryan Loc hte 27 Unjted States
aomi,[Link] Allison Scheitt 22 nited States
olo housing train csv Natalie Coughlin 21 nited States

iLestcv Daa Les

meit a, snal cav Sun Yang
Kirsty coventry 24 timbabue
ayerDutacsv y Lenton rickett ustral1a
mpedaasalety cav
Inge de Bruijn 30 Netheefonds
Petria lhanas Astralia
lan Thorpe 21 Aastralia

Gary Hall 3e

[20 rosT colys)

Display Kecorgr enu
2 BattS Necoeds
34 Sfcific nuber of records fno the top
Specific nuer af records frca the bottos
Disela tomclete drtalUs
Exit

ouhesals ie oheet eke

Sype her lo sear
 4 Code 4 Text
Faes Main Meru
1. Display Records
2. Norking on Records
3. Working on oluens
4. Search speeifie row/column
sainpledata s, Data Visualizotion
README me
your choice2
R SwinmingAthletes1 csy Horking on Records enu
R anscombe json 1. Insert a record
2. Delete à specific record
R calfornie housing [Link] 1. Update a specifíc record
califonia hounkne. traincev 4. Exit

Rmnist_test esv Enter e nancLisa

mnist_train,sinall csy Enter Age:25
Enter Countryi Canata
playerDeta cs Enter Year20es
sempledatasafety esv Enter SportSwiingR
Enter number of Gold Redali
Enter h o e medall
Data successtful ly in serted
Working on Records Menu
1. Jnsert à record
2. Delete a specifit record
3. Update a specific record

choice2
Fnter Athlete nane ehose data needs to be deletedt isa
Data successful ly e leted
Working on Records Renu
1. Insert a record
Delete a spec1t2c record
3. Update a specifi recore
Disk 75.68 G8 availabie
sample csv lefor. sv E sanpledatahockeyzip
S21uet2sampleats othesxh adinexs Bexcet sproadshects
1144
10-02-2021
O Type here to search

Proectt ioynt Colboratoey

colabresearchgoogie com/dr ive:1hSibE-quy0 KofvyydktHo32 thficscrcllTo= PK&uvy2yomu
RAM
Disk
+ Code + Text
E Files
Enter choice2
Enter Athlete nane whose data needs to be deletedL isa

Data Success ee

1. Insert a record
B sample data 2. Delete a specific record
3. Update a specific record
README md
4. Exit
[Link] Enter choices
nge de Bruiin
anscombe json Enter Athlete namel
california housing_test.csy Enter Country: Canada
Enter Year20e8
colifomia housing_train.csv
Enter Sport Swiumi ng
nist_test.csv Enter number of Gold Medall

moist train [Link] Enter nunber OT D a d a

[Link] Lece&fly update
sampledatasafety. csy Working on Records MenG
1. lnsert a record
2. Delete a specific record
3. Update a specific record
4. Exit
Enter oiced
Display Records
2. Working on Records
3. Working on Coluans
4. Search specífic row/calunn
5. Data Visual izat ian
6. Exit
oår choice3
on Colunns Henu
1. Insert a new coluan dat a
2. Delete a specifii culus
7568 GB arailabie
anoedatahockev2e
txcel-soreacsheete
13mplecs-tle4os ch
iine ds
Rdothes ds

Iype here to search

w
 Code4 lext
FRes Warking on ketorts Menu
1. tsert a reoat
record
sEiit record
4. Ext

saple, tata Enter cheicet

Main e u
README md Becerds
[Link]
1. Workng on Colunns
anscembe json Search spec ific rou/column
[Link] Data Visualiration
callonia, houning. train cev
Enter your choice3
Rmnist, testcv Working on Coluns Menu
R mnit train, nall csy 1. Insert a new colun data
2. Delete a specific coluen
R playerData csv
Psompledatasafety csv Ente cholcel
Enter detalls
Enter colunn/heading nametest
Enter details corresponding to all itensi (enclesed in | )|8, 8, 8, 8,8,8,8,8, 8, 8, 8,8, 8, 8, 8, 8,8, 8, 8, 9]

Horking on Colunns Menu

1. Insert a new colunn data
2. Delete a specifir coluen
Ex
cholce
Enter colunn name which needs to be de letedtest
Column Tesporary deleted
Working on Coluns Menu
data

spe
1. Exit

7568 GA available
Enter choice3
Main Aon1s

dothsss [Link] l escel soreadsheet d sample csu fle torc wnpkedatahockey zip
21wkt2semplets
114
18 Type here to search
Prokeett ioynt Coluboratcry
colabyesarch.oo0glecom/drive/ thuSbE-gvo ovydkf lo32 ihfccorcliTo=PKuy2yor
RAM
+ Code Text Disk
E Files
Oter colunn/heading nanctest
Enter detai ls corresponding to all ites: (enclosed in [ D[8,3, 8,8,8,8,8,6,8, 8, 8,8, 8,8,8,8,5,9,9,9]
Column inserted
Workins on Columns Henu
sample_data
README md 2. Delete a specific cMunn
3. Exit
[Link] Enter choice2
needs to be deletedtest
[Link] vdeleted
P califonia_housing [Link] Working on Columns Henu
califomia_housing [Link] 1. hsert a new column data
mnisttest cev ZDelete a specifit colunn
mnistLIrain [Link] Enter choices
R playerData. csv Main Menu
1. Display Records
P [Link]

4. Searh specific row/column

5. Data visualization
6. Exit

o Prortlioyrt Clatotalcry
colahreseach g00gecom/drive/thsibE-qby0 xoFwydkfHn32 hFeiesurcllo PKAeVyyernU
RAM L
4 Code + lext
EFiles
break

a Main Henu
1. Display Records
2. Working on Records
Be sanpie data 3. Working on Columns
README md
S. Data Visualizat ion
P SwinningAthletes [Link] 6. Exit
anscombe json Enter your choice4
Search Penu
P california_housing test csv for the details of a specific Athlete
california housing [Link] 2. Search details of a specific as per à specific colunn heading
3. Exit
nnist_test csy
Enter choicel
R mnist train, srnall csy Enter the Atthlete name whose details you want to seesun Vang
[Link] China
Country
Psampledatasafety cuy Year 2012
Sport Swimuing
Lold heas
Beonze Medals
Nane: Sun Yang, dtype: object
Searh Neu
1. Searh for the detali$ of a SPeITC Athiete
details fa spec1fic as per cific colus heading
Specif

Enter choice2
Enter col unnj he ading nane whose details you want to seelountey
Athlete
Pheles United States
Michael Pheles United States
Michael Plhelps United States
756A GR avbie hatalse toughlin Lnited States
Cik
alne als ceisueacaheet 0 sple seelo snpledatahuckeytip
M21leklienpee clotheals

S lype hee lo seaach

 &Oode 4 Tet
Fes

D Nisy raskiin IItet States

yan t t e
le dats Natalie Coughli Ihifed States
ln Thope Astralla
Nara Terres nited States
SiegAihetes c Sen Van
coneejm Kirsty Coventry Zisbs
1Ehhy Letn Tr ickott Astral ia
calfenesg es e yan LDchte 1ited States
estfo houinaih cv ge de Bruljn
iest c honas
Astealia
mitrein,smal e Inge de Broi jn ether l ands
tary Nal) 3e. nited States
plyebeta cv Naei Country, dtvoes ob ject
sepledatasafet cy Search Menu
1. Search for the detalls of a specific Athlete
2. Search details of a specific as per a specific celu heading

Feter choice)
Main Heu
1. Display Records
2. korking on Pecords
3. Working on Columns
Search specific row/colunn
S. Data Visuali zat ian

Enter your choices

Uata Visualization Menu
1. Line Plot
2. Vertical Bar Plot

Dink 7568 G8 availabie 3. Hori zontal Bar Plet

evet sareadsthect ats A 0 saple csv ie for.c sampledatahockeyip
Bdothesah Aaiine als
2Theamgika
10-02 021
P ye here tosearch
Poett iot Coluboratty
teallo Pceuyy:
+ 0 o 4 colabiesarchgooglecom dve/thSlf-0cofvyydkhlo32 RAN

Code Text
E Fies break
1. Display Records
2. Working on Records
3. Working on Coluns
4. Search specific row/column
sarple data 5. Data Visualization

README md
Enter your choices
[Link] Data Visualization Menu
anscombe json 1. Line Plot
2. Vertical Bar Plot
calfonia_housing [Link] 3. Horizontal Bas Plot
celfornia [Link] csv 4. Histogra
mnistLlesLcsv
Enter choicel
mnist Irain [Link]
2000
playerData cav
1750
sempledalasalety csy
1250
Gold Medals
700 Sitver Medals
Brore Medals

Mchan Phels Mssy frarain urtes nge de En

Data Vi sualization Menu

1La Rar Plut

3. Hor izontal Bar Dlot
7568 G8 aiae
sngledatahoceie
exEel s e e c t h e e t s sampie-cofiefoc
dothes ds lnea 118
211ekpies
NG
16-02-221
piype hete to seasch
 +

e o colabseerchooogleconmi/thstbE aby) xaoydkt lo)2 hesooliTo-PKAulylyemt

Code Text RAM
Fles
D e vasuaI1zation Nenu
2. Vertical Bar Plot
3. Horizontal Bar Plot
4. Histogram
sarmple,data 5. Exit
RREADME md Fnter r hoice2

[Link] 000

anscombe json
calfoma, housing. [Link] 1590

calfomia [Link] cev

mnist, test csy 1000
mnist.train_sinallcsv
playerData csv 50
Gd Heos
[Link] 251 Sier M a t

Aehiet
Data Visualization Menu
1. 1ine Plot
Plot
tnt al Bar Plot
4. Histopran
S. Exit
7568 GB availabie Enter choice3

21tuk 12sampieas dothezsts a ecel sareadshectas A sample cy tie [Link] sampledatahockcy zip Shor a

Iype here to search

10-02 2021

Proertibyrt Coboratory
CO [Link]/thSibE-gy0 <jofvodk lo32 hfcscrcllo-PK4uy2omUs
+ Code + Text
Files

Aniete
Data Visualization Nenu
Line Plot
Vertaca. ber PiO
sample data Plot
P README md 4. Histogram
Exit
[Link] Enter choice3
R ansconbe json Gary aly
california_housing_test.csy lan Thorpe
celifornia_housing _train.csv Inge de bruyn
ninistLlesi csv Lbby Lanton ckett
mnistLIrain, [Link]
en Thnrne
[Link]
R [Link]
Gold Medes

Mchae: Phele
750 S00 1000 230 1500 150 x09
bata s u a 11zation
z Nenu

2. Vertical Bar Plot

B. Horizontal Bar Plot
4. Histogram
Exi
hoices
Main Menu
1. Display Records
2. Working on kecords
3. Working on Col umns
Dik 7568 G8 ailabe Korrh nnrsir roulralim

Rdothes as ee de Rexcel soreacstett-s osamglecw-fie-fos cs

211ekt~[Link]
ssmoledatahdey zig Shor a

E Iype here to search

 Bibliography
"NCERT Text Book
" Informatics Practices bySumita
Arora