a
    DBìjyÚ ã                
   @   s´  d dl Z d dlZd dlZd dlZd dlm  mZ d dl	Z
d dl	mZmZmZmZmZ d dlmZ d dlmZ ejg d¢d�dd„ ƒZG dd	„ d	ƒZej d
dejde d¡d�g¡ej dddidddœg¡ej dddgddgg¡dd„ ƒƒƒZdd„ Zej ddddœdddœdddœg¡d d!„ ƒZd"d#„ Zd$d%„ Z d&d'„ Z!d(d)„ Z"d*d+„ Z#ej d,d-ejd.e d¡d�ejd/e d¡d�g¡d0d1„ ƒZ$e d¡d2d3„ ƒZ%d4d5„ Z&d6d7„ Z'dS )8é    N)ÚIndexÚ	TimedeltaÚ
merge_asofÚoption_contextÚto_datetime)Ú
MergeError)ÚsÚmsÚusÚns)Úparamsc                 C   s   | j S )z-
    Resolution for datetimelike dtypes.
    )Úparam)Úrequest© r   úi/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/reshape/merge/test_merge_asof.pyÚunit   s    r   c                   @   sÈ  e Zd Zd�dd„Zejdd„ ƒZejdd„ ƒZejdd	„ ƒZejd
d„ ƒZ	ejdd„ ƒZ
ejdd„ ƒZdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zd d!„ Zd"d#„ Zd$d%„ Zd&d'„ Zd(d)„ Zd*d+„ Zd,d-„ Zd.d/„ Zej d0d1d2g¡d3d4„ ƒZd5d6„ Zd7d8„ Z d9d:„ Z!d;d<„ Z"d=d>„ Z#d?d@„ Z$dAdB„ Z%dCdD„ Z&dEdF„ Z'dGdH„ Z(ejjdIe)dJƒe*j+dKdL�gdMdNgdO�dPdQ„ ƒZ,dRdS„ Z-dTdU„ Z.dVdW„ Z/dXdY„ Z0dZd[„ Z1d\d]„ Z2d^d_„ Z3d`da„ Z4dbdc„ Z5ddde„ Z6dfdg„ Z7dhdi„ Z8djdk„ Z9dldm„ Z:dndo„ Z;dpdq„ Z<drds„ Z=dtdu„ Z>dvdw„ Z?dxdy„ Z@dzd{„ ZAd|d}„ ZBd~d„ ZCejjd€d�d‚„ dƒd‚„ gd„d…gdO�ej d†d‡dˆg¡d‰dŠ„ ƒƒZDd‹dŒ„ ZEd�dŽ„ ZFd�d�„ ZGej d0g d‘¢¡d’d“„ ƒZHd”d•„ ZId–d—„ ZJd˜d™„ ZKdšd›„ ZLdœS )žÚTestAsOfMergeFc                 C   s.   |r|j ddgdd�jdd�}t|jƒ|_|S )NÚtimeÚtickerÚlast)ZkeepT©Údrop)Zdrop_duplicatesÚreset_indexr   r   )ÚselfÚdfÚdeduper   r   r   Ú	prep_data   s    ÿzTestAsOfMerge.prep_datac                 C   sä   t jg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d	¢g d
¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢gd d¡d�}|d  d¡|d< |d  d¡|d< |  |¡S ) N©ú20160525 13:30:00.023ÚMSFTú51.9500Ú75ÚNASDAQ©ú20160525 13:30:00.038r   r    Ú155r"   ©ú20160525 13:30:00.048ÚGOOGz720.7700Ú100r"   ©r'   r(   z720.9200r)   r"   ©r'   r(   ú720.9300Ú200r"   ©r'   r(   r,   Ú300r"   ©r'   r(   r,   Ú600r"   ©r'   r(   r,   Ú44r"   ©ú20160525 13:30:00.074ÚAAPLú98.6700Ú478343r"   ©ú20160525 13:30:00.075r6   r7   r8   r"   ©r:   r6   z98.6600Ú6r"   ©r:   r6   ú98.6500Ú30r"   ©r:   r6   r>   r!   r"   ©r:   r6   r>   Ú20r"   ©r:   r6   r>   Ú35r"   ©r:   r6   r>   Ú10r"   ©r:   r6   ú98.5500r<   ÚARCA©ú20160525 13:30:00.076r6   ú98.5600Ú1000rI   ©rK   r6   rL   r-   rI   ©rK   r6   rL   r/   rI   ©rK   r6   rL   Ú400rI   ©rK   r6   rL   r1   rI   ©ú20160525 13:30:00.078r   r    Ú783r"   ©rT   r   r    r)   r"   ú'time,ticker,price,quantity,marketCenterú,©ÚcolumnsÚpriceÚfloat64ÚquantityÚint64©ÚpdÚ	DataFrameÚsplitÚastyper   ©r   r   r   r   r   Útrades&   sD    åâ zTestAsOfMerge.tradesc                 C   s¦   t jg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d	¢gd
 d¡d�}|d  d¡|d< |d  d¡|d< | j|dd�S )N©r   r(   ú720.50ú720.93©r   r   ú51.95rj   ©ú20160525 13:30:00.041r   rj   rj   ©r'   r(   rg   rh   ©ú20160525 13:30:00.072r(   rg   z720.88©r:   r6   ú98.55ú98.56©rK   r6   rq   rr   ©rT   r   rj   rj   ©rT   r   ú51.92rj   útime,ticker,bid,askrX   rY   Úbidr\   ÚaskT©r   r_   rd   r   r   r   ÚquotesL   s.    ðízTestAsOfMerge.quotesc                 C   s  t jg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢d	d
dddtjtjgg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢gd d¡d�}|d   d!¡|d < |d"  d#¡|d"< |d$  d!¡|d$< |d%  d!¡|d%< |  |¡S ©&N©r   r   rj   r!   r"   rj   rj   ©r$   r   rj   r%   r"   rj   rj   ©r'   r(   z720.77r)   r"   ú720.5rh   ©r'   r(   z720.92r)   r"   r€   rh   ©r'   r(   rh   r-   r"   r€   rh   ©r'   r(   rh   r/   r"   r€   rh   ©r'   r(   rh   r1   r"   r€   rh   ©r'   r(   rh   r3   r"   r€   rh   r5   r6   ú98.67r8   r"   ©r:   r6   r†   r8   r"   rq   rr   ©r:   r6   ú98.66r<   r"   rq   rr   ©r:   r6   ú98.65r?   r"   rq   rr   ©r:   r6   r‹   r!   r"   rq   rr   ©r:   r6   r‹   rB   r"   rq   rr   ©r:   r6   r‹   rD   r"   rq   rr   ©r:   r6   r‹   rF   r"   rq   rr   ©r:   r6   rq   r<   rI   rq   rr   ©rK   r6   rr   rM   rI   rq   rr   ©rK   r6   rr   r-   rI   rq   rr   ©rK   r6   rr   r/   rI   rq   rr   ©rK   r6   rr   rQ   rI   rq   rr   ©rK   r6   rr   r1   rI   rq   rr   ©rT   r   rj   rU   r"   rv   rj   ©rT   r   rj   r)   r"   rv   rj   ú/time,ticker,price,quantity,marketCenter,bid,askrX   rY   r[   r\   r]   r^   rx   ry   ©r`   ra   ÚnpÚnanrb   rc   r   rd   r   r   r   Úasofg   s^    							
ù																		€ • v€ Š yzTestAsOfMerge.asofc                 C   s  t jg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢d	d
dddtjtjgg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢gd d¡d�}|d   d!¡|d < |d"  d#¡|d"< |d$  d!¡|d$< |d%  d!¡|d%< |  |¡S r|   r™   rd   r   r   r   Ú	toleranceg  s^    							
ù																		€ • v€ Š yzTestAsOfMerge.tolerancec                 C   s¢  t jdddddtjtjgg d¢g d¢g d¢g d	¢g d
¢g d¢g d¢dddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgg d¢g d¢g d¢g d¢g d¢g d¢g d ¢g d!¢g d!¢gd" d#¡d$�}|d%  d&¡|d%< |d'  d(¡|d'< |d)  d&¡|d)< |d*  d&¡|d*< |  |¡S ©+Nr   r   rj   r!   r"   r~   r   r�   r‚   rƒ   r„   r…   r5   r6   r†   r8   r:   r‰   r<   r‹   r?   rB   rD   rF   rq   rI   r‘   r’   r“   r”   r•   )rT   r   rj   rU   r"   rj   rj   )rT   r   rj   r)   r"   rj   rj   r˜   rX   rY   r[   r\   r]   r^   rx   ry   r™   )r   Údatapathr   r   r   r   Úallow_exact_matchesg  sÎ    ù							
ù
ù
ù
ù
ù
ù
ù
ù									€ ¥ f€ š iz!TestAsOfMerge.allow_exact_matchesc                 C   s¢  t jdddddtjtjgg d¢g d¢g d¢g d	¢g d
¢g d¢g d¢dddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgdddddtjtjgg d¢g d¢g d¢g d¢g d¢g d¢g d ¢g d!¢g d!¢gd" d#¡d$�}|d%  d&¡|d%< |d'  d(¡|d'< |d)  d&¡|d)< |d*  d&¡|d*< |  |¡S rž   r™   rd   r   r   r   Ú!allow_exact_matches_and_toleranceW  sÎ    ù							
ù
ù
ù
ù
ù
ù
ù
ù									€ ¥ f€ š iz/TestAsOfMerge.allow_exact_matches_and_tolerancec                 C   sl   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢g d¢dœ¡}t||dd	�}t ||¡ d
S )údoc-string examples©é   é   é
   ©ÚaÚbÚc©r¨   Úleft_val©r¤   é   é   é   é   ©r¨   Ú	right_val©r¤   r¯   r±   ©r¨   r¬   r³   r¨   ©ÚonN©r`   ra   r   ÚtmÚassert_frame_equal©r   ÚleftÚrightÚexpectedÚresultr   r   r   Útest_examples1G  s    ÿzTestAsOfMerge.test_examples1c                 C   sB  |dkrt  d¡ tjtg d¢ƒ d|› d�¡g d¢g d¢g d¢d	œg d	¢d
�}tjtg d¢ƒ d|› d�¡g d¢g d¢g d¢dœg d¢d
�}t||ddd� t||ddtdƒd� tjtg d¢ƒ d|› d�¡g d¢g d¢g d¢tj	dtj	tj	tj	gtj	dtj	tj	tj	gdœg d¢d
�}t||ddtdƒdd�}t
 ||¡ dS )r¢   r   zNThis test is invalid for unit='s' because that would round the trades['time']])r   r$   r'   r'   r'   úM8[ú]©r   r   r(   r(   r6   ©çš™™™™ùI@rÅ   g\�Âõ(††@ç�Âõ(\‡†@g     €X@©éK   é›   éd   rÊ   rÊ   )r   r   r[   r]   rY   )r   r   ú20160525 13:30:00.030rl   r'   ú20160525 13:30:00.049ro   r:   )r(   r   r   r   r(   r6   r(   r   )ç     „†@rÅ   ç\�Âõ(üI@ç…ëQ¸þI@rÍ   ç�Âõ(\X@rÍ   gáz®GJ@)ç=
×£p‡†@ç{®GáúI@ç=
×£pýI@ç      J@rÑ   çq=
×£€X@g×£p=
‡†@g¤p=
×J@)r   r   rx   ry   r   r   ©r·   ÚbyZ2ms©r·   r×   r�   rÎ   rÓ   )r   r   r[   r]   rx   ry   Ú10msF©r·   r×   r�   r    N)ÚpytestÚskipr`   ra   r   rc   r   r   rš   r›   r¹   rº   )r   r   re   r{   r¾   r¿   r   r   r   Útest_examples2S  sj    ÿÿ
ø	ôñÿ
õ
èåÿ
ø	òïúzTestAsOfMerge.test_examples2c                 C   sr   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢ddtjgdœ¡}t||d	d
d�}t ||¡ dS )r¢   r£   r§   r«   r­   r²   r¤   r°   rµ   r¨   Úforward©r·   Ú	directionN©r`   ra   rš   r›   r   r¹   rº   r»   r   r   r   Útest_examples3¬  s    ÿzTestAsOfMerge.test_examples3c                 C   sn   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢g d¢dœ¡}t||dd	d
�}t ||¡ dS )r¢   r£   r§   r«   r­   r²   )r¤   r°   r±   rµ   r¨   Únearestrß   Nr¸   r»   r   r   r   Útest_examples4º  s    ÿzTestAsOfMerge.test_examples4c                 C   s$   |}t ||ddd�}t ||¡ d S )Nr   r   rÖ   ©r   r¹   rº   ©r   re   rœ   r{   r¾   r¿   r   r   r   Ú
test_basicÈ  s    zTestAsOfMerge.test_basicc                 C   sN   |}|j  d¡|_ |j  d¡|_ |j  d¡|_ t||ddd�}t ||¡ d S )NÚcategoryr   r   rÖ   )r   rc   r   r¹   rº   ræ   r   r   r   Útest_basic_categoricalÎ  s    z$TestAsOfMerge.test_basic_categoricalc                 C   sB   |}|  d¡}t||dddd�}|j|_||j }t ||¡ d S )Nr   Tr   )Ú
left_indexÚright_onr×   )Ú	set_indexr   ÚindexrZ   r¹   rº   ræ   r   r   r   Útest_basic_left_index×  s    

