3
®ybz¹  ã               @   sœ   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
mZmZmZ d dljZG dd„ dƒZdd„ Zdd	„ Zd
d„ Zdd„ Zdd„ Zdd„ ZdS )é    )ÚdatetimeN)Ú	DataFrameÚIndexÚ
MultiIndexÚPeriodÚSeriesÚ	TimedeltaÚ
date_rangec               @   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dd„ Zdd„ Zejjddgd"d"d#d#gd"d"d#d#gd"d"d#d#gd"d"d#d#ggejjdhdidjdkgd&d'gd(�ejjdldmdndogd,dpgd(�fdrd"d"d"d"d#d#d#d#gd"d"d"d"d#d#d#d#ggejd$d%gd'd-�ejjdsdtdudvdwdxdydzgd,d{d&gd(�fgƒd.d/„ ƒZd0d1„ Zd2d3„ Zd4d5„ Zd6d7„ Zd8d9„ Zd:d;„ Zd<d=„ Z d>d?„ Z!d@dA„ Z"dBdC„ Z#ejjdDd d'ge$d,ƒgƒdEdF„ ƒZ%dGdH„ Z&dIdJ„ Z'dKdL„ Z(dMdN„ Z)dOdP„ Z*dQdR„ Z+ejjdSdTdUgƒejjdVe,dWƒe,dXƒgƒdYdZ„ ƒƒZ-d[d\„ Z.ejjd]d^d^d"d"gejj/d"d#gd!d*ggƒfd^d^d#d$gejj/d"d#gd!d*ggƒfd^d"d#d$gejj/d"d#gd!d*ggƒfgƒd_d`„ ƒZ0ejjdad^d"gƒdbdc„ ƒZ1ejjdad^ddgƒdedf„ ƒZ2d,S )|ÚTestDataFrameReshapec             C   sÔ   ddddddgddddddgddddddgd	œ}t |ƒ}|jd
ddd	�}t ddddœddddœdœƒ}d\|j_|j_tj||ƒ |jjd
ks’t‚|jjdks¢t‚|jd
dd�}|jjd
ksÀt‚|jjdksÐt‚d S )NÚAÚBÚCÚOneÚTwog      ð?g       @g      @)ÚindexÚcolumnsÚvaluesr   r   r   )r   r   r   )r   r   )r   r   )r   r   )Nr   )	r   Úpivotr   Únamer   ÚtmÚassert_frame_equalÚAssertionErrorÚnames)ÚselfÚdataÚframeZpivotedÚexpected© r   úC/tmp/pip-install-4cy230dp/pandas/pandas/tests/frame/test_reshape.pyÚ
test_pivot   s    
zTestDataFrameReshape.test_pivotc             C   sZ   t dddddgdddddgdddddgd	œƒ}tjtd
d�� |jdddƒ W d Q R X d S )NÚbarÚfooÚoneÚtwog      ð?g       @g      @g      @)ÚaÚbÚczduplicate entries)Úmatchr$   r%   r&   )r   ÚpytestÚraisesÚ
ValueErrorr   )r   r   r   r   r   Útest_pivot_duplicates*   s    z*TestDataFrameReshape.test_pivot_duplicatesc             C   s8   t dddgd�}|jdddƒ}t ƒ }tj||dd� d S )Nr$   r%   r&   )r   F)Úcheck_names)r   r   r   r   )r   ÚdfÚresultr   r   r   r   Útest_pivot_empty5   s    z%TestDataFrameReshape.test_pivot_emptyc             C   sD   t ddgd�}|jdd	d
d�}t|ƒ tj|jtddgd	d�ƒ d S )Nr   Ú1ÚA1r   Ú2ÚB2)r   é   r   é   )r   r   r   )r   )r   r0   r1   )r   r2   r3   )r   r   Úreprr   Zassert_index_equalr   r   )r   r-   r.   r   r   r   Útest_pivot_integer_bug;   s    z+TestDataFrameReshape.test_pivot_integer_bugc             C   s  ddddddgddddddgddddddgd	œ}t |ƒjd
ƒ}|jddd�}t ddddœddddœdœƒ}d\|j_|j_tj||ƒ |jdd�}tj	j
ddgd dgd�|_d
|j_tj||dd� |jjd
ksÔt‚|jjdksät‚|jjdƒ|_|jddd�}d|j_tj||ƒ d S )Nr   r   r   r   r   g      ð?g       @g      @)r   r   r   r   r   r   )r   r   )r   r   r   )r   r   )r   )r   F)r,   r   )r   r   )r   r   )r   r   )Nr   )r   Ú	set_indexr   r   r   r   r   r   Úpdr   Úfrom_tuplesr   r   Ú	droplevel)r   r   r   r.   r   r   r   r   Útest_pivot_index_noneB   s*    
z*TestDataFrameReshape.test_pivot_index_nonec       	      C   s¤   |j ƒ }tjtj|jƒƒj|jƒ|d d …< |jƒ }t||dœƒ}|jƒ }|jƒ }t	j
||ƒ t	j
|d |ƒ |jdƒ}|jdƒ}t	j
|j|ƒ t	j
|d j|ƒ d S )N)r!   r    r    r   )ÚcopyÚnpÚarangeÚprodÚshapeÚreshapeÚstackr   Úunstackr   r   ÚT)	r   Úfloat_framer-   ÚstackedZ
stacked_dfÚ	unstackedZunstacked_dfZunstacked_colsZunstacked_cols_dfr   r   r   Útest_stack_unstackf   s    "

z'TestDataFrameReshape.test_stack_unstackc             C   sä   t dƒdddgddgg}td|d |d d�}|jƒ }tdtj|d d… ƒd�}tj||ƒ td|d tj|dd … ƒd�}|jdƒ}tdtj|d |d gƒ|d d�}tj||ƒ |ddg jdƒ}|ddg }tj||ƒ d S )	Né   r$   r%   r4   r5   r   )r   r   )r   )	Úranger   rC   r   r   Úfrom_productr   Úassert_series_equalr   )r   Úlevelsr-   r.   r   r   r   r   Útest_stack_mixed_levelx   s     
"z+TestDataFrameReshape.test_stack_mixed_levelc             C   sj   t jddtjgddtjgdœƒ}|dg }|d |d< t|jjƒdksJt‚|jƒ }|jƒ }t	j
||ƒ d S )Nr4   r5   g      @é   )ÚxÚyrQ   rR   )r9   r   r>   ÚNaNÚlenÚ_mgrÚblocksr   rD   r   rM   )r   r-   Údf2Úresr   r   r   r   Útest_unstack_not_consolidated�   s     
z2TestDataFrameReshape.test_unstack_not_consolidatedc       	      C   s–  t ddddgtjd�}tjddddgƒ|_|jdd�}tdddgdddgdœdd	d
gtjd�}tj	||ƒ |jdd�}tdddgdddgdœdd	d
gt
d�}tj	||ƒ tdddgdddgdddgdddgdœƒjdd	d
gƒ}|jdd	gdd�}d}|| }tj dddg|j|d�}tj||ƒ |jdd	gƒ}|jj|jjƒ|_|jtjƒ}|j|j }tj	||ƒ |d }|jdd	gdd�}|d }tj	||ƒ d S )Nr4   r5   rP   é   )ÚdtyperQ   r$   r%   rR   Úz)Ú
fill_value)r$   r%   )r   r[   g      à?ÚjÚkr   )rQ   rR   r\   Úwr`   )r   r   )rQ   r$   )rQ   r%   )rR   r%   )r\   r$   éÿÿÿÿra   ra   )r`   r%   r^   )r   r>   Úint16r   r:   r   rD   r   r   r   Úfloatr8   r9   rM   rC   Zreorder_levelsr   ÚastypeÚint64Úloc)	r   r   r.   r   r-   rH   ÚkeyrG   Úsr   r   r   Útest_unstack_fillš   s8    &$(z&TestDataFrameReshape.test_unstack_fillc             C   sr  ddgddgddgddgg}t |td	ƒtjd
�}tjddddgƒ|_|jdd�}ddddgddddgddddgg}t |tdƒtjd�}tjdd d!d"gƒ|_t	j
||ƒ |d jtjƒ|d< |d jtjƒ|d< |jd#d�}|d jtjƒ|d< |d jtjƒ|d< t	j
||ƒ |jdd�}ddddgddddgddddgg}t |tdƒtd�}tjd$d%d&d'gƒ|_t	j
||ƒ d S )(Nr4   r5   rJ   rP   rZ   é   é   é   ZAB)r   r[   rQ   r$   r%   rR   r\   )r]   Úxyz)r   r[   r   r   g      à?)rQ   r$   )rQ   r%   )rR   r%   )r\   r$   ra   ra   ra   ra   ra   )r   r$   )r   r%   )r   r$   )r   r%   ra   )r   r$   )r   r%   )r   r$   )r   r%   )r   Úlistr>   Zint32r   r:   r   rD   r   r   r   rd   rb   Úfloat64rc   )r   Úrowsr-   r.   r   r   r   r   Útest_unstack_fill_frameÉ   s,    ""z,TestDataFrameReshape.test_unstack_fill_framec             C   sÔ   t jddd�j}t|ƒ}tjddddgƒ|_|jƒ }t|d	 t j	|d
 g|d |d t j	gdœdddg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 )Nz
2012-01-01rP   )ÚperiodsrQ   r$   r%   rR   r\   r   rJ   r4   r5   )r$   r%   )r   )r]   )rQ   r$   )rQ   r%   )rR   r%   )r\   r$   )r9   r	   r   r   r   r:   r   rD   r   ÚNaTr   r   )r   Zdvr   r.   r   r   r   r   Ú test_unstack_fill_frame_datetimeî   s    (,z5TestDataFrameReshape.test_unstack_fill_frame_datetimec             C   sÖ   dd„ t dƒD ƒ}t|ƒ}tjddddgƒ|_|jƒ }t|d	 tj|d
 g|d |d tjgdœdddg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 )Nc             S   s   g | ]}t |d �‘qS ))Údays)r   )Ú.0Úir   r   r   ú
<listcomp>  s    zJTestDataFrameReshape.test_unstack_fill_frame_timedelta.<locals>.<listcomp>rP   rQ   r$   r%   rR   r\   r   rJ   r4   r5   )r$   r%   )r   )r]   )rQ   r$   )rQ   r%   )rR   r%   )r\   r$   )rK   r   r   r:   r   rD   r   r9   rs   r   r   )r   Útdr   r.   r   r   r   r   Ú!test_unstack_fill_frame_timedelta  s    (,z6TestDataFrameReshape.test_unstack_fill_frame_timedeltac             C   sÜ   t dƒt dƒt dƒt dƒg}t|ƒ}tjddddgƒ|_|jƒ }t|d
 d |d g|d |d d gdœddd	g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 )Nz2012-01z2012-02z2012-03z2012-04rQ   r$   r%   rR   r\   r   rJ   r4   r5   )r$   r%   )r   )r]   )rQ   r$   )rQ   r%   )rR   r%   )r\   r$   )	r   r   r   r:   r   rD   r   r   r   )r   rr   r   r.   r   r   r   r   Útest_unstack_fill_frame_period  s$    
