Class 12th CBSE IP
LIST OF PRACTICAL QUESTION
Create a pandas series from a dictionary of values and an ndarray.
Given a Series, print all the elements that are above the 75th percentile.
Write a python program to create a DataFrame for students storing their roll no, name, address, phone and display the DataFrame on the screen.
Write a python program to create a 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.
Write a python program to create a DataFrame for examination result and display row labels, column labels data types of each column and the dimensions.
Write a python program to create a Series Object
Write a python program to show the use of header and tail methods of Series
Write a python program to show the use of where condition using Series
Write a python program to create a DataFrame with custom column name/index.
Given a series s1 with some values in it. Write a program to sort the values in descending order and store in s2 object, sort in ascending order and store in s3 object, store the squares of the series in s3 object, store the squares of the series values in s4 object, display s4 object values which are >7.
Write a python program that stores the sales of 5 items of a store for each month in 12 series object that is s1 series object stores sales of these 5 items in 1st month, s2 stores of these items in 2nd month and so on.
Write a program to read details such as item sales made in a Data Frame and then store this data in a csv file.
Bajaj Auto has given his sales figures of his North and East Region for the 1st quarter of the financial year 2020. Present the same in the form of bar graph.
Considering the DataFrame created in Program 13 and present the sales of the east region in the horizontal bar graph.
Write a program to convert csv into a data frame and then display it.
Write a program to Importing and Exporting data between pandas and CSV file.
Given the school result data, analyse the performance of the students on different parameters, e.g subject wise or class wise.
Write a SQL query to create a table Student.
Create a Database Student and Stream with following queries.
Write a SQL Query to create a Bank Account.
Write a SQL command to Create a Table Hospital.
Write SQL commands for the following table Teacher.
Fun & Easy to follow
Works on all devices
Your own Pace
Super Affordable
Popular Videos
UX for Teams
Learn the basics and a bit beyond to improve your backend dev skills.
Chris Matthews
Designer
SEO & Instagram
Learn the basics and a bit beyond to improve your backend dev skills.
Chris Matthews
Designer