3
®ybT�  ã               @   s>  d Z ddlmZ ddlZddlZddlZddlmZ ddl	Z
ddl	mZmZmZmZ ddljZddlmZ ddlmZ G dd	„ d	eƒZG d
d„ dƒZdd„ Zejjddddgddgddgdfdddgddgddgdfdddgddgddgd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"d'd(„ Z#dS ))z$ test label based indexing with loc é    )ÚStringION)Ú_is_numpy_dev)Ú	DataFrameÚSeriesÚ	TimestampÚ
date_range)Ú	is_scalar)ÚBasec               @   s\   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	d
„ Zdd„ Zdd„ Z	dd„ Z
dd„ Zdd„ ZdS )ÚTestLocc             C   s   | j dddgtd� d S )NÚlocé   Úlabels)ÚtypsÚfails)Úcheck_resultÚKeyError)Úself© r   úB/tmp/pip-install-4cy230dp/pandas/pandas/tests/indexing/test_loc.pyÚtest_loc_getitem_int   s    zTestLoc.test_loc_getitem_intc             C   s   | j dddgtd� d S )Nr   ÚcÚempty)r   r   )r   r   )r   r   r   r   Útest_loc_getitem_label   s    zTestLoc.test_loc_getitem_labelc             C   s    | j dddddddgtd� | j ddd	gtd� | j ddd	gtd� | j dd
dddgtd� | j dd
dgtd� | j dd
dgdtd� | j dd
d	gdtd� d S )Nr   ÚfÚintsÚuintsr   ÚmixedÚts)r   r   Úfloatsé   r   )r   Úaxesr   )r   r   )r   r   r   r   Ú#test_loc_getitem_label_out_of_range   s    z+TestLoc.test_loc_getitem_label_out_of_rangec             C   s   d S )Nr   )r   r   r   r   Útest_loc_getitem_label_list+   s    z#TestLoc.test_loc_getitem_label_listc             C   sz   | j ddddgdgtd� | j ddddgdd	d
gdtd� | j ddddgdd	d
gdtd� | j ddddgdgdtd� d S )Nr   r   é   r   r   )r   r   é
   r   r   r   )r   r    r   é   é   é   é   é   Zmulti)r#   r%   )r#   r(   )r   r)   )r   r   )r   r   r   r   Ú(test_loc_getitem_label_list_with_missing0   s    z0TestLoc.test_loc_getitem_label_list_with_missingc             C   s"   | j ddddgddgdtd� d S )	Nr   r   é   é(   r   r   r#   )r   r    r   )r   r   )r   r   r   r   Ú!test_loc_getitem_label_list_failsA   s    z)TestLoc.test_loc_getitem_label_list_failsc             C   s   d S )Nr   )r   r   r   r   Ú!test_loc_getitem_label_array_likeG   s    z)TestLoc.test_loc_getitem_label_array_likec             C   s$   ddddg}| j d|dgtd� d S )NTFr   r   )r   r   )r   Ú
