DECLARATION

I Krishna soni, bearing roll no 3, a student of class XII A the lucky international
school hereby declare that I own the full responsibility for the information,
result etc. provided in this practical file. It has been created successfully by
using pandas and database tool MySQL and SQL commands at lucky
international school in complete fulfilment of practical curriculum of central
board of secondary education CBSE of informatics practices(065) conducted by
CBSE, New Delhi for the academic session 2023-24.

Krishna soni
Roll no: 03
Class 12
Lucky international school
Problem 1: Create a Series object using the Python
sequence with 5 elements

Solution.
Problem 2: Create a Series object 'vowel' to store all
vowels individually. It's index should be 1,2,3 4 &5.

Solution.
Problem 3: Create a Series object using ndarray that
has 5 elements in the range 50 and 100.

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

Solution.
Problem 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.
Problem 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.
Problem 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.
Problem 8: Create a Series object ‘population’ to store
population of 5 different metro cities and display the
population that are more than 300000

Solution.
Problem 9: Create a series ‘temp’ that stores
temperature of seven days in it. Its index should be
‘Sunday’, ‘Monday’ …. Write script to
1. Display temp of first 3 days.
2. Display temp of last 3 days.
3. Display all temp in reverse order like Saturday, Friday,….
4. Display temp from Tuesday to Friday.
5. Display square of all temperature.:

Solution.
Problem 10: Create a Series object ‘employee’ that stores salary
of 7 employees. Write script to print
1. Total no of elements
2. Series is empty or not
3. Series consist NaN value or not
4. Count Non-NA elements
5. Axis labels:

Solution.
Problem 11: Create the following dataframe ‘Sport’ containing
sport wise marks for five students. Use 2D dictionary to create
dataframe.
Student Sport Marks
I Jai Cricket 80
II Raj Football 76
III John Tennis 89
IV Karan Kabaddi 92
V Chandu Hockey 97

Solution.
Problem 12: 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.

Solution.
Problem 13: 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.
Problem 14: 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.
2014 2015 2016 2017
Madhu 1000 2000 2400 2800
Kusum 1500 1800 5000 6000
Kinshuk 2000 2200 7000 7000
Ankit 3000 3000 1000 8000
Shruti 4000 4500 1250 9000

Write program to do the followings

1. Display row labels of ‘sales’
2. Display column label of ‘sales’
3. Display last two rows of the ‘sales’
4. Display first two rows of the ‘sales’.

Solution.
Problem 15: Create a dataframe ‘sales2’ using dictionary as
given below and write a program to append ‘sales2’ to the
dataframe ‘sales’ created in previous practical 14.
2018
Madhu 1600
Kusum 1100
Kinshuk 5000
Ankit 3400
Shruti 9000

Solution.
Problem 16: 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.
Problem 17: 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.
Problem 18: 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.
Problem 19: 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.
 MySQL
Practicals
Problem 20: Create a student table with the student id, name,
and marks as attributes where the student id is the primary key.

Solution.
Problem 21: In the table ‘student’ created in practical 26, insert
the details of new students

Solution.
Problem 22: Write SQL command to get the details of the
students with marks more than 80.

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

Solution.
Problem 24: Delete the details of a student table created in
Practical 26.

Solution.

Problem 25: Find the total number of customers from each

country in the table (customer ID, customer Name, country) using
group by.

Solution.
Problem 26: Write a SQL query to order the (student ID, marks)
table in descending order of the marks.

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

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

Solution.
Problem 29: 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.
 Bibliography

References and Bibliography:

 Informatics Practices Class-XII NCERT Publication
 Informatics Practices Class-XII by Sumita Arora
 Think Python by Allen B Downey
 Python for everybody by Charles Severance
 Learning MYSQL by Seyed M. M. Tahaghoghi
 MySQL in a nutshell by Russell J. T. Dyer
 www.geeksforgeeks.org
 www.ncert.co.in