3
Êb_qY  ã               @   s–   d Z ddlmZ ddlmZmZ ddlZddlZddlZ	ddlm
Z
mZmZmZmZ ddljZddlmZ ddlmZ ddlmZ G d	d
„ d
eƒZdS )z* test positional based indexing with iloc é    )Údatetime)Úcatch_warningsÚsimplefilterN)Ú	DataFrameÚSeriesÚconcatÚ
date_rangeÚisna)Ú	is_scalar)ÚIndexingError)ÚBasec            	   @   sÊ  e Zd Zdd„ Zejjdejdƒe	dƒfgƒejjde
dƒdd	ggd
dge
dƒfedddƒge
dƒfgƒdd„ ƒƒZdd„ Zdd„ Zej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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/d0„ Zd1d2„ Zd3d4„ Zd5d6„ Zd7d8„ Zd9d:„ Zd;d<„ Z d=d>„ Z!ejjd?d@ge
dddƒej"d@gƒgƒejjdAdBgej"dBgƒgƒdCdD„ ƒƒZ#dEdF„ Z$dGdH„ Z%dIdJ„ Z&dKdL„ Z'dMdN„ Z(dOdP„ Z)dS )QÚTestiLocc          W   C   sè  t tjjdƒtdƒd�}d}tjt|d��$ |jd d …ddd	d
ddgf  W d Q R X tjt|d�� |jddg  W d Q R X tjt|d�� |jddg  W d Q R X tjt|d�� |jdg  W d Q R X |d }tjt|d�� |jdg  W d Q R X tjt|d�� |jdg  W d Q R X d}tjt|d�� |jd  W d Q R X tjt|d�� |jd  W d Q R X tjt|d�� |jd  W d Q R X tjt|d�� |jd  W d Q R X |jd d …dd…f }|jd d …dd …f }t	j
||ƒ |jd d …dd…f }|jd d …d d…f }t	j
||ƒ |jd d …ddd…f }|jd d …d dd …f }t	j
||ƒ |jd d …dd!d"…f }|jd d …dd d#…f }t	j
||ƒ |jd d …d$d…f }|jd d …d d…f }t	j
||ƒ |jd d …dd…f }|jd d …d d…f }t	j
||ƒ |jd d …d%d&d'…f }|jd d …d d…f }t	j
||ƒ |jd d …dd…f }|jd d …d d…f }t	j
||ƒ |jdd… }|jdd … }t	j||ƒ |jdd … }|jd d… }t	j||ƒ |jdd d(… }|jd d d)… }t	j||ƒ dd„ }t tjjdd	ƒtdƒd�}||jd d …d	d
…f t |jd�ƒ ||jd d …dd
…f |jd d …dgf ƒ ||jdd… |jdg ƒ d}tjt|d�� |jdddg  W d Q R X d}tjt|d�� |jd d …df  W d Q R X d S )*Né   é   ÚABCDE)Úcolumnsz%positional indexers are out-of-bounds)Úmatchr   é   é   é   é   é   éd   ÚAz*single positional indexer is out-of-boundsé
   é   é   c             S   s   t | ƒ | j tj| |ƒ d S )N)ÚstrÚdtypesÚtmÚassert_frame_equal)ÚresultÚexpected© r#   úA/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/indexing/test_iloc.pyÚcheckg   s    z0TestiLoc.test_iloc_exceeds_bounds.<locals>.checkZAB)Úindexé   )r   r   iâÿÿÿiœÿÿÿiâÿÿÿiâÿÿÿéüÿÿÿiöÿÿÿéÿÿÿÿr)   iöÿÿÿr)   r)   iöÿÿÿiöÿÿÿiõÿÿÿr)   r)   r)   )r   ÚnpÚrandomZrandom_sampleÚlistÚpytestÚraisesÚ
IndexErrorÚilocr   r    Úassert_series_equalÚrandnr&   )ÚselfÚdfÚmsgÚsr!   r"   r%   Zdflr#   r#   r$   Útest_iloc_exceeds_bounds   sˆ    ($,z!TestiLoc.test_iloc_exceeds_boundszindex,columnsr   r   zindex_vals,column_valsNr   ÚDÚ1Ú2iã  r   c          
   C   sP   t tjjt|ƒt|ƒƒ||d�}d}tjt|d�� |j||f  W d Q R X d S )N)r&   r   z$.iloc requires numeric indexers, got)r   )	r   r*   r+   r2   Úlenr-   r.   r/   r0   )r3   r&   r   Z
