R – converting date and time fields to POSIXct with HHMMSS format

by

You were very close. The following “simply” forces the first two columns to be read as character strings, which saves the leading zeros.

R> df <- read.table(text="20010101 000000  0.833
20010101 000500  0.814
20010101 001000  0.794
20010101 001500  0.772", 
+ header=FALSE, colClasses=c("character", "character", "numeric"), 
+ col.names=c("Date", "Time", "Val"))
R> df
      Date   Time   Val
1 20010101 000000 0.833
2 20010101 000500 0.814
3 20010101 001000 0.794
4 20010101 001500 0.772

Now what you were attempting “just works”:

R> df$DateTime <- as.POSIXct(paste(df$Date, df$Time), format="%Y%m%d %H%M%S")
R> df
      Date   Time   Val            DateTime
1 20010101 000000 0.833 2001-01-01 00:00:00
2 20010101 000500 0.814 2001-01-01 00:05:00
3 20010101 001000 0.794 2001-01-01 00:10:00
4 20010101 001500 0.772 2001-01-01 00:15:00
R>

More Related Contents:

  1. Converting numeric time to datetime POSIXct format in R
  2. R datetime series missing values
  3. Round a POSIX date (POSIXct) with base R functionality
  4. How to calculate time difference with previous row of a data.frame by group
  5. How to prevent ifelse() from turning Date objects into numeric objects
  6. strptime, as.POSIXct and as.Date return unexpected NA
  7. Looping over a Date or POSIXct object results in a numeric iterator
  8. How to flatten / merge overlapping time periods
  9. How R formats POSIXct with fractional seconds
  10. Split date-time column into Date and time variables
  11. efficiently generate a random sample of times and dates between two dates
  12. Split time series data into time intervals (say an hour) and then plot the count
  13. calculating time difference in R
  14. Date conversion from POSIXct to Date in R
  15. Convert seconds to days: hours:minutes:seconds
  16. Understanding dates and plotting a histogram with ggplot2 in R
  17. How to join two dataframes by nearest time-date?
  18. Rounding time to nearest quarter hour
  19. Milliseconds in POSIXct Class
  20. Change day of the month in a Date to first day (01)
  21. Handling dates when we switch to daylight savings time and back
  22. Checking if Date is Between two Dates in R
  23. Join two data frames in R based on closest timestamp
  24. extract hours and seconds from POSIXct for plotting purposes in R
  25. Convert hours:minutes:seconds to minutes
  26. R: merge two irregular time series
  27. Convert Factor to Date/Time in R
  28. R: convert date from character to datetime [duplicate]
  29. Character POSIXct Conversion in R causes wrong timezone values on daylight saving time transition (CEST/CET))
  30. Convert decimal day to HH:MM

Leave a Comment