+
    xȇi7                       ^ RI Ht ^ RIHt ^ RIt^ RIHt ^ RIt^ RI	t	^ RI
HtHt ^ RIHt ^ RIHu Ht ^ RIt^ RIHtHtHtHtHtHtHtHtHtHtHtH t H!t!H"t" ^ RI#H$t% ^ RI&H't'H(t( ]! 4       ;'       d    ]'       * ;'       g    ]'       * t)]! 4       ;'       g    ]'       * t*R+R	 lt+R,R lt,]	PZ                  R 4       t.]	PZ                  R 4       t/ ! R R4      t0 ! R R4      t1 ! R R4      t2 ! R R4      t3R t4R t5]	Pl                  Po                  R. R-O4      ]	Pl                  Po                  RRR.4      R 4       4       t8]	Pl                  Po                  R]! R4      ]Pr                  .4      R  4       t:R! t;]	Pl                  Po                  R. R.O4      ]	Pl                  Po                  RR
R.4      ]	Pl                  Po                  R"R#R$.4      R% 4       4       4       t<]	Pl                  Po                  R&. R/O4      R' 4       t=]	Pl                  Po                  R. R0O4      ]	Pl                  Po                  R(^ ^.4      R) 4       4       t>R* t?R# )1    )	timedelta)DecimalN)tzlocal)IS64is_platform_windows)np_version_gt2)CategoricalCategoricalDtype	DataFrameDatetimeIndexIndexPeriodIndex
RangeIndexSeries	Timestamp
date_rangeisnanotnato_datetimeto_timedelta)
algorithmsnanopsc                6   a a S'       d	   V3R lpV# V 3R lpV# )a0  
Create a function for calling on an array.

Parameters
----------
alternative : function
    The function to be called on the array with no NaNs.
    Only used when 'skipna_alternative' is None.
skipna_alternative : function
    The function to be called on the original array

Returns
-------
function
c                 (   < S! V P                   4      # Nvalues)xskipna_alternatives   &r/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/frame/test_reductions.pyskipna_wrapper+make_skipna_wrapper.<locals>.skipna_wrapper=   s    %ahh//    c                 t   < V P                  4       p\        V4      ^ 8X  d   \        P                  # S! V4      # )r   )dropnalennpnanr   nonaalternatives   & r    r!   r"   B   s-    88:D4yA~vvt$$r#    )r+   r   r!   s   ff r    make_skipna_wrapperr-   +   s"      	0 	% r#   TFc	                  a \        W 4      p	V'       d   \        R\        R^R7      /4      p
\        P                  ! R4      ;_uu_ 4        \        W4      ! 4       pRRR4       \        X\        4      '       g   Q h\        \        V
4      4      V
R&   \        P                  ! R4      ;_uu_ 4        \        W4      ! 4       pRRR4       \        V\        4      '       g   Q h\        V4      '       g   Q hV'       d{   V3R lp\        SV4      pV	! ^ RR7      pV	! ^RR7      p\        P                  ! WP                  V4      WFVR	7       \        P                  ! VVP                  V^R
7      VVR7       MSpV	! ^ R
7      pV	! ^R
7      p\        P                  ! VVP                  V4      VVVR	7       V R9   d.   VP                  V^R
7      p\        P                  ! VVRWgR	7       V'       d=   VP                  P                  pVVP                  8X  g   Q hVVP                  8X  g   Q h\        P                  ! \         RR7      ;_uu_ 4        V	! ^R
7       RRR4       V'       d   V\"        P$                  ,          p\        VV 4      ! ^ R
7      p\        VV 4      ! ^R
7      pV R9   d   V R8X  d   ^M^ p\        VVP&                  VP                  R7      p\        P                  ! VV4       \        VVP&                  VP                  R7      p\        P                  ! VV4       R# R# R#   + '       g   i     EL; i  + '       g   i     EL; i  + '       g   i     EL; i)a:  
Check that operator opname works as advertised on frame

Parameters
----------
opname : str
    Name of the operator to test on frame
alternative : function
    Function that opname is tested against; i.e. "frame.opname()" should
    equal "alternative(frame)".
frame : DataFrame
    The object that the tests are executed on
has_skipna : bool, default True
    Whether the method "opname" has the kwarg "skip_na"
check_dtype : bool, default True
    Whether the dtypes of the result of "frame.opname()" and
    "alternative(frame)" should be checked.
check_dates : bool, default false
    Whether opname should be tested on a Datetime Series
rtol : float, default 1e-5
    Relative tolerance.
atol : float, default 1e-8
    Absolute tolerance.
skipna_alternative : function, default None
    NaN-safe version of alternative
bz1/1/2001periodsNac                 (   < S! V P                   4      # r   r   r   r+   s   &r    wrapper$assert_stat_op_calc.<locals>.wrapper       qxx((r#   Faxisskipna)check_dtypertolatolr9   )r<   r=   prodNo axis named 2matchindexdtype)sumr?   )getattrr   r   tmassert_produces_warning
isinstancer   ranger&   r-   assert_series_equalapplyr   rE   pytestraises
ValueErrorr'   r(   rD   )opnamer+   frame
has_skipnar;   check_datesr<   r=   r   fdfresultr5   r!   result0result1expected	lcd_dtypeall_nar0r1units   &f&&&&&&&             r    assert_stat_op_calcr`   K   s   J 	AZ
A>?@''--R(*F .&&))))B.3''--R(*F .&&))))6{{{	) -[:LM5)5)
[[){TX	
 	KKaK(		
 %QiGQiGN#  ;;~A;6
X5t	

 LL&&	GMM)))GMM))) 
z):	;	;	q	 
< VV$!,VV$!,_$&(1aDd"(("((CH""2x0d"(("((CH""2x0 %	 s .--
 .--` 
<	;	;s$   L21M
M2M	M	M+	c            
        \        \        P                  ! \        P                  ! R	\        R7      \        P
                  ! R	\        R7      .^ R7      \        \        ^4       U u. uF  p RV  2NK
  	  up \        R7      \        \        R4      \        R7      \        R7      p\        P                  VP                  R&   \        P                  VP                  RR
R13&   V# u up i )z|
Fixture for DataFrame of booleans with index of unique strings

Columns are ['A', 'B', 'C', 'D']; some entries are missing
rE   r>   foo_ABCD)rD   columnsrE      
   N      NN)rj      )r   r'   concatenateonesboolzerosr   rK   objectlistr(   ilocirV   s     r    bool_frame_with_narw      s     

WWWD)288G4+HIPQ	
 r3AtA3Z36Bd6l&1
B FFBGGDM&&BGGE23JI 4s   %C#c            
        \        \        P                  P                  ^4      P	                  R4      \        \        ^4       U u. uF  p RV  2NK
  	  up \        R7      \        \        R4      \        R7      R7      p\        P                  VP                  R&   \        P                  VP                  RR	R13&   V# u up i )
zz
Fixture for DataFrame of floats with index of unique strings

Columns are ['A', 'B', 'C', 'D']; some entries are missing
rc   rb   rd   rD   re   rf   ri   N)   rl   rm   )r   r'   randomdefault_rngstandard_normalr   rK   rr   rs   r(   rt   ru   s     r    float_frame_with_nar~      s     

		a 009r3AtA3Z36Bd6l&1
B FFBGGDM&&BGGE23JI 4s   B>c                     a  ] tR t^t o ]P
                  P                  R^ ^.4      ]P
                  P                  RRRRRRRR	R
RRR]P                  ! R]P                  ! R4      R7      ]P                  ! R]P                  ! R4      R7      .4      R 4       4       t
]P
                  P                  R^ ^.4      ]P
                  P                  RRRRRRRR	RRR]P                  ! R]P                  ! R4      R7      ]P                  ! R]P                  ! R4      R7      .4      R 4       4       tR tR tR t]P
                  P                  R. RO4      ]P
                  P                  R]! R. ROR. ROR. RO/. RORR7      ]! ^ ]P"                  ^.^]P"                  ^.^]P"                  ^./]R7      .4      ]P
                  P'                  R 4      R! 4       4       4       t]P
                  P                  R". RO4      R# 4       tR$ tR% t]P
                  P                  R&R'R(.4      R) 4       t]P
                  P                  R&R'R(.4      R* 4       tR+ tR, t]P
                  P                  R-. RO4      R. 4       tR/ t]P
                  P                  R0R1R2^.R3R4.R5R6.R7R.R8]! R.R.R97      R:]! R;.R<R7      R=] ! R>.4      /3R?R2^.R3R4.R5]P"                  .R7]!! ]P"                  .R@R7      R8]! ]P"                  .R.R97      R:]! ]"PF                  .R<R7      R=] ! ]"PF                  .4      PI                  RA4      /3R1RB^^	]P"                  ]P"                  .RC^^	]P"                  ]P"                  .RD^]P"                  ]P"                  ]P"                  .RE]! R]P"                  ]P"                  ]P"                  .R.R97      RF]! . ROR<R7      RG] ! . RO4      RH. RO/3R?RB^^	]P"                  ]P"                  .RC^^	]P"                  ]P"                  .RD^]P"                  ]P"                  ]P"                  .RE]! ]P"                  R]P"                  ]P"                  .R.R97      RF]! . ROR<R7      RG] ! . RO4      RH. RO/3.4      RI 4       t%RJ t&RK t'RL t(RM t)]P
                  P                  RNRORP]"PF                  RQ.^]"PF                  .,          .4      RR 4       t*RS t+]P
                  P                  RT],! ^ 4      ]! . 4      ]-! . ]P\                  R7      ]-! . ]P^                  R7      ]! . RURV7      ]0! . R7RV7      .4      RW 4       t1]P
                  P                  RX^ ^.4      RY 4       t2]P
                  P                  RZRR.4      ]P
                  P                  R[. RO4      R\ 4       4       t3R] t4R^ t5]P
                  P                  R_. RO4      ]P
                  P                  R`R^RX^/RaRb]P"                  .3R^RX^/]P"                  ]P"                  ]P"                  .3R^RcR?/RaRb]P"                  .3.4      Rd 4       4       t6]P
                  P                  R_. RO4      ]P
                  P                  R`R^RX^/ReRf]P"                  .3R^RX^/]P"                  ]P"                  ]P"                  .3R^RcR?/ReRf]P"                  .3.4      Rg 4       4       t7Rh t8Ri t9Rj t:Rk t;Rl t<Rm t=Rn t>Ro t?Rp t@]P
                  P                  RqRRrRs.RRtRu./RvRw.3RRxRy.RRzR{./R|R}.3RRrRy.RRzR~./RR.3.4      R 4       tA]P
                  P                  R^ ^.4      R 4       tB]P
                  P                  R^ ^.4      ]P
                  P'                  R4      R 4       4       tC]P
                  P                  R[R1R?.4      R 4       tDR tE]P
                  P                  R^ ^.4      R 4       tF]P
                  P                  R^ ^.4      ]P
                  P'                  R4      R 4       4       tG]P
                  P                  R[R1R?.4      R 4       tHR tIR tJR tK]P
                  P                  RR^ ^.3R^ ^.3.4      R 4       tLR tM]P
                  P                  R^ ^.4      ]P
                  P                  RR?R1.4      R 4       4       tN]P
                  P                  R^ ^.4      R 4       tOR tPR tQ]P
                  P                  R^ ^.4      R 4       tRR tSR tT]P
                  P                  R. ]P                  / R?3N]P                  / R13N]P                  R2. /R?3N]P                  R2. /R13N]P                  R2R?R?./R?3N]P                  R2R?R?./R?3N]P                  R2R1R?./R13N]P                  R2R1R?./R?3N]P                  R2R1R1./R13N]P                  R2R1R1./R13N]P                  R2R?.R3R?./R?3N]P                  R2R?.R3R?./R?3N]P                  R2R?R?.R3R?R1./R13N]P                  R2R?R?.R3R?R1./R?3N]P                  R2]!! RR6.RR7      /R?3N]P                  R2]!! RR6.RR7      /R13N]P                  R2]!! ^ ^.]WR7      /R?3N]P                  R2]!! ^ ^.]WR7      /R13N]P                  ! ]P                  R2]!! ^ ^.R<R7      /R?4      N]P                  ! ]P                  R2]!! ^ ^.RR7      /R?4      N]P                  ! ]P                  R2]!! ^ ^.R<R7      /R14      N]P                  ! ]P                  R2]!! ^ ^.RR7      /R14      N]P                  ! ]P                  R2]!! ^^.R<R7      /R14      N]P                  ! ]P                  R2]!! ^^.RR7      /R14      N]P                  ! ]P                  R2]!! ^^.R<R7      /R14      N]P                  ! ]P                  R2]!! ^^.RR7      /R14      N]P                  ! ]P                  R2]!! ^ ^.RR7      /R?4      N]P                  ! ]P                  R2]!! ^ ^.RR7      /R14      N]P                  ! ]P                  R2]!! ^^.RR7      /R14      N]P                  ! ]P                  R2]!! ^^.RR7      /R14      N]P                  R2]!! ^ ^.RR7      /R13N]P                  R2]!! ^ ^.RR7      /R?3N]P                  R2]!! ^^.RR7      /R13N]P                  R2]!! ^^.RR7      /R?3N]P                  ! ]P                  R2]!! ^
