INFORMATION PRACTICES(065)
CLASS XII
Practical List
1.Write a program to change the value at its 2nd row and 3rd row to 5000 in the given
series.
A 2000
B 3000
C 4000
D 3000
E 5000
2. Given the following Series1:
A 100
B 200
C 300
D 400
E 500
Write the command to create the given series ,then double the value in Seires and
store in another Series named Series2.
3.Consider the pandas DataFrame “DF” given below :
Subodh Ram Paridhi Riya Sonu
Maths 90 92 89 81 94
Science 91 81 91 71 95
English 85 86 83 80 90
Hindi 97 96 88 67 99
a)Write the code to insert column ‘SIYA ‘ with values(90,92,95,89) at position 5 (after
Sonu).
b)Write the code to delete column ‘Riya’ from DataFrame ‘DF’
c)Naina has written the following command to delete the column “Siya” from
DataFrame “DF”.However ,she is not able to get the output.Help her to correct the
code.
DF.drop(“Amit”)
Print(DF)
d)Write the code to insert column ‘Radha’ with values (90,92,95,89) at position 2
4.Consider a table Employee with the following data :
S.n Name Salary Bonus Date of Joining
A01 Akansha 80000 1000.25 20-10-2020
A02 Vani 20000 800.11 10-03-2018
A03 Rohini 70000 1000.5 01-03-2015
A04 Rashmi 50000 NULL 03-12-2014
A05 Sonam 20000 NULL 23-01-2010
A06 Anuj 70000 800.25 15-06-2017
A07 Atharva 50000 1000.5 18-03-2010
Write the SQL queries using SQL function to perform the following operations:
a)Display employee name and bonus after rounding off to zero decimal places.
b)Display the position of occurrence of the string “ni” in employee’s name
c)Display the four characters from employee’s name starting from second character
d)Display the month name for the date of join of Employee
e)Display the name of the weekday for the date of joining of employee.
5.Write the output for SQL queries (a) to (c) which are based on the given table
Purchase :
Cno Cname City Qty Dop
C1 Vaibhav Jaipur 1000 2022-05-11
C2 Dev Pune 2000 2022-03-10
C3 Saanjh Dehradun 1500 2022-02-21
C4 Kavita Noida 2500 2022-08-05
C5 Ashutosh Udaipur 2000 2022-07-18
a)SELECT LENGTH(Cname) FROM PURCHASE WHERE QUANTITY >2000;
b)SELECT Cname FROM PURCHASE where MONTH(DOP)=3;
c)SELECT MOD(QTY,DOP) FROM PURCHASE WHERE CITY=’Dehradun’;
6.Write a program to export marks of four students in five subjects (English,Maths
,IP,Chemistry and Biology) from DataFrame to CSV
