a
    ï½„gã¤  ã                   @   sº   d dl Z d dlZd dlZd dlZd dlmZmZmZm	Z	m
Z
mZ d dlmZ ejdd„ ƒZejdd„ ƒZejdd„ ƒZejd	d
„ ƒZG dd„ dƒZG dd„ dƒZG dd„ dƒZdd„ ZdS )é    N)Ú	DataFrameÚIndexÚ
date_rangeÚlreshapeÚmeltÚwide_to_longc                  C   sf   t tj d¡ d¡ttdƒtd�tdddd�d	�} | d
 dk 	tj
¡| d< | d dk 	tj
¡| d< | S )Né   )é
   é   ÚABCD©Údtypez
2000-01-01r	   ÚB)ÚperiodsÚfreq©ÚcolumnsÚindexÚAr   Úid1Úid2)r   ÚnpÚrandomÚdefault_rngÚstandard_normalr   ÚlistÚobjectr   ÚastypeÚint64©Úres© r!   úa/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/pandas/tests/reshape/test_melt.pyÚdf   s    ýr#   c                  C   s<   t g d¢g d¢g d¢gƒ} tdƒtdƒg| _ddg| j_| S )N)ç5ì÷Ä:ñ?çS°ÆÙtÄñ¿gKÔÔ²µÊ?)ç†U¼‘y$õ¿çê> ©Mœ×?g†K®âð¿)çiÿ¬Õé¿ç<Ú8b->µ?ghB“Ä’òë¿ÚABCÚabcÚCAPÚlow)r   r   r   Únamesr   r!   r!   r"   Údf1   s    ýÿr/   c                   C   s   dS )NÚvarr!   r!   r!   r!   r"   Úvar_name,   s    r1   c                   C   s   dS )NÚvalr!   r!   r!   r!   r"   Ú
value_name1   s    r3   c                   @   sø  e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zej 	d	e
eejf¡d
d„ ƒZdd„ Zej 	ddgdgdeddddœddddœddddœdœƒfdgdgdeddddœddddœddddœdœƒfg¡dd„ ƒZej 	d d!d"ggd!gd"gd!d"gg¡d#d$„ ƒZd%d&„ Zd'd(„ Zd)d*„ Zej 	d+dd,g¡d-d.„ ƒZd/d0„ Zej 	d1e ed2d3d4d5�¡ejg d6¢d7d8�e g d9¢¡g¡d:d;„ ƒZd<d=„ Zd>d?„ Zd@dA„ ZdBdC„ ZdDdE„ Z dFdG„ Z!dHdI„ Z"dJdK„ Z#ej 	dLdMdNg¡dOdP„ ƒZ$dQdR„ Z%dSdT„ Z&dUdV„ Z'dWdX„ Z(dYdZ„ Z)d[S )\ÚTestMeltc                 C   s"   t |ƒ}|j ¡ ddgksJ ‚d S )NÚvariableÚvalue©r   r   Útolist)Úselfr#   Úresultr!   r!   r"   Útest_top_level_method7   s    zTestMelt.test_top_level_methodc                 C   s„   t  | ¡ t|ƒ¡ t  |jddgddgd�t|ddgddgd�¡ t  |j||d�t|||d�¡ t  |jdd�t|dd�¡ d S )	Nr   r   r   r   ©Úid_varsÚ
value_vars©r1   r3   r   ©Ú	col_level)ÚtmÚassert_frame_equalr   )r9   r#   r/   r1   r3   r!   r!   r"   Útest_method_signatures;   s    þþzTestMelt.test_method_signaturesc                 C   sl   |  ¡ }|j ¡ ddgksJ ‚|j dgd�}|j ¡ g d¢ksBJ ‚|j ddgd�}|j ¡ g d¢kshJ ‚d S )Nr5   r6   r   )r=   )r   r5   r6   r   ©r   r   r5   r6   r7   )r9   r#   r:   Zresult1Zresult2r!   r!   r"   Útest_default_col_namesJ   s    zTestMelt.test_default_col_namesc                 C   sž   |j ddgdd�}t|ƒdks"J ‚|j ddgddgd�}t|d  ¡ d |d  ¡ d dgd dgd  |d  ¡ |d  ¡  dœg d¢d	�}t ||¡ d S )
Nr   r   r   r<   r	   r   r   rE   ©r   )r   Úlenr   r8   rB   rC   )r9   r#   Zresult3Zresult4Z	expected4r!   r!   r"   Útest_value_varsT   s    üù	zTestMelt.test_value_varsÚtype_c                 C   s|   t |d  ¡ d |d  ¡ d dgd dgd  |d  ¡ |d  ¡  dœg d¢d�}|jddg|d	ƒd
�}t ||¡ d S )Nr   r   r   r   r	   r   rE   rG   ©r   r   r<   )r   r8   r   rB   rC   )r9   rJ   r#   Úexpectedr:   r!   r!   r"   Útest_value_vars_typesd   s    üù	zTestMelt.test_value_vars_typesc                 C   sX   t |d dgt|ƒ dgt|ƒ |d dœg d¢d�}|jdgdgd�}t ||¡ d S )N©r   Úar   Úb©r   rP   )rN   r,   r-   r6   rG   r<   )r   rH   r   rB   rC   )r9   r/   rL   r:   r!   r!   r"   Útest_vars_work_with_multiindexs   s    üù
z'TestMelt.test_vars_work_with_multiindexz(id_vars, value_vars, col_level, expectedr   r   r   r$   r&   r(   ©r   é   r   r%   r'   r)   )r   r,   r6   rO   rP   rT   )rO   r-   r6   c                 C   s    |j |||d�}t ||¡ d S )Nr@   )r   rB   rC   )r9   r=   r>   rA   rL   r/   r:   r!   r!   r"   Ú%test_single_vars_work_with_multiindex�   s     z.TestMelt.test_single_vars_work_with_multiindexzid_vars, value_varsrN   rQ   c                 C   sD   d}t jt|d�� |j||d� W d   ƒ n1 s60    Y  d S )NzF(id|value)_vars must be a list of tuples when columns are a MultiIndex©Úmatchr<   )ÚpytestÚraisesÚ
ValueErrorr   )r9   r=   r>   r/   Úmsgr!   r!   r"   Ú$test_tuple_vars_fail_with_multiindex¤   s    z-TestMelt.test_tuple_vars_fail_with_multiindexc           	      C   s"  |j |d�}|j ¡ ddgks"J ‚|j dg|d�}|j ¡ g d¢ksHJ ‚|j ddg|d�}|j ¡ g d¢kspJ ‚|j ddgd	|d
�}|j ¡ g d¢ksšJ ‚|j ddgd	dg|d
�}td|d  ¡ d d|d  ¡ d |d	gd dgd  d|d	  ¡ |d  ¡  idd|dgd�}t ||¡ d S )N)r1   r0   r6   r   ©r=   r1   )r   r0   r6   r   )r   r   r0   r6   r   )r=   r>   r1   r   r   r	   rG   ©r   r   r8   r   rB   rC   )	r9   r#   r1   Zresult5Zresult6Zresult7Zresult8Zresult9Z	expected9r!   r!   r"   Útest_custom_var_name´   s(    ÿü
ù	zTestMelt.test_custom_var_namec           	      C   s"  |j |d�}|j ¡ ddgks"J ‚|j dg|d�}|j ¡ g d¢ksHJ ‚|j ddg|d�}|j ¡ g d¢kspJ ‚|j ddgd	|d
�}|j ¡ g d¢ksšJ ‚|j ddgd	dg|d
�}td|d  ¡ d d|d  ¡ d dd	gd dgd  ||d	  ¡ |d  ¡  iddd|gd�}t ||¡ d S )N)r3   r5   r2   r   ©r=   r3   )r   r5   r2   r   )r   r   r5   r2   r   )r=   r>   r3   r   r   r	   rG   r^   )	r9   r#   r3   Zresult10Zresult11Zresult12Zresult13Zresult14Z
expected14r!   r!   r"   Útest_custom_value_nameÏ   s,    
ÿÿü
ù	zTestMelt.test_custom_value_namec                 C   s\  |j ||d�}|j ¡ ddgks$J ‚|j dg||d�}|j ¡ g d¢ksLJ ‚|j ddg||d�}|j ¡ g d¢ksvJ ‚|j ddgd	||d
�}|j ¡ g d¢ks¢J ‚|j ddgd	dg||d
�}td|d  ¡ d d|d  ¡ d |d	gd dgd  ||d	  ¡ |d  ¡  idd||gd�}	t ||	¡ | ¡ }
d|
j_|
  ¡ }|j ¡ ddgk�sXJ ‚d S )Nr?   r0   r2   r   ©r=   r1   r3   )r   r0   r2   r   )r   r   r0   r2   r   ©r=   r>   r1   r3   r   r   r	   rG   Úfoor6   )r   r   r8   r   rB   rC   ÚcopyÚname)r9   r#   r3   r1   Zresult15Zresult16Zresult17Zresult18Zresult19Z
