[R] subset

[Dimitris Rizopoulos]

you have answer it yourself:

x[rowSums(x[,2:4])!=0,]


Best,
Dimitris

----
Dimitris Rizopoulos
Ph.D. Student
Biostatistical Centre
School of Public Health
Catholic University of Leuven

Address: Kapucijnenvoer 35, Leuven, Belgium
Tel: +32/16/336899
Fax: +32/16/337015
Web: http://www.med.kuleuven.ac.be/biostat/
     http://www.student.kuleuven.ac.be/~m0390867/dimitris.htm


----- Original Message ----- 
From: "Rogerio Rosa da Silva" <rrsilva at ib.usp.br>
To: <r-help at stat.math.ethz.ch>
Sent: Wednesday, February 09, 2005 2:52 PM
Subject: [R] subset


> Dear all,
>
> I am trying to extract rows from a data.frame based on the
> rowSums != 0. I want to preserve rownames in the first column in the 
> subset.
>
> Does anyone know how to extract all species that don't have rowSums 
> equal
> to zero?  Here it is:
>
> # dataset
> x <- data.frame(
> species=c("sp.1","sp.2","sp.3","sp.4"),
> site1=c(2,3,0,0),
> site2=c(0,0,0,0),
> site3=c(0,1,0,6),
> site4=c(0,0,0,0))
>
> #I want extract the matrix:
>
> species site1 site2 site3 site4
> sp.1 2 0 0 0
> sp.2 3 0 1 0
> sp.4 0 0 6 0
>
> #extract data.frame of rowSums with x[,2:4] != 0
>
> subset (x, apply (x,1,function(row) all(rowSums(x[,2:4] !=0)) ## 
> don't work
>
>
> Thanks in advance.
>
> -- 
> Rogério R. Silva
> MZUSP http://www.mz.usp.br
> Linux/Debian User # 354364
> Linux counter http://counter.li.org
>
> ______________________________________________
> R-help at 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
>