Gabor Grothendieck wrote: > > 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. > >
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. ______________________________________________ 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.