expected19Zdf20Zresult20r!   r!   r"   Útest_custom_var_and_value_nameì   sD    
ÿüüü
ù	z'TestMelt.test_custom_var_and_value_namerA   r,   c                 C   s&   |j |d�}|j ¡ ddgks"J ‚d S )Nr@   r,   r6   r7   )r9   rA   r/   r    r!   r!   r"   Útest_col_level  s    zTestMelt.test_col_levelc                 C   s"   |  ¡ }|j ¡ g d¢ksJ ‚d S )N)r,   r-   r6   r7   )r9   r/   r    r!   r!   r"   Útest_multiindex  s    zTestMelt.test_multiindexÚcolZ2010é   z
US/Pacific)r   Útz)rO   rP   ÚcrO   ÚdÚcategoryr   )r   rT   r   r   r   c                 C   s¢   t tdƒ|g d¢|dœƒ}tjt g d¢¡|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œƒ}g d¢|_t 	||¡ d S )Nrk   )rT   r   r   r   r   )Úklassrj   Úattr1Úattr2T©Zignore_indexrp   rj   Ú	attributer6   rb   r   rq   rr   ©r   rT   r   é   )rp   rj   rt   r6   )
r   ÚrangeÚpdÚconcatÚSeriesr   r   r   rB   rC   )r9   rj   r#   Zexpected_valuer:   rL   r!   r!   r"   Útest_pandas_dtypes  s     
ÿÿüÿ
zTestMelt.test_pandas_dtypesc                 C   s^   t ddgt ddg¡dœƒ}t|dgdgƒ}t t ddg¡ddgddgdœƒ}t ||¡ d S )	NrT   r   ÚXÚYrK   r   r   )r   r5   r6   )r   rx   ZCategoricalr   rB   rC   )r9   Údatar:   rL   r!   r!   r"   Útest_preserve_category;  s    ÿzTestMelt.test_preserve_categoryc                 C   sŠ  t tj d¡ d¡tdƒd�}d}tjt|d��$ | 	ddgd	d
g¡ W d   ƒ n1 sZ0    Y  tjt|d��$ | 	ddgdd
g¡ W d   ƒ n1 sœ0    Y  tjt|d��$ | 	g d¢dd
g¡ W d   ƒ n1 sÞ0    Y  | 
¡ }tdƒtdƒg|_tjt|d��  | 	dgdg¡ W d   ƒ n1 �s80    Y  tjt|d��$ |j	dgdgdd� W d   ƒ n1 �s|0    Y  d S )Nr   )rk   r
   ÚabcdrG   zEThe following id_vars or value_vars are not present in the DataFrame:rV   rO   rP   ÚCrn   r   rm   )rO   rP   Znot_hereZor_therer   )ÚErO   rQ   ÚFr   r@   )r   r   r   r   r   r   rX   rY   ÚKeyErrorr   re   r   )r9   r#   r[   Úmultir!   r!   r"   Ú test_melt_missing_columns_raisesE  s&    ÿ22þ20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 ||¡ d S )Nrd   ÚbarrT   r   )r   rO   rP   rn   r   rO   rP   rn   r<   Zbd)r   rO   r5   r6   )r   r   r   rB   rC   ©r9   r#   r:   rL   r!   r!   r"   Útest_melt_mixed_int_str_id_varsh  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 ||¡ d S )Nrd   r‡   )r   rO   r   rO   )r>   ©r5   r6   ©r   r   rB   rC   rˆ   r!   r!   r"   Ú"test_melt_mixed_int_str_value_varsq  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 ||¡ d S )Nr   rT   ©rd   r‡   Úfirst©r   Frs   rd   r‡   rŠ   r‹   rˆ   r!   r!   r"   Útest_ignore_indexx  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  g d¢dœ|d�}t ||¡ d S )N)rŽ   Úsecond)rŽ   ÚthirdÚbazZfoobar©r.   r   rT   r   rv   r�   r�   Frs   rd   r‡   ru   rŠ   )rx   Ú