index_valsZcolumn_valsr4   r5   r#   r#   r$   Útest_iloc_non_integer_raisesx   s
    z%TestiLoc.test_iloc_non_integer_raisesc          
   C   s$   | j dddddddddgtd� d S )	Nr0   r   ÚlabelsÚmixedÚtsÚfloatsÚempty)ÚtypsÚfails)Úcheck_resultr/   )r3   r#   r#   r$   Útest_iloc_getitem_intŠ   s    zTestiLoc.test_iloc_getitem_intc          
   C   s$   | j dd	dd
dddddgtd� d S )Nr0   r   r=   r>   r?   r@   rA   )rB   rC   r)   r)   )rD   r/   )r3   r#   r#   r$   Útest_iloc_getitem_neg_int•   s    z"TestiLoc.test_iloc_getitem_neg_intÚdimsr   c          	   C   sV   |dkrt tjdƒƒ}nttjdƒjddƒƒ}tjtdd�� |jd  W d Q R X d S )Nr   r   r   zCannot index by location index)r   Úa)	r   r*   Úaranger   Úreshaper-   r.   Ú	TypeErrorr0   )r3   rG   r6   r#   r#   r$   Ú test_iloc_getitem_invalid_scalar    s
    z)TestiLoc.test_iloc_getitem_invalid_scalarc             C   s~   t jdddgƒ}|jƒ }tjdddgdddgd	d
dgdœdddgd�}|j|  tj||ƒ |jd d …|f  tj||ƒ d S )Nr   r   r   ée   éf   ég   éh   éi   éj   ék   él   )r   ÚBÚCr   )r&   r)   )r*   ÚarrayÚcopyÚpdr   r0   r   Zassert_numpy_array_equal)r3   Zarray_with_neg_numbersZ
array_copyr4   r#   r#   r$   Ú-test_iloc_array_not_mutating_negative_indices¬   s    
z6TestiLoc.test_iloc_array_not_mutating_negative_indicesc          
   C   s0   | j ddddgddddgddddd	gtd
� d S )Nr0   r   r   r   r=   r>   r?   r@   rA   )rB   rC   )rD   r/   )r3   r#   r#   r$   Útest_iloc_getitem_list_intº   s    z#TestiLoc.test_iloc_getitem_list_intc             C   sÖ   t dddgdddgdœƒ}|d }|jd	 }|jd }tj||ƒ |jd	g }|jdg }tj||ƒ |jd	 }|jd }||ks†t‚|jd	g }|jdg }tj||ƒ td
gdgd�}|jdg }tj||ƒ d S )Nr   r   r   é   r   é   )r   rU   r   r   rH   )r&   r   éýÿÿÿr^   r^   r^   r)   )r   r0   r   r1   r    ÚAssertionErrorr   )r3   r4   r6   r"   r!   r#   r#   r$   Ú/test_iloc_getitem_neg_int_can_reach_first_indexÇ   s"    



z8TestiLoc.test_iloc_getitem_neg_int_can_reach_first_indexc             C   s˜   t d ddœdddœgƒ}t dddœdddœgƒ}t||gdd�}|jd }t|ƒsVt‚|jdd d …f }ttjdddgdd	dd	gdd
�}tj	||ƒ d S )Nr   )r   rU   r   r   r   )Úaxisr   r   rU   )r&   Úname)r   r   )
r   r   r0   r	   r_   r   r*   Únanr   r1   )r3   Údf1Údf2r4   r!   r"   r#   r#   r$   Útest_iloc_getitem_dupsâ   s    
 zTestiLoc.test_iloc_getitem_dupsc             C   s   d S )Nr#   )r3   r#   r#   r$   Útest_iloc_getitem_arrayð   s    z TestiLoc.test_iloc_getitem_arrayc             C   s   d S )Nr#   )r3   r#   r#   r$   Útest_iloc_getitem_boolô   s    zTestiLoc.test_iloc_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   r   z0Boolean index has wrong length: {} instead of {})r   )r   Úformatr;   r-   r.   r/   r0   )r3   r&   r6   r5   Ú_r#   r#   r$   Útest_iloc_getitem_bool_diff_lenø   s
    z(TestiLoc.test_iloc_getitem_bool_diff_lenc             C   s   d S )Nr#   )r3   r#   r#   r$   Útest_iloc_getitem_slice  s    z TestiLoc.test_iloc_getitem_slicec             C   s¦  t tjjddƒddddgd�}t tjjdddd�jdd	ƒdd
