a
    DBìj` ã                   @   sŒ	  d Z ddlmZmZmZmZ ddlmZ ddlmZ	 ddl
ZddlZddlZddlmZ ddlZddlmZmZmZmZmZmZ ddlmZ ddlmZ dd	lmZ dd
lm Z  ej! "d¡Z#ej! $d¡Z%ej! $d¡Z&e%dd„ ƒZ'e%dd„ ƒZ(e%dd„ ƒZ)ej! *dddg¡dd„ ƒZ+ej! *de,e-eeg¡ej! *dddg¡dd„ ƒƒZ.ej! *dddg¡dd „ ƒZ/d!d"„ Z0d#d$„ Z1d%d&„ Z2e%d'd(„ ƒZ3ej! *d)d*ddggd+fd,d-ddgid.fg¡d/d0„ ƒZ4d1d2„ Z5e%d3d4„ ƒZ6e&d5d6„ ƒZ7e&d7d8„ ƒZ8e%d9d:„ ƒZ9ej!j:d;d<�ej! *d=d>d?ggddggg¡d@dA„ ƒƒZ;e%ej! *d=ddgdBdCgg¡dDdE„ ƒƒZ<e%ej! *dFddgddgg¡dGdH„ ƒƒZ=e%ej! *dIdJdidKdig¡dLdM„ ƒƒZ>dNdO„ Z?e%ej! *dPdQddgidQfdQddgidfddggdfg¡dRdS„ ƒƒZ@e%dTdU„ ƒZAdVdW„ ZBdXdY„ ZCej! *dIi dFdZig¡d[d\„ ƒZDej! *d=d]e Ed^d_g¡dd`hg¡dadb„ ƒZFej! *dcddg¡ej! *dddedfg¡dgdh„ ƒƒZGej! *dcddg¡ej! *dddig¡djdk„ ƒƒZHe%dldm„ ƒZIej! *dndodpg¡dqdr„ ƒZJej! *dndodpg¡dsdt„ ƒZKe%ej! *dudvd=dBgieedwd^dxƒgdBgdy�fdvdddzœeed{gdBd|�g d}�fd~d=dBdgieedwd^dxƒed€d�d‚ƒggdBdgdy�fd~dddgdzœeejLedwd^dxƒed€d�d‚ƒfgdBdgdƒ�g d}�fg¡d„d…„ ƒƒZMe%d†d‡„ ƒZNej! *dudˆdd‰ddgidŠœeed‹dd_dŒddƒd�dŒged‹dd_dddƒdŽd�ggg d�¢dy�fd‘dddgdd`gd’œdŠœeed“dd”d•dƒed“dd”d–d—ƒd˜d™ged“dd”dšdƒed“dd”d•d—ƒd˜d›ged“dd”dœdƒed“dd”dšd—ƒd˜d�ged“dd”dœdƒed“dd”dœd–ƒd˜džged“dd”dŸdƒed“dd”dœd—ƒd˜d�ged“dd”d dƒed“dd”dŸd—ƒd˜d�ggg d¡¢dy�fg¡d¢d£„ ƒZOd¤d¥„ ZPej! *d¦d§d¨d©„ eQfdªg¡d«d¬„ ƒZRej! *d¦d§d­d©„ eQfd®g¡d¯d°„ ƒZSd±d²„ ZTe%d³d´„ ƒZUdµd¶„ ZVej! *d·d¸edBd¹dºgid»d¼�fd½edBg d¾¢id»d¼�fg¡ej! *d=ddg¡d¿dÀ„ ƒƒZWdÁdÂ„ ZXe&ej! *dÃg dÄ¢¡dÅdÆ„ ƒƒZYej! *dÇdÈdedÉddÊƒfdËdedÉddÊƒfdÌdedÉdd^ƒfg¡dÍdÎ„ ƒZZe&ej! *dÇdÈdedÉddÊƒfdËdedÉddÊƒfg¡dÏdÐ„ ƒƒZ[dÑdÒ„ Z\e&ej! *dÓddÔgd>d?gdÕfddÔgdd?gd?fddÔgd>d?ggdÕfddÔgdd?ggd?fddÔgd>dd?gid?fddÔgd>d>d?gidÕfddÔgd>d?gd>gdÕfg dÖ¢dd>d?gdÕfg dÖ¢d×dØgd×d?gd?fg	¡dÙdÚ„ ƒƒZ]e%dÛdÜ„ ƒZ^e%dÝdÞ„ ƒZ_e%ej! *dßdàdággdâfdãdàdágidãfg¡dädå„ ƒƒZ`dædç„ Zae%dèdé„ ƒZbdêdë„ Zcej! *dìejddíddîdï�ejddðddñdï�g¡dòdó„ ƒZee&dôdõ„ ƒZfe%ej! *d¦d§död©„ eQfd÷g¡dødù„ ƒƒZge%dúdû„ ƒZhdüdý„ Zidþdÿ„ Zjej! *�d �dddggf�d�dddgifg¡�d�d„ ƒZke%�d�d„ ƒZl�d�d„ Zme%�d	�d
„ ƒZndS (  zO
Tests date parsing functionality for all of the
parsers defined in parsers.py
é    )ÚdateÚdatetimeÚ	timedeltaÚtimezone)ÚStringIO)ÚparseN)Úparsing)Ú	DataFrameÚDatetimeIndexÚIndexÚ
MultiIndexÚSeriesÚ	Timestamp)Ú
date_range)Ústart_caching_at)Úread_csvz=ignore:Passing a BlockManager to DataFrame:DeprecationWarningZpyarrow_xfailZpyarrow_skipc              	   C   sx   dd„ }t dƒ}| jtd|dd|dd�}g d¢}tjd	d
„ |D ƒdd�}tg d¢g d¢g d¢dœ|d�}t ||¡ d S )Nc                 S   s$   |   tj¡} |   t¡} tj| dd�S ©NÚs©Úunit©ÚastypeÚnpÚfloat64ÚintÚpdÚto_timedelta©Útime© r   úf/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/io/parser/test_parse_dates.pyÚ__custom_date_parser/   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
        ú Please use 'date_format' insteadTr   ©Zdelim_whitespaceÚparse_datesÚdate_parserÚ	index_col)iW   iX   iY   iZ   i[   c                 S   s   g | ]}t j|d d�‘qS )r   r   )r   r   )Ú.0Úir   r   r    Ú
