[R] how to drop rows from a data.frame
Gabor Grothendieck
ggrothendieck at myway.com
Thu Jul 1 06:36:07 CEST 2004
Assuming all the entries are non-negative and non-NA this will do it:
DF[rowSums(DF) > 0,]
Peter Wilkinson <pwilkinson <at> videotron.ca> writes:
:
: 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
:
: what I want it to 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
More information about the R-help
mailing list