IndexError)r   Úbr   r   r   Útest_loc_getitem_boolL   s    zTestLoc.test_loc_getitem_boolc             C   s˜   | j dtddƒdddddgtd	� | j dtd
dƒdgdtd� | j dtddƒdgdtd� | j dtddƒdgdtd� | j dtdddƒdgdtd� d S )Nr   r#   r%   r   r   r   r   r   )r   r   Z20130102Z20130104)r   r    r   r   é   r   r(   )r   ÚsliceÚ	TypeErrorr   )r   r   r   r   Útest_loc_getitem_label_sliceR   s    z$TestLoc.test_loc_getitem_label_slicec             C   st   t ddgddgddggddgdddgd�}tjd	ƒ|jd< t ddgd
dgddggddgdddgd�}tj||ƒ d S )Nr   ÚaéÈ   Úcol1Zcol2r$   r#   )ÚcolumnsÚindexr   r   )r#   r8   )r   ÚnpÚaranger   ÚtmÚassert_frame_equal)r   ÚdfÚexpectedr   r   r   Ú test_setitem_from_duplicate_axisp   s    (z(TestLoc.test_setitem_from_duplicate_axisN)Ú__name__Ú
__module__Ú__qualname__r   r   r!   r"   r*   r-   r.   r1   r5   rA   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dd„ Ze	j
jdddgddddg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e	j
jd"d#d$d%d&d'd(d)d*gƒd+d,„ ƒZd-d.„ Zd/d0„ Zd1d2„ Ze	j
jd3d4ged5d4d5ƒejd4gƒgƒe	j
jd6d7gejd7gƒgƒd8d9„ ƒƒZe	j
jd:d;d<gd4d=d>d%gfd?ejd?d?d?d?gd@dAejejgd?d?d?d?ggd4d=d>d%gdB�fdCd>d%gfd?dDgejdCd<ejejgd@dAd?dDgdEdFejejggd4d=d>d%gdB�fdCd4d=d>gfejd?dDdGgej dH�ejdCd<ejgd?dDdGgdEdFejggd4d=d>gdB�fedCd@d5ƒd=d>d%gfd?dDdGgdIdJdKggejdCd<ejejgd@d?dDdGgdEdIdJdKggd4d=d>d%gdB�fedCd@d5ƒd>d4d%gfejd?dDdGgdIdJdKggej dH�ejdCd<ejejgdDdAd?dGgdJdFdIdKggd4d=d>d%gdB�fed5d5d5ƒd4d>gfejd?dDgdGdIgdJdKggd4d>gdB�ejd?d<dDgdGdAdIgdJdFdKggd4d=d>gdB�fgƒdLdM„ ƒZ!dNdO„ Z"dPdQ„ Z#dRdS„ Z$dTdU„ Z%dVdW„ Z&dXdY„ Z'dZd[„ Z(e	j
j)d\d]�d^d_„ ƒZ*d`da„ Z+dbdc„ Z,e	j
j)e-ddd]�dedf„ ƒZ.dgdh„ Z/didj„ Z0dkdl„ Z1d5S )mÚTestLoc2c             C   sT   t tjjdƒdd„ tdƒD ƒd�}|jd	 }|jd d …df jd }tj||ƒ d S )
Nr   r)   c             S   s   g | ]}d |d  ‘qS )ZABCDEr)   r   )Ú.0Úxr   r   r   ú
<listcomp>…   s    z2TestLoc2.test_loc_getitem_dups.<locals>.<listcomp>)r:   ÚAr   )r   r)   )rI   r   )r   r;   ÚrandomZrandom_sampleÚranger   r=   Úassert_series_equal)r   r?   r@   Úresultr   r   r   Útest_loc_getitem_dups�   s
     
zTestLoc2.test_loc_getitem_dupsc             C   s€   t ddddtdƒggdddddgdgd�}tddddtdƒgdddddgdd�}|jd	 }tj||ƒ |jd }tj||ƒ d S )
Nr#   r   ÚfooÚbarÚ20130101r6   )r9   r:   )r:   Únamer   )r   r   r   Úilocr=   rL   r   )r   r?   r@   rM   r   r   r   Útest_loc_getitem_dups2‹   s    


zTestLoc2.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	œƒjd
ƒ}tdddggƒ}|jƒ }|j|  d9  < tj	|j| d|j|  ƒ tddgƒ}|jƒ }|j|  d9  < |j| d|j|  ksÌt
‚tdddggƒ}|jƒ }|j|  d9  < tj|j| d|j|  ƒ d S )NZrtttiZaaader)   Úfloat64)Údtypegq=
×£põ?r   gÃõ(\�ÂÕ?)ÚmerO   rP   Úbar2rW   ÚrrP   rX   g       @ÚtgÃõ(\�ÂÕ¿)r   Úlistr;   r<   Z	set_indexÚtupleÚcopyr   r=   rL   ÚAssertionErrorr>   )r   Zdf_origÚindexerr?   r   r   r   Útest_loc_setitem_dups    s$    zTestLoc2.test_loc_setitem_dupsc             C   sð   t dddgtdddgdd�dœƒ}|d	 dk}|j|d
f d }||j|d
f< t dddgtdddgdd�dœƒ}tj||ƒ t dddgdddgdœdd�}|d	 dk}|j|d
f }||j|d
f< t dddgdddgdœdd�}tj||ƒ d S )Nr   r#   éd   r7   i,  Zuint32)rV   )r6   r0   r6   r0   éÉ   i-  Úuint64)r   r   r   r=   r>   )r   Zdf1ÚixZnewb1r@   Zdf2Znewb2r   r   r   Útest_loc_setitem_slice»   s    " zTestLoc2.test_loc_setitem_slicec             C   sx   t dgdgdgdgdœƒ}dddg}|jd d …|f jd	ƒ|jd d …|f< t dgdgdgdgdœd	d
�}tj||ƒ d S )NrI   g333333ó?g        g      @)Úidr6   r0   r   r6   r0   r   Zfloat32)rV   g      Àg      À)r   r   Úastyper=   r>   )r   r?   Úcolsr@   r   r   r   Útest_loc_setitem_dtypeÐ   s    
&zTestLoc2.test_loc_setitem_dtypec             C   sr   t tdƒdddgd�}tjtdd�� |ddg  W d Q R X t tdƒƒ}tjtdd�� |d	dg  W d Q R X d S )
Nr%   r6   r0   r   )r:   zwith any missing labels)ÚmatchÚdr   )r   rK   ÚpytestÚraisesr   )r   Úsr   r   r   Ú$test_getitem_label_list_with_missingÜ   s    z-TestLoc2.test_getitem_label_list_with_missingr:   TFc          	   C   sN   t dddgƒ}dt|ƒ› dt|ƒ› �}tjt|d�� |j| }W d Q R X d S )Nr#   r   r%   z Boolean index has wrong length: z instead of )rj   )r   Úlenrl   rm   r/   r   )r   r:   rn   ÚmsgÚ_r   r   r   Útest_loc_getitem_bool_diff_lenç   s    z'TestLoc2.test_loc_getitem_bool_diff_lenc             C   s   d S )Nr   )r   r   r   r   Útest_loc_getitem_int_sliceï   s    z#TestLoc2.test_loc_getitem_int_slicec          A   C   sö  t tjjdƒdddgdddgd�}d	}tjt|d
�� |jddgddgf  W d Q R X ttd�}d|jd< d|jd< tjtdd
�� |jd  W d Q R X d}tjt|d
�� |jddg  W d Q R X d}tjt|d
�� |jdg  W d Q R X d|jd< tjtdd
�� |jddg  W d Q R X d|d< d}tjt|d
�� |jdg  W d Q R X |d= tjt|d
�� d|jdg< W d Q R X t dgdggddgdgd�}d}tjt|d
�� |jdgd d …f  W d Q R X tjt|d
�� |jdg  W d Q R X d S ) Nr%   r6   r0   r   Úer   Úg)r:   r9   zJ\"None of \[Int64Index\(\[1, 2\], dtype='int64'\)\] are in the \[index\]\")rj   r#   r   )rV   z^-1$zL\"None of \[Int64Index\(\[-1, -2\], dtype='int64'\)\] are in the \[index\]\"zE\"None of \[Index\(\['4'\], dtype='object'\)\] are in the \[index\]\"Ú4zwith any missing labelszH\"None of \[Int64Index\(\[-2\], dtype='int64'\)\] are in the \[index\]\"r   ÚvaluezG\"None of \[Int64Index\(\[3\], dtype='int64'\)\] are in the \[index\]\")r%   r%   éÿÿÿÿry   éþÿÿÿry   ry   rz   rz   rz   )	r   r;   rJ   rl   rm   r   r   r   Úobject)r   r?   rq   rn   r   r   r   Útest_loc_to_failó   s@      



zTestLoc2.test_loc_to_failc             C   sr   t dddgƒ}|jdg  tjttjdƒd�� |jdg  W d Q R X tjtdd�� |jddg  W d Q R X d S )Nr#   r   r%   z="None of [Int64Index([3], dtype='int64')] are in the [index]")rj   zwith any missing labels)r   r   rl   rm   r   ÚreÚescape)r   rn   r   r   r   Útest_loc_getitem_list_with_fail6  s    z(TestLoc2.test_loc_getitem_list_with_failc             C   s’   t tjjdd�dddddgd	�}|jjd
d„ ƒ}|jtj|ƒ }|j| }tj||ƒ |j|j	 }tj||ƒ |jt
j|dd� }tj||ƒ d S )Nr)   r$   )ÚsizeZalpha_0Zalpha_1Zalpha_2Zbeta_0Zbeta_1)r:   c             S   s   d| kS )NÚalphar   )rG   r   r   r   Ú<lambda>S  s    z)TestLoc2.test_loc_index.<locals>.<lambda>Úboolean)rV   )r)   r$   )r   r;   rJ   r:   Úmapr   Úarrayr=   r>   ÚvaluesÚpd)r   r?   Úmaskr@   rM   r   r   r   Útest_loc_indexJ  s    
zTestLoc2.test_loc_indexc             C   sÐ   t tjjddƒddddgddddgd�}|jd d …dd…f jdd…d d …f }|jddgkjƒ sft‚|j	ddgkjƒ s|t‚t t
d	ƒgd
gdœƒjd }tt
d	ƒd
gddgdd�}tj||ƒ |jtksÌt‚d S )Nr(   rI   ÚBÚCÚD)r9   r:   r   r   rQ   r#   )r6   r0   r6   r0   )r:   rR   )r   r;   rJ   Úrandr   rS   r9   Úallr^   r:   r   r   r=   rL   rV   r{   )r   r?   rM   r@   r   r   r   Útest_loc_general_  s    
(zTestLoc2.test_loc_generalc             C   s(  t tdtdƒtjd�ttdƒtjd�dœƒ}t tddƒttdƒtjd�dœƒ}d|jd d …df< tj||ƒ t tddƒttdƒtjd�dœƒ}tj	dtjd�|jd d …df< tj||ƒ t tddƒttdƒtjd�dœƒ}tj	dddddgtjd�|jd d …df< tj||ƒ t td	tdƒd
�ttdƒtjd�dœƒ}t tddƒttdƒtjd�dœƒ}d	|jd d …df< tj||ƒ t tdtdƒd
�ttdƒtjd�dœƒ}t tddƒttdƒtjd�dœƒ}d|jd d …df< tj||ƒ t dtt
dƒgƒiƒ}d|jd d …df< t dtdgƒiƒ}tj||ƒ d S )Nr   r)   )r:   rV   )rV   )ÚdateÚvalz
2000-01-01z	2000-01-5r�   rO   )r:   g      ð?Z20180101Ústring)r   r   rK   r;   Úint64r   r   r=   r>   r…   r   )r   r@   r?   r   r   r   Útest_loc_setitem_consistencyr  sL    (z%TestLoc2.test_loc_setitem_consistencyc             C   st   t ddgd�}|d jtjƒ|d< t ddgd�}d|jd d …df< tj||ƒ t ddgd�}d|d< tj||ƒ d S )NrG   Úy)r9   r#   )r   rg   r;   r“   r   r=   r>   )r   r@   r?   r   r   r   Ú"test_loc_setitem_consistency_empty¼  s    z+TestLoc2.test_loc_setitem_consistency_emptyc             C   sò   d}t jt|ƒddgdddgd�}t j|jd d …df ƒ|jd d …df< t j|jd d …df ƒ|jd d …df< |jd d …df |jd d …df  |jd d …df< |jd d …df jd
ƒ|jd d …df< tddddg|jdd�}tj	|d |ƒ d S )Naœ  Level_0,,,Respondent,Respondent,Respondent,OtherCat,OtherCat
Level_1,,,Something,StartDate,EndDate,Yes/No,SomethingElse
Region,Site,RespondentID,,,,,
Region_1,Site_1,3987227376,A,5/25/2015 10:59,5/25/2015 11:22,Yes,
Region_1,Site_1,3980680971,A,5/21/2015 9:40,5/21/2015 9:52,Yes,Yes
Region_1,Site_2,3977723249,A,5/20/2015 8:27,5/20/2015 8:41,Yes,
Region_1,Site_2,3977723089,A,5/20/2015 8:33,5/20/2015 9:09,Yes,Nor   r#   r   )ÚheaderZ	index_colÚ
RespondentÚ	StartDateÚEndDateÚDurationztimedelta64[s]id  iÐ  iH  g     à @)r:   rR   )r˜   r™   )r˜   r™   )r˜   rš   )r˜   rš   )r˜   rš   )r˜   r™   )r˜   r›   )r˜   r›   )r˜   r›   )r˜   r›   )r˜   r›   )
r‡   Zread_csvr   Úto_datetimer   rg   r   r:   r=   rL   )r   Údatar?   r@   r   r   r   Ú-test_loc_setitem_consistency_slice_column_lenÈ  s    	"""
z6TestLoc2.test_loc_setitem_consistency_slice_column_lenÚunitÚYÚMrŒ   ÚhÚmrn   ÚmsÚusc             C   sª   t dtjdƒtjdƒgiƒ}|jd d …df jjd|› d�ƒ|jd d …|f< |jd d …df jjd|› d�ƒ|d< t|jd d …df |d�}tj|jd d …|f |ƒ d S )NÚ	timestampz2017-02-11 12:41:29z1991-11-07 04:22:37zdatetime64[ú]r@   )rR   )	r   r;   Ú
datetime64r   r†   rg   r   r=   rL   )r   rŸ   r?   r@   r   r   r   Útest_loc_assign_non_ns_datetimeç  s    0&z(TestLoc2.test_loc_assign_non_ns_datetimec             C   sÌ   t jdddddgiƒ}tj|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 dddgdddgdddgdddggdd	d
gd�}d	d
g}|| jtjƒ||< tj||ƒ d S )Nr�   l   çCO!gl   ös~!gl    4	8šl   A{ï?šr¤   T)rŸ   ÚcacheZdate_dtZ
date_dt_cpr   r%   z2017-01-24 13:26:12.711z2017-01-24 13:52:05.110z2018-10-22 13:44:05.888z2018-10-23 08:08:41.025)r9   )r   Z	from_dictr‡   rœ   r   Úapplyr=   r>   )r   r?   r@   r9   r   r   r   Útest_loc_modify_datetimeù  s      
z!TestLoc2.test_loc_modify_datetimec       	      C   sÆ  t tjjddƒtdƒtdƒd�}|jd }d|jd< |jd }|dksJt‚|jd }|dks`t‚d|jd d …d	d
…f< |jd d …d	d
…f }|jd d …dd …f }tj	||ƒ t dddgdgd�}tj
dddgdd�|jdddgdf< t ttdddgdddgd�d�ƒjdddgd�}tj	||ƒ dd„ tdƒD ƒ}tjddd�}dd„ tdƒD ƒ}tjddd�}tt|ƒj|ƒƒ}t |d�}tj|d< ||j|df< tj|d	< ||j|d	f< t tt||d�t||d�d�ƒj|d�}tj	||ƒ t dddgtjdœƒ}|j|j|j|jkd	f< t dddgtjdœƒ}tj	||ƒ t ddgddgddgdœƒ}|jdddgf }tddgddgtdd�}tj||ƒ t ddgddgddgdœƒ}ddg|jdddgf< tj	||ƒ d S )Nr(   ZabcdÚABCD)r:   r9   r   r#   r6   rI   rŠ   rŒ   r%   r)   r   r“   )rV   )r:   )rI   c             S   s   g | ]}d t |ƒ ‘qS )ú@)Ústr)rF   Úir   r   r   rH   /  s    z3TestLoc2.test_loc_setitem_frame.<locals>.<listcomp>c             S   s   g | ]}d t |ƒ ‘qS )r®   )r¯   )rF   r°   r   r   r   rH   2  s    )rI   rŠ   r0   )r#   r   r6   )r:   rV   rR   r&   )r   r   )r6   rI   )r6   rI   )r   r   )r   r;   rJ   Úrandnr[   rS   r   r^   r=   r>   r…   Údictr   ZreindexrK   r<   ÚsetÚunionÚnanrI   rŠ   r{   rL   )	r   r?   rM   r@   Zkeys1Zval1Úkeys2Zval2r:   r   r   r   Útest_loc_setitem_frame  sR     