<listcomp>G   ó    z9test_read_csv_with_custom_date_parser.<locals>.<listcomp>©Úname)g>èÙ¬ÛøÀçVŸ«­ÛøÀgáz®ÛøÀr-   gù1æ®ÛøÀ)ç¦›Ä D˜*Ar.   g‰ÒÞ D˜*Agúíë D˜*Ar.   )çóŽSt$Px@r/   çGx$Px@r0   gîëÀ9#Px@)ÚeÚnÚh©Úindex)r   Úread_csv_check_warningsÚFutureWarningr   ZTimedeltaIndexr	   ÚtmÚassert_frame_equal©Úall_parsersr!   ZtestdataÚresultr   Úexpectedr   r   r    Ú%test_read_csv_with_custom_date_parser,   s.    ÿ	ù	ýú	r>   c              	   C   s\   dd„ }t dƒ}| jtd|dd|dd�}tg d	¢dd
�}tdg d¢i|d�}t ||¡ d S )Nc                 S   s$   |   tj¡} |   t¡} tj| dd�S r   r   r   r   r   r    r!   W   s    
zUtest_read_csv_with_custom_date_parser_parse_dates_false.<locals>.__custom_date_parserz‡time e
        41047.00 -93.77
        41048.00 -95.79
        41049.00 -98.73
        41050.00 -93.99
        41051.00 -97.72
        r"   TFr   r#   )g    à
