Converting datetime arrays to timestamp Python

Question

Bascially, I have an array of datetime that I want to convert into timestamp, but I'm stuck. Below is my Time array.

Time
Out[31]: 
array([datetime.datetime(2014, 2, 1, 0, 0, 0, 100000),
       datetime.datetime(2014, 2, 1, 0, 0, 0, 300000),
       datetime.datetime(2014, 2, 1, 0, 0, 0, 500000), ...,
       datetime.datetime(2014, 2, 1, 19, 30, 0, 500000),
       datetime.datetime(2014, 2, 1, 19, 30, 0, 700000),
       datetime.datetime(2014, 2, 1, 19, 30, 0, 900000)], dtype=object)

I've tried

x = time.mktime(Time.timetuple())

but I get the error:

'numpy.ndarray' object has no attribute 'timetuple'

Any help would be greatly appreciated.

What do you think the difference is between datetime and timestamp? — Stephen Rauch
– Stephen Rauch ♦, Commented Apr 25, 2017 at 3:20
Isn't timestamp in the form of seconds that has passed since 1970/01/01 ? — alex anderson
– alex anderson, Commented Apr 25, 2017 at 3:27

Bill Bell · Accepted Answer · 2017-04-25 03:41:20Z

1

You could store the datetimes or the timestamps, which are just integers. Here the timestamps are calculated from the datetimes.

>>> from datetime import datetime
>>> dt = datetime(2014, 2, 1, 0, 0, 0, 100000)
>>> T = np.array([dt], dtype=np.datetime64)
>>> import time
>>> ts = int(time.mktime(dt.timetuple()))
>>> T = np.array([ts], dtype=np.int32)

answered Apr 25, 2017 at 3:41

Bill Bell

21.7k6 gold badges48 silver badges62 bronze badges

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

Comments

Robbie · Accepted Answer · 2017-04-25 03:41:27Z

1

You can't use Time.timetuple() because Time is a numpy array. You can just iterate over the array though, like this:

x = [time.mktime(t.timetuple()) for t in Time]

answered Apr 25, 2017 at 3:41

Robbie

4,8922 gold badges21 silver badges25 bronze badges

Collectives™ on Stack Overflow

Converting datetime arrays to timestamp Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related