
    Mh8                     X    S SK rS SKrS SKrS SKJrJrJrJrJ	r	  S SK
Jr   " S S5      rg)    N)Categorical	DataFrameSeries	Timestamp
date_rangec                       \ rS rSrS rS rS rS rS rS r	S r
S	 rS
 rS rS rS rS r\R$                  R'                  SSSSS/SS//5      S 5       rS rS rS rSrg)TestDataFrameDescribe   c                 B   [        / SQ/ SQ/ SQS.5      nUR                  5       n[        SSSUR                  R                  5       SS	SS
S/0/ SQS9n[        R
                  " X#5        UR                  S/S9n[        S/ SQ0/ SQS9n[        R
                  " X#5        g )N)abcde)TTFFF
         (   2   )string_data	bool_dataint_datar      r   r   r   r   r   countmeanstdmin25%50%75%maxindexboolincluder   )r      F   r   uniquetopfreq)r   describer   r   tmassert_frame_equalselfdfresultexpecteds       Z/var/www/html/env/lib/python3.13/site-packages/pandas/tests/frame/methods/test_describe.py!test_describe_bool_in_mixed_frame7TestDataFrameDescribe.test_describe_bool_in_mixed_frame   s    8>0
 !R!2BBBGHM
 	f/ fX.*+3U
 	f/    c                 @   [        SS S /0[        S9nUR                  5       n[        SSS[        R                  [        R                  /0[        / SQS9n[
        R                  " X#5        UR                  S S R                  5       n[
        R                  " X#5        g )NAdtyper   r+   )r>   r%   )r   objectr/   npnanr0   r1   ilocr2   s       r7   test_describe_empty_object0TestDataFrameDescribe.test_describe_empty_object*   s    dD\*&91a()4

 	f/!%%'
f/r:   c                    [        / SQ/ SQS.5      nUR                  5       n[        / SQ/ SQS./ SQS9n[        R                  " X#5        [        / SQ/ S	QS
.5      nUR                  5       n[        SSSUR                  R                  5       SSSSS/0/ SQS9n[        R                  " X#5        [        / SQ/ SQS.5      nUR                  5       n[        / SQ/ SQS./ SQS9n[        R                  " X#5        g )N)FFTT)FTTT)bool_data_1bool_data_2)   r)   Fr)   )rH   r)   Tr*   r+   r$   )FFTTF)r      r)   r*   rH   )r   r   r   r   r)   r   rI   r*   rH   r   )r   r   r   r   )r   str_data)rH   r*   r   r)   )r   r/   r0   r1   r   r   r2   s       r7   test_describe_bool_frame.TestDataFrameDescribe.test_describe_bool_frame8   s    98
 ,_M4
 	f/>+
 !Q 11aAqABM
 	f/4BVW
 *G4
 	f/r:   c                 &   [        S[        R                  R                  S5      R	                  SSS5      05      n[        SSS5       Vs/ s H  o" SUS-    3PM     nn[        X35      nUR                  S/S	S
9n[        R                  " UR                  [        SSS5      SUS9US'   UnUR                  5       n[        UR                  5      S:X  d   e[        / SQ/ SQS	S9n[        U5      nUR                  5       n[        / SQ/ SQS9n[        R                   " Xh5        [        [        / SQ5      5      n[        U/ SQS.5      n	U	R                  5       n[        R"                  " US   R$                  US   R$                  5        g s  snf )Nvaluer)   r   i'  d   i  z - i  T)by	ascendingi)  F)rightlabelsvalue_grouprI   )r   r   r   r   r   r   r   )
categoriesordered)rH   r)   r   r*   r+   r$   )r   r   r   r   )catsrX   rY   )r   r@   randomdefault_rngintegersranger   sort_valuespdcutrN   r/   lencolumnsr   r0   assert_series_equalassert_numpy_array_equalvalues)
r3   r4   irS   
cat_labelsrX   r5   rY   r6   df3s
             r7   test_describe_categorical/TestDataFrameDescribe.test_describe_categorical^   sf   !6!6q!9!B!B1eS!QRS.3Auc.BC.BCs1s7)$.BC 0
^^yD^9FFHHeAuc*%

=  6>>"a'''
  _d
 3K.0RS
v0[!567*>?@
##F5M$8$8&+:L:LM7 Ds   Fc                    [        S[        / 5      05      nUR                  5       n[        SSS[        R                  [        R                  /0/ SQSS9n[
        R                  " X#5        [        R                  " UR                  S   5      (       d   e[        R                  " UR                  S   5      (       d   eg )N	empty_colr   r+   r?   r%   r>   )r)   r   )r*   r   )	r   r   r/   r@   rA   r0   r1   isnanrB   r2   s       r7   &test_describe_empty_categorical_column<TestDataFrameDescribe.test_describe_empty_categorical_column}   s     [_561a014

 	f/xxD)****xxD)****r:   c                    [         R                  " / SQSSS9n[        / SQ/ SQ/ SQS.US9nUR                  5       n[         R                  " SS	// SQSSS
9n[        SSUR                  R                  5       SSSSS/SSUR                  R                  5       SSSSS/S./ SQUS9n[        R                  " X55        [        R                  " UR                  R                  UR                  R                  5        g )N)int1int2objTXXX)rW   namer   r<   r   NXrI   )rb   rr   rs   )rV   rW   rv   r   r   r   r   r   r   )rr   rs   r   )r%   rb   )r_   CategoricalIndexr   r/   rr   r   rs   r0   r1   assert_categorical_equalrb   re   r3   rb   r4   r5   exp_columnsr6   s         r7   !test_describe_categorical_columns7TestDataFrameDescribe.test_describe_categorical_columns   s    %%&=tRWX,,-
 
 ))V.	
 Br2r2rBBr2r2rB N
 	f/
##FNN$9$98;K;K;R;RSr:   c                 H   [         R                  " / SQSSSS9n[        / SQ/ SQ/ SQS.5      nXl        UR	                  5       n[         R                  " S	S
/SSSS9n[        SSUR
                  S S 2S4   R                  5       SSSSS/SSUR
                  S S 2S4   R                  5       SSSSS/S./ SQS9nXEl        [        R                  " X55        UR                  R                  S:X  d   eUR                  R                  UR                  R                  :X  d   eg )N)
2011-01-01
2011-02-01z
2011-03-01MSz
US/Easternru   )r.   tzrv   r   rw   )r   rI   r)   r   r   r   r   r   r   r   r   r   rI   )r   rI   r   r$   )r_   DatetimeIndexr   rb   r/   rB   r   r0   r1   r.   r   r{   s         r7   test_describe_datetime_columns4TestDataFrameDescribe.test_describe_datetime_columns   s#   ""6	
 '')
 
&&<(t5
 r2771a4=,,.BBCr2771a4=,,.BBC N
 '
f/~~""d***~~  H$4$4$7$7777r:   c                    [         R                  " SSSS9n[         R                  " SSSS9n[        XS.5      n[        S[         R                  " S5      UR                  S S 2S	4   R                  5       [         R                  " S5      [         R                  " S
5      [         R                  " S5      [         R                  " S5      [         R                  " S5      /S[         R                  " S5      UR                  S S 2S4   R                  5       [         R                  " S5      [         R                  " S5      [         R                  " S5      [         R                  " S5      [         R                  " S5      /S./ SQS9nUR                  5       n[        R                  " XT5        Sn[        U5      U:X  d   eg )Nz1 daysDr   )r.   periodsz1 hoursh)t1t2z3 daysr   z2 daysz4 daysz5 daysz3 hoursrI   z2 hoursz4 hoursz5 hoursr   r$   a                                t1                         t2
count                          5                          5
mean             3 days 00:00:00            0 days 03:00:00
std    1 days 13:56:50.394919273  0 days 01:34:52.099788303
min              1 days 00:00:00            0 days 01:00:00
25%              2 days 00:00:00            0 days 02:00:00
50%              3 days 00:00:00            0 days 03:00:00
75%              4 days 00:00:00            0 days 04:00:00
max              5 days 00:00:00            0 days 05:00:00)
r_   timedelta_ranger   	TimedeltarB   r   r/   r0   r1   repr)r3   r   r   r4   r6   r5   exp_reprs          r7   test_describe_timedelta_values4TestDataFrameDescribe.test_describe_timedelta_values   sZ   sA>	Q?b+, LL*GGAqDM%%'LL*LL*LL*LL*LL*	 LL+GGAqDM%%'LL+LL+LL+LL+LL+	, N/
4 
f/J 	 F|x'''r:   c                    Un[        [        S5      5      n[        SSS5      n[        SSS5      n[        [        XEUS95      n[	        X6S.5      n[	        / SQS[        SSS5      R                  U5      UR                  U5      US   US   US   UR                  U5      [        R                  /S./ S	QS
9nUR                  SS9n	[        R                  " X5        g )Nr     rI   r   s1s2)r   r)   r   rI   r)   r*   rH   gvhXL?r*   r)   r   r   r   r    r!   r"   r#   r   r$   allr'   )r   r]   r   r   r   tz_localizer@   rA   r/   r0   r1   )
r3   tz_naive_fixturer   r   startendr   r4   r6   r5   s
             r7   test_describe_tz_values-TestDataFrameDescribe.test_describe_tz_values   s    E!H$1%a#Jub12b+,5dAq)55b9%%b)qEqEqEOOB'FF	 N
  U+
f/r:   c                 :   [        [        SSS9/ SQS.5      nUR                  5       n[        S[        S5      [        S5      [        S5      [        S5      [        S	5      [        S
5      [        R
                  // SQS./ SQS9n[        R                  " X#5        g )N2012r*   )r   rI   r)   r*   r   r   z
2012-01-02z
2012-01-01z2012-01-01T12:00:00z2012-01-02T12:00:00z
2012-01-03)r*   r)   rI         ?r)         @r*   rI   r   r$   )r   r   r/   r   r@   rA   r0   r1   r2   s       r7   *test_datetime_is_numeric_includes_datetime@TestDataFrameDescribe.test_datetime_is_numeric_includes_datetime  s    Z:KL l+l+34l+34l+FF	 2 N
  	f/r:   c                    Sn[        [        S5      5      n[        SSS5      n[        SSS5      n[        [        X4US95      n[	        X%S.5      nUR                  5       nUR                  5       n/ SQn	[        R                  " Xx/SSS	/S
9R                  U	SS9n
UR                  SS9n[        R                  " X5        g )NCETr   r   rI   r   r   r   r   r   )axiskeysF)copyr   r'   )r   r]   r   r   r   r/   r_   concatreindexr0   r1   )r3   r   r   r   r   r   r4   s1_s2_idxr6   r5   s               r7   test_describe_tz_values2.TestDataFrameDescribe.test_describe_tz_values2-  s    E!H$1%a#Jub12b+,kkmkkm	
 99cZatTlCKKe L 
 U+
f/r:   c                     [        SS/05      n[        R                  " SSS5      nUR                  US9n[        SSS[        R                  S/S U 5       QSP0/ SQS	9n[
        R                  " X45        g )
NxrI   r      )percentiles      ?c              3   &   #    U  H  nS v   M	     g7f)r   N ).0_s     r7   	<genexpr>NTestDataFrameDescribe.test_describe_percentiles_integer_idx.<locals>.<genexpr>O  s     +=ACs   )r   r   r   r   z0%z10%z20%z30%z40%r!   z60%z70%z80%z90%z100%r#   r$   )r   r@   linspacer/   rA   r0   r1   )r3   r4   pctr5   r6   s        r7   %test_describe_percentiles_integer_idx;TestDataFrameDescribe.test_describe_percentiles_integer_idxH  sx    aSz"kk!Q'-3RVVSC+=+=CsCD
* 	f/r:   c                     [        SSS00SSS00/5      n[        SSSSS0S/0/ SQS9nUR                  5       n[        R                  " X25        g )	Ntestr   12r)   rI   r+   r$   )r   r/   r0   r1   )r3   r4   r6   r5   s       r7   8test_describe_does_not_raise_error_for_dictlike_elementsNTestDataFrameDescribe.test_describe_does_not_raise_error_for_dictlike_elementse  s`    #s,vSz.BCDaS#J*+3U
 
f/r:   excluder   yzc                     [        S/S/S/S.5      nSn[        R                  " [        US9   UR	                  SUS9  S	S	S	5        g	! , (       d  f       g	= f)
zE
When include is 'all', then setting exclude != None is not allowed.
rI   r)   r*   )r   r   r   z*exclude must be None when include is 'all')matchr   r(   r   N)r   pytestraises
ValueErrorr/   )r3   r   r4   msgs       r7   2test_describe_when_include_all_exclude_not_allowedHTestDataFrameDescribe.test_describe_when_include_all_exclude_not_allowedn  sJ    
 aSs!56:]]:S1KKwK7 211s   A
Ac                    [        / SQ/ SQ/ SQ// SQSS9nUR                  5       nUR                  S S 2S4   R                  5       n[        R                  " X3U/UR
                  SS	9n[        R                  " X$5        g )
N)rI   rI   rI   )r)   r)   r)   )r*   r*   r*   )barr   r   float64)rb   r>   r   rI   )r   r   )r   r/   rB   r_   r   rb   r0   r1   )r3   r4   r5   serr6   s        r7   $test_describe_with_duplicate_columns:TestDataFrameDescribe.test_describe_with_duplicate_columnsx  sk    	9-%

 ggadm$$&99c_2::AF
f/r:   c                 @   [        S[        R                  [        R                  /[        R                  S.US9nUR                  5       n[        SS[        R                  /S/S-  -   S/[        R                  /S-  -   S./ SQS	S
9n[        R
                  " X45        g )NrI   r   r=   r   r   g           r   Float64rm   )r   r_   NAr/   r0   r1   )r3   any_numeric_ea_dtyper4   r5   r6   s        r7   test_ea_with_na%TestDataFrameDescribe.test_ea_with_na  s     a.RUU;CWXRUU#seai/seruugk6IJM

 	f/r:   c                    [         R                  " S5      n[        [        / SQ[        R
                  " UR                  5       5      S9[        / SQ[        R
                  " UR                  5       5      S9[        / SQ[        R
                  " UR                  5       5      S9S.5      nUR                  [        R
                  " UR                  5       5      [        R
                  " UR                  5       5      S9n[        S/ SQ0/ SQ[        R
                  " UR                  5       5      S	9n[        R                  " X45        g )
Npyarrowr   r=   rU   r   r   )r*   r)   rI   rI   r   r)   r   r*   r   rm   )r   importorskipr   r   r_   
ArrowDtypeint8int16int32r/   r   r0   r1   )r3   par4   r5   r6   s        r7   test_describe_exclude_pa_dtype4TestDataFrameDescribe.test_describe_exclude_pa_dtype  s      +IR]]2779-EFIR]]288:-FGIR]]288:-FG
 MM"''),bmmBHHJ6O  
 ./M--

-

 	f/r:   r   N)__name__
__module____qualname____firstlineno__r8   rC   rK   ri   ro   r}   r   r   r   r   r   r   r   r   markparametrizer   r   r   r   __static_attributes__r   r:   r7   r	   r	      s    040$0LN>+ T>8@.(`080*060:0 [[YcC:Sz(JK8 L8	0
00r:   r	   )numpyr@   r   pandasr_   r   r   r   r   r   pandas._testing_testingr0   r	   r   r:   r7   <module>r      s)        R0 R0r:   