Which of the following code blocks returns a DataFrame containing only the rows from DataFrame storesDF where the value in column sqft is less than or equal to 25,000?

Question

Options

• AstoresDF.where(storesDF[sqft] > 25000)
• BstoresDF.filter(sqft > 25000)
• CstoresDF.filter("sqft" <= 25000)
• DstoresDF.filter(col("sqft") <= 25000)
• EstoresDF.where(sqft > 25000)

• A
  7% (4)
• B
  12% (7)
• C
  2% (1)
• D
  78% (47)
• E
  2% (1)

Explanation

storesDF.filter(col('sqft') <= 25000) is the correct syntax. col('sqft') creates a Column object from the string column name, and the <= operator produces a boolean Column expression suitable for filtering. Option A uses > (wrong direction) and unquoted sqft. Option B uses > (wrong direction) and omits col(). Option C attempts to apply <= directly to a plain string 'sqft', which is not valid. Option E omits col() and uses >, so sqft would be treated as an undefined Python variable and the comparison is inverted.

No community discussion yet for this question.