3
®yb¾  ã               @   sÎ   d dl Z d dlmZ d dlZd dlmZ d dlZd dlmZ d dl	Z	d dl
mZm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d	d
dddddddgZG dd„ dƒZG dd„ deƒZG dd„ deƒZdS )é    N)ÚStringIO)Úproduct)Úrandn)Úis_float_dtypeÚis_integer_dtype)Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚsumÚprodÚminÚmaxZmedianÚmeanZskewZmadÚstdÚvarZsemc               @   s   e Zd Zdd„ ZdS )ÚBasec             C   sf  t ddddgdddggdddd	d	d
d
dddg
dd	d
dd	d	d
dd	d
g
gddgd�}ttjjddƒ|tdddgdd�d�| _t ddddggdd	d
dggdgd�| _ddddddddgddddddddgg}t|Ž }t j	|ƒ}t
tdƒ|d�}tj|d< || _tjdƒ| _| jjdd„ dd„ dd„ gƒjƒ | _| jjjdd„ | jjjD ƒdd � | jjjd!d"d#gdd � d S )$NÚfooÚbarÚbazÚquxÚoneÚtwoÚthreer   é   é   é   ÚfirstÚsecond)ÚlevelsÚcodesÚnamesé
   ÚAÚBÚCÚexp)Úname)ÚindexÚcolumnsé   )r)   éd   c             S   s   | j S )N)Úyear)Úx© r/   ú@/tmp/pip-install-4cy230dp/pandas/pandas/tests/test_multilevel.pyÚ<lambda>>   s    z#Base.setup_method.<locals>.<lambda>c             S   s   | j S )N)Úmonth)r.   r/   r/   r0   r1   >   s    c             S   s   | j S )N)Úday)r.   r/   r/   r0   r1   >   s    c             S   s   g | ]}|j d ƒ‘qS )Úi8)Úastype)Ú.0Zlevr/   r/   r0   ú
<listcomp>C   s    z%Base.setup_method.<locals>.<listcomp>T)Zinplacer-   r2   r3   )r	   r   ÚnpÚrandomr   r   ÚframeZsingle_levelÚzipÚfrom_tuplesr
   ÚNaNÚseriesÚtmÚmakeTimeDataFrameZtdfÚgroupbyr   Úymdr)   Z
set_levelsr    Ú	set_names)ÚselfÚmethodr)   ÚarraysÚtuplesÚsr/   r/   r0   Úsetup_method    s.    .$

zBase.setup_methodN)Ú__name__Ú
__module__Ú__qualname__rI   r/   r/   r/   r0   r      s   r   c            
   @   s  e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	d