^.R<R7      R3]!! ^
^.RR7      /R14      N4      R 4       tXR tYR tZR t[Rt\V t]R'# )TestDataFrameAnalyticsr9   rQ   countrF   meanproductmedianminmaxnuniquevarstdsemskewscipy)markskurtc                   VR9   d   V^ 8X  g   VR9   d   \        W4      ! VR7       MVR9   d   RpMzVR8X  d   V^8X  d   RpMiRpMfVR 8X  d   RpM\VR8X  d   V^ 8X  d   R	P                  R
R.4      pM:RpM7VR9   d   RpM-VR8X  d'   \        P                  ! R\        P                  R7      p\        X\        P                  4      '       g
   VR,           p\        P                  ! \        VR7      ;_uu_ 4        \        W4      ! VR7       RRR4       VR8w  d   \        W4      ! VRR7       R# R#   + '       g   i     L.; i)rF   r   r>   z(could not convert string to float: 'bar'r   z2can't multiply sequence by non-int of type 'float'z0can't multiply sequence by non-int of type 'str'z7unsupported operand type\(s\) for \+: 'float' and 'str'r   |z%Could not convert \['.*'\] to numericz/Could not convert string '(bar){30}' to numericz<'[><]=' not supported between instances of 'float' and 'str'r   z@Cannot convert \[.*\] to numeric|does not support|Cannot perform)flagsz*|does not support|Cannot perform reductionrA   NTr9   numeric_only)rF   r   r   r   r   )r   r   r   r   r   r   r   )
rG   joinrecompileSrJ   PatternrN   rO   	TypeError)selffloat_string_framer9   rQ   msgs   &&&& r    #test_stat_op_api_float_string_frame:TestDataFrameAnalytics.test_stat_op_api_float_string_frame   s(   ( ++	f I
 ?
 &/T:>>@9$19NCLC5P6!19((DMC UC>)T8#jjW$$ c2::..HHy44*3> 5Y&/TM  54s   :D33E	c                ,    \        W4      ! VR R7       R# )Fr   NrG   )r   float_framer9   rQ   s   &&&&r    test_stat_op_api_float_frame3TestDataFrameAnalytics.test_stat_op_api_float_frame  s    & 	$$UCr#   c           	        R  pR pR pR pR p\        RVVRRRR7       \        R	\        P                  VP                  R
4      RRR7       \        R	\        P                  V\        P                  R7       \        R\        P
                  VRR7       \        R\        P                  V\        P                  R7       \        RWQ4       \        RWa4       \        RWq4       \        RVVRRRR7       R# )c                 4    \        V 4      P                  4       # r   )r   rF   ss   &r    r   7TestDataFrameAnalytics.test_stat_op_calc.<locals>.count5  s    8<<>!r#   c                 \    \        \        P                  ! V P                  4       4      4      # r   )r&   r   unique1dr%   r   s   &r    r   9TestDataFrameAnalytics.test_stat_op_calc.<locals>.nunique8  s    z**188:677r#   c                 2    \         P                  ! V ^R7      #    ddof)r'   r   r   s   &r    r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.var;      66!!$$r#   c                 2    \         P                  ! V ^R7      # r   )r'   r   r   s   &r    r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.std>  r   r#   c                 z    \         P                  ! V ^R7      \         P                  ! \        V 4      4      ,          # r   )r'   r   sqrtr&   r   s   &r    r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.semA  s$    66!!$rwws1v66r#   r   FT)rS   r;   rT   rF   float32gMbP?)r;   r<   )r   r   rT   r   r   r   r   r   N)r`   r'   rF   astypenansumr   r?   nanprod)r   r~   mixed_float_framer   r   r   r   r   s   &&&     r    test_stat_op_calc(TestDataFrameAnalytics.test_stat_op_calc4  s    	"	8	%	%	7 		
 	FF$$Y/	
 	266.299	
 	FBGG-@dSrww 3

	
 	E3<E3<E3<	
r#   c                |   a \         P                  ! R 4      oV3R lpV3R lp\        RW!4       \        RW14       R# )scipy.statsc                 j   < \        V 4      ^8  d   \        P                  # SP                  V RR7      # )   Fbias)r&   r'   r(   r   r   sp_statss   &r    skewnessHTestDataFrameAnalytics.test_stat_op_calc_skew_kurtosis.<locals>.skewnesso  s*    1vzvv===//r#   c                 j   < \        V 4      ^8  d   \        P                  # SP                  V RR7      # )rl   Fr   )r&   r'   r(   kurtosisr   s   &r    r   DTestDataFrameAnalytics.test_stat_op_calc_skew_kurtosis.<locals>.kurtt  s-    1vzvv$$QU$33r#   r   r   N)rN   importorskipr`   )r   r~   r   r   r   s   &&  @r    test_stat_op_calc_skew_kurtosis6TestDataFrameAnalytics.test_stat_op_calc_skew_kurtosisl  s3    &&}5	0
	4
 	FHBFD>r#   c                F    R  p\        RW1RR7       \        RW2RRR7       R# )c                     \        V 4      P                  4       '       d   \        P                  # \        P                  ! V 4      # r   )r   anyr'   r(   r   r   s   &r    r5   3TestDataFrameAnalytics.test_median.<locals>.wrapper}  s(    Aw{{}}vv99Q<r#   r   Tr   F)r;   rT   N)r`   )r   r~   	int_framer5   s   &&& r    test_median"TestDataFrameAnalytics.test_median|  s'    	 
 	HgPTUge	
r#   methodrV   r2   r/           cOrC   rb   z0ignore:Mismatched null-like values:FutureWarningc                V   VP                   P                  \        P                  8X  g   Q h\	        W!4      ! VR 7      p\	        VP                  R4      V4      ! VR 7      P                  \        4      pVR9   d   VR9   d   RWUP                  4       &   \        P                  ! WE4       R# )r>   f8N)r   re   r   )
r   rE   r'   object_rG   r   rr   r   rH   rL   )r   r   rV   r9   rW   rZ   s   &&&&  r    %test_stat_operators_attempt_obj_array<TestDataFrameAnalytics.test_stat_operators_attempt_obj_array  s|    : yy"**,,,$$/299T?F3>EEfM>!f&>(,H]]_%
v0r#   opc           	        \        R . ROR. R	OR. R
O/4      pRP                  . RO4      p\        P                  ! \        VR7      ;_uu_ 4        \        W!4      ! 4        RRR4       \        P                  ! RR4      ;_uu_ 4        \        P                  ! \        VR7      ;_uu_ 4        \        W!4      ! 4        RRR4       RRR4       R#   + '       g   i     Lw; i  + '       g   i     L-; i  + '       g   i     R# ; i)intfloatstrr   rA   Nuse_bottleneckFr      r   rl   )      ?       @      @      @)r2   r/   r   d)zCould not convertcould not convertz"can't multiply sequence by non-intzdoes not supportzCannot perform)r   r   rN   rO   r   rG   pdoption_context)r   r   rV   r   s   &&  r    test_mixed_ops%TestDataFrameAnalytics.test_mixed_ops  s     |-+
 hh
 ]]9C00BO 1 /77y44! 5 87 10 54 877s0   C%C5,C"	=C5C	"C2-C55D	c           	     ^   \        R . ROR. ROR. R	O/4      pVP                  . R
OR7       VP                  ^ R7      p\        P                  ! VP
                  \        P                  ! . RO\        R7      4       VP                  P                  ^R7      p\        P                  ! W#4       R# )	bool_dataint_datastring_datare   r>   rb   N)TTFFF)rh   rk   rz   (   2   )r2   r/   r   r   e)r   r   r   )r      abcde)r   reindexrF   rH   assert_numpy_array_equalr   r'   arrayrr   TrL   )r   rV   testalts   &   r    test_reduce_mixed_frame.TestDataFrameAnalytics.test_reduce_mixed_frame  s    >08
 	

C
Dvv1v~
##KK"36B	
 ddhhAh
t)r#   c                   \        R . ROR. R	OR^\        P                  ^./4      p\        P                  ! VP                  4       \        R ^R^R^/4      4       \        P                  ! VP                  RR7      \        R ^R^R^/4      4       \        P                  ! VP                  ^R7      \        . R
O4      4       \        P                  ! VP                  ^RR7      \        . RO4      4       R# )ABCFr%   r>   )r9   r%   Nr   r   r   r   r   r   )r   r   r   )r   r   r   )r   r'   r(   rH   rL   r   r   r   rV   s   & r    test_nunique#TestDataFrameAnalytics.test_nunique  s    YYa^LM
rzz|VS!S!S!4L-MN
JJeJ$fc1c1c1-E&F	
 	rzzqz16)3DE
rzzqz?	ARSr#   tzNUTCc           
         \        R ^^.R\        RVR7      .^,          /4      pVP                  4       p\        R\        RVR7      .R R.R7      p\        P
                  ! W44       R# )r  r	  2000r  r   rD   Nr   r   r   r   rH   rL   r   r  rV   rW   rZ   s   &&   r     test_mean_mixed_datetime_numeric7TestDataFrameAnalytics.test_mean_mixed_datetime_numeric  s_     aVS9V+C*Dq*HIJ3	&R 89#sL
v0r#   c                    \        R \        RVR7      .^,          /4      pVP                  4       p\        \        RVR7      .R .R7      p\        P
                  ! W44       R# )r  r  r  r  Nr  r  s   &&   r    test_mean_includes_datetimes3TestDataFrameAnalytics.test_mean_includes_datetimes  sS    
 i267!;<=9V34SEB
v0r#   c                   R ^RRR\        R4      /R ^RRR\        R4      /R ^RRR\        R4      /R ^RRR\        R4      /R ^RRR\        R4      /R ^RR	R\        R
4      /R ^RRR\        R4      /R ^RRR\        R4      /R ^RRR\        R4      /R ^RRR\        R4      /.
p\        V4      p\        P                  ! \        RR7      ;_uu_ 4        VP                  4        RRR4       VR R.,          P                  4       p\        RR.R R.\        R7      p\        P                  ! W44       R#   + '       g   i     LW; i)r  r	  Nr
  z628.00z383.00z651.00z575.00z1114.00TESTz241.00z572.00z609.00z820.00z1223.00z8unsupported operand type|does not support|Cannot performrA   g@gL@rC   )
r   r   rN   rO   r   r   r   rr   rH   rL   )r   r   rV   rW   rZ   s   &    r    test_mean_mixed_string_decimal5TestDataFrameAnalytics.test_mean_mixed_string_decimal  sV   
 !S$WX%67!S$WX%67!S$WX%67!S$WX%67!S$WY%78!S&#wx'89!S$WX%67!S$WX%67!S$WX%67!S$WY%78
 q\]]W
 
 GGI
 S#J$$&3,sCjG
