a
    ï½„g:Ò ã                	   @   s@  d Z ddlmZ ddlmZmZmZmZ ddlZddlm	Z	 ddl
ZddlZddlmZ ddlmZ ddlmZ dd	lmZ ddlm  mZ ddlZdd
lmZmZmZmZm Z m!Z!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+m,Z,m-Z- ddl.m/Z0 ddl1m2Z2 ddl3m4Z4 ddl5m6Z6 ej7 8dej9ej9dgdej9ej9gg d¢gej9dgdej9gddggg¡dd„ ƒZ:G dd„ dƒZ;G dd„ dƒZ<G dd„ dƒZ=G dd„ dƒZ>G dd„ dƒZ?G d d!„ d!ƒZ@G d"d#„ d#ƒZAG d$d%„ d%ƒZBG d&d'„ d'ƒZCG d(d)„ d)ƒZDG d*d+„ d+ƒZEej7 8d,g d-¢d.d/gdd0gfg d1¢d.d/gdd0gfg d1¢d.d2gdd3gfg¡d4d5„ ƒZFd6d7„ ZGd8d9„ ZHd:d;„ ZId<d=„ ZJd>d?„ ZKd@dA„ ZLdBdC„ ZMdDdE„ ZNdFdG„ ZOdHdI„ ZPdJdK„ ZQej7 8dLdMe RdM¡e SdM¡g¡dNdO„ ƒZTej7 8dPe)dQƒdRfe)dSdTdU�dVfg¡dWdX„ ƒZUdYdZ„ ZVej7 Wd[¡ej7 Wd\¡d]d^„ ƒƒZXd_d`„ ZYG dadb„ dbƒZZdS )cz$ test label based indexing with loc é    )Ú
namedtuple)ÚdateÚdatetimeÚtimeÚ	timedeltaN)Úgettz)Úusing_pyarrow_string_dtype©Úindex)Únp_version_gt2)ÚIndexingError)ÚCategoricalÚCategoricalDtypeÚCategoricalIndexÚ	DataFrameÚDatetimeIndexÚIndexÚ
IndexSliceÚ
MultiIndexÚPeriodÚPeriodIndexÚSeriesÚSparseDtypeÚ	TimedeltaÚ	TimestampÚ
date_rangeÚtimedelta_rangeÚto_datetimeÚto_timedelta)Ú	is_scalar)Ú_one_ellipsis_message)Ú"check_indexing_smoketest_or_raisesz series, new_series, expected_serÚbÚa)FTTFTc                 C   sP   t d| iƒ}||jd d …df< t d|iƒ}t | ¡ |¡ t | ¡ | ¡ d S ©NÚA)r   ÚlocÚtmÚassert_frame_equalÚisnaZnotna)ÚseriesZ
new_seriesZexpected_serÚdfÚexpected© r-   úa/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/pandas/tests/indexing/test_loc.pyÚtest_not_change_nan_loc1   s
    	r/   c                   @   sÀ  e Zd Zdd„ Zej dddg¡dd„ ƒZej dddg¡dd	„ ƒZej d
dg d¢dgddgdgdg d¢dgddgdgddgdgddgdgg¡ej dddg¡dd„ ƒƒZ	ej dg d¢g d¢gg d¢g d¢gg¡ej dddg¡dd„ ƒƒZ
ej d
g d¢dgdgg d¢g d¢dgg d¢g d¢dgg d ¢d!gdgg¡ej dddg¡d"d#„ ƒƒZej d$d%d&g¡ej dddg¡d'd(„ ƒƒZd)d*„ Zej dddg¡d+d,„ ƒZej d-edd.ƒg d/¢deged0d1ƒdgdeged2d3ƒd4gdeged2d3ƒd4gdeged2d5d2ƒd4gdegg¡ej dddg¡d6d7„ ƒƒZd8d9„ Zd:d;„ Zej d<edgged=gƒd>�edd…d=f edgd=d?�fedged=gƒd@�d=dgfedgged=gƒd@�d=edgd=d?�fg¡dAdB„ ƒZdS )CÚTestLocc                 C   s*   t g d¢dgdd�}|jd d u s&J ‚d S )N)Ú1Ú2Nr#   Ústr©ÚcolumnsÚdtype)é   r#   )r   r&   ©Úselfr+   r-   r-   r.   Ú"test_none_values_on_string_columnsB   s    z*TestLoc.test_none_values_on_string_columnsÚkindr*   Úframec                 C   s$   |  |› d�¡}t|ddtd� d S )NZ_labelsr&   r7   ©Úfails©Úgetfixturevaluer!   ÚKeyError©r9   r;   ÚrequestÚobjr-   r-   r.   Útest_loc_getitem_intH   s    zTestLoc.test_loc_getitem_intc                 C   s$   |  |› d�¡}t|ddtd� d S )NÚ_emptyr&   Úcr=   r?   rB   r-   r-   r.   Útest_loc_getitem_labelN   s    zTestLoc.test_loc_getitem_labelzkey, typs, axesÚf)ÚintsÚuintsÚlabelsÚmixedÚtsNÚfloatsé   )rJ   rK   rM   rL   rN   r   c                 C   s4   |D ]*}|  |› d|› �¡}t|d||td� qd S ©NÚ_r&   ©Úaxesr>   r?   ©r9   ÚkeyÚtypsrT   r;   rC   ÚtyprD   r-   r-   r.   Ú#test_loc_getitem_label_out_of_rangeT   s
    
ÿz+TestLoc.test_loc_getitem_label_out_of_rangez	key, typs©r   é   r7   )rJ   rK   rO   )r[   ç      @r%   c                 C   s2   |D ](}|  |› d|› �¡}t|d|td� qd S )NrR   r&   r=   r?   )r9   rV   rW   r;   rC   rX   rD   r-   r-   r.   Útest_loc_getitem_label_listh   s    	z#TestLoc.test_loc_getitem_label_listÚempty)r   r7   é
   )é   é   é   r[   ))r[   r`   )r[   é   )r7   é   Úmultic                 C   s4   |D ]*}|  |› d|› �¡}t|d||td� qd S rQ   r?   rU   r-   r-   r.   Ú(test_loc_getitem_label_list_with_missingv   s
    
ÿz0TestLoc.test_loc_getitem_label_list_with_missingrW   rJ   rK   c                 C   s.   |  |› d|› �¡}t|dg d¢dtd� d S )NrR   r&   )rP   é   é(   r[   rS   r?   )r9   rW   r;   rC   rD   r-   r-   r.   Ú!test_loc_getitem_label_list_failsˆ   s    ÿz)TestLoc.test_loc_getitem_label_list_failsc                 C   s   d S ©Nr-   ©r9   r-   r-   r.   Ú!test_loc_getitem_label_array_like‘   s    z)TestLoc.test_loc_getitem_label_array_likec                 C   s,   |  |› d�¡}g d¢}t|d|td� d S )NrF   ©TFTFr&   r=   )r@   r!   Ú
IndexError)r9   r;   rC   rD   r"   r-   r-   r.   Útest_loc_getitem_bool–   s    zTestLoc.test_loc_getitem_boolzslc, typs, axes, failsr`   )rL   rM   r^   rN   rO   Z20130102Z20130104r7   é   rM   rc   c           	      C   s4   |D ]*}|  |› d|› �¡}t|d|||d� qd S rQ   )r@   r!   )	r9   ZslcrW   rT   r>   r;   rC   rX   rD   r-   r-   r.   Útest_loc_getitem_label_slicež   s    ûz$TestLoc.test_loc_getitem_label_slicec                 C   sp   t ddgddgddggddgg d¢d�}t d¡|jd	< t ddgd
dgddggddgg d¢d�}t ||¡ d S )NrP   r#   éÈ   Úcol1Úcol2)r_   r[   r[   ©r5   r
   r7   )r[   rs   r   r[   )r   ÚnpÚaranger&   r'   r(   ©r9   r+   r,   r-   r-   r.   Ú test_setitem_from_duplicate_axis¾   s    ý ÿz(TestLoc.test_setitem_from_duplicate_axisc                 C   sž   t g d¢dtjdgtdƒtjtdƒgdœd�}t dgtdƒgd	œd�}|j|j|d
  ¡ d
dgf< t g d¢g d¢tdƒtdƒtdƒgdœd�}t	 
||¡ d S )N©r[   r7   r`   úString 1úString 2z2019-06-11 11:00:00z2019-06-11 12:00:00)Zchannelr%   ÚB)ÚdataúString 3©r%   r}   r%   r}   )r{   r   r|   )r   rv   Únanr   ÚpdÚNaTÚvaluesr&   r)   r'   r(   )r9   r+   Údf2r,   r-   r-   r.   Útest_column_types_consistentË   s.    
ýýÿÿýýÿz$TestLoc.test_column_types_consistentzobj, key, expF©r5   ©Únamer	   c                 C   s6   |j | }t|ttfƒr&t ||¡ n||ks2J ‚d S rj   )r&   Ú
isinstancer   r   r'   Úassert_equal)r9   rD   rV   ÚexpÚresr-   r-   r.   Ú#test_loc_getitem_single_boolean_argê   s    
z+TestLoc.test_loc_getitem_single_boolean_arg)Ú__name__Ú
__module__Ú__qualname__r:   ÚpytestÚmarkÚparametrizerE   rH   rY   r]   rf   ri   rl   ro   ÚsliceÚ	TypeErrorrA   rq   ry   r†   r   r   r   r   rŽ   r-   r-   r-   r.   r0   A   sŠ   





úþþþûþ

üöþý$ùþr0   c                   @   sà  e Zd Zdd„ Zej ddedƒddffdedƒd	dffd
edƒddffdedƒedƒdffdedƒdd	ffdedƒdedƒffdedƒddffg¡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 d$d%d&gg d'¢g¡d(d)„ ƒZd*d+„ Zd,d-„ Zd.d/„ Zd0d1„ Zd2d3„ Zd4d5„ Zd6d7„ Zejd8d9„ ƒZej d:d;ejd;ejd<�ejg d=¢ejd<�g¡d>d?„ ƒZd@dA„ ZdBdC„ ZdDdE„ Z dFdG„ Z!dHdI„ Z"ej dJg dK¢¡dLdM„ ƒZ#dNdO„ Z$dPdQ„ Z%dRdS„ Z&dTdU„ Z'dVdW„ Z(dXdY„ Z)dZd[„ Z*d\d]„ Z+ej ,d^¡d_d`„ ƒZ-ej dadbge.dcdbdcƒe dbg¡g¡ej dddege deg¡g¡dfdg„ ƒƒZ/ej dhd;digg dj¢fdke0g dl¢dmdnej1ej1gg dl¢gg dj¢do�fdpdqdrgfdkdsge0dpdiej1ej1gg dt¢dudvej1ej1ggg dj¢do�fdpg dw¢fejg dx¢ejd<�e0dpdiej1gg dx¢dudvej1ggg dw¢do�fe.dpdmdcƒg dy¢fg dx¢g dz¢ge0dpdiej1ej1gg d{¢g d|¢gg dj¢do�fe.dpdmdcƒg d}¢fejg dx¢g dz¢gejd<�e0dpdiej1ej1gg d~¢g d¢gg dj¢do�fe.dcdcdcƒdbdqgfe0dkdsgd€d�gd‚dƒggdbdqgdo�e0g d„¢g d…¢g d†¢gg dw¢do�fg¡d‡dˆ„ ƒZ2d‰dŠ„ Z3d‹dŒ„ Z4d�dŽ„ Z5d�d�„ Z6d‘d’„ Z7ejj8ej d“d”d•gd–d—gg¡d˜d™„ ƒƒZ9dšd›„ Z:dœd�„ Z;dždŸ„ Z<d d¡„ Z=d¢d£„ Z>d¤d¥„ Z?d¦d§„ Z@d¨d©„ ZAdªd«„ ZBd¬d­„ ZCd®d¯„ ZDd°d±„ ZEd²d³„ ZFejjGeHƒ d´dµ�d¶d·„ ƒZId¸d¹„ ZJej dºg d»¢¡ej d¼ejejKeLg¡d½d¾„ ƒƒZMd¿dÀ„ ZNdÁdÂ„ ZOdÃdÄ„ ZPej dadÅdÆg¡dÇdÈ„ ƒZQej dÉeRejeSeTg¡dÊdË„ ƒZUdÌdÍ„ ZVej dÎdÏeSdpgƒfdÐeSdigƒfg¡dÑdÒ„ ƒZWdÓdÔ„ ZXej dÕd;g dÖ¢fe.dndsƒg d×¢fdmdugg dØ¢fg¡dÙdÚ„ ƒZYdÛdÜ„ ZZdÝdÞ„ Z[dßdà„ Z\ej dádâdâgg¡dãdä„ ƒZ]dådæ„ Z^ej dçdbdbgdbe.dcƒfg¡dèdé„ ƒZ_dêdë„ Z`dìdí„ Zadîdï„ Zbdðdñ„ Zcdòdó„ Zdej dôdõdög¡d÷dø„ ƒZedùdú„ Zfdûdü„ Zgdýdþ„ Zhdÿ�d „ Zi�d�d„ Zj�d�d„ ZkdcS (  ÚTestLocBaseIndependentc                 C   sH   t tddƒd�}|jt dg¡d d … }|jdd … }t ||¡ d S )NZ2021Ú2022r	   z2021/6/1r   é—   )r   r   r&   rv   ÚarrayÚilocr'   r(   ©r9   r+   Úresultr,   r-   r-   r.   Útest_loc_npstr  s    z%TestLocBaseIndependent.test_loc_npstrzmsg, keyz'Period\('2019', 'Y-DEC'\), 'foo', 'bar'éã  ÚfooÚbarz&Period\('2019', 'Y-DEC'\), 'y1', 'bar'Úy1z&Period\('2019', 'Y-DEC'\), 'foo', 'z1'Úz1z;Period\('2018', 'Y-DEC'\), Period\('2016', 'Y-DEC'\), 'bar'éâ  éà  z&Period\('2018', 'Y-DEC'\), 'foo', 'y1'z;Period\('2017', 'Y-DEC'\), 'foo', Period\('2015', 'Y-DEC'\)éá  éß  z&Period\('2017', 'Y-DEC'\), 'z1', 'bar'c                 C   sˆ   t tdƒddgtdƒtdƒdgtdƒdtd	ƒgg d
¢g d¢dœƒ g d¢¡}tjt|d�� |j|  W d  ƒ n1 sz0    Y  dS )a(  
        parse_datetime_string_with_reso return parameter if type not matched.
        PeriodIndex.get_loc takes returned value from parse_datetime_string_with_reso
        as a tuple.
        If first argument is Period and a tuple has 3 items,
        process go on not raise exception
        rŸ   Úx1Zx2r¤   r¥   r¢   r¦   r£   r§   rz   ©r_   rP   rg   )r%   r}   ÚCZV1ZV2©r%   r}   rª   ©ÚmatchN)r   r   Ú	set_indexr’   ÚraisesrA   r&   )r9   ÚmsgrV   r+   r-   r-   r.   Ú;test_contains_raise_error_if_period_index_is_in_multi_index  s    ûÿø	zRTestLocBaseIndependent.test_contains_raise_error_if_period_index_is_in_multi_indexc                 C   sR   t ddgiƒ}tjtdd��" |jd d …df  W d   ƒ n1 sD0    Y  d S )Nr#   r[   u   ×�r¬   )r   r’   r¯   rA   r&   r8   r-   r-   r.   Ú$test_loc_getitem_missing_unicode_key/  s    z;TestLocBaseIndependent.test_loc_getitem_missing_unicode_keyc                 C   sZ   t tj d¡ d¡dd„ tdƒD ƒd�}|jd }|jd d …df jd	 }t ||¡ d S )
Nr7   )rP   rd   c                 S   s   g | ]}d |d  ‘qS )ZABCDErd   r-   ©Ú.0Úxr-   r-   r.   Ú
<listcomp>9  ó    z@TestLocBaseIndependent.test_loc_getitem_dups.<locals>.<listcomp>rP   r	   )r%   r   r   r%   )r   rv   ÚrandomÚdefault_rngÚranger&   r'   Úassert_series_equal©r9   r+   r,   r�   r-   r-   r.   Útest_loc_getitem_dups4  s    þ
z,TestLocBaseIndependent.test_loc_getitem_dupsc                 C   st   t ddddtdƒggg d¢dgd�}tddddtdƒgg d¢dd�}|jd	 }t ||¡ |jd }t ||¡ d S )
Nr[   r7   r    r¡   Ú20130101©r#   r#   r#   r#   r#   ru   ©r
   r‰   r   )r   r   r   r›   r'   r»   r&   r¼   r-   r-   r.   Útest_loc_getitem_dups2?  s    ýý

z-TestLocBaseIndependent.test_loc_getitem_dups2c                 C   s  t tdƒtdƒtjddd�d d tjddd�d d d	œƒ d
¡}dddgf}| ¡ }|j|  d9  < t |j| d|j|  ¡ d}| ¡ }|j|  d9  < |j| d|j|  ksÀJ ‚dddgf}| ¡ }|j|  d9  < t 	|j| d|j|  ¡ d S )NZrtttiZaaaderd   Úfloat64©r6   gq=
×£põ?r7   gÃõ(\�ÂÕ¿)Úmer    r¡   Úbar2rÄ   Úrr¡   rÅ   ç       @)rÆ   r¡   Út)
r   Úlistrv   rw   r®   Úcopyr&   r'   r»   r(   )r9   Údf_origÚindexerr+   r-   r-   r.   Útest_loc_setitem_dupsS  s2    üÿù
þþz,TestLocBaseIndependent.test_loc_setitem_dupsc                 C   s  t g d¢tg d¢dd�dœƒ}|d dk}|j|df d }||j|df< t g d¢tg d	¢dd�dœƒ}t ||¡ t g d¢g d¢dœd
d�}|d dk}|j|df }tjtdd�� ||j|df< W d   ƒ n1 sÚ0    Y  t g d¢g d¢dœd
d�}t ||¡ d S )N)r   r[   r[   )éd   rr   é,  Zuint32rÃ   ©r#   r"   r#   r[   r"   )rÎ   éÉ   i-  Úuint64úitem of incompatible dtyper¬   )r   r   r&   r'   r(   Úassert_produces_warningÚFutureWarning)r9   Zdf1ÚixZnewb1r,   r…   Znewb2r-   r-   r.   Útest_loc_setitem_slicev  s"    ÿÿ,z-TestLocBaseIndependent.test_loc_setitem_slicec                 C   s�   t dgdgdgdgdœƒ}g d¢}|jd d …|f  d¡|jd d …|f< t dgtjdgdd	�tjdgdd	�tjdgdd	�dœƒ}t ||¡ d S )
Nr%   ç333333ó?ç        g      À)Úidr#   r"   rG   ©r#   r"   rG   Zfloat32rÂ   rÃ   )r   r&   Úastyperv   rš   r'   r(   )r9   r+   Úcolsr,   r-   r-   r.   Útest_loc_setitem_dtypeŽ  s    &üÿ	z-TestLocBaseIndependent.test_loc_setitem_dtypec                 C   s˜   t tdƒg d¢d�}tjtdd�� |ddg  W d   ƒ n1 sD0    Y  t tdƒƒ}tjtdd�� |ddg  W d   ƒ n1 sŠ0    Y  d S )	Nr`   rÛ   r	   únot in indexr¬   r#   Údr   )r   rº   r’   r¯   rA   )r9   Úsr-   r-   r.   Ú$test_getitem_label_list_with_missing¡  s    *z;TestLocBaseIndependent.test_getitem_label_list_with_missingr
   TFrm   c                 C   s`   t g d¢ƒ}dt|ƒ› dt|ƒ› �}tjt|d�� |j|  W d   ƒ n1 sR0    Y  d S )Nrz   z Boolean index has wrong length: z instead of r¬   )r   Úlenr’   r¯   rn   r&   )r9   r
   rá   r°   r-   r-   r.   Útest_loc_getitem_bool_diff_len¬  s    z5TestLocBaseIndependent.test_loc_getitem_bool_diff_lenc                 C   s   d S rj   r-   rk   r-   r-   r.   Útest_loc_getitem_int_slice´  s    z1TestLocBaseIndependent.test_loc_getitem_int_slicec                 C   s~   t tj d¡ d¡g d¢g d¢d�}dt t¡› d�}tjt|d��& |j	d	dgd	dgf  W d   ƒ n1 sp0    Y  d S )
Nr7   ©r`   r`   rÛ   )ÚerI   Úg©r
   r5   z$\"None of \[Index\(\[1, 2\], dtype='ú'\)\] are in the \[index\]\"r¬   r[   )
r   rv   r¸   r¹   r6   Úintr’   r¯   rA   r&   ©r9   r+   r°   r-   r-   r.   Útest_loc_to_fail¸  s    ýÿz'TestLocBaseIndependent.test_loc_to_failc                 C   sÎ  t td�}d|jd< d|jd< tjtdd�� |jd  W d   ƒ n1 sL0    Y  dt t¡› d	�}tjt|d�� |jdd
g  W d   ƒ n1 sš0    Y  d}tjt|d��$ |jt	dgtd�  W d   ƒ n1 sà0    Y  d|jd< tjtdd�� |jdd
g  W d   ƒ n1 �s(0    Y  d|d< dt t¡› d	�}tjt|d�� |jd
g  W d   ƒ n1 �s~0    Y  |d= tjt|d�� d|jd
g< W d   ƒ n1 �sÀ0    Y  d S )NrÃ   r[   r7   r#   z^-1$r¬   éÿÿÿÿz&\"None of \[Index\(\[-1, -2\], dtype='rê   éþÿÿÿzE\"None of \[Index\(\['4'\], dtype='object'\)\] are in the \[index\]\"Ú4r`   rß   z"\"None of \[Index\(\[-2\], dtype='r   )
r   Úobjectr&   r’   r¯   rA   rv   r6   rë   r   ©r9   rá   r°   r-   r-   r.   Útest_loc_to_fail2Ç  s.    


(ÿ,2
.ÿ,z(TestLocBaseIndependent.test_loc_to_fail2c                 C   s®   t dgdggddgdgd�}dt t¡› d�}tjt|d	��$ |jd
gd d …f  W d   ƒ n1 sf0    Y  tjt|d	�� |jd
g  W d   ƒ n1 s 0    Y  d S )Nr#   r"   r[   r7   Úvalueré   z!\"None of \[Index\(\[3\], dtype='rê   r¬   r`   )r   rv   r6   rë   r’   r¯   rA   r&   rì   r-   r-   r.   Útest_loc_to_fail3î  s    ÿ2z(TestLocBaseIndependent.test_loc_to_fail3c                 C   sª   t g d¢ƒ}|jdg  dt t¡› d�}tjtt 	|¡d�� |jdg  W d   ƒ n1 s`0    Y  tjtdd�� |jddg  W d   ƒ n1 sœ0    Y  d S )Nrz   r7   z"None of [Index([3], dtype='z')] are in the [index]r¬   r`   rß   )
r   r&   rv   r6   rë   r’   r¯   rA   ÚreÚescaperò   r-   r-   r.   Útest_loc_getitem_list_with_failý  s    *z6TestLocBaseIndependent.test_loc_getitem_list_with_failc                 C   s’   t tj d¡jdd�g d¢d�}|j dd„ ¡}|jt |¡ }|j| }t 	||¡ |j|j
 }t 	||¡ |jtj|dd	� }t 	||¡ d S )
