R code to select a column with spaces

Asked Aug 16 '16 at 13:35

Active Aug 16 '16 at 14:17

Viewed 331 times

I am trying to write a simple R code to select multiple columns. I am able to do this when the column names do not have spaces. When it has any space, it doesn't work. Could you please help? I am sure that this is really a simple question. I searched for answers in this forum, but I couldn't find any.

Here is my code.

df.mydata <-select(df.rawdata, ID, Job, Role ID)

I get an error. Can you please correct the syntax?

edited Aug 16 '16 at 14:17

StatMan

asked Aug 16 '16 at 13:35

user2341632

You prly want ``select(df.rawdata, ID, Job, `Role ID`)`` – lukeA Aug 16 '16 at 13:37
I tried both single and double quotes. But its not working. I am using dplyr. – user2341632 Aug 16 '16 at 13:38
may be you should check this and avoid the spaces in first place. http://stackoverflow.com/questions/2261079/how-to-trim-leading-and-trailing-whitespace-in-r – user5249203 Aug 16 '16 at 13:39
copy/paste my code - it's not a standard single quote. Dunno what the character is called, though. – lukeA Aug 16 '16 at 13:39
unless you are left-handed, in which case it's just tick :D – Sotos Aug 16 '16 at 13:41
Backtick/tick whatever may be. It works perfectly. :D Thank you all.. – user2341632 Aug 16 '16 at 13:45

R code to select a column with spaces

0 Answers0