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 http://cran.r-project.org/bin/windows/base/rw-FAQ.html#R-can_0027t-find-my-file
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="",as.is=T) > > 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 > > ______________________________________________ > R-help@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 > ______________________________________________ R-help@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