datediff - R find difference between 2 year-week objects -
i have 2 objects year-week#. i'd find difference between 2 in weeks.
dd1 <- data.frame(date1 = as.date('2015-01-01') + 1:31 , date2 = as.date('2016-03-01') + 1:31 ) dd1$wk1 <- strftime(dd1$date1, format = '%y-%w') dd1$wk2 <- strftime(dd1$date2, format = '%y-%w') dd1$week_diff <- difftime(dd1$wk1, dd1$wk2) error in as.posixlt.character(x, tz, ...) : character string not in standard unambiguous format any suggestions?
note: can't use original date data doesn't include them due aggregation has difference between year_week#'s.
calculate differences in weeks directly on date1 , date2 without converting character.
dd1$week_diff <- difftime(dd1$date1, dd1$date2, units = "weeks") head(dd1) date1 date2 week_diff 1 2015-01-02 2016-03-02 -60.71429 weeks 2 2015-01-03 2016-03-03 -60.71429 weeks 3 2015-01-04 2016-03-04 -60.71429 weeks 4 2015-01-05 2016-03-05 -60.71429 weeks 5 2015-01-06 2016-03-06 -60.71429 weeks 6 2015-01-07 2016-03-07 -60.71429 weeks
Comments
Post a Comment