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

Popular posts from this blog

What is happening when Matlab is starting a "parallel pool"? -

angular - DownloadURL return null in below code -

php - Cannot override Laravel Spark authentication with own implementation -