Hi,
I can see and issue with csv import in R.
I have some data files provided to me in csv format. Unfortunately I cannot import them to R. Although when I open them in Excel and import them in Excel format, everything is fine. I know I can convert all files before importing them but I am just curious that that could be.
this doesn't work:
data.source.csv <- read.csv("P:/User/yyy.csv", header = TRUE, sep = ",")
but this is fine:
library(readxl)
data.source.xls <- read_excel("P:/User/yyy.xlsx")
and I've got that as a result:
data.frame(stringsAsFactors=FALSE,
þÿ.URN. = c("10BE022654416", "10BE022662462", "10BE022001922"),
QUESTION = c("Recommendation", "Recommendation", "Choice Dealer"),
VERBATIM = c("aaa meer!!!!!", "bbb gesteld", "ccceid"),
CONCEPTS = c("-[5|68|180]", "+[7|0|61]\t-[5|61|106]", "+[7|0|107]")
)
any thoughts? Maybe that is related to a weird character in the name of the first variable (þÿ.URN)?