+
    xȇi1                     r    ^ RI t ^ RIt^ RIt^ RIt^ RIHtHtHtH	t	 ^ RI
Ht  ! R R4      t ! R R4      tR# )    N)
ArrowDtype	DataFrame
MultiIndexSeriesc                   f  a  ] tR t^t o R tR tR tR tR tR t	R t
R tR	 tR
 tR t]P                   P#                  R^R.4      R 4       tR tR tR tR t]P                   P#                  RR]P0                  .4      R 4       tR t]P                   P7                  R4      R 4       tRtV tR# )TestMultiLevelc                   TpVP                  R 4      P                  4       pVP                  VP                  ^R7      pVP                  R R7      P	                  R4      p\
        P                  ! WE4       VR,          P                  VP                  ^R7      pVR,          P                  R R7      P	                  R4      p\
        P                  ! WERR7       R# )monthlevelsumAFcheck_namesN)groupbyr   reindexindex	transformtmassert_frame_equalassert_series_equal)self/multiindex_year_month_day_dataframe_random_dataymd
month_sumsresultexpecteds   &&    l/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/test_multilevel.pytest_reindex_level!TestMultiLevel.test_reindex_level   s    =[[)--/
##CIIQ#7;;W;-77>
f/ C((!(<s8##'#2<<UC
vUC    c                    TpVP                   ^ ^.,          pVP                  RR.,          p\        P                  ! WC4       R# )r   Nfooonebarr%   )iloclocr   r   )r    multiindex_dataframe_random_dataframer   	reindexeds   &&   r   test_reindexTestMultiLevel.test_reindex    s:    0::q!f%II~~>?	
i2r!   c                   TpVP                   R ,          pVP                  V4      pVP                   P                  V4      '       g   Q hVP                  V,          pVP                   P	                  V4      '       g   Q hVP
                  pVP                  VR7      pVP                  P                  V4      '       g   Q hVP                  RV3,          pVP                  P	                  V4      '       g   Q hR# ):NN
   columnsNNNN)r   r   is_r)   equalsTr2   )r   r   r   	new_indexchunkymdTs   &&    r   test_reindex_preserve_levels+TestMultiLevel.test_reindex_preserve_levels'   s     >IIdO	I&{{y))))	"{{!!),,,,uuY/}}  ++++I&}}##I....r!   c                &   TpVR ,          pVP                   P                  ^ 4      pVP                  VRR7      pVP                  R 4      pVP	                  R 4      pVP                  VP                   4      p\        P                  ! WRR7       R# )r   F)
group_keysc                     V ^,          #     xs   &r   <lambda>7TestMultiLevel.test_groupby_transform.<locals>.<lambda>B   s    !a%r!   c                     V ^,          # r?   rA   rB   s   &r   rD   rE   C   s    q1ur!   r   N)r   get_level_valuesr   applyr   r   r   r   )	r   r*   r+   sgroupergroupedappliedr   r   s	   &&       r   test_groupby_transform%TestMultiLevel.test_groupby_transform:   sv    0#J''**1-))G)6--0$$_50
vUCr!   c                    \        R .R.R..^ .^ .^ ... ROR7      p\        \        P                  P	                  ^4      P                  ^4      .. R	OVR7      pVP                  RR7       R# )
r$   r'   bazthreelevelscodesnames)r2   r   r   N)r%   tworQ   abcd)r   r   nprandomdefault_rngr   )r   midxdfs   &  r   test_groupby_corner"TestMultiLevel.test_groupby_cornerG   sp    GeWug.3aS/)

 YY""1%,,Q/0(
 	


!r!   c                    TpVR ,          P                   pVR,          VR&   \        VP                  \        4      '       g   Q hVR,          VR,          8H  P	                  4       '       g   Q hR# ):N   NN)        )re   rf   r0   )r6   
isinstancer2   r   all)r   r   r   r`   s   &&  r   .test_setitem_with_expansion_multiindex_columns=TestMultiLevel.test_setitem_with_expansion_multiindex_columnsU   s\     >WYYZ.;"**j1111;2j>1668888r!   c                l   \        . RO\        P                  ! . RO4      R7      p\        . RO\        P                  ! . RO4      R7      pW,
          pVP                  P	                  VP                  4      pVP                  V4      VP                  V4      ,
          p\        P                  ! W54       VRRR1,          VRRR1,          ,
          pVP                  P	                  VP                  4      pVP                  V4      VP                  V4      ,
          p\        P                  ! W54       R# )rf   datar   Nrf   r@      ))r   rf   )r   r@   Brp   )   rd      ))Zrf   )ru   r@   rq   )r   r   from_tuplesr   unionr   r   r   )r   rC   yres	exp_indexexps   &     r   test_alignmentTestMultiLevel.test_alignment_   s    *"8"89W"X
 *"8"89W"X
 eGGMM!''*	ii	"QYYy%99
s( "g$B$GGMM!''*	ii	"QYYy%99
s(r!   c                8   TpVP                  ^ ^.R7      P                  4       pVP                  P                  ^ 4      pVP                  P                  ^4      pVP                  WE.4      P                  4       p\        P
                  ! W64       VP                  P                  VP                  P                  R,          8X  g   Q hVP                  VP                  P                  R,          R7      P                  4       p\        P
                  ! W74       R# )r   r   Nr@   NN)r   meanr   rG   r   r   rU   )r   r   r   r   k1k2r   result2s   &&      r   test_groupby_multilevel&TestMultiLevel.test_groupby_multilevels   s    =Aq6*//1YY''*YY''*;;x(--/
f/||!!SYY__R%8888++CIIOOB$7+8==?
f.r!   c                    \         P                  ! . RO4      p\        \        P                  P                  ^4      P                  R4      WR7      pVP                  ^R7      VR&   VP                  4       pR# )r$   r   r2   )axisN)r#   )r$   rV   r&   )r'   rV   )rs   rs   )Totals )	r   rw   r   r\   r]   r^   standard_normalr   _consolidate)r   r   r`   s   &  r   test_multilevel_consolidate*TestMultiLevel.test_multilevel_consolidate   sb    &&L
 II!!!$44V<E
 66q6><__r!   c                n   \        . RO^ ^... R	O. R
O.R7      p\        \        P                  P	                  ^4      P                  ^4      VR7      p\        \        P                  P	                  ^4      P                  R4      VR7      pVR,          pVP                  R,          pVR,          pVP                  P                  ^ 4      Vn        \        P                  ! WF4       \        P                  ! WV4       \        P                  ! \        RR7      ;_uu_ 4        VR,           RRR4       VP                  R,          pVP                  R4      pVR,          pVP                  P                  ^ 4      Vn        \        P                   ! WF4       \        P                   ! WV4       \        . RO^ ^... R	O. R
O.R7      p\        \        P                  P	                  ^4      P                  ^4      VR7      p\        \        P                  P	                  ^4      P                  R4      VR7      pVR,          pVP                  R,          pVR,          pVP                  P                  ^ 4      Vn        \        P                  ! WF4       \        P                  ! WV4       VP                  R,          pVP                  R4      pVR,          pVP                  P                  ^ 4      Vn        \        P                   ! WF4       \        P                   ! WV4       R#   + '       g   i     EL; i)r$   )rS   rT   r   r   z^\(\('foo', 'bar', 0\), 2\)$)matchNr$   r'   r   )r   )r$   rP   r   )r$   quxr   )r   r   rf   rf   r@   r@   )r   rf   r   rf   r   rf   )rt   rs   )r   r@   r$   r'   )r   )r$   rP   )r$   r   )r   r   r\   r]   r^   r   r   r)   r   	droplevelr   r   pytestraisesKeyErrorxsr   )r   r   seriesr+   r   r   r   s   &      r   test_level_with_tuples%TestMultiLevel.test_level_with_tuples   sh   MPQSTvV%'9:

 		--a0@@C5Q"))//2BB6JRWX)***./":!11!4
v0
w1]]8+JKK'( L ,-((,-9!11!4
f/
g0Dq!fM%'9:

 		--a0@@C5Q"))//2BB6JRWX'**^,":!11!4
