Ë
    @Øïi˜¡  ã                   ó  — 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„ «       Zej                  d„ «       Zej                  d„ «       Zej                  d„ «       Z G d„ d«      Z G d	„ d
«      Z G d„ d«      Zy)é    N)Ú	DataFrameÚIndexÚ
date_rangeÚlreshapeÚmeltÚwide_to_longc            	      ób  — t        t        j                  j                  d«      j	                  d«      t        t        d«      t        ¬«      t        ddd¬«      ¬	«      } | d
   dkD  j                  t        j                  «      | d<   | d   dkD  j                  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©Úress    úX/var/www/html/aiagents/fe/lib/python3.12/site-packages/pandas/tests/reshape/test_melt.pyÚdfr#      sŠ   € ä
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9Ü”d˜6“l¬&Ô1Ü˜¨r¸Ô<ô€Cð
 �c‘(˜Q‘,×&Ñ&¤r§x¡xÓ0€Cˆ�JØ�c‘(˜Q‘,×&Ñ&¤r§x¡xÓ0€Cˆ�JØ€Jó    c                  óŠ   — 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    s    r"   Údf1r1      sE   € ä
â*Ú,Ú+ð	
ó€Cô ˜“;¤ U£Ð,€C„KØ ˜€C‡K�KÔØ€Jr$   c                   ó   — y)NÚvar© r4   r$   r"   Úvar_namer5   ,   ó   € àr$   c                   ó   — y)NÚvalr4   r4   r$   r"   Ú
value_namer9   1   r6   r$   c                   óX  — e Zd Zd„ Zd„ Zd„ Zd„ Zej                  j                  de
eej                  f«      d„ «       Zd„ Zej                  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„ «       Zej                  j                  dddggdgdgddgg«      d„ «       Zd„ Zd„ Zd„ Zej                  j                  d dd!g«      d"„ «       Zd#„ Zej                  j                  d$ ej2                   ed%d&d'¬(«      «       ej2                  g d)¢d*¬+«       ej2                  g d,¢«      g«      d-„ «       Zd.„ Zd/„ Zd0„ Zd1„ Zd2„ Z d3„ Z!d4„ Z"d5„ Z#ej                  j                  d6d7d8g«      d9„ «       Z$d:„ Z%d;„ Z&d<„ Z'd=„ Z(d>„ Z)y?)@ÚTestMeltc                 ó\   — t        |«      }|j                  j                  «       ddgk(  sJ ‚y )NÚvariableÚvalue©r   r   Útolist)Úselfr#   Úresults      r"   Útest_top_level_methodzTestMelt.test_top_level_method7   s+   € Ü�b“ˆØ�~‰~×$Ñ$Ó&¨:°wÐ*?Ò?Ð?Ñ?r$   c           	      óœ  — t        j                  |j                  «       t        |«      «       t        j                  |j                  ddgddg¬«      t        |ddgddg¬«      «       t        j                  |j                  ||¬«      t        |||¬«      «       t        j                  |j                  d¬«      t        |d¬«      «       y )	Nr   r   r   r   ©Úid_varsÚ
value_vars©r5   r9   r   ©Ú	col_level)ÚtmÚassert_frame_equalr   )rA   r#   r1   r5   r9   s        r"   Útest_method_signatureszTestMelt.test_method_signatures;   s¦   € Ü
×Ñ˜bŸg™g›i¬¨b«Ô2ä
×ÑØ�G‰G˜U E˜N¸¸S°zˆGÓBÜ�˜e U˜^¸¸c¸
ÔCô	
ô
 	×ÑØ�G‰G˜X°*ˆGÓ=Ü�˜h°:Ô>ô	
ô
 	×Ñ˜cŸh™h°˜hÓ3´T¸#ÈÔ5KÕLr$   c                 ó8  — |j                  «       }|j                  j                  «       ddgk(  sJ ‚|j                  dg¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddg¬«      }|j                  j                  «       g d¢k(  sJ ‚y )Nr=   r>   r   )rF   )r   r=   r>   r   ©r   r   r=   r>   r?   )rA   r#   rB   Úresult1Úresult2s        r"   Útest_default_col_nameszTestMelt.test_default_col_namesJ   s‹   € Ø—‘“ˆØ�~‰~×$Ñ$Ó&¨:°wÐ*?Ò?Ð?Ð?à—'‘' 5 '�'Ó*ˆØ�‰×%Ñ%Ó'Ò+GÒGÐGÐGà—'‘' 5¨% .�'Ó1ˆØ�‰×%Ñ%Ó'Ò+NÒNÐNÑNr$   c                 ó€  — |j                  ddgd¬«      }t        |«      dk(  sJ ‚|j                  ddgddg¬«      }t        |d   j                  «       dz  |d   j                  «       dz  dgdz  dgdz  z   |d   j                  «       |d   j                  «       z   dœg d¢¬	«      }t	        j
                  ||«       y )
Nr   r   r   rE   r   r   r
   rO   ©r   )r   Úlenr   r@   rK   rL   )rA   r#   Úresult3Úresult4Ú	expected4s        r"   Útest_value_varszTestMelt.test_value_varsT   sÆ   € Ø—'‘' 5¨% .¸S�'ÓAˆÜ�7‹|˜rÒ!Ð!Ð!à—'‘' 5¨% .¸cÀ3¸Z�'ÓHˆÜà˜%‘y×'Ñ'Ó)¨AÑ-Ø˜%‘y×'Ñ'Ó)¨AÑ-Ø ˜E B™J¨#¨°©Ñ3Ø˜S™'Ÿ.™.Ó*¨R°©W¯^©^Ó-=Ñ=ñ	ò 8ô
ˆ	ô 	×Ñ˜g yÕ1r$   Útype_c                 ó>  — t        |d   j                  «       dz  |d   j                  «       dz  dgdz  dgdz  z   |d   j                  «       |d   j                  «       z   dœg d¢¬«      }|j                  ddg |d	«      ¬
«      }t        j                  ||«       y )Nr   r
   r   r   r   r   rO   rT   ©r   r   rE   )r   r@   r   rK   rL   )rA   rZ   r#   ÚexpectedrB   s        r"   Útest_value_vars_typeszTestMelt.test_value_vars_typesd   s¡   € ô à˜%‘y×'Ñ'Ó)¨AÑ-Ø˜%‘y×'Ñ'Ó)¨AÑ-Ø ˜E B™J¨#¨°©Ñ3Ø˜S™'Ÿ.™.Ó*¨R°©W¯^©^Ó-=Ñ=ñ	ò 8ô