„ Zdd„ Z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&d'd'd(d'gd)d)d'd'd(d'ggd*d+d,d-d.d/gd)d'd'd(d'gfd&d&d'd'd(gd)d)d'd'd(ggd*d+d,d-d.gd)d'd'd(gfd&d&d'd'd(gd)d'd'd'd(ggd*d+d,d-d.gd'd'd'd(gfgƒd0d1„ ƒZd2d3„ Zd4d5„ Zd6d7„ Zd8d9„ Zd:d;„ Zd<d=„ Zejjd>d?d@gƒdAdB„ ƒZdCdD„ Z dEdF„ Z!dGdH„ Z"dIdJ„ Z#dKdL„ Z$dMdN„ Z%dOdP„ Z&dQdR„ Z'dSdT„ Z(dUdV„ Z)dWdX„ Z*dYdZ„ Z+d[d\„ Z,d]d^„ Z-ejj.d_d`„ ƒZ/dadb„ Z0dcdd„ Z1dedf„ Z2dgdh„ Z3didj„ Z4dkdl„ Z5dmdn„ Z6dodp„ Z7dqdr„ Z8ejjdse9ƒejjdtdud&gƒejjdvdwdxgƒejjdydwdxgƒdzd{„ ƒƒƒƒZ:ejjdse9ƒejjdtdud&gƒejjd|dud&gƒejjdvdwdxgƒejjdydwdxgƒd}d~„ ƒƒƒƒƒZ;dd€„ Z<d�d‚„ Z=dƒd„„ Z>d…d†„ Z?d‡dˆ„ Z@d‰dŠ„ ZAd‹dŒ„ ZBd�dŽ„ ZCd�d�„ ZDd‘d’„ ZEd“d”„ ZFd•d–„ ZGd—d˜„ ZHd™dš„ ZId›dœ„ ZJd�dž„ ZKdŸd „ ZLd¡d¢„ ZMejjd£d¤d£gƒd¥d¦„ ƒZNd§d¨„ ZOd©dª„ ZPd«d¬„ ZQd­d®„ ZRd¯d°„ ZSd±d²„ ZTd³d´„ ZUdµd¶„ ZVd·d¸„ ZWd¹dº„ ZXd»d¼„ ZYd½d¾„ ZZd'S )¿ÚTestMultiLevelc             C   s^   | j d d… | j dd …  }}|j|ƒ}tj|| j ƒ |d j|d ƒ}tj|| j d ƒ d S )Né   r$   )r:   Úappendr?   Úassert_frame_equalÚassert_series_equal)rD   ÚaÚbÚresultr/   r/   r0   Útest_appendI   s
    
zTestMultiLevel.test_appendc             C   s–   t tjjddƒtjddddgƒtjddddgƒgd�}t|jtƒsFt‚t|j	tƒ sXt‚t tjjddƒddddgddddggd�}t|j	tƒs’t‚d S )Né   rR   rS   r.   Úy)r)   )r*   )
r   r8   r9   r   ÚarrayÚ
isinstancer)   r	   ÚAssertionErrorr*   )rD   Úmultir/   r/   r0   Útest_dataframe_constructorR   s    ((z)TestMultiLevel.test_dataframe_constructorc             C   s¤   t dtjddddgƒtjddddgƒgd�}t|jtƒs<t‚t dddddgddddggd�}t|jtƒslt‚t tdƒddddgddddggd�}t|jtƒs t‚d S )Ng      ð?rR   rS   r.   rW   )r)   rV   )r
   r8   rX   rY   r)   r	   rZ   Úrange)rD   r[   r/   r/   r0   Útest_series_constructor_   s    * $z&TestMultiLevel.test_series_constructorc             C   sÎ   | j jdd�}|j| j jdd�}| j jdd�jtjƒ}tj||ƒ |d j| j jdd�}| j d jdd�jtjƒ}tj	||dd� | j j
jddd�}|j| j jdd�}| j jdd�jtjƒj
}tj||ƒ d S )	Nr2   )Úlevelr   r$   F)Úcheck_names)Úaxisr_   )r*   r_   )rB   r   Úreindexr)   rA   Ú	transformr8   r?   rP   rQ   ÚT)rD   Ú
month_sumsrT   Úexpectedr/   r/   r0   Útest_reindex_levelk   s    z!TestMultiLevel.test_reindex_levelc                s0   ‡ fdd„}|dƒ |dƒ |dƒ |dƒ d S )Nc                s¸   t t| ƒ}ˆ jjdd�}|ˆ j|dd�}ˆ jjdd�jtjƒ}|ˆ j|ƒ}tj||ƒ t t	| ƒ}|ˆ jd |d dd�}ˆ jd jdd�jtjƒ}|ˆ jd |ƒ}d|_
tj||ƒ d S )Nr2   )r_   r$   )Úgetattrr   rB   r   rA   rc   r8   r?   rP   r
   r(   rQ   )ÚopnameÚopre   rT   Zbroadcastedrf   )rD   r/   r0   Ú	_check_op   s    

z3TestMultiLevel.test_binops_level.<locals>._check_opÚsubÚaddÚmulÚdivr/   )rD   rk   r/   )rD   r0   Útest_binops_level~   s
    z TestMultiLevel.test_binops_levelc             C   s8   dd„ }|| j ƒ || j jƒ || jƒ || jjƒ d S )Nc             S   s   t j| ƒ}t j| |ƒ d S )N)r?   Zround_trip_picklerP   )r:   Z	unpickledr/   r/   r0   Ú_test_roundtrip–   s    
z3TestMultiLevel.test_pickle.<locals>._test_roundtrip)r:   rd   rB   )rD   rq   r/   r/   r0   Útest_pickle•   s
    

zTestMultiLevel.test_picklec             C   s0   | j jddg }| j jddg }tj||ƒ d S )Nr   r   r   r   r   )r   r   )r   r   )r:   ÚilocÚlocr?   rP   )rD   rf   Z	reindexedr/   r/   r0   Útest_reindexŸ   s    zTestMultiLevel.test_reindexc             C   sŒ   | j jd d d… }| j j|ƒ}|j|ks,t‚| j j| }|j|ksFt‚| j j}|j|d�}|j|ksht‚|jd d …|f }|j|ksˆt‚d S )Nr#   )r*   )rB   r)   rb   rZ   rt   rd   r*   )rD   Z	new_indexÚchunkZymdTr/   r/   r0   Útest_reindex_preserve_levels¤   s    z+TestMultiLevel.test_reindex_preserve_levelsc             C   sr   t | jƒ t | jƒ t | jjƒ t | jjƒ tƒ }| jj|d� | jj|d� | jjj|d� | jjj|d� d S )N)Úbuf)Úreprr:   rB   rd   r   Z	to_string)rD   rx   r/   r/   r0   Útest_repr_to_string³   s    

z"TestMultiLevel.test_repr_to_stringc             C   sP   t jddgdddgd�}td	ddgi|d
�}t|ƒjdƒ}|d jdƒsLt‚d S )NrR   r   r   rS   r   r   Úc)r"   Úvalue)r)   Ú
r   za 0 foo)rR   r   r   )rS   r   r   )r	   r<   r   ry   ÚsplitÚ
startswithrZ   )rD   r)   ÚdfÚlinesr/   r/   r0   Útest_repr_name_coincide¿   s
    z&TestMultiLevel.test_repr_name_coincidec             C   sz   t tddgddgddgƒƒ}tj|ddd	gd
�}ttjjddƒdddg|d�}|jƒ }t	|d ƒsft
‚t|d	 ƒsvt
‚d S )Nr   r   r#   é   g      ð?gš™™™™™ñ?Zprm0Zprm1Zprm2)r"   r+   r   r$   r%   r&   )r*   r)   )Úlistr   r	   r<   r   r8   r9   r   Úreset_indexr   rZ   r   )rD   rG   r)   r€   Ú	deleveledr/   r/   r0   Útest_delevel_infer_dtypeÉ   s    z'TestMultiLevel.test_delevel_infer_dtypec             C   sÂ   | j jdd�}t|jƒt| j jƒks(t‚|jj| j jjks>t‚| jjƒ }t|t	ƒsVt‚t|jƒt| jjj
ƒd ksvt‚|jj| jjjksŒt‚| jjdd�}t|tƒs¨t‚|jj| jjjks¾t‚d S )NT)Údropr   )rB   r…   Úlenr*   rZ   r)   r(   r>   rY   r   r    r
   )rD   r†   r/   r/   r0   Útest_reset_index_with_dropÑ   s    
 z)TestMultiLevel.test_reset_index_with_dropc             C   sü   ddd„}t j| jjdddgf< t j| jjdddgf< t j| jjdddgf< t j| jjdddgf< || jƒ || jƒ || jjdd� || jjdd� tjƒ }tj	t
dd	�� |jdd
� W d Q R X d| jd< | jjddd�}tj|jttdƒdd�ƒ d S )Nr   c             S   s^   | j |ƒ}xNt|jƒD ]@}| j||d�}| j||d�jƒ }|j|ƒjdƒ}tj||ƒ qW d S )N)ra   r_   r4   )	Ú	_get_axisr]   ZnlevelsÚcountrA   Zreindex_liker5   r?   rP   )r:   ra   r)   ÚirT   rf   r/   r/   r0   Ú_check_countsà   s    
z6TestMultiLevel.test_count_level.<locals>._check_countsr   r   é   )ra   Zhierarchical)Úmatch)r_   r   ÚDT)r_   Znumeric_onlyÚABCr'   )r(   )r   )r8   Únanr:   rs   rB   rd   r?   r@   ÚpytestÚraisesÚ	TypeErrorrŒ   Úassert_index_equalr*   r   r„   )rD   rŽ   r€   rT   r/   r/   r0   Útest_count_levelß   s    



zTestMultiLevel.test_count_levelc             C   sÄ   t ddd ddgdddddgdd	d	d	dgd
œƒ}|jddgƒjdd�}t tddgdd�tdgƒddgd�}tj||ƒ |jddgƒjjddd�}t tddgdd�tdgƒddggd�}tj||ƒ d S )NZJohnZMylag      8@rN   g      5@é!   é   FT)ÚPersonÚAgeÚSingler›   r�   )r_   )r(   rœ   r   )r)   r*   Údatar   )r_   ra   )r*   r)   rž   )r   Ú	set_indexrŒ   r   r?   rP   rd   )rD   r€   Úresrf   r/   r/   r0   Útest_count_index_with_nanû   s     z(TestMultiLevel.test_count_index_with_nanc             C   sÊ   t dddgddddggdddd	d	gd	dd
d
d	ggd�}ttjjt|ƒƒ|d�}|jdd�}|jdd�jƒ }tj	|j
dƒ|j|jƒjdƒƒ |jd
d�}|jd
d�jƒ }tj	|j
dƒ|j|jƒjdƒƒ d S )Nr   r   r   r   r   r   Úfourr   r   r   )r    r!   )r)   )r_   Zf8)r	   r
   r8   r9   r   r‰   rŒ   rA   r?   rQ   r5   rb   r)   Úfillna)rD   r)   rH   rT   rf   r/   r/   r0   Útest_count_level_series  s     z&TestMultiLevel.test_count_level_seriesc             C   s–   | j d d d… }|jdd�}td|jjd dd�}tj||ƒ | j d d… }|jdd�}t|jjd jdgƒ|j	d�j
dƒjtjƒ}tj||ƒ d S )Nr$   r   )r_   )r)   r(   r   )r)   r*   )r:   rŒ   r
   r)   r    r?   rQ   r   rC   r*   r£   r5   r8   Úint64rP   )rD   rH   rT   rf   r€   r/   r/   r0   Útest_count_level_corner+  s    z&TestMultiLevel.test_count_level_cornerc             C   sT   t jtdd�� | jjjdƒ W d Q R X t jtdd�� | jjjdƒ W d Q R X d S )NzToo many levels)r�   r   znot a valid level numberr   éýÿÿÿ)r”   r•   Ú
IndexErrorr:   r)   Z_get_level_number)rD   r/   r/   r0   Ú#test_get_level_number_out_of_bounds:  s    z2TestMultiLevel.test_get_level_number_out_of_boundsc             C   s8   | j jƒ }|jƒ  | j jtƒjƒ  | j jtjƒjƒ  d S )N)rB   Úunstackr5   Úintr8   Zint32)rD   Ú	unstackedr/   r/   r0   Útest_unstack@  s    
zTestMultiLevel.test_unstackz5result_rows,result_columns,index_product,expected_rowr   Ng      >@r   Úix1Úix2Zcol1Zcol2Zcol3Zcol4c             C   sx   t j||d�jddgƒ}|jdd… jdƒ}t j|gt jj|dd … |ggd dgd�t jdgdd�d�}tj	||ƒ d S )	N)r*   r®   r¯   r   r   )r"   )r(   )r*   r)   )
Úpdr   rŸ   rs   rª   r	   Úfrom_productr   r?   rP   )rD   Zresult_rowsZresult_columnsZindex_productZexpected_rowrT   rf   r/   r/   r0   Útest_unstack_partialK  s    
z#TestMultiLevel.test_unstack_partialc             C   sR   t jddddgƒ}ttjjdƒ|d�}|jdd	gƒ}|jdd
d�}tj	||ƒ d S )Nr   r   r   r   r   r   rV   )r)   r   Úall)ra   Úhow)r   r   r   )r   r   r   )r   r   r   )r   r   r   )
r	   r<   r
   r8   r9   r   rª   Údropnar?   rP   )rD   r)   rH   r¬   rf   r/   r/   r0   Ú&test_unstack_multiple_no_empty_columnsv  s    z5TestMultiLevel.test_unstack_multiple_no_empty_columnsc             C   s’  | j jƒ }|jƒ }tj|| j ƒ | j jdd�}|jdƒ}|jƒ }tj|jdd�| j ƒ |d d d… }|jdƒ}|jƒ jddƒ}tj|jdd�| j ƒ |jddƒ}|jdƒjdddd�}|jdƒjddƒ}tj|jdd�| j ƒ | j jƒ }|jddd�}|jƒ }tj|| j ƒ | j jdƒjdƒ}|jdƒ}| j jƒ }tj||ƒ |jdƒ}| j jdƒ}tj||ƒ |jdƒ}| j jƒ jdƒjdƒ}tj||ƒ | j jdƒjd d …d d d…f }|jƒ jƒ }| j jƒ }tj||j	|j
ƒƒ | j jdƒjdƒ}| j jdƒjdƒ}d	d
„ }ttjdƒjddƒtdƒdddgd�}	tddgdddggtjtjdƒjdƒdƒtjtjdƒdƒgd�}
|	jƒ ttjdƒ|
d� }}|||ƒ dddg|	_tddgddggtjtjdƒjdƒdƒtjdddgdƒgd�}
|	jƒ ttjdƒ|
d� }}|||ƒ d}tj|ƒ|	_
tddgddgddggtjtjdƒjdƒdƒtjdddgdddgƒtjdddgdƒgd�}
|	jƒ ttjdƒ|
d� }}|||ƒ d S )Nr   )r_   r   r   )ra   F)ra   Z	ascendingr   c             S   s:   t j| |ƒ | jjdkst‚| j|j }}t j||ƒ d S )NF)r?   rQ   r)   Z	is_uniquerZ   r—   )ÚleftÚrightÚliÚrir/   r/   r0   Úcheck·  s    z(TestMultiLevel.test_stack.<locals>.checké   rV   ZababZ1stZ2ndZ3rd)r)   r*   rR   rS   )r    r!   )r)   é   éÿÿÿÿéþÿÿÿ©rR   r   ©rS   r   ©rR   r   ©rS   r   )rÀ   rÁ   rÂ   rÃ   )rB   rª   Ústackr?   rP   Ú
sort_indexÚ	swaplevelrt   rQ   rb   r)   r   r8   ÚarangeÚreshaper„   r	   ÚtileÚrepeatr
   r*   r<   )rD   r¬   Ú	restackedZunlexsortedrT   rf   ÚstackedZymd_stackedr»   r€   Úmir·   r¸   Ztplsr/   r/   r0   Ú
test_stack�  sx    







 
.
.
zTestMultiLevel.test_stackc             C   s@   d}t jt|ƒƒjdddgƒ}|jdƒ}|jƒ }tj||ƒ d S )Na  day,time,smoker,sum,len
Fri,Dinner,No,8.25,3.
Fri,Dinner,Yes,27.03,9
Fri,Lunch,No,3.0,1
Fri,Lunch,Yes,13.68,6
Sat,Dinner,No,139.63,45
Sat,Dinner,Yes,120.77,42
Sun,Dinner,No,180.57,57
Sun,Dinner,Yes,66.82,19
Thur,Dinner,No,3.0,1
Thur,Lunch,No,117.32,44
Thur,Lunch,Yes,51.51,17r3   ÚtimeZsmokerr   )r°   Zread_csvr   rŸ   rª   rÄ   r?   rP   )rD   rž   r€   rT   Úreconsr/   r/   r0   Útest_unstack_odd_failureâ  s
    
z'TestMultiLevel.test_unstack_odd_failurec             C   sp   | j j}d|d< |jddd�}|jƒ }|d jƒ jƒ }tj|d |dd� |jd ksXt‚|d jt	j
kslt‚d S )	Nr   r¢   r   )r_   ra   F)r`   r   )r   r¢   )r:   rd   rÅ   rÄ   r?   rQ   r(   rZ   Údtyper8   Zfloat_)rD   r€   rÌ   rT   r/   r/   r0   Útest_stack_mixed_dtypeø  s    z%TestMultiLevel.test_stack_mixed_dtypec          
   C   s�   t ddddddgddddddgddddddgd	d	d
