o
    d                     @   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	 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S )    N)	DataFramelreshapemeltwide_to_longc                  C   sD   t  d d } | d dktj| d< | d dktj| d< | S )N
   Ar   id1Bid2)tmmakeTimeDataFrameastypenpint64res r   c/var/www/html/visualizacion-main/env/lib/python3.10/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:?StgKԲ?)Uy$> M?gK)i<8b->?ghBĒABCabcCAPlow)r   listcolumnsnamesr   r   r   r   df1   s   r"   c                   C      dS )Nvarr   r   r   r   r   var_name&      r%   c                   C   r#   )Nvalr   r   r   r   r   
value_name+   r&   r(   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j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$dQS )R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_method1      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r%   r(   r   	col_level)r   assert_frame_equalr   )r.   r   r"   r%   r(   r   r   r   test_method_signatures5   s    zTestMelt.test_method_signaturesc                 C   sl   |  }|j ddgksJ |j dgd}|j g dks!J |j ddgd}|j g dks4J d S )Nr*   r+   r   )r3   )r   r*   r+   r
   r   r
   r*   r+   r,   )r.   r   r/   result1result2r   r   r   test_default_col_namesD   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   r2   r   r	      r:   r    )r   lenr   r-   r   r8   )r.   r   result3result4	expected4r   r   r   test_value_varsN   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	   r:   r?   r   r	   r2   )r   r-   r   r   r8   )r.   rE   r   expectedr/   r   r   r   test_value_vars_types^   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	   rK   )rI   r   r   r+   r?   r2   )r   r@   r   r   r8   )r.   r"   rG   r/   r   r   r   test_vars_work_with_multiindexm   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   r+   rJ   rK   rO   )rJ   r   r+   c                 C   s    |j |||d}t|| d S )Nr6   )r   r   r8   )r.   r3   r4   r7   rG   r"   r/   r   r   r   %test_single_vars_work_with_multiindex{   s    z.TestMelt.test_single_vars_work_with_multiindexzid_vars, value_varsrI   rL   c                 C   sF   d}t jt|d |j||d W d    d S 1 sw   Y  d S )NzF(id|value)_vars must be a list of tuples when columns are a MultiIndexmatchr2   )pytestraises
ValueErrorr   )r.   r3   r4   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s$J |j ddg|d}|j g dks8J |j ddgd	|d
}|j g dksMJ |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)r%   r$   r+   r   )r3   r%   )r   r$   r+   r
   )r   r
   r$   r+   r   )r3   r4   r%   r	   r>   r   r?   r   r    r-   r   r   r8   )	r.   r   r%   result5result6result7result8result9	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s$J |j ddg|d}|j g dks8J |j ddgd	|d
}|j g dksMJ |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)r(   r*   r'   r   r3   r(   )r   r*   r'   r
   )r   r
   r*   r'   r   )r3   r4   r(   r	   r>   r   r?   rX   )	r.   r   r(   result10result11result12result13result14
expected14r   r   r   test_custom_value_name   s,   

	zTestMelt.test_custom_value_namec                 C   sZ  |j ||d}|j ddgksJ |j dg||d}|j g dks&J |j ddg||d}|j g dks;J |j ddgd	||d
}|j g dksQJ |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sJ d S )Nr5   r$   r'   r   r3   r%   r(   )r   r$   r'   r
   )r   r
   r$   r'   r   )r3   r4   r%   r(   r	   r>   r   r?   foor+   )r   r    r-   r   r   r8   copyname)r.   r   r(   r%   result15result16result17result18result19
expected19df20result20r   r   r   test_custom_var_and_value_name   sD   

	z'TestMelt.test_custom_var_and_value_namer7   r   c                 C   s&   |j |d}|j ddgksJ d S )Nr6   r   r+   r,   )r.   r7   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   r+   r,   )r.   r"   r   r   r   r   test_multiindex  r1   zTestMelt.test_multiindexcol2010   z