ˆð —‘ %¨ ¹EÀ*Ó<M�ÓNˆÜ
×Ñ˜f hÕ/r$   c                 óÂ   — t        |d   dgt        |«      z  dgt        |«      z  |d   dœg d¢¬«      }|j                  dgdg¬«      }t        j                  ||«       y )N©r   Úar   Úb©r   rb   )r`   r.   r/   r>   rT   rE   )r   rU   r   rK   rL   )rA   r1   r]   rB   s       r"   Útest_vars_work_with_multiindexz'TestMelt.test_vars_work_with_multiindexs   sh   € Üà 
™OØ�uœs 3›xÑ'Ø�uœs 3›xÑ'Ø˜Z™ñ	ò 8ô
ˆð —‘ : ,¸J¸<�ÓHˆÜ
×Ñ˜f hÕ/r$   z(id_vars, value_vars, col_level, expectedr   r   r   r&   r(   r*   ©r   é   r
   r'   r)   r+   )r   r.   r>   ra   rb   rf   )ra   r/   r>   c                 óX   — |j                  |||¬«      }t        j                  ||«       y )NrI   )r   rK   rL   )rA   rF   rG   rJ   r]   r1   rB   s          r"   Ú%test_single_vars_work_with_multiindexz.TestMelt.test_single_vars_work_with_multiindex�   s)   € ð@ —‘˜' :¸�ÓCˆÜ
×Ñ˜f hÕ/r$   zid_vars, value_varsr`   rc   c                 óŽ   — d}t        j                  t        |¬«      5  |j                  ||¬«       d d d «       y # 1 sw Y   y xY w)NzF(id|value)_vars must be a list of tuples when columns are a MultiIndex©ÚmatchrE   )ÚpytestÚraisesÚ
ValueErrorr   )rA   rF   rG   r1   Úmsgs        r"   Ú$test_tuple_vars_fail_with_multiindexz-TestMelt.test_tuple_vars_fail_with_multiindex¤   s=   € ð XˆÜ�]‰]œ:¨SÔ1ñ 	=Ø�H‰H˜W°ˆHÔ<÷	=÷ 	=ñ 	=ús	   ž;»Ac                 óì  — |j                  |¬«      }|j                  j                  «       ddgk(  sJ ‚|j                  dg|¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddg|¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddgd	|¬
«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddgd	dg|¬
«      }t        d|d   j                  «       dz  d|d   j                  «       dz  |d	gdz  dgdz  z   d|d	   j                  «       |d   j                  «       z   idd|dg¬«      }t	        j
                  ||«       y )N)r5   r3   r>   r   ©rF   r5   )r   r3   r>   r   )r   r   r3   r>   r   )rF   rG   r5   r   r
   r   rT   ©r   r   r@   r   rK   rL   )	rA   r#   r5   Úresult5Úresult6Úresult7Úresult8Úresult9Ú	expected9s	            r"   Útest_custom_var_namezTestMelt.test_custom_var_name´   s  € Ø—'‘' 8�'Ó,ˆØ�‰×%Ñ%Ó'¨E°7Ð+;Ò;Ð;Ð;à—'‘' 5 '°H�'Ó=ˆØ�‰×%Ñ%Ó'Ò+BÒBÐBÐBà—'‘' 5¨% .¸8�'ÓDˆØ�‰×%Ñ%Ó'Ò+IÒIÐIÐIà—'‘' 5¨% .¸SÈ8�'ÓTˆØ�‰×%Ñ%Ó'Ò+IÒIÐIÐIà—'‘'Ø˜E�N°°S¨zÀHð ó 
ˆô à�r˜%‘y×'Ñ'Ó)¨AÑ-Ø�r˜%‘y×'Ñ'Ó)¨AÑ-Ø˜3˜% "™*¨ u¨r¡zÑ1Ø˜"˜S™'Ÿ.™.Ó*¨R°©W¯^©^Ó-=Ñ=ð	ð ˜E 8¨WÐ5ô
ˆ	ô 	×Ñ˜g yÕ1r$   c                 óì  — |j                  |¬«      }|j                  j                  «       ddgk(  sJ ‚|j                  dg|¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddg|¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddgd	|¬
«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddgd	dg|¬
«      }t        d|d   j                  «       dz  d|d   j                  «       dz  dd	gdz  dgdz  z   ||d	   j                  «       |d   j                  «       z   iddd|g¬«      }t	        j
                  ||«       y )N)r9   r=   r8   r   ©rF   r9   )r   r=   r8   r   )r   r   r=   r8   r   )rF   rG   r9   r   r
   r   rT   rs   )	rA   r#   r9   Úresult10Úresult11Úresult12Úresult13Úresult14Ú
expected14s	            r"   Útest_custom_value_namezTestMelt.test_custom_value_nameÏ   s�  € Ø—7‘7 j�7Ó1ˆØ×Ñ×&Ñ&Ó(¨Z¸Ð,?Ò?Ð?Ð?à—7‘7 E 7°z�7ÓBˆØ×Ñ×&Ñ&Ó(Ò,FÒFÐFÐFà—7‘7 E¨5 >¸j�7ÓIˆØ×Ñ×&Ñ&Ó(Ò,MÒMÐMÐMà—7‘7Ø˜E�N¨s¸zð ó 
ˆð ×Ñ×&Ñ&Ó(Ò,MÒMÐMÐMà—7‘7Ø˜E�N°°S¨zÀjð ó 
ˆô à�r˜%‘y×'Ñ'Ó)¨AÑ-Ø�r˜%‘y×'Ñ'Ó)¨AÑ-Ø˜S˜E B™J¨#¨°©Ñ3Ø˜R ™WŸ^™^Ó-°°3±·±Ó0@Ñ@ð	ð ˜E :¨zÐ:ô
ˆ
ô 	×Ñ˜h¨
Õ3r$   c                 óš  — |j                  ||¬«      }|j                  j                  «       ddgk(  sJ ‚|j                  dg||¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddg||¬«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddgd	||¬
«      }|j                  j                  «       g d¢k(  sJ ‚|j                  ddgd	dg||¬
«      }t        d|d   j                  «       dz  d|d   j                  «       dz  |d	gdz  dgdz  z   ||d	   j                  «       |d   j                  «       z   idd||g¬«      }	t	        j
                  ||	«       |j                  «       }
d|
j                  _        |
j                  «       }|j                  j                  «       ddgk(  sJ ‚y )NrH   r3   r8   r   ©rF   r5   r9   )r   r3   r8   r   )r   r   r3   r8   r   ©rF   rG   r5   r9   r   r
   r   rT   Úfoor>   )r   r   r@   r   rK   rL   ÚcopyÚname)rA   r#   r9   r5   Úresult15Úresult16Úresult17Úresult18Úresult19Ú
