[R] Using read.csv() to import data

charles rockson chlsrocks at yahoo.com
Tue Apr 26 04:53:46 CEST 2016

What about converting your anova results in R  back into csv or excel?

      From: Duncan Murdoch <murdoch.duncan at gmail.com>
 To: Jason Hernandez <jason.hernandez74 at yahoo.com>; "r-help at r-project.org" <r-help at r-project.org> 
 Sent: Sunday, April 24, 2016 2:05 PM
 Subject: Re: [R] Using read.csv() to import data
On 24/04/2016 4:30 PM, Jason Hernandez via R-help wrote:
> I am just beginning to learn R, using _R for Dummies_ by Andrie de Vries and Joris Meys. I am using Windows 7, and RGui (64-bit) version 3.0.2. I have reached the chapter on "Getting Data Into and Out of R." But the code they use for importing data doesn't seem to be working for me.
> Their example is:> elements <- read.csv(file.path("f:", "elements.csv"))
> Since I don't have any such file, I am trying to use a file I have. I went to Excel, brought up my file titled JPH_data, and saved it as .csv (comma delineated) on my main hard drive C:
> Then I entered:>  mammals <- read.csv(file.path("C:", "JPH_data.csv"))
> I got the following:Error in file(file, "rt") : cannot open the connection
> In addition: Warning message:
> In file(file, "rt") :
>    cannot open file 'C:/JPH_data.csv': No such file or directory
> Aside from the obvious (how can it say "no such file or directory" when I just saved one such?), the "cannot open the connection" is also unexpected. What am I doing wrong here?
> Jason Hernandezno current affiliation

By far the easiest ways to enter Windows file paths are using the 
file.choose() and choose.files() functions.  Do something like

filename <- file.choose() # navigate to the file
mammals <- read.csv(filename)

and you should be fine.  The file.choose() function works on all 
platforms; choose.files() works only on Windows (and has more options, 
including allowing multiple files to be chosen).

Duncan Murdoch

R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

	[[alternative HTML version deleted]]

More information about the R-help mailing list