CBSE : INFORMATICS PRACTICES/CS & AI

  #INSERTION OF DATA import mysql.connector mydb = mysql.connector.connect( host="localhost", user="root", passwd="root", database="school" ) print("Successfully Connected") #print(mydb) mycursor=mydb.cursor()   v1=int(input("enter ID:")) v2=input("enter name:") v3=input("enter Gender:") v4=int(input("enter age:")) sql='insert into TEACH values("%d","%s","%s","%s")'%(v1,v2,v3,v4) print(sql) mycursor.execute(sql) mydb.commit() print("record added")

 QUESTIONS BASED ON PANDAS SERIES GRADE XII 1.Given the following Series1 A   100 B   200 C   300 D   400 E   500 Write the command to create above Series and then double the value in series and store in another series named Series2 2. State whether True or False a. A series object is size mutable. b. A Dataframe object is value mutable 3. Consider a given Series , Series1: 200 700 201 700 202 700 203 700 204 700 Write a program in Python Pandas to create the series and display it. 4.Consider the following Series object, s IP          95 Physics     89 Chemistry   92 Math        95 i. Write the Python syntax which will display only Physics. ii. Write the Python syntax to increase marks of all subjects by 10. 5. Consider a given series : SQTR QTR1   50000 QTR2   65890 QTR3   56780 QTR4   89000 QTR5   77900 Write a p...

 GRADE XII PANDAS SERIES Notes Link -  Click on the Link -