Introduction
Name Karanveer Singh
Class 12th Commerce
Roll No
Project Python
Submitted by Karanveer Singh
Submitted To Mrs.Rekha
Session 2025-2026
ACKNOWLEDGEMENT
Firstly, I would like to acknowledge my
school “Seth Hukam Chand S.D. Public Sr.
Sec. School”. I have taken the data from
many books as well as from websites during
ups and downs which I have been facing
at that time.
Then the principal “Priyanka Mam” who
have given me this opportunity and my
teacher “Mrs. Rekha” who had always with
me to do this file. I have not made this
project for only marks but also for
knowledge regarding Python.
CERTIFICATE
This is to certify that the original and
genuine investigation has been carried out
of investigate about the subject matter and
the related data collection and
investigation has been completed sincerely
and satisfactorily by Karanveer Singh of
class XII, Seth Hukam Chand S.D. Public Sr.
Sec. School. Regarding the project titled
‘Python Project’.
Introduction To Python
What is Python?
Python is a popular programming language. It
was created by Guido van Rossum and released
in 1991. It is used for:
• web development (server-side),
• software development, • mathematics,
• system scripting.
What can Python do?
• Python can be used on a server to create web
applications.
• Python can be used alongside software to
create workflows.
• Python can connect to database systems. It
can also read and modify files.
• Python can be used to handle big data and
perform complex mathematics.
• Python can be used for rapid prototyping, or
for production-ready software development.
Why Python?
• Python works on different platforms
(Windows, Mac, Linux, Raspberry Pi, etc).
• Python has a simple syntax like the English
language.
• Python has syntax that allows developers to
write programs with fewer lines than some
other programming languages.
• Python runs on an interpreter system,
meaning that code can be executed as soon as
it is written. This means that prototyping can
be very quick.
• Python can be treated in a procedural way,
an object orientated way or a functional way
Python Programs
BIBLIOGRAPHY
BOOKS
▪ Informatics Practices text book by
Sumita Arora.
▪ Informatics Practices text book b CBSE.
INTERNET SOURCES
▪ www.wikipedia.org
▪ www.google.com
▪ www.geeksforgeeks.org
▪ www.python.org
INDEX
S no. Content. Page No.
1. Introduction to Python
What is python? 1
What can python do? 1
Why Python? 2
2. Python Programs
i)Create a pandas series from a dictionary of 3
values and an ndarray.
ii)Given a Series, print all the elements that are 4
above the 75th percentile.
iii)Create a Data Frame quarterly sales where 5
each row contains the item category, item name,
and expenditure. Group the rows by the category,
iv)Create a data frame based on ecommerce 6
data and generate descriptive statistics (mean,
median, mode, quartile, and variance).
v)Create a data frame for examination result 7
and display row labels, column labels data
types of each column and the dimensions
vi)Filter out rows based on different criteria 8
such as duplicate rows.
vii)Find the sum of each column, or find 9
the column with the lowest mean..
viii)Locate the 3 largest values in a data frame. 10
ix)Subtract the mean of a row from each 11
element of the row in a Data Frame.
x)Replace all negative values in a data frame 12
with a 0.
xi)Replace all missing values in a data frame 13
with a 999.
xii)Importing and exporting data between 14
pandas and CSV file
xiii)Importing and exporting data between 15
pandas and MySQL database.
xiv)Given the school result data, analyse the 17
performance of the students on different
parameters, e.g subject wise or class wise.
xv)For the Data frames created above, 18
analyze and plot appropriate charts with title and
legend.
xvi)Take data of your interest from an 19
open source (e.g. data.gov.in), aggregate and
summarize it. Then plot it using different plotting
functions of the Matplotlib