Nr7   )rd   r_   ©Úsize)Zalpha_0Zalpha_1Zalpha_2Zbeta_0Zbeta_1r	   c                 S   s   d| v S )NÚalphar-   ©rµ   r-   r-   r.   Ú<lambda>  r·   z7TestLocBaseIndependent.test_loc_index.<locals>.<lambda>ÚbooleanrÃ   )r   rv   r¸   r¹   r
   Úmapr&   rš   r'   r(   r„   r‚   )r9   r+   Úmaskr,   r�   r-   r-   r.   Útest_loc_index  s    þ
z%TestLocBaseIndependent.test_loc_indexc                 C   sÌ   t tj d¡ d¡g d¢g d¢d�}|jd d …dd…f jdd…d d …f }|jddgk ¡ sbJ ‚|jddgk ¡ sxJ ‚t t	dƒgd	gd
œƒjd }t
t	dƒd	gddgdd�}t ||¡ |jtksÈJ ‚d S )Nr7   ©rc   rc   ©r%   r}   rª   ÚDru   r%   r}   r   r¾   r[   rÐ   r#   r"   rÀ   )r   rv   r¸   r¹   r&   r›   r5   Úallr
   r   r   r'   r»   r6   rñ   rœ   r-   r-   r.   Útest_loc_general"  s    ý(z'TestLocBaseIndependent.test_loc_generalc                 C   s"   t tddƒttdƒtjd�dœƒS )Nú
2000-01-01ú	2000-01-5rd   rÃ   ©r   Úval)r   r   r   rº   rv   Úint64rk   r-   r-   r.   Úframe_for_consistency4  s
    þÿz,TestLocBaseIndependent.frame_for_consistencyr
  r   rÃ   )r   r   r   r   r   c                 C   s„   t tdtdƒtjd�ttdƒtjd�dœƒ}| ¡ }tjtdd��" ||j	d d …df< W d   ƒ n1 sj0    Y  t 
||¡ d S )	Nr   rd   ©r
   r6   rÃ   r	  úincompatible dtyper¬   r   ©r   r   rº   rv   r  rÊ   r'   rÔ   rÕ   r&   r(   )r9   r  r
  r,   r+   r-   r-   r.   Útest_loc_setitem_consistency=  s    þÿ0z3TestLocBaseIndependent.test_loc_setitem_consistencyc                 C   s€   t tdtdƒd�ttdƒtjd�dœƒ}| ¡ }tjtdd��" d|j	d d …df< W d   ƒ n1 sf0    Y  t 
||¡ d S )	Nr    rd   r	   rÃ   r	  r  r¬   r   r  ©r9   r  r,   r+   r-   r-   r.   Ú(test_loc_setitem_consistency_dt64_to_strO  s    þÿ0z?TestLocBaseIndependent.test_loc_setitem_consistency_dt64_to_strc                 C   s€   t tdtdƒd�ttdƒtjd�dœƒ}| ¡ }tjtdd��" d|j	d d …df< W d   ƒ n1 sf0    Y  t 
||¡ d S )	Nç      ð?rd   r	   rÃ   r	  r  r¬   r   r  r  r-   r-   r.   Ú*test_loc_setitem_consistency_dt64_to_float^  s    þÿ0zATestLocBaseIndependent.test_loc_setitem_consistency_dt64_to_floatc                 C   sx   t dttdƒgƒiƒ}tjtdd��" d|jd d …df< W d   ƒ n1 sL0    Y  t dtdgƒiƒ}t ||¡ d S )Nr   Z20180101r  r¬   Ústring)r   r   r   r'   rÔ   rÕ   r&   r(   rx   r-   r-   r.   Ú'test_loc_setitem_consistency_single_rowl  s
    0z>TestLocBaseIndependent.test_loc_setitem_consistency_single_rowc                 C   sž   t ddgd�}t ddgd�}t d ¡�" d|jd d …df< W d   ƒ n1 sN0    Y  t ||¡ t ddgd�}d|d< |d  tj¡|d< t ||¡ d S )Nrµ   Úyr‡   r[   )r   r'   rÔ   r&   r(   rÜ   rv   r  ©r9   r,   r+   r-   r-   r.   Ú"test_loc_setitem_consistency_emptyu  s    0z9TestLocBaseIndependent.test_loc_setitem_consistency_emptyc                 C   sŒ  dgd g d¢g d¢g}t j|g d¢d�}g d¢g d¢g}t j|d	d
gd�}ddddtjgg d¢ddddtjgg d¢g}t|||d�}t|jd d …df ƒ|jd d …df< t|jd d …df ƒ|jd d …df< |jdd�}|jd d …df |jd d …df  |jd d …df< tj	t
dd��8 |jd d …df tdƒ |jd d …df< W d   ƒ n1 �sZ0    Y  tg d¢|jdd�}t |d |¡ d S )NZRegion_1rc   )ÚSite_1r  ÚSite_2r  )l   ðBP[ l   _ˆZ l   q=.Z l   Ñ<.Z )ÚRegionZSiteZRespondentID©Únames)Ú
Respondentr  r  ÚOtherCatr   )Z	SomethingÚ	StartDateÚEndDatezYes/NoZSomethingElseZLevel_0ZLevel_1r%   z5/25/2015 10:59z5/25/2015 11:22ÚYes)r%   z5/21/2015 9:40z5/21/2015 9:52r#  r#  z5/20/2015 8:27z5/20/2015 8:41)r%   z5/20/2015 8:33z5/20/2015 9:09r#  ZNoré   )r  r!  )r  r"  F)rÊ   )r  ZDurationr  r¬   l    XŽp7 )g      7@ç      (@g      ,@g      B@rÀ   )r   Úfrom_arraysrv   r�   r   r   r&   Zinfer_objectsr'   rÔ   rÕ   r   r   r
   r»   )r9   ÚlevelsÚmiZclevelsrÝ   r„   r+   r,   r-   r-   r.   Ú-test_loc_setitem_consistency_slice_column_len…  sH    ýþüÿÿÿÿ
ÿþ2ÿzDTestLocBaseIndependent.test_loc_setitem_consistency_slice_column_lenÚunit)ÚYÚMr  ÚhÚmrá   ÚmsÚusc                 C   sª   t dt d¡t d¡giƒ}|jd d …df j d|› d�¡|jd d …|f< |jd d …df j d|› d�¡|d< t|jd d …df |d�}t |jd d …|f |¡ d S )NÚ	timestampz2017-02-11 12:41:29z1991-11-07 04:22:37zdatetime64[ú]r,   rˆ   )	r   rv   Ú
datetime64r&   r„   rÜ   r   r'   r»   )r9   r)  r+   r,   r-   r-   r.   Útest_loc_assign_non_ns_datetime·  s    þÿÿ	0&z6TestLocBaseIndependent.test_loc_assign_non_ns_datetimec                 C   sº   t  dg d¢i¡}t|d ddd�|d< |jd d …df |jd d …df< |jdd	gdf |jdd	gdf< t g d
¢g d¢g d¢g d¢gg d¢d�}ddg}||  t¡||< t ||¡ d S )Nr   )ì   çCO!gì   ös~!gì    4	8šì   A{ï?šr.  T)r)  ÚcacheÚdate_dtÚ
date_dt_cpr7   r`   )r4  ú2017-01-24 13:26:12.711r;  )r5  ú2017-01-24 13:52:05.110r<  )r6  ú2018-10-22 13:44:05.888r=  )r7  ú2018-10-23 08:08:41.025r>  )r   r9  r:  r‡   )r   Ú	from_dictr   r&   Úapplyr'   r(   )r9   r+   r,   r5   r-   r-   r.   Útest_loc_modify_datetimeÉ  s"    
ÿ  üù
z/TestLocBaseIndependent.test_loc_modify_datetimec                 C   sf   t g d¢dgtd�}tjg d¢dd�|jg d¢df< tg d¢g d¢td	�}t d|iƒ}t ||¡ d S )
N©r`   rd   rc   r%   ©r
   r5   r6   rz   r  rÃ   ©rc   r`   rd   ©r7   r`   r[   r  )r   Úfloatrv   rš   r&   r   r'   r(   ©r9   r+   Úserr,   r-   r-   r.   Ú#test_loc_setitem_frame_with_reindexã  s
     z:TestLocBaseIndependent.test_loc_setitem_frame_with_reindexc                 C   s~   t g d¢ddgtd�}d|d< tjg d¢dd�|jg d	¢df< tg d
¢g d¢dd�}t d| t¡iƒ}d|d< t ||¡ d S )NrB  r%   r}   rC  r  rz   r  rÃ   rD  rE  r  )	r   rF  rv   rš   r&   r   rÜ   r'   r(   rG  r-   r-   r.   Ú)test_loc_setitem_frame_with_reindex_mixedî  s     z@TestLocBaseIndependent.test_loc_setitem_frame_with_reindex_mixedc                 C   sl   t g d¢ddgtd�}d|d< tjg d¢dd�|jtdd	d
ƒdf< t g d¢ddœg d¢d�}t ||¡ d S )Nrz   r%   r}   rC  r  r  rÃ   r`   r   rî   )r\   rÇ   r  r€   r	   )r   rF  rv   rš   r&   r•   r'   r(   rx   r-   r-   r.   Ú*test_loc_setitem_frame_with_inverted_sliceú  s
    $zATestLocBaseIndependent.test_loc_setitem_frame_with_inverted_slicec           
      C   sÞ   dd„ t dƒD ƒ}tjddd�}dd„ t dƒD ƒ}tjddd�}tt|ƒ |¡ƒ}t|d�}tj|d	< ||j|d	f< tj|d
< ||j|d
f< t	||tj
d�}t	||d�}t||dœtd	d
gtd�d�j|d�}	t ||	¡ d S )Nc                 S   s   g | ]}d t |ƒ ‘qS ©ú@©r3   ©r´   Úir-   r-   r.   r¶     r·   zGTestLocBaseIndependent.test_loc_setitem_empty_frame.<locals>.<listcomp>rd   r  rÃ   c                 S   s   g | ]}d t |ƒ ‘qS rL  rN  rO  r-   r-   r.   r¶   	  r·   rc   r	   r%   r}   r  r€   r‡   )rº   rv   rw   rÉ   ÚsetÚunionr   r�   r&   r   rÂ   r   rñ   Úreindexr'   r(   )
r9   Zkeys1Zval1Úkeys2Zval2r
   r+   ZseraZserbr,   r-   r-   r.   Útest_loc_setitem_empty_frame  s$    


ÿþz3TestLocBaseIndependent.test_loc_setitem_empty_framec                 C   s¶   t tj d¡ d¡tdƒtdƒd�}|jd }d|jd< |jd }|dksNJ ‚|jd }|dksdJ ‚d	|jd d …d
d…f< |jd d …d
d…f }|jd d …dd …f }t 	||¡ d S )Nr7   r  ÚabcdÚABCDré   ©r   r   r[   )r#   r%   r   r}   r  )
r   rv   r¸   r¹   Ústandard_normalrÉ   r›   r&   r'   r(   rœ   r-   r-   r.   Útest_loc_setitem_frame  s    ý



z-TestLocBaseIndependent.test_loc_setitem_framec                 C   sP   t g d¢tjdœƒ}|j|j|j|jkdf< t g d¢tjdœƒ}t ||¡ d S )Nrz   r€   r}   )r   rv   r�   r%   r&   r}   r'   r(   rx   r-   r-   r.   Ú/test_loc_setitem_frame_nan_int_coercion_invalid2  s    zFTestLocBaseIndependent.test_loc_setitem_frame_nan_int_coercion_invalidc                 C   sœ   t ddgddgddgdœƒ}|jdddgf }tddgtddgtd	�tdd
�}t ||¡ t ddgddgddgdœƒ}ddg|jdddgf< t ||¡ d S )Nr[   r7   r`   rc   r#   r"   )r[   r7   r#   r   rÃ   ©r
   r6   r‰   rd   ra   )r   r&   r   r   rñ   r'   r»   r(   rœ   r-   r-   r.   Ú#test_loc_setitem_frame_mixed_labels:  s    ÿz:TestLocBaseIndependent.test_loc_setitem_frame_mixed_labelsz.ignore:Setting a value on a view:FutureWarningc                 C   s  t g d¢ttdƒtjd�dœƒ}|jdd… }|jdd… |_||jdd…< t g d¢tg d	¢tjd�dœƒ}t ||¡ t t	d