d
d
dgtjdƒdœƒ}|jddddgƒjtƒ}|jƒ }|jƒ }tj	||j
|jƒjtƒƒ d S )NZnaiveZactivrR   rS   r   r   r   rV   ÚhiZbyeZpeaceg      @)Ústater'   ÚbarcodeÚvÚextrarÕ   r'   rÖ   r×   )r   r8   rÇ   rA   Úapplyr‰   rª   rÄ   r?   rQ   rb   r)   r5   Úfloat)rD   r€   rT   r¬   rË   r/   r/   r0   Útest_unstack_bug  s    zTestMultiLevel.test_unstack_bugc             C   sP   | j jƒ }|jjdkst‚|jjddgks.t‚|jƒ }|jj| j jjksLt‚d S )Nr   r'   r   )r:   rª   r)   r(   rZ   r*   r"   rÄ   )rD   r¬   rË   r/   r/   r0   Ú!test_stack_unstack_preserve_names  s
    
z0TestMultiLevel.test_stack_unstack_preserve_namesrE   rÄ   rª   c             C   sz   | j jd }tjtdd�� t||ƒdƒ W d Q R X |dkrv|jd d …df }tjtdd�� t||ƒdƒ W d Q R X d S )Nr   zdoes not match index name)r�   Zmistakerª   r   )r:   rt   r”   r•   ÚKeyErrorrh   rs   )rD   rE   r€   rH   r/   r/   r0   Ú#test_stack_unstack_wrong_level_name  s    z2TestMultiLevel.test_stack_unstack_wrong_level_namec          	   C   s^   t dddgddggddgddggd�}tdtd	ƒ|d
�}tjtdd�� |d  W d Q R X d S )NZa_lotZonlyoneZ
notevenonei²  Ú r   r   )r    r!   r   )r)   r*   )r�   r¾   )r	   r   r]   r”   r•   rÝ   )rD   rÍ   r€   r/   r/   r0   Útest_unused_level_raises,  s    z'TestMultiLevel.test_unused_level_raisesc             C   s*   | j jdƒ}| j jdd�}tj||ƒ d S )Nr   r   )r_   )r:   rª   r?   rP   )rD   rT   rf   r/   r/   r0   Útest_unstack_level_name7  s    z&TestMultiLevel.test_unstack_level_namec             C   sX   | j jdƒ}|jdƒ}| j jƒ jdƒ}tj||ƒ | j jdƒ}| j jƒ }tj||ƒ d S )Nr   r'   r   )r:   rª   rÄ   r?   rP   rQ   )rD   r¬   rT   rf   r/   r/   r0   Útest_stack_level_name<  s    

z$TestMultiLevel.test_stack_level_namec             C   s@  | j jddgƒ}| j jdƒjdƒ}tj||ƒ |jj|jjksBt‚| j d }|jddgƒ}tj||d ƒ |jddgƒ}|jddƒjddƒ}|j	dd�}tj|| j ƒ |j
j| j j
jks¼t‚| j jddgƒ}| j jdƒjdƒjddd	�}tj||ƒ | j jddgƒ}| j jdƒjdƒjddd	�}tj||jd d …|jf ƒ d S )
Nr-   r2   r$   r   r   r   )r_   r³   )ra   r´   )rB   rª   r?   rP   r*   r"   rZ   rÄ   rÆ   rÅ   r)   rµ   rt   )rD   r¬   rf   rH   Zs_unstackedrË   r/   r/   r0   Útest_stack_unstack_multipleF  s$    
z*TestMultiLevel.test_stack_unstack_multiplec          
   C   s<   | j jddgƒ}tjtdd�� |jddgƒ W d Q R X d S )Nr-   r2   zlevel should contain)r�   r   )rB   rª   r”   r•   Ú
ValueErrorrÄ   )rD   r¬   r/   r/   r0   Útest_stack_names_and_numbersa  s    z+TestMultiLevel.test_stack_names_and_numbersc             C   sd   | j jddgƒ}tjtdd�� |jddgƒ W d Q R X tjtdd�� |jd	d
gƒ W d Q R X d S )Nr-   r2   zToo many levels)r�   r   r   znot a valid level numberrV   éüÿÿÿr§   )rB   rª   r”   r•   r¨   rÄ   )rD   r¬   r/   r/   r0   Ú!test_stack_multiple_out_of_boundsh  s
    z0TestMultiLevel.test_stack_multiple_out_of_boundsc          	   C   s   t jddddddgddd�}tddgd	 d
d�}ddd	dddg}tj||gƒ}t||d�}|jƒ }|jdd�}|jdd�}t jdddgddd�}	tdd	dgdddgdœ|	ddgd�}
d
|
j_	t
j||
ƒ t
j||
ƒ t
j||
jƒ t jddddddgddd�}t jddddddgddd�}tj||gƒ}t||d�}|jƒ }|jdd�}|jdd�}t jdddgddd�}	t jddddddgddd�}ttjtjtjtjddgtjtjdd	tjtjgddtjtjtjtjgg|	|d�}
t
j||
ƒ t
j||
ƒ t
j||
jƒ d S )Nz2013-01z2013-02z2013-03ÚMZperiod)Úfreqr(   r$   r%   r   Ústr)r(   r   r   rV   rN   r½   )r)   )r_   r   )r$   r%   )r)   r*   Úperiod1z2013-12z2013-11z2013-10z2013-09z2013-08z2013-07Úperiod2)r°   ÚPeriodIndexr   r	   Úfrom_arraysr
   rª   r   r*   r(   r?   rP   rd   r8   r“   )rD   Úidx1Úidx2r|   ÚidxrH   Úresult1Úresult2Úresult3Ze_idxrf   Úe_colsr/   r/   r0   Útest_unstack_period_seriesq  s^    "z)TestMultiLevel.test_unstack_period_seriesc             C   s”  t jddddddgddd�}t jddddddgddd�}d	d
ddddgddddd
d	gdœ}tj||gƒ}t||d�}|jƒ }|jd	d�}|jdd�}t jddgddd�}	t jddddddgddd�}
tjdjƒ |
gƒ}tdd	dd
dd	gdd
ddddgg|	|d�}tj||ƒ tj||ƒ t jddddgddd�}	t jdddgddd�}
tjdjƒ |	gƒ}tddd
dgd	d
ddgddd	dgg|
|d�}tj||ƒ d S )Nz2014-01z2014-02rè   rë   )ré   r(   z2013-12z2013-10rì   r   r   r   rV   rN   r½   )r$   r%   )r)   )r_   r   zA A A B B B)r)   r*   zA A B B)	r°   rí   r	   rî   r   rª   r~   r?   rP   )rD   rï   rð   r|   rñ   r€   rò   ró   rô   Ze_1Ze_2rõ   rf   r/   r/   r0   Útest_unstack_period_frame¶  s@    "(*z(TestMultiLevel.test_unstack_period_framec             C   sÔ   dgd dgd  }dgd dgd  }t jdddgd ƒ}tjjd	d
dƒ}tt||||d�ƒ}|jddgƒ}d|j_	|j
dƒ}|jdƒjƒ }|jdƒ}	|jdd…dgf jdƒjƒ jdƒ}
d|
j_	tj|	|
ƒ dS )z8 bug when some uniques are not present in the data #3170r   r   r   rR   rS   z
2013-01-03z
2013-01-04z
2013-01-05r   r,   r½   )ÚIDÚNAMEÚDATEÚVAR1rú   rø   ZParamszW-THUNrû   )r°   Úto_datetimer8   r9   Úrandintr   ÚdictrŸ   r*   r(   rª   Zresampler   rÄ   rt   r?   rP   )rD   Zid_colr(   ÚdateZvar1r€   r[   ZunstZdownÚrsZxpr/   r/   r0   Útest_stack_multiple_bugå  s    

$z&TestMultiLevel.test_stack_multiple_bugc             C   sv   t ddgddgddgdœƒ}|jddgƒ}|jƒ jd	d
�}t|ƒt|jƒ ƒksRt‚|jƒ jdd
�}tj||jƒ ƒ d S )NÚa1Úa2Úb1Úb2r   )r$   r%   r&   r$   r%   F)rµ   T)	r   rŸ   rª   rÄ   r‰   rµ   rZ   r?   rP   )rD   r€   rÌ   r/   r/   r0   Útest_stack_dropna÷  s    z TestMultiLevel.test_stack_dropnac             C   s‚   t ddddddddgddddddddgddddddddggddddgddddggd�}dddg|j_ddg|j_|jddgƒ d S )	Nr   r   )r)   r*   rR   rS   r{   ÚdÚe)r   r)   r"   r*   rª   )rD   r€   r/   r/   r0   Ú"test_unstack_multiple_hierarchical  s    z1TestMultiLevel.test_unstack_multiple_hierarchicalc             C   s\   | j d }|jjdƒ}|j|ƒ}|jdd„ ƒ}|jdd„ ƒ}|j|jƒ}tj||dd� d S )Nr$   r   c             S   s   | d S )Nr   r/   )r.   r/   r/   r0   r1     s    z7TestMultiLevel.test_groupby_transform.<locals>.<lambda>c             S   s   | d S )Nr   r/   )r.   r/   r/   r0   r1     s    F)r`   )	r:   r)   Úget_level_valuesrA   rÙ   rc   rb   r?   rQ   )rD   rH   ZgrouperÚgroupedZappliedrf   rT   r/   r/   r0   Útest_groupby_transform  s    

z%TestMultiLevel.test_groupby_transformc          	   C   s„   d}t tjjd|d�tjjd|d�tjjdd|d�tjjdd|d�tjjd|d�tjj|ƒdœƒ}|jd	d
dddgƒ}|jdƒ d S )Niè  r,   )Úsizei,  r�   é   i¸  )r$   r%   r&   r‘   ÚEÚFr$   r%   r&   r‘   r  iùÿÿÿiíÿÿÿ)r   r8   r9   rý   r   rŸ   rª   )rD   ZNUM_ROWSr€   Úidfr/   r/   r0   Útest_unstack_sparse_keyspace  s    z+TestMultiLevel.test_unstack_sparse_keyspacec             C   s~   ddgddddgg}ddddgddddgg}t ||ƒ}ttjjddƒ|d�}|jƒ }t|jƒdksft‚|j	ƒ }t
j||ƒ d S )Nr   r   r   r   rV   )r)   )r	   r   r8   r9   r   rª   r‰   r*   rZ   rÄ   r?   rP   )rD   r    r!   r)   r€   rT   rÐ   r/   r/   r0   Útest_unstack_unobserved_keys2  s    
z+TestMultiLevel.test_unstack_unobserved_keysc          	   C   sL   t tjjddƒtjdƒtjdƒgd�}tjtdd�� |jƒ  W d Q R X d S )	Nr   é   )r)   zint32 overflow)r�   i   i   i   )	r   r8   r9   r   rÇ   r”   r•   rä   rª   )rD   r€   r/   r/   r0   Ú/test_unstack_number_of_levels_larger_than_int32A  s    $z>TestMultiLevel.test_unstack_number_of_levels_larger_than_int32c       
   	   C   s  dd„ }x–dD ]Ž}t jt jdddg|ƒdd�}xl|D ]d}t|ddddgddddggd�}t|td	ƒgd
�}x,tdƒD ] }|j|ƒ}||||d| ƒ qtW q4W qW tdddgdddggtjtdƒdƒtj	tdƒdƒgd�}	t|	tdƒtj
dt|	ƒ ƒjddƒd�}|||jdƒddƒ d S )Nc                s&   t ‡ ‡‡‡fdd„ˆ jD ƒƒs"t‚d S )Nc             3   sB   | ]:}ˆ j D ].}ˆ j||f ˆj||ˆ f|ˆ f kV  qqd S )N)r*   rt   )r6   ÚrowÚcol)r€   Ú
df_stackedÚlev0Úlev1r/   r0   ú	<genexpr>O  s   zgTestMultiLevel.test_stack_order_with_unsorted_levels.<locals>.manual_compare_stacked.<locals>.<genexpr>)r³   r)   rZ   )r€   r  r  r  r/   )r€   r  r  r  r0   Úmanual_compare_stackedM  s    zTTestMultiLevel.test_stack_order_with_unsorted_levels.<locals>.manual_compare_stackedr   r   r   r   )rÊ   )r    r!   rV   )r*   rž   r$   r&   r%   rN   )r*   r)   rž   )r   r   r¾   )Ú	itertoolsr   Úpermutationsr	   r   r]   rÄ   r8   rÊ   rÉ   rÇ   r‰   rÈ   )
rD   r  ÚwidthZlevels_possr    r*   r€   Z	stack_levr  rÍ   r/   r/   r0   Ú%test_stack_order_with_unsorted_levelsJ  s     

 
$&z4TestMultiLevel.test_stack_order_with_unsorted_levelsc             C   sî   t jdƒ}t jdd„ |D ƒdd„ |D ƒgƒ}tj|jddgd�}d|j_d	|i}tj|d
d�}ddg|j_	|j
t|jƒd
d�}|jddgƒjddgƒ}tddgddgddgddgddggdd
dddgtjddgddgd�d�}tj||ƒ d S )NrN   c             S   s   g | ]}d |› �‘qS )rS   r/   )r6   r.   r/   r/   r0   r7   p  s    zJTestMultiLevel.test_stack_unstack_unordered_multiindex.<locals>.<listcomp>c             S   s   g | ]}d |› �‘qS )rR   r/   )r6   r.   r/   r/   r0   r7   q  s    rS   rR   )r*   r   r.   r   )ra   r   Za0Zb0r  r  r  r  Úa3Zb3Za4Zb4r   r   r   rV   )r"   )r)   r*   )rR   r.   )rS   r.   )r8   rÇ   Zvstackr°   r   rd   r*   r(   Úconcatr"   rb   ÚsortedrÄ   rª   r	   r<   r?   rP   )rD   Úvaluesrž   r€   Zsecond_level_dictZmulti_level_dfrT   rf   r/   r/   r0   Ú'test_stack_unstack_unordered_multiindexk  s"    
 z6TestMultiLevel.test_stack_unstack_unordered_multiindexc             C   s\   t dgdgdggdgdgdggdddgd�}ttjjd	ƒgd
dddg|d�}|jdd� d S )Nr   r   r   r   r   r   r   )r    r!   r"   rV   rR   rS   r{   r  )r*   r)   )r_   )r	   r   r8   r9   ZrandrA   )rD   Úmidxr€   r/   r/   r0   Útest_groupby_corner„  s     z"TestMultiLevel.test_groupby_cornerc             C   sŠ   t jddddddgƒ}tdddd	d
dgddddddgg|d�}|jdd�|jjdd„ ƒ }|jddd�}|jƒ }|jddgkjƒ s†t	‚d S )NÚf1Ús1Ús2Úf2Úf3r   r   r   rV   rN   r½   r�   r+   é	   r#   é   r¼   )r*   )ra   c             S   s   | d dkS )Nr   r+  r,  )r+  r,  r/   )Úur/   r/   r0   r1   ›  s    z:TestMultiLevel.test_groupby_level_no_obs.<locals>.<lambda>r   )ra   r_   )r(  r)  )r(  r*  )r+  r)  )r+  r*  )r,  r)  )r,  r*  )
r	   r<   r   rt   r*   ÚmaprA   r   r³   rZ   )rD   r&  r€   Údf1r  rT   r/   r/   r0   Útest_groupby_level_no_obsŽ  s    (z(TestMultiLevel.test_groupby_level_no_obsc             C   sž   | j j| j jd d… dgf }| j j| j jdd … ddgf }|j|dd�j| j jƒ}| j jƒ }tj|jtj	|jƒ< tj	|jƒj
ƒ  sŠt‚tj||dd	� d S )
NrN   r$   r   r%   r&   Úouter)r´   F)r`   )r:   rt   r)   Újoinrb   Úcopyr8   r“   r$  Úisnanr³   rZ   r?   rP   )rD   rR   rS   Zjoinedrf   r/   r/   r0   Ú	test_join¡  s     
zTestMultiLevel.test_joinc          
   C   sD  | j d jƒ }| j d jdƒ}| j d jddƒ}| j d jddƒ}|jj| j jƒ sXt‚tj||ƒ tj||ƒ tj||ƒ |jƒ }|jdƒ}|jddƒ}|jddƒ}|jj| j jƒsºt‚tj||ƒ tj||ƒ tj||ƒ | j j}	|	jdddd�}| j jddƒj}