US/Pacific)periodstz)rJ   rK   crJ   dcategorydtype)r   rO   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 )Nry   )rO   r   r   r   r   )klassrw   attr1attr2Tignore_indexr   rw   	attributer+   rh   r>   r   r   r   rO   r>      )r   rw   r   r+   )
r   rangepdconcatSeriesr   r   r    r   r8   )r.   rw   r   expected_valuer/   rG   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 )	NrO   r>   XYrF   r	   r   )r	   r*   r+   )r   r   Categoricalr   r   r8   )r.   datar/   rG   r   r   r   test_preserve_category5  s   zTestMelt.test_preserve_categoryc                 C   s  t tjddtdd}d}tjt|jdddd	 |	d
dgddg W d    n1 s0w   Y  tjt|jdddd	 |	ddgddg W d    n1 sVw   Y  tjt|jdddd	 |	g dddg W d    n1 s|w   Y  |
 }tdtdg|_tjt|jdddd	 |	dgdg W d    n1 sw   Y  tjt|jdddd	 |j	dgdgdd W d    d S 1 sw   Y  d S )Nry      abcdr?   z=The following '{Var}' are not present in the DataFrame: {Col}r4   z\['C'\])VarColrQ   rJ   rK   Cr}   r3   z\['A'\]r   r|   z\['not_here', 'or_there'\])rJ   rK   not_hereor_thereABCDz\['E'\])ErJ   rL   z\['F'\]Fr   r6   )r   r   randomrandnr   rS   rT   KeyErrorformatr   rj   r    )r.   r   rV   multir   r   r    test_melt_missing_columns_raises?  s4   "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 )Nri   barrO   r>   )r   rJ   rK   r}   r   rJ   rK   r}   r2   bd)r   rJ   r*   r+   )r   r   r   r   r8   r.   r   r/   rG   r   r   r   test_melt_mixed_int_str_id_varsd  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 )Nri   r   )r   rJ   r   rJ   )r4   r*   r+   r   r   r   r8   r   r   r   r   "test_melt_mixed_int_str_value_varsm  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   rO   ri   r   firstindexFr   ri   r   r   r   r   r   r   r   test_ignore_indext  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bazfoobar)r!   r   rO   r>   r   r   r   Fr   ri   r   r   r   )r   
MultiIndexfrom_tuplesr   r   r   r8   r.   r   r   r/   expected_indexrG   r   r   r   test_ignore_multiindex}  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g dg dd|d}t|| d S )Nri   r   r~   r   )r   rk   r   rO   r>   r   )xyr   Fr   )r   r   r   r   r   r   )r   Indexr   r   r   r8   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>   r   )rJ   rK   rK   r?   rJ   rK   r2   )r   rK   r>   )r   rK   r   )rJ   r*   r+   r   r   r   r   r    test_melt_with_duplicate_columns  s   z)TestMelt.test_melt_with_duplicate_columnsr   Int8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 )NrO   r>   r   r   r   r   rJ   rK   )rJ   rJ   rK   rK   )rO   r>   r   r   r   )r   r   r   r   r   r8   )r.   r   r   r/   rG   r   r   r   test_melt_ea_dtype  s   zTestMelt.test_melt_ea_dtypeN)%__name__
__module____qualname__r0   r9   r=   rD   rS   markparametrizetupler   r   arrayrH   rM   r   rP   rW   r_   rg   rt   ru   rv   r   r   
date_ranger   r   r   r   r   r   r   r   r   r   r   r   r   r   r)   0   s    









*


