Converting two columns of date and time data to one
r
Solution
R> within(df1, { timestamp=format(as.POSIXct(paste(D, Time)), "%d/%m/%Y %H:%M:%S") })
D Time timestamp
1 2012/12/14 18:40:37 14/12/2012 18:40:37
2 2012/12/14 18:40:48 14/12/2012 18:40:48
Problem
I have a simple data frame: ``` D <- c("2012/12/14", "2012/12/14") Time <- c("18:40:37", "18:40:48") df1 <- data.frame(D, Time) ``` I wish to combine the two columns of date and time information into one, preferable in the format of day, month, year, time. How would I go about doing this?