Re: [R] How to Import Data

From: Petr Pikal <petr.pikal_at_precheza.cz>
Date: Thu 23 Feb 2006 - 02:24:04 EST


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@isugw.indstate.edu>
To:             	<r-help@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@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@precheza.cz



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 Received on Thu Feb 23 03:28:02 2006

This archive was generated by hypermail 2.1.8 : Thu 23 Feb 2006 - 06:23:11 EST