Idea of Efficiency and Recursion — Computer Science STD 12 Science — Question

How to Delete Indices, Rows or Columns From a Pandas Data Frame?

Write a function to read the content from the file “India.txt”, and store the frequency of each word in dictionary and display the dictionary in the screen. Content of the file is: ‘‘India is the fastest growing economy. India is looking for more investments around the globe. The whole world is looking at India as a great market. Most of the Indians can foresee the heights that India is capable of reaching.’’ Output of the file: {‘India’: 4, ‘is’: 4, ‘the’: 4, ‘fastest’: 1, ‘growing’: 1, ‘economy.’: 1, ‘looking’: 2, ‘for’: 1, ‘more’: 1, ‘investments’: 1, ‘around’: 1, ‘globe.’: 1, ‘The’: 1, ‘whole’: 1, ‘world’: 1, ‘at’: 1, ‘as’: 1, ‘a’: 1, ‘great’: 1, ‘market.’: 1, ‘Most’: 1, ‘of’: 2, ‘Indians’: 1, ‘can’: 1, ‘foresee’: 1, ‘heights’: 1, ‘that’: 1, ‘capable’: 1, ‘reaching.’: 1}

Write a program to accept a number from the user and to check whether the entered number is prime number or not. The program should be implemented in two ways to show the efficiency of the code.

Consider the following table HOSPITAL.

Table: HOSPITAL

PNo	Name	Age	Department	DateofAdm	Charges	Sex
1	Mayank	65	Surgery	23/02/2018	600	M
2	Babita	24	ENT	01/01/2019	400	F
3	Kashish	45	Orthopaedic	19/12/2018	400	M
4	Tarun	12	Surgery	01/10/2018	600	M
5	Manisha	36	ENT	12/01/2018	400	F
6	Imran	16	ENT	24/02/2018	400	M
7	Ankita	NULL	Cardiology	20/08/2018	800	F
8	Zoya	45	Gynecology	22/02/2018	500	F
9	Kush	19	Cardiology	13/01/2019	800	M
10	Shalini	31	Medicine	19/02/2018	300	F

Note: PNo is the primary key in the above table.

Write SQL commands for the statements (a) to (g) on the table HOSPITAL.

(a) To show all the information about the patients of the cardiology department.

(b) To list the names of female patients who are either in the orthopaedic or surgery department.

(c) To list the name of all the patients with their date of admission in ascending order.

(d) To display the patient’s name, charges, the age for female patients only.

(e) To count the number of patients with age > 30.

(f) To display various departments.

(g) To display the number of patients in each department.

Granuda Consultants are setting up a secured network for their office campus at Faridabad for their day to day office and web based activities. They are planning to have connectivity between 3 buildings and the head office situated in Kolkata. Answer the questions (a) to (d) after going through the building positions in the campus and other details, which are given below:

Distances between various buildings:

Building “RAVI” to Building “JAMUNA”	120m
Building “RAVI” to Building “GANGA”	50m
Building “GANGA” to Building “JAMUNA”	65m
Faridabad Campus to Head Office	1460km

Number of computers:

Building “RAVI”	25
Building “JAMUNA”	150
Building “GANGA”	51
Head Office	10

(a) Suggest the most suitable place (i.e. block) to house the server of this organization. Also give a reason to justify your suggested location.

(b) Suggest a cable layout of connections between the buildings inside the campus.

(c) Suggest the placement of the following devices with justification:

(i) Switch

(ii) Repeater

(d) The organization is planning to provide a high speed link with its head office situated in KOLKATA using a wired connection. Which of the following cable will be most suitable for this job?

(i) Optical Fiber

(ii) Co-axial cable

(iii) Ethernet cable

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

Write a Python program to push all zeros to the end of a given list a. The order of the elements should not change.