Informatics Practices Practical file GRADE 12
SERIES
1. Create a Series object 'vowel' to store all vowels individually. Its index should be 1,2,3,4 &
5.
2. Create s Series object using ndarray that has 5 elements in the range 50 and 100.
3. Create a Series object using dictionary that stores the number of students in each section of
class 12th of your school.
4. Total no of students to be admitted is 350 in ABC School every year. Write a code to
create a Series object School that stores these total number of students for the year 2015 to
2024.
5. Number of students in class 11 and class 12 in three streams (science, commerce and
humanities) are stored in 2 series object class 11 and class 12. Write code to find total no of
students in class 11 & class 12 stream wise.
6. Create a series 'temp' that stores temperature of seven days in it. Its index should be
'Sunday', 'Monday’……. and perform the following tasks.
1. Display temp of first 3 days.
2. Display temp of last 3 days.
3. Display all temp in reverse order like Saturday, Friday......
4. Display temp from Tuesday to Friday.
5. Display square of all temperature.
DATAFRAME
1. Create a dataframe named as students using a list of names of 5 students.
2. Create a dataframe players using a list of names and scores of the previous three
matches. (Using Nested list)
3. Create a dataframe countries using a dictionary which stored country name, capitals
and populations of the country.
4. Creating a Python program to perform writing and reading operations in a CSV file.
5. Consider the following data for :
BookID Subject BookTitle Class Publisher Price
B0001 Computer Science NCERT Computer XII NCERT 270
Science
B0002 Computer Science Move fast with computer XII Dhanpat 340
science Rai
B0003 Computer Sample Papers X BPB 120
Applications
B0004 Informatics NCERT Computer XII NCERT 270
Practices Science
B0005 Artificial Artificial Intelligence IX KIPS 340
Intelligence
B0006 Informatics CBSE Questions Bank XII Oswal 299
Practices Books
a) Create a dataframe using dictionary
b) Display books for class XII.
c) Display the books whose price is more than 250.
d) Plot Book and price data on bar chart.
MATPLOTLIB
1. Given the school result data, analyse the performance of the students on different
parameters ex. Subject-wise and class-wise.
2. Consider the following data of a medical store and plot the data on the line chart and
Customise the chart using all properties of plot function.
Month Masks Sanitizer Hand wash
March 1500 4400 6500
April 3500 4500 5000
May 6500 5500 5800
June 6700 6000 6300
July 6000 5600 6200
Augus 6800 6300 4500
t
3. Use above data and subplot sanitizer data and handwash data.
4. Bar chart Question
Database query using MySQL
Q2. (MySQL)Consider the following table RESULT2024 and write answers for given
questions below:
RollNo Name Class DOB Gender City Marks
1 Naman XII 1995-05-09 M Anand 453
2 Nandini X 1997-04-08 F Baroda 551
3 Nakshatra X 1997-03-02 F Baroda 553
4 Shailesh XI 1995-04-07 M Surat 458
5 Trisha XII 1996-04-01 F Anand 430
6 Manisha XII 1995-02-05 F Anand 530
7 Het XII 1995-08-17 F Junagadh 555
8 Neel X 1997-10-19 M Godhara 559
9 Mayur XII 1996-12-04 M Surat 570
10 Dolin XII 1994-11-02 M Anand 585
Write SQL statements for the following based on table Garments:
(a) Create the above table in MySQL.
(b) Insert records.
(c) To display the details of class XII students in descending order of their marks.
(b) Display all the details of students in ascending order of name.
(d) Find the maximum marks of the student for each class.
(e) Count the students class wise and display only those numbers which are more than (f)
Display unique cities from the table.
