[R] Assigning entries to categories

[LogLord]

Gabor Grothendieck wrote:
> 
> On Mon, Jul 5, 2010 at 8:54 AM, LogLord <nils.schoof at web.de> wrote:
>>
>> OK, thanks for the help!
>>
>> Here a more complex example:
>>
>> a=c("x","y","z")
>> b=c(8,14,19)
>> c=c(200010,535388,19929)
>> data=data.frame(a,b,c)
>>
>> d=c("cat1","cat2","cat3","cat4","cat5","cat6")
>> b1=c(14,5,8,20,19,1)
>> c_start=c(500000,500000,200000,200000,18000,600000)
>> c_stop=c(550000,550000,201000,201000,20000,700000)
>> category=data.frame(d,b1,c_start,c_stop)
>>
>>
>> Again I want to create a new variable, which automatically assigns the
>> category to the data based on matching b = b1 and c  >= c_start and
>> <=c_stop.
>>
> 
> Try this:
> 
>> library(sqldf)
>>
>> sqldf("select data.*, d from data, category where data.b = category.b1
>> and c >= c_start and c <= c_stop")
>   a  b      c    d
> 1 x  8 200010 cat3
> 2 y 14 535388 cat1
> 3 z 19  19929 cat5
> 
> ______________________________________________
> 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.
> 
> 


Great! That's what I need! Seems like I need to extend my sql knowledge
urgently...

Thanks a lot!

-- 
View this message in context: http://r.789695.n4.nabble.com/Assigning-entries-to-categories-tp2272697p2278524.html
Sent from the R help mailing list archive at Nabble.com.