gd�}t||gdd�}tj|j	d d …d d…f |ƒ tj|j	d d …dd …f |ƒ t||gdd�}tj|j	d d …d d	…f |ƒ tj|j	d d …d	d …f |ƒ t||j	d d …dgf gdd�}tj|j	d d …dd…f |ƒ t||gdd�}tj|j	dd…d d	…f |ƒ tj|j	dd…d	d …f |ƒ tj|j	dd …d d	…f |ƒ tj|j	dd …d	d …f |ƒ d S )Nr   r   r   rU   )r   r   r   )Úsizer   rV   r   )ra   r   )
r   r*   r+   r2   ÚrandintrJ   r   r   r    r0   )r3   rd   re   r4   Úexpr#   r#   r$   Útest_iloc_getitem_slice_dups  s     $ z%TestiLoc.test_iloc_getitem_slice_dupsc             C   sÄ   | j }d|jd	< |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dgd�}|jdd…  d7  < tdddgdddgd�}tj||ƒ d S )Nr   r   r   r   r   r   r'   )r&   )r   r   )r   r   )Z
frame_intsr0   r_   r   r    r   r1   )r3   r4   r!   r"   r6   r#   r#   r$   Útest_iloc_setitem   s    

zTestiLoc.test_iloc_setitemc             C   s¢   t tjdƒjdƒdddgdddgd�}|jddgdd	gf  |jddgdd	gf  d
7  < t tjdddddddddg	ƒjdƒdddgdddgd�}tj||ƒ d S )Né	   r   r   rU   rV   )r&   r   r   r   r   r   rM   rN   rP   rQ   r'   r\   é   )r   r   )r   r   )r   r*   rI   rJ   r0   rW   r   r    )r3   r4   r"   r#   r#   r$   Útest_iloc_setitem_list2  s    $ zTestiLoc.test_iloc_setitem_listc             C   sz   t ddddgƒ}t ddddgƒ}|jƒ }ddg|jt ddgƒ< tj||ƒ |jƒ }d	d
g|jtjddgƒ< tj||ƒ d S )Nr   r   r   r   r)   éþÿÿÿr)   ru   r)   ru   )r   rX   r0   r   r1   rY   ÚIndex)r3   Zs_origr"   r6   r#   r#   r$   Útest_iloc_setitem_pandas_objectB  s    z(TestiLoc.test_iloc_setitem_pandas_objectc             C   sx  t d ddœdddœgƒ}t dddœdddœgƒ}t||gdd�}|jdƒ}|d jdƒ|d< tj|jd d …d	f ƒ}|| j}|j|df |j|d	f< tj	||ƒ t ddgddgd
œƒ}ddg|_
|d= tj	||ƒ |jd	dgd	dgf |jd	dgd	dgf< tj	||ƒ |jdd	gd	dgf jdd�|jdd	gd	dgf< |jdd	gd	dgf jdd�|jdd	gd	dgf< tj	||ƒ d S )Nr   )r   rU   r   r   r   )ra   r   Zfloat64r   )r   r   rU   T)Zdrop)r   r   ZfillnaZastyper*   Úisnanr0   r&   r   r    r   Zreset_index)r3   rd   re   r4   r"   ZindsÚmaskr#   r#   r$   Útest_iloc_setitem_dupsO  s$    


(00zTestiLoc.test_iloc_setitem_dupsc             C   sì  t tjjddƒtdddƒtdddƒd�}|jd }|jd }tj||ƒ |jd }|jd }||ksht	‚|jdd… }|jdd… }tj
||ƒ |jd d …dd	…f }|jd d …dd
…f }tj
||ƒ |jddd	g }|jdddg }tj
||ƒ |jddd	gddgf }|jdddgddgf }tj
||ƒ |jddd	gddgf }|jdddgddgf }tj
||ƒ |jdddd	gddgf }|jddddgddgf }tj
||ƒ ttdd
ƒtd�}|j|j }|jddddg }tj
||ƒ d S )Nr   r   r   r   r   rs   )r&   r   é   r   r   r   r'   r   )r&   Údtype)r   r   )r   r   r)   r)   r)   r)   r)   )r   r*   r+   r2   Úranger0   Úlocr   r1   r_   r    r   Úobjectr&   )r3   r4   r!   ro   r"   r6   r#   r#   r$   Útest_iloc_getitem_frameo  s<    &