MultiIndexÚfrom_tuplesr   r   rB   rC   ©r9   r   r#   r:   Zexpected_indexrL   r!   r!   r"   Útest_ignore_multiindex�  s    ÿÿþzTestMelt.test_ignore_multiindexc                 C   sx   t ddgddd�}tddgdd	gd
œ|d�}t|dd�}t ddgd ddd�}tg d¢g d¢dœ|d�}t ||¡ d S )Nrd   r‡   ro   r“   )r   rf   r   rT   r   rv   )ÚxÚyr�   Frs   )r™   r™   rš   rš   ru   rŠ   )r   r   r   rB   rC   r—   r!   r!   r"   Útest_ignore_index_name_and_type“  s    þz(TestMelt.test_ignore_index_name_and_typec                 C   sT   t g d¢gg d¢d�}|jdgdgd�}t g d¢g d¢gg d	¢d�}t ||¡ d S )
N)Úidr   rv   )rO   rP   rP   rG   rO   rP   r<   )rœ   rP   r   )rœ   rP   rv   )rO   r5   r6   r‹   rˆ   r!   r!   r"   Ú test_melt_with_duplicate_columns¡  s    ÿz)TestMelt.test_melt_with_duplicate_columnsr   ÚInt8ZInt64c                 C   sb   t tjddgdd�tjddg|d�dœƒ}| ¡ }t g d¢tjg d	¢|d�d
œƒ}t ||¡ d S )NrT   r   rž   r   rv   r
   ©rO   rP   )rO   rO   rP   rP   )rT   r   rv   r
   rŠ   )r   rx   rz   r   rB   rC   )r9   r   r#   r:   rL   r!   r!   r"   Útest_melt_ea_dtypeª  s    þÿþÿzTestMelt.test_melt_ea_dtypec                 C   s€   t ddddœddddœdd	d