dƒttdƒtjd�dœƒ}t t
dƒt
dƒt
dƒt
dƒt
dƒgtg d¢tjd�dœƒ}|jdd… }|jdd… |_||jdd…< t ||¡ d S )N©r    r¡   Úbazr`   rÃ   r€   r[   r7   r   )r¡   r_  r_  )r[   r7   r7   r  r  rd   r	  Z20000101Z20000102Z20000103)r   r[   r   r[   r7   rc   )r   r   rº   rv   r  r&   r
   r'   r(   r   r   )r9   Úwarn_copy_on_writer+   Úrhsr,   r-   r-   r.   Ú test_loc_setitem_frame_multiplesI  s:    ÿÿþÿûøÿz7TestLocBaseIndependent.test_loc_setitem_frame_multiplesrÌ   r%   Nrô   ÚZc                 C   sV   t ddgddggddgd� dti¡}||jd|f< |jd	 }t|ƒrN|d
ksRJ ‚d S )Nr[   r7   r`   rc   r%   r}   r‡   r   )r   r%   rc  )r   rÜ   rñ   r&   r   )r9   rÌ   rô   r+   r�   r-   r-   r.   Ú"test_loc_setitem_with_scalar_indexo  s    
&
z9TestLocBaseIndependent.test_loc_setitem_with_scalar_indexzindex,box,expectedr7   r  rb   )rb   rb   rb   rb   r`   rc   r‡   r[   rª   r  rp   )r`   rc   rb   rp   rd   ra   r«   ©rb   rp   é	   )r}   rª   r  ©r_   é   é   )r`   rb   rp   rf  )rd   r_   rh  ri  )rª   r%   r  )rp   rc   rb   rf  )rh  ra   r_   ri  rf  r_   rh  ri  )rb   r7   rp   )rf  rc   r_   )rh  ra   ri  c                 C   s<   t ddgddgddggddgd	�}||j|< t ||¡ d S )
Nr[   r7   r`   rc   rd   ra   r%   r}   r‡   ©r   r&   r'   r(   )r9   r
   Úboxr,   r+   r-   r-   r.   Ú test_loc_setitem_missing_columns  s    5"
z7TestLocBaseIndependent.test_loc_setitem_missing_columnsc                 C   sZ   t dtdƒ d¡tjgiƒ}|j}|jdg }t |j|¡ |jdg }t |j|¡ d S )Nr   r¾   ÚUTCr   r[   )	r   r   Útz_localizer‚   rƒ   Údtypesr›   r'   r»   r¼   r-   r-   r.   Útest_loc_coercion¹  s    z(TestLocBaseIndependent.test_loc_coercionc                 C   s^   t dtdddƒtdddƒgiƒ}|j}|jdg }t |j|¡ |jdg }t |j|¡ d S )Nr   éÜ  r[   iô  r7   r   )r   r   ro  r›   r'   r»   r¼   r-   r-   r.   Útest_loc_coercion2Ä  s     z)TestLocBaseIndependent.test_loc_coercion2c                 C   sZ   t ddgd gd  iƒ}|j}|jdd… }t |j|¡ |jdd … }t |j|¡ d S )NÚtextz
some wordsrf  r   r7   r`   )r   ro  r›   r'   r»   r¼   r-   r-   r.   Útest_loc_coercion3Ï  s    z)TestLocBaseIndependent.test_loc_coercion3c                 C   sn   t dƒ d¡t dƒ d¡g}t|tddgtd�d�}ttd�}|d ||ƒd< |d	 ||ƒd< t ||¡ d S )
Né*   rm  iš  r    r¡   rÃ   r	   r   r[   )r   rn  r   r   rñ   r'   r»   )r9   Z
indexer_slÚvalsr,   rH  r-   r-   r.   Útest_setitem_new_key_tzÚ  s    þ
z.TestLocBaseIndependent.test_setitem_new_key_tzc                 C   s’  t g d¢g d¢dœg d¢d�}d}tjt|d�� |jdd …  W d   ƒ n1 sT0    Y  d	}tjt|d�� |jd
d …  W d   ƒ n1 s”0    Y  d}tjt|d�� |jdd…  W d   ƒ n1 sÔ0    Y  t g d¢g d¢dœg d¢d�jd
d�}|jdd … }t g d¢g d¢dœg d¢d�}t ||¡ |jd
d … }t ||¡ |jdd… }t g d¢g d¢dœg d¢d�}t ||¡ d S )N©r[   r7   r`   rc   rd   ra   )r`   rc   rd   ra   rb   rp   r€   )r   r[   r   r[   r7   r`   r	   z5'Cannot get left slice bound for non-unique label: 1'r¬   r[   z5'Cannot get left slice bound for non-unique label: 0'r   r7   ©Úaxis)r7   rc   rd   ra   )rc   ra   rb   rp   )r[   r[   r7   r`   )r7   rc   rd   )rc   ra   rb   )r[   r[   r7   )r   r’   r¯   rA   r&   Ú
sort_indexr'   r(   )r9   r+   r°   r�   r,   r-   r-   r.   Útest_loc_non_uniqueè  s2    ÿ,,,ÿþz*TestLocBaseIndependent.test_loc_non_uniquez
length, l2é„  rÎ   i » é † c              	   C   sÚ   t dƒ}t ttj d¡ |t|ƒf¡t 	|¡|d�tt 
|t|ƒf¡dg| |d�g¡}|jjdu sjJ ‚t 	|¡}|j| }t | dg¡tt 
t|ƒt|ƒf¡dgt|ƒ |d�| |dd … ¡g¡}t ||¡ d S )NZABCDEFGr7   ré   r   Fr[   )rÉ   r‚   Úconcatr   rv   r¸   r¹   rY  rã   rw   Úonesr
   Z	is_uniquer&   Útaker'   r(   )r9   ÚlengthÚl2r5   r+   r   r�   r,   r-   r-   r.   Ú test_loc_non_unique_memory_error
  s0    ý úÿ


ýùÿz7TestLocBaseIndependent.test_loc_non_unique_memory_errorc                 C   s\   t ddgddggƒ}d|j_|jddg jj}|dks:J ‚|jddg jj}|dksXJ ‚d S )Nr[   Z
index_namer   )r   r
   r‰   r›   r&   ©r9   r+   r�   r-   r-   r.   Útest_loc_name.  s    z$TestLocBaseIndependent.test_loc_namec                 C   sÒ   t t d¡tdd„ tdƒD ƒdd�tdd„ tdƒD ƒdd�d	�}tj|jd d …g f |jd d …d d
…f ddd� tj|jg d d …f |jd d
…d d …f ddd� tj|jg  |jd d
…d d …f ddd� d S )N)rd   r7   c                 S   s   g | ]}d |› �‘qS ©zi-r-   rO  r-   r-   r.   r¶   ;  r·   zLTestLocBaseIndependent.test_loc_empty_list_indexer_is_ok.<locals>.<listcomp>rd   r#   rˆ   c                 S   s   g | ]}d |› �‘qS r‡  r-   rO  r-   r-   r.   r¶   <  r·   r7   ré   r   T)Úcheck_index_typeÚcheck_column_type)	r   rv   r€  r   rº   r'   r(   r&   r›   r8   r-   r-   r.   Ú!test_loc_empty_list_indexer_is_ok8  s    ý(ÿ(ÿ ÿz8TestLocBaseIndependent.test_loc_empty_list_indexer_is_okc                 C   s  t dg d¢iƒ}|jd d … }||us*J ‚|d d … |us>J ‚|jd d …d d …f |us\J ‚t |d j|d j¡sxJ ‚t |¡�& g d¢|jd d …df< W d   ƒ n1 s®0    Y  |rÖ|d g d¢k ¡ sêJ ‚n|d dk ¡ sêJ ‚t tj 	d¡ 
d¡ƒ}|�s|�r.|d |jd d …df u�sNJ ‚n |d |jd d …df u �sNJ ‚tg d¢ƒ}|jd d … }||u�svJ ‚|d d … |u�sŒJ ‚t |¡�  g d	¢|d d
…< W d   ƒ n1 �s¾0    Y  |�rît|d d
… g d¢kƒ�sJ ‚nt|d d
… g d	¢kƒ�sJ ‚d S )Nr#   rz   )rc   rc   rc   rc   r7   ©r_   rc   r   rx  re  r`   )r   r&   rv   Zshares_memoryÚ_valuesr'   Úassert_cow_warningr  r¸   r¹   rY  r   )r9   Úusing_copy_on_writer`  Zoriginal_dfZ	sliced_dfr+   Zoriginal_seriesZsliced_seriesr-   r-   r.   Ú&test_identity_slice_returns_new_objectK  s0    4" 0 z=TestLocBaseIndependent.test_identity_slice_returns_new_objectc                 C   s˜   |st jjdd�}| |¡ tttdƒtdƒƒddgd�}| ¡ }|jd d …df }|d7 }t	 
||¡ | ¡ }|j|jdf }|d7 }t	 
||¡ d S )Nz!accidental fix reverted - GH37497©Úreasonr`   r#   r"   r‡   r7   )r’   r“   ÚxfailZapplymarkerr   Úziprº   rÊ   r&   r'   r(   r
   )r9   rC   rŽ  r“   rµ   r  ÚqÚzr-   r-   r.   Útest_loc_copy_vs_viewv  s    
z,TestLocBaseIndependent.test_loc_copy_vs_viewc                 C   s’   t  d¡j}tddg|d |gd�}|j|d  }|jd }||ksHJ ‚|j|d g }|jdg }t ||¡ |j|d |g }t ||¡ d S )NrÒ   r[   r7   r	   r   )rv   ÚiinfoÚmaxr   r&   r›   r'   r»   )r9   ÚumaxrH  r�   r,   r-   r-   r.   Útest_loc_uint64Š  s    
z&TestLocBaseIndependent.test_loc_uint64c                 C   sš   t  d¡j}tddg|d |gd�}tjtdd�� |jd  W d   ƒ n1 sR0    Y  tjtdd�� |jdg  W d   ƒ n1 sŒ0    Y  d S )NrÒ   r[   r7   r	   z-1r¬   rî   )rv   r—  r˜  r   r’   r¯   rA   r&   )r9   r™  rH  r-   r-   r.   Ú!test_loc_uint64_disallow_negative›  s    (z8TestLocBaseIndependent.test_loc_uint64_disallow_negativec                 C   s\   g d¢}t |tjtjgt|ƒ td�dœƒ}t ddgd�}||jd d …df< t ||¡ d S ©Nrz   rÃ   ©rµ   r  rµ   r  r‡   )	r   rv   rš   r�   rã   rñ   r&   r'   r(   ©r9   r~   r,   r+   r-   r-   r.   Ú*test_loc_setitem_empty_append_expands_rows¨  s    ÿzATestLocBaseIndependent.test_loc_setitem_empty_append_expands_rowsc                 C   sp   g d¢}t |tjtjgt|ƒ td�dœƒ}t ddgd�}|d  tj¡|d< ||jd d …df< t	 
||¡ d S rœ  )r   rv   rš   r�   rã   rñ   rÜ   r  r&   r'   r(   rž  r-   r-   r.   Ú6test_loc_setitem_empty_append_expands_rows_mixed_dtypeµ  s    ÿzMTestLocBaseIndependent.test_loc_setitem_empty_append_expands_rows_mixed_dtypec                 C   sD   t dgtjgdœƒ}t ddgtd�}|jd |jd< t ||¡ d S )Nr  r�  rµ   r  r4   )r   rµ   )r   rv   r�   rF  r&   r'   r(   r  r-   r-   r.   Ú*test_loc_setitem_empty_append_single_valueÂ  s    zATestLocBaseIndependent.test_loc_setitem_empty_append_single_valuec                 C   sÀ   ddg}t ddgd�}|j tj¡|_dt t¡› d�}tjt	|d��" ||j
d	dgdf< W d   ƒ n1 sn0    Y  d
}tjt|d��" ||j
d	d…df< W d   ƒ n1 s²0    Y  d S )Nr[   r7   rµ   r  r‡   z"None of \[Index\(\[0, 1\], dtype='z'\)\] are in the \[index\]r¬   r   ú)setting an array element with a sequence.)r   r
   rÜ   rv   r  r6   rë   r’   r¯   rA   r&   Ú
ValueError)r9   r~   r+   r°   r-   r-   r.   Ú$test_loc_setitem_empty_append_raisesÉ  s    ÿ0z;TestLocBaseIndependent.test_loc_setitem_empty_append_raisesc                 C   sD   t ddgddggƒ}|jt d¡ }tddgdd�}t ||¡ d S )Nr[   r7   r`   rc   r   rˆ   )r   r&   rv   rš   r   r'   r»   )r9   r+   r�   rá   r-   r-   r.   Útest_indexing_zerodim_np_arrayÚ  s    z5TestLocBaseIndependent.test_indexing_zerodim_np_arrayc                 C   s,   t ddgƒ}|jt d¡ }|dks(J ‚d S )Nr[   r7   r   )r   r&   rv   rš   )r9   rá   r�   r-   r-   r.   Ú%test_series_indexing_zerodim_np_arrayá  s    z<TestLocBaseIndependent.test_series_indexing_zerodim_np_arrayc                 C   s\   g d¢d gd  }t |tddƒd�}t tddƒtjd�}g d¢|jddd	…< t ||¡ d S )
Nrx  rc   iÚ  iä  r	   r  )ra   rd   rc   r`   r7   r[   r§   rî   )r   rº   rv   rÂ   r&   r'   r»   )r9   r~   r,   r�   r-   r-   r.   Útest_loc_reverse_assignmentç  s
    z2TestLocBaseIndependent.test_loc_reverse_assignmentzcan't set int into stringr�  c                 C   sª   dd„ t dƒD ƒ}t|dgd�}t|dgtd�}t ||¡ dd„ |D ƒ|j|jdf< t|dgtd� t¡}t ||¡ dd„ |D ƒ|d< t|dgtd�}t ||¡ d S )	Nc                 S   s$   g | ]}t tj d ¡ ¡ d ƒ‘qS )r7   gê-�™—q=)r3   rv   r¸   r¹   )r´   rR   r-   r-   r.   r¶   õ  r·   z^TestLocBaseIndependent.test_loc_setitem_str_to_small_float_conversion_type.<locals>.<listcomp>rd   r%   r‡   r4   c                 S   s   g | ]}t |ƒ‘qS r-   ©rF  r³   r-   r-   r.   r¶   ü  r·   c                 S   s   g | ]}t |ƒ‘qS r-   r¨  r³   r-   r-   r.   r¶     r·   )	rº   r   rñ   r'   r(   r&   r
   rF  rÜ   )r9   Zcol_datar�   r,   r-   r-   r.   Ú3test_loc_setitem_str_to_small_float_conversion_typeñ  s    zJTestLocBaseIndependent.test_loc_setitem_str_to_small_float_conversion_typec           	      C   sÌ   t dddd�}|jdk|jdk@ }ttj d¡ t|ƒdf¡|d	�}t	 
||¡}|jtddƒ }|j| }t	 ||¡ |jd
d … }|jtddƒ }|dd … }|j d ¡|_|j d ¡|_t	 ||¡ d S )Nú1/1/2000z1/5/2000Z5min©Úfreqrf  rg   r7   r`   r	   z1/4/2000rî   )r   ÚhourÚminuter   rv   r¸   r¹   rY  rã   r'   Úget_objr&   r   r‹   r
   Ú
_with_freq)	r9   Úframe_or_seriesÚrngr   rD   r�   rŒ   Úchunkr,   r-   r-   r.   Útest_loc_getitem_time_object  s    ÿ
z3TestLocBaseIndependent.test_loc_getitem_time_objectÚ
spmatrix_t)Z
coo_matrixZ
csc_matrixZ
csr_matrixr6   c                 C   s    t  d¡}t||ƒ}d\}}|tj|||d�|d�}tj |¡}td|ƒ}|j	| j
}	| ¡ | }
t |	|
¡ |j	| jj
}	t |t|dd�¡}
t |	|
¡ d S )Núscipy.sparse)rd   rb   rÃ   r7   r   )Z
fill_value)r’   ÚimportorskipÚgetattrrv   Úeyer   ÚsparseÚfrom_spmatrixrº   r&   r„   Ztoarrayr'   Zassert_numpy_array_equalro  Úfullr   )r9   rµ  r6   Ú	sp_sparseÚrowsrÝ   Zspmatrixr+   Zitr_idxr�   r,   r-   r-   r.   Ú$test_loc_getitem_range_from_spmatrix  s    