expected19Údf20Úresult20s               r"   Útest_custom_var_and_value_namez'TestMelt.test_custom_var_and_value_nameì   sê  € Ø—7‘7 H¸�7ÓDˆØ×Ñ×&Ñ&Ó(¨U°E¨NÒ:Ð:Ð:à—7‘7 E 7°XÈ*�7ÓUˆØ×Ñ×&Ñ&Ó(Ò,AÒAÐAÐAà—7‘7Ø˜E�N¨XÀ*ð ó 
ˆð ×Ñ×&Ñ&Ó(Ò,HÒHÐHÐHà—7‘7Ø˜E�NØØØ!ð	 ó 
ˆð ×Ñ×&Ñ&Ó(Ò,HÒHÐHÐHà—7‘7Ø˜E�NØ˜S�zØØ!ð	 ó 
ˆô à�r˜%‘y×'Ñ'Ó)¨AÑ-Ø�r˜%‘y×'Ñ'Ó)¨AÑ-Ø˜3˜% "™*¨ u¨r¡zÑ1Ø˜R ™WŸ^™^Ó-°°3±·±Ó0@Ñ@ð	ð ˜E 8¨ZÐ8ô
ˆ
ô 	×Ñ˜h¨
Ô3à�w‰w‹yˆØ!ˆ�‰ÔØ—9‘9“;ˆØ×Ñ×&Ñ&Ó(¨U°GÐ,<Ò<Ð<Ñ<r$   rJ   r.   c                 ój   — |j                  |¬«      }|j                  j                  «       ddgk(  sJ ‚y )NrI   r.   r>   r?   )rA   rJ   r1   r!   s       r"   Útest_col_levelzTestMelt.test_col_level  s2   € à�h‰h ˆhÓ+ˆØ�{‰{×!Ñ!Ó#¨¨wÐ'7Ò7Ð7Ñ7r$   c                 óf   — |j                  «       }|j                  j                  «       g d¢k(  sJ ‚y )N)r.   r/   r>   r?   )rA   r1   r!   s      r"   Útest_multiindexzTestMelt.test_multiindex  s)   € Ø�h‰h‹jˆØ�{‰{×!Ñ!Ó#Ò'>Ò>Ð>Ñ>r$   ÚcolÚ2010é   z
US/Pacific)r   Útz)ra   rb   Úcra   ÚdÚcategoryr   )r   rf   r   r   r   c                 óˆ  — t        t        d«      |g d¢|dœ«      }t        j                  t        j                  g d¢«      |gd¬«      }t        |ddgdd	¬
«      }t        t        t        d«      «      dz  t        j                  |gdz  d¬«      dgdz  dgdz  z   |dœ«      }g d¢|_        t        j                  ||«       y )Nr™   )rf   r   r   r   r   )Úklassr—   Úattr1Úattr2T©Úignore_indexrŸ   r—   Ú	attributer>   r…   r
   r    r¡   ©r   rf   r
   é   )rŸ   r—   r¤   r>   )
r   ÚrangeÚpdÚconcatÚSeriesr   r   r   rK   rL   )rA   r—   r#   Úexpected_valuerB   r]   s         r"   Útest_pandas_dtypeszTestMelt.test_pandas_dtypes  s¾   € ô Ü˜A“h s²_ÈsÑSó
ˆô Ÿ™¤B§I¡IªoÓ$>ÀÐ#DÐSWÔXˆÜØ˜ %Ð(°;È7ô
ˆô äœ˜a›“> AÑ%Ü—9‘9˜c˜U Q™Y°TÔ:Ø�9˜q‘= G 9¨q¡=Ñ0Ø!ñ	ó
ˆò BˆÔÜ
×Ñ˜f hÕ/r$   c                 óè   — t        ddgt        j                  ddg«      dœ«      }t        |dgdg«      }t        t        j                  ddg«      ddgddgdœ«      }t	        j
                  ||«       y )	Nrf   r
   ÚXÚYr\   r   r   )r   r=   r>   )r   r¨   ÚCategoricalr   rK   rL   )rA   ÚdatarB   r]   s       r"   Útest_preserve_categoryzTestMelt.test_preserve_category;  sq   € ä  1˜v¬B¯N©N¸CÀ¸:Ó,FÑGÓHˆÜ�d˜S˜E C 5Ó)ˆÜÜ—.‘. # s Ó,¸3À¸*ÐPQÐSTÈvÑVó
ˆô 	×Ñ˜f hÕ/r$   c                 óœ  — t        t        j                  j                  d«      j	                  d«      t        d«      ¬«      }d}t        j                  t        |¬«      5  |j                  ddgd	d
g«       d d d «       t        j                  t        |¬«      5  |j                  ddgdd
g«       d d d «       t        j                  t        |¬«      5  |j                  g d¢dd
g«       d d d «       |j                  «       }t        d«      t        d«      g|_        t        j                  t        |¬«      5  |j                  dgdg«       d d d «       t        j                  t        |¬«      5  |j                  dgdgd¬«       d d d «       y # 1 sw Y   �ŒxY w# 1 sw Y   ŒîxY w# 1 sw Y   ŒÀxY w# 1 sw Y   ŒixY w# 1 sw Y   y xY w)Nr
   )r™   r   ÚabcdrT   zEThe following id_vars or value_vars are not present in the DataFrame:rj   ra   rb   ÚCrœ   r   r›   )ra   rb   Únot_hereÚor_therer   )ÚEra   rc   ÚFr   rI   )r   r   r   r   r   r   rl   rm   ÚKeyErrorr   rˆ   r   )rA   r#   ro   Úmultis       r"   Ú test_melt_missing_columns_raisesz)TestMelt.test_melt_missing_columns_raisesE  s…  € ô Ü�I‰I×!Ñ! !Ó$×4Ñ4°VÓ<ÄdÈ6Ãlô
ˆð
 VˆÜ�]‰]œ8¨3Ô/ñ 	,Ø�G‰G�S˜#�J  c 
Ô+÷	,ô �]‰]œ8¨3Ô/ñ 	,Ø�G‰G�S˜#�J  c 
Ô+÷	,ô �]‰]ÜØô
ñ 	Dð �G‰GÒ6¸¸c¸
ÔC÷		Dð —‘“	ˆÜ˜f›¤t¨F£|Ð4ˆŒÜ�]‰]œ8¨3Ô/ñ 	3Ø�J‰J˜
�| j \Ô2÷	3ô �]‰]œ8¨3Ô/ñ 	2Ø�J‰J˜�u˜s˜e¨qˆJÔ1÷	2ð 	2÷)	,ñ 	,ú÷	,ð 	,ú÷	Dð 	Dú÷	3ð 	3ú÷	2ð 	2ús<   Á FÂFÃF*Ä9F6Å1GÆFÆF'Æ*F3Æ6F?ÇGc                 óÂ   — t        dgdgdgdgdœ«      }t        |ddgdd	g¬
«      }t        dgdz  dgdz  t        d«      ddgdœ«      }t        j                  ||«       y )Nr‡   Úbarrf   r
   )r   ra   rb   rœ   r   ra   rb   rœ   rE   Úbd)r   ra   r=   r>   )r   r   r   rK   rL   ©rA   r#   rB   r]   s       r"   Útest_melt_mixed_int_str_id_varsz(TestMelt.test_melt_mixed_int_str_id_varsh  sr   € ä˜E˜7¨%¨¸°sÀ!ÀÑEÓFˆÜ�b 1 c (¸¸S°zÔBˆÜØ�˜!‘ 5 '¨A¡+¼4À»:ÐQRÐTUÐPVÑWó
ˆô 	×Ñ˜f hÕ/r$   c                 ó’   — t        dgdgdœ«      }t        |ddg¬«      }t        ddgddgdœ«      }t        j                  ||«       y )Nr‡   r¾   )r   ra   r   ra   )rG   ©r=   r>   ©r   r   rK   rL   rÀ   s       r"   Ú"test_melt_mixed_int_str_value_varsz+TestMelt.test_melt_mixed_int_str_value_varsq  sL   € ä˜E˜7¨%¨Ñ1Ó2ˆÜ�b a¨ XÔ.ˆÜ¨1¨c¨(¸eÀU¸^ÑLÓMˆÜ
×Ñ˜f hÕ/r$   c                 óœ   — t        dgdgdœdg¬«      }t        |d¬«      }t        dd	gddgd
œddg¬«      }t        j                  ||«       y )Nr   rf   ©r‡   r¾   Úfirst©r   Fr¢   r‡   r¾   rÃ   rÄ   rÀ   s       r"   Útest_ignore_indexzTestMelt.test_ignore_indexx  sX   € ä ˜s¨A¨3Ñ/¸°yÔAˆÜ�b uÔ-ˆÜØ ˜°1°a°&Ñ9À'È7ÐASô
ˆô 	×Ñ˜f hÕ/r$   c                 óF  — t         j                  j                  ddgddg¬«      }t        ddgdd	gd
œ|¬«      }t	        |d¬«      }t         j                  j                  ddgdz  ddg¬«      }t        dgdz  dgdz  z   g d¢dœ|¬«      }t        j                  ||«       y )N)rÈ   Úsecond)rÈ   ÚthirdÚbazÚfoobar)r0   r   rf   r
   r¦   rÇ   rÉ   Fr¢   r‡   r¾   r¥   rÃ   )r¨   Ú
