CBSE 2024- 25 (AISSCE)

PRACTICAL FILE

Submitted By: Priyanshi Gupta

Submitted To: Mrs. Sangeeta Belwal
Roll No.:
Subject: Informatics Practices (065)

Signature of Internal Signature of External

Examiner Examiner
 ACKNOWLEDGEMEN
T
I WOULD LIKE TO EXPRESS MY SPECIAL
THANKS TO MY SUBJECT TEACHER ‘MRS.
SANGEETA BELWAL’ FOR THEIR ABLE
GUIDANCE AND SUPPORT IN COMPLETING
MY PROJECT.
I WOULD ALSO LIKE TO EXPRESS MY
GRATITUDE TO MY FAMILY AND FRIENDS
WHO HELPED ME AND MOTIVATED ME TO
COMPLETE THIS PROJECT IN THE LIMITED
IN TIME FRAME.

PRIYANSHI GUPTA
12TH COMMERCE
 CERTIFICATE
THIS IS TO CERTIFY THAT ‘PRIYANSHI
GUPTA’, STUDENT OF CLASS 12TH
COMMERCE K.V.M PUBLIC SCHOOL HAS
COMPLETED HER PRACTICAL FILE DURING
THE ACADEMIC YEAR 2024-25 TOWARDS
THE PARTIAL FULFILLMENT OF CREDIT FOR
THE INFORMATICS PRACTICES
EVALUATION OF CBSE AND SUBMITTED
SATISFACTORY REPORT, AS COMPLIED IN
THE FOLLOWING PAGES, UNDER MY
SUPERVISION.

SIGNATURE OF
SIGNATURE OF
INTERNAL EXAMINER
EXTERNAL EXAMINER
  PROGRAM 1

Query:
Write a program to create a series object using an
ndarray.

Coding:

Output:
  PROGRAM 2
Query:
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.

Coding:

Output:
  PROGRAM 3

Query:
Write a program to create a series object that
stores the initial budget allocated (50000/-
each)for the four quarters of the
year:Qtr1,Qtr2,Qtr3,Qtr4.

Coding:

Output:
  PROGRAM 4

Query:
A python list namely section stores the section
names (A, B, C, D) of class 12 in your school.
Another list contri stores the contribution made by
the students to a charity fund endorsed by the
school. Write a code to create a series object that
stores the contribution amount as the values and
the section names as indices.

Coding:

Output:
  PROGRAM 5

Query:
Consider the series object s13 shows the
contribution of each section.
A 6700
B 5600
C 5000
D 5200
Write code to modify the amount of section A as
7600 and C and D as 7000.

Coding:

Output:
  PROGRAM 6

Query:
Series object ‘S11’ stores the contribution made by
each section A, B, C, D=7200, 6500, 7500, 6700.
Write a program to display the section who has
contributed more than 7000.

Coding:

Output:
  PROGRAM 7

Query:
No. of students in class 11 and 12 are stored in 3
sections Science, Commerce; Arts in two series
object c11 and c12. Write a code to find out total
no of students in class 11 and 12.

Coding:

Output:
  PROGRAM 8

Query:
Create a series object with a NaN value in it. Write
a code to check whether it has a NaN value or not.

Coding:

Output:
  PROGRAM 9

Query:
Write a code to create a dataframe using 2D
dictionary.

Coding:

Output:
  PROGRAM 10

Query:
Write a program to create a dataframe from 2D
list. Specify your own indices.
Coding:

Output:
  PROGRAM 11

Query:
Write a program to create a dataframe to store
weight, age, name of 3 people. Print the dataframe
and it transpose.

Coding:

Output:
  PROGRAM 12

Query:
Given dataframe has the information of 3 students
in a class.
ROLL NAME AGE
ROW1 1 Amit 12
ROW2 2 Sumit 13
ROW3 3 Rohit 12

Write a program to display only name and

age of students.

Coding:

Output:
  PROGRAM 13

Query:
Given dataframe has the information of 3 students
in a class.
ROLL NAME AGE
ROW1 1 Amit 12
ROW2 2 Sumit 13
ROW3 3 Rohit 12

Write a program to display the data of roll

and name of last two rows.

Coding:

Output:
  PROGRAM 14

Query:
Given dataframe has the information of 3 students
in a class.
ROLL NAME AGE
ROW1 1 Amit 12
ROW2 2 Sumit 13
ROW3 3 Rohit 12