dœdœƒ}|j d¡|_|jdgdgd�}t tdƒtjdgd dd�g d¢dœƒ}t ||¡ d S )NrO   rP   rm   rS   rT   rv   rk   r   r
   é   )r   r   r�   zstring[python]r   r   r<   r+   r   )rT   rv   rk   )r   r5   r6   )	r   r   r   r   r   rx   rz   rB   rC   rˆ   r!   r!   r"   Útest_melt_ea_columns¼  s    


ýÿýÿzTestMelt.test_melt_ea_columnsc              
   C   sÊ   t dtjddd�tjddd�dœdtjddd�tjddd�dœgd	d
gd�}|jdgddgddd�}t dddddœdddddœtjddd�tjddd�tjddd�tjddd�dœdœƒ}t ||¡ d S )NZA0z
2023/03/01z
Asia/Tokyo)rl   z
2023/03/10)ÚtypeÚ
start_dateÚend_dateÚA1z
2023/03/11ZaaaaZbbbb©r~   r   r£   r¤   r¥   ú	start/endÚdaterc   ru   z2023-03-01 00:00:00+0900z2023-03-10 00:00:00+0900z2023-03-11 00:00:00+0900)r£   r¨   r©   )r   rx   Ú	Timestampr   rB   rC   rˆ   r!   r!   r"   Útest_melt_preserves_datetimeÐ  sB    ýýúóüüüøÿz%TestMelt.test_melt_preserves_datetimec                 C   s\   t g d¢g d¢dœg d¢d�}|jdddd	�}t g d¢d
gd g d¢dœƒ}t ||¡ d S ©N©rT   r   rv   ©r
   rk   r¡   rŸ   ©Z11Z22Z33r§   rO   r   rT   rb   rP   rv   )rO   r   rT   r‹   rˆ   r!   r!   r"   Ú#test_melt_allows_non_scalar_id_varsù  s    þýz,TestMelt.test_melt_allows_non_scalar_id_varsc                 C   s^   t g d¢g d¢dœg d¢d�}|jdgddd	�}t g d¢d
gd g d¢dœƒ}t ||¡ d S r¬   r‹   rˆ   r!   r!   r"   Ú$test_melt_allows_non_string_var_name  s    þýz-TestMelt.test_melt_allows_non_string_var_namec                 C   sd   t g d¢g d¢dœg d¢d�}tjtdd��$ |jdgd	d
gd� W d   ƒ n1 sV0    Y  d S )Nr­   r®   rŸ   r¯   r§   z.* must be a scalar.rV   rO   rT   r   r]   )r   rX   rY   rZ   r   ©r9   r#   r!   r!   r"   Ú$test_melt_non_scalar_var_name_raises  s    þz-TestMelt.test_melt_non_scalar_var_name_raisesN)*Ú__name__Ú
__module__Ú__qualname__r;   rD   rF   rI   rX   ÚmarkÚparametrizeÚtupler   r   ÚarrayrM   rR   r   rU   r\   r_   ra   rg   rh   ri   rx   rz   r   r{   r   r†   r‰   rŒ   r�   r˜   r›   r�   r    r¢   r«   r°   r±   r³   r!   r!   r!   r"   r4   6   sŠ   




ýÿü


ýÿüóþ
ýþ
*
ýþ

#			
)r4   c                   @   s   e Zd Zdd„ ZdS )ÚTestLreshapec                 C   sä  g d¢g d¢g d¢g d¢g d¢dt jddd	gd
t jt jddgg d¢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||ƒ}g d¢g d¢g d¢g d¢g d ¢g d!¢d"œ}t||jd#�}t ||¡ t||d$d%�}g d&¢g d'¢g d(¢g d)¢d*d+d,d-d.dt jddd	d
t jt jddgd/dd0d1d2dt jddddt jt jddgd"œ}t||jd#�}t ||¡ d3d„ tdd4ƒD ƒd5d„ tddƒD ƒdœ}d6}tj	t
|d7�� t||ƒ W d   ƒ n1 �sÖ0    Y  d S )8N)Ú	08jan2009Ú	20dec2008Ú	30dec2008Ú	21dec2008Ú	11jan2009)éæ  éå  é®  éC  é%  )ée   éf   ég   éh   éi   )ÚMaleÚFemalerÌ   rÌ   rÌ   )rÀ   Ú	22dec2008Ú	04jan2009Ú	29dec2008Ú	20jan2009Ú	21jan2009Ú	22jan2009Ú	31dec2008Ú	03feb2009Ú	05feb2009Ú	02jan2009Ú	15feb2009)i  i
  i  iâ  iÒ  ç     lŸ@ç     ��@ç     ª@ç     ß±@ç     ê¡@ç     bª@ç     Å²@)
ÚbirthdtÚbirthwtrœ   ÚsexZvisitdt1Zvisitdt2Zvisitdt3Zwt1Zwt2Zwt3c                 S   s   g | ]}d |d›�‘qS ©Úvisitdtrn   r!   ©Ú.0Úir!   r!   r"   Ú
<listcomp>:  ó    z+TestLreshape.test_pairs.<locals>.<listcomp>rT   r
   c                 S   s   g | ]}d |d›�‘qS ©Úwtrn   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Á   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Ð   rÑ   rÒ   rÓ   rÔ   rÕ   rÖ   r×   )ç     |œ@rÚ   ç     4˜@ç     Ä©@ç     Ò°@rØ   rÙ   rÚ   rÛ   rÜ   rÝ   rÞ   )rß   rà   rœ   rá   rã   rê   rG   F)Zdropna)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Æ   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Í   rÎ   rÏ   rÐ   rë   rì   rí   rî   c                 S   s   g | ]}d |d›�‘qS râ   r!   rä   r!   r!   r"   rç   ø  rè   rv   c                 S   s   g | ]}d |d›�‘qS ré   r!   rä   r!   r!   r"   rç   ù  rè   z$All column lists must be same lengthrV   )r   Únanr   rw   r   r   rB   rC   rX   rY   rZ   )r9   r~   r#   Úspecr:   Úexp_dataÚexpr[   r!   r!   r"   Ú
test_pairs  sŽ    êþ
ÆIññªhþzTestLreshape.test_pairsN)r´   rµ   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ej d%d&d'g¡d(d)„ ƒZd*S )+ÚTestWideToLongc              	   C   sÌ   t j d¡ d¡}tddddœddd	dœd
dddœddddœtttdƒ|ƒƒdœƒ}|j|d< | 	¡ | 	¡  g d¢g d¢g d¢g d¢dœ}t|ƒ}| 
ddg¡g d¢ }t|ddgddd�}t ||¡ d S )Nr   rv   rO   rP   rm   rS   rn   ÚeÚfç      @ç333333ó?çffffffæ?çš™™™™™	@çÍÌÌÌÌÌô?çš™™™™™¹?)ZA1970ZA1980ZB1970ZB1980r|   rœ   ©rO   rP   rm   rn   rõ   rö   ©r÷   rø   rù   rú   rû   rü   ©é²  r   r   é¼  r  r  ©r   rT   r   r   rT   r   ©r|   r   r   Úyearrœ   r  ©r|   r   r   r   r   ©ræ   Új©r   r   r   r   r   ÚdictÚziprw   r   r8   Ú	set_indexr   rB   rC   ©r9   r™   r#   rñ   rL   r:   r!   r!   r"   Útest_simple  s(    



ûÿ	
ûzTestWideToLong.test_simplec                 C   sJ   t g d¢g d¢gƒ}g d¢|_ddg}t||ddd� |ddgksFJ ‚d S )	N)r   rT   r   rv   é   )r
   rk   r¡   é   é	   )rœ   Zinc1Zinc2Zedu1Zedu2ÚincÚedurœ   Úager  )r   r   r   )r9   r#   Zstubsr!   r!   r"   Ú
test_stubs  s
    
zTestWideToLong.test_stubsc              	   C   sÎ   t j d¡ d¡}tddddœddd	dœd
dddœddddœtttdƒ|ƒƒdœƒ}|j|d< | 	¡ | 	¡  g d¢g d¢g d¢g d¢dœ}t|ƒ}| 
ddg¡g d¢ }t|ddgdddd�}t ||¡ d S )Nr   rv   rO   rP   rm   rS   rn   rõ   rö   r÷   rø   rù   rú   rû   rü   )zA.1970zA.1980zB.1970zB.1980r|   rœ   rý   rþ   rÿ   r  r  r  r  r   r   Ú.©ræ   r  Úsepr  r  r!   r!   r"   Útest_separating_character#  s(    



