Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/pandas/tests/tools/__pycache__/test_to_datetime.cpython-37.pyc
Назад
B �5�g�q � @ s� d Z ddlZddlmZ ddlmZmZ ddlmZ ddlZddl m Z ddl m Z ddl ZddlZddlZddlmZ dd lmZmZ dd lmZmZ ddlm mZ dd l m Z ddl Z dd l m!Z!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'm(Z(m)Z) ddl*m+Z, dd l-m.Z. ddl/m0Z1 ddl2m3Z3 G dd� d�Z4G dd� d�Z5G dd� d�Z6G dd� d�Z7G dd� d�Z8G dd� d�Z9G d d � d �Z:G d d � d �Z;ej<d d!d"d#d$gd%�d&d'� �Z=ej<d(d)� �Z>ej<d*d+� �Z?ej<d,d-d.d/gd%�d0d1� �Z@ej<d2d3� �ZAG d4d5� d5�ZBejC�Dd6d7d8d9d:d;d<d=d>d?dg d@fd7d7d7d7d:d;d<d=d>d?g dAfg�dBdC� �ZEejC�DdDdEdFg�dGdH� �ZFdIdJ� ZGejC�DdKejHeIg�dLdM� �ZJdNdO� ZKdPdQ� ZLdS )Rz test to_datetime � N)�deque)�datetime� timedelta)�Decimal)�parse)�tzoffset)�tslib)�iNaT�parsing)�OutOfBoundsDatetime�OutOfBoundsTimedelta)�is_datetime64_ns_dtype) � DataFrame� DatetimeIndex�Index�NaT�Series� Timestamp� date_range�isna� to_datetime)� DatetimeArray)� datetimes)�start_caching_atc @ s� e Zd Zej�dddg�dd� �Zej�dddg�dd� �Zej�dddg�d d � �Zej�d d d dgd d e j gd d e gd d dgdddgdde j gdde gdddgg�dd� �Z ej�de d e j ddg�e ed �e j e j e j g�ge d dde j g�e ed �e j e j e j g�ge de j ddg�e ed�e j e j e j g�ge dde j dg�e ed�e j e j e j g�gg�dd � �Zej�dddg�d d � �Zej�d d ed!d"d#�gd$ed%d&d'�gd(d(gd)d)gd*d*gd+d+gg�d,d-� �Zej�dddg�d.d/� �Zej�dddg�d0d1� �Zejej�dddg�d2d3� ��Zej�dddg�d4d5� �Zej�dddg�d6d7� �Zej�d8d9d:gd; ed<d=d>�gd; gd9d:d?d@ged<d=d>�ed<dAd>�ed<dBd>�ggdCdDgd; ed<e�dE�dF�gd; gdGdHgd; ed<e�dE�dF�gd; gdGdHdIged<e�dE�dF�ed<e�dJ�dF�ggdGdKdKged<e�dL�dF�ed<e�dL�dF�ggg�dMdN� �Z dOdP� Z ej�dQdRdSdTdUdVdWg�dXdY� �Z dZd[� Z dS )\�TestTimeConversionFormats�readonlyTFc C s> t jg td�}|r |jdd� t|�}tg �}t�||� d S )N)�dtypeF)�write)�np�array�objectZsetflagsr �tm�assert_index_equal)�selfr �arr�result�expected� r' �Y/home/digitalm-up/venv/lib/python3.7/site-packages/pandas/tests/tools/test_to_datetime.py�test_to_datetime_readonly2 s z3TestTimeConversionFormats.test_to_datetime_readonly�cachec C s* dddg}t d�t d�t d�g}t d�t d�t d�g}x�|t|�t|�fft|�t|�t|�ff|d |d |d ff|d |d |d ff|d |d |d ffgD ]|\}}xrtd d g�D ]b\}}t|||d�} || } t| t�r�t�| t| �� q�t| t ��r| | k�s t�q�t� | | � q�W q�W d S )Nz1/1/2000z1/2/2000z1/3/2000�20000101Z20000201Z20000301Z20000102Z20000103r � � z%d/%m/%Yz%m/%d/%Y)�formatr* ) r r r � enumerater � isinstancer! �assert_series_equal�AssertionErrorr" ) r# r* �valuesZresults1Zresults2�vals� expecteds�i�fmtr% r& r' r' r( �test_to_datetime_format< s" " z1TestTimeConversionFormats.test_to_datetime_formatc C sj t ddgdgd �}t dd� |�t�D ��}t|d|d�}t�||� t|�t�d|d�}t�||� t td�td�gtd �gd �}tj|d < tj|d < t|d|d�}t�||� |�t�}d |d < t|d|d�}t�||� t d d dg�}t|dd|d�}t t ddd�t ddd�t ddd�gt d�}t�||� t|dd|d�}t dddgdd�}t�||� d S ) Ni�$.i9G.� c S s g | ] }t |��qS r' )r )�.0�xr' r' r( � <listcomp>X s zNTestTimeConversionFormats.test_to_datetime_format_YYYYMMDD.<locals>.<listcomp>z%Y%m%d)r. r* �19801222Z19810105r- Znati�3i�T3i����ignore)r. �errorsr* i� � � i� i' )r �coerceZ20121231Z20141231r zM8[ns]) r �apply�strr r! r1 r r �nanr r )r# r* �sr& r% r' r' r( � test_to_datetime_format_YYYYMMDDU s2 z:TestTimeConversionFormats.test_to_datetime_format_YYYYMMDD�input_sr= �20010112Nr i�$.i�T1c C s6 t td�td�tg�}t t|dd��}t�||� d S )Nr= rI z%Y%m%d)r. )r r r r r! r1 )r# rH r& r% r' r' r( �*test_to_datetime_format_YYYYMMDD_with_none~ s zDTestTimeConversionFormats.test_to_datetime_format_YYYYMMDD_with_nonezinput_s, expectedZ20010012Z10019999i]4i T1i {1Z20190813c C s t |ddd�}t�||� d S )Nz%Y%m%drB )r. r? )r r! r1 )r# rH r& r% r' r' r( �)test_to_datetime_format_YYYYMMDD_overflow� s zCTestTimeConversionFormats.test_to_datetime_format_YYYYMMDD_overflowc C s� t dddg�}t dd� |�t�D ��}t|d|d�}t�||� t dd d g�}t d d� |�t�D ��}t|d |d�}t�||� d S ) Ni� i� i� c S s g | ] }t |��qS r' )r )r: r; r' r' r( r< � s zMTestTimeConversionFormats.test_to_datetime_format_integer.<locals>.<listcomp>z%Y)r. r* iA i� i c S s, g | ]$}t |d d� d |dd � ��qS )N� �-)r )r: r; r' r' r( r< � s z%Y%m)r rC rD r r! r1 )r# r* rF r& r% r' r' r( � test_to_datetime_format_integer� s z9TestTimeConversionFormats.test_to_datetime_format_integerzint_date, expectedi�3i� � � i� i� � rL iu��wi�(3iA� iI c C s t |ddd�}||kst�d S )Nz%Y%m%dr> )r. r? )r r2 )r# Zint_dater& r% r' r' r( �.test_int_to_datetime_format_YYYYMMDD_typeerror� s zHTestTimeConversionFormats.test_int_to_datetime_format_YYYYMMDD_typeerrorc C sP t �� \}}tjd }d|� d�}d}t|||d�}t�||�}||ksLt�d S )NrL z01-z-2011 00:00:01.978z%d-%b-%Y %H:%M:%S.%f)r. r* )�locale� getlocale�calendar� month_abbrr r �strptimer2 ) r# r* �lang�_rV �valr. r% �expr' r' r( �#test_to_datetime_format_microsecond� s z=TestTimeConversionFormats.test_to_datetime_format_microsecondc C sV ddt d�gddt d�gddt d �gg}x(|D ] \}}}t|||d �|ks.t�q.W d S ) Nz01/10/2010 15:20z%m/%d/%Y %H:%Mz2010-01-10 15:20z01/10/2010 05:43z%m/%d/%Y %I:%Mz2010-01-10 05:43z01/10/2010 13:56:01z%m/%d/%Y %H:%M:%Sz2010-01-10 13:56:01)r. r* )r r r2 )r# r* �datarF r. �dtr' r' r( � test_to_datetime_format_time� s z6TestTimeConversionFormats.test_to_datetime_format_timec C sJ t ddddg�}t|dd|d�}t|jjddd �d|d �}t�||� d S ) NZ19MAY11Z foobar19MAY11z19MAY11:00:00:00z19MAY11 00:00:00Zz%d%b%yF)r. �exactr* z (\d+\w+\d+))�expand)r. r* )r r rD �extractr! r1 )r# r* rF r% r& r' r' r( � test_to_datetime_with_non_exact� s z9TestTimeConversionFormats.test_to_datetime_with_non_exactc C s8 x2dD ]*}t ||d�}t |d|d�}||kst�qW d S )N)z 2012-01-01 09:00:00.000000001z2012-01-01 09:00:00.000001z2012-01-01 09:00:00.001z2012-01-01 09:00:00.001000z 2012-01-01 09:00:00.001000000)r* z%Y-%m-%d %H:%M:%S.%f)r. r* )r r2 )r# r* �vr& r% r' r' r( �#test_parse_nanoseconds_with_formula s z=TestTimeConversionFormats.test_parse_nanoseconds_with_formulac C sJ ddt d�gddt d�gg}x(|D ] \}}}t|||d�|ks"t�q"W d S )NZ2009324z%Y%W%wz 2009-08-13Z2013020z%Y%U%wz 2013-01-13)r. r* )r r r2 )r# r* r] rF r. r^ r' r' r( � test_to_datetime_format_weeks s z7TestTimeConversionFormats.test_to_datetime_format_weekszfmt,dates,expected_datesz%Y-%m-%d %H:%M:%S %Zz2010-01-01 12:00:00 UTCr- z2010-01-01 12:00:00�UTC)�tzz2010-01-01 12:00:00 GMTz 2010-01-01 12:00:00 US/Pacific�GMTz US/Pacificz%Y-%m-%d %H:%M:%S%zz2010-01-01 12:00:00+0100�< )�tzinfoz%Y-%m-%d %H:%M:%S %zz2010-01-01 12:00:00 +0100z2010-01-01 12:00:00 -0100i���z2010-01-01 12:00:00 Zr c C s$ t ||d�}t|�}t�||� d S )N)r. )r r r! � assert_equal)r# r7 �dates�expected_datesr% r& r' r' r( �)test_to_datetime_parse_tzname_or_tzoffset" s 5 zCTestTimeConversionFormats.test_to_datetime_parse_tzname_or_tzoffsetc C sB ddddg}ddddg}d }t ||d d �}t|�}t�||� d S ) Nz2010-01-01 12:00:00 +0100z2010-01-01 12:00:00 -0100z2010-01-01 12:00:00 +0300z2010-01-01 12:00:00 +0400z2010-01-01 11:00:00+00:00z2010-01-01 13:00:00+00:00z2010-01-01 09:00:00+00:00z2010-01-01 08:00:00+00:00z%Y-%m-%d %H:%M:%S %zT)r. �utc)r r r! r" )r# rm rn r7 r% r& r' r' r( �=test_to_datetime_parse_tzname_or_tzoffset_different_tz_to_utc[ s zWTestTimeConversionFormats.test_to_datetime_parse_tzname_or_tzoffset_different_tz_to_utc�offsetz+0z-1fooZUTCbarz:10z +01:000:01� c C s< d}d| }d}t jt|d�� t|g|d� W d Q R X d S )Nz%Y-%m-%d %H:%M:%S %zz2010-01-01 12:00:00 z.does not match format|unconverted data remains)�match)r. )�pytest�raises� ValueErrorr )r# rr r7 �date�msgr' r' r( �)test_to_datetime_parse_timezone_malformedo s zCTestTimeConversionFormats.test_to_datetime_parse_timezone_malformedc C s> d}t dgdd�}t||d�}tdgddd�}t�||� d S ) Nz%Y-%m-%d %H:%M:%S %zz2010-01-01 12:00:00 Z�foo)�name)r. z2010-01-01 12:00:00rg )rh r| )r r r r! r" )r# r7 �argr% r& r' r' r( �*test_to_datetime_parse_timezone_keeps_namez s zDTestTimeConversionFormats.test_to_datetime_parse_timezone_keeps_name) �__name__� __module__� __qualname__ru �mark� parametrizer) r8 rG r rE r rJ r r rK rN r rR r\ r_ �td�skip_if_has_localerc re rf �pytz� FixedOffsetro rq rz r~ r' r' r' r( r 1 s� ) ( " r c @ s� e Zd Zej�dddeddddd�gdded d d dd�gd ded d d dd�gg�d d� �Zej�ddddgdddgdddgdddgdddgddd gdd d gd d d!gd"d#d$gd"d%d&gd"d'd(gd"d'd)gdd*d+gg �d,d-� �Zej�d.d/d0g�d1d2� �Z d3d4� Z d5d6� Z d7d8� Z e jd9d:� �Ze jd;d<� �Zd=d>� Zej�d?d@dAg�dBdC� �Zej�dDe�dE�e�dF�g�ej�d?d@dAg�dGdH� ��Zej�d?d@dAg�ej�dIdJdKg�dLdM� ��Zej�d?d@dAg�dNdO� �Zej�d?d@dAg�dPdQ� �Zej�d?d@dAg�dRdS� �Zej�d?d@dAg�ej�dTeee j fe ee j fej ee j fe e e j!fg�dUdV� ��Z"ej�d?d@dAg�dWdX� �Z#ej�d?d@dAg�dYdZ� �Z$ej�d?d@dAg�ej�d[d\d]g�d^d_� ��Z%ej�d?d@dAg�e �&d`�dadb� ��Z'ej�d?d@dAg�dcdd� �Z(dedf� Z)ej�dgdhdig�ej�djd@dAg�ej�dkd/dlg�dmdn� ���Z*ej�dgdog�ej�djd@dAg�ej�dkd/dlg�dpdq� ���Z+ej�drdhgdigdhdsdtgg�ej�djd@dAg�ej�dkd/dlg�dudv� ���Z,ej�dwd@d/g�ej�dkdxd/g�ej�dye e-ej ee.g�dzd{� ���Z/ej�d|e.e0d}�gd~ �e0d}�gd~ e-e0d}�gd~ �g�dd�� �Z1d�d�� Z2ej�dwd@d/g�ej�dkdxd/g�d�d�� ��Z3d�d�� Z4ej�d�d/ej5fe6fe7 e6fe7d� fd/e0d��fe6fe7 e6e0d��fe6fe7 fd�e6fe7 d�e0d��f e6fe7d e0d��e0d��f ff�d�d�� �Z8ej�d�d�d�d�d�d�d�g�d�d�� �Z9d�d�� Z:d�d�� Z;d�d�� Z<d�d�� Z=d�d�� Z>d�d�� Z?d�d�� Z@ej�d�e0d��e0d�d�d��fe0d�d�d��e0d�d�d��fg�d�d�� �ZAej�d�d�d�d�d�g�d�d�� �ZBd�d�� ZCd�d�� ZDd/S )��TestToDatetimezs, _format, dtz2015-1-1z%G-%V-%ui� r@ � r z2015-1-4i� r, z2015-1-7rL c C s t ||d�|kst�d S )N)r. )r r2 )r# rF �_formatr^ r' r' r( �%test_to_datetime_iso_week_year_format� s z4TestToDatetime.test_to_datetime_iso_week_year_formatzmsg, s, _formatzxISO week directive '%V' must be used with the ISO year directive '%G' and a weekday directive '%A', '%a', '%w', or '%u'.z1999 50z%Y %VzxISO year directive '%G' must be used with the ISO week directive '%V' and a weekday directive '%A', '%a', '%w', or '%u'.z1999 51z%G %Vz 1999 Mondayz%G %Az1999 Monz%G %az1999 6z%G %wz%G %uZ2051z%Gz`Day of the year directive '%j' is not compatible with ISO year directive '%G'. Use '%Y' instead.z 1999 51 6 256z %G %V %u %jzdISO week directive '%V' is incompatible with the year directive '%Y'. Use the ISO year '%G' instead.z1999 51 Sundayz%Y %V %Az 1999 51 Sunz%Y %V %az 1999 51 1z%Y %V %wz%Y %V %uZ20z%Vc C sB t �� dkr>t �� dkr>tjt|d�� t||d� W d Q R X d S )N)�zh_CNzUTF-8)�it_ITzUTF-8)rt )r. )rS rT ru rv rw r )r# ry rF r� r' r' r( �test_error_iso_week_year� s [z'TestToDatetime.test_error_iso_week_yearrh Nz US/Centralc C sD t ddd|d�}t|�}t|�}||ks,t�t|�}||ks@t�d S )Nz 1965-04-03� Z2W)�periods�freqrh )r r r r2 )r# rh �dtir$ r% r' r' r( �test_to_datetime_dtarr� s z%TestToDatetime.test_to_datetime_dtarrc C s( t tddd��}|tddd�ks$t�d S )Ni� r, � )r r r2 )r# �actualr' r' r( �test_to_datetime_pydatetime� s z*TestToDatetime.test_to_datetime_pydatetimec C s t d�}|tddd�ks t�d S )NZ20080115i� r, r� )r r r2 )r# r� r' r' r( �test_to_datetime_YYYYMMDD s z(TestToDatetime.test_to_datetime_YYYYMMDDc C s d}t |dd�|kst�d S )Nz Month 1, 1999r> )r? )r r2 )r# rF r' r' r( �#test_to_datetime_unparseable_ignore s z2TestToDatetime.test_to_datetime_unparseable_ignorec C s� t �d��� t�d��d�}td�}tdg�d }t|j|�tj� �dk sPt �t|j|�tj� �dk snt �|j d ks|t �|j d ks�t �W d Q R X d S )Nz US/Eastern�nowzdatetime64[ns]r g _�B) r! � set_timezoner � datetime64�astyper �abs�value�int64r2 rk )r# ZnpnowZpdnowZpdnow2r' r' r( �test_to_datetime_now s z#TestToDatetime.test_to_datetime_nowc C st t �d��� t�d��d��tj�}td�}tdg�d }td�}t�� }t |� � j | �dk sdt �t |� � j | �dk s~t �t |j |j �dk s�t �t |j |j �dk s�t �|j d ks�t �|j d ks�t �W d Q R X t �d��� t�d��d��tj�}td�}tdg�d }t |� � j | �dk �s*t �t |� � j | �dk �sFt �|j d k�sVt �|j d k�sft �W d Q R X d S )NzPacific/Auckland�todayzdatetime64[ns]r g _�BzUS/Samoa)r! r� r r� r� r� r r r� r� � normalizer� r2 rk )r# ZnptodayZpdtodayZpdtoday2ZtstodayZtstoday2r' r' r( �test_to_datetime_today s( z%TestToDatetime.test_to_datetime_todayc C s t dg� t dg� d S )Nr� r� )r )r# r' r' r( �(test_to_datetime_today_now_unicode_bytesB s z7TestToDatetime.test_to_datetime_today_now_unicode_bytesr* TFc C s> t �d�t �d�g}x$|D ] }t||d�t|�kst�qW d S )Nz 2000-01-01z 2000-01-02)r* )r r� r r r2 )r# r* Z in_bound_dtsr^ r' r' r( �test_to_datetime_dt64sF s z%TestToDatetime.test_to_datetime_dt64sr^ z 1000-01-01z 5000-01-02c C sl d|� �}t jt|d�� t|dd� W d Q R X t jt|d�� t|� W d Q R X t|d|d�tksht�d S )Nz$Out of bounds nanosecond timestamp: )rt �raise)r? rB )r? r* )ru rv r r r r r2 )r# r* r^ ry r' r' r( �$test_to_datetime_dt64s_out_of_boundsM s z3TestToDatetime.test_to_datetime_dt64s_out_of_bounds�unitrF �Dc C s� t �d|�t �d|�gd }t�t||d�tdd� |D ��� |t �d�g }d}tjt|d �� t|d d � W d Q R X t�t|d |d �tt |d �j t |d �j gd t g �� t�t|d|d �t dd� |D ��� d S )Nz 2000-01-01z 2000-01-02rP )r* c S s g | ]}t |�j�qS r' )r �asm8)r: r; r' r' r( r< f s zBTestToDatetime.test_to_datetime_array_of_dt64s.<locals>.<listcomp>z 9999-01-01z7Out of bounds nanosecond timestamp: 9999-01-01 00:00:00)rt r� )r? rB )r? r* r r, r> c S s g | ] }|� � �qS r' )�item)r: r^ r' r' r( r< } s ) r r� r! r" r r ru rv r r r� r r )r# r* r� �dtsZ dts_with_oobry r' r' r( � test_to_datetime_array_of_dt64sY s$ z.TestToDatetime.test_to_datetime_array_of_dt64sc C s� t ddd�t ddd�g}t||d�}tddgdd�}t�||� t ddd�t ddd�g}d }tjt|d �� t||d� W d Q R X d S ) Nz2013-01-01 13:00:00-0800z US/Pacific)rh z2013-01-02 14:00:00-0800)r* z2013-01-01 13:00:00z2013-01-02 14:00:00z US/EasternzLTz-aware datetime.datetime cannot be converted to datetime64 unless utc=True)rt )r r r r! r" ru rv rw )r# r* r$ r% r& ry r' r' r( �test_to_datetime_tz� s z"TestToDatetime.test_to_datetime_tzc C sJ d}d}|gd |gd }t dd� |D ��}t||d�}t�||� d S )NzMarch 1, 2018 12:00:00+0400zMarch 1, 2018 12:00:00+0500r9 c S s g | ] }t |��qS r' )r )r: r; r' r' r( r< � s zETestToDatetime.test_to_datetime_different_offsets.<locals>.<listcomp>)r* )r r r! r" )r# r* Z ts_string_1Z ts_string_2r$ r& r% r' r' r( �"test_to_datetime_different_offsets� s z1TestToDatetime.test_to_datetime_different_offsetsc C st t �d�}tj|�tdddddd��|�tdddddd��gtd�}t|d |d �}td d gd d d�}t � ||� d S )Nz US/Easterni� r, rQ r )�year�month�day�hour�minute� )r T)rp r* z2000-01-01 08:00:00+00:00z2000-06-01 07:00:00+00:00zdatetime64[ns, UTC])r r� ) r� �timezoner r Zlocalizer r r r r! r" )r# r* Z us_easternr$ r% r& r' r' r( �test_to_datetime_tz_pytz� s z'TestToDatetime.test_to_datetime_tz_pytzz.init_constructor, end_constructor, test_methodc C s~ ddg}t ddd�t ddd�g}t||�dd|d �}||�}|||� x2t||�D ]$\} }t| dd|d �}||ksRt�qRW d S ) Nz20100102 121314z20100102 121315z2010-01-02 12:13:14rp )rh z2010-01-02 12:13:15z %Y%m%d %H%M%ST)r. rp r* )r r �zipr2 ) r# r* Zinit_constructorZend_constructorZ test_methodr] Z expected_datar% r& �scalarr' r' r( �test_to_datetime_utc_true� s z(TestToDatetime.test_to_datetime_utc_truec C s: d}t t|g�d|d�}tt|dd�g�}t�||� d S )Ng { ѴCT)rp r* rp )rh )r r r r! r1 )r# r* �tsr% r& r' r' r( �2test_to_datetime_utc_true_with_series_single_value� s zATestToDatetime.test_to_datetime_utc_true_with_series_single_valuec C sJ d}d}t |gd �}t|d|d�}t t|dd�gd �}t�||� d S )Nz2013-01-01 00:00:00-01:00z2013-01-01 01:00:00rQ T)rp r* rp )rh )r r r r! r1 )r# r* r� Z expected_tsr] r% r& r' r' r( �4test_to_datetime_utc_true_with_series_tzaware_string� s zCTestToDatetime.test_to_datetime_utc_true_with_series_tzaware_stringz date, dtype)z2013-01-01 01:00:00zdatetime64[ns])z2013-01-01 01:00:00zdatetime64[ns, UTC]c C s: t tddd�g�}tt |g|d�d|d�}t�||� d S )Nz2013-01-01 01:00:00rg )rh )r T)rp r* )r r r r! r1 )r# r* rx r r& r% r' r' r( �1test_to_datetime_utc_true_with_series_datetime_ns� s z@TestToDatetime.test_to_datetime_utc_true_with_series_datetime_ns�psycopg2c C s� dd l }|jjdd d�}|jjdd d�}tjtddddd|d�tdd ddd|d�gtd �}t|d d |d �}tddgdd d�}t � ||� tdg|jjdd d�d�}t |�s�t �t|d |d�}t � ||� t|d d |d �}tdgdd �}t � ||� d S )Nr i���)rr r| i���i� r, rQ )rk r� )r rB T)r? rp r* z2000-01-01 08:00:00+00:00z2000-06-01 07:00:00+00:00zdatetime64[ns, UTC])r r� z2000-01-01 08:00:00)rh )r? r* z2000-01-01 13:00:00) r� rh ZFixedOffsetTimezoner r r r r r r! r" r r2 ) r# r* r� Ztz1Ztz2r$ r% r& r6 r' r' r( � test_to_datetime_tz_psycopg2� s, z+TestToDatetime.test_to_datetime_tz_psycopg2c C sD d}t jt|d�� td� W d Q R X tdd|d�tks<t�tdd|d�dksRt�t jt|d�� td� W d Q R X tdd|d�tks�t�tdd|d�dks�t�t|�� d�}t jt|d�� tdt�� g|d � W d Q R X t jt|d�� td dg|d � W d Q R X t � td dtd gd|d�t td |d �tttd |d �g�� d S ) Nz2dtype bool cannot be converted to datetime64\[ns\])rt FrB )r? r* r> Tz is not convertible to datetime)r* �20130101r g ) ru rv � TypeErrorr r r2 �typer r� r! r" r )r# r* ry r' r' r( �test_datetime_bool# s$ z!TestToDatetime.test_datetime_boolc C sL d}t jt|d�� tt� W d Q R X t jt|d�� tt� W d Q R X d S )Nz is not convertible to datetime)rt )ru rv r� r �bool)r# ry r' r' r( � test_datetime_invalid_datatype; s z-TestToDatetime.test_datetime_invalid_datatyper� �az00:01:99�inferr. zH%:M%:S%c C sj t |d||d�}||ks t�t |d||d�}|tks8t�d}tjt|d�� t |d||d� W d Q R X d S )Nr> )r? r. �infer_datetime_formatrB z\is a bad directive in format|second must be in 0..59|Given date string not likely a datetime)rt r� )r r2 r ru rv rw )r# r� r. r� �resry r' r' r( � test_datetime_invalid_scalarC s z+TestToDatetime.test_datetime_invalid_scalarz3000/12/11 00:00:00c C s� t |d||d�}||ks t�t |d||d�}|tks8t�|d k rpd}tjt|d�� t |d||d� W d Q R X n.d}tjt|d�� t |d||d� W d Q R X d S )Nr> )r? r. r� rB z?is a bad directive in format|Out of bounds nanosecond timestamp)rt r� z"Out of bounds nanosecond timestamp)r r2 r ru rv rw r )r# r� r. r� r� ry r' r' r( � test_datetime_outofbounds_scalar\ s z/TestToDatetime.test_datetime_outofbounds_scalarr3 �bz99:00:00c C s| t |d||d�}t�|t|�� t |d||d�}t�|ttgt|� �� d}tjt |d�� t |d||d� W d Q R X d S )Nr> )r? r. r� rB z\is a bad directive in format|Given date string not likely a datetime|second must be in 0..59)rt r� ) r r! r" r r r �lenru rv rw )r# r3 r. r� r� ry r' r' r( �test_datetime_invalid_indexx s z*TestToDatetime.test_datetime_invalid_indexrp z%Y%m%d %H:%M:%S� constructorc C sF d}|gd }||�}t |||dd�}t |||dd�}t�||� d S )Nz20130101 00:00:00i�� T)rp r. r* F)r r! r" ) r# rp r. r� rx � test_datesr] r% r& r' r' r( �test_to_datetime_cache� s z%TestToDatetime.test_to_datetime_cache�listlikez2010-06-02 09:30:00�3 c C s t �|�dkst�d S )NT)�tools� should_cacher2 )r# r� r' r' r( �&test_no_slicing_errors_in_should_cache� s z5TestToDatetime.test_no_slicing_errors_in_should_cachec C s8 t ttd�gd ��}t td�gd �}t�||� d S )Nz2010-06-02 09:30:00r� )r r r r! r" )r# r% r& r' r' r( �test_to_datetime_from_deque� s z*TestToDatetime.test_to_datetime_from_dequec C sF d}|gd }t |�}t|||dd�}t|||dd�}t�||� d S )Nz20130101 00:00:00i�� T)rp r. r* F)r r r! r1 )r# rp r. rx r� r] r% r& r' r' r( � test_to_datetime_cache_series� s z,TestToDatetime.test_to_datetime_cache_seriesc C s( d}t |dd�}td�}||ks$t�d S )Nz20130101 00:00:00T)r* )r r r2 )r# rx r% r& r' r' r( � test_to_datetime_cache_scalar� s z,TestToDatetime.test_to_datetime_cache_scalarz datetimelikes,expected_valuesr- z 2012-07-26)Nz 2012 July 26c C s4 t |dd�}t|dd�}t |dd�}t�||� d S )Nr )r rB )r? zdatetime64[ns])r r r! r1 )r# Z datetimelikesZexpected_values�serZ result_seriesZexpected_seriesr' r' r( �*test_convert_object_to_datetime_with_cache� s z9TestToDatetime.test_convert_object_to_datetime_with_cachez date, format)z2017-20z%Y-%W)z 20 Sundayz%W %A)z20 Sunz%W %a)z2017-21z%Y-%U)z 20 Sundayz%U %A)z20 Sunz%U %ac C s. d}t jt|d�� t||d� W d Q R X d S )Nz,Cannot use '%W' or '%U' without day and year)rt )r. )ru rv rw r )r# rx r. ry r' r' r( �'test_week_without_day_and_calendar_year� s z6TestToDatetime.test_week_without_day_and_calendar_yearc C s` dddg}t |dd�}ttdddd d td d �d �tdddd d td d �d �tg�}t�||� d S )NzMarch 1, 2018 12:00:00+0400zMarch 1, 2018 12:00:00+0500Z20100240rB )r? i� rQ r, r@ r i@8 )rk iPF )r r r r r r! r" )r# � ts_stringsr% r& r' r' r( �test_to_datetime_coerce� s z&TestToDatetime.test_to_datetime_coercec C s0 ddg}t |dd�}tttg�}t�||� d S )Nz 200622-12-31z 111111-24-11rB )r? )r r r r! r" )r# r� r% r& r' r' r( �!test_to_datetime_coerce_malformed s z0TestToDatetime.test_to_datetime_coerce_malformedc C sj d}t |�}t|�}||ks t�tt|�gd �}t |gd �}t�||� t|gd �}t�||� d S )Nz2015-11-18 15:30:00+05:30r- )r r r2 r r! r" )r# Zts_strr% r& r' r' r( �&test_iso_8601_strings_with_same_offset s z5TestToDatetime.test_iso_8601_strings_with_same_offsetc C s� ddt g}t|�}tjtdddddtd d�d �tdddd dtd d �d �t gtd �}t|�}t� ||� t|d d�}t t dddd�t dddd�t gdd�}t� ||� d S )Nz2015-11-18 15:30:00+05:30z2015-11-18 16:30:00+06:30i� � � r� rP iXM )rk � ih[ )r T)rp rO rg )rh ) r r r r r r r r r! r" r r )r# r� r% r& r' r' r( �,test_iso_8601_strings_with_different_offsets s $z;TestToDatetime.test_iso_8601_strings_with_different_offsetsc C sz t dddddgdd�}t dddddgdd�}t�||� ddg}t |dd�}t tt|��dd�d d d� }t�||� d S ) Nz2018-11-28T00:00:00z2018-11-28T00:00:00+12:00z2018-11-28T00:00:00+06:00T)rp z2018-11-27T12:00:00z2018-11-27T18:00:00���)r r! r" �list�reversed)r# r% r& �itemsr' r' r( �-test_iso8601_strings_mixed_offsets_with_naive1 s& z<TestToDatetime.test_iso8601_strings_mixed_offsets_with_naivec C s< t dtd�ddd g�}tjtdd�� t|� W d Q R X d S )NrE z 1990-01-01z 2015-03-14T16:15:14.123-08:00z 2019-03-04T21:56:32.620-07:00zTz-aware datetime.datetime)rt )r r ru rv rw r )r# r� r' r' r( �.test_mixed_offsets_with_native_datetime_raisesN s z=TestToDatetime.test_mixed_offsets_with_native_datetime_raisesc C s@ t dgd �}ttddddt�d�d�gd �}t�||� d S ) NzMarch 1, 2018 12:00:00+0400r- i� rQ r, r@ �� )rk )r r r r� r� r! r" )r# r% r& r' r' r( �#test_non_iso_strings_with_tz_offset\ s z2TestToDatetime.test_non_iso_strings_with_tz_offsetz ts, expectedz 2018-01-01rg )rh z US/Pacificz2018-01-01 08:00c C s t |dd�}||kst�d S )NT)rp )r r2 )r# r� r& r% r' r' r( �test_timestamp_utc_truec s z&TestToDatetime.test_timestamp_utc_true�dt_strZ00010101Z13000101Z30000101Z99990101c C s. d}t jt|d�� t|dd� W d Q R X d S )Nz"Out of bounds nanosecond timestamp)rt z%Y%m%d)r. )ru rv r r )r# r� ry r' r' r( �*test_to_datetime_with_format_out_of_boundsr s z9TestToDatetime.test_to_datetime_with_format_out_of_boundsc C s4 t jtd�gtd�}t|dd�}|jtjks0t�d S )Nz2012-06-13T01:39:00Z)r T)rp ) r r r r r rh r� rp r2 )r# r$ r% r' r' r( �test_to_datetime_utcy s z#TestToDatetime.test_to_datetime_utcc C sT ddl m} tddd|d�tddd|d�tddd|d�g}t|�}|j|ksPt�d S )Nr )� fixed_offi� r, )rk r- rQ )Z-pandas.tests.indexes.datetimes.test_timezonesr� r r rh r2 )r# r� rm r% r' r' r( � test_to_datetime_fixed_offset s z,TestToDatetime.test_to_datetime_fixed_offset)Er r� r� ru r� r� r r� r� r� r� r� r� r� Zskip_if_windowsr� r� r� r� r r� r� r� r� r� r� r r r! r" r� r r r1 r� r� r� r� Z skip_if_nor� r� r� r� r� r� �tupler r� r r� r� r� r� rE r r r� r� r� r� r� r� r� r� r� r� r� r� r� r' r' r' r( r� � s " ' & ( & r� c @ s� e Zd Zej�dddg�dd� �Zej�dddg�dd� �Zej�dddg�dd � �Zej�dddg�d d � �Z ej�dddg�d d � �Z ej�dddg�dd� �Z ej�dddg�dd� �Z ej�dddg�dd� �Z dd� Zdd� Zdd� ZdS )�TestToDatetimeUnitr* TFc C s� d}t jt|d�� tdgdd|d� W d Q R X dddtttjd d g}t|dd |d �}tdt d �t d �tttttgt d�}t � ||� t|dd|d �}t d d d d d d d d g�}t � ||� d}t jt|d�� t|dd|d � W d Q R X dtttjd g}t|d d|d�}tdttttgt d�}t � ||� t|dd|d�}t d d d d d g�}t � ||� d}t jt|d�� t|dd|d� W d Q R X xndt d�gD ]^}yt|dd|d� W nB tk �r� } ztd�|�W d d }~X Y n tk �r� Y nX �q�W d S )Nz#cannot specify both format and unit)rt r, r� z%Y%m%d)r� r. r* iNJ� g �?r rs r> )r� r? r* z 1970-01-02)r rB z/cannot convert input 11111111 with the unit 'D'r� l � _B*rF )r? r� r* z4cannot convert input 1420043460000 with the unit 's'r{ r� zincorrect exception raised)ru rv rw r r r r rE r r r r! r" r r r2 )r# r* ry r3 r% r& rZ �errr' r' r( � test_unit� sP z TestToDatetimeUnit.test_unitc C s� t d�}tddd|d�}||ks$t�t|t �s2t�tddd|d�}||ksNt�t|t �s\t�tddd|d�}||ksxt�t|t �s�t�d S )Nz1970-05-09 14:25:11iNJ� rF r� )r� r? r* rB r> )r r r2 r0 )r# r* r& r% r' r' r( �test_unit_consistency� s z(TestToDatetimeUnit.test_unit_consistencyc C s� t ddg�}ddg}t�|��d�}x@dD ]8}t|||d�}t�||� t|||d�}t�||� q*W t dddg�}d ddg}t|d |d�}t�||� t ddddg�}ddd dg}t|d |d�}t�||� d S ) Nz2015-06-19 05:33:20z2015-05-27 22:33:20g@�� �Cg�A�5�Cr� )r> r� rB )r? r* r r{ rB )r r r r� r r! r" )r# r* r& Zarr1Zarr2r? r% r$ r' r' r( �test_unit_with_numeric� s" z)TestToDatetimeUnit.test_unit_with_numericc C s� t dddg�}td�ddg}t|d|d�}t�||� d}tjt|d �� t|d |d� W d Q R X t dddg�}ddtd�g}t|d|d�}t�||� tjt|d �� t|d |d� W d Q R X d S ) Nz 2013-01-01r r� g@�� �Cg�A�5�CrB )r? r* z,mixed datetimes and integers in passed array)rt r� )r r r r! r" ru rv rw )r# r* r& r$ r% ry r' r' r( �test_unit_mixed� s z"TestToDatetimeUnit.test_unit_mixedc C s& t dd|d�}td�}||ks"t�d S )Ng� �� a�ArF )r� r* z 2015-06-19 19:55:31.877000192)r r r2 )r# r* r% r& r' r' r( �test_unit_rounding s z%TestToDatetimeUnit.test_unit_roundingc C s2 t dgd dd�}t|dd|d�}t�||� d S )Ng ��� Br- r| )r| r> rF )r? r� r* )r r r! r" )r# r* r& r% r' r' r( �test_unit_ignore_keeps_name s z.TestToDatetimeUnit.test_unit_ignore_keeps_namec C s~ t ddgddgddgddgd d gd d gd d gddgddgd� �}t|d |d |d d�|d�}ttd�td�g�}t�||� t|dddg �� |d�}t�||� |dddg �� }d|d< t||d�}ttd�td�g�}t�||� dddddd d �dddd d d d �g}xN|D ]F}t|t|�� � j |d!�|d�}ttd"�td#�g�}t�||� �qW dddd d d d$d%d&d� }t|j |d!�|d�}ttd'�td(�g�}t�||� t|� t �|d�}t�||� t ddgdd)gddgd��}d*} t j t| d+�� t||d� W d Q R X t|d,|d-�}ttd�tg�}t�||� d.} t j t| d+��" |�� }d |d/< t||d� W d Q R X d0} xXdgddgddd gddgddd ggD ]0} t j t| d+�� t|| |d� W d Q R X �q�W d1} t ddgdd)gddgd��}dddg|_t j t| d+�� t||d� W d Q R X t ddgdd)gddgddgd2��}ddddg|_t j t| d+�� t||d� W d Q R X d S )3Ni� i� r- rQ rL r9 r� � �: �; rO r� r, ) r� r� r� r� r� �second�ms�us�nsr� r� r� )r� r� r� )r* z20150204 00:00:00z20160305 00:0:00z20160205 00:0:00Zyears�months�days�hours�minutes�seconds)r� r� r� r� r� r r� r� r )�columnsz20150204 06:58:10z20160305 07:59:11r r r z20150204 06:58:10.001002003z20160305 07:59:11.001002003� zTcannot assemble the datetimes: time data .+ does not match format '%Y%m%d' \(match\))rt rB )r? r* z?extra keys have been passed to the datetime assemblage: \[foo\]r{ z`to assemble mappings requires at least that \[year, month, day\] be specified: \[.+\] is missingz#cannot assemble with duplicate keys)r� r� r� r� )r r r r r! r1 �to_dictr� �keys�renamer� rD ru rv rw r �copyr ) r# r* �dfr% r& Zdf2Z expected2�units�dry �cr' r' r( �test_dataframe s� z!TestToDatetimeUnit.test_dataframec C s� t ddgddgddgd��}t|�d�|d �}ttd �td �g�}t�||� |d �d �|d < |d �d �|d< t||d �}ttd �td �g�}t�||� t ddgddgddgd��}d}tjt |d�� t||d � W d Q R X d S )Ni� i� r- rQ rL r9 )r� r� r� Zint16)r* z20150204 00:00:00z20160305 00:00:00r� Zint8r� i� i� g �?r, z:cannot assemble the datetimes: unconverted data remains: 1)rt ) r r r� r r r! r1 ru rv rw )r# r* r r% r& ry r' r' r( �test_dataframe_dtypes� s z(TestToDatetimeUnit.test_dataframe_dtypesc C sV t ddgddgddgd��}t|dd �}ttjd d gd d ��j�d�}t�||� d S )Ni� i� r- rQ rL r9 )r� r� r� T)rp z 2015-02-04z 2016-03-05zdatetime64[ns])r rg ) r r r r r r^ � tz_localizer! r1 )r# r r% r& r' r' r( �test_dataframe_utc_true� s z*TestToDatetimeUnit.test_dataframe_utc_truec C s0 t dgdddd�}tdgdd�}t�||� d S ) Nr, rF Tr> )r� rp r? z1970-01-01 00:00:01rg )rh )r r r! r" )r# r% r& r' r' r( �'test_to_datetime_errors_ignore_utc_true� s z:TestToDatetimeUnit.test_to_datetime_errors_ignore_utc_truec s& d� t � fdd�td�D ��}t|dd�}t dd� td�D ��}t�||� t � fdd�td�D ���t�}t|dd�}t d d� td�D ��}t�||� t � fd d�td�D �tg �}t|dd�}t d d� td�D �tg �}t�||� t � fd d�td�D �tg ��t�}t|dd�}t d d� td�D �tg �}t�||� t � fdd�t � ddd�D �tg ��t�}t|dd�}t dd� t � ddd�D �tg �}|� d�}t�||� t j t � fdd�td�D ���t�t t jg�gdd�}t|dd�}t dd� td�D �tg �}t�||� tdddtt jgdd�}ttd�td �gdgd �}t�||� d }tjt|d �� tddd gdd� W d Q R X d!}tjt|d �� tddd"gdd� W d Q R X ttd�td �gdgd �}tddd gdd#d$�}t�||� tddd"gdd#d$�}t�||� d S )%Ni��Qc s g | ] }� | �qS r' r' )r: �t)�epochr' r( r< � s z<TestToDatetimeUnit.test_to_datetime_unit.<locals>.<listcomp>r rF )r� c S s g | ]}t d �t|d� �qS )z2013-06-09 02:42:28)r )r r )r: r r' r' r( r< � s c s g | ] }� | �qS r' r' )r: r )r r' r( r< � s c S s g | ]}t d �t|d� �qS )z2013-06-09 02:42:28)r )r r )r: r r' r' r( r< � s c s g | ] }� | �qS r' r' )r: r )r r' r( r< � s c S s g | ]}t d �t|d� �qS )z2013-06-09 02:42:28)r )r r )r: r r' r' r( r< � s c s g | ] }� | �qS r' r' )r: r )r r' r( r< � s c S s g | ]}t d �t|d� �qS )z2013-06-09 02:42:28)r )r r )r: r r' r' r( r< � s c s g | ] }� | �qS r' r' )r: r )r r' r( r< � s r r- g �?c S s g | ]}t d �t|d� �qS )z2013-06-09 02:42:28)r )r r )r: r r' r' r( r< � s r c s g | ] }� | �qS r' r' )r: r )r r' r( r< � s T)Z ignore_indexc S s g | ]}t d �t|d� �qS )z2013-06-09 02:42:28)r )r r )r: r r' r' r( r< s r, r r� z 1970-01-02z 1970-01-03rQ z+non convertible value foo with the unit 'D')rt r{ z0cannot convert input 111111111 with the unit 'D'i�k�rB )r� r? )r �ranger r! r1 r� �floatr r r Zarange�round�pd�concatrE r r r" ru rv rw r )r# rF r% r& ry r' )r r( �test_to_datetime_unit� sn & , * z(TestToDatetimeUnit.test_to_datetime_unitN)r r� r� ru r� r� r� r� r� r� r� r� r r r r r r' r' r' r( r� � s ; r� c @ s� e Zd Zdd� Zej�dddg�dd� �Zej�dddg�dd � �Zej�dddg�d d � �Z ej�dddg�d d � �Z e j ej�dddg�dd� ��Z ej�dddg�dd� �Zej�dddg�dd� �Zej�dddg�dd� �Zdd� Zdd� Zdd� Zej�dddg�d d � �Zej�d d d d!d"d#d$g�ej�dddg�d%d&� ��Zej�dddg�d'd(� �Zej�d)eeg�d*d+� �Zd,S )-�TestToDatetimeMiscc C s: t jdgtd�}d}tjt|d�� t|� W d Q R X d S )Nz 2262-04-11 23:47:16.854775808)r z"Out of bounds nanosecond timestamp)rt )r r r ru rv r r )r# r$ ry r' r' r( �%test_to_datetime_barely_out_of_bounds" s z8TestToDatetimeMisc.test_to_datetime_barely_out_of_boundsr* TFc C sP t dg|d�}td�}|d |ks&t�t dg|d�}td�}|d |ksLt�d S )Nz2012-01-01 00:00:00)r* r Z20121001z 2012-10-01)r r r2 )r# r* r% r[ r' r' r( �test_to_datetime_iso8601, s z+TestToDatetimeMisc.test_to_datetime_iso8601c C s( t d|d�}tddd�}||ks$t�d S )NZ2001)r* i� r, )r r r2 )r# r* �rsZxpr' r' r( �test_to_datetime_default6 s z+TestToDatetimeMisc.test_to_datetime_defaultc C s4 t tddd��}t||d�}|d |d ks0t�d S )Nz1/1/2000rO )r� )r* r )r r r r2 )r# r* rF r% r' r' r( �%test_to_datetime_on_datetime64_seriesB s z8TestToDatetimeMisc.test_to_datetime_on_datetime64_seriesc C s� t dddg�}d}tjt|d�� t|d|d� W d Q R X t|d|d�}t td d d �td d d �tg�}t�||� t|d |d�}t�||� d S )Nz 10/18/2006z 10/18/2008� z0(\(')?String does not contain a date(:', ' '\))?)rt r� )r? r* rB i� rO r� i� r> ) r ru rv rw r r r r! r1 )r# r* rF ry Z result_coerceZexpected_coerceZ result_ignorer' r' r( �%test_to_datetime_with_space_in_seriesJ s z8TestToDatetimeMisc.test_to_datetime_with_space_in_seriesc s� t dddgdddgd�}t|d� d �}|jtd� d �}t�||� t ddd gdddgd�}d }tjt|d �� t|dd � d� W d Q R X tjt|d �� |jtdd � d� W d Q R X t|dd� d�}|�� fdd��}t�||� d S )NzMay 04zJun 02zDec 11r, r- rQ )�indexz%b %y)r. r* rs z4time data '' does not match format '%b %y' \(match\))rt r� )r. r? r* rB c s t | dd� d�S )Nz%b %yrB )r. r? r* )r )r; )r* r' r( �<lambda>k � z@TestToDatetimeMisc.test_to_datetime_with_apply.<locals>.<lambda>)r r rC r! r1 ru rv rw )r# r* r� r& r% ry r' )r* r( �test_to_datetime_with_applyW s z.TestToDatetimeMisc.test_to_datetime_with_applyc C s� t d|d�}|tkst�t ddg|d�}t|��� s8t�td�}t d|d�}||ksXt�t dg|d�d }t d|d�}||ks�t�ddg}tt ||d��}dd� |D �}t�||� d S ) Nrs )r* r Z2012Z20120101z20120101 12:01:01c S s g | ] }t |��qS r' )r )r: �date_strr' r' r( r< � s z=TestToDatetimeMisc.test_to_datetime_types.<locals>.<listcomp>) r r r2 r �allr r� r! �assert_almost_equal)r# r* r% r& r r' r' r( �test_to_datetime_typeso s z)TestToDatetimeMisc.test_to_datetime_typesc C sh t ddgd|d�}ttjddgdd��}t�||� d}tjt|d�� t ddgd |d� W d Q R X d S ) Nr, �1r> )r? r* �O)r z#invalid string coercion to datetime)rt r� ) r r r r r! rl ru rv r� )r# r* r% r& ry r' r' r( �$test_to_datetime_unprocessable_input� s z7TestToDatetimeMisc.test_to_datetime_unprocessable_inputc C s. t dggd �}t|d|d�}t�||� d S )Nr� �d r> )r? r* )r r r! r1 )r# r* �seriesr% r' r' r( �!test_to_datetime_unhashable_input� s z4TestToDatetimeMisc.test_to_datetime_unhashable_inputc C sR t �d��d�}|�d�}t|g�}|d |�d�ks:t�t|�}||ksNt�d S )Nl `SD& zM8[us]r1 r )r r� �viewr� r r2 r )r# r� Zas_objr( r� r' r' r( �'test_to_datetime_other_datetime64_units� s z:TestToDatetimeMisc.test_to_datetime_other_datetime64_unitsc C s8 t ddd�}t|j�}t|j�}t|�}t�||� d S )Nz1/1/2000r )r� )r r r3 r� Zasi8r! r" )r# �rng�intsr% r' r' r( �!test_to_datetime_list_of_integers� s z4TestToDatetimeMisc.test_to_datetime_list_of_integersc C s< d� dddg�}tjt|d�� tdddd � W d Q R X d S ) N�|z)Python int too large to convert to C longzlong too big to convertzint too big to convert)rt z1/1/1700�Bi�� )�startr� r� )�joinru rv r r )r# ry r' r' r( �test_to_datetime_overflow� s z,TestToDatetimeMisc.test_to_datetime_overflowc C s6 t jddt jdgtd�}t jddd�}x2t|�D ]&\}}t|�rJt||< q0t|�||< q0W t � |�d }t � ||� t ||d�}t|t�s�t�t �||j� t jd t jgtd�}d } tjt| d �� t |d |d � W d Q R X t |d|d �}t|�}t �||� tjt| d �� t |d |d � W d Q R X dddddg} tdt jdt jdg| dd�} tt d|d�t jt d|d�t jt d|d�g| dd�} t | |d�}t | |d�} tt jddd�| d�}x>td�D ]2}| | }t|��r�t||< nt ||d�||< �q�W t j||dd� |j dk�st�t j| |dd� | j dk�s2t�d S ) Nz1/1/2000z1/2/2000z1/4/2000, 12:34:56)r rL zM8[ns]r )r* z 1/100/2000z4Unknown string format:|day is out of range for month)rt r� )r? r* r> r� r� r r �ez1/3/2000z1/5/2000r{ )r( r| r9 )r( F)Z check_names) r r rE r �emptyr/ r r r r Zarray_to_datetimer! r. r r0 r r2 Zassert_numpy_array_equalr3 ru rv rw r r" r r r r1 r| )r# r* �stringsr& r6 rZ r% �result2Z malformedry �idxr4 ZdseriesZdresultr; r' r' r( � test_string_na_nat_conversion� sX z0TestToDatetimeMisc.test_string_na_nat_conversionr z datetime64[h]z datetime64[m]z datetime64[s]zdatetime64[ms]zdatetime64[us]zdatetime64[ns]c C sF t dddg|d�}|j�|�}t�t|�|� t�t ||d�|� d S )Nz2000-01-01T00:00z2000-01-02T00:00r )r* )r r3 r� r! r" r )r# r* r �baser3 r' r' r( �$test_dti_constructor_numpy_timeunits s z7TestToDatetimeMisc.test_dti_constructor_numpy_timeunitsc C s� dddg}t tddd�tddd�tddd�g�}t |d d �}t t�|�d d �}t|d |d �}tt�|�d |d �}t t|�d d �}t t|�d d �} t�||� t�||� t�||� t�||� t�||� t�|| � d S ) Nz 10/02/2014z 11/02/2014z 12/02/2014i� r- rO r� r@ T)�dayfirst)rH r* ) r r r r r r r r! r" ) r# r* r$ r& Zidx1Zidx2Zidx3Zidx4Zidx5Zidx6r' r' r( � test_dayfirst s $ z TestToDatetimeMisc.test_dayfirst�klassc C sH t ddd��d�}|�d�}||�}||�}t|dd�}t�||� d S )Nz 2015-04-05rQ )r� r{ rg T)rp )r r r r r! rl )r# rJ r� r& �objr% r' r' r( �test_to_datetime_dta_tz2 s z*TestToDatetimeMisc.test_to_datetime_dta_tzN)r r� r� r! ru r� r� r" r$ r% r' r� r� r+ r/ r2 r5 r7 r: r? rE rG rI r r rL r' r' r' r( r ! s2 F r c @ s e Zd Zejdd� �ZdS )�TestGuessDatetimeFormatc C s� d}t dddddd��|�}tj|||gdd�tjtjtj|gdd�tj|dgdd�g}x |D ]}t�|�|ks^t�q^W t�tjtjtjtjgdd��}|d ks�t�d S ) Nz%Y-%m-%d %H:%M:%S.%fi� r@ rP r r1 )r � random_string)r �strftimer r rE r� Z _guess_datetime_format_for_arrayr2 )r# Zexpected_format� dt_stringZ test_arraysZ test_arrayZformat_for_string_of_nansr' r' r( �$test_guess_datetime_format_for_array@ s z<TestGuessDatetimeFormat.test_guess_datetime_format_for_arrayN)r r� r� r� Zskip_if_not_us_localerQ r' r' r' r( rM ? s rM c @ s� e Zd Zej�dddg�dd� �Zej�dddg�dd� �Zej�dddg�dd � �Zej�dddg�d d � �Z ej�d d ddg�dd� �Z ej�dddg�dd� �Z dS )�TestToDatetimeInferFormatr* TFc s� t tdddd��}dddg}x`|D ]X� |�� fdd ��}t|� |d �}t|d |d �}t|d |d �}t�||� t�||� q"W d S )Nr+ �2 �H)r� r� z%m-%d-%Yz%m/%d/%Y %H:%M:%S.%fz%Y-%m-%dT%H:%M:%S.%fc s | � � �S )N)rO )r; )� test_formatr' r( r) \ r* zdTestToDatetimeInferFormat.test_to_datetime_infer_datetime_format_consistent_format.<locals>.<lambda>)r. r* F)r� r* T)r r rC r r! r1 )r# r* rF Z test_formatsZs_as_dt_stringsZ with_formatZno_inferZ yes_inferr' )rU r( �8test_to_datetime_infer_datetime_format_consistent_formatU s zRTestToDatetimeInferFormat.test_to_datetime_infer_datetime_format_consistent_formatc C sl t t�dddg��}t�t|d|d�t|d|d�� t t�ddd g��}t�t|d|d�t|d|d�� d S ) Nz01/01/2011 00:00:00z01-02-2011 00:00:00z2011-01-03T00:00:00F)r� r* Tz Jan/01/2011z Feb/01/2011z Mar/01/2011)r r r r! r1 r )r# r* rF r' r' r( �:test_to_datetime_infer_datetime_format_inconsistent_formatk s zTTestToDatetimeInferFormat.test_to_datetime_infer_datetime_format_inconsistent_formatc C sB t tjdtjdtjgtd��}t�t|d|d�t|d|d�� d S )Nz01/01/2011 00:00:00z01/03/2011 00:00:00)r F)r� r* T)r r r rE r r! r1 r )r# r* rF r' r' r( �7test_to_datetime_infer_datetime_format_series_with_nans� s zQTestToDatetimeInferFormat.test_to_datetime_infer_datetime_format_series_with_nansc C sD t tjtjtjdddgtd��}t�t|d|d�t|d|d�� d S )Nz01/01/2011 00:00:00z01/02/2011 00:00:00z01/03/2011 00:00:00)r F)r� r* T)r r r rE r r! r1 r )r# r* rF r' r' r( �=test_to_datetime_infer_datetime_format_series_start_with_nans� s zWTestToDatetimeInferFormat.test_to_datetime_infer_datetime_format_series_start_with_nansztz_name, offset)rg r )zUTC-3� )zUTC+3iL���c C sF t d|� �g�}t|dd�}t td��t�|��g�}t�||� d S )Nz2019-02-02 08:07:13 T)r� z2019-02-02 08:07:13)r r r r r� r� r! r1 )r# Ztz_namerr rF r% r& r' r' r( �"test_infer_datetime_format_tz_name� s z<TestToDatetimeInferFormat.test_infer_datetime_format_tz_namec C sV t dddg�}t td�td�td�g�}t�t||d�|� t�t|d|d �|� d S ) Nz2014-1-1z2014-2-2z2015-3-3z 2014-01-01z 2014-02-02z 2015-03-03)r* z%Y-%m-%d)r. r* )r r r! r1 r )r# r* rF r& r' r' r( �%test_to_datetime_iso8601_noleading_0s� s z?TestToDatetimeInferFormat.test_to_datetime_iso8601_noleading_0sN) r r� r� ru r� r� rV rW rX rY r[ r\ r' r' r' r( rR T s rR c @ sZ e Zd Zej�dddg�dd� �Zej�dddg�dd� �Zej�dddg�dd � �Zd S ) �TestDaysInMonthr* TFc C sb t tdd|d��st�t tddd|d��s.t�t tddd|d��sFt�t tddd|d��s^t�d S )Nz 2015-02-29rB )r? r* z%Y-%m-%d)r. r? r* z 2015-02-32z 2015-04-31)r r r2 )r# r* r' r' r( � test_day_not_in_month_coerce� s z,TestDaysInMonth.test_day_not_in_month_coercec C s� d}t jt|d�� tdd|d� W d Q R X d}t jt|d�� tddd|d� W d Q R X d }t jt|d�� td dd|d� W d Q R X d }t jt|d�� td dd|d� W d Q R X d S ) Nz day is out of range for month)rt z 2015-02-29r� )r? r* z3time data 2015-02-29 doesn't match format specifiedz%Y-%m-%d)r? r. r* z3time data 2015-02-32 doesn't match format specifiedz 2015-02-32z3time data 2015-04-31 doesn't match format specifiedz 2015-04-31)ru rv rw r )r# r* ry r' r' r( �test_day_not_in_month_raise� s z+TestDaysInMonth.test_day_not_in_month_raisec C sb t dd|d�dkst�t ddd|d�dks.t�t ddd|d�dksFt�t ddd|d�dks^t�d S )Nz 2015-02-29r> )r? r* z%Y-%m-%d)r? r. r* z 2015-02-32z 2015-04-31)r r2 )r# r* r' r' r( � test_day_not_in_month_ignore� s z,TestDaysInMonth.test_day_not_in_month_ignoreN) r r� r� ru r� r� r^ r_ r` r' r' r' r( r] � s r] c 5 @ s� e Zd Zej�deeddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�eddd�edd d�edd d�edd d�edd d�ed d d �edd d �edd d dd �edd d dd�edd d dd �edd d dd�edd d dd �edd d dd�edd dddd�edd d�edd d�eddd�eddd�eddd�eddd�eddd�edddd�eddddd�edddddd�d�+�� ��ej�dd d g�d d � ��Z ej�dd d g�d d!� �Z d"d#� Z ej�dd d g�d$d%� �Z ej�dd d g�d&d'� �Z ej�dd d g�ej�d(d)e�d*�d+fd,e�d-�d.fg�d/d0� ��Zd1S )2�TestDatetimeParsingWrapperszdate_str,expectedi� r, i� rL r� i� rO r� i� r9 � r� � r i� � �$ � i� r� i� r@ �" �8 )+z 2011-01-01Z2Q2005Z2Q05Z2005Q1Z05Q1Z2011Q3Z11Q3Z3Q2011Z3Q11Z2000Q4Z00Q4Z4Q2000Z4Q00Z2000q4z2000-Q4z00-Q4z4Q-2000z4Q-00Z00q4Z2005z2005-11z2005 11z11-2005z11 2005Z200511Z20051109z20051109 10:15z 20051109 08Hz2005-11-09 10:15z2005-11-09 08Hz2005/11/09 10:15z2005/11/09 08HzThu Sep 25 10:36:28 2003zThu Sep 25 2003z Sep 25 2003zJanuary 1 2014z2014-06z06-2014z2014-6z6-2014z 20010101 12z 20010101 1234z20010101 123456r* TFc C s d}t j||d�\}}t||d�}t|g|d�}ttj|gtd�||d�} t|g|d�} tt|g�|d�} tt|g�|d�} x ||gD ]} | |ks�t �q�W x0|| | | | gD ] } tt |�g�}t � | |� q�W |�st |�}||ks�t �t |dd|d�}||k�st �d S )NT)� yearfirst)r )ri r* �Sr, )r� r� ri )r �parse_time_stringr r r r r r r r2 r r! r" r )r# r, r& r* ri �result1rY rC �result3�result4Zresult6Zresult8Zresult9r� r[ �result5Zresult7r' r' r( � test_parsers� s& 9 z(TestDatetimeParsingWrappers.test_parsersc C s0 t ttgdd�}t||g|d�}t�||� d S )Nzdatetime64[ns])r )r* )r r r r! r" )r# r* Zunique_nulls_fixtureZunique_nulls_fixture2r& r% r' r' r( �test_na_values_with_cacheE s z5TestDatetimeParsingWrappers.test_na_values_with_cachec C s` t �d�\}}td�}td�}tdg�d }|tks8t�|tksDt�|tksPt�|tks\t�d S )Nr r )r rk r r r r r2 )r# rl rY rC rm rn r' r' r( �test_parsers_natN s z,TestDatetimeParsingWrappers.test_parsers_natc C sN ddt ddd�fddt ddd�fddt ddd�fddt ddd�fgddt ddd �fddt ddd �fddt d dd �fddt d dd �fgd �}x�|�� D ]�\}}x�|D ]�\}}}t|||d �}||ks�t�tj|||d �\} } |s�|s�t|�} | |ks�t�t||||d�} t|g||d �d } | |k�s(t�| |k�s6t�| |ks�t�q�W q�W d S )NFi� rO r� Ti� r@ i� r i� � )z10-11-12z20/12/21)rH ri )rH ri r* r ) r r� r r2 r rk r r r )r# r* �casesr, r3 rH ri r& Zdateutil_resultrl rY rC rm rn r' r' r( � test_parsers_dayfirst_yearfirstY s4 - z;TestDatetimeParsingWrappers.test_parsers_dayfirst_yearfirstc C s� t d�tddddd�ft d�tddddd�fd�}x�|�� D ]~\}\}}t�|�\}}t|�}t|g�} t|�} t|g�d } ||ks�t�||ks�t�| |ks�t�| |ks�t�| |ks<t�q<W d S ) Nz10:15r, rO r� z9:05rb r9 )z10:15z9:05r ) r r r� r rk r r r r2 ) r# r* rt r, Zexp_nowZexp_defrl rY rC rm rn ro r' r' r( �test_parsers_timestring� s z3TestDatetimeParsingWrappers.test_parsers_timestringz dt_string, tz, dt_string_reprz2013-01-01 05:45+0545iY zATimestamp('2013-01-01 05:45:00+0545', tz='pytz.FixedOffset(345)')z2013-01-01 05:30+0530iJ zATimestamp('2013-01-01 05:30:00+0530', tz='pytz.FixedOffset(330)')c C sH t d|d�}|�d��|�}t ||d�}||ks4t�|t|�ksDt�d S )Nz2013-01-01 00:00:00)r* rg )r r Z tz_convertr2 �repr)r# r* rP rh Zdt_string_reprrF Zdt_timer' r' r( �.test_parsers_timezone_minute_offsets_roundtrip� s zJTestDatetimeParsingWrappers.test_parsers_timezone_minute_offsets_roundtripN)r r� r� ru r� r� r� r r� rp rq rr ru rv r� r� rx r' r' r' r( ra � sx Xra r� rF r r r )�paramsc C s | j S )zIDay and some time units. * D * s * ms * us * ns )�param)�requestr' r' r( r � s r c C s t d�S )zTimestamp at 1960-01-01.z 1960-01-01)r r' r' r' r( � epoch_1960� s r| c C s t td��S )Nr9 )r� r r' r' r' r( �units_from_epochs� s r} � timestamp� pydatetimer� �str_1960c C sL |j dkst�|j dkr | S |j dkr.| �� S |j dkr@| �� S t| �S dS )zxTimestamp at 1960-01-01 in various forms. * Timestamp * datetime.datetime * numpy.datetime64 * str > r� r r~ r� r~ r r� N)rz r2 Z to_pydatetimeZ to_datetime64rD )r| r{ r' r' r( �epochs� s r� c C s t ddd��� jS )Nz2014-1-1rO )r� )r �to_julian_dater3 r' r' r' r( � julian_dates s r� c @ s� e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zej � d d e fd e fde fe ddd�e fg�dd� �Zdd� Zej � dddg�dd� �Zdd� Zej � dd d d gd dd gd d d gd dd!gg�d"d#� �ZdS )$� TestOriginc C s� t t|ddd��}t t|td��� dd��}t�||� t tdddgddd��}t td �td �td �g�}t�||� t tdddgdd��}t td �td �td �g�}t�||� d S ) Nr� �julian)r� �originr )r� r, r- �unixz 1970-01-01z 1970-01-02z 1970-01-03)r r r r� r! r1 )r# r� r% r& r' r' r( � test_to_basic s zTestOrigin.test_to_basicc C sN t dddd�}|�� dks t�d}tjt|d�� t dddd� W d Q R X d S )NiR|% r� r� )r� r� z&1 is Out of Bounds for origin='julian')rt r, )r r� r2 ru rv rw )r# r% ry r' r' r( �test_julian_round_trip, s z!TestOrigin.test_julian_round_tripc C s8 |dkr4d}t jt|d�� t||dd� W d Q R X d S )Nr� z$unit must be 'D' for origin='julian')rt r� )r� r� )ru rv rw r )r# r r� ry r' r' r( �test_invalid_unit5 s z TestOrigin.test_invalid_unitc C sV d}t jt|d�� tddd� W d Q R X t jt|d�� tdddd� W d Q R X d S )Nz(it must be numeric with a unit specified)rt z 2005-01-01z 1960-01-01)r� r� )r� r� )ru rv rw r )r# ry r' r' r( �test_invalid_origin= s z TestOrigin.test_invalid_originc s: t � �fdd�|D ��}t t|�|d��}t�||� d S )Nc s g | ]}t j|�d �� �qS ))r� )r Z Timedelta)r: r; )r| r r' r( r< J s z)TestOrigin.test_epoch.<locals>.<listcomp>)r� r� )r r r! r1 )r# r r� r| r} r& r% r' )r| r r( � test_epochG s zTestOrigin.test_epochz origin, excrN r z 13-24-1990r, c C s8 d|� d�}t j||d�� t|||d� W d Q R X d S )Nzorigin z6 (is Out of Bounds|cannot be converted to a Timestamp))rt )r� r� )ru rv r )r# r� �excr r} ry r' r' r( �test_invalid_originsP s z TestOrigin.test_invalid_originsc C s: t jtdd��" tddtdddtjd�d� W d Q R X d S )Nzmust be tz-naive)rt r, r� i� )rk )r� r� )ru rv rw r r r� rp )r# r' r' r( �test_invalid_origins_tzinfo_ s z&TestOrigin.test_invalid_origins_tzinfor. Nz%Y-%m-%d %H:%M:%Sc C s. d}t jt|d�� td|d� W d Q R X d S )Nz"Out of bounds nanosecond timestamp)rt z2417-10-27 00:00:00)r. )ru rv r r )r# r. ry r' r' r( �.test_to_datetime_out_of_bounds_with_format_argd s z9TestOrigin.test_to_datetime_out_of_bounds_with_format_argc C sh t ddd�}td�}||ks t�t dddd�}td�}||ksBt�t dddd�}td �}||ksdt�d S ) Ni( r� )r� z2169-11-13 00:00:00z 1870-01-01)r� r� z2069-11-13 00:00:00i�� z2169-10-20 00:00:00)r r r2 )r# r% r& r' r' r( �test_processing_orderk s z TestOrigin.test_processing_orderzoffset,utc,exp�ZTz2019-01-01T00:00:00.000Zz-01:00z2019-01-01T01:00:00.000Zz 2019-01-01T00:00:00.000-01:00c C s2 d| }t |gd|d�}t |g�}t�||� d S )Nz2019-01-01T00:00:00.000r )r� rp )r r! r" )r# rr rp r[ r} r% r& r' r' r( �test_arg_tz_ns_unit{ s z TestOrigin.test_arg_tz_ns_unit)r r� r� r� r� r� r� r� ru r� r� rw r r r� r� r� r� r� r' r' r' r( r� s( r� zlistlike,do_cachingr, r- rQ rL r9 r� r� rc rb FTc C s t j| t| �dd�|ks t�d S )Ngffffff�?)� check_count� unique_share)r� r� r� r2 )r� Z do_cachingr' r' r( �test_should_cache� s r� z%unique_share,check_count, err_message)g �?r� z5check_count must be in next bounds: \[0; len\(arg\)\])rO r- z-unique_share must be in next bounds: \(0; 1\)c C s6 dgd }t jt|d�� t�|| |� W d Q R X d S )Nr9 rO )rt )ru rv r2 r� r� )r� r� Z err_messager} r' r' r( �test_should_cache_errors� s r� c C s| t ddd dd g�} | �d�} | �� }t| dd�}t t�d�t�d�t�d �t�d �t�d �g�}t�||� t�| |� d S ) Nr, r- l ZInt64r )r� z 1970-01-01 00:00:00.000000001z 1970-01-01 00:00:00.000000002r z 2043-01-25 23:56:49.213693952)r r� r r r r� r! r1 )r� Zser_copyr� r& r' r' r( �!test_nullable_integer_to_datetime� s r� rJ c C sV t | t�r4tjtdd�� t|| g�� W d Q R X n t|| g��}|d tksRt�d S )Nznot convertible to datetime)rt r )r0 r ru rv r� r r r2 )Z nulls_fixturerJ r% r' r' r( �test_na_to_datetime� s r� c C s� t dddg�} d}t| |dd�}t ddtgd d �}t�||� tjtd d �� t| |d d�}W d Q R X t| d d�}t�||� d S )Nz 03/24/2016z 03/25/2016rs z%m/%d/%YrB )r. r? z 2016-03-24z 2016-03-25zdatetime64[ns])r zdoes not match format)rt r� )r? )r r r r! r1 ru rv rw )r� r. r% r& r' r' r( �)test_empty_string_datetime_coerce__format� s r� c C sP t ddgddd�} tddgdd �}t�|| � t ddgdd d�} t�|| � d S ) Nr, rs rF rB )r� r? z1970-01-01 00:00:01r zdatetime64[ns])r r� )r r r! r" )r% r& r' r' r( �'test_empty_string_datetime_coerce__unit� s r� )M�__doc__rU � collectionsr r r �decimalr rS Zdateutil.parserr Zdateutil.tz.tzr �numpyr ru r� Z pandas._libsr Zpandas._libs.tslibsr r Z pandas.errorsr r Z pandas.util._test_decorators�utilZ_test_decoratorsr� Zpandas.core.dtypes.commonr Zpandasr r r r r r r r r r Zpandas._testingZ_testingr! Zpandas.core.arraysr Zpandas.core.toolsr r� Zpandas.core.tools.datetimesr r r� r� r rM rR r] ra Zfixturer r| r} r� r� r� r� r� r� r� r� r r� r� r� r� r' r' r' r( �<module> sx , T i3 t xB
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.05 |
proxy
|
phpinfo
|
Настройка