How to Import Data
If you do not want to use csv file transfer you can:
Open Excel
select data
Ctrl-C
Open R
your.data <- read.delim("clipboard")
will transfer clipboard contents of clipboard into your.data.
HTH
Petr
On 21 Feb 2006 at 8:52, Carl Klarner wrote:
Date sent: Tue, 21 Feb 2006 08:52:04 -0500 From: "Carl Klarner" <cklarner at isugw.indstate.edu> To: <r-help at stat.math.ethz.ch> Subject: [R] How to Import Data
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 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
Petr Pikal petr.pikal at precheza.cz