+
    xȇi"                        ^ RI t^ RIt^ RIHt ^ RIt^ RIHtHt ^ RI	H
t ]P                  P                  RR.RRR]P                  .]P                  R	.R
]P                  .]P                  R.R]P                  .]P                  R.R]P                  .]P                  R..]! ^^.RR7      ]! . R'ORR7      3R.R]P                  R	]P                  R	]P                  R]P                  .]P                  R	]P                  R	]P                  R	.R	]P                  R
]P                  R
]P                  .]P                  R	]P                  R
]P                  R.R
]P                  R	]P                  R]P                  .]P                  R
]P                  R	]P                  R.R
]P                  R
]P                  R]P                  .]P                  R
]P                  R
]P                  R..]P                   ! . R(ORR.R7      ]! . R'ORR7      3RR.RR^ ^.^^.^^.^^..]! ^^.RR7      ]P                   ! . R)ORR.R7      3RR.R]P                  . R*O. R+O. R,O. R-O.]P                   ! . R.ORR.R7      ]P                   ! . R)ORR.R7      3.4      R 4       t]P                  P                  RRR.RR]P                  .]P                  R	.R
]P                  .]P                  R.R]P                  .]P                  R.R]P                  .]P                  R..]! ^^.RR7      ]! . R'ORR7      3RR.R.R^ ^.^^.^^.^^..]! ^^.RR7      ]P                   ! . R)ORR.R7      3R.RR.R. R/O. R0O.]P                   ! . R)ORR.R7      ]! ^^.RR7      3RR.RR.RRR	]P                  ]P                  ]P                  ]P                  ]P                  ]P                  .]P                  ]P                  R
R]P                  ]P                  ]P                  ]P                  .]P                  ]P                  ]P                  ]P                  RR]P                  ]P                  .]P                  ]P                  ]P                  ]P                  ]P                  ]P                  RR..]P                   ! . R1ORR.R7      ]P                   ! . R)ORR.R7      3.4      R 4       tR tR t]P                  P                  RRRR.R]P                  R]P                  .]P                  R]P                  R..]! RR .RR!7      ]P*                  ! . R2O. R3O.RR.R"7      3RR.RR]P                  .]P                  R.R]P                  .]P                  R..]P*                  ! . R4O. R3O.RR.R"7      ]! ^^.RR!7      3.R#R$.R%7      R& 4       tR# )5    N)lib)Index
MultiIndexz[input_index, input_columns, input_values, expected_values, expected_columns, expected_indexlev4lev3valuesg              ?       @      @      @g      @g      @      @namelev1lev2namesc                     \         P                  ! R . ROR. R	OR. R
OR. ROR. RO/4      pVP                  WVR7      p\         P                  ! W4VR7      p\        P                  ! Wx4       R# r   r   r   r   r   )indexcolumnsr   )r   r   N)   r   r   r      r   r   r   )r   r   r   r   r   r   r   r   )r   r   r   r   r   r   r   r   r   r                     )r   r   r   r   r   r   r   r   pd	DataFramepivottmassert_frame_equal	input_indexinput_columnsinput_valuesexpected_valuesexpected_columnsexpected_indexdfresultexpecteds	   &&&&&&   z/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/reshape/test_pivot_multilevel.pytest_pivot_list_like_indexr2      sm    d 
,,,,.	

B XXK|XTF||H &+    c                     \         P                  ! R . ROR. R	OR. R
OR. ROR. RO/4      pVP                  WVR7      p\         P                  ! W4VR7      p\        P                  ! Wx4       R# r   r!   r'   s	   &&&&&&   r1   test_pivot_list_like_columnsr5   q   sm    L 
,,,,.	

B XXK|XTF||H &+r3   c            
         \         P                  ! \        P                  ! ^4      P	                  ^^4      \
        P                  ! . RORR.R7      \
        P                  ! . RO. ROR7      R7      p V P                  R.R.R.R R7      p\         P                  ! ^\        P                  .^
R	..\
        P                  ! RR.. ROR7      \        ^ ^.R
RR7      R7      pVP                  R4      p\        P                  ! W4       R# )   col_L0col_L1r   idx_L0idx_L1)datar   r   c                 6    V P                   P                  4       # )N)r   sum)cols   &r1   <lambda>7test_pivot_multiindexed_rows_and_cols.<locals>.<lambda>   s    CJJNN,r3   )r   r   r   aggfuncr   int64)dtyper   float64Nr   r   ))r   r   rF   )r   r   ))r   r   r   )r   r   r   )r   r   r   )r   r   r   )r:   r;   idx_L2)r   r   r   )r   r   r   )r8   r9   r;   )r"   r#   nparangereshaper   from_tuplespivot_tablenanr   astyper%   r&   )r.   resr0   s      r1   %test_pivot_multiindexed_rows_and_colsrP      s     
YYr]""1a(&&$Xx,@
 $$80
	
B ..j
x,	  C ||"&&kB9%&&	"*H
 QF'9H y)H#(r3   c            	         \         P                  ! . RO. RO. RO. RO.. ROR7      p V P                  RR.4      p V P                  RRR7      p\         P                  ! R	\        P
                  .\        P
                  R
.R\        P
                  .\        P
                  R..V P                  \        RR.RR7      R7      p\        P                  ! W4       R# )Alabel1label2index_1index_2labelvalue)r   )r   r   r	   r
   r   r   r   )r   r   N)rR   A1rS   r   )rR   A2rT   r   )BrY   rS   r   )r[   rZ   rT   r   )rU   rV   rW   rX   )
r"   r#   	set_indexr$   rH   rM   r   r   r%   r&   )r.   r/   r0   s      r1   #test_pivot_df_multiindex_index_noner]      s    	$$$$		
 9
B 
y),	-BXXggX6F||
rvvRVV}rvvsmDhhx*9H
 &+r3   z'index, columns, e_data, e_index, e_colsr   r?   rX   g      I@g      Y@g      i@rR   r[   )r<   r   )arraysr   zvalues-and-columnszvalues-and-index)idsc                     . RO. RO. RO. R	O.p\         P                  ! V. R
OR7      pVP                  RWR7      p\         P                  ! W#VR7      p\        P                  ! Wx4       R# )rR   rX   )r<   r   )r   r   r   )r<   r   r   N)rR   r   2   )r[   r   d   )rR   r   rc   rd   )r[   r      )r   r?   rX   extra)r"   r#   rL   r%   r&   )	r   r   e_datae_indexe_colsr<   r.   r/   r0   s	   &&&&&    r1   0test_pivot_table_multiindex_values_as_two_paramsrk      s[    L 		D 
4)K	LB^^7%^IF||GH&+r3   r   ))r   r   )r   r   )r   r   )r   r   r   r   r   r   )r   r   )r   r   )r   r   r   r   )r   r   r   r   )r   r   r   r   )r   r   r   r   )r   r    r   r   ))r   r   )r   r   rl   rm   )r   r   r   r   )r   r   r   r   )rn   ro   )r   r   )r   r   )r   r   )r   r   )r   r   )r   r    )r   r   r   r   )ra   rc   rc   re   )rR   rR   r[   r[   )numpyrH   pytestpandas._libsr   pandasr"   r   r   pandas._testing_testingr%   markparametrizerM   
no_defaultrK   r2   r5   rP   r]   from_arraysrk    r3   r1   <module>r{      s6        8 Hbffbffbffbff	 1a&v&*8	
$ HNNbffc26637bffc26637bffc26637bffc26637bffc26637bffc26637bffc26637bffc26637	 "" Vn
 *83	
8 VVaVaVaV,1a&v&""08H		
 VNN<|D""HVn ""08H	
oDHR,SHR,4 8 Hbffbffbffbff	 1a&v&*8	
$ VHVaVaVaV,1a&v&""08H		
 HV<(""08H 1a&v&		
 VVc266266266266266266Jc266266266266Jc266266JcJ	 ""Pv& ""08H	
M8<z,{<z,4)B,, - Grvvubff-. Sz0""$&9:5'BR	
 grvv	 "",.AB( 1vE*	
: 
12?   B,C B,r3   