Pandas MCQs with answers Page - 3

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 rename columns in a pandas DataFrame?
  • (A) rename_columns()
  • (B) rename()
  • (C) set_columns()
  • (D) update_columns()
💬 Discuss
✅ Correct Answer: (B) rename()

Explanation: The rename() method allows you to rename columns or index labels in a DataFrame using a dictionary mapping.

📊 Pandas
Q. Which function is used to drop a column or row from a DataFrame?
  • (A) drop()
  • (B) remove()
  • (C) delete()
  • (D) discard()
💬 Discuss
✅ Correct Answer: (A) drop()

Explanation: The drop() method removes specified rows or columns from a DataFrame.

📊 Pandas
Q. Which method returns the data type of each column in a DataFrame?
  • (A) dtypes
  • (B) info()
  • (C) type()
  • (D) datatype()
💬 Discuss
✅ Correct Answer: (A) dtypes

Explanation: The dtypes attribute shows the data type of each column in a DataFrame.

📊 Pandas
Q. Which method provides a concise summary of a DataFrame including column names, non-null counts, and data types?
  • (A) describe()
  • (B) info()
  • (C) summary()
  • (D) head()
💬 Discuss
✅ Correct Answer: (B) info()

Explanation: The info() method gives an overview of the DataFrame including column names, non-null counts, and data types.

📊 Pandas
Q. Which pandas method is used to combine two DataFrames along columns?
  • (A) concat(axis=1)
  • (B) merge()
  • (C) append()
  • (D) join()
💬 Discuss
✅ Correct Answer: (A) concat(axis=1)

Explanation: Using pd.concat() with axis=1 combines DataFrames along columns.

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

Explanation: The value_counts() method counts how many times each unique value appears in a Series.

📊 Pandas
Q. Which method reshapes a DataFrame from wide to long format?
  • (A) melt()
  • (B) pivot()
  • (C) stack()
  • (D) unstack()
💬 Discuss
✅ Correct Answer: (A) melt()

Explanation: The melt() method converts wide format DataFrames into long format for easier analysis.

📊 Pandas
Q. Which pandas method is used to remove duplicate rows from a DataFrame?
  • (A) drop_duplicates()
  • (B) remove_duplicates()
  • (C) unique()
  • (D) distinct()
💬 Discuss
✅ Correct Answer: (A) drop_duplicates()

Explanation: The drop_duplicates() method removes duplicate rows based on all or selected columns.

📊 Pandas
Q. Which function is used to get the index of a DataFrame?
  • (A) columns
  • (B) index
  • (C) keys()
  • (D) labels()
💬 Discuss
✅ Correct Answer: (B) index

Explanation: The index attribute returns the row labels of a DataFrame.

📊 Pandas
Q. Which method is used to apply a function to each element of a Series or DataFrame?
  • (A) apply()
  • (B) map()
  • (C) transform()
  • (D) forEach()
💬 Discuss
✅ Correct Answer: (A) apply()

Explanation: The apply() method allows you to apply a function along rows or columns in a DataFrame, or to each element in a Series.

Programming Categories

📱 Download Our App

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

Get it on Google Play