ó
    ®œ‘h³¦  ã                   ó"  • S SK r S SKrS SKrS SKrS SKJrJrJrJ	r	J
r
Jr  S SKJr  \R                  S 5       r\R                  S 5       r\R                  S 5       r\R                  S 5       r " S S5      r " S	 S
5      r " S S5      rS rg)é    N)Ú	DataFrameÚIndexÚ
date_rangeÚlreshapeÚmeltÚwide_to_longc            
      óJ  • [        [        R                  R                  S5      R	                  S5      [        [        S5      5      [        SSSS9S9n U S	   S
:„  R                  [        R                  5      U S'   U S   S
:„  R                  [        R                  5      U S'   U $ )Né   )é
   é   ÚABCDz
2000-01-01r   ÚB)ÚperiodsÚfreq©ÚcolumnsÚindexÚAr   Úid1Úid2)
r   ÚnpÚrandomÚdefault_rngÚstandard_normalr   Úlistr   ÚastypeÚint64©Úress    ÚbC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/reshape/test_melt.pyÚdfr!      sˆ   € ä
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9Ü”d˜6“lÓ#Ü˜¨r¸Ñ<ñ€Cð
 �c‘(˜Q‘,×&Ñ&¤r§x¡xÓ0€Cˆ�JØ�c‘(˜Q‘,×&Ñ&¤r§x¡xÓ0€Cˆ�JØ€Jó    c                  óŠ   • [        / SQ/ SQ/ SQ/5      n [        S5      [        S5      /U l        SS/U R                  l        U $ )N)ç5ì÷Ä:ñ?çS°ÆÙtÄñ¿gKÔÔ²µÊ?)ç†U¼‘y$õ¿çê> ©Mœ×?g†K®âð¿)çiÿ¬Õé¿ç<Ú8b->µ?ghB“Ä’òë¿ÚABCÚabcÚCAPÚlow)r   r   r   Únamesr   s    r    Údf1r/      sE   € ä
â*Ú,Ú+ð	
ó€Cô ˜“;¤ U£Ð,€C„KØ ˜€C‡K�KÔØ€Jr"   c                  ó   • g)NÚvar© r2   r"   r    Úvar_namer3   ,   ó   € àr"   c                  ó   • g)NÚvalr2   r2   r"   r    Ú
value_namer7   1   r4   r"   c                   óT  • \ rS rSrS rS rS rS r\R                  R                  S\\\R                  45      S 5       rS r\R                  R                  S	S
/S/S\" SSSS.SSSS.SSSS.S.5      4S/S/S\" SSSS.SSSS.SSSS.S.5      4/5      S 5       r\R                  R                  SSS//S/S/SS//5      S 5       rS rS rS  r\R                  R                  S!SS"/5      S# 5       rS$ r\R                  R                  S%\R4                  " \" S&S'S(S)95      \R4                  " / S*QS+S,9\R4                  " / S-Q5      /5      S. 5       rS/ rS0 rS1 rS2 r S3 r!S4 r"S5 r#S6 r$\R                  R                  S7S8S9/5      S: 5       r%S; r&S< r'S= r(S> r)S? r*S@r+gA)BÚTestMelté6   c                 ó^   • [        U5      nUR                  R                  5       SS/:X  d   eg )NÚvariableÚvalue©r   r   Útolist)Úselfr!   Úresults      r    Útest_top_level_methodÚTestMelt.test_top_level_method7   s+   € Ü�b“ˆØ�~‰~×$Ñ$Ó&¨:°wÐ*?Ó?Ð?Ñ?r"   c           	      ó|  • [         R                  " UR                  5       [        U5      5        [         R                  " UR                  SS/SS/S9[        USS/SS/S95        [         R                  " UR                  X4S9[        XUS95        [         R                  " UR                  SS9[        USS95        g )	Nr   r   r   r   ©Úid_varsÚ
value_vars©r3   r7   r   ©Ú	col_level)ÚtmÚassert_frame_equalr   )r@   r!   r/   r3   r7   s        r    Útest_method_signaturesÚ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Ð=Ü�°:Ñ>ô	
ô
 	×Ò˜cŸh™h°˜hÐ3´T¸#ÈÑ5KÕLr"   c                 ó2  • UR                  5       nUR                  R                  5       SS/:X  d   eUR                  S/S9nUR                  R                  5       / SQ:X  d   eUR                  SS/S9nUR                  R                  5       / SQ:X  d   eg )Nr<   r=   r   )rF   )r   r<   r=   r   ©r   r   r<   r=   r>   )r@   r!   rA   Úresult1Úresult2s        r    Útest_default_col_namesÚTestMelt.test_default_col_namesJ   s‹   € Ø—‘“ˆØ�~‰~×$Ñ$Ó&¨:°wÐ*?Ó?Ð?Ð?à—'‘' 5 '�'Ð*ˆØ�‰×%Ñ%Ó'Ò+GÓGÐGÐGà—'‘' 5¨% .�'Ð1ˆØ�‰×%Ñ%Ó'Ò+NÓNÐNÑNr"   c                 óp  • UR                  SS/SS9n[        U5      S:X  d   eUR                  SS/SS/S9n[        US   R                  5       S-  US   R                  5       S-  S/S-  S/S-  -   US   R                  5       US   R                  5       -   S./ SQS	9n[        R
                  " X45        g )
Nr   r   r   rE   r   r   r
   rP   ©r   )r   Úlenr   r?   rK   rL   )r@   r!   Úresult3Úresult4Ú	expected4s        r    Útest_value_varsÚ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Õ1r"   Útype_c                 ó2  • [        US   R                  5       S-  US   R                  5       S-  S/S-  S/S-  -   US   R                  5       US   R                  5       -   S./ SQS9nUR                  SS/U" S	5      S
9n[        R                  " XC5        g )Nr   r
   r   r   r   r   rP   rV   ©r   r   rE   )r   r?   r   rK   rL   )r@   r]   r!   ÚexpectedrA   s        r    Útest_value_vars_typesÚTestMelt.test_value_vars_typesd   sŸ   € ô à˜%‘y×'Ñ'Ó)¨AÑ-Ø˜%‘y×'Ñ'Ó)¨AÑ-Ø ˜E B™J¨#¨°©Ñ3Ø˜S™'Ÿ.™.Ó*¨R°©W¯^©^Ó-=Ñ=ñ	ò 8ñ
