Select name with special characters in dplyr

Question

How can I de-select a column named "(Intercept)" using dplyr::select and not using the column-index?

library(dplyr)
library(tibble)

tib<-tribble(~"(Intercept)",~b,
              80,3,
              80,4,
              80,4)

tib[,-1] # works

select(tib,eval(parse(("-(Intercept)")))) # does not work
select(tib,as.name(("-(Intercept)"))) # does not work 
select(tib,-"\(Intercept\)") # does not work

Thanks&kind regards

http://stackoverflow.com/questions/22842232/dplyr-select-column-names-containing-white-space?rq=1 — talat, May 15 '17 at 10:04
Minus only works for numeric position seeking. If you have a name, you first have to map its position first. — Roman Luštrik, May 15 '17 at 11:41

score 5 · Accepted Answer · answered May 15 '17 at 10:03

5

We need to use backquotes

tib %>% 
    select(-`(Intercept)`)
tib %>% 
    select(`(Intercept)`)

answered May 15 '17 at 10:03

akrun

874,273
37
540
662

Select name with special characters in dplyr

1 Answers1