ÿ
z#TestAsOfMerge.test_basic_left_indexc                 C   s0   |}|  d¡}t||dddd�}t ||¡ d S )Nr   Tr   )Úleft_onÚright_indexr×   ©rì   r   r¹   rº   ræ   r   r   r   Útest_basic_right_indexå  s    

ÿz$TestAsOfMerge.test_basic_right_indexc                 C   s@   |  d¡}|  d¡}|  d¡}t||dddd�}t ||¡ d S )Nr   Tr   ©rê   rð   r×   rñ   ræ   r   r   r   Ú!test_basic_left_index_right_indexî  s    



ÿz/TestAsOfMerge.test_basic_left_index_right_indexc                 C   sZ   |  ddg¡}|  d¡}tjtdd��  t||ddd� W d   ƒ n1 sL0    Y  d S )Nr   r[   zleft can only have one index©ÚmatchT©rê   rð   ©rì   rÛ   Úraisesr   r   ©r   re   r{   r   r   r   Útest_multi_index_leftø  s    
z#TestAsOfMerge.test_multi_index_leftc                 C   sZ   |  d¡}|  ddg¡}tjtdd��  t||ddd� W d   ƒ n1 sL0    Y  d S )Nr   rx   zright can only have one indexrõ   Tr÷   rø   rú   r   r   r   Útest_multi_index_rightÿ  s    
z$TestAsOfMerge.test_multi_index_rightc                 C   s\   |  d¡}|  d¡}d}tjt|d��" t||dddd� W d   ƒ n1 sN0    Y  d S )Nr   z:Can only pass argument "left_on" OR "left_index" not both.rõ   r[   T)rï   rê   rð   rø   ©r   re   r{   Úmsgr   r   r   Útest_on_and_index_left_on  s    


ÿz'TestAsOfMerge.test_on_and_index_left_onc                 C   s\   |  d¡}|  d¡}d}tjt|d��" t||dddd� W d   ƒ n1 sN0    Y  d S )Nr   z<Can only pass argument "right_on" OR "right_index" not both.rõ   rx   T)rë   rê   rð   rø   rý   r   r   r   Útest_on_and_index_right_on  s    


ÿz(TestAsOfMerge.test_on_and_index_right_onc                 C   s&   |}t ||dddd�}t ||¡ d S )Nr   r   )r·   Úleft_byÚright_byrå   ræ   r   r   r   Útest_basic_left_by_right_by  s
    