ˆð —‘ %¨ ¹EÀ*Ó<M�ÐNˆÜ
×Ò˜fÕ/r"   c                 ó¶   • [        US   S/[        U5      -  S/[        U5      -  US   S./ SQS9nUR                  S/S/S9n[        R                  " X25        g )N©r   Úar   Úb©r   rf   )rd   r,   r-   r=   rV   rE   )r   rW   r   rK   rL   )r@   r/   r`   rA   s       r    Útest_vars_work_with_multiindexÚ'TestMelt.test_vars_work_with_multiindexs   sf   € Üà 
™OØ�uœs 3›xÑ'Ø�uœs 3›xÑ'Ø˜Z™ñ	ò 8ñ
ˆð —‘ : ,¸J¸<�ÐHˆÜ
×Ò˜fÕ/r"   z(id_vars, value_vars, col_level, expectedr   r   r   r$   r&   r(   ©r   é   r
   r%   r'   r)   )r   r,   r=   re   rf   rk   )re   r-   r=   c                 óP   • UR                  XUS9n[        R                  " Xd5        g )NrI   )r   rK   rL   )r@   rF   rG   rJ   r`   r/   rA   s          r    Ú%test_single_vars_work_with_multiindexÚ.TestMelt.test_single_vars_work_with_multiindex�   s%   € ð@ —‘˜'¸�ÐCˆÜ
×Ò˜fÕ/r"   zid_vars, value_varsrd   rg   c                 óŒ   • Sn[         R                  " [        US9   UR                  XS9  S S S 5        g ! , (       d  f       g = f)NzF(id|value)_vars must be a list of tuples when columns are a MultiIndex©ÚmatchrE   )ÚpytestÚraisesÚ
ValueErrorr   )r@   rF   rG   r/   Úmsgs        r    Ú$test_tuple_vars_fail_with_multiindexÚ-TestMelt.test_tuple_vars_fail_with_multiindex¤   s2   € ð XˆÜ�]Š]œ:¨SÓ1Ø�H‰H˜WˆHÑ<÷ 2×1Ö1ús	   œ5µ
Ac                 óÐ  • UR                  US9nUR                  R                  5       SS/:X  d   eUR                  S/US9nUR                  R                  5       / SQ:X  d   eUR                  SS/US9nUR                  R                  5       / SQ:X  d   eUR                  SS/S	US
9nUR                  R                  5       / SQ:X  d   eUR                  SS/S	S/US
9n[        SUS   R                  5       S-  SUS   R                  5       S-  US	/S-  S/S-  -   SUS	   R                  5       US   R                  5       -   0SSUS/S9n[        R
                  " Xx5        g )N)r3   r1   r=   r   ©rF   r3   )r   r1   r=   r   )r   r   r1   r=   r   )rF   rG   r3   r   r
   r   rV   ©r   r   r?   r   rK   rL   )	r@   r!   r3   Úresult5Úresult6Úresult7Úresult8Úresult9Ú	expected9s	            r    Útest_custom_var_nameÚ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Õ1r"   c                 óÎ  • UR                  US9nUR                  R                  5       SS/:X  d   eUR                  S/US9nUR                  R                  5       / SQ:X  d   eUR                  SS/US9nUR                  R                  5       / SQ:X  d   eUR                  SS/S	US
9nUR                  R                  5       / SQ:X  d   eUR                  SS/S	S/US
9n[        SUS   R                  5       S-  SUS   R                  5       S-  SS	/S-  S/S-  -   X!S	   R                  5       US   R                  5       -   0SSSU/S9n[        R
                  " Xx5        g )N)r7   r<   r6   r   ©rF   r7   )r   r<   r6   r   )r   r   r<   r6   r   )rF   rG   r7   r   r
   r   rV   rz   )	r@   r!   r7   Úresult10Úresult11Úresult12Úresult13Úresult14Ú
expected14s	            r    Útest_custom_value_nameÚ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Ø ™WŸ^™^Ó-°°3±·±Ó0@Ñ@ð	ð ˜E :¨zÐ:ñ
ˆ
ô 	×Ò˜hÕ3r"   c                 óv  • UR                  X2S9nUR                  R                  5       SS/:X  d   eUR                  S/X2S9nUR                  R                  5       / SQ:X  d   eUR                  SS/X2S9nUR                  R                  5       / SQ:X  d   eUR                  SS/S	UUS
9nUR                  R                  5       / SQ:X  d   eUR                  SS/S	S/UUS
9n[        SUS   R                  5       S-  SUS   R                  5       S-  US	/S-  S/S-  -   X!S	   R                  5       US   R                  5       -   0SSX2/S9n	[        R
                  " X‰5        UR                  5       n
SU
R                  l        U
R                  5       nUR                  R                  5       SS/:X  d   eg )NrH   r1   r6   r   ©rF   r3   r7   )r   r1   r6   r   )r   r   r1   r6   r   ©rF   rG   r3   r7   r   r
   r   rV   Úfoor=   )r   r   r?   r   rK   rL   ÚcopyÚname)r@   r!   r7   r3   Úresult15Úresult16Úresult17Úresult18Úresult19Ú
expected19Údf20Úresult20s               r    Útest_custom_var_and_value_nameÚ'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Ø ™WŸ^™^Ó-°°3±·±Ó0@Ñ@ð	ð ˜E 8Ð8ñ
ˆ
ô 	×Ò˜hÔ3à�w‰w‹yˆØ!ˆ�‰ÔØ—9‘9“;ˆØ×Ñ×&Ñ&Ó(¨U°GÐ,<Ó<Ð<Ñ<r"   rJ   r,   c                 óf   • UR                  US9nUR                  R                  5       SS/:X  d   eg )NrI   r,   r=   r>   )r@   rJ   r/   r   s       r    Útest_col_levelÚTestMelt.test_col_level  s2   € à�h‰h ˆhÐ+ˆØ�{‰{×!Ñ!Ó#¨¨wÐ'7Ó7Ð7Ñ7r"   c                 óh   • UR                  5       nUR                  R                  5       / SQ:X  d   eg )N)r,   r-   r=   r>   )r@   r/   r   s      r    Útest_multiindexÚTestMelt.test_multiindex  s)   € Ø�h‰h‹jˆØ�{‰{×!Ñ!Ó#Ò'>Ó>Ð>Ñ>r"   ÚcolÚ2010é   z
US/Pacific)r   Útz)re   rf   Úcre   ÚdÚcategory©Údtype)r   rk   r   r   r   c                 ó|  • [        [        S5      U/ SQUS.5      n[        R                  " [        R                  " / SQ5      U/SS9n[        USS/SS	S
9n[        [        [        S5      5      S-  [        R                  " U/S-  SS9S/S-  S/S-  -   US.5      n/ SQUl        [        R                  " XE5        g )Nr¥   )rk   r   r   r   r   )Úklassr£   Úattr1Úattr2T©Úignore_indexr­   r£   Ú	attributer=   rŽ   r
   r®   r¯   ©r   rk   r
   é   )r­   r£   r²   r=   )
r   ÚrangeÚpdÚconcatÚSeriesr   r   r   rK   rL   )r@   r£   r!   Úexpected_valuerA   r`   s         r    Útest_pandas_dtypesÚ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Õ/r"   c                 óì   • [        SS/[        R                  " SS/5      S.5      n[        US/S/5      n[        [        R                  " SS/5      SS/SS/S.5      n[        R
                  " X#5        g )	Nrk   r
   ÚXÚYr_   r   r   )r   r<   r=   )r   r¶   ÚCategoricalr   rK   rL   )r@   ÚdatarA   r`   s       r    Útest_preserve_categoryÚTestMelt.test_preserve_category;  so   € ä  1˜v¬B¯NªN¸CÀ¸:Ó,FÑGÓHˆÜ�d˜S˜E C 5Ó)ˆÜÜ—.’. # s Ó,¸3À¸*ÐPQÐSTÈvÑVó
ˆô 	×Ò˜fÕ/r"   c                 ó®  • [        [        R                  R                  S5      R	                  S5      [        S5      S9nSn[        R                  " [        US9   UR                  SS/S	S
/5        S S S 5        [        R                  " [        US9   UR                  SS/SS
/5        S S S 5        [        R                  " [        US9   UR                  / SQSS
/5        S S S 5        UR                  5       n[        S5      [        S5      /Ul        [        R                  " [        US9   UR                  S/S/5        S S S 5        [        R                  " [        US9   UR                  S/S/SS9  S S S 5        g ! , (       d  f       GN= f! , (       d  f       Nï= f! , (       d  f       NÈ= f! , (       d  f       Nx= f! , (       d  f       g = f)Nr
   )r¥   r   ÚabcdrV   zEThe following id_vars or value_vars are not present in the DataFrame:rp   re   rf   ÚCr¨   r   r§   )re   rf   Únot_hereÚor_therer   )ÚEre   rg   ÚFr   rI   )r   r   r   r   r   r   rr   rs   ÚKeyErrorr   r‘   r   )r@   r!   ru   Úmultis       r    Ú test_melt_missing_columns_raisesÚ)TestMelt.test_melt_missing_columns_raisesE  s^  € ô Ü�I‰I×!Ñ! !Ó$×4Ñ4°VÓ<ÄdÈ6Ãlñ
ˆð
 VˆÜ�]Š]œ8¨3Ó/Ø�G‰G�S˜#�J  c 
Ô+÷ 0ô �]Š]œ8¨3Ó/Ø�G‰G�S˜#�J  c 
Ô+÷ 0ô �]Š]ÜØó
ð �G‰GÒ6¸¸c¸
ÔC÷	
ð —‘“	ˆÜ˜f›¤t¨F£|Ð4ˆŒÜ�]Š]œ8¨3Ó/Ø�J‰J˜
�| j \Ô2÷ 0ô �]Š]œ8¨3Ó/Ø�J‰J˜�u˜s˜e¨qˆJÑ1÷ 0Ð/÷) 0Ö/ú÷ 0Õ/ú÷
õ 
ú÷ 0Õ/ú÷ 0Õ/ús<   ÁFÂFÃF$Ä.F5Å$GÆ
FÆ
F!Æ$
F2Æ5
GÇ
Gc                 óò   • [        S/S/S/S/S.5      n[        USS/SS	/S
9n[        S/S-  S/S-  [        S5      SS/S.5      nUS   R                  [        5      US'   [
        R                  " X#5        g )Nr�   Úbarrk   r
   )r   re   rf   r¨   r   re   rf   r¨   rE   Úbd)r   re   r<   r=   r<   )r   r   r   r   ÚobjectrK   rL   ©r@   r!   rA   r`   s       r    Útest_melt_mixed_int_str_id_varsÚ(TestMelt.test_melt_mixed_int_str_id_varsh  sŠ   € ä˜E˜7¨%¨¸°sÀ!ÀÑEÓFˆÜ�b 1 c (¸¸S°zÑBˆÜØ�˜!‘ 5 '¨A¡+¼4À»:ÐQRÐTUÐPVÑWó
ˆð  (¨
Ñ3×:Ñ:¼6ÓBˆ�ÑÜ
×Ò˜fÕ/r"   c                 óŒ   • [        S/S/S.5      n[        USS/S9n[        SS/SS/S.5      n[        R                  " X#5        g )Nr�   rÏ   )r   re   r   re   )rG   ©r<   r=   ©r   r   rK   rL   rÒ   s       r    Ú"test_melt_mixed_int_str_value_varsÚ+TestMelt.test_melt_mixed_int_str_value_varss  sJ   € ä˜E˜7¨%¨Ñ1Ó2ˆÜ�b a¨ XÑ.ˆÜ¨1¨c¨(¸eÀU¸^ÑLÓMˆÜ
×Ò˜fÕ/r"   c                 óŠ   • [        S/S/S.S/S9n[        USS9n[        SS	/SS/S
.SS/S9n[        R                  " X#5        g )Nr   rk   ©r�   rÏ   Úfirst©r   Fr°   r�   rÏ   rÖ   r×   rÒ   s       r    Útest_ignore_indexÚTestMelt.test_ignore_indexz  sV   € ä ˜s¨A¨3Ñ/¸°yÑAˆÜ�b uÑ-ˆÜØ ˜°1°a°&Ñ9À'È7ÐASñ
ˆô 	×Ò˜fÕ/r"   c                 ó(  • [         R                  R                  SS/SS/S9n[        SS/SS	/S
.US9n[	        USS9n[         R                  R                  SS/S-  SS/S9n[        S/S-  S/S-  -   / SQS.US9n[
        R                  " X55        g )N)rÜ   Úsecond)rÜ   ÚthirdÚbazÚfoobar©r.   r   rk   r
   r´   rÛ   rÝ   Fr°   r�   rÏ   r³   rÖ   )r¶   Ú
MultiIndexÚfrom_tuplesr   r   rK   rL   ©r@   r   r!   rA   Úexpected_indexr`   s         r    Útest_ignore_multiindexÚ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Õ/r"   c                 óÂ   • [        SS/SSS9n[        SS/SS	/S
.US9n[        USS9n[        SS/S-  SSS9n[        / SQ/ SQS.US9n[        R                  " X55        g )Nr�   rÏ   r©   rã   )r«   r’   r   rk   r
   r´   )ÚxÚyrÝ   Fr°   )rí   rí   rî   rî   r³   rÖ   )r   r   r   rK   rL   rè   s         r    Útest_ignore_index_name_and_typeÚ(TestMelt.test_ignore_index_name_and_type•  su   € ä�u˜e�n¨J¸UÑCˆÜ˜a ˜V¨1¨a¨&Ñ1¸Ñ?ˆÜ�b uÑ-ˆä  u˜~°Ñ1¸È%ÑPˆÜÚ-ºÑEØ ñ
ˆô
 	×Ò˜fÕ/r"   c                 ó–   • [        / SQ// SQS9nUR                  S/S/S9n[        / SQ/ SQ// S	QS9n[        R                  " X#5        g )
N)Úidr
   r´   )re   rf   rf   rV   re   rf   rE   )rò   rf   r
   )rò   rf   r´   )re   r<   r=   r×   rÒ   s       r    Ú test_melt_with_duplicate_columnsÚ)TestMelt.test_melt_with_duplicate_columns£  sK   € äš�~ªÑ?ˆØ—‘ # °C°5�Ð9ˆÜÚš^Ð,Ò6Pñ
