+
    xȇiW                     $   ^ RI t ^ RIt^ RIt^ RIt^ RIHtHtHtH	t	H
t
Ht ^ RIHt ]P                  R 4       t]P                  R 4       t]P                  R 4       t]P                  R 4       t ! R R4      t ! R	 R
4      t ! R R4      tR tR# )    N)	DataFrameIndex
date_rangelreshapemeltwide_to_longc            
      f   \        \        P                  P                  ^4      P	                  R	4      \        \        R4      4      \        R^
RR7      R7      p V R,          ^ 8  P                  \        P                  4      V R&   V R,          ^ 8  P                  \        P                  4      V R&   V # )
   ABCDz
2000-01-01B)periodsfreqcolumnsindexAid1id2)
      )
r   nprandomdefault_rngstandard_normalr   listr   astypeint64ress    n/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/reshape/test_melt.pydfr!      s    

		a 009d6l#r<C
 c(Q,&&rxx0CJc(Q,&&rxx0CJJ    c                      \        . RO. RO. RO.4      p \        R4      \        R4      .V n        RR.V P                  n        V # )5:?ABCabcCAPlow)r$   StgKԲ?)Uy$> M?gK)i<8b->?ghBĒ)r   r   r   namesr   s    r    df1r/      sE    
*,+	
C ;U,CKCKKJr"   c                      R # )var r2   r"   r    var_namer3   ,       r"   c                      R # )valr2   r2   r"   r    
value_namer7   1   r4   r"   c                   B  a  ] tR t^6t o R tR tR tR t]P                  P                  R]]]P                  34      R 4       tR t]P                  P                  RR	.R
.^ R	^ R^R7^R8/R^ R
^R
^R
/R^ R9^R^R//3R.R.^R^ R^R7^R8/R^ R^R^R/R^ R9^R^R//3.4      R 4       t]P                  P                  RR:R;..R:.R;.R:R;..4      R 4       tR tR tR t]P                  P                  R^ R.4      R 4       tR t]P                  P                  R]! R^RR7      ]P4                  ! . R<O4      . R=O.4      R  4       tR! tR" tR# tR$ tR% t R& t!R' t"R( t#]P                  P                  R)R*R+.4      R, 4       t$R- t%R. t&R/ t'R0 t(R1 t)R2 t*R3 t+R4 t,R5t-V t.R6# )>TestMeltc                b    \        V4      pVP                  P                  4       R R.8X  g   Q hR# )variablevalueNr   r   tolist)selfr!   results   && r    test_top_level_methodTestMelt.test_top_level_method7   s+    b~~$$&:w*????r"   c           	        \         P                  ! VP                  4       \        V4      4       \         P                  ! VP                  R R.RR.R7      \        VR R.RR.R7      4       \         P                  ! VP                  W4R7      \        WVR7      4       \         P                  ! VP                  ^ R7      \        V^ R7      4       R# )r   r   r   r   id_vars
value_varsr3   r7   	col_levelN)tmassert_frame_equalr   )r?   r!   r/   r3   r7   s   &&&&&r    test_method_signaturesTestMelt.test_method_signatures;   s    
bggib2
GGUENSzGBeU^c
C	

 	GGXG=:>	

 	chhh3T#5KLr"   c                F   VP                  4       pVP                  P                  4       R R.8X  g   Q hVP                  R.R7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.R7      pVP                  P                  4       . RO8X  g   Q hR# )r;   r<   r   )rE   r   N)r   r;   r<   r   r   r;   r<   r=   )r?   r!   r@   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                   VP                  R R.RR7      p\        V4      ^
8X  g   Q hVP                  R R.RR.R7      p\        R VR ,          P                  4       ^,          RVR,          P                  4       ^,          RR.^
,          R.^
,          ,           RVR,          P                  4       VR,          P                  4       ,           /. R	OR7      p\        P
                  ! W44       R# )
r   r   r   rD   r   r;   r<   r   NrO   )r   lenr   r>   rJ   rK   )r?   r!   result3result4	expected4s   &&   r    test_value_varsTestMelt.test_value_varsT   s    ''5%.S'A7|r!!!''5%.c3Z'Hr%y'')A-r%y'')A-SEBJ#3"S'..*RW^^-==	 8
	 	g1r"   type_c                   \        R VR ,          P                  4       ^,          RVR,          P                  4       ^,          RR.^
,          R.^
,          ,           RVR,          P                  4       VR,          P                  4       ,           /. R	OR7      pVP                  R R.V! R
4      R7      p\        P                  ! WC4       R# )r   r   r;   r   r   r<   rU   rD   NrO   )r   r   )r   r>   r   rJ   rK   )r?   r\   r!   expectedr@   s   &&&  r    test_value_vars_typesTestMelt.test_value_vars_typesd   s     r%y'')A-r%y'')A-SEBJ#3"S'..*RW^^-==	 8
 %E*<MN
f/r"   c                    \        R	VR	,          RR.\        V4      ,          RR.\        V4      ,          RVR
,          /. ROR7      pVP                  R	.R
.R7      p\        P                  ! W24       R# )r   r'   r   r(   br<   rU   rD   Nr   ar   rb   )rc   r'   r(   r<   )r   rV   r   rJ   rK   )r?   r/   r^   r@   s   &&  r    test_vars_work_with_multiindex'TestMelt.test_vars_work_with_multiindexs   sn    C
Ous3x'us3x'Z	 8
 :,J<H
