CBSE : INFORMATICS PRACTICES/CS & AI

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

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

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

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