ÿz)TestAsOfMerge.test_basic_left_by_right_byc                 C   sL   |}||j dk }t||ddd�}tj|j|j dkddgf< t ||¡ d S )Nr   r   r   rÖ   rx   ry   )r   r   rš   r›   Úlocr¹   rº   )r   re   rœ   r{   r¾   Úqr¿   r   r   r   Útest_missing_right_by"  s
    z#TestAsOfMerge.test_missing_right_byc                 C   sæ   t jtg d¢ƒg d¢g d¢g d¢g d¢dœg d¢d�}t jtg d¢ƒg d	¢g d
¢g d¢g d¢dœg d¢d�}t jtg d¢ƒg d¢g d¢g d¢g d¢tjdddtjgtjdddtjgdœg d¢d�}t||dddgd�}t ||¡ d S )N©r   r   z20160525 13:30:00.046r'   ú20160525 13:30:00.050rÃ   ©rI   ÚNSDQr
  ÚBATSr
  rÄ   rÇ   ©r   r   Úexchr[   r]   rY   ©r   r   rË   rl   z20160525 13:30:00.045rÌ   )r(   r   r   r   r(   r6   ©r  r
  rI   rI   r
  rI   ©ç®Gáz„†@rÅ   rÎ   rÏ   rÍ   rÐ   ©rÆ   rÒ   rÓ   rÔ   rÑ   rÕ   ©r   r   r  rx   ry   rÅ   rÍ   r  rÒ   rÑ   rÆ   ©r   r   r  r[   r]   rx   ry   r   r   r  rÖ   )r`   ra   r   rš   r›   r   r¹   rº   )r   re   r{   r¾   r¿   r   r   r   Útest_multiby*  sJ    ÿ	óðÿ
òïÿ	ñîzTestAsOfMerge.test_multibyÚdtypeÚobjectÚstringc                 C   s  t jtg d¢ƒg d¢g d¢g d¢g d¢dœg d¢d�}| ||dœ¡}t jtg d	¢ƒg d
¢g d¢g d¢g d¢dœg d¢d�}| ||dœ¡}t jtg d¢ƒg d¢g d¢g d¢g d¢tjdddtjgtjdddtjgdœg d¢d�}| ||dœ¡}t||dddgd�}t ||¡ d S )Nr  )r   r   r¤   r¤   r®   r	  rÄ   rÇ   r  rY   )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`   ra   r   rc   rš   r›   r   r¹   rº   )r   r  re   r{   r¾   r¿   r   r   r   Ú test_multiby_heterogeneous_typesk  sP    ÿ	óðÿ
òïÿ	ñîz.TestAsOfMerge.test_multiby_heterogeneous_typesc                 C   sö   t jtdƒddgtdƒddgtdƒddgtdƒddggg d¢d� d	¡}|jt  d
¡ |_t jtdƒdddgtdƒdddgtdƒdddgtdƒdddggg d¢d� d	¡}d}tjt|d��& t	||ddddgd� W d   ƒ n1 sè0    Y  d S )NÚ20160602r¤   r¨   r®   Ú20160603r©   ©r   Úk1Úk2rY   r   r   Ú20160502ç      ð?ç       @Ú20160503ç      @ç      @©r   r  r  Úvaluezincompatible merge keysrõ   Tr  r  ró   )
r`   ra   r   rì   rí   Ú	TimestamprÛ   rù   r   r   )r   r¼   r½   rþ   r   r   r   Útest_mismatched_index_dtype°  s0    üùø
üùø
z)TestAsOfMerge.test_mismatched_index_dtypec              	   C   sX  t jtdƒddgtdƒddgtdƒddgtdƒddggg d¢d� d	¡}t jtd
ƒdddgtd
ƒdddgtdƒdddgtdƒdddggg d¢d� d	¡}t jtdƒdddgtdƒdddgtdƒdddgtdƒdddggg d¢d� d	¡}t||ddddgd�}t ||¡ tjt	dd��* t||ddddgdgd� W d   ƒ n1 �sJ0    Y  d S )Nr  r¤   r¨   r®   r  r©   r  rY   r   r  r   r!  r"  r#  r$  r%  Tr  r  ró   z,left_by and right_by must be the same lengthrõ   )rê   rð   r  r  )
r`   ra   r   rì   r   r¹   rº   rÛ   rù   r   r»   r   r   r   Útest_multiby_indexedÌ  sZ    üùø
üùø
üùø
ÿÿúz"TestAsOfMerge.test_multiby_indexedc              O   C   s  t jg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢d	d
dddtjtjgg d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d ¢g d!¢g d"¢g d"¢g d#¢g d#¢g d$¢g d%¢g d&¢g d'¢g d(¢g d)¢g d*¢g d+¢g d,¢g d-¢g d.¢g d/¢g d0¢g d1¢g d2¢g d2¢g d3¢g d4¢g d5¢g d6¢g d7¢g d8¢g d9¢g d:¢g d;¢g d;¢g d<¢g d=¢g d>¢g d?¢g d@¢g dA¢g dB¢g dC¢g dD¢g dE¢g dF¢g dG¢g dH¢g dI¢g dI¢gMdJ dK¡dL�}|dM  dN¡|dM< |dO  dP¡|dO< |dQ  dN¡|dQ< |dR  dN¡|dR< |  |¡}t jg dS¢g dT¢g dU¢g dV¢g dW¢g dX¢g dY¢g dZ¢g d[¢g d\¢g d]¢g d^¢g d_¢g d`¢g da¢g db¢g dc¢g dc¢g dd¢g de¢g df¢g dg¢g dh¢g de¢g di¢g dj¢g dj¢g dk¢g dl¢g dm¢g dn¢g do¢g dp¢g dp¢g dq¢g dq¢g dr¢g ds¢g dt¢g du¢g dv¢g dw¢g dx¢g dy¢g dz¢g d{¢g d|¢g d}¢g d~¢g d¢g d€¢g d€¢g d�¢g d‚¢g dƒ¢g d„¢g d…¢g d†¢g d‡¢g dˆ¢g d‰¢g d‰¢g dŠ¢g d‹¢g dŒ¢g d�¢g dŽ¢g d�¢g d�¢g d‘¢g d’¢g d“¢g d”¢g d•¢g d–¢g d—¢g d—¢gMd˜ dK¡dL�}|dM  dN¡|dM< |dO  dP¡|dO< |  |¡}t jg d™¢g dš¢g d›¢g dœ¢g dœ¢g dœ¢g dœ¢g d�¢g dž¢g dŸ¢g dŸ¢g dŸ¢g d ¢g d ¢g d ¢g d¡¢g d¢¢g d£¢g d¤¢g d¥¢g d¦¢g d§¢g d¨¢g d¨¢g d¨¢g d¨¢g d©¢g dª¢g d«¢g d¬¢g d¬¢g d­¢g d®¢g d®¢g d¯¢g d°¢g d¯¢g d¯¢g d°¢g d±¢g d±¢g d²¢g d³¢g d³¢g d´¢g dµ¢g d¶¢g d¶¢g d·¢g d·¢g d¸¢g d¹¢g d¹¢g dº¢g d¹¢g dº¢g8d» dK¡dL�}|dQ  dN¡|dQ< |dR  dN¡|dR< | j|d¼d½�}t||d¾d¿dÀ�}t 	||¡ d S )ÁNr}   r~   r   r�   r‚   rƒ   r„   r…   r5   r6   r†   r8   r"   r‡   rˆ   rŠ   rŒ   r�   rŽ   r�   r�   r‘   r’   r“   r”   r•   r–   r—   )ú20160525 13:30:00.084r6   z98.64Ú40r"   rq   rr   )r*  r6   rq   Ú149ÚEDGXrq   rr   )ú20160525 13:30:00.086r6   rr   Ú500rI   rq   ú98.63)ú20160525 13:30:00.104r6   r0  Ú647r-  ú98.62r0  )r1  r6   r0  r/   r-  r3  r0  )r1  r6   r0  Ú50r"   r3  r0  )r1  r6   r0  Ú70r"   r3  r0  )r1  r6   r0  Ú1r"   r3  r0  )r1  r6   r0  Ú62r"   r3  r0  )r1  r6   r0  rF   r"   r3  r0  )r1  r6   r0  r)   rI   r3  r0  )ú20160525 13:30:00.105r6   r0  r)   rI   r3  r0  )r8  r6   r0  Ú700rI   r3  r0  )ú20160525 13:30:00.106r6   r0  Ú61r-  r3  r0  )ú20160525 13:30:00.107r6   r0  r)   rI   r3  r0  )r<  r6   r0  Ú53rI   r3  r0  )ú20160525 13:30:00.108r6   r0  r)   rI   r3  r0  )r>  r6   r0  Ú839rI   r3  r0  )ú20160525 13:30:00.115r6   r0  Ú5r-  r3  r0  )ú20160525 13:30:00.118r6   r0  Ú295r-  r3  r0  )rB  r6   r0  rA  r-  r3  r0  )ú20160525 13:30:00.128r6   r0  r)   r"   r3  r0  )rD  r   rv   r)   rI   rv   rj   )ú20160525 13:30:00.129r6   r3  r)   r"   ú98.61r0  )rE  r6   r3  rF   r"   rF  r0  )rE  r6   r3  Ú59r"   rF  r0  )rE  r6   r3  Ú31r"   rF  r0  )rE  r6   r3  Ú69r"   rF  r0  )rE  r6   r3  Ú12r"   rF  r0  )rE  r6   r3  rJ  r-  rF  r0  )rE  r6   r3  r)   rI   rF  r0  )ú20160525 13:30:00.130r   rj   Ú317rI   ú51.93rj   )rK  r   rj   Ú283rI   rM  rj   )ú20160525 13:30:00.135r   rM  r)   r-  rv   rj   )rO  r6   r3  r)   rI   rF  r3  )ú20160525 13:30:00.144r6   r3  rJ  r"   rF  r3  )rP  r6   r3  Ú88r"   rF  r3  )rP  r6   r3  Ú162r"   rF  r3  )rP  r6   rF  r)   r  rF  r3  )rP  r6   r3  r;  rI   rF  r3  )rP  r6   r3  Ú25rI   rF  r3  )rP  r6   r3  Ú14rI   rF  r3  )ú20160525 13:30:00.145r6   r3  rJ  rI   ú98.6r0  )rU  r6   r3  r)   rI   rV  r0  )rU  r6   r0  r)   r"   rV  r0  r˜   rX   rY   r[   r\   r]   r^   rx   ry   r   r#   r&   r*   r+   r.   r0   r2   r4   r9   r;   r=   r@   rA   rC   rE   rG   rJ   rN   rO   rP   rR   rS   rV   )r*  r6   z98.6400r+  r"   )r*  r6   rH   r,  r-  )r.  r6   rL   r/  rI   )r1  r6   ú98.6300r2  r-  )r1  r6   rW  r/   r-  )r1  r6   rW  r4  r"   )r1  r6   rW  r5  r"   )r1  r6   rW  r6  r"   )r1  r6   rW  r7  r"   )r1  r6   rW  rF   r"   )r1  r6   rW  r)   rI   )r8  r6   rW  r)   rI   )r8  r6   rW  r9  rI   )r:  r6   rW  r;  r-  )r<  r6   rW  r)   rI   )r<  r6   rW  r=  rI   )r>  r6   rW  r)   rI   )r>  r6   rW  r?  rI   )r@  r6   rW  rA  r-  )rB  r6   rW  rC  r-  )rB  r6   rW  rA  r-  )rD  r6   rW  r)   r"   )rD  r   z51.9200r)   rI   )rE  r6   ú98.6200r)   r"   )rE  r6   rX  rF   r"   )rE  r6   rX  rG  r"   )rE  r6   rX  rH  r"   )rE  r6   rX  rI  r"   )rE  r6   rX  rJ  r"   )rE  r6   rX  rJ  r-  )rE  r6   rX  r)   rI   )rK  r   r    rL  rI   )rK  r   r    rN  rI   )rO  r   z51.9300r)   r-  )rO  r6   rX  r)   rI   )rP  r6   rX  rJ  r"   )rP  r6   rX  rQ  r"   )rP  r6   rX  rR  r"   )rP  r6   z98.6100r)   r  )rP  r6   rX  r;  rI   )rP  r6   rX  rS  rI   )rP  r6   rX  rT  rI   )rU  r6   rX  rJ  rI   )rU  r6   rX  r)   rI   )rU  r6   rW  r)   r"   rW   rf   ri   rk   rm   rn   rp   rs   rt   ru   )z20160525 13:30:00.079r   rv   rj   )z20160525 13:30:00.080r6   rq   rr   )r*  r6   rq   rr   )r.  r6   rq   r0  )z20160525 13:30:00.088r6   r‹   r0  )z20160525 13:30:00.089r6   r0  r0  )r1  r6   r0  r0  )r1  r6   r3  r0  )r8  r6   r3  r0  )r<  r6   r3  r0  )r@  r6   r3  r0  )rB  r6   r3  r0  )rD  r6   r3  r0  )rE  r6   r3  r0  )rE  r6   rF  r0  )rK  r   rM  rj   )rK  r6   rF  r0  )z20160525 13:30:00.131r6   rF  r3  )rO  r   rv   rj   )rO  r6   rF  r3  )z20160525 13:30:00.136r6   rF  r3  )rP  r6   rF  r3  )rU  r6   rF  r3  )rU  r6   rF  r0  )rU  r6   z98.60r0  rw   Trz   r   r   rÖ   )
r`   ra   rš   r›   rb   rc   r   r   r¹   rº   )r   rŸ   r¾   re   r{   r¿   r   r   r   Útest_basic2þ  s   							
ù																																																																				€ € € € € Ó     <€ € € € € È     ?
³O°R
È:Å=zTestAsOfMerge.test_basic2c                 C   s>   dd„ }||ƒ}||ƒ}||ƒ}t ||dd�}t ||¡ d S )Nc                 S   s    | | j dk jddd�jdd�S )Nr   r   r¤   )ZaxisTr   )r   r   r   ©Úxr   r   r   Ú<lambda>[	  s   ÿþz0TestAsOfMerge.test_basic_no_by.<locals>.<lambda>r   r¶   rå   )r   re   rœ   r{   Úfr¾   r¿   r   r   r   Útest_basic_no_byY	  s    ÿzTestAsOfMerge.test_basic_no_byc                 C   sÆ   d}t jt|d��" t||dddd� W d   ƒ n1 s:0    Y  t jtdd��$ t||ddgdd� W d   ƒ n1 s|0    Y  t jtdd�� t||dd	� W d   ƒ n1 s¸0    Y  d S )
Nz6incompatible merge keys \[1\] .* must be the same typerõ   r   rx   r   )rï   rë   r×   zcan only asof on a key for leftrÖ   )r×   ©rÛ   rù   r   r   rý   r   r   r   Útest_valid_join_keysh	  s    02z"TestAsOfMerge.test_valid_join_keysc                 C   sJ   t  ||g¡ ddg¡jdd�}t||ddd�}|  |¡}t ||¡ d S )Nr   r   Tr   rÖ   )r`   ÚconcatÚsort_valuesr   r   r   r¹   rº   )r   rŸ   re   r{   rœ   r  r¿   r¾   r   r   r   Útest_with_duplicatest	  s    ÿþÿ
z"TestAsOfMerge.test_with_duplicatesc                 C   sl   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t||dd�}t  g d¢g d¢g d¢dœ¡}t ||¡ d S )	N)r¤   r¤   r¯   ©r¤   r®   r¯   )Úkeyr¬   )r¤   r®   r®   )re  r³   re  r¶   )re  r¬   r³   r¸   ©r   Údf1Údf2r¿   r¾   r   r   r   Útest_with_duplicates_no_on~	  s    ÿz(TestAsOfMerge.test_with_duplicates_no_onc                 C   sH   d}t jt|d��" t||dddd� W d   ƒ n1 s:0    Y  d S )Nz/allow_exact_matches must be boolean, passed foorõ   r   r   Úfoo©r·   r×   r    r_  rý   r   r   r   Útest_valid_allow_exact_matches‡	  s
    