MultiIndexÚfrom_tuplesr   r   rK   rL   ©rA   r   r#   rB   Úexpected_indexr]   s         r"   Útest_ignore_multiindexzTestMelt.test_ignore_multiindex�  sº   € ä—‘×)Ñ)Ø Ð"4Ð5¸eÀXÐ=Nð *ó 
ˆô   1˜v¨q°!¨fÑ5¸UÔCˆÜ�b uÔ-ˆäŸ™×2Ñ2Ø Ð"4Ð5¸Ñ9À%ÈÐARð 3ó 
ˆô Ø˜ 1™¨ w°¡{Ñ2º\ÑJØ ô
ˆô
 	×Ñ˜f hÕ/r$   c                 óà   — t        ddgdd¬«      }t        ddgdd	gd
œ|¬«      }t        |d¬«      }t        ddgdz  dd¬«      }t        g d¢g d¢dœ|¬«      }t        j                  ||«       y )Nr‡   r¾   r�   rÎ   )r   r‰   r   rf   r
   r¦   )ÚxÚyrÉ   Fr¢   )rÖ   rÖ   r×   r×   r¥   rÃ   )r   r   r   rK   rL   rÒ   s         r"   Útest_ignore_index_name_and_typez(TestMelt.test_ignore_index_name_and_type“  sw   € ä�u˜e�n¨J¸UÔCˆÜ˜a ˜V¨1¨a¨&Ñ1¸Ô?ˆÜ�b uÔ-ˆä  u˜~°Ñ1¸È%ÔPˆÜÚ-ºÑEØ ô
ˆô
 	×Ñ˜f hÕ/r$   c                 ó¨   — t        g d¢gg d¢¬«      }|j                  dgdg¬«      }t        g d¢g d¢gg d	¢¬«      }t        j                  ||«       y )
N)Úidr
   r¦   )ra   rb   rb   rT   ra   rb   rE   )rÚ   rb   r
   )rÚ   rb   r¦   )ra   r=   r>   rÄ   rÀ   s       r"   Ú test_melt_with_duplicate_columnsz)TestMelt.test_melt_with_duplicate_columns¡  sM   € äš�~ªÔ?ˆØ—‘ # °C°5�Ó9ˆÜÚš^Ð,Ò6Pô
ˆô 	×Ñ˜f hÕ/r$   r   ÚInt8ÚInt64c                 ó  — t        t        j                  ddgd¬«      t        j                  ddg|¬«      dœ«      }|j                  «       }t        g d¢t        j                  g d	¢|¬«      d
œ«      }t	        j
                  ||«       y )Nrf   r
   rÜ   r   r¦   r   ©ra   rb   )ra   ra   rb   rb   )rf   r
   r¦   r   rÃ   )r   r¨   rª   r   rK   rL   )rA   r   r#   rB   r]   s        r"   Útest_melt_ea_dtypezTestMelt.test_melt_ea_dtypeª  sv   € ô ä—Y‘Y  1˜v¨VÔ4Ü—Y‘Y  1˜v¨UÔ3ñó
ˆð —‘“ˆÜâ0ÜŸ™¢<°uÔ=ñó
ˆô 	×Ñ˜f hÕ/r$   c                 ó6  — t        ddddœddddœdd	d
dœdœ«      }|j                  j                  d«      |_        |j                  dgdg¬«      }t        t	        d«      t        j                  dgdz  d¬«      g d¢dœ«      }t        j                  ||«       y )Nra   rb   r›   re   rf   r¦   r™   r
   r   é   )r   r   rµ   zstring[python]r   r   rE   r-   r   )rf   r¦   r™   )r   r=   r>   )	r   r   r   r   r   r¨   rª   rK   rL   rÀ   s       r"   Útest_melt_ea_columnszTestMelt.test_melt_ea_columns¼  sž   € äà ¨Ñ-Ø˜q QÑ'Ø˜q QÑ'ñó
ˆð —Z‘Z×&Ñ&Ð'7Ó8ˆŒ
Ø—‘ # °C°5�Ó9ˆÜä˜%“[ÜŸI™I s e¨a¡iÐ7GÔHÚ"ñó
ˆô 	×Ñ˜f hÕ/r$   c                 ó  — t        dt        j                  dd¬«      t        j                  dd¬«      dœdt        j                  dd¬«      t        j                  dd¬«      dœgd	d
g¬«      }|j                  dgddgdd¬«      }t        dddddœdddddœt        j                  dd¬«      t        j                  dd¬«      t        j                  dd¬«      t        j                  dd¬«      dœdœ«      }t	        j
                  ||«       y )NÚA0z
2023/03/01z
Asia/Tokyo)rš   z
2023/03/10)ÚtypeÚ
start_dateÚend_dateÚA1z
2023/03/11ÚaaaaÚbbbb©r±   r   ræ   rç   rè   ú	start/endÚdater†   r¥   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   r¨   Ú	Timestampr   rK   rL   rÀ   s       r"   Útest_melt_preserves_datetimez%TestMelt.test_melt_preserves_datetimeÐ  s  € Üð !Ü"$§,¡,¨|ÀÔ"MÜ "§¡¨\¸lÔ Kñð !Ü"$§,¡,¨|ÀÔ"MÜ "§¡¨\¸lÔ Kñðð ˜6Ð"ô
ˆð —‘Ø�HØ$ jÐ1Ø Øð	 ó 
ˆô à  T¨d°tÑ<à#Ø#Ø!Ø!ñ	ô —|‘|Ð$>À<ÔPÜ—|‘|Ð$>À<ÔPÜ—|‘|Ð$>À<ÔPÜ—|‘|Ð$>À<ÔPñ	ñó
ˆô" 	×Ñ˜f hÕ/r$   c                 ó²   — t        g d¢g d¢dœg d¢¬«      }|j                  ddd¬	«      }t        g d¢d
gdz  g d¢dœ«      }t        j                  ||«       y ©N©rf   r
   r¦   ©r   r™   râ   rß   ©Ú11Ú22Ú33rì   ra   r   rf   r…   rb   r¦   )ra   r   rf   rÄ   rÀ   s       r"   Ú#test_melt_allows_non_scalar_id_varsz,TestMelt.test_melt_allows_non_scalar_id_varsù  s^   € ÜÚ ¢yÑ1Ú$ô
ˆð —‘ØØØð ó 
ˆô
 ¢9°#°¸±ºyÑIÓJˆÜ
×Ñ˜f hÕ/r$   c                 ó´   — t        g d¢g d¢dœg d¢¬«      }|j                  dgdd¬	«      }t        g d¢d
gdz  g d¢dœ«      }t        j                  ||«       y rò   rÄ   rÀ   s       r"   Ú$test_melt_allows_non_string_var_namez-TestMelt.test_melt_allows_non_string_var_name  s`   € ÜÚ ¢yÑ1Ú$ô
ˆð —‘Ø�EØØð ó 
ˆô
 ¢9°#°¸±ºyÑIÓJˆÜ
