Readxl: handling a column name with a space

Question

I've got excel file with my data, I used "readxl" package to transport data to R. I've got several variables, one of these is called "EMPLOYEE ATTITUDE", it contais three types of grades - A, B and C. I wanted to use summary function to check what is the average hourly rate among employees who gained "A" grade.

Data=read_excel("Data.xls")
attach(Data)
 summary(subset(Data, EMPLOYEE ATTITUDE == A)$"HOURLY RATE")

and it's not working. I've tried to make variable "EMPLOYEE ATTITUDE" to be seen as a factor by commend

Attitude=factor(EMPLOYEE ATTITUDE)

but i still see the communicat that there is no such object as "A"!

Try replacing `"HOURLY RATE"` with `\`HOURLY RATE\`` and `EMPLOYEE ATTITUDE` with `\`EMPLOYEE ATTITUDE\``. — Martin Gal, Jun 03 '20 at 17:14
Please take a look at [How to make a great reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example). You question doesn't contain any data nor the exact error message you are facing. — Martin Gal, Jun 03 '20 at 17:17
Although I think that @MartinGal is on the right track, I think that usually if your column name has a blank in it, xlsx will replace it with a period. So try `Hourly.Rate` — G5W, Jun 03 '20 at 17:19
Error in command 'eval(e, x, parent.frame())':object 'A' can't be found when i tried with summary(subset(Data, 'EMPLOYEE ATTITUDE' == A)$'HOURLY RATE') — wrzosowa, Jun 03 '20 at 17:28

Onyambu · Accepted Answer · 2020-06-03T18:06:43.327

0

you could run:

summary(subset(Data, `EMPLOYEE ATTITUDE` == "A","HOURLY RATE"))

edited Jun 03 '20 at 18:06

answered Jun 03 '20 at 17:20

Onyambu

67,392
3
24
53

ERROR: unexpected symbol in "summary(subset(Data, EMPLOYEE ATTITUDE" – wrzosowa Jun 03 '20 at 17:30
object A still can't be found, but thanks for trying – wrzosowa Jun 03 '20 at 17:42
@wrzosowa look at your example. You are the one who put `A` there. I just rectified the code. I dont know what `A` is supposed to be. It can be anything. Probably its one of the columns – Onyambu Jun 03 '20 at 17:43
A is one of three possible values (A, B, C) in the column named "EMPLOYEE ATTITUDE", which is filled with As, Bs, Cs – wrzosowa Jun 03 '20 at 17:58
@wrzosowa Now that you have clarified the issue, check the edit – Onyambu Jun 03 '20 at 18:06

Readxl: handling a column name with a space

1 Answers1