z TestiLoc.test_iloc_getitem_framec             C   sê   t tjjddƒtdƒtdƒd�}|jd }|jd }||ks@t‚|jd d …d	d
…f }|jd d …dgf }tj	||ƒ |jd }|jd }||ks–t‚d}t
jt|d�� |jd  W d Q R X d}t
jt|d�� |jd  W d Q R X d S )Nr   r   Ú
abcdefghijÚABCD)r&   r   r   ÚbrU   r   r   rV   Újr8   z*single positional indexer is out-of-bounds)r   r   zžLocation based indexing can only have \[integer, integer slice \(START point is INCLUDED, END point is EXCLUDED\), listlike of integers, boolean array\] types)r   r   )rƒ   rU   r)   r)   )r)   r)   )r„   r8   )r   r   )r„   r8   )r   r*   r+   r2   r,   r0   r~   r_   r   r    r-   r.   r/   Ú
ValueError)r3   r4   r!   ro   r"   r5   r#   r#   r$   Ú test_iloc_getitem_labelled_framež  s"    



z)TestiLoc.test_iloc_getitem_labelled_framec             C   s¦  t jjddƒ}tddd�}tdƒ}t|||d�}|jƒ  |jdd…d	d
…f }t|ƒ |j	 t|dd…d	d
…f |dd… |d	d
… d�}t
j||ƒ tdƒ|_|jdd…d	d
…f }t|ƒ |j	 t|dd…d	d
…f |dd… tdƒd�}t
j||ƒ t jjddƒ}ttd	dd
ƒƒ}ttd	dd
ƒƒ}t|||d�}|jjd	 j |jdd…d
d…f }t|ƒ |j	 t|dd…d
d…f |dd… |d
d… d�}t
j||ƒ d S )Nr'   r   Z20130101)Zperiodsr‚   )r&   r   r   r   r   r   ZaaaaZaaé   rs   r   )r*   r+   r2   r   r,   r   Zdescriber0   r   r   r   r    r   r}   Ú_dataÚblocksZmgr_locs)r3   Zarrr&   r   r4   r!   r"   r#   r#   r$   Útest_iloc_getitem_doc_issue¿  s4    .
*.z$TestiLoc.test_iloc_getitem_doc_issuec             C   sb  t tjjddƒtdƒtdƒd�}d|jd< |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	tjjdƒt
dd
dƒd�}d|jd< |jd }|dksÊt‚d|jd d…< |jd d… }|jd d… }tj||ƒ t	dgd ƒ}dddg|jdd d…< dd	dg|jdd d…< |}t	dddd	ddgƒ}tj||ƒ d S )Nr   r   r�   r‚   )r&   r   r   r   r   r   r   )r&   r'   r   )r   r   )r   r   r)   )r   r*   r+   r2   r,   r0   r_   r   r    r   r}   r1   )r3   r4   r!   r"   r6   r#   r#   r$   Útest_iloc_setitem_seriesé  s.    



z!TestiLoc.test_iloc_setitem_seriesc             C   sÞ   t ttjddd�tjdddd�d�ƒ}ddgddgg|jd	d
…< t tddddd
gdddddgd�ƒ}tj||ƒ t ttdƒtjdddd�d�ƒ}ddgddgg|jd	d
…< t tdddddgdddddgd�ƒ}tj||ƒ d S )Nr   Zint64)r|   r   )r   rU   r   r‡   r]   r   r   r   r   r'   rr   ZabcdeÚxÚyrH   rƒ   Úe)r   Údictr*   rI   r0   r   r    r,   )r3   r4   r"   r#   r#   r$   Útest_iloc_setitem_list_of_lists	  s    $$ $z(TestiLoc.test_iloc_setitem_list_of_listsÚindexerr   ÚvalueÚ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   r   rU   )r   r   r“   )r   r   )rY   r   r0   r
   r_   )r3   r‘   r’   r4   r!   r#   r#   r$   Ú#test_iloc_setitem_with_scalar_index  s    
