Class 12 IP Practical File 2022-23 | Download PDF

Download pdf of Class 12 IP Practical File 2022-23 contains 35 practical programs including Pandas Programs, Matplotlib Programs, SQL Queries. This IP Practical File is prepared as per CBSE suggested syllabus.

Contents

0.1 Distribution of Marks
0.2 Data Handling Using Pandas Practicals
0.3 Database Query using SQL Practicals
- 0.3.1 SQL Queries (10 Programs)

1 Download Practical File IP Class 12 2022-23

Distribution of Marks

Download Practical File IP Class 12 2022-23

Data Handling Using Pandas Practicals

Python Series Programs (10 Practicals)

Practical 1: Create a Series object using the python sequence with 5 elements:

Solution:

Output

Practical 2: Create a Series object ‘vowel’ to store all vowels individually. Its index should be 1,2,3,4 & 5.:

Solution:

Output

Practical 3: Create s Series object using ndarray that has 5 elements in the range 50 and 100:

Solution:

Output

Practical 4: Create a Series object using dictionary to that stores the no of students in each section of class 12th of your school:

Solution

Output

Practical 5: Total no of students to be admitted is 350 in Yojna School every year. Write code to create a Series object ‘School’ that stores these total no of students for the year 2015 to 2022:

Solution

Output

Practical 6: Create a Series object ‘Item’ that stores rate of each product as given below:
Soap 54
Salt 20
Sugar 39
Write code to modify rate of soap to 44 and sugar to 42. print the changed rate:

Solution:

Output

Practical 7: No of students in class 11 and class 12 in three streams (science, commerce and humanities) are stored in 2 series object class 11 and class 12. write code to find total no of students in class 11 & class 12 stream wise:

Solution:

Output

Practical 8: Create a Series object ‘population’ to store population of 5 different metro cities and display the population that are more than 300000:

Solution:

Output

Practical 9: Create a series ‘temp’ that stores temperature of seven days in it. Its index should be ‘Sunday’, ‘Monday’ ….

Write script to

Display temp of first 3 days.
Display temp of last 3 days.
Display all temp in reverse order like Saturday, Friday,….
Display temp from Tuesday to Friday.
Display square of all temperature.:

Solution:

Output

Practical 10: Create a Series object ‘employee’ that stores salary of 7 employees. Write script to print

Total no of elements
Series is empty or not
Series consist NaN value or not
Count Non-NA elements
Axis labels:

Solution:

Output

Python DataFrame Programs (10 Practicals)

Practical1: Create the following dataframe ‘Sport’ containing sport wise marks for five students. Use 2D dictionary to create dataframe.

Solution:

Output:

Practical 2: Create a dataframe from list containing dictionaries of most economical bike with its name and rate of three companies. Company name should be the row labels.

Output:

Practical 3: Consider two series object staff and salaries that stores the number of people in various office branches and salaries distributed in these branches respectively.
Write a program to create another Series object that stores average salary per branch and then create a dataframe object from these Series object.
After creating dataframe rename all row labels with Branch name.

Solution:

Output:

Practical 4: Create the following dataframe ‘sales’ containing year wise sales figure for five sales persons in INR. Use the year as column labels, and sales person names as row labels.

Write program to do the followings

Display row labels of ‘sales’
Display column label of ‘sales’
Display last two rows of the ‘sales’
Display first two rows of the ‘sales’.

Solution:

Output:

Practical 5: Create a dataframe ‘sales2’ using dictionary as given below and write a program to append ‘sales2’ to the dataframe ‘sales’ created in previous practical 4.

Solution:

Output:

Practical 6: Create a dataframe ‘cloth’ as given below and write program to do followings:

Check ‘cloth’ is empty or not
Change ‘cloth’ such that it becomes its transpose
Display no of rows and columns of ‘cloth’
Count and display Non NA values for each column
Count and display Non NA values for each row

Solution:

Output:

Practical 7: For given dataframe ‘cloth’ given in Practical 6, Write program to do followings:

Change the name of ‘Trouser’ to ‘pant’ and Jeans to ‘Denim’
Increase price of all cloth by 10%
Rename all the indexes to [C001, C002, C003, C004, C005]
Delete the data of C3 (C003) from the ‘cloth’
Delete size from ‘cloth’

Solution:

Output:

Practical8: Create a dataframe ‘aid’ as given below and write program to do followings:

Display the books and shoes only
Display toys only
Display quantity in MP and CG for toys and books.
Display quantity of books in AP

Solution:

Output:

Practical 9: For given dataframe ‘aid’ in practical 7, write program to write the values of ‘aid’ to a comma separated file ‘aidfigures.csv’ on the disk. Do not write the row labels and column labels.

Output:

Output:

Practical 10: Read the data in the file ‘aidfigure.csv’ into a dataframe ‘aidretrieved’ and display it. Now update the row labels and column labels of ‘aidretrieved’ to be the same as that of ‘aid’ of practical 9.

Solution:

Output:

Python Matplotlib PyPlot Programs (5 Practicals)

Problem statement: Collect and store total medals won by 10 countries in Olympic games and represent it in form of bar chart with title to compare an analyze data.

Solution:

Output:

Practical 2: Techtipnow Automobiles is authorized dealer of different Bikes companies. They record the entire sale of bikes month wise as give below:

To get proper analysis of sale performance create multiple line chart on a common plot where all bike sale data are plotted. Display appropriate x and y axis labels, legend and chart title.

Solution:

Output:

Practical 3: Given the school result data, analyses the performance of the student on different parameters, e.g. subject wise or class wise. Create a dataframe for the above, plot appropriate chart with title and legend.

Solution:

Output:

Practical: The following seat bookings are the daily records of a month December from PVR cinemas:
124,124,135,156,128,189,200,150,158, 150,200,124,143,142,130,130, 170,189,200,130, 142,167,180,143,143, 135,156,150,200,189,189,142
Construct a histogram from above data with 10 bin.

Solution:

Output:

Practical 5: Take data of your interest from an open source (e.g. data.gove.in), aggregate and summarize it. Then plot it using different plotting functions of the Matplotlib library.

Output:

Database Query using SQL Practicals

SQL Queries (10 Programs)

Practical 1: Create a student table with the student id, name, and marks as attributes where the student id is the primary key.

Solution:

Practical 2: In the table ‘student’ created in practical 26, insert the details of new students.

Solution:

Practical 3: Write SQL command to get the details of the students with marks more than 80.

Solution:

Practical 4: Write SQL command to Find the min, max, sum, and average of the marks in a student marks table.

Solution:

Practical 5: Delete the details of a student table created in Practical 26.

Solution:

Practical 6: Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by.

Solution:

Practical 7: Write a SQL query to order the (student ID, marks) table in descending order of the marks.

Solution:

Practical 8: for the given table ‘Hospital’ write SQL command to display name all patient admitted in month of May.

Solution:

Practical 9: for the given table ‘Hospital’ write SQL command to Display patient name in upper case with year of admission.

Solution:

Practical 10: for the given table ‘Hospital’ Create sql query to display first four letters of the patient name along with length of their name who admitted before may.

Solution: