Which of the following sets of DataFrame methods will both return a new DataFrame only containing rows that meet a specified logical condition?

Question

Options

• Adrop(), where()
• Bfilter(), select()
• Cfilter(), where()
• Dselect(), where()
• Efilter(), drop()

• A
  3% (1)
• B
  3% (1)
• C
  89% (31)
• D
  6% (2)

Explanation

filter() and where() are functionally identical aliases in DataFrame APIs like PySpark - both return a new DataFrame containing only the rows that satisfy a given boolean condition, which makes C correct.

Why the distractors are wrong:

• select() (B, D) operates on columns, not rows - it returns a DataFrame with only the specified columns, ignoring row conditions entirely.
• drop() (A, E) also operates on columns - it removes named columns from the DataFrame rather than filtering rows.

Memory tip: Think of filter/where as SQL's WHERE clause (rows), and select/drop as column-level operations (like SELECT col or DROP COLUMN). The word "where" itself is the giveaway - it belongs in the row-filtering category alongside filter().

No community discussion yet for this question.