dplyr: How to Change the Order of Columns in Data Frame

Requirements:

dplyr v>=1.0.0

library(dplyr)
# Data preparation
df <- tibble(w = 0:2, x = 1:3, 
             y = c("a", "b", "c"), 
             z = c("d", "e", "f"))
df

## # A tibble: 3 x 4
##       w     x y     z    
##   <int> <int> <chr> <chr>
## 1     0     1 a     d    
## 2     1     2 b     e    
## 3     2     3 c     f

# Relocate columns to the left hand side
df %>% relocate(y, z)

## # A tibble: 3 x 4
##   y     z         w     x
##   <chr> <chr> <int> <int>
## 1 a     d         0     1
## 2 b     e         1     2
## 3 c     f         2     3

# Move columns to a different position
# Relocate after a specific column
df %>% relocate(w, .after = y)

## # A tibble: 3 x 4
##       x y         w z    
##   <int> <chr> <int> <chr>
## 1     1 a         0 d    
## 2     2 b         1 e    
## 3     3 c         2 f

# Relocate before a specific column
df %>% relocate(w, .before = y)

## # A tibble: 3 x 4
##       x     w y     z    
##   <int> <int> <chr> <chr>
## 1     1     0 a     d    
## 2     2     1 b     e    
## 3     3     2 c     f

# Move columns to the right hand side use `last_col()`
df %>% relocate(w, .after = last_col())

## # A tibble: 3 x 4
##       x y     z         w
##   <int> <chr> <chr> <int>
## 1     1 a     d         0
## 2     2 b     e         1
## 3     3 c     f         2