ûÿ	
ûz(TestWideToLong.test_separating_characterc              	   C   sÌ   t j d¡ d¡}tddddœddd	dœd
dddœddddœtttdƒ|ƒƒdœƒ}|j|d< | 	¡ | 	¡  g d¢g d¢g d¢g d¢dœ}t|ƒ}| 
ddg¡g d¢ }t|ddgddd�}t ||¡ d S )Nr   rv   rO   rP   rm   rS   rn   rõ   rö   r÷   rø   rù   rú   rû   rü   )zA(quarterly)1970zA(quarterly)1980zB(quarterly)1970zB(quarterly)1980r|   rœ   rý   rþ   rÿ   r  )r|   úA(quarterly)úB(quarterly)r  rœ   r  )r|   r  r  r  r  r  r  r  r!   r!   r"   Útest_escapable_characters=  s,    



ûÿ	
ûÿz(TestWideToLong.test_escapable_charactersc                 C   sš   t ddgddgddgddgd	œƒ}|j|d
< g d¢g d¢ddtjtjgg d¢g d¢dœ}t |ƒ}| d
dg¡g d¢ }t|ddgd
dd�}t ||¡ d S )Nç      ð?ç       @ç      @ç      @ç      @ç      @ÚX1ÚX2©ÚA2010ÚA2011ÚB2010r|   rœ   ©r"  r#  r"  r#  ©r  r  r  r  )r   rT   r   rT   )éÚ  r*  éÛ  r+  )r|   r   r   rœ   r  r  r  r   r   r  )r   r   r   rï   r  r   rB   rC   ©r9   r#   rñ   rL   r:   r!   r!   r"   Útest_unbalancedW  s$    üÿ
ûzTestWideToLong.test_unbalancedc              
   C   sÂ   t g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢dœƒ}|j|d	< t g d
¢g d
¢g d¢g d¢g d¢g d¢g d¢dœƒ}| d	dg¡g d¢ }t|g d¢d	dd�}t |jdd�|jdd�¡ d S )N©Úa11Úa22Úa33©Úa21r0  Úa23©Úb11Úb12Úb13©Úb21Úb22Úb23r­   r®   ©é[   é\   é]   )ÚA11ÚA12ÚB11ÚB12ÚBB11ÚBB12ÚBBBXÚBBBZrœ   ©r>  r?  r@  r>  r?  r@  ©r/  r0  r1  r3  r0  r4  ©r6  r7  r8  r:  r;  r<  ©rT   r   rv   r
   rk   r¡   r  ©é   rN  rN  é   rO  rO  )rG  rH  r   r   ÚBBrœ   r  r  )rG  rH  r   r   rP  ©r   r   rP  r  rT   ©Zaxis©r   r   r  r   rB   rC   Ú
sort_index©r9   r#   rL   r:   r!   r!   r"   Útest_character_overlapn  s2    øÿ
ùÿz%TestWideToLong.test_character_overlapc              	   C   s¼   d}t 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 |ƒ dtji¡}| ddg¡g d¢ }|jjddgdd�|_t|ddgdd|d�}t 	|j
dd�|j
dd�¡ d S )Nznope!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   rT   ©Úlevelr   r   r  rR  ©r   r   r   r   r   r  Ú
set_levelsr   rB   rC   rT  )r9   r  r#   rñ   rL   r:   r!   r!   r"   Útest_invalid_separatorŒ  s2    üÿ
ø
ÿz%TestWideToLong.test_invalid_separatorc              
   C   sÂ   t g d¢g d¢g d¢g d¢g d¢g d¢g d¢g d¢dœƒ}|j|d	< t g d
