The code block shown below contains an error. The code block is intended to return a DataFrame containing all columns from DataFrame storesDF except for column sqft and column customerSatisfaction…

Question

Options

• AThe drop() operation only works if one column name is called at a time - there should be two calls
• BThe drop() operation only works if column names are wrapped inside the col() function like
• CThere is no drop() operation for storesDF.
• DThe sqft and customerSatisfaction column names should be quoted like "sqft" and
• EThe sqft and customerSatisfaction column names should be subset from the DataFrame

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

Explanation

In Python (PySpark), when you write sqft and customerSatisfaction without quotes, the interpreter treats them as variable names, not string literals. If those variables are not defined in scope, Python raises a NameError. Column names passed to drop() must be quoted string literals: storesDF.drop('sqft', 'customerSatisfaction'). Spark's drop() does accept multiple column names in a single call, so there is no need for separate calls. Wrapping in col() is also valid but not required for drop().

No community discussion yet for this question.