ÿz,TestAsOfMerge.test_valid_allow_exact_matchesc                 C   sT  t ||ddtdƒd� t | ¡ | ¡ dddd� d}tjt|d��" t ||dddd� W d   ƒ n1 sj0    Y  tjt|d��* t | ¡ | ¡ ddd	d� W d   ƒ n1 s²0    Y  d
}tjt|d��( t ||ddtdƒ d� W d   ƒ n1 sü0    Y  tjt|d��* t | ¡ | ¡ dddd� W d   ƒ n1 �sF0    Y  d S )Nr   r   Ú1srØ   rí   r¤   z6incompatible tolerance .*, must be compat with type .*rõ   r   ztolerance must be positiveéÿÿÿÿ)r   r   r   rÛ   rù   r   rý   r   r   r   Útest_valid_tolerance�	  s@    û0û$ÿ$ûz"TestAsOfMerge.test_valid_tolerancec                 C   s  |j ddd�}|j ddd�}|jjr(J ‚|jjr4J ‚tjtdd��  t||ddd� W d   ƒ n1 sh0    Y  |  d¡}|jjsˆJ ‚|jjr”J ‚tjtdd��  t||ddd� W d   ƒ n1 sÈ0    Y  |  d¡}|jjsèJ ‚|jjsôJ ‚t||ddd� d S )	Nr   F)Z	ascendingzleft keys must be sortedrõ   r   rÖ   zright keys must be sorted)rb  r   Zis_monotonic_increasingrÛ   rù   Ú
ValueErrorr   rú   r   r   r   Útest_non_sorted½	  s    .
.
zTestAsOfMerge.test_non_sortedÚtolerance_tsÚ1dayr¤   )Údaysr   zdatetime.timedelta)Zidsc                 C   s&   t ||dd|d�}|}t ||¡ d S )Nr   r   rØ   rå   )r   rr  re   r{   r�   r¿   r¾   r   r   r   Útest_toleranceÔ	  s
    
ÿzTestAsOfMerge.test_tolerancec                 C   st   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢dtjdgdœ¡}t||d	d
dd�}t ||¡ d S )Nr£   r§   r«   ©r¤   r®   r¯   r±   é   r²   r¤   rw  rµ   r¨   rÞ   ©r·   rà   r�   rá   r»   r   r   r   Útest_tolerance_forwardà	  s    ÿz$TestAsOfMerge.test_tolerance_forwardc                 C   st   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢dtjdgdœ¡}t||d	d
dd�}t ||¡ d S )Nr£   r§   r«   rv  r²   r¤   rw  rµ   r¨   rã   rx  rá   r»   r   r   r   Útest_tolerance_nearestí	  s    ÿz$TestAsOfMerge.test_tolerance_nearestc              	   C   s¸   t  t jtdƒddt d¡|d�t d¡dœ¡}t  t jtdƒddt d¡|d�tdƒd	œ¡}t	||d
t
dƒd�}t  t jtdƒddt d¡|d�t d¡tdƒdœ¡}t ||¡ d S )Nz
2016-01-02ÚDr¥   ÚUTC)ÚstartÚfreqÚperiodsÚtzr   )ÚdateÚvalue1z
2016-01-01ZABCDE)r�  Úvalue2r�  z1 day©r·   r�   ZBCDEE)r�  r‚  rƒ  )r`   ra   Ú
date_ranger   ÚpytzÚtimezonerš   ZarangeÚlistr   r   r¹   rº   )r   r   r¼   r½   r¿   r¾   r   r   r   Útest_tolerance_tzú	  sH    ûøÿûøÿû÷ÿzTestAsOfMerge.test_tolerance_tzc                 C   st   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢ddtjgdœ¡}t||d	d
dd�}t ||¡ d S )N)çš™™™™™ñ?g      @gÍÌÌÌÌÌ%@r§   r«   )r   ç      @çffffff
@g      @g      '@r²   r¤   rŒ  rµ   r¨   rã   ç      à?rx  rá   r»   r   r   r   Útest_tolerance_float%
  s    ÿ
ýÿz"TestAsOfMerge.test_tolerance_floatc                 C   sF   |  d¡}|  d¡}|  d¡}t||dddtdƒd�}t ||¡ d S )Nr   Tr   rs  )rê   rð   r×   r�   )rì   r   r   r¹   rº   )r   re   r{   r�   r¾   r¿   r   r   r   Útest_index_tolerance7
  s    


úz"TestAsOfMerge.test_index_tolerancec                 C   s&   t ||dddd�}|}t ||¡ d S )Nr   r   Frk  rå   )r   re   r{   r    r¿   r¾   r   r   r   Útest_allow_exact_matchesG
  s
    
ÿz&TestAsOfMerge.test_allow_exact_matchesc                 C   sp   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢g d¢dœ¡}t||dd	d
d�}t ||¡ d S )Nr£   r§   r«   rv  r²   )r®   r±   rw  rµ   r¨   rÞ   F©r·   rà   r    r¸   r»   r   r   r   Ú test_allow_exact_matches_forwardN
  s    ÿ
ÿz.TestAsOfMerge.test_allow_exact_matches_forwardc                 C   sp   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢g d¢dœ¡}t||dd	d
d�}t ||¡ d S )Nr£   r§   r«   rv  r²   )r®   r¯   rw  rµ   r¨   rã   Fr‘  r¸   r»   r   r   r   Ú test_allow_exact_matches_nearest]
  s    ÿ
ÿz.TestAsOfMerge.test_allow_exact_matches_nearestc                 C   s,   t ||ddtdƒdd�}|}t ||¡ d S )Nr   r   Z100msFrÚ   )r   r   r¹   rº   )r   re   r{   r¡   r¿   r¾   r   r   r   Ú&test_allow_exact_matches_and_tolerancel
  s    úz4TestAsOfMerge.test_allow_exact_matches_and_tolerancec                 C   sæ   t  tdgƒdgdœ¡}t  tddgƒddgdœ¡}t||dd	�}t  tdgƒdgdgd
œ¡}t ||¡ t||ddd�}t  tdgƒdgdgd
œ¡}t ||¡ t||ddtdƒd�}t  tdgƒdgtjgd
œ¡}t ||¡ d S )Nú2016-07-15 13:30:00.030Úbob©r   Úusernameú2016-07-15 13:30:00.000r¤   r®   ©r   Úversionr   r¶   ©r   r˜  r›  F)r·   r    rÙ   ©r·   r    r�   )	r`   ra   r   r   r¹   rº   r   rš   r›   rf  r   r   r   Ú'test_allow_exact_matches_and_tolerance2z
  sP    ÿÿüÿ	ýÿýÿûýÿz5TestAsOfMerge.test_allow_exact_matches_and_tolerance2c                 C   s„   t  tddgƒddgdœ¡}t  tddgƒddgdœ¡}t||d	d
