Pandas MCQs with answers Page - 2

Dear candidates you will find MCQ questions of Pandas here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 Pandas
Q. Which method is used to sort a DataFrame by column values?
  • (A) sort_values()
  • (B) sort_index()
  • (C) order()
  • (D) rank()
💬 Discuss
✅ Correct Answer: (A) sort_values()

Explanation: sort_values() sorts a DataFrame based on the values of one or more columns.

📊 Pandas
Q. Which pandas function is used to group data?
  • (A) groupby()
  • (B) aggregate()
  • (C) pivot_table()
  • (D) merge()
💬 Discuss
✅ Correct Answer: (A) groupby()

Explanation: The groupby() method groups data according to one or more columns for aggregation or transformation.

📊 Pandas
Q. Which function is used to merge two DataFrames on a key column?
  • (A) concat()
  • (B) merge()
  • (C) join()
  • (D) combine()
💬 Discuss
✅ Correct Answer: (B) merge()

Explanation: merge() combines two DataFrames based on common columns or indices, similar to SQL joins.

📊 Pandas
Q. Which method returns the unique values of a Series?
  • (A) unique()
  • (B) nunique()
  • (C) distinct()
  • (D) values()
💬 Discuss
✅ Correct Answer: (A) unique()

Explanation: The unique() method returns an array of unique values present in a Series.

📊 Pandas
Q. Which function is used to get the number of unique values in a Series?
  • (A) unique()
  • (B) nunique()
  • (C) count_unique()
  • (D) value_counts()
💬 Discuss
✅ Correct Answer: (B) nunique()

Explanation: The nunique() method returns the count of distinct values in a Series.

📊 Pandas
Q. Which method is used to create a pivot table in pandas?
  • (A) pivot()
  • (B) pivot_table()
  • (C) groupby()
  • (D) melt()
💬 Discuss
✅ Correct Answer: (B) pivot_table()

Explanation: pivot_table() creates a spreadsheet-style pivot table for aggregation and analysis.

📊 Pandas
Q. Which method is used to reset the index of a DataFrame?
  • (A) reset_index()
  • (B) set_index()
  • (C) reindex()
  • (D) drop_index()
💬 Discuss
✅ Correct Answer: (A) reset_index()

Explanation: reset_index() resets the index of a DataFrame, converting the current index into a column.

📊 Pandas
Q. Which method is used to check for missing values in a DataFrame?
  • (A) isna()
  • (B) notna()
  • (C) fillna()
  • (D) dropna()
💬 Discuss
✅ Correct Answer: (A) isna()

Explanation: The isna() method returns a boolean DataFrame indicating the presence of NaN values.

📊 Pandas
Q. Which method converts a DataFrame to a NumPy array?
  • (A) to_numpy()
  • (B) asarray()
  • (C) array()
  • (D) values()
💬 Discuss
✅ Correct Answer: (A) to_numpy()

Explanation: The to_numpy() method returns the DataFrame as a NumPy array, preserving the data values.

📊 Pandas
Q. Which function is used to concatenate two DataFrames along rows or columns?
  • (A) concat()
  • (B) merge()
  • (C) append()
  • (D) combine()
💬 Discuss
✅ Correct Answer: (A) concat()

Explanation: pd.concat() can join multiple DataFrames either along rows (axis=0) or columns (axis=1).

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play