r - Adding column with condition using data.table -



r - Adding column with condition using data.table -

suppose have next data.table:

date=c("2014-02-06","2014-02-06","2014-03-01","2014-03-01","2014-03-28","2014-04-25","2014-04-25") departure=c("ny", "ny", "doha", "tokyo", "paris", "tokyo", "tokyo") arrival=c("milano", "beijing", "moscow", "moscow", "singapore", "yaounde", "milano") dt<-data.table(date, departure, arrival)

giving result:

date departure arrival 1: 2014-02-06 ny milano 2: 2014-02-06 ny beijing 3: 2014-03-01 doha moscow 4: 2014-03-01 tokyo moscow 5: 2014-03-28 paris singapore 6: 2014-04-25 tokyo yaounde 7: 2014-04-25 tokyo milano

now have date:

lawdate="2014-03-17"

and want add together column named "law" in dt such if date>lawdateit contains true, false otherwise. doing moment not know if efficient way ... since table dt extremely big ...

my current solution ... not know if there improve way data.table ..

dt$law = ifelse(date>lawdate, true, false)

dt[, law:=false][date>lawdate, law:=true]

or shorter

dt[, law:=date>lawdate]

kind greetings

r data.table

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

c# - Create a Notification Object (Email or Page) At Run Time -- Dependency Injection or Factory -

c# - Create a Notification Object (Email or Page) At Run Time -- Dependency Injection or Factory - i have code emails me notification when happens. trying add together page , also remove dependency on email. for reference; have name of notification want send stored string in database. @ runtime have list of people , string representation of want receive. i thought dependency injection ninject, kernel bindings got big , seemed hacking together. then thought simple factory, activator.createinstance(email/page) inotifcation, don't know how handle differing constructor parameters (unless utilize common, complex property, employee, has info need). so far have this: public interface inotification { void sendmessage(); } public class email: inotification { private readonly string _toemailaddress; private string body { { homecoming "email"; } } private static string smtphost { ...
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more