[Link]’S [Link].
SCHOOL
Informatics Practices
Student Management System
Project File
2022-2023
Submitted to: Ms Seema Narang
Submitted by:Vantika kamra and Gritansh Khandelwal
1|P a ge
Acknowledgement
I would like to convey my thanks to [Link] Narang
Ma’am, my Informatics Practices teacher, who always gave
valuable suggestions and guidance for completion of my
project.
She helped me to understand and remember the importance
of the details of the project. My project was a success
because of her guidance.
2|P a ge
Certificate
This is to certify that “Vantika Kamra” and “Gritansh
Khandelwal” of class XII-DIAMOND of St. Michael’s
[Link] has completed his project under the guidance
of [Link] narang.
She has taken care and shown sincerity in completion of the
project and is upto my expectations, for academic year
2022-2023 as per guidelines issued by CBSE.
Ms. Seema Narang
(HOD)
-------------------
SIGNATURE
3|P a ge
Index
[Link] Topic Page No
1. Hardware and software Requirement
2. Introduction
Features of project
About Python
Python applications
CSV
3. Code
4. Output
4|P a ge
Hardware and Software Requirement
Software:
Python 3.8.2
Operating System:
Windows 10
Minimum Hardware and Software Requirement
Operating system:
X86 64-bit CPU(Intel/AMD Architecture)
4GB RAM
Free Disk Space
5|P a ge
Student Management System
Introduction
In the Student Management system Project in python, we will see a project that
manages the information of the students. It includes managing data such as name,
date of birth, which class and what marks they have got in various subjects.
The basic task to be performed on this Project are:
1. Create/Import New Dataframe
2. Student Data Analysis
3. Student Data Visualisation
4. Export Dataframe to csv file
In Create New Dataframe menu you will come across the following buttons in
which you can create new dataframe, or can add modify the details and also an
option to return to main menu.
1. Create Dataframe
2. Import Dataframe from csv file
3. Add/Modify Custom Index
4. Add/Modify Custom Column Head
5. Return to main menu
Under the analysis tab, there are various options whivh we can perform add new
row, delete row, see the student with max marks, see the first nth rows.
1. Display All records
2. Print first nth records
3. Print last nth records
4. Print All records in order of Name
6|P a ge
5. Display student with maximum marks
6. Display student with minimum marks
7. Display students who have secured passing marks
8. Print distinct classes
9. Add a row to Dataframe
10. Delete a row from Dataframe
11. Return to main menu
Features of Project
Free of technical errors
Easy to understand
Data can be easily analysed
Less human efforts
About Python
Python is very high in demand and all the major companies are looking for great
Python Programmers to develop websites, software components, and applications
or to work with Data Science, AI, and ML technologies.
Python is Open Source which means its available free of cost.
Python is simple and so easy to learn
Python is versatile and can be used to create many different things.
Python has powerful development libraries include AI, ML etc.
Python is much in demand.
Applications of Python
Easy-to-learn − Python has few keywords, simple structure, and a clearly
defined syntax. This allows the student to pick up the language quickly.
Easy-to-read − Python code is more clearly defined and visible to the eyes.
Easy-to-maintain − Python's source code is fairly easy-to-maintain.
A broad standard library − Python's bulk of the library is very portable
and cross-platform compatible on UNIX, Windows, and Macintosh.
Interactive Mode − Python has support for an interactive mode which
allows interactive testing and debugging of snippets of code.
7|P a ge
Portable − Python can run on a wide variety of hardware platforms and has
the same interface on all platforms.
Extendable − You can add low-level modules to the Python interpreter.
These modules enable programmers to add to or customize their tools to be
more efficient.
Databases − Python provides interfaces to all major commercial databases.
GUI Programming − Python supports GUI applications that can be
created and ported to many system calls, libraries and windows systems,
such as Windows MFC, Macintosh, and the X Window system of Unix.
Scalable − Python provides a better structure and support for large
programs than shell scripting.
CSV
A CSV (Comma Separated Values) format is one of the most simple and common
ways to store tabular data. To represent a CSV file, it must be saved with
the .csv file extension.
CSV Advantages
CSV is human readable and easy to edit manually.
CSV is simple to implement and parse.
CSV is processed by almost all existing applications.
CSV provides a straightforward information schema.
CSV is faster to handle.
CSV is smaller in size.
CSV is considered to be standard format.
CSV is compact.
8|P a ge
Result Processing using-code
Import pandas as pd
While(True):
Print(“Main Menu”)
Print(“1. Fetch data”)
Print(“2. Dataframe Statistics”)
Print(“3. Display Records”)
9|P a ge
Print(“4. Working on Records”)
Print(“5. Working on Columns”)
Print(“6. Search specific row/column”)
Print(“7. Data analystics”)
Print(“8. Exit”)
Ch=int(input(“Enter your choice”))
If ch==1:
Result=pd.read_csv(“[Link]”,index_col=0)
Elif ch==2:
While (True):
Print(“Dataframe Statistics Menu”)
Print(“1. Display the Transpose”)
10 | P a g e
Print(“2. Display all column names”)
Print(“3. Display the indexes”)
Print(“4. Display the shape”)
Print(“5. Display the dimension”)
Print(“6. Display the data types of all columns”)
Print(“7. Display the size”)
Print(“8. Exit”)
Ch2=int(input(“Enter choice”))
If ch2==1:
Print(result.T)
Elif ch2==2:
Print([Link])
11 | P a g e
Elif ch2==3:
Print([Link])
Elif ch2==4:
Print([Link])
Elif ch2==5:
Print([Link])
Elif ch2==6:
Print([Link])
Elif ch2==7:
Print([Link])
Elif ch2==8:
Break
12 | P a g e
Elif ch==3:
While(True):
Print(“Display Records Menu”)
Print(“1. Top 5 Records”)
Print(“2. Bottom 5 Records”)
Print(“3. Specific number of records from the top”)
Print(“4. Specific number of records from the bottom”)
Print(“5. Details of a specific Subject”)
Print(“6. Display details of all subjects”)
Print(“7. Exit”)
Ch3=int(input(“Enter choice”))
13 | P a g e
If ch3==1:
Print([Link]())
Elif ch3==2:
Print([Link]())
Elif ch3==3:
N=int(input(“Enter how many records you want to display
from the top”))
Print([Link](n))
Elif ch3==4:
N=int(input(“Enter how many records you want to display
from the bottom”))
Print([Link](n))
Elif ch3==5:
14 | P a g e
St=input(“Enter the subject name for which you want to
see the details”)
Print([Link][st])
Elif ch3==6:
Print(“Results of XYZ school for the session 2018-19”)
Print(result)
Elif ch3==7:
Break
Elif ch==4:
While(True):
Print(“Working on Records Menu”)
Print(“1. Insert a specific subject Detail”)
Print(“2. Delete a specific subject Detail”)
15 | P a g e
Print(“3. Update a specific subject detail”)
Print(“4. Exit”)
Ch4=int(input(“Enter choice”))
If ch4==1:
A=input(“Enter subject name”)
B=int(input(“Enter number of students appeared:”))
C=int(input(“Enter highest marks obtained:”))
D=int(input(“Enter average marks obtained”))
E=int(input(“Enter number of A1’s”))
F=int(input(“Enter number of A2’s”))
G=int(input(“Enter percentage of A1 and A2’s”))
H=int(input(“Enter number of B1’s”))
16 | P a g e
I=int(input(“Enter number of B2’s”))
J=int(input(“Enter number of C1’s”))
K=int(input(“Enter number of C2’s”))
L=int(input(“Enter number of D’s”))
M=int(input(“Enter number of E’s”))
[Link][a]=[b,c,d,e,f,g,h,I,j,k,l,m]
Print(“Data successfully inserted”)
Elif ch4==2:
A=input(“Enter subject name whose data needs to be
deleted”)
[Link]([a],inplace=True)
Print(“Data successfully deleted”)
Elif ch4==3:
17 | P a g e
A=input(“Enter subject name whose data needs to be
updated”)
B=int(input(“Enter number of students appeared:”))
C=int(input(“Enter highest marks obtained:”))
D=int(input(“Enter average marks obtained”))
E=int(input(“Enter number of A1’s”))
F=int(input(“Enter number of A2’s”))
G=int(input(“Enter percentage of A1 and A2’s”))
H=int(input(“Enter number of B1’s”))
I=int(input(“Enter number of B2’s”))
J=int(input(“Enter number of C1’s”))
K=int(input(“Enter number of C2’s”))
L=int(input(“Enter number of D’s”))
18 | P a g e
M=int(input(“Enter number of E’s”))
[Link][a]=[b,c,d,e,f,g,h,I,j,k,l,m]
Print(“Data successfully updated”)
Elif ch4==4:
Break
Elif ch==5:
While(True):
Print(“Working on Columns Menu”)
Print(“1. Insert a new column data”)
Print(“2. Delete a specific column”)
Print(“3. Exit”)
Ch5=int(input(“Enter choice”))
19 | P a g e
If ch5==1:
Print(“Enter details”)
H=input(“Enter column/heading name”)
Det=eval(input(“Enter details corresponding to all
subjectenclosed in [ ])”))
Result[h]=[Link](data=det,index=[Link])
Print(“Column inserted”)
Elif ch5==2:
A=input(“Enter column name which needs to be deleted”)
[Link]([a],axis=1,inplace=False)
Print(“Column Temporary deleted”)
Elif ch5==3:
Break
20 | P a g e
Elif ch==6:
While(True):
Print(“Search Menu”)
Print(“1. Search for the details of a specific subject”)
Print(“2. Search details of a specific as per a specific column
heading”)
Print(“3. Exit”)
Ch6=int(input(“Enter choice”))
If ch6==1:
St=input(“Enter the name of the subject whose details
you want to see”)
Print([Link][st])
Elif ch6==2:
21 | P a g e
Col=input(“Enter column/heading name whose details you
want to see”)
Print(result[col])
Elif ch6==3:
Break
Elif ch==7:
While(True):
Print(“Data Analytics Menu”)
Print(“1. Subject with maximum average marks”)
Print(“2. Subject with minimum average marks”)
Print(“3. Subject with maximum highest marks”)
Print(“4. Subject with minimum highest marks”)
22 | P a g e
Print(“5. Subject with maximum percentage of A1 and A2”)
Print(“6. Subject with minimum percentage of A1 and A2”)
Print(“7. Exit”)
Chana=int(input(“Enter choice:”))
If chana==1:
M=result[‘average’].max()
S=[Link][[Link]==m]
Print(“Subject with maximum average marks of “,m,” is\n
“,[Link])
Elif chana==2:
M=result[‘average’].min()
S=[Link][[Link]==m]
23 | P a g e
Print(“Subject with minimum average marks of “,m,” is\n
“,[Link])
Elif chana==3:
M=result[‘highest’].max()
S=[Link][[Link]==m]
Print(“Subject with maximum highest marks of “,m,” is\n
“,[Link])
Elif chana==4:
M=result[‘highest’].min()
S=[Link][[Link]==m]
Print(“Subject with minimum highest marks of “,m,” is\n
“,[Link])
Elif chana==5:
M=result[‘per’].max()
24 | P a g e
S=[Link][[Link]==m]
Print(“Subject with maximum percentage of A1 and
A2”,[Link],”\n Percentag being”,m)
Elif chana==6:
M=result[‘per’].min()
S=[Link][[Link]==m]
Print(“Subject with minimum percentage of A1 and
A2”,[Link],”\n Percentage being”,m)
Elif chana==7:
Break
Elif ch==8:
Break
25 | P a g e
Result Processing using-output
26 | P a g e
27 | P a g e