Skip to main content

Posts

IP | CSV PROJECT- PATIENT MAMAGEMENT

  CSV PROJECT PATIENT MAMAGEMENT # -*- 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("enter 1 to ADD PATIENT DETAILS")     print("enter 2 to DELETE PATIENT DETAIL")     print("enter 3 to UPDATE PATIENT DETAIL")     print("enter 4 to SEARCH PATIENT ")     print("enter 5 to DISPLAY PATIENT DETAILS")     print("enter 6 to DISPLAY CITY WISE GRAPH")     print("enter 7 to EXIT....")     d=int(input("enter choice:"))     print("="*60)     if d==1:         add()          elif d==2:         delete()     elif d==3:         update()     elif d==4:         search()     elif d==5:         d...
Post a Comment
Read more
Recent posts

DTI | FUNDAMENTAL OF MOVING IMAGES

  DESIGN THINKING & INNOVATION CH - FUNDAMENTAL OF MOVING IMAGES   Important Links: Ultimate Guide to Cinematic Lighting — Types of Light & Gear Explained https://www.youtube.com/watch?v=r2nD_knsNrc   Ultimate Guide to Camera Angles: Every Camera Shot Explained https://www.youtube.com/watch?v=wLfZL9PZI9k   Use these Creative Camera Angles & Shots to become PRO Film Maker !! https://www.youtube.com/watch?v=vZcfj6PTF5A   Ultimate Guide to Camera Movement — Every Camera Movement Technique Explained https://www.youtube.com/watch?v=IiyBo-qLDeM  
Post a Comment
Read more

IP - CSV | DATA ANALYSIS PROJECT

  IP - CSV DATA ANALYSIS PROJECT   RollNo,Name,English,Math,IP 101,Aarav,78,85,92 102,Diya,88,79,95 103,Rohan,67,91,89 104,Ananya,92,87,96 105,Vivaan,75,80,84   import pandas as pd # Reading CSV file df = pd.read_csv("student_marks.csv")   # Display complete data print("Student Data:") print(df)   # Add Total column df["Total"] = df["English"] + df["Math"] + df["IP"]   # Add Percentage column df["Percentage"] = df["Total"] / 3 print("\nUpdated Data:") print(df)   # Highest scorer df = df.sort_values(by="Total", ascending=False) print("\nTopper Details:") print(df.iloc[0])   # Subject-wise average print("\nAverage Marks:") print(df[["English", "Math", "IP"]].mean()) print("\nDataFrame Properties:")   print("Shape of DataFrame:", df.shape) print("Column Na...
Post a Comment
Read more

XII CS | FUNCTIONS WITH PARAMETER | 6TH MAY

  Q1. MINI CALCULATOR WITH PARAMETER def add(a, b):          #a and b given in function header are called parameters     print(a + b) def subtract(a, b):     print(a - b) # taking input from user num1 = float(input("Enter first number: ")) num2 = float(input("Enter second number: ")) # calling functions add(num1, num2)    #num1 and num2 given in function call are arguments subtract(num1, num2) Q2.Store the result in a variable (using return ) def add(a, b):     return a + b def subtract(a, b):     return a - b # taking input num1 = float(input("Enter first number: ")) num2 = float(input("Enter second number: ")) # storing result in variables result1 = add(num1, num2) result2 = subtract(num1, num2) # printing results print("Addition:", result1) print("Subtraction:", result2) IMPORTANT POINT ·      return sends value back to main program ·      That value can be store...
Post a Comment
Read more

GRADE XI - Employability Skills | Unit 1: Assignment

  Employability Skills Unit 1: Communication Skills Introduction to Communication QUE. Answer the following questions: 1.                    What is meant by sender in communication? 2.                    What is feedback in communication? 3.                    Explain the communication cycle with diagram. 4.                    Describe the importance of effective communication in daily life. 5.                    Explain verbal communication and its types with examples. 6.         ...
Post a Comment
Read more

GRADE XII - MYSQL CONNECTIVITY WITH PYTHON

  GRADE XII - MYSQL CONNECTIVITY WITH PYTHON SOURCE CODE : #ADD TO DATABASE import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) mycursor=mydb.cursor() v1=input("enter GROCERY ID:") v2=input("enter GROCERY NAME:") v3=int(input("enter PRICE:")) v4=int(input("enter QUANTITY:")) sql='insert into GRO values("%s","%s","%d","%d")'%(v1,v2,v3,v4)  #print(sql) mycursor.execute(sql) mydb.commit() print("*********Grocery Added To Database Successfully*****") #TO VIEW DATA sql="select * from gro" mycursor.execute(sql) res=mycursor.fetchall() print("The AVAILABLE GROCERY details are as follows : ") print("G_ID    NAME     PRICE   QUANTITY") print("\n##*************************************** ************ ##") for x in res:         print(x) print("\n##**...
Post a Comment
Read more

GRADE XII IP - DATAFRAME OPERATIONS | 9-4-26

  PYTHON PANDAS BASIC DATAFRAME OPERATIONS import pandas as pd import numpy as np print("\nPYTHON PANDAS BASIC DATAFRAME OPERATIONS") # Creating DataFrame data = {     'Name': ['Amba', 'Radha', 'Sharada', 'Ayan'],     'Score': [90, 76, 88, 89] } df = pd.DataFrame(data) print("\nINITIAL DATAFRAME IS:\n") print(df) # Basic Operations print("\nMaximum Value in the Entire DataFrame is:", df.values.max()) print("\nMinimum Value in Score Column is:", df['Score'].min()) print("\nMaximum Value in Score Column is:", df['Score'].max()) print("\nMean of Score Column is:", df['Score'].mean()) print("\nNumber of Records in DataFrame:\n", df.count()) print("\nSum of Score Column:", df['Score'].sum()) # Sorting print("\nSorting DataFrame by Name:\n", df.sort_values('Name')) # Updating using loc print("\nUpdating Score of...
Post a Comment
Read more