3
Êb_8|  ã               @   sô   d Z ddlmZ ddlZddlZddl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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S )z$ test label based indexing with loc é    )ÚStringION)Ú	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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d0d1„ Zejjd2d3d4d5d6d7d8d9d:gƒd;d<„ ƒZd=d>„ Zd?d@„ ZdAdB„ Z ejjdCdDge!dEdDdEƒe"j#dDgƒgƒejjdFdGge"j#dGgƒgƒdHdI„ ƒƒZ$dJdK„ Z%dLdM„ Z&dNdO„ Z'dPdQ„ Z(dRdS„ Z)dTdU„ Z*dVdW„ Z+dXdY„ Z,dZd[„ Z-d\d]„ Z.d^d_„ Z/d`da„ Z0dbdc„ Z1dES )dÚTestLocc             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 )
Né   é   c             S   s   g | ]}d |d  ‘qS )ZABCDEr   © )Ú.0Úxr   r   ú@/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/indexing/test_loc.pyú
<listcomp>   s    z1TestLoc.test_loc_getitem_dups.<locals>.<listcomp>)ÚindexÚAr   )r
   r   )r   r   )r   ÚnpÚrandomZrandom_sampleÚrangeÚlocÚtmÚassert_series_equal)ÚselfÚdfÚexpectedÚresultr   r   r   Útest_loc_getitem_dups   s
     
zTestLoc.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 )
Né   é   ÚfooÚbarÚ20130101Úa)Úcolumnsr   )r   Únamer   )r   r   r   Úilocr   r   r   )r   r   r   r   r   r   r   Útest_loc_getitem_dups2   s    


zTestLoc.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Ãõ(\�ÂÕ?)Úmer    r!   Úbar2r*   Úrr!   r+   g       @ÚtgÃõ(\�ÂÕ¿)r   Úlistr   ÚarangeZ	set_indexÚtupleÚcopyr   r   r   ÚAssertionErrorÚassert_frame_equal)r   Zdf_origÚindexerr   r   r   r   Útest_loc_setitem_dups/   s$    zTestLoc.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   éÈ   i,  Zuint32)r)   )r#   Úbr#   r8   éÉ   i-  Úuint64)r   r   r   r   r3   )r   Zdf1ÚixZnewb1r   Zdf2Znewb2r   r   r   Útest_loc_setitem_sliceJ   s    " zTestLoc.test_loc_setitem_slicec             C   s   | j dddddgtd� d S )Nr   r   Úlabel)ÚtypsÚfails)Úcheck_resultÚKeyError)r   r   r   r   Útest_loc_getitem_int_   s    zTestLoc.test_loc_getitem_intc             C   s   | j dddddgtd� d S )Nr   ÚcÚempty)r>   r?   )r@   rA   )r   r   r   r   Útest_loc_getitem_labeld   s    zTestLoc.test_loc_getitem_labelc          
   C   s¼   | j dddddddddgtd� | j ddd	dd
gtd� | j ddddd
gtd� | j dddddddgtd� | j dddddgtd� | j dddddgdtd� | j ddddd
gdtd� d S )Nr   ÚfÚintsÚuintsÚlabelsÚmixedÚts)r>   r?   r;   Úfloatsr
   r   )r>   Úaxesr?   )r@   rA   Ú	TypeError)r   r   r   r   Ú#test_loc_getitem_label_out_of_rangei   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   s¢   | j ddddgddddgdgtd� | j ddddgddddgd	d
dgdtd� | j ddddgddddgd	d
dgdtd� | j ddddgddddgdgdtd� d S )Nr   r   r   r   rD   )r>   r?   é
   r;   rG   rH   rL   )r>   rM   r?   é   é   é   é   r   Zmulti)r   rR   )r   rU   )r   r   )r   rR   )r   rU   )r   r   )r@   rA   )r   r   r   r   Ú(test_loc_getitem_label_list_with_missing‚   s4     z0TestLoc.test_loc_getitem_label_list_with_missingc             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 )