×Ñ˜f hÕ/r$   c                 ó¼   — t        g d¢g d¢dœg d¢¬«      }t        j                  t        d¬«      5  |j	                  dgd	d
g¬«       d d d «       y # 1 sw Y   y xY w)Nró   rô   rß   rõ   rì   z.* must be a scalar.rj   ra   rf   r
   rr   )r   rl   rm   rn   r   ©rA   r#   s     r"   Ú$test_melt_non_scalar_var_name_raisesz-TestMelt.test_melt_non_scalar_var_name_raises  sS   € ÜÚ ¢yÑ1Ú$ô
ˆô �]‰]œ:Ð-DÔEñ 	4Ø�G‰G˜S˜E¨Q°¨FˆGÔ3÷	4÷ 	4ñ 	4ús   ²AÁAN)*Ú__name__Ú
__module__Ú__qualname__rC   rM   rR   rY   rl   ÚmarkÚparametrizeÚtupler   r   Úarrayr^   rd   r   rh   rp   rz   rƒ   r’   r”   r–   r¨   rª   r   r¬   r²   r¼   rÁ   rÅ   rÊ   rÔ   rØ   rÛ   rà   rã   rð   rù   rû   rþ   r4   r$   r"   r;   r;   6   sJ  „ ò@òMòOò2ð  ‡[�[×Ñ˜W u¨d°B·H±HÐ&=Ó>ñ0ó ?ð0ò0ð ‡[�[×ÑØ2ð �Ø�ØÙà!)¨i¸IÑFØ#&¨3°3Ñ7Ø%.°8ÀÑ!Hñóð	ð �Ø�ØÙà!)¨i¸IÑFØ#&¨3°3Ñ7Ø%.°8ÀÑ!Hñóð	ð	
óñ:0ó;ð:0ð ‡[�[×ÑØà˜*˜Ð&Øˆ\˜:Ð&Ø˜Ð$ð	
óñ=óð=ò2ò64ò:(=ðT ‡[�[×Ñ˜[¨1¨e¨*Ó5ñ8ó 6ð8ò?ð ‡[�[×ÑØàˆB�I‰I‘j °°|ÔDÓEØˆB�I‰IÒ/°zÔBØˆB�I‰I’oÓ&ð	
óñ0óð0ò(0ò!2òF0ò0ò0ò0ò$0ò0ð ‡[�[×Ñ˜W v¨wÐ&7Ó8ñ0ó 9ð0ò"0ò('0òR0ò0ó4r$   r;   c                   ó   — e Zd Zd„ Zy)ÚTestLreshapec                 óÌ  — 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        |«      }t        dd«      D �cg c]  }d|d›�‘Œ
 c}t        dd«      D �cg c]  }d|d›�‘Œ
 c}dœ}t	        ||«      }g d¢g d¢g d¢g d¢g d ¢g d!¢d"œ}t        ||j
                  ¬#«      }t        j                  ||«       t	        ||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
                  ¬#«      }t        j                  ||«       t        dd3«      D �cg c]  }d|d›�‘Œ
 c}t        dd«      D �cg c]  }d|d›�‘Œ
 c}dœ}d4}t        j                  t        |¬5«      5  t	        ||«       d d d «       y c c}w c c}w c c}w c c}w # 1 sw Y   y xY w)6N)Ú	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Úwt3rf   r   Úvisitdtrœ   Úwt)r5  r6  )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.  r5  r6  rT   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  r7  r8  r9  r:  r¦   z$All column lists must be same lengthrj   )r   Únanr   r§   r   r   rK   rL   rl   rm   rn   )	rA   r±   r#   ÚiÚspecrB   Úexp_dataÚexpro   s	            r"   Ú
test_pairszTestLreshape.test_pairs  sr  € òò 6Ú+ÚCòð %¤b§f¡f¨k¸;ÈÐTØ$¤b§f¡f¬b¯f©f°kÀ;ÐOÚ1ØœBŸF™F F¨F°FÐ;ØœBŸF™F¤B§F¡F¨F°FÐ;ñ-
ˆô2 �t‹_ˆô 27°q¸!³Ö=¨A˜' ! A šÒ=Ü',¨Q°£{Ö3 !�R˜˜!�u’:Ò3ñ
ˆô ˜"˜dÓ#ˆòòò OòòòñuH
ˆôR ˜¨&¯.©.Ô9ˆÜ
×Ñ˜f cÔ*ä˜"˜d¨5Ô1ˆòò"ò"ò"ð$ ØØØØØÜ—‘ØØØØÜ—‘Ü—‘ØØðð$ ØØØØØÜ—‘ØØØØÜ—‘Ü—‘ØØðñmg
ˆôP ˜¨&¯.©.Ô9ˆÜ
×Ñ˜f cÔ*ô 27°q¸!³Ö=¨A˜' ! A šÒ=Ü',¨Q°£{Ö3 !�R˜˜!�u’:Ò3ñ
ˆð 5ˆÜ�]‰]œ:¨SÔ1ñ 	Ü�R˜Ô÷	ð 	ùòE >ùÚ3ùòz >ùÚ3÷	ð 	ús$   ÂIÂ8IÇ$IÈIÈ0IÉI#N)rÿ   r   r  rA  r4   r$   r"   r  r    s   „ ó`r$   r  c                   óÀ   — e Zd Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Z	d„ Z
d	„ Zd
„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zej,                  j/                  dddg«      d„ «       Zy)ÚTestWideToLongc                 óê  — t         j                  j                  d«      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<   |j                  «       |j                  «       z   g d¢g d¢g d¢g d¢dœ}t	        |«      }|j                  ddg«      g d¢   }t        |ddgdd¬«      }t        j                  ||«       y )Nr
   r¦   ra   rb   r›   re   rœ   ÚeÚfç      @ç333333ó?çffffffæ?çš™™™™™	@çÍÌÌÌÌÌô?çš™™™™™¹?)ÚA1970ÚA1980ÚB1970ÚB1980r®   rÚ   ©ra   rb   r›   rœ   rE  rF  ©rG  rH  rI  rJ  rK  rL  ©é²  rT  rT  é¼  rU  rU  ©r   rf   r
   r   rf   r
   ©r®   r   r   ÚyearrÚ   rX  ©r®   r   r   r   r   ©r=  Új©r   r   r   r   r   ÚdictÚzipr§   r   r@   Ú	set_indexr   rK   rL   ©rA   rÖ   r#   r?  r]   rB   s         r"   Útest_simplezTestWideToLong.test_simple  sê   € Ü�I‰I×!Ñ! !Ó$×4Ñ4°QÓ7ˆÜà  S¨SÑ1Ø  S¨SÑ1Ø  S¨SÑ1Ø  S¨SÑ1Üœ#œe A›h¨Ó*Ó+ñó
ˆð —8‘8ˆˆ4‰à—‘“˜aŸh™h›jÑ(Ú/Ú/Ú8Ú$ñ
ˆô ˜XÓ&ˆØ×%Ñ% t¨V nÓ5²oÑFˆÜ˜b 3¨ *°¸Ô?ˆÜ
×Ñ˜f hÕ/r$   c                 óp   — t        g d¢g d¢g«      }g d¢|_        ddg}t        ||dd¬«       |ddgk(  sJ ‚y )	N)r   rf   r
   r¦   é   )r   r™   râ   é   é	   )rÚ   Úinc1Úinc2Úedu1Úedu2ÚincÚedurÚ   ÚagerZ  )r   r   r   )rA   r#   Ústubss      r"   Ú
test_stubszTestWideToLong.test_stubs  sA   € äšªÐ9Ó:ˆÚ;ˆŒ
Ø˜�ˆä�R˜ $¨%Õ0à˜ ˜Ò&Ð&Ñ&r$   c                 óì  — t         j                  j                  d«      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<   |j                  «       |j                  «       z   g d¢g d¢g d¢g d¢dœ}t	        |«      }|j                  ddg«      g d¢   }t        |ddgddd¬«      }t        j                  ||«       y )Nr
   r¦   ra   rb   r›   re   rœ   rE  rF  rG  rH  rI  rJ  rK  rL  )zA.1970zA.1980zB.1970zB.1980r®   rÚ   rQ  rR  rS  rV  rW  rX  rY  r   r   ú.©r=  r[  Úsepr\  r`  s         r"   Útest_separating_characterz(TestWideToLong.test_separating_character#  sî   € ô �I‰I×!Ñ! !Ó$×4Ñ4°QÓ7ˆÜà! c¨cÑ2Ø! c¨cÑ2Ø! c¨cÑ2Ø! c¨cÑ2Üœ#œe A›h¨Ó*Ó+ñó
ˆð —8‘8ˆˆ4‰à—‘“˜aŸh™h›jÑ(Ú/Ú/Ú8Ú$ñ
ˆô ˜XÓ&ˆØ×%Ñ% t¨V nÓ5²oÑFˆÜ˜b 3¨ *°¸ÀCÔHˆÜ
×Ñ˜f hÕ/r$   c                 óê  — t         j                  j                  d«      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<   |j                  «       |j                  «       z   g d¢g d¢g d¢g d¢dœ}t	        |«      }|j                  ddg«      g d¢   }t        |ddgdd¬«      }t        j                  ||«       y )Nr
   r¦   ra   rb   r›   re   rœ   rE  rF  rG  rH  rI  rJ  rK  rL  )zA(quarterly)1970zA(quarterly)1980zB(quarterly)1970zB(quarterly)1980r®   rÚ   rQ  rR  rS  rV  )r®   úA(quarterly)úB(quarterly)rX  rÚ   rX  )r®   ru  rv  ru  rv  rZ  r\  r`  s         r"   Útest_escapable_charactersz(TestWideToLong.test_escapable_characters=  sð   € Ü�I‰I×!Ñ! !Ó$×4Ñ4°QÓ7ˆÜà(+°¸Ñ$<Ø(+°¸Ñ$<Ø(+°¸Ñ$<Ø(+°¸Ñ$<Üœ#œe A›h¨Ó*Ó+ñó
ˆð —8‘8ˆˆ4‰à—‘“˜aŸh™h›jÑ(Ú:Ú:Ú8Ú$ñ
ˆô ˜XÓ&ˆØ×%Ñ% t¨V nÓ5Ú1ñ
ˆô ˜b >°>Ð"BÀdÈfÔUˆÜ
×Ñ˜f hÕ/r$   c                 óF  — 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        |«      }|j	                  d
dg«      g d¢   }t        |ddgd
d¬«      }t        j                  ||«       y )Nç      ð?ç       @ç      @ç      @ç      @ç      @ÚX1ÚX2©ÚA2010ÚA2011ÚB2010r®   rÚ   ©r  r€  r  r€  ©ry  rz  r{  r|  )r   rf   r   rf   )éÚ  r‡  éÛ  rˆ  )r®   r   r   rÚ   rX  rX  rY  r   r   rZ  )r   r   r   r<  r_  r   rK   rL   ©rA   r#   r?  r]   rB   s        r"   Útest_unbalancedzTestWideToLong.test_unbalancedW  s¬   € äà˜s˜Ø˜s˜Ø˜s˜Ø˜D�\ñ	ó
ˆð —8‘8ˆˆ4‰â)Ú%Ø�sœBŸF™F¤B§F¡FÐ+ÚÚ,ñ
ˆô ˜XÓ&ˆØ×%Ñ% t¨V nÓ5²oÑFˆÜ˜b 3¨ *°¸Ô?ˆÜ
×Ñ˜f hÕ/r$   c                 ój  — 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œ«      }|j                  d	dg«      g d¢   }t        |g d¢d	d¬«      }t	        j
                  |j                  d¬«      |j                  d¬«      «       y )N©Úa11Úa22Úa33©Úa21rŽ  Úa23©Úb11Úb12Úb13©Úb21Úb22Úb23ró   rô   ©é[   é\   é]   )ÚA11ÚA12ÚB11ÚB12ÚBB11ÚBB12ÚBBBXÚBBBZrÚ   ©rœ  r�  rž  rœ  r�  rž  ©r�  rŽ  r�  r‘  rŽ  r’  ©r”  r•  r–  r˜  r™  rš  ©rf   r
   r¦   r   r™   râ   rV  ©é   r¬  r¬  é   r­  r­  )r¥  r¦  r   r   ÚBBrÚ   rX  rX  )r¥  r¦  r   r   r®  ©r   r   r®  rZ  rf   ©Úaxis©r   r   r_  r   rK   rL   Ú
sort_index©rA   r#   r]   rB   s       r"   Útest_character_overlapz%TestWideToLong.test_character_overlapn  s¶   € äâ,Ú,Ú,Ú,Ú!Ú!Ú$Ú$ñ	ó
ˆð —8‘8ˆˆ4‰Üâ0Ú0Ú?Ú?Ú(Ú(Ú0ñó

ˆð ×%Ñ% t¨V nÓ5Ò6VÑWˆÜ˜bÒ"2°d¸fÔEˆÜ
×Ñ˜f×/Ñ/°QÐ/Ó7¸×9LÑ9LÐRSÐ9LÓ9TÕUr$   c           	      óÈ  — 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        |«      j                  dt        j                  i«      }|j                  ddg«      g d¢   }|j                  j                  ddgd¬«      |_        t        |ddgdd|¬«      }t        j                  |j                  d¬«      |j                  d¬«      «       y )Nznope!ry  rz  r{  r|  r}  r~  r  r€  r�  rÚ   Ú )r®   r‚  rƒ  r„  rÚ   rX  r   r   rX  )r®   r‚  rƒ  r„  r   r   r   rf   ©Úlevelr   r   rq  r°  ©r   r   r   r   r   r_  Ú
set_levelsr   rK   rL   r³  )rA   rr  r#   r?  r]   rB   s         r"   Útest_invalid_separatorz%TestWideToLong.test_invalid_separatorŒ  s   € àˆÜà˜s˜Ø˜s˜Ø˜s˜Ø˜D�\ñ	ó
ˆð —8‘8ˆˆ4‰àØØØØØØØñ	
ˆô ˜XÓ&×-Ñ-¨v´r·x±xÐ.@ÓAˆØ×%Ñ% t¨V nÓ5Ú6ñ
ˆð "Ÿ™×2Ñ2°A°q°6ÀÐ2ÓCˆŒÜ˜b 3¨ *°¸ÀCÔHˆÜ
×Ñ˜f×/Ñ/°QÐ/Ó7¸×9LÑ9LÐRSÐ9LÓ9TÕUr$   c                 ój  — 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œ«      }|j                  d	dg«      g d¢   }t        |g d¢d	d¬«      }t	        j
                  |j                  d¬«      |j                  d¬«      «       y )NrŒ  r�  r“  r—  ró   rô   r›  )rŸ  r   r¡  r¢  r£  r¤  ÚAratingÚArating_oldrÚ   r§  r¨  r©  rª  rV  r«  )r¾  r¿  r   r   r®  rÚ   rX  rX  )r¾  r¿  r   r   r®  r¯  rZ  rf   r°  r²  r´  s       r"   Útest_num_string_disambiguationz-TestWideToLong.test_num_string_disambiguationª  s¼   € ô â,Ú,Ú,Ú,Ú!Ú!Ú'Ú+ñ	ó
