3
Êb_T†  ã               @   sh   d dl Zd dlZd dlZd dlmZmZmZmZ d dl	j
ZG dd„ dƒZG dd„ dƒZG dd„ dƒZdS )	é    N)Ú	DataFrameÚlreshapeÚmeltÚwide_to_longc            
   @   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ejjdejejddd d!�ƒejd"d#d$d"d%gd&d'�ejd(d)d(d(d(gƒgƒd*d+„ ƒZd,d-„ Zd.d/„ Zd0d1„ Zd2d3„ Zd4S )5ÚTestMeltc             C   s    t jƒ d d… | _| jd dkjtjƒ| jd< | jd dkjtjƒ| jd< d| _d| _tj	d	ddgdddgdddggƒ| _
tdƒtdƒg| j
_ddg| j
j_d S )Né
   ÚAr   Úid1ÚBÚid2ÚvarÚvalg5ì÷Ä:ñ?gS°ÆÙtÄñ?gKÔÔ²µÊ?g†U¼‘y$õ?gê> ©Mœ×?g†K®âð?giÿ¬Õé?g<Ú8b->µ?ghB“Ä’òë?ÚABCÚabcÚCAPÚlowgS°ÆÙtÄñ¿g†U¼‘y$õ¿g†K®âð¿giÿ¬Õé¿ghB“Ä’òë¿)ÚtmZmakeTimeDataFrameÚdfÚastypeÚnpZint64Úvar_nameÚ
value_nameÚpdr   Údf1ÚlistÚcolumnsÚnames)ÚselfÚmethod© r   ú@/tmp/pip-build-jkwsxyiy/pandas/pandas/tests/reshape/test_melt.pyÚsetup_method
   s    zTestMelt.setup_methodc             C   s$   t | jƒ}|jjƒ ddgks t‚d S )NÚvariableÚvalue)r   r   r   ÚtolistÚAssertionError)r   Úresultr   r   r    Útest_top_level_method   s    
zTestMelt.test_top_level_methodc             C   sœ   t j| jjƒ t| jƒƒ t j| jjddgddgd�t| jddgddgd�ƒ t j| jj| j| jd�t| j| j| jd�ƒ t j| jjdd�t| jdd�ƒ d S )	Nr	   r   r   r
   )Úid_varsÚ
value_vars)r   r   r   )Ú	col_level)r   Úassert_frame_equalr   r   r   r   r   )r   r   r   r    Útest_method_signatures    s    zTestMelt.test_method_signaturesc             C   sx   | j jƒ }|jjƒ ddgks t‚| j jdgd�}|jjƒ dddgksHt‚| j jddgd�}|jjƒ ddddgkstt‚d S )Nr"   r#   r	   )r(   r   )r   r   r   r$   r%   )r   r&   Zresult1Zresult2r   r   r    Útest_default_col_names/   s    
zTestMelt.test_default_col_namesc             C   s®   | j jddgdd�}t|ƒdks$t‚| j jddgddgd�}t| j d jƒ d | j d jƒ d dgd dgd  | j d jƒ | j d jƒ  dœddd	d
gd�}tj||ƒ d S )Nr	   r   r   )r(   r)   r   r
   é   )r	   r   r"   r#   r"   r#   )r   )r   r   Úlenr%   r   r$   r   r+   )r   Zresult3Zresult4Z	expected4r   r   r    Útest_value_vars9   s    zTestMelt.test_value_varsc             C   s    t | jd jƒ d | jd jƒ d dgd dgd  | jd jƒ | jd jƒ  dœdddd	gd
�}x8tttjfD ](}| jjddg|dƒd�}tj	||ƒ qpW d S )Nr	   r.   r   r   r   r
   )r	   r   r"   r#   r"   r#   )r   )r(   r)   )r   r
   )
r   r   r$   Útupler   r   Úarrayr   r   r+   )r   ÚexpectedÚtype_r&   r   r   r    Útest_value_vars_typesI   s    zTestMelt.test_value_vars_typesc             C   sl   t d
| jd ddgt| jƒ ddgt| jƒ d| jd iddddgd�}| jjdgdgd	�}tj||ƒ d S )Nr   Úar   r
   r   Úbr#   )r   )r(   r)   )r   r6   )r   r6   )r
   r7   )r   r6   )r   r6   )r
   r7   )r   r   r/   r   r   r+   )r   r3   r&   r   r   r    Útest_vars_work_with_multiindexY   s    
z'TestMelt.test_vars_work_with_multiindexc             C   sN   t ddddœddddœddddœd	œƒ}| jjd
gdgdd�}tj||ƒ d S )Ng5ì÷Ä:ñ?g†U¼‘y$õ?giÿ¬Õé?)r   é   r.   r
   gS°ÆÙtÄñ?gê> ©Mœ×?g<Ú8b->µ?)r   r   r#   r   r   )r*   g†U¼‘y$õ¿giÿ¬Õé¿gS°ÆÙtÄñ¿)r   r   r   r   r+   )r   r3   r&   r   r   r    Ú%test_single_vars_work_with_multiindexg   s    

z.TestMelt.test_single_vars_work_with_multiindexc             C   sj   d}|g}d	}|g}d}xL||f||f||ffD ]2\}}t jt|d�� | jj||d� W d Q R X q0W d S )
Nr   r6   r
   r7   zF(id|value)_vars must be a list of tuples when columns are a MultiIndex)Úmatch)r(   r)   )r   r6   )r
   r7   )ÚpytestÚraisesÚ
ValueErrorr   r   )r   Ztuple_aZlist_aZtuple_bZlist_bÚmsgr(   r)   r   r   r    Ú$test_tuple_vars_fail_with_multiindexr   s    z-TestMelt.test_tuple_vars_fail_with_multiindexc             C   sL  | j j| jd�}|jjƒ ddgks&t‚| j jdg| jd�}|jjƒ dddgksRt‚| j jddg| jd�}|jjƒ ddddgks‚t‚| j jddgd| jd�}|jjƒ ddddgks´t‚| j jddgdd	g| jd�}td| j d jƒ d
 d| j d jƒ d
 | jdgd d	gd  d| j d jƒ | j d	 jƒ  idd| jdgd�}tj||ƒ d S )N)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result5Zresult6Zresult7Zresult8Zresult9Z	expected9r   r   r    Útest_custom_var_name„   s$    zTestMelt.test_custom_var_namec             C   sL  | j j| jd�}|jjƒ ddgks&t‚| j jdg| jd�}|jjƒ dddgksRt‚| j jddg| jd�}|jjƒ ddddgks‚t‚| j jddgd| jd�}|jjƒ ddddgks´t‚| j jddgdd	g| jd�}td| j d jƒ d
 d| j d jƒ d
 ddgd d	gd  | j| j d jƒ | j d	 jƒ  iddd| jgd�}tj||ƒ d S )N)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result10Zresult11Zresult12Zresult13Zresult14Z
expected14r   r   r    Útest_custom_value_name¡   s$     zTestMelt.test_custom_value_namec       	      C   s–  | j j| j| jd�}|jjƒ ddgks*t‚| j jdg| j| jd�}|jjƒ dddgksZt‚| j jddg| j| jd�}|jjƒ ddddgksŽt‚| j jddgd| j| jd�}|jjƒ ddddgksÄt‚| j jddgdd	g| j| jd�}td| j d jƒ d
 d| j d jƒ d
 | jdgd d	gd  | j| j d jƒ | j d	 jƒ  idd| j| jgd�}tj	||ƒ | j j
ƒ }d|j_|jƒ }|jjƒ ddgk�s’t‚d S )N)r   r   r   r   r	   )r(   r   r   r   r   )r(   r)   r   r   r
   r.   r   )r   Úfoor#   )r   r   r   r   r   r$   r%   r   r   r+   ÚcopyÚname)	r   Zresult15Zresult16Zresult17Zresult18Zresult19Z
expected19Zdf20Zresult20r   r   r    Útest_custom_var_and_value_name¾   s<    

 
z'TestMelt.test_custom_var_and_value_namec             C   sL   | j jdd�}| j jdd�}|jjƒ ddgks2t‚|jjƒ ddgksHt‚d S )Nr   )r*   r   r#   )r   r   r   r$   r%   )r   Zres1Zres2r   r   r    Útest_col_levelë   s    zTestMelt.test_col_levelc             C   s&   | j jƒ }|jjƒ dddgks"t‚d S )Nr   r   r#   )r   r   r   r$   r%   )r   Úresr   r   r    Útest_multiindexñ   s    
zTestMelt.test_multiindexÚcolZ2010é   z
US/Pacific)ZperiodsÚtzr6   r7   ÚcÚdÚcategory)Zdtyper   r9   c             C   s²   t tdƒ|dddddg|dœƒ}tjtjdddddgƒ|gdd�}t|ddgd	d
d�}t ttdƒƒd tj|gd dd�dgd dgd  |dœƒ}ddd	d
g|_tj	||ƒ d S )NrK   r9   r   )ÚklassrJ   Úattr1Úattr2T)Zignore_indexrP   rJ   Ú	attributer#   )r(   r   r   r.   rQ   rR   )r   r9   r.   é   )
r   Úranger   ÚconcatÚSeriesr   r   r   r   r+   )r   rJ   r   Zexpected_valuer&   r3   r   r   r    Útest_pandas_dtypesõ   s    
"
zTestMelt.test_pandas_dtypesc             C   s`   t ddgtjddgƒdœƒ}tj|dgdgƒ}t tjddgƒddgddgdœƒ}tj||ƒ d S )	Nr9   r.   ÚXÚY)r   r
   r
   r   )r
   r"   r#   )r   r   ZCategoricalr   r   r+   )r   Údatar&   r3   r   r   r    Útest_preserve_category  s
     zTestMelt.test_preserve_categoryc          (   C   sV  t jtjjddƒtdƒd�}d}tjt|j	ddd�d	�� |j
d
dgddgƒ W d Q R X tjt|j	ddd�d	�� |j
ddgddgƒ W d Q R X tjt|j	ddd�d	�� |j
d
dddgddgƒ W d Q R X |jƒ }tdƒtdƒg|_tjt|j	ddd�d	�� |j
dgdgƒ W d Q R X tjt|j	ddd�d	�� |j
dgdgdd� W d Q R X d S )NrK   é   Zabcd)r   z=The following '{Var}' are not present in the DataFrame: {Col}r)   z\['C'\])ZVarZCol)r;   r6   r7   ÚCrN   r(   z\['A'\]r   rM   z\['not_here', 'or_there'\]Znot_hereZor_thereÚABCDz\['E'\]ÚEr
   z\['F'\]ÚFr   )r*   )r`   r6   )r
   r7   )r   r   r   ÚrandomÚrandnr   r<   r=   ÚKeyErrorÚformatr   rD   r   )r   r   r?   Zmultir   r   r    Ú test_melt_missing_columns_raises  s$    "z)TestMelt.test_melt_missing_columns_raisesc             C   sf   t dgdgdgdgdœƒ}t|ddgdd	gd
�}t dgd dgd tdƒddgdœƒ}tj||ƒ d S )NrC   Úbarr9   r.   )r   r6   r7   rN   r   r6   r7   rN   )r(   r)   Zbd)r   r6   r"   r#   )r   r   r   r   r+   )r   r   r&   r3   r   r   r    Útest_melt_mixed_int_str_id_vars@  s
    $z(TestMelt.test_melt_mixed_int_str_id_varsc             C   sH   t dgdgdœƒ}t|ddgd�}t ddgddgdœƒ}tj||ƒ d S )NrC   rg   )r   r6   r   r6   )r)   )r"   r#   )r   r   r   r+   )r   r   r&   r3   r   r   r    Ú"test_melt_mixed_int_str_value_varsI  s    z+TestMelt.test_melt_mixed_int_str_value_varsN)Ú__name__Ú
