PM SHRI KENDRIYA VIDYALAYA
JHARODA KALAN
INFORMATICS PRACTICES Class XII Subject Code: 065 Session:
2025-26
PRACTICAL PROGRAMS
NAME : PREETI
ROLL NO. :
CLASS : 12 COMMERCE (B)
ACKNOWLEDGEMENT
I would like to express my special thanks of gratitude to
my teacher Mrs. Priyanka Chhabra , who gave me the
golden opportunity to do this wonderful project of
Informatics practices , Who also helped me in completing
my project. I came to know about so many new things I
am really thankful to them. Secondly i would also like to
thank my parents and friends who helped me a lot in
finalizing this project within the limited time frame.
Preeti
XII Commerce
CERTIFICATE
This is to certify that Preeti a student of class
XII commerce has successfully completed the
research on the project programs file
Under the guidance of MRS. Priyanka Chhabra
during the session 2025-26 in the partial
fulfilment of INFORMATICS PRACTICES
practical examination conducted by CBSE.
EXTERNAL EXAMINER'S SIGNATURE INTERNAL EXAMINER'S SIGNATURE
1. Write a program to create a Pandas series from a dictionary of
values.
Solution:
Output:
2. Write a program to create a Pandas series from an
ndarray.
Solution:
Output:
3. Write a program to create a Series object using a dictionary that stores
the number of students in each section of class 12 in your school.
Output:
4. Write a program to create a data frame for examination result
and display row labels, column labels, data types of each column
and the dimensions.
Output:
5. Write a program to create a DataFrame and replace all negative values
by 0.
Output:
6. Consider the series object S that stores the contribution of each section, as
shown below:
A 4300
B 6500
C 3900
D 6100
Write code to modify the amount of section ‘A’ as 3400 and for section ‘C’ and
‘D’ as 45000. Print the changed object.
Output:
7. Write a program to create a Data Frame Quarterly Sales where each row
contains the Quarterly Sales of TV, Freeze and AC. Show the DataFrame after
deleting details of Freeze.
Output:
8. Write a program to create a DataFrame to store Roll Number, Name and
Marks of five students. Print the DataFrame and its transpose.
Output:
9. Write a program to create data series and then change the indexes of the
Series object in any random order.
Output:
10. In an online contest, two 2
2-player teams’ point in 4 rounds are stored in
two DataFrames as shown below:
Team 1’s points (df1) Team 2’s points (df2)
P1 P2 P1 P2
1 700 490 1 1100 1400
2 975 460 2 1275 1260
3 970 570 3 1270 1500
4 900 590 4 1400 1190
Write a program to calculate total points earned by both the teams in each round.
Output:
11. Write a program to create a DataFrame with two columns name and age.
Add a new column Updated Age that contains age increased by 10 years.
Output:
13. Write a program to create a DataFrame which contains RollNumber, Name,
Height and Weight of 05 students. Create a CSV file using this DataFrame.
Output:
14. Given the school result data, analyse the performance of the students
on different parameters, e.g subject wise or class wise using bar graph.
Output:
15. Draw the histogram based on the Production of Wheat in different years
Year :2000,2002,2004,2006,2008,2010,2012,2014,2016,2018
Production':4,6,7,15,24,2,19,5,16,4
Output:
16. The table shows passenger car fuel rates in miles per gallon for
several years. Make a line graph of the data.
YEAR: 2000 2002 2004 2006 RATE: 21.0 20.7 21.2 21.6
Output:
17. The number of bed-sheets manufactured by a factory during five
consecutive weeks is given below.
Week First Second Third Fourth Fifth
Number of bed sheets 600 850 700 300 900
Draw the bar graph representing the above data
Output:
18. Write a program to plot a bar chart from the medals won by four
countries. Make sure that bars are separately visible.
Output
19. A survey gathers height and weight of 60 participants and recorded
the participants’ ages as:
Ages=[1,1,2,3,5,7,8,9,10,10,11,13,13,15,16,17,18,19,20,21,21,23,24,24,2
4,25,25,25,25,26,26,26,27,27,27,27,27,29,30,30,30,30,31,33,34,34,34,35,
36 ,36,37,37,37,38,38,39,40,40,41,41]
Write a program to plot a histogram from above data with 20 bins.
Output:
20. Write a program to plot a horizontal bar chart from heights of some
students.
Output:
DATA MANAGEMENT (SQL)
1. Create a Student table with the student id, name, class, marks and
DOB as attributes where the student id is the primary key.
Output:
2. Insert 10 records in the above table.
Output:
3. Delete the details of a student with marks>40 in the above table.
Output:
4. Use the select command to get the details of the students with
marks less than 80.
Output:
5. Find the minimum and maximum marks in a student table.
Output:
6. Find the sum and average of the marks in a student table.
Output:
7. Find the total number of customers from each class in the table
Student using group by.
Output:
8. Write a SQL query to order the (student ID, marks) table in
descending order of the marks.
Output:
9. To show all information about the students whose names are
having ‘A’ as one of the characters.
Output:
10. Display total no. of records in the table Student.
Output:
11. Add a new column Grade of type string.
Output:
12. Remove the column Grade
Output:
13. Convert the name of the students of class XI to upper case
Output:
14. Display the last 2 characters of students’ name studying in class XII
Output:
15. Display the details of students born in the month of October.
Output:
BIBLIOGRAPHY
[Link]
[Link] world
On-line Help of Python
Informatics Practices for class XII
Google Images
NCERT TEXT
Various Websites of Discussion Forum and software
development activities.