2024-2025
NAME - Roshanpreet Singh Dhiman
CLASS - XII Sci-A
ROLL NO. - 22
Submitted To – Mr. Manoj Kumar
ACKNOWLEDGEMENT
I wish to express my deep sense of
gratitude and indebtedness to our
learned teacher Mr. Manoj Kumar, for
his invaluable help, advice and
guidance in the preparation of this
project.
I am also greatly indebted to our
principal Dr. Manoj Kumar and school
authorities for providing me with the
facilities and requisite laboratory
conditions for making this practical file.
Roshanpreet Singh Dhiman
CERTIFICATE
This is to certify that Roshanpreet singh
Dhiman ,student of Class XII, L.S.M.S
SEN. SEC. VIDYA MANDIR SCHOOL ,
has completed the PRACTICAL FILE
during the academic year 2024-25
towards partial fulfillment of credit for
the Informatics Practices practical
evaluation of SSCE-2025 and submitted
satisfactory report, as compiled in the
following pages, under my supervision.
Internal Examiner External Examiner
Signature Signature
________________ _________________
S.No Name of the Exercises Page.No
Programs using Pandas
SERIES
1 Creating a Python program to create a series using a dictionary. 3
2 Creating a Python program to create a series using scalar value. 4
3 Creating a Python program to create a series using numpy array. 5
4 Creating a Python program for modifying or updating existing values of series object. 6
5 Creating a Python program for performing mathematical operations on two Series objects. 7
6 Creating a Python program for calculating per capita income of four zones using Series. 8
7 Creating a Python program to display attributes of a Series. 9
8 Creating a Python program using head() and tail() in Series. 10
DATAFRAME
9 Creating a Python program for creating a DataFrame using a nested list. 11
10 Creating a Python program for creating a DataFrame using a dictionary of lists. 12
11 Creating a Python program for accessing values of rows and columns of a DataFrame. 14
12 Creating a Python program to perform operations on a DataFrame (rename, count, update, replace). 16
13 Creating a Python program to filter the data of a DataFrame. 18
14 Creating a Python program to display the attributes of the DataFrame. 19
15 Creating a Python program to display the data of a DataFrame row-wise and column-wise using iterrows() and iteritems() 20
16 Creating a Python program to perform writing and reading operations in a CSV file. 22
Programs using Matplotlib – Data Visualization
17 Creating a python program for plotting a line chart. 23
18 Creating a python program for plotting a bar chart from a CSV file. 24
19 Creating a python program for plotting a multiple bar chart from a CSV file. 25
20 Creating a python program for plotting Histogram. 26
SQL Queries
21 SQL COMMANDS EXERCISE – 1 (Basic Queries – I) 27
22 SQL COMMANDS EXERCISE – 2 (Basic Queries – II) 29
23 SQL COMMANDS EXERCISE – 3 (Aggregate functions, Order by Group by, Having Clause) 31
24 SQL COMMANDS EXERCISE – 4 (Math Functions) 33
25 SQL COMMANDS EXERCISE – 5 (Text Functions) 35
26 SQL COMMANDS EXERCISE – 6 (Date Functions) 37
1) Creating a Python Program to Create a Series Using a Dictionary.
INPUT:-
OUTPUT:-
2) Creating a Python program to create a series using scalar value.
INPUT:-
OUTPUT:-
Page no 5
3) Creating a Python program to create a series using numpy array.
INPUT:-
OUTPUT:-
4) Creating a Python program for modifying or updating existing
values of series object.
INPUT:-
OUTPUT:-
Page no 6
4) Creating a Python program for performing mathematical
operations on two Series objects.
INPUT:-
OUTPUT:-
Page no 7
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
Page no 4
