Q.
1 Create a pandas series from a dictionary of
values and a ndarray.
Output:-
Q.2 Given a series, print all the elements that are
above the 75th percentile.
Output:-
Q.3 Create a DataFrame 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.
Output:-
Q.4 Create a DataFrame for examination result and
display row labels, column labels data types of
each column and the dimensions.
Output:-
Q.5 Filter out rows based on different criteria such
as duplicate rows.
Output:-
Q.6 Importing and exporting data between pandas
and CSV file.
Output:-
Q.7 Number of students in classes 11 and 12 in three steams
('Science','Commerce','Arts') are stored in two series objects c11
and c12. Write code to find total number of students in classes
11 and 12, stream wise.
Output:-
Q.8 Object1 Population stores the details of population in four
metro cities of india and Object2 AvgIncome stores the total
average income reported in previous year in each of these metros.
Calculate income per capita for each of these metro cities.
Output:-
Q.9 Create and display a DataFrame from a 2D
dictionary, Sales, which stores the quarter-wise
sales as inner dictionary for two years.
Output:-
Q.10 Given a dictionary that store the section names' list as
value for 'Section' key and contribution amounts' list as value
for 'Contri' key:
Write code to create and display the data frame using the
dictionary.
Output:-
Q.11 Write a program to create a dataframe from a list
containing dictionaries of the sales performance of four
zonal offices. Zone name should be the row labels.
Output:-
Q.12 Write a program to create a dataframe from a
2D list. Specify own index labels.
Output:-
Q.13 Write a program to create a DataFrame to
store weight, age and names of 3 people. Print the
DataFrame and its transpose.
Output:-
Q.14 Write a program to calculate total points
earned by both the teams in each round.
Output:-
Q.15 Given two DataFrame storing points of a 2
player teams in four rounds, write a program to
calculate average points obtained by each player in
each round.
Output:-
Q.16 Given a series that store the area of some states in km2 . Write code
to find out the biggest and smallest three areas from the given Series.
Given series has been created like this :-
Ser1=[Link]([34567,890,450,67892,78902,256711,678291,637632,25
723, 2367,11789,345,256517])
Output:-
Q.17 Write a program to create a Series object with
6 random integers and having indexes as :
[‘a’,’b’,’c’,’e’,’f’]
Output:-
Q.1 Write a program to plot a line chart to depict
the changing tweekly onion prices for four weeks.
Give appropriate axes labels.
Output:-
Q.2 First 10 terms of a Fibonacci series are stored in a list namely
fib: fib [0, 1, 1, 2, 3, 5, 8, 13, 21, 34) Write a program to plot
Fibonacci terms and their square-roots with two separate lines on the
same [Link] Fibonacci series should be plotted as a cyan line with
'o' markers having size as 5 and edge-color as [Link] square-root
series should be plotted as a black line with '+' markers having size
as 7 and edge-color as red.
Output:-
Q.3 Write a program to plot a scatter graph taking two
random distributions in XI and YI (both with shape as (250,)
having randomly generated integers) and plotted against
each other with varying
sizes.
Output:-
Q.4 For the DataFrames created above, analyze and plot
appropriate charts with title and legend.
Output:-
Q.5 Considering the TSS school's charity collection (as given in
previous xample). Write a program to create a pie chart showing
collection amount percentage (%) section wise. Also make sure
that the pie chart is perfectly circular.
Output:-
Q.6 Prof Awasthi is doing some research in the field of
Environment. For some plotting purposes, he has
generated some data as: mu = 100, sigma = 15,
x=mu sigma [Link](10000)
Output:-
Q.1 Create a student table with the student id,
name, and marks as attributes where the student id
is the primary key.
Q.2 Insert the details of students in the above
table.
Q.3 Delete the details of a student in the above
table.
Q.4 Use the select command to get the details of
the students with marks more than 90.
Q.5 Write the SQL command to add a new column
named 'Address' with a data type of varchar(255)
to the existing 'students' table, and then display
the updated table structure.
Q.6 Update the address of the students with
StudentsID.
Q.7 Insert the details of a new student in the table.
Q.8 Update the column name from ‘Marks’ to
‘Score’.
Q.9 Convert and display Names into upper case.
Q.10 Convert and display Names into lower case.
Q.11 Display the length of the names in the table.
Q.12 Display the results as ‘‘Name’ scored as
‘Marks’’.
Q.13 Display the details of the students where
address is specific.
Q.14 Display the name of the students where name
starts with “V”.
Q.15 Order by the marks of students table.
Q.16 Group by the marks of students table.
Q.17 Find the min, max, sum, and average of the
marks in a student marks table.