Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

I have a dataframe (df3) with with some values.

One of these values is the daedlines.

The data of this value is something like the following:

deadline
1419397140
1418994978
1419984000
1418702400

They are days and I want to convert the to using this:

df3$deadline <- as.POSIXct(df3$deadline, origin="1970-01-01")

Generally it was worked for me with other dataframes from other files.

However with this it gives me back this error:

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

How can I fix it?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
743 views
Welcome To Ask or Share your Answers For Others

1 Answer

It might be that you have a character or factor, and it's expecting a numeric vector for conversion from unix time :

as.POSIXct(as.numeric(as.character(df3$deadline)),origin="1970-01-01")

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...