ä@g     ä@g     ä@g    @ä@g    `ä@r+   r1   )gáz®GqWÀgÃõ(\�òWÀg…ëQ¸®XÀg�Âõ(\WÀg®GáznXÀr4   )r   r6   r7   r   r	   r8   r9   r:   r   r   r    Ú7test_read_csv_with_custom_date_parser_parse_dates_falseT   s&    ÿ	ù	
þr?   c                 C   s�   | }d}t tddddddƒdggddgd	�}d
}tjt|dd��0 |jt|ƒdddddgid d�}W d   ƒ n1 sv0    Y  t ||¡ d S )Nz06-02-2013;13:00;1-000.215éÝ  é   é   é   r   g…ëQ¸A�@ÚDate©ÚcolumnsúKSupport for nested sequences for 'parse_dates' in pd.read_csv is deprecatedF©ÚmatchZcheck_stacklevelú;ú-é   )ÚsepÚ	thousandsr$   Úheader)r	   r   r8   Úassert_produces_warningr7   r   r   r9   )r;   ÚparserÚdatar=   Údepr_msgÚdfr   r   r    Útest_separator_date_conflictw   s$    ÿÿÿ
û$rU   Úkeep_date_colTFc           
      C   sÜ  d}| }|r.|j dkr.tjjdd�}| |¡ dd„ }d |ddgdd	gd
œ|g d¢dœ}|jtdt|ƒfi |¤ddi¤Ž}tt	dddddƒt	dddddƒdddddddddgt	dddddƒt	dddddƒddd d!d"d#ddd$gt	dddd%dƒt	dddddƒddd&d'd(d#d)ddgt	dddd%dƒt	dddd%dƒddd&d*d+d,d-dd.gt	dddd/dƒt	dddd%dƒddd0d1d(d2d3dd4gt	dddd5dƒt	dddd/dƒddd6d7d(d2d8ddggg d9¢d:�}	|�sÂ|	j
g d;¢dd<�}	||	j }t ||	¡ d S )=NáÌ  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
ÚpyarrowúCpyarrow doesn't support disabling auto-inference on column numbers.©Úreasonc                  W   s   t jt  | ¡td�S )zË
        Test date parser.

        Parameters
        ----------
        date_cols : args
            The list of data columns to parse.

        Returns
        -------
        parsed : Series
        )rQ   )r   Ztry_parse_datesÚconcat_date_colsÚdu_parse)Ú	date_colsr   r   r    r%   §   s    
ÿz2test_multiple_date_col_custom.<locals>.date_parserrL   rB   é   ©ÚactualÚnominal©	ÚX0ÚX1ÚX2ÚX3ÚX4ÚX5ÚX6ÚX7ÚX8)rO   r%   r$   rV   Únamesúuse 'date_format' insteadÚraise_on_extra_warningsFéÏ  é   é   r   é   é8   ÚKORDÚ19990127ú	 19:00:00ú	 18:56:00çìQ¸…ëé?ç{®Gáz@çÍÌÌÌÌÌ@ç        ç     €q@é   ú	 20:00:00ú	 19:56:00ç{®Gáz„?ç®Gáz®@ç     @p@é   ú	 21:00:00ú	 20:56:00çáz®Gáâ¿çÍÌÌÌÌÌ@ú	 21:18:00ç®Gáz®ï¿ç®Gáz @çÍÌÌÌÌÌ@ç     àp@é   ú	 22:00:00ú	 21:56:00ç\�Âõ(\û?çffffff@ç      r@é   ú	 23:00:00ú	 22:56:00çffffff@)ra   rb   rd   re   rf   rg   rh   ri   rj   rk   rl   rE   ©re   rf   rg   ©Zaxis)ÚengineÚpytestÚmarkÚxfailÚapplymarkerr6   r7   r   r	   r   ÚdroprF   r8   r9   )
r;   rV   ÚrequestrR   rQ   rœ   r%   Úkwdsr<   r=   r   r   r    Útest_multiple_date_col_custom“   sÎ    ÿ
ûýüûõõõõõõ¾P¯`
r¢   Ú	containerÚdimrL   rB   c                    s`   d}d‰t ‡ ‡fdd„t|ƒD ƒƒ}tjt|d�� t |¡ W d   ƒ n1 sR0    Y  d S )Nz0not all elements from date_cols are numpy arraysrv   c                 3   s   | ]}ˆ ˆgƒV  qd S ©Nr   )r'   Ú_©r£   Úvaluer   r    Ú	<genexpr>7  r*   z,test_concat_date_col_fail.<locals>.<genexpr>©rI   )ÚtupleÚranger›   ÚraisesÚ
ValueErrorr   r\   )r£   r¤   Úmsgr^   r   r§   r    Útest_concat_date_col_fail1  s
    r°   c           
      C   sò  d}| }|r.|j dkr.tjjdd�}| |¡ d}d ddgddgg|g d	¢d
œ}tjttf|dd��& |j	t
|ƒfi |¤Ž}W d   ƒ n1 s�0    Y  ttdddddƒtdddddƒdddddddddgtdddddƒtdddddƒdddddd ddd!gtdddd"dƒtdddddƒddd#d$d%d d&ddgtdddd"dƒtdddd"dƒddd#d'd(d)d*dd+gtdddd,dƒtdddd"dƒddd-d.d%d/d0dd1gtdddd2dƒtdddd,dƒddd3d4d%d/d5ddggg d6¢d7�}	|�sâ|	jg d8¢dd9�}	t ||	¡ d S ):NrW   rX   rY   rZ   ú8The 'keep_date_col' keyword in pd.read_csv is deprecatedrL   rB   r_   rc   )rO   r$   rV   rm   FrH   rp   rq   rr   r   rs   rt   ru   rv   rw   rx   ry   rz   r{   r|   r}   r~   r   r€   r�   r‚   rƒ   r„   r…   r†   r‡   rˆ   r‰   rŠ   r‹   rŒ   r�   rŽ   r�   r�   r‘   r’   r“   r”   r•   r–   r—   )ZX1_X2ZX1_X3rd   re   rf   rg   rh   ri   rj   rk   rl   rE   r˜   r™   )rš   r›   rœ   r�   rž   r8   rP   ÚDeprecationWarningr7   r   r   r	   r   rŸ   r9   )
r;   rV   r    rR   rQ   rœ   rS   r¡   r<   r=   r   r   r    Útest_multiple_date_col=  sÀ    ÿ
ü
ÿ4õõõõõõ¾P¯`r³   c                 C   sè   d}| }d dgdg d¢dœ}|j t|ƒfi |¤Ž}ttdddddƒtdddd	dƒtdddd
dƒtdddd
dƒtdddddƒgdd�}tg d¢g d¢g d¢g d¢g d¢gg d¢|d�}|jdkrØt d|d  ¡jj	|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
rL   )rd   re   rf   rg   rh   ri   rj   rk   )rO   r$   r&   rm   rp   rq   rr   r   r~   r„   rŽ   re   r+   )ru   rx   ry   rz   r{   r|   r}   )ru   r€   r�   r‚   r{   r|   rƒ   )ru   r†   r‡   r‚   rˆ   r|   r}   )ru   r‰   rŠ   r‹   rŒ   r|   r�   )ru   r�   r‡   r‘   r’   r|   r“   )rd   rf   rg   rh   ri   rj   rk   ©rF   r5   rX   ú
1970-01-01rf   )r   r   r   r   r	   rš   r   Úto_datetimeÚdtr   r8   r9   )r;   rR   rQ   r¡   r<   r5   r=   r   r   r    Útest_date_col_as_index_colÄ  s<    üûø
û÷
r¸   c                 C   s@  d}ddgddgdœ}| }d |t jdœ}|jtdt|ƒfi |¤dd	i¤Ž}ttd
ddddƒtd
ddddƒddgtd
ddddƒtd
ddddƒddgtd
ddddƒtd
ddddƒddgtd
ddddƒtd
ddddƒddgtd
ddddƒtd
ddddƒddgtd
ddddƒtd
ddddƒddggg d¢d�}||j }t 	||¡ d S )Núÿ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.5900rL   rB   r_   r`   ©rO   r$   r%   rn   ro   Frp   rq   rr   r   rs   rt   ru   ry   r~   r�   r„   r‡   rŠ   rŽ   r”   ©ra   rb   r   é   rE   )
r   r¶   r6   r7   r   r	   r   rF   r8   r9   )r;   rR   r$   rQ   r¡   r<   r=   r   r   r    Ú test_multiple_date_cols_int_castò  sZ    ÿýýüû""üüüüëã#
r½   c              	   C   sv   | }d}|j tdt|ƒddggd tdd�}ttdƒddd	dtjdgtdƒdd
d	dtjdggg d¢d�}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.25rn   r   rL   F)r$   rO   r%   ro   z05/31/2012, 15:30:00.029g     i”@ÚEé   )Z0_1rB   r_   r¼   é   rA   é   rE   )	r6   r7   r   r   r	   r   Únanr8   r9   ©r;   rQ   rR   r<   r=   r   r   r    Ú&test_multiple_date_col_timestamp_parse2  s@    ù	ù
ùöërÄ   c                 C   s*  | }d}d}t jt|dd��* |jt|ƒdddgid�}W d   ƒ n1 sL0    Y  ttd	dd
ddƒdddddddgtd	dd
ddƒdddddddgtd	dd
ddƒdddddddgtd	dd
ddƒddddd dd!gtd	dd
d"dƒdd#dd$d%dd&gtd	dd
d'dƒdd(dd$d)ddggg d*¢d+�}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.0000rG   FrH   rb   rL   rB   ©r$   rp   rq   rr   r   ru   rx   ry   rz   r{   r|   r}   r~   r€   r�   r‚   rƒ   r„   r†   r‡   rˆ   r‰   rŠ   r‹   rŒ   r�   rŽ   r�   r‘   r’   r“   r”   r–   r—   ©rb   ÚIDZ
ActualTimeZTDewZTAirZ	WindspeedZPrecipZWindDirrE   )r8   rP   r7   r   r   r	   r   r9   ©r;   rQ   rR   rS   r<   r=   r   r   r    Ú#test_multiple_date_cols_with_headerZ  s†    
ÿÿ8øøøøøøÍ>ÁJrÉ   zdata,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   s€   | }d}t jt|d��V tjttf|dd��" |jt|ƒ|d� W d   ƒ n1 sT0    Y  W d   ƒ n1 sr0    Y  d S )NrG   rª   FrH   rÅ   )	r›   r­   r®   r8   rP   r7   r²   r   r   )r;   rR   r$   r¯   rQ   rS   r   r   r    Ú%test_multiple_date_col_name_collisionº  s    ÿ
ÿrÊ   c              	   C   s`   | }d}|j tdt|ƒddgdd„ dd�}tg d¢gg d	¢ttd
ƒgd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
rn   r   c                 S   s   t jt| ƒtjd�jd d�S )N)Útz)Útzinfo)r   Úfromtimestampr   r   ÚutcÚreplace©Úxr   r   r    Ú<lambda>î  s   ÿz*test_date_parser_int_bug.<locals>.<lambda>F)r&   r$   r%   ro   )go�»ì¯?r   r¼   rA   gX¨5Í;N‘?r_   i90  rL   éÿÿÿÿr_   Zinvoice_InvoiceResourceÚsearch)ÚelapsedÚsysÚuserZqueriesZ
query_timeÚrowsZ	accountidZuseridZ	contactidÚlevelZsiloÚmethodz2012-07-24 04:12:30Zposix_timestampr+   r´   )r6   r7   r   r	   r   r   r8   r9   rÃ   r   r   r    Útest_date_parser_int_bugÜ  s&    ÿõÿá!rÛ   c                 C   s”   | }t tjddd�tdƒ d¡dœƒ}tj|jdd…d d …f< t d	¡�8}| 	|¡ |j
|d
dgd�}t ||¡ W d   ƒ n1 s†0    Y  d S )Né
   r   ©ÚdtypeZ20010101Úns)ÚAÚBr_   rA   z__nat_parse_.csvr   rá   ©r&   r$   )r	   r   Zaranger   Úas_unitrÂ   Zilocr8   Zensure_cleanZto_csvr   r9   )r;   rQ   rT   Úpathr<   r   r   r    Útest_nat_parse  s    þÿ
