ó
    ­œ‘hd�  ã                   óü  • S SK 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  S SKJr  S SKrS SKJrJrJrJrJrJr  S SKJr  S SKJr  S SKJr  \R<                  R?                  S	S
S/5      \R<                  R?                  S/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ\R@                  \R@                  \R@                  //5      S 5       5       r!S r"\R<                  R?                  SS
S/5      S 5       r#\R<                  R?                  SS
S/5      \R<                  R?                  S/ SQ/ SQ\RH                  \RH                  \RH                  /S\RH                  S/S\RH                  S/S\RH                  S//5      S  5       5       r%\R<                  R?                  S!S"S#\RL                  " S/\'S$9\RL                  " \RH                  /S%S$94S&S"\RL                  " \RH                  /S%S$9\RL                  " S/\'S$94S&S&\RL                  " \RH                  /S%S$9\RL                  " \RH                  /S%S$94S#S%\RL                  " \RH                  /S%S$9\RL                  " \RH                  /S%S$94/5      S' 5       r(\R<                  R?                  SS
S/5      \R<                  R?                  S(/ S)Q5      S* 5       5       r)\R<                  R?                  S+S
\RH                  \R@                  /S4S
\RH                  S,\R@                  /S4S\RH                  \RT                  /S4S\RH                  S\RT                  /S4/5      S- 5       r+\R<                  R?                  SS
S/5      S. 5       r,\R<                  R?                  SS
S/5      S/ 5       r-\R<                  R?                  S0S1S2/5      S3 5       r.\R<                  R?                  S0S1S2/5      S4 5       r/\R<                  R?                  S5S1S S6/S,S7/S,S6/S8.4S2S,S7/S S6/S S7/S8.4/5      \R<                  R?                  S9SS/5      S: 5       5       r0\R<                  R?                  S\" S;5      \" S<5      4S=/5      \R<                  R?                  S>/ S?Q5      S@ 5       5       r1\R<                  R?                  S0SASB/5      SC 5       r2SD r3SE r4SF r5SG r6SH r7SI r8SJ r9SK r:SL r;SM r<\R<                  R?                  SNSOSP/5      SQ 5       r=\R<                  R?                  SNSOSP/5      SR 5       r>SS r?\R<                  R?                  SNSOSP/5      SN\@4ST j5       rA\R<                  R?                  S(/ SUQ5      SV 5       rBSW rC\R<                  R?                  SN/ SXQ5      SY 5       rD\R<                  R?                  SNSOSP/5      SZ 5       rE\R<                  R?                  S[S S,/5      \R<                  R?                  S\SS/5      S] 5       5       rF\R<                  R?                  S[S S,/5      S^ 5       rGS_ rH\R<                  R’                  \R<                  R?                  S`SS/5      \R<                  R?                  SaSS/5      \R<                  R?                  SbSS/5      \R<                  R?                  ScSS/5      \R<                  R?                  SdSe/SeSf//5      Sg 5       5       5       5       5       5       rJSh rKSi rLSj rMSk rN\R<                  R?                  Sl/ SmQ\" Sn5      \RT                  \" Sn5      /S\" S,/\Rž                  " So/SpSq9SSr94/ SmQ\R                   " SsS,S,5      \RT                  \R                   " SsS,S,5      /S\" S,/\Rž                  " So/SpSq9SSr94/ StQ\R                   " SsS,S,5      \RT                  \R                   " SsS,S,5      \RT                  \R                   " SsS,S,5      /S\" S6S6/\Rž                  " SoSu/SpSq9SSr94/ SvQ\R                   " SsS,S,5      \RT                  \R                   " SsS,S,5      \RT                  \R                   " SsS,S,5      /S\" S6S,/\Rž                  " SoSu/SpSq9SSr94/5      Sw 5       rQSx rRSy rSSz rTS{ rU\R<                  R?                  S[S S|/5      S} 5       rVS~ rWS rX\R<                  R?                  S(/ S€Q5      \R<                  R?                  S�SAS‚S,S,Sƒ.S6S7Sƒ./04SBS‚S,S6Sƒ.S6S„Sƒ./04SOS‚S,S,Sƒ.S6S7Sƒ./04SPS‚S,S6Sƒ.S6S„Sƒ./04S…S,S6Sƒ.S6S6Sƒ./S†S‡.4/5      Sˆ 5       5       rYS‰ rZ\R<                  R?                  SŠS‹\R¶                  4SŒ\R¸                  4S�\Rº                  4SŽ\R¼                  4S�\R¾                  4S�\RÀ                  4SO\RÂ                  4SP\RÄ                  4SAS‘ 4SBS’ 4S…\RÆ                  4\RÈ                  " S“\Z\RÊ                  " S”5      S•9/5      S– 5       rf\R<                  R?                  S—/ S˜QS,\RH                  S6S,\RH                  S6S,\RH                  S6/	Sƒ./ S™Q/ SšQSƒ./5      \R<                  R?                  S›/ SœQ5      S� 5       5       rg\R<                  R?                  Sž/ SŸQ5      \R<                  R?                  S S S,/5      \R<                  R?                  S¡SS/5      \R<                  R?                  S`SS/5      S¢ 5       5       5       5       rhS£ rig)¤é    N)Úascii_lowercase)ÚiNaT)Úpandas_dtype)Úna_value_for_dtype)Ú	DataFrameÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚisna)Úget_groupby_method_args)Ú_test_decoratorsÚagg_funcÚanyÚallÚvals)ÚfooÚbarÚbaz)r   Ú r   )r   r   r   ©é   é   é   )r   r   r   ©r   r   r   )ç      ð?ç       @ç      @)r   ç        r   )r   r   r   )TTT)TFF)FFFc           	      ól  • [        S/S-  S/S-  -   US-  S.5      n[        [        U5      " U5      nU (       a!  [        [	        U5      5      (       a  US:X  a  Sn[        U/S-  S/[
        R                  " SS/S	S
9S9n[        UR                  S	5      U5      " U S9n[        R                  " Xe5        g )NÚar   Úbr   )ÚkeyÚvalr   Fr$   r#   ©Úname©ÚcolumnsÚindex©Úskipna)
r   ÚgetattrÚbuiltinsr   r   ÚpdÚIndexÚgroupbyÚtmÚassert_frame_equal)r+   r   r   ÚdfÚexpÚexpectedÚresults          ÚhC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/groupby/test_reductions.pyÚtest_groupby_bool_aggsr8      sª   € ô( 
˜C˜5 1™9¨ u¨q¡yÑ0¸À¹ÑBÓ	C€Bô ”(˜HÔ
% dÓ
+€Cö ”#”d˜4“j—/‘/ h°%Ó&7ØˆäØ	ˆ�‰	˜E˜7¬"¯(ª(°C¸°:ÀEÑ*Jñ€Hô �R—Z‘Z Ó&¨Ô1¸Ñ@€FÜ×Ò˜&Õ+ó    c                  ó   • [        / SQS[        R                  S/S[        R                  S/// SQS9n [        SS/S	S//S
S/SS/S9nSUR                  l        U R                  S5      R                  5       n[        R                  " X!5        g )N)r   r   r   r   r   r   r   ©ÚAÚBÚC©r(   TFr=   r>   r'   r<   )	r   ÚnpÚnanr)   r&   r0   r   r1   r2   ©r3   r5   r6   s      r7   Útest_anyrC   ?   s‰   € Ü	Ú	˜œBŸF™F EÐ*¨Q´·±¸Ð,>Ð?Úñ
€Bô Ø
�ˆ˜˜t�}Ð%°°S¨zÀ!ÀQÀñ€Hð €H‡N�NÔØ�Z‰Z˜‹_× Ñ Ó"€FÜ×Ò˜&Õ+r9   Úbool_agg_funcc                 óÞ   • [        SS//SS/S9nUR                  S/5      n[        X 5      " 5       nUR                  [        R
                  " S/5      5      n[        R                  " X45        g )NTr!   r?   r   )r   r0   r,   Úset_axisr@   Úarrayr1   r2   )rD   r3   Úgrp_byr6   r5   s        r7   Ú test_bool_aggs_dup_column_labelsrI   L   s\   € ô 
�T˜4�L�>¨C°¨:Ñ	6€BØ�Z‰Z˜˜‹_€FÜ�VÔ+Ó-€Fà�{‰{œ2Ÿ8š8 Q C›=Ó)€HÜ×Ò˜&Õ+r9   ÚdataFTc                 óâ   • [        USS9n[        X05      " US9n[        U[        R                  " S/5      SS9nUR	                  / SQ5      R                  XS9n[        R                  " Xe5        g )NÚboolean©Údtyper*   r   ©r)   rN   r   )r	   r,   r@   rG   r0   Úaggr1   Úassert_series_equal)rD   r+   rJ   ÚserÚexpected_datar5   r6   s          r7   Útest_masked_kleene_logicrT   W   sc   € ô �˜YÑ
'€Cô ˜CÔ/°vÑ>€MÜ�m¬2¯8ª8°Q°C«=À	ÑJ€Hà�[‰[šÓ#×'Ñ'¨Ð'ÐE€FÜ×Ò˜6Õ,r9   zdtype1,dtype2,exp_col1,exp_col2ÚfloatÚFloat64rM   rL   ÚInt64c                 ó<  • S[         R                  /n[        [        R                  " X@S9[        R                  " XAS9S.5      nUR                  SS/5      R                  SSS9n[        X#S.[         R                  " S/5      S9n[        R                  " Xg5        g )	Nr   rM   )Úcol1Úcol2r   r   Fr*   ©r)   )	r@   rA   r   r.   rG   r0   rP   r1   r2   )Údtype1Údtype2Úexp_col1Úexp_col2rJ   r3   r6   r5   s           r7   Útest_masked_mixed_typesr`   p   s€   € ð> ”—‘ˆ=€DÜ	Ü—’˜$Ñ-´r·x²xÀÑ7SÑTó
€Bð �Z‰Z˜˜A˜Ó×#Ñ# E°%Ð#Ð8€Fä (Ñ=ÄRÇXÂXÈqÈcÃ]ÑS€HÜ×Ò˜&Õ+r9   rN   )rW   rV   rL   c                 ó  • U" [         R                  S/US9nSnU(       d  U S:X  a  [         R                  nU" U/[        R                  " S/5      SS9nUR	                  SS/5      R                  XS9n[        R                  " Xv5        g )Nr   rM   Tr   rL   rO   r*   )r.   ÚNAr@   rG   r0   rP   r1   Úassert_equal)rD   rN   r+   Úframe_or_seriesÚobjÚexpected_resr5   r6   s           r7   Útest_masked_bool_aggs_skipnarg   ™   sv   € ñ œ2Ÿ5™5 !˜*¨EÑ
2€CØ€LÞ�m uÓ,Ü—u‘uˆÙ ˜~´R·X²X¸q¸c³]È)ÑT€Hà�[‰[˜!˜Q˜Ó ×$Ñ$ ]Ð$ÐB€FÜ‡O‚O�FÕ%r9   zbool_agg_func,data,expected_resr   c                 óÜ   • U" U[         S9nUR                  S/[        U5      -  5      R                  U 5      nU" U/[        R
                  " S/5      SS9n[        R                  " XV5        g )NrM   r   ÚboolrO   )Úobjectr0   ÚlenrP   r@   rG   r1   rc   )rD   rJ   rf   rd   re   r6   r5   s          r7   Útest_object_type_missing_valsrl   §   sY   € ñ ˜$¤fÑ
