WAPssuming the given dataset answer the questions below: https://…

Question

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.

✓

Answer

Get the step-by-step solution for this question inside the Vidyadip app.

Get the answer in the app

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "4 Marks Each" from Data Visualisation→Data Visualisation — all question types→Computer Science STD 12 Science question papers→CBSE Board STD 12 Science question papers→CBSE Board question paper generator→

Similar questions

Write a python program using function to accept the list as parameter and print the odd element of the list.

→

Consider the following tables WORKER and PAYLEVEL and answer (a) and (b) parts of this question:

Relation: WORKER

ECODE	NAME	DESIG	PAYLEVEL	DOJ	DOB
11	Radhey Shyam	Supervisor	P001	13-Sep-2004	23-Aug-1981
12	Chander Nath	Operator	P003	22-Feb-2010	12-Jul-1987
13	Fizza	Operator	P003	14-June-2009	14-Oct-1983
15	Ameen Ahmed	Mechanic	P002	21-Aug-2006	13-Mar-1984
18	Sanya	Clerk	P002	19-Dec-2005	09-June-1983

Relation: PAYLEVEL

PAYLEVEL	PAY	ALLOWANCE
P001	26000	12000
P002	22000	10000
P003	12000	6000

(a) Write SQL commands for the following statements:

(i) To display the details of all WORKERs in descending order of DOB.

(ii) To display NAME and DESIG of those WORKERs whose PLEVEL is either P001 or P002.

(iii) To display the content of all the WORKERs table, whose DOB is in between ’19-JAN- 1984 ’and ’18-JAN-1987 ’.

(iv) To add a new row with the following: 19, ‘Daya kishore ’, ‘Operator ’, ‘P003 ’, ’19-Jun-2008 ’, ’11-Jul-1984 ’

(b) Give the output of the following SQL queries:

(i) Select count(plevel), plevel from worker group by plevel;

(ii) Select max(dob), min(doj) from worker;

(iii) Select name, pay from worker w, paylevel p where w.plevel=p.plevel and w.ecode <13;

(iv) Select plevel, pay+allowance from paylevel where plevel=’p003 ’;

→

Write algorithm for insert operation in Queue.

→

Expertia Professional Global (EPG) is an online corporate training provider company for IT related courses. The company is setting up their new campus in Mumbai. You as a network expert have to study the physical locations of various buildings and the number of computers to be installed. In the planning phase, provide the best possible answers for the queries (a) to (d) raised by them.

Building to Building distances (in Mtrs.)

FROM	To	Distance
Administrative Building	Finance Building	60
Administrative Building	Faculty Studio building	120
Finance Building	Faculty Studio building	70

Number of computers in each of the blocks/Center is as follows:

Administrative Building	20
Finance Building	40
Faculty Studio building	120

(a) Suggest the most appropriate building, where EPG should plan to install the server.

(b) Suggest the most appropriate building to building cable layout to connect all three buildings for efficient communication.

LAN, MAN, WAN

(d) Which wireless channel out of the following should be opted by EPG to connect to students of all over the world?

Infrared, Microwave, Satellite

→

Write a menu driven python program using function InQ(), DelQ() and DisplayQ() to implement the Queue. The program will store details of the flights
i.e Flight Number, Flight Name and Fare.

→

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.

→

Aarti is new in python data-handling. Please help her to count the number of lines which begins with ‘W’ or ‘w’ in poem.txt.

(a) # Line 1 : To open file POEM.txt in read mode

(b) # Line 2 : To check first character of every line is ‘W’ or ‘w’.

(d) # Line 4 : To call the function count_poem.

→

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

→

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.

→