3
Êb_µT ã               @   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
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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ÚisnaÚ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© r0   ú>/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/test_multilevel.pyÚ<lambda>?   s    z#Base.setup_method.<locals>.<lambda>c             S   s   | j S )N)Úmonth)r/   r0   r0   r1   r2   ?   s    c             S   s   | j S )N)Úday)r/   r0   r0   r1   r2   ?   s    c             S   s   g | ]}|j d ƒ‘qS )Úi8)Úastype)Ú.0Zlevr0   r0   r1   ú
<listcomp>D   s    z%Base.setup_method.<locals>.<listcomp>T)Úinplacer.   r3   r4   )r	   r   ÚnpÚrandomr   r   ÚframeZsingle_levelÚzipÚfrom_tuplesr
   ÚNaNÚseriesÚtmÚmakeTimeDataFrameZtdfÚgroupbyr   Úymdr*   Ú
set_levelsr!   Ú	set_names)ÚselfÚmethodr*   ÚarraysÚtuplesÚsr0   r0   r1   Úsetup_method!   s.    .$

zBase.setup_methodN)Ú__name__Ú
__module__Ú__qualname__rL   r0   r0   r0   r1   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¢„ ZMd£d¤„ ZNd¥d¦„ ZOd§d¨„ ZPejjd©eQeRgƒdªd«„ ƒZSd¬d­„ ZTd®d¯„ ZUd°d±„ ZVd²d³„ ZWd´dµ„ ZXejjd¶d·d¶gƒd¸d¹„ ƒZYdºd»„ ZZd¼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'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<   ÚappendrA   Úassert_frame_equalÚassert_series_equal)rG   ÚaÚbÚresultr0   r0   r1   Útest_appendJ   s
    
zTestMultiLevel.test_appendc       
   
   C   s®  t dddgƒ}tjddddd�}t d	d
dgƒ}tj||gƒ}tj|||gƒ}|j|ƒ}tjdƒ}d|jt	j	dddƒƒfd|jt	j	dddƒƒfd|jt	j	dddƒƒfg}t dddg| ƒ}	t
j||	ƒ |j|ƒ}t |dddg ƒ}	t
j||	ƒ |j|ƒ}tj|j|ƒ|j|ƒgƒ}	t
j||	ƒ |j|ƒ}t
j||	ƒ |j|ƒ}t jtjd|jt	j	dddƒƒd	fd|jt	j	dddƒƒd
fd|jt	j	dddƒƒdfg| td�d ƒ}	t
j||	ƒ d S )Ngš™™™™™ñ?g333333ó?gÍÌÌÌÌÌô?z
2011-01-01ÚDr   z
Asia/Tokyo)ÚfreqÚperiodsÚtzr%   r&   r'   iÛ  r   r   )Údtype)r   ÚpdÚ
date_ranger	   Úfrom_arraysrR   ÚpytzÚtimezoneZlocalizeÚdatetimerA   Úassert_index_equalZ_simple_newr:   ÚarrayÚobject)
rG   Úidx1Úidx2Úidx3Zmidx_lv2Zmidx_lv3rW   r\   Zexpected_tuplesÚexpectedr0   r0   r1   Útest_append_indexS   s<    





z TestMultiLevel.test_append_indexc             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é   rU   rV   r/   Úy)r*   )r+   )
r   r:   r;   r   re   Ú
isinstancer*   r	   ÚAssertionErrorr+   )rG   Úmultir0   r0   r1   Útest_dataframe_constructor�   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      ð?rU   rV   r/   rm   )r*   rl   )r
   r:   re   rn   r*   r	   ro   Úrange)rG   rp   r0   r0   r1   Ú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 )	Nr3   )Úlevelr   r%   F)Úcheck_names)Úaxisrt   )r+   rt   )rD   r   Úreindexr*   rC   Ú	transformr:   rA   rS   rT   ÚT)rG   Ú
month_sumsrW   rj   r0   r0   r1   Útest_reindex_levelš   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 )Nr3   )rt   r%   )Úgetattrr   rD   r   rC   rx   r:   rA   rS   r
   r)   rT   )ÚopnameÚoprz   rW   Zbroadcastedrj   )rG   r0   r1   Ú	_check_op®   s    

z3TestMultiLevel.test_binops_level.<locals>._check_opÚsubÚaddÚmulÚdivr0   )rG   r   r0   )rG   r1   Ú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)rA   Zround_trip_picklerS   )r<   Z	unpickledr0   r0   r1   Ú_test_roundtripÅ   s    
z3TestMultiLevel.test_pickle.<locals>._test_roundtrip)r<   ry   rD   )rG   r…   r0   r0   r1   Ú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ÚlocrA   rS   )rG   rj   Z	reindexedr0   r0   r1   Ú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+   )rD   r*   rw   ro   rˆ   ry   r+   )rG   Z	new_indexÚchunkZymdTr0   r0   r1   Ú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<   rD   ry   r   Z	to_string)rG   rŒ   r0   r0   r1   Ú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 )NrU   r   r   rV   r   r   Úc)r#   Úvalue)r*   Ú
r   za 0 foo)rU   r   r   )rV   r   r   )r	   r>   r   r�   ÚsplitÚ
startswithro   )rG   r*   ÚdfÚlinesr0   r0   r1   Ú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   r:   r;   r   Úreset_indexr   ro   r   )rG   rJ   r*   r”   Ú	deleveledr0   r0   r1   Ú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   )rD   r™   Úlenr+   ro   r*   r)   r@   rn   r   r!   r
   )rG   rš   r0   r0   r1   Ú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)rv   rt   r5   )	Ú	_get_axisrr   ZnlevelsÚcountrC   Zreindex_liker6   rA   rS   )r<   rv   r*   ÚirW   rj   r0   r0   r1   Ú_check_counts  s    
z6TestMultiLevel.test_count_level.<locals>._check_countsr   r   é   )rv   Zhierarchical)Úmatch)rt   r   rY   T)rt   Znumeric_onlyÚABCr(   )r)   )r   )r:   Únanr<   r‡   rD   ry   rA   rB   ÚpytestÚraisesÚ	TypeErrorr    rd   r+   r   r˜   )rG   r¢   r”   rW   r0   r0   r1   Útest_count_level  s    



zTestMultiLevel.test_count_levelc             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*   )rt   Zf8)r	   r
   r:   r;   r   r�   r    rC   rA   rT   r6   rw   r*   Úfillna)rG   r*   rK   rW   rj   r0   r0   r1   Ú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   )rt   )r*   r)   r   )r*   r+   )r<   r    r
   r*   r!   rA   rT   r   rF   r+   r¬   r6   r:   Úint64rS   )rG   rK   rW   rj   r”   r0   r0   r1   Ú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)rG   r0   r0   r1   Ú#test_get_level_number_out_of_boundsM  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)rD   Úunstackr6   Úintr:   Úint32)rG   Ú	unstackedr0   r0   r1   Útest_unstackS  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*   )
r^   r   Ú	set_indexr‡   r³   r	   Úfrom_productr   rA   rS   )rG   Zresult_rowsZresult_columnsZindex_productZexpected_rowrW   rj   r0   r0   r1   Útest_unstack_partial^  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   rl   )r*   r   Úall)rv   Úhow)r   r   r   )r   r   r   )r   r   r   )r   r   r   )
r	   r>   r
   r:   r;   r   r³   ÚdropnarA   rS   )rG   r*   rK   r¶   rj   r0   r0   r1   Ú&test_unstack_multiple_no_empty_columns‰  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   )rt   r   r   )rv   F)rv   Ú	ascendingr   c             S   s:   t j| |ƒ | jjdkst‚| j|j }}t j||ƒ d S )NF)rA   rT   r*   Ú	is_uniquero   rd   )ÚleftÚrightÚliÚrir0   r0   r1   ÚcheckÊ  s    z(TestMultiLevel.test_stack.<locals>.checké   rl   ZababZ1stZ2ndZ3rd)r*   r+   rU   rV   )r!   r"   )r*   é   éÿÿÿÿéþÿÿÿ©rU   r   ©rV   r   ©rU   r   ©rV   r   )rÌ   rÍ   rÎ   rÏ   )rD   r³   ÚstackrA   rS   Ú
sort_indexÚ	swaplevelrˆ   rT   rw   r*   r   r:   ÚarangeÚreshaper˜   r	   ÚtileÚrepeatr
   r+   r>   )rG   r¶   Ú	restackedZunlexsortedrW   rj   ÚstackedZymd_stackedrÇ   r”   ÚmirÃ   rÄ   Ztplsr0   r0   r1   Ú
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,17r4   ÚtimeZsmokerr   )r^   Zread_csvr   rº   r³   rÐ   rA   rS   )rG   Údatar”   rW   Úreconsr0   r0   r1   Ú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   )rt   rv   F)ru   r   )r   r«   )r<   ry   rÑ   rÐ   rA   rT   r)   ro   r]   r:   Zfloat_)rG   r”   rØ   rW   r0   r0   r1   Ú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activrU   rV   r   r   r   rl   ÚhiZbyeZpeaceg      @)Ústater(   ÚbarcodeÚvÚextrará   r(   râ   rã   )r   r:   rÓ   rC   Úapplyr�   r³   rÐ   rA   rT   rw   r*   r6   Úfloat)rG   r”   rW   r¶   r×   r0   r0   r1   Ú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)   ro   r+   r#   rÐ   )rG   r¶   r×   r0   r0   r1   Ú!test_stack_unstack_preserve_names'  s
    
z0TestMultiLevel.test_stack_unstack_preserve_namesrH   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<   rˆ   r§   r¨   ÚKeyErrorr|   r‡   )rG   rH   r”   rK   r0   r0   r1   Ú#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   rr   r§   r¨   ré   )rG   rÙ   r”   r0   r0   r1   Ú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   )rt   )r<   r³   rA   rS   )rG   rW   rj   r0   r0   r1   Útest_unstack_level_nameJ  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Ð   rA   rS   rT   )rG   r¶   rW   rj   r0   r0   r1   Útest_stack_level_nameO  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.   r3   r%   r   r   r   )rt   r½   )rv   r¾   )rD   r³   rA   rS   r+   r#   ro   rÐ   rÒ   rÑ   r*   r¿   rˆ   )rG   r¶   rj   rK   Zs_unstackedr×   r0   r0   r1   Útest_stack_unstack_multipleY  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.   r3   zlevel should contain)r¤   r   )rD   r³   r§   r¨   Ú
ValueErrorrÐ   )rG   r¶   r0   r0   r1   Útest_stack_names_and_numberst  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.   r3   zToo many levels)r¤   r   r   znot a valid level numberrl   éüÿÿÿr°   )rD   r³   r§   r¨   r±   rÐ   )rG   r¶   r0   r0   r1   Ú!test_stack_multiple_out_of_bounds{  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)rZ   r)   r%   r&   r   Ústr)r)   r   r   rl   rQ   rÉ   )r*   )rt   r   )r%   r&   )r*   r+   Úperiod1z2013-12z2013-11z2013-10z2013-09z2013-08z2013-07Úperiod2)r^   ÚPeriodIndexr   r	   r`   r
   r³   r   r+   r)   rA   rS   ry   r:   r¦   )rG   rg   rh   r�   ÚidxrK   Úresult1Úresult2Úresult3Ze_idxrj   Úe_colsr0   r0   r1   Útest_unstack_period_series„  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ö   )rZ   r)   z2013-12z2013-10r÷   r   r   r   rl   rQ   rÉ   )r%   r&   )r*   )rt   r   zA A A B B B)r*   r+   zA A B B)	r^   rø   r	   r`   r   r³   r’   rA   rS   )rG   rg   rh   r�   rù   r”   rú   rû   rü   Ze_1Ze_2rý   rj   r0   r0   r1   Ú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   rU   rV   z
2013-01-03z
2013-01-04z
2013-01-05r   r-   rÉ   )ÚIDÚNAMEÚDATEÚVAR1r  r   ZParamszW-THUNr  )r^   Úto_datetimer:   r;   Úrandintr   Údictrº   r+   r)   r³   Zresampler   rÐ   rˆ   rA   rS   )rG   Zid_colr)   ÚdateÚvar1r”   rp   ZunstZdownÚrsZxpr0   r0   r1   Ú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 )NZa1Za2Zb1Zb2r   )r%   r&   r'   r%   r&   F)r¿   T)	r   rº   r³   rÐ   r�   r¿   ro   rA   rS   )rG   r”   rØ   r0   r0   r1   Ú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+   rU   rV   r�   ÚdÚe)r   r*   r#   r+   r³   )rG   r”   r0   r0   r1   Ú"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   r0   )r/   r0   r0   r1   r2   +  s    z7TestMultiLevel.test_groupby_transform.<locals>.<lambda>c             S   s   | d S )Nr   r0   )r/   r0   r0   r1   r2   ,  s    F)ru   )	r<   r*   Úget_level_valuesrC   rå   rx   rw   rA   rT   )rG   rK   ZgrouperÚgroupedZappliedrj   rW   r0   r0   r1   Ú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'   rY   ÚEÚFr%   r&   r'   rY   r  iùÿÿÿiíÿÿÿ)r   r:   r;   r  r   rº   r³   )rG   ZNUM_ROWSr”   Úidfr0   r0   r1   Útest_unstack_sparse_keyspace0  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   rl   )r*   )r	   r   r:   r;   r   r³   r�   r+   ro   rÐ   rA   rS   )rG   r!   r"   r*   r”   rW   rÝ   r0   r0   r1   Útest_unstack_unobserved_keysE  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   r:   r;   r   rÓ   r§   r¨   rð   r³   )rG   r”   r0   r0   r1   Ú/test_unstack_number_of_levels_larger_than_int32T  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+   rˆ   )r7   ÚrowÚcol)r”   Ú
df_stackedÚlev0Úlev1r0   r1   ú	<genexpr>b  s   zgTestMultiLevel.test_stack_order_with_unsorted_levels.<locals>.manual_compare_stacked.<locals>.<genexpr>)r½   r*   ro   )r”   r  r  r  r0   )r”   r  r  r  r1   Úmanual_compare_stacked`  s    zTTestMultiLevel.test_stack_order_with_unsorted_levels.<locals>.manual_compare_stackedr   r   r   r   )rÖ   )r!   r"   rl   )r+   rÜ   r%   r'   r&   rQ   )r+   r*   rÜ   )r   r   rÊ   )Ú	itertoolsr   Úpermutationsr	   r   rr   rÐ   r:   rÖ   rÕ   rÓ   r�   rÔ   )
rG   r!  ÚwidthZlevels_possr!   r+   r”   Z	stack_levr  rÙ   r0   r0   r1   Ú%test_stack_order_with_unsorted_levels]  s     

 
$&z4TestMultiLevel.test_stack_order_with_unsorted_levelsc             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#   rl   rU   rV   r�   r  )r+   r*   )rt   )r	   r   r:   r;   ZrandrC   )rG   Úmidxr”   r0   r0   r1   Ú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   rl   rQ   rÉ   r£   r,   é	   r$   é   rÈ   )r+   )rv   c             S   s   | d dkS )Nr   r+  r,  )r+  r,  r0   )Úur0   r0   r1   r2   •  s    z:TestMultiLevel.test_groupby_level_no_obs.<locals>.<lambda>r   )rv   rt   )r(  r)  )r(  r*  )r+  r)  )r+  r*  )r,  r)  )r,  r*  )
r	   r>   r   rˆ   r+   ÚmaprC   r   r½   ro   )rG   r&  r”   Údf1r  rW   r0   r0   r1   Ú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 )
NrQ   r%   r   r&   r'   Úouter)r¾   F)ru   )r<   rˆ   r*   Újoinrw   Úcopyr:   r¦   ÚvaluesÚisnanr½   ro   rA   rS   )rG   rU   rV   Zjoinedrj   r0   r0   r1   Ú	test_join›  s     
zTestMultiLevel.test_joinc             C   s  | 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 S )Nr%   r   r   r   r    )rv   )	r<   rÒ   r*   Úequalsro   rA   rT   ry   rS   )rG   ZswappedZswapped2Zswapped3Zswapped4ÚbackZback2Zback3Zback4Úftr(   r0   r0   r1   Útest_swaplevel¨  s(    
zTestMultiLevel.test_swaplevelc             C   s  | j jdddgƒ}| j jddƒjddƒ}tj||ƒ | j d jdddgƒ}| j d jddƒjddƒ}tj||ƒ | j jjdddgdd�}| j jjdddd�jdddd�}tj||ƒ tjt	d	d
�� | j jddgdd� W d Q R X tjt
dd
�� | j jjdddgƒ W d Q R X d S )Nr3   r4   r.   r   r   r   r%   )rv   zhierarchical axis)r¤   zToo many levelsr   )rD   Zreorder_levelsrÒ   rA   rS   rT   ry   r§   r¨   r©   r±   r*   )rG   rW   rj   r0   r0   r1   Útest_reorder_levelsÀ  s     z"TestMultiLevel.test_reorder_levelsc             C   sH   | j d d… j}|d |d< t|jtƒs,t‚|d |d	 kjƒ sDt‚d S )
NrQ   éÐ  r   r£   r$   )r>  r   r£   )r>  r   r$   )r>  r   r$   )r>  r   r£   )rD   ry   rn   r+   r	   ro   r½   )rG   r”   r0   r0   r1   Ú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*   rl   rQ   rÉ   ÚZ)r%   r   )r%   r   )r&   r   )r@  r   )r@  r   )r&   r   rÊ   rÊ   )r
   r	   r>   r*   Úunionrw   rA   rT   )rG   r/   rm   ÚresZ	exp_indexr(   r0   r0   r1   Ú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 )NrU   rV   )rt   r   F)ru   r   zLevel x not found)r¤   r/   )r<   r5  r*   r#   r    rA   rS   r@   Úrename_axisrT   r§   r¨   ré   )rG   r<   rW   Úexpectr@   Úmsgr0   r0   r1   Ú
test_countí  s*    

zTestMultiLevel.test_countr~   rt   r   ÚskipnaTFÚsortc                sX   | j j||d�}|j‡ ‡fdd„ƒ}t| j ˆ ƒ|ˆd�}|rH|j|d�}tj||ƒ d S )N)rt   rI  c                s   t | ˆ ƒˆd�S )N)rH  )r|   )r/   )r~   rH  r0   r1   r2     s    z:TestMultiLevel.test_series_group_min_max.<locals>.<lambda>)rt   rH  )rt   )r@   rC   Úaggr|   rÑ   rA   rT   )rG   r~   rt   rH  rI  r  ÚleftsideÚ	rightsider0   )r~   rH  r1   Útest_series_group_min_max
  s    z(TestMultiLevel.test_series_group_min_maxrv   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   )rt   rv   rI  c                s   ˆj | ƒ t| ˆƒˆˆ d�S )N)rH  rv   )rR   r|   )r/   )rv   r~   ÚpiecesrH  r0   r1   Úaggf-  s    
z1TestMultiLevel.test_frame_group_ops.<locals>.aggf)rt   rv   rH  )rt   rv   )r:   r¦   r<   r‡   r*   r#   ry   rC   rJ  r|   rÑ   rŸ   r!   ÚrenamerA   rd   rS   )rG   r~   rt   rv   rH  rI  Z
level_namer<   r  rO  rK  rL  Zlevel_indexr0   )rv   r~   rN  rH  r1   Ú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   )rt   )r   r   )r
   r	   r>   r   rA   rT   )rG   ÚobjrW   rj   r0   r0   r1   Útest_stat_op_corner?  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*   )rt   )r   ÚanyrA   rS   r½   )rG   r”   rW   Úexr0   r0   r1   Útest_frame_any_all_groupF  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   rK   r   Úms)rU   Út)rv   FTrU   rX  )rÜ   r*   )rÜ   )r   r
   r^   Zto_timedeltarT  rA   rT   )rG   r”   rW   rj   r0   r0   r1   Útest_series_any_timedeltaW  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 )NrQ   r$   )r*   r   r   rl   c                s   t | ˆƒˆ d�S )N)Úddof)r|   )r/   )rZ  Úmethr0   r1   r2   p  s    z7TestMultiLevel.test_std_var_pass_ddof.<locals>.<lambda>r   )rt   rZ  )rt   )r   r   )r	   r`   r:   rÓ   rÖ   rÕ   r   r;   r   r�   r|   rC   rJ  rA   rT   rS   )rG   r*   r”   ZaltrW   rj   r0   )rZ  r[  r1   Útest_std_var_pass_ddofh  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.   r3   )rt   r%   )rD   r   rC   rA   rS   rT   )rG   rW   rj   r0   r0   r1   Ú%test_frame_series_agg_multiple_levelsz  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   )rt   F)ru   r   )	rD   rC   r   r*   r  rA   rS   r#   ro   )rG   rW   Zk1Zk2rj   rû   r0   r0   r1   Útest_groupby_multilevelƒ  s     z&TestMultiLevel.test_groupby_multilevelc             C   s   d S )Nr0   )rG   r0   r0   r1   Ú&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   rl   )r*   r+   r   ÚTotalsrë   )r   r   )r   r   )r   r   )r   r   )r`  rë   )r	   r>   r   r:   r;   r   r   Z_consolidate)rG   r*   r”   r0   r0   r1   Ú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   )rb  r   )rb  r   )rD   rˆ   r*   r#   ro   r)   )rG   rW   rû   r0   r0   r1   Ú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  r3   r%   r   )r%   r   )r  r   )r  r   )rD   r³   r]   r:   Zfloat64ro   Zobject_)rG   r¶   r0   r0   r1   Ú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*   rl   )re  r   )re  r   )re  r   )r:   rÕ   rÓ   r	   rÖ   r
   r³   Úshapero   rÐ   rA   rT   rw   r*   )rG   r"   rt   r*   rK   rW   rØ   r0   r0   r1   Ú!test_unstack_group_index_overflow²  s,    
  
*
z0TestMultiLevel.test_unstack_group_index_overflowc          	      s\  d}dd„ dgd | dgd | dgd | t jg| dgd |  dg| dgd |  t jg| dgd	 |  dg|  gD ƒ‰ xlttˆ ƒƒD ]\}tjˆ ƒ}|jˆ | ƒ|ks¸t‚t j|d t j	d
�}|j
‡ fdd„|D ƒƒ}tj||ƒ q”W ttˆ ƒƒ}t jdgt|ƒ t j	d
�}tddgd | ƒ}|j
|g‡ fdd„|D ƒ ƒ}tj||ƒ d S )NrQ   c             S   s   g | ]}t |ƒ‘qS r0   )Útuple)r7   Úlr0   r0   r1   r8   Ý  s   z4TestMultiLevel.test_pyint_engine.<locals>.<listcomp>r   r$   r   r   r-  r,   )r]   c                s   g | ]}ˆ | ‘qS r0   r0   )r7   r¡   )Úkeysr0   r1   r8   ò  s    c                s   g | ]}ˆ | ‘qS r0   r0   )r7   r¡   )rj  r0   r1   r8   ù  s    rÊ   )r:   r¦   rr   r�   r	   r>   Zget_locro   rÓ   ZintpZget_indexerrA   Úassert_numpy_array_equalre   r˜   rh  )rG   ÚNrù   r*   rj   rW   ZidcesÚmissingr0   )rj  r1   Útest_pyint_engine×  s&    *	
z TestMultiLevel.test_pyint_enginec             C   s$   d| j j_| j jƒ  | j jjƒ  d S )Nr   )rD   r+   r)   Zto_htmlry   )rG   r0   r0   r1   Ú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*   rl   z^\(\('foo', 'bar', 0\), 2\)$)r¤   )r   r   r   )r   r   r   )r   r   r   )r   r   r   )r   r   r   ©r   r   r   )rp  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ˆ   r*   Z	droplevelrA   rT   r§   r¨   ré   ÚxsrS   )rG   r*   r@   r<   rW   rû   rj   r0   r0   r1   Útest_level_with_tuples  sH    $


$


z%TestMultiLevel.test_level_with_tuplesc             C   s6  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ddd�}|jdgdd�}tj||ƒ |jdgdd�}|jdgdd�}|jdgdd�}tj||ƒ |jddd�}|jdgdd�}tj||ƒ |jdgdd�}|jddd�}|jdddd�}|jddgdd�}tj||ƒ d S )NrU   ÚtopÚroutine1Úroutine2rë   ÚODrú   rû   ÚwxÚwyrl   rÉ   )r+   r   )rv   )rt   rv   )rU   rë   rë   )rs  rv  rw  )rs  rv  rx  )rs  rv  rw  )rs  rv  rw  )rs  rv  rx  )rt  rú   rë   )ru  rú   rë   )	Úsortedr=   r	   r>   r   r   rœ   rA   rS   )rG   rI   rJ   r*   r”   rW   rj   r0   r0   r1   Útest_mixed_depth_drop1  s,    
z$TestMultiLevel.test_mixed_depth_dropc             C   s”   t ddddgtjdddgddddgd	d
ddgdœƒjdddgƒjƒ }|jddd�}t d
d	gdgtjjddtjdfgdddgd�d�}t	j
||ƒ d S )Nr   r   ç        g      ð?g       @rU   rV   r�   r   r   r   rl   )r%   r&   r'   rY   r%   r&   r'   )rt   rY   )r#   )r+   r*   )r   r{  rV   )r   r:   r¦   rº   rÑ   rœ   r^   r	   r>   rA   rS   )rG   r”   rW   rj   r0   r0   r1   Ú$test_drop_multiindex_other_level_nanR  s    

 z3TestMultiLevel.test_drop_multiindex_other_level_nanc             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ddddgddddgddddgg	ddddgd�}|jdƒjƒ }|j|dk }|jdddgƒ}|j|jdd�jƒ }||jj	|jƒ  }|j|_t
j||ƒ d S )Nzx-ar/   rU   g      ø?g333333ó?zz-cÚzr�   gÍÌÌÌÌÌ@gffffff@zx-brV   gffffff@gš™™™™™@zy-arm   zz-bgÍÌÌÌÌÌ @r  Zvar2Zvar3Zvar4)r+   r   r   )rt   )r   rC   r  rˆ   rº   rœ   r*   r™   r  ÚisinrA   rS   )rG   r”   Zgrp_sizeZdrop_idxr  rW   rj   r0   r0   r1   Útest_drop_nonuniquej  s$    







z"TestMultiLevel.test_drop_nonuniquec       	      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 )NrU   rs  rt  ru  rë   rv  rú   rû   rw  rx  rl   rÉ   )r+   F)ru   r   )rv   )rU   rë   rë   )ry  r=   r	   r>   r   r   r5  ÚpoprA   rT   rS   r)   ro   rœ   )	rG   rI   rJ   r*   r”   r1  Údf2rW   rj   r0   r0   r1   Ú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   )rt   r   r   r£   r,   r-  )rv   rt   r%   )r<   rw   r‡   rA   rS   ry   rˆ   rT   )rG   rW   rj   r0   r0   r1   Ú$test_reindex_level_partial_selection   s    z3TestMultiLevel.test_reindex_level_partial_selectionc             C   sè   | j jddgdd�}| j jddddd	g }tj||ƒ | j jd
gdd�}| j jdddd	ddg }tj||ƒ | j jjddgddd�}| j jddddd	g j}tj||ƒ | j jjd
gddd�}| j jdddd	ddg j}tj||ƒ d S )Nr   r   r   )rt   r   r   r   rQ   rÉ   r   r    r   r£   r-  )rv   rt   )r<   rœ   r‡   rA   rS   ry   )rG   rW   rj   r0   r0   r1   Útest_drop_level±  s    zTestMultiLevel.test_drop_levelc             C   s¤   t dddddgdd�}tjddd	d	d
gƒ}ttjdƒjddƒtdƒ|d�}||d< |jddd�}t	d	ƒ}|j
jdksxt‚|j|dd�}|j|dk }tj||ƒ d S )Nr   r   rl   rQ   Úid)r)   Z201603231400Z201603231500Z201603231600Z201603231700r$   Úab)r+   r*   ZtstampT)rR   F)rt   )r   r^   r  r   r:   rÓ   rÔ   r˜   rº   r   r*   rÂ   ro   rœ   rˆ   rA   rS   )rG   rù   Zidxdtr”   ÚtsrW   rj   r0   r0   r1   Ú"test_drop_level_nonunique_datetimeÂ  s     z1TestMultiLevel.test_drop_level_nonunique_datetimeÚboxc       
      C   sŠ   t ddd�}t ddd�}tj||dd�}|dgt|ƒ |d�}|j|ƒ}t d	dd�}tj||dd�}|dgt|ƒ |d�}	tj||	ƒ d S )
Nz
2017-10-29zEurope/Berlin)r\   z2017-10-29 04:00:00Z15min)rZ   r   )rÜ   r*   z2017-10-29 00:15:00)r   r^   r_   r�   rœ   rA   Zassert_equal)
rG   r‰  ÚstartÚendr*   rÜ   rW   Zexpected_startZexpected_idxrj   r0   r0   r1   Ú'test_drop_tz_aware_timestamp_across_dstØ  s    
z6TestMultiLevel.test_drop_tz_aware_timestamp_across_dstc             C   sd   t jddddddgddddddggddgd�}ttjjddƒ|d	�}|jd
gƒ}|jjdks`t	‚d S )Nr   r   r   r   r   r   )r#   rÉ   )r*   )r   r   )r   r   )
r	   r`   r   r:   r;   r   rœ   r*   r#   ro   )rG   r*   r”   rW   r0   r0   r1   Útest_drop_preserve_nameså  s
    *z'TestMultiLevel.test_drop_preserve_namesc             C   sV   t dddgƒt ddgƒg}tjdƒjdƒtjtjdƒdƒg}t||d�}t|jƒ d S )	Nu   a/Ïƒu   b/Ïƒu   c/Ïƒr   r   r   r   )r!   r"   )r   r:   rÓ   rÖ   rÕ   r	   r�   r!   )rG   r!   r"   r*   r0   r0   r1   Útest_unicode_repr_issuesï  s    "z'TestMultiLevel.test_unicode_repr_issuesc             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*   rl   )r   r   )r   r   )	r	   r>   r
   rr   r   r:   r;   r   r�   )rG   r*   rK   r”   r0   r0   r1   Ú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   )rU   rV   r/   )rU   rV   rm   rU   rV   rÃ   rÄ   r3  )r¾   )rÃ   rÄ   r3  )r   rº   r4  )rG   r1  r�  r¾   r0   r0   r1   Útest_join_segfault  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   rl   )r*   )r]   )r   r   r   )r   r   r   )r   r   )r   r   )r   r   )r   rl   )r   r   )r   r   )r   r   )r   rl   )r
   r	   r>   rf   r   Z	from_dict)rG   r)  r*  Zs3r0   r0   r1   Ú(test_frame_dict_constructor_empty_series  s      
z7TestMultiLevel.test_frame_dict_constructor_empty_seriesr  rl   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 )	NrU   rV   r�   r   r   r   )rU   rV   r�   r  )r!   r"   r#   )r   rU   rC   r   r*   r	   rA   rd   )rG   r  Z
group_keysr”   ÚgrW   rj   r0   r0   r1   Ú+test_empty_frame_groupby_dtypes_consistency  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'   rY   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�   )rG   Zdf3r  r0   r0   r1   Útest_multiindex_na_repr&  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   rl   rQ   rÉ   r£   r,   r-  )rU   rV   r�   rU   rV   ÚfazÚboor   )r™  rš  )r   rº   r˜   r*   r�   )rG   r”   r*   r0   r0   r1   Útest_assign_index_sequences6  s    "

z*TestMultiLevel.test_assign_index_sequencesc             C   sn   t ddgddddggddddddddgddddddddggd�}t|d d ƒsTt‚t|jd d ƒsjt‚d S )Nr   r   r   r   )r!   r"   rl   rÊ   )r	   r   ro   r6  )rG   r*   r0   r0   r1   Útest_tuples_have_naE  s
    ,z"TestMultiLevel.test_tuples_have_nac             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
   rC   r*   r   r�   ro   )rG   Zidx_tpÚdtrù   rK   rW   r0   r0   r1   Útest_duplicate_groupby_issuesN  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      @rl   g      @rQ   g      @rÉ   ÚABCD)r+   r%   r&   r   )rt   )r   r   )r   r˜   rº   rÑ   rˆ   rA   rS   )rG   r”   rj   rW   r0   r0   r1   Útest_duplicate_mi]  s     




 

z TestMultiLevel.test_duplicate_mic             C   sz  t jddddddgddddddgfƒ}tjddddddgtd�}|jƒ }tj||ƒ |jtksbt	‚t jdddddgdddddgfƒ}tj
|jƒ |ƒ tjddddddgƒ}|jdd�}tj||ƒ |jtksÐt	‚t jdddddgdddddgfƒ}tj
|jdd�|ƒ tjddddddgƒ}|jdd�}tj||ƒ |jtk�sDt	‚t jddddgddddgfƒ}tj
|jdd�|ƒ d S )	Nr   r   r   FT)r]   Úlast)Zkeep)r	   r`   r:   re   ÚboolÚ
duplicatedrA   rk  r]   ro   rd   Zdrop_duplicates)rG   rù   rj   r§  r0   r0   r1   Útest_duplicated_drop_duplicatess  s&    &""z.TestMultiLevel.test_duplicated_drop_duplicatesc             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   rl   rQ   rÉ   )Út1Út2r   r   rJ   )r   r   )r   r   )r   r   )r   r	   r>   rº   )rG   r  r”   rJ   r*   r0   r0   r1   Útest_multiindex_set_indexŒ  s    
z(TestMultiLevel.test_multiindex_set_indexc             C   sô   t jdddgd dd�}t jddd	d
d�}tj||gƒ}t jdddgdd�}tj|jd |ƒ tj|jd |ƒ tj	j
ƒ }tjj
ƒ }tj
ƒ }xbtj|||g|||gƒD ]F\}}	tj|g|	ggƒ}
t|
jd t jƒsÖt‚t|
jd t jƒs¦t‚q¦W d S )Nz2013-04-01 9:00z2013-04-02 9:00z2013-04-03 9:00r   z
Asia/Tokyo)r\   z
2010/01/01rÉ   rô   z
US/Eastern)r[   rZ   r\   r   r   )r^   ÚDatetimeIndexr_   r	   r`   rA   rd   r!   rc   r  Útodayr   r"  r   r»   rn   ro   )rG   rg   rh   rù   Ú	expected1Zdate1Zdate2Zdate3Zd1Zd2r*   r0   r0   r1   Útest_datetimeindex—  s     

"z!TestMultiLevel.test_datetimeindexc             C   s¼   t jddgddd�}t jddgdd	d�}tj||gƒ}|jddgksHt‚tj|jd
 |ƒ tj|jd |ƒ tjt	|ƒt	|ƒgƒ}|jddgks”t‚tj|jd
 |ƒ tj|jd |ƒ d S )Nz2013/01/01 09:00z2013/01/02 09:00Zdt1z
US/Pacific)r)   r\   z2014/01/01 09:00z2014/01/02 09:00Zdt2z
Asia/Tokyor   r   )
r^   r¬  r	   r`   r#   ro   rA   rd   r!   r
   )rG   r*   r+   rW   r0   r0   r1   Útest_constructor_with_tz±  s    z'TestMultiLevel.test_constructor_with_tzc             C   s<  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	|ƒ}|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 )NrU   rV   z2011-07-19 07:00:00z2011-07-19 08:00:00z2011-07-19 09:00:00rÉ   )Úlabelrc   r�   rc   T)Úutcz
US/Pacific)r)   ÚUTCr±  )rR   r   r   z
US/Eastern)r\   z2012-04-01 09:00z2012-04-02 09:00z2011-01-01 09:00z
Asia/Tokyo)r[   r\   r   )r   rr   r^   r  r€  r*   Z
tz_convertr¬  Ztz_localizerº   rA   rd   r!   r   r#   ro   rÒ   r:   r;   r_   r  )rG   r”   rj   rg   rh   ri   r®  Ú	expected2r0   r0   r1   Útest_set_index_datetimeÆ  sn      
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/2011rQ   rY   rg   )r[   rZ   r\   r)   rh   r®   )r)   r]   )r]   r%   r&   r'   r  )rU   rV   )r*   iÛ  r   r   r   rl   )rg   rh   rU   rV   rU   rV   )r+   c                s   t | ˆ d�S )N)r\   )r   )r  )r\   r0   r1   r2   1  s    z:TestMultiLevel.test_reset_index_datetime.<locals>.<lambda>z1/1/2012ZMSzEurope/Parisri   iÜ  )rg   rh   ri   rU   rV   c                s   t | ˆ d�S )N)r\   )r   )r  )r\   r0   r1   r2   T  s    c             S   s   t | dd�S )NzEurope/Paris)r\   )r   )r  r0   r0   r1   r2   V  s    Ú20130101)r[   r\   rÉ   )r+   r*   za a a b b biÝ  )Úlevel_0Úlevel_1rU   r¹  rº  c                s   t | dˆ d�S )NrY   )rZ   r\   )r   )r  )r\   r0   r1   r2   p  s    )r³  r¶  r·  )r^   r_   r   rr   r	   r`   r   r:   rÓ   rc   rå   rA   rS   r™   r»   rÔ   r’   )rG   rg   rh   rù   r”   rj   ri   r0   )r\   r1   Ú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[   rZ   Úabcr3   Úfeature)r#   r-  r®   )r]   r   rU   )r*   r+   z2013-01)rZ   z2013-02z2013-03rV   r�   )r3   r½  rU   )r+   rÊ   )r	   r»   r^   Úperiod_ranger˜   r   r:   rÓ   rÔ   ZPeriodrA   rS   r™   )rG   rù   r”   rj   r0   r0   r1   Útest_reset_index_periodt  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&   rV   r   r   r   r   )r+   z)cannot insert \('A', ''\), already exists)r¤   r¹  )rv   T)rR   z0Item must have length equal to number of levels.r'   r�   r¡   rU   Úii)Úcol_fillzFcol_fill=None is incompatible with incomplete column name \('C', 'c'\))Z	col_levelrÁ  )r%   rë   )r¹  rë   )r&   rV   )r%   rë   )r&   rV   )r'   r�   r¡   )r'   r�   rÀ  )r'   r�   )r'   r�   )r�   rÀ  )r   r	   r>   rD  r™   rA   rS   r§   r¨   rð   rº   r^   Úconcat)rG   r!   r”   rW   rF  Zidx_colrj   r�  r0   r0   r1   Ú#test_reset_index_multiindex_columnsŒ  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[   rZ   z2013-01-01 09:00r   ÚHZ2005r%   T)rR   r   r   )r   r:   r;   r^   r¾  rR   rº   rA   rd   r*   r!   r  )rG   r”   rg   rh   ri   r®  r´  r0   r0   r1   Ú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   rl   rQ   rÉ   r£   r,   rU   rV   r�   r  )r*   )r   r   )r   rl   )rQ   rÉ   )r£   r,   )r	   r>   r
   rÖ   rf  r�   ro   )rG   Zm_idxrÜ   Zm_dfr0   r0   r1   Ú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   rU   rV   r�   ç        )r+   )rU   r�   rÇ  )r:   r¦   r   r^   r	   r>   ÚdtypesrU   rV   rA   rT   )rG   rÜ   r+   r”   rj   rW   r0   r0   r1   Útest_subsets_multiindex_dtypeà  s    