ˆð —8‘8ˆˆ4‰Üâ3Ú7Ú?Ú?Ú(Ú(Ú0ñó

ˆð ×%Ñ% t¨V nÓ5Ú6ñ
ˆô ˜bÒ"2°d¸fÔEˆÜ
×Ñ˜f×/Ñ/°QÐ/Ó7¸×9LÑ9LÐRSÐ9LÓ9TÕUr$   c           	      ó¸  — 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        |«      j                  dt        j                  i«      }|j                  d
dg«      }|j                  j                  ddgd¬«      |_        t        |ddgd
d¬«      }t        j                  |j                  d¬«      |j                  d¬«      «       y )Nry  rz  r{  r|  r}  r~  r  r€  )ÚAoneÚAtwoÚBoner®   rÚ   r·  )r®   rÂ  rÃ  rÄ  rÚ   rX  r   r   rX  r   rf   r¸  r   r   rZ  r°  rº  r‰  s        r"   Útest_invalid_suffixtypez&TestWideToLong.test_invalid_suffixtypeË  sñ   € ô à˜c˜
Ø˜c˜
Ø˜c˜
Ø˜D�\ñ	ó
ˆð —8‘8ˆˆ4‰àØØØØØØØñ	
ˆô ˜XÓ&×-Ñ-¨v´r·x±xÐ.@ÓAˆà×%Ñ% t¨V nÓ5ˆØ!Ÿ™×2Ñ2°A°q°6ÀÐ2ÓCˆŒÜ˜b 3¨ *°¸Ô?ˆÜ
×Ñ˜f×/Ñ/°QÐ/Ó7¸×9LÑ9LÐRSÐ9LÓ9TÕUr$   c                 óà   — t        g d¢g d¢g d¢g d¢dœ«      }t        g d¢g d¢g d¢g d	¢d
œ«      }|j                  g d¢«      dg   }t        |dddgd¬«      }t        j                  ||«       y )N)	rf   rf   rf   r
   r
   r
   r¦   r¦   r¦   )	rf   r
   r¦   rf   r
   r¦   rf   r
   r¦   )	çffffff@ç333333@çš™™™™™@r
   çÍÌÌÌÌÌü?çffffffþ?rÉ  çffffff@çÍÌÌÌÌÌ @)	ç333333@çffffff@rÈ  rJ  rÇ  ç333333@çffffff
@rÎ  rÈ  )ÚfamidÚbirthÚht1Úht2)rÇ  rÎ  rÈ  rÏ  rÉ  rÈ  rz  rJ  rÊ  rÇ  rË  rÐ  rÉ  rÑ  rÌ  rÎ  rÍ  rÈ  )rf   rf   rf   rf   rf   rf   r
   r
   r
   r
   r
   r
   r¦   r¦   r¦   r¦   r¦   r¦   )rf   rf   r
   r
   r¦   r¦   rf   rf   r
   r
   r¦   r¦   rf   rf   r
   r
   r¦   r¦   )rf   r
   rf   r
   rf   r
   rf   r
   rf   r
   rf   r
   rf   r
   rf   r
   rf   r
   )ÚhtrÒ  rÓ  rl  )rÒ  rÓ  rl  rÖ  rÒ  rÓ  rl  rZ  ©r   r_  r   rK   rL   r´  s       r"   Útest_multiple_id_columnsz'TestWideToLong.test_multiple_id_columnsè  s~   € äâ4Ú4ÚBÚDñ	ó
ˆô òò( PÚOÚMñ/ó
ˆð6 ×%Ñ%Ò&?Ó@À$ÀÑHˆÜ˜b $¨7°GÐ*<ÀÔFˆÜ
×Ñ˜f hÕ/r$   c                 ó´   — t        g d¢g d¢g d¢dœ«      }d}t        j                  t        |¬«      5  t	        |ddgdd	¬
«       d d d «       y # 1 sw Y   y xY w)N)rf   r
   r¦   r   r™   )rf   rf   rf   rf   rf   )ÚA_A1ÚB_B1rÖ   z3the id variables need to uniquely identify each rowrj   ÚA_AÚB_BrÖ   ÚcolnamerZ  ©r   rl   rm   rn   r   ©rA   r#   ro   s      r"   Útest_non_unique_idvarsz%TestWideToLong.test_non_unique_idvars  sY   € ô Ú$ªoÂOÑTó
ˆð DˆÜ�]‰]œ:¨SÔ1ñ 	AÜ˜˜e U˜^¨s°iÕ@÷	A÷ 	Añ 	Aús   ³AÁAc                 óÜ   — t        g d¢g d¢g d¢g d¢g d¢dœ«      }t        g d¢g d¢g d	¢g d
¢dœ«      j                  ddg«      }t        |ddgddd¬«      }t        j                  ||«       y )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î  )rf   rf   rf   r
   r
   r
   )rï  rð  rñ  rï  rð  rñ  )ÚactorÚactor_fb_likesÚnumrö  rö  rù  r÷  rø  Ú_rq  r×  r´  s       r"   Útest_cast_j_intzTestWideToLong.test_cast_j_int  s‡   € ÜâLÚPÚ$>Ú$:ÚJñó
