[go: up one dir, main page]
Scribd
Upload
8 views36 pages

Practical File Ishanvi

The document is a project file for Informatics Practices submitted by Ishanvi of XII-B at Bal Bharati Public School for the AISSCE 2024-2025. It includes a certificate of completion, acknowledgments, and an index of various data manipulation tasks using pandas and SQL. The tasks cover creating data frames, filtering data, and performing statistical analysis.

Uploaded by

ishanvikaushal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views36 pages

Practical File Ishanvi

The document is a project file for Informatics Practices submitted by Ishanvi of XII-B at Bal Bharati Public School for the AISSCE 2024-2025. It includes a certificate of completion, acknowledgments, and an index of various data manipulation tasks using pandas and SQL. The tasks cover creating data frames, filtering data, and performing statistical analysis.

Uploaded by

ishanvikaushal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 36

BAL BHARATI PUBLIC

SCHOOL PHASE-III
DUGRI,LUDHIANA

Informatics Practices
project file (065)
AISSCE 2024-2025

Submitted To: Submitted By:


Mr. Ravi Anand Ishanvi XII-B
CERTIFICATE
This is to certify that Ishanvi
of XII- B has completed her
project entitled___ under my
supervision. She has taken a
proper care and sincerity in
completion of her project. I
certify that the project is
upto my expectations and as
per guidelines given by CBSE

Teacher Signature
___________________
ACKNOWLEDGEMENT

The making of this project has been


possible due to the guidance, efforts and
support given by various people. I wish to
acknowledge my special thanks to God, for
nothing happens without his will and then
my gratitude and deep appreciation to my
honourable Principal Mr. Ashish Sawhney
and my IP teacher Mr. Ravi Anand who
gave me the golden opportunity to work
on this project on the topic ___ which
helped me in doing alot of research and I
get to knowabout many things. I would like
to express my heartiest gratitude to my
family members and all those people who
selflessly devoted time for any help that
was required.
INDEX
INDEX
1. Create a pandas series from a
dictionary of values and an ndarray
2. Given a Series, print all the elements
that are above the 75th percentile
3. Create a Data Frame quarterly sales where
each row contains the item
category, item name, and expenditure. Group
the rows by the category
4. Create a data frame based on ecommerce data
and generate descriptive statistics (mean, median,
mode, quartile, and variance).
5. Create a data frame for examination result
and display row labels, column labels data
types of each column and the dimensions
6. Filter out rows based on
different criteria such as
duplicate rows
7. Find the sum of each column, or
find the column with the lowest
mean
8. Locate the 3 largest values in a
data frame
9. Subtract the mean of a row from each
element of the row in a Data Frame
10. Replace all negative values in a data
frame with a 0
11. Replace all missing values in
a data frame with a 999
12. Importing and exporting
data between pandas and
CSV file
13. Importing and exporting
data between pandas and
MySQL database
14. Create a python program to
store 2018 drivers world
champion and print the
maximum Points and age.
15. Write a program to show
the example of Reindexing in
Pandas DataFrame
17. Create a dataframe with
columns (Name, Age, Stream,
Percentage) and
print the rows on the basis of
percentage above 80.
18. Write a program to show
deleting a column in
dataframe with two different
methods
19. Write a program to create
dataframe with columns Name,
English, Math, science
20. Write any example code to
show the use of Limiting row
selection with given column
21. Display the Batsman name
along with runs scored in ODI using
loc
22.Given the school result data,
analyse the performance of the
students on different parameters,
e.g subject wise or class wise
23. For the Data frames
created above, analyze and
plot appropriate charts with
title and legend
29. Create a student table
with the student id, name,
and marks as attributes
where the student id is the
primary key
30. Insert the details of a
new student in the above
table.
31. Delete the details of a
particular student in the above
table
32. Use the select command to
get the details of the students
with marks more than 80
35. Find the min, max, sum,
and average of the marks in a
student marks table
36. Find the total number of
customers from each country
in the table (customer ID,
customer Name, country)
using group by
37. Create a new table (name, date
of birth) by joining two tables
(student id, name) and (student id,
date of birth)
38. Write a SQL query to
order the (student ID, marks)
table in descending order of
the marks

You might also like