This article help you to get Solved Informatics Practices Practical Question Paper Class 12. Here we go!

Solved Informatics Practices Practical Question Paper Class 12

Lets see the solution for Informatics Practices 065 Practical Question Paper Class 12 solution. Here I will provide you these 5 sets of question paper’s solution. Here we go!

Solved Informatics Practices Practical Question Paper Class 12 Set 1

Let us see the solutions for 5 sets of IP practical Paper 2023. Here it is:

Programs using Pandas and Matplotlib

In this part of Solved IP Practical Paper CBSE Board Exam 2023, programs from Pandas and Matplotlib can be asked. Here I have added 3 programs.

  1. Pandas Series
  2. Pandas Dataframe
  3. Matplotlib

Pandas Series

I have taken the question for pandas series for 2 marks:

Write a program to generate a series of marks of 10 students. Give grace marks up to 3 marks of those who are having marks between 30 to 33 marks and print the new list of the marks. 

Solution:

import pandas as pd
std_marks = []
for i in range(1,11):
  m = int(input("Enter the marks:"))
  std_marks.append(m)
  s = pd.Series(index=range(1201,1211),data=std_marks)
  s[s==32]=s+1
  s[s==31]=s+2
  s[s==30]=s+3
  print("New List is:")
  print(s[s>=33])

If you are looking for pandas series programs follow the below given link:

Pandas Series practical programs

Pandas Dataframe

I have taken question from pandas dataframe for 3 marks. Here

Consider the following data for :      

BookIDSubjectBookTitleClassPublisherPrice
B0001Computer ScienceNCERT Computer ScienceXIINCERT270
B0002Computer ScienceMove fast with computer scienceXIIDhanpat Rai340
B0003Computer ApplicationsSample PapersXBPB120
B0004Informatics PracticesNCERT Computer ScienceXIINCERT270
B0005Artificial IntelligenceArtificial IntelligenceIXKIPS340
B0006Informatics PracticesCBSE Questions BankXIIOswal Books299
  1. Create a dataframe using lists.                                                                                           1
  2. Display books for class XII.                                                                                                         1
  3. Display the books whose price is more than 250.                                                                         1
  4. Plot these data on line chart.                                                                                                         3

Code for 1,2, & 3.

import pandas as pd
import matplotlib.pyplot as mpp
#Answer 1
data={'BookID':['B0001','B0002','B0003','B0004','B0005','B0006'],\
      'Subject':['Computer Science','Computer Science','Computer Appllications',\
      'Informatics Practices','Artificial Intelligence','Informatics Practices'],\
      'Class':['XII','XII','X','XII','IX','XII'],\
      'Publisher':['NCERT','Dhanpat Rai','BPB','NCERT','KIPS','Oswal books'],\
      'Price':[270,340,120,270,340,299]}
books=pd.DataFrame(data)
#Asnwer 2
print("Class XII Books:")
print(books[books['Class']=='XII'].to_string(header=False,index=False))
print("***********************************************************")
#Asnwer 3
print("Books having price more than 250")
print(books[books['Price']>250].to_string(header=False,index=False))
#Answer 4
books.plot(x='Subject',y='Price',kind='bar')
mpp.show()

Download the python code in .py

Download Python Code

MySQL

Consider the following table and write answers for given questions below:

RollNoNameClassDOBGenderCityMarks
1NamanXII1995-05-09MAnand453
2NandiniX1997-04-08FBaroda551
3NakshatraX1997-03-02FBaroda553
4ShaileshXI1995-04-07MSurat458
5TrishaXII1996-04-01FAnand430
6ManishaXII1995-02-05FAnand530
7HetveeXII1995-08-17FJunagadh555
8NeelX1997-10-19MGodhara559
9MayurXII1996-12-04MSurat570
10DolinXII1994-11-02MAnand585

Write SQL statements for the following based on table Garments:

  1. Create above table in MySQL.
  2. Insert records.
  3. To display the detail of class XII students in descending order of their marks.
  4. Display all the details of students in ascending order of name.
  5. Find the maximum marks of the student for each class.
  6. Count the students class wise is display only those number who is more than 2.
  7. Display unique cities from the table.

Solution:

1 Create table:

create table students
(rollno int(4) primary key,
name varchar(20) not null,
class varchar(4),
dob date,
gender char(1),
city varchar(20),
marks float);

2 Insert records:

insert into students values 
(1, 'Naman', 'XII','1995/05/09','M','Anand',453)

Insert all records simimlarly.

3 display the detail of class XII students in descending order of their marks

select * from students order by marks desc;

4 Display all the details of students in ascending order of name

select * from students order by name asc

5 Find the maximum marks of the student for each class

select class,max(marks) from students group by class

6 Count the students class wise is display only those number who is more than 2

select class,count(*) from students group by class having count(*)>2;

7 Display unique cities from the table

select distinct city from students;

Q3. Practical Records                                                                                                           5

The practical file needs to be checked and marks will be given accordingly.

Q4. Project Work                                                                                                                  5

The project work report should be made as per the guideline. Follow this link to download projects for informatics practices with code and solution.

Download Projects Inofrmatics Practices Class 12

Q5. Viva Voce                                                                                                  5

Viva questions can be asked by the external examiner.

Solution Informatics Practices Practical Question Paper Class 12 Set 2

Let us see solution for Inforamtics Practices practical question paper class 12 set 2.

Python Program

Q 1 Write a program in python to create the following dataframe named “country” storing the following details:

 cnameCitybillamtTran_date
1001ShrutiAhmedabad95002010-10-01
1002TusharBaroda53002010-01-04
1003JaySurat45502009-03-01
1004SameerAhmedabad40002009-04-01
1005MayankSurat85002008-08-05
1006MeenaBaroda43002008-08-06
1007DhairyaAhmedabad30002009-10-10

Considering the above dataframe answer the following queries by writing appropriate command in python pandas.
i. Add a new column named discount which is 10% of their bill amount.
ii. Add a row with row index 1008 as Rohan,Bharuch,6000,2011-04-01.
iii. Now plot a bar chart depicting the customer name on x-axis and their corresponding
bill amount on y-axis, with appropriate Graph title, x-axis title, y-axis title, gridlines
and color etc.

Solution:

import pandas as pd
import matplotlib.pyplot as plt
d={'cname':['Shruti','Tushar','Jay','Sameer','Mayank','Meena','Dhairya'],
   'city':['Ahmedabad','Baroda','Surat','Ahmedabad','Surat','Baroda','Ahmedabad'],
   'billamt':[9500,5300,4550,4000,8500,4300,3000],
   'tran_date':['2010-10-01','2010-01-04','2009-03-01','2009-04-01','2008-08-05','2008-08-06','2009-10-10']
  }
customer=pd.DataFrame(d)


#Answer 1
customer['discount']=customer['billamt']*0.10
print(customer)

#Answer 2
customer.loc[1008]=['Rohan','Bharuch',6000,'2011-04-01',600]
print(customer)

#Answer 3
plt.bar(customer['cname'],customer['billamt'],color=['r','g','b','c','m','y','k'])
plt.title("Report",color='Red')
plt.xlabel("Customer Names",color='Blue')
plt.ylabel("Bill Amount",color='Magenta')
plt.show()

Download the Python code:

Download Python Code

MySQL

Q – 2 Create below table “staff” and insert all records.

 Sidsnamedesignationsalarydojoin
1001SagarPGT870002010-11-02Residential Section
1002AnkitClerk240002010-04-01Office
1003DhwaniClerk220002009-01-05Office
1004JenilPRT340002009-07-25Primary
1005RoshniPGT730002008-07-17Senior
1006MitalTGT410002008-04-08Middle
1007GaganLab Assistant240002009-11-23Office

Answer the following sql queries:

i. Display the difference of maximum and minimum salary of each section.

select max(salary)-min(salary) from staff group by section;

ii. Display the staff name, designation and date of joining who joins in the month of July and April.

select sname,designation,dojoin from staff where monthname(dojoin) in ('April','July');

iii. Display the records of staff in their descending order of salary.

select * from staff order by salary desc;

iv. Show first 3 character of staff name.

select left(sname,3) from staff;

v. Display the records of staff who is working since last 12 years

select * from staff where year(now())-year(dojoin)=12;

vi. Display power of length of staff name

select power(length(sname),2) from staff;

Solution Informatics Practices Practical Question Paper Class 12 Set 3

Now get the Solution Informatics Practices Practical Question Paper Class 12 Set 3. Here it is:

Pyhon Program

Q – 1 Write a program in python to create the following dataframe named “country” storing the following details:

 CountryPopulationBirthRateUpdateDate
0China137975000012.002016-08-11
1India133078000021.762016-08-11
2United States32488200013.212016-08-11
3Indonesia26058100018.842016-01-07
4Brazil20691800018.432016-08-11
5Pakistan19475400027.622016-08-11

