Changing Column position in spark dataframe

Question

Is it possible to change the position of a column in a dataframe?

i have declared a dataframe ['x','y','z'] , so can i change it to   ['x','z','y']?

Answer 1

Yes, you can reorder the dataframe elements.

You need to extract the column names and reorder them.

val columns: Array[String] = dataFrame.columns
val reorderedColumnNames: Array[String] = //reordering
val result: DataFrame = dataFrame.select(reorderedColumnNames.head, reorderedColumnNames.tail: _*)