Hi
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> > To: Alfons Sutter <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > 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@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@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.