f/r"   z(id_vars, value_vars, col_level, expectedr   r   r$   r'   r<   r+   r-   rd   rb   r(   c                n    VP                  WVR 7      p\        V4      p\        P                  ! Wd4       R# )rH   N)r   r   rJ   rK   )r?   rE   rF   rI   r^   r/   r@   s   &&&&&& r    %test_single_vars_work_with_multiindex.TestMelt.test_single_vars_work_with_multiindex   s.    8 'CX&
f/r"   zid_vars, value_varsc                    R p\         P                  ! \        VR7      ;_uu_ 4        VP                  WR7       RRR4       R#   + '       g   i     R# ; i)zF(id|value)_vars must be a list of tuples when columns are a MultiIndexmatchrD   N)pytestraises
ValueErrorr   )r?   rE   rF   r/   msgs   &&&& r    $test_tuple_vars_fail_with_multiindex-TestMelt.test_tuple_vars_fail_with_multiindex   s8     X]]:S11HHWH< 2111s   AA	c                N   VP                  VR 7      pVP                  P                  4       RR.8X  g   Q hVP                  R.VR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.VR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.RVR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.RR.VR7      p\        RVR,          P                  4       ^,          RVR,          P                  4       ^,          VR.^
,          R.^
,          ,           RVR,          P                  4       VR,          P                  4       ,           /RRVR.R	7      p\        P
                  ! Wx4       R
# )r3   r1   r<   r   rE   r3   r   r   )rE   rF   r3   r   rU   N)r   r1   r<   )r   r   r1   r<   r   r   r>   r   rJ   rK   )	r?   r!   r3   result5result6result7result8result9	expected9s	   &&&      r    test_custom_var_nameTestMelt.test_custom_var_name   s}   ''8',%%'E7+;;;;''5'H'=%%'+BBBB''5%.8'D%%'+IIII''5%.S8'T%%'+IIII''ENSzH  
 r%y'')A-r%y'')A-3%"*urz1"S'..*RW^^-==	 E8W5
	 	g1r"   c                L   VP                  VR 7      pVP                  P                  4       RR.8X  g   Q hVP                  R.VR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.VR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.RVR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.RR.VR7      p\        RVR,          P                  4       ^,          RVR,          P                  4       ^,          RR.^
,          R.^
,          ,           W!R,          P                  4       VR,          P                  4       ,           /RRRV.R	7      p\        P
                  ! Wx4       R
# ))r7   r;   r6   r   rE   r7   r   r   )rE   rF   r7   r   rU   N)r   r;   r6   )r   r   r;   r6   rw   )	r?   r!   r7   result10result11result12result13result14
expected14s	   &&&      r    test_custom_value_nameTestMelt.test_custom_value_name   s   77j71&&(Z,????77E7z7B&&(,FFFF77E5>j7I&&(,MMMM77ENsz  
 &&(,MMMM77ENSzj  
 r%y'')A-r%y'')A-SEBJ#3W^^-30@@	 E:z:

 	h3r"   c                   VP                  W2R 7      pVP                  P                  4       RR.8X  g   Q hVP                  R.W2R7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.W2R7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.RVVR7      pVP                  P                  4       . RO8X  g   Q hVP                  RR.RR.VVR7      p\        RVR,          P                  4       ^,          RVR,          P                  4       ^,          VR.^
,          R.^
,          ,           W!R,          P                  4       VR,          P                  4       ,           /RRW2.R	7      p	\        P
                  ! W4       VP                  4       p
R
V
P                  n        V
P                  4       pVP                  P                  4       R
R.8X  g   Q hR# )rG   r1   r6   r   rE   r3   r7   r   r   rE   rF   r3   r7   r   rU   foor<   N)r   r1   r6   )r   r   r1   r6   )r   r   r>   r   rJ   rK   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   77H7D&&(UEN:::77E7X7U&&(,AAAA77ENX  
 &&(,HHHH77EN!	  
 &&(,HHHH77ENSz!	  
 r%y'')A-r%y'')A-3%"*urz1W^^-30@@	 E88

 	h3wwy!99;&&(UG,<<<<r"   rI   c                p    VP                  VR 7      pVP                  P                  4       RR.8X  g   Q hR# )rH   r'   r<   Nr=   )r?   rI   r/   r   s   &&& r    test_col_levelTestMelt.test_col_level  s2    hhh+{{!!#w'7777r"   c                l    VP                  4       pVP                  P                  4       . RO8X  g   Q hR# )r'   N)r'   r(   r<   r=   )r?   r/   r   s   && r    test_multiindexTestMelt.test_multiindex  s)    hhj{{!!#'>>>>r"   col2010z
US/Pacific)r   tzc           
        \         P                  ! V4      p\        R \        ^4      RVR. R
ORV/4      p\         P                  ! \         P                  ! . R
O4      V.RR7      p\        VR R.RRR7      p\        ^ \        \        ^4      4      ^,          ^\         P                  ! V.^,          RR7      ^R.^,          R.^,          ,           ^V/4      p. ROVn        \        P                  ! WE4       R	# )klassr   attr1attr2Tignore_index	attributer<   r   N)   r   r   r   r   )r   r   r   r<   )
pdSeriesr   rangeconcatr   r   r   rJ   rK   )r?   r   r!   expected_valuer@   r^   s   &&    r    test_pandas_dtypesTestMelt.test_pandas_dtypes  s     iineAhsG_gsS
 BIIo$>#DSWX%(;7
 4a>A%299cUQYT:G9q=G9q=0>	
 B
f/r"   c           	         \        R ^^.R\        P                  ! RR.4      /4      p\        VR.R .4      p\        R\        P                  ! RR.4      RR R .R^^./4      p\        P
                  ! W#4       R# )r   r   XYr;   r<   N)r   r   Categoricalr   rJ   rK   )r?   datar@   r^   s   &   r    test_preserve_categoryTestMelt.test_preserve_category9  sy    #1vsBNNC:,FGHdSEC5)"..#s,j3*gPQSTvV
 	f/r"   c                "   \        \        P                  P                  ^4      P	                  R4      \        R4      R7      pRp\        P                  ! \        VR7      ;_uu_ 4        VP                  RR.RR.4       R	R	R	4       \        P                  ! \        VR7      ;_uu_ 4        VP                  R
R.RR.4       R	R	R	4       \        P                  ! \        VR7      ;_uu_ 4        VP                  . RORR.4       R	R	R	4       \        R4      \        R4      .Vn
        \        P                  ! \        VR7      ;_uu_ 4        VP                  R.R.4       R	R	R	4       \        P                  ! \        VR7      ;_uu_ 4        VP                  R
.R.^ R7       R	R	R	4       R	#   + '       g   i     EL8; i  + '       g   i     EL	; i  + '       g   i     L; i  + '       g   i     L; i  + '       g   i     R	# ; i)r
   abcdrU   zEThe following id_vars or value_vars are not present in the DataFrame:rl   rd   rb   CdNr   cr   FrH   )   r   )rd   rb   not_hereor_there)Erd   re   )r   r   r   r   r   r   rn   ro   KeyErrorr   r   r?   r!   rq   s   &  r     test_melt_missing_columns_raises)TestMelt.test_melt_missing_columns_raisesC  sm    II!!!$44V<d6l

 V]]83//GGS#Jc
+ 0 ]]83//GGS#Jc
+ 0 ]]
 
 GG6c
C	
 6lDL1
]]83//GGZL:,/ 0 ]]83//GGSEC5AG. 0/' 0// 0//
 
 0/ 0//s<   )F/,G/GG*G=/G 	G	G'	*G:	=H	c                   \        ^ R.RR.R^.R^./4      p\        V^ R.RR.R7      p\        ^ R.^,          RR.^,          R\        R4      R	^^./4      pVR,          P                  \        4      VR&   \
        P                  ! W#4       R
# )r   r   rd   barrb   r   rD   r;   bdr<   N)r   r   r   r   objectrJ   rK   r?   r!   r@   r^   s   &   r    test_melt_mixed_int_str_id_vars(TestMelt.test_melt_mixed_int_str_id_varse  s    E7C%#sC!EFb1c(SzB!S5'A+z4:wQRTUPVW
  (
3::6B
f/r"   c                    \        ^ R.RR./4      p\        V^ R.R7      p\        R^ R.RRR./4      p\        P                  ! W#4       R# )r   r   rd   r   )rF   r;   r<   Nr   r   rJ   rK   r   s   &   r    "test_melt_mixed_int_str_value_vars+TestMelt.test_melt_mixed_int_str_value_varsp  sR    E7C%12baX.j1c(GeU^LM
f/r"   c                    \        R ^ .R^./R.R7      p\        VRR7      p\        RR R.R^ ^./RR.R7      p\        P                  ! W#4       R# )	r   r   firstr   Fr   r;   r<   Nr   r   s   &   r    test_ignore_indexTestMelt.test_ignore_indexw  s^    sEA3/yAbu-%1a&9'7AS
 	f/r"   c                l   \         P                  P                  RR.RR.R7      p\        R^ ^.R^^./VR7      p\	        VRR7      p\         P                  P                  RR.^,          RR.R7      p\        R	R.^,          R.^,          ,           R
. RO/VR7      p\
        P                  ! W54       R# )r   bazfoobarr.   r   r   r   Fr   r;   r<   N)r   second)r   thirdr   r   r
      )r   
MultiIndexfrom_tuplesr   r   rJ   rK   r?   r   r!   r@   expected_indexr^   s   &     r    test_ignore_multiindexTestMelt.test_ignore_multiindex  s    )) "45eX=N * 
 1vuq!f5UCbu-22 "459%AR 3 
 %1w{2G\J 

 	f/r"   c                    \        R R.RRR7      p\        R^ ^.R^^./VR7      p\        VRR	7      p\        R R.^,          RRR7      p\        R
. ROR. RO/VR7      p\        P                  ! W54       R# )r   r   categoryr   )dtyper   xyr   Fr   r;   r<   N)r   r   r   r   r   )r   r   r   rJ   rK   r   s   &     r    test_ignore_index_name_and_type(TestMelt.test_ignore_index_name_and_type  s~    uenJUCaVS1a&1?bu-u~1%P-wE 

 	f/r"   c                    \        . RO.. ROR7      pVP                  R.R.R7      p\        . RO. R	O.. R
OR7      p\        P                  ! W#4       R# )idrd   rb   rU   rD   N)r   r
   r   )rd   rb   rb   )r   rb   r
   )r   rb   r   )rd   r;   r<   r   r   s   &   r     test_melt_with_duplicate_columns)TestMelt.test_melt_with_duplicate_columns  sK    ~?#C59^,6P
 	f/r"   r   Int8Int64c           
     "   \        R \        P                  ! ^^.RR7      R\        P                  ! ^^.VR7      /4      pVP                  4       p\        R. ROR\        P                  ! . ROVR7      /4      p\        P
                  ! W44       R# )	rd   r   r   rb   r;   r<   N)rd   rd   rb   rb   )r   r
   r   r   )r   r   r   r   rJ   rK   )r?   r   r!   r@   r^   s   &&   r    test_melt_ea_dtypeTestMelt.test_melt_ea_dtype  s}     RYY1vV4RYY1vU3
 0<u=
 	f/r"   c                V   \        R ^ R^R^R/R^ ^^^^^/R^ ^^^^^//4      pVP                  P                  R4      Vn        VP                  R .R.R7      p\        R \	        R4      R	\
        P                  ! R.^,          RR
7      R. RO/4      p\        P                  ! W#4       R# )r   rd   rb   r   r   r   zstring[python]rD   r&   r;   r   r<   N)r   r   r   )	r   r   r   r   r   r   r   rJ   rK   r   s   &   r    test_melt_ea_columnsTestMelt.test_melt_ea_columns  s    aaa-aAq!Q'aAq!Q'
 ZZ&&'78
#C59T%[BIIseai7GH
 	f/r"   c                N   \        R RR\        P                  ! RRR7      R\        P                  ! RRR7      /R RR\        P                  ! RRR7      R\        P                  ! R	RR7      /.R
R.R7      pVP                  R .RR.RRR7      p\        R ^ R^R^R^R/R^ R^R^R^R/R^ \        P                  ! RRR7      ^\        P                  ! RRR7      ^\        P                  ! RRR7      ^\        P                  ! RRR7      //4      p\        P
                  ! W#4       R# )typeA0
start_datez
2023/03/01z
Asia/Tokyo)r   end_datez
2023/03/10A1z
2023/03/11aaaabbbbr   r   z	start/enddater   z2023-03-01 00:00:00+0900z2023-03-10 00:00:00+0900z2023-03-11 00:00:00+0900N)r   r   	Timestampr   rJ   rK   r   s   &   r    test_melt_preserves_datetime%TestMelt.test_melt_preserves_datetime  s<    D ",,|"M\l K D ",,|"M\l K 6"
 H$j1 	  
 D!T1dAt<||zz	 r||$><Pr||$><Pr||$><Pr||$><P	
" 	f/r"   c           	         \        R . ROR. RO/. ROR7      pVP                  R ^ ^R7      p\        R . RO^ R.^,          ^. RO/4      p\        P                  ! W#4       R# rd   rb   r  r   Nr   r
   r   r   r      112233r   r   s   &   r    #test_melt_allows_non_scalar_id_vars,TestMelt.test_melt_allows_non_scalar_id_vars  sf    y#y1$
   

 c9a#AyIJ
f/r"   c           	         \        R . ROR. RO/. ROR7      pVP                  R .^ ^R7      p\        R . RO^ R.^,          ^. RO/4      p\        P                  ! W#4       R# r  r   r   s   &   r    $test_melt_allows_non_string_var_name-TestMelt.test_melt_allows_non_string_var_name  sh    y#y1$
 E  

 c9a#AyIJ
f/r"   c                    \        R . ROR. RO/. R	OR7      p\        P                  ! \        RR7      ;_uu_ 4        VP	                  R .^^.R7       RRR4       R#   + '       g   i     R# ; i)
rd   rb   r  z.* must be a scalar.rl   rv   Nr  r	  r  r   rn   ro   rp   r   r?   r!   s   & r    $test_melt_non_scalar_var_name_raises-TestMelt.test_melt_non_scalar_var_name_raises  sU    y#y1$
 ]]:-DEEGGSEQFG3 FEEEs   AA.	c                    \        R^.R^./4      p\        R	R
.. ROR7      p\        P                  ! VP                  RR.R7      V4       \        P                  ! VP                  R.R7      VRR.,          4       R# )r   r   r   r<   rU   ru   Nrc   r   rb   )r   rd   r   )r   rb   r
   )r   r   r<   )r   rJ   rK   r   )r?   r!   r^   s   &  r    %test_melt_multiindex_columns_var_name.TestMelt.test_melt_multiindex_columns_var_name  sw    
QCaS9:M*4P
 	bgg/BgCXN
bggyg98WgDV;WXr"   c                    \        R^.R^./4      p\        P                  ! \        RR7      ;_uu_ 4        VP	                  . ROR7       RRR4       R#   + '       g   i     R# ; i)r   z,but the dataframe columns only have 2 levelsrl   ru   Nrc   r  )r   r   r   r  r  s   & r    .test_melt_multiindex_columns_var_name_too_many7TestMelt.test_melt_multiindex_columns_var_name_too_many%  sV    
QCaS9:]]L
 
 GG9G:
 
 
 