v0
 
s   D22E	c                   VP                  ^R7      pVP                  R 4      p\        P                  ! W#4       VP	                  ^R7      pVP                  R 4      p\        P                  ! W#4       \
        P                  ! \
        P                  P                  ^4      P                  R	4      R^ 4      p\        P                  ! V^ R7      pV^ 8  P                  4       '       d   Q h\        P                  ! RR4      ;_uu_ 4        \        P                  ! V^ R7      pV^ 8  P                  4       '       d   Q h RRR4       R#   + '       g   i     R# ; i)
rl   r   c                 &    V P                  ^R7      # rl   r   )r   r   s   &r    <lambda>5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>      !%%Q%-r#   c                 &    V P                  ^R7      # r$  )r   r   s   &r    r%  r&    r'  r#     r>   r   FNr   r)  )r   rM   rH   assert_almost_equalr   r'   repeatr{   r|   r   nanvarr   r   r   r   datetime_framerW   rZ   arrs   &&   r    test_var_std#TestDataFrameAnalytics.test_var_std  s
   ###+!''(?@
v0###+!''(?@
v0ii		--a077	BD!Ls+QJ##%%%%/77]]3Q/F
''))))) 8777s   4E

E	methc                   \        \        P                  P                  ^4      P	                  R4      . ROR7      pVP                  R\        /4      pRVP                  R&   \        \        P                  P                  ^4      P	                  R4      . ROR7      pVP                  R\        /4      pRVP                  R&   \        W!4      ! ^RR7      p\        VRR.,          V4      ! ^R	7      p\        P                  ! WT4       \        W14      ! ^RR7      p\        VRR.,          V4      ! ^R	7      p\        P                  ! WT4       R
p\        P                  ! \        VR7      ;_uu_ 4        \        W!4      ! ^RR7       RRR4       Rp\        P                  ! \        VR7      ;_uu_ 4        \        W14      ! ^RR7       RRR4       R#   + '       g   i     LT; i  + '       g   i     R# ; i)r   foobarbazr   100r2   Tr   r>   z6unsupported operand type\(s\) for -: 'float' and 'str'rA   FNz&could not convert string to float: 'a')rg   r   r5  r6  r7  )r   r5  )r   r'   r{   r|   r}   r   rr   locrG   rH   rL   rN   rO   r   )r   r3  df1df2rW   rZ   r   s   &&     r    test_numeric_only_flag-TestDataFrameAnalytics.test_numeric_only_flag  s}    II!!!$44V<)

 jj%)!II!!!$44V<)

 jj%)#>3u~.51=
x0#>3u~.51=
x0 H]]9C00CAE: 16]]9C00CAE: 10 10 100s   3G5G&G#	&G7	c                H   VP                  ^R7      pVP                  R 4      p\        P                  ! W#4       \        P
                  ! \        P                  P                  ^4      P                  R4      R^ 4      p\        P                  ! V^ R7      pV^ 8  P                  4       '       d   Q h\        P                  ! RR4      ;_uu_ 4        \        P                  ! V^ R7      pV^ 8  P                  4       '       d   Q h RRR4       R#   + '       g   i     R# ; i)	rl   r   c                 n    V P                  ^R7      \        P                  ! \        V 4      4      ,          # r$  )r   r'   r   r&   r   s   &r    r%  1TestDataFrameAnalytics.test_sem.<locals>.<lambda>E  s    !%%Q%-"''#a&/2Qr#   r)  r>   r   FNr*  )r   rM   rH   r+  r'   r,  r{   r|   r   nansemr   r   r   r.  s   &&   r    test_semTestDataFrameAnalytics.test_semC  s    ###+!''(QR
v0ii		--a077	BD!Ls+QJ##%%%%/77]]3Q/F
''))))) 8777s   4DD!	zdropna, expectedTr  r	  g      $@r
  r   DE)
categoriesF
2000-01-02M8[ns]G1 daysFr   usHIJKLMNc           "        \        R . ROR^
^
\        P                  ^.R^\        P                  \        P                  \        P                  .R\        \        P                  \        P                  R\        P                  .RR7      R\	        \        P                  \        P                  R\        P                  .4      R\        . ROR	R7      R
\        . RO4      R. ROR. ROR^^\        P                  \        P                  .R\	        R\        P                  R\        P                  .4      R\        . ROR	R7      R\        . RO4      R\        P                  ! ^RR7      /4      pV\        VP                  4       4      ,          P                  VR7      p\        V4      p\        P                  ! WB4       R# )r  r	  r
  rE  r2   r   rb   rF  rH  rJ  rK  rN  rO  rP  rQ  rR  rS  rT  int64r  N)   rW        NaTrI  r[  r[  rL  r(   r(   r(   )   r]  	   r^  )r^  r^  r]  r]  )rI  rI  r[  r[  )rL  r(   rL  r(   )r   r'   r(   r   r	   r   r   arangesortedkeysmoderH   assert_frame_equal)r   r%   rZ   rV   rW   s   &&&  r    test_mode_dropna'TestDataFrameAnalytics.test_mode_dropnaP  sB   t %b"bffa(a0VRVVRVVS"&&9G["&&"&&#rvv!>?]#FhW\"AB\\aBFFBFF+[#rvvsBFF!;<]>h \"DERYYq0!
* F8==?+,111@X&
f/r#   c                    \        R \        P                  \        P                  RR./4      p\        R R\        P                  ./4      pVP                  RR7      p\        P
                  ! WC4       R# )r  r2   Fr  N)r   r'   r(   rb  rH   rc  )r   using_infer_stringrV   rZ   rW   s   &&   r    test_mode_sort_with_na-TestDataFrameAnalytics.test_mode_sort_with_na  sW    bffbffc3789cC=12&
f/r#   c                    \        . R R.R7      pVP                  4       pVP                  4       p\        P                  ! W24       R# )r2   r/   r   N)r   copyrb  rH   rc  )r   rV   rZ   rW   s   &   r    test_mode_empty_df)TestDataFrameAnalytics.test_mode_empty_df  s6    rC:.779
f/r#   c                	   \        R \        R^RRR7      R\        R^RRR7      R\        R4      \        ^^R	7      ,
          /4      p\        R VR ,          VR,          ,
          RVR ,          VR,          ,
          /4      pVP	                  4       pVP
                  ^ ,          VP                  R!,          8X  g   Q hVP
                  ^,          VP                  R",          8X  g   Q hVP	                  ^R
7      pW2P                  R",          8H  P                  4       '       g   Q hVP                  4       pVP
                  ^ ,          VP                  R#,          8X  g   Q hVP
                  ^,          VP                  R$,          8X  g   Q hVP                  ^R
7      pW2R ,          8H  P                  4       '       g   Q hVP                  4       p\        V4      p\        R VR ,          VR,          ,
          RVR,          VR ,          ,
          /4      p\        P                  ! W54       \        P                  ! WE4       VP                  4       pRVR&   ^VR&   RVR&   \        R4      VR&   VP	                  4       p\        \        P                  ! \        R%R7      4      \        P                  ! \        R&R7      4      R^R\        R4      .VP                   R7      p\        P"                  ! W54       VP	                  ^RR7      p\        . R'O4      p\        P"                  ! W54       VR R.,          P	                  ^R
7      p\        \        R&R7      .^,          RR7      p\        P"                  ! W54       VR R.,          P	                  4       p\        \        R%R7      \        R&R7      .R R.RR7      p\        P"                  ! W54       \        R\        R^RR7      R\        R^RR7      /4      pVR,          VR,          ,
          VR&   VR,          P$                  R8X  g   Q hVR,          VR,          ,
          VR&   VP'                  4        VR,          P$                  R8X  g   Q hVR,          P$                  R8X  g   Q hR # )(r  z2012-1-1rE  ns)r1   freqr_   r	  z2012-1-2r
  20120101)minutessecondsr>   r5  r   rF  20130101rH  rs  )daysr  Tr   m8[ns]rb   rC   time20130102)r1   r_   time220130105off1timedelta64[ns]off2N)r   r  )r   r	  )r   r  )r   r	  i1  )r   r   r   )r   r   r   r   r   rt   r:  allr   absrH   rc  rk  r   r   	Timedeltare   rL   rE   _consolidate_inplace)r   rV   diffsrW   result2rZ   mixeds   &      r    test_operators_timedelta641TestDataFrameAnalytics.test_operators_timedelta64  s   Z
ACdKZ
ACdKYz*Yq!-LL
 33"S' 133"S'8IJK {{1~6!2222{{1~6!2222"))F++002222 {{1~6!2222{{1~6!2222"*$))++++ e*c2c7RW#4c2c7RW;LMN
f/
g0 

c
c
c
z*c
 Yz:;YB/0*% --

 	v0 5+&
v0 Sz"&&A&.9"-.2(C
v0Sz"&&(z*I2,>?*

 	v0 
:qtDJE
 [2f:-6
&z#4444Z"W+-6

!&z#4444&z#4444r#   c                F   \         P                  ! R ^
R7      p\        RVRV/RR7      p\         P                  VP                  R&   VP                  RR7      p\        VR,          P                  4       \         P                  .RR.RR	7      p\        P                  ! W44       VP                  ^RR
7      p\        \         P                  ! ^ 4      .^,          \         P                  \         P                  ! ^ 4      .,           RR7      p\        P                  ! W44       R# )z1 Dayr0   r  r	  Trk  Fr:   ztimedelta64[us]rC   r8   zm8[us]rb   N)rm   r  )
r   timedelta_ranger   r[  rt   r   r   rH   rL   r  )r   tdirV   rW   rZ   s   &    r    !test_std_timedelta64_skipna_false8TestDataFrameAnalytics.test_std_timedelta64_skipna_false  s      "5S#s+$7&&u%W[[]BFF#C:=N
 	v0Qu-\\!_!RVVR\\!_$==X
 	v0r#   r   z
2022-01-01z
2022-01-02z
2022-01-03c                   \        V4      P                  V4      p\        R V/4      pVP                  VR7      pV'       d;   \        ;QJ d    R V 4       F  '       d   K   RM	  RM! R V 4       4      '       d#   \        R \        P                  /RV R2R7      pM\        R R/RV R2R7      p\        P                  ! Wx4       R	# )
r2   r  c              3   D   "   T F  q\         P                  J x  K  	  R # 5ir   )r   r[  ).0values   & r    	<genexpr>FTestDataFrameAnalytics.test_std_datetime64_with_nat.<locals>.<genexpr>"  s     A&bff_&s    FTztimedelta64[]rb   rL  N)
r   as_unitr   r   r  r   r   r[  rH   rL   )	r   r   r:   requestr_   dtirV   rW   rZ   s	   &&&&&    r    test_std_datetime64_with_nat3TestDataFrameAnalytics.test_std_datetime64_with_nat  s    
 &!))$/Sz"v&A&AA&AAAsBFFm\$q3IJHsHo|D65KLH
v0r#   c                
   \        4       pVP                  ^ R7      pVP                  ^R7      p\        V\        4      '       g   Q h\        V\        4      '       g   Q h\	        V4      ^ 8X  g   Q h\	        V4      ^ 8X  g   Q hR# )r   r>   N)r   rF   rJ   r   r&   )r   empty_frameaxis0axis1s   &   r    test_sum_corner&TestDataFrameAnalytics.test_sum_corner(  so    kQ'Q'%((((%((((5zQ5zQr#   rD   ME)rp  c                    \        R .VR7      p\        W14      ! ^R7      pVR	9   d   RpMVR8X  d   RpMRp\        . W%R7      p\        P                  ! WF4       R# )
r2   )re   rD   r>   rp   r   rV  rr   rC   N)r   r  )r   rG   r   rH   rL   )r   all_reductionsrD   rV   rW   expected_dtyperZ   s   &&&    r    test_axis_1_empty(TestDataFrameAnalytics.test_axis_1_empty2  sZ     uE2,!4^+#Nw&$N%N"E@
v0r#   	min_countc                    Tp\        R \        P                  ./VR7      pVP                  ^W#R7      pV'       d
   V^ 8X  d   RM\        P                  p\	        V.VR7      p\
        P                  ! Wh4       R# )r2   rb   )r9   r:   r   N)r   r   NArF   r   rH   rL   )	r   string_dtype_no_objectr:   r  rE   rV   rW   r  rZ   s	   &&&&     r    test_axis_1_sum_na)TestDataFrameAnalytics.test_axis_1_sum_naI  s`     'beeW~U3QvCaRUU5'/
v0r#   zmethod, unitr   c           	     "   . ROp\        R W".RV\        P                  .R\        P                  \        P                  ./4      p\        WQ4      ! VR7      p\	        W"V.VRR7      p\
        P                  ! Wg4       \        WQ4      ! V^R7      p\	        W"\        P                  .VR7      p\
        P                  ! Wg4       \        WQ4      ! V^ R7      p\	        W"V.VRR7      p\
        P                  ! Wg4       \        VP                  R,          V4      ! V^R7      p\	        V\        P                  \        P                  .VR7      p\
        P                  ! Wg4       \        R	V.^
,          R
V.^,          \        P                  .^,          ,           /4      p\        WQ4      ! V^R7      p\	        VR	R
.R7      p\
        P                  ! Wg4       \        WQ4      ! V^R7      p\	        VR	R
.R7      p\
        P                  ! Wg4       R# )r2   r/   r   r   float64rC   )r   r  r  :r   NNr  r	  Nr2   r/   r   )r   r'   r(   rG   r   rH   rL   rt   )r   r   r_   r   idxrV   rW   rZ   s   &&&&    r    test_sum_prod_nanops+TestDataFrameAnalytics.test_sum_prod_nanopsS  s    d\3rvvbffbffEUVW$,?4t,CyI
v0 $,!L4rvv.c:
v0 $,!L4t,CyI
v0f-<STU40<
v0 dVb[#vzRVVHqL/HIJ$,!L&c
3
v0$,!L&c
3
v0r#   c           	        . ROp\        R ^ ^ .R^ \        P                  .R\        P                  \        P                  ./4      pVP                  \        4      pVP                  4       p\        . RORVR7      p\        P                  ! WE4       VP                  ^ R7      p\        P                  ! WE4       VP                  ^R7      p\        ^ ^ \        P                  .RVR7      p\        P                  ! WE4       R# )	r2   r/   r   rw  rE   rD   r  Nr  )r   r   r   )	r   r'   r(   rM   r   rF   r   rH   rL   )r   r  rV   r<  rW   rZ   s   &     r    test_sum_nanops_timedelta0TestDataFrameAnalytics.test_sum_nanops_timedeltau  s    aVS1bff+sRVVRVV<LMNhh|$ )83?
v0 1%
v0 1%1a.D
v0r#   c                    \        R . ROR. RO/4      pVP                  ^
R7      p\        \        P                  \        P                  .R R.R7      p\
        P                  ! W#4       R# )r   yr  r  Nr  rl   rg      )r   rF   r   r'   r(   rH   rL   r   rV   rW   rZ   s   &   r    test_sum_nanops_min_count0TestDataFrameAnalytics.test_sum_nanops_min_count  sP    YY78"%266266*3*=
v0r#   
float_typezkwargs, expected_resultg	@g333333@r:   c                    \        R . RORR^\        P                  ./VR7      pVP                  ! R/ VB p\	        V4      P                  V4      p\        P                  ! WV4       R# )r2   r/   g@rb   N)r   gffffff@皙@r,   )r   r'   r(   rF   r   r   rH   rL   r   r  kwargsexpected_resultrV   rW   rZ   s   &&&&   r    test_sum_nanops_dtype_min_count6TestDataFrameAnalytics.test_sum_nanops_dtype_min_count  sX     _cCBFF3CDJW!&!/*11*=
v0r#   r   r   c                    \        R . RORRR\        P                  ./VR7      pVP                  ! R/ VB p\	        V4      P                  V4      p\        P                  ! WV4       R# )r2   r   r/   rb   N)r   r   r  r,   )r   r'   r(   r?   r   r   rH   rL   r  s   &&&&   r     test_prod_nanops_dtype_min_count7TestDataFrameAnalytics.test_prod_nanops_dtype_min_count  s]     /3c266(:;:
 "6"/*11*=
v0r#   c                    VP                   P                  \        4      p\        W!P                  VP
                  R 7      pV\        ^4      ,          pVP                  4        R# )ry   N)r   r   r   r   rD   re   r   rF   )r   r   r   rR   deltass   &&   r    test_sum_object&TestDataFrameAnalytics.test_sum_object  sG    ##**3/&(9(9;CVCVW1%

r#   c                z    \         P                  ! V4      pVP                  ^R7       VP                  ^ R7       R# r   r>   N)r'   isnanrF   )r   r   boolss   && r    test_sum_bool$TestDataFrameAnalytics.test_sum_bool  s,    %		q			q	r#   c                   \        R \        R^R7      R. RO/4      P                  . RO4      p\        P                  ! \
        RR7      ;_uu_ 4        VP                  4        RRR4       R#   + '       g   i     R# ; i)	r  r  r0   r	  z does not support operation 'sum'rA   Nr   )r   r   rl   )r   r   r   rN   rO   r   rF   r  s   & r    test_sum_mixed_datetime.TestDataFrameAnalytics.test_sum_mixed_datetime  sW    Z:CNOWW
 ]]9,NOOFFH POOOs   A--A>	c                   R p\         P                  ! \        VR7      ;_uu_ 4        VP                  ^ R7       RRR4       \         P                  ! \        RR7      ;_uu_ 4        VP                  ^R7       RRR4       VR,          ^ 8  VR&   VP                  ^ R7      pVR,          VR,          P                  P                  4       8X  g   Q hR#   + '       g   i     L; i  + '       g   i     Lu; i)z1Could not convert|does not support|Cannot performrA   r>   Nunsupported operand typer  rp   )rN   rO   r   r   r   )r   r   r   r   meanss   &&&  r    test_mean_corner'TestDataFrameAnalytics.test_mean_corner  s    A]]9C00###+ 1 ]]9,FGG###+ H *#.2F  a (V}F 3 : : ? ? AAAA 10 HGs   C&C&C#	&C6	c                   \        R \        P                  ! ^4      R\        R^R7      R\        P
                  ! R^R7      R\        P                  ! R^RR	7      /4      pVP                  R
R7      p\        R R/4      p\        P                  ! W#4       \        P                  ! \        RR7      ;_uu_ 4        VP                  4        RRR4       R#   + '       g   i     R# ; i)r  r	  
2016-01-01r0   r
  1DrE  2016Yr1   rp  Tr  r   z'mean is not implemented for PeriodArrayrA   N)r   r'   r_  r   r   r  period_ranger   r   rH   rL   rN   rO   r   r  s   &   r    test_mean_datetimelike-TestDataFrameAnalytics.test_mean_datetimelike  s    
 RYYq\Za8R''a8R__VQSA	
 d+3*%
v0]]9,UVVGGI WVVVs   9CC%	c                &   \        R \        P                  ! ^4      R\        R^R7      R\        P
                  ! R^R7      /4      pVP                  RR7      p\        R ^RVP                  R,          RVP                  R,          /4      p\        P                  ! W#4       \        P                  ! R^R	R
7      VR&   \        P                  ! \        RR7      ;_uu_ 4        VP                  RR7       RRR4       R#   + '       g   i     R# ; i)r  r	  r  r0   r
  r  Fr  r  r  r  rE  z"mean is not implemented for PeriodrA   N)r   r	  )r   r
  )r   r'   r_  r   r   r  r   r   r:  rH   rL   r  rN   rO   r   r  s   &   r    )test_mean_datetimelike_numeric_only_false@TestDataFrameAnalytics.test_mean_datetimelike_numeric_only_false  s    RYYq\Za8R''a8
 e,33vRVVF^LM
v0 //&!#>3]]9,PQQGGG' RQQQs   "C??D	c                    \         P                  P                  ^4      P                  RR	R7      p\	        VRR7      pVP                  RR7      p\	        V4      P                  4       P                  R4      p\        P                  ! W44       R# )
r   r)  )sizeInt64rb   Tr  Float64N)rh   rg   )	r'   r{   r|   integersr   r   r   rH   rL   )r   r0  rV   rW   rZ   s   &    r    *test_mean_extensionarray_numeric_only_trueATestDataFrameAnalytics.test_mean_extensionarray_numeric_only_true  sm    ii##A&//7/Cs'*d+S>&&(//	:
v0r#   c                   \         P                  ! \        R R7      ;_uu_ 4        VP                  ^R7       RRR4       \         P                  ! \        R R7      ;_uu_ 4        VP	                  ^R7       RRR4       \         P                  ! \        RR7      ;_uu_ 4        VP                  ^R7       RRR4       \         P                  ! \        R R7      ;_uu_ 4        VP                  ^R7       RRR4       R#   + '       g   i     L; i  + '       g   i     L; i  + '       g   i     Lw; i  + '       g   i     R# ; i)r   rA   r>   Nr  )rN   rO   r   r   r   r   r   )r   r   s   &&r    test_stats_mixed_type,TestDataFrameAnalytics.test_stats_mixed_type  s    ]]9,?@@"""* A]]9,?@@"""* A]]9,FGG###+ H]]9,?@@###+ A@ A@@@GG@@@s/   C?$D#D%"D8?D	D"	%D5	8E		c                    \        \        ^4      \        ^
4      R7      p\        V4      pVP                  ^R7      ^ ,          ^
8X  g   Q hR# )r   ry   r>   N)r   rK   r   rF   )r   rV   r  s   &  r    test_sum_bools%TestDataFrameAnalytics.test_sum_bools  s=    U1XuRy9Ryyay #r)))r#   zinput_data, expected_data483394759483943759z483.948z3.0z94.2z759.93z483.94894.2z	3.0759.9379z48394.2z3.079c                    \        V4      p\        V4      pVP                  ^R7      p\        P                  ! WT4       R# r  )r   r   rF   rH   rL   )r   
input_dataexpected_datarV   rZ   rW   s   &&&   r    test_sum_string_dtype_coercion5TestDataFrameAnalytics.test_sum_string_dtype_coercion  s5     z"-(Q
v0r#   c                   Tp\         P                  VP                  R &   \         P                  VP                  RRR13&   WR3 EF  pV'       d   V^8X  d   WbJd   V'       d   RpMRp\        P                  ! \
        VR7      ;_uu_ 4        VP                  WCR7       RRR4       \        P                  ! \
        VR7      ;_uu_ 4        VP                  WCR7       RRR4       K  VP                  WCR7      pVP                  \        P                  WCR7      p	V	P                  VP                  P                  4      p	\        P                  ! W4       EK  	  R#   + '       g   i     L; i  + '       g   i     EK?  ; i)rf   ri   NEncountered all NA valuesEncountered an NA valuerA   r8   rm   )r'   r(   rt   rN   rO   rP   idxminrM   r   r   rD   rE   rH   rL   
r   r   r   r:   r9   rR   rV   r   rW   rZ   s
   &&&&&     r    test_idxmin"TestDataFrameAnalytics.test_idxmin,  s   66

4!#

5"#:$BdaiR-@5C3C]]:S99II4I7 :]]:S99II4I7 :9 <88FMM8L#??288>>:&&v8 % :9999s   EE1E.1Fz3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc                    V^ 8X  d   \        VR7      pM\        VR7      pVP                  W2R7      p\        VP                  R7      p\        P
                  ! WV4       R# r   r  r   r8   rb   N)r   r  r   rE   rH   rL   r   rD   r:   r9   rR   rW   rZ   s   &&&&   r    test_idxmin_empty(TestDataFrameAnalytics.test_idxmin_emptyA  K     19E*Ee,E47,
v0r#   c           
         \        R . ROR. ROR\        R4      /4      pVP                  VR7      pV'       d   \        ^^.R R.R7      pM\        . R	O. R
OR7      p\        P
                  ! W44       R# )r2   r/   r   xyxr  r  Nr   r   r   r   r   r   )r   r   r   r  )r   rs   r  r   rH   rL   r   r   rV   rW   rZ   s   &&   r    test_idxmin_numeric_only/TestDataFrameAnalytics.test_idxmin_numeric_onlyN  ^    YYT%[IJ5q!fS#J7Hi?H
v0r#   c                    TpR p\         P                  ! \        VR7      ;_uu_ 4        VP                  ^R7       RRR4       R#   + '       g   i     R# ; iz)No axis named 2 for object type DataFramerA   r>   N)rN   rO   rP   r  r   r   rR   r   s   &&  r    test_idxmin_axis_2)TestDataFrameAnalytics.test_idxmin_axis_2X  :    9]]:S11LLaL  2111   AA	c                b   Tp\         P                  VP                  R &   \         P                  VP                  RRR13&   WR3 F  pVRJ g   V^8X  dU   WeJ dP   V'       d   RpMRp\        P                  ! \
        VR7      ;_uu_ 4        VP                  WCR7       RRR4        R# VP                  WCR7      pVP                  \        P                  WCR7      p	V	P                  VP                  P                  4      p	\        P                  ! W4       K  	  R#   + '       g   i      R# ; i)	rf   ri   NFr  r  rA   r8   rm   )r'   r(   rt   rN   rO   rP   idxmaxrM   r   r   rD   rE   rH   rL   r  s
   &&&&&     r    test_idxmax"TestDataFrameAnalytics.test_idxmax^  s    66

4!#

5"#:$B%419"+5C3C]]:S99II4I7 :YYDY8FxxDxHHrxx~~6H""64 % :9s   
DD.c                    V^ 8X  d   \        VR7      pM\        VR7      pVP                  W2R7      p\        VP                  R7      p\        P
                  ! WV4       R# r  )r   r!  r   rE   rH   rL   r  s   &&&&   r    test_idxmax_empty(TestDataFrameAnalytics.test_idxmax_emptyr  r  r#   c           
         \        R . ROR. ROR\        R4      /4      pVP                  VR7      pV'       d   \        ^^ .R R.R7      pM\        . R	O. R
OR7      p\        P
                  ! W44       R# )r2   r/   r   r  r  r  Nr  r  )r   r   r   r  )r   rs   r!  r   rH   rL   r  s   &&   r    test_idxmax_numeric_only/TestDataFrameAnalytics.test_idxmax_numeric_only  r  r#   c                6   \         P                  ! R 4       \        R. R
OR. RO/RR7      pVP                  4       p\	        ^^ .RR.R7      p\
        P                  ! W#4       VP                  4       p\	        ^^.RR.R7      p\
        P                  ! W#4       \        R. RO/RR7      pVP                  RR7      p\	        ^.R.R7      p\
        P                  ! W#4       VP                  RR7      p\	        ^.R.R7      p\
        P                  ! W#4       R	# )pyarrowr2   r/   zint64[pyarrow]rb   r  zstring[pyarrow]Fr  Nr  r  )r/   r   r2   )rN   r   r   r!  r   rH   rL   r  r  s   &   r    test_idxmax_arrow_types.TestDataFrameAnalytics.test_idxmax_arrow_types  s    I&YY7?OP1a&c
3
v01a&c
3
v0_-5FG.1#cU+
v0.1#cU+
v0r#   c                    TpR p\         P                  ! \        VR7      ;_uu_ 4        VP                  ^R7       RRR4       R#   + '       g   i     R# ; ir  )rN   rO   rP   r!  r  s   &&  r    test_idxmax_axis_2)TestDataFrameAnalytics.test_idxmax_axis_2  r  r  c           	        \        R ^R7      p\        ^. RO^\        ^4      RRR1,          ^V/4      pVP                  4       p\	        . RO\        ^^4      R7      p\
        P                  ! W44       VP                  4       p\	        . RO\        ^^4      R7      p\
        P                  ! W44       \        P                  VP                  R&   VP                  4       p\	        . RO\        ^^4      R7      p\
        P                  ! W44       VP                  4       p\	        . RO\        ^^4      R7      p\
        P                  ! W44       VRRR1,          V^&   VP                  4        VP                  4       p\	        . R	O\        ^^4      R7      p\
        P                  ! W44       VP                  4       p\	        . R
O\        ^^4      R7      p\
        P                  ! W44       R# )r  r0   Nr  )r   r   r   r  )r   r   r   )r   r   r   )r   r   )r   r   r   r   )r   r   r   r   )r   r   rK   r!  r   rH   rL   r  r   r[  r:  r  r   r  rV   rW   rZ   s   &    r    test_idxmax_mixed_dtype.TestDataFrameAnalytics.test_idxmax_mixed_dtype  se   q19aq$B$C@A)5A;7
v0)5A;7
v0 vvt)5A;7
v0)5A;7
v0 DbD	1
!,eAqk:
v0,eAqk:
v0r#   zop, expected_valuer!  r  c           	         \        R . ROR. RO/RR7      pVP                  R 4      p\        W14      ! 4       p\        RV/\        ^d^.R RR7      R7      p\        P
                  ! WE4       R# )	IDr  r  rb   )namerE   r  N)d   r8  r8     r9  r9  )r   r   r   r   r   r   )r   groupbyrG   r   rH   rc  )r   r   expected_valuerV   rW   rZ   s   &&&   r    !test_idxmax_idxmin_convert_dtypes8TestDataFrameAnalytics.test_idxmax_idxmin_convert_dtypes  sr     4+ 
 ZZ"n%c
W=
 	f/r#   c           	        \        R ^R7      p\        ^V^VRRR1,          /RR7      p\        P                  VP                  R&   VP                  4        VP                  ^R7      p\        . RO4      p\        P                  ! W44       VP                  ^R7      p\        . R	O4      p\        P                  ! W44       R# )
r  r0   NTr  r>   r  )r   r   )rl   r   r   )rl   r   rl   )r   r   r   r[  rt   r  r!  r   rH   rL   r  r2  s   &    r    "test_idxmax_dt64_multicolumn_axis19TestDataFrameAnalytics.test_idxmax_dt64_multicolumn_axis1  s    q133tt9-D9
!")$
v0")$
v0r#   	bool_onlyc                    Tp\         P                  P                  ^4      P                  \	        V4      4      R8  VR&   \        WQ4      ! W#R7       R# )r   g      ?_bool_r9   rA  N)r'   r{   r|   r}   r&   rG   )r   all_boolean_reductionsr9   rA  r   r  s   &&&&& r    test_any_all_mixed_float/TestDataFrameAnalytics.test_any_all_mixed_float  sC     #))//2BB3u:NQTTh.DNr#   c                ,    \        W14      ! VR R7       R# )FrD  Nr   )r   rE  r9   rw   s   &&&&r    test_any_all_bool_with_na0TestDataFrameAnalytics.test_any_all_bool_with_na  s     	";QVWr#   c                  a VP                  R 4      p\        \        V4      o\        W14      pV3R lpV3R lpV! ^ RR7      pV! ^RR7      p\        P                  ! WsP                  V4      4       \        P                  ! WP                  V^R7      4       V! ^ R7      pV! ^R7      p\        P                  ! WsP                  V4      4       \        P                  ! WP                  V^R7      RR7       \        P                  ! \        RR7      ;_uu_ 4        V! ^R7       R	R	R	4       V\        P                  ,          p	\        W4      ! ^ R7      p
\        W4      ! ^R7      pVR
8X  d3   V
P                  4       '       d   Q hVP                  4       '       d   Q hR	# V
P                  4       '       g   Q hVP                  4       '       g   Q hR	#   + '       g   i     L; i)Tc                 H   < V P                  4       P                  pS! V4      # r   )r%   r   r)   s   & r    r!   FTestDataFrameAnalytics.test_any_all_bool_frame.<locals>.skipna_wrapper  s    88:$$Dt$$r#   c                 (   < S! V P                   4      # r   r   r4   s   &r    r5   ?TestDataFrameAnalytics.test_any_all_bool_frame.<locals>.wrapper  r7   r#   Fr8   r>   )r;   r@   rA   Nr   )fillnarG   r'   rH   rL   rM   rN   rO   rP   r(   r   r  )r   rE  rw   rR   rU   r!   r5   rX   rY   r\   r]   r^   r+   s   &&&         @r    test_any_all_bool_frame.TestDataFrameAnalytics.test_any_all_bool_frame  sk    #))$/b"89E2	%	) 5)5)
wG(<=
wG!(DE))
wN(CD
[[a[8e	

 ]]:->??1I @ V4!<V4!<!U*vvxx<vvxx<x6688O86688O8 @?s   
GG&	c           	     $   \        R . R	OR. R
OR. RO/. ROR7      pVR R.,          P                  ^R7      p\        . R
O. ROR7      p\        P                  ! W44       VR R.,          P                  ^RR7      p\        P                  ! W44       VP                  ^R7      p\        . R	O. ROR7      p\        P                  ! W44       VP                  ^RR7      p\        P                  ! W44       VP                  RR7      pV'       g   VP                  4       pVRJ g   Q hVP                  RR7      pV'       g   VP                  4       pVRJ g   Q hVR.,          P                  RR7      pV'       g   VP                  4       pVRJ g   Q hR# )r  TFr	  r
  r  r>   rD  N)TFF)TTF)TTTr  )r   r   r   rH   rL   r  item)r   using_python_scalarsrV   rW   rZ   s   &&   r    test_any_all_extra)TestDataFrameAnalytics.test_any_all_extra,  s[   )('
 "
 S#J###+-_E
v0S#J##d#;
v0Q.oF
v0Q$/
v0 T"#[[]FT"#[[]F~~SED)#[[]F~~r#   c           	        \        ^\        P                  \        P                  R.\        P                  ^\        P                  R.\        P                  \        P                  \        P                  R.\        P                  \        P                  R\        P                  ..R7      p\        WB4      ! WR7      p\	        . RO4      p\
        P                  ! WV4       R# )r   T5datar8   N)TTTT)r   r'   r(   rG   r   rH   rL   )r   r9   rE  r:   rV   rW   rZ   s   &&&&   r    test_any_all_object_dtype0TestDataFrameAnalytics.test_any_all_object_dtypeS  s     BFFBFFD)BFFD).bff-	
 4$N23
v0r#   c                z   ^\         P                  ^\         P                  .p\        R4      \        R4      \        P                  \        P                  .p\        RVRV/4      pRp\        P                  ! \        VR7      ;_uu_ 4        VP                  ^R7       RRR4       R#   + '       g   i     R# ; i)	r   z
1960-02-15z
1960-02-16r  r	  z0datetime64 type does not support operation 'any'rA   r>   N)
r'   r(   r   r   r[  r   rN   rO   r   r   )r   
float_datadatetime_datarV   r   s   &    r    test_any_datetime(TestDataFrameAnalytics.test_any_datetimeb  s    BFF+
l#l#FFFF	
 Zm<=@]]9C00FFFN 1000s   B))B:	c                   \        R . ROR. ROR. RO/\        . RO\        R7      R7      pVP                  RR7      p\	        \
        P                  . R7      p\        P                  ! W#4       \        R . ROR. ROR. ROR	. RO/4      pVP                  RR7      p\	        R	R
/4      p\        P                  ! W#4       R# )col1col2col3Nrb   r   TrA  r  col4Fr  r  )NNN)rd  re  rf  )FFT)	r   r   rr   r  r   r'   bool_rH   rL   r  s   &   r    test_any_all_bool_only-TestDataFrameAnalytics.test_any_all_bool_onlyq  s    Y	6;MN2&A

 $'3
v0		*,	
 $'65/*
v0r#   zfunc, data, expectedr   zM8[ns, UTC]rw  categoryc                   \        V4      p\        ;QJ d&    R  VP                   4       F  '       g   K   RM	  RM! R  VP                   4       4      '       d   \        P                  ! \
        RR7      ;_uu_ 4        V! V4       RRR4       \        P                  ! \
        RR7      ;_uu_ 4        \        \        V4      VP                  4      ! RR7       RRR4       VP                  P                  R 4      P                  4       '       d   Rp\        P                  ! \
        VR7      ;_uu_ 4        V! V4       RRR4       \        P                  ! \
        VR7      ;_uu_ 4        \        \        V4      VP                  4      ! RR7       RRR4       R# VP                  P                  R	 4      P                  4       '       d   V! V4      pV'       d	   WcJ g   Q hM8\        V\        P                  4      '       g   Q hVP                  4       VJ g   Q h\        \        V4      VP                  4      ! RR7      pV'       d
   WcJ g   Q hR# \        V\        P                  4      '       g   Q hVP                  4       VJ g   Q hR# R#   + '       g   i     EL; i  + '       g   i     EL; i  + '       g   i     EL; i  + '       g   i     R# ; i)
c              3   B   "   T F  p\        V\        4      x  K  	  R # 5ir   )rJ   r
   )r  r   s   & r    r  >TestDataFrameAnalytics.test_any_all_np_func.<locals>.<genexpr>  s     D1z!-..s   TFz,.* dtype category does not support operationrA   Nr>   c                      V P                   R 8H  # )rS  )kindr   s   &r    r%  =TestDataFrameAnalytics.test_any_all_np_func.<locals>.<lambda>  s    qvv}r#   z6datetime64 type does not support operation '(any|all)'c                     V R 8g  # )rl  r,   r   s   &r    r%  rr    s    jr#   )r   r   dtypesrN   rO   r   rG   __name__rM   rJ   r'   ri  rT  )r   funcr[  rZ   rU  r   rW   s   &&&&&  r    test_any_all_np_func+TestDataFrameAnalytics.test_any_all_np_func  s   j 3DD333DDDD!O  T
 !O  	$7TB ;;4599;;JCy44T
 5 y44	$7TB 54 [[89==??$ZF#)))!&"((3333{{}000 Yt_dmm<$GF#)))!&"((3333{{}000 @)     544 544s0   >	J3'J%8	J9-'KJ"	%J6	9K
	K	c                   \         P                  ! \        R R.R7      4      pV'       g   VP                  4       pVRJ g   Q h\         P                  ! \        R R.R7      4      pV'       g   VP                  4       pVRJ g   Q hR# )r2   r/   r   TFN)r'   r  r   rT  r   )r   rU  rW   s   && r    test_any_all_object*TestDataFrameAnalytics.test_any_all_object  sd    	3*56#[[]F~~	3*56#[[]Fr#   c                :   \        R R^.RRR./4      P                  \        4      pVP                  4        \	        RR.4      VR&   VR,          P                  R4      VR&   VP                  4       pVR.,          p\        P                  ! W#4       VP                  R^ R7      p\	        R.R.R	7      p\        P                  ! W#4       VRR.,          P                  R^ R7      p\        P                  ! W#4       VP                  RR
R7      '       g   Q hVP                  R^ R7      p\	        R.R.R	7      p\        P                  ! W#4       VR.,          P                  R^ R7      p\        P                  ! W#4       VP                  RR
R7      '       g   Q hR
# )r  r5  r	  TFr
  rl  rE  )rA  r9   r  N)r   r   rr   r  r   _get_bool_datarH   rc  r  rL   r   )r   rV   resrZ   s   &   r    test_any_all_object_bool_only4TestDataFrameAnalytics.test_any_all_object_bool_only  sn   eQZtUm<=DDVL
!$&3 S'..,3 !se9
c,fft!f,4&.
s- #sn  4a 8
s-vv4v0000fft!f,4&.
s- #immdm3
s-vv4v0000r#   c                   \        . RO4      p\        R\        P                  R\        P                  ./4      p\        . RO4      p\        \        P                  \        P                  ^.4      p\        P
                  ! R4      ;_uu_ 4        VP                  V^ R7       R F  p\        W4      ! V^ R7       K  	  RRR4       R#   + '       g   i     R# ; i)	r   r  r   N)lowerr9   r>   )r   r   r   r  )ltlegtgeeqne)r   r'   r(   r   rH   rI   cliprG   )r   rV   df_nanr   s_nanr   s   &     r    test_series_broadcasting/TestDataFrameAnalytics.test_series_broadcasting  s     'C"&&#rvv!6789*+''--KKaaK(:A. ; .---s   0C		C	r,   )rF   r   r?   r   r   r   r   r   )gȃw@Ba@gCVZg
?Z.F?)r   r   r   )g94c4?g@}jX?gNr9  )r   r   r   r   r   r   )r   r   r   )rI  r[  r[  r[  r\  r   r   r   r   rZ  )r(   rL  r(   r(   )rF   r   )r?   r   )NTF)float16r   r  )^ru  
__module____qualname____firstlineno__rN   markparametrizeparamtd
skip_if_nor   r   r   r   r   r   r'   r(   rr   filterwarningsr   r   r  r  r  r  r   r1  r=  rC  r	   r   r   r   r   r[  r  rd  rh  rl  r  r  r  r  r   r   rV  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/  r3  r<  r?  rF  rI  rQ  rV  r\  ra  rj  r   r  r   rw  rz  r  r  __static_attributes____classdictcell____classdict__s   @r    r   r      s     [[VaV,[[LLr}}W'=>LLr}}W'=>	
$'N% -&'NR [[VaV,[[LLr}}W'=>LLr}}W'=>	
"D# -$D6
p? 	
 [[M [[ 
   ," q2661+q2661+q2661+FfU%	
. [[ RS1 T/61 [[T#PQ" R"2*"T [[TD%=11 21 [[TD%=11 2116*" [[V%:;"; <";H* [[ "$##cUu=~XFxj1 "$"&&6bffX3%@xx@rvvh/77= !Q/!Q/!RVVRVVRVV4c266266266%BPSuU;8 &EF
 !Q/!Q/!RVVRVVRVV4bffc266266%BPSuU;8 &EF
O5	
8r0s8r0400W5r1$ [[L,EqBFF8|T	1	1 [[qM""BHH%"BJJ'"4(%	


1

1 [[[1a&11 21 [[^j+-FG[[^-@A1 B H1@1*1 [[\+LM[[!aa(3RVV*<=aa(266266266*BCa5)Cbff+=>	
1 N1 [[\+LM[[!aa(3RVV*<=aa(266266266*BCa5)Cbff+=>	
1 N1B(((1,*
 [[#E3<tUm4w6GHy%(#/AB, E5>37)W9MN	

1
1 [[VaV,9 -9( [[VaV,[[ VW	1 X -	1 [[^dE];1 <1! [[VaV,5 -5& [[VaV,[[ VW	1 X -	1 [[^dE];1 <11,!!1F [[
QF	hA/00	0$1$ [[VaV,[[[5$-8O 9 -O [[VaV,X -X
)V%N [[VaV,1 -110 [[/	
VVR/	
VVR/	
 VVc2Y&/	
 VVc2Y%	/	

 VVcE5>*E2/	
 VVcE5>*E2/	
 VVcD%=)40/	
 VVcD%=)51/	
 VVcD$<($//	
 VVcD$<($//	
 VVcE7C%159/	
 VVcE7C%159/	
 VVcE5>3>E/	
 VVcE5>3>F/	
  VVc63*G<=uE!/	
" VVc63*G<=tD#/	
$ VVc61a&45u=%/	
& VVc61a&45t<'/	
( LL#vq!fH'E!FN)/	
* LL#vq!fM'J!KUS+/	
, LL#vq!fH'E!FM-/	
. LL#vq!fM'J!KTR//	
0 LL#vq!fH'E!FM1/	
2 LL#vq!fM'J!KTR3/	
4 LL#vq!fH'E!FM5/	
6 LL#vq!fM'J!KTR7/	
8 LL#vq!fH'E!FN9/	
: LL#vq!fH'E!FM;/	
< LL#vq!fH'E!FM=/	
> LL#vq!fH'E!FM?/	
D VVc61a&
;<dCE/	
F VVc61a&
;<eDG/	
H VVc61a&
;<dCI/	
J VVc61a&
;<eDK/	
N LLR9R9 O/	
2f'1g2f'1R
 1J/ /r#   r   c                   :  a  ] tR tRt o R tR tR tR tR tR t	]
P                  P                  RR	R
.4      ]
P                  P                  RRR.4      V 3R lR l4       4       t]
P                  P                  RRR.4      R 4       tR tR tR tR tRtV tR# )TestDataFrameReductionsi$  c                   \        R \        P                  \        P                  \        R4      ./4      pVP	                  4       p\        \        R4      .R .R7      p\        P                  ! W#4       VP                  4       p\        \        R4      .R .R7      p\        P                  ! W#4       \        R \        P                  \        P                  ./4      pVP	                  4       p\        \        P                  .R .R7      p\        P                  ! W#4       VP                  4       p\        \        P                  .R .R7      p\        P                  ! W#4       R# )r5  z
2012-05-01r  N)	r   r   r[  r   r   r   rH   rL   r   r   rV   r~  exps   &   r    test_min_max_dt64_with_NaT2TestDataFrameReductions.test_min_max_dt64_with_NaT%  s    	,0GHIJffhi-.ug>
s(ffhi-.ug>
s( /01ffhbffXeW-
s(ffhbffXeW-
s(r#   c                   \        R \        P                  \        P                  \        R4      ./RR7      pVP	                  ^R7      pVP
                  P                  R4      p\        P                  ! W#4       VP                  ^R7      pVP
                  P                  R4      p\        P                  ! W#4       R# )r5  z2012-05-01 09:20:00.123456789zdatetime64[ns]rb   r>   N)
r   r   r[  r   r   r5  renamerH   rL   r   r  s   &   r    $test_min_max_dt64_with_NaT_precision<TestDataFrameReductions.test_min_max_dt64_with_NaT_precision<  s     RVVRVVY/N%OPQ"

 ff!fnffmmD!
s(ff!fnffmmD!
s(r#   c                   \        R \        P                  \        P                  \        R4      ./RR7      pVP	                  ^R7      pVP
                  P                  R4      p\        P                  ! W#4       VP                  ^R7      pVP
                  P                  R4      p\        P                  ! W#4       R# )r5  z10000 days 06:05:01.123456789r}  rb   r>   N)
r   r   r[  r   r   r5  r  rH   rL   r   r  s   &   r    $test_min_max_td64_with_NaT_precision<TestDataFrameReductions.test_min_max_td64_with_NaT_precisionL  s     FFFF !@A $	
 ff!fnffmmD!
s(ff!fnffmmD!
s(r#   c           
        Tp\        V\        4      '       d'   \        4       '       d   \        P                  ! R 4       \        R\        RVR7      \        RVR7      .R\        RVR7      \        P                  ./4      pVP                  ^RR7      p\        VP                  R
,          \        P                  .4      pVP                  VR,          P                  8X  g   Q h\        P                  ! WV4       VP                  ^RR7      p\        VP                  R,          \        P                  .4      pVP                  VR,          P                  8X  g   Q h\        P                  ! WV4       R	# )zSGH#37659 OSError raised within tzlocal bc Windows chokes in times before 1970-01-01r2   z2020-01-01 08:00:00r  z1920-02-01 09:00:00r/   z2020-02-01 08:00:00Fr8   N)r   r2   )r   r/   )rJ   r   r   rN   skipr   r   r   r[  r   r   r:  rE   rH   rL   r   )r   r  tz_naive_fixturer  rV   r~  rZ   s   &&&    r    'test_min_max_dt64_with_NaT_skipna_false?TestDataFrameReductions.test_min_max_dt64_with_NaT_skipna_falseb  s!   b'""':'<'<KK4
 3;3; i 5"=rvvF
 ff!Ef*266&>26623~~C...
s-ff!Ef*266&>26623~~C...
s-r#   c                :   \        R \        . 4      /4      p\        \        . 4      4      pVP                  ^ R7      P                  \
        P                  J VP                  4       \
        P                  J 8X  g   Q hVP                  ^ R7      P                  \
        P                  J VP                  4       \
        P                  J 8X  g   Q h\        P                  ! VP                  ^R7      V4       \        P                  ! VP                  ^R7      V4       R# )r   r>   N)
r   r   r   r   r   r   r[  r   rH   rL   )r   rV   expected_dt_seriess   &  r    *test_min_max_dt64_api_consistency_with_NaTBTestDataFrameReductions.test_min_max_dt64_api_consistency_with_NaT  s    
 [_-.#KO4A  BFF*0B0F0F0HBFF0RSSSA  BFF*0B0F0F0HBFF0RSSS 	rvv1v~/AB
rvv1v~/ABr#   c                B   \        R . /4      p\        . \        R7      p\        P                  ! VP                  ^ R7      P                  4      \        P                  ! VP                  4       4      8X  g   Q h\        P                  ! VP                  ^ R7      P                  4      \        P                  ! VP                  4       4      8X  g   Q h\        P                  ! VP                  ^R7      V4       \        P                  ! VP                  ^R7      V4       R# )r   rb   r>   N)
r   r   r   r'   r  r   r   r   rH   rL   )r   rV   expected_float_seriess   &  r    *test_min_max_dt64_api_consistency_empty_dfBTestDataFrameReductions.test_min_max_dt64_api_consistency_empty_df  s     Ry! &r 7xxA(()RXX6K6O6O6Q-RRRRxxA(()RXX6K6O6O6Q-RRRR
rvv1v~/DE
rvv1v~/DEr#   initialz2018-10-08 13:36:45+00:00z2018-10-08 13:36:45+03:00r   r   r   c                    < V ^8  d   QhRS[ /# )r   r  )r   )formatr  s   "r    __annotate__$TestDataFrameReductions.__annotate__  s     1 1c 1r#   c                    \        V4      p\        V.4      p\        V.4      p\        WR4      ! ^R7      p\        P
                  ! Wd4       R# r  )r   r   r   rG   rH   rL   )r   r  r   
initial_dtrZ   rV   rW   s   &&&    r    test_preserve_timezone.TestDataFrameReductions.test_preserve_timezone  sC     !)
:,'z"$!,
v0r#   c           
        \        R RR7      p\        R\        \        P                  \        P                  V.4      R\        \        P                  W3.4      /4      p\        WA4      pV! ^VR7      pV'       d   \        \        P                  W3.4      pM*\        \        P                  \        P                  V.4      p\        P                  ! Wg4       R# )z
1900-01-01T)utcr2   r/   r8   N)r   r   r   r   r[  rG   rH   rL   )r   r   r:   valrV   r   rW   rZ   s   &&&     r    !test_minmax_tzaware_skipna_axis_19TestDataFrameReductions.test_minmax_tzaware_skipna_axis_1  s     ,D1&"&&"&&#./fbffc=O6PQ
 R 6*rvvs01Hrvvrvvs34H
v0r#   c                V   \        R \        ^ ^ .4      R\        \        ^ R4      \        ^R4      .4      /4      pVP                  ^ R7      p\        RR.R R.R7      p\        P
                  ! W#4       VP                  ^R7      p\        RR.R7      p\        P
                  ! W#4       R	# )
r2   tr   msr>   FT)r[  rD   rZ  N)r   r   r   r   rH   rL   r  s   &   r    test_frame_any_with_timedelta5TestDataFrameReductions.test_frame_any_with_timedelta  s    VQF^V\!S1<43HIJ
 Qt}S#J?
v0Qt}-
v0r#   c                0   VR 8X  d0   VP                  \        P                  P                  RR7      4       V! . RO4      pRp\        P                  ! \
        VR7      ;_uu_ 4        \        WC4      ! RR7       RRR4       R#   + '       g   i     R# ; i)r   zCount does not accept skipna)reasonzAFor argument "skipna" expected type bool, received type NoneType.rA   Nr  r  )applymarkerrN   r  xfailrO   rP   rG   )r   r  frame_or_seriesr  objr   s   &&&&  r    "test_reductions_skipna_none_raises:TestDataFrameReductions.test_reductions_skipna_none_raises  sn     W$!!)G!H i(Q]]:S11C(5 2111s   'BB	c           
        \        R \        \        R4      .RR7      R\        \        R4      .RR7      /4      pVP                  4       p\        \        R4      \        R4      .RR R.R7      p\        P
                  ! W#4       R# )	r2   z
2019-12-31zdatetime64[s]rb   r/   z2019-12-31 00:00:00.123zdatetime64[ms]r  N)r   r   r   r   rH   rL   r  s   &   r    &test_reduction_timestamp_smallest_unit>TestDataFrameReductions.test_reduction_timestamp_smallest_unit  s    VY|45_MV89:BR
 |$i0I&JK"*

 	v0r#   c           
     d   \        R \        \        P                  ! R4      .RR7      R\        \        P                  ! R4      .RR7      /4      pVP	                  4       p\        \        P                  ! R4      \        P                  ! R4      .RR R.R7      p\
        P                  ! W#4       R# )r2   rL  ztimedelta64[s]rb   r/   ztimedelta64[ms]r  N)r   r   r   r  r   rH   rL   r  s   &   r    &test_reduction_timedelta_smallest_unit>TestDataFrameReductions.test_reduction_timedelta_smallest_unit  s    VR\\(34<LMVR\\(34<MN
 \\(#R\\(%;<#*

 	v0r#   r,   N)ru  r  r  r  r  r  r  r  r  r  rN   r  r  r  r  r  r  r  r  r  r  r  s   @r    r  r  $  s     ).) ),.<C
F [[	$&AB [[Xu~61 7	
1 [[Xu~61 711"
61$1 1r#   r  c                   t   a  ] tR tRt o R tR t]P                  P                  RRR.4      R 4       t	Rt
V tR	# )
TestNuisanceColumnsi  c                   \        ^ ^.RRR7      pVP                  4       p\        P                  ! \        RR7      ;_uu_ 4        \        W!4      ! 4        RRR4       \        P                  ! \        RR7      ;_uu_ 4        \        \        V4      ! V4       RRR4       \        P                  ! \        RR7      ;_uu_ 4        \        W14      ! RR7       RRR4       \        P                  ! \        RR7      ;_uu_ 4        \        W14      ! RR7       RRR4       \        P                  ! \        RR7      ;_uu_ 4        \        \        V4      ! V^ R	7       RRR4       R#   + '       g   i     EL; i  + '       g   i     L; i  + '       g   i     L; i  + '       g   i     L; i  + '       g   i     R# ; i)
r   rl  r  )rE   r7  does not support operationrA   NFrg  r>   )r   to_framerN   rO   r   rG   r'   )r   rE  serrV   s   &&  r    .test_any_all_categorical_dtype_nuisance_columnBTestNuisanceColumns.test_any_all_categorical_dtype_nuisance_column  s#   aV:C8\\^ ]]9,HIIC02 J ]]9,HIIB./4 J ]]9,HIIB/%@ J ]]9,HIIB/$? J ]]9,HIIB./; JI JII JI JI JI JIIs<   E&E:FF F3&E7	:F
	F	 F0	3G	c                   \        R \        . RO4      /4      pVR ,          p\        P                  ! \        RR7      ;_uu_ 4        VP                  4        RRR4       \        P                  ! \        RR7      ;_uu_ 4        VP                  RR7       RRR4       \        P                  ! \        RR7      ;_uu_ 4        VP                  4        RRR4       VR ,          P                  \        4      VR&   \        P                  ! \        RR7      ;_uu_ 4        VP                  RR7       RRR4       \        P                  ! \        RR7      ;_uu_ 4        VP                  4        RRR4       R#   + '       g   i     EL*; i  + '       g   i     L; i  + '       g   i     L; i  + '       g   i     L; i  + '       g   i     R# ; i)r  r  rA   NFr  r	  )r   r   r   r   r   )r   r	   rN   rO   r   r   r   r   )r   rV   r  s   &  r    -test_median_categorical_dtype_nuisance_columnATestNuisanceColumns.test_median_categorical_dtype_nuisance_column  s)   [9:;g ]]9,HIIJJL J ]]9,HIIII5I) J ]]9,HIIIIK J S'..%3]]9,HIIII5I) J ]]9,HIIIIK JI JII JI JI JI JIIs<   E8FFF2G8F		F	F/	2G	G	r   r   r   c                6   \        . R
ORR7      p\        V4      pVP                  R4      p\        P                  ! \
        RR7      ;_uu_ 4        \        W14      ! 4        RRR4       \        P                  ! \
        RR7      ;_uu_ 4        \        \        V4      ! V4       RRR4       \        P                  ! \
        RR7      ;_uu_ 4        \        WA4      ! RR7       RRR4       \        P                  ! \
        RR7      ;_uu_ 4        \        WA4      ! 4        RRR4       \        P                  ! \
        RR7      ;_uu_ 4        \        \        V4      ! V^ R7       RRR4       VR,          P                  \        4      VR	&   \        P                  ! \
        RR7      ;_uu_ 4        \        WA4      ! 4        RRR4       \        P                  ! \
        RR7      ;_uu_ 4        \        \        V4      ! V^ R7       RRR4       R#   + '       g   i     EL; i  + '       g   i     EL; i  + '       g   i     EL^; i  + '       g   i     EL5; i  + '       g   i     EL; i  + '       g   i     L; i  + '       g   i     R# ; i)r2   F)orderedr  zis not ordered for operationrA   Nr  r>   r	  )r2   r/   r   r/   )
r	   r   r  rN   rO   r   rG   r'   r   rr   )r   r   catr  rV   s   &&   r    :test_min_max_categorical_dtype_non_ordered_nuisance_columnNTestNuisanceColumns.test_min_max_categorical_dtype_non_ordered_nuisance_column(  s    .>Sk\\# ]]9,JKKC " L ]]9,JKKB$ L ]]9,JKKBU3 L ]]9,JKKB! L ]]9,JKKB+ L S'..(3]]9,JKKB! L ]]9,JKKB+ LK) LKK LKK LKK LKK LKK
 LK LKKsT   HH$H8II 0I4-JH!	$H5	8I		I	 I1	4J	J	r,   N)ru  r  r  r  r  r  rN   r  r  r  r  r  r  s   @r    r  r    s8     <*6 [[Xu~6, 7,r#   r  c                   Z  a  ] tR tRt o ]P
                  P                  RR]P                  ^ ]P                  3R]P                  ^]P                  3R]P                  ^ ]P                  3R]P                  ^]P                  3R]P                  ^ ]P                  3R]P                  ^]P                  3R]P                  ^ ]P                  3R]P                  ^]P                  3R]P                  ^ ]P                  3R]P                  ^]P                  3R]P                  ^ ]P                  3.4      R 4       t]P
                  P                  RR]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3R]P                  ]P                  3.4      R 4       t]P
                  P                  RRR^ ]'       d   R	MR
3RR^]'       d   R	MR
3RRRR^ ]'       d   RMR3RR^]'       d   RMR3RRR R!R".4      R 4       t]P
                  P                  RRR]'       d   R	MR
3RR]'       d   R	MR
3R#R$RR]'       d   RMR3RR]'       d   RMR3R%R&R'R(R).4      R 4       t]P
                  P                  RR. R*OR]P.                  ]P.                  ]P.                  ./R. R*OR]! R4      ]P.                  ]P.                  ./R. R*OR]! R4      ]! R4      ]! R4      ./R. R*OR]P2                  ! R4      ]P2                  ! R4      ]P.                  ./R. R*OR]P2                  ! R4      ]P2                  ! R4      ]P2                  ! R4      ./.4      R 4       tRtV tR# )+TestEmptyDataFrameReductionsiH  z#opname, dtype, exp_value, exp_dtyperF   r?   c                    \        ^ . ^. /VR7      p\        WQ4      ! ^ R7      p\        W3.V\        ^4      R7      p\        P
                  ! Wg4       R# r   rb   r  r  N)r   rG   r   rK   rH   rL   r   rQ   rE   	exp_value	exp_dtyperV   rW   rZ   s   &&&&&   r    test_df_empty_min_count_06TestEmptyDataFrameReductions.test_df_empty_min_count_0I  sJ    " 2q"~U3$q190	qR
v0r#   zopname, dtype, exp_dtypec                    \        ^ . ^. /VR7      p\        WA4      ! ^R7      p\        \        P                  \        P                  .V\        ^ ^.4      R7      p\        P                  ! WV4       R# r  )r   rG   r   r'   r(   r   rH   rL   r   rQ   rE   r  rV   rW   rZ   s   &&&&   r    test_df_empty_min_count_16TestEmptyDataFrameReductions.test_df_empty_min_count_1`  sX    " 2q"~U3$q1266266*)5!Q=Q
v0r#   Int8Int32r  UInt8UInt32UInt64c                    \        ^ . ^. /VR7      p\        WQ4      ! ^ R7      p\        W3.V\        ^ ^.4      R7      p\        P
                  ! Wg4       R# r  )r   rG   r   r   rH   rL   r  s   &&&&&   r    "test_df_empty_nullable_min_count_0?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_0w  sP    " 2q"~U3$q190	PQSTvW
v0r#   c                    \        ^ . ^. /VR7      p\        WA4      ! ^R7      p\        \        P                  \        P                  .V\        ^ ^.4      R7      p\        P                  ! WV4       R# r  )r   rG   r   r   r  r   rH   rL   r  s   &&&&   r    "test_df_empty_nullable_min_count_1?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_1  sW    " 2q"~U3$q1255"%%.	1vO
v0r#   r[  r2   r/   z
1990-01-01z
1991-01-01z
1992-01-01rL  z2 daysz3 daysc                    \        V4      p\        P                  ! \        R R7      ;_uu_ 4        VP	                  4        RRR4       R#   + '       g   i     R# ; i)znot supported for covrA   N)r   rN   rO   r   cov)r   r[  rV   s   && r    test_df_cov_pd_nat/TestEmptyDataFrameReductions.test_df_cov_pd_nat  s8    : t_]]9,CDDFFH EDDDs   AA	r,   N)rF   r  r   r  )r?   r  r   r  )rF   r  r   r  )r?   r  r   r  )rF   Float32r   r  )r?   r  r   r  )rF   r  r   r  )rF   r  r  )r?   r  r  )rF   r  r  )r?   r  r  )rF   r  r  )r?   r  r  )rF   r  r  )r   r   r   )ru  r  r  r  rN   r  r  r'   int8rV  int_uint8uint64uintr   r  r  r  is_windows_np2_or_is32r  is_windows_or_is32r  r   r[  r   r  r  r  r  r  s   @r    r  r  H  s    [[-BGGQ)RWWa)BHHa*RXXq"((+BHHa+RXXq"''*BIIq")),RYY299-BJJ2::.RZZBJJ/BJJ2::.	
 1! 1 [["BGGRZZ(RWWbjj)BHHbjj)RXXrzz*BHHbjj)RXXrzz*BIIrzz*RYY

+BJJ

+RZZ,BJJ

+	
 1! 1 [[-FA+AwPVQ,BQ()GQ-CSWa.D((T*+,-,	
 1! 1 [["F(:WIV);gJ%&G*<h(LW+=x8M'()*)	
 1! 1 [[)S266266266":;)S9\#:BFFBFF"KLYl+l+l+ Ybll8,bll8.DbffM
 YLL*LL*LL*	
676r#   r  c                  <   \         P                  ! ^4      P                  \         P                  4      P	                  R4      P                  ^^4      p RV R	&   \        V 4      pVP                  V P                  8H  P                  4       '       g   Q hVP                  RR7      p\        \        P                  ! ^R7      \        P                  .RR7      p\        P                   ! W#4       VP                  ^ RR7      p\        P                   ! W#4       VP                  ^RR7      p\        \        P                  ! ^R7      \        P                  ! ^R7      \        P                  ! ^	R7      \        P                  .RR7      p\        P                   ! W#4       R# )
r]  zm8[s]NatFr  ru  rb   r8   N)r  r  )r'   r_  r   rV  viewreshaper   rt  rE   r  rF   r   r   r  r[  rH   rL   )r0  rV   rW   rZ   s       r    !test_sum_timedelta64_skipna_falser    s'   
))A,

bhh
'
,
,W
5
=
=a
CCCK	3BII"''))))VV5V!Fr||B/8HH6,VV5V)F6,VV5V)FLL#LL#LL#FF		
 H 6,r#   c                      \        R ^..\        R4      R7      p V P                  RR/4      p V P                  4       p\	        R ^.R R.R7      p\
        P                  ! W4       R# )r2   abr   r/   r  r  N)r   rs   r   rF   r   rH   rL   rV   rW   rZ   s      r    !test_mixed_frame_with_integer_sumr    sW    	S!H:tDz	2B	C>	"BVVXFsAhsCj1H6,r#   r   r   r   r   c                 N   \         P                  ! R 4      p\        VP                  RVP                  .\
        P                  ! 4       R7      p\        RV/4      p\        W@4      ! VR7      p\        \        W 4      .R\        R.4      R7      p\        P                  ! WV4       R# )rV  Nrb   r  r  r  )r'   iinfor   r   r   r   
Int64Dtyper   rG   r   rH   rL   )r   r   
int64_infor  rV   rW   rZ   s   &&     r    test_minmax_extensionarrayr    s     '"J
*..$
7r}}
OC	GS>	"BR l;F		$%WIH
 6,r#   ts_valuez
2000-01-01c           
          \        R ^.RR.RR.RV ./4      p\        P                  ! \        RR7      ;_uu_ 4        VP	                  4        RRR4       R#   + '       g   i     R# ; i)	r2   r/   g?r   r5  r   z)does not support operation|Cannot performrA   N)r   rN   rO   r   rF   )r  rV   s   & r    .test_frame_mixed_numeric_object_with_timestampr    sR     
C!cC5#whZH	IB	y(S	T	T
 
U	T	T	Ts   AA(	c                  n   \        . RO4      p V P                  ^ ^RR7      p\        R.\        R7      p\        P
                  ! W4       \        P                  ! R4      p\        P                  ! \        VR7      ;_uu_ 4        V P                  ^ ^RR7       RRR4       R#   + '       g   i     R# ; i)	r   r2   F)r9   r  r   rb   z2unsupported operand type(s) for +: 'int' and 'str'rA   N)r   r2   T)r   r?   r   rr   rH   rL   r   escaperN   rO   r   rF   )rV   rW   rZ   r   s       r    $test_prod_sum_min_count_mixed_objectr     s}    	>	"BWW!quW=Fse6*H6,
))H
IC	y	,	,
A7 
-	,	,	,s   B##B4	rE   r  r  c                    \        \        P                  P                  ^4      P	                  R
4      VR7      p\        W04      ! RVR7      pVP                  \        P                  R7      pV R9   dL   \        P                  ! R4      pV R8X  d   Rp \        W`4      ! VRRR7      p\        P                  ! WG4       R# \        \        V 4      ! VRR	7      pWG8X  g   Q hR# )r   rb   Nr   r   r   r   F)r   r9   r>   )rl   rl   >   r   r   )r   r'   r{   r|   r}   rG   to_numpyr  rN   r   rH   r+  )r   r   rE   rV   rW   np_arrcomp_modrZ   s   &&&     r    'test_reduction_axis_none_returns_scalarr%    s     
299((+;;FC5	QBR dFF[[rzz[*F!!&&}5VF8,V%dK
v02v&vD9!!!r#   kernelc                 H   \        R . R	OR\        /4      pV R8X  d   V3MR
pRP                  . RO4      pV R8X  d   RpRpRP                  WE.4      p\        P                  ! \
        VR7      ;_uu_ 4        \        W4      ! V!   RRR4       R#   + '       g   i     R# ; i)r2   r/   corrwithr   r   zTCannot convert \[\[<class 'object'> <class 'object'> <class 'object'>\]\] to numericzPCannot convert \[<class 'object'> <class 'object'> <class 'object'>\] to numericrA   Nr  r,   )znot allowed for this dtypez%argument must be a string or a numberz"not supported between instances ofr  z*argument must be a string or a real number)r   rr   r   rN   rO   r   rG   )r&  rV   argsr   msg1msg2s   &     r    test_fails_on_non_numericr,  (  s    0 
CC0	1Bj(B5bD
((	
C / 	
- 	 hh|$	y	,	,T" 
-	,	,	,s   6BB!	r  c                     \        R \        . ROVR7      R\        ^ ^\        P                  ^.VR7      /4      p\        R . RORRR\        P
                  R./4      pV R9   d   RpM-V R9   d   RpM#V R9   d   VP                  R4      '       g   R	pMTp/ pV R9  d   WR
&   V R9   d   W(R&   V'       g   V R9   d   \        P                  ! \        RR7      ;_uu_ 4        \        WP4      ! RR^/VB  RRR4       \        P                  ! \        RR7      ;_uu_ 4        \        W`4      ! RR^/VB  RRR4       R# \        WP4      ! RR^/VB p	\        W`4      ! RR^/VB p
V R9  dX   V'       d   V
P                  V4      p
M=\        P                  ! V
4      p^ W&   V
P                  V4      p
\        P                  W&   \        P                  ! W4       R#   + '       g   i     L; i  + '       g   i     R# ; i)r2   rb   r/   r   r   r   rV  booleanFloatr  r:   r  zencountered an NA valuerA   r9   Nr  r  )r   r   r   r   r   )r  r   )r   r   r   r   r   r   r   r   )r   r   quantile)r?   r   rF   )r!  r  r,   )r   r   r   r  r'   r(   
startswithrN   rO   rP   rG   r   r  rH   rL   )r   r:   r  any_numeric_ea_dtypeusing_nan_is_narV   expected_dfr  r  rW   rZ   masks   &&&&&       r    test_numeric_ea_axis_1r6  Z  s   : 
,@AAruua(0DE	

B %#sBFFC(	
K %% 	>	!"	 	 	
 #--g66"-F55!x++'{f 44]]:-FGGB1Q1&1 H]]:-FGGK(:a:6: HR 2a262F{+==f=H))~6H88H%DHN~6HUUHN6, HGGGs   GG,G)	,G=	c            
      h   \        R . ROR\        . RO\        P                  ! 4       R7      /4      p V P	                  ^RR7      p\        . ROR	R7      p\
        P                  ! W4       V P	                  ^R
R7      p\        RRR\        P                  .R	R7      p\
        P                  ! W4       R# )r2   r/   Nrb   Tr8   r   r         @r  Fr   )r   r   rl   N)r   r   r8  r   )r   r   r   r  r   rH   rL   r  r  s      r    test_mean_nullable_int_axis_1r9    s    		lCr}}!OP
B WW!DW)F*)<H6,WW!EW*FsCbee,I>H6,r#   r   )TTFgh㈵>g:0yE>N)TFN)r   r   r   r   r   r   )corrr(  r  r!  r  r   r   r   r   r   r?   r0  r   r   r   rF   r   )r  r   r   r!  r  r   r   r   r   r   r   r   r?   r   r   r   r   rF   r   )@datetimer   decimalr   r   dateutil.tzr   numpyr'   rN   pandas.compatr   r   pandas.compat.numpyr   pandas.util._test_decoratorsutil_test_decoratorsr  pandasr   r	   r
   r   r   r   r   r   r   r   r   r   r   r   r   pandas._testing_testingrH   pandas.corer   r   r  r  r-   r`   fixturerw   r~   r   r  r  r  r  r  r  r  r  r[  r  r   r%  r,  r6  r9  r,   r#   r    <module>rI     sO     	    / ) )      
 ./FF4FSSt8 (*66$h @k1\  (  "A/ A/H*P1 P1fN, N,b~ ~B-8- )<=E5>2- 3 >- i&=rvv%FG H
8 #ST$79i"89" : 8 U"$ ,#-,#8 0 q!f-8- .128-v-r#   