Page 354 - Informatics_Practices_Fliipbook_Class12
P. 354

52.  What do you understand by the size of a DataFrame?
         Ans. Size attribute gives the number of elements present in Series or Dataframes.

          53.  Name the plot in which bars need not to be of the same width.

         Ans. Histogram
          54.  Name the function which is used to plot the line plot.
         Ans. plot()

          55.  Which graphs are used to show results of continuous data, such as: weight, height, how much time etc?

         Ans. Histogram
          56.  Name the method which is used to plot the horizontal bar plot.

         Ans. barh( )

          57.  Name the method which is used to set the label for y axis.
         Ans. ylabel()
          58.  What is the purpose of the Matplotlib library?

         Ans. Matplotlib is a data visualization library in Python for 2D plots of arrays. It is a multi-platform data visualisation
              library built on NumPy arrays.

          59.  Name the function which is used to save the plot.
         Ans. The name of the function which is used to save the plot is savefig().
          60.  What is the purpose of a legend?

         Ans. The information shown on the graph's Y-axis is represented by the legend.
              Legend helps to understand what the colors and shapes in the graph mean in terms of data.

          61.  What is open data? Name any two websites from which we can download open data.
         Ans. Open data is a term used to describe information that is freely and legally available online.
              You may obtain data at data.gov.in and kaggle.com, respectively.
          62.  Name the plot which displays the statistical summary.
              Note: Give appropriate title, set xlabel and ylabel while attempting the following questions.
         Ans. Using a bar plot and a histogram, you can display the statistical summary.

          63.  Write the output for the following SQL command:
              SELECT MOD(-4523,2);
         Ans. –1

          64.  Write SQL statement that gives the same output as the following SQL statement but uses 'IN' keyword:
              SELECT NAME FROM ITEM WHERE CLASS = 'XII';

         Ans. SELECT NAME FROM ITEM WHERE CLASS IN ('XII');
          65.  Write the output of the following SQL query:
              SELECT MID('Most Is More',2,4);
         Ans. ost

          66.  Write commands in SQL to display "Edu" from the string "Invest In Education".

         Ans. SELECT MID('Invest In Education',11,3);

          340  Touchpad Informatics Practices-XII
   349   350   351   352   353   354   355   356   357   358   359