Sona Modern Public School
A-3/4, Devli Road, Khanpur, New Delhi
A Project Report On
For
AISSCE 2026 Examination
[Subject :- Informatics Practices (065)]
SUBMITTED BY
NAME ROLL NO.
1. ANMOL …………………..
2. CHARVI …………………..
3. AVINASH …………………..
Under the Guidance of:
Mr. Anuj Kumar (PGT[I.P.]
This is to certify that the Project entitled Data
Analysis & Visualizaion on Employee is a
bonafide work done by Master ANMOL, Miss
CHARVI & Master AVINASH of class XII Session
2025-26 in partial fulfillment of CBSE’s AISSCE
Examination 2026 and has been carried out
under my direct supervision and guidance. This
report or a similar report on the topic has not
been submitted for any other examination and
does not form a part of any other course
undergone by the candidate.
Signature of Teacher/Guide
Name:Mr.Anuj Kumar
Designation: PGT ( I. P.)
ACKNOWLEDGEMENT
We undertook this Project work, as the part of our XII-Informatics
Practices course. We had tried to apply our best of knowledge and
experience, gained during the study and class work experience.
However, developing software system is generally a quite complex and
time-consuming process. It requires a systematic study, insight vision
and professional approach during the design and development.
Moreover, the developer always feels the need, the help and good
wishes of the people near you, who have considerable experience and
idea.
We would like to extend our sincere thanks and gratitude to our teacher
Mr. Anuj Kumar. We would like to take the opportunity to extend our
sincere thanks and gratitude to our parents for being a source of
inspiration and providing time and freedom to develop this software
project.
We also feel indebted to our friends for the valuable suggestions during
the project work.
NAME ROLL NO. SIGN.
ANMOL …………… …………………
CHARVI …………… …………………
AVINASH …………… …………………
INTRODUCTION & TOOLS/PLATFORM ENVIRONMENT USED
Modules used pandas and sub module pyplot of matplotlib
Pandas is a module(package) useful for data analysis and manipulation. It
provides an easy way to create, manipulate and wrangle the data. It provides
powerful and easy to use data structures, as well as the means to quickly
perform operations on these structures. It uses series for one dimensional data
structure and dataframe for two dimensional data structure. It provides an
efficient way to slice the data. It provides a flexible way to merge, concatenate
or reshape the data.
matplotlib.pyplot is a collection of functions that make matplotlib work like
MATLAB. Each pyplot function makes some change to a figure: e.g., creates a
figure, creates a plotting area in a figure, plots some lines in a plotting area,
decorates the plot with labels, etc.
In matplotlib.pyplot various states are preserved across function calls, so that it
keeps track of things like the current figure and plotting area, and the plotting
functions are directed to the current axes (please note that "axes" here and in
most places in the documentation refers to the axes part of a figure and not the
strict mathematical term for more than one axis).
ABOUT THE PROJECT
In this I have created dataframe from dictionary of lists
Then transferred the contents of dataframe to csv file
Then read the csv file and performed operations such as reading, displaying,
searching contents of the csv file according to some criteria then plotted line
graph, bar graph and histogram.
My project contains seven menu options:-
1) Creation of CSV file from dataframe
2) Displaying contents of csv file according to some criteria
3) Displaying maximum and minimum value of a column
4) Displaying records in ascending or descending order according to a column
5) Searching and displaying records that matches the defined criteria
6) Count of records according to some criteria
7) Data visualization (plotted line graph, bar graph and histogram from the data
of the csv file
#DATA ANALYSIS AND VISUALIZATION ON DOCTOR
import pandas as pd
ans='y'
while ans=='y' or ans=='Y':
print("1:Creation of CSV file from dataframe\n")
print("2:Display contents from CSV file\n")
print("3:Display maximum and minimum salary \n")
print("4:Display records in ascending/descending order of salary\n")
print("5:Search and display records on empno, name\n")
print("6:Count all records for salary > user given salary\n")
print("7:Data Visualization\n")
choice=int(input("Enter choice :"))
if choice==1: #Creation of CSV file
n=int(input("Enter number of records to be inserted"))
lempno,lname,ldept,lsalary=[],[],[],[]
demp={}
for i in range(n):
print("Enter value for record no ",i+1)
lempno+=[int(input("Enter doctorno :"))]
lname+=[input("Enter name:")]
ldept+=[input("Enter department:")]
lsalary+=[float(input("Enter salary"))]
demp['Empno']=lempno
demp['Name']=lname
demp['Dept']=ldept
demp['Salary']=lsalary
print('dictionary')
print(demp)
dfemp=pd.DataFrame(demp)
print('Dataframe')
print(dfemp)
dfemp.to_csv("d:\\PROJECT\\doc.csv")#transferring contents to csv files
elif choice==2: #Display from CSV
print("a: Display all records\n")
print("b: Display first n records\n")
print("c: Display bottom n records\n")
print("d: Display records with user headings\n")
chdisp=input("Enter choice")
if chdisp=='a' or chdisp=='A':
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
elif chdisp=='b' or chdisp=='B':
n=int(input("Enter number of rows to be displayed"))
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0,nrows=n)
print(dfemp)
elif chdisp=='c' or chdisp=='C':
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv")
print(dfemp)
n=int(input("Enter no. of records to be displayed:"))
print(dfemp.tail(n)) #Display bottom n rows
elif chdisp=='d' or chdisp=='D':
L1=[]
L1=eval(input("Enter suitable headings for
docno,name,dept,salary"))#Taking user given heading
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",names=L1,skiprows=1)
print(dfemp)
elif choice==3: #Display max/min salary
print("1:Display maximum salary\n")
print("2:Display minimum salary\n")
ch=int(input("Enter choice"))
if ch==1:
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
print("maximum salary")
print(dfemp['Salary'].max())#Display max salary
elif ch==2:
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
print("minimum salary")
print(dfemp['Salary'].min())#Display min salary
elif choice==4: #Arrange in ascending/descending order of salary
print("a:Arrange in ascending order of salary\n")
print("b:Arrange in descending order of salary\n")
chd=input("Enter choice")
if chd=='a' or chd=='A':
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
print("Displaying records in ascending order of salaries")
print(dfemp.sort_values('Salary') )
if chd=='b' or chd=='B':
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
print("Displaying records in descending order of salaries")
print(dfemp.sort_values('Salary',ascending=True))
elif choice==5: #Search on employee number or name
print("a:Search and display record on doctor number\n")
print("b:Search and display record on doctor name\n")
chs=input("Enter choice")
if chs=='a' or chs=='A':
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
i=0
eno=int(input("Enter empno to be searched:"))
for (col,colseries) in dfemp.iteritems():
if col=='Empno':
for val in colseries:
if val==eno:
print(dfemp.iloc[[i]])
break
i+=1
else:
print("Record not found")
elif chs=='b' or chs=='B':
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
i=0
ename=input("Enter empname to be searched:")
for (col,colseries) in dfemp.iteritems():
if col=='Name':
for val in colseries:
if val==ename:
print(dfemp.iloc[[i]])
break
i+=1
else:
print("Record not found")
elif choice==6: # To count employees whose salary>user given salary
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
print(dfemp)
i,cnt=0,0
sal=float(input("Enter salary :"))
for (col,colseries) in dfemp.iteritems():
if col=='Salary':
for val in colseries:
if val>sal:
cnt+=1
i+=1
print("Count of doctors having salary more than user given salary",cnt)
elif choice==7:
print("1:Line Plot with docno on x-axis and salary on y-axis\n")
print("2:Bar Plot with doctor name on x-axis and salary on y-axis\n")
print("3:Histogram salary range on x-axis and count of doctors on y-
axis\n")
chp=int(input("Enter choice"))
if chp==1:
import matplotlib.pyplot as plt
import pandas as pd
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
plt.plot(dfemp.Empno,dfemp.Salary,marker="+",markeredgecolor="red")
plt.xlabel("Doctor no")
plt.ylabel("Salary")
plt.title("Displaying Salary of Doctors")
plt.show()
elif chp==2:
import matplotlib.pyplot as plt
import pandas as pd
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
plt.bar(dfemp.Name,dfemp.Salary)
plt.xlabel("Doctor name")
plt.ylabel("Salary")
plt.title("Displaying Salary of Doctors")
plt.show()
elif chp==3:
import matplotlib.pyplot as plt
import pandas as pd
dfemp=pd.read_csv("d:\\PROJECT\\doc.csv",index_col=0)
n=len(dfemp)
plt.hist(dfemp.Salary,bins=n,histtype='bar',edgecolor='k')
plt.show()
ans=input("Do you want to continue y/Y")
Creation of CSV file from dataframe
Display contents from CSV file
Display maximum and minimum salary
Display records in ascending/descending order of salary
Search and display records on empno, name
Count all records for salary > user given salary
Data Visualization
(LINE GRAPH)
(BAR GRAPH)
(HISTOGRAM)