tdƒd�}t  tddgƒddgtjtjgdœ¡}t ||¡ d S )Nr•  r–  Zcharlier—  r™  r¤   r®   rš  r   FrÙ   r�  rœ  )	r`   ra   r   r   r   rš   r›   r¹   rº   rf  r   r   r   Ú'test_allow_exact_matches_and_tolerance3¬
  s<    ÿüÿÿüÿ	ûÿ
ûÿ	z5TestAsOfMerge.test_allow_exact_matches_and_tolerance3c                 C   sv   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢tjddgdœ¡}t||d	d
ddd�}t ||¡ d S )Nr£   r§   r«   ©r¤   r¯   é   r°   rw  r²   r°   rw  rµ   r¨   rÞ   Fr¤   ©r·   rà   r    r�   rá   r»   r   r   r   Ú.test_allow_exact_matches_and_tolerance_forwardÑ
  s    ÿúz<TestAsOfMerge.test_allow_exact_matches_and_tolerance_forwardc                 C   sv   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}t  g d¢g d¢tjddgd	œ¡}t||d
dddd�}t ||¡ d S )Nr£   r§   r«   r   )r¤   r¯   r¡  r±   rw  r²   r¡  rw  rµ   r¨   rã   Fr¤   r¢  rá   r»   r   r   r   Ú.test_allow_exact_matches_and_tolerance_nearestå
  s    ÿúz<TestAsOfMerge.test_allow_exact_matches_and_tolerance_nearestc              
   C   sŠ   t  g d¢g d¢g d¢dœ¡}t  g d¢g d¢g d¢dœ¡}t  g d¢g d¢g d¢dtjd	d
dgdœ¡}t||dddd�}t ||¡ d S )N©r¤   r¥   r¦   é   é   )ÚXr¨  ÚYÚZr©  ©r¨   r©   rª   ÚdÚe©r¨   r©   r¬   ©r¤   r°   rw  r§  é   )r¨  rª  r©  rª  r©  ©r¨   r©   r³   r¤   rw  r§  r°  ©r¨   r©   r¬   r³   r¨   r©   rÞ   ©r·   r×   rà   rá   r»   r   r   r   Útest_forward_byù
  s*    ýÿýÿüÿ	zTestAsOfMerge.test_forward_byc                 C   s‚   t  g d¢g d¢g d¢dœ¡}t  g d¢g d¢g d¢dœ¡}t  g d¢g d¢g d¢g d¢d	œ¡}t||d
ddd�}t ||¡ d S )Nr¥  )r¨  r¨  rª  rª  r©  r«  r®  r¯  )r¨  rª  rª  rª  r©  r±  )r¤   r¤   rw  rw  r°  r²  r¨   r©   rã   r³  r¸   r»   r   r   r   Útest_nearest_by  s*    ýÿýÿüÿ	zTestAsOfMerge.test_nearest_byc                 C   s¤   t jtg d¢ƒg d¢g d¢dœg d¢d�}t jtg d¢ƒg d¢g d¢d	œg d	¢d�}t||d
dd�}t jtg d¢ƒg d¢g d¢g d¢dœg d¢d�}t ||¡ d S )N)ú20160525 13:30:00.020rË   ú20160525 13:30:00.040r  ú20160525 13:30:00.060)r¤   r®   r¤   r¯   r®   )rŠ  g333333ó?gÍÌÌÌÌÌô?gffffffö?g      ø?)r   re  r‚  rY   )z20160525 13:30:00.015r¶  z20160525 13:30:00.025z20160525 13:30:00.035r·  z20160525 13:30:00.055r¸  z20160525 13:30:00.065)r®   r¤   r¤   r¯   r®   r¤   r®   r¯   )çÍÌÌÌÌÌ @çš™™™™™@çffffff@ç333333@r‹  gÍÌÌÌÌÌ@çš™™™™™@gffffff@)r   re  rƒ  r   re  rÖ   )rº  r¹  r»  r¼  r½  )r   re  r‚  rƒ  )r`   ra   r   r   r¹   rº   rf  r   r   r   Útest_by_int5  s<    ÿ	õòÿòïÿ	ôñzTestAsOfMerge.test_by_intc                 C   s–   t jg d¢tdƒdœddgd�}t jg d¢g d¢d	œdd
gd�}| d¡jdd�}t||dd�}t jtdƒg d¢g d¢dœg d¢d�}t ||¡ d S )N)ç
×£p=
@çHPüs×b?çáz®G!9@çÍÌÌÌÌ@u@çHáz®Ç>@çš™™™™C�@çÞqŠŽäò?ÚABCDEFG)r[   ÚsymbolrÇ  r[   rY   )ç        r   ç      Y@)ç-Cëâ6?ç{®Gáz„?çš™™™™™©?)r[   ÚmpvrÍ  Tr   r¶   ZBGACEDF)rÀ  rÅ  r¿  rÁ  rÃ  rÂ  rÄ  )rÊ  rÊ  rË  rË  rË  rÌ  rÌ  )rÇ  r[   rÍ  ©r`   ra   rˆ  rb  r   r   r¹   rº   rf  r   r   r   Útest_on_floatr  s(    þûþýú	zTestAsOfMerge.test_on_floatc                 C   sÆ   t  |¡j}tjg d¢tdƒdœddgd�}||jƒ|_tjg d¢tdƒd	œdd
gd�}||jƒ|_| d¡jdd�}t	||dd�}tjtdƒg d¢tdƒdœg d¢d�}||jƒ|_t
 ||¡ d S )N©r¥   r®   é   rÊ   éN   éx   éO   rÆ  )r&  rÇ  rÇ  r&  rY   ©r   éP   rÓ  é}   Úxyzw)r&  r¿   r¿   Tr   r¶   ÚBACEGDF©r®   r¥   rÑ  rÒ  rÔ  rÊ   rÓ  Zxxxxxyz)rÇ  r&  r¿   )rš   r  Útyper`   ra   rˆ  r&  rb  r   r   r¹   rº   ©r   Zany_real_numpy_dtyper  rg  rh  r¿   r¾   r   r   r   Útest_on_specialized_type�  s,    þþýúz&TestAsOfMerge.test_on_specialized_typec                 C   sì   t  |¡j}tjg d¢g d¢tdƒdœg d¢d�}||jƒ|_tjg d¢g d¢td	ƒd
