How to get week number and year from date in R

r date lubridate iso8601 week-number
Lili picture Lili · Sep 8, 2017 · Viewed 9.5k times · Source

I am trying to get both week number and year from a date object in R.

Until then, I did it separately : I used isoweek() function to extract week and year() function to extract year. So that my data.frame has 3 variables : date, week, year

This is working except for beginning/end of year : for example, 2015 has 53 weeks and January 1st, 2016 belongs to the 53rd week of 2015 ... but with my code, it is such that 1/1/2016 is week 53 but year 2016 whereas I would like it to be week 53 in year 2015.

So is there a way in R to extract week numbers and years that make sense together ?

I know there are lots of questions about this but not found anything on this specific beginning/end of year issue.

Thanks !

Answer

Rui Barradas picture Rui Barradas · Sep 8, 2017

Try this. (Two steps.)

x <- as.Date("1/1/2016", "%d/%m/%Y")
format(x, "%G")
[1] "2015"

format(x, "%V")
[1] "53"

See ?strptime for details.

Related questions

Convert character to class Date

I have a data frame with a character column of dates. When I use as.Date, most of my dates are parsed correctly, except for a few instances. The example below will hopefully show you what is going on. # my …

Read More
How to convert Excel date format to proper date in R

I'm working with a csv which unfortunately has logged datetimes using the number format of 42705 although it should be 01/12/2016. I'd like to convert it to the right format in R using lubridate or some other package. Is there a function …

Read More
lubridate: how to parse month-year?

I have a column of dates as follows, > mymonth = c('10/2015','11/2016','12/2016') > data <- data_frame(mymonth) > data # A tibble: 3 × 1 mymonth <chr> 1 10/2015 2 11/2016 3 12/2016 Here, obviously, my month corresponds to a particular …

Read More