$"


zTestLoc2.test_loc_setitem_framec             C   s  t dddgttdƒtjd�dœƒ}|jdd… }|jd	d… |_||jd	d…< t dddgtdddgtjd�dœƒ}tj||ƒ t t	d
dƒttdƒtjd�dœƒ}t t
dƒt
dƒt
dƒt
dƒt
dƒgtd	dd	ddgtjd�dœƒ}|jd	d… }|jdd… |_||jdd…< tj||ƒ d S )NrO   rP   Zbazr%   )rV   )rI   rŠ   r#   r   r   z
2000-01-01z	2000-01-5r)   )r�   r‘   Z20000101Z20000102Z20000103r(   )r   r   rK   r;   r“   r   r:   r=   r>   r   r   )r   r?   Úrhsr@   r   r   r   Ú test_loc_setitem_frame_multiplesU  s,     "z)TestLoc2.test_loc_setitem_frame_multiplesr_   rI   Nrx   ÚZc             C   sN   t jddgddggddgd�}||jd|f< |jd
 }t|ƒrF|d	ksJt‚d S )Nr#   r   r%   r(   rI   rŠ   )r9   r   rº   )r   rI   )r‡   r   r   r   r^   )r   r_   rx   r?   rM   r   r   r   Ú"test_loc_setitem_with_scalar_indexz  s    	
