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?
NumPy allows the subtraction of two datetime values, an operation which produces a number with a time unit. Because NumPy doesn't have a physical quantities system in its core, the timedelta64 data type was created to complement datetime64 .
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')
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With