Skip to main content

Posts

IP - CSV XII - BOARD PROJECT

  CSV XII - BOARD PROJECT   RESULT ANALYSIS PROJECT SAMPLE # -*- coding: utf-8 -*- """ Created on Sat Jun 19 16:59:58 2021 @author: Kirti Hora """ # CLASS XII RESULT ANALYSIS PROJECT SAMPLE #CSV DATA #File name: result.csv #File location: g:\ import pandas as pd import matplotlib.pyplot as plt # Main Menu while(True):     print("Main Menu")     print("1. Fetch data")     print("2. Dataframe Statistics")     print("3. Display Records")     print("4. Working on Records")     print("5. Working on Columns")     print("6. Search specific row/column")     print("7. Data Visualization")     print("8. Data analystics")     print("9. Exit")     ch=int(input("Enter your choice"))     if ch==1:         result=pd.read_csv("D:\GRADE XII PYTHON/result.csv",index_col=0)              elif ch==2:       ...
Post a Comment
Read more
Recent 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

DTI | FUNDAMENTAL OF MOVING IMAGES

  DESIGN THINKING & INNOVATION CH - FUNDAMENTAL OF MOVING IMAGES   THEORY NOTES CHAPTER -  FUNDAMENTALS OF MOVING IMAGES Important Video Links: Ultimate Guide to Cinematic Lighting — Types of Light & Gear Explained https://www.youtube.com/watch?v=r2nD_knsNrc   The 3 Essential Elements of Suspense Explained https://www.youtube.com/watch?v=FHXh_uy6gT4 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