Considering the above dataframe answer the following question by writing appropriatecommand in python pandas:

  1. Display complete data for China and India.
  2. Display Country, Population and BirthRate of Brazil and Pakistan.
  3. Create a CSV File from the above data frame.
  4. Now plot a bar chart depicting the Country on x-axis and their corresponding Population on y-axis, with appropriate Graph title, x-axis title, y-axis title, gridlines an color etc.

Solution:

import pandas as pd
import matplotlib.pyplot as plt
d={'country':['China','India','US','Indonasia','Brazil','Pakistan'],
   'population':[1379750000,1330780000,324882000,260581000,206918000,194754000],
   'birthrate':[12.00,21.76,13.21,18.84,18.43,27.62],
   'updatedate':['2010-10-01','2010-01-04','2009-03-01','2009-04-01','2008-08-05','2010-04-05']
   }
country=pd.DataFrame(d)


#Answer 1
print("Answer 1")
print(country[country['country']=='China'].to_string(header=False,index=False))
print(country[country['country']=='India'].to_string(header=False,index=False))


#Answer 2
print("Answer 2")
c=country.loc[:,['country','population','birthrate']]
print(c[c['country']=='Brazil'].to_string(header=False,index=False))
print(c[c['country']=='Pakistan'].to_string(header=False,index=False))


#Answer 3
plt.bar(country['country'],country['population'],color=['r','g','b','c','m','y','k'])
plt.title("Population Report")
plt.xlabel("Country")
plt.ylabel("Population")
plt.grid()
plt.show()

country.to_csv('country.csv')

Download Python Code:

Download Python Program

MySQL

Q – 2 Consider the table “Charity” and write SQL queries for the tasks that follow:

Table – Charity

item_idItemnamePriceQtyPdate
1Shoes750052022/11/30
2Socks47532022/08/25
3Jeans350052022/10/19
4T-Shirts140042022/11/30

i) Display the name of week day when socks purchased.

select dayname(pdate) from charity;

ii) Display remainder after dividing price by qty

select mod(price,qty) from charity;

iii) Display the discount amount by 10% in two decimal places.

select round(price*0.10,2) from charity;

iv) Display the records of items purchased in the month 11.

select * from charity where month(pdate)=11

v) Display maximum qty purchased from the table.

select max(qty) from charity;

vi) Display itemname, price and qty in the descending order of price

select itemname, price, qty from charity order by price desc;

vii) Display item_id, itemname and position of s in each itemname.

select item_id,itemname, instr(itemname,'s') from charity;

Solved Informatics Practices Practical Question Paper Class 12 Set 4

Lets move ahead with Solved Informatics Practices Practical Question Paper Class 12 Set 4. Here it is:

Python Program

Q – 1 Write a program in python to create the following dataframe named “employee” storing
the following details:

 ENamePostSalaryDt_join
101AnilManager650002018-03-02
102AkshayClerk330002018-05-01
103AjayManager750002018-09-15
104VarunAnalyst660002018-04-11
105SiddharthDeveloper600002018-10-12
106RajeshClerk350002018-06-12

Considering the above dataframe answer the following queries by writing appropriate command in python pandas.
i. Display Name, Post and Salary for all employees earning more than 60000 .
ii. Add a new row of your choice data.
iii. Transfer these data from dataframe to csv named employees.csv.
iv. Now plot a multi-line chart depicting the Employee Name on x-axis and their corresponding Salary on y-axis, with appropriate Graph title, x-axis title, y-axis title, legends and color etc.

Solution:

import pandas as pd
import matplotlib.pyplot as plt
d={'Ename':['Anil','Akshay','Ajay','Varun','Siddharth','Rajesh'],
   'Post':['Manager','Clerk','Manager','Analyst','Developer','Clerk'],
   'Salary':[65000,33000,75000,66000,60000,35000],
   'Dt_join':['2018-03-02','2018-05-01','2018-09-15','2018-04-11','2018-10-12','2018-06-12']}
employee=pd.DataFrame(d,index=[101,102,103,104,105,106])


#Answer 1
print("Answer 1")
em=employee.loc[:,['Ename','Post','Salary']]
print(em[em.Salary>60000].to_string(header=False,index=False))



#Answer 2
print("Answer 2")
employee.loc[employee.index[-1]+1]=['Ranveer','Analyst',65000,'2020-01-06']
print(employee.iloc[-1])


#Answer 3
employee.to_csv('employees.csv')

#Answer 4
plt.plot(employee['Ename'],employee['Salary'],color='r')
plt.title("Employee Analysis",color='blue')
plt.xlabel("Employee Names",color='red')
plt.ylabel("Salary",color='magenta')
plt.legend(['Salary'])
plt.show()

