Which of the following code blocks returns a new DataFrame where column division from DataFrame storesDF has been replaced and renamed to column state and column managerName from DataFrame storesDF…

Question

Options

• A(storesDF.withColumnRenamed(["division", "state"], ["managerName", "managerFullName"])
• B(storesDF.withColumn("state", col("division"))
• C(storesDF.withColumn("state", "division")
• D(storesDF.withColumnRenamed("state", "division")
• E(storesDF.withColumnRenamed("division", "state")

• A
  2% (1)
• D
  4% (2)
• E
  94% (44)

Explanation

withColumnRenamed(existingName, newName) renames a single column: the first argument is the current column name and the second is the desired new name. To rename two columns, you chain two calls. Option E - storesDF.withColumnRenamed("division", "state").withColumnRenamed("managerName", "managerFullName") - correctly chains both renames. Option A incorrectly passes lists to withColumnRenamed, which only accepts single strings. Option D has the argument order reversed (new name first, old name second). Options B and C use withColumn, which adds a new column without removing the original - they would leave the old "division" column alongside the new "state" column and only handle one rename.

No community discussion yet for this question.