CBSE Class 12 Informatics Practices Data Handling using Pandas I MCQs Set B

Question: Which of the following file can be created in Python?
a) Text File
b) Binary File
c) CSV File
d) All of the above
Answer: d

Question: Which of the following statement(s) are true for CSV files?
a) When you open a file for reading, if the file does not exist, an error occurs
b) When you open a file for writing, if the file does not exist, a new file is created
c) When you open a file for writing, if the file exists, the existing file is overwritten with the new file
d) All the above
Answer: d

Question: Which of the following property/attribute returns total number of values in Series ‘S1’?
a) size
b) values
c) index
d) None of the above
Answer: a

Question: Which of the following properties returns the nested list of elements from the dataframe row-wise?
a) T
b) hasnans
c) elements
d) values
Answer: d

Question: A dataframe has two axes, where axes = 0 represents
a) Row
b) Column
c) Index
d) Values
Answer: a

Question: Which of the following statement shows first five values of Series ‘S1’?
a) S1.head()
b) S1.head(5)
c) Both of the above
d) None of the above
Answer: c

Question: Python libraries contain a collection of built-in _____________.
a) Data
b) Modules
c) Packages
d) Data Structure
Answer: b

Question: When an operation is carried out on every value of Series object it is called _____
a) Scalar Operation
b) Vector Operation
c) Both of the above
d) None of the above
Answer: b

Question: To access the value of dataframe using row labels we can use -
a) at
b) loc
c) iat
d) iloc
Answer: b

Question: Which of the following statement is incorrect for dataframe indexes?
a) Dataframe index can have only numbers
b) DataFrame index can have numbers, characters or string
c) DataFrame index cannot be defined explicitly
d) DataFrame indexes are of two type : row indexes and column indexes
Answer: a

Question: Which of the following method does not return the number of characters written in the file?
a) write()
b) writelines()
c) Both of the above
d) None of the above
Answer: b

Question: Which argument of bar() lets you set the thickness of bar?
a) thick
b) thickness
c) width
d) barwidth
Answer: c

Question: Which of the following is not a valid plotting function of pyplot?
a) pie()
b) plot()
c) bar()
d) line()
Answer: d

Question: When a dataframe is created using 2D dictionary, column labels are formed by:
a) Key of outer dictionary
b) Key of inner dictionary
c) Value of outer dictionary
d) Value of inner dictionary
Answer: a

Question: Which is a Python package used for 2D graphics?
a) matplotlib.pyplot
b) matplotlib.pip
c) matplotlib.numpy
d) matplotlib.plt
Answer: a

Question: Which of the following is a module of matplotlib that contains a set of functions for data visualization?
a) plt
b) pandas
c) plot
d) pyplot
Answer: d

Question: Which package can be used to generate publication quality plots, histograms, bar charts, scatterplots, etc.?
a) NumPy
b) Pandas
c) Matplotlib
d) All of these
Answer: c

Question: A _______________ is a collection of data values and operations that can be applied to that data. It enables efficient storage, retrieval and modification to the data.
a) array
b) series
c) data frame
d) data structure
Answer: d

Question: NumPy stands for _________________
a) Number Program
b) Numerical Python
c) Numeric Array Python
d) Nested Python
Answer: b

Question: Which of the following is Not True about Series and Dataframe?
a) Both are size mutable
b) Both can be derived from pandas
c) Both can be reshaped into different forms
d) Both can be created by passing data in form of list, dictionaries and ndarray
Answer: a

Question:
Assertion (A): You need to install the pandas library using the pip install command
Reason (R): You can also access pandas without installation
(a) Both Assertion (A) and Reason (B) are correct and Reason (R) is the correct explanation of Assertion (A)
(b) Both are correct but Reason(R) is not the correct explanation of Assertion (A)
(c) Assertion (A) is true but Reason (R) is false
(d) Assertion (A) is not correct but Reason (R) is correct
Answer: c

Question:
Assertion (A) : Slicing can be also used to modify the series elements.
Reason (R): Series elements can be modified with a list of values respectively.
(a) Both Assertion (A) and Reason (B) are correct and Reason (R) is the correct explanation of Assertion (A)
(b) Both are correct but Reason(R) is not the correct explanation of Assertion (A)
(c) Assertion (A) is true but Reason (R) is false
(d) Assertion (A) is not correct but Reason (R) is correct
Answer: c

Question:
Assertion (A): The pop() method can be used to delete values from the top index from the series.
Reason (R): The pop() and drop() methods can be used to delete values from the series but the pop() only deletes the value from top and drop() will delete the specified indexed value.
(a) Both Assertion (A) and Reason (B) are correct and Reason (R) is the correct explanation of Assertion (A)
(b) Both are correct but Reason(R) is not the correct explanation of Assertion (A)
(c) Assertion (A) is true but Reason (R) is false
(d) Assertion (A) is not correct but Reason (R) is correct
Answer: a