BHOLANANDA NATIONAL
VIDYALAYA
BARRACKPORE
INFORMATICS PRACTICES(065)
PROJECT
2023-2024
TOPIC:
BOOK RECORD STORING SYSTEM
GUIDED BY:- MR. Meghdoot Mukherjee
SUBMITTED BY: Ayush Kumar Singh
CLASS AND SECTION : XII-A
STREAM : Commerce
ROLL NUMBER:
TABLE OF CONTENTS
INTRODUCTION TO PYTHON.
INTRODUCTION TO THE PROJECT.
ACKNOWLEDGEMENT.
SYSTEM REQUIREMENTS.
CSV FILE DETAILS.
PROGRAM CODE DETAILS.
SCREEN SHOTS OF EXECUTION.
BIBLIOGRAPHY.
CERTIFICATE.
INTRODUCTION TO PYTHON
Python is an interpreted, object-oriented, high-
level programming language with dynamic
semantics. Its high-level built in data structures,
combined with dynamic typing and dynamic
binding, make it very attractive for Rapid
Application Development, as well as for use as a
scripting or glue language to connect existing
components together. Python's simple, easy to
learn syntax emphasizes readability and
therefore reduces the cost of program
maintenance. Python supports modules and
packages, which encourages program
modularity and code reuse. The Python
interpreter and the extensive standard library
are available in source or binary form without
charge for all major platforms, and can be freely
distributed.
History of Python:
Python is a widely used general-purpose, high-level
programming language. It was initially designed by
Guido van Rossum in 1991 and developed by
Python Software Foundation. It was mainly
developed for emphasis on code readability, and its
syntax allows programmers to express concepts in
fewer lines of code.
INTRODUCTION TO THE PROJECT
The BOOK RECORD STORING SYSTEM
is an program which can be used to store
records of books.This application stores the
details of books( ID, NAME, PUBLISHER,
QUANTITY,CLASS AND SUBJECT).We can
insert records and we can search by
bookname, publisher and class.
ACKNOWLEDGEMENT
I thank my Informatics Practices teacher Mr.
Meghdoot Mukherjee for guidance and
support. I am also thankful to our principal
Mrs. Swati Rudra. I would also thank to my
parent for encouraging during the course of
this project. Finally, I would like to thank CBSE
for giving me this opportunity to undertake
this project.
SYSTEM REQUIREMENTS
HARDWARE REQUIREMENT:
Printer- to print the required documents of
the project.
Compact Drive
Proccesor: Pentium III and above
RAM: 256 MB(minimum)
Hard-Disk : 20 GB(minimum)
SOFTWARE REQUIREMENT:
Windows 7 or higher
Microsoft Excel to create CSV File.
Python idle 3.6 or higher or spyder.
Microsoft Word 2010 or higher for
documentation.
CSV FILE DETAILS
FILE Name: BOOK.CSV
LOCATION : D DRIVE
CONTENTS :
PROGRAM CODE
import pandas as pd
print('----------------WELCOME TO BOOK RECORDS
STORING SYSTEM------------------')
flag=True
while(flag):
print('---------------SELECT THE OPTION AS PER YOUR
REQUIREMENT--------------')
print('PRESS 1 TO INSERT NEW RECORD')
print('PRESS 2 TO VIEW ALL THE RECORDS')
print('PRESS 3 TO SEARCH A RECORD BY BOOK
NAME')
print('PRESS 4 TO SEARCH A RECORD BY
PUBLISHER')
print('PRESS 5 TO SEARCH A RECORD BY CLASS')
print('PRESS ANY OTHER NUMBER TO QUIT.')
choice=int(input('ENTER YOUR CHOICE:'))
if choice==1:
id=int(input("ENTER BOOK ID"))
name=input('ENTER THE BOOK NAME:')
publisher=input("ENTER PUBLISHER")
price=int(input("ENTER PRICE"))
quantity=int(input("ENTER QUANTITY"))
Class=input("ENTER CLASS")
subject=input("ENTER SUBJECT")
L=[[id,name,publisher,price,quantity,Class,subject]]
df=pd.DataFrame(L)
df.to_csv("D:\\
BOOK.csv",mode='a',header=False,index=False)
print('Record Inserted Suceessfully')
elif choice==2:
print('-------DISPLAYING ALL THE BOOK
DETAILS---------------')
df=pd.read_csv("D:\\BOOK.csv")
print(df)
elif choice==3:
n=input('ENTER A BOOK NAME TO SEARCH:')
df=pd.read_csv("D:\\
BOOK.csv",names=['ID','NAME','PUBLISHER','PRICE','QUAN
TITY','CLASS','SUBJECT'])
val=df[df['NAME']==n]
if(val.empty==True):
print('No Such BOOK Exists')
else:
print(val)
elif choice==4:
n=input('ENTER PUBLISHER TO SEARCH:')
df=pd.read_csv("D:\\
BOOK.csv",names=['ID','NAME','PUBLISHER','PRICE','QUAN
TITY','CLASS','SUBJECT'])
val=df[df['PUBLISHER']==n]
if(val.empty==True):
print('No Such BOOK Exists')
else:
print(val)
elif choice==5:
n=input('ENTER CLASS TO SEARCH:')
df=pd.read_csv("D:\\
BOOK.csv",names=['ID','NAME','PUBLISHER','PRICE','QUAN
TITY','CLASS','SUBJECT'])
val=df[df['CLASS']==n]
if(val.empty==True):
print('No Such BOOK Exists')
else:
print(val)
else:
print('THANK YOU FOR BOOK RECORD STORING
SYSTEM')
flag=False
SCREEN SHOTS OF EXECUTION
MAIN MENU
INSERTING A NEW BOOK DETAILS
DISPLAYING ALL THE RECORDS
SEARCHING A RECORD BY BOOK
NAME
SEARCHING A RECORD BY
PUBLISHER
SEARCHING A RECORD BY CLASS
CLOSING THE PROGRAM
BIBLIOGRAPHY
BOOKS:
INFORMATICS PRACTICESWITH
PYTHON- BY SUMITA ARORA
INFORMATICS PRACTICES WITH
PYTHON- BY PREETI ARORA
PYTHON COOKBOOK
WEBSITES:
www.geeksforgeeks.org
https://docs.python.org/3/
https://www.w3schools.com/python/
CERTIFICATE
This is to certify that Ayush Kumar Singh
of class XII, BHOLANANDA NATIONAL
VIDYALAYA, Barrackpore has successfully
completed his/her project in Informatics
Practices Practical for the AISSCE as
prescribed by CBSE in the year 2023-2024.
Roll No :
Sign. of Internal Sign. of External
________________________________
