GRADE XII - IP -PROJECT (STUDENT MANAGEMENT SYSTEM)

 

PATIENT MANAGEMENT SYSTEM

# -*- coding: utf-8 -*-

"""

Created on Sat Nov 13 20:37:02 2021

@author: Kirti Hora

"""

import pandas as pd

import matplotlib.pyplot as plt

def main():

  while True:

    print("="*60)

    print("STUDENT MANAGEMENT")

    print("="*60)

    print("enter 1 to ADD STUDENT DETAILS")

    print("enter 2 to DELETE STUDENT DETAIL")

    print("enter 3 to VIEW MAX MARKS")

    print("enter 4 to UPDATE STUDENT DETAIL")

    print("enter 5 to SEARCH STUDENT")

    print("enter 6 to DISPLAY STUDENT DETAILS")

    print("enter 7 to STUDENT PERFORMANCE GRAPH")

    print("enter 8 to EXIT....")

    print("="*60)

    d=int(input("enter choice:"))

    print("="*60)

    if d==1:

        add()     

    elif d==2:

        delete()

    elif d==3:

        maxi()

    elif d==4:

        update()

    elif d==5:

        search()

    elif d==6:

        display()

    elif d==7:

        gra()

    elif d==8:

        print("*********THANKS FOR USING STUDENT MANAGEMENT SYSTEM**********")

        break     

    else: 

        print("Enter correct choice. . .")

def add():

    print("---------------------------------------------------------------------------")

    print("---------------------------------------------------------------------------")

    df=pd.read_csv("D:\GRADE XII PYTHON/test1.csv",index_col=0)

    sid=int(input("Enter Student Id:"))

    if len(df.loc[df['sid']==sid])>0:

        print("Duplicate Record")

    else:

        name=input("Enter NAME:")

        cla=input("Enter CLASS:")

        sec=input("Enter SECTION:")

        sub=input("Enter SUBJECT:")

        mark=input("Enter MARKS:")

        df.loc[sid]=[sid,name,cla,sec,sub,mark]

        df.to_csv("D:\GRADE XII PYTHON/test2.csv",mode="w") 

        print("RECORD ADDED SUCCESSFULLY")

        print("="*60)

        

def update():

    df=pd.read_csv("D:\GRADE XII PYTHON/test1.csv",index_col=0)

    sid=int(input("Enter STUDENT ID:"))

    if len(df.loc[df['sid']==sid])>0:

        name=input("Enter name")

        cla=input("Enter CLASS")

        sec=input("Enter SECTION")

        sub=input("Enter SUBJECT")

        mark=input("Enter MARKS")

        df.loc[sid]=[sid,name,cla,sec,sub,mark]

        df.to_csv("D:\GRADE XII PYTHON/test1.csv",mode="w") 

        print("RECORD ADDED SUCCESSFULLY")

        print("="*60)

    else:

        print("Invalid Student Id")

        

def display():

    df=pd.read_csv(r"D:\GRADE XII PYTHON/test1.csv")

    print(df)

    print("="*60)

        

def delete(): 

    print("---------------------------------------------------------------------------")

    print("---------------------------------------------------------------------------")

    df=pd.read_csv("D:\GRADE XII PYTHON/test1.csv",index_col=0)

    sid=int(input("Enter Sid"))

    if len(df.loc[df['sid']==sid])>0:

        df.drop(sid,inplace=True)

    df.to_csv("D:\GRADE XII PYTHON/test1.csv",mode="w")   

    print("RECORD DELETED SUCCESSFULLY")

    print("="*60)

def search():

    print("---------------------------------------------------------------------------")

    print("---------------------------------------------------------------------------")

    df=pd.read_csv("D:\GRADE XII PYTHON/test1.csv",index_col=0)

    sid=int(input("Enter Sid"))

    if len(df.loc[df['sid']==sid])>0:

        print(df.loc[sid])

        print("="*60)

    else:

        print("Record not Found")

        print("="*60)

        

def maxi():

    df=pd.read_csv("D:\GRADE XII PYTHON/test1.csv",index_col=0)

    print("MAXIMUM MARKS ARE::",df['marks'].max())

    print()

    print('---------------------------------------------------------------------------')

    print('---------------------------------------------------------------------------')

def gra():

    df=pd.read_csv("D:\GRADE XII PYTHON/test1.csv",index_col=0)

    plt.bar(df['name'],df['marks'],label="STUDENT PERFORMANCE GRAPH")

    plt.title("STUDENT PERFORMANCE GRAPH")

    plt.xlabel("LEARNERS NAME")

    plt.ylabel("MARKS OBTAINED")

    plt.xticks(rotation=30)

    plt.legend()

    plt.grid(True)

    plt.show()

main()