Data Structure — Computer Science STD 12 Science — Question

Given a list of numbers (integers), write a function to return the second maximum and second minimum in this list.

Write a program which will find all such numbers which are divisible by 7 but are not multiples of 5, between 2000 and 2500 (both included). The numbers obtained should be printed in a comma-separated sequence on a single line.

WAP to generate 2n+1 lines of the following pattern on the computer screen:

Write a python program using function to accept a list as parameter and multiply all the odd elements by 5. [This program will also demonstrate by reference concept]

Write a program using function to accept the list from the user and sort the number using bubble sort.

Write SQL commands for the following queries on the basis of Club relation given below:

Relation: Club

Coach-ID	CoachName	Age	Sports	date_of_app	Pay	Sex
1	Kukreja	35	Karate	27/03/1996	1000	M
2	Ravina	34	Karate	20/01/1998	1200	F
3	Karan	34	Squash	19/02/1998	2000	M
4	Tarun	33	Basketball	01/01/1998	1500	M
5	Zubin	36	Swimming	12/01/1998	750	M
6	Ketaki	36	Swimming	24/02/1998	800	F
7	Ankita	39	Squash	20/02/1998	2200	F
8	Zareen	37	Karate	22/02/1998	1100	F
9	Kush	41	Swimming	13/01/1998	900	M
10	Shailya	37	Basketball	19/02/1998	1700	M

(a) To show all information about the swimming coaches in the club.

(b) To list the names of all coaches with their date of appointment (date_of_app) in descending order.

(c) To display a report showing coach name, pay, age, and bonus (15% of pay) for all coaches.

(d) To insert a new row in the Club table with ANY relevant data:

(e) Give the output of the following SQL statements:

(i) Select COUNT(Distinct Sports) from Club;

(ii) Select Min(Age) from Club where SEX = “F ”;

Write a function readall() the record from the binary file “student” and display all the records

Answer the following question based on the given dataset download from data.gov.in:

data name : Percentage of Schools with Computers from 2013-14 to 2015-16

Screen shot of the data:

Assuming that we have saved the file with name: "computer_data" in python default folder.

Assuming that all the required libraries are imported once:

(i) To create the data frame of the above file.

(ii) To display all the column names of the data frame.

(iii) To plot the line graph for the first 5 record of the Primary Only column on y-axis and 'State_UT' on x-axis.

The line colour should be red and marker as 'x'. The graph will display only 2013-14

(iv) To display the histogram of the 2013-14, primary_only column.

(v) To display bar graph of the last 7 record of the year 2013-14 use the title and required label. Also write the statement to create the data frame.

(vi) To display the pie chart of the first 10 records of the 2013-14. Also create the data frame.

(vii) To display the boxplot for the Sec with higher secondary and All India data.

(viii) To display the scatter diagram of the 2014-15

Describe Data Operations in Pandas.