z+TestLoc2.test_loc_setitem_with_scalar_indexzindex,box,expectedr   r   rŠ   r‹   r'   r%   r(   )r9   r#   r2   r)   r&   é	   )rV   r$   é   é   c             C   s>   t jddgddgddggddgd	�}||j|< tj||ƒ d S )
Nr#   r   r%   r(   r)   r&   rI   rŠ   )r9   )r‡   r   r   r=   r>   )r   r:   Zboxr@   r?   r   r   r   Ú test_loc_setitem_missing_columns‰  s    6$
z)TestLoc2.test_loc_setitem_missing_columnsc             C   s  t dtdƒjdƒtjgiƒ}|j}|jdg }tj|j|ƒ |jdg }tj|j|ƒ dd l	}t d|j	dddƒ|j	dddƒgiƒ}|j}|jdg }tj|j|ƒ |jdg }tj|j|ƒ t d	d
gd gd  iƒ}|j}|jdd… }tj|j|ƒ |jdd … }tj|j|ƒ d S )Nr�   rQ   ÚUTCr   r#   iÜ  iô  r   Útextz
some wordsr¼   r%   )
r   r   Útz_localizer‡   ZNaTZdtypesrS   r=   rL   Údatetime)r   r?   r@   rM   rÃ   r   r   r   Útest_loc_coercionÃ  s(    "zTestLoc2.test_loc_coercionc             C   sš   t jdƒjdƒt jdƒjdƒg}t j|ddgd�}t jtd�}|d |d< |d	 |d< tj||ƒ t jtd�}|d |jd< |d	 |jd< tj||ƒ d S )
Né*   rÀ   iš  rO   rP   )r:   )rV   r   r#   )r‡   rœ   rÂ   r   r{   r=   rL   r   )r   Úvalsr@   Úserr   r   r   Útest_setitem_new_key_tzç  s    z TestLoc2.test_setitem_new_key_tzc             C   s˜  t ddddddgddddddgd	œd
dd
dddgd�}d}tjt|d�� |jdd …  W d Q R X d}tjt|d�� |jd
d …  W d Q R X d}tjt|d�� |jdd…  W d Q R X t ddddddgddddddgd	œd
dd
dddgd�jd
d�}|jdd … }t ddddgddddgd	œddddgd�}tj||ƒ |jd
d … }tj||ƒ |jdd… }t dddgdddgd	œdddgd�}tj||ƒ d S )Nr#   r   r%   r(   r)   r&   r'   r2   )rI   rŠ   r   )r:   z5'Cannot get left slice bound for non-unique label: 1')rj   z5'Cannot get left slice bound for non-unique label: 0')Úaxis)r   rl   rm   r   r   Z
sort_indexr=   r>   )r   r?   rq   rM   r@   r   r   r   Útest_loc_non_uniqueû  s,    44*$zTestLoc2.test_loc_non_uniquec                s¬   t dƒ‰ ‡ fdd„}‡ fdd„}|ddƒ}|jjdks:t‚tjdƒ}|j| }|||ƒ}tj||ƒ |d	d
ƒ}|jjdks~t‚tjd
ƒ}|j| }|||ƒ}tj||ƒ d S )NZABCDEFGc                sJ   t jttjj| tˆ ƒƒtj| ƒˆ d�ttj|tˆ ƒfƒdg| ˆ d�gƒS )N)r:   r9   r   )	r‡   Úconcatr   r;   rJ   r±   rp   r<   Úones)ÚlÚl2)r9   r   r   Úgen_test$  s    z;TestLoc2.test_loc_non_unique_memory_error.<locals>.gen_testc                sL   t |ƒ}tj| jdgƒttj|t ˆ ƒfƒdg| ˆ d�| j|dd … ƒgƒS )Nr   )r:   r9   r#   )rp   r‡   rË   Ztaker   r;   rÌ   )r?   rˆ   Zlen_mask)r9   r   r   Úgen_expected2  s    
z?TestLoc2.test_loc_non_unique_memory_error.<locals>.gen_expectedi„  ra   Fi » i † )	r[   r:   Z	is_uniquer^   r;   r<   r   r=   r>   )r   rÏ   rÐ   r?   rˆ   rM   r@   r   )r9   r   Ú test_loc_non_unique_memory_error  s    