v0
w1>*((>*9!11!4
f/
g0= LKKs   !
L##L4	c                T   TpVP                  R R.^ R7      pVP                  . RO,          p\        P                  ! W44       VP                  P                  R R.^^ R7      p\        P                  ! W4P                  4       VP
                  R R.,          p\        P                  ! W44       VR,          P
                  R R.,          p\        P                  ! W4R,          4       VP                  P
                  RR R.3,          p\        P                  ! W4P                  4       R# )r$   r   r   )r   r   r   r3   N)r   rf   r@   rg      	   )r   r(   r   r   r6   r)   r   )r   r*   r+   r   r   s   &&   r   $test_reindex_level_partial_selection3TestMultiLevel.test_reindex_level_partial_selection   s    0u~Q7::01
f/%aqA
fjj1E5>*
f/s/
v}5Q./
fjj1r!   r[   c           
        . ROp\        R ^.R^.R^.RV./4      pW3P                  ^8H  ,          P                  V4      pVP                  4       P                  p\        ^.^.^... . . .. ROR7      p\        P                  ! WV4       R# )rX   rY   rZ   r[   rR   N)rX   rY   rZ   )r   rX   r   firstr   r   r   assert_index_equal)r   r[   r=   r`   gr   r   s   &&     r   +test_empty_frame_groupby_dtypes_consistency:TestMultiLevel.test_empty_frame_groupby_dtypes_consistency   s     %
aS#sC!cA3?@ttqyM!!*-C!qc?2r2,o
 	f/r!   c                    . ROp. ROp\         P                  ! VRR.R7      p\        W#R7      pVP                  VP                  4      P                  4       p\        V4      ^8X  g   Q hR# )600809STK_IDRPT_DaterU   r   N))r   20061231r   20070331)r   20070630r   )demor   r   r   )r   rw   r   r   r   r   len)r   idx_tpdtidxrI   r   s   &     r   test_duplicate_groupby_issues,TestMultiLevel.test_duplicate_groupby_issues   s^    
 .$$VHj3IJ2!177#))+6{ar!   c                (   R ^..pRR\         P                  3R.p\        V\        P                  ! V4      R7      pVP
                  P                  P                  pVP                  P                  P
                  p\        P                  ! WT4       R# )rC   rX   rY   r1   N)rX   rZ           )
r\   nanr   r   rw   dtypesrX   rY   r   r   )r   rn   r2   r`   r   r   s   &     r   test_subsets_multiindex_dtype,TestMultiLevel.test_subsets_multiindex_dtype   si    azbff%7tZ%;%;G%DE99;;==
v0r!   c                F   ^ \         P                  ! R^^4      3R^R^
/^ \         P                  ! R^^4      3R^R^/^\         P                  ! R^^4      3R^R^/^\         P                  ! R^^4      3R^R^//p\        P                  ! VRR7      pR. ROR. R	O/p. R
O\         P                  ! R^^4      \         P                  ! R^^4      \         P                  ! R^^4      \         P                  ! R^^4      ..p\        W4R7      p\        P
                  ! W%4       R# )r   i  r   rr   r   )orientrm   N)rf   r@   rp   rs   )r0            )r   r   rf   rf   )datetimedater   	from_dictr   r   )r   data_dicr   rn   r   r   s   &     r   test_datetime_object_multiindex.TestMultiLevel.test_datetime_object_multiindex   s   dAq)*S!S",=dAq)*S!S",=dAq)*S!S",=dAq)*S!S",=	
 $$Xg>\3(89dAq)dAq)dAq)dAq)	
 $4
f/r!   c           	     Z   \        R \        P                  RR.. R	O. R
O.. ROR7      P                  RR.4      pRVP                  R&   \        R \        P                  RR.. R	O. R
OR R\        P                  R... ROR7      P                  RR.4      p\
        P                  ! W4       R# )r   Gz?=
ףp=@pivot_0pivot_1r1   r   FN)r   Gr   r   )r   Dg=
ףp#@gGz%@)r   r   col_1col_2))r   r   r   )r   r\   r   	set_indexatr   r   )r   r`   r   s   &  r   test_multiindex_with_na&TestMultiLevel.test_multiindex_with_na  s    bffdD)&'
 =
 )Y	*
+ 	 &)!"bffdD)&'c2663'	 =
 )Y	*
+ 	 	b+r!   naNc                    \        ^ .R.R..R7      p^W!R3&   \        P                  ! W!,          \        ^.R.R7      4       R# )r   r   rr   r1   N)r   r   r   )r   r   r`   s   && r   $test_multiindex_insert_level_with_na3TestMultiLevel.test_multiindex_insert_level_with_na$  sB     scUSEN3s7
bficU&CDr!   c                   \        ^\        P                  ^\        P                  .^\        P                  ^\        P                  .\        P                  ^\        P                  ^.\        P                  ^\        P                  ^..\        . RO\        RR7      \
        P                  ! RR.\        P                  ! R^^4      \        P                  ! R^^4      ..RR.R7      R	7      pVP                  4       pWP                  ^ ,          ,          p\        . ROR\        P                  3R
7      p\        P                  ! W#4       R# )rf   sub)dtypenamevalue1value2i  NDater   r   )r   rW   )r   r\   r   r   objectr   from_productr   reset_indexr2   r   r   )r   r`   r   r   s   &   r   test_multiindex_dt_with_nan*TestMultiLevel.test_multiindex_dt_with_nan+  s    BFFArvv&BFFArvv&BFFA&BFFA&	 -V%H++x(&&tR3X5F5FtRQR5ST Vn
  ^^JJqM".eRVV_E
v0r!   z0ignore:Passing a BlockManager:DeprecationWarningc           
        \         P                  ! R 4      p\        R. R	OR. R
O/4      P                  R\	        VP                  VP                  4       VP                  4       4      4      RR/4      pVP                  RR.4      p\        \        P                  ! . R	O. R
O.RR.R7      R7      p\        P                  ! VVRRR7       R# )pyarrowstring_columnnumber_columnzfloat[pyarrow]r   r   F)check_index_typecheck_column_typeNr   rr   Cro   )r   importorskipr   astyper   
dictionaryint32stringr   r   from_arraysr   r   )r   par`   df_expecteds   &   r   (test_multiindex_with_pyarrow_categorical7TestMultiLevel.test_multiindex_with_pyarrow_categoricalB  s       +o	J

&BMM"((*biik,R!S!1
 	 \\?O<=(( ),_o4V

 	"#		
r!   rA   )__name__
__module____qualname____firstlineno__r   r-   r:   rM   ra   rj   r}   r   r   r   r   r   markparametrizer   r   r   r   r   r\   r   r   r   filterwarningsr   __static_attributes____classdictcell____classdict__s   @r   r   r      s     D3/&D"9)(/ .1`2& [[S1c(+0 ,0 10,,0 [[TD"&&>2E 3E1. [[ RS
 T
r!   r   c                   *   a  ] tR tRt o RtR tRtV tR# )
TestSortedi_  z+everything you wanted to test about sortingc                   \        . RO. R	O.. R
O. RO.4      p\        R\        \        V4      4      /VRR7      pVP                  P
                  RJ g   Q hVP                  4       pVP                  P
                  RJ g   Q h\        R. RO/\         P                  ! . RO4      RR7      pVP                  \        P                  R,          R3,          p\        P                  ! WT4       R# )r   colint64)r   r   FTr3   Nr   )rZ   rY   rX   )r   rf   r@   r   rf   r@   )r   r@   rf   rf   r   r@   )rf   rs   rd   r@   ))rr   rX   )rr   rZ   )r   rX   )r   rY   ):rr   r   N:rX   rZ   N)r   r   ranger   r   is_monotonic_increasing
sort_indexrw   r)   pd
IndexSlicer   r   )r   r   r`   sortedr   r   s   &     r   test_sort_non_lexsorted"TestSorted.test_sort_non_lexsortedb  s     o.1CEW0X
 uSX/s'Jxx//5888||33t;;;L!((@ 
 BMM*:;Q>?
f/r!   rA   N)r   r   r   r   __doc__r  r  r  r  s   @r   r  r  _  s     50 0r!   r  )r   numpyr\   r   pandasr  r   r   r   r   pandas._testing_testingr   r   r  rA   r!   r   <module>r     s7         L
 L
^
0 0r!   