z;TestLocBaseIndependent.test_loc_getitem_range_from_spmatrixc                 C   s<   t dtjddgtdƒd�iƒ}|jddg }t ||¡ d S )Nr%   r   r  rÃ   r[   )r   r‚   rš   r   r&   r'   r(   r…  r-   r-   r.   Ú,test_loc_getitem_listlike_all_retains_sparse5  s    zCTestLocBaseIndependent.test_loc_getitem_listlike_all_retains_sparsec                 C   s”   t  d¡}tj | d¡¡}|jtdƒ }tg d¢g d¢gtddƒd�}t	 
||¡ |jtdƒ jtd	ƒ }tg d¢gtddƒd�}t	 
||¡ d S )
Nr¶  rd   r7   ©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(   )r9   r½  r+   r�   r,   r-   r-   r.   Útest_loc_getitem_sparse_frame:  s    
þÿz4TestLocBaseIndependent.test_loc_getitem_sparse_framec                 C   s„   t g d¢tddƒd�}|jtdƒ }t ddgtddƒd�}t ||¡ |jtdƒ jtdƒ }t ddgtddƒd�}t ||¡ d S )NrÁ  rÂ   rÙ   rÃ   r7   r  r`   )r   r   r&   rº   r'   r»   )r9   rá   r�   r,   r-   r-   r.   Útest_loc_getitem_sparse_seriesL  s    z5TestLocBaseIndependent.test_loc_getitem_sparse_seriesr&   r›   c                 C   sP   t g d¢g d¢gttƒd�}t||ƒd }tg d¢ttƒdd�}t ||¡ d S )N)r  rÙ   ç      ø?)rÙ   rÇ   rÙ   rÃ   r   )r6   r‰   )r   r   rF  r¸  r   r'   r»   )r9   rÌ   r+   r�   r,   r-   r-   r.   Ú!test_getitem_single_row_sparse_dfX  s    z8TestLocBaseIndependent.test_getitem_single_row_sparse_dfÚkey_typec                 C   sD   |g d¢ƒ}|j d d …|f }|j d d …g d¢f }t ||¡ d S )Nr«   )r&   r'   r(   )r9   Úfloat_framerÆ  Úidxr�   r,   r-   r-   r.   Útest_loc_getitem_iterable`  s    z0TestLocBaseIndependent.test_loc_getitem_iterablec                 C   sh   t tj d¡jdd�ƒ}tdddd�|_|jtdƒd …d d …f }|jdd …d d …f }t	 
||¡ d S )Nr7   r‹  rù   Z0sr_   rá   ©ÚstartÚperiodsr¬  )r   rv   r¸   r¹   Únormalr   r
   r&   r   r'   r(   r¼   r-   r-   r.   Ú#test_loc_getitem_timedelta_0secondsg  s
    z:TestLocBaseIndependent.test_loc_getitem_timedelta_0secondsúval,expectedì   ÿÿÿÿ ì            c                 C   s4   t ddgddgd�}|j| }||_t ||¡ d S )Nr[   r7   rÐ  rÑ  r	   )r   r&   r‰   r'   r»   )r9   r
  r,   r+   r�   r-   r-   r.   Útest_loc_getitem_uint64_scalaro  s    
z5TestLocBaseIndependent.test_loc_getitem_uint64_scalarc                 C   sL   |}t g d¢tg d¢|d�d�}| ¡ }d|jd< d|jd< t ||¡ d S )NrÛ   )r   ç      à?r[   rÃ   r	   Zzoor[   r7   )r   r   rÊ   r&   r›   r'   r»   )r9   Úfloat_numpy_dtyper6   rH  r,   r-   r-   r.   Ú+test_loc_setitem_int_label_with_float_indexz  s    

zBTestLocBaseIndependent.test_loc_setitem_int_label_with_float_indexzindexer, expected)
rP   r[   r7   r`   rc   rd   ra   rb   rp   rf  )
r   r[   r7   r`   rP   rP   rP   rP   rp   rf  )
r   r[   r7   rP   rc   rP   ra   rb   rp   rf  c                 C   s\   t tdƒdd�}tdtdƒid|d�}d|j|j| df< t||dgdd�}t ||¡ d S )	Nr_   rá   ©r)  rµ   r  ©r6   r
   rP   rC  )r   rº   r   r&   r
   r'   r(   )r9   rÌ   r,   Útdir+   r-   r-   r.   Ú/test_loc_setitem_listlike_with_timedelta64index…  s    üzFTestLocBaseIndependent.test_loc_setitem_listlike_with_timedelta64indexc                 C   s®   t g d¢tdƒdœƒ}t g d¢tdƒdœƒ}tjtdd��T tddgd	dgd
�|jdd…d	f< tddgd	dgd
�|jdd…df< W d   ƒ n1 s”0    Y  t ||¡ d S )N©r[   r[   r[   r[   r[   ZaaaaarÐ   )r[   r"   r"   r[   r[   ZaabbarÓ   r¬   r"   r#   ©Ú
categoriesr[   r7   r`   )r   rÉ   r'   rÔ   rÕ   r   r&   r(   )r9   r+   rŒ   r-   r-   r.   Ú8test_loc_setitem_categorical_values_partial_column_sliceŸ  s    ÿ"@zOTestLocBaseIndependent.test_loc_setitem_categorical_values_partial_column_slicec                 C   sŽ   t dgdgdœƒ}t|d g d¢d�}||jd d …df< |d }t||jdd� |sXtnd¡}t ||¡ ||d< t |d t|dd	�¡ d S )
Nr#   r   )ÚAlphaZNumericrÞ  rÛ   rÛ  rÀ   ústring[pyarrow_numpy]rˆ   )	r   r   r&   r   r
   rÜ   rñ   r'   r»   )r9   Úusing_infer_stringr+   rÜ  r�   r,   r-   r-   r.   Ú'test_loc_setitem_single_row_categorical«  s    
ÿz>TestLocBaseIndependent.test_loc_setitem_single_row_categoricalc                 C   s¸   t dtdƒgd iƒ}t d¡|jdd…df< tdƒ|jd ksDJ ‚tdƒ|jd ksZJ ‚tjtd	d
��" tdddƒ|jd< W d   ƒ n1 s�0    Y  tdƒ ¡ |jd ks´J ‚d S )NrG   z
2010-10-01r`   z
2008-08-08r   r[   )r   rG   )r[   rG   r  r¬   iÕ  rd   )r7   rG   z
2005-05-05)	r   r   rv   r2  r&   r'   rÔ   rÕ   r   r8   r-   r-   r.   Ú"test_loc_setitem_datetime_coercion¾  s    0z9TestLocBaseIndependent.test_loc_setitem_datetime_coercionÚidxerÚvarc                 C   s’   |}t ddd|d�}td|dgd�}t|dgtjd�}tj|dkrFtnd d	d
��" ||jd d …|f< W d   ƒ n1 sx0    Y  t ||¡ d S )Nz
2015-07-12r`   r,  )rË  rÌ  r¬  ÚtzrØ   rä  ré   rC  r  r¬   )	r   r   rv   rÂ   r'   rÔ   rÕ   r&   r(   )r9   rã  Ztz_naive_fixturerå  rÈ  r,   r�   r-   r-   r.   Ú!test_loc_setitem_datetimeindex_tzÈ  s    ÿ0z8TestLocBaseIndependent.test_loc_setitem_datetimeindex_tzc           
      C   sl  t dddd�}ttj d¡ t|ƒdf¡|d�}tdd	d	ƒ}ttd
d	d	ƒtdd	d	ƒƒ}g d¢}g d¢}| 	¡ }d	|j
|< |j
| }|j
|  	¡ }	d	|	j
d d …< |r¬|	 t¡}	t ||	¡ | 	¡ }d	|j
|< |j| |j
|< t ||¡ | 	¡ }d	|j
|< |j
| }|j
|  	¡ }	d	|	j
d d …< |�r.|	 t¡}	t ||	¡ | 	¡ }d	|j
|< |j| |j
|< t ||¡ d S )Nz
2012-01-01z
2012-01-05Z30minr«  r7   rd   r	   ri  r   é   é   )é   éH   éx   é¨   )é   é   é   éJ   éK   éL   éz   é{   é|   éª   é«   é¬   )r   r   rv   r¸   r¹   rY  rã   r   r•   rÊ   r&   rÜ   rF  r'   r(   r›   )
r9   Zusing_array_managerr
   r+   ZakeyZbkeyZaindsZbindsr�   r,   r-   r-   r.   Útest_loc_setitem_time_keyØ  s@    ÿ







z0TestLocBaseIndependent.test_loc_setitem_time_keyrV   c                 C   s²   t  g d¢¡}tg d¢g d¢g|d�}| ¡ }tjddd�|jd d …|f< tg d¢g d	¢g|d�}t ||¡ |j	d
d�}tjddd�|jd d …|f< |j	d
d�}t ||¡ d S )N))r%   rc   )r}   Ú3)r%   r2   rz   ©rc   rd   ra   r‡   ©r7   r7   r  rÃ   )r   r7   r   )r   rd   r   r[   ry  )
r   Úfrom_tuplesr   rÊ   rv   Zzerosr&   r'   r(   r{  )r9   rV   r'  r+   rD   r,   r-   r-   r.   Ú,test_loc_setitem_unsorted_multiindex_columns   s    zCTestLocBaseIndependent.test_loc_setitem_unsorted_multiindex_columnsc                 C   s:   t g d¢|d�}d|jd< t g d¢|d�}t ||¡ d S )Nrz   rÃ   rc   r   )rc   r7   r`   ©r   r&   r'   r»   )r9   Zany_int_numpy_dtyper*   r,   r-   r-   r.   Útest_loc_setitem_uint_drop  s    
z1TestLocBaseIndependent.test_loc_setitem_uint_dropc                 C   sl   t dt dd¡g ƒ}t dd¡|jg d¢< t dt dd¡g ƒ}tt dd¡ƒ|jg d¢< t ||¡ d S )Nr_   r-  rP   rz   )r   rv   Útimedelta64r&   r   r'   r»   )r9   rH  r,   r-   r-   r.   Útest_loc_setitem_td64_non_nano  s
    z5TestLocBaseIndependent.test_loc_setitem_td64_non_nanoc                 C   s¢   t j d¡ d¡}ttdƒdd�}d}tjt|d�� ||j	tdƒ< W d   ƒ n1 sX0    Y  tjt|d�� ||j	d d …< W d   ƒ n1 s”0    Y  d S )Nr7   rü  rÂ   rÃ   r¢  r¬   )
rv   r¸   r¹   rY  r   rº   r’   r¯   r£  r&   )r9   r~   rH  r°   r-   r-   r.   Ú test_loc_setitem_2d_to_1d_raises  s    ,z7TestLocBaseIndependent.test_loc_setitem_2d_to_1d_raisesc                 C   sP   t jddd�}tg d¢g d¢g d¢g|g d¢d�}d	}|jd
 }t ||¡ d S )Nr   r`   )rË  rÌ  rz   rû  re  r«   ré   r[   )rÓ  r%   )r‚   Úinterval_ranger   r&   r'   Úassert_almost_equal)r9   r
   r+   r,   r�   r-   r-   r.   Útest_loc_getitem_interval_index+  s    ÿ
z6TestLocBaseIndependent.test_loc_getitem_interval_indexc                 C   sr   t jdddd�}tg d¢g d¢g d¢g|g d¢d	�}t jdd
ddd�}tddg|dd�}|jd }t ||¡ d S )Nr   r`   Zboth)rË  rÌ  Úclosedrz   rû  re  r«   ré   r7   r[   )rË  rÌ  r¬  r  rc   r%   rÀ   ©r[   r%   )r‚   r  r   r   r&   r'   r»   )r9   r
   r+   Z	index_expr,   r�   r-   r-   r.   Ú test_loc_getitem_interval_index26  s    ÿ
z7TestLocBaseIndependent.test_loc_getitem_interval_index2Útpl©r[   ©r[   r7   c                 C   sR   t ddgddd�}t|d�}|j|g }t |gddd�}t|d�}t ||¡ d S )Nr  r  r%   F©r‰   Ztupleize_colsr	   )r   r   r&   r'   r(   )r9   r
  rÈ  r+   r�   r,   r-   r-   r.   Ú+test_loc_getitem_index_single_double_tuplesB  s    ý

zBTestLocBaseIndependent.test_loc_getitem_index_single_double_tuplesc                 C   sn   t dddgƒ}|ddƒ}|ddƒ}t||gdd	d
�}tddg|ddgd�}|j|ddƒ d }|dksjJ ‚d S )NÚ	IndexTyper#   r"   r    r¡   r_  ZbofZcomposite_indexFr  r  )r`   rc   r%   r}   ré   r[   )r   r   r   r&   )r9   r  Zidx1Zidx2r
   r+   r�   r-   r-   r.   Ú!test_loc_getitem_index_namedtupleQ  s    

z8TestLocBaseIndependent.test_loc_getitem_index_namedtuplec                 C   s„   t tj d¡ d¡g d¢g d¢d�}d|d< tj|j|jd d d… df< ttjdtjdtjg|sdt	ndd	�j
}t |d j
|¡ d S )
Nr7   ©rd   r`   )r#   r"   rG   rà   rç   r^  ré   Úquxr3   rß  rÃ   )r   rv   r¸   r¹   rY  r�   r&   r
   r   rñ   r„   r'   r  )r9   rà  r+   r,   r-   r-   r.   Ú$test_loc_setitem_single_column_mixed[  s    ý
þz;TestLocBaseIndependent.test_loc_setitem_single_column_mixedc                 C   sž   t tj d¡ d¡tdƒd�}tj|d< tjtdd�� d|j	d	< W d   ƒ n1 sV0    Y  |j
}tt d
¡gd t d¡g g d¢d�}t ||¡ d S )Nr7   )rg   r`   ÚABCr‡   ÚeventrÓ   r¬   r    )r_   r  rÂ   r`   rñ   )r%   r}   rª   r  r	   )r   rv   r¸   r¹   Útupler�   r'   rÔ   rÕ   r&   ro  r   r6   r»   rœ   r-   r-   r.   Útest_loc_setitem_cast2i  s    
ÿ(þz-TestLocBaseIndependent.test_loc_setitem_cast2c                 C   sb   t dtjdtjd�iƒ}d|jd< |jjt tj¡ks:J ‚t d¡|_|jjt tj¡ks^J ‚d S )NÚonera   rÃ   )r[   r  rb   )r   rv   rw   Zint8r&   ro  r  r6   r8   r-   r-   r.   Útest_loc_setitem_cast3y  s
    
z-TestLocBaseIndependent.test_loc_setitem_cast3c                 C   sf   |t dƒg d¢d�}g d¢}|jdkr6dgdgdgg}||jt d	ƒ< |g d
¢|jd�}t ||¡ d S )Nrd   )r`   rc   r[   r   r7   r	   )rf  r_   rh  r7   rf  r_   rh  r`   )r   r[   r_   rf  rh  )rº   Úndimr&   r
   r'   r‹   )r9   r±  rD   r„   r,   r-   r-   r.   Útest_loc_setitem_range_key�  s    
z1TestLocBaseIndependent.test_loc_setitem_range_keyc                 C   s^   t g d¢g d¢dœƒ}tddgddgd�|jdd…df< t g d¢g d¢dœƒ}t ||¡ d S )	NrÚ  r¿   rÐ   r7   r[   rÛ  r#   )r[   r7   r7   r[   r[   ©r   r   r&   r'   r(   rx   r-   r-   r.   Ú.test_loc_setitem_numpy_frame_categorical_valueŽ  s    "zETestLocBaseIndependent.test_loc_setitem_numpy_frame_categorical_value)lr�   r�   r‘   rž   r’   r“   r”   r   r±   r²   r½   rÁ   rÍ   r×   rÞ   râ   rä   rå   rí   ró   rõ   rø   r  r  Úfixturer  rv   rš   r  r  r  r  r  r  r(  r3  rA  rI  rJ  rK  rU  rZ  r[  r]  Úfilterwarningsrb  r•   rd  r   r�   rl  rp  rr  rt  rw  r|  Zarm_slowr„  r†  rŠ  r�  r–  rš  r›  rŸ  r   r¡  r¤  r¥  r¦  r§  r’  r   r©  r´  rÂ   Úcomplexr¿  rÀ  rÂ  rÃ  rÅ  Úiterr   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—   ÿ   s`  þþóþ
#
'
$þ
	2



%ÿþý	
$þý	
"ÿýþý	þý	 ÿýØþ3
""
+



ÿ

ûþ



(



r—   c                   @   sZ   e Zd Zejejejgd�dd„ ƒZejdd„ ƒZ	dd„ Z
ej d¡d	d
„ ƒZdd„ ZdS )ÚTestLocWithEllipsis)Úparamsc                 C   s   |j S rj   )Úparam)r9   rC   r-   r-   r.   rÌ   ˜  s    zTestLocWithEllipsis.indexerc                 C   s   |}|t ur| ¡ }|S rj   )r   Úto_frame)r9   Úseries_with_simple_indexr±  rD   r-   r-   r.   rD   �  s    zTestLocWithEllipsis.objc                 C   s   ||ƒd }t  ||¡ d S )N.)r'   r‹   )r9   rD   rÌ   r�   r-   r-   r.   Útest_loc_iloc_getitem_ellipsis¤  s    z2TestLocWithEllipsis.test_loc_iloc_getitem_ellipsisú3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc           
      C   s*  |}|t ju st|ƒdkrdn|jd }|t ju rB|jjdkrBd S |t ju ržt|jtƒržd}tj	t
|d��" ||ƒd|gf }W d   ƒ qÖ1 s’0    Y  n8t|ƒdkrÖ||ƒd|gf }||ƒ|g }t  ||¡ |t ju rädn|j}| ¡ }	||	ƒd|gf }||	ƒd d …|gf }t  ||¡ d S )Nr   rþ   z2MultiIndex does not support indexing with Ellipsisr¬   .)r'   r›   rã   r
   r&   Úinferred_typerŠ   r   r’   r¯   ÚNotImplementedErrorr»   r‰   r%  r(   )
