10 Must-Know Tidyverse Functions: #1 - relocate()

Written by Matt Dancho

This article is part of a R-Tips Weekly, a weekly video tutorial that shows you step-by-step how to do common R coding tasks.

Let’s learn how relocate, a new function that speeds up column arrangements.

(Click image to play tutorial)

Tidyverse relocate() Tutorial

Today we are covering a new R function available in dplyr 1.0.0

Change Column Order

Select vs Relocate

First, let’s compare the 2 column reordering functions: select() and relocate()

select vs relocate 1

Select is like filter() but for columns. We just get the columns that we specify.

select vs relocate 2

Relocate is like arrange() for columns. It keeps all of the columns, but provides much more flexibility for reordering. Notice how all of the columns are returned.

select vs relocate 3

With relocate(), we can take advantage of special tidy-selectors including last_col() with an offset to provide very specific relocation patterns.

select vs relocate 4

Congrats - You’ve just zapped that data.


You Learned Something New!

Great! But, you need to learn a TON to master the Blue Steel pose.

What happens after you learn R for Business from Matt 👇

…And the look on your boss’ face after seeing your first Shiny App. 👇

I call this, “career acceleration”.


  1. Get the Code

  2. Check out the R-Tips Setup Video.

Once you take these actions, you’ll be set up to receive R-Tips with Code every week. =)

👇 Top R-Tips Tutorials you might like:

  1. mmtable2: ggplot2 for tables
  2. ggdist: Make a Raincloud Plot to Visualize Distribution in ggplot2
  3. ggside: Plot linear regression with marginal distributions
  4. DataEditR: Interactive Data Editing in R
  5. openxlsx: How to Automate Excel in R
  6. officer: How to Automate PowerPoint in R
  7. DataExplorer: Fast EDA in R
  8. esquisse: Interactive ggplot2 builder
  9. gghalves: Half-plots with ggplot2
  10. rmarkdown: How to Automate PDF Reporting
  11. patchwork: How to combine multiple ggplots
  12. Geospatial Map Visualizations in R

Want these tips every week? Join R-Tips Weekly.