Skip to main content

Posts

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
Recent posts

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

GRADE XII IP - Creating DataFrame from Dictionary

  Creating DataFrame from Dictionary 1. Dictionary of List import pandas as pd # Creating dictionary data = {     'Name': ['Aman', 'Riya', 'Karan', 'Sita'],     'Class': ['XII', 'XII', 'XII', 'XII'],     'Marks': [85, 90, 78, 88] } # Creating DataFrame df = pd.DataFrame(data) # Display DataFrame print(df) 2. import pandas as pd data = {     'Product': ['Pen', 'Pencil', 'Eraser'],     'Price': [10, 5, 3] } df = pd.DataFrame(data, index=['P1', 'P2', 'P3']) print(df) Creating DataFrame from List of Dictionaries import pandas as pd # List of dictionaries data = [     {'Name': 'Aman', 'Marks': 85, 'Subject': 'Math'},     {'Name': 'Riya', 'Marks': 90, 'Subject': 'Science'},     {'Name': 'Karan', 'Marks': 78, 'Subject': 'English...
Post a Comment
Read more

GRADE XII - MYSQL JOIN QUERY ASSIGNMENT

  MYSQL JOINS Given Tables Student(RollNo, Name, Class) Marks(RollNo, Subject, Marks) Questions 1. Write a query using Equi Join to display Student Name and Marks. 2. Write a query using Equi Join to display all columns from both tables where RollNo matches. 3. Write a query using NATURAL JOIN to display all matching records. 4. Write a query using NATURAL JOIN to display Name, Subject, and Marks. 5. Write a query to display all possible combinations of Student and Marks using Cartesian Product. 6. Write a query using Cartesian Product with WHERE condition to display only matching RollNo records. 7. Identify the type of JOIN used in: SELECT * FROM Student, Marks; 8. Predict the number of rows returned by: SELECT * FROM Student, Marks; 9. Write a query using Equi Join to display names of students who have marks greater than 85. 10. Write a query using NATURAL JOIN to display records of Class 12 students only. 11. Write a query using Equi Join to display RollNo, Name, and Subject. 12...
Post a Comment
Read more