rå   c                 C   sb   d}| }|j tdt|ƒdd„ d�}|jt|ƒdd�}t ||¡ |jt|ƒdd	�}t ||¡ d S )
Nú3A,B,C
20090101,a,1,2
20090102,b,3,4
20090103,c,4,5
rn   c                 S   s   t  | d¡S )Nú%Y%m%d)r   ÚstrptimerÐ   r   r   r    rÒ   6  r*   z(test_csv_custom_parser.<locals>.<lambda>)r%   TrÅ   rç   )Údate_format)r6   r7   r   r   r8   r9   ©r;   rR   rQ   r<   r=   r   r   r    Útest_csv_custom_parser*  s    ürë   c                 C   s>   d}| }|j t|ƒdd�}|j t|ƒddd�}t ||¡ d S )Nræ   TrÅ   r   râ   ©r   r   r8   r9   rê   r   r   r    Ú#test_parse_dates_implicit_first_col>  s
    rí   c                 C   sb   d}| }|j t|ƒddgd�}tdddd� d ¡}tg d¢g d¢g d	¢d
œ|d�}t ||¡ d S )Nz8date,A,B,C
20090101,a,1,2
20090102,b,3,4
20090103,c,4,5
r   râ   z1/1/2009r_   )Zperiodsr,   ©ÚaÚbÚc)rL   r_   r¼   )rB   r¼   rÀ   ©rà   rá   ÚCr4   )r   r   r   Ú
_with_freqr	   r8   r9   )r;   rR   rQ   r<   r5   r=   r   r   r    Útest_parse_dates_stringL  s    ÿrõ   z#yearfirst is not surfaced in read_*rZ   r$   r   r   c              
   C   sˆ   d}| }|j tdt|ƒd|d�}ttddddddƒtdd	d
