Page 366 - Informatics_Practices_Fliipbook_Class12
P. 366
27. Write a Python code to create a DataFrame studentDF containing ROLLNO, NAME, TOTAL as column headings from
the list given below:
[ ['10', 'Nishka', 450], ['20', 'Sachin', 369], ['30', 'Ruby', 278], ['40', 'Raman', 498] ]
28. Write SQL statements to:
a. view the structure of a table 'Customer'.
b. create the 'Employee' table according to the following specification:
COLUMN NAME DATA TYPE REMARK
employee_id INT PRIMARY KEY
first_name VARCHAR(50)
last_name VARCHAR(50)
date_of_birth DATE
29. Akshit was preparing his science project on "Green House Effects".
Step-1: He visited many websites and downloaded three web pages (web page1, web page2, web page3)
containing information on the above topic.
Step-2: He read a paragraph on web page1, rephrased it in his own words and finally used the rephrased paragraph
in his project.
Step-3: He downloaded five images from webpage2 and used the images in his project.
Fill in the blanks:
(i) Step-1 is an example of _____________ .
(ii) Step-2 is an act of _____________ .
(iii) Step-3 is an act of _____________ .
OR
List any three etiquettes that needs to be followed for good online behaviour.
30. Consider a DataFrame df with C1, C2, C3, C4 and C5 as row indexes, shown below:
CITY MAXTEMP MINTEMP RAINFALL
C1 Delhi 40 32 24.1
C2 Bengaluru 31 25 36.2
C3 Chennai 35 27 40.8
C4 Mumbai 29 21 35.2
C5 Kolkata 39 23 41.8
Write Python statements to:
a. Display maximum and minimum temperature of Delhi and Mumbai.
b. Display the DataFrame in reverse order.
c. Change the MinTemp of Mumbai to 19.
352 Touchpad Informatics Practices-XII