œg d
¢d�}||jƒ|_| d¡jdd�}t	||ddd�}tjtdƒg d¢g d¢t j
dt j
t j
t j
ddgdœg d¢d�}||jƒ|_t ||¡ d S )NrÐ  )r¤   r®   r¯   r®   r¯   r¤   r®   rÆ  )r&  re  rÇ  )rÇ  re  r&  rY   rÕ  )r¤   r®   r®   r¯   rØ  )r&  re  r¿   r&  Tr   re  rÖ   rÙ  )r®   r¤   r¯   r¯   r®   r®   r¤   rÚ  r[  Úy)rÇ  re  r&  r¿   )rš   r  rÛ  r`   ra   rˆ  r&  rb  r   r   r›   r¹   rº   rÜ  r   r   r   Útest_on_specialized_type_by_int¯  s4    ýúþüù	z-TestAsOfMerge.test_on_specialized_type_by_intc                 C   s¼   t jtdƒg d¢g d¢dœg d¢d�}t jg d¢g d¢g d¢d	œg d	¢d�}| d
¡jdd�}| d
¡jdd�}t||d
dd�}t jtdƒg d¢g d¢g d¢dœg d¢d�}t ||¡ d S )NZ	AAABBBCCC)	r¤   r®   r¯   r¤   r®   r¯   r¤   r®   r¯   )	ç®Gáz
@çÜ×�sF
@ç£¼
@ç)\�Âõ()@ç®Gáz.)@ç      )@çfffff¢w@ç33333£w@ç     ¤w@)rÇ  r  r[   rY   )	r¤   r¤   r¤   r®   r®   r®   r¯   r¯   r¯   )	rÈ  r   rÉ  rÈ  ç      @rÉ  rÈ  ré  g     @�@)	rÊ  rË  rÌ  rÊ  rË  çš™™™™™¹?rÊ  ç      Ð?r   )r  r[   rÍ  r[   Tr   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ë  )rÇ  r  r[   rÍ  rÎ  rf  r   r   r   Útest_on_float_by_intÓ  s4    ýðýú	òïz"TestAsOfMerge.test_on_float_by_intc                 C   st   d}t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}tjt|d�� t||dd	� W d   ƒ n1 sf0    Y  d S )
Nú@Incompatible merge dtype, .*, both sides must have numeric dtyper£   r§   ©r¬   r¨   r­   ©r³   r¨   rõ   r¨   r¶   ©r`   ra   rÛ   rù   r   r   ©r   rþ   r¼   r½   r   r   r   Ú test_merge_datatype_error_raises  s
    z.TestAsOfMerge.test_merge_datatype_error_raisesc                 C   s€   d}t  g d¢t  g d¢¡dœ¡}t  g d¢t  g d¢¡dœ¡}tjt|d�� t||d	d