ˆô òò #SÚ)òñó
÷* ‰)�W˜eÐ$Ó
%ð+ 	ô, Ø�Ð*Ð+¨w¸%ÀSô
ˆô 	×Ñ˜f hÕ/r$   c                 óº   — t        ddgddgddgddgd	œ«      }d
}t        j                  t        |¬«      5  t	        |ddgdd¬«       d d d «       y # 1 sw Y   y xY w)Nry  rz  r{  r|  r}  r~  r  r€  )r‚  rƒ  r„  r   z,stubname can't be identical to a column namerj   r   r   rÞ  rZ  rß  rà  s      r"   Útest_identical_stubnamesz'TestWideToLong.test_identical_stubnamesB  si   € Üà˜s˜Ø˜s˜Ø˜s˜Ø˜D�\ñ	ó
ˆð =ˆÜ�]‰]œ:¨SÔ1ñ 	=Ü˜˜c 3˜Z¨3°)Õ<÷	=÷ 	=ñ 	=ús   ¶AÁAc                 ó  — 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œ«      }|j                  ddg«      }t	        |ddgdddd¬«      }t        j                  ||«       y )Nry  rz  r{  r|  r}  r~  r  r€  )Útreatment_placeboÚtreatment_testÚresult_placebor   r…  )Úplacebor  Útestr  r†  ©r   rÞ  rB   Ú	treatmentr   rÞ  rB   r  z[a-z]+rú  ©r=  r[  Úsuffixrr  ©r   r   r<  r_  r   rK   rL   r´  s       r"   Útest_nonnumeric_suffixz%TestWideToLong.test_nonnumeric_suffixO  s¡   € Üà&)¨3 ZØ#&¨ *Ø#&¨ *Ø˜D�\ñ	ó
ˆô â-ÚAØ ¤R§V¡V¬R¯V©VÐ4Ú1ñ	ó
ˆð ×%Ñ% s¨IÐ&6Ó7ˆÜØ�˜;Ð'¨3°)ÀHÐRUô
ˆô 	×Ñ˜f hÕ/r$   c                 óÞ   — 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œ«      j                  ddg«      }t        |ddgdddd¬«      }t        j                  ||«       y )Nr  r€  r   re  r}  r~  ry  rz  r{  r|  )r   Úresult_1Ú
result_fooÚtreatment_1Útreatment_foor…  )Ú1r  r‡   r‡   )ç        ç      "@r}  r~  r†  r  r   rÞ  rB   r  z.+rú  r  r×  r´  s       r"   Útest_mixed_type_suffixz%TestWideToLong.test_mixed_type_suffixf  s•   € Üà˜D�\Ø ˜FØ" C˜jØ # S˜zØ"% s ñó
ˆô â-Ú3Ú.Ú1ñ	ó
÷ ‰)�S˜)Ð$Ó
%ð 	ô Ø�˜;Ð'¨3°)ÀDÈcô
ˆô 	×Ñ˜f hÕ/r$   c                 óÚ  — 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œ«      }|j                  ddg«      }t	        |ddgdddd¬«      }t        j                  ||«       y )Nry  rz  r{  r|  r}  r~  r   re  r  r€  )ztreatment_1.1ztreatment_2.1z
result_1.2r  r   )r  r€  r  r€  r  r€  r  r€  )rH  rH  ry  ry  çš™™™™™ñ?r  rÍ  rÍ  r  r  r  r   rÞ  rB   r  z[0-9.]+rú  r  r  r´  s       r"   Útest_float_suffixz TestWideToLong.test_float_suffix}  sÙ   € Üà"% s Ø"% s Ø" C˜jØ ˜FØ˜D�\ñó
ˆô âEÚCØ  S¨#¬r¯v©v´r·v±v¼r¿v¹vÄrÇvÁvÐNÜ Ÿf™f¤b§f¡f¬b¯f©f´b·f±f¸cÀ3ÈÈSÐQñ	ó
ˆð ×%Ñ% s¨IÐ&6Ó7ˆÜØ�˜;Ð'¨3°)ÀIÐSVô
ˆô 	×Ñ˜f hÕ/r$   c           
      óì   — 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                  |«      }t        |dgddgd¬«      }t        |dddgd¬«      }t        j                  ||«       y )Nr   rf   r
   r¦   r   )r   rf   r
   r¦   r   gš™™™™™é?r  g      Ð?ry  gìQ¸…ëé?g®Gáz®ç?gìQ¸…ëá?g\�Âõ(\ï?g333333ã?g¤p=
×£è?g{®Gázä?g¤p=
×£à?gq=
×£på?gÃõ(\�ÂÕ?rI  )Únode_idr   ÚPA0ÚPA1ÚPA3ÚPAr  r   Útime)Ú	stubnamesr=  r[  )r   Ú	from_dictr   rK   rL   )rA   Ú	wide_dataÚwide_dfr]   rB   s        r"   Útest_col_substring_of_stubnamez-TestWideToLong.test_col_substring_of_stubname•  s    € ð
   q¨Q°1Ñ5Ø˜c d¨s°tÑ<Ø ¨°$¸3Ñ?Ø ¨°$¸4Ñ@Ø ¨°$¸4Ñ@ñ
ˆ	ô ×%Ñ% iÓ0ˆÜ °D°6¸iÈÐ=MÐQWÔXˆÜ˜g°¸)ÀSÐ9IÈVÔTˆÜ
×Ñ˜f hÕ/r$   c                 óô   — t        t        d«      t        ddd«      dœ«      }t        j                  t
        t        j                  d«      ¬«      5  |j                  dd¬	«       d d d «       y # 1 sw Y   y xY w)
Nr,   r   é   r
   )r—   r>   zvalue_name (value) cannot matchrj   r>   r|   )	r   r   r§   rl   rm   rn   ÚreÚescaper   rý   s     r"   Útest_raise_of_column_name_valuez.TestWideToLong.test_raise_of_column_name_value¥  sb   € ô œt E›{´U¸2¸rÀ1Ó5EÑFÓGˆä�]‰]ÜœbŸi™iÐ(IÓJô
ñ 	9ð �G‰G˜G°ˆGÔ8÷	9÷ 	9ñ 	9ús   ÁA.Á.A7r   ÚOÚstringc                 óž  — t        ddgddgddgdœ«      }|j                  d|i«      }t        |d	d
gddd¬«      }t        g d¢d¬«      }t        g d¢t        j
                  gdz  dœ|¬«      }|j                  j                  d   j                  |«      }|j                  j                  |d¬«      |_        t        j                  ||«       y )Nr  Ú2éd   éÈ   é,  é�  )rÚ   za-1za-2rÚ   ra   rb   rù  ú-)r  r=  r[  rr  ))r  rf   )r*  rf   )r  r
   )r*  r
   )rÚ   rù  )r‰   )r+  r,  r-  r.  r   rß   rÉ   r   r¸  )r   r   r   r   r   r<  r   Úlevelsr»  rK   rL   )rA   r   r#   rB   r   r]   Ú	new_levels          r"   Útest_missing_stubnamez$TestWideToLong.test_missing_stubname°  sÏ   € ô ˜s C˜j°#°s°ÀSÈ#ÀJÑOÓPˆØ�Y‰Y˜˜e�}Ó%ˆÜØØ˜C�jØØØô
ˆô Ú4Øô
ˆô Ú&¬b¯f©f¨X¸©\Ñ:Øô
ˆð —N‘N×)Ñ)¨!Ñ,×3Ñ3°EÓ:ˆ	Ø!Ÿ™×2Ñ2°9ÀAÐ2ÓFˆŒÜ
×Ñ˜f hÕ/r$   N)rÿ   r   r  ra  rn  rs  rw  rŠ  rµ  r¼  rÀ  rÅ  rØ  rá  rû  rý  r	  r  r  r!  r&  rl   r  r  r2  r4   r$   r"   rC  rC     s�   „ ò0ò0'ò0ò40ò40ò.Vò<Vò<VòBVò:'0òRAò%0òN=ò0ò.0ò.0ò00ò 	9ð ‡[�[×Ñ˜W s¨H oÓ6ñ0ó 7ñ0r$   rC  )r$  Únumpyr   rl   Úpandasr¨   r   r   r   r   r   r   Úpandas._testingÚ_testingrK   Úfixturer#   r1   r5   r9   r;   r  rC  r4   r$   r"   ú<module>r8     s¦   ðÛ 	ã Û ã ÷÷ õ ð ‡�ñó ðð ‡�ñ
ó ð
ð ‡�ñó ðð ‡�ñó ð÷c4ñ c4÷Lañ a÷HF0ò F0r$   