tj||
ƒ d}t	j
t|d�� ttd	ƒƒjƒ  W d Q R X d S )
Nr$   r   r   r   r   )ra   z,Can only swap levels on a hierarchical axis.)r�   r   )r:   rÆ   r)   ÚequalsrZ   r?   rQ   rd   rP   r”   r•   r–   r   r]   )rD   ZswappedZswapped2Zswapped3Zswapped4ÚbackZback2Zback3Zback4Úftr'   Úmsgr/   r/   r0   Útest_swaplevel®  s.    
zTestMultiLevel.test_swaplevelc             C   sH   | j d d… j}|d |d< t|jtƒs,t‚|d |d	 kjƒ sDt‚d S )
NrN   éÐ  r   r�   r#   )r=  r   r�   )r=  r   r#   )r=  r   r#   )r=  r   r�   )rB   rd   rY   r*   r	   rZ   r³   )rD   r€   r/   r/   r0   Útest_insert_indexÊ  s    z TestMultiLevel.test_insert_indexc             C   sÀ   t dddgtjdddgƒd�}t ddd	gtjdddgƒd�}|| }|jj|jƒ}|j|ƒ|j|ƒ }tj||ƒ |d d d… |d d d…  }|jj|jƒ}|j|ƒ|j|ƒ }tj||ƒ d S )Nr   r   r   r$   r%   )rž   r)   rV   rN   r½   ÚZ)r$   r   )r$   r   )r%   r   )r?  r   )r?  r   )r%   r   r¾   r¾   )r
   r	   r<   r)   Úunionrb   r?   rQ   )rD   r.   rW   r    Ú	exp_indexr'   r/   r/   r0   Útest_alignmentÐ  s    zTestMultiLevel.test_alignmentc             C   s*  | j jƒ }ddg|j_|jdd�}| j jdd�}tj||dd� |jdd�}| j jdd�}tj||dd� | jjƒ }ddg|j_|jdd�}| jjdd�jdƒ}tj	||ƒ |jdd�}| jjdd�jdƒ}tj	||ƒ d}t
jt|d	�� |jd
ƒ W d Q R X t
jt|d	�� |jd
d� W d Q R X d S )NrR   rS   )r_   r   F)r`   r   zLevel x not found)r�   r.   )r:   r5  r)   r"   rŒ   r?   rP   r>   Úrename_axisrQ   r”   r•   rÝ   )rD   r:   rT   Úexpectr>   r;  r/   r/   r0   Ú
test_countä  s*    

zTestMultiLevel.test_countrj   r_   r   ÚskipnaTFÚsortc                sX   | j j||d�}|j‡ ‡fdd„ƒ}t| j ˆ ƒ|ˆd�}|rH|j|d�}tj||ƒ d S )N)r_   rG  c                s   t | ˆ ƒˆd�S )N)rF  )rh   )r.   )rj   rF  r/   r0   r1   	  s    z:TestMultiLevel.test_series_group_min_max.<locals>.<lambda>)r_   rF  )r_   )r>   rA   Úaggrh   rÅ   r?   rQ   )rD   rj   r_   rF  rG  r  ÚleftsideÚ	rightsider/   )rj   rF  r0   Útest_series_group_min_max  s    z(TestMultiLevel.test_series_group_min_maxra   c                s   t j| jjdddgf< t j| jjdddgf< | jjj| }ˆ dkrJ| j}n| jj}|j|ˆ |d�}g ‰‡ ‡‡‡fdd„}	|j|	ƒ}
t	|ˆƒ|ˆ ˆd�}|r¶|j
|ˆ d	�}|j
|ˆ d	�}|jˆ ƒj| j|ƒ}tj|
jˆ ƒ|ƒ tj|jˆ ƒ|ƒ tj|
|ƒ d S )
Nr   r   r�   r   )r_   ra   rG  c                s   ˆj | ƒ t| ˆƒˆˆ d�S )N)rF  ra   )rO   rh   )r.   )ra   rj   ÚpiecesrF  r/   r0   Úaggf$  s    
z1TestMultiLevel.test_frame_group_ops.<locals>.aggf)r_   ra   rF  )r_   ra   )r8   r“   r:   rs   r)   r"   rd   rA   rH  rh   rÅ   r‹   r    Úrenamer?   r—   rP   )rD   rj   r_   ra   rF  rG  Z
level_namer:   r  rM  rI  rJ  Zlevel_indexr/   )ra   rj   rL  rF  r0   Útest_frame_group_ops  s$    
z#TestMultiLevel.test_frame_group_opsc             C   sB   t dgtjdgƒd�}|jdd�}t dgdgd�}tj||ƒ d S )Ng      $@r   r   )r)   r   )r_   )r   r   )r
   r	   r<   r   r?   rQ   )rD   ÚobjrT   rf   r/   r/   r0   Útest_stat_op_corner6  s    z"TestMultiLevel.test_stat_op_cornerc          
   C   s¢   t ddddddddgidddddddgddddddd	ggd
�}|jdd�}t dddgiddgd
�}tj||ƒ |jdd�}t dddgiddgd
�}tj||ƒ d S )Nrž   FTr   r   r   r   r   r   )r)   )r_   )r   Úanyr?   rP   r³   )rD   r€   rT   Úexr/   r/   r0   Útest_frame_any_all_group=  s    z'TestMultiLevel.test_frame_any_all_groupc             C   s„   t tddgƒttjddƒtjddƒgƒdœƒ}|jdd�}tddgd	d
gd�}tj||ƒ |jdd�}tddgd�}tj||ƒ d S )Nr   rH   r   Úms)rR   Út)ra   FTrR   rV  )rž   r)   )rž   )r   r
   r°   Zto_timedeltarR  r?   rQ   )rD   r€   rT   rf   r/   r/   r0   Útest_series_any_timedeltaN  s    
"z(TestMultiLevel.test_series_any_timedeltac                sÎ   t jtjdƒjdƒtjtjdƒdƒgƒ}ttjjt	|ƒdƒ|d�}x†dD ]~‰d‰ ‡ ‡fdd„}t
|d	 ˆƒd	ˆ d
�}|d	 jd	d�j|ƒ}tj||ƒ t
|ˆƒd	ˆ d
�}|jd	d�j|ƒ}tj||ƒ qHW d S )NrN   r#   )r)   r   r   rV   c                s   t | ˆƒˆ d�S )N)Úddof)rh   )r.   )rX  Úmethr/   r0   r1   g  s    z7TestMultiLevel.test_std_var_pass_ddof.<locals>.<lambda>r   )r_   rX  )r_   )r   r   )r	   rî   r8   rÇ   rÊ   rÉ   r   r9   r   r‰   rh   rA   rH  r?   rQ   rP   )rD   r)   r€   ZaltrT   rf   r/   )rX  rY  r0   Útest_std_var_pass_ddof_  s    $
z%TestMultiLevel.test_std_var_pass_ddofc             C   st   | j jddgd�}| j jddgd�jƒ }tj||ƒ | j d jddgd�}| j d jddgd�jƒ }tj||ƒ d S )Nr-   r2   )r_   r$   )rB   r   rA   r?   rP   rQ   )rD   rT   rf   r/   r/   r0   Ú%test_frame_series_agg_multiple_levelsq  s    z4TestMultiLevel.test_frame_series_agg_multiple_levelsc             C   s¤   | j jddgd�jƒ }| j jjdƒ}| j jjdƒ}| j j||gƒjƒ }tj||dd� |jj| j jjd d… kstt‚| j j| j jjd d… d�jƒ }tj||ƒ d S )Nr   r   )r_   F)r`   r   )	rB   rA   r   r)   r
  r?   rP   r"   rZ   )rD   rT   Zk1Zk2rf   ró   r/   r/   r0   Útest_groupby_multilevelz  s     z&TestMultiLevel.test_groupby_multilevelc             C   s   d S )Nr/   )rD   r/   r/   r0   Ú&test_groupby_multilevel_with_transform‰  s    z5TestMultiLevel.test_groupby_multilevel_with_transformc             C   sD   t jd