NrR   r#   r8   rC   )r   zwith any missing labels)ÚmatchÚdr   )r   r   ÚpytestÚraisesrA   )r   Úsr   r   r   Ú$test_getitem_label_list_with_missing¥   s    z,TestLoc.test_getitem_label_list_with_missingc          	   C   s,   | j ddddgddddgddgdtd� d S )	Nr   r
   é   é(   rG   rH   r   )r>   rM   r?   )r@   rA   )r   r   r   r   Ú!test_loc_getitem_label_list_fails°   s    z)TestLoc.test_loc_getitem_label_list_failsc             C   s   d S )Nr   )r   r   r   r   Ú!test_loc_getitem_label_array_like¼   s    z)TestLoc.test_loc_getitem_label_array_likec             C   s(   ddddg}| j d|d|dgtd� d S )NTFr   rD   )r>   r?   )r@   Ú
IndexError)r   r8   r   r   r   Útest_loc_getitem_boolÁ   s    zTestLoc.test_loc_getitem_boolr   TFc          	   C   sJ   t dddgƒ}djt|ƒt|ƒƒ}tjt|d�� |j| }W d Q R X d S )Nr   r   rR   z0Boolean index has wrong length: {} instead of {})rW   )r   ÚformatÚlenrY   rZ   ra   r   )r   r   r[   ÚmsgÚ_r   r   r   Útest_loc_getitem_bool_diff_lenÇ   s
    z&TestLoc.test_loc_getitem_bool_diff_lenc             C   s   d S )Nr   )r   r   r   r   Útest_loc_getitem_int_sliceÑ   s    z"TestLoc.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 ) NrR   r#   r8   rC   ÚerF   Úg)r   r$   zJ\"None of \[Int64Index\(\[1, 2\], dtype='int64'\)\] are in the \[index\]\")rW   r   r   )r)   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\]\")rR   rR   éÿÿÿÿrm   éþÿÿÿrm   rm   rn   rn   rn   )	r   r   r   rY   rZ   rA   r   r   Úobject)r   r   re   r[   r   r   r   Útest_loc_to_failÕ   s@      



zTestLoc.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   rR   z="None of [Int64Index([3], dtype='int64')] are in the [index]")rW   zwith any missing labels)r   r   rY   rZ   rA   ÚreÚescape)r   r[   r   r   r   Útest_loc_getitem_list_with_fail  s    z'TestLoc.test_loc_getitem_list_with_failc          
   C   sÌ   | j dtddƒdtddƒdddddgtd	� | j dtd
dƒdtd
dƒdgdtd� | j dtddƒdtddƒdgdtd� | j dtddƒdtddƒdgdtd� | j dtdddƒdtdddƒdgdtd� d S )Nr   r   rR   rI   rJ   rD   rK   rL   )r>   r?   Z20130102Z20130104)r>   rM   r?   r   é   r   rU   )r@   ÚslicerN   rA   )r   r   r   r   Útest_loc_getitem_label_slice,  sN    

