j UddlmZddlmZddlmZddlmZddlm Z ddl m Z m Z m Z mZmZmZddlZddlZddlmZmZdd lmZmZmZmZmZmZmZmZ dd l!m"Z"dd l#m$Z$m%Z%dd l&m'Z'dd l(m)Z)m*Z*m+Z+ddl,m-Z-ddl.m/Z/ddl0m1Z1m2Z2m3Z3m4Z4m5Z5m6Z6m7Z7ddl8m9Z9m:Z:ddl;mm?Z?m@Z@mAZAddlBmCZCddlDmEZEddlFmGZGddlHmIZImJZJmKZKddlLmMZMddlNmOZOddlPmQZQe r"ddlRmSZSmTZTddlUmVZVddlWmXZXddl(mYZYddlZm[Z[m\Z\e]e^ze)zZ_d e`d!<eaebzZcd e`d"<ecezejdzZed e`d#<eee_zZfd e`d$<e]ece^ecd%fze)zZgd e`d&<Gd'd(e d)*ZhGd+d,ehd-*Zieeid.fZjd/Zkd~dd4Zl ddd<ZmddBZn dddIZo dddKZp dddRZqddUZrddVZsdWZte dddYZue ddd[Zue ddd^Zue-d_dLd-d-d-dejvdd`d)f ddeZuidfdfdgdfdhdhdidhdjdjdkdjdldmdndmdodpdqdpdrdsdtdsdududvdudwdudxdxdydxdxdzdzdzd{Zwdd|Zxgd}ZydS)) annotations)abc)date)partial)islice) TYPE_CHECKING TypeAlias TypedDictUnioncastoverloadN)libtslib)NaTOutOfBoundsDatetime Timedelta Timestampastype_overflowsafeget_supported_dtypeis_supported_dtype timezones)cast_from_unit_vectorized)DateParseErrorguess_datetime_format)array_strptime) AnyArrayLike ArrayLikeDateTimeErrorChoices) set_module)find_stack_level) ensure_objectis_floatis_float_dtype is_integeris_integer_dtype is_list_likeis_numeric_dtype) ArrowDtypeDatetimeTZDtype) ABCDataFrame ABCSeries) DatetimeArray IntegerArrayNumpyExtensionArray)unique)ArrowExtensionArray)ExtensionArray)maybe_convert_dtypeobjects_to_datetime64 tz_to_dtype) extract_array)Index) DatetimeIndex)CallableHashable)NaTType) UnitChoices)TimeUnit) DataFrameSeriesr ArrayConvertibleScalarDatetimeScalar DatetimeScalarOrArrayConvertible.DatetimeDictArgc.eZdZUded<ded<ded<dS)YearMonthDayDictrCyearmonthdayN__name__ __module__ __qualname____annotations__IC:\Projects\DSCons\.venv\Lib\site-packages\pandas\core\tools\datetimes.pyrErEls6rOrET)totalcjeZdZUded<ded<ded<ded<ded<ded<ded<ded <ded <d S) FulldatetimeDictrChourhoursminuteminutessecondsecondsmsusnsNrIrNrOrPrSrSrs~rOrSFr=2dayfirst bool | Nonereturn str | Nonec6tj|x}dkr~t||x}tur`t ||}||Stj||dzddkr(t jdttdS)Nr^zCould not infer format, so each element will be parsed individually, falling back to `dateutil`. To ensure parsing is consistent and as-expected, please specify a format.) stacklevel) rfirst_non_nulltypestrrwarningswarn UserWarningr )arrr^rgfirst_non_nan_elementguessed_formats rP _guess_datetime_format_for_arrayrps.s333:: ^)<<% = = D D2%N)%%#C(:(<(<$=>>"DD K /11  4rOffffff?arg unique_sharefloat check_count int | Noneboolcd}|Ct|tkrdSt|dkrt|dz}n1d}n.d|cxkrt|ks nJd|dkrdSd|cxkrd ks nJd  tt||}n#t$rYdSwxYwt|||zkrd}|S) a Decides whether to do caching. If the percent of unique elements among `check_count` elements less than `unique_share * 100` then we can do caching. Parameters ---------- arg: listlike, tuple, 1-d array, Series unique_share: float, default=0.7, optional 0 < unique_share < 1 check_count: int, optional 0 <= check_count <= len(arg) Returns ------- do_caching: bool Notes ----- By default for a sequence of less than 50 items in size, we don't do caching; for the number of elements less than 5000, we take ten percent of all elements to check for a uniqueness share; if the sequence size is more than 5000, then we check only the first 500 elements. All constants were chosen empirically by. TNFi irz1check_count must be in next bounds: [0; len(arg)]rez+unique_share must be in next bounds: (0; 1))lenstart_caching_atsetr TypeError)rrrsru do_cachingunique_elementss rP should_cachers*:J s88' ' '5 s88t  c((b.KKKKK++++3s88+++++ ?,++ !  5 |    a     !N   fS+6677 uu ?kL888 sB.. B<;B<formatcacheconvert_listliker8r>cddlm}|t}|rt|s|St |t jtttfst j |}t|}t|t|krZ|||} |||d}n#t$r|cYSwxYw|jjs ||j}|S)a Create a cache of unique dates from an array of dates Parameters ---------- arg : listlike, tuple, 1-d array, Series format : string Strftime format to parse time cache : bool True attempts to create a cache of converted values convert_listlike : function Conversion function to apply on dates Returns ------- cache_array : Series Cache of converted, unique dates. Can be empty rr>dtypeF)indexcopy)pandasr>objectr isinstancenpndarrayr1r6r+arrayr/rzrr is_unique duplicated)rrrrrr> cache_array unique_dates cache_datess rP _maybe_cachers0&v&&&K KC    # NE9MNN (3--Cc{{ |  s3xx ' '**<@@K #$f[ 5QQQ & # # #"""" #$. K);+<+G+G+I+I*IJ s(B77 CCdt_arrayrutcnameHashable | Noner6ctj|jdr|rdnd}t|||St |||jS)a  Properly boxes the ndarray of datetimes to DatetimeIndex if it is possible or to generic Index instead Parameters ---------- dt_array: 1-d array Array of datetimes to be wrapped in an Index. utc : bool Whether to convert/localize timestamps to UTC. name : string, default None Name for a resulting index Returns ------- result : datetime of converted dates - DatetimeIndex if convertible to sole datetime64 type - general Index otherwise MrNtzr)rr)r is_np_dtyperr7r6)rrrrs rP_box_as_indexliker sT. x~s++9 #UUtX"48888 HN ; ; ;;rOrcddlm}|||jj|}t |jd|S)a Convert array of dates with a cache and wrap the result in an Index. Parameters ---------- arg : integer, float, string, datetime, list, tuple, 1-d array, Series cache_array : Series Cache of converted, unique dates name : string, default None Name for a DatetimeIndex Returns ------- result : Index-like of converted dates rrrFrr)rr>rrmapr_values)rrrrr>results rP_convert_and_box_cacher'sU( VC{06 7 7 7 ; ;K H HF V^T B B BBrOraiseuniterrorsr yearfirstexactc Bt|ttfrtj|d}n)t|t rtj|}t |dd} |rdnd} t| trZt|ttfst|| |S|r(| d d}|St| tr| j tur|rt|trct!t"|j} | jj| d} n| d} t| d }n7| jj|d}n|d}|St-j| d rt1| s:t3tj|tjd |d k }t|ttfst|| |S|r| dS|S|$|t9dt;|||||St |dddkrt=d t?|dtAj!| \}} n]#t<$rP|d krHtj"tG|tj$dd} t| |cYSwxYwtK|}|tM||}||dkrtO||||||StQ|||||d\}}|tj)|jd}t!d|}tU||}|+d|j,d}tj-||}tj-||St]|||S)a Helper function for to_datetime. Performs the conversions of 1D listlike of dates Parameters ---------- arg : list, tuple, ndarray, Series, Index date to be parsed name : object None or string for the Index name utc : bool Whether to convert/localize timestamps to UTC. unit : str None or string of the frequency of the passed data errors : str error handing behaviors from to_datetime, 'raise', 'coerce' dayfirst : bool dayfirst parsing behavior from to_datetime yearfirst : bool yearfirst parsing behavior from to_datetime exact : bool, default True exact format matching behavior from to_datetime Returns ------- Index-like of parsed dates OrrNrrUTCFrrzM8[s]coerce) is_coercez#cannot specify both format and unitndimrezAarg must be a string, datetime, list, tuple, 1-d array, or Series)rrrr\rrdmixedT)r^rrr allow_objectrr<M8[]r)/rlisttuplerrr.getattrr)r,r7 tz_convert tz_localizer(rhrr6r r0 pyarrow_dtyper_dt_tz_convert_dt_tz_localizerrrrasarrayr ValueError_to_datetime_with_unitr}r2 libtimezones maybe_get_tzfullrz datetime64r!rp_array_strptime_with_fallbackr3 datetime_datar4viewr _simple_newr)rrrrrrrr^rr arg_dtyper arg_array_npvaluesr tz_parsedout_unitr dt64_valuesdtas rP_convert_listlike_datetimesrAsPL#e}%%hs#&&& C, - -hsmmWd++I 4B)_--1 # }=>> 8 $777 7  :..&&22599C Iz * ** y~/J/J  1#u%% 1 !4ci@@ *-9 ) 8 8 ? ?II ) 9 9% @ @IIE222(+7((//))%00 C ( ( !),, % 3!! H,C # }=>> * $777 7  *??5)) )   BCC C%c4sFCCC fa 1 $ $ O   $Su9RSU9V9VWWWQQ  X  ws3xxud)C)CDDH 555 5 5 5    C ~1#IIIf//,S$VUFSSS-   FI#FL11!4 H--Ix00kk"5 "5"5"566 ' 5AAA(48888 V4 8 8 88s)'KAL+)L+fmtrict|||||\}}|tj|jd}t d|}t ||} t j|| } |r| d} t| |d S|jtkrJ|rHtj|jd}t d|}t|d |d |d } | St||j|d S) zL Call array_strptime, with fallback behavior depending on 'errors'. )rrrNrr<)rrrrF)rrrz, UTC])rrr) rrrrr r)r,rrr6r) rrrrrrrrtz_outrrrress rPrrs$CE&cRRRNFF  --a0J%%6555'e<<<  (..''CSt%0000   C  --a0J%%F"4"4"4"44eLLL v|$U C C CCrOc @t|d}t|tr|d|d}d}nVt j|}|jjdvr|d|dd}t|j} t||d}nD#t$r7|d kr|t}t|||||cYSwxYwd}n|jjd krat j d 5|tj}dddn #1swxYwYt j|} | ||kzr%t||||| } t"| j| <| St j d 5 t'||}nh#t$r[} |d krT ! !**24222*??C' 22E L)#u5AAA& L L LW$$jj((-c4sFKKKKK  L II Y^s " "X... 2 2 ZZ11  2 2 2 2 2 2 2 2 2 2 2 2 2 2 28C==Dz)*//11 0T#f&) T" '***   3CdCCCCC*((5JJv..dC          .B4BBB                ((8$$CII**V%*00C"4"& NC3T * * *F fm , ,    & & 1 1) < C*)C* EE E7I9G  I H00H+H0IH++H00IIIc|dkr|}td}|dkrtd ||z }n"#t$r}td|d}~wwxYwtj|z }tj|z }t j||kst j||krt|dnvt|sFt|s7tt j |std|d |d  tj |stj |rt|| }nt|}nG#t$r}td |d |d}~wt$r}td |d|d}~wwxYw|jtd|d|tdz } | td| z} t!|r;t#|t$t&t jfst j |}|| z}|S)a Helper function for to_datetime. Adjust input argument to the specified origin Parameters ---------- arg : list, tuple, ndarray, Series, Index date to be adjusted origin : 'julian' or Timestamp origin offset for the arg unit : str passed unit from to_datetime, must be 'D' Returns ------- ndarray or scalar of adjusted date(s) julianrDz$unit must be 'D' for origin='julian'z3incompatible 'arg' type for given 'origin'='julian'Nz% is Out of Bounds for origin='julian'rz!' is not compatible with origin='z+'; it must be numeric with a unit specifiedrzorigin z is Out of Boundsz# cannot be converted to a Timestampzorigin offset z must be tz-naivere)rto_julian_daterr}maxminranyrr$r"r'rrrrr&rr+r6r) rroriginroriginalj0rj_maxj_minoffset td_offsetioffsets rP_adjust_to_originr7s$ q\\ ( ( * * 3;;CDD D (CC   E    ,,..3 ,,..3 6#+   "&u"5"5 %BBB  __  (  2B2:c??2S2S ;C;;&;;;  ~f%% +f)=)= +"6555"6**" T T T%&I&I&I&IJJPS S   E&EEE   9 GfGGGHH HYq\\) y6666    "Zi 5S%T%T "*S//CGm Js=A A%A  A%A F GF,, G9G  Grc dSNrN rrrr^rrrrrrrs rP to_datetimers rOSeries | DictConvertiblec dSrrNrs rPrrs SrO list | tuple | Index | ArrayLiker7c dSrrNrs rPrrs CrOrunix2DatetimeScalarOrArrayConvertible | DictConvertiblebool | lib.NoDefaultr1DatetimeIndex | Series | DatetimeScalar | NaTTypec |tjur|dvrtd|tS|dkrt |||}t t ||||||} t|tr9|} |r3|j | d} n:| d} n#t|tret||| | } | js|| } n| |j|} || |j|j} nt|t(t*jfrt/|||} nut|t0rGt||| | } | jst3|| |j} n.| |||j} nt5|r t7t8t:t<t>t@j!d t0f|}t||| | } n/#tD$r"|d krd d l#m$}|gtJ } YnwxYw| jst3|| } np| ||} nc| tAj&|g|d } t|tNr)t| t@j(rtO| } | S)aE5 Convert argument to datetime. This function converts a scalar, array-like, :class:`Series` or :class:`DataFrame`/dict-like to a pandas datetime object. Parameters ---------- arg : int, float, str, datetime, list, tuple, 1-d array, Series, DataFrame/dict-like The object to convert to a datetime. If a :class:`DataFrame` is provided, the method expects minimally the following columns: :const:`"year"`, :const:`"month"`, :const:`"day"`. The column "year" must be specified in 4-digit format. errors : {'raise', 'coerce'}, default 'raise' - If :const:`'raise'`, then invalid parsing will raise an exception. - If :const:`'coerce'`, then invalid parsing will be set as :const:`NaT`. dayfirst : bool, default False Specify a date parse order if `arg` is str or is list-like. If :const:`True`, parses dates with the day first, e.g. :const:`"10/11/12"` is parsed as :const:`2012-11-10`. .. warning:: ``dayfirst=True`` is not strict, but will prefer to parse with day first. yearfirst : bool, default False Specify a date parse order if `arg` is str or is list-like. - If :const:`True` parses dates with the year first, e.g. :const:`"10/11/12"` is parsed as :const:`2010-11-12`. - If both `dayfirst` and `yearfirst` are :const:`True`, `yearfirst` is preceded (same as :mod:`dateutil`). .. warning:: ``yearfirst=True`` is not strict, but will prefer to parse with year first. utc : bool, default False Control timezone-related parsing, localization and conversion. - If :const:`True`, the function *always* returns a timezone-aware UTC-localized :class:`Timestamp`, :class:`Series` or :class:`DatetimeIndex`. To do this, timezone-naive inputs are *localized* as UTC, while timezone-aware inputs are *converted* to UTC. - If :const:`False` (default), inputs will not be coerced to UTC. Timezone-naive inputs will remain naive, while timezone-aware ones will keep their time offsets. Limitations exist for mixed offsets (typically, daylight savings), see :ref:`Examples ` section for details. See also: pandas general documentation about `timezone conversion and localization `_. format : str, default None The strftime to parse time, e.g. :const:`"%d/%m/%Y"`. See `strftime documentation `_ for more information on choices, though note that :const:`"%f"` will parse all the way up to nanoseconds. You can also pass: - "ISO8601", to parse any `ISO8601 `_ time string (not necessarily in exactly the same format); - "mixed", to infer the format for each element individually. This is risky, and you should probably use it along with `dayfirst`. .. note:: If a :class:`DataFrame` is passed, then `format` has no effect. exact : bool, default True Control how `format` is used: - If :const:`True`, require an exact `format` match. - If :const:`False`, allow the `format` to match anywhere in the target string. Cannot be used alongside ``format='ISO8601'`` or ``format='mixed'``. unit : str, default 'ns' The unit of the arg (D,s,ms,us,ns) denote the unit, which is an integer or float number. This will be based off the origin. Example, with ``unit='ms'`` and ``origin='unix'``, this would calculate the number of milliseconds to the unix epoch start. origin : scalar, default 'unix' Define the reference date. The numeric values would be parsed as number of units (defined by `unit`) since this reference date. - If :const:`'unix'` (or POSIX) time; origin is set to 1970-01-01. - If :const:`'julian'`, unit must be :const:`'D'`, and origin is set to beginning of Julian Calendar. Julian day number :const:`0` is assigned to the day starting at noon on January 1, 4713 BC. - If Timestamp convertible (Timestamp, dt.datetime, np.datetimt64 or date string), origin is set to Timestamp identified by origin. - If a float or integer, origin is the difference (in units determined by the ``unit`` argument) relative to 1970-01-01. cache : bool, default True If :const:`True`, use a cache of unique, converted dates to apply the datetime conversion. May produce significant speed-up when parsing duplicate date strings, especially ones with timezone offsets. The cache is only used when there are at least 50 values. The presence of out-of-bounds values will render the cache unusable and may slow down parsing. Returns ------- datetime If parsing succeeded. Return type depends on input (types in parenthesis correspond to fallback in case of unsuccessful timezone or out-of-range timestamp parsing): - scalar: :class:`Timestamp` (or :class:`datetime.datetime`) - array-like: :class:`DatetimeIndex` (or :class:`Series` with :class:`object` dtype containing :class:`datetime.datetime`) - Series: :class:`Series` of :class:`datetime64` dtype (or :class:`Series` of :class:`object` dtype containing :class:`datetime.datetime`) - DataFrame: :class:`Series` of :class:`datetime64` dtype (or :class:`Series` of :class:`object` dtype containing :class:`datetime.datetime`) Raises ------ ParserError When parsing a date from string fails. ValueError When another datetime conversion error happens. For example when one of 'year', 'month', day' columns is missing in a :class:`DataFrame`, or when a Timezone-aware :class:`datetime.datetime` is found in an array-like of mixed time offsets, and ``utc=False``, or when parsing datetimes with mixed time zones unless ``utc=True``. If parsing datetimes with mixed time zones, please specify ``utc=True``. See Also -------- DataFrame.astype : Cast argument to a specified dtype. to_timedelta : Convert argument to timedelta. convert_dtypes : Convert dtypes. Notes ----- Many input types are supported, and lead to different output types: - **scalars** can be int, float, str, datetime object (from stdlib :mod:`datetime` module or :mod:`numpy`). They are converted to :class:`Timestamp` when possible, otherwise they are converted to :class:`datetime.datetime`. None/NaN/null scalars are converted to :const:`NaT`. - **array-like** can contain int, float, str, datetime objects. They are converted to :class:`DatetimeIndex` when possible, otherwise they are converted to :class:`Index` with :class:`object` dtype, containing :class:`datetime.datetime`. None/NaN/null entries are converted to :const:`NaT` in both cases. - **Series** are converted to :class:`Series` with :class:`datetime64` dtype when possible, otherwise they are converted to :class:`Series` with :class:`object` dtype, containing :class:`datetime.datetime`. None/NaN/null entries are converted to :const:`NaT` in both cases. - **DataFrame/dict-like** are converted to :class:`Series` with :class:`datetime64` dtype. For each row a datetime is created from assembling the various dataframe columns. Column keys can be common abbreviations like ['year', 'month', 'day', 'minute', 'second', 'ms', 'us', 'ns']) or plurals of the same. The following causes are responsible for :class:`datetime.datetime` objects being returned (possibly inside an :class:`Index` or a :class:`Series` with :class:`object` dtype) instead of a proper pandas designated type (:class:`Timestamp`, :class:`DatetimeIndex` or :class:`Series` with :class:`datetime64` dtype): - when any input element is before :const:`Timestamp.min` or after :const:`Timestamp.max`, see `timestamp limitations `_. - when ``utc=False`` (default) and the input is an array-like or :class:`Series` containing mixed naive/aware datetime, or aware with mixed time offsets. Note that this happens in the (quite frequent) situation when the timezone has a daylight savings policy. In that case you may wish to use ``utc=True``. Examples -------- **Handling various input formats** Assembling a datetime from multiple columns of a :class:`DataFrame`. The keys can be common abbreviations like ['year', 'month', 'day', 'minute', 'second', 'ms', 'us', 'ns']) or plurals of the same >>> df = pd.DataFrame({"year": [2015, 2016], "month": [2, 3], "day": [4, 5]}) >>> pd.to_datetime(df) 0 2015-02-04 1 2016-03-05 dtype: datetime64[us] Using a unix epoch time >>> pd.to_datetime(1490195805, unit="s") Timestamp('2017-03-22 15:16:45') >>> pd.to_datetime(1490195805433502912, unit="ns") Timestamp('2017-03-22 15:16:45.433502912') .. warning:: For float arg, precision rounding might happen. To prevent unexpected behavior use a fixed-width exact type. Using a non-unix epoch origin >>> pd.to_datetime([1, 2, 3], unit="D", origin=pd.Timestamp("1960-01-01")) DatetimeIndex(['1960-01-02', '1960-01-03', '1960-01-04'], dtype='datetime64[s]', freq=None) **Differences with strptime behavior** :const:`"%f"` will parse all the way up to nanoseconds. >>> pd.to_datetime("2018-10-26 12:00:00.0000000011", format="%Y-%m-%d %H:%M:%S.%f") Timestamp('2018-10-26 12:00:00.000000001') **Non-convertible date/times** Passing ``errors='coerce'`` will force an out-of-bounds date to :const:`NaT`, in addition to forcing non-dates (or non-parseable dates) to :const:`NaT`. >>> pd.to_datetime("invalid for Ymd", format="%Y%m%d", errors="coerce") NaT .. _to_datetime_tz_examples: **Timezones and time offsets** The default behaviour (``utc=False``) is as follows: - Timezone-naive inputs are converted to timezone-naive :class:`DatetimeIndex`: >>> pd.to_datetime(["2018-10-26 12:00:00", "2018-10-26 13:00:15"]) DatetimeIndex(['2018-10-26 12:00:00', '2018-10-26 13:00:15'], dtype='datetime64[us]', freq=None) - Timezone-aware inputs *with constant time offset* are converted to timezone-aware :class:`DatetimeIndex`: >>> pd.to_datetime(["2018-10-26 12:00 -0500", "2018-10-26 13:00 -0500"]) DatetimeIndex(['2018-10-26 12:00:00-05:00', '2018-10-26 13:00:00-05:00'], dtype='datetime64[us, UTC-05:00]', freq=None) - However, timezone-aware inputs *with mixed time offsets* (for example issued from a timezone with daylight savings, such as Europe/Paris) are **not successfully converted** to a :class:`DatetimeIndex`. Parsing datetimes with mixed time zones will raise a ValueError unless ``utc=True``: >>> pd.to_datetime( ... ["2020-10-25 02:00 +0200", "2020-10-25 04:00 +0100"] ... ) # doctest: +SKIP ValueError: Mixed timezones detected. Pass utc=True in to_datetime or tz='UTC' in DatetimeIndex to convert to a common timezone. - To create a :class:`Series` with mixed offsets and ``object`` dtype, please use :meth:`Series.apply` and :func:`datetime.datetime.strptime`: >>> import datetime as dt >>> ser = pd.Series(["2020-10-25 02:00 +0200", "2020-10-25 04:00 +0100"]) >>> ser.apply(lambda x: dt.datetime.strptime(x, "%Y-%m-%d %H:%M %z")) 0 2020-10-25 02:00:00+02:00 1 2020-10-25 04:00:00+01:00 dtype: object - A mix of timezone-aware and timezone-naive inputs will also raise a ValueError unless ``utc=True``: >>> from datetime import datetime >>> pd.to_datetime( ... ["2020-01-01 01:00:00-01:00", datetime(2020, 1, 1, 3, 0)] ... ) # doctest: +SKIP ValueError: Mixed timezones detected. Pass utc=True in to_datetime or tz='UTC' in DatetimeIndex to convert to a common timezone. | Setting ``utc=True`` solves most of the above issues: - Timezone-naive inputs are *localized* as UTC >>> pd.to_datetime(["2018-10-26 12:00", "2018-10-26 13:00"], utc=True) DatetimeIndex(['2018-10-26 12:00:00+00:00', '2018-10-26 13:00:00+00:00'], dtype='datetime64[us, UTC]', freq=None) - Timezone-aware inputs are *converted* to UTC (the output represents the exact same datetime, but viewed from the UTC time offset `+00:00`). >>> pd.to_datetime(["2018-10-26 12:00 -0530", "2018-10-26 12:00 -0500"], utc=True) DatetimeIndex(['2018-10-26 17:30:00+00:00', '2018-10-26 17:00:00+00:00'], dtype='datetime64[us, UTC]', freq=None) - Inputs can contain both string or datetime, the above rules still apply >>> pd.to_datetime(["2018-10-26 12:00", datetime(2020, 1, 1, 18)], utc=True) DatetimeIndex(['2018-10-26 12:00:00+00:00', '2020-01-01 18:00:00+00:00'], dtype='datetime64[us, UTC]', freq=None) >rISO8601z8Cannot use 'exact' when 'format' is 'mixed' or 'ISO8601'Nr)rrr^rrrr)rrrr>rrrr))r no_defaultrrrrrrrrrrr+remptyrr _constructorrrr*rMutableMapping_assemble_from_unit_mappingsr6rr&r r rrr1rrrrr>rrrwbool_)rrrr^rrrrrrrrrrvaluesargcr>s rPrrs D  CN""v1E'E'ESTTT {  VT22#  #y!!0"  0v!..// C # #)""37GHH   NWW[))FF%%ck6::F%%fCICH%MMFF C,(:; < <""-c63?? C   ""37GHH   B+C38LLLFF%%c6AAAFF c  " 3 dE>2:xNOQTD'tVU>FF%%dF33FF!!"(C5//6::1= c4  "Z%A%A "&\\F MsAH)IIrFyearsrGmonthsrHdaysrThrUrVmrWrXsrYrZ millisecond millisecondsr[ microsecondr\) microsecondsr\ nanosecond nanosecondsc ddlm}mm}||}|jjst ddfd|D}d|D}gd}t|t|z }t|r5d t|} t d | d t|ttz } t| r5d t| } t d | d fd } | ||ddz| ||ddzz| ||dz} t| d|} n,#t t f$r}t d||d}~wwxYwgd}|D]n}||}|U||vrQ | || |||z } ?#t t f$r}t d|d||d}~wwxYwo| S)a assemble the unit specified fields from the arg (DataFrame) Return a Series for actual parsing Parameters ---------- arg : DataFrame errors : {'raise', 'coerce'}, default 'raise' - If :const:`'raise'`, then invalid parsing will raise an exception - If :const:`'coerce'`, then invalid parsing will be set as :const:`NaT` utc : bool Whether to convert/localize timestamps to UTC. Returns ------- Series r)r= to_numeric to_timedeltaz#cannot assemble with duplicate keysc|tvr t|S|tvrt|S|Sr) _unit_maplower)values rPrz'_assemble_from_unit_mappings..fvsE I  U# # ;;==I % %U[[]]+ + rOc(i|]}||SrNrN).0krs rP z0_assemble_from_unit_mappings..s# ( ( (Aqqtt ( ( (rOci|]\}}|| SrNrN)r&r'vs rPr(z0_assemble_from_unit_mappings..s...A1...rO)rFrGrH,zNto assemble mappings requires at least that [year, month, day] be specified: [z ] is missingz9extra keys have been passed to the datetime assemblage: [rc|}t|jr|d}t|jr|d}|S)N)rfloat64r)r#rrr%)rrrs rPrz,_assemble_from_unit_mappings..coercesfF6222 &, ' ' .]]9--F FL ) ) ,]]7++F rOrFi'rGdrHz%Y%m%d)rrrzcannot assemble the datetimes: N)rrrrZr[r\)rrzcannot assemble the datetimes [z]: )rr=rr columnsrrkeysitemsr|rzjoinsortedr"rrr}get)rrrrr=r runit_revrequiredreq _requiredexcess_excessrrrunitsur$rrs ` @@rPrrVs>* )C..C ; @>??? ) ( ( (SXXZZ ( ( (D.....H(''H h--#hmmoo.. .C 3xx HHVC[[))  I1: I I I    ! !C (8(8(:(:$;$; ;F 6{{ ((6&>>** R R R R          s8F#$%%- &Xg&' ( (3 . / &Xe_% & & ' KVHVMMM z "KKK@3@@AAsJK A@@E  Q  # ,,vvc%j'9'9&QQQQz*    EeEEEE  Ms0G""H 3HH 2 II?$I::I?)rrr)F)r^r_r`ra)rqN)rrr?rsrtrurvr`rw) rrr?rrarrwrr8r`r>)FN)rrrrwrrr`r6r)rrrBrr>rrr`r6)NFNrNNT)rrarrrrwrrarrr^r_rr_rrw) rrwrrirrwrrir`r6)rrwrrir`r6) .........)rrrArrr^rwrrwrrwrrarrwrrarrwr`r)rrrrrr^rwrrwrrwrrarrwrrarrwr`r>)rrrrrr^rwrrwrrwrrarrwrrarrwr`r7)rrrrrr^rwrrwrrwrrarrrrarrirrwr`r)rrrrwr`r>)z __future__r collectionsrdatetimer functoolsr itertoolsrtypingrr r r r r rjnumpyr pandas._libsrrpandas._libs.tslibsrrrrrrrrrpandas._libs.tslibs.conversionrpandas._libs.tslibs.parsingrrpandas._libs.tslibs.strptimerpandas._typingrrrpandas.util._decoratorsrpandas.util._exceptionsr pandas.core.dtypes.commonr!r"r#r$r%r&r'pandas.core.dtypes.dtypesr(r)pandas.core.dtypes.genericr*r+ pandas.arraysr,r-r.pandas.core.algorithmsr/pandas.core.arraysr0pandas.core.arrays.baser1pandas.core.arrays.datetimesr2r3r4pandas.core.constructionr5pandas.core.indexes.baser6pandas.core.indexes.datetimesr7collections.abcr8r9pandas._libs.tslibs.nattyper:pandas._libs.tslibs.timedeltasr;r<rr=r>rrr?rMrtrir@rrArBrCrErSDictConvertibler{rprrrrrrrrrr r"r__all__rNrOrPr\sW"""""""                    EDDDDD877777 /.....444444  *)))))222222222222 322222******777777  433333::::::''''''#Ul\99999CK"TMBM99999.>MMMMMy     'u    (+56 0QU99999x////fEI<<<<<@!CCCCC:!#* !G9G9G9G9G9TDDDD8MMMM`HHHV $'        $'        $'        H$+"%.IIIIIZ   F  V  W  g    5    E   C  S  c s  c s  $ 4 D   $! "4# $ +    2````F   rO