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
Distribution of Marks
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/marks-distribution-ip-practical-class-12-1.png?resize=599%2C349&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/series-practical-2022-23-1.png?resize=697%2C169&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-1-2022-23-output-1.png?resize=375%2C215&ssl=1)
Practical 2: Create a Series object ‘vowel’ to store all vowels individually. Its index should be 1,2,3,4 & 5.:
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-2-2022-23.png?resize=664%2C137&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-2-2022-23-output.png?resize=260%2C168&ssl=1)
Practical 3: Create s Series object using ndarray that has 5 elements in the range 50 and 100:
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-3-2022-23.png?resize=582%2C169&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-3-2022-23-output.png?resize=286%2C153&ssl=1)
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
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-4-2022-23.png?resize=572%2C153&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-4-2022-23-output.png?resize=279%2C165&ssl=1)
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
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-5-2022-23.png?resize=572%2C144&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-5-2022-23-output.png?resize=268%2C213&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-6-2022-23.png?resize=553%2C172&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-6-2022-23-output.png?resize=252%2C203&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-7-2022-23.png?resize=514%2C229&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-7-2022-23-output.png?resize=194%2C229&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-8-2022-23.png?resize=698%2C177&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-8-2022-23-output.png?resize=306%2C262&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-9-2022-23.png?resize=636%2C168&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-9-2022-23-output.png?resize=226%2C548&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-10-2022-23.png?resize=600%2C283&ssl=1)
Output
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/python-series-practical-10-2022-23-output.png?resize=698%2C295&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-1-2022-23.png?resize=660%2C144&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-1-2022-23-output.png?resize=476%2C155&ssl=1)
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.
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-2-2022-23.png?resize=641%2C170&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-2-2022-23-output.png?resize=320%2C119&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-3-2022-23.png?resize=603%2C259&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-3-2022-23-output.png?resize=594%2C267&ssl=1)
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.
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sales-dataframe-1.png?resize=258%2C176&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-4-2022-23-1.png?resize=601%2C303&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-4-2022-23-output-1.png?resize=603%2C433&ssl=1)
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.
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sales2-dataframe-1.png?resize=137%2C203&ssl=1)
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-5-2022-23.png?resize=697%2C267&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-5-2022-23-output.png?resize=697%2C445&ssl=1)
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
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/cloth-dataframe-1.png?resize=217%2C193&ssl=1)
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-6-2022-23.png?resize=556%2C445&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-6-2022-23-output.png?resize=425%2C505&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-7-2022-23.png?resize=641%2C511&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-7-2022-23-output.png?resize=507%2C660&ssl=1)
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
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/aid-dataframe.png?resize=197%2C143&ssl=1)
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-8-2022-23.png?resize=696%2C356&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-8-2022-23-output-1.png?resize=526%2C462&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-9-2022-23.png?resize=696%2C232&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-9-2022-23-output.png?resize=448%2C574&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-10-2022-23.png?resize=654%2C124&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/dataframe-practical-10-2022-23-output.png?resize=386%2C144&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-1-2022-23.png?resize=517%2C184&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-1-2022-23-output.png?resize=306%2C266&ssl=1)
Practical 2: Techtipnow Automobiles is authorized dealer of different Bikes companies. They record the entire sale of bikes month wise as give below:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sale-bike-dataframe.png?resize=536%2C114&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-2-2022-23.png?resize=615%2C369&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-2-2022-23-output.png?resize=444%2C380&ssl=1)
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.
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/marks-dataframe.png?resize=468%2C135&ssl=1)
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-3-2022-23.png?resize=540%2C302&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-3-2022-23-output.png?resize=350%2C490&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-4-2022-23.png?resize=596%2C280&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-4-2022-23-output.png?resize=432%2C370&ssl=1)
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.
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-5-2022-23.png?resize=424%2C200&ssl=1)
Output:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/matplotlib-practical-5-2022-23-output.png?resize=266%2C228&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-1-2022-23.png?resize=408%2C165&ssl=1)
Practical 2: In the table ‘student’ created in practical 26, insert the details of new students.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-2-2022-23.png?resize=517%2C269&ssl=1)
Practical 3: Write SQL command to get the details of the students with marks more than 80.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-3-2022-23.png?resize=516%2C174&ssl=1)
Practical 4: Write SQL command to Find the min, max, sum, and average of the marks in a student marks table.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-4-2022-23.png?resize=674%2C152&ssl=1)
Practical 5: Delete the details of a student table created in Practical 26.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-5-2022-23.png?resize=494%2C76&ssl=1)
Practical 6: Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-6-2022-23.png?resize=634%2C188&ssl=1)
Practical 7: Write a SQL query to order the (student ID, marks) table in descending order of the marks.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-7-2022-23.png?resize=346%2C188&ssl=1)
Practical 8: for the given table ‘Hospital’ write SQL command to display name all patient admitted in month of May.
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/hospital-table.png?resize=719%2C122&ssl=1)
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-8-2022-23.png?resize=538%2C138&ssl=1)
Practical 9: for the given table ‘Hospital’ write SQL command to Display patient name in upper case with year of admission.
Solution:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-9-2022-23.png?resize=623%2C189&ssl=1)
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:
![](https://i0.wp.com/techtipnow.in/wp-content/uploads/2022/11/sql-practical-10-2022-23.png?resize=622%2C140&ssl=1)
Download Practical File IP Class 12 2022-23
Data Handling and Visualization Notes : https://techtipnow.in/data-handling-pandas-data-visualization-notes/
Database Query Using SQL Notes : https://techtipnow.in/class-12-ip-database-query-using-sql-notes/
Introduction to Computer Network : https://techtipnow.in/introduction-to-computer-network-notes/
Societal Impact Notes : https://techtipnow.in/societal-impact-notes-societal-impact-ip-class-12/
Previous Year Question Paper IP Class 12: https://techtipnow.in/previous-year-question-paper-ip-class-12/
CBSE Sample Papers : https://techtipnow.in/ip-sample-paper/
Practice Sample Paper IP : https://techtipnow.in/ip-sample-paper-class-12-with-solutions/
NCERT Text Book Solution IP Class 12: https://techtipnow.in/ncert-solution-ip-class-12/
Sumita Arora Textbook Solution : https://techtipnow.in/sumita-arora-textbook-solution-information-practices-xii/
Python Pandas Series MCQ : https://techtipnow.in/python-pandas-series-mcq/
Python DataFrame MCQ : https://techtipnow.in/python-pandas-dataframe-mcq/
Plotting with PyPlot MCQ : https://techtipnow.in/python-data-visualization-mcq/
Societal Impact MCQ : https://techtipnow.in/python-data-visualization-mcq/
SQL MCQs : https://techtipnow.in/sql-mcq-class-12/
MySQL Functions MCQ : https://techtipnow.in/mysql-functions-mcq/
IP Class 11 Notes : https://techtipnow.in/ip-class-11-notes/
IP Class 11 MCQs : https://techtipnow.in/ip-class-11-mcq/NCERT Solution Class 11: https://techtipnow.in/ncert-textbook-solution-ip-class-11/
Please sir send me this pdf IP practical is coming. Please sir it will be a great help🙏🙏
send request via email..