Ip Kamalesh

IP PROJECT (2024-2025)
Employee MANAGEMENT DETAILS
NAME : C.KAMALESH
ROLL NO:
CLASS: XII
SECTION: G
ACKNOWLEDGEMENT
I WOULD LIKE TO EXPRESS MY SPECIAL THANKS OF

GRATITUDE TO MY INFORMATICS PRACTICES
TEACHER MRS.VASUPRIYA MAM FOR THEIR ABLE
GUIDANCE AND SUPPORT IN COMPLETING MY
PROJECT ON THE TOPIC "THEATRE MANAGEMENT
DETAILS".
I WOULD ALSO LIKE TO EXTEND MY GRATITUDE TO
THE SCHOOL PRINCIPAL MRS.KATHEEJA J.A FOR
PROVIDING US THE LAB FACILITIES AND MAKING
OUR PROJECT FRUITFUL.
THE GUIDANCE AND SUPPORT RECEIVED FROM ALL

MY FRIENDS, FAMILY, AND TEACHERS FROM THE
SCHOOL WHO CONTRIBUTED, AND STILL
CONTRIBUTING, ARE VITAL OF THIS PROJECT. I AM
GRATEFUL FOR THEIR CONSTANT SUPPORT AND
THEIR NEED TO HELP.
INDEX
S.NO TOPIC PAGE NO
1 Brief description about project 5
2 The Source of dataset 6
3 Hardware requirements 7
4 Software requirements 8
5 About Python 9
6 About Pandas 10
7 About Series 11
8 About DataFrame 12
9 About CSV 13
10 About Matplotlib 14
11 Source Code 15
12 Output Screen 19
13 Data Vizualisation 26
14 Back end table CSV 28
15 Conclusion 29
16 Reference 30
BRIEF DESCRIPTION ABOUT THE PROJECT
Employee management involves overseeing and

coordinating the activities of a workforce within an
organization. It includes tasks such as recruitment,
training, performance evaluation, and addressing
employee concerns to ensure a productive and
harmonious work environment. Effective employee
management contributes to organizational success by
optimizing individual and collective contributions
THE SOURCE OF DATA SET
The source of the dataset is created by our team members.

Information of the columns required for our project and other
details on our name
HARDWARE REQUIREMENTS
1. OPERATING SYSTEM
 Windows 7 or 10
 Mac OS 10.11 or Higher
 Linux(latest)
2. PROCESSOR
1. X86 64-bit CPU (Intel/AMD architecture)
3. RAM
2. 4 GB ram
4. STORAGE SPACE
3. 5 GB free disk space
SOFTWARE REQUIREMENTS
1.OPERATING SYSTEM
 Windows 7 or 10
 Mac OS 10.11 or Higher
 Linux(latest)
2.APPLICATION
 Python IDLE (latest version)
3.PROGRAMMING LANGUAGE
 Python
4.MS OFFICE
 Microsoft Excel
 Microsoft Word
5.LIBRARIES
 Pandas
 Numpy
 Matplotlib
ABOUT PYTHON
Python libraries contain a collection built- in

modules that allow to perform many actions.
Numpy, pandas and matplotlib are three well
established python libraries for scientific and
analytical use. These libraries allow us to
manipulate, transform and visualise data easily and
efficiently
ABOUT PANDAS
PANDAS [PANEI DAta] is a high level data manipulation

tool used for analysing data. It is very easy to import and
export data using pandas library which has set of very rich
functions.
• A data structure is a collection of data values and operations
that can be applied to that data.
• It enables efficient storage, retrieval and modification to the
data. Pandas has three important data structures, namely
series, data frame and panel
ABOUT SERIES
A series is 1-dimentional array containing a sequence of

values of any datatype (int, float. list, string, etc) which by
default have a numeric data labels starting from zero. The
data label associated with a particular value is called it's index
ABOUT DATAFRAME
 A DataFrame is a two-dimensional labelled data

structure like a table of MYSQL.
 It contains rows and columns and therefore has both a
row and column Index. In DataFrame, axis = 0 means
the row and axis =1 means column
 Each column can have a different type of value such as
numeric, string
 Boolean etc as in tables of a database.
ABOUT CSV
A comma-separated value (CSV) file is a text file where

values are separated by comma read CSV() is used to load the
data from a CSV into a DataFrame to csv() is used to save a
DataFrame to a CSV File.
ADVANTAGES OF CSV:
• A simple, compact and ubiquitous format for data storage.
• A common format for data interchange.
In can be opened in popular spreadsheets packages like MS
Excel, open Office-Calc, etc...
• Nearly all spreadsheets and databases support
import/export to csv format
ABOUT MATPLOTLIB
Matplotlib library is used for creating static, animated

and interactive 2D plots, on figures in python.
• The pyplot module of matplotlib contains a collection
of functions that can be used to work on a plot.
• The plot() function of the pyplot module is used to
create a figure
SOURCE CODE
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
salary = {}
rep='y'
while(rep=='y'):
print('1.Importing Employee Details')
print('2.Displaying specific columns')
print('3.Add a new row')
print('4.Calculating annual salary for a specific person')
print('5.Displaying specific rows and columns')
print('6.Exporting to CSV')
print('7.Visualization')
print('8.QUIT')
ch=int(input("\n Enter a choice(1-8):"))
if (ch==1):
print("\n Importing all the values from CSV")
d= pd.read_csv("D:\emp.csv")
df = pd.DataFrame(d)
print(df)
elif(ch==2):
print("\n Displaying specific columns")
print("")
d= pd.read_csv("D:\emp.csv")
df=pd.DataFrame(d,columns=["Idno","Name","Gender"])
print(df)
elif(ch==3):
print("\nAdding a new Employee")
i=int(input("\nEnter Idno :"))
n=input("Enter Name :")
g=input("Enter Gender :")
s=int(input("Enter Salary:"))
df=df._append({"Name":n,"Idno":i,"Gender":
g,"Salary":s},ignore_index=True)
print("")
print(df)
elif(ch==4):
print("\n Calculating Annual Salary for specific person")
print("")
kk=int(input("Enter The Idno: "))

p=df[df['Idno']==kk]
n=p["Name"].values[0]
an=((p['Salary'])*12).values[0]
print("Annual Salary Of",n,"is",an)
elif(ch==5):
print("\n Displaying specific rows and column")
print("\n First 2 rows of second column:")
print(df.loc[0:1,'Name'])
print("\n All rows of last 3 columns:")
print(df.loc[:,"Salary":'Idno'])
print("\n All rows of first and third columns:")
print(df[['Idno','Gender']])
elif(ch==6):
print("\n Exporting to csv")
df.to_csv(r'D:\det.csv')
print('\n Data exported to csv')
elif(ch==7):
print("\n Visualization")
d=pd.read_csv("D:\emp.csv")
print('\n importing name and salary')
df=pd.DataFrame(d,columns=['Name','Salary'])
print(df)
n=df['Name']
t=df['Salary']
plt.bar(n,t,color='green',label='Annual salary')
plt.xlabel("Name")
plt.ylabel("Salary")
plt.title("Comparison of salary")
plt.legend()
plt.show()
n=df['Name']
t=df['Salary']
plt.plot(n,t)
plt.xlabel("Name")
plt.ylabel("Salary")
plt.title("Comparison of salary")
plt.show()
elif(ch==8):
print("\n Quit")
print("Bye!!")
exit()
else:
print("invalid option try again")

OUTPUT SCREEN
1.Importing Employee Details
2.Displaying specific columns
3.Add a new row
4.Calculating annual salary for a specific person
5.Displaying specific rows and columns
6.Exporting to CSV
7.Visualization
8.QUIT
Enter a choice(1-8):1
Importing all the values from CSV

Idno Name Gender Salary
0 100 Alok M 300000
1 101 Kelly F 230000
2 102 Misha F 290000
3 103 Skyler M 150000
4 104 Iris F 430000
5 105 Maxim M 170000
3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Displaying specific columns
Idno Name Gender

0 100 Alok M
1 101 Kelly F
2 102 Misha F
3 103 Skyler M
4 104 Iris F
5 105 Maxim M
3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Adding a new Employee
Enter Idno :107

Enter Name :Alex
Enter Gender :M
Enter Salary:700000
Idno Name Gender Salary

0 100 Alok M 300000
1 101 Kelly F 230000
2 102 Misha F 290000
3 103 Skyler M 150000
4 104 Iris F 430000
5 105 Maxim M 170000
6 107 Alex M 700000
3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Calculating Annual Salary for specific person
Enter The Idno: 100

Annual Salary Of Alok is 3600000
3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Displaying specific rows and column
First 2 rows of second column:

0 Alok
1 Kelly
Name: Name, dtype: object
All rows of last 3 columns:

Empty DataFrame
Columns: []
Index: [0, 1, 2, 3, 4, 5]
All rows of first and third columns:
Idno Gender
0 100 M
1 101 F
2 102 F
3 103 M
4 104 F
5 105 M
3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Exporting to csv
Data exported to csv

3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Visualization
importing name and salary

Name Salary
0 Alok 300000
1 Kelly 230000
2 Misha 290000
3 Skyler 150000
4 Iris 430000
5 Maxim 170000
3.Add a new row
6.Exporting to CSV
7.Visualization
8.QUIT
Quit
Bye!!
DATA VIZUALISATION
BACKEND TABLE – CSV
Importing CSV files

EMPLOYEE MANAGEMENT TABLE
Exported CSV
CONCLUSION
In conclusion, this project has been a great experience and I

have learnt about many functions. I used this project to work
out every concept I have learnt with both class Xi and
XII.The project is similar to the Employee Management
System, but some features have been added to the project.
This project is used to incorporate our real-life experiences in
form of a simple program. This coding is efficient as the code
is simple but has a lot of uses
REFERENCE
 NCERT Textbook
 Youtube.com
 Chatgpt

Ip Kamalesh

Uploaded by

Copyright:

Available Formats

Ip Kamalesh

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Ip Kamalesh

Uploaded by

Copyright:

Available Formats

IP PROJECT (2024-2025)

Employee MANAGEMENT DETAILS

I WOULD LIKE TO EXPRESS MY SPECIAL THANKS OF

THE GUIDANCE AND SUPPORT RECEIVED FROM ALL

S.NO TOPIC PAGE NO

1 Brief description about project 5

2 The Source of dataset 6

14 Back end table CSV 28

Employee management involves overseeing and

The source of the dataset is created by our team members.

Python libraries contain a collection built- in

PANDAS [PANEI DAta] is a high level data manipulation

A series is 1-dimentional array containing a sequence of

 A DataFrame is a two-dimensional labelled data

A comma-separated value (CSV) file is a text file where

Matplotlib library is used for creating static, animated

import matplotlib.pyplot as plt

print('1.Importing Employee Details')

print('2.Displaying specific columns')

print('3.Add a new row')

print('4.Calculating annual salary for a specific person')

print('5.Displaying specific rows and columns')

ch=int(input("\n Enter a choice(1-8):"))

print("\n Importing all the values from CSV")

print("\n Displaying specific columns")

print("\nAdding a new Employee")

i=int(input("\nEnter Idno :"))

n=input("Enter Name :")

g=input("Enter Gender :")

print("\n Calculating Annual Salary for specific person")

kk=int(input("Enter The Idno: "))

print("Annual Salary Of",n,"is",an)

print("\n Displaying specific rows and column")

print("\n First 2 rows of second column:")

print("\n All rows of last 3 columns:")

print("\n All rows of first and third columns:")

print("\n Exporting to csv")

print('\n Data exported to csv')

print('\n importing name and salary')

print("invalid option try again")

Importing all the values from CSV

Displaying specific columns

Idno Name Gender

Adding a new Employee

Enter Idno :107

Idno Name Gender Salary

Calculating Annual Salary for specific person

Enter The Idno: 100

Displaying specific rows and column

First 2 rows of second column:

All rows of last 3 columns:

Data exported to csv

importing name and salary

Importing CSV files

In conclusion, this project has been a great experience and I

You might also like