Converting dates, minutes and seconds to ISOdatetime format in R -



Converting dates, minutes and seconds to ISOdatetime format in R -

i have info frame similar dd

dd = data.frame(date = as.date(c("2014-04-29", "2014-04-29","2014-04-29", "2014-04-29", "2014-04-29", "2014-04-29"), format ="%y-%m-%d"), hh = 1:6, mm = seq(0, 50, 10))

i want create new variables, phone call them time1 , time2, where

time1 time of day, irregardless of date, e.g.: in row 1 time1 = 01:00 [hh:mm] no entry seconds time2 date + time1; e.g. row 1 time2 = 2014-04-29 : 01:00

any suggestion appreciated!

using base of operations r

dd$time1 <- format(strptime(paste0(dd$hh, ":", dd$mm), "%h:%m"), "%h:%m") dd$time2 <- format(strptime(paste0(dd$date, ":", dd$hh, ":", dd$mm), "%y-%m-%d:%h:%m"), "%y-%m-%d : %h:%m")

which result in

dd$time1 ## [1] "01:00" "02:10" "03:20" "04:30" "05:40" "06:50" dd$time2 ## [1] "2014-04-29 : 01:00" "2014-04-29 : 02:10" "2014-04-29 : 03:20" "2014-04-29 : 04:30" ##v[5] "2014-04-29 : 05:40" "2014-04-29 : 06:50"

they won't date type though (see @mrflick comment)

r date

Comments

Popular posts from this blog

model view controller - MVC Rails Planning -

ruby on rails - Devise Logout Error in RoR -

html - Submenu setup with jquery and effect 'fold' -