Converting date and hour into xts R

Question

i have this table of consumptions. I am trying to convert the first two columns into a one xts date format.

1   01.01.2016  00:00:00    26.27724
2   01.01.2016  01:00:00    24.99182
3   01.01.2016  02:00:00    23.53261
4   01.01.2016  03:00:00    22.46478
5   01.01.2016  04:00:00    22.00291
6   01.01.2016  05:00:00    21.95708
7   01.01.2016  06:00:00    22.20354
8   01.01.2016  07:00:00    21.84416

i have tried the code belo and got that error.

timestamp=format(as.POSIXct(paste(datecol,hourcol)), "%d/%m/%Y %H:%M:%S")

Error in as.POSIXlt.character(x, tz, ...) : character string is not in a standard unambiguous format

the date is character and hour is in double format.

Inside your as.POSIXct() you need to set the format for the data as it is converting from (e.g. if your data starts as 2016-01-23 for example, it would need to be as.POSIXct(..., format = "%Y-%m-%d") — rg255

Ronak Shah Ronak Shah · Accepted Answer · 2020-05-06T00:20:20

If you were trying to combine date and time value to create timestamp, we can use as.POSIXct in base R.

df$timestamp <- as.POSIXct(paste(df$datecol,df$hourcol), 
                          format = "%d.%m.%Y %T", tz = "UTC")

Or using lubridate

df$timestamp <- lubridate::dmy_hms(paste(df$datecol,df$hourcol))

Or using anytime

df$timestamp <- anytime::anytime(paste(df$datecol,df$hourcol))

Converting date and hour into xts R

1 Answers