On Mon, Jul 5, 2010 at 8:54 AM, LogLord <nils.sch...@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@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.