Write a program to add a row in the

dataframe.

Coding:

Output:
  PROGRAM 15

Query:
Given dataframe has the information of 3 students
in a class.
ROLL NAME AGE
ROW1 1 Amit 12
ROW2 2 Sumit 13
ROW3 3 Rohit 12

Write a program to add a column in the

dataframe.

Coding:

Output:
  PROGRAM 16

Query:
Given dataframe has the information of 3 students
in a class.
ROLL NAME AGE CLASS
ROW1 1 Amit 12
12th
ROW2 2 Sumit 13
12th
ROW3 3 Rohit 12
12th

Write a program to rename the column

class=standard in the dataframe.

Coding:

Output:
  PROGRAM 17

Query:
Given dataframe has the information of 3 students
in a class.
ROLL NAME AGE CLASS
ROW1 1 Amit 12
12th
ROW2 2 Sumit 13
12th
ROW3 3 Rohit 12
12th
ROW4 4 Garvit 14
12th
Write a program to delete the column
‘CLASS’ and row ‘ROW4’ from the dataframe.

Coding:
Output:

 PROGRAM 18

Query:
Import a CSV file to pandas converting it into a
series.
CSV File:
Coding:
Output:

 PROGRAM 19

Query:
Import the following table from CSV file to pandas:
ROLL NAME
1 Ram
2 Bharat
3 Laxman
4 Shatrugan

CSV File:
Coding:

Output:
PROGRAM 20

Query:
Write a suitable python code to draw the following
chart ‘CO2 Emission’ having title and label X and Y
axis as shown below.

Coding:
  PROGRAM 21

Query:
Dheeraj wants to plot a line chart based on given
data to view the changing weekly average
temperature. Help her to write the code in python.
Also find appropriate chart title and axis title.

Coding:

Output:
  PROGRAM 22

Query:
Country Gold Silver Bronze
Total
Australia 80 59 59
198
India 26 20 20
66
Plot a bar graph.
Coding:

Output:
  PROGRAM 23

Query:
Val limited is a list having 3 lists inside it. It
contains summarised data of 3 different conducted
by company a. Create a bar chart that plots these
3 subsits of vol in single chart. Keep the width of
each bar 0.25.
Coding:

Output:
  PROGRAM 24

Query:
Write a program to plot a bar graph from medals
won by India. Make sure that the gold, silver,
bronze and total is represented through different
colours.

Coding:

Output:
  PROGRAM 25

Query:

This is the table-students in SQL.

Display the name and age from the table students.

Coding:

Output:
  PROGRAM 26

Query:

This is the table-students in SQL.

Display the name whose age is more than 13 from

the table students.

Coding:

Output:
  PROGRAM 27

Query:

This is the table-students in SQL.

Display the name and roll of those students whose

name ends with ‘man’.

Coding:

Output:
  PROGRAM 28

Query:

This is the table-students in SQL.

Update the table and set age of sohan as 15.

Coding:

Output:
  PROGRAM 29

Query:

This is the table-students in SQL.

Delete the tuples whose age is less than 15.

Coding:

Output:
  PROGRAM 30

Query:

This is the table student in SQL.

Write a command to convert all the names from

upper case to lower case.

Coding:

Output:
  PROGRAM 31

Query:
Write a query to remove leading spaces from (‘
information’).

Coding:

Output:

 PROGRAM 32

Query:
Write a query to remove trailing spaces from
(‘informatics ‘).

Coding:

Output:
  PROGRAM 33

Query:
Write a query to select the last 4 characters from
the word(‘technology’).

Coding:

Output:

 PROGRAM 34

Query:
Display the position of occurrence of string ‘or’ in
the word ‘corporate’.

Coding:

Output:
  PROGRAM 35

Query:
Find out the remainder of 11 divided by 4.

Coding:

Output:

 PROGRAM 36

Query:
Display the result of 32.

Coding:

Output:
  PROGRAM 37

Query:
Round off the value 15.193 to one decimal place.

Coding:

Output:

 PROGRAM 38

Query:
Find out the square root of value 25.

Coding:

Output:
  PROGRAM 39

Query:
Write a program to display date of current date on
your system.

Coding:

Output:

 PROGRAM 40

Query:
Write a program to display the day of year.

Coding:

Output: