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 AND the value in column customerSatisfaction is greater than or equal to 30?
A.
storesDF.filter(col("sqft") <= 25000 and col("customerSatisfaction") >= 30)
B.
storesDF.filter(col(sqft) <= 25000 & col(customerSatisfaction) >= 30)
C.
storesDF.filter(col("sqft") <= 25000 & col("customerSatisfaction") >= 30)
D.
storesDF.filter((col("sqft") <= 25000) & (col("customerSatisfaction") >= 30))
E.
storesDF.filter(sqft <= 25000 and customerSatisfaction >= 30)
D. storesDF.filter((col("sqft") <= 25000) & (col("customerSatisfaction") >= 30)): This correctly uses the filter() method along with logical AND (&) to apply both conditions. Each condition is wrapped in parentheses to ensure proper evaluation.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ARUNKUMARKRISHNASAMY
1 month, 3 weeks agoThameur01
2 months agoOks_An
7 months, 2 weeks ago