[R] How to Import Data

[Petr Pikal]

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