3
®yb*‘  ã               @   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               @   sx  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	e
jjddgdgdeddGdHdœddddœdIdddœdœƒfdgdgdeddJdKdœddddœdLdddœdœƒfgƒ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/d0d1�ƒejddd2dd3gd4d5�ejdddddgƒgƒd6d7„ ƒZd8d9„ Zd:d;„ Zd<d=„ Zd>d?„ Zd@dA„ ZdBdC„ ZdDdE„ ZdFS )MÚ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   úB/tmp/pip-install-4cy230dp/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_multiindexz(id_vars, value_vars, col_level, expectedr   r
   r   g5ì÷Ä:ñ?g†U¼‘y$õ?giÿ¬Õé?)r   é   r.   gS°ÆÙtÄñ?gê> ©Mœ×?g<Ú8b->µ?)r   r   r#   r6   r7   r9   )r6   r   r#   c             C   s"   | j j|||d�}tj||ƒ d S )N)r*   )r   r   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_multiindexŠ   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ÚtzÚcÚdÚcategory)Údtypec             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)Úignore_indexrQ   rJ   Ú	attributer#   )r(   r   r   r.   rR   rS   )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*   )rb   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_raises3  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_varsX  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   ri   )r   r6   r   r6   )r)   )r"   r#   )r   r   r   r+   )r   r   r&   r3   r   r   r    Ú"test_melt_mixed_int_str_value_varsa  s    z+TestMelt.test_melt_mixed_int_str_value_varsc             C   sR   t dgdgdœdgd�}t|dd�}t dd	gddgd
œddgd�}tj||ƒ d S )Nr   r9   )rC   ri   Úfirst)ÚindexF)rT   rC   ri   )r"   r#   )r   r   r   r+   )r   r   r&   r3   r   r   r    Útest_ignore_indexh  s
    zTestMelt.test_ignore_indexc             C   s”   t jjddgddgd�}tddgd	d
gdœ|d�}t|dd�}t jjddgd	 ddgd�}tdgd	 dgd	  ddd	d
gdœ|d�}tj||ƒ d S )Nrl   ÚsecondÚthirdÚbazZfoobar)r   r   r9   r.   rV   )rC   ri   )rm   F)rT   rC   ri   )r"   r#   )rl   ro   )rl   rp   )rl   ro   )rl   rp   )r   Z
MultiIndexÚfrom_tuplesr   r   r   r+   )r   rm   r   r&   Úexpected_indexr3   r   r   r    Útest_ignore_multiindexq  s     zTestMelt.test_ignore_multiindexc             C   s„   t jddgddd�}tddgdd	gd
œ|d�}t|dd�}t jddgd ddd�}tddddgdddd	gdœ|d�}tj||ƒ d S )NrC   ri   rO   rq   )rP   rE   r   r9   r.   rV   )ÚxÚy)rm   F)rT   ru   rv   )r"   r#   )r   ÚIndexr   r   r   r+   )r   rm   r   r&   rs   r3   r   r   r    Útest_ignore_index_name_and_typeƒ  s    z(TestMelt.test_ignore_index_name_and_typeNg†U¼‘y$õ¿giÿ¬Õé¿gS°ÆÙtÄñ¿g†U¼‘y$õ¿giÿ¬Õé¿gS°ÆÙtÄñ¿) Ú__name__Ú
__module__Ú__qualname__r!   r'   r,   r-   r0   r5   r8   r<   ÚmarkZparametrizer   r:   r@   rA   rB   rF   rG   rI   r   rY   Z
date_rangerZ   r^   rh   rj   rk   rn   rt   rx   r   r   r   r    r   	   sR   




 - 
%		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 |d›�‘qS )ÚvisitdtrN   r   )Ú.0Úir   r   r    ú
<listcomp>°  s    z+TestLreshape.test_pairs.<locals>.<listcomp>r9   r_   c             S   s   g | ]}d |d›�‘qS )ÚwtrN   r   )rˆ   r‰   r   r   r    rŠ   ±  s    )r‡   r‹   g     |œ@g     4˜@g     Ä©@g     Ò°@)rƒ   r„   r…   r†   r‡   r‹   )r   F)ÚdropnarC   )rŒ   Úlabelc             S   s   g | ]}d |d›�‘qS )r‡   rN   r   )rˆ   r‰   r   r   r    rŠ   q  s    rV   c             S   s   g | ]}d |d›�‘qS )r‹   rN   r   )rˆ   r‰   r   r   r    rŠ   r  s    z$All column lists must be same length)r;   )r   Únanr   rW   r   r   r   r+   Úassert_produces_warningÚFutureWarningr<   r=   r>   )r   r]   r   Úspecr&   Úexp_dataÚexpr?   r   r   r    Ú
test_pairs“  sr   


