Файловый менеджер - Редактировать - /home/digitalm/venv/lib/python3.7/site-packages/pandas/tests/io/parser/__pycache__/test_parse_dates.cpython-37.pyc
Назад
B �5�g�� � @ s� d Z ddlmZmZ ddlmZ ddlmZ ddlm Z m Z m Z ddl ZddlZddlZddlmZ ddlmZ dd lmZmZ ddlZdd lmZmZm Z m Z m Z m Z ddl m!Z" dd l#m$Z$ ddl%m m&Z' ed d d �Z(e� r�e j)ed d d �d�Z*ne �)� Z*dd� Z+dd� Z,ej-�.dddg�dd� �Z/ej-�.de0e1e e g�ej-�.dd dg�dd � ��Z2ej-�.dddg�d d � �Z3d d � Z4ej-�.d!e'j5e6gej7dgf�d"d#� �Z8d$d%� Z9d&d'� Z:ej-�.d(d)d dggd*fd+d,d dgid-fg�d.d/� �Z;d0d1� Z<d2d3� Z=d4d5� Z>d6d7� Z?d8d9� Z@ej-jAd:d;�ej-�.d<d=d>ggdd ggg�d?d@� ��ZBej-�.d<ddgdAdBgg�dCdD� �ZCej-�.dEdd gd dgg�dFdG� �ZDej-�.dHdIdidJdig�dKdL� �ZEdMdN� ZFej-�.dOdPd dgidPfdPd dgidfd dggdfg�dQdR� �ZGdSdT� ZHdUdV� ZIdWdX� ZJej-�.dHi dEdYig�dZd[� �ZKej-�.d<d\e�Ld]d^g�d d_d_hg�d`da� �ZMej-�.dbddg�ej-�.dcdddedfg�dgdh� ��ZNdidj� ZOej-�.dkdld<dAgieedmd]dn�gdAgdo�fdldddp�eedqgdAdr�ds�fdtd<dAdugieedmd]dn�edvdwdx�ggdAdugdo�fdtddd gdp�ee jPedmd]dn�edvdwdx�fgdAdugdy�ds�fg�dzd{� �ZQej-�.d!e'j5e6gej7dgf�d|d}� �ZRej-�.d!e'j5e6gej7dgf�ej-�.dkd~dddd gid��eed�d d^d�dd�d�d�ged�d d^ddd�d�d�ggddAdugdo�fd�dd dgd d_gd��d��eed�d d�d�d�ed�d d�d�d��d�d�ged�d d�d�d�ed�d d�d�d��d�d�ged�d d�d�d�ed�d d�d�d��d�d�ged�d d�d�d�ed�d d�d�d��d�d�ged�d d�d�d�ed�d d�d�d��d�d�ged�d d�d�d�ed�d d�d�d��d�d�ggd�dPdd]gdo�fg�d�d�� ��ZSej-�.d!e'jTe6gej7dgf�d�d�� �ZUej-�.d!e'jVe6gd�d�� dgf�d�d�� �ZWej-�.d!e'jVe6gd�d�� dgf�d�d�� �ZXd�d�� ZYd�d�� ZZd�d�� Z[ej-�.d�d�edAd�d�gid�d��fd�edAd�d�d�gid�d��fg�ej-�.d<ddg�d�d�� ��Z\d�d�� Z]ej-�.d�d�d�d�d�d�d�g�d�d�� �Z^ej-�.d�d�ded�ddfd�ded�ddfd�ded�ddfd�ded�ddfd�ded�dd]�fg�d�dƄ �Z_d�dȄ Z`e e*�e ddɍej-�.d�e0d˃�ej-�.dIddg�ej-�.d�d�d�d�d�d�d�d�g�d�dՄ �����Zaej-�.d�dd�gd=d>gd�fdd�gdd>gd>fdd�gd=d>ggd�fdd�gdd>ggd>fdd�gd=dd>gid>fdd�gd=d=d>gid�fdd�gd=d>gd=gd�fd�d�d�gdd=d>gd�fd�d�d�gd�d�gd�d>gd>fg �d�d݄ �Zbd�d߄ Zcd�d� ZddS )�zO Tests date parsing functionality for all of the parsers defined in parsers.py � )�date�datetime)�StringIO)�parse)�given�settings� strategiesN)�parsing)�parse_datetime_string)�is_platform_windows�np_array_datetime64_compat)� DataFrame� DatetimeIndex�Index� MultiIndex�Series� Timestamp)� date_range� il )Z min_valuec C s� dd� }t d�}| j|dd|dd�}ddd d d g}tjd d � |D �dd�}tdddddgdddddgdddddgd�|d�}t�||� d S )Nc S s& | � tj�} | � tj�} tj| dd�S )N�s)�unit)�astype�npZfloat_�int_�pd� to_timedelta)�time� r �]/home/digitalm-up/venv/lib/python3.7/site-packages/pandas/tests/io/parser/test_parse_dates.py�__custom_date_parser7 s zCtest_read_csv_with_custom_date_parser.<locals>.__custom_date_parsera time e n h 41047.00 -98573.7297 871458.0640 389.0089 41048.00 -98573.7299 871458.0640 389.0089 41049.00 -98573.7300 871458.0642 389.0088 41050.00 -98573.7299 871458.0643 389.0088 41051.00 -98573.7302 871458.0640 389.0086 Tr )Zdelim_whitespace� parse_dates� date_parser� index_coliW� iX� iY� iZ� i[� c S s g | ]}t j|d d��qS )r )r )r r )�.0�ir r r � <listcomp>M s z9test_read_csv_with_custom_date_parser.<locals>.<listcomp>)�nameg>�٬���gV������g�z����g�1����g��� D�*Ag��� D�*Ag��� D�*Ag�St$Px@gGx $Px@g��9#Px@)�e�n�h)�index)r �read_csvr ZTimedeltaIndexr �tm�assert_frame_equal)� all_parsersr Ztestdata�resultr �expectedr r r �%test_read_csv_with_custom_date_parser5 s" r1 c C s\ | }d}t tdddddd�dggddgd �}|jt|�d d ddd gid d �}t�||� d S )Nz06-02-2013;13:00;1-000.215i� � � � r g ��Q�A�@�Date)�columns�;�-r )�sep� thousandsr �header)r r r+ r r, r- )r. �parser�datar0 �dfr r r � test_separator_date_conflictZ s " r? � keep_date_colTFc C s� d}| }dd� }|j t|�d |dddgddgd�|d �}ttd dd d d �td dd dd�dddddddddg td dd dd �td dd d d�ddddd d ddd g td dd d d �td dd dd�ddd d!d"d d#ddg td dd d d �td dd d d�ddd d$d%d&d'dd(g td dd d)d �td dd d d�ddd*d+d"d,d-dd.g td dd d/d �td dd d)d�ddd0d1d"d,d2ddg gd3d4d5d6d7d8d9d:d;d<d=g d>�}|�s�|jd6d7d8gdd?�}n |jd@k�r�|d6 �tj�|d6< ||j }t � ||� d S )ANa� KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000 c W s t �t �| ��S )z� Test date parser. Parameters ---------- date_cols : args The list of data columns to parse. Returns ------- parsed : Series )r Ztry_parse_dates�concat_date_cols)� date_colsr r r r! { s z2test_multiple_date_col_custom.<locals>.date_parser�Xr r3 � )�actual�nominal)r; r! �prefixr r@ i� � � r � �8 �KORD�19990127z 19:00:00z 18:56:00g�Q� ���?g{�G�z@g������ @g g �q@� z 20:00:00z 19:56:00g{�G�z�?g�G�z�@g @p@� z 21:00:00z 20:56:00g�z�G��g������@z 21:18:00g�G�z��g�G�z @g������ @g �p@� z 22:00:00z 21:56:00g\��(\�?gffffff@g r@� z 23:00:00z 22:56:00gffffff@rE rF �X0�X1�X2�X3�X4�X5�X6�X7�X8)r6 )�axis�python) r+ r r r �drop�enginer r �int64r6 r, r- )r. r@ r= r< r! r/ r0 r r r � test_multiple_date_col_customo s� r` � container�dimr3 c sL d}d�t � �fdd�t|�D ��}tjt|d�� t�|� W d Q R X d S )Nz0not all elements from date_cols are numpy arraysrM c 3 s | ]}� �g�V qd S )Nr )r# �_)ra �valuer r � <genexpr> s z,test_concat_date_col_fail.<locals>.<genexpr>)�match)�tuple�range�pytest�raises� ValueErrorr rA )ra rb �msgrB r )ra rd r �test_concat_date_col_fail� s rm c C s� d}| }|j t|�d dddgddgg|d�}ttdddd d �tdddd d �d ddddddddg tddddd �tdddd d �d ddddddddg tdddd d �tddddd �d dd d d dd ddg tdddd d �tdddd d �d dd d!d"d#d$dd%g tdddd&d �tdddd d �d dd'd(d d)d*dd+g tdddd,d �tdddd&d �d dd-d.d d)d/ddg gd0d1d2d3d4d5d6d7d8d9d:g d;�}|�s�|jd3d4d5gdd<�}n |jd=k�r�|d3 �tj�|d3< t � ||� d S )>Na� KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000 rC r r3 rD )r; rG r r@ i� rH rI r rJ rK rL rM z 19:00:00z 18:56:00g�Q� ���?g{�G�z@g������ @g g �q@rN z 20:00:00z 19:56:00g{�G�z�?g�G�z�@g @p@rO z 21:00:00z 20:56:00g�z�G��g������@z 21:18:00g�G�z��g�G�z @g������ @g �p@rP z 22:00:00z 21:56:00g\��(\�?gffffff@g r@rQ z 23:00:00z 22:56:00gffffff@ZX1_X2ZX1_X3rR rS rT rU rV rW rX rY rZ )r6 )r[ r\ ) r+ r r r r] r^ r r r_ r, r- )r. r@ r= r< r/ r0 r r r �test_multiple_date_col s� rn c C s� d}| }|j t|�d ddgdd�}ttddddd�tdddd d�tdddd d�tdddd d�tdddd d�gd d �}tdddddddgdddddddgdddddddgdd d d d dd gdd!dd"d#dd$ggd%d&d'd(d)d*d+g|d,�}t�||� d S )-Naz KORD,19990127 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 rC r )r; rG r r" i� rH rI r rN rO rP rS )r& rL z 18:56:00g�Q� ���?g{�G�z@g������ @g g �q@z 19:56:00g{�G�z�?g�G�z�@g @p@z 20:56:00g�z�G��g������@z 21:18:00g�G�z��g�G�z @g������ @g �p@z 21:56:00g\��(\�?gffffff@g r@rR rT rU rV rW rX rY )r6 r* )r+ r r r r r, r- )r. r= r< r/ r* r0 r r r �test_date_col_as_index_col� s( ro zdate_parser, warningc C sF d}ddgddgd�}| }t j|dd�� |jt|�d ||dd �}W d Q R X ttd dd d d �td dd dd�ddgtd dd dd �td dd d d�ddgtd dd dd �td dd dd�ddgtd dd dd �td dd dd�ddgtd dd dd �td dd dd�ddgtd dd dd �td dd dd�ddggdddd gd �}||j }t �||� d S ) Nz�KORD,19990127, 19:00:00, 18:56:00, 0.8100 KORD,19990127, 20:00:00, 19:56:00, 0.0100 KORD,19990127, 21:00:00, 20:56:00, -0.5900 KORD,19990127, 21:00:00, 21:18:00, -0.9900 KORD,19990127, 22:00:00, 21:56:00, -0.5900 KORD,19990127, 23:00:00, 22:56:00, -0.5900r r3 rD )rE rF F)�check_stacklevelrC )r; r! r rG i� rH rI r rJ rK rL g�Q� ���?rN g{�G�z�?rO g�z�G��g�G�z��rP rQ rE rF rR rV )r6 )r, �assert_produces_warningr+ r r r r6 r- )r. r! �warningr= r r< r/ r0 r r r � test_multiple_date_cols_int_cast� s@ "" rs c C sz | }d}|j t|�ddggd td�}ttd�ddddtjdgtd�ddddtjdggd d d d d ddgd�}t�||� d S )Nz]05/31/2012,15:30:00.029,1306.25,1,E,0,,1306.25 05/31/2012,15:30:00.029,1306.25,8,E,0,,1306.25r r )r r; r! z05/31/2012, 15:30:00.029g i�@�E� Z0_1r3 rD � � r2 � )r6 )r+ r r r r �nanr, r- )r. r< r= r/ r0 r r r �&test_multiple_date_col_timestamp_parse� s* rz c C s | }d}|j t|�dddgid�}ttddddd �d d d d dddgtddddd �d ddddddgtddddd �d ddddddgtddddd �d ddd d dd gtdddd d �d d dd!d"dd#gtdddd$d �d d%dd!d&ddggdd'd(d)d*d+d,d-gd.�}t�||� d S )/Na ID,date,NominalTime,ActualTime,TDew,TAir,Windspeed,Precip,WindDir KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000rF r r3 )r i� rH rI r rL z 18:56:00g�Q� ���?g{�G�z@g������ @g g �q@rN z 19:56:00g{�G�z�?g�G�z�@g @p@rO z 20:56:00g�z�G��g������@z 21:18:00g�G�z��g�G�z @g������ @g �p@rP z 21:56:00g\��(\�?gffffff@g r@rQ z 22:56:00gffffff@�ID� ActualTime�TDew�TAir� Windspeed�Precip�WindDir)r6 )r+ r r r r, r- )r. r< r= r/ r0 r r r �#test_multiple_date_cols_with_header sz r� zdata,parse_dates,msgzSdate_NominalTime,date,NominalTime KORD1,19990127, 19:00:00 KORD2,19990127, 20:00:00z0New date column already in dict date_NominalTimezCID,date,nominalTime KORD,19990127, 19:00:00 KORD,19990127, 20:00:00r{ z Date column ID already in dictc C s4 | }t jt|d�� |jt|�|d� W d Q R X d S )N)rf )r )ri rj rk r+ r )r. r= r rl r< r r r �%test_multiple_date_col_name_collisiond s r� c C s� | }d}|j t|�ddgdd� d�}tddddd d d d d d ddg gddddddddddddg ttd �gd d �d �}t�||� d S ) Nz�posix_timestamp,elapsed,sys,user,queries,query_time,rows,accountid,userid,contactid,level,silo,method 1343103150,0.062353,0,4,6,0.01690,3,12345,1,-1,3,invoice_InvoiceResource,search r c S s t �t| ��S )N)r �utcfromtimestamp�int)�xr r r �<lambda>� � z*test_date_parser_int_bug.<locals>.<lambda>)r" r r! go���?rv r2 gX�5�;N�?rD i90 r ���Zinvoice_InvoiceResource�search�elapsed�sys�userZqueriesZ query_time�rowsZ accountidZuseridZ contactid�levelZsilo�methodz2012-07-24 04:12:30Zposix_timestamp)r& )r6 r* )r+ r r r r r, r- )r. r< r= r/ r0 r r r �test_date_parser_int_bug� sD r� c C s~ | }t ttjddd�td�d���}tj|jdd�d d �f< t�d��.}|� |� |j |d d gd �}t� ||� W d Q R X d S ) N� �float64)�dtypeZ20010101)�A�BrD r2 z__nat_parse_.csvr r� )r" r ) r �dictr Zaranger ry Zilocr, Z ensure_cleanZto_csvr+ r- )r. r< r> �pathr/ r r r �test_nat_parse� s r� c C s@ d}| }|j t|�dd� d�}|j t|�dd�}t�||� d S )Nz3A,B,C 20090101,a,1,2 20090102,b,3,4 20090103,c,4,5 c S s t �| d�S )Nz%Y%m%d)r �strptime)r� r r r r� � r� z(test_csv_custom_parser.<locals>.<lambda>)r! T)r )r+ r r, r- )r. r= r< r/ r0 r r r �test_csv_custom_parser� s r� c C s> d}| }|j t|�dd�}|j t|�ddd�}t�||� d S )Nz3A,B,C 20090101,a,1,2 20090102,b,3,4 20090103,c,4,5 T)r r )r" r )r+ r r, r- )r. r= r< r/ r0 r r r �#test_parse_dates_implicit_first_col� s r� c C sn d}| }|j t|�ddgd�}tttddd��dd d�}tdd d gd dd gd d dgd�|d�}t�||� d S )Nz8date,A,B,C 20090101,a,1,2 20090102,b,3,4 20090103,c,4,5 r )r" r z1/1/2009rD )Zperiods)r& �freq�a�b�cr rv r3 rw )r� r� �C)r* )r+ r r �listr r r, r- )r. r= r< r/ r* r0 r r r �test_parse_dates_string� s $r� z#yearfirst is not surfaced in read_*)�reasonr r r c C s� d}| }|j t|�d|d�}ttdddddd�tddd dd d�tdd dd d d�gtdd�}tdd dgdddgd�|d�}t�||� d S )Nz>date,time,B,C 090131,0010,1,2 090228,1020,3,4 090331,0830,5,6 r )r" r i� r � r� r3 � rN rD ru � � date_time)r� r& rw rv r2 )r� r� )r* )r+ r r r �objectr r, r- )r. r r= r< r/ r* r0 r r r � test_yy_format_with_year_first� s r� r� r� c C sf d}| }t tddd�gdgtddd�gd��}|�ddg�}|jt|�d dg|d d �}t�||� d S ) Nz a,b,c 01/01/2010,1,15/02/2010i� r r3 � )r� r� r� r� r� r T)r" r �dayfirst)r r � set_indexr+ r r, r- )r. r r= r< r0 r/ r r r � test_parse_dates_column_list s $r� r" c C s� d}| }t jtddd�tddd�tddd�fdgddgd �}|dd gkrT|�d d�}td ddgd dd gdd dgd ddgd dd gdd dgd ddgd dd gdd dgg dddg|d�}|jt|�|dd�}t�||� d S )Nz�index1,index2,A,B,C 20090101,one,a,1,2 20090101,two,b,3,4 20090101,three,c,4,5 20090102,one,a,1,2 20090102,two,b,3,4 20090102,three,c,4,5 20090103,one,a,1,2 20090103,two,b,3,4 20090103,three,c,4,5 i� r r3 rD )�one�two�threeZindex1�index2)�namesr r� r� rv r� rw r� r� r� )r6 r* T)r" r ) r Z from_productr Z swaplevelr r+ r r, r- )r. r" r= r< r* r0 r/ r r r � test_multi_index_parse_dates s, r� �kwargsr� Z day_firstc s | }d}d� kr�|j t|�dddg� fdd�ddd d gd �}ttd d d�td dd �td dd�gdd�}td d d gdtjdgd�|ddgd�}t�||� nbd}t j t |d��J t� t ��4 |j t|�dddg� fdd�dgdd d gd� W d Q R X W d Q R X d S )Nz:foo,bar,baz 31/01/2010,1,2 01/02/2010,1,NA 02/02/2010,1,2 r� r �Q�NTUc s t | f� �S )N)�du_parse)�d)r� r r r� S r� z5test_parse_dates_custom_euro_format.<locals>.<lambda>r TZNA)r� r! r; r" r � na_valuesi� r r� r3 )r& )r� r� )r* r6 z.got an unexpected keyword argument 'day_first')rf c s t | f� �S )N)r� )r� )r� r r r� k r� )r� r! Zskiprowsr" r r� )r+ r r r r r ry r, r- ri rj � TypeErrorrq � FutureWarning)r. r� r< r= r> Z exp_indexr0 rl r )r� r �#test_parse_dates_custom_euro_formatG s< r� c C s^ | }d}|j t|�ddd�}tddgittd�gdd �d �}t�||� |jjt j ksZt �d S ) Nz Date,x 2012-06-13T01:39:00Z,0.5r T)r" r r� g �?z2012-06-13 01:39:00+00:00r5 )r& )r* ) r+ r r r r r, r- r* �tz�pytz�utc�AssertionError)r. r< r= r/ r0 r r r �test_parse_tz_awares s r� zparse_dates,index_colrF c C s | }d}t tddddd�ddd d d d d gtddddd�ddddd d dgtddddd�dddddd d gtddddd�dddd d d d gtdddd d�d d!dd"d#d d$gtdddd%d�d&d'dd"d(d d ggd)d*d+d,d-d.d/d0gd1�}|�d)�}t|t�s�d2|j_|jt|�||d3�}t � ||� d S )4Na ID,date,NominalTime,ActualTime,TDew,TAir,Windspeed,Precip,WindDir KORD1,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD2,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD3,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD4,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD5,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD6,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000 i� r rH rI r ZKORD1z 18:56:00g�Q� ���?g{�G�z@g������ @g g �q@rN ZKORD2z 19:56:00g{�G�z�?g�G�z�@g @p@rO ZKORD3z 20:56:00g�z�G��g������@ZKORD4z 21:18:00g�G�z��g�G�z @g������ @g �p@rP ZKORD5z 21:56:00g\��(\�?gffffff@g r@rQ ZKORD6z 22:56:00gffffff@rF r{ r| r} r~ r r� r� )r6 Zdate_NominalTime)r r" ) r r r� � isinstancer� r* r& r+ r r, r- )r. r r" r< r= r0 r/ r r r � test_multiple_date_cols_index� s� r� c C s` | }d}t tddddd�ddd d d d d gtddddd�ddddd d dgtddddd�dddddd d gtddddd�dddddd dgtdddd d�dd dd d d d gtdddd!d�dd"dd d#d d ggd$d%d&d'd(d)d*d+gd,�}|�d$�}|jt|�d$dd-gid$d-d.��}t|�}W d Q R X t�|d |d d-� � t�|d |d-d/� � t�|d- |d/d � � d S )0Na� ID,date,nominalTime,actualTime,A,B,C,D,E KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000 i� r rH rI r rL z 18:56:00g�Q� ���?g{�G�z@g������ @g g �q@rN z 19:56:00g{�G�z�?g�G�z�@g @p@rO z 20:56:00g�z�G��g������@z 21:18:00g�G�z��g�G�z @g������ @g �p@rP z 21:56:00g\��(\�?gffffff@g r@rQ z 22:56:00gffffff@rF r{ Z actualTimer� r� r� �Drt )r6 r3 )r r" � chunksizerv )r r r� r+ r r� r, r- )r. r< r= r0 �reader�chunksr r r � test_multiple_date_cols_chunked� s~ r� c C sP | }d}|j t|�dddgidd�}|j t|�ddddgid�}t�||� d S ) Na� ID,date,nominalTime,actualTime,A,B,C,D,E KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000 rF r r3 )r r" r Z nominalTime)r" r )r+ r r, r- )r. r< r= Z with_indicesZ with_namesr r r �)test_multiple_date_col_named_index_compat@ s r� c C s` | }d}|j t|�ddgdddgid�}|j t|�dddgid�}|�ddg�}t�||� d S )Na� ID,date,nominalTime,actualTime,A,B,C,D,E KORD,19990127, 19:00:00, 18:56:00, 0.8100, 2.8100, 7.2000, 0.0000, 280.0000 KORD,19990127, 20:00:00, 19:56:00, 0.0100, 2.2100, 7.2000, 0.0000, 260.0000 KORD,19990127, 21:00:00, 20:56:00, -0.5900, 2.2100, 5.7000, 0.0000, 280.0000 KORD,19990127, 21:00:00, 21:18:00, -0.9900, 2.0100, 3.6000, 0.0000, 270.0000 KORD,19990127, 22:00:00, 21:56:00, -0.5900, 1.7100, 5.1000, 0.0000, 290.0000 KORD,19990127, 23:00:00, 22:56:00, -0.5900, 1.7100, 4.6000, 0.0000, 280.0000 rF r{ r r3 )r" r )r )r+ r r� r, r- )r. r< r= r/ r0 r r r �,test_multiple_date_col_multiple_index_compatW s r� r� c C sD | }d}d}t jt|d�� |jt|�fddi|�� W d Q R X d S )NzSOnly booleans, lists, and dictionaries are accepted for the 'parse_dates' parameterzA,B,C 1,2,2003-11-1)rf r r� )ri rj r� r+ r )r. r� r< rl r= r r r �*test_read_with_parse_dates_scalar_non_boolk s r� )r rv rw rD c C s< | }d}d}t jt|d�� |jt|�dd� W d Q R X d S )NzSOnly booleans, lists, and dictionaries are accepted for the 'parse_dates' parameterzA,B,C 1,2,2003-11-1)rf )r )r )ri rj r� r+ r )r. r r< rl r= r r r �'test_read_with_parse_dates_invalid_typez s r� � cache_datesrd ry �0� c C s6 | }t |� d�d �}|j|d ddgdgd|d� d S )Nz, iP� Zfoo�barF)r; r� r Zinfer_datetime_formatr� )r r+ )r. r� rd r< r r r r �test_bad_date_parse� s r� c C sT | }d}|j t|�dgdd�}ttddd�dgtjdggddgd �}t�||� d S ) NzDate,test 2012-01-01,1 ,2r5 F)r Z na_filteri� r r3 �test)r6 )r+ r r r r ZNaTr, r- )r. r< r= r/ r0 r r r � test_parse_dates_empty_string� s $r� zdata,kwargs,expectedz a 04.15.2016i� r� )r6 )r r" z 2016-04-15)r& )r* za,b 04.15.2016,09.16.2013r� i� � � )r� c C s. | }|j t|�fddi|��}t�||� d S )Nr: �.)r+ r r, r- )r. r= r� r0 r< r/ r r r �%test_parse_dates_no_convert_thousands� s !r� c C s� d}| }t j|dd��( |jt|�ddgdddgi|d�}W d Q R X tddd d dd�d d gtddd ddd�ddgg}t|dddgd�}t �||� d S )NzUD,T,A,B date, time,a,b 2001-01-05, 09:00:00, 0.0, 10. 2001-01-06, 00:00:00, 1.0, 11. F)rp r r r� )r; r r! i� rw r� g g $@r2 g �?g &@)r� r� )r� r� )r6 )r, rq r+ r r r r- )r. r! rr r= r< r/ � expected_datar0 r r r �,test_parse_date_time_multi_level_column_name� s r� zKdate,time,a,b 2001-01-05, 10:00:00, 0.0, 10. 2001-01-05, 00:00:00, 1., 11. r� )r; r i� r� g g �?g &@z�KORD,19990127, 19:00:00, 18:56:00, 0.8100 KORD,19990127, 20:00:00, 19:56:00, 0.0100 KORD,19990127, 21:00:00, 20:56:00, -0.5900 KORD,19990127, 21:00:00, 21:18:00, -0.9900 KORD,19990127, 22:00:00, 21:56:00, -0.5900 KORD,19990127, 23:00:00, 22:56:00, -0.5900)rE rF i� rH rI rJ rK rL g�Q� ���?rN g{�G�z�?rO g�z�G��g�G�z��rP rQ rE c C sR | }t j|dd�� |jt|�fd|i|��}W d Q R X ||j }t �||� d S )NF)rp r! )r, rq r+ r r6 r- )r. r= r� r0 r! rr r< r/ r r r �test_parse_date_time� s M$ r� c C s~ | }d}t j|dd��& |jt|�dddddgi|d�}W d Q R X ttd dd �d gtd dd�d ggdd gd�}t �||� d S )Nz-year,month,day,a 2001,01,10,10. 2001,02,1,11.F)rp r Zymdr r3 )r; r r! i� r� g $@g &@r� )r6 )r, rq r+ r r r r- )r. r! rr r< r= r/ r0 r r r �test_parse_date_fieldsA s r� c C s t j| dd�S )Nz%Y %m %d %H %M %S)�format)r � to_datetime)r� r r r r� [ r� r� c C s� | }d}t j|dd��, |jt|�d|dddddd d gid �}W d Q R X ttd dd d dd�ddgtd dd d dd�ddggdddgd�}t �||� d S )NzZyear,month,day,hour,minute,second,a,b 2001,01,05,10,00,0,0.0,10. 2001,01,5,10,0,00,1.,11. F)rp r �ymdHMSr r3 rD rv rw )r; r! r i� r� g g $@g �?g &@r� r� )r6 )r, rq r+ r r r r- )r. r! rr r< r= r/ r0 r r r �test_parse_date_all_fieldsW s "r� c C s t j| dd�S )Nz%Y %m %d %H %M %S.%f)r� )r r� )r� r r r r� z r� c C s� | }d}t j|dd��, |jt|�d|dddddd d gid �}W d Q R X ttd dd d dddd�ddgtd dd d dddd�ddggdddgd�}t �||� d S )Nzgyear,month,day,hour,minute,second,a,b 2001,01,05,10,00,0.123456,0.0,10. 2001,01,5,10,0,0.500000,1.,11. F)rp r r� r r3 rD rv rw )r; r! r i� r� i@� )� microsecondg g $@i � g �?g &@r� r� )r6 )r, rq r+ r r r r- )r. r! rr r< r= r/ r0 r r r � test_datetime_fractional_secondsv s " r� c C s� | }d}t jtdd��( |jt|�ddddgidd� d �}W d Q R X ttd dd�d d gtd d d�ddggdddgd�}t �||� d S )Nz-year,month,day,a 2001,01,10,10. 2001,02,1,11.F)rp r Zymr c S s t t| �t|�dd�S )Nr )�year�month�day)r r� )�y�mr r r r� � r� z test_generic.<locals>.<lambda>)r; r r! i� r� g $@r3 g &@r� r� )r6 )r, rq r� r+ r r r r- )r. r< r= r/ r0 r r r � test_generic� s "r� c C s� | }d}dd� }|j t|�|dddgiddgd�}td gd d d �}td dgd itj|d df|d df|d dfgddgd�d�}t�||� d S )Nzxdate,time,prn,rxstatus 2013-11-03,19:00:00,126,00E80000 2013-11-03,19:00:00,23,00E80000 2013-11-03,19:00:00,13,00E80000 c S s t | d | d dd�S )N�T�Zz datetime64[s])r� )r )�dtr r r r r! � s z:test_date_parser_resolution_if_not_ns.<locals>.date_parserr r r Zprn)r! r r" z2013-11-03T19:00:00ZrD z datetime64[s])r� ZrxstatusZ00E80000r �~ r rQ r3 r4 )r� )r= r* )r+ r r r r � from_tuplesr, r- )r. r< r= r! r/ � datetimesr0 r r r �%test_date_parser_resolution_if_not_ns� s r� c C sR | }d}|j t|�dgd�}ddgddgddgg}t|d dgd �}t�||� d S ) Nz+case,opdate 7,10/18/2006 7,10/18/2008 621, Zopdate)r rx z 10/18/2006z 10/18/2008im � �case)r6 )r+ r r r, r- )r. r< r= r/ r� r0 r r r �(test_parse_date_column_with_empty_string� s r� z data,expectedz"a 135217135789158401 1352171357E+5l 0� l H�b�k r� )r� z%a 99999999999 123456789012345 1234E+0l �g�] l y_ "A i� c C s& | }|j t|�|d�}t�||� d S )N)r )r+ r r, r- )r. r= r0 r r< r/ r r r �test_parse_date_float� s r� c C sj | }d}|j t|�dgd�}tttdddt�d�d��d d �}|d d d d d gd �}t|�}t� ||� d S ) Nz�dt,val 2018-01-04 09:01:00+09:00,23350 2018-01-04 09:02:00+09:00,23400 2018-01-04 09:03:00+09:00,23400 2018-01-04 09:04:00+09:00,23400 2018-01-04 09:05:00+09:00,23400r� )r z2018-01-04 09:01:00z2018-01-04 09:05:00Z1mini )�start�endr� r� )r� i6[ ih[ )r� �val) r+ r r r� r r� Z FixedOffsetr r, r- )r. r< r= r/ Zdtir� r0 r r r �test_parse_timezone� s r� � date_stringz 32/32/2019z 02/30/2019z 13/13/2019z13/2019z a3/11/2018z 10/11/2o17c C s< | }t d|gidd�}|jt|�d dgd�}t�||� d S )Nr r� )r� )r; r )r r+ r r, r- )r. r� r< r0 r/ r r r �!test_invalid_parse_delimited_date s r� z date_string,dayfirst,expectedz 13/02/2019i� r4 z 02/13/2019z 04/02/2019c C s> | }t d|gidd�}|jt|�d |dgd�}t�||� d S )Nr zdatetime64[ns])r� )r; r� r )r r+ r r, r- )r. r� r� r0 r< r/ r r r � test_parse_delimited_date_swap s r� c K sL d\}}y| |f|�}W n* t k rB } z t|�}W d d }~X Y nX ||fS )N)NN)rk �str)�callr� r� rl r/ Zerr r r �!_helper_hypothesis_delimited_date) s r� )�deadline� delimiterz -./� date_formatz%d %m %Yz%m %d %Yz%m %Yz%Y %m %dz%y %m %dz%Y%m%dz%y%m%dc C s� | dkr|dkrt �d� d\}}d\}}|�| �d|��}tt||d�\}}tt|t|dd�\}}||kspt�||ks|t�d S ) Nz%m %Yr� zkparse_datetime_string cannot reliably tell whether e.g. %m.%Y is a float or a date, thus we skip it)NNr� )r� F)�defaultr� Z yearfirst) ri �skip�strftime�replacer� r r� �_DEFAULT_DATETIMEr� ) r r� r� Z test_datetimer/ r0 Zexcept_in_dateutilZexcept_out_dateutilr� r r r � test_hypothesis_delimited_date3 s r z)names, usecols, parse_dates, missing_colsr� z date, timeZdate1Ztime1Z temperaturec C sJ | }t d�}d|� d�}tjt|d�� |j|d|||d� W d Q R X d S )Nz%date,time,val 2020-01-31,04:20:32,32 z+Missing column provided to 'parse_dates': '�')rf �,)r9 r� �usecolsr )r ri rj rk r+ )r. r� r r Z missing_colsr< �contentrl r r r �&test_missing_parse_dates_column_raisesT s r c C sH | }t d�}|j|dgdgd�}tdddgiddgd�}t�||� d S ) Nzx,y 1,2r� )r r� r� �2r� �1)r* )r r+ r r, r- )r. r< r= r/ r0 r r r �test_date_parser_and_namest s r c C sP d}| }|j t|�dgddgdd�}tddgtd�gd d ��}t�||� d S ) Nz2A,B,C 1,3,20-09-01-01 2,4,20-09-01-01 r r3 r8 )r r r: rD rv z20-09-2001 01:00:00)r� r� )r+ r r r r, r- )r. r= r< r/ r0 r r r �"test_date_parser_usecols_thousands} s r )e�__doc__r r �ior Zdateutil.parserr r� Z hypothesisr r r �st�numpyr ri r� Zpandas._libs.tslibsr Zpandas._libs.tslibs.parsingr Z pandas.compatr r Zpandasr r r r r r r Zpandas._testingZ_testingr, Z pandas.core.indexes.datetimesr Zpandas.io.date_convertersZdate_converters�convr r� Z date_strategyr1 r? �markZ parametrizer` r� rg rm rn ro Zparse_date_timer� r� rs rz r� r� r� r� r� r� r� Zxfailr� r� r� r� r� r� r� r� r� r� �arrayr� r� r� r� r� r� r� Zparse_date_fieldsr� Zparse_all_fieldsr� r� r� r� r� r� r� r� r� r� r r r r r r r r �<module> sb % z% >"Y 4 (""-", 6b\ , $ 6 ! $
| ver. 1.4 |
Github
|
.
| PHP 8.3.23 | Генерация страницы: 0.03 |
proxy
|
phpinfo
|
Настройка