R help - Feb 2011 - How to delete rows with specific values on all columns (variables)?

Hi,

I need to filter my data:
I think its easy but i'm stuck so i'll appreciate some help:

I have a data frame with 14 variables and 6 million rows. About half of this
rows have a value of "0" in 12 variables (the other two variables
always
have values). How can I delete the rows in which all 12 variables have the
value of "0".

example (from my data, variable 14 is missing):

1783         81      85      78     89     71     97     76     66     88    
95     95     98  -57.48258
1784         81      86      79     90     71     97     77     66     88    
95     95     98  -57.43768
1785         81      86      79     90     71     98     77     66     89    
95     94     98  -57.39278
1786          0       0       0      0      0      0      0      0      0     
0      0      0  -57.34788
1787          0       0       0      0      0      0      0      0      0     
0      0      0  -57.30298
1788         80      86      80     90     72     98     78     66     88    
93     93     96  -57.25808
1789         77      83      78     88     70     95     76     63     86    
91     90     93  -57.21318
1790         77      84      79     89     70     96     76     64     87    
91     90     93  -57.16828

I would need to delete rows 1786 & 1787.

I tried subset with variable1>"0"&variable2>"0",
but it wasn't useful 'cause
it only took the rows that didn't have a 0 in any of the variables; I only
need in ALL of the variables simultaneously.

Thanks,

Ignacio

-- 
View this message in context:
http://r.789695.n4.nabble.com/How-to-delete-rows-with-specific-values-on-all-columns-variables-tp3318115p3318115.html
Sent from the R help mailing list archive at Nabble.com.

On Feb 21, 2011, at 4:03 PM, IgnacioQM wrote:
>
> Hi,
>
> I need to filter my data:
> I think its easy but i'm stuck so i'll appreciate some help:
>
> I have a data frame with 14 variables and 6 million rows. About half  
> of this
> rows have a value of "0" in 12 variables (the other two variables
> always
> have values). How can I delete the rows in which all 12 variables  
> have the
> value of "0".
>
> example (from my data, variable 14 is missing):
>
> 1783         81      85      78     89     71     97     76      
> 66     88
> 95     95     98  -57.48258
> 1784         81      86      79     90     71     97     77      
> 66     88
> 95     95     98  -57.43768
> 1785         81      86      79     90     71     98     77      
> 66     89
> 95     94     98  -57.39278
> 1786          0       0       0      0      0      0      0       
> 0      0
> 0      0      0  -57.34788
> 1787          0       0       0      0      0      0      0       
> 0      0
> 0      0      0  -57.30298
> 1788         80      86      80     90     72     98     78      
> 66     88
> 93     93     96  -57.25808
> 1789         77      83      78     88     70     95     76      
> 63     86
> 91     90     93  -57.21318
> 1790         77      84      79     89     70     96     76      
> 64     87
> 91     90     93  -57.16828
>
> I would need to delete rows 1786 & 1787.
something along the lines of:

dfrm[ -apply(dfrm, 1, function(x) all(x==0) ), ]


>
> I tried subset with
variable1>"0"&variable2>"0", but it wasn't
> useful 'cause
> it only took the rows that didn't have a 0 in any of the variables;  
> I only
> need in ALL of the variables simultaneously.
>
> Thanks,
>
> Ignacio
>
> -- 
> View this message in context:
http://r.789695.n4.nabble.com/How-to-delete-rows-with-specific-values-on-all-columns-variables-tp3318115p3318115.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help at 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.
David Winsemius, MD
West Hartford, CT