r9   r&  rÌ   rD   rV   r°   r�   r,   Úkey2r+   r-   r-   r.   Ú&test_loc_iloc_getitem_leading_ellipses¨  s"    $2z:TestLocWithEllipsis.test_loc_iloc_getitem_leading_ellipsesc                 C   s&  |t ju st|ƒdkrdn|jd }tjttd�� ||ƒd  W d   ƒ n1 sT0    Y  tjttd��$ ||ƒd|gdf  W d   ƒ n1 s–0    Y  tjttd��" ||ƒdd|f  W d   ƒ n1 sÖ0    Y  tjtdd��" ||ƒ|ddf  W d   ƒ n1 �s0    Y  d S )Nr   r¬   )...úToo many indexers)r'   r›   rã   r
   r’   r¯   r   r    )r9   rD   rÌ   rV   r-   r-   r.   Ú0test_loc_iloc_getitem_ellipses_only_one_ellipsisÁ  s    $*20zDTestLocWithEllipsis.test_loc_iloc_getitem_ellipses_only_one_ellipsisN)r�   r�   r‘   r’   r  r'   r&   r›   rÌ   rD   r'  r“   r  r,  r.  r-   r-   r-   r.   r"  —  s   



r"  c                   @   sœ  e Zd Zej dddgg d¢g d¢gfddgg d¢g d¢gfddgddgfg d¢g d¢gfddgddgfg d¢g d	¢gfddgddgfg d¢g d	¢gfddgddgfg d¢g d¢gfd
dgddgfg d¢g d¢gfg¡ej dddg¡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 d&ejejd'ejf¡d(d)„ ƒZd*d+„ Zej d,d-d.g¡d/d0„ ƒZd1d2„ Zd3d4„ Zd'S )5ÚTestLocWithMultiIndexzkeys, expectedr"   r#   )r"   r"   r#   r#   )r[   r7   r[   r7   )r#   r#   r"   r"   r[   r7   )r7   r[   r7   r[   rG   )rG   r#   r#   )r[   r7   r[   Údimr
   r5   c                 C   s’   |g d¢g d¢gi}t t d¡ dd¡fi |¤Ž}t |¡}|dkrf|j|d d …f }t |j	|¡ n(|dkrŽ|jd d …|f }t |j
|¡ d S )N)rG   r#   r#   r"   r"   )r[   r[   r7   r[   r7   é   rd   r
   r5   )r   rv   rw   Úreshaper   r%  r&   r'   Úassert_index_equalr
   r5   )r9   r0  Úkeysr,   Úkwargsr+   Ú	exp_indexr�   r-   r-   r.   Ú'test_loc_getitem_multilevel_index_orderÕ  s    
z=TestLocWithMultiIndex.test_loc_getitem_multilevel_index_orderc                 C   s    |}|j d }|d j d }|jj|jjdd … ks8J ‚|jj|jjdd … ksTJ ‚|j d }|d j d }|jj|jjd ks„J ‚|jj|jjd ksœJ ‚d S )NéÐ  r%   r[   )r8  r7   r7   )r&   r
   r  r‰   )r9   Z/multiindex_year_month_day_dataframe_random_dataZymdr�   Úresult2r-   r-   r.   Útest_loc_preserve_namesï  s    

z-TestLocWithMultiIndex.test_loc_preserve_namesc                 C   sf   t  dgddgg¡}td|d�}|jg  }|d d… }t ||¡ |j|jdd…  }t ||¡ d S )Nr   r[   r	   )r   Úfrom_productr   r&   r'   r»   r›   )r9   r'  rH  r�   r,   Zres2r-   r-   r.   Ú.test_loc_getitem_multiindex_nonunique_len_zeroü  s    
zDTestLocWithMultiIndex.test_loc_getitem_multiindex_nonunique_len_zeroc                 C   s¤   t d gt dgdgg¡ƒ}|jd }|d u s0J ‚t dgddgg¡}t d gt|ƒ t|d�}|jd }|d u srJ ‚t dgt|ƒ t|d�}|jd }|dks J ‚d S )	NÚLevel1ÚLevel2)r=  r>  ÚLevel2_aZLevel2_br×  )r=  r?  r[   )r   r   r%  r&   r;  rã   rñ   )r9   rH  r�   Zmidxr-   r-   r.   Ú0test_loc_getitem_access_none_value_in_multiindex	  s    


zFTestLocWithMultiIndex.test_loc_getitem_access_none_value_in_multiindexc                 C   s^   t jtg d¢g d¢ƒddgd�}tg d¢|d�}d|jd	d
…< tg d¢|d�}t ||¡ d S )N)r¡   r¡   r_  r_  r    r    r  r  )r  Útwor  rA  r  rA  r  rA  ÚfirstÚsecondr  )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»   )r9   r
   r�   r,   r-   r-   r.   Ú!test_loc_setitem_multiindex_slice  s    þûz7TestLocWithMultiIndex.test_loc_setitem_multiindex_slicec                 C   sJ   t dddd�}ttdƒ|ƒ}|jtdddƒtdddƒ… }t ||¡ d S )Nr  Z10minr~  ©r¬  rÌ  il  r[   i4  )r   r   rº   r&   r   r'   r»   )r9   ÚtimesrH  r�   r-   r-   r.   Ú7test_loc_getitem_slice_datetime_objs_with_datetimeindex,  s    zMTestLocWithMultiIndex.test_loc_getitem_slice_datetime_objs_with_datetimeindexc                 C   sh   t tdƒtdƒdœtddƒd�}|jddgddgf }t d	d
gd	d
gdœtddgƒd�}t ||¡ d S )Nr_   rÐ   z
2010-01-01z
2010-01-10r	   z
2010-01-05r#   r"   r   rc   )r   rº   r   r&   r   r'   r(   rœ   r-   r-   r.   Ú3test_loc_getitem_datetime_string_with_datetimeindex2  s    þ
þzITestLocWithMultiIndex.test_loc_getitem_datetime_string_with_datetimeindexc                 C   s    t jg d¢ddgd�}tddgddgd	d
gddgddgddgg|ddgd�}|jdd�}tddgddgddggddg| g d¢¡d�}|jd }t ||¡ d S )N)©r    r¡   rI  ©ZbahZbamrJ  rI  rJ  r%   r}   r  r  r[   rÇ   r7   r\   r`   ç      @rc   ç      @rd   ç      @ra   rª   r  ré   r   )Úlevel)r   r[   rc   ru   rI  )r   rý  r   r{  r�  r&   r'   r(   )r9   r'  r+   r,   r�   r-   r-   r.   Ú3test_loc_getitem_sorted_index_level_with_duplicates?  s*    ÷úö&ÿ
zITestLocWithMultiIndex.test_loc_getitem_sorted_index_level_with_duplicatesc                 C   s:   t g d¢dd�}d|jd< t g d¢dd�}t ||¡ d S )NrÛ   ÚcategoryrÃ   r   r`   )r#   r"   rG   r   rñ   rÿ  ©r9   r�   r,   r-   r-   r.   Ú1test_additional_element_to_categorical_series_loca  s    
zGTestLocWithMultiIndex.test_additional_element_to_categorical_series_locc                 C   s:   t g d¢dd�}d|jd< t g d¢dd�}t ||¡ d S )NrÛ   rP  rÃ   r#   r`   ©r#   r"   rG   r#   rÿ  rQ  r-   r-   r.   Ú'test_additional_categorical_element_loch  s    
z=TestLocWithMultiIndex.test_additional_categorical_element_locc                 C   s¢   t g d¢ttg d¢|d�ƒd�}tj|jd< t dddtjgttg d¢|d�ƒd�}t ||¡ tj|jd< t dtjdtjgttg d¢|d�ƒd�}t ||¡ d S )Nrz   rÃ   r`   r[   r7   )r   r   r   rv   r�   r&   r'   r»   )r9   Zany_numeric_ea_dtypeZsrsr,   r-   r-   r.   Ú&test_loc_set_nan_in_categorical_serieso  s     þþþz<TestLocWithMultiIndex.test_loc_set_nan_in_categorical_seriesÚnaNc                 C   sd   t g d¢dd�}||jd< t g d¢dd�}||jd< t ||¡ t ddd|gdd�}t ||¡ d S )	NrÛ   rP  rÃ   r`   rS  r#   r"   rG   rÿ  )r9   rV  Zsrs_enlargeZsrs_setintor,   r-   r-   r.   Ú,test_loc_consistency_series_enlarge_set_into„  s    

zBTestLocWithMultiIndex.test_loc_consistency_series_enlarge_set_intoc                 C   s¢   t t ddd¡ttddgƒtdƒgdgd dgd  tdƒgd	d
gd�d�}tddgddgdd	dd�}|jjd }t 	||¡ |j
dg jjd }t 	||¡ d S )Nr7   é   r#   r"   r_   r   rd   r[   ZIndex1ZIndex2)r&  Úcodesr  )r~   r
   FrP  )rÜ  Úorderedr‰   r6   )r   rv   rw   r   r   rº   r
   r&  r'   r3  r&   r¼   r-   r-   r.   Ú5test_loc_getitem_preserves_index_level_category_dtype‘  s&    ýþ	ûzKTestLocWithMultiIndex.test_loc_getitem_preserves_index_level_category_dtypeÚlt_valuerg   r_   c                 C   s|   t dg d¢itdƒg d¢gd�}tjtdd��: |j|d |k d d …f jdgd d …f  W d   ƒ n1 sn0    Y  d S )	Nr#   )ri  é   é"   é-   Úaabb©r   r[   r7   r`   r	   z\['b'\] not in indexr¬   r"   )r   rÉ   r’   r¯   rA   r&   )r9   r\  r+   r-   r-   r.   Ú>test_loc_multiindex_levels_contain_values_not_in_index_anymoreª  s     zTTestLocWithMultiIndex.test_loc_multiindex_levels_contain_values_not_in_index_anymorec                 C   sl   t  t jt jg¡}ddg}t ||g¡}tddg|d�}|jd d …df }tdgt jgd�}t ||¡ d S )Nr¡   r_  r   r[   r	   )	rv   rš   r�   r   r%  r   r&   r'   r»   )r9   Úlev1Úlev2r'  rH  r�   r,   r-   r-   r.   Ú'test_loc_multiindex_null_slice_na_level±  s    z=TestLocWithMultiIndex.test_loc_multiindex_null_slice_na_levelc                 C   sr   t jtdƒtdƒddggg d¢d�}ttdƒ|d�}|jd	d d …d d …f }|j d
¡d d… }t 	|j|¡ d S )NÚabÚxyr[   r7   )rf  rg  Únumr  rp   r	   r#   r   rc   )
r   r;  rÉ   r   rº   r&   r
   Z	droplevelr'   r3  )r9   r'  rH  Z
loc_resultr,   r-   r-   r.   Útest_loc_drops_level½  s    ÿz*TestLocWithMultiIndex.test_loc_drops_level)r�   r�   r‘   r’   r“   r”   r7  r:  r<  r@  rD  rG  rH  rO  rR  rT  rU  rv   r�   r‚   ZNArƒ   rW  r[  rb  re  ri  r-   r-   r-   r.   r/  Ô  s<   ùþ"

r/  c                   @   sÀ   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	d
„ Zej	j
ddd„ dd„ dd„ dd„ gg d¢d�dd„ ƒZdd„ Zdd„ Zdd„ Zdd„ Zej	 d¡dd„ ƒZej	 
d g d!¢¡d"d#„ ƒZd$d%„ Zd&S )'ÚTestLocSetitemWithExpansionc                 C   s€   d}|  ¡ �< | td|¡ tdt|ƒidd�}||j|< W d   ƒ n1 sN0    Y  tdt|d ƒidd�}t ||¡ d S )Né2   Z_SIZE_CUTOFFrµ   r  rÃ   r[   )ÚcontextÚsetattrÚlibindexr   rº   r&   r'   r(   )r9   ZmonkeypatchZsize_cutoffr�   r,   r-   r-   r.   Ú/test_loc_setitem_with_expansion_large_dataframeË  s    
(zKTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_large_dataframec                 C   sV   t td�}d|jd< t |t dgdgd�¡ d|jd< t |t ddgddgd�¡ d S )NrÃ   r[   r	   r`   ©r   rñ   r&   r'   r»   ©r9   rH  r-   r-   r.   Útest_loc_setitem_empty_seriesÕ  s
    


z9TestLocSetitemWithExpansion.test_loc_setitem_empty_seriesc                 C   sV   t td�}d|jd< t |t dgdgd�¡ d|jd< t |t ddgddgd�¡ d S )NrÃ   r  r[   r	   r\   r`   rp  rq  r-   r-   r.   Ú#test_loc_setitem_empty_series_floatß  s
    


z?TestLocSetitemWithExpansion.test_loc_setitem_empty_series_floatc              	   C   s”   t td�}d|jd< t |t dgtdgtd�d�¡ d|jd< t |t ddgtddgtd�d�¡ d|jd< t |t g d¢tg d	¢td�d�¡ d S )
NrÃ   r[   r    r	   r`   r¡   rc   )r[   r`   rc   )r    r¡   r`   )r   rñ   r&   r'   r»   r   rq  r-   r-   r.   Ú%test_loc_setitem_empty_series_str_idxé  s    

 
ÿ
ÿzATestLocSetitemWithExpansion.test_loc_setitem_empty_series_str_idxc                    sn   t dddtdƒd�‰ ‡ fdd„tdƒD ƒ}td	g|d	 gd
�}|D ]}d|j|< qBtd|d
�}t ||¡ d S )Nr§   rh  r[   ú
US/Pacific)Útzinfoc                    s   g | ]}ˆ t |d  d� ‘qS )r}  )Úseconds)r   rO  ©Úbaser-   r.   r¶   ü  r·   zUTestLocSetitemWithExpansion.test_loc_setitem_incremental_with_dst.<locals>.<listcomp>é   r   r	   )r   r   rº   r   r&   r'   r»   )r9   Zidxsr�   rN   r,   r-   rx  r.   Ú%test_loc_setitem_incremental_with_dstù  s    zATestLocSetitemWithExpansion.test_loc_setitem_incremental_with_dstÚconvc                 C   s   | S rj   r-   rü   r-   r-   r.   rý     r·   z$TestLocSetitemWithExpansion.<lambda>c                 C   s   |   ¡ S rj   )Úto_datetime64rü   r-   r-   r.   rý     r·   c                 C   s   |   ¡ S rj   )Úto_pydatetimerü   r-   r-   r.   rý     r·   c                 C   s
   t  | ¡S rj   )rv   r2  rü   r-   r-   r.   rý   	  r·   )r9   r}  r~  znp.datetime64)Úidsc                 C   sn   t dƒ}t dƒ}tƒ }d|j||ƒdf< d|j||ƒdf< tdddgi||gtdgtd�d	�}t ||¡ d S )
Nz20130101 09:00:00z20130101 10:00:00rÎ   r  rr   g      Y@g      i@rÃ   ré   )r   r   r&   r   rñ   r'   r(   )r9   r|  Zdt1Zdt2r+   r,   r-   r-   r.   Ú#test_loc_setitem_datetime_keys_cast  s    
ýz?TestLocSetitemWithExpansion.test_loc_setitem_datetime_keys_castc                 C   sT   t ddgiƒ}tdg|d�|jd d …df< t dgtdg|d�dœƒ}t ||¡ d S )Nr%   r[   r"   )rZ  r}   r€   r  )r9   rZ  r�   r,   r-   r-   r.   Ú1test_loc_setitem_categorical_column_retains_dtype  s    zMTestLocSetitemWithExpansion.test_loc_setitem_categorical_column_retains_dtypec                 C   sœ   t ddd�}t ddd�}t ddd�}t||ddd�}||vs@J ‚t|d	gd
�}d|j|d	f< ttjgt|ƒ dg | t|gƒ¡d	gt	d�}t
 ||¡ d S )Nz2017-10-29 00:00:00+0200zEurope/Madrid©rå  z2017-10-29 03:00:00+0100z2016-10-10 03:00:00Úleftr,  )Z	inclusiver¬  rô   ré   ri  rC  )r   r   r   r&   rv   r�   rã   Úappendr   rñ   r'   r(   )r9   rË  ÚendrN   rÈ  r�   r,   r-   r-   r.   Ú0test_loc_setitem_with_expansion_and_existing_dst#  s    üzLTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_and_existing_dstc                 C   sì   t tddgƒdgd�}ddg|d< | d¡j d¡|_||jdk  d¡j d	¡}| ¡ }||j	|jdkdf< t
|d
  d¡|j	d gdd�}t |j|¡ |j	|jdkdf tdƒ }||j	|jdkdf< t |j	|jdkdf |¡ d S )Nz2015-03-30 20:12:32z2015-03-12 00:11:11r   )r~   r5   ÚnewÚoldÚnew_colrm  ru  r   )r[   r   rˆ   Z1s)r   r   r®   r
   rn  r   r‰  Z
tz_convertrÊ   r&   r   r'   r»   r   )r9   r+   Úvr…   r,   r-   r-   r.   Útest_setitem_with_expansion5  s    
þ z7TestLocSetitemWithExpansion.test_setitem_with_expansionc                 C   sV   t ƒ }d|jd< d|jd< d|jdtjf< |j}tddtjgtjd�}t ||¡ d S )Nr[   rX  r7   )r[   r[   r`   r   rÃ   )	r   r&   rv   Úinfr5   r   rÂ   r'   r3  rœ   r-   r-   r.   Ú0test_loc_setitem_with_expansion_inf_upcast_emptyK  s    

zLTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_inf_upcast_emptyz"ignore:indexing past lexsort depthc                 C   sf  t |ƒst d¡ | d¡}t |ƒ}t |¡ tj¡}t||dgd�}d}||vsVJ ‚| 	t |ƒ|¡}t
|tƒr†|d d |ks–J ‚n|d |ks–J ‚t |d ¡ tj¡}t||dgd�}| ¡ }	||	j|df< t |	|¡ | ¡ d }
||
j|< |d  tj¡}t |
|¡ | ¡ }	||	j|df< tt|ƒtjg tjg| t|ƒg dœ|d	�}t |	|¡ d S )
NzNot relevant for empty Indexr7   r   ré   Zkapowrî   r[   ©r   r[   r	   )rã   r’   ÚskipÚrepeatrv   rw   rÜ   r  r   ÚinsertrŠ   r   rÂ   rÊ   r&   r'   r(   r»   rÉ   r�   rF  )r9   r
   ÚNÚarrÚorigrV   r6  Zexp_datar,   r+   rH  r-   r-   r.   Ú/test_loc_setitem_with_expansion_nonunique_indexV  s8    



&þzKTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_nonunique_indexr6   )ZInt32ÚInt64ZUInt32ZUInt64ZFloat32ZFloat64c                 C   sz   t g d¢|d�}td|iƒ}t|jd�}||j|jdf< tj||dd� t|jd�}|j|j|jdf< tj||dd� d S )Nra  rÃ   r~   r	   F©r‰  )r   r   r
   r&   r'   r(   rŒ  )r9   r6   rH  r+   r�   r-   r-   r.   Ú6test_loc_setitem_with_expansion_preserves_nullable_int„  s    zRTestLocSetitemWithExpansion.test_loc_setitem_with_expansion_preserves_nullable_intc                 C   s‚   t dtdƒiƒ}tdddd�}||jg d¢df< | ttjtjg|jd	�¡}t tdƒ|d
œƒ}|j	d |jksrJ ‚t
 ||¡ d S )Nr%   rd   ú
2016-01-01r`   ru  ©rÌ  rå  rZ   r}   rÃ   r€   )r   rº   r   r&   r„  r   r‚   rƒ   r6   ro  r'   r(   )r9   r+   r
  Zbexr,   r-   r-   r.   Ú#test_loc_setitem_ea_not_full_column•  s    z?TestLocSetitemWithExpansion.test_loc_setitem_ea_not_full_columnN)r�   r�   r‘   ro  rr  rs  rt  r{  r’   r“   r”   r€  r�  r†  r‹  r�  r  r•  r˜  r›  r-   r-   r-   r.   rj  Ê  s4   



üø



-ÿ
rj  c                   @   s,   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	S )
ÚTestLocCallablec                 C   sz  t g d¢tdƒg d¢dœƒ}|jdd„  }t ||j|jdk ¡ |jdd„ d d …f }t ||j|jdkd d …f ¡ |jd	d„ d
d„ f }t ||j|jdkg d¢f ¡ |jdd„ dd„ f }t ||j|jdkdf ¡ |jdd„ dd„ f }t ||j|jdkddgf ¡ |jdd„ dd„ f }t ||j|jdkddgf ¡ |jdd„ dd„ f }||jd k�svJ ‚d S )N©r[   r7   r`   rc   r`  r«   c                 S   s
   | j dkS ©Nr7   ©r%   rü   r-   r-   r.   rý   ª  r·   zATestLocCallable.test_frame_loc_getitem_callable.<locals>.<lambda>r7   c                 S   s
   | j dkS )Nr"   )r}   rü   r-   r-   r.   rý   ­  r·   r"   c                 S   s
   | j dkS rž  rŸ  rü   r-   r-   r.   rý   °  r·   c                 S   s
   | j dkS ©Nr}   r‡   rü   r-   r-   r.   rý   °  r·   )FTFc                 S   s
   | j dkS rž  rŸ  rü   r-   r-   r.   rý   ³  r·   c                 S   s   dS r   r-   rü   r-   r-   r.   rý   ³  r·   r}   c                 S   s
   | j dkS rž  rŸ  rü   r-   r-   r.   rý   ¶  r·   c                 S   s   ddgS ©Nr%   r}   r-   rü   r-   r-   r.   rý   ¶  r·   r%   c                 S   s
   | j dkS rž  rŸ  rü   r-   r-   r.   rý   ¹  r·   c                 S   s   ddgS r¡  r-   rü   r-   r-   r.   rý   ¹  r·   c                 S   s   dS )Nr[   r-   rü   r-   r-   r.   rý   ½  r·   c                 S   s   dS r$   r-   rü   r-   r-   r.   rý   ½  r·   r  )r   rÉ   r&   r'   r(   r%   r}   r»   ©r9   r+   r�   r-   r-   r.   Útest_frame_loc_getitem_callable¤  s        z/TestLocCallable.test_frame_loc_getitem_callablec                 C   s¶   t g d¢tdƒg d¢dœƒ}|jdd„ ddgf }t ||j|jdkddgf ¡ |jdd	gd
d„ f }t ||jdd	gddgf ¡ |jd	dd„ f }t ||jd	ddgf ¡ d S )Nr�  r`  r«   c                 S   s
   | j dkS rž  rŸ  rü   r-   r-   r.   rý   Ä  r·   zITestLocCallable.test_frame_loc_getitem_callable_mixture.<locals>.<lambda>r%   r}   r7   r`   c                 S   s   ddgS r¡  r-   rü   r-   r-   r.   rý   Ç  r·   c                 S   s   ddgS r¡  r-   rü   r-   r-   r.   rý   Ê  r·   )r   rÉ   r&   r'   r(   r%   r»   r¢  r-   r-   r.   Ú'test_frame_loc_getitem_callable_mixtureÀ  s     z7TestLocCallable.test_frame_loc_getitem_callable_mixturec                 C   sš  t g d¢tdƒdœtdƒd�}|jdd„  }t ||jdd	g ¡ |jd
d„ d d …f }t ||jdd	gd d …f ¡ |jdd„ dd„ f }t ||jdd	gdf ¡ |jdd„ dd„ f }t ||jdd	gdgf ¡ |jdd	gdd„ f }t ||jdd	gdf ¡ |jdd	gdd„ f }t ||jdd	gdgf ¡ |jdd„ df }t ||jdd	gdf ¡ |jdd„ dgf }t ||jdd	gdgf ¡ d S )Nr�  r`  ©ÚXr*  rW  r	   c                 S   s   ddgS ©Nr%   rª   r-   rü   r-   r-   r.   rý   Ò  r·   zHTestLocCallable.test_frame_loc_getitem_callable_labels.<locals>.<lambda>r%   rª   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   Õ  r·   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   Ø  r·   c                 S   s   dS ©Nr¦  r-   rü   r-   r-   r.   rý   Ø  r·   r¦  c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   Û  r·   c                 S   s   dgS r¨  r-   rü   r-   r-   r.   rý   Û  r·   c                 S   s   dS r¨  r-   rü   r-   r-   r.   rý   ß  r·   c                 S   s   dgS r¨  r-   rü   r-   r-   r.   rý   â  r·   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   å  r·   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   è  r·   )r   rÉ   r&   r'   r(   r»   r¢  r-   r-   r.   Ú&test_frame_loc_getitem_callable_labelsÍ  s"    z6TestLocCallable.test_frame_loc_getitem_callable_labelsc                 C   s^  t g d¢ttdƒtd�dœtdƒd�}| ¡ }d|jdd	„ < | ¡ }d|jd
dg< t ||¡ | ¡ }d|jdd	„ d d …f< | ¡ }d|jd
dgd d …f< t ||¡ | ¡ }d|jdd	„ dd	„ f< | ¡ }d|jd
dgdf< t ||¡ | ¡ }ddg|jdd	„ dd	„ f< | ¡ }ddg|jd
dgdgf< t ||¡ | ¡ }t 	ddg¡|jd
dgdd	„ f< | ¡ }t 	ddg¡|jd
dgdf< t ||¡ | ¡ }d|jd
dgdd	„ f< | ¡ }d|jd
dgdgf< t ||¡ | ¡ }d|jdd	„ df< | ¡ }d|jd
dgdf< t ||¡ | ¡ }d|jdd	„ dgf< | ¡ }d|jd
dgdgf< t ||¡ d S )Nr�  r`  rÃ   r¥  rW  r	   iìÿÿÿc                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   ô  r·   zATestLocCallable.test_frame_loc_setitem_callable.<locals>.<lambda>r%   rª   rP   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   ú  r·   rî   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý    	  r·   c                 S   s   dS r¨  r-   rü   r-   r-   r.   rý    	  r·   r¦  rd   r_   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   	  r·   c                 S   s   dgS r¨  r-   rü   r-   r-   r.   rý   	  r·   rï   c                 S   s   dS r¨  r-   rü   r-   r-   r.   rý   	  r·   c                 S   s   dgS r¨  r-   rü   r-   r-   r.   rý   	  r·   c                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   	  r·   éüÿÿÿc                 S   s   ddgS r§  r-   rü   r-   r-   r.   rý   	  r·   )
r   r   rÉ   rñ   rÊ   r&   r'   r(   rv   rš   )r9   r+   r�   rŒ   r-   r-   r.   Útest_frame_loc_setitem_callableë  sX    þ z/TestLocCallable.test_frame_loc_setitem_callableN)r�   r�   r‘   r£  r¤  r©  r«  r-   r-   r-   r.   rœ  £  s   rœ  c                   @   sF   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zej 	d	d
dg¡dd„ ƒZ
d
S )ÚTestPartialStringSlicingc                 C   s^   t g d¢g d¢dœtg d¢ƒd�}t ddgdd	gdœtd
dgƒd�}|jd }t ||¡ d S )NrÛ   rz   )rs   rt   )ú
2020-08-01z
2020-07-02ú
2020-08-05r	   r#   rG   r[   r`   r­  r®  z2020-08)r   r   r&   r'   r(   r¼   r-   r-   r.   Ú5test_loc_getitem_partial_string_slicing_datetimeindex&	  s    
þ
þ
zNTestPartialStringSlicing.test_loc_getitem_partial_string_slicing_datetimeindexc                 C   sD   t jdddd�}| ¡ }|jd d… }|jd d… }t ||¡ d S )Nú
2017-01-01ú
2018-01-01r+  ©rË  r…  r¬  z2017-12rî   )r‚   Úperiod_rangeÚ	to_seriesr&   r›   r'   r»   )r9   ÚpirH  r�   r,   r-   r-   r.   Ú8test_loc_getitem_partial_string_slicing_with_periodindex3	  s
    zQTestPartialStringSlicing.test_loc_getitem_partial_string_slicing_with_periodindexc                 C   sB   t dddd�}| ¡ }|jd d… }|jd d… }t ||¡ d S )Nú1 dayú2 daysÚ1hr²  z1 daysrî   )r   r´  r&   r›   r'   r»   )r9   rÖ   rH  r�   r,   r-   r-   r.   Ú;test_loc_getitem_partial_string_slicing_with_timedeltaindex;	  s
    zTTestPartialStringSlicing.test_loc_getitem_partial_string_slicing_with_timedeltaindexc                 C   sD   t dtdƒittdƒdd�d�}|jd }|jd }t ||¡ d S )Nrµ   r`   ÚdaysrÖ  r	   r   ú0 days)r   rº   r   r›   r&   r'   r»   )r9   r+   r,   Zslicedr-   r-   r.   Ú#test_loc_getitem_str_timedeltaindexC	  s     

z<TestPartialStringSlicing.test_loc_getitem_str_timedeltaindexÚindexer_endNú2020-01-02 23:59:59.999999999c              	   C   s–   |dgd t tdƒtdƒtdƒtdƒtdƒg|d�d	�}|dgd
 t tdƒtdƒg|d�d	�}td|ƒ}|| }t ||¡ |j| }t ||¡ d S )Nr[   rd   z
2019-12-30z
2020-01-01z
2019-12-25r¿  z
2019-12-19r‚  r	   r7   )r   r   r•   r'   r‹   r&   )r9   Ztz_aware_fixturer¾  r±  rD   r,   rÌ   r�   r-   r-   r.   Ú/test_loc_getitem_partial_slice_non_monotonicityJ	  s4    ûøþþûþ


zHTestPartialStringSlicing.test_loc_getitem_partial_slice_non_monotonicity)r�   r�   r‘   r¯  r¶  rº  r½  r’   r“   r”   rÀ  r-   r-   r-   r.   r¬  %	  s   r¬  c                
   @   sø   e Zd Zdd„ Zdd„ Zej dej	dddd	�e
d
ddd	�g¡dd„ ƒZdd„ Zdd„ Zej de dd¡deddƒge dd¡e dd¡eddƒgde dd¡eddƒgg¡dd„ ƒZej d d!d"g¡d#d$„ ƒZej d%dd&g¡d'd(„ ƒZd)d*„ ZdS )+ÚTestLabelSlicingc                 C   s  t tjddd�dd„ dD ƒd�}t tjddd�d	d„ d
D ƒd�}||fD ]Æ}|jtddddƒd … }t ||¡ |jd tddddƒ… }t ||¡ |jtddddƒtddddƒ… }t ||¡ |jtddddƒd … }|jdd … }t ||¡ |jdd … }t ||¡ qHd S )NrK  rÂ   rÃ   c                 S   s   g | ]}t d d|ddƒ‘qS ©éÑ  r[   r_   r   ©r   rO  r-   r-   r.   r¶   v	  r·   zMTestLabelSlicing.test_loc_getitem_slicing_datetimes_frame.<locals>.<listcomp>r�  r	   rL  c                 S   s   g | ]}t d d|ddƒ‘qS rÂ  rÄ  rO  r-   r-   r.   r¶   |	  r·   )r[   r7   r7   r`   rc   rÃ  r[   r_   rc   rh  z20010101 11)r   rv   rw   r&   r   r'   r(   r›   )r9   Z	df_uniqueZdf_dupsr+   r�   r,   r-   r-   r.   Ú(test_loc_getitem_slicing_datetimes_framep	  s(    þþ"z9TestLabelSlicing.test_loc_getitem_slicing_datetimes_framec                 C   s†   t ddddd�}tg d¢|d�}tddd	�}td
dd	�}|j||… }tddg|dd… d�}t ||¡ || }d}||ks‚J ‚d S )Nz2017-10-29 01:30:00zEurope/Berlinrd   z30 min)rå  rÌ  r¬  )r   r[   r7   r`   rc   r	   z2017-10-29 02:30:00+02:00r‚  z2017-10-29 02:00:00+01:00r7   r`   rc   )r   r   r   r&   r'   r»   )r9   rÈ  Zseries2Zt_1Zt_2r�   r,   r-   r-   r.   Ú'test_loc_getitem_label_slice_across_dst�	  s    ÿz8TestLabelSlicing.test_loc_getitem_label_slice_across_dstr
   r°  r±  r+  r²  r·  r¸  r¹  c                 C   s8   |  ¡ }|jd |d … }|jd d… }t ||¡ d S )Nrï   rî   )r´  r&   r›   r'   r»   )r9   r
   rH  r�   r,   r-   r-   r.   Ú-test_loc_getitem_label_slice_period_timedeltaž	  s    z>TestLabelSlicing.test_loc_getitem_label_slice_period_timedeltac                 C   s€   g d¢}t tj d¡ d¡|d�}|jdd… }t|ƒdks@J ‚|jdd… }t|ƒdks^J ‚|jdd… }t|ƒd	ks|J ‚d S )
N)gæx"p|é@g\Va³‰|é@g‹ßÖË|é@r7   ©r`   r7   r	   g3333c|é@g    �|é@g3333“|é@gÍÌÌÌÜ|é@r`   )r   rv   r¸   r¹   r&   rã   )r9   r
   r+   Ús1r-   r-   r.   Ú%test_loc_getitem_slice_floats_inexact¬	  s    z6TestLabelSlicing.test_loc_getitem_slice_floats_inexactc                 C   s´   |}t tj d¡ d¡tjdd|d�d�}t|jdd … ƒdksDJ ‚t|jdd … ƒd	ks^J ‚tjdd|d�}d
|d< ||_t|jdd … ƒdks–J ‚t|jdd … ƒd	ks°J ‚d S )Nr7   r_   rP   rÃ   r	   r$  rp   g      )@rb   gffffff(@)r   rv   r¸   r¹   rw   rã   r&   r
   )r9   rÔ  r6   rH  rÈ  r-   r-   r.   Ú'test_loc_getitem_float_slice_floatindex¹	  s    ÿz8TestLabelSlicing.test_loc_getitem_float_slice_floatindexzstart,stop, expected_slicer   ÚnsNrh  r[   r  ra   rb   rc   rd   c                 C   s>   t tdƒtddƒƒ}|jt||ƒ }|j| }t ||¡ d S )Nrh  r¼  z10 days)r   rº   r   r&   r•   r›   r'   r»   )r9   rË  ÚstopZexpected_slicerH  r�   r,   r-   r-   r.   Ú$test_loc_getitem_slice_label_td64objÈ	  s    

