CENTRAL BOARD OF SECONDARY EDUCATION
ASM’s EMPROS INTERNATIONAL SCHOOL,
MIDC, Block C, IBMR, Chinchwad, Pune411019
A PRACTICAL RECORD FILE IS SUBMITTED TO DEPARTMENT OF
INFORMATICSPRACTICES FOR THE PARTIAL FULLFILLMENT OF
AISSCE EXAMINATION SESSION-2024-2025
SUBMITTED BY: SARTHAK BALU KOKATE
HOD (COMPUTER): SRUJANA
CLASS: 12TH
ROLL NO:
Page1of19
ACKNOWLEDGEMENT
I wish to express my deep sense of
gratitude and indebtedness to our learned
teacher Srujana G ma’am, PGT
INFROMATICS PRACTICES, ASM’s
Empros International School for her
invaluable help, advice and guidance in
the preparation of this project.
I am also greatly indebted to our
principal Dr Vaishali Chavan ma’am and
school authorities for providing me with
the facilities and requisite laboratory
conditions for making this practical file.
I also extend my thanks to a number
of teachers, my classmates and friends
who helped me to complete this practical
file successfully.
(Student Sign)
Page2of19
CERTIFICATE
This is to be certify that Sarthak Balu Kokate,
student of class XII , ASM’s Empros
International school has completed the
PRACTICAL FILE during the academic year
2024-2025 towards partial fulfillment of
credit for the Informatics Practices practical
evaluation of SSCE-2024-2025 and submitted
satisfactory report, as compiled in the
following pages, under my supervision.
Total number of practical certified are:
Internal Examiner External
Examiner
Signature Signature
Page3of19
Date: SchoolSeal Principal Signature
Page4of19
No Practical Date Signature
1 Data Handling
1 Createa panda’s series from adictionary of
values and and array
2 Given a Series,print all the elements that are
above the 75thpercentile
3 Create DataFrame quarterly sales where each
row contains the item category, item name and
expenditure. Group the rows by the category
and Print the total expenditure per category.
4 Create a dataframe for examination result and
display row labels, column labels datatypes of
each Column and the dimensions.
5 Filter out rows based on different criteria such
as Duplicate rows.
6 Importing and exporting data between pandas
and CSVfile
2 Visualization
1 Given the school result data, analyses the
Performance of the students on different
parameters, e.g subject wise or class wise
2 For the Dataframes created above,analyze,and
Plot appropriate charts with title and legend.
3 Take data of your interest from an opensource
(e.g data.gov.in),aggregate and summarize
it.Then plot it using different plotting functions of
the Matplot liblibrary.
3 Data Management
Page5of19
1 Create a student table with the student
id,name,and marks as attributes where the
student id is the Primary key.
2 Insert the details of a new student in the above
table.
3 Delete the details of a student in the above table
4 Use the select command to get the details of the
Students with marks more than 80.
5 Find the min,max,sum and average of the marks
in a student marks table.
6 Find the total number of customers from each
country in the table (customer ID, customer
Name, country) using group by.
7 Write a SQL Query to order he(studentID,marks)
Table in descending order of the marks.
Page6of19
DataHandling
1) Create a panda’s series from a dictionary of values and
and array
Code:
Output:
Page7of19
2) GivenaSeries,print all the elements that are above the75th percentile
Code:
Output:
Page8of19
3) Create a Data Frame quarterly sales where each row contains
the item category, item name and expenditure. Group the rows by
the category and print the total expenditure per category.
Code:
Output:
Page9of19
4) Create a data frame for examination result and display row labels,
column labels data types of each column and the dimensions.
Code:
Output:
Page10of16
5) Filter out rows based on different criteria such as duplicate
rows.
Code:
Output:
Page10of16
6) Importing and exporting data between pandas and CSVfile
Code1:
Output:
Code2:
Output
Page10of16
Visualization
1) Given the school result data,analyses the performance of the
students on different parameters, e.g subject wise or class wise
Code:
Output:
Page11of19
2) FortheDataframescreatedabove,analyze,andplotappropriatechartswith title
and legend.
Code:
Output:
Page12of19
3) Take data of your interest from an open source (e.gdata.gov.in),aggregate
and summarize it. Then plot it using different plotting functions of the
Matplotlib library.
Code:
Page13of19
DataManagement
Output:
1) Create a student table with the studentid, name, and marks as attributes
where the student id is the primary key.
Code:
Output:
2) Insert the details of a new student in the above table.
Page14of19
Code:
Output:
3) Deletethedetailsofastudentintheabovetable.
Code:
Output:
4) Use the select command to get the details of the students with marks
more than 80.
Code:
Output:
Page15of19
5) Findthemin,max,sum andaverage of themarksinastudent markstable.
Code: & Output:
6) Find the total number of customers from each country in the table (customer
ID, customer Name, country) using group by.
Code:
Output:
Page16of19
7) Write a SQL Query to order the(studentID,marks)table in descending order
of the marks.
Code:
Output:
Page17of19
