DSA DEC Batch 2023 Pandas MCQ

What is Pandas?

• A type of bear

• A data manipulation library in Python

• A new programming language

• A framework for web development

What are the advantages of Pandas.

Choose all correct answers and submit the answers

• Restricted compatibility with external file formats

• Fast and efficient for manipulating and analyzing data

• Easy handling of missing data (represented as NaN) in floating point as well as non-floating point data.

• Limited flexibility in handling diverse data types

Which Pandas object is used to store one-dimensional labeled data?

• DataFrame

• Series

• Panel

• Array

Which Pandas object is used to store two-dimensional labeled data?

• DataFrame

• Series

• Panel

• Matrix

What is python Modules?

• It is a file containing Python definitions and statements

• A built-in data type

• A software framework

• A hardware component

What does the following Python code do?

auto_data.isnull().sum()

• Checks if the DataFrame auto_data is null.

• Counts the total number of null values in each column of the DataFrame auto_data

• Removes null values from the DataFrame auto_data

• Checks if the DataFrame auto_data is empty.

Which command is used for converting this dictionary into a DataFrame?

• data = pd.DataFrame(data_dic)

• data = FrameConvert(data_dic)

• data = pd.convert(data_dic).toFrame

• data = DataFrameConv(data_dic).pd

What do the head() and tail() functions do in Pandas when applied to a DataFrame?

• Both functions display the entire DataFrame.

• head() displays the first few rows, while tail() displays the last few rows of the DataFrame.

• head() displays the last few rows, while tail() displays the first few rows of the DataFrame.

• Both functions are used for sorting the DataFrame.

In pandas, what do the min ( ) and max ( ) functions do?

• The min ( ) function returns the minimum value in a DataFrame or Series, and the max ( ) function returns the maximum value.

• The min ( ) function computes the mean value of a DataFrame or Series, and the max ( ) function calculates the median.

• Both min ( ) and max ( ) functions return the sum of all values in a DataFrame or Series.

• The min ( ) function calculates the standard deviation, while the max ( ) function finds the variance.

What does the following Python code do?

auto_data.iloc[1:10, [0, 2]]

• Selects rows from index 1 to 10 and all columns in the DataFrame 'auto_data'.

• Selects rows from index 1 to 9 and columns with indices 0 and 2 in the DataFrame 'auto_data'.

• Selects the first 10 rows and the first and third columns in the DataFrame 'auto_data'.

• Selects all rows and columns with indices 1 to 10 and 0 to 2, respectively, in the DataFrame 'auto_data'.