$z3TestDataFrameReshape.test_unstack_fill_frame_periodc             C   sú   t jddddgdd�}t jjddddgƒ|_|jƒ }tt jtd	ƒtd
ƒd�t jtdƒtd
ƒd�dœtdƒd�}t	j
||ƒ d}tjt|d�� |jdd� W d Q R X |jdd�}tt jtdƒtd
ƒd�t jtdƒtd
ƒd�dœtdƒd�}t	j
||ƒ d S )Nr$   r%   r&   Úcategory)r[   rQ   rR   r\   ZaxaÚabc)Ú
categoriesZbcx)r$   r%   rm   )r   z 'fill_value=d' is not present in)r'   Úd)r]   ZacaZbcc)rQ   r$   )rQ   r%   )rR   r%   )r\   r$   )r9   r   r   r:   r   rD   r   ÚCategoricalrn   r   r   r(   r)   r*   )r   r   r.   r   Úmsgr   r   r   Ú#test_unstack_fill_frame_categorical;  s$    z8TestDataFrameReshape.test_unstack_fill_frame_categoricalc          
   C   sÄ   t jjdddgdddggddgd	�}t jdgd
 dgd
 dœ|d�}|jdƒ}t jddddddgddddddgddddddggt jjddddddgd dgd	�t jdddgdd�d�}tj||ƒ d S )Nr$   r%   r&   r4   r5   rJ   r   r   )r   é	   )r   Úe)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%   )	r9   r   rL   r   rD   r:   r   r   r   )r   Úidxr-   r.   r   r   r   r   Ú$test_unstack_tuplename_in_multiindex^  s      
,
z9TestDataFrameReshape.test_unstack_tuplename_in_multiindexz>unstack_idx, expected_values, expected_index, expected_columnsr   r$   r4   r5   rJ   rP   r   r   )r   r   r%   r„   N)r   c       	      C   sr   t jjddgddgddggddd	gd
�}t jdgd dgd dœ|d�}|j|ƒ}t j|||d�}tj||ƒ d S )Nr$   r%   r4   r5   rJ   rP   r   r   r   )r   rl   )r   r„   )r   )r   r   )r   r$   )r9   r   rL   r   rD   r   r   )	r   Zunstack_idxZexpected_valuesZexpected_indexZexpected_columnsr…   r-   r.   r   r   r   r   Ú*test_unstack_mixed_type_name_in_multiindexw  s    &" 
z?TestDataFrameReshape.test_unstack_mixed_type_name_in_multiindexc             C   s*  t jtdddgdddgt jdddgƒjdƒtjjdƒd	d
t jdƒt jdddgƒjdƒt jdddgƒjdƒdt jd	ddgdd�d�ƒ}dd„ }|j	ddgƒ}||dƒ |j	ddgƒ}||dƒ |j	dd gƒ}||dƒ |j	d!d"dgƒ}||d"ƒ |j	d#d$gƒ}||d#ƒ |j	ddgƒ}|d$ }||dƒ d S )%NZILZMIZNCr$   r%   r&   r|   rJ   r4   r!   Z20010102g      ð?g      I@g      Y@Zfloat32g      @g      @g      @ro   FéÈ   i2 Zint8)r[   )Ústater   Úsome_categoriesr   r   r   ÚDÚEÚFÚGÚHc             S   s&   | j |gƒ}| j |ƒ}tj||ƒ d S )N)rD   r   r   )r-   Zcolumn_nameZ
unstacked1Z
unstacked2r   r   r   Úunstack_and_compareº  s    
zNTestDataFrameReshape.test_unstack_preserve_dtypes.<locals>.unstack_and_comparer‰   r   rŠ   r�   r   rŽ   r   rŒ   r   )
r9   r   Údictr   rd   r>   ÚrandomZrandÚ	Timestampr8   )r   r-   r�   Zdf1rh   r   r   r   Útest_unstack_preserve_dtypes¨  s6    





