Scribd
Upload
47 views2 pages

12 IP Practical File Questions

The document outlines practical file questions for 12th-grade Informatics Practices for the academic year 2025-26. It includes tasks related to creating and manipulating pandas series and data frames, data visualization using charts, and SQL operations on student and customer data. The questions cover a range of topics from data analysis to database management.

Uploaded by

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

12 IP Practical File Questions

The document outlines practical file questions for 12th-grade Informatics Practices for the academic year 2025-26. It includes tasks related to creating and manipulating pandas series and data frames, data visualization using charts, and SQL operations on student and customer data. The questions cover a range of topics from data analysis to database management.

Uploaded by

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

Practical File Questions

12th Informatics Practices


2025-26

1. Create a panda’s series from a dictionary of values and a Nd array


2. Create a series using list.
3. Creating a series: Empty, Scaler and Numpy array
4. Create Data Frame quarterly 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.
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. Importing and exporting data between pandas and CSV file.
8. Write a program to iterate over a DataFrame containing names and marks, then
calculate grades as per marks and add them to the grade column.
9. Given the school result data and analysis the performance of the student on
different parameter such as subjectwise or classwise.
10. Create DataFrame for analysis and plot chart with title and legends.
11. Write a Python program to plot a simple line chart showing the growth of a plant
over 5 days.
12. Create a bar chart showing the marks obtained by a student in 5 subjects.
13. Plot a horizontal bar chart showing the number of students in different streams.
14. Draw a pie chart showing the percentage of time spent by a student on various
activities in a day.
15. Write a Python script to display bar chart for population of five cities using
custom colors.
16. Display a pie chart showing favourite fruits of students with explode and shadow
effects.
17. Program to concatenating two 2D array using single array.
18. WAP to Sort the data in dataframe.
19. To write in csv file ‘stud.csv’ and also display the content of the file.
20. Binary operations on dataframes.
21. Create a student table with the student id, name, and marks as attributes where the
student id is the primary key.
22. Insert the details of a new student in the above table.
23. Delete the details of a student in the above table.
24. Use the select command to get the details of the students with marks more than 80.
25. Find the min, max, sum, and average of the marks in a student marks table.
26. Find the total number of customers from each country in the table (customer ID,
customer Name, country) using group by.
27.Write a SQL query to order the (student ID, marks) table in descending order of
the marks.
28.Write SQL query to display all the records of the student table.
29. String functions
30. Date and Time functions.

You might also like