z,TestMultiLevel.test_subsets_multiindex_dtype)jrM   rN   rO   rX   rk   rq   rs   r{   r„   r†   r‰   r‹   rŽ   r–   r›   rž   rª   r­   r¯   r²   r·   r§   ÚmarkZ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'  r2  r8  r<  r=  r?  rC  rG  ÚAGG_FUNCTIONSrM  rQ  rS  rV  rY  r\  r]  r^  r_  ra  rc  rd  rg  rn  ro  rr  rz  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Ã  rÅ  rÆ  rÉ  r0   r0   r0   r1   rP   I   sè   	.


a
	E/	!
 "#	
%%0!


	Q]4rP   c               @   s�   e Zd 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"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#   ro   )rG   rW   r0   r0   r1   Ú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   rl   g      ð?g      @g       @g      @g      @r   r   rQ   r¸  Z20130103Z20130102Z20130105Z20130104Z1oneZ3oneZ2oneZ5oneZ4onec             S   s   g | ]}d |f‘qS )Úredr0   )r7   r¡   r0   r0   r1   r8     s    z5TestSorted.test_sorting_repr_8017.<locals>.<listcomp>Údef)r*   r+   ZworldrÎ  )rv   )r:   r;   Úseedr   r   r	   r>   r   r˜   r^   rÂ  rõ   Ú
splitlinesr’   ro   r5  rÑ   r‡   rA   rS   )	rG   rÜ   Úgenrä   r+   r”   r�  rW   rj   r0   r0   r1   Útest_sorting_repr_8017ñ  s>    z!TestSorted.test_sorting_repr_8017c             C   st   | j jƒ }tjt|ƒƒ|_| j d jdd�}|jj| j jjksBt‚| j jƒ }|jddd� t	j
|| j jdd�ƒ d S )Nr%   r   )rt   T)rt   r9   )r<   r5  r:   rÓ   r�   r*   rÑ   r#   ro   rA   rS   )rG   r”   Za_sortedr	  r0   r0   r1   Útest_sort_index_level*  s    

