INDIAN PUBLIC SCHOOL
INFORMATICS PRACTICES
PRACTICAL RECORD 2024-2025
NAME: MD.AHAD
CLASS: XII-B
ROLL NO:- ____________________
BONAFIDE CERTIFICATE
Certified to be the bonafide work done by Mr.
MD.AHAD of class XII-B in INFORMATICS
PRACTICES, during the year 2024-2025 Date:
MR. SAJI VARGHESE SAMUEL
(PGT in Computer Science)
INDIAN PUBLIC SCHOOL
SALMIYA KUWAIT
Submitted for ALL INDIAN SENIOR SCHOOL
CERTIFICATE PRACTICAL EXAMINATION held in Computer lab at
INDIAN PUBLIC SCHOOL, SALMIYA, KUWAIT
DATE: Examiner:
Seal:
INDEX
S.NO. Name of the Page No.
Experiment
I SERIES
1 Create the given pandas
series from a dictionary of
values
Write a Pandas program to
2 perform arithmetic operation
on two Pandas Series
Write pandas programs to add
3 some data to existing
Series
Write Python program to
4
create and display the series
Consider the series object
5 ,'company' and its profit in
Crores
Consider the series object
6
's10'
Consider the series object
7 's12' and
Write code to find total
8 number of students in class
11 and 12,stream wise
Write code to create series
9 'serObj'
Create the series and display
10 the first three and last five
values
II DATAFRAME PAGE NO.
Create dataframe named as
1 students using a list of names
of 5 students
Create dataframe named as
2 students using a list of names
of 5 students
Develop a program to create a
3 dataframe players using a
list of names and scores using
dictionary
Write a program to create a
4 dataframe salesman using the
series sales_person
Develop python program to
5 store the given information as
a Dataframe
Iterate the given Dataframe by
6 its rows
Iterate the given Dataframe by
7 its column
Create the dataframe and
8 answer the following
questions
Given the series, answer the
9 questions
Create the following
10 dataframe and answer the
following questions
Create the dataframe and
11 answer the following
questions
III DATA PAGE NO.
VISUALISATION
The score of four teams in 5
1 IPL matches are given.Write
program to plot these in a
bar charts
The prices of a stock for three
2 months are given. Write a
program to show the
variations in prices
Based on the given Bar
3 graph,write python program
to get an output as given
below
Given set of data for subject
4 and marks plot a horizontal
bar graph
Navya has started an online
5 business. Write a python
program to plot this data on a
horizontal bar graph
Given the following set of
6 data; create a simple
histogram from the above
data
Plot the following data using a
7 line plot
Write python code to plot bar
8 chart for sales in different
cities
Prepare a line chart for the
9 given data of marks of student
with red color line
Plot the following data on line
10 chart
IV MYSQL PAGE NO.
QUERIES
ASSIGNMENT -1 Table :
1 Member
ASSIGNMENT-2 Table :
2 CUSTOMER
ASSIGNMENT-3 Table :
3 SALESMAN
ASSIGNMENT-4 Table 1:
4 GAMES Table 2 : PLAYER
ASSIGNMENT-5 Table :
5 STUDENT
ASSIGNMENT-6 Table 1 : Item
6 Table 2 : Vendor
ASSIGNMENT-7 Table 1 :
7 Flights Table 2 : Fares
ASSIGNMENT-8 Table 1 :
8 Salesperson Table 2 : Orders