__module__Ú__qualname__r!   r'   r,   r-   r0   r5   r8   r:   r@   rA   rB   rF   rG   rI   r<   ÚmarkZparametrizer   rW   Z
date_rangerX   r\   rf   rh   ri   r   r   r   r    r   	   s.   
- 
%	r   c               @   s   e Zd Zdd„ ZdS )ÚTestLreshapec             C   sø  dddddgdddd	d
gdddddgdddddgdddddgdt jdddgdt jt jddgdddd d!gd"t jd#d$d%gd&t jt jd'd(gd)œ
}t|ƒ}d*d+„ td,d-ƒD ƒd.d+„ td,d-ƒD ƒd/œ}t||ƒ}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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dddddddddddgd0d$d1d2d3d"d#d$d%d&d'd(gd4œ}t||jd5�}tj||ƒ t||d6d7�}ddd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dd	d
gddd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dddgddddddt jddddt jt jddgd0d$d1d2d3d"t jd#d$d%d&t jt jd'd(gd4œ}t||jd5�}tj||ƒ tjt	ƒ� t||d6d8d9�}W d Q R X d:d+„ td,d;ƒD ƒd<d+„ td,d-ƒD ƒd/œ}d=}t
jt|d>�� t||ƒ W d Q R X d S )?NZ	08jan2009Z	20dec2008Z	30dec2008Z	21dec2008Z	11jan2009iæ  iå  i®  iC  i%  ée   éf   ég   éh   éi   ZMaleZFemaleZ	22dec2008Z	04jan2009Z	29dec2008Z	20jan2009Z	21jan2009Z	22jan2009Z	31dec2008Z	03feb2009Z	05feb2009Z	02jan2009Z	15feb2009i  i
  i  iâ  iÒ  g     lŸ@g     ��@g     ª@g     ß±@g     ê¡@g     bª@g     Å²@)
ÚbirthdtÚbirthwtÚidÚsexZvisitdt1Zvisitdt2Zvisitdt3Zwt1Zwt2Zwt3c             S   s   g | ]}d j |d�‘qS )zvisitdt{i:d})Úi)re   )Ú.0rx   r   r   r    ú
<listcomp>o  s    z+TestLreshape.test_pairs.<locals>.<listcomp>r9   r]   c             S   s   g | ]}d j |d�‘qS )zwt{i:d})rx   )re   )ry   rx   r   r   r    rz   p  s    )ÚvisitdtÚwtg     |œ@g     4˜@g     Ä©@g     Ò°@)rt   ru   rv   rw   r{   r|   )r   F)ÚdropnarC   )r}   Úlabelc             S   s   g | ]}d j |d�‘qS )zvisitdt{i:d})rx   )re   )ry   rx   r   r   r    rz   0  s    rT   c             S   s   g | ]}d j |d�‘qS )zwt{i:d})rx   )re   )ry   rx   r   r   r    rz   1  s    z$All column lists must be same length)r;   )r   Únanr   rU   r   r   r   r+   Zassert_produces_warningÚFutureWarningr<   r=   r>   )r   r[   r   Úspecr&   Úexp_dataÚexpr?   r   r   r    Ú
test_pairsR  sr   


zTestLreshape.test_pairsN)rj   rk   rl   r„   r   r   r   r    rn   Q  s   rn   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#S )$ÚTestWideToLongc          
   C   sö   t jjdƒ t jjdƒ}tjddddœddd	dœd
dddœddddœtttdƒ|ƒƒdœƒ}|j	|d< |j
ƒ |j
ƒ  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dœ}t|ƒ}|jddgƒdddg }t|ddgddd�}tj||ƒ d S )Né{   rT   r6   r7   rM   )r   r9   r.   rN   ÚeÚfg      @g333333ó?gffffffæ?gš™™™™™	@gÍÌÌÌÌÌô?gš™™™™™¹?)ZA1970ZA1980ZB1970ZB1980rY   rv   i²  i¼  r   r9   r.   )rY   r   r
   Úyearrv   r‰   rY   r   r
   )rx   Új)r   rb   Úseedrc   r   r   ÚdictÚziprU   Úindexr$   Ú	set_indexr   r   r+   )r   Úxr   r‚   r3   r&   r   r   r    Útest_simple9  s$    




