3
Êb_öŸ  ã               @   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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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/d0d1ged2ƒgƒd3d4„ ƒZd5d6„ Zd7d8„ Z d9d:„ Z!ejjd;d<d=gƒejjd>e"d?ƒe"d@ƒgƒdAdB„ ƒƒZ#dCdD„ Z$ejjdEdFdFdGdGge%j&j'dGdHgdIdJggƒfdFdFdHdKge%j&j'dGdHgdIdJggƒfdFdGdHdKge%j&j'dGdHgdIdJggƒfgƒdLdM„ ƒZ(ejjdNdFdGgƒdOdP„ ƒZ)ejjdNdFdQgƒdRdS„ ƒZ*d2S )TÚ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   úA/tmp/pip-build-jkwsxyiy/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   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j
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   é   é   )ÚdtypeÚxr$   r%   ÚyÚz)Ú
fill_value)r$   r%   )r   rR   g      à?ÚjÚkr   )rS   rT   rU   ÚwrY   )r   r   )rS   r$   )rS   r%   )rT   r%   )rU   r$   éÿÿÿÿrZ   rZ   )rY   r%   rW   )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   st  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jd�}tjd$d%d&d'gƒ|_t	j
||ƒ d S )(Nr4   r5   rJ   rP   rQ   é   é   é   ZAB)r   rR   rS   r$   r%   rT   rU   )rV   Úxyz)r   rR   r   r   g      à?)rS   r$   )rS   r%   )rT   r%   )rU   r$   rZ   rZ   rZ   rZ   rZ   )r   r$   )r   r%   )r   r$   )r   r%   rZ   )r   r$   )r   r%   )r   r$   )r   r%   )r   Úlistr>   Zint32r   r:   r   rD   r   r   r   r]   r[   Úfloat64r\   )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   )ÚperiodsrS   r$   r%   rT   rU   r   rJ   r4   r5   )r$   r%   )r   )rV   )rS   r$   )rS   r%   )rT   r%   )rU   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   rS   r$   r%   rT   rU   r   rJ   r4   r5   )r$   r%   )r   )rV   )rS   r$   )rS   r%   )rT   r%   )rU   r$   )rK   r   r   r:   r   rD   r   r9   rl   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-04rS   r$   r%   rT   rU   r   rJ   r4   r5   )r$   r%   )r   )rV   )rS   r$   )rS   r%   )rT   r%   )rU   r$   )	r   r   r   r:   r   rD   r   r   r   )r   rk   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)rR   rS   rT   rU   ZaxaÚabc)Ú
categoriesZbcx)r$   r%   rf   )r   z'fill_value' \('d'\) is not in)r'   Úd)rV   ZacaZbcc)rS   r$   )rS   r%   )rT   r%   )rU   r$   )r9   r   r   r:   r   rD   r   ÚCategoricalrg   r   r   r(   r)   Ú	TypeError)r   r   r.   r   Úmsgr   r   r   Ú#test_unstack_fill_frame_categorical0  s$    z8TestDataFrameReshape.test_unstack_fill_frame_categoricalc             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&   ru   rJ   r4   r!   Z20010102g      ð?g      I@g      Y@Zfloat32g      @g      @g      @rh   FéÈ   i2 Zint8)rR   )Ú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_comparee  s    
zNTestDataFrameReshape.test_unstack_preserve_dtypes.<locals>.unstack_and_comparer~   r   r   r‚   r   rƒ   r   r�   r   )
r9   r   Údictr   r]   r>   ÚrandomZrandÚ	Timestampr8   )r   r-   r…   Zdf1ra   r   r   r   Útest_unstack_preserve_dtypesS  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
� t
j|jddgd�|jdd�jdd�ƒ d S )NrJ   )Úrepeaté   é   )r   r4   r5   )ÚlevelT)ZinplaceéþÿÿÿrZ   )r   r:   rg   Ú	itertoolsÚproductrK   r   r>   r‡   Úrandnr   r   rC   r=   r   Z	set_names)r   r   r-   Zdf_namedr   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_stackedÚdf2r{   Ú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›   rœ   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   )rR   )
r   r   Úfrom_arraysrD   r>   ÚarrayÚnanÚobjectr   r   )r   r-   ÚrsZxpr   r   r   Útest_unstack_boolâ  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   )rR   )r   )r   r   )r9   r   r   rD   rC   r   r>   r£   r¤   rh   r   r   r   )r   Úmira   r.   Zexpected_mir   r   r   r   Útest_unstack_level_bindingð  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   )rS   rT   r$   r%   r&   rS   rT   r   )rN   rª   rJ   )r   )rD   Ú
isinstancer   r   rE   r   r   r   r>   ÚNaNr   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   r^   )r   r   r   r   r€   )r   g      @rh   r!   r¥   rQ   Zf8)rR   é
   r$   z
