[R] trouble with reading data from excel

[Murray Pung]

Alternatively, you can set the working directory to your folder:

File > Change dir...

Select your directory, and then:

diseasedat <- read.csv("disease.csv")

Murray


-----Original Message-----
From: John Charles Considine [mailto:vinum at iinet.net.au]
Sent: Tuesday, 13 September 2005 9:29 AM
To: r-help
Subject: Re: [R] trouble with reading data from excel


Sloane, 

try,

diseasedat<-read.csv("M:\\sloan\\R\\disease\\disease.csv")

and read http://cran.r-project.org/doc/manuals/R-data.html

JC


On Mon, 2005-09-12 at 19:58 +0100, 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?
> 
> Sloan
> 

	[[alternative HTML version deleted]]

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html