zTestWideToLong.test_simplec             C   s`   t jdddddgdddd	d
ggƒ}dddddg|_ddg}t j||ddd�}|ddgks\t‚d S )Nr   r9   r.   rT   é   r]   rK   é   é   é	   rv   Zinc1Zinc2Zedu1Zedu2ÚincÚeduÚage)rx   rŠ   )r   r   r   r   r%   )r   r   ZstubsZdf_longr   r   r    Ú
test_stubsR  s
    "zTestWideToLong.test_stubsc          
   C   sø   t jjdƒ t jjdƒ}tjddddœddd	dœd
dddœddddœtttdƒ|ƒƒdœƒ}|j	|d< |j
ƒ |j
ƒ  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dœ}t|ƒ}|jddgƒdddg }t|ddgdddd�}tj||ƒ d S )Nr†   rT   r6   r7   rM   )r   r9   r.   rN   r‡   rˆ   g      @g333333ó?gffffffæ?gš™™™™™	@gÍÌÌÌÌÌô?gš™™™™™¹?)zA.1970zA.1980zB.1970zB.1980rY   rv   i²  i¼  r   r9   r.   )rY   r   r
   r‰   rv   r‰   rY   r   r
   Ú.)rx   rŠ   Úsep)r   rb   r‹   rc   r   r   rŒ   r�   rU   rŽ   r$   r�   r   r   r+   )r   r�   r   r‚   r3   r&   r   r   r    Útest_separating_character]  s$    




z(TestWideToLong.test_separating_characterc          
   C   sö   t jjdƒ t jjdƒ}tjddddœddd	dœd
dddœddddœtttdƒ|ƒƒdœƒ}|j	|d< |j
ƒ |j
ƒ  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dœ}t|ƒ}|jddgƒdddg }t|ddgddd�}tj||ƒ d S )Nr†   rT   r6   r7   rM   )r   r9   r.   rN   r‡   rˆ   g      @g333333ó?gffffffæ?gš™™™™™	@gÍÌÌÌÌÌô?gš™™™™™¹?)zA(quarterly)1970zA(quarterly)1980zB(quarterly)1970zB(quarterly)1980rY   rv   i²  i¼  r   r9   r.   )rY   zA(quarterly)zB(quarterly)r‰   rv   r‰   rY   zA(quarterly)zB(quarterly))rx   rŠ   )r   rb   r‹   rc   r   r   rŒ   r�   rU   rŽ   r$   r�   r   r   r+   )r   r�   r   r‚   r3   r&   r   r   r    Útest_escapable_charactersw  s&    




z(TestWideToLong.test_escapable_charactersc             C   s°   t jddgddgddgddgd	œƒ}|j|d
< ddddgddddgdtjdtjgddddgddddgdœ}t j|ƒ}|jd
dgƒdddg }t|ddgd
dd�}tj||ƒ d S )Ng      ð?g       @g      @g      @g      @g      @ÚX1ÚX2)ÚA2010ÚA2011ÚB2010rY   rv   r   r9   iÚ  iÛ  )rY   r   r
   rv   r‰   r‰   rY   r   r
   )rx   rŠ   )	r   r   rŽ   r   r   r�   r   r   r+   )r   r   r‚   r3   r&   r   r   r    Útest_unbalanced’  s    




zTestWideToLong.test_unbalancedc             C   s  t jdddgdddgdddgd	d
dgdddgdddgdddgdddgdœƒ}|j|d< t jddddddgddddddgddddddg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dœƒ}|jddgƒddddd g }t|ddd gddd!�}tj|jdd"�|jdd"�ƒ d S )#NÚa11Úa22Úa33Úa21Úa23Úb11Úb12Úb13Úb21Úb22Úb23r9   r.   rT   r]   rK   r“   é[   é\   é]   )ÚA11ÚA12ÚB11ÚB12ÚBB11ÚBB12ÚBBBXÚBBBZrv   r   é   é   )r¸   r¹   r   r
   ÚBBrv   r‰   r‰   r¸   r¹   r   r
   r¼   )rx   rŠ   )Úaxis)r   r   rŽ   r�   r   r   r+   Ú
sort_index)r   r   r3   r&   r   r   r    Útest_character_overlap©  s*    
z%TestWideToLong.test_character_overlapc          	   C   sÆ   d}t jddgddgddgdd	gd
œƒ}|j|d< dg g g g g g g dœ}t j|ƒjddiƒ}|jddgƒddddddg }|jjddgddd� t|ddgdd|d�}tj|j	dd�|j	dd�ƒ d S )Nznope!g      ð?g       @g      @g      @g      @g      @rž   rŸ   )r    r¡   r¢   rY   rv   Ú )rY   r    r¡   r¢   rv   r‰   r   r
   r‰   ÚintrY   r    r¡   r¢   r   r
   r   r9   T)ÚlevelÚinplace)rx   rŠ   r›   )r½   )
r   r   rŽ   r   r�   Ú
set_levelsr   r   r+   r¾   )r   r›   r   r‚   r3   r&   r   r   r    Útest_invalid_separatorÇ  s*    
z%TestWideToLong.test_invalid_separatorc             C   s  t jdddgdddgdddgd	d
dgdddgdddgdddgdddgdœƒ}|j|d< t jddddddgddddddgddddddg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dœƒ}|jddgƒddddd g }t|ddd gddd!�}tj|jdd"�|jdd"�ƒ d S )#Nr¤   r¥   r¦   r§   r¨   r©   rª   r«   r¬   r­   r®   r9   r.   rT   r]   rK   r“   r¯   r°   r±   )r²   r³   r´   rµ   r¶   r·   ÚAratingÚArating_oldrv   r   rº   r»   )rÆ   rÇ   r   r
   r¼   rv   r‰   r‰   rÆ   rÇ   r   r
   r¼   )rx   rŠ   )r½   )r   r   rŽ   r�   r   r   r+   r¾   )r   r   r3   r&   r   r   r    Útest_num_string_disambiguationå  s,    
z-TestWideToLong.test_num_string_disambiguationc          	   C   s°   t jddgddgddgddgd	œƒ}|j|d
< dg g g g g g g dœ}t j|ƒjddiƒ}|jd
dgƒ}|jjddgddd� t|ddgd
dd�}tj|j	dd�|j	dd�ƒ d S )Ng      ð?g       @g      @g      @g      @g      @rž   rŸ   )ÚAoneÚAtwoÚBonerY   rv   rÀ   )rY   rÉ   rÊ   rË   rv   r‰   r   r
   r‰   rÁ   r   r9   T)rÂ   rÃ   r   r
   )rx   rŠ   )r½   )
r   r   rŽ   r   r�   rÄ   r   r   r+   r¾   )r   r   r‚   r3   r&   r   r   r    Útest_invalid_suffixtype  s&    
z&TestWideToLong.test_invalid_suffixtypec             C   s:  t jdddddddddg	dddddddddg	dddddddd	d
g	dddddddddg	dœƒ}t jdddddd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ddddddgdddddd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ddddddgdœƒ}|jdddgƒdg }t|dddgdd�}tj||ƒ d S )Nr9   r.   rT   gffffff@g333333@gš™™™™™@gÍÌÌÌÌÌü?gffffffþ?gffffff@gÍÌÌÌÌÌ @g333333@gffffff@gš™™™™™	@g333333@gffffff
@)ÚfamidÚbirthZht1Zht2g       @)ÚhtrÍ   rÎ   r˜   rÍ   rÎ   r˜   rÏ   )rx   rŠ   )r   r   r�   r   r   r+   )r   r   r3   r&   r   r   r    Útest_multiple_id_columns#  s<    &&.z'TestWideToLong.test_multiple_id_columnsc             C   sf   t jdddddgdddddgdddddgdœƒ}d}tjt|d�� t|d	d
gddd� W d Q R X d S )Nr9   r.   rT   r]   rK   )ZA_A1ZB_B1r�   z3the id variables need to uniquely identify each row)r;   ZA_AZB_Br�   Úcolname)rx   rŠ   )r   r   r<   r=   r>   r   )r   r   r?   r   r   r    Útest_non_unique_idvarsL  s
    ,z%TestWideToLong.test_non_unique_idvarsc          
   C   s¨   t jdddgdddgddd	gd
ddgdddgdœƒ}t j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dœƒjddgƒ}t|ddgdddd�}tj||ƒ d S )NzCCH PounderzJohnny DeppzChristoph WaltzzJoel David MoorezOrlando BloomzRory Kinnearg     @�@g     ˆã@g     |Å@g     @�@g     ˆ³@g     �x@ZAvatarzPirates of the CaribbeanZSpectre)Zactor_1Zactor_2Zactor_fb_likes_1Zactor_fb_likes_2Útitler9   r.   )ÚactorÚactor_fb_likesÚnumrÓ   rÓ   rÖ   rÔ   rÕ   Ú_)rx   rŠ   r›   )r   r   r�   r   r   r+   )r   r   r3   r&   r   r   r    Útest_cast_j_intV  s2    
zTestWideToLong.test_cast_j_intc             C   sZ   t jddgddgddgddgd	œƒ}d
}tjt|d�� t|ddgddd� W d Q R X d S )Ng      ð?g       @g      @g      @g      @g      @rž   rŸ   )r    r¡   r¢   r   z,stubname can't be identical to a column name)r;   r   r
   rÑ   )rx   rŠ   )r   r   r<   r=   r>   r   )r   r   r?   r   r   r    Útest_identical_stubnames}  s    z'TestWideToLong.test_identical_stubnamesc             C   s’   t jddgddgddgddgd	œƒ}t jddddgd
dd
dgdtjdtjgddddgdœƒ}|jddgƒ}t|ddgddddd�}tj||ƒ d S )Ng      ð?g       @g      @g      @g      @g      @rž   rŸ   )Ztreatment_placeboZtreatment_testZresult_placebor   ZplaceboÚtest)r   rÑ   r&   Ú	treatmentr   rÑ   r&   rÛ   z[a-z]+r×   )rx   rŠ   Úsuffixr›   )r   r   r   r   r�   r   r   r+   )r   r   r3   r&   r   r   r    Útest_nonnumeric_suffixŠ  s    

z%TestWideToLong.test_nonnumeric_suffixc             C   s�   t jddgddgddgddgd	d
gdœƒ}t jddddgddddgddddgddd	d
gdœƒjddgƒ}t|ddgddddd�}tj||ƒ d S )Nrž   rŸ   r   r•   g      @g      @g      ð?g       @g      @g      @)r   Úresult_1Z
result_fooZtreatment_1Ztreatment_fooÚ1rC   g        g      "@)r   rÑ   r&   rÛ   r   rÑ   r&   rÛ   z.+r×   )rx   rŠ   rÜ   r›   )r   r   r�   r   r   r+   )r   r   r3   r&   r   r   r    Útest_mixed_type_suffix¡  s    



z%TestWideToLong.test_mixed_type_suffixc             C   sÄ   t jddgddgddgddgd	d
gdœƒ}t jd	d	d	d	d
d
d
d
gddddddddgdtjdtjdtjdtjgtjdtjdtjdtjdgdœƒ}|jddgƒ}t|ddgddddd�}tj||ƒ d S )Ng      ð?g       @g      @g      @g      @g      @r   r•   rž   rŸ   )ztreatment_1.1ztreatment_2.1z
result_1.2rÞ   r   r9   gš™™™™™ñ?g333333ó?gÍÌÌÌÌÌ @g        g      "@)r   rÑ   r&   rÛ   r   rÑ   r&   rÛ   z[0-9.]+r×   )rx   rŠ   rÜ   r›   )r   r   r   r   r�   r   r   r+   )r   r   r3   r&   r   r   r    Útest_float_suffix¸  s    "z TestWideToLong.test_float_suffixc          
   C   s–   ddddddœddd	d
ddœddddddœddddddœddddddœdœ}t jj|ƒ}t j|dgddgdd�}t j|dddgdd�}tj||ƒ d S )Nr   r9   r.   rT   r]   )r   r9   r.   rT   r]   gš™™™™™é?g        g      Ð?g      ð?gìQ¸…ëé?g®Gáz®ç?gìQ¸…ëá?g\�Âõ(\ï?g333333ã?g¤p=
×£è?g{®Gázä?g¤p=
×£à?gq=
×£på?gÃõ(\�ÂÕ?gffffffæ?)Únode_idr   ZPA0ZPA1ZPA3ZPArâ   r   Útime)Z	stubnamesrx   rŠ   )r   r   Z	from_dictr   r   r+   )r   Z	wide_dataZwide_dfr3   r&   r   r   r    Útest_col_substring_of_stubnameÐ  s    z-TestWideToLong.test_col_substring_of_stubnameN)rj   rk   rl   r‘   r™   rœ   r�   r£   r¿   rÅ   rÈ   rÌ   rÐ   rÒ   rØ   rÙ   rÝ   rà   rá   rä   r   r   r   r    r…   8  s"   !)
'r…   )Znumpyr   r<   Zpandasr   r   r   r   r   Zpandas._testingZ_testingr   r   rn   r…   r   r   r   r    Ú<module>   s   
  J h