2012-01-01)rk   )r   r   r€   r   T)Údeepr   )Nr   )Nr   )Nr   )r€   r$   )r€   r$   )rJ   r5   )r   rg   Údtypesr   r>   rR   r   rM   r8   rD   r9   r   r¢   Úzerosr?   r	   Úilocr=   r]   rA   r   r   )r   ri   r-   r.   r   rœ   r�   r&   rx   ÚrightÚleftr   r   r   Útest_unstack_dtypes%  s\    ,
"
"
"(z(TestDataFrameReshape.test_unstack_dtypesc             C   sl   t jd
dgddgd�}tddg|d	�}tjtƒ� |jdƒ W d Q R X tjtƒ� |jjdƒ W d Q R X d S )Nr$   r%   r&   rx   Zc1)r   r4   r5   )r   )r$   r%   )r&   rx   )	r   r:   r   r(   r)   r*   rD   rE   rC   )r   Úidxr-   r   r   r   Ú#test_unstack_non_unique_index_namesm  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   rd   r5   rP   )Úaxis)r   r&   rQ   re   é   é   rc   é	   é   é   é   )r�   é   rZ   rZ   rZ   )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_levelsv  s@    " $ 
*.z/TestDataFrameReshape.test_unstack_unused_levelsrÇ   r   r   Nc             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   r_   Ú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                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„d/d0�|j‡ fd1d„d/d0� |d2< |d3< x„tj	d4d5d6gƒD ]p}|jt|ƒƒ}xZtdƒD ]N}|j|d�}|jƒ jjƒ dt|ƒ k�s6t‚xddD ]}	|||	 ƒ �q<W �qW �qêW tj td7ƒtd8ƒtd8ƒd9œƒ}tj|jde< |jd:d;gƒjd<ƒ}dd<d/d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<d/dddd=d>gd;d?�}td@gddggd<d<gd<d/ggd d:gdA�}t |
||dB�}tj||ƒ t td7ƒttdƒƒd td8ƒd9œƒ}tj|jdf< |jd:d;gƒjd<ƒ}dtjgd<dgd/dgtjd=gdd>gg}
td@gddggd<d<gd<d/ggd d:gdA�}ttjd<d/ddgd;d?�}t |
||dB�}tj||ƒ tj td7ƒttdƒƒd td8ƒd9œƒ}tj|jdg< |jd:d;gƒjd<ƒ}dtjgd<dgd/dgdd=gtjd>gg}
td@gddggd<d<gd<d/ggd d:gdA�}ttjd<d/ddgd;d?�}t |
||dB�}tj||ƒ tj tdCƒtdDddE�jƒ d tjdFƒd9œƒ}tj|jdh< |jd:d;gƒjƒ }tjdd<d/dtjdgtjdd=d>d8dGggƒ}
tddgd:d?�}td@gtdDddE�gd<d<d<d<d<d<gdid<d/dddggd d;gdA�}t |
||dB�}tj||ƒ dHtjtjdIgdJdKtjdIgdLdMtjdIgdNdOdPdQgdRdKdPdQgdHdjdPdQgg}
t |
dTdUdVdWgdXdYdZd[d\d]gdB�}|jƒ jdWdVdTgƒjƒ }tjtjdMtjdKgdKdktjdOtjgg}
tdIdQgdPggd<d/gdld<ggdWdVgdA�}tdUgdRdHdLdNdJggd<d<d<d<d<gd<d/dddggd dTgdA�}t |
||dB�}tj||ƒ |jdYd … jƒ jdWdVdTgƒ}tj|jƒ |ƒ t d/dd/dd/dgtjd^d=d_d`�datjd=ƒ tj j!d=ƒdF j"dƒdbœƒ}|d5 tj#dcƒ |d6< tj |jdm< |jdn< tj |jdo< |jdp< |jd4d5d6gƒjd5d6gƒ}|jƒ jjƒ dt|ƒ k�s¾t‚xXdqD ]P}	xH|j$ƒ D ]<\}}|d4 |	|d5 |d6 ff}||	 |j| k�sÒt‚�qÒW �qÄW d S )rNc             S   s   dj | | krdn| ƒS )Nz{0:1}Ú )Úformat)Úvalr   r   r   Ú<lambda>¶  s    z=TestDataFrameReshape.test_unstack_nan_index.<locals>.<lambda>c                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­   Útuplerg   )r$   r   r   r   rÐ   ¹  s    zMTestDataFrameReshape.test_unstack_nan_index.<locals>.verify.<locals>.<lambda>Ú.)Únotnar   ZnonzeroÚzipÚsortedr·   Úsplitr   r   Úmapr   )r-   Zmk_listri   rÇ   rp   rW   r¹   r¸   )Úcastr   r   Úverify¸  s    z;TestDataFrameReshape.test_unstack_nan_index.<locals>.verifyr$   r%   rx   rY   rS   rT   rU   za.wzb.xz .yzd.z)ÚjimÚjoeÚjolierÚ   rÛ   rÜ   r5   )r�   rJ   rQ   r&   ÚerP   é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    r4   )r½   c                s   dj tˆ | jd d d… ƒƒS )NrÒ   r4   rZ   )rð   r×   r·   )rñ   )rØ   r   r   rÐ   þ  s    Ú4thÚ5thrí   rî   rï   Zaaaabbbbre   )r   r   r   r   r   r   rc   rd   )r   r   )rN   rª   r   )r   r   Z
aaaaabbbbbz
2012-01-01)rk   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€   )rk   Úfreqéd   )rí   rî   rÚ   rÛ   z
2014-02-02)rò   ró   )rJ   r4   )r5   r4   )rJ   r4   )rJ   r4   rZ   ga2U0*©#¿ga2U0*©#¿rZ   )r4   rî   )rJ   rî   )r4   rï   )rP   rï   )rÚ   rÛ   )%r   r>   r¤   r8   rD   rE   r   r   r�   Úpermutationsr   rg   rK   rÓ   r   ÚsumÚlenr   Úapplyr9   r®   r·   r×   rÔ   r   r   r	   Útolistr?   r£   r=   r_   r‡   r‘   Úroundrˆ   Ziterrows)r   rÙ   r-   r¹   r¸   r»   r«   ZlevZudfr¡   ÚvalsrÇ   r°   rñ   r`   r   )rØ   r   Útest_unstack_nan_indexµ  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   rZ   )r   r>   r?   rù   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   rS   rU   r   rT   r   ÚuZUpperZLower)r   r   r4   r5   rJ   rP   rc   )r   F)r  rQ   )rN   rª   r   )r   )r   r   rR   )r   rS   )r   rU   )r   rT   )r   rS   )r   r  )r   r:   rù   Ú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 )Nrf   )rw   r  r³   rÁ   rÂ   )r   )r   )r9   ZCategoricalIndexrg   r   rC   r   rL   r   r   r   rM   )r   r  r	  Zcidxr-   r.   r¯   r   r   r   r   Ú%test_stack_preserve_categorical_dtype×  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   ry   r   rC   r   rL   r   r   rM   )r   r“   r-   r.   r   r   r   r   r   Ú,test_stack_preserve_categorical_dtype_valuesæ  s     zATestDataFrameReshape.test_stack_preserve_categorical_dtype_valueszindex, columnsr   r4   r5   r$   r%   rJ   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   ZfillnarC   r   r:   r   r  r   r   r   r>   Zasarrayrª   Zassert_numpy_array_equal)	r   r   r   r-   rG   Z	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_arrayry   rD   r]   r¥   r   r   rR   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   rx   r&   r    r  )r   r5   r4   rJ   r   r   )r   r   r!   )r   )r½   )r½   r�   )r&   r   )r&   r   )rx   r   )rx   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)+Ú__name__Ú
__module__Ú__qualname__r   r+   r/   r7   r<   rI   rO   rb   rj   rm   rs   rt   r|   r‰   r’   rž   rŸ   r§   r¬   r±   rº   r¼   rÈ   r(   ÚmarkZparametrizerÊ   rÌ   rþ   r   r  rg   r
  r  r9   r   rL   r  r  r  r   r   r   r   r
      sL   $/%#*,)H	-" V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¥   )rR   rS   rT   rU   )r$   r%   rf   )r   rx   )rV   )rS   r$   )rS   r%   )rT   r%   )rU   r$   )r9   r   r   r:   r   rD   r   r>   r¤   rg   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&   r  )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_valuesE  s    r  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Úendr  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    *r  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      #@re   FTr   ÚfemaleÚmale)r   ÚscoreÚemployedÚkidsÚgenderr   r!  r"  r#  )rV   g        g       @)r   r   )r   )r   r   )r   r  Fr   )r   r  Tr   )r   r  Fr   )r   r  Tr   )r   r8   rD   r   r   r:   r   r   )r-   r   r.   r   r   r   Útest_unstacking_multi_index_dfm  s(    r$  )r   r�   Znumpyr>   r(   Zpandasr9   r   r   r   r   r   r   r	   Zpandas._testingZ_testingr   r
   r  r  r  r$  r   r   r   r   Ú<module>   s&   $
        +