Overview
NumPy implements datetime64 for fixed-point dates and timedelta64 for durations. Unlike Python's standard datetime, NumPy's implementation is "naive" (no timezones) and designed for high-performance vectorized operations on time-series data.
When to Use
- Creating uniform time grids for simulations or financial modeling.
- Calculating business day offsets while accounting for weekends and holidays.
- Performing arithmetic between dates (e.g., finding durations in hours).
- Handling timestamp datasets where timezone complexity is not required.
Decision Tree
- Need to create a sequence of dates?
- Use
np.arange(start, stop, dtype='datetime64[D]').
- Use
- Calculating work deadlines?
- Use
np.busday_offsetwith theholidaysparameter.
- Use
- Converting a duration to a numeric float (e.g., hours)?
- Divide the
timedelta64bynp.timedelta64(1, 'h').
- Divide the
Workflows
-
Generating a Custom Date Range
- Define a start date and end date as strings (e.g., '2023-01-01').
- Use
np.arange(start, end, dtype='datetime64[D]')to create the sequence. - Index the resulting array to select specific dates.
-
Calculating Business Deadlines
- Select a start date.
- Use
np.busday_offset(date, 10, roll='forward')to find the date 10 business days later. - Pass a 'holidays' list to ensure the calculation skips known non-working days.
-
Time-Difference Analysis
- Subtract two
datetime64arrays to get atimedelta64result. - Divide the result by
np.timedelta64(1, 'h')to convert the duration into a float of hours. - Perform statistical analysis (e.g., mean duration) on the numeric result.
- Subtract two
Non-Obvious Insights
- Naive Assumption:
datetime64ignores timezones and assumes 86,400 SI seconds per day, meaning it cannot parse timestamps during positive leap seconds. - Unsafe Casting: Conversion between variable-length units (Months/Years) and fixed-length units (Days) is considered "unsafe" because their relationship changes (leap years, month lengths).
- Precision Mapping: The unit in brackets (e.g.,
[ms],[D]) determines the resolution and the maximum range the timestamp can represent.
Evidence
- "This is a “naive” time, with no explicit notion of timezones or specific time scales." Source
- "Timedelta day unit is equivalent to 24 hours, month and year units cannot be converted directly into days without using ‘unsafe’ casting." Source
Scripts
scripts/numpy-datetime_tool.py: Logic for business day calculations and time delta conversion.scripts/numpy-datetime_tool.js: Simulated ISO date range generator.
Dependencies
numpy(Python)