How to convert numpy.timedelta64 to minutes

numpy pandas string-to-datetime

Behzad Shahbaz · Oct 25, 2014 · Viewed 20.3k times · Source

I have a date time column in a Pandas DataFrame and I'd like to convert it to minutes or seconds.

For example: I want to convert 00:27:00 to 27 mins.

example = data['duration'][0]
example

result: numpy.timedelta64(1620000000000,'ns')

What's the best way to achieve this?

Answer

Use array.astype() to convert the type of an array safely:

>>> import numpy as np
>>> a = np.timedelta64(1620000000000,'ns')
>>> a.astype('timedelta64[m]')
numpy.timedelta64(27,'m')