z,TestiLoc.test_iloc_setitem_with_scalar_indexc          +   C   s"  t ttdƒƒtdƒdgd�}|jd dk}d}tjt|d�� |j|  W d Q R X tt|ƒƒ|_	d	}tjt
|d�� |j|  W d Q R X |jtjd
gt|ƒ td� }tj||ƒ tjdƒ}d| }dd„ |D ƒ}t ||dœ|ƒ}ddddd dd!dd"dd#dd$dd%dd&d	i	}td
d��� tdtƒ tƒ }xêd'D ]â}	|jdkj}|	�r\t|ttt||	ƒƒƒƒ}x°d(D ]¨}
y:|
�r‚t||
dd … ƒ}n|}tt|| d jƒ ƒƒ}W n2 ttt
fk
�rÒ } zt|ƒ}W Y d d }~X nX t|	|
gƒ}|j|ƒ}||k�rbt dj!|||d�ƒ‚�qbW �q.W W d Q R X d S ))Nr   r   rH   )r&   r   r   r   zBiLocation based boolean indexing cannot use an indexable as a mask)r   zDiLocation based boolean indexing on an integer type is not availableT)r|   r   c             S   s   g | ]}t |ƒ‘qS r#   )Úbin)Ú.0Únumr#   r#   r$   ú
<listcomp>:  s    z+TestiLoc.test_iloc_mask.<locals>.<listcomp>)ÚlocsÚnumsÚ Z0b1100ú.locú.ilocr&   Z0b11r™   ztUnalignable boolean Series provided as indexer (index of the boolean Series and of the indexed object do not match).)ÚrecordÚignorer   rš   z.[{key}] does not match [{ans}], received [{r}])ÚkeyÚansÚr)Nr›   )Nrœ   )Nr�   )r&   r›   )r&   rœ   )r&   r�   )r™   r›   )r™   rœ   )r™   r�   )Nr&   r™   )r›   rœ   r�   )"r   r,   r}   rH   r-   r.   r…   r0   r;   r&   ÚNotImplementedErrorr*   rW   Úboolr   r    rI   r   r   ÚUserWarningr�   rš   Úvaluesr   ÚreversedÚgetattrr   r•   Úsumr   ÚtupleÚgetr_   ri   )r3   r4   ry   r5   r!   r™   rš   Zrepsr"   ÚidxÚmethodZaccessorr¡   rŽ   r    r¢   r#   r#   r$   Útest_iloc_mask&  s^    





zTestiLoc.test_iloc_maskc          	   C   s¶   t dgd dgd dœƒ}tjdƒd }|j| }t|d| d| gƒ}|j| }tj||ƒ t dgd	 dgd	 dœƒ}t|d| d| gƒ}tjt	d
d�� |j
|  W d Q R X d S )Ngš™™™™™¹?i¸  r   )r   rU   r   éc   r   r   iè  zwith any missing labels)r   )r   r*   rI   r0   r   r   r    r-   r.   ÚKeyErrorr~   )r3   r4   r¬   r"   Zdf3r!   re   r#   r#   r$   Útest_iloc_non_unique_indexingm  s    

z&TestiLoc.test_iloc_non_unique_indexingc             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_typeZcheck_column_type)r   ZmakeCustomDataframer    r0   )r3   r4   r#   r#   r$   Ú"test_iloc_empty_list_indexer_is_ok  s    z+TestiLoc.test_iloc_empty_list_indexer_is_okc             C   s°   t ddddgiƒ}|jd d … }||k	s,t‚dddg|d< |d dkjƒ sNt‚tddddddgƒ}|jd d … }||k	s|t‚dd	d
g|d d…< t|d d… dd	d
gkƒs¬t‚d S )NrH   r   r   r   r   r   r'   r\   rs   rr   )r   r0   r_   Úallr   )r3   Zoriginal_dfZ	sliced_dfZoriginal_seriesZsliced_seriesr#   r#   r$   Ú&test_identity_slice_returns_new_object•  s    z/TestiLoc.test_identity_slice_returns_new_objectc             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   )rb   )r   r0   r*   rW   rY   r   r   r1   )r3   r4   r!   r6   r#   r#   r$   Útest_indexing_zerodim_np_array§  s    z'TestiLoc.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   r0   r*   rW   r_   )r3   r6   r!   r#   r#   r$   Ú%test_series_indexing_zerodim_np_array®  s    z.TestiLoc.test_series_indexing_zerodim_np_array)*Ú__name__Ú
__module__Ú__qualname__r7   r-   ÚmarkZparametrizer*   rI   r,   Úslicer   r<   rE   rF   rL   rZ   r[   r`   rf   rg   rh   rk   rl   rp   rq   rt   rw   rz   r€   r†   rŠ   r‹   r�   rW   r”   r®   r±   r²   r´   rµ   r¶   r#   r#   r#   r$   r      sH   f$&
 /!* $&Gr   )Ú__doc__r   Úwarningsr   r   Znumpyr*   r-   ZpandasrY   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#   r$   Ú<module>   s   
