[R] How to delete rows using conditions on all columns
Aher
ajit.aher at cedar-consulting.com
Mon Oct 24 06:28:49 CEST 2011
n <- 10
P1 <- runif(n)
P2 <- runif(n)
P3 <- P1 + P2 + runif(n)/100
P4 <- P1 + P2 + P3 + runif(n)/100
mydata <- data.frame(cbind(P1,P2,P3,P4))
mydata[1,1] <- 8
mydata[3,1] <- -5
mydata[2,3] <- -6
mydata[7,3] <- 7
f=function(z){quantile(z, c(0.01, 0.99)) }
temp1 <- lapply(mydata, f)
temp1
$P1
1% 99%
-4.542391 7.354209
$P2
1% 99%
0.03452814 0.61029804
$P3
1% 99%
-5.423229 6.498828
$P4
1% 99%
0.7825967 2.8454615
I want to remove rows based on the conditions on the columns as stored in
the vector temp1. Any row containing value less than 1% and value greater
than 99% need to be removed for each of the variable.
How this can be achieved.
Thanks for the help in advance.
Regards,
-Aher
--
View this message in context: http://r.789695.n4.nabble.com/How-to-delete-rows-using-conditions-on-all-columns-tp3932027p3932027.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list