Data handling using pandas and Data visualization

Data Frame in pandas is

• a) 1 dimensional array

• b) 2 dimensional array

• c) 3 dimensional array

• d) None of the above

Which of the following takes a dict of dicts or a dict of array-like sequences and returns a DataFrame?

• a) DataFrame.from_items

• b) DataFrame.from_records

• c) DataFrame.from_dict

• d) All of the mentioned

This function in the library of Pandas allows you to manipulate data and create new variables:

• a) read_csv function

• b) Pivot_table function

• c) apply function

• d) merge function

______________ function returns current date and time.

• a) SET DATEFIRST

• b) SYSDATETIME

• c) Cert_ID

• d) GETDATE

In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.

• a) True

• b) False

• c) Either True or False

• d) None of the above

We apply the aggregate function to a group of sets of tuples using the _______ clause.

• a) group by

• b) group

• c) group set

• d) group attribute

What is the output of the following program?

squares = {1:1, 2:4, 3:9, 4:16, 5:25}

print(squares.pop(4))

print(squares)

• 16

  {1: 1, 2: 4, 3: 9, 5: 25}

• 16

  {1: 1, 2: 4, 3: 9, 4:16, 5: 25}

• 4

  {1: 1, 2: 4, 3: 9, 5: 25}

• 4

  {1: 1, 2: 4, 3: 9, 4:16, 5: 25}

Which is a python package used for 2D graphics?

• A. matplotlib.pyplot

• B. matplotlib.pip

• C. matplotlib.numpy

• D. matplotlib.plt

To install matplotlib, the following function will be typed in your command prompt. What does “-U”represents?

Python –m pip install –U pip

• A. downloading pip to the latest version

• B . upgrading pip to the latest version

• C. removing pip

• D. upgrading matplotlib to the latest version

The expansion of CRLF is

• A. Control Return and Line Feed

• B. Carriage Return and Form Feed

• C. Control Router and Line Feed

• D .Carriage Return and Line Fee