z)TestLoc2.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:t‚|jddg jj}|dksXt‚d S )Nr#   Z
index_namer   )r   r:   rR   rS   r^   r   )r   r?   rM   r   r   r   Útest_loc_nameP  s    zTestLoc2.test_loc_namec             C   sž   t j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 )Nr)   r   r   T)Zcheck_index_typeÚcheck_column_type)r=   ZmakeCustomDataframer>   r   rS   )r   r?   r   r   r   Ú!test_loc_empty_list_indexer_is_okZ  s    ..z*TestLoc2.test_loc_empty_list_indexer_is_okc             C   s(  t ddddgiƒ}|jd d … }||k	s,t‚|d d … |k	s@t‚dddg|d< |d dkjƒ sbt‚||jd d …d d …f ks€t‚t tjjddƒƒ}|d |jd d …df ks°t‚tdddddd	gƒ}|jd d … }||k	sÞt‚|d d … |k	sòt‚d
ddg|d d…< t|d d… d
ddgkƒ�s$t‚d S )Nr6   r#   r   r%   r(   r$   r   r)   r&   r'   r2   r¼   )r   r   r^   rŽ   r;   rJ   r±   r   )r   Zoriginal_dfZ	sliced_dfr?   Zoriginal_seriesZsliced_seriesr   r   r   Ú&test_identity_slice_returns_new_objectj  s    z/TestLoc2.test_identity_slice_returns_new_objectz!accidental fix reverted - GH37497)Úreasonc             C   s|   t ttdƒtdƒƒddgd�}|jƒ }|jd d …df }|d7 }tj||ƒ |jƒ }|j|jdf }|d7 }tj||ƒ d S )Nr%   r6   r0   )r9   r   )r   ÚziprK   r]   r   r=   r>   r:   )r   rG   r•   ÚqÚzr   r   r   Útest_loc_copy_vs_viewƒ  s    zTestLoc2.test_loc_copy_vs_viewc             C   s¸   t jddgtjdƒjd tjdƒjgd�}|jtjdƒjd  }|jd }||ksVt‚|jtjdƒjd g }|jdg }tj	||ƒ |jtjdƒjd tjdƒjg }tj	||ƒ d S )Nr#   r   rc   )r:   r   )
r‡   r   r;   ZiinfoÚmaxr   rS   r^   r=   rL   )r   rn   rM   r@   r   r   r   Útest_loc_uint64”  s    &
"zTestLoc2.test_loc_uint64c             C   s’   dddg}t |d gt|ƒ dœƒ}t ddgd�}||jd d …df< tj||ƒ t dgtjgdœƒ}t ddgtd	�}|jd |jd< tj||ƒ d S )Nr#   r   r%   )rG   r•   rG   r•   )r9   g      ð?)r9   rV   r   )r   rG   )r   rG   )r   rp   r   r=   r>   r;   rµ   Úfloat)r   r�   r@   r?   r   r   r   Útest_loc_setitem_empty_append¦  s    
z&TestLoc2.test_loc_setitem_empty_appendzgh-35481c             C   sŠ   ddg}t ddgd�}|jjtjƒ|_d}tjt|d�� ||jddgdf< W d Q R X d	}tjt	|d�� ||jdd…df< W d Q R X d S )
Nr#   r   rG   r•   )r9   zFNone of \[Int64Index\(\[0, 1\], dtype='int64'\)\] are in the \[index\])rj   r   z?cannot copy sequence with size 2 to array axis with dimension 0)
r   r:   rg   r;   r“   rl   rm   r   r   Ú
ValueError)r   r�   r?   rq   r   r   r   Ú$test_loc_setitem_empty_append_raises·  s    z-TestLoc2.test_loc_setitem_empty_append_raisesc             C   sF   t ddgddggƒ}|jtjdƒ }tjddgdd�}tj||ƒ d S )Nr#   r   r%   r(   r   )rR   )r   r   r;   r…   r‡   r   r=   rL   )r   r?   rM   rn   r   r   r   Útest_indexing_zerodim_np_arrayÉ  s    z'TestLoc2.test_indexing_zerodim_np_arrayc             C   s,   t ddgƒ}|jtjdƒ }|dks(t‚d S )Nr#   r   r   )r   r   r;   r…   r^   )r   rn   rM   r   r   r   Ú%test_series_indexing_zerodim_np_arrayÐ  s    z.TestLoc2.test_series_indexing_zerodim_np_arrayc             C   sn   ddddddgd gd  }t |tddƒd	�}tj tddƒtjd
�}ddddddg|jddd…< tj||ƒ d S )Nr#   r   r%   r(   r)   r&   iÚ  iä  )r:   )r:   rV   iß  ry   )r   rK   r‡   r;   rU   r   r=   rL   )r   r�   r@   rM   r   r   r   Útest_loc_reverse_assignmentÖ  s
    z$TestLoc2.test_loc_reverse_assignment)2rB   rC   rD   rN   rT   r`   re   ri   ro   rl   ÚmarkÚparametrizers   rt   r|   r   r‰   r�   r”   r–   rž   r©   r¬   r·   r¹   r3   r;   r…   r»   r‡   r   rµ   r“   r¿   rÄ   rÈ   rÊ   rÑ   rÒ   rÔ   rÕ   ZxfailrÚ   rÜ   rÞ   r   rà   rá   râ   rã   r   r   r   r   rE   ~   s†   
&CJ&B%&$
($$"6$"3
rE   c           	   C   sZ   t jddddgdd�} tdddd	gtd
ddd�ƒ}tjtdd�� |j|   W d Q R X d S )Nz
2001-01-04z
2001-01-02z
2001-01-14r¨   )rV   r   r)   r2   r½   z
2001-01-01rŒ   r(   )ÚfreqÚperiodszwith any missing labels)rj   )r;   r…   r   r   rl   rm   r   r   )Úkeyrn   r   r   r   Ú1test_series_loc_getitem_label_list_missing_valuesá  s
    ré   z8columns, column_key, expected_columns, check_column_typeiÛ  iÜ  iÝ  r#   TZAllFr   c             C   sV   t tjjddƒ| tdƒd�}|jd d …|f }|jdddg|f }tj|||d� d S )Nr%   ÚABC)r9   r:   rI   rŠ   r‹   )rÓ   )	r   r;   rJ   r�   r[   rS   r   r=   r>   )r9   Z
column_keyZexpected_columnsrÓ   r?   r@   rM   r   r   r   Ú*test_loc_getitem_label_list_integer_labelsë  s    rë   c              C   s¢   t jjddƒ} tj| ƒ}t j|jd d …df< t j| t jt jgd ƒj	ddƒfƒ}tj|dddddgd	�}t
j||ƒ tj| ƒ}t j|jd d …df< t
j||ƒ d S )
Nr2   r(   g      à?r#   g        g      ð?g       @g      @)r9   )r;   rJ   r±   r‡   r   rµ   r   Zhstackr…   Zreshaper=   r>   )Z	rand_datarM   Zexpected_datar@   r   r   r   Útest_loc_setitem_float_intindexý  s    
$
rì   c           	   C   s~   dd„ dD ƒ} t jtjdƒtdƒt jj| ƒd�}|jd	d
�dd… }t jtjdƒtdƒt jjddddgƒd�}tj	||ƒ d S )Nc             S   s   g | ]}dD ]}||f‘qqS )r'   r2   r¼   r$   )r'   r2   r¼   r$   r   )rF   Úyrr£   r   r   r   rH     s    z)test_loc_axis_1_slice.<locals>.<listcomp>éÞ  éß  r$   r2   Z
ABCDEFGHIJ)r:   r9   r#   )rÉ   r¼   r(   r'   )rî   rï   )r$   r2   )rî   r¼   )rï   r2   )r$   r(   )rî   r¼   )rî   r$   )rï   r'   )rï   r2   )
r‡   r   r;   rÌ   r\   Ú
MultiIndexÚfrom_tuplesr   r=   r>   )rh   r?   rM   r@   r   r   r   Útest_loc_axis_1_slice  s    rò   c              C   s\   t jdtdƒt jjtdƒtdƒgƒd�} | jƒ }|jddgf |jddgf< tj|| ƒ d S )Nr6   r   )r:   r9   r   r#   )r   r#   )r   r#   )	r‡   r   rK   rð   Zfrom_productr]   r   r=   r>   )r@   rM   r   r   r   Ú!test_loc_set_dataframe_multiindex  s
    $ró   c              C   s8   t jtdƒt jddgtd�ƒ} | jd }|dks4t‚d S )Nr   r#   g       @)rV   r   )r‡   r   rK   ÚIndexr{   r   r^   )rÇ   rM   r   r   r   Útest_loc_mixed_int_float(  s    
rõ   c              C   sp   t jtdƒddddgd�} tjtdd�� d	| jd d
…< W d Q R X t jd	d	d	d
gddddgd�}tj| |ƒ d S )Nr(   rI   rŠ   r‹   rŒ   )r:   F)Úcheck_stacklevelr   r%   )r‡   r   rK   r=   Úassert_produces_warningÚFutureWarningr   rL   )rÇ   r@   r   r   r   Ú*test_loc_with_positional_slice_deprecation0  s
    rù   c              C   sê   t jddd�} t jtjjdƒ| d�}|d }d}x`||gD ]T}tjt|d�� |jd	d…  W d Q R X t	j