dddƒtddddddƒgtdd�}tg d¢g d¢dœ|d�}t ||¡ d S )Nz>date,time,B,C
090131,0010,1,2
090228,1020,3,4
090331,0830,5,6
úCould not infer formatr   râ   éÙ  rL   é   rÜ   rB   é   r~   r_   r¿   é   Ú	date_time©rÞ   r,   )rL   r_   rÀ   )rB   r¼   rA   ©rá   ró   r4   )	r6   ÚUserWarningr   r
   r   Úobjectr	   r8   r9   )r;   r$   rR   rQ   r<   r5   r=   r   r   r    Útest_yy_format_with_year_first`  s&    ûýù	r   rï   rñ   c                 C   sf   d}| }t tdddƒgdgtdddƒgdœƒ}| ddg¡}|jt|ƒd	dg|d
d�}t ||¡ d S )Nza,b,c
01/01/2010,1,15/02/2010éÚ  rL   rB   é   rî   rï   rð   r   T)r&   r$   Údayfirst)r	   r   Ú	set_indexr   r   r8   r9   )r;   r$   rR   rQ   r=   r<   r   r   r    Útest_parse_dates_column_list}  s     ÿÿr  r&   c                 C   sÄ   d}| }t jtdddƒtdddƒtdddƒfdgddgd	�}|dd
gkrT| d
d¡}tg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g	g d¢|d�}|jtdt|ƒ|dd�}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
r÷   rL   rB   r_   )ÚoneÚtwoÚthreeZindex1Úindex2©rm   r   )rï   rL   rB   )rð   r_   r¼   )rñ   r¼   rÀ   rò   r´   rö   Trâ   )
r   Zfrom_productr   Z	swaplevelr	   r6   rþ   r   r8   r9   )r;   r&   rR   rQ   r5   r=   r<   r   r   r    Útest_multi_index_parse_datesŽ  s@     þû	÷óûr  Úkwargsr  Z	day_firstc                    s   | }d}dˆ v rš|j tdt|ƒg d¢‡ fdd„dddd	gd
�	}ttdddƒtdddƒtdddƒgdd�}tg d¢dtjdgdœ|ddgd�}t 	||¡ nbd}t
jt|d��@ |j tdt|ƒg d¢‡ fdd„dgddd	gd�	 W d   ƒ n1 sò0    Y  d S )Nz:foo,bar,baz
31/01/2010,1,2
01/02/2010,1,NA
02/02/2010,1,2
r  rn   )r   ÚQÚNTUc                    s   t | fi ˆ ¤ŽS r¥   ©r]   ©Úd©r  r   r    rÒ   Ñ  r*   z5test_parse_dates_custom_euro_format.<locals>.<lambda>r   TZNA)rm   r%   rO   r&   r$   Ú	na_valuesr  rL   rø   rB   r   r+   )rL   rL   rL   )r  r  r  r  ©r5   rF   z.got an unexpected keyword argument 'day_first'rª   c                    s   t | fi ˆ ¤ŽS r¥   r  r  r  r   r    rÒ   é  r*   )rm   r%   Zskiprowsr&   r$   r  )r6   r7   r   r   r   r	   r   rÂ   r8   r9   r›   r­   Ú	TypeError)r;   r  rQ   rR   rT   Z	exp_indexr=   r¯   r   r  r    Ú#test_parse_dates_custom_euro_formatÂ  sJ    
÷ þý
÷r  c                 C   sŒ   | }d}|j t|ƒddd�}|jdkr4|j d¡|_tddgittd	ƒgd
d�d�}|jdkrftj	}nt
j	}t ||¡ |jj|u sˆJ ‚d S )NzDate,x
2012-06-13T01:39:00Z,0.5r   Trâ   rX   rß   rÑ   g      à?z2012-06-13 01:39:00+00:00rD   r+   r4   )r   r   rš   r5   rã   r	   r   r   ÚpytzrÎ   r   r8   r9   rË   )r;   rQ   rR   r<   r=   Zexpected_tzr   r   r    Útest_parse_tz_awareñ  s    
ÿ
r  zparse_dates,index_colrb   c                 C   sB  | }d}t tdddddƒddd	d
dddgtdddddƒdddddddgtdddddƒdddddddgtdddddƒdddddddgtdddddƒd d!dd"d#dd$gtdddd%dƒd&d'dd"d(ddggg d)¢d*�}| d+¡}t|tƒsèd,|j_d-}tjt	|d.d/��$ |j
t|ƒ||d0�}W d   ƒ n1 �s(0    Y  t ||¡ d S )1Na  
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
rp   rL   rq   rr   r   ZKORD1rx   ry   rz   r{   r|   r}   r~   ZKORD2r€   r�   r‚   rƒ   r„   ZKORD3r†   r‡   rˆ   ZKORD4r‰   rŠ   r‹   rŒ   r�   rŽ   ZKORD5r�   r‘   r’   r“   r”   ZKORD6r–   r—   rÆ   rE   rb   Zdate_NominalTimerG   FrH   ©r$   r&   )r	   r   r  Ú
isinstanceÚdictr5   r,   r8   rP   r7   r   r   r9   )r;   r$   r&   rQ   rR   r=   rS   r<   r   r   r    Útest_multiple_date_cols_index  s�    	øøøøøøÍ>ÁJ

ÿÿ
ÿ&r  c                 C   s   | }d}t tdddddƒddd	d
dddgtdddddƒdddddddgtdddddƒdddddddgtdddddƒdddddddgtdddddƒddddddd gtdddd!dƒdd"ddd#ddggg d$¢d%�}| d&¡}d'}tjt|d(d)��X |jt|ƒd&dd*gid&d*d+��}t|ƒ}W d   ƒ n1 �s*0    Y  W d   ƒ n1 �sJ0    Y  t 	|d |d d*… ¡ t 	|d |d*d,… ¡ t 	|d* |d,d … ¡ d S )-Náõ  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
rp   rL   rq   rr   r   ru   rx   ry   rz   r{   r|   r}   r~   r€   r�   r‚   rƒ   r„   r†   r‡   rˆ   r‰   rŠ   r‹   rŒ   r�   rŽ   r�   r‘   r’   r“   r”   r–   r—   )rb   rÇ   Z
actualTimerà   rá   ró   ÚDr¾   rE   rb   rG   FrH   rB   )r$   r&   Ú	chunksizer¼   )
r	   r   r  r8   rP   r7   r   r   Úlistr9   )r;   rQ   rR   r=   rS   ÚreaderÚchunksr   r   r    Útest_multiple_date_cols_chunkedp  sš    
øøøøøøÍ>ÁA
ÿÿ
üHr#  c                 C   s¼   | }d}d}t jttf|dd��, |jt|ƒdddgidd�}W d   ƒ n1 sR0    Y  t jttf|dd��, |jt|ƒddd	d
gid�}W d   ƒ n1 s¢0    Y  t  ||¡ d S )Nr  rG   FrH   rb   rL   rB   r  r   ZnominalTimerâ   )r8   rP   r7   r²   r   r   r9   )r;   rQ   rR   rS   Zwith_indicesZ
with_namesr   r   r    Ú)test_multiple_date_col_named_index_compatÓ  s&    ÿ
ÿÿ$
ÿ
ý$r$  c                 C   sÌ   | }d}d}t jttf|dd��0 |jt|ƒddgdddgid	�}W d   ƒ n1 sV0    Y  t jttf|dd��* |jt|ƒdddgid
�}W d   ƒ n1 s¤0    Y  | ddg¡}t  ||¡ d S )Nr  rG   FrH   rb   rÇ   rL   rB   râ   rÅ   )r8   rP   r7   r²   r   r   r  r9   rÈ   r   r   r    Ú,test_multiple_date_col_multiple_index_compatô  s     
ÿ
ÿÿ$
ÿ8r%  ró   c                 C   sX   | }d}d}t jt|d��* |jt|ƒfddi|¤Ž W d   ƒ n1 sJ0    Y  d S )NúSOnly booleans, lists, and dictionaries are accepted for the 'parse_dates' parameterúA,B,C
    1,2,2003-11-1rª   r$   ró   ©r›   r­   r  r   r   )r;   r  rQ   r¯   rR   r   r   r    Ú*test_read_with_parse_dates_scalar_non_bool  s    ÿr)  ©rL   r¼   rÀ   r_   c                 C   sP   | }d}d}t jt|d��" |jt|ƒdd� W d   ƒ n1 sB0    Y  d S )Nr&  r'  rª   r*  rÅ   r(  )r;   r$   rQ   r¯   rR   r   r   r    Ú'test_read_with_parse_dates_invalid_type   s    ÿr+  Úcache_datesr¨   rÂ   Ú c                 C   s8   | }t |› d�td  ƒ}|j|d ddgdg|d� d S )Nú,
rL   ÚfooÚbar)rO   rm   r$   r,  )r   r   r   )r;   r,  r¨   rQ   r   r   r   r    Útest_bad_date_parse.  s    ûr1  Ú0c              
   C   sX   | }t |› d�d ƒ}|jdkr&d }n|r0d }nt}|j|d|d ddgdg|dd� d S )	Nr.  iPÃ  rX   rö   r/  r0  F)rO   rm   r$   r,  ro   )r   rš   rþ   r6   )r;   r,  r¨   rQ   r   Úwarnr   r   r    Ú test_bad_date_parse_with_warning?  s"    
ør4  c                 C   sT   | }d}|j t|ƒdgdd�}ttdddƒdgtjdggddgd	�}t ||¡ d S )
NúDate,test
2012-01-01,1
,2rD   F)r$   Z	na_filteriÜ  rL   rB   ÚtestrE   )r   r   r	   r   r   ÚNaTr8   r9   rÃ   r   r   r    Útest_parse_dates_empty_string_  s    ÿr8  r!  r6   Zread_table_check_warningsc              	   C   s.   | }d}t ||ƒtdt|ƒdgdddd� d S )Nr5  z2The argument 'infer_datetime_format' is deprecatedrD   Tú,F)r$   Zinfer_datetime_formatrM   ro   )Úgetattrr7   r   )r;   r!  rQ   rR   r   r   r    Ú.test_parse_dates_infer_datetime_format_warningl  s    ùr;  c              
   C   sb   | }d}d}t jt|d��4 t||ƒtdt|ƒdgtjddd� W d   ƒ n1 sT0    Y  d S )	Nr5  z/Cannot use both 'date_parser' and 'date_format'rª   rn   rD   ZISO8601r9  )r$   r%   ré   rM   )r›   r­   r  r:  r7   r   r   r¶   )r;   r!  rQ   rR   r¯   r   r   r    Ú,test_parse_dates_date_parser_and_date_format  s    ùr<  zdata,kwargs,expectedza
04.15.2016ià  r  rE   r  z
2016-04-15r+   r  za,b
04.15.2016,09.16.2013rð   r@   é	   é   r
  c                 C   s.   | }|j t|ƒfddi|¤Ž}t ||¡ d S )NrN   Ú.rì   ©r;   rR   r  r=   rQ   r<   r   r   r    Ú%test_parse_dates_no_convert_thousands“  s    #rA  c                 C   s€   d}| }|j tdt|ƒddgdddgitjd�}tdddd	ddƒd
dgtddddddƒddgg}t|g d¢d�}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.
rn   r   rL   rû   rº   éÑ  rÀ   r=  r|   ç      $@rA   ç      ð?ç      &@)rû   )rà   rï   )rá   rð   rE   )	r6   r7   r   r   r¶   r   r	   r8   r9   )r;   rR   rQ   r<   Úexpected_datar=   r   r   r    Ú,test_parse_date_time_multi_level_column_name¼  s    
ú
þrG  zKdate,time,a,b
2001-01-05, 10:00:00, 0.0, 10.
2001-01-05, 00:00:00, 1., 11.
rû   ©rO   r$   rB  rÜ   r|   rD  rE  )rû   rï   rð   r¹   r`   rp   rq   rr   rs   rt   ru   ry   r~   r�   r„   r‡   rŠ   rŽ   r”   r»   c                 C   sF   | }|j tdt|ƒfdtji|¤ddi¤Ž}||j }t ||¡ d S )Nrn   r%   ro   F)r6   r7   r   r   r¶   rF   r8   r9   r@  r   r   r    Útest_parse_date_timeÖ  s    Iýüûú
rI  c              	   C   sl   | }d}|j tdt|ƒddg d¢idd„ dd	�}ttd
ddƒdgtd
ddƒdggddgd�}t ||¡ d S )Nú-year,month,day,a
2001,01,10,10.
2001,02,1,11.rn   r   Zymd)r   rL   rB   c                 S   s   | S r¥   r   rÐ   r   r   r    rÒ   9  r*   z(test_parse_date_fields.<locals>.<lambda>F©rO   r$   r%   ro   rB  rL   rÜ   rC  rB   rE  rï   rE   )r6   r7   r   r	   r   r8   r9   rÃ   r   r   r    Útest_parse_date_fields0  s     
ù
þrL  )Úkeyr¨   r3  r%   c                 C   s   t j| dd�S )Nú%Y %m %d %H %M %S©Úformat©r   r¶   rÐ   r   r   r    rÒ   I  r*   rÒ   )ré   rN  Nc              	   C   sˆ   | }d}|j |dt|ƒfddg d¢idœ||i¤ddi¤Ž}ttd	d
ddddƒddgtd	d
ddddƒddggg d¢d�}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.
rn   r   ÚymdHMS©r   rL   rB   r_   r¼   rÀ   rH  ro   FrB  rL   rÀ   rÜ   r|   rC  rD  rE  ©rR  rï   rð   rE   ©r6   r   r	   r   r8   r9   ©r;   rM  r¨   r3  rQ   rR   r<   r=   r   r   r    Útest_parse_date_all_fieldsD  s*    ý
ûúù	þûrW  c                 C   s   t j| dd�S )Nú%Y %m %d %H %M %S.%frO  rQ  rÐ   r   r   r    rÒ   n  r*   )ré   rX  Nc                 C   s�   | }d}|j |dt|ƒfddg d¢idœ||i¤ddi¤Ž}ttd	d
dddddd�ddgtd	d
dddddd�ddggg d¢d�}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.
rn   r   rR  rS  rH  ro   FrB  rL   rÀ   rÜ   i@â )Úmicrosecondr|   rC  i ¡ rD  rE  rT  rE   rU  rV  r   r   r    Ú test_datetime_fractional_secondsi  s*    ý
ûúù	þûrZ  c              	   C   s†   | }d}dd„ }|j tdt|ƒddddgi|dd	�}ttd
ddƒddgtd
ddƒddggg d¢d�}|d  d¡|d< t ||¡ d S )NrJ  c                 S   s   dd„ t | |ƒD ƒS )Nc                 S   s&   g | ]\}}t t|ƒt|ƒd d�‘qS )rL   )ÚyearÚmonthÚday)r   r   )r'   ÚyÚmr   r   r    r)   “  r*   z8test_generic.<locals>.parse_function.<locals>.<listcomp>)Úzip)ÚyyÚmmr   r   r    Úparse_function’  s    z$test_generic.<locals>.parse_functionrn   r   ÚymrL   FrK  rB  rÜ   rC  rB   rE  )rd  r]  rï   rE   údatetime64[ns])r6   r7   r   r	   r   r   r8   r9   )r;   rQ   rR   rc  r<   r=   r   r   r    Útest_genericŽ  s$    
ù	"þrf  c                 C   s†   | }d}dd„ }|j tdt|ƒ|dddgiddgd	�}tjd
gd dd�}tddgd itj|g d¢gddgd�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   sF   z| d | }W n& t y6   dd„ t| |ƒD ƒ}Y n0 tj|dd�S )NÚTc                 S   s   g | ]\}}t  ||¡‘qS r   )r   Úcombine)r'   r  Útr   r   r    r)   ¶  r*   zNtest_date_parser_resolution_if_not_ns.<locals>.date_parser.<locals>.<listcomp>údatetime64[s]rÝ   )r  r`  r   Úarray)r·   r   Zarrr   r   r    r%   ±  s
    z:test_date_parser_resolution_if_not_ns.<locals>.date_parserrn   r   r   r   Zprn)r%   r$   r&   z2013-11-03T19:00:00r_   rj  rÝ   ZrxstatusZ00E80000)é~   r”   rC   r
  )rR   r5   )
