Re: [R] How to delete rows

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Thu 28 Jul 2005 - 03:02:43 EST

To delete duplicate rows, use unique(TAB1): see its help page.

It looks to me as if the names are missing values NA and *not* start with NA. If so, you want to use

TAB1[!is.na(TAB1$Name), ]

Otherwise, perhaps TAB1[substr(TAB1$Name, 1, 2) == "NA", ].

On Wed, 27 Jul 2005, Michael Graber wrote:

> Dear R-users,
>
> I am very new to R, so maybe my question is very easy to answer.
> I have the following table:
> TAB1<-data.frame(Name,Number), "Name" and "Number" are all character
> strings,
> it looks like this:
>
> Name Number
>
> ab 2
>
> ab 2
>
> NA 15
>
> NA 15
>
> NA 15
>
> cd 3
>
> ef 1
>
> NA 15
>
> NA 15
>
> gh 15
>
> gh 15
>

> I want to delete all the rows which begin with "NA"
> and all the rows where names are duplicates
> (for example the second row).
> I have tried this, but I only get numbers:
>
> for (i in 1:ZeileMax ) {if ( TAB1[[1]] [i] != "NA" )
> {cat(TAB1[[1]][i],file = "Name.txt",fill= TRUE,append = TRUE ,sep =
> "");cat(TAB1[[2]][i], file="Number.txt", fill=TRUE,append=TRUE, sep="")}}
> Name<-readLines("Name.txt")
> Number<-readLines("Number.txt")
> TAB<-data.frame(Name,Number)

>
>
> Thanks in advance,
>
>
>
> Michael Graber
>
> ______________________________________________
> 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
>

-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
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 Jul 28 03:17:43 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:34:05 EST