Rearrange columns while fetching from datasource

Question

Hi, I want to rearrange the columns from the datasource to the last column, so that my new calculation also comes together. How to do this?

Answer 1

You cannot reorder the columns like below.

suppose df is a data frame object with 5 columns,

Then reorder columns as

df <- df[, c(5, 4, 1, 2, 3)]