ˆô 	×Ò˜fÕ/r"   r«   ÚInt8ÚInt64c                 ó
  • [        [        R                  " SS/SS9[        R                  " SS/US9S.5      nUR                  5       n[        / SQ[        R                  " / S	QUS9S
.5      n[        R
                  " X45        g )Nrk   r
   rõ   rª   r´   r   ©re   rf   )re   re   rf   rf   )rk   r
   r´   r   rÖ   )r   r¶   r¸   r   rK   rL   )r@   r«   r!   rA   r`   s        r    Útest_melt_ea_dtypeÚTestMelt.test_melt_ea_dtype¬  st   € ô ä—Y’Y  1˜v¨VÑ4Ü—Y’Y  1˜v¨UÑ3ñó
ˆð —‘“ˆÜâ0ÜŸš¢<°uÑ=ñó
ˆô 	×Ò˜fÕ/r"   c                 ó,  • [        SSSS.SSSS.SS	S
S.S.5      nUR                  R                  S5      Ul        UR                  S/S/S9n[        [	        S5      [
        R                  " S/S-  SS9/ SQS.5      n[        R                  " X#5        g )Nre   rf   r§   rj   rk   r´   r¥   r
   r   é   )r   r   rÅ   zstring[python]r   r   rE   r+   rª   )rk   r´   r¥   )r   r<   r=   )	r   r   r   r   r   r¶   r¸   rK   rL   rÒ   s       r    Útest_melt_ea_columnsÚ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Õ/r"   c                 óò  • [        S[        R                  " SSS9[        R                  " SSS9S.S[        R                  " SSS9[        R                  " SSS9S./S	S
/S9nUR                  S/SS/SSS9n[        SSSSS.SSSSS.[        R                  " SSS9[        R                  " SSS9[        R                  " SSS9[        R                  " SSS9S.S.5      n[        R
                  " X#5        g )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_datetimeÚ%TestMelt.test_melt_preserves_datetimeÒ  s  € Üð !Ü"$§,¢,¨|ÀÑ"MÜ "§¢¨\¸lÑ Kñð !Ü"$§,¢,¨|ÀÑ"MÜ "§¢¨\¸lÑ Kñðð ˜6Ð"ñ
ˆð —‘Ø�HØ$ jÐ1Ø Øð	 ð 
ˆô à  T¨d°tÑ<à#Ø#Ø!Ø!ñ	ô —|’|Ð$>À<ÑPÜ—|’|Ð$>À<ÑPÜ—|’|Ð$>À<ÑPÜ—|’|Ð$>À<ÑPñ	ñó
ˆô" 	×Ò˜fÕ/r"   c                 ó¦   • [        / SQ/ SQS./ SQS9nUR                  SSSS	9n[        / SQS
/S-  / SQS.5      n[        R                  " X#5        g ©N©rk   r
   r´   ©r   r¥   rü   rø   ©Ú11Ú22Ú33r  re   r   rk   rŽ   rf   r´   )re   r   rk   r×   rÒ   s       r    Ú#test_melt_allows_non_scalar_id_varsÚ,TestMelt.test_melt_allows_non_scalar_id_varsû  s\   € ÜÚ ¢yÑ1Ú$ñ
ˆð —‘ØØØð ð 
ˆô
 ¢9°#°¸±ºyÑIÓJˆÜ
×Ò˜fÕ/r"   c                 ó¨   • [        / SQ/ SQS./ SQS9nUR                  S/SSS	9n[        / SQS
/S-  / SQS.5      n[        R                  " X#5        g r  r×   rÒ   s       r    Ú$test_melt_allows_non_string_var_nameÚ-TestMelt.test_melt_allows_non_string_var_name  s^   € ÜÚ ¢yÑ1Ú$ñ
ˆð —‘Ø�EØØð ð 
ˆô
 ¢9°#°¸±ºyÑIÓJˆÜ
×Ò˜fÕ/r"   c                 ó¶   • [        / SQ/ SQS./ SQS9n[        R                  " [        SS9   UR	                  S/S	S
/S9  S S S 5        g ! , (       d  f       g = f)Nr  r  rø   r  r  z.* must be a scalar.rp   re   rk   r
   ry   )r   rr   rs   rt   r   ©r@   r!   s     r    Ú$test_melt_non_scalar_var_name_raisesÚ-TestMelt.test_melt_non_scalar_var_name_raises  sK   € ÜÚ ¢yÑ1Ú$ñ
ˆô �]Š]œ:Ð-DÓEØ�G‰G˜S˜E¨Q°¨FˆGÑ3÷ F×EÖEús   ­A
Á

Ar2   N),Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__rB   rM   rS   r[   rr   ÚmarkÚparametrizeÚtupler   r   Úarrayra   rh   r   rm   rv   r�   r‹   r›   rž   r¡   r¶   r¸   r   rº   rÁ   rÌ   rÓ   rØ   rÞ   rê   rï   ró   rù   rý   r  r  r  r  Ú__static_attributes__r2   r"   r    r9   r9   6   sD  † ò@ò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ò?ð ‡[�[×ÑØà�IŠI‘j °°|ÑDÓEØ�IŠIÒ/°zÑ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"   r9   c                   ó   • \ rS rSrS rSrg)ÚTestLreshapei  c                 óÎ  • / SQ/ SQ/ SQ/ SQ/ SQS[         R                  SSS	/S
[         R                  [         R                  SS// SQS[         R                  SSS/S[         R                  [         R                  SS/S.
n[        U5      n[        SS5       Vs/ s H	  nSUS 3PM     sn[        SS5       Vs/ s H	  nSUS 3PM     snS.n[	        X$5      n/ SQ/ SQ/ SQ/ SQ/ S Q/ S!QS".n[        XeR
                  S#9n[        R                  " XW5        [	        X$S$S%9n/ S&Q/ S'Q/ S(Q/ S)QS*S+S,S-S.S[         R                  SSS	S
[         R                  [         R                  SS/S/SS0S1S2S[         R                  SSSS[         R                  [         R                  SS/S".n[        XeR
                  S#9n[        R                  " XW5        [        SS35       Vs/ s H	  nSUS 3PM     sn[        SS5       Vs/ s H	  nSUS 3PM     snS.nS4n[        R                  " [        US59   [	        X$5        S S S 5        g s  snf s  snf s  snf s  snf ! , (       d  f       g = f)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Úwt3rk   r   Úvisitdtr¨   Úwt)rV  rW  )r*  r+  r,  r-  r.  r*  r,  r-  r.  r*  r-  r.  )r/  r0  r1  r2  r3  r/  r1  r2  r3  r/  r2  r3  )r4  r5  r6  r7  r8  r4  r6  r7  r8  r4  r7  r8  )r9  r:  r:  r:  r:  r9  r:  r:  r:  r9  r:  r:  )r.  r;  r<  r=  r>  r?  r@  rA  rB  rC  rD  rE  )ç     |œ@rH  ç     4˜@ç     Ä©@ç     Ò°@rF  rG  rH  rI  rJ  rK  rL  )rM  rN  rò   rO  rV  rW  rV   F)Údropna)r*  r+  r,  r-  r.  r*  r+  r,  r-  r.  r*  r+  r,  r-  r.  )r/  r0  r1  r2  r3  r/  r0  r1  r2  r3  r/  r0  r1  r2  r3  )r4  r5  r6  r7  r8  r4  r5  r6  r7  r8  r4  r5  r6  r7  r8  )r9  r:  r:  r:  r:  r9  r:  r:  r:  r:  r9  r:  r:  r:  r:  r.  r;  r<  r=  r>  rX  rY  rZ  r[  r´   z$All column lists must be same lengthrp   )r   Únanr   rµ   r   r   rK   rL   rr   rs   rt   )	r@   rÀ   r!   ÚiÚspecrA   Úexp_dataÚexpru   s	            r    Ú
test_pairsÚTestLreshape.test_pairs  sk  € òò 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ñ
ˆô ˜"Ó#ˆòòò OòòòñuH
ˆôR ˜¯.©.Ñ9ˆÜ
×Ò˜fÔ*ä˜"¨5Ñ1ˆòò"ò"ò"ð$ ØØØØØÜ—‘ØØØØÜ—‘Ü—‘ØØðð$ ØØØØØÜ—‘ØØØØÜ—‘Ü—‘ØØðñmg
ˆôP ˜¯.©.Ñ9ˆÜ
×Ò˜fÔ*ô 27°q¸!´Ó=²¨A˜' ! A ›±Ñ=Ü',¨Q°¤{Ó3¢{ !�R˜˜!�u“:¡{Ñ3ñ
ˆð 5ˆÜ�]Š]œ:¨SÓ1Ü�RÔ÷ 2Ð1ùòE >ùÚ3ùòz >ùÚ3÷ 2Õ1ús$   ÂIÂ;IÇIÇ=IÈ-IÉ
I$r2   N)r  r  r   r!  rb  r&  r2   r"   r    r(  r(    s   † õ`r"   r(  c                   ó†   • \ rS rSrS rS rS rS rS rS r	S r
S	 rS
 rS rS rS rS rS rS rS rS rS rS rSrg)ÚTestWideToLongi  c                 óä  • [         R                  R                  S5      R                  S5      n[	        SSSS.SSS	S.S
SSS.SSSS.[        [        [        S5      U5      5      S.5      nUR                  US'   UR                  5       UR                  5       -   / SQ/ SQ/ SQ/ SQS.n[	        U5      nUR                  SS/5      / SQ   n[        USS/SSS9n[        R                  " XT5        g )Nr
   r´   re   rf   r§   rj   r¨   ÚeÚfç      @ç333333ó?çffffffæ?çš™™™™™	@çÍÌÌÌÌÌô?çš™™™™™¹?)ÚA1970ÚA1980ÚB1970ÚB1980r½   rò   ©re   rf   r§   r¨   rg  rh  ©ri  rj  rk  rl  rm  rn  ©é²  rv  rv  é¼  rw  rw  ©r   rk   r
   r   rk   r
   ©r½   r   r   Úyearrò   rz  ©r½   r   r   r   r   ©r^  Új©r   r   r   r   r   ÚdictÚziprµ   r   r?   Ú	set_indexr   rK   rL   ©r@   rí   r!   r`  r`   rA   s         r    Útest_simpleÚ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Õ/r"   c                 ój   • [        / SQ/ SQ/5      n/ SQUl        SS/n[        XSSS9  USS/:X  d   eg )	N)r   rk   r
   r´   é   )r   r¥   rü   é   é	   )rò   Úinc1Úinc2Úedu1Úedu2ÚincÚedurò   Úager|  )r   r   r   )r@   r!   Ústubss      r    Ú
