Skip to content

BUG: datetime with datetime ops very slow #5801

Closed
@jreback

Description

@jreback
In [1]: df = pd.DataFrame({ 'date1' : pd.Timestamp('20130101'), 'date2' : pd.date_range('20120101',periods=1000000,freq='s') })

In [2]: %timeit df['date1']-df['date2']
1 loops, best of 3: 2.17 s per loop

pretty easy fix; don't need to infer if its a series (as we know its dtype already)

should be more like this

In [3]: %timeit Series(df['date1'].astype('int64')-df['date2'].astype('int64'),dtype='m8[ns]')
10 loops, best of 3: 43 ms per loop

Metadata

Metadata

Assignees

No one assigned

    Labels

    DatetimeDatetime data dtypePerformanceMemory or execution speed performanceTimedeltaTimedelta data type

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions