U f/e(E@sddlmZddlmZmZmZmZddlmZmZm Z ddl Z ddl Z ddl mZmZddlmZddlmZmZmZmZmZmZmZmZmZmZmZmZmZm Z m!Z!ddl"m#Z#dd l$m%Z%dd l&m'Z'm(Z(m)Z)m*Z*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7dd l8m9Z9dd l:m;Z;dd lm?Z?ddl@mAZAmBZCddlDmEZEddlFmGZGddlHmImJZKddlLmMZMddlNmOZOddlPmQZQmRZRmSZSerddlmTZTddlUmVZVddl@mWZWmXZXeddZYddZZdIddZ[GdddeCj\eCj]Z^e dJdd dd!d"d#Z_e dKd$d d%d!d&d#Z_dLd d d%d!d(d#Z_dMd'd'd'd*d d d d*d+d,Z`dNd-d d d d.d/d0Zad d1d2d3Zbd4d4d4d5d6d7Zcd8d9Zdd4d4d:d;d<Zed=d=d4d4d>d?d@ZfdAdAd dBdCdDZgdEdFZhdddeQfdGdHZidS)O) annotations)datetimetime timedeltatzinfo) TYPE_CHECKINGcastoverloadN)libtslib) NDArrayBacked) BaseOffsetNaTNaTType Resolution Timestamp conversionfieldsget_resolutioniNaTints_to_pydatetimeis_date_array_normalizednormalize_i8_timestamps timezones to_offset tzconversion)PerformanceWarning)astype_dt64_to_dt64tz) DT64NS_DTYPE INT64_DTYPE is_bool_dtypeis_categorical_dtypeis_datetime64_any_dtypeis_datetime64_dtypeis_datetime64_ns_dtypeis_datetime64tz_dtypeis_dtype_equalis_extension_array_dtypeis_float_dtypeis_object_dtypeis_period_dtype is_sparseis_string_dtypeis_timedelta64_dtype pandas_dtype)DatetimeTZDtype) ABCMultiIndex)isna)checked_add_with_arr)ExtensionArray datetimelike)generate_regular_range) IntegerArray) extract_array)get_period_alias)BDayDayTick)Literal DataFrame) PeriodArrayTimedeltaArraycCs|dkr tSt|dSdS)z Return a datetime64[ns] dtype appropriate for the given timezone. Parameters ---------- tz : tzinfo or None Returns ------- np.dtype or Datetime64TZDType Ntz)rr/rArC@/tmp/pip-unpacked-wheel-tiezk1ph/pandas/core/arrays/datetimes.py tz_to_dtype_s rEcs fdd}||_||_t|S)Ncs|}|jkrhdrX|j}d}|rD|j}|d|dd}t||j|}n t |}|S|j krt |}|j |dd}nt |}|j |ddd}|S)N)startend Z startingMonthmonth fill_valuefloat64)rKconvert) _local_timestamps _bool_opsendswithfreqkwdsgetrZget_start_end_fieldfreqstrZget_date_field _object_opsget_date_name_field_maybe_mask_results)selfvaluesrQZmonth_kwrRresultfieldrCrDfrs4      z_field_accessor..f)__name____doc__property)namer\Z docstringr]rCr[rD_field_accessorqs rbcseZdZUdZdZeZeej fZ e Z dZ dddddd d gZd ed <d dgZd ed<ddddddddddddddddd d!gZd ed"<d#d$d%gZd ed&<eeeeZd ed'<d(d)d*d+d,d-d.d/d0d1g Zd ed2<d3Zd4ed5<d6Zed6d7fd8d9d:d;Zed6efdfd?d@ Zed6d7dAd8d9dBdCZed6d7d6ejd7d7dDfd8d8d8dEdFdGZeddHdIZdd8dJdKdLdMZ dNdOdPdQZ!dd8dRdSdTZ"dNdOdUdVZ#e$d4dOdWdXZ%e$dYdOdZd[Z&e&j'd\d[Z&e$dYdOd]d^Z(e$d8dOd_d`Z)e$dadOdbdcZ*dde$dtd|rL|}|rZt|}t|ddrztt |jd}tj|||d||_|dkr|dk rt|||dS)NTZ extract_numpyint64na_value_freqrBrAz1Timezone of the array and 'dtype' do not match. '' != ''zUnexpected type 'zY'. 'values' must be a DatetimeArray, ndarray, or Series or Index containing one of those.)z.Only 1-dimensional input arrays are supported.i8zBThe dtype of 'values' is incorrect. Must be 'datetime64[ns]'. Got z instead.inferzTFrequency inference not allowed in DatetimeArray.__init__. Use 'pd.array()' instead.)rYdtype)r7 isinstancer6to_numpyrgetattrtyperBr/r tz_compare TypeErrorrrQ_ndarraynpndarray ValueErrorr^ndimviewr_validate_dt64_dtyperrZtz_standardizer __init__r_validate_frequency)rXrYrrQr inferred_freqdtzmsgrCrCrDrsZ             zDatetimeArray.__init__ np.ndarrayzBaseOffset | None)rYrQreturncs6t|tjst|jtkstt||}||_|SN) rrrAssertionErrorrrsuper _simple_newr)clsrYrQrrZ __class__rCrDrCs zDatetimeArray._simple_newrrcCs|j|||dS)Nr)_from_sequence_not_strict)rZscalarsrrrCrCrD_from_sequenceNszDatetimeArray._from_sequenceraise)rdayfirst yearfirstc  Cs|dk} |tjk r|nd}t|\}} t|||||||d\} }} t|| | \}} | r^d}t|}|j| ||d} | dkr|dk r|j| ||dn| rt | j | _ | S)N)rrrBrr ambiguousrQrr) r no_defaultdtlZmaybe_infer_freqsequence_to_dt64nsZvalidate_inferred_freqrErrrrr)rdatarrrBrQrrrZ explicit_noneZ freq_inferZsubarrrrZrCrCrDrRs,   z'DatetimeArray._from_sequence_not_strictc Cst|}|dkr2tdd|||fDr2tdt||||dkrNtdt|}|dk rft|}|dk rvt|}|tks|tkrtdt | \} } t |||\}}} t |||}|dk r|dkrdn|j } |dkrdn|j }t || |||||}t |||||||}|dk r0t|trN|dk r:|d}|dk rN|d}t|trjt||||}n*t||||d}tjdd |Dtjd }|dk r|j n|j }|d }|j||t|d }|dk rv|j dkrvtj|j|||d }||}|dk r||||j}|dk rv||||j}nFtjd|j|j|dd |j}t|}|j d dd}|j|d|d }| st!|r|d|krt"t#|dd}| st!|r|d|krt"t#|dd}t|}|j|j$||d S)Ncss|]}|dkVqdSrrC.0xrCrCrD sz0DatetimeArray._generate_range..z1Must provide freq argument if no data is suppliedzVOf the four parameters: start, end, periods, and freq, exactly three must be specifiedz$Neither `start` nor `end` can be NaT)rFrGperiodsoffsetcSsg|] }|jqSrC)valuerrCrCrD sz1DatetimeArray._generate_range..rM8[ns]rr nonexistentrrFrr)%rZvalidate_periodsanyrcomZcount_not_nonerrrZvalidate_endpoints_maybe_normalize_endpoints_infer_tz_from_endpointsrB_maybe_localize_pointrr:rr;r5generate_rangerarrayrrrrErtz_localize_to_utcasi8asm8Zlinspacerastypelenrrcr)rrFrGrrQrBrrrclosedZ left_closedZ right_closed _normalizedZstart_tzZend_tzrYZxdrZ_tzindexZarrrrCrCrD_generate_ranges              zDatetimeArray._generate_rangez np.datetime64)setitemrcCs0t||js|tk rtd|j||d|jS)Nz'value' should be a Timestamp.r)r _scalar_typerr_check_compatible_withr)rXrrrCrCrD _unbox_scalarszDatetimeArray._unbox_scalarzTimestamp | NaTType)rcCst||jdSNrA)rrBrXrrCrCrD_scalar_from_stringsz!DatetimeArray._scalar_from_stringrcCsH|tkr dS|||rDt|j|jsDtd|jd|jddS)NzTimezones don't match. 'rr)r_assert_tzawareness_compatrrrBr)rXotherrrCrCrDrs  z$DatetimeArray._check_compatible_withcCs&t||jd}|tk r"||j|Sr)rrBrZ _set_freqrQ)rXrtsrCrCrD _box_funcs zDatetimeArray._box_funccCs|jS)a% The dtype for the DatetimeArray. .. warning:: A future version of pandas will change dtype to never be a ``numpy.dtype``. Instead, :attr:`DatetimeArray.dtype` will always be an instance of an ``ExtensionDtype`` subclass. Returns ------- numpy.dtype or DatetimeTZDtype If the values are tz-naive, then ``np.dtype('datetime64[ns]')`` is returned. If the values are tz-aware, then the ``DatetimeTZDtype`` is returned. )rrXrCrCrDr szDatetimeArray.dtype tzinfo | NonecCst|jddS)z Return timezone, if any. Returns ------- datetime.tzinfo, pytz.tzinfo.BaseTZInfo, dateutil.tz.tz.tzfile, or None Returns None when the array is tz-naive. rBN)rrrrCrCrDrB"s zDatetimeArray.tzcCs tddS)NzNCannot directly set timezone. Use tz_localize() or tz_convert() as appropriate)AttributeErrorrrCrCrDrB/scCs|jS)z( Alias for tz attribute rArrCrCrDr7szDatetimeArray.tzinfocCst|j|jS)zN Returns True if all of the dates are at midnight ("no time") )rrrBrrCrCrD is_normalized>szDatetimeArray.is_normalizedrcCst|j|jSr)rrrBrrCrCrD_resolution_objEszDatetimeArray._resolution_objcs |dkr|jrt}tj|dS)Nr)rBobjectr __array__)rXrrrCrDrLszDatetimeArray.__array__c cs|jdkr(tt|D]}||Vqn|j}t|}d}||d}tbtjdtdt|D]D}||}t|d||}t ||||j |j dd}|EdHqfW5QRXdS)zt Return an iterator over the boxed values Yields ------ tstamp : Timestamp ri'ignore)category timestamp)rBrQboxN) rrangerrwarningscatch_warningsfilterwarnings FutureWarningminrrBrQ) rXirlength chunksizechunksZstart_iZend_iZ convertedrCrCrD__iter__Ss&     zDatetimeArray.__iter__TcCst|}t||jr$|r |S|St|r>> dti = pd.date_range(start='2014-08-01 09:00', ... freq='H', periods=3, tz='Europe/Berlin') >>> dti DatetimeIndex(['2014-08-01 09:00:00+02:00', '2014-08-01 10:00:00+02:00', '2014-08-01 11:00:00+02:00'], dtype='datetime64[ns, Europe/Berlin]', freq='H') >>> dti.tz_convert('US/Central') DatetimeIndex(['2014-08-01 02:00:00-05:00', '2014-08-01 03:00:00-05:00', '2014-08-01 04:00:00-05:00'], dtype='datetime64[ns, US/Central]', freq='H') With the ``tz=None``, we can remove the timezone (after converting to UTC if necessary): >>> dti = pd.date_range(start='2014-08-01 09:00', freq='H', ... periods=3, tz='Europe/Berlin') >>> dti DatetimeIndex(['2014-08-01 09:00:00+02:00', '2014-08-01 10:00:00+02:00', '2014-08-01 11:00:00+02:00'], dtype='datetime64[ns, Europe/Berlin]', freq='H') >>> dti.tz_convert(None) DatetimeIndex(['2014-08-01 07:00:00', '2014-08-01 08:00:00', '2014-08-01 09:00:00'], dtype='datetime64[ns]', freq='H') Nz?Cannot convert tz-naive timestamps, use tz_localize to localizerrQ)r maybe_get_tzrBrrErrrQ)rXrBrrCrCrDrs@  zDatetimeArray.tz_convertcCsd}||krt|tstd|jdk rL|dkrBt|j|j}qjtdnt |}tj |j|||d}| t }t |}d}t|st|dkrt|ds|j}n|dkr|jdkr|j}|j|||dS) a Localize tz-naive Datetime Array/Index to tz-aware Datetime Array/Index. This method takes a time zone (tz) naive Datetime Array/Index object and makes this time zone aware. It does not move the time to another time zone. This method can also be used to do the inverse -- to create a time zone unaware object from an aware object. To that end, pass `tz=None`. Parameters ---------- tz : str, pytz.timezone, dateutil.tz.tzfile or None Time zone to convert timestamps to. Passing ``None`` will remove the time zone information preserving local time. ambiguous : 'infer', 'NaT', bool array, default 'raise' When clocks moved backward due to DST, ambiguous times may arise. For example in Central European Time (UTC+01), when going from 03:00 DST to 02:00 non-DST, 02:30:00 local time occurs both at 00:30:00 UTC and at 01:30:00 UTC. In such a situation, the `ambiguous` parameter dictates how ambiguous times should be handled. - 'infer' will attempt to infer fall dst-transition hours based on order - bool-ndarray where True signifies a DST time, False signifies a non-DST time (note that this flag is only applicable for ambiguous times) - 'NaT' will return NaT where there are ambiguous times - 'raise' will raise an AmbiguousTimeError if there are ambiguous times. nonexistent : 'shift_forward', 'shift_backward, 'NaT', timedelta, default 'raise' A nonexistent time does not exist in a particular timezone where clocks moved forward due to DST. - 'shift_forward' will shift the nonexistent time forward to the closest existing time - 'shift_backward' will shift the nonexistent time backward to the closest existing time - 'NaT' will return NaT where there are nonexistent times - timedelta objects will shift nonexistent times by the timedelta - 'raise' will raise an NonExistentTimeError if there are nonexistent times. Returns ------- Same type as self Array/Index converted to the specified time zone. Raises ------ TypeError If the Datetime Array/Index is tz-aware and tz is not None. See Also -------- DatetimeIndex.tz_convert : Convert tz-aware DatetimeIndex from one time zone to another. Examples -------- >>> tz_naive = pd.date_range('2018-03-01 09:00', periods=3) >>> tz_naive DatetimeIndex(['2018-03-01 09:00:00', '2018-03-02 09:00:00', '2018-03-03 09:00:00'], dtype='datetime64[ns]', freq='D') Localize DatetimeIndex in US/Eastern time zone: >>> tz_aware = tz_naive.tz_localize(tz='US/Eastern') >>> tz_aware DatetimeIndex(['2018-03-01 09:00:00-05:00', '2018-03-02 09:00:00-05:00', '2018-03-03 09:00:00-05:00'], dtype='datetime64[ns, US/Eastern]', freq=None) With the ``tz=None``, we can remove the time zone information while keeping the local time (not converted to UTC): >>> tz_aware.tz_localize(None) DatetimeIndex(['2018-03-01 09:00:00', '2018-03-02 09:00:00', '2018-03-03 09:00:00'], dtype='datetime64[ns]', freq=None) Be careful with DST changes. When there is sequential data, pandas can infer the DST time: >>> s = pd.to_datetime(pd.Series(['2018-10-28 01:30:00', ... '2018-10-28 02:00:00', ... '2018-10-28 02:30:00', ... '2018-10-28 02:00:00', ... '2018-10-28 02:30:00', ... '2018-10-28 03:00:00', ... '2018-10-28 03:30:00'])) >>> s.dt.tz_localize('CET', ambiguous='infer') 0 2018-10-28 01:30:00+02:00 1 2018-10-28 02:00:00+02:00 2 2018-10-28 02:30:00+02:00 3 2018-10-28 02:00:00+01:00 4 2018-10-28 02:30:00+01:00 5 2018-10-28 03:00:00+01:00 6 2018-10-28 03:30:00+01:00 dtype: datetime64[ns, CET] In some cases, inferring the DST is impossible. In such cases, you can pass an ndarray to the ambiguous parameter to set the DST explicitly >>> s = pd.to_datetime(pd.Series(['2018-10-28 01:20:00', ... '2018-10-28 02:36:00', ... '2018-10-28 03:46:00'])) >>> s.dt.tz_localize('CET', ambiguous=np.array([True, True, False])) 0 2018-10-28 01:20:00+02:00 1 2018-10-28 02:36:00+02:00 2 2018-10-28 03:46:00+01:00 dtype: datetime64[ns, CET] If the DST transition causes nonexistent times, you can shift these dates forward or backwards with a timedelta object or `'shift_forward'` or `'shift_backwards'`. >>> s = pd.to_datetime(pd.Series(['2015-03-29 02:30:00', ... '2015-03-29 03:30:00'])) >>> s.dt.tz_localize('Europe/Warsaw', nonexistent='shift_forward') 0 2015-03-29 03:00:00+02:00 1 2015-03-29 03:30:00+02:00 dtype: datetime64[ns, Europe/Warsaw] >>> s.dt.tz_localize('Europe/Warsaw', nonexistent='shift_backward') 0 2015-03-29 01:59:59.999999999+01:00 1 2015-03-29 03:30:00+02:00 dtype: datetime64[ns, Europe/Warsaw] >>> s.dt.tz_localize('Europe/Warsaw', nonexistent=pd.Timedelta('1H')) 0 2015-03-29 03:30:00+02:00 1 2015-03-29 03:30:00+02:00 dtype: datetime64[ns, Europe/Warsaw] )rrZ shift_forwardZshift_backwardzoThe nonexistent argument must be one of 'raise', 'NaT', 'shift_forward', 'shift_backward' or a timedelta objectNz,Already tz-aware, use tz_convert to convert.rrrr )rrrrBrrrrrr!rrrrErrr1rQr)rXrBrrZnonexistent_optionsZ new_datesrrQrCrCrDr_s8     "zDatetimeArray.tz_localizecCst|j|jdS)z Return Datetime Array/Index as object ndarray of datetime.datetime objects. Returns ------- datetimes : ndarray[object] rArrrBrrCrCrD to_pydatetimes zDatetimeArray.to_pydatetimecCs(t|j|j}t||d|jS)a Convert times to midnight. The time component of the date-time is converted to midnight i.e. 00:00:00. This is useful in cases, when the time does not matter. Length is unaltered. The timezones are unaffected. This method is available on Series with datetime values under the ``.dt`` accessor, and directly on Datetime Array/Index. Returns ------- DatetimeArray, DatetimeIndex or Series The same type as the original data. Series will have the same name and index. DatetimeIndex will have the same name. See Also -------- floor : Floor the datetimes to the specified freq. ceil : Ceil the datetimes to the specified freq. round : Round the datetimes to the specified freq. Examples -------- >>> idx = pd.date_range(start='2014-08-01 10:00', freq='H', ... periods=3, tz='Asia/Calcutta') >>> idx DatetimeIndex(['2014-08-01 10:00:00+05:30', '2014-08-01 11:00:00+05:30', '2014-08-01 12:00:00+05:30'], dtype='datetime64[ns, Asia/Calcutta]', freq='H') >>> idx.normalize() DatetimeIndex(['2014-08-01 00:00:00+05:30', '2014-08-01 00:00:00+05:30', '2014-08-01 00:00:00+05:30'], dtype='datetime64[ns, Asia/Calcutta]', freq=None) r)rrrBrZ _with_freqr)rXrrCrCrDrs&zDatetimeArray.normalizer?cCsrddlm}|jdk r"tdt|dkr^|jp4|j}|dkrFtdt |}|dkrZ|}|}|j |j ||jdS)ax Cast to PeriodArray/Index at a particular frequency. Converts DatetimeArray/Index to PeriodArray/Index. Parameters ---------- freq : str or Offset, optional One of pandas' :ref:`offset strings ` or an Offset object. Will be inferred by default. Returns ------- PeriodArray/Index Raises ------ ValueError When converting a DatetimeArray/Index with non-regular values, so that a frequency cannot be inferred. See Also -------- PeriodIndex: Immutable ndarray holding ordinal values. DatetimeIndex.to_pydatetime: Return DatetimeIndex as object. Examples -------- >>> df = pd.DataFrame({"y": [1, 2, 3]}, ... index=pd.to_datetime(["2000-03-31 00:00:00", ... "2000-05-31 00:00:00", ... "2000-08-31 00:00:00"])) >>> df.index.to_period("M") PeriodIndex(['2000-03', '2000-05', '2000-08'], dtype='period[M]') Infer the daily frequency >>> idx = pd.date_range("2017-01-01", periods=2) >>> idx.to_period() PeriodIndex(['2017-01-01', '2017-01-02'], dtype='period[D]') r)r?NzNConverting to PeriodArray/Index representation will drop timezone information.z8You must pass a freq argument as current index has none.rA) pandas.core.arraysr?rBrr UserWarningrTrrr8Z_from_datetime64r)rXrQr?resrCrCrDrGs"-   zDatetimeArray.to_periodr@cCsDtjdtddddlm}|j||j}|d}||S)a5 Calculate TimedeltaArray of difference between index values and index converted to PeriodArray at specified freq. Used for vectorized offsets. Parameters ---------- freq : Period frequency Returns ------- TimedeltaArray/Index zto_perioddelta is deprecated and will be removed in a future version. Use `dtindex - dtindex.to_period(freq).to_timestamp()` insteadr stacklevelrr@zm8[ns]) rrrZpandas.core.arrays.timedeltasr@rrZ to_timestampr)rXrQr@Zi8deltaZm8deltarCrCrDto_perioddeltas  zDatetimeArray.to_perioddeltacCs*|}tj|d|d}|j|dd}|S)a Return the month names of the DateTimeIndex with specified locale. Parameters ---------- locale : str, optional Locale determining the language in which to return the month name. Default is English locale. Returns ------- Index Index of month names. Examples -------- >>> idx = pd.date_range(start='2018-01', freq='M', periods=3) >>> idx DatetimeIndex(['2018-01-31', '2018-02-28', '2018-03-31'], dtype='datetime64[ns]', freq='M') >>> idx.month_name() Index(['January', 'February', 'March'], dtype='object') rlocaleNrJrNrrVrWrXr,rYrZrCrCrDrszDatetimeArray.month_namecCs*|}tj|d|d}|j|dd}|S)a Return the day names of the DateTimeIndex with specified locale. Parameters ---------- locale : str, optional Locale determining the language in which to return the day name. Default is English locale. Returns ------- Index Index of day names. Examples -------- >>> idx = pd.date_range(start='2018-01-01', freq='D', periods=3) >>> idx DatetimeIndex(['2018-01-01', '2018-01-02', '2018-01-03'], dtype='datetime64[ns]', freq='D') >>> idx.day_name() Index(['Monday', 'Tuesday', 'Wednesday'], dtype='object') rr+NrJr-r.rCrCrDrszDatetimeArray.day_namecCs|}t|ddS)zX Returns numpy array of datetime.time. The time part of the Timestamps. rrrNrrXZ timestampsrCrCrDrszDatetimeArray.timecCst|j|jddS)z Returns numpy array of datetime.time also containing timezone information. The time part of the Timestamps. rr/r"rrCrCrDrszDatetimeArray.timetzcCs|}t|ddS)z Returns numpy array of python datetime.date objects (namely, the date part of Timestamps without timezone information). rer/r0r1rCrCrDres zDatetimeArray.dater>cCsHddlm}|}t|}||dddgdd}|jrDd|j|j<|S) a Returns a DataFrame with the year, week, and day calculated according to the ISO 8601 standard. .. versionadded:: 1.1.0 Returns ------- DataFrame with columns year, week and day See Also -------- Timestamp.isocalendar : Function return a 3-tuple containing ISO year, week number, and weekday for the given Timestamp object. datetime.date.isocalendar : Return a named tuple object with three components: year, week and weekday. Examples -------- >>> idx = pd.date_range(start='2019-12-29', freq='D', periods=4) >>> idx.isocalendar() year week day 2019-12-29 2019 52 7 2019-12-30 2020 1 1 2019-12-31 2020 1 2 2020-01-01 2020 1 3 >>> idx.isocalendar().week 2019-12-29 52 2019-12-30 1 2019-12-31 1 2020-01-01 1 Freq: D, Name: week, dtype: UInt32 rr=rmrsrnZUInt32)columnsrN)pandasr>rNrZbuild_isocalendar_sarrayrZilocr)rXr>rYZsarrayZiso_calendar_dfrCrCrD isocalendar s#   zDatetimeArray.isocalendarcCs<tjdtdd|j}|jr0|jdtjdS|jddS)z The week ordinal of the year. .. deprecated:: 1.1.0 weekofyear and week have been deprecated. Please use DatetimeIndex.isocalendar().week instead. zweekofyear and week have been deprecated, please use DatetimeIndex.isocalendar().week instead, which returns a Series. To exactly reproduce the behavior of week and weekofyear and return an Index, you may call pd.Int64Index(idx.isocalendar().week)rr'rL)rrrr) rrrr4rsZhasnansrrnan)rXZ week_seriesrCrCrDrr:s  zDatetimeArray.weekofyearYa The year of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="Y") ... ) >>> datetime_series 0 2000-12-31 1 2001-12-31 2 2002-12-31 dtype: datetime64[ns] >>> datetime_series.dt.year 0 2000 1 2001 2 2002 dtype: int64 Ma The month as January=1, December=12. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="M") ... ) >>> datetime_series 0 2000-01-31 1 2000-02-29 2 2000-03-31 dtype: datetime64[ns] >>> datetime_series.dt.month 0 1 1 2 2 3 dtype: int64 Da The day of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="D") ... ) >>> datetime_series 0 2000-01-01 1 2000-01-02 2 2000-01-03 dtype: datetime64[ns] >>> datetime_series.dt.day 0 1 1 2 2 3 dtype: int64 ha The hours of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="h") ... ) >>> datetime_series 0 2000-01-01 00:00:00 1 2000-01-01 01:00:00 2 2000-01-01 02:00:00 dtype: datetime64[ns] >>> datetime_series.dt.hour 0 0 1 1 2 2 dtype: int64 ma The minutes of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="T") ... ) >>> datetime_series 0 2000-01-01 00:00:00 1 2000-01-01 00:01:00 2 2000-01-01 00:02:00 dtype: datetime64[ns] >>> datetime_series.dt.minute 0 0 1 1 2 2 dtype: int64 sa The seconds of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="s") ... ) >>> datetime_series 0 2000-01-01 00:00:00 1 2000-01-01 00:00:01 2 2000-01-01 00:00:02 dtype: datetime64[ns] >>> datetime_series.dt.second 0 0 1 1 2 2 dtype: int64 usa The microseconds of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="us") ... ) >>> datetime_series 0 2000-01-01 00:00:00.000000 1 2000-01-01 00:00:00.000001 2 2000-01-01 00:00:00.000002 dtype: datetime64[ns] >>> datetime_series.dt.microsecond 0 0 1 1 2 2 dtype: int64 nsa The nanoseconds of the datetime. Examples -------- >>> datetime_series = pd.Series( ... pd.date_range("2000-01-01", periods=3, freq="ns") ... ) >>> datetime_series 0 2000-01-01 00:00:00.000000000 1 2000-01-01 00:00:00.000000001 2 2000-01-01 00:00:00.000000002 dtype: datetime64[ns] >>> datetime_series.dt.nanosecond 0 0 1 1 2 2 dtype: int64 a The day of the week with Monday=0, Sunday=6. Return the day of the week. It is assumed the week starts on Monday, which is denoted by 0 and ends on Sunday which is denoted by 6. This method is available on both Series with datetime values (using the `dt` accessor) or DatetimeIndex. Returns ------- Series or Index Containing integers indicating the day number. See Also -------- Series.dt.dayofweek : Alias. Series.dt.weekday : Alias. Series.dt.day_name : Returns the name of the day of the week. Examples -------- >>> s = pd.date_range('2016-12-31', '2017-01-08', freq='D').to_series() >>> s.dt.dayofweek 2016-12-31 5 2017-01-01 6 2017-01-02 0 2017-01-03 1 2017-01-04 2 2017-01-05 3 2017-01-06 4 2017-01-07 5 2017-01-08 6 Freq: D, dtype: int64 ZdowZdoyz. The ordinal day of the year. qz* The quarter of the date. Zdimz2 The number of days in the month. a Indicates whether the date is the {first_or_last} day of the month. Returns ------- Series or array For Series, returns a Series with boolean values. For DatetimeIndex, returns a boolean array. See Also -------- is_month_start : Return a boolean indicating whether the date is the first day of the month. is_month_end : Return a boolean indicating whether the date is the last day of the month. Examples -------- This method is available on Series with datetime values under the ``.dt`` accessor, and directly on DatetimeIndex. >>> s = pd.Series(pd.date_range("2018-02-27", periods=3)) >>> s 0 2018-02-27 1 2018-02-28 2 2018-03-01 dtype: datetime64[ns] >>> s.dt.is_month_start 0 False 1 False 2 True dtype: bool >>> s.dt.is_month_end 0 False 1 True 2 False dtype: bool >>> idx = pd.date_range("2018-02-27", periods=3) >>> idx.is_month_start array([False, False, True]) >>> idx.is_month_end array([False, True, False]) first)Z first_or_lastlasta Indicator for whether the date is the first day of a quarter. Returns ------- is_quarter_start : Series or DatetimeIndex The same type as the original data with boolean values. Series will have the same name and index. DatetimeIndex will have the same name. See Also -------- quarter : Return the quarter of the date. is_quarter_end : Similar property for indicating the quarter start. Examples -------- This method is available on Series with datetime values under the ``.dt`` accessor, and directly on DatetimeIndex. >>> df = pd.DataFrame({'dates': pd.date_range("2017-03-30", ... periods=4)}) >>> df.assign(quarter=df.dates.dt.quarter, ... is_quarter_start=df.dates.dt.is_quarter_start) dates quarter is_quarter_start 0 2017-03-30 1 False 1 2017-03-31 1 False 2 2017-04-01 2 True 3 2017-04-02 2 False >>> idx = pd.date_range('2017-03-30', periods=4) >>> idx DatetimeIndex(['2017-03-30', '2017-03-31', '2017-04-01', '2017-04-02'], dtype='datetime64[ns]', freq='D') >>> idx.is_quarter_start array([False, False, True, False]) a Indicator for whether the date is the last day of a quarter. Returns ------- is_quarter_end : Series or DatetimeIndex The same type as the original data with boolean values. Series will have the same name and index. DatetimeIndex will have the same name. See Also -------- quarter : Return the quarter of the date. is_quarter_start : Similar property indicating the quarter start. Examples -------- This method is available on Series with datetime values under the ``.dt`` accessor, and directly on DatetimeIndex. >>> df = pd.DataFrame({'dates': pd.date_range("2017-03-30", ... periods=4)}) >>> df.assign(quarter=df.dates.dt.quarter, ... is_quarter_end=df.dates.dt.is_quarter_end) dates quarter is_quarter_end 0 2017-03-30 1 False 1 2017-03-31 1 True 2 2017-04-01 2 False 3 2017-04-02 2 False >>> idx = pd.date_range('2017-03-30', periods=4) >>> idx DatetimeIndex(['2017-03-30', '2017-03-31', '2017-04-01', '2017-04-02'], dtype='datetime64[ns]', freq='D') >>> idx.is_quarter_end array([False, True, False, False]) a~ Indicate whether the date is the first day of a year. Returns ------- Series or DatetimeIndex The same type as the original data with boolean values. Series will have the same name and index. DatetimeIndex will have the same name. See Also -------- is_year_end : Similar property indicating the last day of the year. Examples -------- This method is available on Series with datetime values under the ``.dt`` accessor, and directly on DatetimeIndex. >>> dates = pd.Series(pd.date_range("2017-12-30", periods=3)) >>> dates 0 2017-12-30 1 2017-12-31 2 2018-01-01 dtype: datetime64[ns] >>> dates.dt.is_year_start 0 False 1 False 2 True dtype: bool >>> idx = pd.date_range("2017-12-30", periods=3) >>> idx DatetimeIndex(['2017-12-30', '2017-12-31', '2018-01-01'], dtype='datetime64[ns]', freq='D') >>> idx.is_year_start array([False, False, True]) a{ Indicate whether the date is the last day of the year. Returns ------- Series or DatetimeIndex The same type as the original data with boolean values. Series will have the same name and index. DatetimeIndex will have the same name. See Also -------- is_year_start : Similar property indicating the start of the year. Examples -------- This method is available on Series with datetime values under the ``.dt`` accessor, and directly on DatetimeIndex. >>> dates = pd.Series(pd.date_range("2017-12-30", periods=3)) >>> dates 0 2017-12-30 1 2017-12-31 2 2018-01-01 dtype: datetime64[ns] >>> dates.dt.is_year_end 0 False 1 True 2 False dtype: bool >>> idx = pd.date_range("2017-12-30", periods=3) >>> idx DatetimeIndex(['2017-12-30', '2017-12-31', '2018-01-01'], dtype='datetime64[ns]', freq='D') >>> idx.is_year_end array([False, True, False]) a Boolean indicator if the date belongs to a leap year. A leap year is a year, which has 366 days (instead of 365) including 29th of February as an intercalary day. Leap years are years which are multiples of four with the exception of years divisible by 100 but not by 400. Returns ------- Series or ndarray Booleans indicating if dates belong to a leap year. Examples -------- This method is available on Series with datetime values under the ``.dt`` accessor, and directly on DatetimeIndex. >>> idx = pd.date_range("2012-01-01", "2015-01-01", freq="Y") >>> idx DatetimeIndex(['2012-12-31', '2013-12-31', '2014-12-31'], dtype='datetime64[ns]', freq='A-DEC') >>> idx.is_leap_year array([ True, False, False]) >>> dates_series = pd.Series(idx) >>> dates_series 0 2012-12-31 1 2013-12-31 2 2014-12-31 dtype: datetime64[ns] >>> dates_series.dt.is_leap_year 0 True 1 False 2 False dtype: bool cCst|j}t|j}t|j}|dk}||d8<||d7<|td|ddd|t|dt|d t|d d |j|jd |j d |j d d|j d ddS)z Convert Datetime Array to float64 ndarray of Julian Dates. 0 Julian date is noon January 1, 4713 BC. https://en.wikipedia.org/wiki/Julian_day rrrHiimdigC:A<ii@Biʚ;) rasarrayrmrIrnZfixrrorprqr|r})rXrmrIrnZtestarrrCrCrDto_julian_dateSs@        zDatetimeArray.to_julian_daterint)ddofkeepdimsskipnac Cs2ddlm}||jd}|j||||||dS)Nrr)r)axisroutrJrKrL)r$r@rrstd) rXrMrrNrJrKrLr@ZtdarCrCrDrOvs zDatetimeArray.std)NFrrN)F)F)N)T)rN)rr)N)N)N)NNNrFT)cr^ __module__ __qualname__r_Z_typrrrrrdZ_recognized_scalarsr"Z_is_recognized_dtypeZ_infer_matchesrO__annotations__rUr~rrrZ__array_priority__rrr classmethodrrr rrrrrrrr`rrBsetterrrrrrrrZ ravel_compatr r rrrrrNrrr#rrr*rrrrrer4rrrsrbrmrIrnrorprqr|r}Z_dayofweek_docrvrurtrxrwryrzr{Z _is_month_docrrfrgrhrirjrkrlrHrO __classcell__rCrCrrDrcs "    I , j      L4 )G    . " ,  **,,*%rc.zLiteral[False]r) allow_objectrequire_iso8601rcCsdSrrCrrVrWrCrCrDsequence_to_datetimessrYz Literal[True]znp.ndarray | DatetimeArraycCsdSrrCrXrCrCrDrYsFcCs@t||d|d\}}}|jtkr$|St|}tj|||d}|S)zV Parse/convert the passed data to either DatetimeArray or np.ndarray[object]. TrV allow_mixedrWr)rrrrErcr)rrVrWrZrBrQrZdtarCrCrDrYs  rrZcCsd} t|}t|}t||}t|dsPt|dkr@t|}t|}d}n t |t rdt dn t |dd}t |t r|jdtd }nt |tjtfst|}t |tr|j} t||\}}t|dd} t| st| st| r~d}tj|dd d kr|tj}njt|||||| d \}} |rP| rPt| d |}| t!}n(| r\| }n|rx|j"t#krx|ddfS|j"} t$| rt%||j&}|j'} nt(| rt|d|}|j"t!krt)*|}d}|dk rt|}tj+| d ||d}| t!}|j"t!kst,|j"|} n6|r,t|}|j"t-krH|jtjdd}| t!} |r`| .} t | tjszt,t/| | j"dkst,| j"t||| || fS)af Parameters ---------- data : list-like dtype : dtype, str, or None, default None copy : bool, default False tz : tzinfo, str, or None, default None dayfirst : bool, default False yearfirst : bool, default False ambiguous : str, bool, or arraylike, default 'raise' See pandas._libs.tslibs.tzconversion.tz_localize_to_utc. allow_object : bool, default False Whether to return an object-dtype ndarray instead of raising if the data contains more than one timezone. allow_mixed : bool, default False Interpret integers as timestamps when datetime objects are also present. require_iso8601 : bool, default False Only consider ISO-8601 formats when parsing strings. Returns ------- result : numpy.ndarray The sequence converted to a numpy array with dtype ``datetime64[ns]``. tz : tzinfo or None Either the user-provided tzinfo or one inferred from the data. inferred_freq : Tick or None The inferred frequency of the sequence. Raises ------ TypeError : PeriodDType data is passed NrrFz0Cannot create a DatetimeArray from a MultiIndex.Trrr)rLinteger)rrrVr[rWrrrrr)0rrr!validate_tz_from_dtyper rrlistrGrr0rr7r6rrrr3rcrQmaybe_convert_dtyperr)r,r+r Z infer_dtyperrobjects_to_datetime64nsrrrrrrr%_maybe_infer_tzrBrr#rZensure_datetime64nsrrrrr)rrrrBrrrrVr[rWrZ data_dtype inferred_tzrZrCrCrDrs.                            rr)rrWrVr[c Cs>|dks ttj|dtjd}|j}|jr.dnd} z6tj|d||||||d\} } | j |j | d} Wn|t k r} z^z(      r`rcCst|ds||fSt|jr,|t}d}nt|js@t|jrTtd|jdn`t|jrhtdnLt |jr|j j |j t dj}d}n(t|jrt|jstj|tjd}d}||fS)aN Convert data based on dtype conventions, issuing deprecation warnings or errors where appropriate. Parameters ---------- data : np.ndarray or pd.Index copy : bool Returns ------- data : np.ndarray or pd.Index copy : bool Raises ------ TypeError : PeriodDType data is passed rFzdtype z& cannot be converted to datetime64[ns]zFPassing PeriodDtype data is invalid. Use `data.to_timestamp()` insteadrJr)r r(rrrr-r rr*r! categoriesZtakecodesrZ_valuesr'r%rrri)rrrCrCrDr_s$     r_r)rBrbrcCs<|dkr|}n*|dkrn t||s8td|d||S)aV If a timezone is inferred from data, check that it is compatible with the user-provided timezone, if any. Parameters ---------- tz : tzinfo or None inferred_tz : tzinfo or None Returns ------- tz : tzinfo or None Raises ------ TypeError : if both timezones are present but do not match Nzdata is already tz-aware z, unable to set specified tz: )rrr)rBrbrCrCrDras racCsd|dk r`t|}t|tdr,d}t|t|tjr@|tksPt|tjtfs`td|d|S)a Check that a dtype, if passed, represents either a numpy datetime64[ns] dtype or a pandas DatetimeTZDtype. Parameters ---------- dtype : object Returns ------- dtype : None, numpy.dtype, or DatetimeTZDtype Raises ------ ValueError : invalid dtype Notes ----- Unlike validate_tz_from_dtype, this does _not_ allow non-existent tz errors to go through NZM8zhPassing in 'datetime64' dtype with no precision is not allowed. Please pass in 'datetime64[ns]' instead.zUnexpected value for 'dtype': 'z0'. Must be 'datetime64[ns]' or DatetimeTZDtype'.)r.r&rrrrrr/)rrrCrCrDr s r)rBrcCs|dk rt|tr6zt|}Wntk r4YnXt|dd}|dk rj|dk rft||sftd|}|dk rt |r|dk rt||std|S)aU If the given dtype is a DatetimeTZDtype, extract the implied tzinfo object from it and check that it does not conflict with the given tz. Parameters ---------- dtype : dtype, str tz : None, tzinfo Returns ------- tz : consensus tzinfo Raises ------ ValueError : on tzinfo mismatch NrBz-cannot supply both a tz and a dtype with a tzzHcannot supply both a tz and a timezone-naive dtype (i.e. datetime64[ns])) rstrr/Zconstruct_from_stringrrrrrr#)rrBrrCrCrDr]0 s"  r]r)rFrGrBrc Cszt||}Wn,tk r<}ztd|W5d}~XYnXt|}t|}|dk rx|dk rxt||stdn |dk r|}|S)a If a timezone is not explicitly given via `tz`, see if one can be inferred from the `start` and `end` endpoints. If more than one of these inputs provides a timezone, require that they all agree. Parameters ---------- start : Timestamp end : Timestamp tz : tzinfo or None Returns ------- tz : tzinfo or None Raises ------ TypeError : if start and end timezones do not agree z>Start and end cannot both be tz-aware with different timezonesNz0Inferred time zone not equal to passed time zone)rZ infer_tzinforrr!r)rFrGrBrbrlrCrCrDr_ s     rzTimestamp | None)rFrGrcCsbd}|dk r.|r|}d}n|o,|tk}|dk rX|rH|}d}n|oV|tk}|||fS)NT)rr _midnight)rFrGrrrCrCrDr srcCsV|dkrR|dk rR|dkr|nd}||dd}t|ts>|dkrF||d<|jf|}|S)a Localize a start or end Timestamp to the timezone of the corresponding start or end Timestamp Parameters ---------- ts : start or end Timestamp to potentially localize is_none : argument that should be None is_not_none : argument that should not be None freq : Tick, DateOffset, or None tz : str, timezone object or None ambiguous: str, localization behavior for ambiguous times nonexistent: str, localization behavior for nonexistent times Returns ------- ts : Timestamp NrF)rrrBrB)rr;r)rZis_noneZ is_not_nonerQrBrrZ localize_argsrCrCrDr s  rccsbt|}t|}|tk r|nd}t|}|tk r4|nd}|rR||sR||}n|rj||sj||}|dkr||kr|jdkrd}d}|dkr||d|}|dkr||d|}|}|jdkr||kr^|V||krq^||}||kr td|d|}qnJ||kr^|V||kr2q^||}||krVtd|d|}qdS)a Generates a sequence of dates corresponding to the specified time offset. Similar to dateutil.rrule except uses pandas DateOffset objects to represent time increments. Parameters ---------- start : datetime, (default None) end : datetime, (default None) periods : int, (default None) offset : DateOffset, (default BDay()) Notes ----- * This method is faster for generating weekdays than dateutil.rrule * At least two of (start, end, periods) must be specified. * If both start and end are specified, the returned dates will satisfy start <= date <= end. Returns ------- dates : generator object NrrzOffset z did not increment datez did not decrement date) rrrZ is_on_offsetZ rollforwardrollbacknapplyr)rFrGrrcurZ next_daterCrCrDr sD          r)N)..)..)FF)NFNFFr)FrFFF)j __future__rrrrrtypingrrr rZnumpyrZ pandas._libsr r Zpandas._libs.arraysr Zpandas._libs.tslibsr rrrrrrrrrrrrrrZ pandas.errorsrZpandas.core.dtypes.castrZpandas.core.dtypes.commonrrr r!r"r#r$r%r&r'r(r)r*r+r,r-r.Zpandas.core.dtypes.dtypesr/Zpandas.core.dtypes.genericr0Zpandas.core.dtypes.missingr1Zpandas.core.algorithmsr2r$r3r4rZpandas.core.arrays._rangesr5Zpandas.core.arrays.integerr6Zpandas.core.commoncorecommonrZpandas.core.constructionr7Zpandas.tseries.frequenciesr8Zpandas.tseries.offsetsr9r:r;r<r3r>r?r@rprErbZ TimelikeOpsZ DatelikeOpsrcrYrr`r_rarr]rrrrrCrCrCrDs  D  L            & $\=*/+!