Data Structure — Computer Science STD 12 Science — Question

Based on the given dataset answer the questions given below:

	From_To	FlightNumber	RecentDelays	Airline
0	NewDelhi_Chennai	10045.0	[23, 47]	Spicejet
1	Mumbai_NewDelhi	NaN	[]	Indigo
2	Jaipur_Jammu	10065.0	[24, 43, 87]	Spicejet
3	Chennai_Lucknow	NaN	[13]	Indian Airlines
4	Mumnbai_Chennai	10085.0	[67, 32]	Spicejet

(i) #To display the maximum flight number

(ii) #To print the number of flights airline wise

(iii) #to drop the nan values from the dataframe

(iv) To fill nan with blank values

(v) To print the maximum values of recent delays

(vi) To print the median of all the numeric values.

(vii) To print the sum of the recentdelays

(viii) To count the flight numbers.

(ix) To print the airline wise the sum of the recentdelays along with From_to as column

(x) To print the airline wise the sum of the recentdelays along with From_to as column. Also fill NaN values as blank.

What are the adverse effects of technology?

How can one protect from cyber fraud?

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

Write algorithm for insert operation in Queue.

Write a python program to create the list numeric values and sort the list using Bubble sort technique.

Write a menu driven program in python to implement the various method related to insertion and deletion in the list.

Answer the questions related to pandas Series which will perform:

(i) To import the pandas

(ii) To create the series from the list

(iii) To print List.

(iv) To print the index of the series.

(v) To print the values of the series.

WAPssuming the given dataset answer the questions below:

https://data.gov.in/catalog/statistical-hand-book-2009-education?filters%5Bfield_catalog_reference%5D=6690578& format=json&offset=6&limit=6&sort%5Bcreated%5D=desc

Schools for Professional Education 2007-08 : SHB 2009

(i) Write a python / statement to read the data frame.

(ii) Write a python code to plot the pie chart of all the institutions which have more than hundred teachers. Also display the values of portion.

(iii) Write a python code to plot the horizontal bar chart to plot the Type of institution and Total students.

(iv) Write a python code to plot the scatter diagram boys vs girls students.

(v) Write a python code to plot the histogram for no. of institution.

Write python program using function to find the sum of first n terms of the following series:

where n and x have to be input from the user. The function should have two parameter n and x and return the sum of the series.