[R] trouble with reading data from excel

Roger Bivand Roger.Bivand at nhh.no
Mon Sep 12 21:11:02 CEST 2005

On Mon, 12 Sep 2005, sloan jones wrote:

> I have been trying to open data that I have saved in an excel spread sheet.  I saved it as a csv.  Then I tried using the read.csv command. However, everytime I do this--
> diseasedat<-read.csv("M:/sloan/R/disease/disease.csv", sep=,  header = TRUE, fill= TRUE)--
> I get an error message:  
> Error in file(file, "r") : unable to open connection
> In addition: Warning message:
> cannot open file 'M:/sloan/R/disease/disease.csv'
> What am I doing wrong or what should I look for to correct this?

Try using file.choose() instead of typing in your file name - read.csv()
cannot find a file with that name in that directory.

> Sloan

Roger Bivand
Economic Geography Section, Department of Economics, Norwegian School of
Economics and Business Administration, Helleveien 30, N-5045 Bergen,
Norway. voice: +47 55 95 93 55; fax +47 55 95 95 43
e-mail: Roger.Bivand at nhh.no

More information about the R-help mailing list