UFuncTypeError When adding two datetime dates

user_5346843 0
Viewed 52

I am trying to read some date info from Excel using openpyxl which returns them as datetime.datetime. I need to resample the data and then plot the resampled times using matplotlib. I would like an array of dates starting at tmin, incremented by 30.0 days. The code stub is

import numpy as np
import datetime

vals = [
datetime.date.fromisoformat('2004-06-01'),
datetime.date.fromisoformat('2004-07-01'),
datetime.date.fromisoformat('2004-08-01'),
datetime.date.fromisoformat('2004-09-01'),
datetime.date.fromisoformat('2004-10-01'),
datetime.date.fromisoformat('2004-11-01')]

xtim = np.array(vals)
tmin = np.min(xtim)

ytim = np.arange(0.0, 150.0, 30.0)
tnew = tmin + ytim.astype('timedelta64[D]')

Unfortunately, this gives me the error message

UFuncTypeError: ufunc 'add' cannot use operands with types dtype('O') and dtype('<m8[D]')
numpy datetime python
2 Answers

You should wrap tmin in an array with 'datetime64' type:

np.array(tmin, dtype='datetime64') + ytim.astype('timedelta64[D]')

output: array(['2004-06-01', '2004-07-01', '2004-07-31', '2004-08-30', '2004-09-29'], dtype='datetime64[D]')

user_163434640

To add 30 days I'd suggest using datetime.timedelta(days=30).
For example as:

import numpy as np
import datetime

vals = [
    datetime.date.fromisoformat('2004-06-01'),
    datetime.date.fromisoformat('2004-07-01'),
    datetime.date.fromisoformat('2004-08-01'),
    datetime.date.fromisoformat('2004-09-01'),
    datetime.date.fromisoformat('2004-10-01'),
    datetime.date.fromisoformat('2004-11-01')]

xtim = np.array(vals)
tmin = np.min(xtim)


t_new=[tmin+datetime.timedelta(days=i) for i in np.arange(0.0, 150.0, 30.0)]
user_157851780
Related