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

From: Peter Wilkinson <pwilkinson_at_videotron.ca>
Date: Thu 01 Jul 2004 - 14:29:48 EST

You right its a matrix (I ran an is.matrix() on my object).

Thanks,

Peter

At 12:13 AM 7/1/2004, Patrick Connolly wrote:
>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:34:26 2004

This archive was generated by hypermail 2.1.8 : Wed 03 Nov 2004 - 22:54:38 EST