Re: [R] (no subject)

From: Petr PIKAL <petr.pikal_at_precheza.cz>
Date: Mon, 10 Mar 2008 14:48:09 +0100

Hi

r-help-bounces_at_r-project.org napsal dne 10.03.2008 13:00:39:

> If you have an original file in excel, the way I get such files is to
> save them as csv (comma-separated), and then to use read.csv. Then

Or if you do not have need to save the file just in Excel select data you want to transfer to R
press Ctrl - C

In R write
test <- read.delim("clipboard")

and you shall get test data frame. See ?read.delim

Regards
Petr

> these empty spots are more easily handled, since they correspond to
> too successive commas.
>
> Haris Skiadas
> Department of Mathematics and Computer Science
> Hanover College
>
>
> On Mar 10, 2008, at 7:26 AM, Alfons Sutter wrote:
>
> > Thank you! I have the origenal file in MS-Excel, I save the excel
> > file in a txt file. In the excel file there are missing value empty
> > places for these missing value? Do I need to replace the empty
> > places in a symbol for missing value and could you tell me place
> > how can I avoid this warning message?
> >
> > Thank you in advance!
> >
> > ----- Original Message ----
> > From: Duncan Murdoch <murdoch_at_stats.uwo.ca>
> > To: Alfons Sutter <alfonssutter_at_yahoo.com>
> > Cc: r-help_at_stat.math.ethz.ch
> > Sent: Monday, March 10, 2008 12:18:11 PM
> > Subject: Re: [R] (no subject)
> >
> > On 10/03/2008 6:50 AM, Alfons Sutter wrote:
> >> Hi all,
> >>
> >> I am trying to read a text file in R! I have a warning message:
> >>
> >> In read.table(file = "data1.txt", header = T) : uncompleted last
> >> line of readTableHeader in 'data1.txt'
> >
> > R is warning you that the file may be incomplete. In Unix, text files
> > are supposed to always end with a newline. Windows programs often
> > omit
> > it on the last line. So on Unix, R is probably right to warn you, but
> > it could well be a false positive if you're on Windows.
> >
> >> Could you please tell me why? and how can I deal with missing
> >> value when I read this file?
> >
> > How you deal with missing values really depends on what you want to do
> > with the data. There's no general answer.
> >
> > Duncan Murdoch
> >
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Mon 10 Mar 2008 - 14:03:51 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 10 Mar 2008 - 14:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive