Re: [R] how to drop rows from a data.frame

From: Patrick Connolly <p.connolly_at_hortresearch.co.nz>
Date: Thu 01 Jul 2004 - 14:13:40 EST

On Wed, 30-Jun-2004 at 11:57PM -0400, Peter Wilkinson wrote:

|> here is a snippet of data where I would like to drop all rows that have
|> zeros across them, and keep the rest of the rows while maintaining the row
|> names (1,2,3, ...10). The idea here is that a row of zeros is an indication
|> that the row must be dropped. There will never be the case where there is a
|> row(of n columns) with less than 5 zeros in this case(n zeros
|>
|> I am unsure how to manipulate the data frame to drop rows whiles keeping
|> row names.
|>
|> Peter
|>
|> the data (imagine separated by tabs):
|>
|> SEKH0001 SEKH0002 SEKH0003 SEKH0004 SEKH0005
|> [1,] 256.1139 256.1139 256.1139 256.1139 256.1139
|> [2,] 283.0741 695.1000 614.5117 453.0342 500.1436
|> [3,] 257.3578 305.0818 257.3578 257.3578 257.3578
|> [4,] 0.0000 0.0000 0.0000 0.0000 0.0000
|> [5,] 0.0000 0.0000 0.0000 0.0000 0.0000
|> [6,] 0.0000 0.0000 0.0000 0.0000 0.0000
|> [7,] 0.0000 0.0000 0.0000 0.0000 0.0000
|> [8,] 257.0000 257.0000 257.0000 257.0000 257.0000
|> [9,] 305.7857 2450.0417 335.5428 305.7857 584.2485
|> [10,] 0.0000 0.0000 0.0000 0.0000 0.0000

I'm curious to know how you got those row names. I suspect you really have a matrix.

If it were a dataframe, it would behave exactly how you are reqesting -- depending on how you got rid of rows 4:7.

Try as.data.frame(<whatever.your.data.is.now>)

Then deleting the rows will look like:

  SEKH0001 SEKH0002 SEKH0003 SEKH0004 SEKH0005

1 256.1139  256.1139 256.1139 256.1139 256.1139
2 283.0741  695.1000 614.5117 453.0342 500.1436
3 257.3578  305.0818 257.3578 257.3578 257.3578
8 257.0000  257.0000 257.0000 257.0000 257.0000
9 305.7857 2450.0417 335.5428 305.7857 584.2485


HTH

-- 
Patrick Connolly
HortResearch
Mt Albert
Auckland
New Zealand 
Ph: +64-9 815 4200 x 7188
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~
I have the world`s largest collection of seashells. I keep it on all
the beaches of the world ... Perhaps you`ve seen it.  ---Steven Wright 
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Thu Jul 01 14:18:55 2004

This archive was generated by hypermail 2.1.8 : Fri 18 Mar 2005 - 08:52:48 EST