Pandas: timestamp to datetime

Question

I have dataframe and column with dates looks like

I use df['date'] = pd.to_datetime(df.date, format='%Y-%m-%d %H:%M:%S') to convert that, but I'm get strange result

 date 
 1970-01-01 00:00:01.476329529   
 1970-01-01 00:00:01.476329530   
 1970-01-01 00:00:01.476329803  
 1970-01-01 00:00:01.476329805    
 1970-01-01 00:00:01.476329805   
 1970-01-01 00:00:01.476329805

Maybe I did anything wrong

EdChum · Accepted Answer · 2016-10-14 08:17:25Z

20

This looks look epoch timestamps which is number of seconds since 1st January 1970 :

In [71]:
pd.to_datetime(df['date'], unit='s')

Out[71]:
0   2016-10-13 03:32:09
1   2016-10-13 03:32:10
2   2016-10-13 03:36:43
3   2016-10-13 03:36:45
4   2016-10-13 03:36:45
5   2016-10-13 03:36:45
Name: date, dtype: datetime64[ns]

answered Oct 14, 2016 at 8:17

EdChum

397k204 gold badges836 silver badges583 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Baobab Over a year ago

Hello, for me this is still defaulting 1970. What is the problem?

user108569 Over a year ago

check your units. pd now defaults to nanoseconds if you don't specify units

milos.ai · Accepted Answer · 2016-10-14 08:16:07Z

2

Something like this maybe:

import datetime
date = datetime.datetime.fromtimestamp(1476329529)
date
# gives
# datetime.datetime(2016, 10, 13, 5, 32, 9)

str(date) # '2016-10-13 05:32:09'

answered Oct 14, 2016 at 8:16

milos.ai

3,9287 gold badges34 silver badges33 bronze badges

Collectives™ on Stack Overflow

Pandas: timestamp to datetime

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related