z1TestDataFrameReshape.test_unstack_preserve_dtypesc             C   sÖ   t jttjtdƒdd�ƒƒ}ttjj	ddƒ|d�}t
j|jddgd�|jdd�jdd�ƒ t
j|jddgd�|jdd�jdd�ƒ |jƒ }|jjtdƒd	d
�}|d ksªt‚t
j|jddgd�|jdd�jdd�ƒ d S )NrJ   )Úrepeaté   é   )r   r4   r5   )ÚlevelT)Zinplaceéþÿÿÿra   )r   r:   rn   Ú	itertoolsÚproductrK   r   r>   r’   Úrandnr   r   rC   r=   r   Z	set_namesr   )r   r   r-   Zdf_namedZreturn_valuer   r   r   Útest_stack_intsÒ  s    ($z$TestDataFrameReshape.test_stack_intsc             C   s  t jddddgddd	gd
�}ttjjddƒ|d�}|jdd	gd�}|jdd	gd�}|jƒ }dddg|j_	t
j|jddgd�|dd� t
j|jddgd�|dd� d}tjt|d�� |jddgd� W d Q R X |jƒ }dddg|j_	t
j|jddgd�|dd� d S )Nr   ÚcatÚlongr   ÚdogÚshortÚexpÚanimalÚhair_length)r   rP   )r   )r˜   r4   F)r,   zSlevel should contain all level names or all level numbers, not a mixture of the two)r'   r   )r   rž   rŸ   )r   rž   rŸ   )r   r    r¡   )r   r    r¡   )r   r:   r   r>   r’   rœ   rC   r=   r   r   r   r   r(   r)   r*   )r   r   r-   Úanimal_hair_stackedÚexp_hair_stackedrW   r�   Údf3r   r   r   Útest_stack_mixed_levelsã  s,    z,TestDataFrameReshape.test_stack_mixed_levelsc             C   s:  t jddddgddd	gd
�}ttjjddƒ|d�}|jddgd�}|jdd	gd�}|jdd	gd�}|jƒ }dddg|j_	t
j|jddgd�|dd� t
j|jddgd�|dd� t
j|jddgd�|dd� |jƒ }dddg|j_	t
j|jddgd�|dd� t
j|jddgd�|dd� t
j|jddgd�|dd� d S )Nr   rž   rŸ   r   r    r¡   r¢   r£   r¤   )r   rP   )r   )r˜   r   r4   r5   F)r,   )r   rž   rŸ   )r   rž   rŸ   )r   r    r¡   )r   r    r¡   )r   r:   r   r>   r’   rœ   rC   r=   r   r   r   r   )r   r   r-   Zexp_animal_stackedr¥   r¦   rW   r§   r   r   r   Útest_stack_int_level_names  s4    z/TestDataFrameReshape.test_stack_int_level_namesc             C   s|   t ddgtjddgddggƒdgd�}|jƒ }t tjdtjgtjdggtd�ddgtjddgddggƒd�}tj	||ƒ d S )	NFr$   r%   r&   ÚlÚcol)r   r   )r[   )
r   r   Úfrom_arraysrD   r>   ÚarrayÚnanÚobjectr   r   )r   r-   ÚrsZxpr   r   r   Útest_unstack_bool8  s    
z&TestDataFrameReshape.test_unstack_boolc             C   sö   t jddgddgddggddddgddddgddddggd	d
dgd�}t jd|d�}|jddgƒjdƒ}t jddgddggddddgddddggd	d
gd�}t jtjtjdgdtjgtjdgdtjggtj	d�|t j
ddgdd�d�}tj||ƒ d S )Nr!   r    r"   r#   r$   r%   r   r4   ÚfirstÚsecondZthird)rN   Úcodesr   )r   r5   )r[   )r   )r   r   )r9   r   r   rD   rC   r   r>   r­   r®   ro   r   r   r   )r   Úmirh   r.   Zexpected_mir   r   r   r   Útest_unstack_level_bindingF  s      *z/TestDataFrameReshape.test_unstack_level_bindingc       	   	   C   sò   |j ƒ }t|tƒst‚|j ƒ j}tj||ƒ tddtj	gddtj	gdœƒ}t
dddgƒ|_|j ƒ }td	d
gdddggddddddgddddddggd�}tddtj	ddtj	g|d�}tj||ƒ |jƒ }xtdƒD ]}|j ƒ }qÒW tj||ƒ d S )Nr4   r5   g      @rP   )rQ   rR   r$   r%   r&   rQ   rR   r   )rN   r´   rJ   )r   )rD   Ú
isinstancer   r   rE   r   r   r   r>   rS   r   r   r   rM   r=   rK   )	r   rF   r   Zundor.   Úmidxr   Zold_dataÚ_r   r   r   Útest_unstack_to_series`  s     
$z+TestDataFrameReshape.test_unstack_to_seriesc          	   C   s¦  ddddgddddgddddgddddgg}t |tdƒd�}|j}ttjdƒgd tdƒd�}tj||ƒ |jd	d
gƒ}|j	d
ƒ}|j}ttjdƒgd t
jjddddgddddggdd�d�}tj||ƒ |jd	d
gƒ}d|d< |j	d
ƒ}|j}ttjdƒgd tjdƒgd  t
jjddddgddddggdd�d�}tj||ƒ d|d< |j	d
ƒ}|j}ttjdƒgd tjdƒgd  t
jjddddgddddggdd�d�}tj||ƒ xîtjdƒtjdƒftjddd�tjdddd�ffD ]¸\}}t dgd ||t
jddd�dœƒ}|jd d… jdd�}	|jd	d
gƒ}|d jdƒ|d< |jd d… j	dƒ}
|	jd	d
gƒj	dƒ}	|	d  jdƒ|	d!< |
jd"k�s�t‚tj|
|	ƒ �qæW d S )#Nr4   rJ   rP   r5   ÚABCD)r   re   )r   r   r   r   r‹   )r   g      @ro   r!   r¯   rZ   Zf8)r[   é
   r$   z
2012-01-01)rr   )r   r   r‹   r   T)Údeepr   )Nr   )Nr   )Nr   )r‹   r$   )r‹   r$   )rJ   r5   )r   rn   Údtypesr   r>   r[   r   rM   r8   rD   r9   r   r¬   Úzerosr?   r	   Úilocr=   rd   rA   r   r   )r   rp   r-   r.   r   rW   r§   r&   r   ÚrightÚleftr   r   r   Útest_unstack_dtypes{  s\    ,
"
"
"(z(TestDataFrameReshape.test_unstack_dtypesc             C   sx   t jddgddgd�}tddg|d	�}d
}tjt|d�� |jdƒ W d Q R X tjt|d�� |jjdƒ W d Q R X d S )Nr$   r%   r&   r   Úc1)r   r4   r5   )r   z5The name c1 occurs multiple times, use a level number)r'   )r$   r%   )r&   r   )	r   r:   r   r(   r)   r*   rD   rE   rC   )r   r…   r-   r�   r   r   r   Ú#test_unstack_non_unique_index_namesÃ  s    z8TestDataFrameReshape.test_unstack_non_unique_index_namesc          
   C   s”  t jjdgddddggƒd d… }t jddggd |d	�}|jƒ }t jjddgdddggƒ}t jddddddggdg|d
�}tj||ƒ |jjd |jd kj	ƒ s¦t
‚dddgddddgg}ddddgddddgg}t j||ƒ}tjdƒjddƒ}t jtj||d gƒ|d	�}|jƒ }t jtj|d |d d gdd�|d�}tj||ƒ |jjd |jd kj	ƒ �sjt
‚dddgddddgg}ddddgddddgg}t j||ƒ}tjdƒ}	t j|	jddƒ|d	�}dddddddddgtjddgtjddgfdddddddddgtjddgtjddgff}
xr|
D ]j\}}}}|j|d�}tjdƒtj }|	||< t jjddg|gƒ}t j|jddƒ||d
�}tj||ƒ �q"W d S )Nr$   r   r   r   r‹   r4   r   rJ   )r   )r   r   rk   r5   rP   )Úaxis)r   r&   rZ   rl   é   é   rj   rƒ   é   é   é   )r˜   é   ra   ra   ra   )r9   r   rL   r   rD   r   r   r   rN   Úallr   r>   r?   rB   Zconcatenater®   r¿   )r   r…   r-   r.   Zexp_colr   rN   r´   Úblockr   Zcasesr˜   ZidcesZ	col_levelZ	idx_levelZexp_dataÚcolsr   r   r   Útest_unstack_unused_levelsÍ  s@    " $ 
*.z/TestDataFrameReshape.test_unstack_unused_levelsrÏ   c             C   s¦   t jdddgdddggddd	gd
�}|jddd	gdd�}|jtd ƒtd ƒdf|f }|jƒ }|jdg | }tj|j	dggd d	gd�|_	|j
jd	ƒ|_
tj||ƒ d S )NiÚ  r$   ÚIiÛ  r%   ZIIr   r   r   )r   F)Zdropr   )r   )r9   r   r8   rf   ÚslicerD   rÀ   r   rL   r   r   r;   r   r   )r   rÏ   r-   ÚindZ	selectionr.   r   r   r   r   Útest_unstack_unused_levelú  s     z.TestDataFrameReshape.test_unstack_unused_levelc             C   sÀ   t jdggt jjdggdgd�t jjdddddddggddddd	d
dgd�d�}|jdddd	d
dgƒ}t jdggt jjdddddddggddddd	d
dgd�t jdgdd�d�}tj||ƒ d S )Nr4   r   rÄ   )r   Úi1Úi2Úi3Úi4Zi5Zi6Zi7)r   r   )r   )r9   r   r   r:   rD   r   r   r   )r   r-   r.   r   r   r   r   Útest_unstack_long_index  s    z,TestDataFrameReshape.test_unstack_long_indexc             C   s„   t jddgddggt jjddgddggddgd�t jjdd	d
gdd	dggdddgd�d�}|jddgƒjjdd … ddgks€t‚d S )Ng        r   r   r‹   rÄ   Úc2)r   r¼   é   r–   é(   rÕ   rÖ   r×   )r   r   r5   r™   )r9   r   r   r:   rD   r   r   r   )r   r-   r   r   r   Útest_unstack_multi_level_cols"  s    $z2TestDataFrameReshape.test_unstack_multi_level_colsc          
   C   s¤   t jddgddgddgddggt jjdddgdd	d
ggƒt jjdddgdddgdddgdddggdddgd�d�}|jddgƒ}|jdgƒjdgƒ}tj||ƒ d S )Nr4   r5   rJ   rP   r$   r%   r&   r   r„   ÚfÚm1ZP3éÞ   ZA5éo   Úm2rÕ   rÖ   r×   )r   )r   r   ra   r™   éýÿÿÿéüÿÿÿ)r9   r   r   r:   rD   r   r   )r   r-   r.   r   r   r   r   Ú&test_unstack_multi_level_rows_and_cols/  s    
z;TestDataFrameReshape.test_unstack_multi_level_rows_and_colsc                s  dd„ ‰ ‡ fdd„}t ddtjdgdd	d
dgddddgdœƒ}|jddgƒjƒ d }|jddgƒjƒ d j}tj||ƒ xntj	|j
d d… ƒD ]V}|jt|ƒƒ}xBtdƒD ]6}|j|d�}|jƒ jjƒ t|ƒksÔt‚||d ƒ qªW qŽW t dgd tjgd  dgd  dgd  dgd  dgd  d
gd dgd  tjgd  dgd  tjgd  d	gd  tjgd  dddddd d!d"d#d$d%d&d'd%d(d)d*dd+d,gd-œƒ}|j‡ fd.d/„d0d1�|j‡ fd2d/„d0d1� |d3< |d4< x„tj	d5d6d7gƒD ]p}|jt|ƒƒ}xZtdƒD ]N}|j|d�}|jƒ jjƒ dt|ƒ k�s6t‚xdeD ]}	|||	 ƒ �q<W �qW �qêW tj td8ƒtd9ƒtd9ƒd:œƒ}tj|jdf< |jd;d<gƒjd=ƒ}dd=d0dtjtjtjtjgtjtjtjtjddd>d?gg}
tttt|
Ž ƒƒ}
ttjd=d0dddd>d?gd<d@�}tdAgddggd=d=gd=d0ggd d;gdB�}t |
||dC�}tj||ƒ t td8ƒttdƒƒd td9ƒd:œƒ}tj|jdg< |jd;d<gƒjd=ƒ}dtjgd=dgd0dgtjd>gdd?gg}
tdAgddggd=d=gd=d0ggd d;gdB�}ttjd=d0ddgd<d@�}t |
||dC�}tj||ƒ tj td8ƒttdƒƒd td9ƒd:œƒ}tj|jdh< |jd;d<gƒjd=ƒ}dtjgd=dgd0dgdd>gtjd?gg}
tdAgddggd=d=gd=d0ggd d;gdB�}ttjd=d0ddgd<d@�}t |
||dC�}tj||ƒ tj tdDƒtdEddF�jƒ d tjdGƒd:œƒ}tj|jdi< |jd;d<gƒjƒ }tjdd=d0dtjdgtjdd>d?d9dHggƒ}
tddgd;d@�}tdAgtdEddF�gd=d=d=d=d=d=gdjd=d0dddggd d<gdB�}t |
||dC�}tj||ƒ dItjtjdJgdKdLtjdJgdMdNtjdJgdOdPdQdRgdSdLdQdRgdIdkdQdRgg}
t |
dUdVdWdXgdYdZd[d\d]d^gdC�}|jƒ jdXdWdUgƒjƒ }tjtjdNtjdLgdLdltjdPtjgg}
tdJdRgdQggd=d0gdmd=ggdXdWgdB�}tdVgdSdIdMdOdKggd=d=d=d=d=gd=d0dddggd dUgdB�}t |
||dC�}tj||ƒ |jdZd … jƒ jdXdWdUgƒ}tj|jƒ |ƒ t d0dd0dd0dgtjd_d>d`da�dbtjd>ƒ tj j!d>ƒdG j"dƒdcœƒ}|d6 tj#ddƒ |d7< tj |jdn< |jdo< tj |jdp< |jdq< |jd5d6d7gƒjd6d7gƒ}|jƒ jjƒ dt|ƒ k�s¾t‚xXdrD ]P}	xH|j$ƒ D ]<\}}|d5 |	|d6 |d7 ff}||	 |j| k�sÒt‚�qÒW �qÄW d S )sNc             S   s   | | krdn| }|d›S )NÚ r0   r   )ÚvalZval_strr   r   r   ÚcastC  s    z9TestDataFrameReshape.test_unstack_nan_index.<locals>.castc                s„   dd„ }| j ƒ jjƒ \}}xdt||ƒD ]V\}}t| j||f jdƒƒ}|| j| ƒ|| j| ƒ }tt	ˆ |ƒƒ}||ks&t
‚q&W d S )Nc             S   s   t | tƒrt| ƒS | gS )N)r·   Útuplern   )r$   r   r   r   Ú<lambda>H  s    zMTestDataFrameReshape.test_unstack_nan_index.<locals>.verify.<locals>.<lambda>Ú.)Únotnar   ZnonzeroÚzipÚsortedrÀ   Úsplitr   r   Úmapr   )r-   Zmk_listrp   rÏ   rw   r^   rÂ   rÁ   )rè   r   r   ÚverifyG  s    z;TestDataFrameReshape.test_unstack_nan_index.<locals>.verifyr$   r%   r   r`   rQ   rR   r\   za.wzb.xz .yzd.z)ÚjimÚjoeÚjolierò   ró   rô   r5   )r˜   rJ   rZ   r&   r„   rP   éC   é'   é5   éH   é9   éP   é   rÌ   rÉ   r–   é;   é2   é>   éL   é4   é   é<   é3   )Ú1stÚ2ndÚ3rdc                s   dj tˆ | ƒƒS )Nrë   )Újoinrð   )Úr)rè   r   r   rê   Œ  s    z=TestDataFrameReshape.test_unstack_nan_index.<locals>.<lambda>r4   )rÆ   c                s   dj tˆ | jd d d… ƒƒS )Nrë   r4   ra   )r  rð   rÀ   )r  )rè   r   r   rê   �  s    Ú4thÚ5thr  r  r  Zaaaabbbbrl   )r   r   r   r   r   r   rj   rk   )r   r   )rN   r´   r   )r   r   Z
aaaaabbbbbz
2012-01-01)rr   r¼   rƒ   ZHgi¼ç�(ÚUg        ZPbg¢	VÍZ§Ý>ZSngº@¹ÕÂø>gÌ]KÈ=‹?i)=‘(ZAgga2U0*©#?ZagentZchangeZdosageZs_idioC  ipC  iqC  irC  isC  itC  z
2014-02-01r‹   )rr   Úfreqéd   )r  r  rò   ró   z
2014-02-02)r	  r
  )rJ   r4   )r5   r4   )rJ   r4   )rJ   r4   ra   ga2U0*©#¿ga2U0*©#¿ra   )r4   r  )rJ   r  )r4   r  )rP   r  )rò   ró   )%r   r>   r®   r8   rD   rE   r   r   rš   Úpermutationsr   rn   rK   rì   r   ÚsumrT   r   Úapplyr9   rS   rÀ   rð   rí   r   r   r	   Útolistr?   r­   r=   rf   r’   rœ   Úroundr“   Ziterrows)r   rñ   r-   rÂ   rÁ   r…   rµ   ZlevZudfr«   ÚvalsrÏ   r¹   r  rg   r   )rè   r   Útest_unstack_nan_indexB  s   	
<J" 
&$&&"&&*


 
z+TestDataFrameReshape.test_unstack_nan_indexc             C   sz   t dddƒ}tddddgtj|ddfgƒd�}|jƒ }tjddgƒ}tj|dfgƒ}tddddg||d
�}tj||ƒ d S )NiÞ  r4   r5   rJ   rP   r   r   )r   r   )r   r   )r   r4   r5   rJ   )r   )r   r   r   r:   rC   rL   r   r   )r   Útr-   r.   ZeidxZecolsr   r   r   r   Ú%test_stack_datetime_column_multiIndex  s    "z:TestDataFrameReshape.test_stack_datetime_column_multiIndexc             C   sd  dd„ }t jdddddgd
dgd�}xŽdddddgddddgddddgdddgdddgdddgddgddgddgdgdgdgfD ]0}||| ƒ t|ƒdkr€|jƒ  ||| ƒ q€W ttjdƒjddƒ|dddg d�}|jdd�}tddgdtj	gddgdtj	ggt ddgd	dddggddddgddddggd dgd�t
ddgd
d�|jd d�}tj||ƒ d S )Nc             S   sà   t tjdt| ƒ ƒjdt| ƒƒ| d�}x´d	ddddgddgfD ]š}|j|dd�}t|tƒrŒ|j|dd�}t|tƒr€t	j
||ƒ nt	j||ƒ tj|jjƒ |jjd�|_|j|dd�}t|tƒrÌt	j
||ƒ q>t	j||ƒ q>W d S )
NrJ   )r   r4   r   F)r˜   ÚdropnaT)r   ra   )r   r>   r?   rT   rB   rC   r·   Úintr   r   rM   r   r   r:   r   Úto_numpyr   )Z
multiindexr-   r˜   r.   r   r   r   r   Ú_test_stack_with_multiindex&  s     


zWTestDataFrameReshape.test_stack_partial_multiIndex.<locals>._test_stack_with_multiindexr   rQ   r\   r   rR   r   ÚuZUpperZLower)r   r   r4   r5   rJ   rP   rj   )r   F)r  rZ   )rN   r´   r   )r   )r   r   r[   )r   rQ   )r   r\   )r   rR   )r   rQ   )r   r  )r   r:   rT   Úreverser   r>   r?   rB   rC   r®   r   r¾   r   r   )r   r  Zfull_multiindexZmultiindex_columnsr-   r.   r   r   r   r   Útest_stack_partial_multiIndex$  s@    

$
z2TestDataFrameReshape.test_stack_partial_multiIndexÚorderedFTÚlabelsZyxzZyxyc             C   sd   t j|tdƒ|d�}tdddgg|d�}|jƒ }t jj|j|gƒ}tdddg|d�}t	j
||ƒ d S )Nrm   )r~   r  r¼   rÉ   rÊ   )r   )r   )r9   ZCategoricalIndexrn   r   rC   r   rL   r   r   r   rM   )r   r  r  Zcidxr-   r.   r¸   r   r   r   r   Ú%test_stack_preserve_categorical_dtypef  s    z:TestDataFrameReshape.test_stack_preserve_categorical_dtypec          
   C   sz   t jddddgƒ}t j||dœƒ}|jƒ }t jjddddgd	d
ggƒ}t jt jddddddddgƒ|d�}tj||ƒ d S )Nr$   r%   r&   )r   r   r   r4   r5   rJ   r   r   )r   )	r9   r€   r   rC   r   rL   r   r   rM   )r   rž   r-   r.   r   r   r   r   r   Ú,test_stack_preserve_categorical_dtype_valuesu  s     zATestDataFrameReshape.test_stack_preserve_categorical_dtype_valueszindex, columnsr   c       	      C   sz   t j||d�jdƒ}|jƒ }t jj|jjƒ ƒ}t j|jƒ ||jd�}t	j
||ƒ tj|jjƒ}tj|jƒ}t	j||ƒ d S )N)r   r   r4   )r9   r   ÚfillnarC   r   r:   r   r  r   r   r   r>   Zasarrayr´   Zassert_numpy_array_equal)	r   r   r   r-   rG   Ú	new_indexr   Zstacked_codesZexpected_codesr   r   r   Ú)test_stack_multi_columns_non_unique_index€  s    
z>TestDataFrameReshape.test_stack_multi_columns_non_unique_indexr˜   c             C   s´   t jjdddgddgd�}t jt jjjddd gƒt jdddgƒdœ|d	�}|j|d
�}|j	t
ƒj|d
�}t j|jjgd |jjgd  |jd	�}tj|j|ƒ tj|j	t
ƒ|ƒ d S )Nr   r   r4   r   r$   r%   )r   )r   r   )r   )r˜   r5   )r   r   )r   r4   )r   r4   )r9   r   r:   r   ÚcoreZarraysZinteger_arrayr€   rD   rd   r¯   r   r   r[   r   r   r   rM   r¾   r   )r   r˜   r   r-   r.   r   Zexpected_dtypesr   r   r   Ú"test_unstack_mixed_extension_types•  s    $z7TestDataFrameReshape.test_unstack_mixed_extension_typesÚbazc             C   s¨   t jjdgddggddgd�}t jddgdd	gg|d
dgd�}d|j_t jd	dddggt jjddddgddgd�d�}d|j_|jƒ j	dd�j
d|d�}tj||ƒ d S )Nr   r   r&   r    r'  )r   r5   r4   rJ   r   r   )r   r   r!   )r   )rÆ   )rÆ   r˜   )r&   r   )r&   r   )r   r   )r   r   )r9   r   rL   r   r   r   r:   r   rD   Z	swaplevelZ
sort_indexr   r   )r   r˜   rµ   r-   r   r.   r   r   r   Ú test_unstack_swaplevel_sortlevel«  s     z5TestDataFrameReshape.test_unstack_swaplevel_sortlevel)r   r$   )r4   rJ   )r4   rP   )r5   rJ   )r5   rP   )r   r$   )r   r%   )r„   r$   )r„   r%   )r   r$   ©r   r$   )r)  r   )r   r$   r4   )r   r$   r5   )r   r%   r4   )r   r%   r5   )r„   r$   r4   )r„   r$   r5   )r„   r%   r4   )r„   r%   r5   )r   r$   )3Ú__name__Ú
__module__Ú__qualname__r   r+   r/   r7   r<   rI   rO   rY   ri   rq   rt   rz   r{   r‚   r†   r(   ÚmarkZparametrizer9   r   r:   r   r‡   r”   r�   r¨   r©   r±   r¶   rº   rÃ   rÅ   rÐ   rÒ   rÔ   rÙ   rÝ   rå   r  r  r  rn   r   r!  rL   r$  r&  r(  r   r   r   r   r
      s‚   $/%#*
&*,)H
-" XB$""0r
   c              C   s¨   t jddddgdd�} t jjddddgƒ| _| jƒ }t jdtjdgddtjgd	œt	d
ƒd�}t
j||ƒ | jdd�}t jdddgdddgd	œt	d
ƒd�}t
j||ƒ d S )Nr$   r%   r&   r¯   )r[   rQ   rR   r\   )r$   r%   rm   )r   r   )r]   )rQ   r$   )rQ   r%   )rR   r%   )r\   r$   )r9   r   r   r:   r   rD   r   r>   r®   rn   r   r   )r   r.   r   r   r   r   Útest_unstack_fill_frame_object¾  s    $ r.  c              C   s¦   t jt jddd�gdgdgdgdœddddgd	�} | jddgƒjƒ }t jt jddd�dggt jdgdd
�t jddgdggddgddggd dgd�d�}tj||ƒ d S )Nz2017-08-27 01:00:00.709949+0000ÚUTC)Útzr$   r%   r&   )Ú	timestampr$   r%   r&   r1  )r   )r   r   r4   )rN   r´   r   )r   r   )	r9   r   r“   r8   rD   r   r   r   r   )r-   r.   r   r   r   r   Ú"test_unstack_timezone_aware_valuesÔ  s    r2  c              C   sv   t jddddd�} t jd| iddd	gd
�}|jƒ }t j| t jddd	gdggdddgdddggd�d
�}tj||ƒ d S )Nr‹   Z20180101Z20180103zAmerica/New_York)r  ÚstartÚendr0  r   r$   r%   r&   )r   r   r4   r5   )rN   r´   )r9   r	   r   rC   r   r   r   rM   )Útsr-   r.   r   r   r   r   Ú test_stack_timezone_aware_valuesì  s    *r6  c              C   sÌ   t ddgddgddgddgdd	gd
œƒ} | jddddgƒ} | jdgdd�} | jddd�jddd�}| jddgdd�}t ddddgddddggtddgdd�tjddddgd dddgd�d�}tj||ƒ d S )NZAliceZBobg      #@rl   FTr   ÚfemaleÚmale)r   ÚscoreÚemployedÚkidsÚgenderr   r:  r;  r<  )r]   g        g       @)r   r9  )r   )r   r   )r9  r7  Fr   )r9  r7  Tr   )r9  r8  Fr   )r9  r8  Tr   )r   r8   rD   r   r   r:   r   r   )r-   r   r.   r   r   r   Útest_unstacking_multi_index_dfü  s(    r=  c              C   s�   t jjddgddgd�} t jddddgg| d�}|jdƒ}t jddgdd	�}t jjddgd dgd�}t jddgddgg||d
�}tj||ƒ d S )NrQ   rR   r\   r$   )r   r4   )r   r   )r   )r   r   )rQ   rR   )rR   r\   )r   rQ   )r   rR   )	r9   r   rL   r   rC   r   r:   r   r   )r   r-   r.   Znew_columnsr#  r   r   r   r   Ú2test_stack_positional_level_duplicate_column_names  s    
r>  c           	   C   s¼   t dddgdddgdgd dœƒjdd	gƒ} d
| d< t| jjƒdksHt‚| jd	ƒ}|d jdƒ|d< t ddddgtj	dddggt
ddgddd�tjddddgd d	gd�d�}tj||ƒ d S )Nr   r   ÚcaÚcbr¼   rJ   )r$   r%   Úvr$   r%   r4   Úis_r5   r   g      $@g      ð?g        r¯   )r[   r   rA  )r   )r   r   )rB  r?  )rB  r?  )rA  r?  )rA  r@  )rB  r?  )rB  r@  )r   r8   rT   rU   rV   r   rD   r"  r>   r®   r   r   r:   r   r   )r-   r.   r   r   r   r   Ú+test_unstack_with_missing_int_cast_to_float(  s     

rC  )r   rš   Znumpyr>   r(   Zpandasr9   r   r   r   r   r   r   r	   Zpandas._testingZ_testingr   r
   r.  r2  r6  r=  r>  rC  r   r   r   r   Ú<module>   s,   $
         ;