Skip to content
Back to formatted view

Raw Message

Message-ID: <15152.37100.97532.274098@gargle.gargle.HOWL>
Date: 2001-06-20T12:02:52Z
From: Peter Holzer
Subject: select cases from a data.frame or matrix
In-Reply-To: <3B30A741.23872.867E0D@localhost>

Till Baumgaertel writes:
 > hi all,
 > 
 > is there a better solution to select rows from a data.frame than by iterating 
 > through the whole set and evaluating every case one by one? 
 > 
 > is there maybe something like:
 > d <- data.frame(...)
 > maleOver40 <- select.data.frame( d, "( sex=m or sex=M) and age > 40)")
 > 
 > of course, i could use direct database-requests, but this would require my data 
 > to be stored in a database...
 > 

maleOver40 <- d[(d$sex == "m" | d$sex == "M") & d$age > 40,]

 > thank you,
 > till
 > 
 > --
 > "I have seen things you people wouldn't believe.
 > Attack-ships  on fire off the shoulder of Orion.
 > I watched seabeams glitter in the dark near the 
 > Tannhauser gate.
 > All  those  moments  will  be lost in time like
 > tears in rain. Time to die."              (Roy)
 > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
 > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
 > Send "info", "help", or "[un]subscribe"
 > (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
 > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._