Rukmani Birla Modern High School
Informatics Practices
Python Project On
“Employee Data Analysis”
(2025-26)
Submitted By: Yahvi Gupta and Tia Bhuwania
Under the guidance of: Mrs. Anita Khatri
(PGT, informatics practices)
ACKNOWLEDGEMENT
We would like to convey our heartfelt thanks to
Mrs. Anita Khatri, our Informatics Practices teacher
who always gave valuable suggestions and guidance
for the completion of the project. She helped us a
lot to understand and remember important details
of the project that we would have either lost. This
project has been a success only because of her
guidance.
Name: Tia Bhuwania and Yahvi Gupta
Class: XII-A
School: Rukmani Birla Modern High School, Jaipur
CERTIFICATE
This is to certify that Yahvi Gupta and Tia Bhuwania
of Class XII-A have successfully completed the
investigatory project/survey on the topic “Employee
Data Analysis” Under the guidance of “Mrs. Anita
Khatri (Informatics Practices)” during the academic
year 2025-26 in the partial fulfilment of the AISSCE
Practical Examination conducted by CBSE.
Signature of Signature of Signature of
Internal Examiner External Examiner Candidates
Index
• Introduction
• CSV file
• Python Code
• Complete Table
• Data Analysis
• Graphical Analysis
• Bibliography
INTRODUCTION
Python is an interpreted, general-purpose and high level language.
It provides a powerful interface for scientific computing using its
popular libraries and is being extensively used for data analytics.
Numpy and Pandas are the most extensively used libraries
supported by Python. Data Visualization in Python can be done
via many packages; one of the examples of the package is
Matplotlib.
This project is based on the data analysis of “Employee Data
Analysis” using CSV file and Python. [Link] is a file
containing the data of different employees of a company based in
different locations. In this project, with the help of different
functions and graphs, we intend to analyse the data of the
employees making it easier to access certain information. Python
provides powerful tools to help us analyse and manipulate data to
help us complete this project successfully.
Csv file
File name: [Link]
Employee Data Analysis: Python Code
import numpy as np
import pandas as pd
import [Link] as plt
# Informatics Practices Project by Yahvi Gupta and Tia Bhuwania
ed = pd.read_csv("C:\\Users\\TIA\\OneDrive\\Desktop\\[Link]")
print("select the operation you want to perform the employee table:-")
print("")
a = '''1. Display Complete Table
2. Data Analysis
3. Graphic Analysis
4. End program and Exit'''
print(a)
print("")
b = int(input("Enter your choice(Serial Number Only):"))
print("")
if b == 1:
print(ed)
print("")
elif b == 2:
print("Data Analysis Menu:",
"1. Display The Names Of Employees In Alphabetical Order",
"2. Display Any Column Of Your Choice",
"3. Find The Average Of The Salaries Of All Employees",
"4. Find The Highest Salary",
"5. Find The Lowest Salary",
"6. To Display The Salary After A Year-Round Bonus",
"7. Display The Details Of An Employee",
"8. Group On The Basis Of Department/Location",
"9. Drop An Employees Record ",
"10. Delete the column you do not want",
"11. Add a column",
"12. End program and exit",
"", sep="\n")
c1 = int(input("Enter your choice (Serial Number Only):"))
if c1 == 1:
print("")
print(ed.sort_values(by='Full_Name')["Full_Name"])
elif c1 == 2:
des = '''1. Display ID
2. Display full name
3. Display gender
4. Display department
5. Display designation
6. Display contact number
7. Display date of joining
8. Display salary
9. Display location
10. End program and exit'''
print(des)
print("")
y = int(input("Enter your choice (Serial Number Only):"))
if y == 1:
print(ed[" ID"])
elif y == 2:
print(ed["Full_Name"])
elif y == 3:
print(ed["Gender"])
elif y == 4:
print(ed["Department"])
elif y == 5:
print(ed["Designation"])
elif y == 6:
print(ed["Contact no."])
elif y == 7:
print(ed["Date_of_joining"])
elif y == 8:
print(ed["Salary"])
elif y == 9:
print(ed["Location"])
elif y == 13:
print("")
print('Thank you')
else:
print("You have not entered the correct value")
elif c1 == 3:
print("")
print("The average of the salary of all employees is:")
print(ed["Salary"].mean())
elif c1 == 4:
print("")
print("The highest salary is:")
print(ed["Salary"].max())
elif c1 == 5:
print("")
print("The lowest salary is:")
print(ed["Salary"].min())
elif c1 == 6:
bonus = float(input("Enter bonus percentage"))
new_sal = ed["Salary"]*(1 + bonus / 100)
print("\nSalaries after applying bonus:\n")
print([Link]({"Full_Name": ed["Full_Name"], "Original Salary":
ed["Salary"], "Updated Salary": new_sal.round(2)}))
elif c1 == 7:
print("select the employee whose details you wish to view")
print("")
name = input("Enter the name of the employee: ")
print(ed[ed['Full_Name'] == name])
elif c1 == 8:
print("1. Group by Department")
print("2. Group by Location")
choice = int(input("Enter your choice (1 or 2): "))
print("")
if choice == 1:
print([Link]('Department').size())
elif choice == 2:
print([Link]('Location').size())
else:
print("Invalid choice.")
elif c1 == 9:
x = input("Enter the name of the employee record you want to drop: ")
if x in ed['Full_Name'].values:
print("Updated records:")
print([Link](ed[ed['Full_Name'] == x].index, axis=0))
else:
print("No employee found with that name.")
elif c1 == 10:
print("")
z = (input('''following are the names of the columns:-
id
Full_Name
Gender
Department
Designation
Contact no.
Date_of_joining
Salary
Location
enter the name of the column you want to delete:'''))
print("updated records")
del ed[z]
print("")
print(ed)
elif c1 == 11:
new_col = input("Enter the name of the new column you want to add: ")
ed[new_col] = ""
for i in range(len(ed)):
val = input(f"Enter value for {new_col} of {[Link][i, 'Full_Name']}: ")
[Link][i, new_col] = val
print("Updated records:")
print(ed)
elif c1 == 12:
print("")
print("Thank You")
else:
print("you have not entered the correct value")
elif b == 3:
print('''Graphical Analysis:
1. How many employees are in a particular location
2. How many female and male employees are there in the organization
3. To Display The Average Salary By Department''')
y = int(input("enter your choice from the above options"))
if y == 1:
Location_counts = ed['Location'].value_counts()
[Link](Location_counts.index, Location_counts.values, color='skyblue',
edgecolor='black')
[Link]("Number of Employees per Location")
[Link]("Location")
[Link]("Number of Employees")
[Link]()
elif y == 2:
Gender_counts = ed['Gender'].value_counts()
[Link](Gender_counts.index, Gender_counts.values, color='pink',
edgecolor='black')
[Link]("Number of Employees per Gender")
[Link]("Gender")
[Link]("Number of Employees")
[Link]()
elif y == 3:
avg_salary = [Link]('Department')['Salary'].mean()
print("Average salary by department:")
print(avg_salary)
[Link](avg_salary.index, avg_salary.values, marker='o', linestyle='-',
color='yellow')
[Link]("Average Salary by Department")
[Link]("Department")
[Link]("Average Salary")
[Link](True)
[Link]()
else:
print("you have not entered the correct value")
elif b == 4:
print("Exit Program")
OUTPUT
I Display Complete Table:
II Data Analysis:
i. Display The Names of Employees in Alphabetical Order:
ii. Display Any Column of your choice:
iii. Find The Average of The Salaries of All Employees:
iv. Find the Highest Salary:
v. Find the Lowest Salary:
vi. To Display Salary After Year Round Bonus:
vii. To Display the Details of an Employee:
viii. Group on The Basis of Department/Location:
ix. Drop an Employees Record:
x. Delete the Column you do not want:
xi. Add a Column:
xii. End Program and Exit:
III. Graphic Analysis:
i. How many employees are in a particular location:
ii. How many female and male employees are there in the organization:
iii. To Display the Average Salary by Department:
IV. End Program and Exit:
Bibliography
•Informatics Practices for Class 12 by Sumita Arora
•Informatics Practices for Class 12 by NCERT
•[Link]
•[Link]
•[Link]
•[Link]
•[Link]
•[Link]
•[Link]