z5TestLabelSlicing.test_loc_getitem_slice_label_td64objrË  Z2018Z2020c                 C   sb   |g d¢t dƒt dƒt dƒgd�}tjtdd�� |j|d…  W d   ƒ n1 sT0    Y  d S )	Nrz   Z2016Z2019Z2017r	   z,Value based partial slicing on non-monotonicr¬   r˜   )r   r’   r¯   rA   r&   )r9   r±  rË  rD   r-   r-   r.   Ú)test_loc_getitem_slice_unordered_dt_index×	  s    þÿz:TestLabelSlicing.test_loc_getitem_slice_unordered_dt_indexrô   rÄ  c                 C   sN   |t dƒ|dddgd�}|j|d… }|t dƒ|dddgd�}t ||¡ d S )Nrc   rB  r7   Úthirdr	   )rº   r&   r'   r‹   )r9   r±  rô   rD   r�   r,   r-   r-   r.   Ú1test_loc_getitem_slice_labels_int_in_object_indexâ	  s    zBTestLabelSlicing.test_loc_getitem_slice_labels_int_in_object_indexc                 C   sZ   t ddddœdgd�}t ddggdgtddgtd�d�}t |jd d …dd …f |¡ d S )	Nr[   r7   r`   )Útestr[   r7   r   r	   rÃ   )r~   r
   r5   )r   r   rñ   r'   r(   r&   rx   r-   r-   r.   Ú*test_loc_getitem_slice_columns_mixed_dtypeê	  s
    ÿz;TestLabelSlicing.test_loc_getitem_slice_columns_mixed_dtype)r�   r�   r‘   rÅ  rÆ  r’   r“   r”   r‚   r³  r   rÇ  rÊ  rË  rv   r  r•   rÎ  rÏ  rÑ  rÓ  r-   r-   r-   r.   rÁ  o	  s0   þþ
ýþ



rÁ  c                   @   sH   e Zd Zej dddg¡dd„ ƒZej dddg¡dd„ ƒZdd	„ Zd
S )ÚTestLocBooleanLabelsAndSlicesÚ
bool_valueTFc                 C   s\   |› d�}|j dkrX||dd�}tjt|d�� |j|  W d   ƒ n1 sN0    Y  d S )Nz7: boolean label can not be used without a boolean indexrþ   rñ   r  r¬   )r)  r’   r¯   rA   r&   )r9   r
   r±  rÕ  ÚmessagerD   r-   r-   r.   Ú'test_loc_bool_incompatible_index_raisesô	  s
    

zETestLocBooleanLabelsAndSlices.test_loc_bool_incompatible_index_raisesc                 C   s&   |t ddgdd�dd�}|j|  d S )NTFrþ   rÃ   rñ   r  )r   r&   )r9   r±  rÕ  rD   r-   r-   r.   Útest_loc_bool_should_not_raiseÿ	  s    ÿz<TestLocBooleanLabelsAndSlices.test_loc_bool_should_not_raisec                 C   sP   d}||dd�}t jt|d�� |jdd…  W d   ƒ n1 sB0    Y  d S )NzEslice\(True, False, None\): boolean values can not be used in a slicerñ   r  r¬   TF)r’   r¯   r–   r&   )r9   r
   r±  rÖ  rD   r-   r-   r.   Útest_loc_bool_slice_raises
  s
    ÿz8TestLocBooleanLabelsAndSlices.test_loc_bool_slice_raisesN)	r�   r�   r‘   r’   r“   r”   r×  rØ  rÙ  r-   r-   r-   r.   rÔ  ó	  s
   


rÔ  c                   @   sl   e Zd Zdd„ Zej dddg¡dd„ ƒZdd	„ Zd
d„ Z	e
jdd„ ƒZdd„ Zdd„ Zdd„ Zdd„ ZdS )ÚTestLocBooleanMaskc                 C   s²   t dtdƒiƒ}ttdƒdd�|_|d dk|d dk|d dk g}g d¢g d¢g d¢g}t||ƒD ]H\}}| ¡ }d|j|df< t |ttdƒdd�dgd	d
�}t ||¡ qdd S )Nrµ   r_   rá   rÖ  r`   )
r   r[   r7   r`   r_   r_   r_   r_   r_   r_   )
r   r[   r7   r_   rc   rd   ra   rb   rp   rf  )
r_   r_   r_   r`   rc   rd   ra   rb   rp   rf  r  rC  )	r   rº   r   r
   r“  rÊ   r&   r'   r(   )r9   r+   Z
conditionsÚexpected_dataZcondr~   r�   r,   r-   r-   r.   Ú)test_loc_setitem_bool_mask_timedeltaindex
  s"    "ýüz<TestLocBooleanMask.test_loc_setitem_bool_mask_timedeltaindexrå  Nrm  c                 C   s”   t  g d¢¡}tdd|d�}tdt  d¡i|d� d¡}| ¡ }|j|d d …f |j|d d …f< t 	||¡ | ¡ }|j| |j|< t 	||¡ d S )Nrm   Z20010101rc   rš  r#   r	   rÂ   )
rv   rš   r   r   rw   rÜ   rÊ   r&   r'   r(   )r9   rå  r   rÈ  r+   r�   r-   r-   r.   Ú+test_loc_setitem_mask_with_datetimeindex_tz'
  s     z>TestLocBooleanMask.test_loc_setitem_mask_with_datetimeindex_tzc                 C   s~   t t d¡ dd¡tdƒtdddd�d�}| ¡ }|jd	 gtj	tj	g |d
< |j
dk }|j| j|j|d
f< t ||¡ d S )NrM  r`   r7   ZABrª  r¹  )rÌ  r¬  ru   r   rª   r[   )r   rv   rw   r2  rÉ   r   rÊ   r
   r‚   rƒ   r%   r&   r'   r(   )r9   r+   r,   r   r-   r-   r.   Ú2test_loc_setitem_mask_and_label_with_datetimeindex8
  s    ý
zETestLocBooleanMask.test_loc_setitem_mask_and_label_with_datetimeindexc                 C   s€   t dƒ}t dƒ}tdt||gƒiƒ}| ¡ }t|gƒ}|d jd j}||jddg< |d jd j}||kspJ ‚t ||¡ d S )Nr   l   ,GsO1Úcolr[   TF)	r   r   r   rÊ   r›   Ú_valuer&   r'   r(   )r9   Ztd1Ztd2r+   Zdf_copyrH  r,   r�   r-   r-   r.   Ú'test_loc_setitem_mask_td64_series_valueG
  s    
z:TestLocBooleanMask.test_loc_setitem_mask_td64_series_valuec                 C   s\   |  ¡ }|d dk}d|j|df< |j  ¡ }d||jdf< t||j|jd�}t ||¡ d S )Nr%   r   r}   r[   ré   )rÊ   r&   r„   r   r
   r5   r'   r(   )r9   rÇ  r,   r   r„   r-   r-   r.   Ú#test_loc_setitem_boolean_and_columnV
  s    
z6TestLocBooleanMask.test_loc_setitem_boolean_and_columnc                 C   s~  t g d¢g d¢dœƒ}t dg d¢ig d¢d�|jg d¢dgf< t g d	¢g d¢dœƒ}t ||¡ t g d¢g d¢dœƒ}tg d
¢g d¢d�|jg d¢dgf< t ||¡ t g d¢g d¢dœƒ}tg d
¢g d¢d�|jg d¢df< t ||¡ t g d¢g d¢dœƒ}| ¡ }|d }t |¡�. tg d
¢g d¢d�|jg d¢< W d   ƒ n1 �sP0    Y  |�rnt ||¡ nt ||¡ d S )Nrz   rû  rÐ   r#   r©   )r7   r[   r   r	   )FFT)r[   r7   r_   rg  )r   r&   r'   r(   r   rÊ   r�  )r9   rŽ  r`  r+   r,   rË   rH  r-   r-   r.   Ú)test_loc_setitem_ndframe_values_alignmentb
  s(    ÿ$">z<TestLocBooleanMask.test_loc_setitem_ndframe_values_alignmentc                 C   sN   t g g dœtd�}| ¡ }|d  ¡ |jtjg tjd�dgf< t ||¡ d S )NrÐ   rÃ   r#   ©	r   rñ   rÊ   r&   rv   rš   Zbool_r'   r(   rx   r-   r-   r.   Ú test_loc_indexer_empty_broadcast‚
  s    $z3TestLocBooleanMask.test_loc_indexer_empty_broadcastc                 C   sT   t dgdgdœtd�}| ¡ }|d  ¡ |jtjdgtjd�dgf< t ||¡ d S )Nrµ   r  rÐ   rÃ   r"   Fr#   rä  rx   r-   r-   r.   Ú$test_loc_indexer_all_false_broadcast‰
  s    &z7TestLocBooleanMask.test_loc_indexer_all_false_broadcastc                 C   sb   t dgdgdœtd�}t dgdgdœtd�}|d  ¡ |jtjdgtjd�dgf< t ||¡ d S )Nrµ   r  rÐ   rÃ   r"   Tr#   rä  rx   r-   r-   r.   Útest_loc_indexer_length_one�
  s    &z.TestLocBooleanMask.test_loc_indexer_length_one)r�   r�   r‘   rÜ  r’   r“   r”   rÝ  rÞ  rá  ÚtdÚskip_array_manager_invalid_testrâ  rã  rå  ræ  rç  r-   r-   r-   r.   rÚ  
  s   

 rÚ  c                   @   s`   e Zd Zej ddd„ ejeg¡dd„ ƒZ	dd„ Z
dd	„ Zej d
ddg¡dd„ ƒZdd„ ZdS )ÚTestLocListlikerk  c                 C   s   | S rj   r-   rü   r-   r-   r.   rý   ™
  r·   zTestLocListlike.<lambda>c                 C   sL  t ddtjgƒ}ttdƒ|d�}|j||ƒ }t ||¡ |||ƒ }t ||¡ | ¡ j||ƒ }t 	|| ¡ ¡ |d d… }|dd … }d}t
jt|d�� |j||ƒ  W d   ƒ n1 sÂ0    Y  t
jt|d�� |||ƒ  W d   ƒ n1 sü0    Y  t
jt|d��" | ¡ j||ƒ  W d   ƒ n1 �s>0    Y  d S )	Nr%   r}   r`   r	   rî   r[   rß   r¬   )r   rv   r�   r   rº   r&   r'   r»   r%  r(   r’   r¯   rA   )r9   rk  ÚcirH  r�   Zser2Zci2r°   r-   r-   r.   Ú8test_loc_getitem_list_of_labels_categoricalindex_with_na™
  s"    ,*zHTestLocListlike.test_loc_getitem_list_of_labels_categoricalindex_with_nac                 C   sf   t jg d¢dd�}tg d¢tdddd�ƒ}tjtd	d
�� |j|  W d   ƒ n1 sX0    Y  d S )N)ú
2001-01-04z
2001-01-02rí  z
2001-01-14r2  rÃ   )r7   rd   rp   rh  z
2001-01-01r  rc   rE  rß   r¬   )rv   rš   r   r   r’   r¯   rA   r&   )r9   rV   rH  r-   r-   r.   Ú1test_loc_getitem_series_label_list_missing_valuesµ
  s    ÿzATestLocListlike.test_loc_getitem_series_label_list_missing_valuesc                 C   sf   t t ddg¡t ddg¡d�}tjtdd��$ |jt ddg¡  W d   ƒ n1 sX0    Y  d S )Nl   PF
AHl   UBÿeNl   P2ˆ$Þ$én©r
   r~   rß   r¬   l   NZ4FçG)r   rv   rš   r’   r¯   rA   r&   rq  r-   r-   r.   Ú9test_loc_getitem_series_label_list_missing_integer_values¾
  s    þzITestLocListlike.test_loc_getitem_series_label_list_missing_integer_valuesÚ	to_periodTFc                 C   sX  t ddddd�}|r| d¡}tddg|dd	�}tdƒtdƒg}|rRd
d„ |D ƒ}|j| }tddg|dd	�}|s€|j d ¡|_tj||dd� tdƒtdƒtdƒg}|r¸dd„ |D ƒ}tg d¢t	|d|j
d�dd	�}|j| }tj||dd� tdƒtdƒtdƒg}|�rdd„ |D ƒ}tjtdd�� |j|  W d   ƒ n1 �sJ0    Y  d S )Nú
2011-01-01z
2011-01-02r  rÈ  )r¬  r‰   çš™™™™™¹?çš™™™™™É?rá   rÀ   c                 S   s   g | ]}|  d ¡‘qS ©r  ©rñ  r³   r-   r-   r.   r¶   Ò
  r·   zRTestLocListlike.test_loc_getitem_listlike_of_datetimelike_keys.<locals>.<listcomp>T)rˆ  c                 S   s   g | ]}|  d ¡‘qS rõ  rö  r³   r-   r-   r.   r¶   ß
  r·   )rô  rô  ró  )r‰   r6   ú
2011-01-03c                 S   s   g | ]}|  d ¡‘qS rõ  rö  r³   r-   r-   r.   r¶   ì
  r·   rß   r¬   )r   rñ  r   r   r&   r
   r°  r'   r»   r   r6   r’   r¯   rA   )r9   rñ  rÈ  rH  r4  r�   rŒ   r-   r-   r.   Ú.test_loc_getitem_listlike_of_datetimelike_keysÇ
  s>    

ýÿ
ýz>TestLocListlike.test_loc_getitem_listlike_of_datetimelike_keysc                 C   sd   t ddgddgddggg d¢dd	gd
�}|jd d… }d|j_|jtddgdd� }t ||¡ d S )Nr[   r7   rc   rd   rb   rp   )ÚcobraÚviperZ
sidewinderZ	max_speedÚshieldré   r    rù  rú  rˆ   )r   r›   r
   r‰   r&   r   r'   r(   r¼   r-   r-   r.   Útest_loc_named_indexñ
  s    ýz$TestLocListlike.test_loc_named_indexN)r�   r�   r‘   r’   r“   r”   rv   ZasarrayrÉ   rì  rî  rð  rø  rü  r-   r-   r-   r.   rê  ˜
  s   
		
)rê  z%columns, column_key, expected_columns)éÛ  rq  iÝ  rý  rq  r[   )rý  rq  ÚAllrþ  r7   c                 C   sX   t tj d¡ d¡| tdƒd�}|jd d …|f }|jg d¢|f }tj||dd� d S )Nr7   ræ   r  ru   r«   Tr—  )	r   rv   r¸   r¹   rÉ   r›   r&   r'   r(   )r5   Z
column_keyZexpected_columnsr+   r,   r�   r-   r-   r.   Ú*test_loc_getitem_label_list_integer_labelsþ
  s    
ÿrÿ  c                  C   sš   t j d¡ d¡} t| ƒ}t j|jd d …df< t  | t  t jgd ¡ 	dd¡f¡}t|g d¢d�}t
 ||¡ t| ƒ}t j|jd d …df< t
 ||¡ d S )Nr7   )rp   rc   rÓ  rp   r[   )rÙ   r  rÇ   r\   rÓ  r‡   )rv   r¸   r¹   rY  r   r�   r&   Zhstackrš   r2  r'   r(   )Z	rand_datar�   rÛ  r,   r-   r-   r.   Útest_loc_setitem_float_intindex  s    $r   c                  C   sr   dd„ dD ƒ} t t d¡tdƒt | ¡d�}|jdd�d	d
