Pandas DataFrame Quiz

In the given code, the dataframe ‘D1’ has ______ rows and ____ columns.

import pandas as pd

LoD = [{‘a’:10, ‘b’:20}, {‘a’:5, ‘b’:10, ‘c’:20}, {‘a’:7, ‘d’:10, ‘e’:20}]

D1 = pd.DataFrame(LoD)

• 3, 3

• 3, 4

• 3, 5

• None of the above

D1[ : ] = 77 will set ____ values of a DataFrame ‘D1’ to 77.

• Only First Row

• Only First Column

• All

• None of the above

The following statement will df = df.drop(['Name', 'Class', 'Rollno'], axis = 1) #df is a DataFrame object

• delete three columns having labels ‘Name’, ‘Class’, and ‘Rollno’.

• delete three rows having labels ‘Name’, ‘Class’, and ‘Rollno’.

• delete any three columns

• return error

Which of the following are ways of indexing to access data elements in a DataFrame?

• Label-based indexing

• Boolean Indexing

• All of the above

• None of the above

The following statement is >>> DF=DF.rename({‘Maths’:’Sub1′,‘Science’:’Sub2′}, axis=’index’) #DF is a DataFrame

• altering the column labels

• altering the row and column labels (both)

• Error

• altering the row labels

Which of the following statements is transposing the DataFrame ‘DF1’?

• DF1.transpose

• DF1.T

• DF1.Trans

• DF1.t

CSV stands for:

• Comma-Separated Values

• Comma Separated Variables

• Column Separated Values

• Column-Separated Variables

In order to work with CSV files from Pandas, you need to import _____, other than Pandas.

• csv

• pandas

• numpy

• no extra package required

To read a specific number of rows from a CSV file, which argument is to be given in read_csv()?

• rows =

• nrows =

• n rows =

• number_rows =

While reading from a CSV file, to use a column’s values as index labels, the argument given in read_CSV() is

• index

• index_col

• index_values

• index_label