GOVT.

BOYS SENIOR
SECONDARY SCHOOL

IP PRACTICAL FILE

NAME :- AYUSH KUMAR

ROLL NO. :- 12841

CLASS :- 12TH (H)

 INDEX
S.no. TITLE SIGN

PROGRAMMING USING PANDAS

1. PRACTICAL 1 : CREATE PANDA SERIES FROM

DICTIONARY VALUES & NDARRAY
2. PRACTICAL 2 : GIVEN A SERIES, PRINT ALL THE
ELEMENTS THAT ARE ABOVE THE 75TH
PERCENTILE
3.
PRACTICAL 3 : CREATE A DATAFRAME QUARTELY 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. PRACTICAL 4 : CREATE A DATAFRAME FOR

EXAMINATION RESULT AND DISPLAY THE ROW
LABELS , COLUMN LABELS DATA TYPES OF EACH
COLUMN AND THE DIMENSIONS
5. PRACTICAL 5 : FILTER OUT ROWS BASED ON
DIFFERENT CRITERIA SUCH AS DUPLICATE ROWS
6. PRACTICAL 6 : IMPORTING AND EXPORTING DATA
BETWEEN PANDAS AND CSV FILE
S.no. TITLE SIGN

PROGRAMS USING MATPLOTLIB

1. PRACTICAL 1 : GIVEN THE SCHOOL RESULT DATA,

ANALYSES THE PERFORMANCE OF THE STUDENTS
ON DIFFERENT PARAMETERS, E.G. SUBJECT WISE
OR CLASS WISE
2. PRACTICAL 2 : FOR THE DATAFRAMES CREATED
ABOVE , ANALYZE , AND PLOT THE APPROPRIATE
CHARTS WITH THE TITLE AND LEGEND
3. PRACTICAL 3 : TAKE DATA OF YOUR INTEREST
FROM AN OPEN SOURCE AGGREGATE AND
SUMMARIZE IT. THEN PLOT IT USING DIFFERENT
PLOTTING FUNCTIONS OF THE MATPLOTLIB
LIBRARY

SQL QUERIES

1. CREATE A STUDENT TABLE WITH THE STUDENT

ID,NAME AND MARKS AS ATTRIBUTE WHERE
STUDENT ID AS PRIMARY KEY

2. INSERT THE DETAILS OF A NEW STUDENT IN

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
S.no. TITLE SIGN

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 USING GROUP BY

7. WRITE A SQL QUERY TO ORDER THE (STUDENT ID ,

MARKS) TABLE IN DESCENDING ORDER OF THE
MARKS

8. WRITE A QUERY TO FIND THE NAME OF STUDENT

WHOSE NAME STARTS WITH ‘A’ & ENDS WITH ‘H’

9. WRITE A QUERY TO CHANGE THE STUDENT NAME

WHOSE STUDENT ID IS 131

10. ADD COLUMN PRICE AND PRODUCT LIST IN THE

CUSTOMER TABLE

11. DISPLAY THE CUSTOMER TABLE SORTED BY PRICE

IN DESCENDING ORDER

12. DISPLAY THE DISTINCT CUSTOMER NAMES FROM

THE CUSTOMER TABLE
13. DISPLAY ID AND NAME OF CUSTOMER
WHOSE PRODUCT PRICE IS MORE THAN
20000
14. DISPLAY THE MAXIMUM & MINIMUM
PRICE OF ORDER

15. UPDATE PRICE OF MOBILE TO 20000

PROGRAMS USING PANDAS.
 PRACTICAL 1
CREATED A PANDA’S SERIES FROM A DICTIONARY OF
VALUES AND A NDARRAY.
PROGRAM :
OUTPUT :
 PRACTICAL 2
GIVEN A SERIES, PRINT ALL THE ELEMENTS THAT ARE
ABOVE THE 75TH PERCENTILE.
PROGRAM :
OUTPUT :
 PRACTICAL 3
CREATE A DATAFRAME QUARTELY 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.
PROGRAM :
OUTPUT :
 PRACTICAL 4
CREATE A DATAFRAME FOR EXAMINATION RESULT AND
DISPLAY THE ROW LABELS , COLUMN LABELS DATA
TYPES OF EACH COLUMN AND THE DIMENSIONS.
PROGRAM :
OUTPUT :
 PRACTICAL 5
FILTER OUT ROWS BASED ON DIFFERENT CRITERIA
SUCH AS DUPLICATE ROWS.
PROGRAM :
OUTPUT :
 PRACTICAL 6
IMPORTING AND EXPORTING DATA BETWEEN PANDAS
AND CSV FILE.
PROGRAM :
OUTPUT :
PROGRAMS USING
MATPLOTLIB
 PRACTICAL 1