r6   r7   r   r   rk  r	   r   Zfrom_arraysr8   r9   )r;   rQ   rR   r%   r<   Z	datetimesr=   r   r   r    Ú%test_date_parser_resolution_if_not_ns¦  s(    
ú	
þþrm  c                 C   sR   | }d}|j t|ƒdgd�}ddgddgddgg}t|d	dgd
�}t ||¡ d S )Nz+case,opdate
7,10/18/2006
7,10/18/2008
621, ZopdaterÅ   rÁ   z
10/18/2006z
10/18/2008im  ú ÚcaserE   ©r   r   r	   r8   r9   )r;   rQ   rR   r<   rF  r=   r   r   r    Ú(test_parse_date_column_with_empty_stringÍ  s    rq  zdata,expectedz"a
135217135789158401
1352171357E+5l   0„l    H®bêk r   rÝ   z%a
99999999999
123456789012345
1234E+0)l   ÿgí] l   y_"A iÒ  c                 C   s&   | }|j t|ƒ|d�}t ||¡ d S )NrÅ   rì   )r;   rR   r=   r$   rQ   r<   r   r   r    Útest_parse_date_floatØ  s    rr  c                 C   sb   | }d}|j t|ƒdgd�}tdddttdd�ƒd	� d ¡}|g d
¢dœ}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Å   z2018-01-04 09:01:00z2018-01-04 09:05:00Z1mini  )Úminutes)ÚstartÚendÚfreqrË   )i6[  éh[  rw  rw  rw  )r·   Úval)	r   r   r   r   r   rô   r	   r8   r9   )r;   rQ   rR   r<   ZdtirF  r=   r   r   r    Útest_parse_timezoneñ  s    üûry  Údate_string)z
32/32/2019z
02/30/2019z
13/13/2019z13/2019z
a3/11/2018z
10/11/2o17c                 C   s<   | }t d|gidd�}|jt|ƒd dgd�}t ||¡ d S )Nr   ÚstrrÝ   rH  )r	   r   r   r8   r9   )r;   rz  rQ   r=   r<   r   r   r    Ú!test_invalid_parse_delimited_date  s    ýr|  zdate_string,dayfirst,expectedz
13/02/2019iã  rC   z
02/13/2019z
04/02/2019c                 C   s¦   | }t d|gidd�}|jdkr~|s0tjdd� d}tjt|d��( |jt|ƒd |dgd	� W d   ƒ n1 sp0    Y  d S |jt|ƒd |dgd	�}t 	||¡ d S )
Nr   re  rÝ   rX   z,https://github.com/apache/arrow/issues/38676rZ   z@The 'dayfirst' option is not supported with the 'pyarrow' enginerª   ©rO   r  r$   )
r	   rš   r›   Úskipr­   r®   r   r   r8   r9   )r;   rz  r  r=   r    rQ   r¯   r<   r   r   r    Ú)test_parse_delimited_date_swap_no_warning  s    
ÿ$ÿr  c                 C   sF   | }t d|gidd�}d}|jt|t|ƒd |dgd�}t ||¡ d S )Nr   re  rÝ   úzParsing dates in .* format when dayfirst=.* was specified. Pass `dayfirst=.*` or specify a format to silence this warning.r}  )r	   r6   rþ   r   r8   r9   )r;   rz  r  r=   rQ   Úwarning_msgr<   r   r   r    Ú+test_parse_delimited_date_swap_with_warning:  s    ÿúr‚  c                   C   s@   t jtdd�� t g d¢¡ W d   ƒ n1 s20    Y  d S )Nz_^time data "31/05/2000" doesn\'t match format "%m/%d/%Y", at position 1. You might want to try:rª   )z
01/01/2000z
31/05/2000z
31/05/2001z
01/02/2000)r›   r­   r®   r   r¶   r   r   r   r    Ú6test_parse_multiple_delimited_dates_with_swap_warningsX  s
    ýrƒ  z)names, usecols, parse_dates, missing_colsrx  z
date, time)Údate1Ztime1Útemperaturer„  r…  c           
   	   C   s¶   | }t dƒ}d|› d�}d}t}	t|tƒr@tdd„ |D ƒƒr@d }	tjt|d��T tj	|	|dd	��$ |j
|d
|||d� W d   ƒ n1 sŠ0    Y  W d   ƒ n1 s¨0    Y  d S )Nz%date,time,val
2020-01-31,04:20:32,32
z+Missing column provided to 'parse_dates': 'ú'rG   c                 s   s   | ]}t |ttfƒV  qd S r¥   )r  r   r{  )r'   rÑ   r   r   r    r©   …  s   z9test_missing_parse_dates_column_raises.<locals>.<genexpr>rª   FrH   r9  )rM   rm   Úusecolsr$   )r   r7   r  r   Úallr›   r­   r®   r8   rP   r   )
r;   rm   r‡  r$   Zmissing_colsrQ   Úcontentr¯   rS   r3  r   r   r    Ú&test_missing_parse_dates_column_raisese  s    ÿÿ
ÿrŠ  c                 C   sb   | }t dƒ}t}|jdkr"ttf}|j|d|dgdgd�}tdddgidd	gd
�}t ||¡ d S )Nzx,y
1,2rX   rö   rá   )r$   rm   r^  Ú2rÑ   Ú1r4   )r   rþ   rš   r²   r6   r	   r8   r9   )r;   rQ   rR   r3  r<   r=   r   r   r    Útest_date_parser_and_names‘  s    
ûr�  c                 C   sL   | }d}|j t|ƒdgddgd�}ttdƒ d¡dgd	œƒ}t ||¡ d S )
Nza,b
1,2
2019-12-31,6©rï   rŒ  r   rL   ©r$   rO   ú
2019-12-31rß   rA   )rŽ  ©rð   r‹  )r   r   r	   r   rã   r8   r9   rÃ   r   r   r    Ú#test_date_parser_multiindex_columns¥  s    ÿr’  zparse_spec, col_namerŽ  r‘  )Úa_bZ1_2)r/  rŒ  c                 C   s€   | }d}d}t jt|dd��( |jt|ƒ|ddgd�}W d   ƒ n1 sJ0    Y  t|tdƒ d	¡d
dgiƒ}t  ||¡ d S )Nza,b,c
1,2,3
2019-12,-31,6rG   FrH   r   rL   r�  r�  rß   )rñ   Ú3rA   )	r8   rP   r7   r   r   r	   r   rã   r9   )r;   Z
parse_specZcol_namerQ   rR   rS   r<   r=   r   r   r    Ú0test_date_parser_multiindex_columns_combine_cols²  s     	ÿÿý$ÿr•  c                 C   s°   d}| }|j dkrdd}tjt|d��, |jt|ƒdgddgdd� W d   ƒ n1 sV0    Y  d S |jtd	t|ƒdgddgdd�}td
dgt	dƒgd dœƒ}t
 ||¡ d S )Nz2A,B,C
    1,3,20-09-01-01
    2,4,20-09-01-01
    rX   zAThe 'thousands' option is not supported with the 'pyarrow' enginerª   rL   rB   rK   )r$   r‡  rN   rö   r_   r¼   z20-09-2001 01:00:00rý   )rš   r›   r­   r®   r   r   r6   rþ   r	   r   r8   r9   )r;   rR   rQ   r¯   r<   r=   r   r   r    Ú"test_date_parser_usecols_thousandsÑ  s,    
ü$úr–  c                 C   s„   | }d}d}t jt|dd��* |jt|ƒddgidd�}W d   ƒ n1 sL0    Y  td	ƒtd
ƒg}t||dœƒ}t  ||¡ d S )NzA
20150908
20150909
r±   FrH   r   rà   T)r$   rV   z
2015-09-08z
2015-09-09)r   rà   )r8   rP   r7   r   r   r   r	   r9   )r;   rQ   rR   rS   r<   rF  r=   r   r   r    Ú)test_parse_dates_and_keep_original_columnò  s    ÿÿ$r—  c                  C   s$  d} t ddgdd dd�}d}tt| ƒdgddd	�j}t ||¡ tjt|d
��( tt| ƒdgddd	�j}W d   ƒ n1 s|0    Y  t ||¡ d} tddgddd�}tt| ƒdgddd	�j}t ||¡ tjt|d
��( tt| ƒdgddd	�j}W d   ƒ n1 �s
0    Y  t ||¡ d S )Nzdate
31/12/2014
10/03/2011z
2014-12-31z
2011-03-10re  r   ©rÞ   rv  r,   r€  T)r$   r  r&   rª   Fzdate
31/12/2014
03/30/2011z
31/12/2014z
03/30/2011r{  rü   )	r
   r   r   r5   r8   Úassert_index_equalrP   rþ   r   )Úinputr=   r�  Zres1Zres2Zres5Zres6r   r   r    Útest_dayfirst_warnings  s4    ÿÿÿÿ&ÿÿ(r›  zdate_string, dayfirstz	31/1/2014zsecond date is single-digit)Úidz	1/31/2014zfirst date is single-digitc                 C   sv   d| › �}t dgdd dd�}d}tjt|d��( tt|ƒdgd|d�j}W d   ƒ n1 s\0    Y  t ||¡ d S )	Nzdate