s   AA&	c                    \        . RO. R	O.. R
OR7      pRp\        P                  ! \        VR7      ;_uu_ 4        VP	                  R.R.R7       RRR4       R#   + '       g   i     R# ; i)r   r   r   rU   z)id_vars cannot contain duplicate columns.rl   rD   Nr  )r   r   r   )r   r   r   r  r   s   &  r    (test_melt_duplicate_column_header_raises1TestMelt.test_melt_duplicate_column_header_raises.  sL    	9-G9]]:S11GGSEseG4 2111s   AA-	r2   Nr*   r,   r)   rc   re   )rd   rb   r   rd   r   )r   r   r   r   r   )/__name__
__module____qualname____firstlineno__rA   rL   rR   rZ   rn   markparametrizetupler   r   arrayr_   rf   ri   rr   r~   r   r   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____classdictcell____classdict__s   @r    r9   r9   6   sh    @MO2  [[WudBHH&=>0 ?00 [[2 !Xq)Q	BAsAsAs3aAxGD		 !Xq)Q	BAsAsAs3aAxGD			
20320 [[*&\:&$	
==264:(=T [[[1e*58 68? [[vq\:NN45	
00*0 /D	0000$00 [[Wvw&780 90"0('0R004	Y;5 5r"   r9   c                   &   a  ] tR tRt o R tRtV tR# )TestLreshapei7  c                    R . R*OR. R+OR. R,OR. R-OR. R.OR
R\         P                  RRR.RR\         P                  \         P                  RR.R. R/ORR\         P                  RRR.RR\         P                  \         P                  RR./
p\        V4      pR\        ^^4       Uu. uF	  pRVR 2NK  	  upR\        ^^4       Uu. uF	  pRVR 2NK  	  up/p\	        W$4      pR . R0OR. R1OR. R2OR. R3OR. R4OR. R5O/p\        WeP
                  R$7      p\        P                  ! WW4       \	        W$R%R&7      pR . R6OR. R7OR. R8OR. R9ORRRRRR	R\         P                  RRRR\         P                  \         P                  RR.RR RR!R"R#R\         P                  RRRR\         P                  \         P                  RR./p\        WeP
                  R$7      p\        P                  ! WW4       R\        ^^4       Uu. uF	  pRVR 2NK  	  upR\        ^^4       Uu. uF	  pRVR 2NK  	  up/pR'p\        P                  ! \        VR(7      ;_uu_ 4        \	        W$4       R)R)R)4       R)# u upi u upi u upi u upi   + '       g   i     R)# ; i):birthdt	11jan2009birthwtr   sexvisitdt1	22dec2008	04jan2009	29dec2008	20jan2009visitdt2	21jan2009	22jan2009	31dec2008	03feb2009visitdt3	05feb2009	02jan2009	15feb2009wt1wt2     l@     @     @     ߱@wt3     @     b@     Ų@visitdtr   wt     |@     4@     ĩ@     Ұ@rU   F)dropnaz$All column lists must be same lengthrl   N)	08jan2009	20dec2008	30dec2008	21dec2008r3  )      C  %  )e   f   g   h   i   )MaleFemalerd  rd  rd  )r3  r7  r8  r9  r:  )i  i
  i  i  i  )rU  rV  rW  rX  r3  rU  rW  rX  r3  rU  rX  r3  )rY  rZ  r[  r\  r]  rY  r[  r\  r]  rY  r\  r]  )r^  r_  r`  ra  rb  r^  r`  ra  rb  r^  ra  rb  )rc  rd  rd  rd  rd  rc  rd  rd  rd  rc  rd  rd  )r3  r7  r8  r9  r:  r<  r=  r>  r?  rA  rB  rC  )rP  rH  rQ  rR  rS  rF  rG  rH  rI  rK  rL  rM  )rU  rV  rW  rX  r3  rU  rV  rW  rX  r3  rU  rV  rW  rX  r3  )rY  rZ  r[  r\  r]  rY  rZ  r[  r\  r]  rY  rZ  r[  r\  r]  )r^  r_  r`  ra  rb  r^  r_  r`  ra  rb  r^  r_  r`  ra  rb  )rc  rd  rd  rd  rd  rc  rd  rd  rd  rd  rc  rd  rd  rd  rd  )r   nanr   r   r   r   rJ   rK   rn   ro   rp   )	r?   r   r!   ispecr@   exp_dataexprq   s	   &        r    
test_pairsTestLreshape.test_pairs8  s     5+C  bffk;Tbffbffk;O1FBFFFFF;FBFFBFFFF;-
2 t_ q!=A'!A=uQ{3{!R!u:{3
 "#     N     uH
R ..9
f*"51 "  "  "  " " mg
P ..9
f* q!=A'!A=uQ{3{!R!u:{3
 5]]:S11R 21E >3z >3 211s$   %I(I-
9I2I7
I<<J	r2   N)r#  r$  r%  r&  rj  r+  r,  r-  s   @r    r0  r0  7  s     ` `r"   r0  c                      a  ] tR tRt o R tR tR tR tR tR t	R t
R	 tR
 tR tR tR tR tR tR tR tR tR tR tRtV tR# )TestWideToLongi  c                   \         P                  P                  ^4      P                  ^4      p\	        R^ R^R^R/R^ R^R^R/R	^ R
^R^R/R^ R^R^R/R\        \        \        ^4      V4      4      /4      pVP                  VR&   RVP                  4       VP                  4       ,           R. ROR. ROR. ROR. RO/p\	        V4      pVP                  RR.4      . RO,          p\        VRR.RRR7      p\        P                  ! WT4       R# )r
   A1970rd   rb   r   A1980r   efB1970      @333333?ffffff?B1980皙	@?皙?r   r   r   r   yearrf  jNrd   rb   r   r   rq  rr  rt  ru  rv  rx  ry  rz    r  r    r  r  r   r   r
   r   r   r
   r   r   r   r   r   r   r   r   dictzipr   r   r>   	set_indexr   rJ   rK   r?   r   r!   rh  r^   r@   s   &     r    test_simpleTestWideToLong.test_simple  s   II!!!$44Q7!S!S!S1!S!S!S1!S!S!S1!S!S!S1T#eAh*+
 884ahhj(//8$
 X&%%tVn5oFb3*?
f/r"   c                t    \        . RO. RO.4      p. R	OVn        RR.p\        WRRR7       VRR.8X  g   Q hR# )
r   r   inceduager|  N)r   r   r
   r      )r   r   r
     	   )r   inc1inc2edu1edu2)r   r   r   )r?   r!   stubss   &  r    
test_stubsTestWideToLong.test_stubs4  s?    9:;
R$%0&&&r"   c                   \         P                  P                  ^4      P                  ^4      p\	        R^ R^R^R/R^ R^R^R/R	^ R
^R^R/R^ R^R^R/R\        \        \        ^4      V4      4      /4      pVP                  VR&   RVP                  4       VP                  4       ,           R. ROR. ROR. ROR. RO/p\	        V4      pVP                  RR.4      . RO,          p\        VRR.RRRR7      p\        P                  ! WT4       R# )r
   zA.1970rd   rb   r   zA.1980r   rq  rr  zB.1970rt  ru  rv  zB.1980rx  ry  rz  r   r   r   r   r{  .rf  r}  sepNr~  r  r  r  r  r  r  s   &     r    test_separating_character(TestWideToLong.test_separating_character>  s    II!!!$44Q71c1c1c21c1c1c21c1c1c21c1c1c2T#eAh*+
 884ahhj(//8$
 X&%%tVn5oFb3*CH
f/r"   c                   \         P                  P                  ^4      P                  ^4      p\	        R^ R^R^R/R^ R^R^R/R	^ R
^R^R/R^ R^R^R/R\        \        \        ^4      V4      4      /4      pVP                  VR&   RVP                  4       VP                  4       ,           R. ROR. ROR. ROR. RO/p\	        V4      pVP                  RR.4      . RO,          p\        VRR.RRR7      p\        P                  ! WT4       R# )r
   zA(quarterly)1970rd   rb   r   zA(quarterly)1980r   rq  rr  zB(quarterly)1970rt  ru  rv  zB(quarterly)1980rx  ry  rz  r   r   A(quarterly)B(quarterly)r{  r|  Nr~  r  r  r  )r   r  r  r  r  s   &     r    test_escapable_characters(TestWideToLong.test_escapable_charactersX  s   II!!!$44Q7"QQQ$<"QQQ$<"QQQ$<"QQQ$<T#eAh*+
 884ahhj(::8$
 X&%%tVn51
 b>>"BdfU
f/r"   c                ^   \        R RR.RRR.RRR.R	R
R./4      pVP                  VR&   R	. ROR. RORRR\        P                  \        P                  .R. ROR. RO/p\        V4      pVP	                  RR.4      . RO,          p\        VRR.RRR7      p\        P                  ! WC4       R# )A2010      ?       @A2011      @      @B2010      @      @r   X1X2r   r   r   r{  r|  Nr  r  r  r  r  r  r  r  )r   r   r   r   )  r    r  r  )r   r   r   re  r  r   rJ   rK   r?   r!   rh  r^   r@   s   &    r    test_unbalancedTestWideToLong.test_unbalancedr  s    #s#s#sdD\	
 884)%#sBFFBFF+,,
 X&%%tVn5oFb3*?
f/r"   c                   \        R . ROR. ROR. ROR. ROR. ROR. ROR. ROR. RO/4      pVP                  VR&   \        R. ROR. ROR	. ROR
. ROR. ROR. ROR. RO/4      pVP                  RR.4      . RO,          p\        V. RORRR7      p\        P
                  ! VP                  ^R7      VP                  ^R7      4       R# )A11A12B11B12BB11BB12BBBXBBBZr   r   r   BBr{  r|  axisNa11a22a33a21r  a23b11b12b13b21b22b23r  r	  [   \   ]   r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r  r   r
   r   r   r   r
  r     r  r     r  r  )r  r  r   r   r  r   r   r  r   r   r  r   rJ   rK   
sort_indexr?   r!   r^   r@   s   &   r    test_character_overlap%TestWideToLong.test_character_overlap  s    ,,,,			
 88400??((0

 %%tVn56VWb"2dfE
f//Q/79L9LRS9L9TUr"   c                   R p\        RRR.RRR.RRR	.R
RR./4      pVP                  VR&   R
RR. R. R. R. R. R. R. /p\        V4      P                  R\        P                  /4      pVP                  RR.4      . RO,          pVP                  P                  ^ ^.^ R7      Vn        \        VRR.RRVR7      p\        P                  ! VP                  ^R7      VP                  ^R7      4       R# )znope!r  r  r  r  r  r  r  r  r  r   r  r  r    r{  r   r   levelr  r  N)r   r  r  r  r   r   r   r   r   r   r   r  
set_levelsr   rJ   rK   r  )r?   r  r!   rh  r^   r@   s   &     r    test_invalid_separator%TestWideToLong.test_invalid_separator  s   #s#s#sdD\	
 884RRR"B	
 X&--vrxx.@A%%tVn56
 "22Aq62Cb3*CH
f//Q/79L9LRS9L9TUr"   c                   \        R . ROR. ROR. ROR. ROR. ROR. ROR. ROR. RO/4      pVP                  VR&   \        R. ROR. ROR	. ROR
. ROR. ROR. ROR. RO/4      pVP                  RR.4      . RO,          p\        V. RORRR7      p\        P
                  ! VP                  ^R7      VP                  ^R7      4       R# )r  r  r  r  r  r  AratingArating_oldr   r   r   r  r{  r|  r  Nr  r  r  r  r  r	  r  r  r  r  r  r  r  )r  r  r   r   r  r  r  r  s   &   r    test_num_string_disambiguation-TestWideToLong.test_num_string_disambiguation  s     ,,,,		<|	
 88437??((0

 %%tVn56
 b"2dfE
f//Q/79L9LRS9L9TUr"   c                   \        R RR.RRR.RRR.R	R
R./4      pVP                  VR&   R	RR . R. R. R. R. R. R. /p\        V4      P                  R\        P                  /4      pVP                  RR.4      pVP                  P                  ^ ^.^ R7      Vn        \        VRR.RRR7      p\        P                  ! VP                  ^R7      VP                  ^R7      4       R# )Aoner  r  Atwor  r  Boner  r  r   r  r  r   r  r{  r   r   r  r|  r  Nr  r  s   &    r    test_invalid_suffixtype&TestWideToLong.test_invalid_suffixtype  s	    c
c
c
dD\	
 884BBB"B	
 X&--vrxx.@A%%tVn5!22Aq62Cb3*?
f//Q/79L9LRS9L9TUr"   c                    \        R . ROR. R	OR. R
OR. RO/4      p\        R. ROR . ROR. ROR. RO/4      pVP                  . RO4      R.,          p\        VRR R.RR7      p\        P                  ! W24       R# )famidbirthht1ht2htr  r|  N)	r   r   r   r
   r
   r
   r   r   r   )	r   r
   r   r   r
   r   r   r
   r   )	ffffff@333333@皙@r
   ?ffffff?r  ffffff@ @)	333333@ffffff@r  rx  r  333333@ffffff
@r  r  )r  r  r  r  r  r  r  rx  r   r  r  r  r  r  r  r  r  r  )r   r   r   r   r   r   r
   r
   r
   r
   r
   r
   r   r   r   r   r   r   )r   r   r
   r
   r   r   r   r   r
   r
   r   r   r   r   r
   r
   r   r   )r   r
   r   r
   r   r
   r   r
   r   r
   r   r
   r   r
   r   r
   r   r
   )r  r  r  r   r  r   rJ   rK   r  s   &   r    test_multiple_id_columns'TestWideToLong.test_multiple_id_columns  s    44BD	
  ( OOM/
6 %%&?@$Hb$7G*<F
f/r"   c           	         \        R . R
OR. R
OR. RO/4      pRp\        P                  ! \        VR7      ;_uu_ 4        \	        VRR.RRR7       R	R	R	4       R	#   + '       g   i     R	# ; i)A_A1B_B1r   z3the id variables need to uniquely identify each rowrl   A_AB_Bcolnamer|  N)r   r
   r   r   r   )r   r   r   r   r   r   rn   ro   rp   r   r   s   &  r    test_non_unique_idvars%TestWideToLong.test_non_unique_idvars,  sX     _fosOT
 D]]:S11eU^si@ 2111s   AA+	c                    \        R . ROR. ROR. ROR. ROR. RO/4      p\        R. ROR. ROR. ROR. RO/4      P                  RR.4      p\        VRR.RRRR	7      p\        P                  ! W24       R
# )actor_1actor_2actor_fb_likes_1actor_fb_likes_2titleactoractor_fb_likesnum_r  N)CCH PounderJohnny DeppChristoph Waltz)Joel David MooreOrlando BloomRory Kinnear)     @@     @     |@)     @@     @     x@)AvatarPirates of the CaribbeanSpectre)r  r  r   r!  r"  r#  )r$  r%  r&  r'  r(  r)  )r   r   r   r
   r
   r
   )r*  r+  r,  r*  r+  r,  r  r  s   &   r    test_cast_j_intTestWideToLong.test_cast_j_int6  s    LP"$>"$:J
   !"R) 
* )We$
%+ 	, *+w%S
 	f/r"   c                    \        R RR.RRR.RRR.R	R
R./4      pRp\        P                  ! \        VR7      ;_uu_ 4        \	        VR	R.R	RR7       RRR4       R#   + '       g   i     R# ; i)r  r  r  r  r  r  r  r  r  r   r  r  z,stubname can't be identical to a column namerl   r   r  r|  Nr  r   s   &  r    test_identical_stubnames'TestWideToLong.test_identical_stubnames]  sn    #s#s#sdD\	
 =]]:S11c3Z3)< 2111s   AA/	c                &   \        R RR.RRR.RRR.R	R
R./4      p\        R	. ROR. RORRR\        P                  \        P                  .R. RO/4      pVP                  R	R.4      p\	        VRR.R	RRRR7      p\
        P                  ! W24       R# )treatment_placebor  r  treatment_testr  r  result_placebor  r  r   r  r  r  r@   	treatmentz[a-z]+r  rf  r}  suffixr  Nr  )placebor9  testr:  r  r   r   re  r  r   rJ   rK   r  s   &   r    test_nonnumeric_suffix%TestWideToLong.test_nonnumeric_suffixj  s    #c3Z 3* 3*dD\	
 -A3RVVRVV41	
 %%sI&67;'3)HRU
 	f/r"   c                    \        R RR.R^ ^	.RRR.RRR	.R
RR./4      p\        R . ROR. ROR. ROR. RO/4      P                  R R.4      p\        VRR.R RRRR7      p\        P                  ! W24       R# )r   r  r  result_1
result_foor  r  treatment_1r  r  treatment_foor  r  r  r@   r6  z.+r  r7  Nr  )1rC  r   r   )              "@r  r  r  r  r  s   &   r    test_mixed_type_suffix%TestWideToLong.test_mixed_type_suffix  s    dD\QFsCjSz#s
 -3.1	
 )S)$
% 	 ;'3)Dc
 	f/r"   c                   \        R RR.RRR.RRR.R	^ ^	.R
RR./4      p\        R
. ROR. RORRRRR\        P                  \        P                  \        P                  \        P                  .R\        P                  \        P                  \        P                  \        P                  RRRR./4      pVP                  R
R.4      p\	        VRR.R
RRRR7      p\
        P                  ! W24       R# )ztreatment_1.1r  r  ztreatment_2.1r  r  z
result_1.2r  r  r?  r   r  r  r  r@   rD  rE  r6  z[0-9.]+r  r7  N)r  r  r  r  r  r  r  r  )ru  ru  r  r  皙?rI  r  r  r;  r  s   &   r    test_float_suffix TestWideToLong.test_float_suffix  s    #s#ssCjQFdD\
 EC3S#rvvrvvrvvrvvNbffbffbffbffc3SQ	
 %%sI&67;'3)ISV
 	f/r"   c                    R ^ ^ ^^^^^^^^/R^ R^R^R^R^R/R^ R^R	^R	^R
^R/R^ R^R^R^R
^R/R^ R^R^R^R
^R//p\         P                  ! V4      p\        VR.R R.RR7      p\        VRR R.RR7      p\        P                  ! WC4       R# )node_idr   g?rD  g      ?r  gQ?PA0gGz?gQ?g\(\?g333333?PA1gp=
ף?g{Gz?gp=
ף?gq=
ףp?PA3g(\?rv  PAtime)	stubnamesrf  r}  N)r   	from_dictr   rJ   rK   )r?   	wide_datawide_dfr^   r@   s   &    r    test_col_substring_of_stubname-TestWideToLong.test_col_substring_of_stubname  s    
 1aAq!Q15!T1c1dAsAt<AtQaq$3?AtQaq$4@AtQaq$4@
	 %%i0D6i=MQWXg)S9IVT
f/r"   c           
        \        R \        R4      R\        ^
^^4      /4      p\        P                  ! \
        \        P                  ! R4      R7      ;_uu_ 4        VP                  RRR7       RRR4       R#   + '       g   i     R# ; i)r   r%   r<   zvalue_name (value) cannot matchrl   r   N)	r   r   r   rn   ro   rp   reescaper   r  s   & r    test_raise_of_column_name_value.TestWideToLong.test_raise_of_column_name_value  sk     tE{GU2r15EFG]]bii(IJ
 
 GGGG8
 
 
 
s   A::B	c           	        \        R RR.R^d^.RRR./4      pVP                  R V/4      p\        VRR.R R	R
R7      p\        . RORR7      p\        R. ROR\        P
                  .^,          /VR7      pVP                  P                  ^ ,          P                  V4      pVR8X  d-   VP                  P                  ^ ,          P                  R4      pVP                  P                  V^ R7      Vn        \        P                  ! W54       R# )r   rC  2za-1za-2,    rd   rb   r  -)rS  rf  r}  r  )r   r   r   strr  N))rC  r   )r_  r   )rC  r
   )r_  r
   )r   r  )d      r`  ra  )r   r   r   r   r   re  r   levelsr  rJ   rK   )r?   any_string_dtyper!   r@   r   r^   	new_levels   &&     r    test_missing_stubname$TestWideToLong.test_missing_stubname  s    sCj%#sUS#JOPYY./0Cj
 4
 &bffX\:
 NN))!,334DE	x' --a077>I!229A2F