¢g d
¢g d¢g d¢g d¢g d¢g d¢dœƒ}| d	dg¡g d¢ }t|g d¢d	dd�}t |jdd�|jdd�¡ d S )Nr.  r2  r5  r9  r­   r®   r=  )rA  rB  rC  rD  rE  rF  ÚAratingÚArating_oldrœ   rI  rJ  rK  rL  r  rM  )r]  r^  r   r   rP  rœ   r  r  )r]  r^  r   r   rP  rQ  r  rT   rR  rS  rU  r!   r!   r"   Útest_num_string_disambiguationª  s6    øÿ
ùÿÿz-TestWideToLong.test_num_string_disambiguationc              	   C   s®   t 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 |ƒ dtji¡}| d
dg¡}|jjddgdd�|_t|ddgd
dd�}t 	|j
dd�|j
dd�¡ d S )Nr  r  r  r  r   r!  r"  r#  )ÚAoneÚAtwoÚBoner|   rœ   rW  )r|   r`  ra  rb  rœ   r  r   r   r  r   rT   rX  r   r   r  rR  rZ  r,  r!   r!   r"   Útest_invalid_suffixtypeË  s,    üÿ
ø
z&TestWideToLong.test_invalid_suffixtypec                 C   s|   t g d¢g d¢g d¢g d¢dœƒ}t g d¢g d¢g d¢g d	¢d
œƒ}| g d¢¡dg }t|dddgdd�}t ||¡ d S )N)	rT   rT   rT   r   r   r   rv   rv   rv   )	rT   r   rv   rT   r   rv   rT   r   rv   )	çffffff@ç333333@çš™™™™™@r   çÍÌÌÌÌÌü?çffffffþ?rf  çffffff@çÍÌÌÌÌÌ @)	ç333333@çffffff@re  rú   rd  ç333333@çffffff
@rk  re  )ÚfamidÚbirthZht1Zht2)rd  rk  re  rl  rf  re  r  rú   rg  rd  rh  rm  rf  rn  ri  rk  rj  re  )rT   rT   rT   rT   rT   rT   r   r   r   r   r   r   rv   rv   rv   rv   rv   rv   )rT   rT   r   r   rv   rv   rT   rT   r   r   rv   rv   rT   rT   r   r   rv   rv   )rT   r   rT   r   rT   r   rT   r   rT   r   rT   r   rT   r   rT   r   rT   r   )Úhtro  rp  r  )ro  rp  r  rq  ro  rp  r  r  ©r   r  r   rB   rC   rU  r!   r!   r"   Útest_multiple_id_columnsè  s"    üÿéÿz'TestWideToLong.test_multiple_id_columnsc                 C   sf   t g d¢g d¢g d¢dœƒ}d}tjt|d��$ t|ddgdd	d
� W d   ƒ n1 sX0    Y  d S )N)rT   r   rv   r
   rk   )rT   rT   rT   rT   rT   )ZA_A1ZB_B1r™   z3the id variables need to uniquely identify each rowrV   ZA_AZB_Br™   Úcolnamer  ©r   rX   rY   rZ   r   ©r9   r#   r[   r!   r!   r"   Útest_non_unique_idvars  s    ÿz%TestWideToLong.test_non_unique_idvarsc                 C   sz   t g d¢g d¢g d¢g d¢g d¢dœƒ}t g d¢g d¢g d	¢g d
