Bharatiya Vidya
Bhavan
Senior Secondary School , Kodunganoor
Thiruvananthapuram
Investigatory Project in
INFORMATICSPRACTICES
Topic: IPL CRICKET SCORE
MANAGEMENT SYSTEM
Name: Govard a anand
Class &Div: 12 b
reg. No:
CERTIFICATE
Certified that this is the bonafide project report in Informatics
Practices titled ‘IPL CRICKET SCORE
MANAGEMENT SYSTEM’ done by GOVARD A
ANAND of class 12B submitted for the AISSCE Practical
Examination 2023-2024.
Teacher-in-charge Principal Examiner
ACKNOWLEDGEMENT
I wish to express my sincere gratitude to
Mrs.Rekha G Nair, for her constant support, help
and guidance which enabled me to complete this
project successfully. I also thank Mr.Sunil Chacko,
our principal, who provided the technical support
and cooperation without which the project would not
have been possible.
My heartfelt thanks to my friends and group
members. Last but not the least I thank the Almighty
for clearing my path when the going got tough.
Signature of the candidate
Contents
1. Introduction
2. About software
3. Source Code
4. Output
5. Bibliography
INTRODUCTION
The project titled ‘IPL CRICKET SCORE
MANAGEMENT SYSTEM’ demonstrates how
the data of a school can be maintained automatically
using computer software. This project is developed
by using Python Pandas.
This program is menu-driven. It is designed in such
a way that the user can create a new record of a
student’s details, delete any particular student’s
details and to modify any student’s details.
ABOUT SOFTWARE
Pandas is a software library written for the Python
programming language for data manipulation
and analysis. In particular, it offers data
structures and operations for manipulating numerical
tables and time series. It is free software and the
name is derived from the term "panel data".Pandas
allows importing data from various file formats such
as comma-separated values (CSV). In this project
the csv file is created in Microsoft Excel.
Matplotlib is a 2D plotting library used for Data
Visualization in Python. It is used for creating static,
animated and interactive 2D plots or figures in
Python. Pyplot provides the machine interface to the
plotting library in matplotlib.
CSV TABLE
Student database:
Class strength:
SOURCE
CODE
importmatplotlib.pyplot as plt
import sys
import pandas as pd
df=pd.read_csv("D:\\school managment system.csv")
whileTrue:
print ("\t\tMENU")
print ("\t\t*****")
print ("1.Display")
print ("2. Data Visualization")
print ("3.Search a record")
print ("4. Add a record")
print ("5. Delete a record")
print ("6. Exit")
ch=int(input("Enter your choice"))
if ch==1:
print (df.to_string())
elif ch==2:
d=pd.read_csv("C:\\Users\\USER\\Documents\\Class.csv")
df=pd.DataFrame(d)
df.plot("Class","Strength",kind='bar',facecolor='r')
plt.title('class/Strength',color='black',fontsize=20)
plt.xlabel('Class',color='b',size=15)
plt.ylabel('Strength',color='b',size=15)
plt.show()
elif ch==3:
n=int(input("Enter Admission Number to be searched"))
flag=0
for (c,s) in df.iteritems():
t=len(s)
if c=='Admission Number':
for row in range(t):
m=s[row]
if m==n:
z=df.iloc[row]
print (z.values)
flag=1
if flag==0:
print ("record not found")
elifch==4:
a=int(input("Enter Admission number:"))
b=input("Enter Name:")
c=int(input("Enter Class:"))
d=input("Enter Div:")
e=input("Enter Fathers Name:")
f=input("Enter Address:")
g=int(input("Enter Phone Number:"))
h=input("Enter Blood Group:")
df=pd.read_csv("D:\\school managment system.csv")
df.loc[len(df.index)]=[a,b,c,d,e,f,g,h]
print("Record added Successfully")
df.to_csv("D:\\school managment system.csv")
print(df)
elifch==5:
a=int(input("Enter Admission number:"))
df=pd.read_csv("D:\\school management system.csv")
df=df.drop(df[df["Admission Number"]==a].index)
df.to_csv("D:\\school management system.csv")
print(df)
OUTPUT
BIBLIOGRAPHY:
INFORMATICS PRACTICES WITH PYTHON, By
PreetiArora
INFORMATICS PRACTICES WITH PYTHON,
By SumitaArora