z TestSorted.test_sort_index_levelc             C   s°   t jtjdƒgd ƒ}ttjjdƒ|tjd�}|jdd�}|j	j
dksJt‚t jtjdƒgd ƒ}ttjjdƒ|tjd�}|jdd�}|jj|jjkjƒ sœt‚|j	j
dks¬t‚d S )Ni   r   )r*   r]   r   )rt   )r	   r`   r:   rÓ   r   r;   r   r®   rÑ   r*   Úlexsort_depthro   rµ   rÈ  r6  r½   )rG   r*   r”   rW   r0   r0   r1   Ú'test_sort_index_level_large_cardinality;  s    z2TestSorted.test_sort_index_level_large_cardinalityc             C   s:   ddg| j j_| j jdd�}| j jdd�}tj||ƒ d S )Nr   r    )rt   r   )r<   r*   r#   rÑ   rA   rS   )rG   rW   rj   r0   r0   r1   Útest_sort_index_level_by_nameN  s    z(TestSorted.test_sort_index_level_by_namec             C   s˜   | j jdd�}| j jƒ }d|d< |jdd�}tj||jdgdd�ƒ | j j}|jddd�}d|d< |jddd�}tj|jd	gdd�|jd
gdd�ƒ d S )Nr   )rt   r   r   )rv   )rt   rv   r   )r   r   )r   r   )r   r   )r<   rÑ   r5  rA   rS   rœ   ry   )rG   Zsorted_beforer”   Zsorted_afterZdftr0   r0   r1   Útest_sort_index_level_mixedT  s    
z&TestSorted.test_sort_index_level_mixedc          	   C   sÄ   ddgdddgg}t |ddddddgddddddggd�}|jƒ sFt‚t |ddddddgddddddggd�}|jƒ  s|t‚t |ddddddgddddddggd�}|jƒ  s²t‚|jdksÀt‚d S )Nr   r   r   )r!   r"   )r	   Úis_lexsortedro   rÕ  )rG   r!   r*   r0   r0   r1   Útest_is_lexsortedf  s    &&&zTestSorted.test_is_lexsortedc             C   sÈ   ddgdddgg}t |ddddddgddddddggdd� tjtdd��0 t |ddddddgddddddggdd� W d Q R X tjtdd��0 t |ddddddgddddddggdd� W d Q R X d S )Nr   r   r   )r!   r"   Ú	sortorderz%.* sortorder 2 with lexsort_depth 1.*)r¤   z%.* sortorder 1 with lexsort_depth 0.*)r	   r§   r¨   rð   )rG   r!   r0   r0   r1   Útest_raise_invalid_sortordery  s    (z'TestSorted.test_raise_invalid_sortorderc          	   C   s¾   ddgdddgg}t |ddddddgddddddggdd�}|jdksJt‚t |ddddddgddddddggdd�}|jdks‚t‚t |ddddddgddddddggdd�}|jdksºt‚d S )Nr   r   r   )r!   r"   rÛ  )r	   rÕ  ro   )rG   r!   r*   r0   r0   r1   Útest_lexsort_depth’  s    (((zTestSorted.test_lexsort_depthc          	   C   s>  t ddgddggtdƒd�}t ddgddgddgddggtjddddgƒd�}|jjƒ s\t‚t ddgddgddgddggtjddgtdƒgƒd�}|jƒ }|jjƒ s¨t‚|jj	s´t‚t
j||ƒ t ddgddgddgddggtddgddggd	d	ddgd	dd	dggd
�d�}|jƒ }|jjƒ �s$t‚t
j||ƒ tj||gddgd�}|jƒ }|jjƒ �s^t‚|jj	�slt‚t
j||ƒ t ddgddggtjddgddgd�d�}|jjtj|jjd ƒddd� |jjƒ  �sÔt‚|jj	 �sät‚|jdd�}|jjƒ �s t‚|jj	�st‚|jddd�}|jjƒ �s,t‚|jj	�s:t‚d S )Nr   r   r†  )r*   ç      à?rU   rV   çš™™™™™é?r   )r!   r"   )rj  rÉ   r£   ú20160811 12:00:00ú20160809 12:00:00Úl1ÚDate)r#   )r+   T)rt   r9   )rv   )rv   rt   )rÞ  rU   )rÞ  rV   )rß  rU   )rß  rV   )r   rà  )r   rá  )r   r˜   r	   r>   r*   rÙ  ro   r»   rÑ   Úis_monotonicrA   rS   r^   rÂ  r+   rE   r  r!   )rG   r”   rj   rW   Z	concattedr0   r0   r1   Ú"test_sort_index_and_reconstruction¨  sP    .z-TestSorted.test_sort_index_and_reconstructionc          	   C   s  t dddddgitddgdd	ggd
d
ddgd
dd
dggd�d�}|jjƒ sNt‚|jj s\t‚t dddddgitddgd	dggd
d
ddgd
dd
dggd�d�}|jƒ }|jjƒ s²t‚|jjs¾t‚tj||ƒ |jƒ j	ƒ }|jj
ƒ |_|jjƒ sðt‚|jjsüt‚tj||ƒ d S )Nr�   r   r   r   rl   rU   rV   ZbbZaar   )r!   r"   )r*   )r   r	   r*   rÙ  ro   rä  rÑ   rA   rS   r5  Z_sort_levels_monotonic)rG   r”   rj   rW   r0   r0   r1   Ú.test_sort_index_and_reconstruction_doc_exampleé  s&    ..z9TestSorted.test_sort_index_and_reconstruction_doc_examplec             C   sJ   t dg tjjg g gƒd�}d|jd	< d|jd
< |jƒ jj}|dksFt‚d S )Nr   )r+   r*   r   rV   Ú2rU   Ú3T)rV   rç  )rU   rè  )	r   r^   r	   r»   rˆ   rÑ   r*   rä  ro   )rG   r”   rW   r0   r0   r1   Ú-test_sort_index_non_existent_label_multiindex		  s
    

z8TestSorted.test_sort_index_non_existent_label_multiindexc             C   s    t tjjddƒtjddgddgddggd	d
dgd�ddgd�}|jƒ }dd„ }|jd	d
gd�j|ƒjƒ }tjddgddgddggd	d
d gd�}t	j
|j|ƒ d S )Nr,   r   rU   rV   ÚbigÚsmallrÎ  ZbluÚletterr  Úcolor)r#   ZnearZfar)r*   r+   c             S   s   ddg| _ | S )NÚnewzÚnewa)r*   )Úgroupr0   r0   r1   Úmy_func	  s    
z:TestSorted.test_sort_index_reorder_on_ops.<locals>.my_func)rt   rï  rî  )r   r:   r;   r   r	   r»   rÑ   rC   rå   rA   rd   r*   )rG   r”   rñ  rW   rj   r0   r0   r1   Útest_sort_index_reorder_on_ops	  s    z)TestSorted.test_sort_index_reorder_on_opsc          	   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�   rV   rU   r   r   r   r  r®   )r*   r]   FTrl   rQ   )r&   rU   )r&   r�   )r'   rU   )r'   rV   )r	   r   rr   r�   r*   rÙ  ro   rä  rÑ   r>   rˆ   r^   Z
IndexSlicerA   rS   )rG   rù   r”   ry  rj   rW   r0   r0   r1   Útest_sort_non_lexsorted)	  s    4$z"TestSorted.test_sort_non_lexsortedc             C   s  ddgt jt jgt jdgddgg}tj|ƒ}tt jdƒjddƒ|tdƒd	�}tt jdƒ|d
�}tt	j
ddddddddddddgƒddddddddddddgdt jddt jdddt jdddgdddddddt jd d!ddgd"œƒjd#d$gƒ}|jƒ }|jddddgd d …f }tj||ƒ |jd%d&�}|jddddgd d …f }tj||ƒ |jd'd&�}|jddddgd d …f }tj||ƒ |jƒ jƒ }|jƒ jƒ }tj||ƒ |jƒ }|jddddg }tj||ƒ |jd%d&�}|jddddg }tj||ƒ |jd'd&�}|jddddg }tj||ƒ d S )(NrÈ   é   r   r   r   r  rl   r£  )r*   r+   )r*   Z20121002Z20121007Z20130130Z20130202Z20130305Z20121207rQ   iþ  i  i  io  éZ   i8  i-  ig  i!  é   r$   é   é'   r   é-   é"   )r  Úuser_idZ
whole_costZcostr  rû  r¥  )Zna_positionr   )r:   r¦   r	   r>   r   rÓ   rÔ   r˜   r
   r^   r  rº   rÑ   r‡   rA   rS   r¿   rT   )rG   rJ   rÙ   r”   rK   r�  rW   rj   r0   r0   r1   Útest_sort_index_nanC	  sl    "
 $
zTestSorted.test_sort_index_nanc          
   C   sÞ   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}t |Ž }tj|dddgd�}ttdƒ|d�}|jddgdd�}|jdddd
dd	ddg }tj||ƒ |jddgddgd�}|jddd
dd	dddg }tj||ƒ d S )Nr   r   r   r   r   r   rl   r   r   r   r   r    Zthird)r#   r,   )r*   F)rt   rÁ   r   rQ   rÉ   r£   T)	r=   r	   r>   r
   rr   rÑ   r‡   rA   rT   )rG   rI   rJ   rÙ   rK   rW   rj   r0   r0   r1   Útest_sort_ascending_list”	  s    z#TestSorted.test_sort_ascending_listN)rM   rN   rO   Ú__doc__rÍ  rÓ  rÔ  rÖ  r×  rØ  rÚ  rÜ  rÝ  rå  ræ  ré  rò  ró  rü  rý  r0   r0   r0   r1   rÌ  ê  s"   9A QrÌ  )rc   Úior   r"  r   Znumpyr:   Znumpy.randomr   r§   ra   Zpandas.core.dtypes.commonr   r   Zpandasr^   r   r   r	   r
   r   r   Zpandas._testingZ_testingrA   rË  r   rP   rÌ  r0   r0   r0   r1   Ú<module>   sP    
)               0