3

How can I convert a "string" dataframe column attr_date into datetime when my hour can be one digit length too (eg.: 2012.01.01 9:00:00)? The following code returns only with the date part without time part:

df[['attr_date']] <- as.Date(df[['attr_date']], format='%Y.%m.%d  %H:%M:%S')

So the result of 2012.01.01 9:00:00 is 2012-01-01.

Bonus question: Using Anaconda R Essentials, in Jupyter R Notebook why I get 15340.00 as the result of 2012.01.01 9:00:00 when I use the above code?

Thank you!

ragesz
  • 9,009
  • 20
  • 71
  • 88

1 Answers1

9

Try using strptime instead:

df[['attr_date']] <- strptime(df[['attr_date']], format='%Y.%m.%d  %H:%M:%S')
Matt Sandgren
  • 476
  • 1
  • 4
  • 10