f/r"   r2   N)r#  r$  r%  r&  r  r  r  r  r  r  r  r  r  r	  r  r-  r0  r<  rF  rJ  rW  r\  ri  r+  r,  r-  s   @r    rm  rm    sq     00'04040.V<V<VBV:'0RA%0N=0.0.000 	90 0r"   rm  c                    \         P                  ! V \        P                  R 7      p\	        R^ ^/R^ ^/R^ ^/R^ ^/R^ ^//4      pVP
                  P                  V4      Vn        \        VRRRRR	R
7      p\	        ^^.^^.^^..\        RR.4      \         P                  P                  . RO\        . ROVR7      .RR.R7      R7      p\        P                  ! W44       R# ))na_valueIDR_test1R_test2R_test3DR	UNPIVOTEDr  z.*)rS  rf  r}  r  r8  r   r   r   N)r   r   r   )test1test2test3)r   StringDtyper   re  r   r   r   r   r   r   from_arraysrJ   rK   )string_storagestring_dtyper!   r@   r^   s   &    r     test_wide_to_long_string_columnsr{    s    >>.266BL	1a&1v1v1v!Q	

B ""<0BJ
cT[c$F 
Q!Q!Q sCj!mm''1F % ( 

H &+r"   )rZ  numpyr   rn   pandasr   r   r   r   r   r   r   pandas._testing_testingrJ   fixturer!   r/   r3   r7   r9   r0  rm  r{  r2   r"   r    <module>r     s    	        
 
    ~5 ~5Ba aHG0 G0T,r"   