… }t t d¡tdƒt g d¢¡d�}t ||¡ d S )Nc                 S   s   g | ]}d D ]}||f‘qqS ))rb   rp   rf  r_   r-   )r´   Úyrr-  r-   r-   r.   r¶   !  r·   z)test_loc_axis_1_slice.<locals>.<listcomp>)éÞ  r§   )r_   rp   Z
ABCDEFGHIJré   r[   ry  ©r  rf  ©r§   rp   r‹  )r  )r  r_   )r§   rb   r  )	r   rv   r€  r  r   rý  r&   r'   r(   )rÝ   r+   r�   r,   r-   r-   r.   Útest_loc_axis_1_slice  s    ýýr  c                  C   sX   t dtdƒt tdƒtdƒg¡d�} |  ¡ }|jddgf |jddgf< t || ¡ d S )Nr#   r7   ré   r   rŽ  )r   rº   r   r;  rÊ   r&   r'   r(   )r,   r�   r-   r-   r.   Ú!test_loc_set_dataframe_multiindex0  s    ÿr  c                  C   s4   t tdƒtddgtd�ƒ} | jd }|dks0J ‚d S )Nr7   r[   rÇ   rÃ   r   )r   rº   r   rñ   r&   )rH  r�   r-   r-   r.   Útest_loc_mixed_int_float:  s    
r  c                  C   sT   t tdƒg d¢d�} tjtdd�� d| jd d…< W d   ƒ n1 sF0    Y  d S )Nrc   r  r	   ú$Slicing a positional slice with .locr¬   r7   r`   )r   rº   r’   r¯   r–   r&   )rH  r-   r-   r.   Ú%test_loc_with_positional_slice_raisesB  s    r	  c               	   C   s>  t ddd�} ttj d¡ d¡| d�}|d }d}||fD ]|}tjt|d	�� |jd
d…  W d   ƒ n1 sp0    Y  tjtdd	�� d
|jd
d…< W d   ƒ q:1 s¬0    Y  q:tjt|d	��" |jd
d…d
f  W d   ƒ n1 sî0    Y  tjtdd	��" d|jd
d…d
f< W d   ƒ n1 �s00    Y  d S )Nr™  r`   ©rÌ  r7   rÈ  r	   r   zOcannot do slice indexing on DatetimeIndex with these indexers \[1\] of type intr¬   r[   r  )	r   r   rv   r¸   r¹   r’   r¯   r–   r&   )Údtir+   rH  r°   rD   r-   r-   r.   Ú#test_loc_slice_disallows_positionalJ  s    ÿ,.0r  c                  C   sÊ   t tj d¡ d¡g d¢tdddd�d�} | jg d	¢  ¡ } | j}t	 
|j¡}d
}tjt|d�� | j|  W d   ƒ n1 s€0    Y  tjt|d�� | d j|  W d   ƒ n1 s¼0    Y  d S )Nr7   r  rÛ   Z2012r,  rd   rE  ru   )r   r7   r7   r`   z/None of \[TimedeltaIndex.* are in the \[index\]r¬   r#   )r   rv   r¸   r¹   rY  r   r›   rÊ   r
   r‚   ZTimedeltaIndexZasi8r’   r¯   rA   r&   )r+   r  rØ  r°   r-   r-   r.   Ú'test_loc_datetimelike_mismatched_dtypesf  s    ý(r  c                  C   s¦   t jdddd�} ttj d¡ d¡| d�}t ||j	|  ¡ t ||j	t
| ƒ ¡ t ||j	t
| ƒ ¡ t |jdd	… |j	| dd	…  ¡ t ||j	t
| ƒ ¡ d S )
Nz2002-01z2003-12r+  r«  r7   )ré  r_   r	   r   rd   )r‚   r³  r   rv   r¸   r¹   rY  r'   r(   r&   rÉ   r›   )rÈ  r+   r-   r-   r.   Ú"test_loc_with_period_index_indexer|  s    $r  c                  C   sz   t j d¡ d¡} tddd�}g d¢}t| ||d�}t j|j|jd d	f< t j| d d
d…< t| ||d�}t	 
||¡ d S )Nr7   )rp   ra   rª  rp   r
  )r%   r}   rª   r  ÚEÚFré   r[   r€   r   )rv   r¸   r¹   rY  r   r   r�   r&   r
   r'   r(   )rv  rÈ  rÝ   rŒ   r�   r-   r-   r.   Ú%test_loc_setitem_multiindex_timestamp‡  s    r  c                  C   s2  g d¢} ddg}ddg}t j| ||gg d¢d�}tdtd	ƒ|d
�}|jd d …| d |d |d ff }|jd d …d d…f }t ||¡ |j| d |d |d fg d¢dd�}t ||¡ |jd }|jd d… }	|j| d |d |d fg d¢dd�}
t 	|
|	¡ |j| d |d |d f }|dk�s.J ‚d S )NrÛ   rŽ  )r[   r   r   r[   )rµ   r  r•  r  ra   rd   ré   rZ   )rN  rz  )
r   r;  r   rº   r&   r›   r'   r(   Zxsr»   )rc  rd  Zlev3rÝ   r+   r�   r,   ZaltrH  Z	expected2Zalt2r9  r-   r-   r.   Ú'test_loc_getitem_multiindex_tuple_level“  s     $&
&r  c               	   C   s¢   t t g d¢g d¢ddtjtjgg¡jg d¢dd�} |  d¡}|jjdksNJ ‚|jd }t	dd	g|j
ddd
�}t ||¡ |j t¡|_|jd }t ||¡ d S )Nr�  )rd   ra   rb   rp   r[   r7   rÛ   r–  )r~   r5   r6   rG   rd   r\  )r   rv   rš   r�   ÚTr®   r
   r6   r&   r   r5   r'   r»   rÜ   rñ   )r+   r…   r�   r,   r-   r-   r.   Ú/test_loc_getitem_nullable_index_with_duplicates±  s    $ý


r  rô   rÏ   c                 C   sŠ   t g d¢dgdd�}tjtdd�� | |jd< W d   ƒ n1 sB0    Y  trbt| tjƒrbd}nd	}t g d
¢dg|d�}t 	||¡ d S )Nr�  rs   Zuint8r4   rÓ   r¬   )r7   rs   Úint16Úuint16)r[   r7   rÏ   rc   )
r   r'   rÔ   rÕ   r&   r   rŠ   rv   r  r(   )rô   r+   r6   r,   r-   r-   r.   Útest_loc_setitem_uint8_upcastÅ  s    (r  zfill_val,exp_dtypez
2022-01-06zdatetime64[ns]z
2022-01-07ú
US/Easternr‚  zdatetime64[ns, US/Eastern]c                 C   sj   ddd|   ¡ g}t|| j|d�}tg d¢dg|d�}d|jd	< | d
¡ t||d�}tj|j|dd� d S )Nz
2022-01-02z
2022-01-03z
2022-01-04)rå  r6   )r_   rh  ri  rè  r#   ru   rç  )ú
2022-01-08r#   r  rÃ   T)Úexact)	r   r   rå  r   r&   r„  r'   r3  r
   )Zfill_valZ	exp_dtyper~   r
   r+   Zexpected_indexr-   r-   r.   Ú0test_loc_setitem_using_datetimelike_str_as_indexÙ  s    

r  c                  C   sJ   t tdƒgƒ} d| jd d …df< t dgdgdgdgdœƒ}t | |¡ d S )NÚabcrd   rs   r#   r"   rG   )r   r[   r7   rs   )r   rÉ   r&   r'   r(   )r+   r,   r-   r-   r.   Útest_loc_set_int_dtypeì  s    r  z8ignore:Period with BDay freq is deprecated:FutureWarningr(  c                  C   sr   t g d¢ddd�} tg d¢g d¢g d¢g d¢g| g d	¢d
�}|jddgdd�d }|j| d ddf dksnJ ‚d S )N)z20181101 1100z20181101 1200z20181102 1300z20181102 1400r   r}   )r‰   r¬  )r%   r}   r  )r%   rª   rÇ   )rc  ÚQr\   )ÚWr  rK  )ÚONEÚTWOÚVALUESré   r   r!  T)r„  r"  r   r%   r  )r   r   r®   r&   )Zp_indexZ	mi_seriesr-   r-   r.   Útest_loc_periodindex_3_levelsõ  s    ýýr#  c                  C   sz   t  d¡ ttg d¢dd�tg d¢ƒdœƒ} tddgƒ}|| j| jd	f< ttg d
¢dd�tg d¢ƒdœƒ}t | |¡ d S )NZpyarrowr«   zstring[pyarrow]rÃ   )TTF)Ústringsr  r¦  r*  r$  )r¦  r*  rª   )r’   r·  r   r   r&   r  r'   r(   )r+   Ú	new_valueZexpected_dfr-   r-   r.   Ú test_loc_setitem_pyarrow_strings  s    

þÿ
þÿr&  c                   @   s  e Zd Zej dddg¡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 dejejeeg¡ej dg d¢¡dd„ ƒƒZej deddd…f dedƒfg¡d d!„ ƒZd"d#„ Zej d$d%d&g¡d'd(„ ƒZejd)d*„ ƒZd+d,„ Zd-d.„ Zd/d0„ Z dS )1ÚTestLocSeriesrÏ  )rÐ  r`   )rÑ  rc   c                 C   s$   t dddœƒ}|j| |ks J ‚d S )Nr`   rc   )rÐ  rÑ  )r   r&   )r9   r
  r,   rH  r-   r-   r.   rš    s    zTestLocSeries.test_loc_uint64c           	      C   sÒ   |j g d¢ }t |j| | |¡¡ t |jdd d… |dd d… ¡ |j ddg \}}|j||… }| ||¡}t ||¡ || ¡ k}t |j| || ¡ |j| || ks¸J ‚|j| || ksÎJ ‚d S )N©r`   rc   rb   rd   r7   é   )r
   r'   r»   r&   rS  r›   ÚtruncateÚmedian)	r9   Ústring_seriesÚdatetime_seriesÚindsÚd1Úd2r�   r,   r   r-   r-   r.   Útest_loc_getitem$  s    "zTestLocSeries.test_loc_getitemc                 C   sª   |j ddg \}}|d d d… jg d¢ }d}tjt|d�� |j||…  W d   ƒ n1 s`0    Y  tjt|d�� d|j||…< W d   ƒ n1 sœ0    Y  d S )Nrd   r)  r7   )r[   r7   r   z"Timestamp\('2000-01-10 00:00:00'\)r¬   r   )r
   r›   r’   r¯   rA   r&   )r9   r-  r/  r0  Zts2r°   r-   r-   r.   Útest_loc_getitem_not_monotonic7  s    ,z,TestLocSeries.test_loc_getitem_not_monotonicc                 C   sl  t tj d¡ d¡ttdddƒƒd�}| ¡ }d|jdd…< |jdd… dk 	¡ sVJ ‚| ¡ }d|jdd…< |jdd… dkj
 	¡ sˆJ ‚|jdd	… }|jdd… }| g d
¢¡}t ||¡ t ||¡ |jttdƒƒttdddƒƒ  }tjtdd�� |jdd…  W d   ƒ n1 �s 0    Y  tjtdd�� d|jdd…< W d   ƒ n1 �s^0    Y  d S )Nr7   r_   r   rP   r	   rc   r`   rh  ra   )rc   ra   rp   r_   rd   rf  rî   z^3$r¬   )r   rv   r¸   r¹   rY  rÉ   rº   rÊ   r›   r  r„   r&   rS  r'   r»   r’   r¯   rA   )r9   rH  Úcpr�   r9  r,   Ús2r-   r-   r.   Ú0test_loc_getitem_setitem_integer_slice_keyerrorsB  s&    ÿ".z>TestLocSeries.test_loc_getitem_setitem_integer_slice_keyerrorsc                 C   s4   t |jd d… ƒ}|j| }t ||d d… ¡ d S )Nr_   )r!  r
   r&   r'   r»   )r9   r,  rÈ  r�   r-   r-   r.   Útest_loc_getitem_iterator_  s    
z'TestLocSeries.test_loc_getitem_iteratorc                 C   s:   ||  ¡ k}| ¡ }d|j|< |}d||< t ||¡ d S )Nr   )r+  rÊ   r&   r'   r»   )r9   r,  r   r�   r,   r-   r-   r.   Útest_loc_setitem_booleand  s    
z&TestLocSeries.test_loc_setitem_booleanc                 C   sb   t |jg d¢ ƒ}d|j|< d}tjt|d��  d|j|dg < W d   ƒ n1 sT0    Y  d S )N)rd   rp   ri  rd   z\['foo'\] not in indexr¬   r    )rÉ   r
   r&   r’   r¯   rA   )r9   r,  r.  r°   r-   r-   r.   Útest_loc_setitem_cornerm  s
    
z%TestLocSeries.test_loc_setitem_cornerc                 C   s†   |j g d¢ }| ¡ }| ¡ }d||< d|j|< t ||¡ | ¡ }| ¡ }d||d |d …< d|j|d |d …< t ||¡ d S )N)rd   r_   r)  r   r7   )r
   rÊ   r&   r'   r»   )r9   r-  Úindicesr3  rŒ   r-   r-   r.   Útest_basic_setitem_with_labelst  s    
z,TestLocSeries.test_basic_setitem_with_labelsc           	      C   s$  t tj d¡ d¡ttdddƒƒd�}g d¢}t g d¢¡}| ¡ }| ¡ }d||< d|j	|< t
 ||¡ | ¡ }| ¡ }d||< d|j	|< t
 ||¡ g d¢}t g d¢¡}d}tjt|d	�� d||< W d   ƒ n1 sÞ0    Y  tjt|d	�� d||< W d   ƒ n1 �s0    Y  d S )
Nr7   r_   r   rP   r	   )r   rc   ra   ©r   rc   rd   ra   z\[5\] not in indexr¬   )r   rv   r¸   r¹   rY  rÉ   rº   rš   rÊ   r&   r'   r»   r’   r¯   rA   Ú	Exception)	r9   rH  r.  Zarr_indsr3  rŒ   Zinds_notfoundZarr_inds_notfoundr°   r-   r-   r.   Ú!test_loc_setitem_listlike_of_intsƒ  s,    ÿ

&z/TestLocSeries.test_loc_setitem_listlike_of_intsc                 C   sž   t tdddd�g d¢d�}| ¡ }tddd�}||jd	< |jd	 }||ksNJ ‚| ¡ }||jd
< |jd
 }||ksvJ ‚| ¡ }||d	< |d	 }||ksšJ ‚d S )Nrò  r`   r  rš  rÛ   r	   r÷  r‚  r#   r   )r   r   rÊ   r   r&   r›   )r9   rH  r4  r,   r�   r-   r-   r.   Útest_loc_setitem_dt64tz_valuesŸ  s"    þ



z,TestLocSeries.test_loc_setitem_dt64tz_valuesÚarray_fnrú   r;  c                 C   s~   |dg| ƒ}t |ddddgtdƒtd�}t dtdƒtd�}||jd< t ||¡ t dtdƒtd�}||jd< t ||¡ d S )Nr   Zabcder  r#   )r   rÉ   rñ   r&   r'   r»   r›   )r9   rú   r?  r“  r,   rH  r-   r-   r.   Ú#test_loc_iloc_setitem_with_listlikeµ  s    

z1TestLocSeries.test_loc_iloc_setitem_with_listlikerÌ   r%   Nc                 C   s¢   t t g d¢¡g d¢d�}d}tjt|d��" |j|d d …f  W d   ƒ n1 sT0    Y  tjt|d��" d|j|d d …f< W d   ƒ n1 s”0    Y  d S )N))r%   Ú0)r%   r1   )r}   rA  )é   rX  r]  rï  r-  r¬   r[   )r   r   rý  r’   r¯   r   r&   )r9   rÌ   rH  r°   r-   r-   r.   Ú+test_loc_series_getitem_too_many_dimensionsÇ  s    þ0z9TestLocSeries.test_loc_series_getitem_too_many_dimensionsc                 C   sØ   |j g d¢ }| ¡ }d|j|< | ¡ }d|jg d¢< t ||¡ d|jdd…< d|dd…< t ||¡ |j ddg \}}d|j||…< d|dd…< t ||¡ d|j|< d|j|< || dksÄJ ‚|| dksÔJ ‚d S )Nr(  rd   r_   r)  ra   rz  rc   )r
   rÊ   r&   r›   r'   r»   )r9   r,  r.  r�   r,   r/  r0  r-   r-   r.   Útest_loc_setitemÕ  s"    


zTestLocSeries.test_loc_setitemr6   rñ   r  c                 C   s\   t ddgddgdœ|d�}dddœ|jd	d d …f< t ddgddgdœ|d�}t ||¡ d S )
Nr  ÚdefZghiZjklr€   rÃ   ZnewAZnewBr   rj  )r9   r6   r+   r,   r-   r-   r.   Útest_loc_assign_dict_to_rowï  s    z)TestLocSeries.test_loc_assign_dict_to_rowc                 C   sp   t ddgd�}tddd�ddœ|jd	< tddd�ddœ|jd	< t tddd�dggddgd	gd
�}t ||¡ d S )Nr   rô   r‡   ra   rá   rÖ  r    )r   rô   r[   ru   )r   r   r&   r'   r(   rQ  r-   r-   r.   Ú,test_loc_setitem_dict_timedelta_multiple_setù  s    ÿz:TestLocSeries.test_loc_setitem_dict_timedelta_multiple_setc                 C   sl   t ddgdgd�}ddg|jdddgf< t ttjtjgd	d
�dtjgdtjgdœddgd�}t ||¡ d S )Nr[   r7   r#   ré   ra   rb   r"   rG   rñ   rÃ   rÛ   r	   )r   r&   r   rv   r�   r'   r(   rx   r-   r-   r.   Ú3test_loc_set_multiple_items_in_multiple_new_columns  s    ýú	zATestLocSeries.test_loc_set_multiple_items_in_multiple_new_columnsc                 C   sh   d}t jt|d��B tjdddd�}ttdƒ|d�}|jd d	ksFJ ‚W d   ƒ n1 sZ0    Y  d S )
Nz#Period with BDay freq is deprecatedr¬   Ú2000rP   r}   rÊ  r	   z
2000-01-14rf  )r'   rÔ   rÕ   r‚   r³  r   rº   r&   )r9   r°   r
   r*   r-   r-   r.   Ú test_getitem_loc_str_periodindex  s
    z.TestLocSeries.test_getitem_loc_str_periodindexc                 C   sŠ   t tdƒƒ}t|d dd�}tdtjt|ƒtjd�i|d�}|j| }td|j	dd� 
tj¡itt |¡ d¡dd�d�}t ||¡ d S )	Nrh  iè  r–  rÃ   r
  r	   Zstable)r;   )rÉ   rº   r   r   rv   rw   rã   Zintpr&   ZargsortrÜ   rš   r�  r'   r(   )r9   r  r
   r+   r�   r,   r-   r-   r.   Útest_loc_nonunique_masked_index  s     
þz-TestLocSeries.test_loc_nonunique_masked_index)!r�   r�   r‘   r’   r“   r”   rš  r1  r2  r5  r6  r7  r8  r:  r=  r>  rv   rš   r‚   rÉ   r  r@  r   r•   rC  rD  rF  rè  ré  rG  rH  rJ  rK  r-   r-   r-   r.   r'    s0   
	$

	

r'  )[Ú__doc__Úcollectionsr   r   r   r   r   rö   Zdateutil.tzr   Únumpyrv   r’   Zpandas._configr   Zpandas._libsr
   rn  Zpandas.compat.numpyr   Zpandas.errorsr   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsrè  Zpandasr‚   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   Zpandas._testingZ_testingr'   Zpandas.api.typesr   Zpandas.core.indexingr    Zpandas.tests.indexing.commonr!   r“   r”   r�   r/   r0   r—   r"  r/  rj  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.   Ú<module>   s¬   P þþ
	 ?           #= w Z J  	fýþ



þþ
	