%			r)   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    d S 1 sw   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   sexvisitdt1visitdt2visitdt3wt1wt2wt3c                 S      g | ]}d |dqS visitdtr}   r   .0ir   r   r   
<listcomp>      z+TestLreshape.test_pairs.<locals>.<listcomp>rO   r   c                 S   r   wtr}   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  r?   F)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   r   r   r   r   r   r   r   r     r   r   c                 S   r   r   r   r   r   r   r   r     r   z$All column lists must be same lengthrQ   )r   nanr   r   r   r    r   r8   rS   rT   rU   )r.   r   r   specr/   exp_dataexprV   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      t jd t j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 )N{   r   rJ   rK   r|   rN   r}   ef      @333333?ffffff?皙	@?皙?)A1970A1980B1970B1980r   r   rJ   rK   r|   r}   r  r  r  r  r  r  r  r    r  r    r  r  r   rO   r>   r   rO   r>   r   r   r	   yearr   r"  r   r   r	   r   r	   r   jr   r   seedr   r   dictzipr   r   r-   	set_indexr   r   r8   r.   r   r   r	  rG   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s#J d S )	N)r   rO   r>   r      )r   ry         	   )r   inc1inc2edu1edu2incedur   ager$  )r   r    r   )r.   r   stubsr   r   r   
test_stubs  s
   
