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



Labels:

Comments

Post a Comment

Popular posts from this blog

GRADE XII - Python Connectivity with MySQL

  Python Connectivity with MySQL In real-life applications, the data inputted by the user and processed by the application needs to be saved permanently, so that it can be used for future manipulation. Usually, input and output data is displayed during execution but not stored, as it resides in main memory , which is temporary — i.e., it gets erased once the application is closed. This limitation can be overcome by sending the data to be stored in a database , which is made accessible to the user through a Front-End interface . Key Concepts Database A database is an organized collection of data that is stored and accessed electronically from a computer system. DBMS (Database Management System) A DBMS is software that interacts with end-users, applications, and the database to capture and analyze data. Front-End The Front-End is the user interface of the application, responsible for input/output interaction with the user. Back-End The Back-End refe...
Post a Comment
Read more

GRADE XII - CSV FILE

CSV FILE (COMMA SEPERATED VALUE) CSV NOTES LINK :  CSV NOTES - CLICK HERE Writing data to a CSV file involves the following steps: Import the csv module Open the CSV file in write mode ( "w" ) using open() Create the writer object Write the data into the file using the writer object Close the file using close() writerow() Method This method is used to write a single row to a CSV file. It takes a sequence (list or tuple) as its parameter, and writes the items as a comma-separated line in the file. You do not need to add a newline character (\n) — it automatically places the end-of-line marker.     EXAMPLE 1: import csv  # Importing the csv module # CSV file opened using relative path csv_fobj = open("emp.csv", "w")   # Writer object created wtr_obj = csv.writer(csv_fobj) # Record with field heading is written wtr_obj.writerow(["Empno", "Name", "Salary"]) # Records with data are...
Post a Comment
Read more