Extract week number from POSIXct object

r date lubridate
Gianluca picture Gianluca · Sep 16, 2014 · Viewed 15.5k times · Source

Is there a function in lubridate to extract the week number? I've tried to search for that but couldn't find anything which serves the purpose.

The week() function does something different.

Description

Date-time must be a POSIXct, POSIXlt, Date, chron, yearmon, yearqtr, zoo, zooreg, timeDate, xts, > its, ti, jul, timeSeries, and fts objects. Weeks is the number of complete seven day periods that have occured between the date and January 1st, plus one. isoweek returns the week as it would appear in the ISO 8601 system, which uses a reoccuring leap week.

Answer

Prasanna Nandakumar picture Prasanna Nandakumar · Sep 16, 2014

Use strftime:

dateRange <- c("2008-10-01","2008-12-01") 
x <- as.POSIXlt(dateRange) 
strftime(x,format="%W") 
[1] "39" "48"

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