td
d�� d	|jd	d…< W d Q R X q:W tjt|d�� |jd	d…d	f  W d Q R X t	j
tƒ� d|jd	d…d	f< W d Q R X d S )Nz
2016-01-01r%   )rç   r   )r:   r   zOcannot do slice indexing on DatetimeIndex with these indexers \[1\] of type int)rj   r#   F)rö   )r%   r   )r‡   r   r   r;   rJ   rl   rm   r4   r   r=   r÷   rø   )Údtir?   rÇ   rq   Úobjr   r   r   Ú#test_loc_slice_disallows_positional;  s    rü   c              C   s¨   t jtjjddƒdddgt jdddd�d	�} | jd
dddg jƒ } | j}t j	|j
ƒ}d}tjt|d�� | j|  W d Q R X tjt|d�� | d j|  W d Q R X d S )Nr)   r%   r6   r0   r   Z2012ÚH)ræ   rç   )r9   r:   r   r   z/None of \[TimedeltaIndex.* are in the \[index\])rj   )r‡   r   r;   rJ   r±   r   rS   r]   r:   ZTimedeltaIndexZasi8rl   rm   r   r   )r?   rú   Ztdirq   r   r   r   Ú'test_loc_datetimelike_mismatched_dtypesW  s    rþ   c              C   s¤   t jdddd�} t jtjjddƒ| d�}tj||j|  ƒ tj||jt	| ƒ ƒ tj||jt	| ƒ ƒ tj|j
dd	… |j| dd	…  ƒ tj||jt	| ƒ ƒ d S )
Nz2002-01z2003-12r¡   )ræ   é   r$   )r:   r   r)   )r‡   Zperiod_ranger   r;   rJ   r±   r=   r>   r   r[   rS   )Úidxr?   r   r   r   Ú"test_loc_with_period_index_indexerm  s    $r  )$Ú__doc__Úior   r}   Znumpyr;   rl   Zpandas.compat.numpyr   Zpandasr‡   r   r   r   r   Zpandas._testingZ_testingr=   Zpandas.api.typesr   Zpandas.tests.indexing.commonr	   r
   rE   ré   rä   rå   rë   rì   rò   ró   rõ   rù   rü   rþ   r  r   r   r   r   Ú<module>   s@   
m      i
&