� W d   ƒ n1 sr0    Y  d S )NzHincompatible merge keys \[0\] .* both sides category, but not equal onesr£   r§   rî  r­   )r¨   r¨  rª   r¨  r©   rï  rõ   r¨   r¶   )r`   ra   ÚCategoricalrÛ   rù   r   r   rñ  r   r   r   Ú,test_merge_datatype_categorical_error_raises  s    ÿÿþÿz:TestAsOfMerge.test_merge_datatype_categorical_error_raisesc                 C   s`   t  dgdgt  dg¡dœ¡}t||dddgd�}t  dgdgt  dg¡dœ¡}t ||¡ d S )Nr   ©r[  rÞ  Úzr[  rÞ  rö  rÖ   )r`   ra   ró  r   r¹   rº   )r   r   r¿   r¾   r   r   r   Ú:test_merge_groupby_multiple_column_with_categorical_column(  s    zHTestAsOfMerge.test_merge_groupby_multiple_column_with_categorical_columnÚfuncc                 C   s   | S ©Nr   rZ  r   r   r   r\  0  ó    zTestAsOfMerge.<lambda>c                 C   s   t | ƒS rù  )r   rZ  r   r   r   r\  0  rú  ÚnumericÚdatetimeÚsider¼   r½   c                 C   s¨   d|› d�}|ddt jgƒ}|g d¢ƒ}t |g d¢dœ¡}t |g d¢d	œ¡}tjt|d
��6 |dkrxt||dd� nt||dd� W d   ƒ n1 sš0    Y  d S )Nz"Merge keys contain null values on z sider   ré  )r   ré  g      $@r§   r«   )r¤   r°   rw  r²   rõ   r¼   r¨   r¶   )rš   r›   r`   ra   rÛ   rù   rp  r   )r   rø  rý  rþ   ZnullsZ	non_nullsZdf_nullr   r   r   r   Útest_merge_on_nans/  s    z TestAsOfMerge.test_merge_on_nansc           	      C   s  t jt jddg|d�}|jjdv r4t |jj¡j}nt 	|jj¡j}||d< t  
|g d¢g d¢g d¢d	œ¡}t  
|g d
¢g d¢g d¢d	œ¡}t||ddgdd�}t  
|g d¢g d¢g d¢dœ¡}tjtjtjtjgtd�|d< |rô|d  d¡|d< t ||¡ d S )Nr   r¤   ©r  )ÚiÚur®   )ÚHELLOÚToZYou)r®   r¡  r°   )r¨   rª   r­  ©Úby_col1Úby_col2Úon_colr&  )ÚWORLDZWideZWeb)r¤   r®   r°   )r©   r¬  r]  r  r  r  ©r×   r·   ©r  r  r  Úvalue_xÚvalue_yÚstr)r`   ÚarrayZNAr  Úkindrš   ZiinfoZnumpy_dtypeÚmaxZfinfora   r   r›   r  rc   r¹   rº   )	r   Zany_numeric_ea_dtypeÚusing_infer_stringZarrZmax_valr¼   r½   r¿   r¾   r   r   r   Útest_by_nullableA  s>    üÿüÿ	üÿzTestAsOfMerge.test_by_nullablec                 C   sŽ   t  t  dg¡ d¡dgdgdœ¡}t  t  dg¡ d¡dgdgdœ¡}t||dd	d
�}t jt jddd�dddggg d¢d�}t ||¡ d S )Nú
2018-01-01r|  r®   r¨   )Úby_colr  Úvaluesr¤   r©   r  r  r	  ©r€  )r  r  Zvalues_xZvalues_yrY   )r`   ra   ÚDatetimeIndexÚtz_localizer   r'  r¹   rº   )r   r¼   r½   r¿   r¾   r   r   r   Útest_merge_by_col_tz_awareo  s$    ýÿýÿþz(TestAsOfMerge.test_merge_by_col_tz_awarec                 C   sÆ   t  t  dg¡ d¡dgdgdgdœ¡}t  t  dg¡ d¡dgdgd	gdœ¡}t||d
dgdd�}t jt jddd�dddggg d¢d�}tjtjgt	d�|d< |r¶|d  
d¡|d< t ||¡ d S )Nr  r|  r  r®   r¨   r  r  r¤   r©   r  r  r  r	  r  r
  rY   rÿ  r  r  )r`   ra   r  r  r   r'  rš   r  r›   r  rc   r¹   rº   )r   r  r¼   r½   r¿   r¾   r   r   r   Útest_by_mixed_tz_aware†  s.    üÿüÿþz$TestAsOfMerge.test_by_mixed_tz_aware)r\   Zint16zm8[ns]zM8[us]c                 C   sŠ   t  tjdg|d�dgdgdœ¡}t  tjdg|d�dgdgdœ¡}t||ddd	�}t  tjdg|d�dgdgdgd
œ¡}t ||¡ d S )Nr¤   rÿ  r®   r¨   )r  r  r&  r©   r  r  r	  )r  r  r  r  )r`   ra   rš   r  r   r¹   rº   )r   r  r¼   r½   r¿   r¾   r   r   r   Útest_by_dtype¢  s*    ýÿýÿüÿzTestAsOfMerge.test_by_dtypec                 C   s  |dkrt  d¡ tjttg d¢g d¢ƒƒddgd�}t |d d¡ d	|› d
�¡|d< tjttg d¢g d¢ƒƒddgd�}t |d d¡ d	|› d
�¡|d< tjttg d¢g d¢dtj	ddtj	tj	gƒƒg d¢d�}t |d d¡ d	|› d
�¡|d< t
||dtdƒdd�}t ||¡ d S )Nr   zHThis test is invalid with unit='s' because that would round left['time'])r   r¥   r¦   r§  é   rÑ  )r   r¤   r®   r¯   r¡  r¥   r   r¼   rY   r	   zm8[rÂ   )r   r¯   é	   r¦  r§  é   r½   r   r®   r¡  )r   r¼   r½   Z1msrã   )r·   r�   rà   )rÛ   rÜ   r`   ra   rˆ  ÚzipZto_timedeltarc   rš   r›   r   r   r¹   rº   )r   r   r¼   r½   r¾   r¿   r   r   r   Ú test_timedelta_tolerance_nearest¾  s:    ÿþ"þ"ýÿø"ÿz.TestAsOfMerge.test_timedelta_tolerance_nearestc                 C   s¨   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}|d  |¡|d< |d  |¡|d< t  g d¢g d¢tjddgd	œ¡}|d  |¡|d< t||dd
d�}t ||¡ d S )N)r   r¦   r  rd  r«   )r¥   r§  rÑ  r²   r¨   r   r!  rµ   r¦   r„  )r`   ra   rc   rš   r›   r   r¹   rº   )r   Zany_int_dtyper¼   r½   r¾   r¿   r   r   r   Útest_int_type_toleranceç  s    ÿz%TestAsOfMerge.test_int_type_tolerancec                 C   sþ   t jddddd�}t jg d¢dg|dd … d	�}t  |d
gd dg dœ¡}t||ddgd�}t jg d¢|dd … d
gd dg dœt jddddd�d�}t ||¡ t||ddgd�}t j|d
gd dg tjddddgdœtg d¢ƒd�}t ||¡ d S )Nz
2019-10-01Z30minr¥   r|  )r~  r  r€  )çÍÌÌÌÌÌì?çš™™™™™é?çffffffæ?ç333333ã?Úxyzr¤   )rZ   rí   g®Gáz®@r¡  g…ëQ¸…@)Ú	from_dateÚabcTr'  )r¼   r½   rê   rë   r¯   )r&  r'  r(  z2019-10-01 00:30:00©rí   )r¼   r½   rð   rï   r"  r#  r$  r%  )r'  r(  r&  )r   r¤   r®   r¯   r¡  )	r`   r…  ra   r   r¹   rº   rš   r›   r   )r   rí   r¼   r½   r¿   r¾   r   r   r   Útest_merge_index_column_tz÷  s6    
ÿ
ýÿú

ÿý
úz(TestAsOfMerge.test_merge_index_column_tzc                 C   s¶   |dkrt  d¡ tjddd|d�tdd� |¡ }tjdd	|d
�}tjddit |¡d�}tjddit |¡d�}tjdddœt |¡d�}t||ddtdd�d�}t	 
||¡ d S )Nr   z?This test is invalid with unit='s' because that would round dr1z1/1/2020z	1/20/2020Z2D)r}  Úendr~  r   gš™™™™™Ù?)Úsecondsz2/1/2020)r}  r+  r   Úval1rj  r)  Úval2Úbar)r-  r.  Tr�  )rê   rð   r�   )rÛ   rÜ   r`   r…  r   Zas_unitra   r  r   r¹   rº   )r   r   Zdr1Zdr2rg  rh  r¾   r¿   r   r   r   Ú%test_left_index_right_index_tolerance  s.    ÿÿþÿûz3TestAsOfMerge.test_left_index_right_index_toleranceN)F)MÚ__name__Ú
__module__Ú__qualname__r   rÛ   Úfixturere   r{   rœ   r�   r    r¡   rÀ   rÝ   râ   rä   rç   ré   rî   rò   rô   rû   rü   rÿ   r   r  r  r  ÚmarkÚparametrizer  r(  r)  rY  r^  r`  rc  ri  rl  ro  rq  r   rü  Ú	timedeltaru  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*  r0  r   r   r   r   r      sÀ   

%

  
  
 p
 pY		

		A
D2      a
	.ý