test_stubsÚTestWideToLong.test_stubs  s?   € äšªÐ9Ó:ˆÚ;ˆŒ
Ø˜�ˆä�R $¨%Ò0à˜ ˜Ó&Ð&Ñ&r"   c                 óæ  • [         R                  R                  S5      R                  S5      n[	        SSSS.SSS	S.S
SSS.SSSS.[        [        [        S5      U5      5      S.5      nUR                  US'   UR                  5       UR                  5       -   / SQ/ SQ/ SQ/ SQS.n[	        U5      nUR                  SS/5      / SQ   n[        USS/SSSS9n[        R                  " XT5        g )Nr
   r´   re   rf   r§   rj   r¨   rg  rh  ri  rj  rk  rl  rm  rn  )zA.1970zA.1980zB.1970zB.1980r½   rò   rs  rt  ru  rx  ry  rz  r{  r   r   Ú.©r^  r}  Úsepr~  r‚  s         r    Útest_separating_characterÚ(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Õ/r"   c                 óä  • [         R                  R                  S5      R                  S5      n[	        SSSS.SSS	S.S
SSS.SSSS.[        [        [        S5      U5      5      S.5      nUR                  US'   UR                  5       UR                  5       -   / SQ/ SQ/ SQ/ SQS.n[	        U5      nUR                  SS/5      / SQ   n[        USS/SSS9n[        R                  " XT5        g )Nr
   r´   re   rf   r§   rj   r¨   rg  rh  ri  rj  rk  rl  rm  rn  )zA(quarterly)1970zA(quarterly)1980zB(quarterly)1970zB(quarterly)1980r½   rò   rs  rt  ru  rx  )r½   úA(quarterly)úB(quarterly)rz  rò   rz  )r½   rš  r›  rš  r›  r|  r~  r‚  s         r    Útest_escapable_charactersÚ(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Õ/r"   c                 ó@  • [        SS/SS/SS/SS/S	.5      nUR                  US
'   / SQ/ SQSS[        R                  [        R                  // SQ/ SQS.n[        U5      nUR	                  S
S/5      / SQ   n[        USS/S
SS9n[        R                  " XC5        g )Nç      ð?ç       @ç      @ç      @ç      @ç      @ÚX1ÚX2©ÚA2010ÚA2011ÚB2010r½   rò   ©r¥  r¦  r¥  r¦  ©rŸ  r   r¡  r¢  )r   rk   r   rk   )éÚ  r­  éÛ  r®  )r½   r   r   rò   rz  rz  r{  r   r   r|  )r   r   r   r]  r�  r   rK   rL   ©r@   r!   r`  r`   rA   s        r    Útest_unbalancedÚTestWideToLong.test_unbalancedY  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Õ/r"   c                 óZ  • [        / SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQS.5      nUR                  US	'   [        / S
Q/ S
Q/ SQ/ SQ/ SQ/ SQ/ SQS.5      nUR                  S	S/5      / SQ   n[        U/ SQS	SS9n[        R
                  " UR                  SS9UR                  SS95        g )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Á  ©rk   r
   r´   r   r¥   rü   rx  ©é   rÓ  rÓ  é   rÔ  rÔ  )rÌ  rÍ  r   r   ÚBBrò   rz  rz  )rÌ  rÍ  r   r   rÕ  ©r   r   rÕ  r|  rk   ©Úaxis©r   r   r�  r   rK   rL   Ú
sort_index©r@   r!   r`   rA   s       r    Útest_character_overlapÚ%TestWideToLong.test_character_overlapp  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           	      ó²  • Sn[        SS/SS/SS/SS	/S
.5      nUR                  US'   S/ / / / / / / S.n[        U5      R                  S[        R                  05      nUR                  SS/5      / SQ   nUR                  R                  SS/SS9Ul        [        USS/SSUS9n[        R                  " UR                  SS9UR                  SS95        g )Nznope!rŸ  r   r¡  r¢  r£  r¤  r¥  r¦  r§  rò   Ú )r½   r¨  r©  rª  rò   rz  r   r   rz  )r½   r¨  r©  rª  r   r   r   rk   ©Úlevelr   r   r•  r×  ©r   r   r   r   r   r�  Ú
set_levelsr   rK   rL   rÚ  )r@   r–  r!   r`  r`   rA   s         r    Útest_invalid_separatorÚ%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                 óZ  • [        / SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQS.5      nUR                  US	'   [        / S
Q/ S
Q/ SQ/ SQ/ SQ/ SQ/ SQS.5      nUR                  S	S/5      / SQ   n[        U/ SQS	SS9n[        R
                  " UR                  SS9UR                  SS95        g )Nr³  r·  rº  r¾  r  r  rÂ  )rÆ  rÇ  rÈ  rÉ  rÊ  rË  ÚAratingÚArating_oldrò   rÎ  rÏ  rÐ  rÑ  rx  rÒ  )rç  rè  r   r   rÕ  rò   rz  rz  )rç  rè  r   r   rÕ  rÖ  r|  rk   r×  rÙ  rÛ  s       r    Útest_num_string_disambiguationÚ-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           	      ó¢  • [        SS/SS/SS/SS/S	.5      nUR                  US
'   S/ / / / / / / S.n[        U5      R                  S[        R                  05      nUR                  S
S/5      nUR                  R                  SS/SS9Ul        [        USS/S
SS9n[        R                  " UR                  SS9UR                  SS95        g )NrŸ  r   r¡  r¢  r£  r¤  r¥  r¦  )ÚAoneÚAtwoÚBoner½   rò   rß  )r½   rì  rí  rî  rò   rz  r   r   rz  r   rk   rà  r   r   r|  r×  râ  r¯  s        r    Útest_invalid_suffixtypeÚ&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                 óÚ   • [        / SQ/ SQ/ SQ/ SQS.5      n[        / SQ/ SQ/ SQ/ S	QS
.5      nUR                  / SQ5      S/   n[        USSS/SS9n[        R                  " X25        g )N)	rk   rk   rk   r
   r
   r
   r´   r´   r´   )	rk   r
   r´   rk   r
   r´   rk   r
   r´   )	çffffff@ç333333@çš™™™™™@r
   çÍÌÌÌÌÌü?çffffffþ?rô  çffffff@çÍÌÌÌÌÌ @)	ç333333@çffffff@ró  rl  rò  ç333333@çffffff
@rù  ró  )ÚfamidÚbirthÚht1Úht2)rò  rù  ró  rú  rô  ró  r   rl  rõ  rò  rö  rû  rô  rü  r÷  rù  rø  ró  )rk   rk   rk   rk   rk   rk   r
   r
   r
   r
   r
   r
   r´   r´   r´   r´   r´   r´   )rk   rk   r
   r
   r´   r´   rk   rk   r
   r
   r´   r´   rk   rk   r
   r
   r´   r´   )rk   r
   rk   r
   rk   r
   rk   r
   rk   r
   rk   r
   rk   r
   rk   r
   rk   r
   )Úhtrý  rþ  r�  )rý  rþ  r�  r  rý  rþ  r�  r|  ©r   r�  r   rK   rL   rÛ  s       r    Útest_multiple_id_columnsÚ'TestWideToLong.test_multiple_id_columnsê  s|   € äâ4Ú4ÚBÚDñ	ó
ˆô òò( PÚOÚMñ/ó
ˆð6 ×%Ñ%Ò&?Ó@À$ÀÑHˆÜ˜b $¨7°GÐ*<ÀÑFˆÜ
×Ò˜fÕ/r"   c                 ó´   • [        / SQ/ SQ/ SQS.5      nSn[        R                  " [        US9   [	        USS/SS	S
9  S S S 5        g ! , (       d  f       g = f)N)rk   r
   r´   r   r¥   )rk   rk   rk   rk   rk   )ÚA_A1ÚB_B1rí   z3the id variables need to uniquely identify each rowrp   ÚA_AÚB_Brí   Úcolnamer|  ©r   rr   rs   rt   r   ©r@   r!   ru   s      r    Útest_non_unique_idvarsÚ%TestWideToLong.test_non_unique_idvars  sL   € ô Ú$ªoÂOÑTó
ˆð DˆÜ�]Š]œ:¨SÓ1Ü˜˜e U˜^¨s°iÒ@÷ 2×1Ö1ús   ±A	Á	
Ac                 óÖ   • [        / SQ/ SQ/ SQ/ SQ/ SQS.5      n[        / SQ/ SQ/ S	Q/ S
QS.5      R                  SS/5      n[        USS/SSSS9n[        R                  " X25        g )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  )rk   rk   rk   r
   r
   r
   )r  r  r  r  r  r  )ÚactorÚactor_fb_likesÚnumr#  r#  r&  r$  r%  Ú_r•  r  rÛ  s       r    Útest_cast_j_intÚTestWideToLong.test_cast_j_int  s…   € ÜâLÚPÚ$>Ú$:ÚJñó
ˆô òò #SÚ)òñó
÷* ‰)�W˜eÐ$Ó
%ð+ 	ô, Ø�Ð*Ð+¨w¸%ÀSñ
ˆô 	×Ò˜fÕ/r"   c                 óº   • [        SS/SS/SS/SS/S	.5      nS
n[        R                  " [        US9   [	        USS/SSS9  S S S 5        g ! , (       d  f       g = f)NrŸ  r   r¡  r¢  r£  r¤  r¥  r¦  )r¨  r©  rª  r   z,stubname can't be identical to a column namerp   r   r   r
  r|  r  r  s      r    Útest_identical_stubnamesÚ'TestWideToLong.test_identical_stubnamesD  s`   € Üà˜s˜Ø˜s˜Ø˜s˜Ø˜D�\ñ	ó
ˆð =ˆÜ�]Š]œ:¨SÓ1Ü˜˜c 3˜Z¨3°)Ò<÷ 2×1Ö1ús   ´AÁ
Ac           	      ó  • [        SS/SS/SS/SS/S	.5      n[        / S
Q/ SQSS[        R                  [        R                  // SQS.5      nUR                  SS/5      n[	        USS/SSSSS9n[
        R                  " X25        g )NrŸ  r   r¡  r¢  r£  r¤  r¥  r¦  )Útreatment_placeboÚtreatment_testÚresult_placebor   r«  )Úplacebor1  Útestr2  r¬  ©r   r
  rA   Ú	treatmentr   r
  rA   r4  z[a-z]+r'  ©r^  r}  Úsuffixr–  ©r   r   r]  r�  r   rK   rL   rÛ  s       r    Útest_nonnumeric_suffixÚ%TestWideToLong.test_nonnumeric_suffixQ  sŸ   € Üà&)¨3 ZØ#&¨ *Ø#&¨ *Ø˜D�\ñ	ó
ˆô â-ÚAØ ¤R§V¡V¬R¯V©VÐ4Ú1ñ	ó
ˆð ×%Ñ% s¨IÐ&6Ó7ˆÜØ�˜;Ð'¨3°)ÀHÐRUñ
ˆô 	×Ò˜fÕ/r"   c           	      óØ   • [        SS/SS/SS/SS/S	S
/S.5      n[        / SQ/ SQ/ SQ/ SQS.5      R                  SS/5      n[        USS/SSSSS9n[        R                  " X25        g )Nr¥  r¦  r   rˆ  r£  r¤  rŸ  r   r¡  r¢  )r   Úresult_1Ú
result_fooÚtreatment_1Útreatment_foor«  )Ú1r?  r�   r�   )ç        ç      "@r£  r¤  r¬  r3  r   r
  rA   r4  z.+r'  r5  r  rÛ  s       r    Útest_mixed_type_suffixÚ%TestWideToLong.test_mixed_type_suffixh  s“   € Üà˜D�\Ø ˜FØ" C˜jØ # S˜zØ"% s ñó
ˆô â-Ú3Ú.Ú1ñ	ó
÷ ‰)�S˜)Ð$Ó
%ð 	ô Ø�˜;Ð'¨3°)ÀDÈcñ
ˆô 	×Ò˜fÕ/r"   c                 óÔ  • [        SS/SS/SS/SS/S	S
/S.5      n[        / SQ/ SQSSSS[        R                  [        R                  [        R                  [        R                  /[        R                  [        R                  [        R                  [        R                  SSSS/S.5      nUR                  SS/5      n[	        USS/SSSSS9n[
        R                  " X25        g )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¦  )rj  rj  rŸ  rŸ  çš™™™™™ñ?rE  rø  rø  r@  rA  r3  r   r
  rA   r4  z[0-9.]+r'  r5  r7  rÛ  s       r    Útest_float_suffixÚ 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Õ/r"   c           
      óâ   • SSSSSS.SSS	S
SS.SSSSSS.SSSSSS.SSSSSS.S.n[         R                  " U5      n[        US/SS/SS9n[        USSS/SS9n[        R                  " XC5        g )Nr   rk   r
   r´   r   )r   rk   r
   r´   r   gš™™™™™é?r@  g      Ð?rŸ  gìQ¸…ëé?g®Gáz®ç?gìQ¸…ëá?g\�Âõ(\ï?g333333ã?g¤p=
×£è?g{®Gázä?g¤p=
×£à?gq=
×£på?gÃõ(\�ÂÕ?rk  )Únode_idr   ÚPA0ÚPA1ÚPA3ÚPArI  r   Útime)Ú	stubnamesr^  r}  )r   Ú	from_dictr   rK   rL   )r@   Ú	wide_dataÚwide_dfr`   rA   s        r    Útest_col_substring_of_stubnameÚ-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Õ/r"   c                 óö   • [        [        S5      [        SSS5      S.5      n[        R                  " [
        [        R                  " S5      S9   UR                  SSS	9  S S S 5        g ! , (       d  f       g = f)
Nr*   r   é   r
   )r£   r=   zvalue_name (value) cannot matchrp   r=   r„   )	r   r   rµ   rr   rs   rt   ÚreÚescaper   r  s     r    Útest_raise_of_column_name_valueÚ.TestWideToLong.test_raise_of_column_name_value§  s]   € ô œt E›{´U¸2¸rÀ1Ó5EÑFÓGˆä�]Š]ÜœbŸišiÐ(IÓJó
ð �G‰G˜G°ˆGÑ8÷
÷ 
ö 
ús   ÁA*Á*
A8c                 óT  • U(       a2  US:X  a,  UR                  [        R                  R                  SS95        [	        SS/SS/SS	/S
.5      nUR                  SU05      n[        USS/SSSS9n[        / SQSS9n[	        / SQ[        R                  /S-  S.US9nUR                  R                  S   R                  U5      nUS:X  a(  UR                  R                  S   R                  S5      nUR                  R                  USS9Ul
        [        R                  " XW5        g )NrÑ   zTODO(infer_string))Úreasonr?  Ú2éd   éÈ   é,  é�  )rò   za-1za-2rò   re   rf   r&  Ú-)rO  r^  r}  r–  ))r?  rk   )r]  rk   )r?  r
   )r]  r
   )rò   r&  )r’   )r^  r_  r`  ra  r   rø   rÝ   r   Ústrrà  )Úapplymarkerrr   r"  Úxfailr   r   r   r   r   r]  r   Úlevelsrã  rK   rL   )	r@   ÚrequestÚany_string_dtypeÚusing_infer_stringr!   rA   r   r`   Ú	new_levels	            r    Útest_missing_stubnameÚ$TestWideToLong.test_missing_stubname²  s!  € ÞÐ"2°hÓ">à×Ñ¤§¡× 1Ñ 1Ð9MÐ 1Ð NÔOä˜s C˜j°#°s°ÀSÈ#ÀJÑOÓPˆØ�Y‰Y˜Ð.Ð/Ó0ˆÜØØ˜C�jØØØñ
ˆô Ú4Øñ
ˆô Ú&¬b¯f©f¨X¸©\Ñ:Øñ
ˆð —N‘N×)Ñ)¨!Ñ,×3Ñ3Ð4DÓEˆ	Ø˜xÓ'Ø Ÿ™×-Ñ-¨aÑ0×7Ñ7¸Ó>ˆIØ!Ÿ™×2Ñ2°9ÀAÐ2ÐFˆŒÜ
×Ò˜fÕ/r"   r2   N)r  r  r   r!  rƒ  r‘  r—  rœ  r°  rÜ  rä  ré  rï  r  r  r(  r+  r8  rB  rF  rS  rY  rk  r&  r2   r"   r    re  re    si   † ò0ò0'ò0ò40ò40ò.Vò<Vò<VòBVò:'0òRAò%0òN=ò0ò.0ò.0ò00ò 	9õ0r"   re  c                 óž  • [         R                  " U [        R                  S9n[	        SS0SS0SS0SS0SS0S.5      nUR
                  R                  U5      Ul        [        USSSS	S
S9n[	        SS/SS/SS//[        SS/5      [         R                  R                  / SQ[        / SQUS9/SS/S9S9n[        R                  " X45        g )N)Úna_valuer   rk   r
   )ÚIDÚR_test1ÚR_test2ÚR_test3ÚDÚRro  Ú	UNPIVOTEDr'  z.*)rO  r^  r}  r–  r6  rs  )rk   rk   rk   )Útest1Útest2Útest3rª   rå   r   )r¶   ÚStringDtyper   r]  r   r   r   r   r   ræ   Úfrom_arraysrK   rL   )Ústring_storageÚstring_dtyper!   rA   r`   s        r    Ú test_wide_to_long_string_columnsr}  Ï  sé   € ä—>’> .¼2¿6¹6ÑB€LÜ	à�a�&Ø˜1�vØ˜1�vØ˜1�vØ�Q�ñ	
ó
€Bð —‘×"Ñ" <Ó0€B„JÜØ
�c˜T [°cÀ$ñ€Fô Ø
ˆQˆ�!�Q�˜!˜Q˜Ð Ü�s˜C�jÓ!Ü�m‰m×'Ñ'âÜÒ1¸ÑFðð ˜Ð%ð (ð 
ñ
€Hô ×Ò˜&Õ+r"   )rW  Únumpyr   rr   Úpandasr¶   r   r   r   r   r   r   Úpandas._testingÚ_testingrK   Úfixturer!   r/   r3   r7   r9   r(  re  r}  r2   r"   r    Ú<module>rƒ     s¬   ðÛ 	ã Û ã ÷÷ õ ð ‡�ñó ðð ‡�ñ
ó ð
ð ‡�ñó ðð ‡�ñó ð÷e4ñ e4÷Pañ a÷HJ0ñ J0óZ,r"   