-€CØ�[‰[˜!˜œs 4›y™Ó)×-Ñ-¨mÓ<€FÙ ˜~´R·X²X¸q¸c³]È&ÑQ€HÜ‡O‚O�FÕ%r9   c                 óä   • [        [        R                  /[        S9n[        R
                  " [        SS9   UR                  S/5      R                  U SS9  S S S 5        g ! , (       d  f       g = f)NrM   z boolean value of NA is ambiguous©Úmatchr   Fr*   )	r	   r.   rb   rj   ÚpytestÚraisesÚ	TypeErrorr0   rP   )rD   rR   s     r7   Ú'test_object_NA_raises_with_skipna_falsers   ¸   sP   € ô ”"—%‘%�¤Ñ
'€CÜ	�Š”yÐ(JÓ	KØ�‰�Q�CÓ×Ñ˜]°5ÐÑ9÷ 
L×	KÖ	Kús   ·!A!Á!
A/c                 óè   • U [         L a  SS/0OSS0nU " S0 UDS[        0D6n[        UR                  UR                  5      U5      " 5       nU " S0 UDS[
        0D6n[        R                  " XE5        g )Nr(   r!   r&   rN   © )r   rj   r,   r0   r)   ri   r1   rc   )rd   rD   Úkwargsre   r6   r5   s         r7   Ú
test_emptyrw   À   si   € ð $3´iÒ#?ˆi˜#˜ÑÀfÈcÀ]€FÙ
Ñ
1˜FÑ
1¬&Ò
1€CÜ�S—[‘[ §¡Ó+¨]Ô;Ó=€FÙÑ4 Ñ4¬tÒ4€HÜ‡O‚O�FÕ%r9   ÚhowÚidxminÚidxmaxc           	      ó–  • U[         L d	  U[        L a  g SU;   a  [        R                  O[        R                  nU" U5      R
                  nU" U5      R                  n[        / SQX4XC/S.US9nUR                  S5      n[        X`5      " 5       n[        SSS/0[        R                  " SS	/SUS
9S9n[        R                  " Xx5        g )NÚint)r   r   r   r   ©r!   r"   rM   r!   r"   r   r   r   ©r&   rN   r[   )r|   rU   r@   ÚiinfoÚfinfoÚminÚmaxr   r0   r,   r.   r/   r1   r2   )	rx   Úany_real_numpy_dtypeÚinfoÚ	min_valueÚ	max_valuer3   Úgbr6   r5   s	            r7   Útest_idxmin_idxmax_extremesrˆ   Ê   s¿   € ð œsÒ"Ð&:¼eÒ&CàØÐ 4Ó4Œ2�8Š8¼"¿(¹(€DÙÐ)Ó*×.Ñ.€IÙÐ)Ó*×.Ñ.€IÜ	Ú )¸	Ð!MÑNØ"ñ
€Bð 
�‰�C‹€BÜ�RÔÓ€FÜØ	ˆq�!ˆfˆœRŸXšX q¨! f°3Ð>RÑSñ€Hô ×Ò˜&Õ+r9   c                 óX  • [         R                  " U5      R                  n[         R                  " U5      R                  n[	        [        [         R                  " [        SS5      SS9SS9[        [         R                  U[         R                  UU[         R                  U[         R                  [         R                  [         R                  /
US9S.5      nUR                  S5      nU (       a  S O[        nS	U S
3n[        R                  " XxS9   [        Xa5      " U S9n	S S S 5        U (       a  SSSS[         R                  /n
O[         R                  n
[	        SU
0[        R                  " [        SS5      SSS9S9n[        R                   " W	U5        g ! , (       d  f       N}= f)Nr   é   r   )ÚrepeatsÚintprM   r}   r!   z!The behavior of DataFrameGroupBy.z with all-NA valuesrn   r*   r   é   r"   r~   r[   )r@   r€   r�   r‚   r   r	   ÚrepeatÚrangerA   r0   ÚFutureWarningr1   Úassert_produces_warningr,   r.   r/   r2   )r+   rx   Úfloat_numpy_dtyper…   r†   r3   r‡   ÚwarnÚmsgr6   Úvaluesr5   s               r7   Ú"test_idxmin_idxmax_extremes_skipnar–   ß   sJ  € ô —’Ð*Ó+×/Ñ/€IÜ—’Ð*Ó+×/Ñ/€IÜ	äœŸ	š	¤%¨¨1£+°qÑ9ÀÑHÜä—F‘FØÜ—F‘FØØÜ—F‘FØÜ—F‘FÜ—F‘FÜ—F‘Fðð (ññ	
ó
€Bð( 
�‰�C‹€Bæ‰4œ}€DØ-¨c¨UÐ2EÐ
F€CÜ	×	#Ò	# DÓ	4Ü˜Ô!¨Ñ0ˆ÷ 
5æØ�Q˜˜1œbŸf™fÐ%‰ä—‘ˆÜØ	ˆfˆœRŸXšX¤e¨A¨q£k¸À6ÑJñ€Hô ×Ò˜& (Õ+÷ 
5Õ	4ús   ÄFÆ
F)zfunc, valuesr   r   )Úc_intÚc_floatÚc_dateÚnumeric_onlyc                 óª  • [        / SQ/ SQ/ SQ/ SQS.5      n[        R                  " US   5      US'   US   R                  R	                  S5      US'   US   US   R
                  S	   -
  US
'   US   R                  R                  S5      US'   US   R                  S5      US'   US   R                  S5      US'   [        UR                  S5      U 5      " US9n[        U[        R                  " SS/SS9S9nU(       a  UR                  S/S9nOUS   US'   US   US
'   US   US'   US   US'   US   US'   [        R                  " XE5        g )N©r<   r<   r=   r=   ©r   r   r   r�   )g®Gáz@g=
×£p=@gR¸…ëQ @gÍÌÌÌÌÌð?)Ú2019Ú2018Ú2016Ú2017)r&   r—   r˜   r™   r™   z
US/PacificÚ	c_date_tzr   Úc_timedeltaÚWÚc_periodr—   rW   Ú	c_Integerr˜   rV   Ú
c_Floatingr&   ©rš   r<   r=   r%   r[   r?   )r   r.   Úto_datetimeÚdtÚtz_localizeÚilocÚ	to_periodÚastyper,   r0   r/   Údropr1   r2   )Úfuncr•   rš   r3   r6   r5   s         r7   Ú$test_idxmin_idxmax_returns_int_typesr±     se  € ô 
â(Ú!Ú/Ú6ñ		
ó
€Bô —>’> " X¡,Ó/€B€x�LØ˜‘l—o‘o×1Ñ1°,Ó?€B€{�OØ˜8™ r¨(¡|×'8Ñ'8¸Ñ';Ñ;€B€}ÑØ˜‘\—_‘_×.Ñ.¨sÓ3€B€z�NØ˜‘k×(Ñ(¨Ó1€B€{�OØ˜)‘}×+Ñ+¨IÓ6€B€|Ñä�R—Z‘Z Ó'¨Ô.¸LÑI€Fä˜¤r§x¢x°°c°
ÀÑ'HÑI€HÞØ—=‘=¨(¨�=Ð4‰à (¨Ñ 2ˆ�ÑØ"*¨8Ñ"4ˆ�ÑØ'¨Ñ1ˆ�ÑØ$ WÑ-€Hˆ[ÑØ% iÑ0€Hˆ\Ñä×Ò˜&Õ+r9   z2011-01-15 12:50:28.502376z2011-01-20 12:50:28.593448)l    m;-L¼l    m;-L¼Úmethod)Úcountr�   r‚   ÚfirstÚlastc                 ó>  • [        SS/US.5      nUR                  S5      n[        X05      " 5       nU S:X  a  SnO,U S:X  a  US   nO U S:X  a  US   nO[        US	   U 5      " 5       n[        S	U/0[        R                  " S/SS
9S9n[
        R                  " XF5        g )Nr   r}   r!   r³   r   r´   r   rµ   r"   r%   r[   )r   r0   r,   r.   r/   r1   r2   )r²   rJ   r3   Úgroupedr6   Úexpected_valuer5   s          r7   Ú2test_groupby_non_arithmetic_agg_int_like_precisionr¹   0  s¢   € ô 
˜!˜Q˜ dÑ+Ó	,€Bà�j‰j˜‹o€GÜ�WÔ%Ó'€FØ�ÓØ‰Ø	�7Ó	Ø˜a™‰Ø	�6Ó	Ø˜a™‰ä   C¡¨&Ô1Ó3ˆÜ˜# Ð/Ð0¼¿ºÀ!ÀÈ3Ñ8OÑP€Hä×Ò˜&Õ+r9   r´   rµ   c           
      óÒ  • [        [        U 5      5      n[        / SQUSUS[        R                  [        R                  /USUS[        R                  [        R                  /S.U S9nUR                  SUS9n[        Xc5      nU" US9n/ S	Q/ S
Q/ SQ/ SQS.X24   n	UR                  U	   R                  S5      n
U(       a  U
R                  5       n
[        R                  " XŠ5        g )N)r   r   r   r   r   r   r   ç      @©r!   r"   ÚcrM   r!   )Úsortr*   )r   r   r�   )r   r   r�   )r   r   é   )r   r   r¿   ))r´   T)r´   F)rµ   T)rµ   F)r   r   r   r@   rA   r0   r,   r¬   Ú	set_indexÚ
sort_indexr1   r2   )Úany_real_nullable_dtyper¾   r+   rx   Úna_valuer3   r‡   r²   r6   Úilocsr5   s              r7   Útest_first_last_skipnarÅ   N  sÝ   € ô "¤,Ð/FÓ"GÓH€HÜ	â#Ø˜C ¨3´·±¼¿¹Ð?Ø˜C ¨3´·±¼¿¹Ð?ñ	
ð
 &ñ
€Bð 
�‰�C˜dˆÐ	#€BÜ�RÓ€FÙ˜6Ñ"€Fò #Ú#Ú!Ú"ñ	ð
 
€kñ€Eð �w‰w�u‰~×'Ñ'¨Ó,€HÞØ×&Ñ&Ó(ˆÜ×Ò˜&Õ+r9   c                  ó   • [        [        R                  R                  S5      R	                  S5      / SQS9n / SQU S'   U R                  S5      nSn[        R                  " [        US9   UR                  S	S
9nS S S 5        U R                  S S 2S	S 24   R                  S	S
9nWR                  R                  S	5      n[        R                  " XE   UR                  S5      5        [        SSS9U S'   U R                  S5      nSn[         R"                  " [$        US9   [        R                  " [        US9   UR                  S	S
9  S S S 5        S S S 5        g ! , (       d  f       Nç= f! , (       d  f       N(= f! , (       d  f       g = f)Nr   )é
   r�   )r<   r=   r>   ÚDr?   )
r   r   r   r   r   r   r   r   r   r�   r<   z1DataFrameGroupBy.idxmax with axis=1 is deprecatedrn   r   ©Úaxisz
2016-01-01rÇ   ©ÚperiodsÚEz>'>' not supported between instances of 'Timestamp' and 'float')r   r@   ÚrandomÚdefault_rngÚstandard_normalr0   r1   r‘   r�   rz   r¬   r)   Úget_level_valuesrQ   Ú	droplevelr   rp   rq   rr   )r3   r‡   Úwarn_msgÚresÚaltÚindexerÚgb2r”   s           r7   Útest_idxmin_idxmax_axis1rØ   j  s:  € Ü	Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9ÒCWñ
€Bò -€B€s�Gà	�‰�C‹€BàB€HÜ	×	#Ò	#¤M¸Ó	BØ�i‰i˜QˆiÐˆ÷ 
Cð �'‰'’!�Q‘R�%‰.×
Ñ
 QÐ
Ð
'€CØ�i‰i×(Ñ(¨Ó+€Gä×Ò˜3™<¨¯©°sÓ);Ô<ä˜¨rÑ2€B€s�GØ
�*‰*�S‹/€Cà
J€CÜ	�Š”y¨Ó	,Ü×'Ò'¬¸XÓFØ�J‰J˜AˆJÑ÷ G÷ 
-Ð	,÷ 
CÕ	Bú÷ GÕFú÷ 
-Õ	,ús0   Á,EÄ"E?Ä<E.ÅE?Å
E+Å.
E<	Å8E?Å?
Fc                  ó~   • [        / SQ/ SQS.5      n U R                  S5      S   R                  5       S   S:X  d   eg )N)r<   r<   r<   r<   r<   )ij  i�  io  i`  l    @Ü~ÿÿ )ÚuserÚconnectionsrÚ   rÛ   r<   l    ,fÌL™ )r   r0   Úmean)r3   s    r7   Útest_groupby_mean_no_overflowrÝ   „  sD   € ä	â-ÚIñ	
ó
€Bð �:‰:�fÓ˜mÑ,×1Ñ1Ó3°CÑ8Ð<OÓOÐOÑOr9   c            	      ó@  • [        [        R                  " [        S5      5      SS/S-  S.5      n U R	                  S5      S   R                  5       n[        [        R                  " SS/5      S[        R                  " SS/SS	9S
9n[        R                  " X5        g )NrÇ   r<   r=   r¿   )ÚtimeÚcatrà   rß   r�   r%   ©r&   r)   )
r   r.   Úto_timedeltar�   r0   rÜ   r	   r/   r1   rQ   ©r3   r6   r5   s      r7   Útest_mean_on_timedeltarä   �  s   € ä	œBŸOšO¬E°"«IÓ6ÀÀS¸zÈA¹~ÑNÓ	O€BØ�Z‰Z˜Ó˜vÑ&×+Ñ+Ó-€FÜÜ
�Š˜˜A˜Ó f´B·H²H¸cÀ3¸ZÈeÑ4Tñ€Hô ×Ò˜6Õ,r9   c                  ó"  • [         R                  R                  S5      R                  S5      n [         R                  U S S S2'   [        U 5      n[         R                  R                  S5      R                  SSSS9R                  [        5      n[         R                  US S S2'   UR                  U5      R                  5       nSn[        R                  " [        US9   UR                  U5      R                  [         R                  5      nS S S 5        [        R                   " UW5        [        [         R                  R                  S5      R                  S	5      5      nSn[        R                  " [        US9   UR                  U5      R                  [         R                  5      nS S S 5        UR                  U5      R                  5       n[        R                   " WU5        g ! , (       d  f       Nå= f! , (       d  f       NV= f)
Nr   éè  r   é2   ©Úsizeé   zusing DataFrameGroupBy.medianrn   )ræ   r¿   )r@   rÎ   rÏ   rÐ   rA   r   Úintegersr®   rU   r0   Úmedianr1   r‘   r�   rP   Ú	nanmedianr2   )Úarrr3   Úlabelsr6   r”   r4   ÚrsÚxps           r7   Útest_cython_medianrò   ™  so  € Ü
�)‰)×
Ñ
 Ó
"×
2Ñ
2°4Ó
8€CÜ�v‰v€C‰ˆ!ˆ�HÜ	�3‹€Bä�Y‰Y×"Ñ" 1Ó%×.Ñ.¨q°"¸4Ð.Ð@×GÑGÌÓN€FÜ—6‘6€F‰4ˆRˆ4�Là�Z‰Z˜Ó×&Ñ&Ó(€FØ
)€CÜ	×	#Ò	#¤M¸Ó	=Ø�j‰j˜Ó ×$Ñ$¤R§\¡\Ó2ˆ÷ 
>ä×Ò˜& #Ô&ä	”2—9‘9×(Ñ(¨Ó+×;Ñ;¸IÓFÓ	G€BØ
)€CÜ	×	#Ò	#¤M¸Ó	=Ø�Z‰Z˜Ó×#Ñ#¤B§I¡IÓ.ˆ÷ 
>à	�‰�FÓ	×	"Ñ	"Ó	$€BÜ×Ò˜"˜bÕ!÷ 
>Õ	=ú÷ 
>Õ	=ús   Ã!/G/Æ/H Ç/
G=È 
Hc                 óh  • [        [        R                  R                  S5      R	                  SSS5      5      n[        SSS5      n[        R                  " US   U5      nUR                  X0S9R                  5       nUR                  X0S9R                  S 5      n[        R                  " XE5        g )	Nr   r   é,   éô  é7   r¿   ©Úobservedc                 ó"   • U R                  5       $ )N)rì   ©Úxs    r7   Ú<lambda>Ú(test_median_empty_bins.<locals>.<lambda>¶  s
   € ÀÇÁÄr9   )r   r@   rÎ   rÏ   rë   r�   r.   Úcutr0   rì   rP   r1   r2   )rø   r3   ÚgrpsÚbinsr6   r5   s         r7   Útest_median_empty_binsr  ¯  sŽ   € Ü	”2—9‘9×(Ñ(¨Ó+×4Ñ4°Q¸¸CÓ@Ó	A€Bä��B˜‹?€DÜ�6Š6�"�Q‘%˜Ó€Dà�Z‰Z˜ˆZÐ0×7Ñ7Ó9€FØ�z‰z˜$ˆzÐ2×6Ñ6Ñ7KÓL€HÜ×Ò˜&Õ+r9   c                  óf  • [        / SQ/ SQSS/-  S.5      n U R                  S5      R                  5       nSU;   d   eU R                  S5      R                  SS	9nSU;   d   eU R                  S5      R                  5       nSU;   d   eU R                  S5      R                  SS	9nSU;   d   eg )
N)é   r  é   r  r�   r�   Úmama)ÚnnÚiiÚssr  r  Fr¨   )r   r0   r‚   r�   )Úaar6   s     r7   Útest_max_min_non_numericr
  º  s°   € ä	Ò*²,ÀaÈ6È(ÁlÑSÓ	T€Bà�Z‰Z˜Ó×!Ñ!Ó#€FØ�6‹>Ðˆ>à�Z‰Z˜Ó×!Ñ!¨uÐ!Ð5€FØ�6‹>Ðˆ>à�Z‰Z˜Ó×!Ñ!Ó#€FØ�6‹>Ðˆ>à�Z‰Z˜Ó×!Ñ!¨uÐ!Ð5€FØ�6‹>Ð‰>r9   c                 ó  • [        / SQ/ SQ/ SQS.5      nUR                  5         U (       d-  U(       a%  [        UR                  R                  5      S:X  d   e UR                  S5      nUS/   R                  5       n[        R                  " / SQSS	9n[        S/ S
Q0US9n[        R                  " XF5        US/   R                  5       n[        R                  " / SQSS	9n[        S/ SQ0US9n[        R                  " XF5        g )N)r   r   r   r   r   )r   r   r   r   F)r!   r"   r½   ÚdÚer;   r   r<   r>   r   r%   )r"   r  r  r[   )r!   r½   r  )r   Ú_consolidate_inplacerk   Ú_mgrÚblocksr0   r‚   r.   r/   r1   r2   r�   )Úusing_array_managerÚusing_infer_stringr3   r‡   r6   Úeir5   s          r7   Ú$test_max_min_object_multiple_columnsr  Ë  sÙ   € ô
 
â Ú,Ú*ñ	
ó
€Bð ×ÑÔÞÞ+=Œs�2—7‘7—>‘>Ó" aÓ'ÐDÐDÀ1à	�‰�C‹€Bà��‰Y�]‰]‹_€Fä	�Š’) #Ñ	&€BÜ˜#šÐ/°rÑ:€HÜ×Ò˜&Ô+à��‰Y�]‰]‹_€Fä	�Š’) #Ñ	&€BÜ˜#šÐ/°rÑ:€HÜ×Ò˜&Õ+r9   c                  ó8  • [         R                  " [        / SQ5      SS9R                  R                  n [        [        R                  S[        R                  // SQU S.5      nUR                  SSS	9S
   R                  5       S
   n[         R                  " [        SS/S
S9SS9R                  R                  n[        R                  " X#5        UR                  S5      S
   R                  5       nSUR                  l        [        R                  " X#5        g )N)ú
2019-05-09r  r  z%Y-%m-%d)ÚformatÚ1)r   r   r   r¼   r"   F©Úas_indexr½   r  r%   )r.   r©   r	   rª   Údater   r@   rA   r0   r�   r1   rQ   r)   r&   )Údatesr3   r6   r5   s       r7   Útest_min_date_with_nansr  ê  sÞ   € ä�NŠNÜÒ9Ó:À:ñç�b�‰ð 
ô 
œ"Ÿ&™& #¤r§v¡vÐ.²YÀUÑKÓ	L€Bà�Z‰Z˜ eˆZÐ,¨SÑ1×5Ñ5Ó7¸Ñ<€FÜ�~Š~Ü�˜lÐ+°#Ñ6¸zñç�b�‰ð ô ×Ò˜6Ô,à�Z‰Z˜‹_˜SÑ!×%Ñ%Ó'€FØ€H‡N�NÔÜ×Ò˜6Õ,r9   c                  ó  • [        S[        /5      n [        R                  " SS/[        R                  S9nU R                  U5      nUR                  SS9n[        SS0[        R                  S9n[        R                  " X4SS9  UR                  SS9n[        S[        0[        R                  S9n[        R                  " X4SS9  UR                  SS9n[        S[        R                  05      n[        R                  " X4SS9  g )Nr   rM   r   ©Ú	min_countT©Úcheck_exactr   )r	   r   r@   rG   Úint64r0   r‚   r1   rQ   r�   rA   )rR   r#   r‡   r6   r5   s        r7   Útest_max_inatr$  ü  sÒ   € ä
�!”T�Ó
€CÜ
�(Š(�A�q�6¤§¡Ñ
*€CØ	�‰�SÓ	€Bà�V‰V˜aˆVÐ €FÜ�q˜!�f¤B§H¡HÑ-€HÜ×Ò˜6¸Ò>à�V‰V˜aˆVÐ €FÜ�qœ$�i¤r§x¡xÑ0€HÜ×Ò˜6¸Ò>ð �V‰V˜aˆVÐ €FÜ�qœ"Ÿ&™&�kÓ"€HÜ×Ò˜6¸Ó>r9   c                  óR  • [        S[        S[        S-   /5      n U R                  / SQ5      nUR                  SS9n[        [        R
                  [        R
                  [        S-   S.5      nUR                  R                  [        5      Ul        [        R                  " X#SS9  g )Nr   r   )r   r   r   r   r  r   Tr!  )r	   r   r0   r�   r@   rA   r)   r®   r|   r1   rQ   )rR   r‡   r6   r5   s       r7   Útest_max_inat_not_all_nar&    s~   € ô �!”T˜1œd Q™hÐ'Ó
(€CØ	�‰’\Ó	"€BØ�V‰V˜aˆVÐ €Fô œ"Ÿ&™&¤R§V¡V´°q±Ñ9Ó:€HØ—^‘^×*Ñ*¬3Ó/€H„NÜ×Ò˜6¸Ó>r9   r°   r�   r‚   c                 ó  • SS/n[         R                  " SSSS9n[        XS.5      n[        UR	                  S5      S   U 5      " 5       n[         R
                  " SS/SS	9n[        X%SS
9n[        R                  " XF5        g )Nr   r   Ú2020ÚY©rÌ   Úfreqr}   r!   r"   r%   ©r)   r&   )	r.   Úperiod_ranger   r,   r0   r/   r	   r1   rQ   ©r°   ÚgroupsrÌ   r3   r6   Úidxr5   s          r7   Ú$test_groupby_aggregate_period_columnr1    sv   € ð �ˆV€FÜ�oŠo˜f¨a°cÑ:€GÜ	˜Ñ.Ó	/€Bä�R—Z‘Z “_ SÑ)¨4Ô0Ó2€FÜ
�(Š(�A�q�6 Ñ
$€CÜ�g¨sÑ3€Hä×Ò˜6Õ,r9   c                 ó  • SS/n[         R                  " SSSS9n[        XS.5      n[        UR	                  S5      U 5      " 5       n[         R
                  " SS/SS9n[        S	U0US
9n[        R                  " XF5        g )Nr   r   r(  r)  r*  r}   r!   r%   r"   r[   )r.   r-  r   r,   r0   r/   r1   r2   r.  s          r7   Ú#test_groupby_aggregate_period_framer3  ,  su   € ð �ˆV€FÜ�oŠo˜f¨a°cÑ:€GÜ	˜Ñ.Ó	/€Bä�R—Z‘Z “_ dÔ+Ó-€FÜ
�(Š(�A�q�6 Ñ
$€CÜ˜#˜w˜¨sÑ3€Hä×Ò˜&Õ+r9   c                  óÖ  • [        / SQ[        S5      [        R                  /S-  S.5      R	                  [
        5      n U R                  S5      R                  5       n[        SS/SS	/[        R                  [        R                  /S.5      R                  S5      R	                  [
        5      n[        R                  " X5        [        / SQ[        S5      [        S5      S.5      R	                  [
        5      n U R                  S5      R                  5       n[        SS/SS	/S
S/S.5      R                  S5      R	                  [
        5      n[        R                  " X5        g )Nrœ   Úabcdr�   )r#   rY   rZ   r#   r<   r=   r!   r½   r   r   )r   Úlistr@   rA   r®   rj   r0   r�   rÀ   r1   r2   r�   rã   s      r7   Ú#test_aggregate_numeric_object_dtyper7  :  s"  € ô 
Ú$¬d°6«lÄRÇVÁVÀHÈqÁLÑQó
ç�fŒVƒnð ð �Z‰Z˜Ó×"Ñ"Ó$€FäØ˜#�J¨¨c¨
¼R¿V¹VÄRÇVÁVÐ<LÑMó	
÷ 
‰�5Ó	ß	‰”‹ð ô ×Ò˜&Ô+ô 
Ú$¬d°6«lÄEÈ!ÃHÑMó
ç�fŒVƒnð ð �Z‰Z˜Ó×"Ñ"Ó$€Fä˜3 ˜*¨s°C¨jÀ1ÀaÀ&ÑIÓJß	‰�5Ó	ß	‰”‹ð ô
 ×Ò˜&Õ+r9   c                 ó\  • [        S/SS9R                  R                  5       n[        S/US.5      nUR	                  S5      R                  SU 05      n[        SS/0[        R                  " S/SS9S	9nUS   R                  UR                  5      US'   [        R                  " X45        g )
Nr"   ÚcategoryrM   iÍ  ©r<   r=   r<   r=   r%   r[   )r	   rà   Ú
as_orderedr   r0   rP   r.   r/   r®   rN   r1   r2   )r°   Údsr3   r6   r5   s        r7   Ú%test_aggregate_categorical_lost_indexr=  X  s™   € ô 
��˜ZÑ	(×	,Ñ	,×	7Ñ	7Ó	9€BÜ	˜$˜ bÑ)Ó	*€BØ�Z‰Z˜‹_× Ñ  # t Ó-€FÜ˜# ˜u˜¬R¯XªX°t°fÀ3Ñ-GÑH€Hð ˜S‘M×(Ñ(¨¯©Ó2€HˆS�Mä×Ò˜&Õ+r9   )rW   ÚInt32rV   ÚFloat32rL   c                 óZ  • U S:X  a  SnOU S:X  a  SnOSn[        SS/XS-   /S.5      nUS	   R                  U 5      US	'   UR                  S
5      nUR                  5       nUR                  S S R                  S
5      n[        R                  " XE5        UR                  5       nUR                  SS  R                  S
5      n[        R                  " Xg5        UR                  SS9n[        S	[        R                  /0UR                  U S9n	[        R                  " X‰5        UR                  SS9n
[        R                  " X©5        [        / SQU[        R                  US-   /S.5      nUS	   R                  U 5      US	'   UR                  S
5      nUR                  5       n[        R                  " XÕ5        UR                  5       n[        R                  " Xç5        UR                  SS9n[        R                  " Xù5        UR                  SS9n[        R                  " UU	5        g )NrW   l   ².¿Dÿ²3 rL   r   r»   r   r   )ÚidÚtsrB  rA  r   r  rO   )r   r   r   éd   )r   r®   r0   r�   r¬   rÀ   r1   r2   r‚   r.   rb   r)   )rN   rB  r3   r‡   r6   r5   Úres_maxÚexpected_maxÚresult2Ú	expected2Úres_max2Údf2r×   Úresult3Úres_max3Úresult4Úres_max4s                    r7   Útest_groupby_min_max_nullablerN  f  sÒ  € à�Óà ‰Ø	�)Ó	Ø‰àˆä	˜1˜a˜&¨°!©V¨Ñ5Ó	6€BØ�$‰x�‰˜uÓ%€B€t�Hà	�‰�DÓ	€Bà�V‰V‹X€FØ�w‰w�r˜ˆ{×$Ñ$ TÓ*€HÜ×Ò˜&Ô+à�f‰f‹h€GØ—7‘7˜1˜2�;×(Ñ(¨Ó.€LÜ×Ò˜'Ô0à�f‰f˜qˆfÐ!€GÜ˜4¤"§%¡% ˜/°·±ÀuÑM€IÜ×Ò˜'Ô-à�v‰v ˆvÐ"€HÜ×Ò˜(Ô.ô š9¨R´·±¸¸Q¹Ð,?Ñ@Ó
A€CØ�D‘	× Ñ  Ó'€Cˆ�IØ
�+‰+�dÓ
€Cà�g‰g‹i€GÜ×Ò˜'Ô,à�w‰w‹y€HÜ×Ò˜(Ô1à�g‰g ˆgÐ$€GÜ×Ò˜'Ô-à�w‰w ˆwÐ%€HÜ×Ò˜( IÕ.r9   c            
      ó8  • [         R                  " S/S-  SS/S9n [        U [         R                  " [        R
                  " S[        R                  S95      S.5      nUR                  SSS	9nUR                  5       n[         R                  " SS/U R                  SS
9n[        S[         R                  " S[         R                  /SS90US9n[        R                  " X55        UR                  5       nSUR                  S'   [        R                  " X55        g )Nr   rÇ   r   )Ú
categoriesrM   r:  r<   Fr÷   ©rN   r&   r=   ÚUInt64r[   é	   )r   r   )r.   ÚCategoricalr   rG   r@   ÚarangeÚuint64r0   r�   ÚCategoricalIndexrN   rb   r1   r2   r‚   r¬   )rà   r3   r‡   rÔ   r0  r5   s         r7   Ú(test_min_max_nullable_uint64_empty_grouprX  –  sÕ   € ä
�.Š.˜!˜˜r™¨q°!¨fÑ
5€CÜ	˜¤2§8¢8¬B¯IªI°bÄÇ	Á	Ñ,JÓ#KÑLÓ	M€BØ	�‰�C %ˆÐ	(€Bà
�&‰&‹(€Cä
×
Ò
˜q !˜f¨C¯I©I¸CÑ
@€CÜ˜#œrŸxšx¨¬B¯E©E¨
¸(ÑCÐDÈCÑP€HÜ×Ò˜#Ô(à
�&‰&‹(€CØ€H‡M�M�$ÑÜ×Ò˜#Õ(r9   )r´   rµ   r�   r‚   c           	      ót  • [        [        R                  " S/[        S5      SS9[        R                  " S/SS/SS9SS.5      n[	        UR                  S	S
S9U 5      " 5       n[        R                  " SS/S	SS9n[        [        R                  " SS /SS/SS9SS /S.US9n[        R                  " X$5        g )Nr<   ÚABT)rP  Úorderedr   r   gš™™™™™¹?)rY   rZ   ÚvaluerY   Fr÷   r=   )rJ   r&   r[  )rZ   r\  r[   )	r   r.   rT  r6  r,   r0   rW  r1   r2   )r°   r3   r6   r0  r5   s        r7   Ú test_groupby_min_max_categoricalr]  §  s»   € ô 
ä—N’N C 5´T¸$³ZÈÑNÜ—N’N A 3°A°q°6À4ÑHØñ	
ó
€Bô �R—Z‘Z °�ZÐ7¸Ô>Ó@€Fä
×
Ò
 C¨ :°FÀDÑ
I€CÜä—N’N A t 9¸!¸Q¸ÈÑNØ˜4�[ñ	
ð ñ€Hô ×Ò˜&Õ+r9   c           
      óî   • Un[        S/SSS.US9R                  S S n[        UR                  S5      U 5      " 5       n[        SS/U[        R
                  " / USS9S9n[        R                  " XE5        g )	Nr!   r¼   rM   r   r"   r½   rQ  )r(   rN   r)   )r   r¬   r,   r0   r.   r/   r1   r2   )r°   Ústring_dtype_no_objectrN   r3   r6   r5   s         r7   Útest_min_empty_string_dtyper`  ¾  st   € ð #€EÜ	˜#˜ S¨sÑ3¸5Ñ	A×	FÑ	FÀrÈÐ	J€BÜ�R—Z‘Z “_ dÔ+Ó-€FÜØ�c�
 %¬r¯xªx¸À%ÈcÑ/Rñ€Hô ×Ò˜&Õ+r9   r   Útest_seriesc                 óÆ  • US:X  a  g U nUS;   a  0 nOUS;   a  SU0nOUS;   a  0 nOSU0nU[         R                  pvUS;   a  SnUS:X  a  S	OS
nO‡US;   aJ  U(       a6  US:X  a0  UR                  S:X  a   UR                  [         R                  L a  SnOSnUS:X  a  SOSnO7US;   a  S[        R
                  pvOUS:”  a  [         R                  nOUS:X  a  Sn[        S/[         R                  /S.US9nU(       a  US   OUn	[        X5      n
U	R                  US   5      n[        X±5      nUS;   a4  SU SU S3n[        R                  " [        US9   U" U
0 UD6  S S S 5        g U" U
0 UD6n[         R                  " S/SUS 9nU(       d  US:X  a  U(       d  US:X  a  S OSn[        XUUS!9nO[        SU0XöS"9n[        R                   " UU5        g ! , (       d  f       g = f)#NÚcorrwith)r   r   ry   rz   rÜ   rì   ÚstdÚvar)Úkurtr   )r³   ÚnuniqueÚquantileÚsemré   )r   r   ri   r   FT)r³   rg  ré   ré   ÚpyarrowrW   r#  r   r   )ry   rz   Úfloat64Úsumr   rû   r}   rM   r"   r!   )	rÜ   rì   rf  Úprodrh  ri  Úskewrd  re  zdtype 'z' does not support operation 'Ú'rn   r~   )r)   rN   r&   rO   )r.   rb   ÚstoragerÃ   r@   rA   r   r   r0   r,   rp   rq   rr   r/   r	   r1   rc   )r_  Úreduction_funcr   ra  rN   rv   Úexpected_dtyper¸   r3   re   Úargsr‡   r²   r”   r6   r)   r&   r5   s                     r7   Útest_string_dtype_all_nart  Ê  sþ  € ð ˜Ó#àà"€Eàð 	ó 	ð ‰Ø	˜8Ó	#Ø˜yÐ)‰Ø	ÐJÓ	JØ‰à˜yÐ)ˆà%*¬B¯E©E�NØ˜Ó'Øˆà"0°EÓ"9™¸t‰Ø	Ð7Ó	7ö Ø &Ó(Ø—‘ Ó*Ø—‘¤"§%¡%Ò'à$‰Nà$ˆNØ,°Ó6™¸A‰Ø	Ð/Ó	/Ø)2´B·F±F™Ø	�Q‹ÜŸ™‰Ø	˜5Ó	 àˆä	˜#˜¤b§e¡e WÑ-°UÑ	;€BÞ ˆ"ˆSŠ' b€CÜ" >Ó7€DØ	�‰�R˜‘WÓ	€BÜ�RÓ(€Fàð 
ó 
ð ˜�wÐ<¸^Ð<LÈAÐNˆÜ�]Š]œ9¨CÓ0Ù�DÐ#˜FÒ#÷ 1àá�TÐ$˜VÑ$€FÜ�HŠH�c�U ¨EÑ2€EÞ�n¨Ó.Þ&¨>¸VÓ+C‰tÈˆÜ˜.¸^ÐRVÑW‰ä˜c >Ð2¸%ÑVˆÜ‡O‚O�F˜HÕ%÷ 1Ô0àús   Å	GÇ
G c           	      ó"  • U n[        S/[        R                  /S.US9nUR                  S5      nUR	                  US9nUS:X  a  SO[        R                  n[        SU0[        R
                  " S/SUS	9US
9n[        R                  " XW5        g )Nrû   r}   rM   r!   r  r   r   r"   r~   rO   )r   r.   rb   r0   rl  r/   r1   r2   )r_  r   rN   r3   r‡   r6   r\  r5   s           r7   Útest_string_dtype_empty_sumrv  !  s„   € ð #€EÜ	˜#˜¤b§e¡e WÑ-°UÑ	;€BØ	�‰�C‹€BØ�V‰V˜iˆVÐ(€FØ˜q“.‰B¤b§e¡e€EÜØ	ˆeˆœBŸHšH c U°¸EÑBÈ%ñ€Hô ×Ò˜&Õ+r9   c            	      óˆ  • [        / SQ/ SQ[        [        R                  [        R                  S/5      / SQS.5      n U R	                  S5      nUS/   R                  5       nUS   R                  5       R                  5       n[        R                  " X#5        US   R                  5       R                  5       (       a   eg )N)z-04-23z-05-06z-05-07)z2013-04-23 00:00:00z2013-05-06 00:00:00z2013-05-07 00:00:00ÚOE)zlog080001.logzlog.logÚxlsx)z
Unnamed: 0ÚDateÚappÚFilerz  r|  )r   r	   r@   rA   r0   r‚   Úto_framer1   r2   r   r   )r3   r‡   Úrr  s       r7   Útest_max_nan_bugr  /  s£   € Ü	â8òô
 œ2Ÿ6™6¤2§6¡6¨4Ð0Ó1Ú8ñ		
ó
€Bð 
�‰�FÓ	€BØ
ˆFˆ8‰×ÑÓ€AØ
ˆ6‰
�‰Ó×!Ñ!Ó#€AÜ×Ò˜!ÔØ�‰y�~‰~Ó×#Ñ#×%Ñ%Ð%Ð%Ð%r9   r¾   Údropnar  Úwith_nanÚkeysÚjoeÚjimc           	      óê  • SnSn[        SSS9n[        [        R                  R	                  S5      R                  [        [        5      U5      [        R                  R	                  S5      R                  Xu5      [        R                  R	                  S5      R                  SXe5      S.5      nU(       a{  UR                  S[        05      nS UR                  S	S S
2S4'   S UR                  SS S2S4'   S UR                  SS S2S4'   S UR                  SS S2S4'   S UR                  SS S2S4'   UR                  5       n	UR                  XBU S9n
U
S   R                  US9nUR                  XBU S9n
U
S   R                  [         R                  US9nU(       d  UR#                  SS9nU(       a  [$        R&                  " X¼SS9  O[$        R(                  " X¼SS9  [$        R(                  " X‰5        g )NrC  rÇ   z
2015-08-23rË   r   r   )r„  rƒ  Újulier†  r   rê   r„  r   é%   rƒ  é   é   é   rS  )r  r¾   ©r€  T)r¯   F)Úcheck_names)r   r   r@   rÎ   rÏ   Úchoicer6  r   rë   r®   rU   ÚlocÚcopyr0   rg  Úapplyr	   Úreset_indexr1   rQ   r2   )r¾   r€  r  r�  r‚  ÚnÚmÚdaysr3   Úoriginal_dfÚgrÚleftÚrights                r7   Útest_series_groupby_nuniquer™  C  sÃ  € ð 	€AØ
€AÜ�l¨BÑ/€DÜ	ä—9‘9×(Ñ(¨Ó+×2Ñ2´4¼Ó3HÈ!ÓLÜ—9‘9×(Ñ(¨Ó+×2Ñ2°4Ó;Ü—Y‘Y×*Ñ*¨1Ó-×6Ñ6°q¸!Ó?ñ	
ó
€Bö Ø�Y‰Y˜¤Ð'Ó(ˆØ#ˆ�‰ˆqˆu�"ˆu�eˆ|ÑØ#ˆ�‰ˆqˆu�"ˆu�eˆ|ÑØ!%ˆ�‰ˆqˆu�"ˆu�gˆ~ÑØ!%ˆ�‰ˆqˆu�"ˆu�gˆ~ÑØ!%ˆ�‰ˆqˆu�"ˆu�gˆ~ÑØ—'‘'“)€KØ	�‰�D°$ˆÐ	7€BØˆg‰;×Ñ fÐÐ-€Dà	�‰�D°$ˆÐ	7€BØˆw‰K×ÑœfŸn™n°VÐÐ<€EÞØ×!Ñ! tÐ!Ð,ˆæÜ
×Ò˜t¸Ó>ä
×Ò˜d°uÒ=Ü×Ò˜"Õ*r9   c                  ó6  • [        [        S5      [        S5      [        S5      S.5      n [        [        S5      / SQ/ SQS.5      nU R                  SS	S
9R                  5       n[        R
                  " X!5        [        S5      Ul        SUR                  l        UR                  SS9nU R                  S5      R                  5       n[        R
                  " X!5        U R                  SS 05      R                  S5      R                  S	S9n[        R
                  " X!5        [        S/S-  S/S-  S.[        S5      S9nSUR                  l        U R                  SS 05      R                  S5      R                  5       n[        R
                  " X!5        g )NÚabbaccÚabxaccÚabbacxr;   Úabc)r   r   r   )r   r   r   r<   Fr  r?   rû   r‹  r   r   )r=   r>   r[   )
r   r6  r0   rg  r1   r2   r)   r&   r¯   ÚreplacerB   s      r7   Útest_nuniquer   k  sH  € Ü	œ˜h›¬d°8«nÄ4ÈÃ>ÑRÓ	S€Bäœt E›{²ÂÑKÓL€HØ�Z‰Z˜ eˆZÐ,×4Ñ4Ó6€FÜ×Ò˜&Ô+ô ˜%“[€H„NØ€H‡N�NÔØ�}‰} Sˆ}Ð)€HØ�Z‰Z˜‹_×$Ñ$Ó&€FÜ×Ò˜&Ô+ð �Z‰Z˜˜d˜Ó$×,Ñ,¨SÓ1×9Ñ9ÀÐ9ÐG€FÜ×Ò˜&Ô+ô  ˜s Q™w¨a¨S°1©WÑ5¼TÀ%»[ÑI€HØ€H‡N�NÔØ�Z‰Z˜˜d˜Ó$×,Ñ,¨SÓ1×9Ñ9Ó;€FÜ×Ò˜&Õ+r9   c                  ó$  • [        / SQ/ SQ/ SQ/ SQ/ SQ// SQS9n U R                  SS	/5      S
   R                  5       n[        R                  " U R
                  U R                  /5      n[        S/S-  S
US9n[        R                  " X5        g )N)rC  r   ÚAlice)éÈ   r   ÚBob)i,  r   ÚCharlie)ipþÿÿr�   ÚDan)rõ   r¿   ÚEdith)ÚamountrA  r&   r?   rA  r¨  r&   r   r¿   rá   )
r   r0   rg  r   Úfrom_arraysrA  r¨  r	   r1   rQ   )rJ   r6   r)   r5   s       r7   Útest_nunique_with_objectrª  „  s‡   € äâÚÚÚÚð	
ò )ñ	€Dð �\‰\˜4 Ð*Ó+¨FÑ3×;Ñ;Ó=€FÜ×"Ò" D§G¡G¨T¯[©[Ð#9Ó:€EÜ�q�c˜A‘g F°%Ñ8€HÜ×Ò˜6Õ,r9   c                  óš   • [        S[        S9n U R                  SS9R                  5       n[        SSS9n[        R
                  " X5        g )Nr&   r~   r   ©Úlevelr#  )r	   rj   r0   rg  r1   rQ   )rJ   r6   r5   s      r7   Útest_nunique_with_empty_seriesr®  —  sA   € ä�v¤VÑ,€DØ�\‰\ ˆ\Ð"×*Ñ*Ó,€FÜ˜6¨Ñ1€HÜ×Ò˜6Õ,r9   c                  ó˜  • [        [        S5      [        S5      [        S5      // SQS.5      R                  S5      n U R                  [        R
                  " SS95      S	   R                  5       nU R                  [        R
                  " SS95      S	   R                  [        R                  5      n[        R                  " X5        g )
Nz2016-06-28 09:35:35z2016-06-28 16:09:30z2016-06-28 16:46:28)r  Ú2Ú3)rß   rJ   rß   Úh)r+  rJ   )r   r
   rÀ   r0   r.   ÚGrouperrg  r�  r	   r1   rQ   ©Útestr6   r5   s      r7   Útest_nunique_with_timegrouperr¶  Ÿ  s§   € äô Ð/Ó0ÜÐ/Ó0ÜÐ/Ó0ðò
 $ñ	
ó	÷ �i�Óð 	ð �\‰\œ"Ÿ*š*¨#Ñ.Ó/°Ñ7×?Ñ?ÓA€FØ�|‰|œBŸJšJ¨CÑ0Ó1°&Ñ9×?Ñ?ÄÇÁÓO€HÜ×Ò˜6Õ,r9   zkey, data, dropna, expected)rû   rû   rû   z
2019-01-01rû   r#   r%   r,  iã  )rû   rû   rû   Úyr·  r·  )rû   rû   rû   rû   r·  c                 óŽ   • [        XS.5      nUR                  S/5      S   R                  US9n[        R                  " XS5        g )N)r#   rJ   r#   rJ   r‹  )r   r0   rg  r1   rQ   )r#   rJ   r€  r5   r3   r6   s         r7   Útest_nunique_with_NaTr¹  °  sC   € ôV 
˜3Ñ-Ó	.€BØ�Z‰Z˜˜Ó  Ñ(×0Ñ0¸Ð0Ð?€FÜ×Ò˜6Õ,r9   c                  ó  • [        / SQ[        R                  " S/SS9S9n U R                  / SQ5      R	                  5       n[        S/[
        R                  " S/5      U R                  S	9n[        R                  " X5        g )
N)r   r   r   r<   Úlevel_0r%   r?   r   r   r   )r)   r(   )
r   r.   r/   r0   rg  r@   rG   r(   r1   r2   r´  s      r7   Ú)test_nunique_preserves_column_level_namesr¼  à  s^   € ä’Y¬¯ª°#°¸YÑ(GÑH€DØ�\‰\š)Ó$×,Ñ,Ó.€FÜ˜!˜¤B§H¢H¨a¨S£M¸4¿<¹<ÑH€HÜ×Ò˜&Õ+r9   c                  ó¼   • [        [        SS5      S/S9n U R                  / SQ5      S   R                  S5      n[	        / SQSS9n[
        R                  " X5        g )	Nz
2008-12-31z
2009-01-02r  r?   )r   r   r   rg  )r   r   r   r%   )r   r   r0   Ú	transformr	   r1   rQ   rã   s      r7   Ú$test_nunique_transform_with_datetimer¿  è  sO   € ä	”:˜l¨LÓ9ÀFÀ8Ñ	L€BØ�Z‰Zš	Ó" 6Ñ*×4Ñ4°YÓ?€FÜ’i fÑ-€HÜ×Ò˜6Õ,r9   c                 óò   • [        S/5      R                  S5      nUS S nUR                  X S9nUR                  5       nU (       a  [        / US S SS9nO[        S/USS9n[        R
                  " XE5        g )Nr   r9  r   r÷   r#  rO   )r	   r®   r0   rg  r1   rQ   )rø   rà   rR   r‡   r6   r5   s         r7   Útest_empty_categoricalrÁ  ð  ss   € ä
�!�‹+×
Ñ
˜ZÓ
(€CØ
ˆbˆqˆ'€CØ	�‰�SˆÐ	,€BØ�Z‰Z‹\€FÞÜ˜" C¨¨ G°7Ñ;‰ä˜1˜# S°Ñ8ˆÜ×Ò˜6Õ,r9   c                  ó0  • [        SS[        R                  S/5      n U R                  / SQ5      nSn[        R
                  " [        US9   UR                  [        R                  5      nS S S 5        Sn[        R
                  " [        US9   UR                  [        R                  5      nS S S 5        UR                  5       n[        R                  " WU5        [        R                  " WU5        g ! , (       d  f       N�= f! , (       d  f       N^= f)Nr   r   r   )r   r   r   r   zusing SeriesGroupBy.sumrn   zusing np.sum)r	   r@   rA   r0   r1   r‘   r�   rP   r-   rl  r�  rQ   )Úsr·   r”   r6   rF  r5   s         r7   Útest_intercept_builtin_sumrÄ  ý  sÀ   € Ü��Sœ"Ÿ&™& #Ð&Ó'€AØ�i‰išÓ%€Gà
#€CÜ	×	#Ò	#¤M¸Ó	=à—‘œXŸ\™\Ó*ˆ÷ 
>ð €CÜ	×	#Ò	#¤M¸Ó	=à—-‘-¤§¡Ó-ˆ÷ 
>ð �{‰{‹}€HÜ×Ò˜6 8Ô,Ü×Ò˜7 HÕ-÷ 
>Õ	=ú÷ 
>Õ	=ús   Á C6Â DÃ6
DÄ
DrÇ   c           	      ó  • SnSn[         R                  n[        R                  " XX3X"U/SS9n[	        / SQUS.5      nUR                  S5      R                  U S9nU S	:X  aM  [	        S
[        R                  " / SQSS90[        R                  " / SQSS9S9n[        R                  " Xg5        g [	        S
[        R                  " [        R                  /S-  SS90[        R                  " / SQSS9S9n[        R                  " Xg5        g )NTFrL   rM   )r   r   r   r   r   r   r   r:  r<   r  r   r=   )r   r   r   rW   r   r%   r[   r   )r@   rA   r.   rG   r   r0   rl  r/   r1   r2   rb   )r   r"   r!   ÚnaÚdfgr3   r6   r5   s           r7   Ú!test_groupby_sum_mincount_booleanrÈ    sà   € à€AØ€AÜ	�‰€BÜ
�(Š(�A˜" !¨Ð*°)Ñ
<€Cä	Ò.°SÑ9Ó	:€BØ�Z‰Z˜‹_× Ñ ¨9Ð Ð5€FØ�Aƒ~ÜØ”"—(’(š9¨GÑ4Ð5Ü—(’(š9¨3Ñ/ñ
ˆô 	×Ò˜fÕ/äØ”"—(’(œBŸE™E˜7 Q™;¨gÑ6Ð7Ü—(’(š9¨3Ñ/ñ
ˆô 	×Ò˜fÕ/r9   c                  ó¸  • [        / SQ/ SQ/ SQS.SS9n U R                  S5      n[        R                  " / SQSSS9nUS   R	                  SS	9n[        [        R                  /S
-  SUSS9n[        R                  " X45        UR	                  SS	9n[        [        R                  /S
-  [        R                  /S
-  S.SUS9n[        R                  " X45        g )N)r   r   r   r¼   rW   rM   r!   r~   r"   r   r  r   )rN   r)   r&   )r"   r½   )rN   r)   )
r   r0   r.   r/   rl  r	   rb   r1   rQ   r2   )r3   r·   r0  r6   r5   s        r7   Ú0test_groupby_sum_below_mincount_nullable_integerrÊ  %  s¹   € ä	šªºÑCÈ7Ñ	S€BØ�j‰j˜‹o€GÜ
�(Š(’9 3¨gÑ
6€Cà�S‰\×Ñ¨ÐÐ*€FÜ”r—u‘u�g ‘k¨¸À#ÑF€HÜ×Ò˜6Ô,à�[‰[ 1ˆ[Ð%€FÜ¤§¡˜w¨™{´"·%±%°¸1±Ñ=ÀWÐTWÑX€HÜ×Ò˜&Õ+r9   c                  óŽ  • [        / SQ[        R                  " S5      [        R                  " S5      [        R                  " S5      [        R                  /S.5      n [        R                  " SS9nU R	                  S5      nUR                  5       n[        S	X/0[        R                  " S
S/SS9S9n[        R                  " X45        US	   R                  5       n[        R                  " X4S	   5        US	   R                  SS9n[        U[        R                  /SS	UR                  S9n[        R                  " X45        g )N)r   r   r   r   Ú1dÚ2dÚ3dr}   r   )r”  r!   r"   r   r   r%   r[   r  zm8[ns])rN   r&   r)   )r   r.   Ú	TimedeltaÚNaTr0   rl  r/   r1   r2   rQ   r	   r)   )r3   Útd3r‡   rÔ   r5   s        r7   Ú#test_groupby_sum_timedelta_with_natrÒ  4  sö   € ä	âÜ—,’,˜tÓ$¤b§l¢l°4Ó&8¼"¿,º,ÀtÓ:LÌbÏfÉfÐUñ	
ó
€Bô �,Š,˜AÑ
€Cà	�‰�C‹€Bà
�&‰&‹(€CÜ˜# ˜zÐ*´"·(²(¸A¸q¸6ÈÑ2LÑM€HÜ×Ò˜#Ô(à
ˆS‰'�+‰+‹-€CÜ×Ò˜3¨¡Ô.à
ˆS‰'�+‰+ ˆ+Ð
"€CÜ�sœBŸF™F�m¨8¸#ÀXÇ^Á^ÑT€HÜ×Ò˜3Õ)r9   )Úint8Úint16Úint32r#  Úfloat32rk  rV  zmethod,datar3   r}   r�   r³   r#  )r3   Úout_typec                 ó”  • [        SSS.SSS.SSS.SSS./5      nUR                  R                  U 5      US'   SU;  a  / US'   SU;   a  US   nOU nUS	   n[        U5      nUR                  R                  U5      US'   UR                  S
SS9  UR	                  S
5      n[        Xq5      " US   6 n[        R                  " X†5        g )Nr   r}   r   r   r�   r"   rs  r×  r3   r!   T)Úinplace)r   r"   r®   rÀ   r0   r,   r1   r2   )	rN   r²   rJ   r3   r×  r4   Údf_outÚgrpdÚts	            r7   Ú%test_groupby_non_arithmetic_agg_typesrÝ  L  s×   € ô 
Ø�qÑ	 ¨Ñ+°1¸1Ñ-=ÀQÈQÑ?OÐPó
€Bð �d‰d�k‰k˜%Ó €B€s�Gà�TÓØˆˆV‰à�TÓØ˜
Ñ#‰àˆà
ˆt‰*€CÜ�s‹^€Fà—(‘(—/‘/ (Ó+€Fˆ3�KØ
×Ñ�S $ÐÑ'à�:‰:�c‹?€DÜ�Ô˜t F™|Ð,€AÜ×Ò˜!Õ$r9   c                  ó"   • SSK Jn  U" U SS0UD6$ )Nr   )ri  Úddofr   )Úscipy.statsri  )rs  rv   ri  s      r7   Ú	scipy_semrá  t  s   € Ýá�Ð'˜1Ð' Ñ'Ð'r9   z	op,targoprÜ   rì   rd  re  rl  rm  c                 ó    • U R                   S   $ )Nr   ©r¬   rú   s    r7   rü   rü   …  s   € ˜AŸF™F 1šIr9   c                 ó    • U R                   S   $ )Néÿÿÿÿrã  rú   s    r7   rü   rü   †  s   € ˜1Ÿ6™6 "š:r9   ri  Úscipy)Úmarksc                 ó$  • [        [        R                  R                  S5      R	                  S5      5      n[        R                  R                  S5      R                  SSSS9R                  [        5      n[        UR                  U5      U 5      " 5       nU S;   a  S O[        nSU  3n[        R                  " XVS9   UR                  U5      R                  U5      nS S S 5        [        R                  " UW5        g ! , (       d  f       N&= f)	Nr   ræ   r   rç   rè   )r´   rµ   r³   ri  zusing DataFrameGroupBy.rn   )r   r@   rÎ   rÏ   rÐ   rë   r®   rU   r,   r0   r�   r1   r‘   rP   r2   )ÚopÚtargopr3   rï   r6   r“   r”   r5   s           r7   Útest_ops_generalrë  z  sÑ   € ô$ 
”2—9‘9×(Ñ(¨Ó+×;Ñ;¸DÓAÓ	B€BÜ�Y‰Y×"Ñ" 1Ó%×.Ñ.¨q°"¸4Ð.Ð@×GÑGÌÓN€Fä�R—Z‘Z Ó'¨Ô,Ó.€FØÐ:Ó:‰4Ä€DØ# B 4Ð
(€CÜ	×	#Ò	# DÓ	4Ø—:‘:˜fÓ%×)Ñ)¨&Ó1ˆ÷ 
5ä×Ò˜& (Õ+÷ 
5Õ	4ús   Ã !DÄ
Dr•   )	r   r   r   r   r   r   r   r   r   )r   r   r   r   r   r   )r   r   r   r   r   r   Úfunction)rÜ   rì   re  c                 ó  • US:X  a  SOSn[         R                  " U/S-  [        S9n[        R                  " / SQSSS	9n[        S
U0US9R                  S5      n[        U SS9R                  S5      n[        Xa5      " 5       n[        R                  " Xu5        UR                  U5      n[        R                  " Xu5        UR                  U/5      n[        R                  " S
U4/5      Ul        [        R                  " Xu5        g )Nre  g      à?g      ø?r   rM   r   r!   rW   r~   r"   r[   rV   )r@   rG   rU   r.   r/   r   r®   r0   r,   r1   r2   rP   r   Úfrom_tuplesr(   )r•   rì  Úoutputrî   r0  r5   r/  r6   s           r7   Ú,test_apply_to_nullable_integer_returns_floatrð  —  sÛ   € ð  Ó%‰S¨3€FÜ
�(Š(�F�8˜a‘<¤uÑ
-€CÜ
�(Š(’9 3¨gÑ
6€CÜ˜#˜s˜¨3Ñ/×6Ñ6°yÓA€Hä�v WÑ-×5Ñ5°cÓ:€Fä�VÔ&Ó(€FÜ×Ò˜&Ô+à�Z‰Z˜Ó!€FÜ×Ò˜&Ô+à�Z‰Z˜˜
Ó#€FÜ!×-Ò-°°X¨Ð.?Ó@€HÔÜ×Ò˜&Õ+r9   ré  )
rl  rm  r�   r‚   rì   rÜ   rn  rd  re  ri  rÊ   r+   c                 ój  ^ ^^• [        S/5      nTS:X  a  UnSnOUR                  nSn[        R                  " [        US9   UR                  STUS9nS S S 5        T S:X  aa  [        WT 5      " TS9nUR                  SS9R                  UU U4S	 j5      n	U(       a  U	R                  TS
9n	[        R                  " X‰5        g [        WT 5      " 5       nUR                  SS9R                  UU 4S j5      n	U(       a  U	R                  TS
9n	[        R                  " X‰5        g ! , (       d  f       NÖ= f)Nr   zAThe 'axis' keyword in DataFrame.groupby is deprecated and will bez+DataFrame.groupby with axis=1 is deprecatedrn   )r­  rÊ   r¾   rn  r*   r¬  c                 ó&   >• [        U T5      " TTS9$ )N)rÊ   r+   ©r,   )r²  rÊ   ré  r+   s    €€€r7   rü   Ú3test_regression_allowlist_methods.<locals>.<lambda>Û  s   ø€ ”g˜a ”n¨$°vÒ>r9   rÉ   c                 ó$   >• [        U T5      " TS9$ )NrÉ   ró  )r²  rÊ   ré  s    €€r7   rü   rô  â  s   ø€ ¼'À!ÀR¼.ÈdÒ:Sr9   )
r   ÚTr1   r‘   r�   r0   r,   r�  rÁ   r2   )
ré  rÊ   r+   r¾   Ú	raw_frameÚframer”   r·   r6   r5   s
   ```       r7   Ú!test_regression_allowlist_methodsrù  ¶  s  ú€ ô, ˜1˜#“€IØˆqƒyØˆØQ‰à—‘ˆØ;ˆä	×	#Ò	#¤M¸Ó	=Ø—-‘- a¨d¸�-Ð>ˆ÷ 
>ð 
ˆVƒ|ä˜ "Ô%¨VÑ4ˆØ—=‘= q�=Ð)×/Ñ/Þ>ó
ˆö Ø×*Ñ*°Ð*Ð5ˆHÜ
×Ò˜fÕ/ä˜ "Ô%Ó'ˆØ—=‘= q�=Ð)×/Ñ/Õ0SÓTˆÞØ×*Ñ*°Ð*Ð5ˆHÜ
×Ò˜fÕ/÷# 
>Õ	=ús   ÁD$Ä$
D2c                  ó  • SS/SS/SS/SS/SS/SS/SS/SS	/SS
/SS/SS/SS/SS/SS//n [        U SS/SS9nUR                  S/5      R                  5       R                  5       n[        S/S/S.SS9n[        R
                  " X#5        g )Nr   r  é)   rê   r‡  rˆ  é   é   r   r   é+   r¿   é/   r‰  éX   r<   r=   r#  )r(   rN   l   �N+R@r:  rM   )r   r0   rm  r‘  r1   r2   )rJ   r3   r6   r5   s       r7   Ú"test_groupby_prod_with_int64_dtyper  è  sÈ   € ð 
ˆBˆØ	
ˆBˆØ	
ˆBˆØ	
ˆBˆØ	
ˆAˆØ	
ˆBˆØ	
ˆBˆØ	
ˆAˆØ	
ˆAˆØ	
ˆBˆØ	
ˆAˆØ	
ˆBˆØ	
ˆBˆØ	
ˆBˆð€Dô  
�4 # s °7Ñ	;€BØ�Z‰Z˜˜Ó×#Ñ#Ó%×1Ñ1Ó3€FÜ ˜sÐ*<Ð)=Ñ>ÀgÑN€HÜ×Ò˜&Õ+r9   )jr-   Údatetimerª   Ústringr   Únumpyr@   rp   Úpandas._libs.tslibsr   Úpandas.core.dtypes.commonr   Úpandas.core.dtypes.missingr   Úpandasr.   r   r   r	   r
   r   r   Úpandas._testingÚ_testingr1   Úpandas.tests.groupbyr   Úpandas.utilr   ÚtdÚmarkÚparametrizerA   r8   rC   rI   rb   rT   rG   ri   r`   rg   rÐ  rl   rs   rw   rˆ   r–   r±   r¹   rÅ   rØ   rÝ   rä   rò   r  r
  r  r  r$  r&  r1  r3  r7  Ústrr=  rN  rX  r]  r`  rt  rv  r  Úslowr™  r   rª  r®  r¶  r/   r  r¹  r¼  r¿  rÁ  rÄ  rÈ  rÊ  rÒ  rÝ  rá  rÜ   rì   rd  re  rl  rm  r�   r‚   ré   ÚparamÚ
skip_if_norë  rð  rù  r  ru   r9   r7   Ú<module>r     sð  ðÛ Û Ý "ã Û å $å 2Ý 9ã ÷÷ õ Ý 8Ý .ð ‡�×Ñ˜ e¨U ^Ó4Ø‡�×ÑØ
âÚÚÚÚÚÚÚÚÚÚÚØ	�‰�—‘˜Ÿ™Ð ðóñ$,ó%ó 5ð&,ò"
,ð ‡�×Ñ˜¨5°%¨.Ó9ñ,ó :ð,ð ‡�×Ñ˜¨5°%¨.Ó9Ø‡�×ÑØ
âÚØ	�‰�—‘�r—u‘uÐØ	�—‘�uÐØ	ˆr�u‰u�dÐØ	ˆr�u‰u�eÐðó
ñ
-ó
ó :ð
-ð ‡�×ÑØ%ð ØØ�HŠH�d�V 4Ñ(Ø�HŠH�b—e‘e�W IÑ.ð		
ð ØØ�HŠH�b—e‘e�W IÑ.Ø�HŠH�d�V 4Ñ(ð		
ð ØØ�HŠH�b—e‘e�W IÑ.Ø�HŠH�b—e‘e�W IÑ.ð		
ð ØØ�HŠH�b—e‘e�W IÑ.Ø�HŠH�b—e‘e�W IÑ.ð		
ð'óñ:	,ó;ð:	,ð ‡�×Ñ˜¨5°%¨.Ó9Ø‡�×Ñ˜Ò"AÓBñ	&ó Có :ð	&ð ‡�×ÑØ%à	�—‘˜Ÿ™� Ð'Ø	�—‘˜˜2Ÿ6™6Ð" DÐ)Ø	�—‘˜Ÿ™� Ð&Ø	�—‘˜˜rŸv™vÐ&¨Ð.ð	óñ&óð&ð ‡�×Ñ˜¨5°%¨.Ó9ñ:ó :ð:ð ‡�×Ñ˜¨5°%¨.Ó9ñ&ó :ð&ð ‡�×Ñ˜ ¨8Ð 4Ó5ñ,ó 6ð,ð( ‡�×Ñ˜ ¨8Ð 4Ó5ñ%,ó 6ð%,ðP ‡�×ÑØà	˜a ˜V°°A°À1ÀaÀ&ÑIÐJØ	˜a ˜V°°A°À1ÀaÀ&ÑIÐJðóð ‡�×Ñ˜¨$°¨Ó7ñ,ó 8óð,ð@ ‡�×ÑØ
ñ Ð2Ó3ÙÐ2Ó3ð	
ð 	/ðó	ð ‡�×Ñ˜Ò#KÓLñ,ó Mó	ð,ð& ‡�×Ñ˜ ¨&Ð 1Ó2ñ,ó 3ð,ò6ò4Pò-ò"ò,,òò",ò>-ò$?ò(?ð ‡�×Ñ˜ %¨ Ó0ñ
-ó 1ð
-ð ‡�×Ñ˜ %¨ Ó0ñ
,ó 1ð
,ò,ð< ‡�×Ñ˜ %¨ Ó0ð
,°ó 
,ó 1ð
,ð ‡�×Ñ˜Ò"UÓVñ,/ó Wð,/ò^)ð" ‡�×Ñ˜Ò!@ÓAñ,ó Bð,ð, ‡�×Ñ˜ %¨ Ó0ñ,ó 1ð,ð ‡�×Ñ˜ q¨! fÓ-Ø‡�×Ñ˜¨¨u¨Ó6ñR&ó 7ó .ðR&ðj ‡�×Ñ˜ q¨! fÓ-ñ
,ó .ð
,ò&ð( ‡�×ÑØ‡�×Ñ˜ %¨ Ó/Ø‡�×Ñ˜ E¨4 =Ó1Ø‡�×Ñ˜ d¨E ]Ó3Ø‡�×Ñ˜ d¨E ]Ó3Ø‡�×Ñ˜ 5 '¨E°5¨>Ð!:Ó;ñ+ó <ó 4ó 4ó 2ó 0ó ð+òD,ò2-ò&-ò-ð" ‡�×ÑØ!ò Ù�|Ó$ b§f¡f©i¸Ó.EÐFØÙ�A�3˜bŸhšh¨ u°5Ñ9ÀÑGð		
ò Ø�WŠW�T˜1˜aÓ  "§&¡&¨"¯'ª'°$¸¸1Ó*=Ð>ØÙ�A�3˜bŸhšh¨ u°5Ñ9ÀÑGð		
ò &à—’˜˜a Ó#Ø—‘Ø—’˜˜a Ó#Ø—‘Ø—’˜˜a Ó#ðð Ù�A�q�6 §¢¨3°¨*¸5Ñ!AÈÑOð	
ò &à—’˜˜a Ó#Ø—‘Ø—’˜˜a Ó#Ø—‘Ø—’˜˜a Ó#ðð Ù�A�q�6 §¢¨3°¨*¸5Ñ!AÈÑOð	
ð3%ó(ñR-óS(ðR-ò,ò-ò
-ò.ð" ‡�×Ñ˜ q¨" gÓ.ñ0ó /ð0ò,,ò*ð0 ‡�×ÑØÒPóð ‡�×ÑØà	�4 ¨Ñ*°!¸!Ñ,<Ð=Ð>Ð?Ø	�$˜q qÑ)°¸Ñ+;Ð<Ð=Ð>Ø	�˜a aÑ(°¸Ñ*:Ð;Ð<Ð=Ø	�˜a aÑ(°¸Ñ*:Ð;Ð<Ð=Ø	 ¨Ñ*°!¸!Ñ,<Ð=È7ÑSÐTðó	ñ%ó	óð%ò6(ð ‡�×ÑØà	�—‘ÐØ	�2—9‘9ÐØ	�—‘ˆØ	�—‘ˆØ	�—‘ˆØ	�—‘ÐØ	�—‘ˆØ	�—‘ˆØ	Ñ%Ð&Ø	Ñ%Ð&Ø	�"—'‘'ÐØ�Š�U˜I¨R¯]ª]¸7Ó-CÑDðóñ"	,ó#ð"	,ð ‡�×ÑØò -Ø�R—U‘U˜A˜q "§%¡%¨¨A¨r¯u©u°aÐ8ñ	
ò !Ò'9Ñ:ðó	ð ‡�×Ñ˜Ò%>Ó?ñ,ó @ó	ð,ð( ‡�×ÑØòóð ‡�×Ñ˜ ! Q Ó(Ø‡�×Ñ˜ D¨% =Ó1Ø‡�×Ñ˜ $¨ Ó/ñ0ó 0ó 2ó )óð$0ó@,r9   