Dealing with timestamps in R

by

You want the (standard) POSIXt type from base R that can be had in ‘compact form’ as a POSIXct (which is essentially a double representing fractional seconds since the epoch) or as long form in POSIXlt (which contains sub-elements). The cool thing is that arithmetic etc are defined on this — see help(DateTimeClasses)

Quick example:

R> now <- Sys.time()
R> now
[1] "2009-12-25 18:39:11 CST"
R> as.numeric(now)
[1] 1.262e+09
R> now + 10  # adds 10 seconds
[1] "2009-12-25 18:39:21 CST"
R> as.POSIXlt(now)
[1] "2009-12-25 18:39:11 CST"
R> str(as.POSIXlt(now))
 POSIXlt[1:9], format: "2009-12-25 18:39:11"
R> unclass(as.POSIXlt(now))
$sec
[1] 11.79

$min
[1] 39

$hour
[1] 18

$mday
[1] 25

$mon
[1] 11

$year
[1] 109

$wday
[1] 5

$yday
[1] 358

$isdst
[1] 0

attr(,"tzone")
[1] "America/Chicago" "CST"             "CDT"            
R>

As for reading them in, see help(strptime)

As for difference, easy too:

R> Jan1 <- strptime("2009-01-01 00:00:00", "%Y-%m-%d %H:%M:%S")
R> difftime(now, Jan1, unit="week")
Time difference of 51.25 weeks
R>

Lastly, the zoo package is an extremely versatile and well-documented container for matrix with associated date/time indices.

More Related Contents:

  1. Convert hour:minute:second (HH:MM:SS) string to proper time class
  2. Measuring function execution time in R
  3. Convert UNIX epoch to Date object
  4. Display a time clock in the R command line
  5. R: How to handle times without dates?
  6. Extracting time from POSIXct
  7. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  8. Join R data.tables where key values are not exactly equal–combine rows with closest times
  9. Subset xts object by time of day
  10. R group by date, and summarize the values
  11. How to convert time (mm:ss) to decimal form in R
  12. How convert decimal to POSIX time
  13. Join two data frames in R based on closest timestamp
  14. How can I change XTS to data.frame and keep Index?
  15. Convert hours:minutes:seconds to minutes
  16. Time series plot gets offset by 2 hours if scale_x_datetime is used
  17. Convert decimal day to HH:MM
  18. R issue with rounding milliseconds
  19. Create a time interval of 15 minutes from minutely data in R?
  20. ggplot2: histogram with normal curve
  21. Remove quotes from a character vector in R
  22. Collapse rows with overlapping ranges
  23. Joining aggregated values back to the original data frame [duplicate]
  24. How to avoid: read.table truncates numeric values beginning with 0
  25. R – converting date and time fields to POSIXct with HHMMSS format
  26. How to select last N observation from each group in dplyr dataframe?
  27. Seeking workaround for gtable_add_grob code broken by ggplot 2.2.0
  28. Perform multiple paired t-tests based on groups/categories
  29. Quantmod Error ‘cannot open URL’
  30. R Warning ‘length(x) = 2 > 1’ in coercion to ‘logical(1)’

Leave a Comment