+2%=$9	ÿ.
)!r   Úinfer_stringFTZpyarrow)ZmarksÚkwargsr·   r[  r÷   Údataz2019-06-01 00:09:12z2019-06-01 00:10:29r   c              	   C   s’   t d|ƒ�t tjd|i|d�}tjd|i|d�}tjtdd��" t||fi | ¤Ž W d   ƒ n1 sf0    Y  W d   ƒ n1 s„0    Y  d S )Nzfuture.infer_stringr[  r)  rí  rõ   )r   r`   ra   rÛ   rù   r   r   )r9  r:  r8  r¼   r½   r   r   r   Ú#test_merge_asof_non_numerical_dtype4  s    þr;  c               	   C   sv   t  g d¢g d¢dœ¡} t  g d¢g d¢dœ¡}tjtdd��$ t| |dd	d	d
d� W d   ƒ n1 sh0    Y  d S )N)rJ  Z13Z15r§   )r¨   Ú	left_val1)r¬  r­  r]  r«   rí  rõ   r<  r¨   r¬   )rï   rë   r  r  rð  ©r¼   r½   r   r   r   Ú*test_merge_asof_non_numerical_dtype_objectJ  s    þúr>  )rð   rê   Ú	left_time)rï   rð   r½   )rê   rë   c                 C   sŠ   t g d¢dd�}tjg d¢g d¢dœ|d�}tjdg d	¢ig d	¢d�}t||fi | ¤Ž}tjg d¢g d¢g d
¢dœ|d�}t ||¡ d S )Nr£   Útest©Únamer§   )r¤   r¡  r¦   )r¼   r?  r)  r½   r­   r´   )r¼   r?  r½   )r   r`   ra   r   r¹   rº   )r9  rí   r¼   r½   r¿   r¾   r   r   r   Útest_merge_asof_index_behavior\  s    
þrC  c                  C   s‚   t jdg d¢itg d¢dd�d�} t jdg d¢itg d	¢dd�d�}t| |ddd
�}t  g d¢g d¢g d¢dœ¡}t ||¡ d S )Nr©   ©r¦   rw  r¦  rd  r¨   rA  r)  rª   ©r  é   é   )r   r®   r¯   ©rï   rë   r§   )r`   ra   r   r   r¹   rº   ©r¼   r½   r¿   r¾   r   r   r   Ú'test_merge_asof_numeric_column_in_indexr  s
    ""rJ  c                  C   s¢   t jdg d¢it jjg d¢g d¢gddgd�d�} t jd	g d
¢it jjg d¢g d¢gddgd�d�}t| |ddd�}t  g d¢g d¢g d
¢dœ¡}t ||¡ d S )Nr©   rD  rd  r§   r¨   rö  )Únamesr)  rª   rE  rõ  rÞ  rH  )r`   ra   Z
MultiIndexZfrom_arraysr   r¹   rº   rI  r   r   r   Ú,test_merge_asof_numeric_column_in_multiindex|  s    
þ
þrL  c                  C   sè   t jdg d¢itg d¢dd�d�} t jdg d¢itg d	¢dd�d�}tjtd
d��  t| |ddd� W d   ƒ n1 sx0    Y  |  ¡  ddg¡} | ¡  ddg¡}tjtd
d��  t| |ddd� W d   ƒ n1 sÚ0    Y  d S )Nr©   rD  )r6  Ú2Ú3r¨   rA  r)  rª   rE  )ÚmÚnÚorí  rõ   rH  )	r`   ra   r   rÛ   rù   r   r   r   rì   r=  r   r   r   Ú3test_merge_asof_numeri_column_in_index_object_dtypeŒ  s    ""þ.þrR  c                 C   sÔ   t jddgd| › d�d�}t  ddg|dœ¡}t jt  d	¡d
d| d�}t  dg d¢i¡}t|||dddd�}t  g d¢tjddg|dœ¡}t 	||¡ t||d|ddd�}t  ddg|ddgdœ¡}t 	||¡ d S )Nz2021/01/01 00:37z2021/01/01 01:40rÁ   rÂ   rÿ  r®   r°   )r¨   Útsz2021/01/01 00:00r¯   Z1h)r}  r  r~  r   r©   )r¡  é   r±   rS  FZbackward)rï   rë   r    rà   )r©   r¨   rS  r¡  rT  )r¨   rS  r©   )
r`   r  ra   r…  r'  r   rš   r›   r¹   rº   )r   Zdtir½   Zts_merger¼   r¿   r¾   r   r   r   Útest_merge_asof_array_as_on¡  sJ    ÿþÿÿúúýÿrU  c                  C   sì   t jg d¢gg d¢d�} t jg d¢gg d¢d�}tjtdd�� t| |dd	� W d   ƒ n1 sb0    Y  tjtdd��  t| |dd
d� W d   ƒ n1 s 0    Y  tjtdd��  t| |ddd� W d   ƒ n1 sÞ0    Y  d S )N)r¤   r®   r¨   )r¨   r¨   r¬   rY   )r¤   r¤   r¤   )r¨   r¨   r³   zcolumn label 'a'rõ   r¨   r¶   r³   rH  r¬   )r`   ra   rÛ   rù   rp  r   r=  r   r   r   Ú+test_merge_asof_raise_for_duplicate_columnsÍ  s    ,.rV  r  ZInt64zint64[pyarrow]ztimestamp[s][pyarrow]c                 C   sš   t  g d¢g d¢dœ¡}t  g d¢g d¢dœ¡}| d| i¡}| d| i¡}t||dd�}t  g d¢g d¢tjdd	gd
œ¡}| d| i¡}t ||¡ d S )N)r¤   r¯   r¥   rd  )Újoin_colr¬   )r®   r¯   r¡  )rW  r³   rW  r¶   r!  r#  )rW  r¬   r³   )r`   ra   rc   r   rš   r›   r¹   rº   )r  r¼   r½   r¿   r¾   r   r   r   Útest_merge_asof_extension_dtypeÜ  s*    
þÿþÿ
ýÿrX  c                  C   sf   t jt ddd¡gdd�} t  | dgdœ¡}t||dtdƒd�}t  | dgdgd	œ¡}t ||¡ d S )
Niç  r¤   ztimestamp[us, UTC][pyarrow]rÿ  )Ú	timestampr&  rY  rm  r„  )rY  r  r  )r`   ÚSeriesrü  ra   r   r   r¹   rº   )Zserr   r¿   r¾   r   r   r   Ú$test_merge_asof_pyarrow_td_tolerance   s     ÿþÿýÿr[  c                  C   sz   t jdgdgdd�} t jdgdgdd�}d| jjj_d|jjj_t| |ddd�}t jdgdgd	œdgd
�}t 	||¡ d S )Nr®   r¼   )rí   rB  r¤   r½   FTr÷   r=  r)  )
r`   rZ  rí   r  ÚflagsZ	writeabler   ra   r¹   rº   rI  r   r   r   Ú!test_merge_asof_read_only_ndarray  s    r]  c               
   C   sÚ   t  t jg d¢ddgd�dgd dgd tdƒdœ¡} t  t jddgddgd�dgd	 dd	gtd	ƒdœ¡}t| |d
dgddddgd�}t  t jg d¢ddgd�dgd dgd tdƒtjtjddgdœ¡}t ||¡ d S )N)r¨   r¨   r©   r©   r¨   r©   )Ú
categoriesr[  r¡  r¤   )Úc1Úc2ÚtÚvr®   r_  r`  ra  rÞ   Ú_leftÚ_right)r×   r·   rà   ÚsuffixesrÈ  )r_  r`  ra  Zv_leftZv_right)	r`   ra   ró  Úranger   rš   r›   r¹   rº   rI  r   r   r   Ú(test_merge_asof_multiby_with_categorical#  s>    üÿüÿúûÿ	rg  )(rü  Únumpyrš   rÛ   r†  Zpandas.util._test_decoratorsÚutilZ_test_decoratorsÚtdZpandasr`   r   r   r   r   r   Zpandas._testingZ_testingr¹   Zpandas.core.reshape.merger   r4  r   r   r5  r6  r   Z
skip_if_nor;  r>  rC  rJ  rL  rR  rU  rV  rX  r[  r]  rg  r   r   r   r   Ú<module>   s”   
                          1ÿÿþýþ

,ýþ

