
    MhP-                       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  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,S2S
 jr-      S3S jr.\	R^                  S 5       r0\	R^                  S 5       r1 " S S5      r2 " S S5      r3 " S S5      r4 " S S5      r5S r6\	Rn                  Rq                  \" 5       SS9S 5       r9\	Rn                  Ru                  S/ SQ5      \	Rn                  Ru                  SSS /5      S! 5       5       r;\	Rn                  Ru                  S"\" S#5      \Rx                  /5      S$ 5       r=S% r>\	Rn                  Ru                  S/ S&Q5      \	Rn                  Ru                  SSS/5      \	Rn                  Ru                  S'S(S)/5      S* 5       5       5       r?\	Rn                  Ru                  S+/ S,Q5      S- 5       r@\	Rn                  Ru                  S/ S.Q5      \	Rn                  Ru                  S/S S0/5      S1 5       5       rAg)4    )	timedelta)DecimalN)tzlocal)using_pyarrow_string_dtype)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    T/var/www/html/env/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#   D   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matchrC   indexdtype)getattrr   r   tmassert_produces_warning
isinstancer   ranger'   r.   assert_series_equalapplyr   rI   pytestraises
ValueErrorr(   r)   rH   )opnamer,   frame
has_skipnar>   check_datesr?   r@   r    fdfresultr7   r"   result0result1expected	lcd_dtypeall_nar0r1units    `                    r!   assert_stat_op_calcrc   M   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
)      rI   r   rA      foo_ABCD)rH   columnsrI      
   re      N)r   r(   concatenateonesboolzerosr   rN   objectlistr)   ilocirY   s     r!   bool_frame_with_nary      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
