Append suffix to colnames

Question

I have multiple columns of different names in a data frame. For all of them i would like to add a common suffix

tot_proc

So, for example

DF
a   b   c

->

DF
a_tot_proc   b _tot_proc   c_tot_proc

I was able only to figure out how to add a prefix for column names:

colnames(DF) <- paste("tot_proc", colnames(DF), sep = "_")

but not suffix.Could you please help me. Thank you!

Just revert the order in `paste`: `colnames(DF) <- paste(colnames(DF), "tot_proc", sep = "_")` — nicola, Feb 29 '16 at 11:05

score 17 · Answer 1 · answered Dec 19 '17 at 20:38

17

You could just switch the order around.

colnames(DF) <- paste(colnames(DF), "tot_proc", sep = "_")

answered Dec 19 '17 at 20:38

jmaval

1

A handy generalized function: `appendDataFrameColumns<-function(df, prefix="", suffix="", sep="") { colnames(df) <- paste(prefix, colnames(df), suffix, sep=sep) return(df) }` – Gürol Canbek Sep 29 '18 at 15:25

Julien · Answer 2 · 2023-05-30T10:03:09.263

2

With dplyr::rename_with

library(dplyr)
DF %>% rename_with(~ paste(., "tot_proc", sep = "_"))

edited May 30 '23 at 10:03

answered Sep 29 '22 at 11:00

Julien

2 Answers2