Get next month first date based on datetime numpy array

Question

Data

lst=array(['2019-08-30T00:00:00.000000000', '2019-09-30T00:00:00.000000000',
       '2019-10-31T00:00:00.000000000', '2019-11-29T00:00:00.000000000',
       '2020-01-23T00:00:00.000000000', '2020-02-28T00:00:00.000000000'],
      dtype='datetime64[ns]')

Goal

I want to get next month first date for each element in the above array. For example, 2019-08-30T00:00:00.000000000 will be '2019-09-01T00:00:00.000000000',2020-01-23T00:00:00.000000000 will be 2020-02-01T00:00:00.000000000,the final ouput will be dictionary like {'2019-08-30T00:00:00.000000000':'2019-09-01T00:00:00.000000000',……}

Try

It's easy to get by +timedelta(days=1) for some elements, but it's hard for '2020-01-23T00:00:00.000000000' etc.

Paul Panzer · Accepted Answer · 2020-04-16 02:58:16Z

1

You can convert to month units, add one and convert back:

(lst.astype("M8[M]")+1).astype("M8[ns]")
# array(['2019-09-01T00:00:00.000000000', '2019-10-01T00:00:00.000000000',
#        '2019-11-01T00:00:00.000000000', '2019-12-01T00:00:00.000000000',
#        '2020-02-01T00:00:00.000000000', '2020-03-01T00:00:00.000000000'],
#       dtype='datetime64[ns]')

answered Apr 16, 2020 at 2:58

Paul Panzer

53.3k3 gold badges60 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

Get next month first date based on datetime numpy array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related