
    m*i*                       S SK Jr  S SKJr  S SKrS SKJr  S SKrS SK	r	S SK
JrJr  S SKJr  S SKJs  Jr  S SKrS SKJrJrJrJrJrJrJrJrJrJrJrJ r J!r!J"r"  S SK#J$r%  S SK&J'r'J(r(  \" 5       =(       a    \(       + =(       d    \(       + r)\" 5       =(       d    \(       + r*S/S	 jr+      S0S jr,\	RZ                  S 5       r.\	RZ                  S 5       r/ " S S5      r0 " S S5      r1 " S S5      r2 " S S5      r3S r4S r5\	Rl                  Ro                  S/ SQ5      \	Rl                  Ro                  SSS/5      S 5       5       r8\	Rl                  Ro                  S\" S 5      \Rr                  /5      S! 5       r:S" r;\	Rl                  Ro                  S/ S#Q5      \	Rl                  Ro                  SS
S/5      \	Rl                  Ro                  S$S%S&/5      S' 5       5       5       r<\	Rl                  Ro                  S(/ S)Q5      S* 5       r=\	Rl                  Ro                  S/ S+Q5      \	Rl                  Ro                  S,S S-/5      S. 5       5       r>g)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                 4   ^ ^ T(       a  U4S jnU$ U 4S jnU$ )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                 (   > T" U R                   5      $ Nvalues)xskipna_alternatives    b/var/www/html/land-doc-ocr/venv/lib/python3.13/site-packages/pandas/tests/frame/test_reductions.pyskipna_wrapper+make_skipna_wrapper.<locals>.skipna_wrapper=   s    %ahh//    c                 r   > U R                  5       n[        U5      S:X  a  [        R                  $ T" U5      $ )Nr   )dropnalennpnanr   nonaalternatives     r    r!   r"   B   s-    88:D4yA~vvt$$r#    )r+   r   r!   s   `` r    make_skipna_wrapperr-   +   s"      	0 	% r#   TFc	                   ^ [        X 5      n	U(       a  [        S[        SSS905      n
[        R                  " S5         [        X5      " 5       nSSS5        [        W[        5      (       d   e[        [        U
5      5      U
S'   [        R                  " S5         [        X5      " 5       nSSS5        [        U[        5      (       d   e[        U5      (       d   eU(       ak  U4S jn[        TU5      nU	" SS	S
9nU	" SS	S
9n[        R                  " XR                  U5      XFUS9  [        R                  " UUR                  USS9UUS9  OTnU	" SS9nU	" SS9n[        R                  " UUR                  U5      UUUS9  U S;   a'  UR                  USS9n[        R                  " UUS	XgS9  U(       a:  UR                  R                  nUUR                  :X  d   eUUR                  :X  d   e[        R                  " [         SS9   U	" SS9  SSS5        U(       a  U["        R$                  -  n[        UU 5      " SS9n[        UU 5      " SS9nU S;   aw  U S:X  a  SOSn[        UUR&                  UR                  S9n[        R                  " UU5        [        UUR&                  UR                  S9n[        R                  " UU5        ggg! , (       d  f       GN= f! , (       d  f       GN@= f! , (       d  f       N= f)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                 (   > T" U R                   5      $ r   r   r   r+   s    r    wrapper$assert_stat_op_calc.<locals>.wrapper       qxx((r#   r   Faxisskipna   )check_dtypertolatolr:   )r>   r?   )sumprodNo axis named 2matchrB   indexdtype)getattrr   r   tmassert_produces_warning
isinstancer   ranger&   r-   assert_series_equalapplyr   rH   pytestraises
ValueErrorr'   r(   rG   )opnamer+   frame
has_skipnar=   check_datesr>   r?   r   fdfresultr6   r!   result0result1expected	lcd_dtypeall_nar0r1units    `                    r    assert_stat_op_calcrb   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#   KK&K8
K#&
K58
Lc            
         [        [        R                  " [        R                  " S[        S9[        R
                  " S[        S9/SS9[        [        S5       V s/ s H  n SU  3PM
     sn [        S9[        [        S5      [        S9[        S9n[        R                  UR                  S	S
& [        R                  UR                  SS2SS24'   U$ s  sn f )z|
Fixture for DataFrame of booleans with index of unique strings

Columns are ['A', 'B', 'C', 'D']; some entries are missing
)      rH   r   r@      foo_ABCD)rG   columnsrH      
   rd      N)r   r'   concatenateonesboolzerosr   rM   objectlistr(   ilocirX   s     r    bool_frame_with_narx      s     

WWWD)288G4+HIPQ	
 r3AtA3Z36Bd6l&1
B FFBGGAbM&&BGGBrE23JI 4s   Cc            
      z   [        [        R                  R                  S5      R	                  S5      [        [        S5       V s/ s H  n SU  3PM
     sn [        S9[        [        S5      [        S9S9n[        R                  UR                  SS	& [        R                  UR                  S
S2SS24'   U$ s  sn f )zz
Fixture for DataFrame of floats with index of unique strings

Columns are ['A', 'B', 'C', 'D']; some entries are missing
r0   )rg   re   rg   rh   rf   ri   rG   rj   rk   rl   rd   rm   rn   N)r   r'   randomdefault_rngstandard_normalr   rM   rs   rt   r(   ru   rv   s     r    float_frame_with_nar~      s     

		a 009r3AtA3Z36Bd6l&1
B FFBGGAbM&&BGGBrE23JI 4s   B8c                      \ rS rSr\R
                  R                  SSS/5      \R
                  R                  SSSSS	S
SSSSSS\R                  " S\R                  " S5      S9\R                  " S\R                  " S5      S9/5      S 5       5       r
\R
                  R                  SSS/5      \R
                  R                  SSSSS	S
SSSSS\R                  " S\R                  " S5      S9\R                  " S\R                  " S5      S9/5      S 5       5       rS rS rS r\R
                  R                  S/ SQ5      \R
                  R                  S\" / SQ/ SQ/ SQS ./ S!QS"S#9\" \R"                  S$/\R"                  S%/\R"                  S&/S'.\S(9/5      \R
                  R'                  S)5      S* 5       5       5       r\R
                  R                  S+/ S,Q5      S- 5       rS. rS/ r\R
                  R                  S0S1S2/5      S3 5       r\R
                  R                  S0S1S2/5      S4 5       rS5 rS6 r\R
                  R                  S7/ S8Q5      S9 5       rS: r\R
                  R                  S;S<S=/S>/S?/S@/\" S@/S@/SA9\" SB/SCS(9\ " SD/5      SE.4SFS=/S>/\R"                  /\!" \R"                  /SGS(9\" \R"                  /S@/SA9\" \"RF                  /SCS(9\ " \"RF                  /5      SE.4S<SHSI\R"                  \R"                  /SHSI\R"                  \R"                  /S\R"                  \R"                  \R"                  /\" S@\R"                  \R"                  \R"                  /S@/SA9\" / SJQSCS(9\ " / SKQ5      / SLQSM.4SFSHSI\R"                  \R"                  /SHSI\R"                  \R"                  /S\R"                  \R"                  \R"                  /\" \R"                  S@\R"                  \R"                  /S@/SA9\" / SNQSCS(9\ " / SOQ5      / SLQSM.4/5      SP 5       r$SQ r%SR r&SS r'ST r(\R
                  R                  SUSVSW\"RF                  SX/S&\"RF                  /-  /5      SY 5       r)SZ r*\R
                  R                  S[\+" S5      \" / 5      \," / \RZ                  S(9\," / \R\                  S(9\" / S\S]9\/" / S^S]9/5      S_ 5       r0\R
                  R                  S`SS/5      Sa 5       r1\R
                  R                  SbScSd/5      \R
                  R                  Se/ SfQ5      Sg 5       5       r2Sh r3Si r4\R
                  R                  Sj/ SkQ5      \R
                  R                  SlSS$Sm.SnSo\R"                  /4SS%Sm.\R"                  \R"                  \R"                  /4SSFSp.SnSo\R"                  /4/5      Sq 5       5       r5\R
                  R                  Sj/ SkQ5      \R
                  R                  SlSS$Sm.SrSs\R"                  /4SS%Sm.\R"                  \R"                  \R"                  /4SSFSp.SrSs\R"                  /4/5      St 5       5       r6Su r7Sv r8Sw r9Sx r:Sy r;Sz r<S{ r=S| r>S} r?\R
                  R                  S~S<SF/5      \R
                  R                  SSS/5      S 5       5       r@\R
                  R                  SSS/5      \R
                  R'                  S5      S 5       5       rA\R
                  R                  SeS<SF/5      S 5       rBS rC\R
                  R                  SSS/5      S 5       rD\R
                  R                  SSS/5      \R
                  R'                  S5      S 5       5       rE\R
                  R                  SeS<SF/5      S 5       rFS rGS rHS rI\R
                  R                  SSSS&/4SSS/4/5      S 5       rJS rK\R
                  R                  SSS/5      \R
                  R                  SSS/5      \R
                  R                  SSFS</5      S 5       5       5       rL\R
                  R                  SSS/5      \R
                  R                  SSS/5      S 5       5       rM\R
                  R'                  S5      \R
                  R                  SSS/5      S 5       5       rNS rO\R
                  R                  SSS/5      \R
                  R                  SSS/5      \R
                  R                  S~S<SF/5      S 5       5       5       rP\R
                  R'                  S5      S 5       rQS rR\R
                  R                  S/ \R                  0 SF4P\R                  0 S<4P\R                  S/ 0SF4P\R                  S/ 0S<4P\R                  SSFSF/0SF4P\R                  SSFSF/0SF4P\R                  SS<SF/0S<4P\R                  SS<SF/0SF4P\R                  SS<S</0S<4P\R                  SS<S</0S<4P\R                  SF/SF/S.SF4P\R                  SF/SF/S.SF4P\R                  SFSF/SFS</S.S<4P\R                  SFSF/SFS</S.SF4P\R                  S\!" SS?/SS(90SF4P\R                  S\!" SS?/SS(90S<4P\R                  S\!" SS/\US(90SF4P\R                  S\!" SS/\US(90S<4P\R                  " \R                  S\!" SS/SCS(90SF5      P\R                  " \R                  S\!" SS/SS(90SF5      P\R                  " \R                  S\!" SS/SCS(90S<5      P\R                  " \R                  S\!" SS/SS(90S<5      P\R                  " \R                  S\!" SS$/SCS(90S<5      P\R                  " \R                  S\!" SS$/SS(90S<5      P\R                  " \R                  S\!" SS$/SCS(90S<5      P\R                  " \R                  S\!" SS$/SS(90S<5      P\R                  " \R                  S\!" SS/SS(90SF5      P\R                  " \R                  S\!" SS/SS(90S<5      P\R                  " \R                  S\!" SS$/SS(90S<5      P\R                  " \R                  S\!" SS$/SS(90S<5      P\R                  S\!" SS/SS(90S<4P\R                  S\!" SS/SS(90SF4P\R                  S\!" SS$/SS(90S<4P\R                  S\!" SS$/SS(90SF4P\R                  " \R                  \!" SS/SCS(9\!" SS/SS(9S.S<5      P5      S 5       rVS rWS rXS rYSrZg1)TestDataFrameAnalytics   r:   r   r<   rS   countrA   meanproductmedianminmaxnuniquevarstdsemskewscipy)markskurtc                 4   US;   a  US:X  d  US;   a  [        X5      " US9  OUS;   a  SnOpUS:X  a  US:X  a  S	nOaS
nO^US:X  a  SnOUUS:X  a  US:X  a  SR                  SS/5      nO5SnO2US;   a  SnO)US:X  a#  [        R                  " S[        R                  S9n[        W[        R                  5      (       d  US-   n[        R                  " [        US9   [        X5      " US9  S S S 5        US:w  a  [        X5      " USS9  g g ! , (       d  f       N&= f)N)rA   r   r   r   r   r   r@   )r   r   r   r   r   z(could not convert string to float: 'bar'r   r<   z2can't multiply sequence by non-int of type 'float'z0can't multiply sequence by non-int of type 'str'rA   z7unsupported operand type\(s\) for \+: 'float' and 'str'r   |z%Could not convert \['.*'\] to numericz/Could not convert string '(bar){30}' to numericr   r   z<'[><]=' 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 reductionrD   r   Tr:   numeric_only)
rI   joinrecompileSrL   PatternrP   rQ   	TypeError)selffloat_string_framer:   rS   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*3> 5Y&/TM  54s   D		
Dc                 $    [        X5      " USS9  g )NFr   rI   )r   float_framer:   rS   s       r    test_stat_op_api_float_frame3TestDataFrameAnalytics.test_stat_op_api_float_frame  s    & 	$$UCr#   c           	         S nS nS nS nS n[        SUUSSSS	9  [        S
[        R                  UR                  S5      SSS9  [        S
[        R                  U[        R                  S9  [        S[        R
                  USS9  [        S[        R                  U[        R                  S9  [        SXQ5        [        SXa5        [        SXq5        [        SUUSSSS	9  g )Nc                 4    [        U 5      R                  5       $ r   )r   rA   ss    r    r   7TestDataFrameAnalytics.test_stat_op_calc.<locals>.count5  s    8<<>!r#   c                 \    [        [        R                  " U R                  5       5      5      $ r   )r&   r   unique1dr%   r   s    r    r   9TestDataFrameAnalytics.test_stat_op_calc.<locals>.nunique8  s    z**188:677r#   c                 ,    [         R                  " U SS9$ Nr<   ddof)r'   r   r   s    r    r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.var;      66!!$$r#   c                 ,    [         R                  " U SS9$ r   )r'   r   r   s    r    r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.std>  r   r#   c                 l    [         R                  " U SS9[         R                  " [        U 5      5      -  $ r   )r'   r   sqrtr&   r   s    r    r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.semA  s$    66!!$rwws1v66r#   r   FT)rU   r=   rV   rA   float32gMbP?)r=   r>   )r   r   rV   r   r   r   r   r   )rb   r'   rA   astypenansumr   rB   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                 z   ^ [         R                  " S5      mU4S jnU4S jn[        SX!5        [        SX15        g )Nscipy.statsc                 b   > [        U 5      S:  a  [        R                  $ TR                  U SS9$ )N   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                 b   > [        U 5      S:  a  [        R                  $ TR                  U SS9$ )Nre   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   )rP   importorskiprb   )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                 8    S n[        SX1SS9  [        SX2SSS9  g )Nc                     [        U 5      R                  5       (       a  [        R                  $ [        R                  " U 5      $ r   )r   anyr'   r(   r   r   s    r    r6   3TestDataFrameAnalytics.test_median.<locals>.wrapper}  s(    Aw{{}}vv99Q<r#   r   Tr   F)r=   rV   )rb   )r   r~   	int_framer6   s       r    test_median"TestDataFrameAnalytics.test_median|  s'    	 
 	HgPTUge	
r#   method)rA   r   rB   r   r   r   r   r   rX   )gȃw@Ba@gCVZg
?Z.F?)r   r           )g94c4?g@}jX?gNr3   r/   cfoobarbazOrF   r0   r   re   r   r<   r0   rf   z0ignore:Mismatched null-like values:FutureWarningc                 B   UR                   R                  [        R                  :X  d   e[	        X!5      " US9n[	        UR                  S5      U5      " US9R                  [        5      nUS;   a  US;   a  S XUR                  5       '   [        R                  " XE5        g )Nr@   f8)r<   rj   r   )
r   rH   r'   object_rI   r   rs   r   rJ   rN   )r   r   rX   r:   rY   r\   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#   op)r   r   r   r   r   r   c                    [        / SQ/ SQ/ SQS.5      nSR                  / SQ5      n[        R                  " [        US9   [        X!5      " 5         S S S 5        [        R                  " SS	5         [        R                  " [        US9   [        X!5      " 5         S S S 5        S S S 5        g ! , (       d  f       Na= f! , (       d  f       N(= f! , (       d  f       g = f)
Nr<   r0   r   re   )      ?       @      @      @r3   r/   r   d)intfloatstrr   )zCould not convertcould not convertz"can't multiply sequence by non-intzdoes not supportzCannot performrD   use_bottleneckF)r   r   rP   rQ   r   rI   pdoption_context)r   r   rX   r   s       r    test_mixed_ops%TestDataFrameAnalytics.test_mixed_ops  s     #-+
 hh
 ]]9C0BO 1 /7y4! 5 87 10 54 87s0   B.2CB?C.
B<?
C		C
Cc                 @   [        / SQ/ SQ/ SQS.5      nUR                  / SQS9  UR                  SS9n[        R                  " UR
                  [        R                  " / SQ[        S	95        UR                  R                  S
S9n[        R                  " X#5        g )N)TTFFF)rl   rm   rg   (   2   )r3   r/   r   r   e)	bool_dataint_datastring_datarj   r   r@   )r0      abcderf   r<   )r   reindexrA   rJ   assert_numpy_array_equalr   r'   arrayrs   TrN   )r   rX   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           	         [        / SQ/ SQS[        R                  S/S.5      n[        R                  " UR                  5       [        SSSS.5      5        [        R                  " UR                  SS9[        SSSS.5      5        [        R                  " UR                  SS	9[        SSSS
.5      5        [        R                  " UR                  SSS9[        SSSS
.5      5        g )Nr<   r<   r<   r<   r0   r   r<   r   ABCr0   Fr%   r@   r   )r:   r%   )r   r'   r(   rJ   rN   r   r   r   rX   s     r    test_nunique#TestDataFrameAnalytics.test_nunique  s    YYa^LM
rzz|V!!!4L-MN
JJeJ$f111-E&F	
 	rzzqz16aA!:L3MN
JJAeJ,fqQ5G.H	
r#   tzNUTCc                     [        SS/[        SUS9/S-  S.5      nUR                  5       n[        S[        SUS9/SS/S	9n[        R
                  " X45        g )
Nr<   2000r  r0   r  r  r   r  r  rG   r   r   r   r   rJ   rN   r   r  rX   rY   r\   s        r     test_mean_mixed_datetime_numeric7TestDataFrameAnalytics.test_mean_mixed_datetime_numeric  s[     aV9V+C*Dq*HIJ3	&R 89#sL
v0r#   c                     [        S[        SUS9/S-  05      nUR                  5       n[        [        SUS9/S/S9n[        R
                  " X45        g )Nr  r  r  r0   r  r  r   s        r    test_mean_includes_datetimes3TestDataFrameAnalytics.test_mean_includes_datetimes  sS    
 i267!;<=9V34SEB
v0r#   c                 8   SS [        S5      S.SS [        S5      S.SS [        S5      S.SS [        S5      S.S	S [        S
5      S.SS[        S5      S.SS [        S5      S.S	S [        S5      S.SS [        S5      S.SS [        S5      S./
n[        U5      n[        R                  " [        SS9   UR                  5         S S S 5        USS/   R                  5       n[        SS/SS/[        S9n[        R                  " X45        g ! , (       d  f       NM= f)Nr0   z628.00r  r<   z383.00r   z651.00z575.00re   z1114.00TESTz241.00z572.00z609.00z820.00rk   z1223.00z8unsupported operand type|does not support|Cannot performrD   r  r  g@gL@rF   )
r   r   rP   rQ   r   r   r   rs   rJ   rN   )r   r   rX   rY   r\   s        r    test_mean_mixed_string_decimal5TestDataFrameAnalytics.test_mean_mixed_string_decimal  s   
 $WX%67$WX%67$WX%67$WX%67$WY%78&wx'89$WX%67$WX%67$WX%67$WY%78
 q\]]W
 GGI
 S#J$$&3,sCjG
v0
 
s   3D
Dc                    UR                  SS9nUR                  S 5      n[        R                  " X#5        UR	                  SS9nUR                  S 5      n[        R                  " X#5        [
        R                  " [
        R                  R                  S5      R                  S5      SS5      n[        R                  " USS	9nUS:  R                  5       (       a   e[        R                  " S
S5         [        R                  " USS	9nUS:  R                  5       (       a   e S S S 5        g ! , (       d  f       g = f)Nre   r   c                      U R                  SS9$ Nre   r   )r   r   s    r    <lambda>5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>      !%%Q%-r#   c                      U R                  SS9$ r,  )r   r   s    r    r-  r.    r/  r#   r0   r<     r2  r   r@   r   F)r   rO   rJ   assert_almost_equalr   r'   repeatr{   r|   r   nanvarr   r   r   r   datetime_framerY   r\   arrs        r    test_var_std#TestDataFrameAnalytics.test_var_std  s   ###+!''(?@
v0###+!''(?@
v0ii		--a077	BD!Ls+QJ##%%%%/7]]3Q/F
''))))) 877s   90D33
Emeth)r   r   r   c                 |   [        [        R                  R                  S5      R	                  S5      / SQS9nUR                  S[        05      nSUR                  S'   [        [        R                  R                  S5      R	                  S5      / SQS9nUR                  S[        05      nSUR                  S'   [        X!5      " S	S
S9n[        USS/   U5      " S	S9n[        R                  " XT5        [        X15      " S	S
S9n[        USS/   U5      " S	S9n[        R                  " XT5        Sn[        R                  " [        US9   [        X!5      " S	SS9  S S S 5        Sn[        R                  " [        US9   [        X15      " S	SS9  S S S 5        g ! , (       d  f       NC= f! , (       d  f       g = f)Nr0   )rk   r   r   r  r   100)r   r   r3   r<   Tr   r   r   r@   z6unsupported operand type\(s\) for -: 'float' and 'str'rD   Fz&could not convert string to float: 'a')r   r'   r{   r|   r}   r   rs   locrI   rJ   rN   rP   rQ   r   )r   r;  df1df2rY   r\   r   s          r    test_numeric_only_flag-TestDataFrameAnalytics.test_numeric_only_flag   st    II!!!$44V<)

 jj%)!II!!!$44V<)

 jj%)#>3u~.51=
x0#>3u~.51=
x0 H]]9C0CAE: 16]]9C0CAE: 10 10 10s   FF-
F*-
F;c                    UR                  SS9nUR                  S 5      n[        R                  " X#5        [        R
                  " [        R                  R                  S5      R                  S5      SS5      n[        R                  " USS9nUS:  R                  5       (       a   e[        R                  " S	S
5         [        R                  " USS9nUS:  R                  5       (       a   e S S S 5        g ! , (       d  f       g = f)Nre   r   c                 `    U R                  SS9[        R                  " [        U 5      5      -  $ r,  )r   r'   r   r&   r   s    r    r-  1TestDataFrameAnalytics.test_sem.<locals>.<lambda>G  s    !%%Q%-"''#a&/2Qr#   r0   r1  r2  r   r@   r   F)r   rO   rJ   r3  r'   r4  r{   r|   r   nansemr   r   r   r6  s        r    test_semTestDataFrameAnalytics.test_semE  s    ###+!''(QR
v0ii		--a077	BD!Ls+QJ##%%%%/7]]3Q/F
''))))) 877s   0C<<
D
zdropna, expectedT   g      $@r   r3   )
categories
2000-01-02M8[ns]1 days)r  r  r  DEFGFr      	   )rK  NaTrT  rT  rM  r(   r(   r(   r   r<   r0   r   )HIJKLMNrT  rK  rT  rT  )r(   rM  r(   r(   c                 >   [        / SQSS[        R                  S/S[        R                  [        R                  [        R                  /[        [        R                  [        R                  S[        R                  /SS9[	        [        R                  [        R                  S[        R                  /5      [        / SQS	S9[        / S
Q5      / SQ/ SQSS[        R                  [        R                  /[	        S[        R                  S[        R                  /5      [        / SQS	S9[        / SQ5      [        R                  " SSS9S.5      nU[        UR                  5       5         R                  US9n[        U5      n[        R                  " XB5        g )N)rI  rI        rl   r   r<   r3   r   rf   r^  rL  rU  )rR  rR  rS  rS  )rS  rS  rR  rR  )rK  rK  rT  rT  )rM  r(   rM  r(   re   int64)r  r  r  rN  rO  rP  rQ  rW  rX  rY  rZ  r[  r\  r]  r  )r   r'   r(   r   r	   r   r   arangesortedkeysmoderJ   assert_frame_equal)r   r%   r\   rX   rY   s        r    test_mode_dropna'TestDataFrameAnalytics.test_mode_dropnaR  s%   t %"bffa(0RVVRVVS"&&9G "&&"&&#rvv!>?"#FhW!"AB!!BFFBFF+ #rvvsBFF!;<">h ""DEYYq0!
* F8==?+,111@X&
f/r#   c                     [        S[        R                  [        R                  SS/05      n[        SS[        R                  /05      nUR                  SS9n[        R
                  " XC5        g )Nr  r3   Fr  )r   r'   r(   rf  rJ   rg  )r   using_infer_stringrX   r\   rY   s        r    test_mode_sort_with_na-TestDataFrameAnalytics.test_mode_sort_with_na  sW    bffbffc3789cC=12&
f/r#   c           	          [        / SS/S9nUR                  5       n[        / SS/[        / [        R                  S9S9n[
        R                  " X#5        g )Nr3   r/   r  rf   rj   rG   )r   rf  r   r'   rb  rJ   rg  r   rX   rY   r\   s       r    test_mode_empty_df)TestDataFrameAnalytics.test_mode_empty_df  sH    rC:.R#s5288;TU
f/r#   c           
      p   [        [        SSSS9[        SSSS9[        S5      [        SSS9-
  S	.5      n[        US
   US   -
  US
   US   -
  S.5      nUR	                  5       nUR
                  S   UR                  S   :X  d   eUR
                  S   UR                  S   :X  d   eUR	                  SS9nX2R                  S   :H  R                  5       (       d   eUR                  5       nUR
                  S   UR                  S   :X  d   eUR
                  S   UR                  S   :X  d   eUR                  SS9nX2S
   :H  R                  5       (       d   eUR                  5       n[        U5      n[        US
   US   -
  US   US
   -
  S.5      n[        R                  " X55        [        R                  " XE5        UR                  5       nSUS'   SUS'   SUS'   [        S5      US'   UR	                  5       n[        [        R                  " [        SS95      [        R                  " [        SS95      SSS[        S5      /UR                   S9n[        R"                  " X55        UR	                  SSS 9n[        / S!Q/ S"QS9n[        R"                  " X55        US
S/   R	                  S5      n[        [        SS9/S-  5      n[        R"                  " X55        US
S/   R	                  5       n[        [        SS9[        SS9/S
S/S9n[        R"                  " X55        [        [        S#SS$9[        S%SS$9S&.5      nUS'   US(   -
  US)'   US)   R$                  S*:X  d   eUS(   US'   -
  US+'   UR'                  5         US)   R$                  S*:X  d   eUS+   R$                  S*:X  d   eg ),Nz2012-1-1r   rN  r2   freqz2012-1-220120101rk   )minutessecondsr  r  r  r  r  r   )r   r  r<   )r   r  r@   )r0   r  )r0   r  r   r   rO  20130101rP  i1  rx  )daysr  Tr   )r<   r<   r   r   20130102r1   20130105)timetime2r  r  off1timedelta64[ns]off2)r   r   r   r   r   ru   r>  allr   absrJ   rg  copyr   r   	Timedeltarj   rN   rH   _consolidate_inplace)r   rX   diffsrY   result2r\   mixeds          r    test_operators_timedelta641TestDataFrameAnalytics.test_operators_timedelta64  s   
AC@
AC@z*Yq!-LL
 3"S' 1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*2c7RW#42c7RW;LMN
f/
g0 

c
c
c
z*c
 Yz:;YB/0*% --

 	v0 5+Y7
v0 Sz"&&q)9"-.23
v0Sz"&&(z*I2,>?Sz
 	v0 ":q9#J:
 [2f:-6
&z#4444Z"W+-6

!&z#4444&z#4444r#   c                    [         R                  " SSS9n[        XS.SS9n[         R                  UR                  S'   UR                  SS	9n[        US
   R                  5       [         R                  /S
S/SS9n[        R                  " X45        UR                  SSS9n[        [         R                  " S5      /S-  [         R                  [         R                  " S5      /-   5      n[        R                  " X45        g )Nz1 Dayrl   r1   r  Tr  )rn   r{  Fr;   r  r  r  rF   r<   r9   r   rR  )
r   timedelta_ranger   rT  ru   r   r   rJ   rN   r  )r   tdirX   rY   r\   s        r    !test_std_timedelta64_skipna_false8TestDataFrameAnalytics.test_std_timedelta64_skipna_false  s      "5S+$7&&u%W[[]BFF#C:=N
 	v0Qu-2<<?+a/2662<<?2KKL
v0r#   r   z
2022-01-01z
2022-01-02z
2022-01-03c                    U(       aL  U(       a  [        S U 5       5      (       a.  [        R                  R                  SS9nUR	                  U5        [        U5      R                  U5      n[        SU05      nUR                  US9n	U(       a  [        S U 5       5      (       a  [        S[        R                  0SU S3S	9n
O[        SS
0SU S3S	9n
[        R                  " X5        g )Nc              3   D   #    U  H  o[         R                  L v   M     g 7fr   r   rT  .0values     r    	<genexpr>FTestDataFrameAnalytics.test_std_datetime64_with_nat.<locals>.<genexpr>   s     B6%rvvo6    z=GH#51446: Incorrect type inference on NaT in reduction resultreasonr3   r  c              3   D   #    U  H  o[         R                  L v   M     g 7fr   r  r  s     r    r  r  )  s     A&bff_&r  ztimedelta64[]rf   l     "R: )r  rP   markxfailapplymarkerr   as_unitr   r   r   r   rT  rJ   rN   )r   r   r;   using_array_managerrequestra   r  dtirX   rY   r\   s              r    test_std_datetime64_with_nat3TestDataFrameAnalytics.test_std_datetime64_with_nat  s     #B6BBB;;$$V % D %&!))$/Sz"v&A&AAAsBFFm\$q3IJH sN3\$q;QRH
v0r#   c                     [        5       nUR                  S5      nUR                  S5      n[        U[        5      (       d   e[        U[        5      (       d   e[	        U5      S:X  d   e[	        U5      S:X  d   eg )Nr   r<   )r   rA   rL   r   r&   )r   empty_frameaxis0axis1s       r    test_sum_corner&TestDataFrameAnalytics.test_sum_corner0  sk    k""%((((%((((5zQ5zQr#   rG   ME)ru  rN  c                     [        S/US9n[        X15      " SS9nUS;   a  SnOUS:X  a  SnOS	n[        / X%S
9n[        R                  " XF5        g )Nr3   ro  r<   r@   )r   r  rq   r   rb  rs   rF   r   rI   r   rJ   rN   )r   all_reductionsrG   rX   rY   expected_dtyper\   s          r    test_axis_1_empty(TestDataFrameAnalytics.test_axis_1_empty:  sZ     uE2,!4^+#Nw&$N%N"E@
v0r#   	min_countc                     Un[        S[        R                  /0US9nUR                  SX#S9nU(       a  US:X  a  SO[        R                  n[	        U/US9n[
        R                  " Xh5        g )Nr3   rf   r<   )r:   r;   r  r    )r   r   NArA   r   rJ   rN   )	r   string_dtype_no_objectr;   r  rH   rX   rY   r  r\   s	            r    test_axis_1_sum_na)TestDataFrameAnalytics.test_axis_1_sum_naQ  s`     'beeW~U3QvCaRUU5'/
v0r#   zmethod, unit)rA   r   )rB   r<   r   )NTFc                    / SQn[        X"/U[        R                  /[        R                  [        R                  /S.5      n[        XQ5      " US9n[	        X"U/USS9n[
        R                  " Xg5        [        XQ5      " USS9n[	        X"[        R                  /US9n[
        R                  " Xg5        [        XQ5      " USS9n[	        X"U/USS9n[
        R                  " Xg5        [        UR                  SS  U5      " USS9n[	        U[        R                  [        R                  /US9n[
        R                  " Xg5        [        U/S	-  U/S
-  [        R                  /S
-  -   S.5      n[        XQ5      " US
S9n[	        USS/S9n[
        R                  " Xg5        [        XQ5      " USS9n[	        USS/S9n[
        R                  " Xg5        g )Nr   r   float64rF   r<   )r   r  r  r   rl   rk   r  r  r     )r   r'   r(   rI   r   rJ   rN   ru   )r   r   ra   r   idxrX   rY   r\   s           r    test_sum_prod_nanops+TestDataFrameAnalytics.test_sum_prod_nanops[  s    d\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                    / SQn[        SS/S[        R                  /[        R                  [        R                  /S.5      nUR                  [        5      nUR                  5       n[        / SQSUS9n[        R                  " XE5        UR                  SS9n[        R                  " XE5        UR                  SS9n[        SS[        R                  /SUS9n[        R                  " XE5        g )Nr   r   )r   r   r   m8[ns]rH   rG   r  r<   )	r   r'   r(   rO   r   rA   r   rJ   rN   )r   r  rX   r@  rY   r\   s         r    test_sum_nanops_timedelta0TestDataFrameAnalytics.test_sum_nanops_timedelta}  s    aV1bff+RVVRVV<LMNhh|$ )83?
v0 1%
v0 1%1a.D
v0r#   c                     [        / SQ/ SQS.5      nUR                  SS9n[        [        R                  [        R                  /SS/S9n[
        R                  " X#5        g )	Nr  re   rk   r  )r   yrl   r  r   r  r  )r   rA   r   r'   r(   rJ   rN   rp  s       r    test_sum_nanops_min_count0TestDataFrameAnalytics.test_sum_nanops_min_count  sL    YY78"%266266*3*=
v0r#   
float_type)float16r   r  zkwargs, expected_result)r:   r  g	@g333333@r9   c                     [        / SQSS[        R                  /S.US9nUR                  " S0 UD6n[	        U5      R                  U5      n[        R                  " XV5        g )N)r   gffffff@皙@g@r   r3   r/   rf   r,   )r   r'   r(   rA   r   r   rJ   rN   r   r  kwargsexpected_resultrX   rY   r\   s          r    test_sum_nanops_dtype_min_count6TestDataFrameAnalytics.test_sum_nanops_dtype_min_count  sT     _CBFF3CDJW!&!/*11*=
v0r#   r   r   c                     [        / SQSS[        R                  /S.US9nUR                  " S0 UD6n[	        U5      R                  U5      n[        R                  " XV5        g )N)r   r   r  r   r  rf   r,   )r   r'   r(   rB   r   r   rJ   rN   r  s          r     test_prod_nanops_dtype_min_count7TestDataFrameAnalytics.test_prod_nanops_dtype_min_count  sY     !c266(:;:
 "6"/*11*=
v0r#   c                     UR                   R                  [        5      n[        X!R                  UR
                  S9nU[        S5      -  nUR                  5         g )Nrz   r<   )r   r   r   r   rG   rj   r   rA   )r   r   r   rT   deltass        r    test_sum_object&TestDataFrameAnalytics.test_sum_object  sG    ##**3/&(9(9;CVCVW1%

r#   c                 t    [         R                  " U5      nUR                  S5        UR                  S5        g )Nr<   r   )r'   isnanrA   )r   r   boolss      r    test_sum_bool$TestDataFrameAnalytics.test_sum_bool  s&    %		!		!r#   c                     [        [        SSS9/ SQS.5      R                  / SQ5      n[        R                  " [
        SS9   UR                  5         S S S 5        g ! , (       d  f       g = f)	Nr  re   r1   r   r  )r0   r   re   z does not support reduction 'sum'rD   )r   r   r  rP   rQ   r   rA   r  s     r    test_sum_mixed_datetime.TestDataFrameAnalytics.test_sum_mixed_datetime  sM    Z:NOWW
 ]]9,NOFFH POOs   A
A+c                    Sn[         R                  " [        US9   UR                  SS9  S S S 5        [         R                  " [        SS9   UR                  SS9  S S S 5        US   S:  US'   UR                  S5      nUS   US   R                  R                  5       :X  d   eg ! , (       d  f       N= f! , (       d  f       Nb= f)	Nz1Could not convert|does not support|Cannot performrD   r   r@   unsupported operand typer<   r  rq   )rP   rQ   r   r   r   )r   r   r   r   meanss        r    test_mean_corner'TestDataFrameAnalytics.test_mean_corner  s    A]]9C0###+ 1 ]]9,FG###+ H *#.2F  #V}F 3 : : ? ? AAAA 10 HGs   B(B9(
B69
Cc                    [        [        R                  " S5      [        SSS9[        R
                  " SSS9[        R                  " SSSS9S.5      nUR                  S	S
9n[        SS05      n[        R                  " X#5        [        R                  " [        SS9   UR                  5         S S S 5        g ! , (       d  f       g = f)Nr   
2016-01-01r1   1D2016Yrt  )r  r  r  rN  Tr  r  r   z'mean is not implemented for PeriodArrayrD   )r   r'   rc  r   r   r  period_ranger   r   rJ   rN   rP   rQ   r   rp  s       r    test_mean_datetimelike-TestDataFrameAnalytics.test_mean_datetimelike  s    
 YYq\a8''a8__VQSA	
 d+3*%
v0]]9,UVGGI WVVs   B99
Cc           	         [        [        R                  " S5      [        SSS9[        R
                  " SSS9S.5      nUR                  SS9n[        SUR                  S	   UR                  S
   S.5      n[        R                  " X#5        [        R                  " SSSS9US'   [        R                  " [        SS9   UR                  SS9  S S S 5        g ! , (       d  f       g = f)Nr   r  r1   r  r  Fr  r<   )r<   r  )r<   r  r  r  rt  rN  z"mean is not implemented for PeriodrD   )r   r'   rc  r   r   r  r   r   r>  rJ   rN   r  rP   rQ   r   rp  s       r    )test_mean_datetimelike_numeric_only_false@TestDataFrameAnalytics.test_mean_datetimelike_numeric_only_false  s    YYq\a8''a8
 e,vRVVF^LM
v0 //&!#>3]]9,PQGGG' RQQs   ?C
C&c                    [         R                  R                  S5      R                  SSS9n[	        USS9nUR                  SS9n[	        U5      R                  5       R                  S	5      n[        R                  " X45        g )
Nr0   r2  )rl   rk   )sizeInt64rf   Tr  Float64)	r'   r{   r|   integersr   r   r   rJ   rN   )r   r8  rX   rY   r\   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                 $   [         R                  " [        SS9   UR                  S5        S S S 5        [         R                  " [        SS9   UR	                  S5        S S S 5        [         R                  " [        SS9   UR                  S5        S S S 5        [         R                  " [        SS9   UR                  S5        S S S 5        g ! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       Nd= f! , (       d  f       g = f)Nr   rD   r<   r  )rP   rQ   r   r   r   r   r   )r   r   s     r    test_stats_mixed_type,TestDataFrameAnalytics.test_stats_mixed_type  s    ]]9,?@""1% A]]9,?@""1% A]]9,FG##A& H]]9,?@##A& A@ A@@@GG@@s/   CC C03D
C
C-0
C>
Dc                     [        [        S5      [        S5      S9n[        U5      nUR                  SS9S   S:X  d   eg )Nr<   rl   rz   r@   r   )r   rM   r   rA   )r   rX   r  s      r    test_sum_bools%TestDataFrameAnalytics.test_sum_bools  s=    U1XuRy9Ryyay #r)))r#   r;   c                 `   Un[         R                  UR                  SS& [         R                  UR                  SS2SS 24'   XR4 H  nS nUSL d  US:X  a  XbL a  S O[        nSn[        R
                  " XxS	9   UR                  XCS
9n	S S S 5        Sn
[        R
                  " XzS	9   UR                  [        R                  XCS
9nS S S 5        WR                  UR                  R                  5      n[        R                  " W	U5        M     g ! , (       d  f       N= f! , (       d  f       N`= f)Nrk   rl   rd   rm   rn   Fr<   z3The behavior of DataFrame.idxmin with all-NA valuesrD   r9   zThe behavior of Series.idxmin)r'   r(   ru   FutureWarningrJ   rK   idxminrO   r   r   rG   rH   rN   r   r   r   r;   r:   rT   rX   warnr   rY   msg2r\   s               r    test_idxmin"TestDataFrameAnalytics.test_idxmin   s     66

1R!#

2b5"#:$BD$!)!tMGC++D<< = 3D++D=88FMM8L >rxx~~6H""684 %
 =< >=   8D&D
D	
D-	z3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc                     US:X  a
  [        US9nO	[        US9nUR                  X2S9n[        UR                  S9n[        R
                  " XV5        g Nr   r  r  r9   rf   )r   r	  r   rH   rJ   rN   r   rG   r;   r:   rT   rY   r\   s          r    test_idxmin_empty(TestDataFrameAnalytics.test_idxmin_empty4  K     19E*Ee,E47,
v0r#   c                     [        / SQ/ SQ[        S5      S.5      nUR                  US9nU(       a  [        SS/SS	/S
9nO[        / SQ/ SQS
9n[        R
                  " X45        g )Nr0   r   r<   r0   r<   r<   xyxr   r  r0   r<   r3   r/   r  )r0   r<   r   )r   rt   r	  r   rJ   rN   r   r   rX   rY   r\   s        r    test_idxmin_numeric_only/TestDataFrameAnalytics.test_idxmin_numeric_onlyA  X    YYT%[IJ5q!fS#J7Hi?H
v0r#   c                     UnSn[         R                  " [        US9   UR                  SS9  S S S 5        g ! , (       d  f       g = fNz)No axis named 2 for object type DataFramerD   r0   r@   )rP   rQ   rR   r	  r   r   rT   r   s       r    test_idxmin_axis_2)TestDataFrameAnalytics.test_idxmin_axis_2K  4    9]]:S1LLaL  211	   7
Ac                 `   Un[         R                  UR                  SS& [         R                  UR                  SS2SS 24'   XR4 H  nS nUSL d  US:X  a  XbL a  S O[        nSn[        R
                  " XxS	9   UR                  XCS
9n	S S S 5        Sn
[        R
                  " XzS	9   UR                  [        R                  XCS
9nS S S 5        WR                  UR                  R                  5      n[        R                  " W	U5        M     g ! , (       d  f       N= f! , (       d  f       N`= f)Nrk   rl   rd   rm   rn   Fr<   z3The behavior of DataFrame.idxmax with all-NA valuesrD   r9   zThe behavior of Series.idxmax)r'   r(   ru   r  rJ   rK   idxmaxrO   r   r   rG   rH   rN   r
  s               r    test_idxmax"TestDataFrameAnalytics.test_idxmaxQ  s    66

1R!#

2b5"#:$BD$!)!tMGC++D<< = 3D++D=88FMM8L >rxx~~6H""684 %
 =< >=r  c                     US:X  a
  [        US9nO	[        US9nUR                  X2S9n[        UR                  S9n[        R
                  " XV5        g r  )r   r&  r   rH   rJ   rN   r  s          r    test_idxmax_empty(TestDataFrameAnalytics.test_idxmax_emptyd  r  r#   c                     [        / SQ/ SQ[        S5      S.5      nUR                  US9nU(       a  [        SS/SS	/S
9nO[        / SQ/ SQS
9n[        R
                  " X45        g )Nr  r  r  r   r  r<   r   r3   r/   r  )r<   r   r<   )r   rt   r&  r   rJ   rN   r  s        r    test_idxmax_numeric_only/TestDataFrameAnalytics.test_idxmax_numeric_onlyq  r  r#   c                    [         R                  " S5        [        / SQ/ SQS.SS9nUR                  5       n[	        SS/S	S
/S9n[
        R                  " X#5        UR                  5       n[	        SS/S	S
/S9n[
        R                  " X#5        [        S	/ SQ0SS9nUR                  SS9n[	        S/S	/S9n[
        R                  " X#5        UR                  SS9n[	        S/S	/S9n[
        R                  " X#5        g )Npyarrowr  r  r  zint64[pyarrow]rf   r<   r   r3   r/   r  r0   )r/   r   r3   zstring[pyarrow]Fr  )rP   r   r   r&  r   rJ   rN   r	  rp  s       r    test_idxmax_arrow_types.TestDataFrameAnalytics.test_idxmax_arrow_types{  s    I&YY7?OP1a&c
3
v01a&c
3
v0_-5FG.1#cU+
v0.1#cU+
v0r#   c                     UnSn[         R                  " [        US9   UR                  SS9  S S S 5        g ! , (       d  f       g = fr  )rP   rQ   rR   r&  r   s       r    test_idxmax_axis_2)TestDataFrameAnalytics.test_idxmax_axis_2  r#  r$  c                 R   [        SSS9n[        / SQ[        S5      S S S2   UR                  SS9S.5      nUR	                  5       n[        / S	Q/ SQS
9n[        R                  " X45        UR                  5       n[        / SQ/ SQS
9n[        R                  " X45        [        R                  UR                  S'   UR	                  5       n[        / S	Q/ SQS
9n[        R                  " X45        UR                  5       n[        / SQ/ SQS
9n[        R                  " X45        US S S2   US'   UR                  5         UR	                  5       n[        / SQ/ SQS
9n[        R                  " X45        UR                  5       n[        / SQ/ SQS
9n[        R                  " X45        g )Nr  r   r1   )r   r0   r<   r{  T)deepr  )r<   r   r0   r  )r   r0   r   )r   r   re   )r<   r   r0   r   r   )r   r0   r<   r0   )r   r   rM   r  r&  r   rJ   rN   r	  r   rT  r>  r  r   r  rX   rY   r\   s        r    test_idxmax_mixed_dtype.TestDataFrameAnalytics.test_idxmax_mixed_dtype  sH   q1 9q$B$CHH$H<OPQ)95
v0)95
v0 vvt)95
v0)95
v0 DbD	1
!,l;
v0,l;
v0r#   zop, expected_valuer&  r	  rk   c           	          [        / SQ/ SQS.SS9nUR                  S5      n[        X15      " 5       n[        SU0[        SS	/SSS
9S9n[        R
                  " XE5        g )N)d   r<  r<     r=  r=  )r   r   r   r<   r0   r   )IDr  r  rf   r>  r  r<  r=  )namerH   r  )r   groupbyrI   r   rJ   rg  )r   r   expected_valuerX   rY   r\   s         r    !test_idxmax_idxmin_convert_dtypes8TestDataFrameAnalytics.test_idxmax_idxmin_convert_dtypes  sl     4+ 
 ZZ"n%c
W=
 	f/r#   c                 ^   [        SSS9n[        XS S S2   S.SS9n[        R                  UR                  S'   UR                  5         UR                  S	S
9n[        / SQ5      n[        R                  " X45        UR                  S	S
9n[        / SQ5      n[        R                  " X45        g )Nr  r   r1   r{  )r   re   Tr  )r   r   r<   r@   )re   r   r   )re   r   re   )r   r   r   rT  ru   r  r&  r   rJ   rN   r	  r8  s        r    "test_idxmax_dt64_multicolumn_axis19TestDataFrameAnalytics.test_idxmax_dt64_multicolumn_axis1  s    q13tt9-D9
!")$
v0")$
v0r#   r   r  	bool_onlyc                     Un[         R                  R                  S5      R                  [	        U5      5      S:  US'   [        XQ5      " X#S9  g )Nr0   g      ?_bool_r:   rG  )r'   r{   r|   r}   r&   rI   )r   rS   r:   rG  r   r  s         r    test_any_all_mixed_float/TestDataFrameAnalytics.test_any_all_mixed_float  sC    
 #))//2BB3u:NQTThD>r#   c                 $    [        X15      " USS9  g )NFrJ  r   )r   rS   r:   rx   s       r    test_any_all_bool_with_na0TestDataFrameAnalytics.test_any_all_bool_with_na  s     	"+Gr#   z4ignore:Downcasting object dtype arrays:FutureWarningc                 f  ^ UR                  S5      n[        [        U5      m[        X15      nU4S jnU4S jnU" SSS9nU" SSS9n[        R                  " XsR                  U5      5        [        R                  " XR                  USS95        U" SS9nU" SS9n[        R                  " XsR                  U5      5        [        R                  " XR                  USS9SS	9  [        R                  " [        S
S9   U" SS9  S S S 5        U[        R                  -  n	[        X5      " SS9n
[        X5      " SS9nUS:X  a/  U
R                  5       (       a   eUR                  5       (       a   eg U
R                  5       (       d   eUR                  5       (       d   eg ! , (       d  f       N= f)NTc                 H   > U R                  5       R                  nT" U5      $ r   )r%   r   r)   s     r    r!   FTestDataFrameAnalytics.test_any_all_bool_frame.<locals>.skipna_wrapper  s    88:$$Dt$$r#   c                 (   > T" U R                   5      $ r   r   r5   s    r    r6   ?TestDataFrameAnalytics.test_any_all_bool_frame.<locals>.wrapper  r8   r#   r   Fr9   r<   r@   )r=   rC   rD   r0   r   )fillnarI   r'   rJ   rN   rO   rP   rQ   rR   r(   r   r  )r   rS   rx   rT   rW   r!   r6   rZ   r[   r^   r_   r`   r+   s               @r    test_any_all_bool_frame.TestDataFrameAnalytics.test_any_all_bool_frame  sf   
 #))$/b&)E"	%	) 5)5)
wG(<=
wG!(DE))
wN(CD
[[a[8e	

 ]]:->?1I @ V$!,V$!,U?vvxx<vvxx<x6688O86688O8 @?s   >F""
F0c                    [        / SQ/ SQ/ SQS./ SQS9nUSS/   R                  S	S
9n[        / SQ/ SQS9n[        R                  " X#5        USS/   R                  S	SS9n[        R                  " X#5        UR                  S	5      n[        / SQ/ SQS9n[        R                  " X#5        UR                  S	SS9n[        R                  " X#5        UR                  S S
9R                  5       nUSL d   eUR                  S S
9R                  5       nUSL d   eUS/   R                  S S
9R                  5       nUSL d   eg )N)TFF)TTF)TTTr  r   r  r  r  r<   r@   TrJ  rG  Fr  )r   r   r   rJ   rN   r  itemrp  s       r    test_any_all_extra)TestDataFrameAnalytics.test_any_all_extra!  sA   )('
 "
 S#J###+-_E
v0S#J##d#;
v0.oF
v0T*
v0 T"'')T"'')~~SED)..0~~r#   bool_agg_funcc           	         [        S[        R                  [        R                  S/[        R                  S[        R                  S/[        R                  [        R                  [        R                  S/[        R                  [        R                  S[        R                  //S9n[        XB5      " XS9n[	        / SQ5      n[
        R                  " XV5        g )Nr<   Tr0   5datar9   )TTTT)r   r'   r(   rI   r   rJ   rN   )r   r:   r]  r;   rX   rY   r\   s          r    test_any_all_object_dtype0TestDataFrameAnalytics.test_any_all_object_dtypeB  s    
 BFFBFFD)BFFD).bff-	
 +E23
v0r#   zAignore:'any' with datetime64 dtypes is deprecated.*:FutureWarningc                 .   S[         R                  S[         R                  /n[        S5      [        S5      [        R                  [        R                  /n[        XS.5      nUR                  SS9n[        / SQ5      n[        R                  " XE5        g )Nr<   r   z
1960-02-15z
1960-02-16r  r@   )TTTF)
r'   r(   r   r   rT  r   r   r   rJ   rN   )r   
float_datadatetime_datarX   rY   r\   s         r    test_any_datetime(TestDataFrameAnalytics.test_any_datetimeT  sv    
 BFF+
l#l#FFFF	
 Z<=Q34
v0r#   c                 V   [        / SQ/ SQ/ SQS.[        / SQ[        S9S9nUR                  SS9n[	        [
        R                  / S	9n[        R                  " X#5        [        / SQ/ SQ/ SQ/ S
QS.5      nUR                  SS9n[	        SS05      n[        R                  " X#5        g )Nr  r  )NNN)col1col2col3rf   r  TrY  r  )FFT)rj  rk  rl  col4rm  F)	r   r   rs   r  r   r'   bool_rJ   rN   rp  s       r    test_any_all_bool_only-TestDataFrameAnalytics.test_any_all_bool_onlyg  s    	;MN2&A

 $'3
v0!!*,	
 $'65/*
v0r#   zfunc, data, expectedr  r  r   r   zM8[ns, UTC]r  categoryrl   rm   c                    [        U5      n[        S UR                   5       5      (       ap  [        R                  " [
        SS9   U" U5        S S S 5        [        R                  " [
        SS9   [        [        U5      UR                  5      " S S9  S S S 5        g SnUR                  R                  S 5      R                  5       (       a  [        nOS n[        R                  " XTSS9   U" U5      nS S S 5        [        W[        R                  5      (       d   eUR                  5       UL d   e[        R                  " XTS9   [        [        U5      UR                  5      " S S9nS S S 5        [        U[        R                  5      (       d   eUR                  5       UL d   eg ! , (       d  f       GNb= f! , (       d  f       g = f! , (       d  f       N= f! , (       d  f       Ny= f)	Nc              3   B   #    U  H  n[        U[        5      v   M     g 7fr   )rL   r
   )r  r   s     r    r  >TestDataFrameAnalytics.test_any_all_np_func.<locals>.<genexpr>  s     D1z!-..s   z)dtype category does not support reductionrD   r@   z0'(any|all)' with datetime64 dtypes is deprecatedc                      U R                   S:H  $ )Nr\  )kindr   s    r    r-  =TestDataFrameAnalytics.test_any_all_np_func.<locals>.<lambda>  s    166S=r#   F)rE   check_stacklevel)r   r   dtypesrP   rQ   r   rI   __name__rO   r  rJ   rK   rL   r'   rn  rZ  )r   funcra  r\   r   r  rY   s          r    test_any_all_np_func+TestDataFrameAnalytics.test_any_all_np_func  s{   j DDDD!L T
 !L 	$7TB 
 EC{{  !89==??$++DeTd U fbhh////;;=H,,, ++D< 4$--@dK = fbhh////;;=H,,,9   UT =<s0   	F*0$F<,	G$G*
F9<
G

G
G,c                     [         R                  " [        SS/S95      R                  5       nUSL d   e[         R                  " [        SS/S95      R                  5       nUSL d   eg )Nr3   r/   r  TF)r'   r  r   rZ  r   )r   rY   s     r    test_any_all_object*TestDataFrameAnalytics.test_any_all_object  sZ    	3*56;;=~~	3*56;;=r#   c                    [        SS/SS/S.5      R                  [        5      nUR                  5         [	        SS/5      US'   US   R                  S5      US'   UR                  5       nUS/   n[        R                  " X#5        UR                  SS	S
9n[	        S/S/S9n[        R                  " X#5        USS/   R                  SS	S
9n[        R                  " X#5        UR                  SS S
9(       d   eUR                  SS	S
9n[	        S/S/S9n[        R                  " X#5        US/   R                  SS	S
9n[        R                  " X#5        UR                  SS S
9(       d   eg )Nr   r0   TFr  r  rq  rN  r   )rG  r:   r  r  )r   r   rs   r  r   _get_bool_datarJ   rg  r  rN   r   )r   rX   resr\   s       r    test_any_all_object_bool_only4TestDataFrameAnalytics.test_any_all_object_bool_only  sd   eQZtUm<=DDVL
!$&3 S'..,3 !se9
c,fft!f,4&.
s- #sn  4a 8
s-vv4v000fft!f,4&.
s- #immdm3
s-vv4v000r#   c                    [        / SQ5      n[        S[        R                  S[        R                  /05      n[        / SQ5      n[        [        R                  [        R                  S/5      n[        R
                  " S 5         UR                  USS9  S H  n[        X5      " USS	9  M     S S S 5        g ! , (       d  f       g = f)
N)r   r   r   r  r   r  r<   r   )lowerr:   )ltlegtgeeqner@   )r   r'   r(   r   rJ   rK   cliprI   )r   rX   df_nanr   s_nanr   s         r    test_series_broadcasting/TestDataFrameAnalytics.test_series_broadcasting  s     'C"&&#rvv!6789*+''-KKaaK(:A. ; .--s   *B::
Cr,   )[rz  
__module____qualname____firstlineno__rP   r  parametrizeparamtd
skip_if_nor   r   r   r   r   r   r'   r(   rs   filterwarningsr   r   r  r  r!  r$  r(  r9  rA  rG  r	   r   r   r   r   rT  rh  rl  rq  r  r  r  r  r   r   rb  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-  r1  r4  r9  rB  rE  rK  rN  rV  r[  rb  rg  ro  r   r  r   r|  r  r  r  __static_attributes__r,   r#   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 [[
 ' ," 2661+2661+2661+FfU%	
. [[ RS1 T/61 [[T#PQ" R"2*"	
 [[TD%=11 21 [[TD%=11 2116*" [[V%:;"; <";H* [[ $cUu=&~XF%xj1 &&6$bffX3%@&xx@%rvvh/ 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U5n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(3RVV*<=a(266266266*BC5)Cbff+=>	
1 N1 [[\+LM[[!a(3RVV*<=a(266266266*BC5)Cbff+=>	
1 N1B(((1'* [[Xe}5[[VaV,5 - 65$ [[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,!$1L [[
QF	hA/00	0$1$ [[Xu~6[[VaV,[[[5$-8? 9 - 7? [[Xu~6[[VaV,H - 7H [[ VW[[Xu~6) 7 X)VB [[VaV,[[_uen=[[Xe}51 6 > -1 [[K11 10 [[/	
VVR/	
VVR/	
 VVc2Y&/	
 VVc2Y%	/	

 VVcE5>*E2/	
 VVcE5>*E2/	
 VVcD%=)40/	
 VVcD%=)51/	
 VVcD$<($//	
 VVcD$<($//	
 VVE7%159/	
 VVE7%159/	
 VVE5>>E/	
 VVE5>>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!-g2f!-F 1J/r#   r   c                   Z   \ rS rSrS rS rS rS r\R                  R                  SSS/5      \R                  R                  S	S
S/5      S\4S j5       5       r\R                  R                  S	S
S/5      S 5       rS rS r\R"                  S 5       r\R&                  S 5       rSrg)TestDataFrameReductionsi  c                    [        S[        R                  [        R                  [        S5      /05      nUR	                  5       n[        [        S5      /S/S9n[        R                  " X#5        UR                  5       n[        [        S5      /S/S9n[        R                  " X#5        [        S[        R                  [        R                  /05      nUR	                  5       n[        [        R                  /S/S9n[        R                  " X#5        UR                  5       n[        [        R                  /S/S9n[        R                  " X#5        g )Nr   z
2012-05-01r  )	r   r   rT  r   r   r   rJ   rN   r   )r   rX   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                    Un[        U[        5      (       a%  [        5       (       a  [        R                  " S5        [        [        SUS9[        SUS9/[        SUS9[        R                  /S.5      nUR                  SSS	9n[        UR                  S
   [        R                  /5      nUR                  US   R                  :X  d   e[        R                  " XV5        UR                  SSS	9n[        UR                  S   [        R                  /5      nUR                  US   R                  :X  d   e[        R                  " XV5        g )NzSGH#37659 OSError raised within tzlocal bc Windows chokes in times before 1970-01-01z2020-01-01 08:00:00r  z1920-02-01 09:00:00z2020-02-01 08:00:00r  r<   Fr9   )r   r3   r3   )r   r/   )rL   r   r   rP   skipr   r   r   rT  r   r   r>  rH   rJ   rN   r   )r   r  tz_naive_fixturer  rX   r  r\   s          r    'test_min_max_dt64_with_NaT_skipna_false?TestDataFrameReductions.test_min_max_dt64_with_NaT_skipna_false(  s   b'""':'<'<KK4
  3;3;   5"=rvvF
 ff!Ef*266&>26623~~C...
s-ff!Ef*266&>26623~~C...
s-r#   c                    [        S[        / 5      05      n[        [        / 5      5      nUR                  SS9R                  [
        R                  L UR                  5       [
        R                  L :X  d   eUR                  SS9R                  [
        R                  L UR                  5       [
        R                  L :X  d   e[        R                  " UR                  SS9U5        [        R                  " UR                  SS9U5        g )Nr   r   r@   r<   )
r   r   r   r   r   r   rT  r   rJ   rN   )r   rX   expected_dt_seriess      r    *test_min_max_dt64_api_consistency_with_NaTBTestDataFrameReductions.test_min_max_dt64_api_consistency_with_NaTF  s    
 [_-.#KO4A  BFF*0B0F0F0HBFF0RSSSA  BFF*0B0F0F0HBFF0RSSS 	rvv1v~/AB
rvv1v~/ABr#   c                    [        S/ 05      n[        / [        S9n[        R                  " UR                  SS9R                  5      [        R                  " UR                  5       5      :X  d   e[        R                  " UR                  SS9R                  5      [        R                  " UR                  5       5      :X  d   e[        R                  " UR                  SS9U5        [        R                  " UR                  SS9U5        g )Nr   rf   r   r@   r<   )
r   r   r   r'   r  r   r   r   rJ   rN   )r   rX   expected_float_seriess      r    *test_min_max_dt64_api_consistency_empty_dfBTestDataFrameReductions.test_min_max_dt64_api_consistency_empty_dfU  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                     [        U5      n[        U/5      n[        U/5      n[        XR5      " SS9n[        R
                  " Xd5        g )Nr<   r@   )r   r   r   rI   rJ   rN   )r   r  r   
initial_dtr\   rX   rY   s          r    test_preserve_timezone.TestDataFrameReductions.test_preserve_timezonea  sC     !)
:,'z"$!,
v0r#   c                    [        SSS9n[        [        [        R                  [        R                  U/5      [        [        R                  X3/5      S.5      n[        XA5      nU" SUS9nU(       a  [        [        R                  X3/5      nO*[        [        R                  [        R                  U/5      n[        R                  " Xg5        g )Nz
1900-01-01T)utcr  r<   r9   )r   r   r   r   rT  rI   rJ   rN   )r   r   r;   valrX   r   rY   r\   s           r    !test_minmax_tzaware_skipna_axis_19TestDataFrameReductions.test_minmax_tzaware_skipna_axis_1n  s     ,D1"&&"&&#./fbffc=O6PQ
 R 6*rvvs01Hrvvrvvs34H
v0r#   c           
      :   [        [        SS/5      [        [        SS5      [        SS5      /5      S.5      nUR                  SS9n[        SS/S	S
/S9n[        R
                  " X#5        UR                  SS9n[        SS/S9n[        R
                  " X#5        g )Nr   r   r<   ms)r3   tr@   FTr3   r  )ra  rG   r`  )r   r   r   r   rJ   rN   rp  s       r    test_frame_any_with_timedelta5TestDataFrameReductions.test_frame_any_with_timedelta}  s    QF^\!S1<43HIJ
 Qt}S#J?
v0Qt}-
v0r#   c                    US:X  a,  UR                  [        R                  R                  SS95        U" / SQ5      nSn[        R                  " [
        US9   [        XC5      " S S9  S S S 5        g ! , (       d  f       g = f)Nr   zCount does not accept skipnar  r  zAFor argument "skipna" expected type bool, received type NoneType.rD   r  )r  rP   r  r  rQ   rR   rI   )r   r  frame_or_seriesr  objr   s         r    "test_reductions_skipna_none_raises:TestDataFrameReductions.test_reductions_skipna_none_raises  sh     W$!!)G!H i(Q]]:S1C(5 211s   A11
A?c                     [        [        [        S5      /SS9[        [        S5      /SS9S.5      nUR                  5       n[        [        S5      [        S5      /SSS/S	9n[        R
                  " X#5        g )
Nz
2019-12-31zdatetime64[s]rf   z2019-12-31 00:00:00.123zdatetime64[ms]r  r3   r/   r  )r   r   r   r   rJ   rN   rp  s       r    &test_reduction_timestamp_smallest_unit>TestDataFrameReductions.test_reduction_timestamp_smallest_unit  s     Y|45_M89:BR
 |$i0I&JK"*

 	v0r#   c                 N   [        [        [        R                  " S5      /SS9[        [        R                  " S5      /SS9S.5      nUR	                  5       n[        [        R                  " S5      [        R                  " S5      /SSS/S9n[
        R                  " X#5        g )	NrM  ztimedelta64[s]rf   ztimedelta64[ms]r  r3   r/   r  )r   r   r   r  r   rJ   rN   rp  s       r    &test_reduction_timedelta_smallest_unit>TestDataFrameReductions.test_reduction_timedelta_smallest_unit  s     R\\(34<LMR\\(34<MN
 \\(#R\\(%;<#*

 	v0r#   r,   N)rz  r  r  r  r  r  r  r  rP   r  r  r   r  r  r  r  r  skip_array_manager_invalid_testr  &skip_array_manager_not_yet_implementedr  r  r,   r#   r    r  r    s    )..<C
F [[	$&AB [[Xu~61c 1 7	
1 [[Xu~61 711"
6 ''1 (1$ ..1 /1r#   r  c                       \ rS rSr\R
                  R                  SSS/5      S 5       rS r\R
                  R                  SSS/5      S	 5       r	S
r
g)TestNuisanceColumnsi  r   r   r  c                    [        SS/SSS9nUR                  5       n[        R                  " [        SS9   [        X!5      " 5         S S S 5        [        R                  " [        SS9   [        [        U5      " U5        S S S 5        [        R                  " [        SS9   [        X15      " SS	9  S S S 5        [        R                  " [        SS9   [        X15      " S S	9  S S S 5        [        R                  " [        SS9   [        [        U5      " USS
9  S S S 5        g ! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       Ny= f! , (       d  f       g = f)Nr   r<   rq  r  )rH   r?  does not support reductionrD   FrY  r@   )r   to_framerP   rQ   r   rI   r'   )r   r   serrX   s       r    .test_any_all_categorical_dtype_nuisance_columnBTestNuisanceColumns.test_any_all_categorical_dtype_nuisance_column  s    aV:C8\\^ ]]9,HIC " J ]]9,HIB$ J ]]9,HIB%0 J ]]9,HIB$/ J ]]9,HIB+ JI JI JI JI JI JIs;   D")D3!EEE&"
D03
E
E
E#&
E4c                    [        S[        / SQ5      05      nUS   n[        R                  " [        SS9   UR                  5         S S S 5        [        R                  " [        SS9   UR                  SS9  S S S 5        [        R                  " [        SS9   UR                  5         S S S 5        US   R                  [        5      US'   [        R                  " [        SS9   UR                  SS9  S S S 5        [        R                  " [        SS9   UR                  5         S S S 5        g ! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       Nt= f! , (       d  f       g = f)Nr  )r<   r0   r0   r0   r   r  rD   Fr  r  )r   r	   rP   rQ   r   r   r   r   )r   rX   r  s      r    -test_median_categorical_dtype_nuisance_columnATestNuisanceColumns.test_median_categorical_dtype_nuisance_column  s   [9:;g ]]9,HIJJL J ]]9,HIII5I) J ]]9,HIIIK J S'..%3]]9,HIII5I) J ]]9,HIIIK JI JI JI JI JI JIs;   D2)EE'E%E62
E 
E
E"%
E36
Fr   r   c                 Z   [        / SQSS9n[        U5      nUR                  S5      n[        R                  " [
        SS9   [        X15      " 5         S S S 5        [        R                  " [
        SS9   [        [        U5      " U5        S S S 5        [        R                  " [
        SS9   [        XA5      " SS9  S S S 5        [        R                  " [
        SS9   [        XA5      " 5         S S S 5        [        R                  " [
        SS9   [        [        U5      " USS	9  S S S 5        US   R                  [        5      US
'   [        R                  " [
        SS9   [        XA5      " 5         S S S 5        [        R                  " [
        SS9   [        [        U5      " USS	9  S S S 5        g ! , (       d  f       GNf= f! , (       d  f       GN@= f! , (       d  f       GN!= f! , (       d  f       GN= f! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       g = f)N)r3   r/   r   r/   F)orderedr  zis not ordered for operationrD   r  r   r@   r  )
r	   r   r  rP   rQ   r   rI   r'   r   rs   )r   r   catr  rX   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C " L ]]9,JKB$ L ]]9,JKBU3 L ]]9,JKB! L ]]9,JKB+ L S'..(3]]9,JKB! L ]]9,JKB+ LK) LK LK LK LK LK
 LK LKsT   F24G,GG(G:!HH2
G
G
G%(
G7:
H
H
H*r,   N)rz  r  r  r  rP   r  r  r  r  r  r  r,   r#   r    r  r    sW    [[Xu~6, 7,*6 [[Xu~6, 7,r#   r  c                   j   \ rS rSr\R
                  R                  SS\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4S\R                  S\R                  4/5      S 5       r\R
                  R                  SS\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4S\R                  \R                  4/5      S	 5       r\R
                  R                  SSS
S\(       a  SOS4SS
S\(       a  SOS4SS
S\(       a  SOS4SSSSS\(       a  SOS4SSS\(       a  SOS4SSSSS/5      S 5       r\R
                  R                  SSS
\(       a  SOS4SS
\(       a  SOS4SSSS\(       a  SOS4SS\(       a  SOS4SSSSS/5      S 5       rS rg!)"TestEmptyDataFrameReductionsi  z#opname, dtype, exp_value, exp_dtyperA   r   rB   r<   c                 ~    [        / / S.US9n[        XQ5      " SS9n[        X3/US9n[        R                  " Xg5        g Nr   r<   rf   r   r  r  r   rS   rH   	exp_value	exp_dtyperX   rY   r\   s           r    test_df_empty_min_count_06TestEmptyDataFrameReductions.test_df_empty_min_count_0  s@    " 2"~U3$q190	B
v0r#   zopname, dtype, exp_dtypec                     [        / / S.US9n[        XA5      " SS9n[        [        R                  [        R                  /US9n[
        R                  " XV5        g Nr  rf   r<   r  )r   rI   r   r'   r(   rJ   rN   r   rS   rH   r  rX   rY   r\   s          r    test_df_empty_min_count_16TestEmptyDataFrameReductions.test_df_empty_min_count_1)  sJ    " 2"~U3$q1266266*)<
v0r#   Int8Int32r  )rA   r  r   r  )rB   r  r<   r  UInt8UInt32UInt64)rA   r  r   r  )rB   r  r<   r  )rA   Float32r   r  )rB   r  r<   r  )rA   r  r   r  c                 ~    [        / / S.US9n[        XQ5      " SS9n[        X3/US9n[        R                  " Xg5        g r  r  r  s           r    "test_df_empty_nullable_min_count_0?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_0@  s@    $ 2"~U3$q190	B
v0r#   )rA   r  r  )rB   r  r  )rA   r  r  )rB   r  r  )rA   r  r  )rB   r  r  )rA   r  r  c                     [        / / S.US9n[        XA5      " SS9n[        [        R                  [        R                  /US9n[
        R                  " XV5        g r  )r   rI   r   r   r  rJ   rN   r  s          r    "test_df_empty_nullable_min_count_1?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_1Z  sI    " 2"~U3$q1255"%%.	:
v0r#   r,   N)rz  r  r  r  rP   r  r  r'   int8rb  int_uint8uint64uintr   r  r  r  is_windows_np2_or_is32r  is_windows_or_is32r  r  r,   r#   r    r  r    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VQ,BQ()GQ-CSWa.D((T*+,-,	
"1#"1 [["F(:WIV);gJ%&G*<h(LW+=x8M'()*)	
 1! 1r#   r  c                 l   U (       a.  [         R                  R                  SS9nUR                  U5        [        R
                  " S5      R                  [        R                  5      R                  S5      R                  SS5      nSUS'   [        U5      nUR                  UR                  :H  R                  5       (       d   eUR                  S	S
9n[        [         R"                  " SS9[         R$                  /SS9n[&        R(                  " XV5        UR                  SS	S9n[&        R(                  " XV5        UR                  SS	S9n[        [         R"                  " SS9[         R"                  " SS9[         R"                  " SS9[         R$                  /SS9n[&        R(                  " XV5        g )Nz3Incorrect type inference on NaT in reduction resultr  rR  zm8[s]re   r0   Nat)r{  r{  Fr  rI  rz  rf   r   r9   r<   rk   rS  )rP   r  r  r  r'   rc  r   rb  viewreshaper   ry  rH   r  rA   r   r   r  rT  rJ   rN   )r  r  r  r8  rX   rY   r\   s          r    !test_sum_timedelta64_skipna_falser  r  sV   {{  H ! 
 	D!
))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                      [        SS//[        S5      S9n U R                  SS05      n U R                  5       n[	        SS/SS/S9n[
        R                  " X5        g )Nr3   r<   abr  r/   r  r  )r   rt   r   rA   r   rJ   rN   )rX   rY   r\   s      r    !test_mixed_frame_with_integer_sumr    sW    	S!H:tDz	2B	C>	"BVVXFsAhsCj1H6,r#   r   )TFNr   r   r   c                 :   [         R                  " S5      n[        UR                  S UR                  /[
        R                  " 5       S9n[        SU05      n[        X@5      " US9n[        [        X 5      /S[        S/5      S9n[        R                  " XV5        g )Nrb  rf   r  r  r  )r'   iinfor   r   r   r   
Int64Dtyper   rI   r   rJ   rN   )r   r   
int64_infor  rX   rY   r\   s          r    test_minmax_extensionarrayr	    s     '"J
*..$
7r}}
OC	GS>	"BR l;F		$%WIH
 6,r#   ts_valuez
2000-01-01c                     [        S/S/S/U /S.5      n[        R                  " [        SS9   UR	                  5         S S S 5        g ! , (       d  f       g = f)Nr<   g?r   r   z5does not support (operation|reduction)|Cannot performrD   )r   rP   rQ   r   rA   )r
  rX   s     r    .test_frame_mixed_numeric_object_with_timestampr    sL     
!C5whZH	IB	P
 	
 
 
s   A
Ac                  >   [        / SQ5      n U R                  SSSS9n[        S/[        S9n[        R
                  " X5        [        R                  " S5      n[        R                  " [        US	9   U R                  SSSS9  S S S 5        g ! , (       d  f       g = f)
N)r<   r3   Tr   r<   F)r:   r  r   r3   rf   z2unsupported operand type(s) for +: 'int' and 'str'rD   )r   rB   r   rs   rJ   rN   r   escaperP   rQ   r   rA   )rX   rY   r\   r   s       r    $test_prod_sum_min_count_mixed_objectr    sw    	>	"BWW!quW=Fse6*H6,
))H
IC	y	,
A7 
-	,	,s   3B
B)r   r   r   r   r   r   rH   r  r  c                    [        [        R                  R                  S5      R	                  S5      US9n[        X05      " S US9nUR                  [        R                  S9nU S;   aF  [        R                  " S5      nU S:X  a  Sn [        X`5      " US	S S
9n[        R                  " XG5        g [        [        U 5      " US S9nXG:X  d   eg )Nr0   )re   re   rf   r   >   r   r   r   r   r   F)r   r:   r@   )r   r'   r{   r|   r}   rI   to_numpyr  rP   r   rJ   r3  )r   r   rH   rX   rY   np_arrcomp_modr\   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#   kernel)corrcorrwithcovr&  r	  r   r   r   r   r   rB   quantiler   r   r   rA   r   c                 "   [        / SQ[        S.5      nU S:X  a  U4OSnSR                  / SQ5      nU S:X  a  SnS	nSR                  XE/5      n[        R                  " [
        US
9   [        X5      " U6   S S S 5        g ! , (       d  f       g = f)Nr  r  r  r,   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 numberr   zTCannot convert \[\[<class 'object'> <class 'object'> <class 'object'>\]\] to numericzPCannot convert \[<class 'object'> <class 'object'> <class 'object'>\] to numericrD   )r   rs   r   rP   rQ   r   rI   )r  rX   argsr   msg1r  s         r    test_fails_on_non_numericr    s    0 
0	1Bj(B5bD
((	
C / 	
- 	 hh|$	y	,T" 
-	,	,s   (B  
B)r  r   r   r&  r	  r   r   r   r   r   r   r   rB   r   r   r   r   rA   r   r  r0   c           	         [        [        / SQUS9[        SS[        R                  S/US9S.5      n[        / SQSS	[        R
                  S
/S.5      nU S;   a  SnO*U S;   a  SnO!U S;   a  UR                  S5      (       d  SnOUn0 nU S;  a  XS'   U S;   a  X'S'   S nS n	U(       d  U S;   a  [        nSU  S3n	[        R                  " XS9   [        X@5      " SSS0UD6n
S S S 5        [        R                  " XS9   [        XP5      " SSS0UD6nS S S 5        U S;  a  WR                  U5      n[        R                  " W
W5        g ! , (       d  f       Nm= f! , (       d  f       NN= f)NrV  rf   r   r<   r   r  )r   r   r   r   r   r   r   r   rb  )r  r   boolean)r   r   r   r   r   r   r   r   Floatr  )r   r   r  r;   )rB   r   rA   r  )r&  r	  zThe behavior of DataFrame.z with all-NA valuesrD   r:   r,   )r   r   r   r  r'   r(   
startswithr  rJ   rK   rI   r   rN   )r   r;   r  any_numeric_ea_dtyperX   expected_dfr  r  r  r   rY   r\   s               r    test_numeric_ea_axis_1r$    s|   6 
,@AAruua(0DE	

B %sBFFC(	
K %% 	>	!"	 	 	
 #--g66"-F55!x++'{D
Cf 44*6(2EF		#	#D	4$6!6v6 
5		#	#D	4;/AQA&A 
5))??>268, 
5	4	4	4s   E
?E

E
E)r   )TTFgh㈵>g:0yE>N)?datetimer   decimalr   r   dateutil.tzr   numpyr'   rP   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_testingrJ   pandas.corer   r   r  r  r-   rb   fixturerx   r~   r   r  r  r  r  r  r  r  r	  rT  r  r  r  r  r$  r,   r#   r    <module>r3     sU     	    / ) )      
 ./F4FSt8 (*6$h H 		k1\  (  "m/ m/`)l1 l1^O, O,d^1 ^1B-D- )<=E5>2- 3 >- i&=rvv%FG H
8 #ST$79i"89" : 8 U"$ ,#-,#8 0 q!f-1- .121-r#   