ó
    ­œ‘hôJ  ã                   ó0  • S SK r S SKrS SKrS SKJ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KJr   " S S5      r\R&                  R)                  S/ SQ5      S	 5       r\R&                  R)                  S
/ SQ5      \R&                  R)                  SSS\R,                  /5      \R&                  R)                  SS/SS//5      S 5       5       5       r\R&                  R1                  S5      \R&                  R)                  S\\\\/5      S 5       5       rg)é    N)Úlib)Ú	DataFrameÚIndexÚSeriesÚ	TimestampÚ
date_range)Úget_groupby_method_argsc                   óî  • \ rS rSr\R
                  S 5       r\R                  R                  SSS/5      S 5       r	\R                  R                  SSS/5      S	 5       r
\R                  R                  SS
S/5      S 5       r\R                  R                  SSS/5      S 5       r\R                  R                  SSS/5      S 5       r\R                  R                  SSS/5      S 5       rS rSrg)ÚTestNumericOnlyé   c                 ó   • [        / SQ/ SQ/ SQ[        / SQSS9[        / SQ[        S9[        [        S5      5      R	                  S5      / S	Q[        S
SS9[        S
SSS9[        R                  " SSSS9S.
/ SQS9nU$ )N)é   r   é   )r   r   é   )g      @g      @ç      @)ÚaÚbÚcÚstr©ÚdtypeÚabcÚcategory)é   é   é	   Ú20130101r   )Úperiodsú
US/Eastern)r   Útzz1 sÚs)r   Úfreq)
ÚgroupÚintÚfloatÚstringÚobjectÚcategory_stringÚcategory_intÚdatetimeÚ
datetimetzÚ	timedelta©Úcolumns)r   r   r'   ÚlistÚastyper   ÚpdÚtimedelta_range)ÚselfÚdfs     ÚjC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/groupby/test_numeric_only.pyr4   ÚTestNumericOnly.df   s~   € ô â"Ú Ú(Ü ¢¸Ñ>Ü ¢¼Ñ?Ü#)¬$¨u«+Ó#6×#=Ñ#=¸jÓ#IÚ )Ü& z¸1Ñ=Ü(¨¸QÀ<ÑPÜ×/Ò/°¸qÀsÑKñòñ
ˆð4 ˆ	ó    ÚmethodÚmeanÚmedianc                 óÎ  • [        / SQ5      nUR                  S5      n[        SS/SS/[        R                  " S5      [        R                  " S5      /S	S
/[        S5      [        S5      /[        SSS9[        SSS9/S.[        SS/SS9/ SQS9n[        XB5      " SS9n[        R                  " UR                  U5      U5        UR                  nU R                  XXs5        g )N©r$   r%   r)   r#   g      @r   g      @r   z1.5sÚ3sg      ø?r   z2013-01-01 12:00:00z2013-01-03 00:00:00r   )r    )r)   r%   r,   r$   r*   r+   r   r   )Úname)Úindexr.   T©Únumeric_only)r   Úgroupbyr   r1   Ú	Timedeltar   ÚgetattrÚtmÚassert_frame_equalÚreindex_liker.   Ú_check)r3   r4   r8   Úexpected_columns_numericÚgbÚexpectedÚresultÚexpected_columnss           r5   Útest_averagesÚTestNumericOnly.test_averages7   sì   € ô $)Ò)IÓ#JÐ à�Z‰Z˜Ó ˆÜà!$ a Ø˜s˜Ü Ÿlšl¨6Ó2´B·L²LÀÓ4FÐGØ˜Q�xäÐ3Ó4ÜÐ3Ó4ðô
 Ð3¸ÑEÜÐ3¸ÑEðñô ˜˜A˜ WÑ-òñ!
ˆô. ˜Ô$°$Ñ7ˆÜ
×Ò˜f×1Ñ1°(Ó;¸XÔFà#×+Ñ+Ðà�‰�BÐ 0ÕKr7   ÚminÚmaxc                 óF   • [        / SQ5      nUnU R                  XX45        g )N)r$   r%   r&   r)   r*   r+   r,   ©r   rH   ©r3   r4   r8   rM   rI   s        r5   Útest_extremaÚTestNumericOnly.test_extrema[   s+   € ô
 !òó

Ðð $4Ð à�‰�BÐ 0ÕKr7   ÚfirstÚlastc                 óF   • [        / SQ5      nUnU R                  XX45        g )N)	r$   r%   r&   r'   r(   r)   r*   r+   r,   rS   rT   s        r5   Útest_first_lastÚTestNumericOnly.test_first_lasto   s)   € ä ò
ó
Ðð $4Ð à�‰�BÐ 0ÕKr7   ÚsumÚcumsumc                 ó‚   • [        / SQ5      n[        / SQ5      nUS:X  a  [        / SQ5      nU R                  XXC5        g )Nr<   )r$   r%   r&   r)   r,   r]   )r$   r%   r)   r,   rS   )r3   r4   r8   rI   rM   s        r5   Útest_sum_cumsumÚTestNumericOnly.test_sum_cumsum‚   sA   € ä#(Ò)IÓ#JÐ Ü ÚCó
Ðð �XÓä$Ò%RÓSÐà�‰�BÐ 0ÕKr7   ÚprodÚcumprodc                 óF   • [        / SQ5      nUnU R                  XX45        g )Nr<   rS   rT   s        r5   Útest_prod_cumprodÚ!TestNumericOnly.test_prod_cumprodŽ   s#   € ä Ò!AÓBÐØ#3Ð à�‰�BÐ 0ÕKr7   ÚcumminÚcummaxc                 óF   • [        / SQ5      nUnU R                  XX45        g )N)r$   r%   r)   r*   r+   r,   rS   rT   s        r5   Útest_cummin_cummaxÚ"TestNumericOnly.test_cummin_cummax•   s)   € ô !ÚSó
Ðð
 $4Ð à�‰�BÐ 0ÕKr7   c                 ór  • UR                  S5      nUR                  S5      (       a  [        [        4O[        nUS;   ad  SR	                  SSU S3[
        R                  " SU S	35      S
SU S3/5      n[        R                  " XgS9   [        XR5      " 5         S S S 5        O®US;   aw  SR	                  S[
        R                  " SU S	35      [
        R                  " SU S35      SU S3/5      n[        R                  " XgS9   [        XR5      " 5         S S S 5        O1[        XR5      " 5       n[        R                  " UR                  U5        US;  a}  SR	                  SSS
SU S3[
        R                  " SU S	35      [
        R                  " SU S35      SU S3/5      n[        R                  " XgS9   [        XR5      " SS9  S S S 5        g [        XR5      " SS9n[        R                  " UR                  U5        g ! , (       d  f       NÂ= f! , (       d  f       NÓ= f! , (       d  f       g = f)Nr#   Úcum)rP   rQ   rf   rg   r]   rb   Ú|zCategorical is not orderedzCannot perform z with non-ordered Categoricalúagg function failed [how->ú,dtype->object]ú*function is not implemented for this dtypez(dtype 'str' does not support operation 'Ú'©Úmatch)r\   r9   r:   ra   z-category type does not support sum operationsz,dtype->string]©rW   rX   zcategory type does not supportFr@   )rB   Ú
startswithÚNotImplementedErrorÚ	TypeErrorÚjoinÚreÚescapeÚpytestÚraisesrD   rE   Úassert_index_equalr.   )	r3   r4   r8   rM   rI   rJ   Ú	exceptionÚmsgrL   s	            r5   rH   ÚTestNumericOnly._check¡   s  € Ø�Z‰Z˜Ó ˆð
 17×0AÑ0AÀ%×0HÑ0HÔ ¤)Ñ,Ìið 	ð ÐLÓLà—(‘(à0Ø% f XÐ-JÐKÜ—I’IÐ :¸6¸(À/ÐRÓSà@Ø>¸v¸hÀaÐHðó	ˆCô —’˜yÓ4Ü˜Ô#Ô%÷ 5Ð4àÐ8Ó8Ø—(‘(àCÜ—I’IÐ :¸6¸(À/ÐRÓSÜ—I’IÐ :¸6¸(À/ÐRÓSØ>¸v¸hÀaÐHð	óˆCô —’˜yÓ4Ü˜Ô#Ô%÷ 5Ð4ô ˜RÔ(Ó*ˆFÜ×!Ò! &§.¡.Ð2JÔKàÐ*Ó*Ø—(‘(à0Ø4Ø@Ø% f XÐ-JÐKÜ—I’IÐ :¸6¸(À/ÐRÓSÜ—I’IÐ :¸6¸(À/ÐRÓSØ>¸v¸hÀaÐHðó
ˆCô —’˜yÓ4Ü˜Ô#°Ò7÷ 5Ð4ô ˜RÔ(°eÑ<ˆFÜ×!Ò! &§.¡.Ð2BÕC÷C 5Õ4ú÷ 5Õ4ú÷$ 5Õ4ús$   Â
HÄHÆ<H(È
HÈ
H%È(
H6© N)Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__r{   Úfixturer4   ÚmarkÚparametrizerN   rU   rZ   r_   rd   ri   rH   Ú__static_attributes__r�   r7   r5   r   r      s(  † ð ‡^�^ñó ðð> ‡[�[×Ñ˜X¨°Ð'9Ó:ñ!Ló ;ð!LðF ‡[�[×Ñ˜X¨¨u ~Ó6ñLó 7ðLð& ‡[�[×Ñ˜X¨°Ð'8Ó9ñLó :ðLð$ ‡[�[×Ñ˜X¨¨xÐ'8Ó9ñ	Ló :ð	Lð ‡[�[×Ñ˜X¨°	Ð':Ó;ñLó <ðLð ‡[�[×Ñ˜X¨°(Ð';Ó<ñ	Ló =ð	Lõ6Dr7   r   rA   )TFNc                 ó°  • US;   a  [         R                  " S5        US;   a.  SnU R                  [         R                  R	                  US95        [        [        R                  R                  S5      R                  S5      / SQS	9nS
US'   / SQnUR                  U5      n[        Xq5      n[        X5      n	SS0n
Ub  X*S'   SnSnSU S3nUb…  X;   a€  SnUS;   aM  [         R                  " [        US9   [        R                   " ["        US9   U" U	0 U
D6  S S S 5        S S S 5        g [         R                  " [        US9   U" U	0 U
D6  S S S 5        g X;  a-  Sn[         R                  " [        US9   U" U	0 U
D6  S S S 5        g Ub  U(       d¤  US;  až  SnU(       a3  [         R$                  " S5      n[        UR&                  R(                  4nO[        n[         R                  " USSR+                  U5       S3S9   [        R                   " ["        US9   U" U	0 U
D6  S S S 5        S S S 5        g [        R                   " ["        US9   U" U	0 U
D6nS S S 5        U(       a  UR-                  SS	9R.                  OUR.                  n[        UU5      " U	6 R.                  nUS:X  a  U(       d  UR1                  [2        5      n[        R4                  " WU5        g ! , (       d  f       GNÌ= f! , (       d  f       g = f! , (       d  f       g = f! , (       d  f       g = f! , (       d  f       GN= f! , (       d  f       g = f! , (       d  f       Nõ= f)N)ÚidxmaxÚidxminz5idxmax and idx_min tested in test_idxmin_idxmax_axis1)ÚcorrwithÚskewzDGH#47723 groupby.corrwith and skew do not correctly implement axis=1)Úreasonr   )é
   é   )ÚAÚBÚCÚDr-   ÚxÚE)
r   r   r   r   r   r   r   r   r   r‘   Úaxisr   rA   )rb   r]   ÚdiffÚfillnaÚ
pct_changeÚrankÚshift)rb   r]   r™   r›   rœ   r�   rg   rf   rŒ   r‹   rš   zDataFrameGroupBy.z with axis=1 is deprecatedú1got an unexpected keyword argument 'numeric_only')rb   r]   rr   z)got an unexpected keyword argument 'axis')rš   r�   )z"not supported between instances ofz2can't multiply sequence by non-int of type 'float'úunsupported operand typezhas no kernelzBoperation 'sub' not supported for dtype 'str' with dtype 'float64'ÚpyarrowÚ(rm   Ú)r�   )r{   ÚskipÚapplymarkerr‡   Úxfailr   ÚnpÚrandomÚdefault_rngÚstandard_normalrB   rD   r	   r|   rw   rE   Úassert_produces_warningÚFutureWarningÚimportorskipr   ÚArrowNotImplementedErrorrx   ÚdropÚTr0   r%   Úassert_equal)ÚrequestÚgroupby_funcrA   Úusing_infer_stringr   r4   ÚgroupsrJ   r8   ÚargsÚkwargsÚno_argsÚhas_axisÚwarn_msgÚmsgsÚpaÚerrsrL   Údf_expectedrK   s                       r5   Útest_axis1_numeric_onlyr¾   Ú   sÞ  € àÐ+Ó+Ü�ŠÐKÔLØÐ+Ó+ØTˆØ×ÑœFŸK™K×-Ñ-°SÐ-Ð9Ô:ä	Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9ÒCWñ
€Bð €B€s�GÚ+€FØ	�‰�FÓ	€BÜ�RÓ&€FÜ" <Ó4€DØ�aˆ[€FØÑà!-ˆ~Ñð U€Gð€Hð # < .Ð0JÐK€HØÑ LÓ$;ØAˆØÐ0Ó0Ü—’œy°Ó4Ü×/Ò/´ÀXÓNÙ˜DÐ+ FÒ+÷ O÷ 5Ð4ô —’œy°Ó4Ù˜Ð' Ò'÷ 5Ð4à	Ó	%Ø9ˆÜ�]Š]œ9¨CÓ0Ù�DÐ#˜FÒ#÷ 1Ð0ð Ñ
¦l¸ð Mó 9ð	
ˆö Ü×$Ò$ YÓ/ˆBä˜rŸv™v×>Ñ>Ð?‰DäˆDÜ�]Š]˜4¨¨3¯8©8°D«>Ð*:¸!Ð'<Ó=Ü×+Ò+¬MÀÓJÙ˜Ð' Ò'÷ K÷ >Ð=ô ×'Ò'¬¸XÓFÙ˜TÐ, VÑ,ˆF÷ Gö 1=�b—g‘g c�gÐ*×,Ò,À"Ç$Á$ˆÜ˜;¨Ô5°tÐ<×>Ñ>ˆØ˜7Ó"®<ð  —‘¤uÓ-ˆHä
�Š˜ Õ)÷Y OÖNú÷ 5Õ4ú÷ 5Õ4ú÷ 1Õ0ú÷0 KÖJú÷ >Õ=ú÷ GÕFúsl   Ã7K1Ä	KÄK1Å	LÅ6	LÈL6È	L$È%L6É	MË
K.	Ë)K1Ë1
K?Ì
LÌ
L!Ì$
L3	Ì.L6Ì6
MÍ
Mzkernel, has_arg))ÚallF)ÚanyF)ÚbfillF)ÚcorrT)r�   T)ÚcovT)rg   T)rf   T)rb   T)r]   T)r™   F)ÚffillF)rš   F)rW   T)r‹   T)rŒ   T)rX   T)rQ   T)r9   T)r:   T)rP   T)ÚnthF)ÚnuniqueF)r›   F)ra   T)ÚquantileT)ÚsemT)rŽ   T)ÚstdT)r\   T)ÚvarTTFÚkeysÚa1Úa2c                 ó¼  • [        SS/SS/SS/S[        /-  S.5      n[        X5      nU[        R                  L a  0 OSU0nUR                  U5      n[        Xp5      nU(       a   USL a  U" U0 UD6n	SU	R                  ;  d   eg U S	;   d  U S
;   a[  U[        R                  L aH  U S:X  a  [        OS n
Sn[        R                  " X«S9   U" U0 UD6n	S S S 5        SW	R                  ;   d   eg U(       a˜  USLd   eU R                  S5      (       a  [        O[        nSR                  SSSSS[        R                   " SU  S35      /5      nU S:X  a  SnOU S:X  a  SnOU S:X  a  Sn["        R$                  " XËS9   U" U0 UD6  S S S 5        g U(       d>  U[        R                  La+  ["        R$                  " [        SS9   U" U0 UD6  S S S 5        g U S;   d   eU[        R                  L d   e["        R$                  " [        SS9   U" U0 UD6  S S S 5        g ! , (       d  f       GNN= f! , (       d  f       g = f! , (       d  f       g = f! , (       d  f       g = f)Nr   r   é   é   )rÌ   rÍ   Úa3r   rA   Tr   rt   )rÀ   r¿   rÁ   rÄ   rš   rÅ   rÆ   rš   ú%DataFrameGroupBy.fillna is deprecatedrr   rl   rm   znot allowed for this dtypez+cannot be performed against 'object' dtypeszmust be a string or a.* numberrŸ   rp   rn   ro   rÇ   ú4dtype 'object' does not support operation 'quantile'rŒ   z8'<' not supported between instances of 'type' and 'type'r‹   z8'>' not supported between instances of 'type' and 'type'rž   )r™   r›   )r   r'   r	   r   Ú
no_defaultrB   rD   r.   r«   rE   rª   ru   rv   rw   rx   ry   rz   r{   r|   )ÚkernelÚhas_argrA   rË   r4   rµ   r¶   rJ   r8   rL   Úwarnr   r~   s                r5   Útest_numeric_onlyrØ   3  sO  € ôT 
˜1˜a˜&¨¨A¨°q¸!°fÀ1ÌÀxÁ<ÑPÓ	Q€Bä" 6Ó.€DØ¤3§>¡>Ò1‰R¸ÈÐ7U€Fà	�‰�DÓ	€BÜ�RÓ €FÞ�< 4Ò'á˜Ð( Ñ(ˆØ˜&Ÿ.™.Ó(Ð(Ñ(ð 	Ð#Ó#ð ÐRÓRØ¤§¡Ò.ð !'¨(Ó 2�}¸ˆØ5ˆÜ×'Ò'¨Ó8Ù˜TÐ, VÑ,ˆF÷ 9à�f—n‘nÓ$Ð$Ñ$Þ	Ø 4Ò'Ð'Ð'ð
 ,2×+<Ñ+<¸U×+CÑ+CÕ'Ìˆ	à�h‰hà,Ø=à0Ø*Ø<Ü—	’	Ð6°v°h¸oÐNÓOðó

ˆð �ZÓØH‰CØ�xÓØL‰CØ�xÓØLˆCÜ�]Š]˜9Ó0Ù�DÐ#˜FÒ#÷ 1Ð0æ˜¬S¯^©^Ò;Ü�]Š]ÜÐPó
ñ �DÐ#˜FÒ#÷
ð 
ð
 Ð/Ó/Ð/Ð/ØœsŸ~™~Ò-Ð-Ð-ä�]Š]œ9Ð,GÓHÙ�DÐ#˜FÒ#÷ IÐH÷O 9Ö8ú÷8 1Õ0ú÷
õ 
ú÷ IÕHús0   Ã		HÅ:	H+Æ?	H<È	IÈ
H(È+
H9È<
I
É
Iz4ignore:Downcasting object dtype arrays:FutureWarningr   c                 óê  • / SQn[        / SQU S9nUR                  U5      nUS:X  a  [        XQ5      (       a   eg [        XQ5      n[        / SQ5      nUR                  U5      n[        X�5      n	[	        X5      n
SnSnX;   ai  U [
        L a`  US:X  a  SnOS	nUS
:X  a  [        OS nSn[        R                  " XïS9   [        R                  " [        US9   U" U
6   S S S 5        S S S 5        OŽU [
        L a…  US
:X  a  [        OS nSn[        R                  " XïS9   U" U
6 nS S S 5        [        R                  " XïS9   U	" U
6 nS S S 5        X;   a  WR                  [
        5      n[        R                  " WW5        SnUU;  a-  Sn[        R                  " [        US9   U" U
SS06  S S S 5        g U [
        L a>  SR                  / SQ5      n[        R                  " [        US9   U" U
SS06  S S S 5        g U [        :X  aR  US:X  aL  Sn[        R                  " [        US9   U" U
SS06nU" U
SS06nS S S 5        [        R                  " WW5        g U" U
SS06nU" U
SS06n[        R                  " UU5        g ! , (       d  f       GN¦= f! , (       d  f       GN!= f! , (       d  f       GN†= f! , (       d  f       GNv= f! , (       d  f       g = f! , (       d  f       g = f! , (       d  f       N¸= f)N)r   r   r   )r   r   r   r   r�   )rÂ   rÃ   rg   rf   rb   r]   rÇ   )rW   rX   rÅ   rÁ   rÄ   r�   r\   r™   r›   rÊ   r9   r:   rP   rQ   ra   rŽ   rÇ   rÓ   z!is not supported for object dtyperš   rÒ   rr   z"SeriesGroupBy.fillna is deprecated)rW   rX   rQ   r9   r:   rP   ra   rÇ   rÈ   rŽ   rÉ   r\   rÊ   rg   rf   rb   r]   rž   rA   Trm   )z@SeriesGroupBy.sem called with numeric_only=True and dtype objectz=Series.skew does not allow numeric_only=True with non-numericz7cum(sum|prod|min|max) is not supported for object dtypezCCannot use numeric_only=True with SeriesGroupBy\..* and non-numericz-Allowing bool dtype in SeriesGroupBy.quantileF)r   rB   ÚhasattrrD   r	   r'   r«   rE   rª   r{   r|   rw   r0   Úassert_series_equalrx   Úbool)r   r²   r±   ÚgrouperÚserrJ   r8   Úexpected_serÚexpected_gbÚexpected_methodrµ   Úfails_on_numeric_objectÚ
obj_resultr   r×   r¹   rL   rK   Úhas_numeric_onlys                      r5   Ú"test_deprecate_numeric_only_seriesrå   ž  s¢  € ò €Gä
’ %Ñ
(€CØ	�‰�WÓ	€Bà�zÓ!ä˜2×,Ñ,Ð,Ð,Øä�RÓ&€Fäš)Ó$€LØ×&Ñ& wÓ/€KÜ˜kÓ8€Oä" <Ó5€DðÐð€Jð* Ó.°5¼F²?Ø˜:Ó%ØH‰Cà5ˆCØ ,°Ó 8�}¸dˆØ:ˆÜ×'Ò'¨Ó=Ü—’œy°Ó4Ù˜‘÷ 5÷ >Ð=ð 
”&ŠØ ,°Ó 8�}¸dˆØ7ˆÜ×'Ò'¨Ó=Ù˜T�]ˆF÷ >ä×'Ò'¨Ó=Ù&¨Ð-ˆH÷ >àÓ%Ø—‘¤vÓ.ˆHÜ
×Ò˜v xÔ0ðÐð& Ð+Ó+ØAˆÜ�]Š]œ9¨CÓ0Ù�DÐ, tÒ,÷ 1Ð0à	”&ŠØ�h‰hòó
ˆô �]Š]œ9¨CÓ0Ù�DÐ, tÒ,÷ 1Ð0à	”$‹˜<¨:Ó5Ø=ˆÜ×'Ò'¬¸SÓAá˜TÐ5°Ñ5ˆFÙ˜tÐ8°%Ñ8ˆH÷ Bô 	×Ò˜v xÕ0á˜Ð1¨DÑ1ˆÙ˜4Ð4¨eÑ4ˆÜ
×Ò˜v xÕ0÷s 5Ö4ú÷ >Ö=ú÷ >Ö=úç=Ö=ú÷6 1Õ0ú÷ 1Õ0ú÷ BÕAús`   Â;JÃI:ÃJÄJÄ;J0Æ	KÇ$	KÈ!K$É:
J		ÊJÊ
JÊ
J-Ê0
J?Ë
KË
K!Ë$
K2)ry   Únumpyr¦   r{   Úpandas._libsr   Úpandasr1   r   r   r   r   r   Úpandas._testingÚ_testingrE   Úpandas.tests.groupbyr	   r   r‡   rˆ   r¾   rÔ   rØ   ÚfilterwarningsrÜ   r$   r%   r'   rå   r�   r7   r5   Ú<module>rí      s#  ðÛ 	ã Û å ã ÷õ õ Ý 8÷CDñ CDðL ‡�×Ñ˜Ò)<Ó=ñU*ó >ðU*ðp ‡�×ÑØò ó#ðH ‡�×Ñ˜¨$°°s·~±~Ð)FÓGØ‡�×Ñ˜ 4 &¨4°¨,Ð!7Ó8ñB$ó 9ó HóI#ðLB$ðJ ‡�×ÑÐRÓSØ‡�×Ñ˜ 4¨¨e°VÐ"<Ó=ñt1ó >ó Tñt1r7   