r - Conversion from character to date/time returns NA -
i use as.posixct
convert characters posixct
, na
, don't know why. example:
date <- "fri apr 10 11:57:47 2015" date_in_posix <- as.posixct(date, format="%a %b %d %h:%m:%s %y")
i tried too:
date_in_posix <- as.posixct(date, format="%a %h %d %h:%m:%s %y")
but result both always:
> date_in_posix [1] na
maybe input as.posixct
long? , when it's long solution?
it's because "fri" , "apr" not correct abbreviations in locale.
use sys.setlocale("lc_time", locale)
set r session's locale 1 correctly interpret english abbreviations. see examples section of ?sys.setlocale
how specify locale
in above function call.
for example, on ubuntu machine be:
> sys.setlocale("lc_time", "en_us.utf-8") > as.posixct("fri apr 10 11:57:47 2015", format="%a %b %d %h:%m:%s %y") [1] "2015-04-10 11:57:47 cdt"
Comments
Post a Comment