Re: [R] How to Import Data

From: Adaikalavan Ramasamy <>
Date: Wed 22 Feb 2006 - 01:13:02 EST

  1. You need to use sep="," which is appropriate for a CSV file.
  2. You need to specify the FULL path to the file. See
  3. You can use read.csv which is the read.table variant for CSV files.

For example

  a <- read.csv( file="c:/Progra~1/Docume~1/ramasamy/x111.csv" )

might work if you replace it with your full path. If you have the _unique_ rownames in the first column, you can add the argument "row.names=1" in the call.

Regards, Adai

On Tue, 2006-02-21 at 08:52 -0500, Carl Klarner wrote:
> Hello,
> I am a very new user of R. I've spent several hours trying to import
> data, so I feel okay asking the list for help. I had an Excel file,
> then I turned it into a "csv" file, as instructed by directions. My
> filename is "x111.csv." I then used the following commands to read this
> (fairly small) dataset in.
> x111 <-read.table(file='x111.csv',
> sep="",header=T,
> quote="",comment.char="",
> I then get the following error message.
> Error in file(file, "r") : unable to open connection
> In addition: Warning message:
> cannot open file 'x111.csv', reason 'No such file or directory'
> I would imagine I'm not putting my csv file in the right location for R
> to be able to read it. If that's the case, where should I put it? Or
> is there something else I need to do to it first?
> Thanks for your help,
> Carl
> ______________________________________________
> mailing list
> PLEASE do read the posting guide!
> mailing list PLEASE do read the posting guide! Received on Wed Feb 22 01:26:53 2006

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:42:38 EST