Download Python Code:

Click here to dwnload Python code

MySQL

Q – 2 Create the table “employee” and write sql queries for the following:

 ENamePostSalaryDt_join
101AnilManager650002018-03-02
102AkshayClerk330002018-05-01
103AjayManager750002018-09-15
104VarunAnalyst660002018-04-11
105SiddharthDeveloper600002018-10-12
106RajeshClerk350002018-06-12

Write queries for the following:
a) Count and display employees post wise.

select post,count(*) from employee group by post;

b) Display 3 characters from 2nd place from the column ename.

select mid(ename,2,3) from employee;

c) Display last 2 characters of post column.

select right(post,2) from employee;

d) Display ename in lower letters

select lower(ename) from employee;

e) Display most senior employee

select min(Dt_join) from employee;

Write output of the following:
a) Select max(dt_join) from employee;

Ans.: max(dt_join)

———————-

2018-10-12


b) Select instr(ename,’a’) from employee

instr(ename,a)

—————-

1

1

1

2

6

2


c) Select power(length(post),2) from employee;

Ans.: power(length(post),2)

———————————

49

25

49

49

64

25
d) Select left(ename,4) from employee;

Ans.: left(ename,4)


anil

aksh

ajay

varu

sidd

raje

Solved Informatics Practices Practical Question Paper Class 12 Set 5

Here is the 5th paper solution. Let us see.

Python Program

Q – 1 Write a Python code for following questions:

 medicineIDMedicinenamePriceManufacturer
05147Paracetamol15Dwarkesh Pharma
15274D-Cold20Apollo Pharmacy
24296Vicks VapoRub45Procter & Gamlbe
34175Vicks Action 50015Procter & Gamble
44385Soframycin85Sanofi

a) create above Data Frame “ved_medicines”
b) Display medicines and its price.
c) Display last 4 medicines
d) Display records of medicines whose price is more 20
e) Draw a bar chart which represent medicine name on x-axis and its price on y-axis.

Solution:

import pandas as pd
import matplotlib.pyplot as plt
d={'medicineid':[5147,5274,4296,4175,4385],
   'medicinename':['Paracetamol','D-Cold','Vicks Vaporub','Vicks Action 500','Soframycin'],
   'price':[15,20,45,15,85],
   'manufacturer':['Dwarkesh Pharma','Apollo Pharmacy','Procter & Gamble','Procter & Gamble','Sanofi']
}
ved_medicines=pd.DataFrame(d)


#Answer 1
print("Answer 1")

print(ved_medicines.loc[:,['medicinename','price']].to_string(header=False,index=False))


#Answer 2
print("Answer 2")
print(ved_medicines.tail(4))


#Answer 3
print(ved_medicines[ved_medicines.price>20])

#Answer 4
plt.bar(ved_medicines['medicinename'],ved_medicines['price'],color=['r','g','b','c','y'])
plt.title("Medicine Report",color='blue')
plt.xlabel("Medicine Names",color='red')
plt.ylabel("Price",color='magenta')
plt.legend(['Price'])
plt.show()

Download Python Code:

Download Python Porgram

MySQL

medicineIDMedicinenamePriceManufacturer
5147Paracetamol15Dwarkesh Pharma
5274D-Cold20Apollo Pharmacy
4296Vicks VapoRub45Procter & Gamlbe
4175Vicks Action 50015Procter & Gamble
4385Soframycin85Sanofi

Observe the above medicine table and write queries for following:
a) Display the unique manufacturer from medicine

select distinct(manufacturer) from medicines;

b) Display manufacturer and total price for each manufacturer

select manufacturer,sum(price) from medicines group by manufacturer;

c) Display manufacturer and price in the ascending order of price

select manufacturer,price from medicines order by price;

d) Display first 4 characters of medicinename which medicine id contains 5 as last digit

select left(medicinename,4) from medines where medicineid like '%5';

e) Display all medicine names in Capital letter

select upper(mdeicinename) from manufacturer;

Write output of the following queries:
a) Select length(right(medicinename,4)) from medicine;

Ans.: length(right(medicinename,4))

————————————-

4

4

4

4

4
b) Select instr(price,5) from medicine;

Ans.: instr(price,5)

————————–

2

0

2

2

2
c) Select round(medicineID/2,-1) from medicine;

Ans.: round(medicineID/2,-1)

————————–

2590

2640

2150

2090

2190

d) Select mid(medicinename,2,4) from medicine

Ans.: mid(medicinename,2,4)


arac

-Col

icks

icks

ofra

Leave a Reply