¢dœƒ ddg¡}t|ddgdddd�}t ||¡ d S )N)úCCH PounderúJohnny DeppúChristoph Waltz)úJoel David MooreúOrlando BloomúRory Kinnear)ç     @�@ç     ˆã@ç     |Å@)ç     @�@ç     ˆ³@ç     �x@)ÚAvatarúPirates of the CaribbeanÚSpectre)Zactor_1Zactor_2Zactor_fb_likes_1Zactor_fb_likes_2Útitle)rx  ry  rz  r{  r|  r}  )r~  r  r€  r�  r‚  rƒ  )rT   rT   rT   r   r   r   )r„  r…  r†  r„  r…  r†  )ÚactorÚactor_fb_likesÚnumr‡  r‡  rŠ  rˆ  r‰  Ú_r  rr  rU  r!   r!   r"   Útest_cast_j_int  s*    ûÿ
õÿëÿzTestWideToLong.test_cast_j_intc                 C   sl   t 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   ƒ n1 s^0    Y  d S )Nr  r  r  r  r   r!  r"  r#  )r%  r&  r'  r   z,stubname can't be identical to a column namerV   r   r   rt  r  ru  rv  r!   r!   r"   Útest_identical_stubnamesB  s    üÿz'TestWideToLong.test_identical_stubnamesc                 C   s‚   t ddgddgddgddgd	œƒ}t g d
¢g d¢ddtjtjgg d¢dœƒ}| ddg¡}t|ddgddddd�}t ||¡ d S )Nr  r  r  r  r   r!  r"  r#  )Ztreatment_placeboZtreatment_testZresult_placebor   r(  )ÚplaceborŽ  Útestr�  r)  ©r   rt  r:   Ú	treatmentr   rt  r:   r‘  z[a-z]+r‹  ©ræ   r  Úsuffixr  ©r   r   rï   r  r   rB   rC   rU  r!   r!   r"   Útest_nonnumeric_suffixO  s&    üÿüÿÿz%TestWideToLong.test_nonnumeric_suffixc                 C   s|   t ddgddgddgddgd	d
gdœƒ}t g d¢g d¢g d¢g d¢dœƒ ddg¡}t|ddgddddd�}t ||¡ d S )Nr"  r#  r   r  r   r!  r  r  r  r  )r   Úresult_1Z
result_fooZtreatment_1Ztreatment_foor(  )Ú1r—  rd   rd   )ç        ç      "@r   r!  r)  r�  r   rt  r:   r‘  z.+r‹  r’  rr  rU  r!   r!   r"   Útest_mixed_type_suffixf  s*    ûÿ	üÿùÿz%TestWideToLong.test_mixed_type_suffixc                 C   s¨   t ddgddgddgddgd	d
gdœƒ}t g d¢g d¢ddddtjtjtjtjgtjtjtjtjddddgdœƒ}| ddg¡}t|ddgddddd�}t ||¡ d S )Nr  r  r  r  r   r!  r   r  r"  r#  )ztreatment_1.1ztreatment_2.1z
result_1.2r–  r   )r"  r#  r"  r#  r"  r#  r"  r#  )rø   rø   r  r  çš™™™™™ñ?r›  rj  rj  r˜  r™  r�  r   rt  r:   r‘  z[0-9.]+r‹  r’  r”  rU  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  |¡}t|dgddgdd�}t|dddgdd�}t ||¡ d S )Nr   rT   r   rv   r
   )r   rT   r   rv   r
   gš™™™™™é?r˜  g      Ð?r  gìQ¸…ëé?g®Gáz®ç?gìQ¸…ëá?g\�Âõ(\ï?g333333ã?g¤p=
×£è?g{®Gázä?g¤p=
×£à?gq=
×£på?gÃõ(\�ÂÕ?rù   )Únode_idr   ZPA0ZPA1ZPA3ZPAr�  r   Útime)Ú	stubnamesræ   r  )r   Ú	from_dictr   rB   rC   )r9   Z	wide_dataZwide_dfrL   r:   r!   r!   r"   Útest_col_substring_of_stubname•  s    û
z-TestWideToLong.test_col_substring_of_stubnamec                 C   s`   t tdƒtdddƒdœƒ}tjtt d¡d�� |jddd	� W d   ƒ n1 sR0    Y  d S )
Nr*   r	   é   r   )rj   r6   zvalue_name (value) cannot matchrV   r6   r`   )	r   r   rw   rX   rY   rZ   ÚreÚescaper   r²   r!   r!   r"   Útest_raise_of_column_name_value¥  s
    
ÿz.TestWideToLong.test_raise_of_column_name_valuer   ÚOÚstringc                 C   s¢   t ddgddgddgdœƒ}| d|i¡}t|d	d
gdddd�}tg d¢dd�}t g d¢tjgd dœ|d�}|jjd  |¡}|jj|dd�|_t	 
||¡ d S )Nr—  Ú2éd   éÈ   é,  é�  )rœ   za-1za-2rœ   rO   rP   rŠ  ú-)rŸ  ræ   r  r  ))r—  rT   )r¨  rT   )r—  r   )r¨  r   )rœ   rŠ  )rf   )r©  rª  r«  r¬  r
   rŸ   r�   r   rX  )r   r   r   r   r   rï   r   Zlevelsr[  rB   rC   )r9   r   r#   r:   r   rL   Z	new_levelr!   r!   r"   Útest_missing_stubname°  s(    ûþþz$TestWideToLong.test_missing_stubnameN)r´   rµ   r¶   r  r  r  r  r-  rV  r\  r_  rc  rs  rw  rŒ  r�  r•  rš  rœ  r¡  r¥  rX   r·   r¸   r®  r!   r!   r!   r"   rô      s(   
!)
'rô   c               	   C   s´   t  d¡ tddiddiddiddiddidœƒ} | j d¡| _t| ddd	d
dd�}tddgddgddggtddgtd�tj	j
g d¢tg d¢dd�gdd	gd�d�}t ||¡ d S )NZpyarrowr   rT   r   )ÚIDZR_test1ZR_test2ZR_test3ÚDzstring[pyarrow_numpy]ÚRr¯  Z	UNPIVOTEDr‹  z.*)rŸ  ræ   r  r  r“  r°  r   )rT   rT   rT   )Ztest1Ztest2Ztest3r”   r   )rX   Zimportorskipr   r   r   r   r   r   rx   r•   Zfrom_arraysrB   rC   )r#   r:   rL   r!   r!   r"   Ú(test_wide_to_long_pyarrow_string_columnsÉ  s0    
ûÿ	ÿþûýr²  )r£  Únumpyr   rX   Zpandasrx   r   r   r   r   r   r   Zpandas._testingZ_testingrB   Zfixturer#   r/   r1   r3   r4   r»   rô   r²  r!   r!   r!   r"   Ú<module>   s0    



   i e   L