INFORMATICS PRACTICES(065)
Programs for Practical file(DATA HANDLING AND SQL)
CLASS-XII
1) Create a pandas series from a dictionary of values and an ndarray.
2) Write a program to create a series from dictionary that stores classes (6,7,8,9,10) as
keys and number of students as values
3) Consider a series object “study, created using the following statements:
Study=[Link]([11,23,31,61,87,93],index=[‘a’,’b’,’c’,’c’,’d’,’f’])
Based on the series object, write statements to do the following:
a) Retrieve the third element and print it.
b) Retrieve and print the first three elements.
c) Retrieve and print the last two elements.
d) Retrieve and print all elements where value is even.
4) Write a Pandas program to perform arithmetic operations on two Pandas Series.
5) Write a Pandas program to add some data to an existing Series.
6) Write a Pandas program to select the rows where the percentage greater than 70.
7) Write a Pandas program to select the rows the percentage is between 70 and 90
(inclusive)
8) Write a Pandas program to change the percentage in a given row by the user.
9) Write a Pandas program to join the two given dataframes along rows and assign all
data.
10) Write a Pandas program to join the two given dataframes along with columns and
assign all data.
11) Write a Pandas program to append a list of dictionaries or series to an existing
DataFrame and display the combined data.
12) Program to select or filter rows from a DataFrame based on values in columns in
pandas ( Use of Relational and Logical Operators)
13) Mr. Pankaj wants to plot a bar graph for a given set of values of subject on X-axis and
number of students who opted for that subject on Y-axis
a) To plot the bar graph in statement 1
b) To display the graph in statement 2
14) Write a program to plot a bar chart to depict the changing weekly the onion prices for
four weeks. Give appropriate axes labels:
a) Week[1,2,3,4]
b) Prices=[40,50,100,70]
15) The sugar levels for men and women in a city. Compare the sugar levels amongst
them through a histogram:
a) Men=[113,85,90,150,149,88,93,115,135,80,77,82,129]
b) Women=[67,98,89,120,133,150,84,69,89,79,120,112,100]
16) Plot a bar chart to depict the popularity of various programming languages.
17) Write a python program to draw a line with a suitable label in the X-axis and Y-axis
and a title.
18) Create a student table with the student id, name, and marks as attributes where the
student id is the primary key.
19) Insert the details of a new student in the above table.
20) Delete the details of a student in the above table.
21) Use the select command to get the details of the students with marks more than 80.
22) Find the min, max, sum, and average of the marks in a student marks table.
23) Find the total number of customers from each country in the table (customer ID,
customer, Name, country) using group by.
24) Write a SQL query to order the (student ID, marks) table in descending order of the
marks
25) Write a SQL query to display the marks without decimal places, display the reminder
after diving marks by 3 and display the square of marks
26) Write a SQL query to display names into capital letters, small letters, display first 3
letters of name, display last 3 letters of name, display the position the letter A in name
27) Remove extra spaces from left, right and both sides from the text – ” Informatics
Practices Class XII “.
28) Display today’s date in “Date/Month/Year” format.
29) Display dayname, monthname, day, dayname, day of month, day of year for today’s
date.