How to remove unnecessary single quotation marks (') from column names in a R data frame?

Question

unfortunately I have got colnames, which all have additional single quotation marks like here:

x <- data.frame(c(11,21,31),c(12,22,32),c(13,23,33))
colnames(x) <- c("'A'","'B'","'C'")

So my question is, if I can get rid of those "'" for my entire data frame? Preferably not retyping the colnames, and using tidyR code? Thanks!

@Onyambu you should Include your comment as an answer. Its the simplest way of answering the question. — Daniel O, May 28 '20 at 17:31

score 3 · Answer 1 · answered May 28 '20 at 17:31

3

In base R:

names(x) <- gsub("'", "", names(x))

x
   A  B  C
1 11 12 13
2 21 22 23
3 31 32 33

answered May 28 '20 at 17:31

Chris Ruehlemann

score 1 · Accepted Answer · answered May 28 '20 at 17:24

1

library(stringr)

colnames(x) <- str_remove_all(colnames(x), "'")

That should do it

library(dplyr)
library(stringr)
    x %>% 
       rename_all(~str_remove_all(., "'"))

If you want a pipe

answered May 28 '20 at 17:24

NotThatKindODr

Yes, it does. Thanks - Great library - I was worried I would have to use gsub! What a relief ;-) – LxndrF May 28 '20 at 17:34

score 0 · Answer 3 · answered May 28 '20 at 18:19

0

We can use trimws in base R

names(x) <-  trimws(names(x), whitespace = "'")
x
#   A  B  C
#1 11 12 13
#2 21 22 23
#3 31 32 33

answered May 28 '20 at 18:19

akrun

3 Answers3