Functions — Computer Science STD 12 Science — Question

Table: HOSPITAL

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.

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

Write a script to create a list of 10 random integers and display it. Then input an integer from the user and check whether it is present in the list (use in operator). If it is present in the list, then remove it from the list. If the element is present in the list multiple times then all its occurrences should be removed. (use remove() method). If the element is not present, then display an appropriate message.