zTestWideToLong.test_stubsc              	   C   s   t jd t j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  r   rJ   rK   r|   rN   r}   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   r  )Nr  r   rJ   rK   r|   rN   r}   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   rG  rH  rG  rH  rA  rB  rC  rD  )r   rO   r   rO   )  rO    rP  )r   r   r	   r   r"  r"  r#  r   r	   r$  )r   r   r   r  r*  r   r   r8   r.   r   r	  rG   r/   r   r   r   test_unbalanced  s$   
zTestWideToLong.test_unbalancedc              
   C      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a21rV  a23b11b12b13b21b22b23rO   r>   r   r   ry   r.  [   \   ]   )A11A12B11B12BB11BB12BBBXBBBZr   rf  rg  rh  rf  rg  rh  rU  rV  rW  rY  rV  rZ  r\  r]  r^  r`  ra  rb  rO   r>   r   r   ry   r.  r      rv  rv     rw  rw  )ro  rp  r   r	   BBr   r"  r"  )ro  rp  r   r	   rx  r   r	   rx  r$  rO   axisr   r   r*  r   r   r8   
sort_indexr.   r   rG   r/   r   r   r   test_character_overlap  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!rA  rB  rC  rD  rE  rF  rG  rH  rI  r    )r   rJ  rK  rL  r   r"  r   r	   r"  )r   rJ  rK  rL  r   r	   r   rO   levelr   r	   r;  rz  r   r   r   r   r   r*  
set_levelsr   r   r8   r}  )r.   r<  r   r	  rG   r/   r   r   r   test_invalid_separator+  s2   

 z%TestWideToLong.test_invalid_separatorc              
   C   rS  )NrT  rX  r[  r_  rc  rd  re  )ri  rj  rk  rl  rm  rn  AratingArating_oldr   rq  rr  rs  rt  r   ru  )r  r  r   r	   rx  r   r"  r"  )r  r  r   r	   rx  ry  r$  rO   rz  r|  r~  r   r   r   test_num_string_disambiguationI  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 )NrA  rB  rC  rD  rE  rF  rG  rH  )AoneAtwoBoner   r   r  )r   r  r  r  r   r"  r   r	   r"  r   rO   r  r   r	   r$  rz  r  rQ  r   r   r   test_invalid_suffixtypej  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)	rO   rO   rO   r>   r>   r>   r   r   r   )	rO   r>   r   rO   r>   r   rO   r>   r   )	ffffff@333333@皙@r>   ?ffffff?r  ffffff@ @)	333333@ffffff@r  r  r  333333@ffffff
@r  r  )famidbirthht1ht2)r  r  r  r  r  r  rB  r  r  r  r  r  r  r  r  r  r  r  )rO   rO   rO   rO   rO   rO   r>   r>   r>   r>   r>   r>   r   r   r   r   r   r   )rO   rO   r>   r>   r   r   rO   rO   r>   r>   r   r   rO   rO   r>   r>   r   r   )rO   r>   rO   r>   rO   r>   rO   r>   rO   r>   rO   r>   rO   r>   rO   r>   rO   r>   )htr  r  r7  )r  r  r7  r  r  r  r7  r$  r   r*  r   r   r8   r~  r   r   r   test_multiple_id_columns  s"   z'TestWideToLong.test_multiple_id_columnsc                 C   sh   t g dg dg dd}d}tjt|d t|ddgdd	d
 W d    d S 1 s-w   Y  d S )N)rO   r>   r   r   ry   )rO   rO   rO   rO   rO   )A_A1B_B1r   z3the id variables need to uniquely identify each rowrQ   A_AB_Br   colnamer$  r   rS   rT   rU   r   r.   r   rV   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)actor_1actor_2actor_fb_likes_1actor_fb_likes_2title)r  r  r  r  r  r  )r  r  r  r  r  r  )rO   rO   rO   r>   r>   r>   )r  r  r  r  r  r  )actoractor_fb_likesnumr  r  r  r  r  _r;  r  r~  r   r   r   test_cast_j_int  s*   

zTestWideToLong.test_cast_j_intc                 C   sn   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    d S 1 s0w   Y  d S )NrA  rB  rC  rD  rE  rF  rG  rH  )rJ  rK  rL  r   z,stubname can't be identical to a column namerQ   r   r	   r  r$  r  r  r   r   r   test_identical_stubnames  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 )NrA  rB  rC  rD  rE  rF  rG  rH  )treatment_placebotreatment_testresult_placebor   rM  )placebor  testr  rN  r   r  r/   	treatmentr   r  r/   r  z[a-z]+r  r   r%  suffixr<  r   r   r  r*  r   r   r8   r~  r   r   r   test_nonnumeric_suffix  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 )NrG  rH  r   r0  rE  rF  rA  rB  rC  rD  )r   result_1
result_footreatment_1treatment_foorM  )1r  ri   ri   )              "@rE  rF  rN  r  r   r  r/   r  z.+r  r  r  r~  r   r   r   test_mixed_type_suffix  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 )NrA  rB  rC  rD  rE  rF  r   r0  rG  rH  )ztreatment_1.1ztreatment_2.1z
result_1.2r  r   )rG  rH  rG  rH  rG  rH  rG  rH  )r  r  rA  rA  皙?r  r  r  r  r  r  r   r  r/   r  z[0-9.]+r  r  r  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 |}t|dgddgdd}t|dddgdd}t|| d S )Nr   rO   r>   r   r   )r   rO   r>   r   r   g?r  g      ?rA  gQ?gGz?gQ?g\(\?g333333?gp=
ף?g{Gz?gp=
ף?gq=
ףp?g(\?r  )node_idr   PA0PA1PA3PAr  r   time)	stubnamesr   r%  )r   	from_dictr   r   r8   )r.   	wide_datawide_dfrG   r/   r   r   r   test_col_substring_of_stubname4  s   
z-TestWideToLong.test_col_substring_of_stubnamec                 C   sb   t tdtdddd}tjttdd |jddd	 W d    d S 1 s*w   Y  d S )
Nr   r      r>   )rw   r+   zvalue_name (value) cannot matchrQ   r+   r`   )	r   r   r   rS   rT   rU   reescaper   )r.   r   r   r   r   test_raise_of_column_name_valueD  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jg ddd}t g dtjgd d|d}|jjd |}|jj	|dd|_t
|| d S )Nr  2d      ,    )r   za-1za-2r   rJ   rK   r  -)r  r   r%  r<  ))r  rO   )r  rO   )r  r>   )r  r>   )r   r  )rk   )r  r  r  r  r   r   r   r   r  )r   r   r   r   r   r   r  r   levelsr  r   r8   )r.   r   r   r/   r   rG   	new_levelr   r   r   test_missing_stubnameO  s(   z$TestWideToLong.test_missing_stubnameN)r   r   r   r,  r9  r=  r@  rR  r  r  r  r  r  r  r  r  r  r  r  r  r  rS   r   r   r  r   r   r   r   r    s*    
!)
'r  )r  numpyr   rS   pandasr   r   r   r   r   pandas._testing_testingr   fixturer   r"   r%   r(   r)   r   r  r   r   r   r   <module>   s*    



    e