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



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

Version: Français





No Comments

Give a comment

Want to post an issue with R? If yes, please make sure you have read this: How to Include Reproducible R Script Examples in Datanovia Comments