zTestLreshape.test_pairsN)ry   rz   r{   r”   r   r   r   r    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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é{   rV   r6   r7   rM   )r   r9   r.   rN   ÚeÚfg      @g333333ó?gffffffæ?gš™™™™™	@gÍÌÌÌÌÌô?gš™™™™™¹?)ZA1970ZA1980ZB1970ZB1980r[   r…   i²  i¼  r   r9   r.   )r[   r   r
   Úyearr…   r™   r[   r   r
   )r‰   Új)r   rd   Úseedre   r   r   ÚdictÚziprW   rm   r$   Ú	set_indexr   r   r+   )r   ru   r   r’   r3   r&   r   r   r    Útest_simplez  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.   rV   é   r_   rK   é   é   é	   r…   Zinc1Zinc2Zedu1Zedu2ÚincÚeduÚage)r‰   rš   )r   r   r   r   r%   )r   r   ZstubsZdf_longr   r   r    Ú
test_stubs“  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–   rV   r6   r7   rM   )r   r9   r.   rN   r—   r˜   g      @g333333ó?gffffffæ?gš™™™™™	@gÍÌÌÌÌÌô?gš™™™™™¹?)zA.1970zA.1980zB.1970zB.1980r[   r…   i²  i¼  r   r9   r.   )r[   r   r
   r™   r…   r™   r[   r   r
   Ú.)r‰   rš   Úsep)r   rd   r›   re   r   r   rœ   r�   rW   rm   r$   rž   r   r   r+   )r   ru   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–   rV   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)1980r[   r…   i²  i¼  r   r9   r.   )r[   zA(quarterly)zB(quarterly)r™   r…   r™   r[   zA(quarterly)zB(quarterly))r‰   rš   )r   rd   r›   re   r   r   rœ   r�   rW   rm   r$   rž   r   r   r+   )r   ru   r   r’   r3   r&   r   r   r    Útest_escapable_characters¸  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ÚB2010r[   r…   r   r9   iÚ  iÛ  )r[   r   r
   r…   r™   r™   r[   r   r
   )r‰   rš   )	r   r   rm   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.   rV   r_   rK   r¡   é[   é\   é]   )ÚA11ÚA12ÚB11ÚB12ÚBB11ÚBB12ÚBBBXÚBBBZr…   r   é   é   )rÆ   rÇ   r   r
   ÚBBr…   r™   r™   rÆ   rÇ   r   r
   rÊ   )r‰   rš   )Úaxis)r   r   rm   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°   r[   r…   Ú )r[   r®   r¯   r°   r…   r™   r   r
   r™   Úintr[   r®   r¯   r°   r   r
   r   r9   T)ÚlevelÚinplace)r‰   rš   r©   )rË   )
r   r   rm   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.   rV   r_   rK   r¡   r½   r¾   r¿   )rÀ   rÁ   rÂ   rÃ   rÄ   rÅ   ÚAratingÚArating_oldr…   r   rÈ   rÉ   )rÔ   rÕ   r   r
   rÊ   r…   r™   r™   rÔ   rÕ   r   r
   rÊ   )r‰   rš   )rË   )r   r   rm   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ÚBoner[   r…   rÎ   )r[   r×   rØ   rÙ   r…   r™   r   r
   r™   rÏ   r   r9   T)rÐ   rÑ   r   r
   )r‰   rš   )rË   )
r   r   rm   r   rž   rÒ   r   r   r+   rÌ   )r   r   r’   r3   r&   r   r   r    Útest_invalid_suffixtypeG  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.   rV   gffffff@g333333@gš™™™™™@gÍÌÌÌÌÌü?gffffffþ?gffffff@gÍÌÌÌÌÌ @g333333@gffffff@gš™™™™™	@g333333@gffffff
@)ÚfamidÚbirthZht1Zht2g       @)ÚhtrÛ   rÜ   r¦   rÛ   rÜ   r¦   rÝ   )r‰   rš   )r   r   rž   r   r   r+   )r   r   r3   r&   r   r   r    Útest_multiple_id_columnsd  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.   rV   r_   rK   )ZA_A1ZB_B1ru   z3the id variables need to uniquely identify each row)r;   ZA_AZB_Bru   Úcolname)r‰   rš   )r   r   r<   r=   r>   r   )r   r   r?   r   r   r    Útest_non_unique_idvars�  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ã   Ú_)r‰   rš   r©   )r   r   rž   r   r   r+   )r   r   r3   r&   r   r   r    Útest_cast_j_int—  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ß   )r‰   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å   )r‰   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å   )r‰   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å   )r‰   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.   rV   r_   )r   r9   r.   rV   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	stubnamesr‰   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_stubnamec          
   C   sz   t jtdƒtdddƒdœƒ}t jdddgdddgd	dd	ggd
dd
gd�}tjtƒ� |jd
d�}tj||ƒ W d Q R X d S )Nr   r   é   r.   )rJ   r#   r   rJ   r
   r`   r#   r"   )r   )r(   )	r   r   r   rW   r   r�   r�   r   r+   )r   r   r3   r&   r   r   r    Útest_warn_of_column_name_value#  s    z-TestWideToLong.test_warn_of_column_name_valueN)ry   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•   y  s$   !)
'r•   )Znumpyr   r<   Zpandasr   r   r   r   r   Zpandas._testingZ_testingr   r   r}   r•   r   r   r   r    Ú<module>   s   
    h