dddgƒ}ttjjddƒ||d�}|jdƒ|d< |jƒ }d S )Nr   r   r   r   rV   )r)   r*   r   ÚTotalsrß   )r   r   )r   r   )r   r   )r   r   )r^  rß   )r	   r<   r   r8   r9   r   r   Z_consolidate)rD   r)   r€   r/   r/   r0   Útest_multilevel_consolidateŒ  s
    z*TestMultiLevel.test_multilevel_consolidatec             C   s¬   | j jd }| j d jd }|jj| j jjdd … ks:t‚|jj| j jjdd … ksXt‚| j jd }| j d jd }|jj| j jjd ksŽt‚|jj| j jjd ks¨t‚d S )NéÐ  r$   r   r   )r`  r   )r`  r   )rB   rt   r)   r"   rZ   r(   )rD   rT   ró   r/   r/   r0   Útest_loc_preserve_names”  s    z&TestMultiLevel.test_loc_preserve_namesc             C   s`   d| j d< d| j d< | j jdƒ}|d jtjks4t‚|d	 jtjksHt‚|d
 jtjks\t‚d S )Nr   r  r   r  r2   r$   r   )r$   r   )r  r   )r  r   )rB   rª   rÒ   r8   Zfloat64rZ   Zobject_)rD   r¬   r/   r/   r0   Útest_unstack_preserve_typesŸ  s    

z*TestMultiLevel.test_unstack_preserve_typesc             C   sj  t jt jdƒdƒ}t jdƒ}t|gd ddgg |gd t jdƒjdƒg d�}tt jdƒ|d�}|jƒ }|jd
ksxt‚|j	ƒ }t
j||j|jƒƒ tddgg|gd  t jdƒjdƒg|gd  d�}tt jdƒ|d�}|jdƒ}|jdksòt‚t|gd	 ddgg |gd	  |gd	 t jdƒjdƒg |gd	  d�}tt jdƒ|d�}|jd	ƒ}|jdk�sft‚d S )Néô  r   r+   r   r   )r    r!   iè  )r)   rV   )rc  r   )rc  r   )rc  r   )r8   rÉ   rÇ   r	   rÊ   r
   rª   ÚshaperZ   rÄ   r?   rQ   rb   r)   )rD   r!   r_   r)   rH   rT   rÌ   r/   r/   r0   Ú!test_unstack_group_index_overflow©  s,    
  
*
z0TestMultiLevel.test_unstack_group_index_overflowc             C   s$   d| j j_| j jƒ  | j jjƒ  d S )Nr   )rB   r*   r(   Zto_htmlrd   )rD   r/   r/   r0   Útest_to_htmlÎ  s    

zTestMultiLevel.test_to_htmlc             C   sú  t dddgddggddddddgddddddggd�}ttjjd	ƒ|d
�}ttjjd	dƒ|d
�}|d }|jd }|d d… }|jjdƒ|_t	j
||ƒ t	j
||ƒ tjtdd�� |d  W d Q R X |jd }|jdƒ}|d d… }|jjdƒ|_t	j||ƒ t	j||ƒ t dddgddggddddddgddddddggd�}ttjjd	ƒ|d
�}ttjjd	dƒ|d
�}|d }|jd }|d d… }|jjdƒ|_t	j
||ƒ t	j
||ƒ |jd }|jdƒ}|d d… }|jjdƒ|_t	j||ƒ t	j||ƒ d S )Nr   r   r   r   r   r   r   )r    r!   r½   )r)   rV   z^\(\('foo', 'bar', 0\), 2\)$)r�   )r   r   r   )r   r   r   )r   r   r   )r   r   r   )r   r   r   ©r   r   r   )rg  r   )r   r   r   )r   r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r   )r	   r
   r8   r9   r   r   rt   r)   Z	droplevelr?   rQ   r”   r•   rÝ   ÚxsrP   )rD   r)   r>   r:   rT   ró   rf   r/   r/   r0   Útest_level_with_tuplesÓ  sH    $


$


