# CBSE XII Informatics Practices 065 Practical Question Paper Set 2 – Download Word Document

AISSCE XII Informatics Practices 065 – Practical Question Paper Set #2 – Download Word File

All India Senior Secondary Certificate Examination
XII Informatics Practices 065- Practical Question Paper Set #2

### Answer Key of Set – 2 Practical Examination Question Paper

Q1.       Problem Solving using PANDAS & MATPLOTLIB                                                  [5 + 3 = 8]

A. Write the code to create a DataFrame ‘df’ and answer the questions followed.                        (5)

Maths                 Science            SST

Amit                100                  100.0               60.0

Mohan             95                    50.0                 57.48

Sudha              85                    90.0                 53.58

(i) Write a command to add one column Total = Maths + Science + SST
(ii) Write a command to add one row T5 with values 75.6, 98.6, 56.0
(iii) Write a command to print Score of Maths and Science only.
(iv) Write a command to update marks of Science of Sudha to 85.0
(v) Write a command to delete a row – Mohan

import pandas as pd

data =   {‘Maths’:{‘Amit’:100, ‘Mohan’:95, ‘Sudha’:85},
‘Science’:{‘Amit’:100, ‘Mohan’:50, ‘Sudha’:90},
‘SST’:{‘Amit’:60, ‘Mohan’:57.48, ‘Sudha’:53.58}
}

df = pd.DataFrame(data)

>>> df

Maths  Science    SST

Amit     100      100       60.00

Mohan    95      50         57.48

Sudha     85       90        53.58

(i)         df[‘Total’] = df[‘Maths’]+df[‘Science’]+df[‘SST’]

>>> df

Maths  Science    SST   Total

Amit     100      100       60.00    260.00

Mohan    95       50        57.48    202.48

Sudha     85       90        53.58    228.58

(ii)        df.loc[‘T5’,: ] = [75.6, 98.6, 56.6, 230.8]

>>> df

Maths  Science    SST   Total

Amit   100.0    100.0      60.00  260.00

Mohan 95.0     50.0       57.48    202.48

Sudha  85.0     90.0       53.58    228.58

T5        75.6     98.6       56.60    230.80

(iii) df[ [‘Maths’, ‘Science’] ]

Maths  Science

Amit       100.0    100.0

Mohan   95.0     50.0

Sudha     85.0     90.0

T5           75.6     98.6

(iv) df.at[‘Sudha’,’Science’] = 85.0

>>> df

Maths  Science             SST      Total

Amit     100.0    100.0               60.00    260.00

Mohan  95.0     50.0                 57.48    202.48

Sudha  85.0     85.0                 53.58    228.58

T5         75.6     98.6                 56.60    230.80

(v) df = df.drop(‘Mohan’)

Maths  Science             SST      Total

Amit     100.0    100.0               60.00    260.00

Sudha   85.0     85.0                 53.58    228.58

T5         75.6     98.6                 56.60    230.80

B. Write a Python program to display the given Result using a BAR CHART                             (3)

Maths              Science            SST

Amit                100                  100.0               60.0

Mohan             95                    100.0               57.48

Sudha              85                    100.0               53.58

(i)   Set the title of the graph as “Result Analysis”.
(ii)  Display the legends.
(iii) Display the label of x axis to “Name” and y axis to “Score”

```import matplotlib.pyplot as plt
import numpy as np

Subject = ['Maths','Science', 'S.St']

Amit = [100, 100.0, 60.0]
Mohan = [95, 100.0, 57.48]
Sudha = [85,100.0,53.58]

x_axis = np.arange(len(Subject))

plt.bar(x_axis - 0.25 , Amit, 0.25, label='Amit')
plt.bar(x_axis, Mohan, 0.25, label='Mohan')
plt.bar(x_axis + 0.25, Sudha,0.25, label='Sudha')

plt.xticks(x_axis, Subject)

plt.legend(loc =1)

plt.xlabel("Name")
plt.ylabel("Score")
plt.title("Result Analysis")

plt.show()

```

Output:

Q2        SQL Queries:                                                                                                                     [7]

Write the commands in SQL for (i) to (vi) and output for (vii) and (viii).

• To list the names of items and their unit price that have unit price less than 800 and discount more than 5%.

Answer:    SELECT ITEM, UNITPRICE FROM INFANT
WHERE UNITPRICE < 800 AND DISCOUNT > 5 ;

• To display the number of items that have more than 10% as discount.

WHERE DISCOUNT > 10 ;

• To display item code and unit price in decreasing order of unit price.

Answer:           SELECT ITEMCODE, UNITPRICE FROM INFANT
ORDER BY UNITPRICE DESC;

• To increase the unit price of each item by 10% of their unit price.

Answer:           UPDATE INFANT SET UNITPRICE = UNITPRICE + UNITPRICE * 10/100 ;

• To display the highest unit price of items.

• To display the names of items that have ‘Baby’ anywhere in their item names.

WHERE ITEM LIKE ‘%BABY%’ ;

• Find Output :

(i) SELECT MID (Item,1,2) FROM Infant;