z
2014-01-31re  r   r˜  r€  rª   )r$   r&   r  )r
   r8   rP   rþ   r   r   r5   r™  )rz  r  Úinitial_valuer=   r�  Úresr   r   r    Ú&test_dayfirst_warnings_no_leading_zero6  s    

ÿÿü&rŸ  c                 C   sB   | }d}|j t|ƒdgd�}tddddœdgd	�}t ||¡ d S )
Nza,b,c
1970-01-01,2,3,4rï   rÅ   r‹  r_   r¼   rî   rµ   r4   rp  rÃ   r   r   r    Ú test_infer_first_column_as_indexY  s    þr   c                 C   s   t j| dd�S )Nú%Y-%m-%drO  rQ  rÐ   r   r   r    rÒ   j  r*   )ré   r¡  Nc                 C   sl   | }d}|j |dt|ƒfdddgidgdœ||i¤Ž}tdtdƒtjtdƒtjtd	ƒgiƒ}t ||¡ d S )
Nz*Test
2012-10-01
0
2015-05-15
#
2017-09-09
rn   ZTestú#r2  )r  r$   z
2012-10-01z
2015-05-15z
2017-09-09)r6   r   r	   r   r   r7  r8   r9   rV  r   r   r    Ú&test_replace_nans_before_parsing_datesf  s.    
ý
ûúûÿÿr£  c                 C   sV   | }d}|j t|ƒddgd�}tdgtdƒgdœƒ}|d  d¡|d< t ||¡ d S )	Nza,b
1,2019-12-31
Ústringrð   )rÞ   r$   rŒ  r�  ©rï   rð   rï   )r   r   r	   r   r   r8   r9   rÃ   r   r   r    Ú!test_parse_dates_and_string_dtypeŽ  s    r¦  c                 C   s‚   | }d}|j dkr*tddgddd�}d }ntdd	gd
dd�}t}d}|j||t|ƒdddd�}tdddgi|d�}t ||¡ d S )Nz7a,b
27.03.2003 14:55:00.000,1
03.08.2003 15:20:00.000,2rX   z27.03.2003 14:55:00.000z03.08.2003 15:20:00.000r{  rï   rü   z2003-03-27 14:55:00z2003-08-03 15:20:00re  z1when dayfirst=False \(the default\) was specifiedTr   F)r$   r&   ro   rð   rL   rB   r4   )	rš   r   r
   rþ   r6   r   r	   r8   r9   )r;   rQ   rR   Zexpected_indexr3  r¯   r<   r=   r   r   r    Útest_parse_dot_separated_dates›  s4    
ýýúr§  c                 C   s\   | }d}|j t|ƒdddœddgd�}ttdƒtd	ƒgtdƒtd	ƒgdœƒ}t ||¡ d S )
Nú/a,b
2019-12-31,31-12-2019
2020-12-31,31-12-2020r¡  z%d-%m-%Yr¥  rï   rð   ©ré   r$   r�  ú
2020-12-31)r   r   r	   r   r8   r9   rÃ   r   r   r    Útest_parse_dates_dict_format¼  s    ýþÿr«  zkey, parse_datesr“  r/  c                 C   s€   | }d}d}t jttf|dd��( |jt|ƒ|di|d�}W d   ƒ n1 sN0    Y  t|tdƒtdƒgiƒ}t  ||¡ d S )	Nza,b
31-,12-2019
31-,12-2020rG   FrH   z	%d- %m-%Yr©  r�  rª  )	r8   rP   r7   r²   r   r   r	   r   r9   )r;   rM  r$   rQ   rR   rS   r<   r=   r   r   r    Ú(test_parse_dates_dict_format_two_columnsÑ  s    ÿ
ÿÿ$ÿÿr¬  c                 C   sZ   | }d}|j t|ƒddiddd�}tddd	gittd
ƒtdƒgdd�d�}t ||¡ d S )Nr¨  rï   r¡  Tr   )ré   r$   r&   rð   z
31-12-2019z
31-12-2020r�  rª  r+   r4   )r   r   r	   r   r   r8   r9   rÃ   r   r   r    Ú"test_parse_dates_dict_format_indexì  s    ÿÿür­  c                 C   sd   | }d}|j t|ƒdgd�}|jdkr:|d j d¡|d< ttdƒtdƒgdd	œƒ}t ||¡ d S )
Nz/a,b
2000-01-01 00:00:00,1
2000-01-01 00:00:01,1rï   rÅ   rX   rß   z2000-01-01 00:00:00z2000-01-01 00:00:01rL   r¥  )	r   r   rš   r·   rã   r	   r   r8   r9   rÃ   r   r   r    Útest_parse_dates_arrow_engine 	  s    
þûÿ	r®  c                 C   sN   | }d}|j t|ƒdgd�d }ttdƒtdƒgdddgd�}t ||¡ d S )	Nz5a
2020-01-01T00:00:00+01:00
2020-01-01T00:00:00+00:00rï   rÅ   z2020-01-01 00:00:00+01:00z2020-01-01 00:00:00+00:00r   rL   )r,   r5   )r   r   r   r   r8   Zassert_series_equalrÃ   r   r   r    Ú test_from_csv_with_mixed_offsets	  s    þúr¯  )oÚ__doc__r   r   r   r   Úior   Zdateutil.parserr   r]   Únumpyr   r›   r  Zpandas._libs.tslibsr   Zpandasr   r	   r
   r   r   r   r   Zpandas._testingZ_testingr8   Zpandas.core.indexes.datetimesr   Zpandas.core.tools.datetimesr   Zpandas.io.parsersr   rœ   ÚfilterwarningsZ
pytestmarkZusefixturesZxfail_pyarrowZskip_pyarrowr>   r?   rU   Zparametrizer¢   r   r«   r°   r³   r¸   r½   rÄ   rÉ   rÊ   rÛ   rå   rë   rí   rõ   r�   r   r  r  r  r  r  r#  r$  r%  r)  rk  r+  r1  r4  r8  r;  r<  Úfrom_tuplesrA  rG  rI  rL  r7   rW  rZ  rf  rm  rq  rr  ry  r|  r  r‚  rƒ  rŠ  r�  r’  r•  r–  r—  r›  ÚparamrŸ  r   r£  r¦  r§  r«  r¬  r­  r®  r¯  r   r   r   r    Ú<module>   s~   ÿ
'
"

 

 .@(
_ú	
ú÷þ
;



2-*þf
b!
 

ÿ
ÿ
ýý
ÿýÿüýîþ 
þûùüüüüüüá&ÙöðþH
ýúþ
ýúþ

&þþûþþúþ
üþ	ü÷þ

þþ!
0ýýúþ

þþ 
!&ÿ