r1   )rh   rf   rh   ri   rg   rj   rH   rk   rl   rm   re   rn   ro   N)r   r(   randomdefault_rngstandard_normalr   rN   rt   ru   r)   rv   rw   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\R
                  R-                  \" 5       S.S/9S0 5       rS1 r\R
                  R                  S2S3S4/5      S5 5       r\R
                  R                  S2S3S4/5      S6 5       rS7 rS8 r\R
                  R                  S9/ S:Q5      S; 5       rS< r\R
                  R                  S=S>S?/S@/SA/SB/\ " SB/SB/SC9\!" SD/SES(9\"" SF/5      SG.4SHS?/S@/\R"                  /\RF                  " \R"                  /\S(9\ " \R"                  /SB/SC9\!" \$RJ                  /SES(9\"" \$RJ                  /5      SG.4S>SISJ\R"                  \R"                  /SISJ\R"                  \R"                  /S\R"                  \R"                  \R"                  /\ " SB\R"                  \R"                  \R"                  /SB/SC9\!" / SKQSES(9\"" / SLQ5      / SMQSN.4SHSISJ\R"                  \R"                  /SISJ\R"                  \R"                  /S\R"                  \R"                  \R"                  /\ " \R"                  SB\R"                  \R"                  /SB/SC9\!" / SOQSES(9\"" / SPQ5      / SMQSN.4/5      SQ 5       r&SR r'SS r(ST r)SU r*\R
                  R                  SVSWSX\$RJ                  SY/S&\$RJ                  /-  /5      SZ 5       r+S[ r,\R
                  R                  S\\-" S5      \!" / 5      \." / \R^                  S(9\." / \R`                  S(9\!" / S]S^9\1" / S_S^9/5      S` 5       r2\R
                  R                  SaSbSc/5      \R
                  R                  Sd/ SeQ5      Sf 5       5       r3Sg r4Sh r5\R
                  R                  Si/ SjQ5      \R
                  R                  SkSS$Sl.SmSn\R"                  /4SS%Sl.\R"                  \R"                  \R"                  /4SSHSo.SmSn\R"                  /4/5      Sp 5       5       r6\R
                  R                  Si/ SjQ5      \R
                  R                  SkSS$Sl.SqSr\R"                  /4SS%Sl.\R"                  \R"                  \R"                  /4SSHSo.SqSr\R"                  /4/5      Ss 5       5       r7St r8Su r9Sv r:Sw r;Sx r<Sy r=Sz r>S{ r?S| r@\R
                  R                  S}S>SH/5      \R
                  R                  SSS/5      S~ 5       5       rA\R
                  R                  SSS/5      \R
                  R'                  S5      S 5       5       rB\R
                  R                  SdS>SH/5      S 5       rCS rD\R
                  R                  S}S>SH/5      \R
                  R                  SSS/5      S 5       5       rE\R
                  R                  SSS/5      \R
                  R'                  S5      S 5       5       rF\R
                  R                  SdS>SH/5      S 5       rGS rHS rIS rJ\R
                  R                  SSSS&/4SSS/4/5      S 5       rKS rL\R
                  R                  SSS/5      \R
                  R                  SSS/5      \R
                  R                  SSHS>/5      S 5       5       5       rM\R
                  R                  SSS/5      \R
                  R                  SSS/5      S 5       5       rN\R
                  R'                  S5      \R
                  R                  SSS/5      S 5       5       rOS rP\R
                  R                  SSS/5      \R
                  R                  SSS/5      \R
                  R                  S}S>SH/5      S 5       5       5       rQ\R
                  R'                  S5      S 5       rRS rS\R
                  R                  S/ \R                  0 SH4P\R                  0 S>4P\R                  S/ 0SH4P\R                  S/ 0S>4P\R                  SSHSH/0SH4P\R                  SSHSH/0SH4P\R                  SS>SH/0S>4P\R                  SS>SH/0SH4P\R                  SS>S>/0S>4P\R                  SS>S>/0S>4P\R                  SH/SH/S.SH4P\R                  SH/SH/S.SH4P\R                  SHSH/SHS>/S.S>4P\R                  SHSH/SHS>/S.SH4P\R                  S\V" SSA/SS(90SH4P\R                  S\V" SSA/SS(90S>4P\R                  S\V" SS/\WS(90SH4P\R                  S\V" SS/\WS(90S>4P\R                  " \R                  S\V" SS/SES(90SH5      P\R                  " \R                  S\V" SS/SS(90SH5      P\R                  " \R                  S\V" SS/SES(90S>5      P\R                  " \R                  S\V" SS/SS(90S>5      P\R                  " \R                  S\V" SS$/SES(90S>5      P\R                  " \R                  S\V" SS$/SS(90S>5      P\R                  " \R                  S\V" SS$/SES(90S>5      P\R                  " \R                  S\V" SS$/SS(90S>5      P\R                  " \R                  S\V" SS/SS(90SH5      P\R                  " \R                  S\V" SS/SS(90S>5      P\R                  " \R                  S\V" SS$/SS(90S>5      P\R                  " \R                  S\V" SS$/SS(90S>5      P\R                  S\V" SS/SS(90S>4P\R                  S\V" SS/SS(90SH4P\R                  S\V" SS$/SS(90S>4P\R                  S\V" SS$/SS(90SH4P\R                  " \R                  \V" SS/SES(9\V" SS/SS(9S.S>5      P5      S 5       rXS rYS rZS r[Sr\g3)TestDataFrameAnalytics   r;   r   r=   rT   countrB   meanproductmedianminmaxnuniquevarstdsemskewscipy)markskurtc                 N   US;   a  US:X  d  US;   a  U(       a  US:X  d  [        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)rB   r   r   r   r   r   rB   rA   )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'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   z1Cannot convert \[.*\] to numeric|does not support)flagsz|does not supportrE   r   Tr;   numeric_only)
rJ   joinrecompileSrM   PatternrQ   rR   	TypeError)selffloat_string_framer;   rT   using_infer_stringmsgs         r!   #test_stat_op_api_float_string_frame:TestDataFrameAnalytics.test_stat_op_api_float_string_frame   s0   . ,,
 &&E/&/T:>>@9$19NCLC5P6!19((DMC UC>)T8#jjHPRPTPT c2::..//y4*3> 5Y&/TM  54s   &D
D$c                 $    [        X5      " USS9  g )NFr   rJ   )r   float_framer;   rT   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   rB   ss    r!   r   7TestDataFrameAnalytics.test_stat_op_calc.<locals>.count<  s    8<<>!r$   c                 \    [        [        R                  " U R                  5       5      5      $ r   )r'   r   unique1dr&   r   s    r!   r   9TestDataFrameAnalytics.test_stat_op_calc.<locals>.nunique?  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>.varB      66!!$$r$   c                 ,    [         R                  " U SS9$ r   )r(   r   r   s    r!   r   5TestDataFrameAnalytics.test_stat_op_calc.<locals>.stdE  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>.semH  s$    66!!$rwws1v66r$   r   FT)rV   r>   rW   rB   float32gMbP?)r>   r?   )r    r   rW   r   r   r   r   r   )rc   r(   rB   astypenansumr   rC   nanprod)r   r   mixed_float_framer   r   r   r   r   s           r!   test_stat_op_calc(TestDataFrameAnalytics.test_stat_op_calc;  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>.skewnessv  s*    1vzvv===//r$   c                 b   > [        U 5      S:  a  [        R                  $ TR                  U SS9$ )Nrf   Fr   )r'   r(   r)   kurtosisr   s    r!   r   DTestDataFrameAnalytics.test_stat_op_calc_skew_kurtosis.<locals>.kurt{  s-    1vzvv$$QU$33r$   r   r   )rQ   importorskiprc   )r   r   r   r   r   s       @r!   test_stat_op_calc_skew_kurtosis6TestDataFrameAnalytics.test_stat_op_calc_skew_kurtosiss  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!   r7   3TestDataFrameAnalytics.test_median.<locals>.wrapper  s(    Aw{{}}vv99Q<r$   r   Tr   F)r>   rW   )rc   )r   r   	int_framer7   s       r!   test_median"TestDataFrameAnalytics.test_median  s'    	 
 	HgPTUge	
r$   method)rB   r   rC   r   r   r   r   r   rY   )gȃw@Ba@gCVZg
?Z.F?)r   r           )g94c4?g@}jX?gNr4   r0   cfoobarbazOrG   r1   r   rf   r   r=   r1   rg   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 )NrA   f8)r=   rk   r   )
r   rI   r(   object_rJ   r   rt   r   rK   rO   )r   r   rY   r;   rZ   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         SR                  / SQ5      n[        R                  " [        US9   [        X!5      " 5         S S S 5        S S S 5        g ! , (       d  f       Nt= f! , (       d  f       N(= f! , (       d  f       g = f)
Nr=   r1   r   rf   )      ?       @      @      @r4   r0   r   d)intfloatstrr   )zCould not convertcould not convertz"can't multiply sequence by non-intzdoes not supportrE   use_bottleneckF)r   r   rQ   rR   r   rJ   pdoption_context)r   r   rY   r   s       r!   test_mixed_ops%TestDataFrameAnalytics.test_mixed_ops  s     #-+
 hh
 ]]9C0BO 1 /7((C y4! 5 87 10 54 87s0   C2-C#C0C#
C
C 	C##
C1z"sum doesn't work for arrow stringsreasonc                 @   [        / 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)rm   rn   rh   (   2   )r4   r0   r   r   e)	bool_dataint_datastring_datark   r   rA   )r1      abcderg   r=   )r   reindexrB   rK   assert_numpy_array_equalr   r(   arrayrt   TrO   )r   rY   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=   r1   r   r=   r   ABCr1   Fr&   rA   r   )r;   r&   )r   r(   r)   rK   rO   r   r   r   rY   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  r1   r  r  r   r  r  rH   r   r   r   r   rK   rO   r   r  rY   rZ   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   r1   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)Nr1   z628.00r  r=   z383.00r   z651.00z575.00rf   z1114.00TESTz241.00z572.00z609.00z820.00rl   z1223.00z)unsupported operand type|does not supportrE   r  r  g@gL@rG   )
r   r   rQ   rR   r   r   r   rt   rK   rO   )r   r   rY   rZ   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\]]H
 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)Nrf   r   c                      U R                  SS9$ Nrf   r   )r   r   s    r!   <lambda>5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>"      !%%Q%-r$   c                      U R                  SS9$ r0  )r   r   s    r!   r1  r2  &  r3  r$   r1   r=     r6  r   rA   r   F)r   rP   rK   assert_almost_equalr   r(   repeatr|   r}   r   nanvarr   r   r   r   datetime_framerZ   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)Nr1   )rl   r   r   r  r   100)r   r   r4   r=   Tr   r   r   rA   z6unsupported operand type\(s\) for -: 'float' and 'str'rE   Fz&could not convert string to float: 'a')r   r(   r|   r}   r~   r   rt   locrJ   rK   rO   rQ   rR   r   )r   r?  df1df2rZ   r]   r   s          r!   test_numeric_only_flag-TestDataFrameAnalytics.test_numeric_only_flag1  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)Nrf   r   c                 `    U R                  SS9[        R                  " [        U 5      5      -  $ r0  )r   r(   r   r'   r   s    r!   r1  1TestDataFrameAnalytics.test_sem.<locals>.<lambda>X  s    !%%Q%-"''#a&/2Qr$   r1   r5  r6  r   rA   r   F)r   rP   rK   r7  r(   r8  r|   r}   r   nansemr   r   r   r:  s        r!   test_semTestDataFrameAnalytics.test_semV  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   r4   )
categories
2000-01-02M8[ns]1 days)r  r  r  DEFGF   	   )rO  NaTrX  rX  rQ  r)   r)   r)   r   r=   r1   r   )HIJKLMNrX  rO  rX  rX  )r)   rQ  r)   r)   c                 F   [        / SQSS[        R                  S/S[        R                  [        R                  [        R                  /[        [        R                  [        R                  S[        R                  /[        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)rM  rM        rm   r   r=   r4   rg   rb  rP  rY  )rV  rV  rW  rW  )rW  rW  rV  rV  )rO  rO  rX  rX  )rQ  r)   rQ  r)   rf   int64)r  r  r  rR  rS  rT  rU  r[  r\  r]  r^  r_  r`  ra  r  )r   r(   r)   r   rt   r
   r   r   arangesortedkeysmoderK   assert_frame_equal)r   r&   r]   rY   rZ   s        r!   test_mode_dropna'TestDataFrameAnalytics.test_mode_dropnac  s%   t %"bffa(0RVVRVVS"&&9H "&&"&&#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(       a  S O[        n[        R
                  " U5         UR                  SS9nUR                  SS9R                  SS9nS S S 5        [        R                  " WU5        g ! , (       d  f       N&= f)Nr  r4   Fr  )byT)drop)
r   r(   r)   UserWarningrK   rL   rj  sort_valuesreset_indexrk  )r   r   rY   r]   warningrZ   s         r!   test_mode_sortwarning,TestDataFrameAnalytics.test_mode_sortwarning  s     bffbffc3789cC=12,$+''0WWEW*F''3'/;;;FF 1 	fh/	 10s   0,B<<
C
c           	          [        / SS/S9nUR                  5       n[        / SS/[        / [        R                  S9S9n[
        R                  " X#5        g )Nr4   r0   r  rg   rk   rH   )r   rj  r   r(   rf  rK   rk  r   rY   rZ   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   rR  r3   freqz2012-1-220120101rl   )minutessecondsr  r  r  r  r!  r   )r   r  r=   )r   r  rA   )r1   r  )r1   r  r   r   rS  20130101rT  i1  r  )daysr"  Tr   )r=   r=   r   r   20130102r2   20130105)timetime2r  r  off1timedelta64[ns]off2)r   r   r   r   r   rv   rB  allr   absrK   rk  copyr   r   	Timedeltark   rO   rI   _consolidate_inplace)r   rY   diffsrZ   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 Dayrm   r2   r!  Tr  )ro   r  Fr<   r  r  r  rG   r=   r:   r   rV  )
r   timedelta_ranger   rX  rv   r   r   rK   rO   r  )r   tdirY   rZ   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   rX  .0values     r!   	<genexpr>FTestDataFrameAnalytics.test_std_datetime64_with_nat.<locals>.<genexpr>9  s     B6%rvvo6    z=GH#51446: Incorrect type inference on NaT in reduction resultr   r4   r  c              3   D   #    U  H  o[         R                  L v   M     g 7fr   r  r  s     r!   r  r  B  s     A&bff_&r  ztimedelta64[]rg   l     "R: )r  rQ   markxfailapplymarkerr   as_unitr   r   r   r   rX  rK   rO   )r   r   r<   using_array_managerrequestrb   r  dtirY   rZ   r]   s              r!   test_std_datetime64_with_nat3TestDataFrameAnalytics.test_std_datetime64_with_nat1  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   rB   rM   r   r'   )r   empty_frameaxis0axis1s       r!   test_sum_corner&TestDataFrameAnalytics.test_sum_cornerI  sk    k""%((((%((((5zQ5zQr$   rH   ME)r~  rR  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 )Nr4   rx  r=   rA   )r   r  rr   r   rf  rt   rG   r   rJ   r   rK   rO   )r   all_reductionsrH   rY   rZ   expected_dtyper]   s          r!   test_axis_1_empty(TestDataFrameAnalytics.test_axis_1_emptyS  sZ     uE2,!4^+#Nw&$N%N"E@
v0r$   zmethod, unit)rB   r   )rC   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   float64rG   r=   )r   	min_countr"  r   rm   rl   r!  r  r     )r   r(   r)   rJ   r   rK   rO   rv   )r   r   rb   r   idxrY   rZ   r]   s           r!   test_sum_prod_nanops+TestDataFrameAnalytics.test_sum_prod_nanopsj  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]rI   rH   r  r=   )	r   r(   r)   rP   r   rB   r   rK   rO   )r   r  rY   rD  rZ   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  rf   rl   r  )r   yrm   r  r   r  r"  )r   rB   r   r(   r)   rK   rO   ry  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@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   gffffff@皙@g@r   r4   r0   rg   r-   )r   r(   r)   rB   r   r   rK   rO   r   r  kwargsexpected_resultrY   rZ   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  rg   r-   )r   r(   r)   rC   r   r   rK   rO   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 )Nr{   r=   )r   r   r   r   rH   rk   r   rB   )r   r   r   rU   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(   isnanrB   )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  rf   r2   r   r!  )r1   r   rf   z does not support reduction 'sum'rE   )r   r   r	  rQ   rR   r   rB   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)	Nz"Could not convert|does not supportrE   r   rA   unsupported operand typer=   r  rr   )rQ   rR   r   r   r   )r   r   r   r   meanss        r!   test_mean_corner'TestDataFrameAnalytics.test_mean_corner  s    2]]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-01r2   1D2016Yr}  )r  r  r  rR  Tr  r  r   z'mean is not implemented for PeriodArrayrE   )r   r(   rg  r   r   r  period_ranger   r   rK   rO   rQ   rR   r   ry  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  r2   r  r  Fr  r=   )r=   r  )r=   r  r  r  r}  rR  z"mean is not implemented for PeriodrE   )r   r(   rg  r   r   r  r   r   rB  rK   rO   r  rQ   rR   r   ry  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 )
Nr1   r6  )rm   rl   )sizeInt64rg   Tr  Float64)	r(   r|   r}   integersr   r   r   rK   rO   )r   r<  rY   rZ   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   rE   r=   r  )rQ   rR   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=   rm   r{   rA   r   )r   rN   r   rB   )r   rY   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)Nrl   rm   re   rn   ro   Fr=   z3The behavior of DataFrame.idxmin with all-NA valuesrE   r:   zThe behavior of Series.idxmin)r(   r)   rv   FutureWarningrK   rL   idxminrP   r   r   rH   rI   rO   r   r   r   r<   r;   rU   rY   warnr   rZ   msg2r]   s               r!   test_idxmin"TestDataFrameAnalytics.test_idxmin/       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  r:   rg   )r   r
  r   rI   rK   rO   r   rH   r<   r;   rU   rZ   r]   s          r!   test_idxmin_empty(TestDataFrameAnalytics.test_idxmin_emptyC  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r1   r   r=   r1   r=   r=   xyxr   r  r1   r=   r4   r0   r"  )r1   r=   r   )r   ru   r
  r   rK   rO   r   r   rY   rZ   r]   s        r!   test_idxmin_numeric_only/TestDataFrameAnalytics.test_idxmin_numeric_onlyP  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 DataFramerE   r1   rA   )rQ   rR   rS   r
  r   r   rU   r   s       r!   test_idxmin_axis_2)TestDataFrameAnalytics.test_idxmin_axis_2Z  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)Nrl   rm   re   rn   ro   Fr=   z3The behavior of DataFrame.idxmax with all-NA valuesrE   r:   zThe behavior of Series.idxmax)r(   r)   rv   r	  rK   rL   idxmaxrP   r   r   rH   rI   rO   r  s               r!   test_idxmax"TestDataFrameAnalytics.test_idxmax`  r  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   rI   rK   rO   r  s          r!   test_idxmax_empty(TestDataFrameAnalytics.test_idxmax_emptyt  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   r4   r0   r"  )r=   r   r=   )r   ru   r(  r   rK   rO   r  s        r!   test_idxmax_numeric_only/TestDataFrameAnalytics.test_idxmax_numeric_only  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]rg   r=   r   r4   r0   r"  r1   )r0   r   r4   zstring[pyarrow]Fr  )rQ   r   r   r(  r   rK   rO   r
  ry  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!  )rQ   rR   rS   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   r2   )r   r1   r=   r  T)deepr  )r=   r   r1   r"  )r   r1   r   )r   r   rf   )r=   r   r1   r   r   )r   r1   r=   r1   )r   r   rN   r  r(  r   rK   rO   r
  r   rX  rB  r  r   r  rY   rZ   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
  rl   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=   r1   r   )IDr  r  rg   r@  r  r>  r?  )namerI   r"  )r   groupbyrJ   r   rK   rk  )r   r   expected_valuerY   rZ   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   r2   r  )r   rf   Tr  )r   r   r=   rA   )rf   r   r   )rf   r   rf   )r   r   r   rX  rv   r  r(  r   rK   rO   r
  r:  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 )Nr1   g      ?_bool_r;   rI  )r(   r|   r}   r~   r'   rJ   )r   rT   r;   rI  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 )NFrL  r   )r   rT   r;   ry   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   r6   s    r!   r7   ?TestDataFrameAnalytics.test_any_all_bool_frame.<locals>.wrapper  r9   r$   r   Fr:   r=   rA   )r>   rD   rE   r1   r   )fillnarJ   r(   rK   rO   rP   rQ   rR   rS   r)   r   r  )r   rT   ry   rU   rX   r"   r7   r[   r\   r_   r`   ra   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=   rA   TrL  rI  Fr  )r   r   r   rK   rO   r  itemry  s       r!   test_any_all_extra)TestDataFrameAnalytics.test_any_all_extra1  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U(       a!  US:X  + =(       a    U(       + =(       a    US:H  nOSn[        XR5      " XS9n[	        SSUS/5      n[
        R                  " Xx5        g )	Nr=   Tr1   5datar   r  r:   )r   r(   r)   rJ   r   rK   rO   )	r   r;   r_  r<   r   rY   valrZ   r]   s	            r!   test_any_all_object_dtype0TestDataFrameAnalytics.test_any_all_object_dtypeR  s     BFFBFFD)BFFD).bff-	
 a-IJI=E3ICC+E4sD12
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!  rA   )TTTF)
r(   r)   r   r   rX  r   r   r   rK   rO   )r   
float_datadatetime_datarY   rZ   r]   s         r!   test_any_datetime(TestDataFrameAnalytics.test_any_datetimek  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col3rg   r  Tr[  r  )FFT)rm  rn  ro  col4rp  F)	r   r   rt   r  r   r(   bool_rK   rO   ry  s       r!   test_any_all_bool_only-TestDataFrameAnalytics.test_any_all_bool_only~  s    	;MN2&A

 $'3
v0!!*,	
 $'65/*
v0r$   zfunc, data, expectedr  r!  r   r   zM8[ns, UTC]r  categoryrm   rn   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   )rM   r   )r  r   s     r!   r  >TestDataFrameAnalytics.test_any_all_np_func.<locals>.<genexpr>  s     D1z!-..s   z)dtype category does not support reductionrE   rA   z0'(any|all)' with datetime64 dtypes is deprecatedc                      U R                   S:H  $ )Nr`  )kindr   s    r!   r1  =TestDataFrameAnalytics.test_any_all_np_func.<locals>.<lambda>  s    166S=r$   F)rF   check_stacklevel)r   r   dtypesrQ   rR   r   rJ   __name__rP   r	  rK   rL   rM   r(   rq  r\  )r   funcrc  r]   r   r  rZ   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 )Nr4   r0   r  TF)r(   r  r   r\  r   )r   rZ   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   r1   TFr!  r  rt  rR  r   )rI  r;   r"  r  )r   r   rt   r  r   _get_bool_datarK   rk  r  rO   r   )r   rY   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nerA   )r   r(   r)   r   rK   rL   cliprJ   )r   rY   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-   )]r}  
__module____qualname____firstlineno__rQ   r  parametrizeparamtd
skip_if_nor   r   r   r   r   r   r(   r)   rt   filterwarningsr   r   r  r   r  r  r%  r(  r,  r=  rE  rK  r
   r   r   r  r   rX  rl  ru  rz  r  r  r  r  r   r   rf  r  r   r  r  r  r  r  r  r  r  r  r  r  r  r   r  r  r  r  r  r#  r)  r,  r/  r3  r6  r;  rD  rG  rM  rP  rX  r]  re  rj  rr  r   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\ [[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"@ [["$-Q  **"	
 [[TD%=11 21 [[TD%=11 2116*" [[V%:;"; <";H* [[ $cUu=&~XF%xj1 &&266(&9$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 [[^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! [[Xe}5[[VaV,5 - 6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   rX  r   r   r   rK   rO   r   )r   rY   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=   Fr:   )r   r4   r4   )r   r0   )rM   r   r   rQ   skipr   r   r   rX  r   r   rB  rI   rK   rO   r   )r   r  tz_naive_fixturer  rY   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   rA   r=   )
r   r   r   r   r   r   rX  r   rK   rO   )r   rY   expected_dt_seriess      r!   *test_min_max_dt64_api_consistency_with_NaTBTestDataFrameReductions.test_min_max_dt64_api_consistency_with_NaT]  s    
 [_-.#KO4A  BFF*0B0F0F0HBFF0RSSSA  BFF*0B0F0F0HBFF0RSSS 	rvv1v~/AB
rvv1v~/ABr$   c                    [        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   rg   r   rA   r=   )
r   r   r   r(   r  r   r   r   rK   rO   )r   rY   expected_float_seriess      r!   *test_min_max_dt64_api_consistency_empty_dfBTestDataFrameReductions.test_min_max_dt64_api_consistency_empty_dfl  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=   rA   )r   r   r   rJ   rK   rO   )r   r  r   
initial_dtr]   rY   rZ   s          r!   test_preserve_timezone.TestDataFrameReductions.test_preserve_timezonex  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=   r:   )r   r   r   r   rX  rJ   rK   rO   )r   r   r<   rd  rY   r   rZ   r]   s           r!   !test_minmax_tzaware_skipna_axis_19TestDataFrameReductions.test_minmax_tzaware_skipna_axis_1  s     ,D1"&&"&&#./fbffc=O6PQ
 R 6*rvvs01Hrvvrvvs34H
v0r$   c           
      :   [        [        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)r4   trA   FTr4   r  )rc  rH   rb  )r   r   r   r   rK   rO   ry  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.rE   r  )r  rQ   r  r  rR   rS   rJ   )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]rg   z2019-12-31 00:00:00.123zdatetime64[ms]r  r4   r0   r  )r   r   r   r   rK   rO   ry  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 )	NrQ  ztimedelta64[s]rg   ztimedelta64[ms]r  r4   r0   r  )r   r   r   r  r   rK   rO   ry  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)r}  r  r  r  r  r  r  r  rQ   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=   rt  r  )rI   rA  does not support reductionrE   Fr[  rA   )r   to_framerQ   rR   r   rJ   r(   )r   r   serrY   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=   r1   r1   r1   r   r  rE   Fr  r  )r   r
   rQ   rR   r   r   r   r   )r   rY   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)r4   r0   r   r0   F)orderedr  zis not ordered for operationrE   r  r   rA   r  )
r
   r   r  rQ   rR   r   rJ   r(   r   rt   )r   r   catr  rY   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)r}  r  r  r  rQ   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_dtyperB   r   rC   r=   c                 ~    [        / / S.US9n[        XQ5      " SS9n[        X3/US9n[        R                  " Xg5        g Nr   r=   rg   r   r  r  r   rT   rI   	exp_value	exp_dtyperY   rZ   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  rg   r=   r  )r   rJ   r   r(   r)   rK   rO   r   rT   rI   r  rY   rZ   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  )rB   r  r   r  )rC   r  r=   r  UInt8UInt32UInt64)rB   r  r   r  )rC   r  r=   r  )rB   Float32r   r  )rC   r  r=   r  )rB   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_0W  s@    $ 2"~U3$q190	B
v0r$   )rB   r  r  )rC   r  r  )rB   r  r  )rC   r  r  )rB   r  r  )rC   r  r  )rB   r  r  c                     [        / / S.US9n[        XA5      " SS9n[        [        R                  [        R                  /US9n[
        R                  " XV5        g r  )r   rJ   r   r   NArK   rO   r  s          r!   "test_df_empty_nullable_min_count_1?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_1q  sI    " 2"~U3$q1255"%%.	:
v0r$   r-   N)r}  r  r  r  rQ   r  r  r(   int8rf  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   rV  zm8[s]rf   r1   Nat)r  r  Fr  rM  r  rg   r   r:   r=   rl   rW  )rQ   r  r  r  r(   rg  r   rf  viewreshaper   r|  rI   r  rB   r   r   r  rX  rK   rO   )r  r  r  r<  rY   rZ   r]   s          r!   !test_sum_timedelta64_skipna_falser    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$   z#sum doesn't work with arrow stringsr   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 )Nr4   r=   abr  r0   r  r"  )r   ru   r   rB   r   rK   rO   )rY   rZ   r]   s      r!   !test_mixed_frame_with_integer_sumr    sY    
 
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 )Nrf  rg   r  r  r  )r(   iinfor   r   r   r   
Int64Dtyper   rJ   r   rK   rO   )r   r   
int64_infor  rY   rZ   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   r  rE   )r   rQ   rR   r   rB   )r  rY   s     r!   .test_frame_mixed_numeric_object_with_timestampr    sD     
!C5whZH	IB	y(D	E
 
F	E	Es   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=   r4   Tr   r=   F)r;   r  r   r4   rg   z2unsupported operand type(s) for +: 'int' and 'str'rE   )r   rC   r   rt   rK   rO   r   escaperQ   rR   r   rB   )rY   rZ   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   rI   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 )Nr1   )rf   rf   rg   r   >   r   r   r   r   r   F)r   r;   rA   )r   r(   r|   r}   r~   rJ   to_numpyr  rQ   r   rK   r7  )r   r   rI   rY   rZ   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   rC   quantiler   r   r   rB   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 numericrE   )r   rt   r   rQ   rR   r   rJ   )r  rY   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   rC   r   r   r   r   rB   r   r  r1   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)NrZ  rg   r   r=   r   r  )r   r   r   r   r   r   r   r   rf  )r  r   boolean)r   r   r   r   r   r   r   r   Floatr  )r   r   r  r<   )rC   r   rB   r  )r(  r
  zThe behavior of DataFrame.z with all-NA valuesrE   r;   r-   )r   r   r   r  r(   r)   
startswithr	  rK   rL   rJ   r   rO   )r   r<   r  any_numeric_ea_dtyperY   expected_dfr  r  r  r   rZ   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)Bdatetimer   decimalr   r   dateutil.tzr   numpyr(   rQ   pandas._configr   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_testingrK   pandas.corer   r   r  r  r.   rc   fixturery   r   r   r  r  r  r  r  r  r  r  r  rX  r  r  r  r   r'  r-   r$   r!   <module>r7     s     	    5 / ) )      
 ./F4FSt8 (*6$h H 		k1\  (  "B/ B/J*l1 l1^O, O,d^1 ^1B-D  )N  -- )<=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$   