Removing suffix from column names using rename_all?

r tidyverse
linda picture linda · Aug 30, 2017 · Viewed 10.9k times · Source

I have a data frame with a number of columns in a form var1.mean, var2.mean. I would like to strip the suffix ".mean" from all columns that contain it. I tried using rename_all in conjunction with regex in a pipe but could not come up with a correct syntax. Any suggestions?

Answer

Benjamin picture Benjamin · Aug 30, 2017

If you want to use the dplyr package, I'd recommend using the rename_at function.

Dframe <- data.frame(var1.mean = rnorm(10),
                     var2.mean = rnorm(10),
                     var1.sd = runif(10))

library(dplyr)

Dframe %>% 
  rename_at(.vars = vars(ends_with(".mean")),
            .funs = funs(sub("[.]mean$", "", .)))

Related questions

Removing NA observations with dplyr::filter()

My data looks like this: library(tidyverse) df <- tribble( ~a, ~b, ~c, 1, 2, 3, 1, NA, 3, NA, 2, 3 ) I can remove all NA observations with drop_na(): df %>% drop_na() Or remove all NA observations in a single column (a for …

Read More
ggplot 'non-finite values' error

I have an R dataframe (df) that looks like this: blogger; word; n; total joe; dorothy; 17; 718 paul; sheriff; 10; 354 joe; gray; 9; 718 joe; toto; 9; 718 mick; robin; 9; 607 paul; robin; 9; 354 ... I want to use ggplot2 to plot n divided by total for each blogger. …

Read More
Convert all columns to characters in a data.frame

Consider a data.frame with a mix of data types. For a weird purpose, a user needs to convert all columns to characters. How is it best done? A tidyverse attempt at solution is this: map(mtcars,as.character) %>% …

Read More