Asking for a fix for R backtick operator

Question

I am trying to import data from in xls format in R, but it reads the header incorrectly, instead of

X1

R interprets the data as

`X1 `

that makes writing complicated R syntax impossible.

How this issue can be resolved ?

welcome to SO. you were prompted to write a detailed, reproducible example when you started a question. You've also likely read many SO questions & shld be able to tell good ones from bad ones. https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example has info on how to make a gd question. — hrbrmstr, Dec 09 '17 at 10:25
Having said ^^, why not just change the column names after you read in the xls file? `?colnames` in an R console will show you how to do that. — hrbrmstr, Dec 09 '17 at 10:28

score 1 · Answer 1 · answered Dec 09 '17 at 11:18

1

One can skip the header record and give your own column names with any number of R packages that read excel data. Here is an example with readxl::read_excel().

library(readxl)
data <- read_excel("./data/anExcelWorksheet.xlsx",
                   col_names=FALSE,
                   skip=1)

answered Dec 09 '17 at 11:18

Len Greski

10,505
2
22
33

Actually, the problem was solved after installing the most recent update of R – Idomen Dec 16 '17 at 02:29
@Idomen which package and function did you use to read the data? – Len Greski Dec 16 '17 at 13:54
I am using no package, just I load .xlsx file, I use attach command for dataset and I type the name of the variable. – Idomen Dec 18 '17 at 02:38
@Idomen please update your original post to include the exact code you used to read the file. How did you "load the .xlsx file?" – Len Greski Dec 18 '17 at 04:18
@Igleski Just I used the drop-down menu from Import dataset button, – Idomen Dec 20 '17 at 01:30

Asking for a fix for R backtick operator

1 Answers1