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
   361   362   363   364   365   366   367   368   369   370   371