z%TestMultiLevel.test_level_with_tuplesc       	      C   sâ   ddddddgddddddgdd	d
dddgg}t t|Ž ƒ}tj|ƒ}ttddƒ|d�}|jƒ }|jƒ }|jdƒ}|jdƒ}tj	||dd� tj
||ƒ |jdks¤t‚|d }|jdgdd�}|jdƒ}tj
||ƒ tj
||ƒ d S )NrR   ÚtopZroutine1Zroutine2rß   ZODrò   ró   ZwxZwyrV   r½   )r*   F)r`   r   )ra   )rR   rß   rß   )r#  r;   r	   r<   r   r   r5  Úpopr?   rQ   rP   r(   rZ   rˆ   )	rD   rF   rG   r)   r€   r1  Údf2rT   rf   r/   r/   r0   Útest_mixed_depth_pop  s$    



z#TestMultiLevel.test_mixed_depth_popc             C   sÊ   | j jddgdd�}| j jdddddd	g }tj||ƒ | j jjddgddd
�}tj||jƒ | j jddg }tj||ƒ | j d jddg }tj||d ƒ | j jjd d …ddgf }tj||jƒ d S )Nr   r   r   )r_   r   r   r�   r+   r-  )ra   r_   r$   )r:   rb   rs   r?   rP   rd   rt   rQ   )rD   rT   rf   r/   r/   r0   Ú$test_reindex_level_partial_selection  s    z3TestMultiLevel.test_reindex_level_partial_selectionc             C   sP   t jd	d
gddgd�}ttdƒ|d�}ttjjddƒ|d�}t|ƒ t|ƒ d S )Nr   r   u   Î”Úi1)r"   r   )r)   rV   )r   r   )r   r   )	r	   r<   r
   r]   r   r8   r9   r   ry   )rD   r)   rH   r€   r/   r/   r0   Útest_unicode_repr_level_names-  s
    z,TestMultiLevel.test_unicode_repr_level_namesc             C   st   t ddgddgddgdœƒ}t ddgddgddgdœƒ}|jddgƒ}|jddgƒ}xdD ]}|j||d
� qZW d S )Nr   r   )rR   rS   r.   )rR   rS   rW   rR   rS   r·   r¸   r3  )r´   )r·   r¸   r3  )r   rŸ   r4  )rD   r1  rl  r´   r/   r/   r0   Útest_join_segfault5  s    
z!TestMultiLevel.test_join_segfaultc             C   st   t ddddgtjd	d
ddgƒd�}t ddddgtjddddgƒd�}t td�}t|||dœƒ tj|||dœƒ d S )Nr   r   r   rV   )r)   )rÒ   )r   r   r   )r   r   r   )r   r   )r   r   )r   r   )r   rV   )r   r   )r   r   )r   r   )r   rV   )r
   r	   r<   Úobjectr   Z	from_dict)rD   r)  r*  Zs3r/   r/   r0   Ú(test_frame_dict_constructor_empty_series?  s      
z7TestMultiLevel.test_frame_dict_constructor_empty_seriesr  rV   c             C   sx   dddg}t dgdgdg|gdœƒ}||jdk j|ƒ}|jƒ j}tdgdgdggg g g gdddgd�}tj||ƒ d S )	NrR   rS   r{   r   r   r   )rR   rS   r{   r  )r    r!   r"   )r   rR   rA   r   r)   r	   r?   r—   )rD   r  Z
group_keysr€   ÚgrT   rf   r/   r/   r0   Ú+test_empty_frame_groupby_dtypes_consistencyL  s    

$z:TestMultiLevel.test_empty_frame_groupby_dtypes_consistencyc             C   sz   t dd d
didd dtjidd dtjidd dtjidd ddid	d dtjiiƒ}|jdd dd gƒ}t|ƒ d S )Nr$   é   ÚA0006000Únuitr%   r&   r‘   r  r  )r$   rw  rx  )r$   rw  rx  )r$   rw  rx  )r$   rw  rx  )r$   rw  rx  )r$   rw  rx  )r   r8   r“   rŸ   ry   )rD   Zdf3r  r/   r/   r0   Útest_multiindex_na_reprZ  s    z&TestMultiLevel.test_multiindex_na_reprc             C   sj   t dddgdddgddd	gd
œƒjddgƒ}t|jƒ}d|d< ||_t|ƒ ddg|d< ||_t|ƒ d S )Nr   r   r   rV   rN   r½   r�   r+   r-  )rR   rS   r{   rR   rS   ÚfazÚboor   )rz  r{  )r   rŸ   r„   r)   ry   )rD   r€   r)   r/   r/   r0   Útest_assign_index_sequencesj  s    "

z*TestMultiLevel.test_assign_index_sequencesc             C   sZ   ddddg}ddddg}t j|ddgd�}t||d	�}|j|jƒjƒ }t|ƒd
ksVt‚d S )NÚ600809Ú20061231Ú20070331Ú20070630ZdemoZSTK_IDZRPT_Date)r"   )r)   r   )r}  r~  )r}  r  )r}  r€  )r}  r  )r	   r<   r
   rA   r)   r   r‰   rZ   )rD   Zidx_tpÚdtrñ   rH   rT   r/   r/   r0   Útest_duplicate_groupby_issuesy  s    z,TestMultiLevel.test_duplicate_groupby_issuesc          
   C   s¸   t ddddgddddgddd	d
gddddgddddgddddggtdƒd�}|jddgƒ}|jdd�}t ddddgddddgddddggtdƒd�jddgƒ}|jd }tj||ƒ d S )Nr   r   g      ð?r   g       @r   ZbahZbamg      @r   g      @rV   g      @rN   g      @r½   ÚABCD)r*   r$   r%   r   )r_   )r   r   )r   r„   rŸ   rÅ   rt   r?   rP   )rD   r€   rf   rT   r/   r/   r0   Útest_duplicate_miˆ  s     




 

z TestMultiLevel.test_duplicate_mic             C   sL   dddgdddgdœ}t |ƒ}dddg}||d
< tj|d
 ƒ}|j|ƒ d S )Nr   g      @r   rV   rN   r½   )Út1Út2r   r   rG   )r   r   )r   r   )r   r   )r   r	   r<   rŸ   )rD   r  r€   rG   r)   r/   r/   r0   Útest_multiindex_set_indexž  s    
z(TestMultiLevel.test_multiindex_set_indexc             C   sF  t ddddddgddddddgtdƒdœƒ}tj|jdƒd	d
�|_|jjdƒ|_tjdddgdd�}|jdƒjdƒ}|j	dd	d�}t
j|jjd |ƒ t
j|jjd tddgdd�ƒ |jjddgksÊt‚|jddƒ}t
j|jjd tddgdd�ƒ t
j|jjd |ƒ |jjddgk�s t‚t tjjdƒƒ}tjddddddgdd�}tjddddddgdd�}tjdddd�}|jd ƒ}|j	|ƒ}|j	|d	d�}|j	|d	d�}tjdddgdd�}tjddgdd�}t
j|jjd |ƒ t
j|jjd |ƒ t
j|jjd |ƒ t
j|jjdƒ|ƒ t
j|jjdƒ|ƒ t
j|jjdƒ|ƒ d S )NrR   rS   z2011-07-19 07:00:00z2011-07-19 08:00:00z2011-07-19 09:00:00r½   )ÚlabelÚdatetimer|   r‰  T)Úutcz
US/Pacific)r(   ÚUTCrˆ  )rO   r   r   z
US/Eastern)Útzz2012-04-01 09:00z2012-04-02 09:00z2011-01-01 09:00z
Asia/Tokyo)ÚperiodsrŒ  r   )r   r]   r°   rü   rk  r)   Z
tz_convertZDatetimeIndexZtz_localizerŸ   r?   r—   r    r   r"   rZ   rÆ   r8   r9   Ú
date_rangeZ
_with_freqr
  )rD   r€   rf   rï   rð   Úidx3Ú	expected1Ú	expected2r/   r/   r0   Útest_set_index_datetime©  sp      

z&TestMultiLevel.test_set_index_datetimec                s  �xd0D �]ü‰ t jdddˆ dd�}ttdƒd	d
d�}tj||gƒ}ttjdd
d�dddddgdœ|d�}tt	j	dddƒt	j	dddƒt	j	dddƒt	j	dddƒt	j	dddƒgtjdd
d�tjdd
d�dddddgdœdd	ddgd�}|d j
‡ fdd„ƒ|d< tj|jƒ |ƒ t jdddd d!d�}tj|||gƒ}ttjdd
d�dddddgdœ|d�}tt	j	dddƒt	j	dddƒt	j	dddƒt	j	dddƒt	j	dddƒgtjdd
d�t	j	d"ddƒt	j	d"ddƒt	j	d"ddƒt	j	d"ddƒt	j	d"ddƒgtjdd
d�dddddgd#œdd	d!ddgd�}|d j
‡ fd$d„ƒ|d< |d! j
d%d„ ƒ|d!< tj|jƒ |ƒ tjddgt jd&dˆ d'�gƒ}ttjd(d
d�jd(dƒdg|d)�}td*jƒ t	j	d+ddƒt	j	d+ddƒt	j	d+ddƒgd tjd(d
d�d,œd-d.dgd�}|d. j
‡ fd/d„ƒ|d.< tj|jƒ |ƒ qW d S )1Nr‹  ú
Asia/Tokyoú
US/Easternz1/1/2011rN   r‘   rï   )r�  ré   rŒ  r(   rð   r¥   )r(   rÒ   )rÒ   r$   r%   r&   r  )rR   rS   )r)   iÛ  r   r   r   rV   )rï   rð   rR   rS   rR   rS   )r*   c                s   t | ˆ d�S )N)rŒ  )r   )r  )rŒ  r/   r0   r1     s    z:TestMultiLevel.test_reset_index_datetime.<locals>.<lambda>z1/1/2012ZMSzEurope/Parisr�  iÜ  )rï   rð   r�  rR   rS   c                s   t | ˆ d�S )N)rŒ  )r   )r  )rŒ  r/   r0   r1   8  s    c             S   s   t | dd�S )NzEurope/Paris)rŒ  )r   )r  r/   r/   r0   r1   :  s    Ú20130101)r�  rŒ  r½   )r*   r)   za a a b b biÝ  )Úlevel_0Úlevel_1rR   r–  r—  c                s   t | dˆ d�S )Nr‘   )ré   rŒ  )r   )r  )rŒ  r/   r0   r1   T  s    )r‹  r“  r”  )r°   rŽ  r   r]   r	   rî   r   r8   rÇ   r‰  rÙ   r?   rP   r…   r±   rÈ   r~   )rD   rï   rð   rñ   r€   rf   r�  r/   )rŒ  r0   Útest_reset_index_datetimeû  sv     z(TestMultiLevel.test_reset_index_datetimec             C   sÂ   t jtjdddd�tdƒgddgd�}ttjd	d
d�jddƒ|dgd�}ttj	ddd�gd tj	ddd�gd  tj	ddd�gd  dddgd tjd	d
d�dœdddgd�}t
j|jƒ |ƒ d S )Nr•  r   rè   )r�  ré   Úabcr2   Úfeature)r"   r-  r¥   )rÒ   r   rR   )r)   r*   z2013-01)ré   z2013-02z2013-03rS   r{   )r2   rš  rR   )r*   r¾   )r	   r±   r°   Úperiod_ranger„   r   r8   rÇ   rÈ   ZPeriodr?   rP   r…   )rD   rñ   r€   rf   r/   r/   r0   Útest_reset_index_periodX  s     :z&TestMultiLevel.test_reset_index_periodc             C   sî  ddgddgg}t ddgddggtj|ƒd	�}|dg jdƒjƒ }tj||ƒ d
}tjt	|d�� |jdƒjƒ  W d Q R X |j
dgƒjƒ }tj||ƒ t dgdggtjdgƒd	�}tj||ddg gdd�}|j
dgdd�jƒ }tj||ƒ d}tjt	|d�� |jdgƒjƒ  W d Q R X dddgdddgg}t ddgddggtj|ƒd	�}t dgdggtjdgƒd	�}tj||gdd�}|jd gƒjdd�}tj||ƒ tjt	dd�� |jd!gƒjd d� W d Q R X |jd"gƒjddd�}tj||ƒ d S )#Nr$   rß   r%   rS   r   r   r   r   )r*   z)cannot insert \('A', ''\), already exists)r�   r–  )ra   T)rO   z0Item must have length equal to number of levels.r&   r{   r�   rR   Úii)Úcol_fillzFcol_fill=None is incompatible with incomplete column name \('C', 'c'\))Z	col_levelrž  )r$   rß   )r–  rß   )r%   rS   )r$   rß   )r%   rS   )r&   r{   r�   )r&   r{   r�  )r&   r{   )r&   r{   )r{   r�  )r   r	   r<   rC  r…   r?   rP   r”   r•   rä   rŸ   r°   r"  )rD   r    r€   rT   r;  Zidx_colrf   rl  r/   r/   r0   Ú#test_reset_index_multiindex_columnsp  s<    
z2TestMultiLevel.test_reset_index_multiindex_columnsc             C   s  t tjjdƒƒ}tjdddd�}|j|ƒ}tjdddd�}|j|ƒj|ƒ}tjd	dd
d�}|j|ƒ}|j|dd�}|j|dd�}tjdddd�}tjdddd�}tj|j	j
d |ƒ tj|j	j
d |ƒ tj|j	j
d |ƒ tj|j	jdƒ|ƒ tj|j	jdƒ|ƒ tj|j	jdƒ|ƒ d S )Nr½   z
2011-01-01r   rè   )r�  ré   z2013-01-01 09:00r   ÚHZ2005r$   T)rO   r   r   )r   r8   r9   r°   r›  rO   rŸ   r?   r—   r)   r    r
  )rD   r€   rï   rð   r�  r�  r‘  r/   r/   r0   Útest_set_index_period¤  s"    

z$TestMultiLevel.test_set_index_periodc             C   sL   t jddddgƒ}d	d
ddg}t||d�}|jdƒjdt|ƒ fksHt‚d S )Nr   r   r   rV   rN   r½   r�   r+   rR   rS   r{   r  )r)   )r   r   )r   rV   )rN   r½   )r�   r+   )r	   r<   r
   rÊ   rd  r‰   rZ   )rD   Zm_idxrž   Zm_dfr/   r/   r0   Útest_repeat¼  s    zTestMultiLevel.test_repeatc             C   sR   ddgg}ddt jfdg}t|tjj|ƒd�}|jjj}|jjj}t	j
||ƒ d S )	Nr.   r   rR   rS   r{   ç        )r*   )rR   r{   r£  )r8   r“   r   r°   r	   r<   ZdtypesrR   rS   r?   rQ   )rD   rž   r*   r€   rf   rT   r/   r/   r0   Útest_subsets_multiindex_dtypeÄ  s    


z,TestMultiLevel.test_subsets_multiindex_dtype)[rJ   rK   rL   rU   r\   r^   rg   rp   rr   ru   rw   rz   r‚   r‡   rŠ   r˜   r¡   r¤   r¦   r©   r­   r”   ÚmarkÚparametrizer²   r¶   rÎ   rÑ   rÓ   rÛ   rÜ   rÞ   rà   rá   râ   rã   rå   rç   rö   r÷   r  r  r	  r  r  r  Zslowr  r   r%  r'  r2  r7  r<  r>  rB  rE  ÚAGG_FUNCTIONSrK  rO  rQ  rT  rW  rZ  r[  r\  r]  r_  ra  rb  re  rf  ri  rm  rn  rp  rq  rs  ru  ry  r|  r‚  r„  r‡  r’  r˜  rœ  rŸ  r¡  r¢  r¤  r/   r/   r/   r0   rM   H   sÎ   	


a
	E/	!
 "#	
%0
R]4rM   c               @   sF  e Zd ZdZdd„ Zdd„ Zdd„ Zejj	dd	d
gd	d	d
d
gddddggfd
d	gd
d
d	d	gddddggfd
d	gddgfd
d
d	d	gddddggfd
d	gddgfd
d
d	d	gddddggfd	d
gddgfd	d	d
d
gddddggfd	d
gddgfd	d	d
d
gddddggfdd
gddgfdd
d
gdddggfgƒejj	dddgƒdd„ ƒƒZ
dS )Ú
TestSortedz- everything you wanted to test about sorting c             C   s$   | j jƒ }|jj| j jjks t‚d S )N)r:   rÅ   r)   r"   rZ   )rD   rT   r/   r/   r0   Útest_sort_index_preserve_levelsÑ  s    
z*TestSorted.test_sort_index_preserve_levelsc       	   	   C   s†  t jjdƒ t jjddƒ}�xdddddgdfd	dd
dgdftdƒtdƒtdƒtdƒgtdƒfddddgdfgD �]\}}tjdd„ |D ƒƒ}t|tdƒ|d�}t	j
|tdtdƒtjd|fgƒd�gd	d�}t|ƒjƒ d jƒ dgksèt‚|jƒ jd	d�}|jd d …dd
d	dgf }tj||ƒ |jd	d�}|jd d …dd
d	ddgf }tj||ƒ |jƒ }d|d|f< |jd	d�}tj||ƒ qnW d S )Nr   r   rV   g      ð?g      @g       @g      @g      @r   r   rN   r•  Z20130103Z20130102Z20130105Z20130104Z1oneZ3oneZ2oneZ5oneZ4onec             S   s   g | ]}d |f‘qS )Úredr/   )r6   r�   r/   r/   r0   r7   è  s    z5TestSorted.test_sorting_repr_8017.<locals>.<listcomp>Údef)r)   r*   Zworldrª  )ra   )r8   r9   Úseedr   r   r	   r<   r   r„   r°   r"  rê   Ú
splitlinesr~   rZ   r5  rÅ   rs   r?   rP   )	rD   rž   ÚgenrØ   r*   r€   rl  rT   rf   r/   r/   r0   Útest_sorting_repr_8017Õ  s>    z!TestSorted.test_sorting_repr_8017c          	   C   sø   t dddgdddggddd	ddd	gdd	dddd	ggƒ}td
tt|ƒƒi|dd�}|jjƒ dksbt‚|jjdksrt‚|jƒ }|jjƒ dksŒt‚|jjdksœt‚td
dddd	git j	ddddgƒdd�}|j
tjdd…dd…f d d …f }tj||ƒ d S )Nr$   r%   r&   r{   rS   rR   r   r   r   r  r¥   )r)   rÒ   FTrV   rN   )r%   rR   )r%   r{   )r&   rR   )r&   rS   )r	   r   r]   r‰   r)   Zis_lexsortedrZ   Zis_monotonicrÅ   r<   rt   r°   Z
IndexSlicer?   rP   )rD   rñ   r€   r#  rf   rT   r/   r/   r0   Útest_sort_non_lexsorted  s    4$z"TestSorted.test_sort_non_lexsortedzkeys, expectedrS   rR   r   r   r{   Údimr)   r*   c             C   sœ   |dddddgdddddggi}t jtjdƒjddƒf|Ž}tj|ƒ}|dkrp|j|d d …f }tj	|j
|ƒ n(|d	kr˜|jd d …|f }tj	|j|ƒ d S )
Nr{   rR   rS   r   r   é   rN   r)   r*   )r°   r   r8   rÇ   rÈ   r	   rî   rt   r?   r—   r)   r*   )rD   r±  Úkeysrf   Úkwargsr€   rA  r    r/   r/   r0   Útest_multilevel_index_loc_order(  s     
z*TestSorted.test_multilevel_index_loc_orderN)rJ   rK   rL   Ú__doc__r©  r¯  r°  r”   r¥  r¦  rµ  r/   r/   r/   r0   r¨  Î  s   9&&&&&r¨  )r‰  Úior   r  r   Znumpyr8   Znumpy.randomr   r”   Zpandas.core.dtypes.commonr   r   Zpandasr°   r   r   r	   r
   r   Zpandas._testingZ_testingr?   r§  r   rM   r¨  r/   r/   r/   r0   Ú<module>   sJ   
)             