GIVEN THE SCHOOL RESULT DATA, ANALYSES THE
PERFORMANCE OF THE STUDENTS ON DIFFERENT
PARAMETERS, E.G. SUBJECT WISE OR CLASS WISE.
PROGRAM :
OUTPUT :
 PRACTCAL 2
FOR THE DATAFRAMES CREATED ABOVE , ANALYZE ,
AND PLOT THE APPROPRIATE CHARTS WITH THE TITLE
AND LEGEND.
PROGRAM :
OUTPUT :
 PRACTICAL 3
TAKE DATA OF YOUR INTEREST FROM AN OPEN SOURCE
AGGREGATE AND SUMMARIZE IT. THEN PLOT IT USING
DIFFERENT PLOTTING FUNCTIONS OF THE MATPLOTLIB
LIBRARY.
PROGRAM :
OUTPUT :
SQL QUERIES
 PRACTICAL
1. CREATE A STUDENT TABLE WITH THE STUDENT
ID,NAME AND MARKS AS ATTRIBUTE WHERE STUDENT
ID AS PRIMARY KEY.
PROGRAM :

2. NOW, INSERTING THE DETAILS OF A NEW STUDENT IN

ABOVE TABLE.
PROGRAM :
OUTPUT :
3. NOW DELETE THE DETAILS OF A STUDENT IN THE
ABOVE TABLE.
PROGRAM :

OUTPUT (AFTER EXECUTING ABOVE QUERY) :

4. USE THE SELECT COMMAND TO GET THE DETAILS OF
THE STUDENTS WITH MARKS MORE THAN 80.

PROGRAM :
5. FIND THE MIN,MAX,SUM AND AVERAGE OF THE
MARKS IN A STUDENT MARKS TABLE.
PROGRAMS :
 FOR MIN :

 FOR MAX :
 FOR SUM :

 FOR AVERAGE :
6. FIND THE TOTAL NUMBER OF CUSTOMERS FROM
EACH COUNTRY IN THE TABLE USING GROUP BY.

PROGRAM :
 FIRST CREATING A TABLE(CUSTOMER
ID,CUSTOMER NAME AND COUNTRY).
NOW , EXECUTING QUERY TO FIND TOTAL NUMBER OF
CUSTOMERS FROM EACH COUNTRY .

PROGRAM :
7. WRITE A SQL QUERY TO ORDER THE (STUDENT ID ,
MARKS) TABLE IN DESCENDING ORDER OF THE MARKS.

PROGRAM :
8. NOW , WRITING A QUERY TO FIND THE NAME OF
STUDENT WHOSE NAME STARTS WITH ‘A’ & ENDS
WITH ‘H’.
PROGRAM :

9. NOW WRITING A QUERY TO CHANGE THE STUDENT

NAME WHOSE STUDENT ID IS 131.
PROGRAM :
10. ADD COLUMN PRICE AND PRODUCT LIST IN THE
CUSTOMER TABLE.
PROGRAM :

RESULT AFTER PERFORMING PREVIOUS PROGRAM :

11. DISPLAY THE CUSTOMER TABLE SORTED BY PRICE IN
DESCENDING ORDER.
CUSTOMER TABLE :

NOW , PROGRAM FOR SORTING :

12. DISPLAY THE DISTINCT CUSTOMER NAMES FROM
THE CUSTOMER TABLE.
PROGRAM :

13. DISPLAY ID AND NAME OF CUSTOMER WHOSE

PRODUCT PRICE IS MORE THAN 20000.
PROGRAM :
14. DISPLAY THE MAXIMUM & MINIMUM PRICE OF
ORDER.
PROGRAM (FOR MAXIMUM):

FOR MINIMUM :
15. UPDATE PRICE OF MOBILE TO 20000 .
PROGRAM :
16. Create a pandas series from a dictionary of values and an
ndarray.
PROGRAM:

17. Write a Pandas program to perform arithmetic

operations on two Pandas Series.
PROGRAM:
18. Write a Pandas program to add some data to an existing
Series.
PROGRAM:

19. Write a Pandas program to select the rows where the

percentage greater than 70
PROGRAM:
20. Write a Pandas program to select the rows the
percentage is between 70 and 90 (inclusive)
PROGRAM:

21. Locate the 3 largest values in a data frame.

PROGRAM:
22. Importing and exporting data between pandas and CSV
file.
# To create and open a data frame using ‘Student_result.csv’
file using Pandas.
# To display row labels, column labels data types of
each column and the dimensions
# To display the shape (number of rows and columns) of the
CSV file.
PROGRAM:
23. Replace all negative values in a data frame with a 0.
PROGRAM:

24. Given a Series, print all the elements that are above the
75th percentile.
PROGRAM: