Skip to main content

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()



Comments

Popular posts from this blog

PYTHON - MYSQL CONNECTIVITY CODE

  #INSERTION OF DATA import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) print("Successfully Connected") #print(mydb) mycursor=mydb.cursor()   v1=int(input("enter ID:")) v2=input("enter name:") v3=input("enter Gender:") v4=int(input("enter age:")) sql='insert into TEACH values("%d","%s","%s","%s")'%(v1,v2,v3,v4) print(sql) mycursor.execute(sql) mydb.commit() print("record added") #MYSQL Connection code – Deletion on database SOURCE CODE: s=int(input("enter id of TEACHER to be deleted:")) r=(s,) v="delete from TEACH where id=%s" mycursor.execute(v,r) mydb.commit() print("record deleted") MYSQL Connection code – Updation on database SOURCE CODE: import mysql.connector mydb = mysql.connector.c...

GRADE XII CS - VIVA QUESTIONS

  VIVA QUESTIONS GRADE XII CS Dear All Be thorough with your project and practical files, as the viva can be asked from anywhere. Stay calm, don’t get nervous, and be confident in front of the examiner. 1. Tell me about your project. 2. Which concepts you have used for your project? 3. What do you mean by front end and back end? How they are important in developing any such projects? 4  Mention the modules and built-in functions you have used in your project. 5. Which real world problems are solved by your project? 6. Explain the most important feature of your project. 7. Name a few mutable data types of python. Lists, Sets, and Dictionaries 8. Name a few immutable data types of python. Strings, Tuples, Numeric 9. Name ordered and unordered data type of python. Ordered – String, List, Tuples Unordred – Set, Dictionaries 10. What is the significance of a pass statement in python? pass is no operation python statement. This is used where python requires syntax but logic requires...