numpypandasstring-to-datetime

How to convert numpy.timedelta64 to minutes

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?

Solution

  • 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')