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

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...

GRADE XI | DESIGN THINKING & INNOVATION (848) | INTRO | CH-1

  DESIGN THINKING &  INNOVATION (848)  INTRODUCTION LINK : INTRODUCTION PPT PPT LINK Notes: Design Thinking and Innovation Grade XI Introduction Section   I. What is Design? (0.1.1) Definitions from Experts: John Maeda: "Design is solution to a problem". Saul Bass: "Design is thinking made visual". Charles Eames:   “Design is a plan for arranging elements in such a way as best to accomplish a particular purpose.” Steve Jobs:  "Design is not just what it looks like and feels like. Design is how it works". Prof. Sudhakar Nadkarni:  "Essentials of design are— purity, precision, details". Design is a way of understanding needs, identifying problems, and creating appropriate and innovative solutions. It is not only about appearance, but also about usefulness and sustainability. Design is explained as something that helps solve problems and make a positive difference. Key ...