z$TestLoc.test_loc_getitem_label_slicec             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   rQ   )ÚsizeZalpha_0Zalpha_1Zalpha_2Zbeta_0Zbeta_1)r   c             S   s   d| kS )NÚalphar   )r   r   r   r   Ú<lambda>m  s    z(TestLoc.test_loc_index.<locals>.<lambda>Úboolean)r)   )r   rQ   )r   r   r   r   Úmapr   Úarrayr   r3   ÚvaluesÚpd)r   r   Úmaskr   r   r   r   r   Útest_loc_indexd  s    
zTestLoc.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 )NrU   r   ÚBÚCÚD)r$   r   r   r   r"   r   )r#   r8   r#   r8   )r   r%   )r   r   r   Úrandr   r&   r$   Úallr2   r   r   r   r   r   r)   ro   )r   r   r   r   r   r   r   Útest_loc_generaly  s    
(zTestLoc.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   r)   )r)   )ÚdateÚvalz
2000-01-01z	2000-01-5r‡   r    )r   g      ð?Z20180101Ústring)r   r   r   r   Úint64r   r   r   r3   r|   r   )r   r   r   r   r   r   Útest_loc_setitem_consistencyŒ  sL    (z$TestLoc.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 )Nr   Úy)r$   r   )r   Úastyper   rŠ   r   r   r3   )r   r   r   r   r   r   Ú"test_loc_setitem_consistency_emptyÖ  s    z*TestLoc.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   r%   )r�   r‘   )r�   r‘   )r�   r’   )r�   r’   )r�   r’   )r�   r‘   )r�   r“   )r�   r“   )r�   r“   )r�   r“   )r�   r“   )
r~   Zread_csvr   Úto_datetimer   r�   r   r   r   r   )r   Údatar   r   r   r   r   Ú-test_loc_setitem_consistency_slice_column_lenâ  s    	"""
z5TestLoc.test_loc_setitem_consistency_slice_column_lenÚunitÚYÚMrƒ   ÚhÚmr[   ÚmsÚusc             C   sª   t dtjdƒtjdƒgiƒ}|jd d …df jjdj|d�ƒ|jd d …|f< |jd d …df jjdj|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[{unit}])r—   r   )r%   )
r   r   Ú
datetime64r   r}   r�   rc   r   r   r   )r   r—   r   r   r   r   r   Útest_loc_assign_non_ns_datetime  s    z'TestLoc.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   rR   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)r$   )r   Z	from_dictr~   r”   r   Úapplyr   r3   )r   r   r   r$   r   r   r   Útest_loc_modify_datetime  s      
z TestLoc.test_loc_modify_datetimec       	      C   s¬  | j }|jd }d|jd< |jd }|dks0t‚|jd }|dksFt‚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   r   r#   r   r�   rƒ   rR   r   rU   )r   r$   r   rŠ   )r)   )r   )r   c             S   s   g | ]}d t |ƒ ‘qS )ú@)Ústr)r   Úir   r   r   r   M  s    z2TestLoc.test_loc_setitem_frame.<locals>.<listcomp>c             S   s   g | ]}d t |ƒ ‘qS )r¤   )r¥   )r   r¦   r   r   r   r   P  s    )r   r�   r8   )r   r   r#   )r   r)   r%   rS   )r   r   )r#   r   )r#   r   )r   r   )Zframe_labelsr&   r   r2   r   r3   r   r   r|   Údictr   Zreindexr   r/   r.   ÚsetÚunionÚnanr   r�   ro   r   )	r   r   r   r   Zkeys1Zval1Úkeys2Zval2r   r   r   r   Útest_loc_setitem_frame1  sR    



$"


zTestLoc.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 )Nr    r!   ZbazrR   )r)   )r   r�   r   r   r   z
2000-01-01z	2000-01-5r   )r‡   rˆ   Z20000101Z20000102Z20000103rU   )r   r   r   r   rŠ   r   r   r   r3   r   r   )r   r   Úrhsr   r   r   r   Ú test_loc_setitem_frame_multipless  s,     "z(TestLoc.test_loc_setitem_frame_multiplesr4   r   Nrl   Ú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   rR   rU   r   r�   )r$   r   r¯   )r   r   )r~   r   r   r   r2   )r   r4   rl   r   r   r   r   r   Ú"test_loc_setitem_with_scalar_index˜  s    	
z*TestLoc.test_loc_setitem_with_scalar_indexc             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‡   r"   ÚUTCr   r   iÜ  iô  r   Útextz
some wordsé	   rR   )
r   r   Útz_localizer~   ZNaTZdtypesr&   r   r   Údatetime)r   r   r   r   rµ   r   r   r   Útest_loc_coercion§  s(    "zTestLoc.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š  r    r!   )r   )r)   r   r   )r~   r”   r´   r   ro   r   r   r   )r   Úvalsr   Zserr   r   r   Útest_setitem_new_key_tzË  s    zTestLoc.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   rR   rU   r   rS   rT   rt   )r   r�   r   )r   z5'Cannot get left slice bound for non-unique label: 1')rW   z5'Cannot get left slice bound for non-unique label: 0')Úaxis)r   rY   rZ   rA   r   Z
sort_indexr   r3   )r   r   re   r   r   r   r   r   Útest_loc_non_uniqueß  s,    44*$zTestLoc.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   r$   r   )	r~   Úconcatr   r   r   Úrandnrd   r/   Úones)ÚlÚl2)r$   r   r   Úgen_test  s    z:TestLoc.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   r$   r   )rd   r~   r¼   Ztaker   r   r¾   )r   r   Zlen_mask)r$   r   r   Úgen_expected  s    
z>TestLoc.test_loc_non_unique_memory_error.<locals>.gen_expectedi„  r6   Fi » i † )	r.   r   Z	is_uniquer2   r   r/   r   r   r3   )r   rÁ   rÂ   r   r   r   r   r   )r$   r   Ú test_loc_non_unique_memory_error  s    







z(TestLoc.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   r%   r&   r2   r   )r   r   r   r   r   r   Útest_loc_name4  s    zTestLoc.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makeCustomDataframer3   r   r&   )r   r   r   r   r   Ú!test_loc_empty_list_indexer_is_ok>  s    ..z)TestLoc.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 )Nr#   r   r   rR   rU   rQ   r   r   rS   rT   rt   r³   )r   r   r2   r…   r   r   r½   r   )r   Zoriginal_dfZ	sliced_dfr   Zoriginal_seriesZsliced_seriesr   r   r   Ú&test_identity_slice_returns_new_objectN  s    z.TestLoc.test_identity_slice_returns_new_objectc             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   r:   )r   r   )
r~   r   r   ZiinfoÚmaxr   r&   r2   r   r   )r   r[   r   r   r   r   r   Útest_loc_uint64g  s    &
"zTestLoc.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jd	�}|jd |jd< tj||ƒ d S )Nr   r   rR   )r   rŒ   r   rŒ   )r$   g      ð?)r$   r)   r   )r   r   )r   r   )r   rd   r   r   r3   r   rª   Úfloat)r   r•   r   r   r   r   r   Útest_loc_setitem_empty_appendy  s    
z%TestLoc.test_loc_setitem_empty_appendc             C   sz   ddg}t ddgd�}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   r   rŒ   )r$   zFNone of \[Int64Index\(\[0, 1\], dtype='int64'\)\] are in the \[index\])rW   r   z?cannot copy sequence with size 2 to array axis with dimension 0)r   rY   rZ   rA   r   Ú
ValueError)r   r•   r   re   r   r   r   Ú$test_loc_setitem_empty_append_raisesŠ  s    z,TestLoc.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   rR   rU   r   )r%   )r   r   r   r|   r~   r   r   r   )r   r   r   r[   r   r   r   Útest_indexing_zerodim_np_arrayš  s    z&TestLoc.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|   r2   )r   r[   r   r   r   r   Ú%test_series_indexing_zerodim_np_array¡  s    z-TestLoc.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   rR   rU   r   rS   iÚ  iä  )r   )r   r)   iß  rm   )r   r   r~   r   r(   r   r   r   )r   r•   r   r   r   r   r   Útest_loc_reverse_assignment§  s
    z#TestLoc.test_loc_reverse_assignment)2Ú__name__Ú
__module__Ú__qualname__r   r'   r5   r<   rB   rE   rO   rP   rV   r\   r_   r`   rb   rY   ÚmarkÚparametrizerg   rh   rp   rs   rv   r€   r†   r‹   rŽ   r–   r    r£   r¬   r®   ru   r   r|   r°   r¶   r¹   r»   rÃ   rÄ   rÆ   rÇ   rÉ   rË   rÍ   rÎ   rÏ   rÐ   r   r   r   r   r	      sV   
#&
C8J&B%&$"3
r	   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Ÿ   )r)   r   r   rt   é   z
2001-01-01rƒ   rU   )ÚfreqZperiodszwith any missing labels)rW   )r   r|   r   r   rY   rZ   rA   r   )Úkeyr[   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 )NrR   ÚABC)r$   r   r   r�   r‚   )rÅ   )	r   r   r   r„   r.   r&   r   r   r3   )r$   Z
column_keyZexpected_columnsrÅ   r   r   r   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 )
Nrt   rU   g      à?r   g        g      ð?g       @g      @)r$   )r   r   r½   r~   r   rª   r   Zhstackr|   Zreshaper   r3   )Z	rand_datar   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 )rT   rt   r³   rQ   )rT   rt   r³   rQ   r   )r   Úyrr›   r   r   r   r   Þ  s    z)test_loc_axis_1_slice.<locals>.<listcomp>éÞ  éß  rQ   rt   Z
ABCDEFGHIJ)r   r$   r   )rº   r³   rU   rT   )rÞ   rß   )rQ   rt   )rÞ   r³   )rß   rt   )rQ   rU   )rÞ   r³   )rÞ   rQ   )rß   rT   )rß   rt   )
r~   r   r   r¾   r0   Z
MultiIndexÚfrom_tuplesr   r   r3   )Úcolsr   r   r   r   r   r   Útest_loc_axis_1_sliceÜ  s    râ   )Ú__doc__Úior   rq   Znumpyr   rY   Zpandasr~   r   r   r   r   Zpandas._testingZ_testingr   Zpandas.api.typesr   Zpandas.tests.indexing.commonr   r	   rÙ   rÔ   rÕ   rÛ   rÜ   râ   r   r   r   r   Ú<module>   s2   
       *
&