ó
    ­œ‘h¡© ã                   óî  • S SK J r   S SKrS SKJr  S SKrS SKrS SKrS SKJrJ	r	  S SK
Js  Jr  S SKrS SKJrJrJrJrJrJrJrJrJrJrJrJr  S SKJr  S SKJ r   S SK!J"s  J#r$  \RJ                  RM                  S5      r'S r(S	 r)\RJ                  RU                  S
/ SQ5      S 5       r+S r,S r-S r.S r/\RJ                  RU                  SSS/5      S 5       r0S r1S r2S r3\RJ                  RU                  S
/ SQ5      S 5       r4S r5S r6S r7S r8S r9S r:S  r;S! r<S" r=\RJ                  RU                  S#S$ S% /5      S& 5       r>S' r?S( r@S) rAS* rBS+ rCS, rDS- rES. rFS/ rGS0 rHS1 rIS2 rJS3 rK\RJ                  RU                  S4S5S6/5      S7 5       rL\RJ                  RU                  S4/ S8Q5      \RJ                  RU                  S9SS/5      S: 5       5       rMS; rNS< rOS= rPS> rQS? rRS@ rSSA rTSB rUSC rVSD rWSE rXSF rYSG rZSH r[SI r\SJ r]SK r^SL r_SM r`SN raSO rbSP rcSQ rdSR reSS rfST rgSU rhSV riSW rjSX rkSY rlSZ rmS[ rnS\ roS] rpS^ rqS_ rrS` rsSa rt\RJ                  RU                  SbScScSd//5      Se 5       ruSf rvSg rwSh rxSi rySj rzSk r{Sl r|Sm r}\RJ                  RU                  SnSoSpSqSoSp/SoSq//5      \RJ                  RU                  SrSsStSsSt//5      Su 5       5       r~Sv r\RJ                  RU                  SwSxSx//5      \RJ                  RU                  SySc/ScSd//5      \RJ                  RU                  SzS/S /S{/S|/\" S /5      \" S 5      /\" S S}S}S~S9\GR                   " S€S�S‚Sƒ9\GR                  " S /S„S…9\GR                  " S /S†S…9\GR                  " S/S‡S…9// SˆQS‰9\RJ                  RU                  SŠ/ S‹Q5      \RJ                  RU                  S#/ SŒQ5      S� 5       5       5       5       5       r‚SŽ rƒS� r„S� r…S‘ r†S’ r‡S“ rˆS” r‰S• rŠ\RJ                  RU                  S–S—S—//5      S˜ 5       r‹\RJ                  RU                  S™SšS›SS\" Sœ5      \" S�5      SS/04SžS›\" Sœ5      \" S�5      \" SŸ5      \" S 5      \" SŸ5      \" S 5      /04S¡S›\" Sœ5      \" S�5      \" Sœ5      \" S�5      \" SŸ5      \" S 5      /04/5      S¢ 5       rŒS£ r�S¤ rŽS¥ r�S¦ r�S§ r‘\RJ                  RU                  S¨/ S©Q5      Sª 5       r’S« r“\RJ                  RU                  S¬\S­S|4\SS4\S®S4\S¯S4\S°S4\S±S4\S­S|4\SS4\S®S4\S¯S4\S°S4\S±S4/5      S² 5       r”S³ r•\RJ                  RU                  S´/ SµQ5      S¶ 5       r–\RJ                  RU                  S·S\GR.                  " S\GR0                  " S¸5      S¹9/5      Sº 5       r™S» rš\RJ                  RU                  S¼S½S¾S¿/4SÀSÁSÂ/4/5      SÃ 5       r›SÄ rœSÅ r�SÆ ržSÇ rŸSÈ r \RJ                  RU                  S9SS/5      SÉ 5       r¡SÊ r¢SË r£SÌ r¤SÍ r¥SÎ r¦SÏ r§SÐ r¨SÑ r©SÒ rª\RJ                  RU                  SÓSS|S|//5      SÔ 5       r«SÕ r¬\RJ                  RU                  SÖS /S4S×S /S4SØ/5      SÙ 5       r­\RJ                  RU                  S´/ SÚQ5      SÛ 5       r®\RJ                  RU                  SÜSÝSÞ/5      Sß 5       r¯\RJ                  RU                  SàSáSâ/5      Sã 5       r°\RJ                  RU                  SäSåS\GRb                  4/5      Sæ 5       r²\RJ                  RU                  Sç/ SèQ/ SéQ/ SêQ4/ SëQ/ SìQ/ SíQ4/5      Sî 5       r³\RJ                  RU                  Sï/ SðQ5      Sñ 5       r´\RJ                  RM                  Sò5      \RJ                  RU                  SŠ/ SóQ5      Sô 5       5       rµSõ r¶Sö r·\RJ                  RU                  S9SS/5      S÷ 5       r¸\RJ                  RM                  Sø5      Sù 5       r¹\RJ                  RU                  SúS}S|/5      Sû 5       rº\RJ                  RU                  SŠ/ SüQ5      Sý 5       r»Sþ r¼Sÿ r½GS  r¾\RJ                  RU                  GSSS/5      \RJ                  RU                  GSGSGSS|/S}\¿4GSS|/GSS4GSS­S /S}\¿4S­S /GSS4/5      GS 5       5       rÀGS rÁGS	 rÂGS
 rÃ\RJ                  RU                  GSSS/5      GS 5       rÄg(  é    )ÚdatetimeN)ÚDecimal)ÚPerformanceWarningÚSpecificationError)ÚCategoricalÚ	DataFrameÚGrouperÚIndexÚIntervalÚ
MultiIndexÚ
RangeIndexÚSeriesÚ	TimedeltaÚ	TimestampÚ
date_rangeÚto_datetime)ÚBooleanArrayz)ignore:Mean of empty slice:RuntimeWarningc                  ó<   • [        [        SSS95      n SnX:X  d   eg )NÚAÚB)ÚkeyÚlevelz<Grouper(key='A', level='B', axis=0, sort=False, dropna=True))Úreprr	   )ÚresultÚexpecteds     ÚeC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/groupby/test_groupby.pyÚ	test_reprr   %   s$   € ä”'˜c¨Ñ-Ó.€FØM€HØÓÐÑó    c                 óF  • [         R                  " SSS9n[        U5      nUS S S2==   S-  ss'   UR                  S5      R	                  5       nU[        S5      -   US'   U[        SS	S
9-   US'   [         R                  UR                  S'   UR                  [        [        S5      5      S-  5      nUR                  5       n[        S5      n[        S5      n[        US-  XfXg/[        R                  " S5      S9n[        XˆUS.5      n	[         R"                  " XY5        g )Nz1 Dayé'  ©Úperiodsé   é   r   r   r   ÚUTC©ÚtzÚCéÿÿÿÿiÐ  z2887 days 11:21:02.326710176z2886 days 00:42:34.664668096©Úindex©r   r   r(   )ÚpdÚtimedelta_ranger   Úto_frameÚcopyr   ÚNaTÚilocÚgroupbyÚlistÚrangeÚstdr   ÚnpÚaranger   ÚtmÚassert_frame_equal)
Úwarn_copy_on_writeÚtdiÚserÚdfÚgbr   Útd1Útd4Úexp_serr   s
             r   Útest_groupby_std_datetimelikerC   ,   s÷   € ä
×
Ò
˜W¨eÑ
4€CÜ
�‹+€CØ‰ˆ!ˆƒH��MƒHà	�‰�cÓ	×	Ñ	Ó	!€Bà”I˜a“LÑ €B€s�GØ”I˜a EÑ*Ñ*€B€s�GÜ—&‘&€B‡G�GˆB�Kà	�‰”Dœ˜q›“N TÑ)Ó	*€Bà�V‰V‹X€Fô Ð2Ó
3€CÜ
Ð2Ó
3€CÜ�c˜A‘g˜s¨Ð2¼"¿)º)ÀA»,ÑG€GÜ˜w¸7ÑCÓD€HÜ×Ò˜&Õ+r   Údtype)Úint64Úint32Úfloat64Úfloat32c                 ó¤  ^• [        [        R                  " S5      S-  [        R                  " S5      U S9n[        R                  " S5      n[        R                  R	                  S5      R                  U5        UR                  U5      nUR                  S SS9nU H  u  pE[        U5      S:X  a  M   e   Sn[        R                  " [        US	9   UR                  [        R                  5      nS S S 5        WS
   S
:X  d   eSn[        R                  " [        US	9   UR                  [        R                  5      nS S S 5        [        R                  " UW5        [        R                  " XsR                  5       5        UR!                  5       n	Sn[        R                  " [        US	9   UR                  [        R                   5      nS S S 5        [        R                  " X˜5        UR#                  S 5      nUR%                  S 5      n
U
S   S:X  d   e[        R                  " X¨5        UR                  U5      nSn[        R                  " [        US	9   UR                  [        R                  5      n	S S S 5        [        R                  " X—SS9  Sn[        R                  " [        US	9   UR                  [        R                  [        R&                  /5      nS S S 5        Sn[(        R*                  " [,        US	9   UR                  [        R                  [        R&                  S.5        S S S 5        SSSS.mSn[        R                  " [        US	9   UR                  U4S j5      nS S S 5        US
   S:X  d   eSn[(        R*                  " [.        US	9   UR                  S 5        S S S 5        g ! , (       d  f       GN×= f! , (       d  f       GN›= f! , (       d  f       GN= f! , (       d  f       GN‚= f! , (       d  f       GN,= f! , (       d  f       Né= f! , (       d  f       N»= f! , (       d  f       g = f)Né	   é   ©r+   rD   r$   c                 ó   • U S-  $ ©NrK   © ©Úxs    r   Ú<lambda>Ú)test_basic_aggregations.<locals>.<lambda>O   s   €  Q¨!¢Vr   F©Ú
group_keyszusing SeriesGroupBy.mean©Úmatché   zusing SeriesGroupBy.sumc                 ó&   • X R                  5       -  $ ©N©ÚsumrP   s    r   rR   rS   d   s   €  q¯5©5«7¢{r   c                 ó&   • X R                  5       -  $ rZ   r[   rP   s    r   rR   rS   e   s   € ¨a·%±%³'ªkr   é   é   ©Úcheck_index_typezusing SeriesGroupBy.[mean|std]únested renamer is not supported)ÚoneÚtwoé
   é   é   ©r   rX   r$   z„Pinning the groupby key to each group in SeriesGroupBy.agg is deprecated, and cases that relied on it will raise in a future versionc                 óD   >• TU R                      U R                  5       -   $ rZ   )ÚnameÚmean)rQ   Úgroup_constantss    €r   rR   rS      s   ø€  o°a·f±fÑ&=ÀÇÁÃÒ&Hr   é   zMust produce aggregated valuec                 ó   • U S-  $ ©Nr$   rO   rP   s    r   rR   rS   †   s   €  A¨¢Er   )r   r7   r8   ÚrandomÚdefault_rngÚshuffleÚreindexr3   Úlenr9   Úassert_produces_warningÚFutureWarningÚ	aggregaterk   ÚaggÚassert_series_equalr\   ÚapplyÚ	transformr6   ÚpytestÚraisesr   Ú	Exception)rD   Údatar+   ÚgroupedÚkÚvÚmsgÚaggedr   r   ÚtransformedÚvalue_groupedrl   s               @r   Útest_basic_aggregationsr‡   G   s"  ø€ ä”"—)’)˜A“, !Ñ#¬2¯9ª9°Q«<¸uÑE€Dä�IŠI�a‹L€EÜ‡I�I×Ñ˜!Ó×$Ñ$ UÔ+Ø�<‰<˜Ó€Dà�l‰lÑ+¸ˆlÐ>€Gã‰ˆÜ�1‹v˜�{Ðˆ{ñ ð %€CÜ	×	#Ò	#¤M¸Ó	=Ø×!Ñ!¤"§'¡'Ó*ˆ÷ 
>à�‰8�q‹=Ðˆ=à
$€CÜ	×	#Ò	#¤M¸Ó	=Ø—;‘;œrŸw™wÓ'ˆ÷ 
>ä×Ò˜5 (Ô+Ü×Ò˜5§,¡,£.Ô1Ø�[‰[‹]€FØ
#€CÜ	×	#Ò	#¤M¸Ó	=Ø—;‘;œrŸv™vÓ&ˆ÷ 
>ä×Ò˜6Ô,à�}‰}Ñ2Ó3€HØ×#Ñ#Ñ$9Ó:€KØ�q‰>˜RÓÐÐÜ×Ò˜;Ô1à—L‘L Ó&€MØ
$€CÜ	×	#Ò	#¤M¸Ó	=Ø×(Ñ(¬¯©Ó1ˆ÷ 
>ä×Ò˜6¸5ÒAð +€CÜ	×	#Ò	#¤M¸Ó	=Ø×!Ñ!¤2§7¡7¬B¯F©FÐ"3Ó4ˆ÷ 
>ð -€CÜ	�ŠÔ)°Ó	5Ø×Ñ¤"§'¡'´"·&±&Ñ9Ô:÷ 
6ð  ¨Ñ+€Oð	Eð ô 
×	#Ò	#¤M¸Ó	=à—‘ÔHÓIˆ÷ 
>ð �‰8�r‹>Ðˆ>ð *€Cä	�Š”y¨Ó	,Ø×Ñ™/Ô*÷ 
-Ð	,÷a 
>Ö	=ú÷
 
>Ö	=ú÷ 
>Ö	=ú÷ 
>Ö	=ú÷ 
>Ö	=ú÷ 
6Õ	5ú÷ 
>Õ	=ú÷ 
-Õ	,ús`   Ã OÄ# OÆ1 O)É  O;Ê80PÌ1PÍ%P0Î)QÏ
OÏ
O&Ï)
O8Ï;
P
Ð
PÐ
P-Ð0
P>Ñ
Qc                 ó¦  • U R                   R                  S   nU R                  U5      nUR                  5       nU R                  UR	                  S5      5      R                  5       nUR                   R
                  [        R                  :X  d   eUR                   R
                  [        R                  :X  d   e[        R                  " X4SS9  g )Nr   ÚOFr`   )r+   Úcodesr3   r\   ÚastyperD   r7   Úint8rE   r9   r:   )Ú multiindex_dataframe_random_datar   r€   r   r   s        r   Útest_groupby_nonobject_dtyperŽ   ‰   sœ   € Ø
*×
0Ñ
0×
6Ñ
6°qÑ
9€CØ.×6Ñ6°sÓ;€GØ�[‰[‹]€Fà/×7Ñ7¸¿
¹
À3»ÓH×LÑLÓN€HØ�<‰<×Ñ¤§¡Ó(Ð(Ð(Ø�>‰>×Ñ¤2§8¡8Ó+Ð+Ð+Ü×Ò˜&¸UÓCr   c            
      ó<  • [        / SQ/ SQ[        R                  R                  S5      R	                  S5      [        R
                  " [        R                  R                  S5      R	                  S5      SS9S.5      n [        [        U 5      5      U S'   S	 nS
n[        R                  " [        US9   U R                  S5      R                  U5      nS S S 5        WR                  nU R                  n[        R                  " XE5        g ! , (       d  f       N== f)N©ÚfooÚbarr‘   r’   r‘   r’   r‘   r‘   )rc   rc   rd   Úthreerd   rd   rc   r“   r$   é   rH   ©rD   ©r   r   r(   ÚDÚvaluec                 óB   • U R                   U S   R                  5          $ )Nr˜   )ÚlocÚidxmax©Úgroups    r   Ú	max_valueÚ5test_groupby_nonobject_dtype_mixed.<locals>.max_value    s   € Ø�y‰y˜˜w™×.Ñ.Ó0Ñ1Ð1r   ú7DataFrameGroupBy.apply operated on the grouping columnsrV   r   )r   r7   rp   rq   Ústandard_normalÚarrayr5   rt   r9   ru   rv   r3   rz   Údtypesry   )r>   rž   rƒ   Úappliedr   r   s         r   Ú"test_groupby_nonobject_dtype_mixedr¥   ”   sÒ   € ä	âIÚMÜ—‘×&Ñ& qÓ)×9Ñ9¸!Ó<Ü—’œ"Ÿ)™)×/Ñ/°Ó2×BÑBÀ1ÓEÈYÑWñ		
ó
€Bô œ˜B›“.€B€w�Kò2ð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—*‘*˜S“/×'Ñ'¨	Ó2ˆ÷ 
>à�^‰^€FØ�y‰y€HÜ×Ò˜6Õ,÷	 
>Õ	=ús   Â5!DÄ
Dc            	      ó  • [        / SQ[        [        R                  " S5      SS9[	        SSS9S.5      n S nU R                  S	5      R                  5       S
/   nSn[        R                  " [        US9   U R                  S	5      R                  U5      S
/   nS S S 5        [        R                  " WU5        S nSn[        R                  " [        US9   U R                  S	5      R                  U5      S
/   nS S S 5        UR                  5       n[        R                  UR                  S'   [        R                  " XF5        S nSn[        R                  " [        US9   U R                  S	5      R                  U5      S
/   nS S S 5        UR                  5       n[        R                  UR                  S'   [        R                  " XF5        S nSn[        R                  " [        US9   U R                  S	5      R                  U5      S/   nS S S 5        U R                  S	5      R                  5       S/   n[        R                   UR                  S'   [        R                  " XF5        S n	Sn[        R                  " [        US9   U R                  S	5      R                  U	5      nS S S 5        U R                  S	5      R                  5       S   R                  5       n[        R                  UR                  S'   S Ul        [        R$                  " XF5        g ! , (       d  f       GN•= f! , (       d  f       GNE= f! , (       d  f       GNÉ= f! , (       d  f       GNM= f! , (       d  f       NÁ= f)N)ÚTigerr§   r§   ÚLambr¨   ÚPonyr©   r^   rE   r•   Ú20130101r!   r,   c                 ó    • U R                   S   $ ©Nr   )r2   ©Úgrps    r   Úf_0Ú*test_inconsistent_return_type.<locals>.f_0¶   s   € Ø�x‰x˜‰{Ðr   r   r   r    rV   c                 óB   • U R                   S:X  a  g U R                  S   $ )Nr§   r   ©rj   r2   r­   s    r   Úf_1Ú*test_inconsistent_return_type.<locals>.f_1¿   s   € Ø�8‰8�wÓØØ�x‰x˜‰{Ðr   r§   c                 óB   • U R                   S:X  a  g U R                  S   $ ©Nr©   r   r²   r­   s    r   Úf_2Ú*test_inconsistent_return_type.<locals>.f_2Ë   ó   € Ø�8‰8�vÓØØ�x‰x˜‰{Ðr   r©   c                 óB   • U R                   S:X  a  g U R                  S   $ r¶   r²   r­   s    r   Úf_3Ú*test_inconsistent_return_type.<locals>.f_3Ø   r¹   r   r(   c                 ó\   • U R                   S:X  a  g U R                  S   R                  S   $ )Nr©   r   r(   )rj   r2   rš   r­   s    r   Úf_4Ú*test_inconsistent_return_type.<locals>.f_4å   s(   € Ø�8‰8�vÓØØ�x‰x˜‰{�‰˜sÑ#Ð#r   )r   r   r7   r8   r   r3   Úfirstr9   ru   rv   rz   r:   r0   Únanrš   r-   r1   rj   ry   )
r>   r¯   r   rƒ   r   r³   Úer·   r»   r¾   s
             r   Útest_inconsistent_return_typerÃ   «   s¤  € ô 
âLÜœŸ	š	 !›¨GÑ4Ü˜J°Ñ2ñ	
ó
€Bòð �z‰z˜#‹×$Ñ$Ó&¨ uÑ-€HØ
C€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×&Ñ& sÓ+¨S¨EÑ2ˆ÷ 
>ä×Ò˜& (Ô+òð
 D€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×&Ñ& sÓ+¨S¨EÑ2ˆ÷ 
>à�‰‹€AÜ—V‘V€A‡E�Eˆ'�NÜ×Ò˜&Ô$òð
 D€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×&Ñ& sÓ+¨S¨EÑ2ˆ÷ 
>à�‰‹€AÜ—F‘F€A‡E�Eˆ&�MÜ×Ò˜&Ô$òð
 D€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×&Ñ& sÓ+¨S¨EÑ2ˆ÷ 
>à
�
‰
�3‹×ÑÓ  Ñ&€AÜ—F‘F€A‡E�Eˆ&�MÜ×Ò˜&Ô$ò$ð
 D€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×&Ñ& sÓ+ˆ÷ 
>à
�
‰
�3‹×ÑÓ Ñ$×)Ñ)Ó+€AÜ—F‘F€A‡E�Eˆ&�MØ€A„FÜ×Ò˜6Õ%÷k 
>Ö	=ú÷ 
>Ö	=ú÷ 
>Ö	=ú÷ 
>Ö	=ú÷ 
>Õ	=ús<   Á7%L*Ã%L<Å'%MÇ5%M Ê!M2Ì*
L9Ì<
MÍ
MÍ 
M/Í2
N c                 óf  • SS jnS nU R                  S 5      nUR                  [        R                  SSS9nUR	                  [        R                  SSS9nUR                  [        R                  SSS9nUR                  S5      nUR                  U5      n	[        R                  " Xh5        [        R                  " XX5        [        R                  " Xy5        UR                  USS9nUR	                  USS9nUR                  USS9n[        R                  " XX5        [        R                  " Xh5        [        R                  " Xy5        S	 GHô  n
UR                  S
 U
S9nU
(       a  S O[        nSn[        R                  " XÍS9   UR                  [        R                  SSS9nS S S 5        [        R                  " XÍS9   UR	                  [        R                  S5      nS S S 5        [        R                  " XÍS9   UR                  S5      nS S S 5        [        R                  " UWSS9  [        R                  " X^5        UR	                  [        R                  SS/5      n[        R                  " XÍS9   UR                  SS/5      nS S S 5        [        R                  " UWSS9  [        R                  " XÍS9   UR                  USS9nS S S 5        [        R                  " XÍS9   UR	                  [        R                  SS9nS S S 5        [        R                  " X^5        [        R                  " XnSS9  GM÷     g ! , (       d  f       GN§= f! , (       d  f       GN|= f! , (       d  f       GN`= f! , (       d  f       Nó= f! , (       d  f       NÁ= f! , (       d  f       N—= f)Nr   c                 ó,   • [         R                  " XUS9$ )N©Úaxis©r7   Ú
percentile)rQ   ÚqrÇ   s      r   ÚfÚ test_pass_args_kwargs.<locals>.fô   s   € Ü�}Š}˜Q¨Ñ-Ð-r   c                 ó.   • [         R                  " U SSS9$ )NéP   r   rÆ   rÈ   rP   s    r   rR   Ú'test_pass_args_kwargs.<locals>.<lambda>÷   s   € ”"—-’-  2¨AÒ.r   c                 ó   • U R                   $ rZ   ©ÚmonthrP   s    r   rR   rÏ   ú   s   €  a§g¢gr   rÎ   rÆ   çš™™™™™é?©rÊ   )TFc                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   rÏ     s   € ¨q¯wªwr   ©Úas_indexú*A grouping .* was excluded from the resultrV   F©Úcheck_namesgš™™™™™Ù?r¬   )r3   rx   r7   rÉ   rz   r{   Úquantiler9   ry   rv   ru   r   r:   )ÚtsÚtsframerË   ÚgÚ
ts_groupedÚ
agg_resultÚapply_resultÚtrans_resultÚagg_expectedÚtrans_expectedr×   Ú
df_groupedÚwarnrƒ   r   Úexpected_seqs                   r   Útest_pass_args_kwargsrè   ó   sÙ  € ô.ñ 	/€Að —‘Ñ-Ó.€JØ—‘¤§¡¨r¸�Ð:€JØ×#Ñ#¤B§M¡M°2¸AÐ#Ð>€LØ×'Ñ'¬¯©°rÀÐ'ÐB€Là×&Ñ& sÓ+€LØ×)Ñ)¨!Ó,€Nä×Ò˜<Ô6Ü×Ò˜:Ô4Ü×Ò˜<Ô8à—‘  R�Ð(€JØ×#Ñ# A¨Ð#Ð,€LØ×'Ñ'¨¨RÐ'Ð0€LÜ×Ò˜:Ô4Ü×Ò˜<Ô6Ü×Ò˜<Ô8ô "ˆØ—_‘_Ñ%6À�_ÐJˆ
Þ‰t¤]ˆØ:ˆÜ×'Ò'¨Ó8Ø#Ÿ™¬¯©°rÀ˜ÐBˆJ÷ 9ä×'Ò'¨Ó8Ø%×+Ñ+¬I×,>Ñ,>ÀÓDˆL÷ 9ä×'Ò'¨Ó8Ø!×*Ñ*¨3Ó/ˆH÷ 9ä
×Ò˜l¨HÀ%ÒHÜ
×Ò˜jÔ3à!×'Ñ'¬	×(:Ñ(:¸SÀ#¸JÓGˆÜ×'Ò'¨Ó8Ø%×.Ñ.°°S¨zÓ:ˆL÷ 9ä
×Ò˜l¨LÀeÒLä×'Ò'¨Ó8Ø#Ÿ™¨¨R˜Ð0ˆJ÷ 9ä×'Ò'¨Ó8Ø%×+Ñ+¬I×,>Ñ,>À#Ð+ÐFˆL÷ 9ä
×Ò˜jÔ3Ü
×Ò˜lÀ%ÕHò/ "÷ 9Ö8úç8Ö8úç8Ö8ú÷ 9Õ8ú÷ 9Õ8úç8Õ8úsH   Æ
 M
Ç!MÈM.É?N ËNË2N"Í

M	Í
M+	Í.
M=	Î 
N	Î
N	Î"
N0	r×   TFc                 ó6  • / SQU l         U R                  S US9nU(       a  S O[        nSn[        R                  " X4S9   UR                  [        R                  SSS9nS S S 5        X R                  R                  S	:H     R                  S
5      X R                  R                  S:H     R                  S
5      S.n[        U5      R                  nU(       d  [        [        S5      5      Ul        [        R                  " WU5        g ! , (       d  f       N°= f)N)r   r   r   r(   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   Ú9test_pass_args_kwargs_duplicate_columns.<locals>.<lambda>,  s   €  1§7¢7r   rÖ   rØ   rV   rÎ   r   rÆ   rX   rÓ   r$   ©rX   r$   )Úcolumnsr3   rv   r9   ru   rx   r7   rÉ   r+   rÒ   rÛ   r   ÚTr
   r5   r:   )rÝ   r×   r?   ræ   rƒ   ÚresÚex_datar   s           r   Ú'test_pass_args_kwargs_duplicate_columnsrñ   (  sÝ   € ò +€G„OØ	�‰Ñ*°XˆÐ	>€Bæ‰4¤€DØ
6€CÜ	×	#Ò	# DÓ	4Ø�f‰f”R—]‘] B¨QˆfÐ/ˆ÷ 
5ð —=‘=×&Ñ&¨!Ñ+Ñ,×5Ñ5°cÓ:Ø—=‘=×&Ñ&¨!Ñ+Ñ,×5Ñ5°cÓ:ñ€Gô ˜Ó!×#Ñ#€HÞäœu Q›x›ˆŒä×Ò˜#˜xÕ(÷ 
5Õ	4ús   Á  D
Ä

Dc            
      óÜ  • [        [        R                  R                  S5      R	                  S5      [        [        S5      [        S9[        SSSS9S	9n U R                  S
 S S /5      n[        U5      [        U 5      :X  d   eU R                  S S /5      n[        U R                   Vs1 s H  o"R                  UR                  4iM     sn5      n[        U5      U:X  d   eg s  snf )Nr$   ©re   é   ÚABCDr•   ú
2000-01-01re   r   ©r"   Úfreq©rí   r+   c                 ó   • U R                   $ rZ   ©ÚyearrP   s    r   rR   Útest_len.<locals>.<lambda>E  ó   €  A§F¢Fr   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   rý   E  ó   € °a·g²gr   c                 ó   • U R                   $ rZ   ©ÚdayrP   s    r   rR   rý   E  ó   € ÈÏÊr   c                 ó   • U R                   $ rZ   rû   rP   s    r   rR   rý   H  rþ   r   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   rý   H  r   r   )r   r7   rp   rq   r¡   r
   r4   Úobjectr   r3   rt   r+   rü   rÒ   )r>   r€   rQ   r   s       r   Útest_lenr  ?  sÆ   € Ü	Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9Ü”d˜6“l¬&Ñ1Ü˜¨r¸Ñ<ñ
€Bð
 �j‰jÑ*Ñ,=¹ÐOÓP€GÜˆw‹<œ3˜r›7Ó"Ð"Ð"à�j‰jÑ*Ñ,=Ð>Ó?€GÜ¨r¯xªxÓ8ªx¨!—V‘V˜QŸW™WÓ%©xÑ8Ó9€HÜˆw‹<˜8Ó#Ð#Ñ#ùò 9s   Â/!C)c                  ó  • [        [        R                  /S-  / SQS.5      n [        U R	                  S5      5      S:X  d   e[        U R	                  S5      5      S:X  d   e[        U R	                  SS/5      5      S:X  d   eg )NrK   ©rX   r$   rK   ©ÚaÚbr  r   r  )r   r7   rÁ   rt   r3   ©r>   s    r   Útest_len_nan_groupr  M  sq   € ä	œ"Ÿ&™&˜ A™ªIÑ6Ó	7€BÜˆr�z‰z˜#‹Ó 1Ó$Ð$Ð$Üˆr�z‰z˜#‹Ó 1Ó$Ð$Ð$Üˆr�z‰z˜3 ˜*Ó%Ó&¨!Ó+Ð+Ñ+r   c                  ó2  • [        [        [        SS5      5      S-   V s/ s H  n SU -  PM
     sn 5      n[        R                  R                  S5      R	                  S5      S-  n[        U5      nUR                  U5      nUR                  5         g s  sn f )NrX   re   ç      ð?r$   iL  g      $@)r   r4   r5   r7   rp   rq   r3   rk   )rQ   r   r   Ú	groupingsr€   s        r   Útest_basic_regressionr  U  sz   € ä¤d¬5°°B«<Ó&8¸2Ò&=Ó>Ò&= �S˜1”WÑ&=Ñ>Ó?€Fä�9‰9× Ñ  Ó#×*Ñ*¨4Ó0°4Ñ7€DÜ�t“€Ià�n‰n˜YÓ'€GØ‡L�L…Nùò ?s    B)rG   rH   rE   rF   Úint16rŒ   c                 ó  • [        [        R                  " S5      5      n[        [        R                  " S5      XS9n[        [        R
                  SSS[        R
                  [        R
                  SS[        R
                  S/
US9nUR                  U5      nUR                  [        5      n[        SS/SS/S9n[        R                  " XVSS	9  S
 nUR                  U5      n[        SS/SS/S9n[        R                  " XV5        g )Nre   r•   r‘   r’   r*   rô   r$   F©Úcheck_dtypec                 ó*   • [        [        U 5      5      $ rZ   )Úfloatrt   rP   s    r   rË   Útest_with_na_groups.<locals>.fu  s   € Ü”S˜“V‹}Ðr   ç      @ç       @)r
   r7   r8   r   ÚonesrÁ   r3   rx   rt   r9   ry   )rD   r+   ÚvaluesÚlabelsr€   r„   r   rË   s           r   Útest_with_na_groupsr   `  s×   € ô ”"—)’)˜B“-Ó €EÜ”B—G’G˜B“K Ñ4€FÜÜ	�‰�˜˜u¤b§f¡f¬b¯f©f°e¸UÄBÇFÁFÈEÐRØñ€Fð �n‰n˜VÓ$€GØ�K‰KœÓ€EÜ�q˜!�f U¨E NÑ3€Hä×Ò˜5¸Ò>ò
ð �K‰K˜‹N€EÜ�s˜C�j¨°¨Ñ7€Hä×Ò˜5Õ+r   c                  ó0  • S n S nS n[        / SQ[        S5      [        SS5      S.5      n[        / S	Q[        S5      [        SS5      S.5      nS
nSn[        R                  " [        US9   UR                  S5      R                  U 5      nS S S 5        [        R                  " [        US9   UR                  S5      R                  U 5      nS S S 5        [        R                  " WW5        Sn[        R                  " [        US9   UR                  S5      R                  U5        S S S 5        [        R                  " [        US9   UR                  S5      R                  U5        S S S 5        [        R                  " [        US9   UR                  S5      R                  U5        S S S 5        [        R                  " [        US9   [        R                  " [        US9   UR                  S5      R                  U5        S S S 5        S S S 5        g ! , (       d  f       GN•= f! , (       d  f       GNe= f! , (       d  f       GN= f! , (       d  f       Në= f! , (       d  f       Nº= f! , (       d  f       No= f! , (       d  f       g = f)Nc                 óÀ   • X R                   S-  S:H     S-  nUR                  (       a"  [        / /S-  / /S-  SS/S9n[        S/US9nU$ UR	                  SS/5      nU$ )Nr$   rX   r  Úc©ÚlevelsrŠ   Únamesr  rù   )r  Úemptyr   r   Ú	set_index©rQ   ÚyÚ
multiindexrï   s       r   Úf1Ú,test_indices_concatenation_order.<locals>.f1�  sk   € Ø�s‰s�Q‰w˜1‰nÑ Ñ"ˆØ�7�7Ü#¨B¨4°!©8¸B¸4À!¹8ÈCÐQTÈ:ÑVˆJÜ S E°Ñ<ˆCØˆJà—‘˜S #˜JÓ'ˆAØˆHr   c                 ó�   • X R                   S-  S:H     S-  nUR                  (       a
  [        5       $ UR                  SS/5      nU$ )Nr$   rX   r  r#  )r  r'  r   r(  )rQ   r*  s     r   Úf2Ú,test_indices_concatenation_order.<locals>.f2‹  sA   € Ø�s‰s�Q‰w˜1‰nÑ Ñ"ˆØ�7�7Ü“;Ðà—‘˜S #˜JÓ'ˆAØˆHr   c                 óœ   • X R                   S-  S:H     S-  nUR                  (       a#  [        / /S-  / /S-  SS/S9n[        SS/US9nU$ U$ )	Nr$   rX   r‘   r’   r$  r  r  rù   )r  r'  r   r   r)  s       r   Úf3Ú,test_indices_concatenation_order.<locals>.f3“  s_   € Ø�s‰s�Q‰w˜1‰nÑ Ñ"ˆØ�7�7Ü#Ø�t˜a‘x¨ t¨a¡x¸¸u°~ñˆJô  S¨# J°jÑAˆCØˆJàˆHr   )rX   r$   r$   r$   rô   r#   rJ   ©r  r  r#  )rK   r$   r$   r$   zDThe behavior of array concatenation with empty entries is deprecatedr    rV   r  z@Cannot concat indices that do not have the same number of levels)r   r5   r9   ru   rv   r3   rz   r:   r|   r}   ÚAssertionError)	r,  r/  r2  r>   Údf2Údepr_msgrƒ   Úresult1Úresult2s	            r   Ú test_indices_concatenation_orderr:  ~  sÆ  € òòò	ô 
š¬E°!«H¼5ÀÀA»;ÑGÓ	H€Bä
š,¬U°1«X¼EÀ!ÀQ»KÑHÓ
I€CàU€Hð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—*‘*˜S“/×'Ñ'¨Ó+ˆ÷ 
>ä	×	#Ò	#¤M¸Ó	=Ø—+‘+˜cÓ"×(Ñ(¨Ó,ˆ÷ 
>ä×Ò˜' 7Ô+ð M€CÜ	�Š”~¨SÓ	1Ø
�
‰
�3‹×Ñ˜bÔ!÷ 
2ä	�Š”~¨SÓ	1Ø�‰�CÓ×Ñ˜rÔ"÷ 
2ô 
�Š”~¨SÓ	1Ø
�
‰
�3‹×Ñ˜bÔ!÷ 
2ä	�Š”~¨SÓ	1Ü×'Ò'¬¸XÓFØ�K‰K˜Ó×"Ñ" 2Ô&÷ G÷ 
2Ð	1÷! 
>Ö	=úç	=Ö	=ú÷ 
2Ö	1úç	1Õ	1ú÷ 
2Õ	1ú÷ GÕFú÷ 
2Õ	1ús`   Á/!HÂ1!H0Ä!IÅ!IÆ!I%ÇJÇ,!I6ÈJÈ
H-È0
H?É
IÉ
I"É%
I3É6
J	Ê JÊ
Jc                 óL  • U R                  S 5      nUR                  5       nUR                  S 5      n[        R                  " X#5        UR                  5       nU VVs0 s H  u  pEXER                  5       _M     nnn[        U5      R                  n[        R                  " X#5        UR                  nUR                  S 5      n[        R                  " X#5        Sn[        R                  " [        US9   [        US5        S S S 5        g s  snnf ! , (       d  f       g = f)Nc                 ó"   • U R                  5       $ rZ   ©ÚweekdayrP   s    r   rR   Ú#test_attr_wrapper.<locals>.<lambda>¼  s
   €  1§9¡9¤;r   c                 ó,   • [         R                  " U SS9$ )NrX   )Úddof)r7   r6   rP   s    r   rR   r?  ¿  s   € ¤R§V¢V¨A°AÒ%6r   c                 ó   • U R                   $ rZ   r•   rP   s    r   rR   r?  Ê  s   €  Q§W¢Wr   z-'SeriesGroupBy' object has no attribute 'foo'rV   r‘   )r3   r6   rx   r9   ry   Údescriber   rî   r:   rD   r|   r}   ÚAttributeErrorÚgetattr)rÜ   r€   r   r   rj   Úgprƒ   s          r   Útest_attr_wrapperrG  »  sã   € Ø�j‰jÑ.Ó/€Gà�[‰[‹]€FØ�{‰{Ñ6Ó7€HÜ×Ò˜6Ô,ð ×ÑÓ€FÙ4;Ô<²G©¨�—k‘k“mÒ#±G€HÑ<Ü˜Ó"×$Ñ$€HÜ×Ò˜&Ô+ð �]‰]€FØ�{‰{Ñ,Ó-€HÜ×Ò˜6Ô,ð :€CÜ	�Š”~¨SÓ	1Ü�˜Ô÷ 
2Ð	1ùó =÷ 
2Õ	1ús   Á DÃ9DÄ
D#c                 óD  • U R                  S 5      nUR                  S5      n[        U5      S:X  d   e[        UR                  5      S:X  d   eU R	                  5       nUR
                   Vs/ s H  oDR                  5       PM     snUS'   UR                  S5      R                  S5      n[        R                  " XRSS9  U R                  S5      R                  S	 5      nUR                  S
 5      n[        U5      S:X  d   e[        UR                  5      S:X  d   eUR                  S 5      nU HM  u  pxUR                  5       n	UR
                   H(  n
[        R                  " UR                  U
5      U	SS9  M*     MO     U H(  u  p¸UR
                  S   R                  5       U:X  a  M(   e   UR                  nUR                  nUR!                  5        H<  u  pïU R
                  R#                  XÞ   5      nUU:H  R%                  5       (       a  M<   e   g s  snf )Nc                 ó"   • U R                  5       $ rZ   r=  rP   s    r   rR   Ú$test_frame_groupby.<locals>.<lambda>Ô  s
   € ¨¯	©	¬r   rk   r#   rô   r>  FrÙ   rg   c                 ó"   • U R                  5       $ rZ   r=  rP   s    r   rR   rJ  â  s
   € °·±´r   c                 ó&   • X R                  5       -
  $ rZ   ©rk   rP   s    r   rR   rJ  ã  s   € ¨a·&±&³(ªlr   c                 ó"   • U R                  5       $ rZ   rM  rP   s    r   rR   rJ  è  s
   € ¨a¯f©f¬hr   r   )r3   rw   rt   rí   r0   r+   r>  r9   r:   Úheadr{   rk   ry   ÚxsÚgroupsÚindicesÚitemsÚtakeÚall)rÝ   r€   Ú
aggregatedÚtscopyrQ   Ústraggedr…   rj   r�   rk   Úidxr>  rQ  rR  r�   r‚   Ú	samethings                    r   Útest_frame_groupbyr[  Ó  sØ  € Ø�o‰oÑ3Ó4€Gð ×"Ñ" 6Ó*€JÜˆz‹?˜aÓÐÐÜˆz×!Ñ!Ó" aÓ'Ð'Ð'ð �\‰\‹^€FØ.4¯lªlÓ;ªl¨Ÿ™ž©lÑ;€Fˆ9ÑØ�~‰~˜iÓ(×2Ñ2°6Ó:€HÜ×Ò˜(¸EÒBð �l‰l˜2Ó×&Ñ&Ñ'<Ó=€GØ×#Ñ#Ñ$:Ó;€KÜˆ{Ó˜rÓ!Ð!Ð!Üˆ{×"Ñ"Ó# qÓ(Ð(Ð(ð ×#Ñ#Ñ$6Ó7€KÛ‰ˆØ�z‰z‹|ˆØ—;”;ˆCÜ×"Ò" ;§>¡>°#Ó#6¸È%ÔPó ñ ó "‰ˆØ�{‰{˜1‰~×%Ñ%Ó'¨7Õ2Ð2Ð2ñ "ð �^‰^€FØ�o‰o€Gà—‘–‰ˆØ—M‘M×&Ñ& w¡zÓ2ˆ	Ø˜Q‘×#Ñ#×%Ó%Ð%Ð%ò ùò3 <s   Á.Hc                 ó–  • SSSSS.nSn[         R                  " [        US9   U R                  USS9nS S S 5        WR	                  S5      n[        U5      [        U 5      :X  d   e[        UR                  5      S:X  d   eS	 nS
n[         R                  " [        US9   U R                  R                  USS9nS S S 5        [         R                  " WR                  U5      R                  UR                  U5      5        U H   u  px[        UR                  5      S:X  a  M    e   g ! , (       d  f       Nû= f! , (       d  f       N…= f)Nr   rX   r–   ú+DataFrame.groupby with axis=1 is deprecatedrV   rÆ   rk   r$   c                 ó&   • X R                  5       -
  $ rZ   rM  rP   s    r   rR   Ú,test_frame_groupby_columns.<locals>.<lambda>  s   € �1—v‘v“x’<r   ú5The 'axis' keyword in DataFrame.groupby is deprecated)
r9   ru   rv   r3   rw   rt   rí   rî   r:   r{   )	rÝ   Úmappingrƒ   r€   rV  ÚtfÚgroupedTr�   r‚   s	            r   Útest_frame_groupby_columnsrd  û  s  € Ø˜A A¨AÑ.€GØ
7€CÜ	×	#Ò	#¤M¸Ó	=Ø—/‘/ '°�/Ð2ˆ÷ 
>ð ×"Ñ" 6Ó*€JÜˆz‹?œc '›lÓ*Ð*Ð*Üˆz×!Ñ!Ó" aÓ'Ð'Ð'ñ 
 €BØ
A€CÜ	×	#Ò	#¤M¸Ó	=Ø—9‘9×$Ñ$ W°1Ð$Ð5ˆ÷ 
>ä×Ò˜(×,Ñ,¨RÓ0×2Ñ2°G×4EÑ4EÀbÓ4IÔJó ‰ˆÜ�1—9‘9‹~ Õ"Ð"Ð"ò ÷! 
>Õ	=ú÷ 
>Õ	=ús   £D)Â D:Ä)
D7Ä:
Ec                 ól  • U R                  S5      nUR                  SS9nUR                  R                  S:X  d   eU R                  SSS9R                  SS9nUR                  R                  S:w  d   eUSS/   R	                  S5      nUR                  R                  S:X  d   eUR	                  SS	S
.5      nUR                  R                  S:X  d   eUS   R                  5       nUR                  R                  S:X  d   eUS   R	                  S5      nUR                  R                  S:X  d   eUS   R	                  SS	/5      nUR                  R                  S:X  d   eSn[
        R                  " [        US9   US   R	                  SS	S.5        S S S 5        g ! , (       d  f       g = f)Nr   T©Únumeric_onlyFrÖ   r(   r—   rk   r6   ©r(   r—   rb   rV   ©r‘   r’   )r3   rk   r+   rj   rx   r|   r}   r   )r>   r€   r   rƒ   s       r   Útest_frame_set_name_singlerj    sˆ  € Ø�j‰j˜‹o€Gà�\‰\ tˆ\Ð,€FØ�<‰<×Ñ Ó#Ð#Ð#à�Z‰Z˜ eˆZÐ,×1Ñ1¸tÐ1ÐD€FØ�<‰<×Ñ Ó#Ð#Ð#à�c˜3�ZÑ ×$Ñ$ VÓ,€FØ�<‰<×Ñ Ó#Ð#Ð#à�[‰[˜v¨EÑ2Ó3€FØ�<‰<×Ñ Ó#Ð#Ð#à�S‰\×ÑÓ €FØ�<‰<×Ñ Ó#Ð#Ð#Ø�S‰\×Ñ˜fÓ%€FØ�<‰<×Ñ Ó#Ð#Ð#Ø�S‰\×Ñ˜v u˜oÓ.€FØ�<‰<×Ñ Ó#Ð#Ð#à
,€CÜ	�ŠÔ)°Ó	5Ø�‰×Ñ °Ñ6Ô7÷ 
6×	5Ö	5ús   ÆF%Æ%
F3c           	      ó°  • U S   nU S   nU R                  UR                  UR                  /5      nUR                  SS9nU R                  SS/5      R                  5       n[        R                  " UR
                  S S 2SS/4   UR
                  S S 2SS/4   SS9  [        [        R                  R                  S	5      R                  S
5      [        R                  R                  S	5      R                  S
5      [        R                  " / SQ5      [        R                  " / SQ5      S./ SQS9n U R                  SS/5      nUR                  S5        g )Nr   r   Trf  r(   r—   FrÙ   r$   é   ©r  r  r  r  r  r  ©Ú1ro  ro  Ú2rp  rp  )Úv1Úv2Úk1Úk2)rc   rd   r“   ÚfourÚfiveÚsixr*   rs  rt  r\   )r3   Úgetrk   r9   r:   rš   r   r7   rp   rq   r¡   r¢   rx   )r>   Úcol1Úcol2r€   r„   r   s         r   Útest_multi_funcr{  -  s  € Øˆc‰7€DØˆc‰7€Dà�j‰j˜$Ÿ(™( D§H¡HÐ-Ó.€GØ�L‰L dˆLÐ+€EØ�z‰z˜3 ˜*Ó%×*Ñ*Ó,€Hô ×ÒØ�	‰	’!�c˜3�Z�-Ñ  (§,¡,ªq°3¸°*¨}Ñ"=È5òô
 
ä—)‘)×'Ñ'¨Ó*×:Ñ:¸1Ó=Ü—)‘)×'Ñ'¨Ó*×:Ñ:¸1Ó=Ü—(’(Ò9Ó:Ü—(’(Ò9Ó:ñ		
ò =ñ
€Bð �j‰j˜$ ˜Ó&€GØ‡K�K�Õr   c                 óÚ   • U R                  SS/5      S   nUR                  SS/5      n[        UR                  S5      UR                  S5      S.5      n[        R                  " X#5        g )Nr   r   r(   rk   r6   )rk   r6   )r3   rx   r   r9   r:   )r>   r€   r„   r   s       r   Ú!test_multi_key_multiple_functionsr}  I  sZ   € Ø�j‰j˜#˜s˜Ó$ SÑ)€Gà�K‰K˜ ˜Ó(€EÜ '§+¡+¨fÓ"5¸g¿k¹kÈ%Ó>PÑQÓR€HÜ×Ò˜%Õ*r   c            	      óØ  • [        / SQ/ SQ[        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      S.5      n U R                  SS/5      nSS	/nUR                  U5      n[        R                  " US
   R                  U5      US   R                  U5      US   R                  U5      // SQSS9n[        UR                  [        5      (       d   e[        UR                  [        5      (       d   e[        R                  " X45        g )N©r‘   r‘   r‘   r‘   r’   r’   r’   r’   r‘   r‘   r‘   ©rc   rc   rc   rd   rc   rc   rc   rd   rd   rd   rc   r$   é   )r   r   r—   ÚEÚFr   r   rk   r6   r—   r‚  rƒ  )r—   r‚  rƒ  rX   )ÚkeysrÇ   )r   r7   rp   rq   r¡   r3   rx   r-   ÚconcatÚ
isinstancer+   r   r9   r:   )r   r€   Úfuncsr„   r   s        r   Ú"test_frame_multi_key_function_listrˆ  Q  s)  € Üòòô —‘×&Ñ& qÓ)×9Ñ9¸"Ó=Ü—‘×&Ñ& qÓ)×9Ñ9¸"Ó=Ü—‘×&Ñ& qÓ)×9Ñ9¸"Ó=ñ;	
ó €DðD �l‰l˜C ˜:Ó&€GØ�UˆO€EØ�K‰K˜Ó€EÜ�yŠyØ	�‰×	Ñ	˜%Ó	  '¨#¡,×"2Ñ"2°5Ó"9¸7À3¹<×;KÑ;KÈEÓ;RÐSÚØñ€Hô
 �e—k‘k¤:×.Ñ.Ð.Ð.Ü�h—n‘n¤j×1Ñ1Ð1Ð1Ü×Ò˜%Õ*r   c           
      ó0  • [        / SQ/ SQ/ SQ[        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      [        R                  R                  S5      R	                  S5      S.5      nUR                  SS/5      nS	S
/n[        R                  " S5      nU (       a  Sn[        R                  " [        US9   UR                  U5        S S S 5        g ! , (       d  f       g = f)Nr  r€  )ÚdullrŠ  ÚshinyrŠ  rŠ  r‹  r‹  rŠ  r‹  r‹  r‹  r$   r�  )r   r   r(   r—   r‚  rƒ  r   r   rk   r6   ú&agg function failed [how->mean,dtype->ú-dtype 'str' does not support operation 'mean'rV   )r   r7   rp   rq   r¡   r3   ÚreÚescaper|   r}   Ú	TypeErrorrx   )Úusing_infer_stringr   r€   r‡  rƒ   s        r   Ú2test_frame_multi_key_function_list_partial_failurer’  �  sÕ   € Üòòòô —‘×&Ñ& qÓ)×9Ñ9¸"Ó=Ü—‘×&Ñ& qÓ)×9Ñ9¸"Ó=Ü—‘×&Ñ& qÓ)×9Ñ9¸"Ó=ñU+	
ó-€Dð^ �l‰l˜C ˜:Ó&€GØ�UˆO€EÜ
�)Š)Ð<Ó
=€CÞØ=ˆÜ	�Š”y¨Ó	,Ø�‰�EÔ÷ 
-×	,Ö	,ús   Ã,DÄ
DÚopc                 ó"   • U R                  5       $ rZ   r[   rP   s    r   rR   rR   º  s
   € ¨!¯%©%¬'r   c                 ó"   • U R                  5       $ rZ   rM  rP   s    r   rR   rR   º  s
   € ¸Q¿V¹V¼Xr   c           
      óú  • U nUR                  SS/5      nU" U5      n/ n/ nUR                  S5       H[  u  pxUR                  S5       HA  u  pšUR                  Xy45        UR                  U" U
R                  S S 2SS/4   5      5        MC     M]     [        R                  " USS/S9n[
        R                  " USS9R                  nX¼l        S HC  nU" X=   5      nXM   nXÍ   n[        R                  " UU5        [        R                  " UU5        ME     US   R                  US   US   /5      R                  5       nUR                  SS/5      R                  5       S   n[        R                  " UU5        g )	Nr   r   r(   r—   ©r&  rX   rÆ   rh  )r3   Úappendrš   r   Úfrom_tuplesr-   r…  rî   r+   r9   ry   rk   )r>   r“  r   r€   r8  r„  r  Ún1Úgp1Ún2Úgp2Úmir   ÚcolÚ
result_colÚpivotedÚexpr   s                     r   Útest_groupby_multiple_columnsr£  º  s[  € à€DØ�l‰l˜C ˜:Ó&€Gá�‹k€Gà€DØ€FØ—<‘< Ö$‰ˆØ—{‘{ 3Ö'‰GˆBØ�K‰K˜˜Ô!Ø�M‰M™"˜SŸW™W¢Q¨¨c¨
 ]Ñ3Ó4Ö5ó (ñ %ô
 
×	Ò	 ¨S°#¨JÑ	7€BÜ�yŠy˜ aÑ(×*Ñ*€HØ„Nó ˆÙ˜™Ó%ˆ
Ø‘,ˆØ‰mˆÜ
×Ò˜z¨3Ô/Ü
×Ò˜w¨Ö,ñ ð �#‰Y×Ñ  S¡	¨4°©9Ð5Ó6×;Ñ;Ó=€FØ�|‰|˜S #˜JÓ'×,Ñ,Ó.¨sÑ3€Hä×Ò˜6 8Õ,r   c                  óp  • [        SS/SS/SS//SS/S9n U R                  SS	S
9S   R                  S5      n[        SS/SS9n[        R
                  " X5        U R                  SS	SS9S   R                  S 5      n[        / SQS[        R                  " / SQ5      S9n[        R
                  " X5        g )NrX   r$   rô   r#   rl  r   r   ©rí   FrÖ   ©rj   T)r×   rU   c                 ó"   • U R                  5       $ rZ   )ÚcumsumrP   s    r   rR   Ú-test_as_index_select_column.<locals>.<lambda>ã  s
   € �!—(‘(”*r   )r$   rl  rl  ))r   r   )r   rX   rì   ©rj   r+   )	r   r3   Ú	get_groupr   r9   ry   rz   r   r™  ©r>   r   r   s      r   Útest_as_index_select_columnr­  Û  s»   € ä	�Q˜�F˜Q ˜F Q¨ FÐ+°c¸3°ZÑ	@€BØ�Z‰Z˜ eˆZÐ,¨SÑ1×;Ñ;¸AÓ>€FÜ�q˜!�f 3Ñ'€HÜ×Ò˜6Ô,à�Z‰Z˜ e¸ˆZÐ=¸cÑB×HÑHÙó€Fô Ú˜¤:×#9Ò#9Ò:RÓ#Sñ€Hô ×Ò˜6Õ,r   c                  ój  • Sn [        / SQ/ SQS.5      nUR                  UR                  S5      R                  R	                  S5         n[
        R                  " [        U S9   UR                  S5      R                  SUS9n[
        R                  " X25        S S S 5        g ! , (       d  f       g = f)	Nzobj is deprecated©rX   rX   r$   ©rK   rô   r#   r  r  rô   rV   )Úobj)
r   r2   r3   rR  rx  r9   ru   rv   r«  r:   )r7  r>   r   r   s       r   Ú!test_obj_arg_get_group_deprecatedr²  ë  s…   € Ø"€Hä	šªÑ3Ó	4€BØ�w‰w�r—z‘z #“×.Ñ.×2Ñ2°1Ó5Ñ6€HÜ	×	#Ò	#¤M¸Ó	BØ—‘˜C“×*Ñ*¨1°"Ð*Ð5ˆÜ
×Ò˜fÔ/÷ 
C×	BÖ	Bús   Á%6B$Â$
B2c                  óú   • [        [        / SQSS9S9n U R                  SSS9S   R                  SS	9n[        U R                  S S
 [        S5      S9nS /UR                  l        [        R                  " X5        g )Nr,   Úalphar¦  r¥  r   F)Úbyr×   r   rf  r$   r   rù   )	r   r
   r3   r\   rí   r5   r&  r9   r:   )r>   Úleftr   s      r   Ú0test_groupby_as_index_select_column_sum_empty_dfr·  õ  sp   € ä	œ5¢°wÑ?Ñ	@€BØ�:‰:˜ uˆ:Ð-¨cÑ2×6Ñ6ÀEÐ6ÐJ€Dä §¡¨B¨Q ´u¸Q³xÑ@€Hà"˜V€H×ÑÔÜ×Ò˜$Õ)r   c                 óÌ  • U R                  SSS9nUSS/   R                  S5      nUR                  SS9n[        R                  " X#5        UR                  SS	S
.5      nUR                  SS9nUR                  5       S   US'   [        R                  " XE5        U R                  SSS9nSn[        R                  " [        US9   US   R                  SS	05        S S S 5        U R                  SS/SS9nUR                  S5      nUR                  5       n[        R                  " X#5        UR                  SS	S
.5      nUR                  5       nUR                  5       S   US'   [        R                  " XE5        US   R                  5       n[        U5      R                  SS0S9nSn[        R                  " [        US9   US   R                  SS	05      nS S S 5        [        R                  " WU5        [        [        R                  R                  S5      R!                  SSS5      / SQS9n [#        [        R                  R                  S5      R!                  SSS5      SS9n	U R                  U	5      n
U
R%                  S5        Sn[        R                  " [        USS9   U
R'                  [
        5      nS S S 5        [        R                  " [        USS9   U R                  U	5      R'                  [
        5      nS S S 5        [        R                  " WW5        S Hp  nU R                  U	SS9n
[)        X­5      " 5       nU R                  U	R*                  SS9n
[)        X­5      " 5       R-                  SS9n[        R                  " Xï5        Mr     g ! , (       d  f       GNÉ= f! , (       d  f       GNÛ= f! , (       d  f       GN= f! , (       d  f       NÒ= f)Nr   FrÖ   r(   r—   rk   Trf  r\   rh  rb   rV   ÚQr   r¥  z7Passing a dictionary to SeriesGroupBy.agg is deprecatedr$   r   éd   )é2   rK   )ÚjimÚjoeÚjolier#   re   r»  r¼  r¦  z:The behavior of DataFrame.sum with axis=None is deprecated)rW   Úcheck_stacklevel)rk   ÚmaxÚcountr›   r¨  rU  ©Údrop)r3   rx   rk   r9   r:   r\   r|   r}   r   r   Úrenameru   rv   r7   rp   rq   Úintegersr   Únthrz   rE  r  Úreset_index)r>   r€   r   r   r9  Ú	expected2rƒ   Ú	expected3Úresult3rÜ   Úgrrï   ÚaltÚattrr¶  Úrights                   r   Útest_groupby_as_index_aggrÏ     s-  € Ø�j‰j˜ uˆjÐ-€Gð �c˜3�ZÑ ×$Ñ$ VÓ,€FØ�|‰|¨ˆ|Ð.€HÜ×Ò˜&Ô+à�k‰k ¨UÑ3Ó4€GØ—‘¨$�Ð/€IØ—[‘[“] 3Ñ'€Iˆc�NÜ×Ò˜'Ô-à�j‰j˜ tˆjÐ,€Gà
,€CÜ	�ŠÔ)°Ó	5Ø�‰×Ñ˜#˜u˜Ô&÷ 
6ð
 �j‰j˜#˜s˜¨eˆjÐ4€Gà�[‰[˜Ó €FØ�|‰|‹~€HÜ×Ò˜&Ô+à�k‰k ¨UÑ3Ó4€GØ—‘“€IØ—[‘[“] 3Ñ'€Iˆc�NÜ×Ò˜'Ô-à˜‘× Ñ Ó"€IÜ˜)Ó$×+Ñ+°S¸#°JÐ+Ð?€IØ
C€CÜ	×	#Ò	#¤M¸Ó	=Ø˜#‘,×"Ñ" C¨ <Ó0ˆ÷ 
>ä×Ò˜' 9Ô-ô 
Ü
�	‰	×Ñ˜aÓ ×)Ñ)¨!¨S°'Ó:Ú'ñ
€Bô 
”—	‘	×%Ñ% aÓ(×1Ñ1°!°R¸Ó<À5Ñ	I€Bà	�‰�B‹€BØ‡F�Fˆ1„Ià
F€CÜ	×	#Ò	#¤M¸ÈuÓ	UØ�h‰h”s‹mˆ÷ 
Vä	×	#Ò	#¤M¸ÈuÓ	UØ�j‰j˜‹n×"Ñ"¤3Ó'ˆ÷ 
Vä×Ò˜#˜sÔ#ãCˆØ�Z‰Z˜ UˆZÐ+ˆÜ�rÔ Ó"ˆà�Z‰Z˜Ÿ	™	¨DˆZÐ1ˆÜ˜Ô!Ó#×/Ñ/°TÐ/Ð:ˆä
×Ò˜dÖ*ò D÷Q 
6Ö	5ú÷& 
>Ö	=ú÷ 
VÖ	Uúç	UÕ	Uús0   ÃNÇN1Ê,OË$%OÎ
N.Î1
O Ï
OÏ
O#c                 óö  • U S;   a  [         R                  " SU  35        [        [        R                  R                  S5      R                  SSSS9SS	/S
9n[        UR                  S5      U 5      " 5       nU S:X  a  UR                  S5      nUR                  5       nU S:w  a$  US   R                  US   R                  5      US'   UR                  SSS9n[        X05      " 5       n[        R                  " XB5        UR                  U 5      n[        R                  " XB5        [        US	   U 5      " 5       n[        R                  " XB5        US	   R                  U 5      n[        R                  " XB5        g )N)ÚcorrwithrÆ  Úngroupz!GH 5755: Test not applicable for r$   r   r#   )rº  r$   )Úsizer  r  r¥  rÓ  FrÖ   )r|   Úskipr   r7   rp   rq   rÅ  rE  r3   rÄ  rÇ  r‹   rD   r9   r:   rx   )Úreduction_funcr>   r   rÞ   r   s        r   Útest_ops_not_as_indexrÖ  C  sE  € ð Ð6Ó6Ü�ŠÐ7¸Ð7GÐHÔIä	Ü
�	‰	×Ñ˜aÓ ×)Ñ)¨!¨Q°XÐ)Ð>ÈÈcÈ
ñ
€Bô �r—z‘z #“¨Ô7Ó9€HØ˜ÓØ—?‘? 6Ó*ˆØ×#Ñ#Ó%€Hà˜Óà  ™×,Ñ,¨R°©W¯]©]Ó;ˆ�‰à
�
‰
�3 ˆ
Ð'€Aä�QÔ'Ó)€FÜ×Ò˜&Ô+à�U‰U�>Ó"€FÜ×Ò˜&Ô+ä�Q�s‘V˜^Ô,Ó.€FÜ×Ò˜&Ô+àˆs‰V�Z‰Z˜Ó'€FÜ×Ò˜&Õ+r   c                 óh  • U R                  SSS9nU R                  SS/SS9nUS   R                  S5      nUR                  S5      R                  S S 2SS/4   n[        U[        5      (       d   e[
        R                  " X45        US   R                  S5      nUR                  S5      R                  S S 2/ SQ4   n[        U[        5      (       d   e[
        R                  " XV5        US   R                  5       nUR                  5       R                  S S 2SS/4   n[        U[        5      (       d   e[
        R                  " X45        US   R                  5       nUR                  5       R                  S S 2/ SQ4   n[        U[        5      (       d   e[
        R                  " XV5        g )Nr   FrÖ   r   r(   r\   r,   )r3   rx   rš   r†  r   r9   r:   r\   )r>   r€   Úgrouped2r   r   r9  rÈ  s          r   Ú!test_as_index_series_return_framerÙ  e  sr  € Ø�j‰j˜ uˆjÐ-€GØ�z‰z˜3 ˜*¨uˆzÐ5€Hà�S‰\×Ñ˜eÓ$€FØ�{‰{˜5Ó!×%Ñ%¢a¨#¨s¨ mÑ4€HÜ�fœi×(Ñ(Ð(Ð(Ü×Ò˜&Ô+à�s‰m×Ñ Ó&€GØ—‘˜UÓ#×'Ñ'ªª?Ð(:Ñ;€IÜ�gœy×)Ñ)Ð)Ð)Ü×Ò˜'Ô-à�S‰\×ÑÓ€FØ�{‰{‹}× Ñ ¢ S¨# J Ñ/€HÜ�fœi×(Ñ(Ð(Ð(Ü×Ò˜&Ô+à�s‰m×ÑÓ!€GØ—‘“×"Ñ"¢1¢oÐ#5Ñ6€IÜ�gœy×)Ñ)Ð)Ð)Ü×Ò˜'Õ-r   c                 ó¶   • U R                  SSS9nSn[        R                  " [        US9   US   R	                  S5        S S S 5        g ! , (       d  f       g = f)Nr   FrÖ   zColumn\(s\) C already selectedrV   r(   r—   )r3   r|   r}   Ú
IndexErrorÚ__getitem__)r>   r€   rƒ   s      r   Ú(test_as_index_series_column_slice_raisesrÝ  ~  sE   € à�j‰j˜ uˆjÐ-€GØ
+€Cä	�Š”z¨Ó	-Ø�‰× Ñ  Ô%÷ 
.×	-Ö	-ús   ¬A
Á

Ac                 ó¢  • U nUR                  SSS9nUR                  SS9nUR                  S/5      R                  SS9nUR                  SSUR                  5        [	        [        U5      5      Ul        [        R                  " X45        UR                  SS/SS9nUR                  5       nUR                  SS/5      R                  5       n[        [        UR                  R                  6 5      nUR                  SSUS   5        UR                  SSUS   5        [	        [        U5      5      Ul        [        R                  " X45        g )	Nr   FrÖ   Trf  r   r   rX   )r3   rk   Úinsertr+   r   rt   r9   r:   r4   Úzipr  )r>   r   r€   r   r   Úarrayss         r   Útest_groupby_as_index_cythonrâ  ‡  s  € Ø€Dð �l‰l˜3¨ˆlÐ/€GØ�\‰\ tˆ\Ð,€FØ�|‰|˜S˜EÓ"×'Ñ'°TÐ'Ð:€HØ‡O�O�A�s˜HŸN™NÔ+Ü¤ H£Ó.€H„NÜ×Ò˜&Ô+ð �l‰l˜C ˜:°ˆlÐ6€GØ�\‰\‹^€FØ�|‰|˜S #˜JÓ'×,Ñ,Ó.€Hä”#�x—~‘~×,Ñ,Ð-Ó.€FØ‡O�O�A�s˜F 1™IÔ&Ø‡O�O�A�s˜F 1™IÔ&Ü¤ H£Ó.€H„NÜ×Ò˜&Õ+r   c                 óÔ   • U R                  SS/SS9nUS   R                  [        5      nUR                  [        5      R                  S S 2/ SQ4   n[        R
                  " X#5        g )Nr   r   FrÖ   r(   r,   )r3   rx   rt   rš   r9   r:   ©r>   r€   r   r   s       r   Ú#test_groupby_as_index_series_scalarrå  ž  sZ   € Ø�j‰j˜#˜s˜¨eˆjÐ4€Gð �S‰\×ÑœcÓ"€FØ�{‰{œ3Ó×#Ñ#¢A¢Ð$6Ñ7€HÜ×Ò˜&Õ+r   c                 óˆ  • Sn[         R                  " [        US9   UR                  S SS9  S S S 5        SnSn[         R                  " [        US9   [
        R                  " [        US9   U R                  S SS	S
9  S S S 5        S S S 5        g ! , (       d  f       Ni= f! , (       d  f       N(= f! , (       d  f       g = f)Nz(as_index=False only valid with DataFramerV   c                 ó"   • U R                  5       $ rZ   r=  rP   s    r   rR   Ú.test_groupby_as_index_corner.<locals>.<lambda>«  s
   € ˜QŸY™Yœ[r   FrÖ   z$as_index=False only valid for axis=0r]  c                 ó"   • U R                  5       $ rZ   )ÚlowerrP   s    r   rR   rè  ±  s
   €  §¡¤r   rX   )r×   rÇ   )r|   r}   r�  r3   Ú
ValueErrorr9   ru   rv   )r>   rÜ   rƒ   r7  s       r   Útest_groupby_as_index_cornerrì  ¨  s’   € Ø
4€CÜ	�Š”y¨Ó	,Ø
�
‰
Ñ(°5ˆ
Ñ9÷ 
-ð 1€CØ<€HÜ	�Š”z¨Ó	-Ü×'Ò'¬¸XÓFØ�J‰JÑ*°UÀˆJÑC÷ G÷ 
.Ð	-÷ 
-Õ	,ú÷ GÕFú÷ 
.Õ	-ús/   œBÁB3Á-B"Â B3Â
BÂ"
B0	Â,B3Â3
Cc            
      ón  • [        [        R                  R                  S5      R	                  S5      [        [        S5      [        S9[        SSSS9S	9n U R                  S
 S S /5      nUR                  5       n[        R                  " U R                  UR                  5        Sn[        R                  " [        US9   U R                   R                  S S S /SS9nS S S 5        UR#                  S 5      n[        R$                  " UR&                  U R(                  5        [        R                  " U R                   R                  UR                  5        UR#                  S 5      n[        R                  " U R                   R                  UR                  5        g ! , (       d  f       NÈ= f)Nr$   ró   rõ   r•   rö   re   r   r÷   rù   c                 ó   • U R                   $ rZ   rû   rP   s    r   rR   Ú+test_groupby_multiple_key.<locals>.<lambda>º  rþ   r   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   rï  º  r   r   c                 ó   • U R                   $ rZ   r  rP   s    r   rR   rï  º  r  r   r]  rV   c                 ó   • U R                   $ rZ   rû   rP   s    r   rR   rï  Á  s   € �q—v’vr   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   rï  Á  ó   € ¨¯ªr   c                 ó   • U R                   $ rZ   r  rP   s    r   rR   rï  Á  s   € ¸A¿EºEr   rX   rÆ   c                 ó"   • U R                  5       $ rZ   r[   rP   s    r   rR   rï  Ä  ó
   €  !§%¡%¤'r   c                 ó"   • U R                  5       $ rZ   r[   rP   s    r   rR   rï  È  r÷  r   )r   r7   rp   rq   r¡   r
   r4   r  r   r3   r\   r9   Úassert_almost_equalr  ru   rv   rî   rx   Úassert_index_equalr+   rí   )r>   r€   r„   r7  s       r   Útest_groupby_multiple_keyrû  ´  s8  € Ü	Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9Ü”d˜6“l¬&Ñ1Ü˜¨r¸Ñ<ñ
€Bð
 �j‰jÑ*Ñ,=¹ÐOÓP€GØ�K‰K‹M€EÜ×Ò˜2Ÿ9™9 e§l¡lÔ3à<€HÜ	×	#Ò	#¤M¸Ó	BØ—$‘$—,‘,ÙÑ0±/ÐBÈð ð 
ˆ÷ 
Cð
 �K‰KÑ)Ó*€EÜ×Ò˜%Ÿ+™+ r§z¡zÔ2Ü×Ò˜2Ÿ4™4Ÿ;™;¨¯©Ô5à�K‰KÑ)Ó*€EÜ×Ò˜2Ÿ4™4Ÿ;™;¨¯©Õ5÷ 
CÕ	Bús   Ã!F&Æ&
F4c                 ó   • U R                  5       n [        R                  U S'   U R                  SS/5      R	                  5       nU R                  SS/5      R	                  5       n[        R                  US'   [
        R                  " X5        g )NÚbadr   r   )r0   r7   rÁ   r3   rk   r9   r:   )r>   r„   r   s      r   Útest_groupby_multi_cornerrþ  Ì  sk   € à	�‰‹€BÜ—‘€B€u�IØ�J‰J˜˜S�zÓ"×'Ñ'Ó)€Eà�z‰z˜3 ˜*Ó%×*Ñ*Ó,€HÜ—f‘f€HˆU�Oä×Ò˜%Õ*r   c                 ó&  • U R                  S5      n[        R                  " S5      nU(       a  Sn[        R                  " [
        US9   UR                  S5        S S S 5        [        R                  " [
        US9   UR                  5         S S S 5        U R                  S S 2/ SQ4   n [        R                  " 5       U S'   U R                  S5      nSn[        R                  " [
        US9   UR                  S	5        S S S 5        [        R                  " [
        US9   UR                  5         S S S 5        S
n[        R                  " [        US9   U R                  SSSSS.SS9nS S S 5        Sn[        R                  " [
        US9   UR                  S 5        S S S 5        g ! , (       d  f       GNV= f! , (       d  f       GN6= f! , (       d  f       NÔ= f! , (       d  f       N³= f! , (       d  f       N‹= f! , (       d  f       g = f)Nr   rŒ  r�  rV   rk   ©r   r(   r—   r‚  z/datetime64 type does not support sum operationsr\   r]  r   rX   )r   r(   r—   r‚  rÆ   z?does not support reduction 'sum'|Cannot perform reduction 'sum'c                 ó"   • U R                  SSS9$ )Nr   Frf  r[   rP   s    r   rR   Ú)test_raises_on_nuisance.<locals>.<lambda>ñ  s   € ˜aŸe™e A°E˜eÑ:r   )r3   rŽ  r�  r|   r}   r�  rx   rk   rš   r   Únowr\   r9   ru   rv   )r>   r‘  r€   rƒ   r7  s        r   Útest_raises_on_nuisancer  Ø  se  € Ø�j‰j˜‹o€GÜ
�)Š)Ð<Ó
=€CÞØ=ˆÜ	�Š”y¨Ó	,Ø�‰�FÔ÷ 
-ä	�Š”y¨Ó	,Ø�‰Œ÷ 
-ð 
�‰’’?Ð"Ñ	#€BÜ�lŠl‹n€B€s�GØ�j‰j˜‹o€GØ
;€CÜ	�Š”y¨Ó	,Ø�‰�EÔ÷ 
-ä	�Š”y¨Ó	,Ø�‰Œ÷ 
-ð =€HÜ	×	#Ò	#¤M¸Ó	BØ—*‘* 1¨1°1¸1Ñ=ÀA�*ÐFˆ÷ 
Cà
K€CÜ	�Š”y¨Ó	,Ø�‰Ñ:Ô;÷ 
-Ð	,÷' 
-Ö	,úç	,Ö	,ú÷ 
-Õ	,úç	,Õ	,ú÷
 
CÕ	Bú÷ 
-Õ	,úsH   Á
F+Á=F=Ã/GÄ"G ÅG1ÆHÆ+
F:Æ=
GÇ
GÇ 
G.Ç1
G?È
HÚagg_functionrÀ  Úminc                 ó^  • U R                  S5      n[        X!5      " 5       nUR                  5       n[        U R                  U S   S:H  S4   U5      " 5       UR                  S'   [        U R                  U S   S:H  S4   U5      " 5       UR                  S'   [        R
                  " X45        g )Nr   r’   r   )r’   r   r‘   )r‘   r   )r3   rE  r0   rš   r9   r:   )r>   r  r€   r   r   s        r   Útest_keep_nuisance_aggr  ô  s•   € ð �j‰j˜‹o€GÜ�WÔ+Ó-€FØ�{‰{‹}€HÜ& r§v¡v¨b°©g¸Ñ.>ÀÐ.CÑ'DÀlÔSÓU€H‡L�L�ÑÜ& r§v¡v¨b°©g¸Ñ.>ÀÐ.CÑ'DÀlÔSÓU€H‡L�L�ÑÜ×Ò˜&Õ+r   )r\   rk   Úprodr6   ÚvarÚsemÚmedianrg  c                 ó  • U R                  S5      nSnX;   aw  U(       dp  U(       a  SU S3n[        nO/US;   a	  [        nSnO [        n[        R                  " SU S35      n[
        R                  " XvS	9   [        XA5      " US
9  S S S 5        g [        XA5      " US
9nU(       d  US:X  a  / SQn	O/ SQn	[        U R                  S S 2U	4   R                  S5      U5      " US
9n
[        R                  " XŠ5        g ! , (       d  f       g = f)Nr   )r
  r6   r  rk   r	  r  ú(dtype 'str' does not support operation 'Ú')r6   r  z(could not convert string to float: 'one'zagg function failed [how->z,dtype->rV   rf  r\   r–   r   )r3   r�  rë  rŽ  r�  r|   r}   rE  rš   r9   r:   )r>   r  rg  r‘  r€   Úno_drop_nuisancerƒ   Úklassr   rí   r   s              r   Útest_omit_nuisance_aggr    sñ   € ð �j‰j˜‹o€GàFÐØÓ'¶ö Ø<¸\¸NÈ!ÐLˆCÜ‰EØ˜^Ó+ÜˆEØ<‰CäˆEÜ—)’)Ð8¸¸ÀhÐOÓPˆCÜ�]Š]˜5Ó,Ü�GÔ*¸ÒE÷ -Ð,ô ˜Ô/¸\ÑJˆÞ °Ó 5â*‰Gâ%ˆGÜ˜2Ÿ6™6¢! W *Ñ-×5Ñ5°cÓ:¸LÔIØ%ñ
ˆô 	×Ò˜fÕ/÷ -Õ,ús   Á7C<Ã<
D
c                 óÐ   • U R                  S5      n[        nSnU(       a  [        nSn[        R                  " X4S9   UR                  5         S S S 5        g ! , (       d  f       g = f)Nr   zcould not convertz-dtype 'str' does not support operation 'skew'rV   )r3   rë  r�  r|   r}   Úskew)r>   r‘  r€   Úerrrƒ   s        r   Ú$test_raise_on_nuisance_python_singler  '  sG   € à�j‰j˜‹o€Gä
€CØ
€CÞÜˆØ=ˆÜ	�Š�sÓ	&Ø�‰Œ÷ 
'×	&Ö	&ús   ½AÁ
A%c                 óv  • U R                  SS/5      n[        R                  " S5      nU(       a  Sn[        R                  " [
        US9   UR                  S5        S S S 5        [        R                  " [
        US9   UR                  5         S S S 5        g ! , (       d  f       NA= f! , (       d  f       g = f)Nr   r   rŒ  r�  rV   rk   )r3   rŽ  r�  r|   r}   r�  rx   rk   )Úthree_groupr‘  r€   rƒ   s       r   Ú&test_raise_on_nuisance_python_multipler  4  s{   € Ø×!Ñ! 3¨ *Ó-€GÜ
�)Š)Ð<Ó
=€CÞØ=ˆÜ	�Š”y¨Ó	,Ø�‰�FÔ÷ 
-ä	�Š”y¨Ó	,Ø�‰Œ÷ 
-Ð	,÷ 
-Õ	,úç	,Õ	,ús   ÁBÁ?B*Â
B'Â*
B8c           	      ó°  • [        [        R                  " / SQ5      [        R                  " / SQ5      SS/S-  [        R                  R	                  S5      R                  S5      [        R                  R	                  S5      R                  S5      S.5      nUR                  S	S
/5      nUSS/   R                  S5      nUR                  SS9n[        R                  " X45        U SS R                  SS9nUR                  S 5      nUS   R                  S5      n[        R                  " US   U5        UR                  R                  S:X  d   eg )Nrm  rn  r‘   r’   rK   r$   rl  )rs  rt  Úk3rq  rr  rs  rt  rq  rr  rk   Trf  r#   r   ©r   c                 ó"   • U R                  5       $ rZ   rM  rP   s    r   rR   Ú*test_empty_groups_corner.<locals>.<lambda>Q  s
   €  A§F¡F¤Hr   r   rÀ   )r   r7   r¢   rp   rq   r¡   r3   rx   rk   r9   r:   rz   ry   r+   rj   )r�   r>   r€   r   r   r„   Úagged_As          r   Útest_empty_groups_cornerr   ?  s%  € ä	ä—(’(Ò9Ó:Ü—(’(Ò9Ó:Ø˜%�. 1Ñ$Ü—)‘)×'Ñ'¨Ó*×:Ñ:¸1Ó=Ü—)‘)×'Ñ'¨Ó*×:Ñ:¸1Ó=ñ	
ó
€Bð �j‰j˜$ ˜Ó&€GØ�d˜D�\Ñ"×&Ñ& vÓ.€FØ�|‰|¨ˆ|Ð.€HÜ×Ò˜&Ô+à.¨q°Ð3×;Ñ;À!Ð;ÐD€GØ�M‰MÑ,Ó-€EØ�c‰l× Ñ  Ó(€GÜ×Ò˜5 ™: wÔ/Ø�;‰;×Ñ˜wÓ&Ð&Ñ&r   c                  óª   • [        S/5      n Sn[        R                  " [        US9   U R	                  S 5        S S S 5        g ! , (       d  f       g = f)Nr   z5unsupported operand type\(s\) for \+: 'int' and 'str'rV   c                 ó   • U S-   $ )Nr‘   rO   rP   s    r   rR   Ú$test_nonsense_func.<locals>.<lambda>[  s   € ˜Q šYr   )r   r|   r}   r�  r3   )r>   rƒ   s     r   Útest_nonsense_funcr$  W  s9   € Ü	�A�3‹€BØ
B€CÜ	�Š”y¨Ó	,Ø
�
‰
Ñ&Ô'÷ 
-×	,Ö	,ús   ¨AÁ
Ac                 ó²  • U R                   nSUS'   [        R                  " / SQ5      [        R                  " / SQ5      /n[        R                  " S5      nU(       a  Sn[
        R                  " [        US9   UR                  U5      R                  S5        S S S 5        UR                  SS9R                  U5      R                  S5      n[        UR                  [        5      (       d   eS	 n[
        R                  " [        S
S9   UR                  U5      R                  U5        S S S 5        g ! , (       d  f       N¢= f! , (       d  f       g = f)NÚpeekaboo)Úbazrd   ©r   r   rX   rŒ  r�  rV   rk   r¥  c                 óX   • U R                   S:X  a  [        S5      eU R                  5       $ )N)r‘   rc   úTest error message)rj   r�  r\   )r=   s    r   ÚaggfunÚ5test_wrap_aggregated_output_multindex.<locals>.aggfunm  s&   € Ø�8‰8�~Ó%ÜÐ0Ó1Ð1Ø�w‰w‹yÐr   r*  )rî   r7   r¢   rŽ  r�  r|   r}   r�  r3   rx   rÃ  r†  rí   r   rw   )r�   r‘  r>   r„  rƒ   r„   r+  s          r   Ú%test_wrap_aggregated_output_multindexr-  ^  sú   € ð 
*×	+Ñ	+€BØ!€B€|Ñä�HŠH’YÓ¤§¢ª)Ó!4Ð5€DÜ
�)Š)Ð<Ó
=€CÞØ=ˆÜ	�Š”y¨Ó	,Ø
�
‰
�4Ó×Ñ˜VÔ$÷ 
-à�G‰G˜NˆGÐ+×3Ñ3°DÓ9×=Ñ=¸fÓE€EÜ�e—m‘m¤Z×0Ñ0Ð0Ð0òô
 
�Š”yÐ(<Ó	=Ø
�
‰
�4Ó×"Ñ" 6Ô*÷ 
>Ð	=÷ 
-Õ	,ú÷ 
>Õ	=ús   Á:!D7Ä!EÄ7
EÅ
Ec                 ó`  • U R                  SS9R                  5       nUR                  R                  S:X  d   eU R                  SS9R                  5       nUR                  R                  S:X  d   eU S   R                  SS9R                  5       nUR                  R                  S:X  d   eg )Nr   r  rÀ   rX   Úsecondr   )r3   rÁ  r+   rj   )r�   r   s     r   Útest_groupby_level_applyr0  v  s£   € Ø-×5Ñ5¸AÐ5Ð>×DÑDÓF€FØ�<‰<×Ñ Ó'Ð'Ð'Ø-×5Ñ5¸AÐ5Ð>×DÑDÓF€FØ�<‰<×Ñ Ó(Ð(Ð(à-¨cÑ2×:Ñ:ÀÐ:ÐC×IÑIÓK€FØ�<‰<×Ñ Ó'Ð'Ñ'r   c                 óø  • U R                  5       nSSSSS.nSSSS.nU R                  USS9R                  5       nU R                  USS9R                  5       n[        R                  " US    Vs/ s H  obR                  U5      PM     sn[        R                  S9n[        R                  " US    Vs/ s H  ocR                  U5      PM     sn[        R                  S9nU R                  U5      R                  5       n	U R                  U5      R                  5       n
S	u  U	R                  l        U
R                  l        [        R                  " XI5        [        R                  " XZ5        g s  snf s  snf )
Nr   rX   )r‘   r’   r'  Úqux)rc   rd   r“   r  rÀ   r•   r/  )rÀ   r/  )rÇ  r3   r\   r7   r¢   rx  rE   r+   rj   r9   r:   )r�   Ú	deleveledÚmapper0Úmapper1Úresult0r8  rQ   Úmapped_level0Úmapped_level1Ú	expected0Ú	expected1s              r   Útest_groupby_level_mapperr;  €  s@  € Ø0×<Ñ<Ó>€Ià ¨!°AÑ6€GØ ¨AÑ.€Gà.×6Ñ6°wÀaÐ6ÐH×LÑLÓN€GØ.×6Ñ6°wÀaÐ6ÐH×LÑLÓN€Gä—H’HØ!*¨7Ò!3Ó4Ò!3˜A�‰�QŽÑ!3Ñ4¼B¿H¹Hñ€Mô —H’HØ!*¨8Ò!4Ó5Ò!4˜A�‰�QŽÑ!4Ñ5¼R¿X¹Xñ€Mð 1×8Ñ8¸ÓG×KÑKÓM€IØ0×8Ñ8¸ÓG×KÑKÓM€IØ1BÑ.€I‡O�OÔ˜)Ÿ/™/Ô.ä×Ò˜'Ô-Ü×Ò˜'Õ-ùò 	5ùò 	6s   Á1E2Â6E7c            	      óD  • [        / SQ[        / SQSS95      n [        / SQ[        [        SS5      SS95      nU R                  SS	9R	                  5       n[
        R                  " X!5        U R                  S/S	9R	                  5       n[
        R                  " X!5        U R                  S
S	9R	                  5       n[
        R                  " X!5        U R                  S
/S	9R	                  5       n[
        R                  " X!5        Sn[        R                  " [        US9   U R                  SS	9  S S S 5        [        R                  " [        US9   U R                  SS	9  S S S 5        Sn[        R                  " [        US9   U R                  / S	9  S S S 5        Sn[        R                  " [        US9   U R                  SS/S	9  S S S 5        [        R                  " [        US9   U R                  SS/S	9  S S S 5        Sn[        R                  " [        US9   U R                  S/S	9  S S S 5        g ! , (       d  f       GN= f! , (       d  f       Nð= f! , (       d  f       NÎ= f! , (       d  f       Nª= f! , (       d  f       Nˆ= f! , (       d  f       g = f)N)rX   r$   rK   re   rô   r#   rf   rl  )rX   r$   rK   rX   rô   r#   r$   rl  r‘   r¦  )r�  é   rK   rô   r#   rl  rX   r^   r   r  r)   z2level > 0 or level < -1 only valid with MultiIndexrV   éþÿÿÿzNo group keys passed!z*multiple levels only valid with MultiIndex)
r   r
   r5   r3   r\   r9   ry   r|   r}   rë  )Úsr   r   rƒ   s       r   Útest_groupby_level_nonmultir@  —  së  € äÒ)¬5Ò1IÐPUÑ+VÓW€AÜÒ*¬E´%¸¸1³+ÀEÑ,JÓK€Hà�Y‰Y˜QˆYÐ×#Ñ#Ó%€FÜ×Ò˜6Ô,Ø�Y‰Y˜a˜SˆYÐ!×%Ñ%Ó'€FÜ×Ò˜6Ô,Ø�Y‰Y˜RˆYÐ ×$Ñ$Ó&€FÜ×Ò˜6Ô,Ø�Y‰Y˜b˜TˆYÐ"×&Ñ&Ó(€FÜ×Ò˜6Ô,à
>€CÜ	�Š”z¨Ó	-Ø	�	‰	˜ˆ	Ñ÷ 
.ä	�Š”z¨Ó	-Ø	�	‰	˜ˆ	Ñ÷ 
.à
!€CÜ	�Š”z¨Ó	-Ø	�	‰	˜ˆ	Ñ÷ 
.à
6€CÜ	�Š”z¨Ó	-Ø	�	‰	˜˜A˜ˆ	Ñ÷ 
.ä	�Š”z¨Ó	-Ø	�	‰	˜˜A˜ˆ	Ñ÷ 
.à
>€CÜ	�Š”z¨Ó	-Ø	�	‰	˜˜ˆ	Ñ÷ 
.Ð	-÷ 
.Ö	-úç	-Õ	-ú÷ 
.Õ	-ú÷ 
.Õ	-úç	-Õ	-ú÷ 
.Õ	-úsH   Ä"H;ÅIÆIÆ9I/Ç,J È!JÈ;
I
É
IÉ
I,É/
I=Ê 
JÊ
Jc                  óÆ   • [        [        R                  " S5      S-  / SQS9n [        S5      nU R                  SS9R	                  5       n[
        R                  " X!5        g )Nrô   ù      ð?       @)r   r   rX   rX   ©r   r+   )rB  y      @      $@r   r  )r   r7   r8   r3   r\   r9   ry   )r  r   r   s      r   Útest_groupby_complexrD  ·  sM   € ä”B—I’I˜a“L FÑ+²<Ñ@€AÜÐ'Ó(€Hà�Y‰Y˜QˆYÐ×#Ñ#Ó%€FÜ×Ò˜6Õ,r   c                  óâ   • [        SSS.SSS.SSS./5      n U R                  S5      R                  5       n[        S/S//[        SS/SS	9[        S
/5      S9n[        R
                  " X5        g )Nr$   rB  r  rX   ù      ð?      ð?r  r  ç      ø?r¦  r  ©r+   rí   )r   r3   rk   r
   r9   r:   r¬  s      r   Útest_groupby_complex_meanrI  À  s~   € ä	à˜&Ñ!Ø˜&Ñ!Ø˜&Ñ!ð	
ó
€Bð �Z‰Z˜‹_×!Ñ!Ó#€FÜØ
ˆ��ˆÜ�f Ð(¨sÑ3Ü�s�e“ñ€Hô
 ×Ò˜&Õ+r   c                  ó¨  • [        SSS.SSS.SSS./5      n [        [        R                  " / SQ[        R                  S9[	        / SQS	S
9[	        S/5      S9nU R                  S	SS9R                  5       n[        R                  " X!5        [	        / SQS	S
9Ul	        U R                  S	SS9R                  5       n[        R                  " X!5        g )NrX   rF  r  rB  rô   )rX   rX   rX   r•   )rF  rB  ù      ð?        r  r¦  r  rH  F©Úsort)rK  rF  rB  T)
r   r7   r¢   rE   r
   r3   rÁ  r9   r:   r+   ©r>   r   r   s      r   Útest_groupby_complex_numbersrO  Ò  sÀ   € ä	à˜&Ñ!Ø˜&Ñ!Ø˜!Ñð	
ó
€Bô Ü
�Š’¤"§(¡(Ñ+ÜÒ2¸Ñ=Ü�s�e“ñ€Hð
 �Z‰Z˜ %ˆZÐ(×.Ñ.Ó0€FÜ×Ò˜&Ô+ô Ò9ÀÑD€H„NØ�Z‰Z˜ $ˆZÐ'×-Ñ-Ó/€FÜ×Ò˜&Õ+r   c                  óR  • [        / SQ[        / SQ5      S9n [        / SQ[        / SQ5      S9nU R                  U5      nUR                  5       nU R                  UR	                  U R
                  5      R                  5      R                  5       n[        R                  " X45        g )N)ç      @g      "Àr  g      Y@g      Àg     €K@gÍÌÌÌÌÌ@)r  r  r#  ÚdrÂ   rË   rÞ   r*   )r  r  r  rQ  rQ  g      @)r  r  rR  rË   rÞ   Úh)	r   r
   r3   rk   rs   r+   rx  r9   ry   )Ús1Ús2r€   r„   r¢  s        r   Ú'test_groupby_series_indexed_differentlyrV  é  s�   € Ü	Ú0ÜÒ7Ó8ñ
€Bô 
Ú&¬eÒ4RÓ.Sñ
€Bð �j‰j˜‹n€GØ�L‰L‹N€EØ
�*‰*�R—Z‘Z §¡Ó)×-Ñ-Ó
.×
3Ñ
3Ó
5€CÜ×Ò˜5Õ&r   c                  ó’  • [        [        / SQ/ SQ/6 5      n [        R                  " U 5      n[        R                  " / SQ5      n[	        [
        R                  R                  S5      R                  S5      XS9nUR                  SS9R                  5       n[        R                  " UR                  U5        S	n[        R                  " [        US
9   UR                  SSS9nS S S 5        WR                  5       n[        R                  " UR                   UR                   5        UR                  SS9R#                  S5      n[        R                  " UR                  U5        UR                  SS9R%                  S 5      n[        R                  " UR                  U5        [        R                  " [        US
9   UR                  SSS9nS S S 5        UR#                  S 5      n[        R                  " UR                  ['        SS/5      5        [        R                  " UR                   UR                   5        UR)                  S5      u  pxSUS'   UR                  SS9R                  SS9n[        R                  " UR                  UR                  S S 5        g ! , (       d  f       GNÇ= f! , (       d  f       Nì= f)N)r’   r’   r'  r'  r‘   r‘   r2  r2  )rc   rd   rc   rd   rc   rd   rc   rd   ))r   Úcat)r   Údog)r   rX  )r   rY  r$   )r”   rô   rH  r   r  r]  rV   rX   )r   rÇ   rk   c                 ó"   • U R                  5       $ rZ   rM  rP   s    r   rR   Ú0test_groupby_with_hier_columns.<locals>.<lambda>  s
   € °·±´r   c                 ó$   • U R                  S5      $ )NrX   rM  rP   s    r   rR   r[    s   € ˜aŸf™f Qœir   r   r   r’   )r   r‘   Trf  r)   )r4   rà  r   r™  r   r7   rp   rq   r¡   r3   rk   r9   rú  rí   ru   rv   r+   rx   rz   r
   Ú	sortlevel)	Útuplesr+   rí   r>   r   r7  r?   Úsorted_columnsÚ_s	            r   Útest_groupby_with_hier_columnsra  ø  s'  € ÜÜâHÚHðð	
ó€Fô ×"Ò" 6Ó*€EÜ×$Ò$Ú@ó€Gô 
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó8Àñ
€Bð �Z‰Z˜aˆZÐ ×%Ñ%Ó'€FÜ×Ò˜&Ÿ.™.¨'Ô2à<€HÜ	×	#Ò	#¤M¸Ó	BØ�Z‰Z˜a aˆZÐ(ˆ÷ 
Cà�W‰W‹Y€FÜ×Ò˜&Ÿ,™,¨¯©Ô1à�Z‰Z˜aˆZÐ ×$Ñ$ VÓ,€FÜ×Ò˜&Ÿ.™.¨'Ô2à�Z‰Z˜aˆZÐ ×&Ñ&Ñ'9Ó:€FÜ×Ò˜&Ÿ.™.¨'Ô2ä	×	#Ò	#¤M¸Ó	BØ�Z‰Z˜a aˆZÐ(ˆ÷ 
Cà�V‰VÑ'Ó(€FÜ×Ò˜&Ÿ.™.¬%°°c°
Ó*;Ô<Ü×Ò˜&Ÿ,™,¨¯©Ô1ð  ×)Ñ)¨!Ó,Ñ€NØ€B€z�NØ�Z‰Z˜aˆZÐ ×%Ñ%°4Ð%Ð8€FÜ×Ò˜&Ÿ.™.¨"¯*©*°S°b¨/Õ:÷+ 
CÖ	Bú÷ 
CÕ	Bús   ÃJ&ÇJ8Ê&
J5Ê8
Kc                 óò   • U R                  U S   R                  5      nU R                  U S   R                  S 5      5      nUR                  5       nUR                  5       n[        R
                  " X45        g )Nr   )r3   r  rÄ  r\   r9   r:   )r>   r€   rØ  r   r   s        r   Útest_grouping_ndarrayrc  %  sW   € Ø�j‰j˜˜C™Ÿ™Ó(€GØ�z‰z˜"˜S™'Ÿ.™.¨Ó.Ó/€Hà�[‰[‹]€FØ�|‰|‹~€HÜ×Ò˜&Õ+r   c                  óä   • [        / SQSS9n [        / SQ/ SQ/ SQ/ SQ/ SQS	.U S
9nUR                  / SQ5      nUR                  S5      nUR	                  5       n[
        R                  " X45        g )N©r   rX   r$   rK   rô   r+   r¦  )Úfoo1rf  Úfoo2rf  Úfoo3)Úbar1Úbar2rj  ri  ri  )Úbaz1rk  rk  Úbaz2rl  )Úspam2Úspam3rm  Úspam1ro  )rf   rg   é(   r»  é<   )r‘   r’   r'  Úspamr   r*   )r‘   r’   r'  rr  rk   )r
   r   r3   rx   rk   r9   r:   )r+   r   r€   r   r   s        r   Útest_groupby_wrong_multi_labelsrs  .  si   € Ü’/¨Ñ0€EÜâ;Ú;Ú;ÚAÚ(ñ	
ð ñ	€Dð �l‰lÒ8Ó9€Gà�[‰[˜Ó €FØ�|‰|‹~€HÜ×Ò˜&Õ+r   c                 óÀ  • U R                  U S   5      R                  SS9nU R                  U S   SS9R                  SS9nUR                  R                  S:X  d   eSU;   d   eU R                  U S   U S   /5      R                  5       nU R                  U S   U S   /SS9R                  5       nUR                  R                  S:X  d   eSU;   d   eSU;   d   eg )Nr   Trf  FrÖ   r   ©r   r   )r3   rk   r+   rj   r&  ©r>   r   r9  s      r   Útest_groupby_series_with_namerw  B  sæ   € Ø�Z‰Z˜˜3™Ó ×%Ñ%°4Ð%Ð8€FØ�j‰j˜˜C™¨5ˆjÐ1×6Ñ6ÀDÐ6ÐI€GØ�<‰<×Ñ Ó#Ð#Ð#Ø�'‹>Ðˆ>à�Z‰Z˜˜C™ " S¡'Ð*Ó+×0Ñ0Ó2€FØ�j‰j˜"˜S™' 2 c¡7Ð+°eˆjÐ<×AÑAÓC€GØ�<‰<×Ñ Ó+Ð+Ð+Ø�'‹>Ðˆ>Ø�'‹>Ð‰>r   c                 óô   • U R                  S5      S   nUR                  5       R                  S:X  d   eUR                  5       R                  S:X  d   eS nUR	                  U5      R                  S:X  d   eg )Nr   r(   c                 ó4   • [         R                  " U 5      S-  $ ro   )r7   r\   rP   s    r   rR   Ú.test_seriesgroupby_name_attr.<locals>.<lambda>U  s   € œŸš › Qšr   )r3   rÁ  rj   rk   rx   )r>   r   ÚtestFuncs      r   Útest_seriesgroupby_name_attrr|  O  sj   € à�Z‰Z˜‹_˜SÑ!€FØ�<‰<‹>×Ñ #Ó%Ð%Ð%Ø�;‰;‹=×Ñ Ó$Ð$Ð$á&€HØ�:‰:�hÓ×$Ñ$¨Ó+Ð+Ñ+r   c                  ó˜  • [        / SQ/ SQ[        R                  R                  S5      R	                  S5      S-   [        R
                  " S5      S.5      n U R                  S/5      R                  R                  5       nU R                  R                  U R                  5      R                  5       n[        R                  " X!5        g )Nr�   )rc   rc   rd   rd   rd   rd   rc   rd   r$   r”   r  r–   r   )r   r7   rp   rq   r¡   r8   r3   r   rÁ  r   r9   ry   rN  s      r   Útest_consistency_namer~  Y  s”   € ô 
âIÚIÜ—‘×&Ñ& qÓ)×9Ñ9¸!Ó<¸sÑBÜ—’˜1“ñ		
ó
€Bð �z‰z˜3˜%Ó ×"Ñ"×(Ñ(Ó*€HØ�T‰T�\‰\˜"Ÿ$™$Ó×%Ñ%Ó'€FÜ×Ò˜6Õ,r   c                 ó¨  • SS jnS nSn[         R                  " [        US9   U R                  S5      R	                  U5      nS S S 5        WR
                  R                  b   e[         R                  " [        US9   U R                  S5      R	                  US5      nS S S 5        UR
                  R                  S:X  d   e[         R                  " [        US9   U R                  S5      R	                  U5      nS S S 5        UR
                  R                  b   eg ! , (       d  f       Nâ= f! , (       d  f       N—= f! , (       d  f       NJ= f)Nc                 ó   • [        SSSS.US9$ )NrX   r$   rK   ©rÁ  rk   Ú	omissionsr¦  )r   )r>   rj   s     r   Ú	summarizeÚ0test_groupby_name_propagation.<locals>.summarizel  s   € Ü ¨1¸1Ñ=ÀDÑIÐIr   c                 ó>   • [        SSSS.U R                  S   S   S9$ )NrX   r$   rK   r�  r   r   r¦  )r   r2   r  s    r   Úsummarize_random_nameÚ<test_groupby_name_propagation.<locals>.summarize_random_nameo  s$   € ô  ¨1¸1Ñ=ÀBÇGÁGÈAÁJÈsÁOÑTÐTr   r    rV   r   ÚmetricsrZ   )r9   ru   rv   r3   rz   rí   rj   )r>   rƒ  r†  rƒ   rˆ  s        r   Útest_groupby_name_propagationr‰  j  sÿ   € ôJòUð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—*‘*˜S“/×'Ñ'¨	Ó2ˆ÷ 
>à�?‰?×ÑÑ'Ð'Ð'Ü	×	#Ò	#¤M¸Ó	=Ø—*‘*˜S“/×'Ñ'¨	°9Ó=ˆ÷ 
>à�?‰?×Ñ 9Ó,Ð,Ð,Ü	×	#Ò	#¤M¸Ó	=Ø—*‘*˜S“/×'Ñ'Ð(=Ó>ˆ÷ 
>à�?‰?×ÑÑ'Ð'Ñ'÷ 
>Õ	=ú÷ 
>Õ	=ú÷ 
>Õ	=ús#   ¤!D!Á?"D2Ã!EÄ!
D/Ä2
E Å
Ec                  ó2  • [        [        S5       V s/ s H  n [        R                  " S5      PM     sn 5      nUR	                  S5      nUR                  5       nUR	                  US   5      R                  5       n[        R                  " X45        g s  sn f )Nre   r   )r   r5   r7   r8   r3   rk   r9   r:   )rQ   r>   r€   r   r   s        r   Útest_groupby_nonstring_columnsr‹  �  sm   € Ü	¬5°¬9Ó5ª9 a”B—I’I˜b–M©9Ñ5Ó	6€BØ�j‰j˜‹m€GØ�\‰\‹^€FØ�z‰z˜"˜Q™%Ó ×%Ñ%Ó'€HÜ×Ò˜&Õ+ùò	 6s   “ Bc            	      ó(  • [        / SQ// SQS9n [        SS//SS/[        S/SS	9S
9nU R                  S5      R                  5       n[        R
                  " X!5        U R                  S5      R                  5       n[        R
                  " X!5        g )Nrh   )r   r   r   r¥  rX   r$   r   r   r   r¦  rù   )r   r
   r3   rÀ   r9   r:   r\   rN  s      r   Útest_groupby_mixed_type_columnsr�  ‰  sy   € ä	’I�;ªÑ	6€BÜ˜1˜a˜&˜¨C°¨8¼5À!ÀÈ3Ñ;OÑP€Hà�Z‰Z˜‹_×"Ñ"Ó$€FÜ×Ò˜&Ô+à�Z‰Z˜‹_× Ñ Ó"€FÜ×Ò˜&Õ+r   c                  óx  • [         R                  " S5      n U R                  [         R                  5        [	        U S S 2S4   5      n[         R
                  " [        S5      S5      nUR                  U5      R                  [        R                  5      nUR                  5       R                  5       (       d   eg )N)rº  rº  r   re   )r7   r'  ÚfillrÁ   r   Útiler5   r3   rx   r  ÚisnarU  )Úarrr±  Úindsr   s       r   Ú(test_cython_grouper_series_bug_noncontigr”  •  s~   € Ü
�(Š(�:Ó
€CØ‡H�HŒR�V‰VÔÜ
�’Q˜�T‘Ó
€CÜ�7Š7”5˜“9˜bÓ!€Dà�[‰[˜Ó×"Ñ"¤6§=¡=Ó1€FØ�;‰;‹=×Ñ×ÑÐÑr   c                  óD  • [        S/S-  5      n [        [        R                  R	                  S5      R                  S5      U S S S2   S9n[        R                  R	                  S5      R                  SSS5      nUR                  U5      nS nUR                  U5        g )	NÚ
aaaaaaaaaarº  r$   r»  r*   r   r#   c                 óZ   • [        [        [        [        U R                  5      5      5      $ rZ   )rt   ÚsetÚmapÚidr+   rP   s    r   rR   Ú5test_series_grouper_noncontig_index.<locals>.<lambda>©  s   € ”#”cœ#œb !§'¡'Ó*Ó+Ô,r   )	r
   r   r7   rp   rq   r¡   rÅ  r3   rx   )r+   r  r  r€   rË   s        r   Ú#test_series_grouper_noncontig_indexrœ  Ÿ  s‡   € Ü�8�*˜sÑ"Ó#€Eä”B—I‘I×)Ñ)¨!Ó,×<Ñ<¸RÓ@ÈÉcÐPQÈcÉ
ÑS€FÜ�Y‰Y×"Ñ" 1Ó%×.Ñ.¨q°!°RÓ8€Fð �n‰n˜VÓ$€Gñ 	-€AØ‡K�K�…Nr   c                  óÜ  • [        [        S5      5      n [        R                  " / SQSS9nS nS nU R	                  U5      nUR                  U5      nUR                  [        R                  :X  d   e[        UR                  S   [        5      (       d   eUR                  U5      nUR                  [        R                  :X  d   e[        UR                  S   [        5      (       d   eg )Nr#   )r  r  r#  rR  rÂ   r‰   r•   c                 óF   • [        [        U R                  5       5      5      $ rZ   )r   Ústrrk   rP   s    r   Úconvert_fastÚ>test_convert_objects_leave_decimal_alone.<locals>.convert_fast±  s   € Ü”s˜1Ÿ6™6›8“}Ó%Ð%r   c                 ó�   • [        U R                  R                  5      S:”  d   e[        [	        U R                  5       5      5      $ r¬   )rt   r  Úbaser   rŸ  rk   rP   s    r   Úconvert_force_pureÚDtest_convert_objects_leave_decimal_alone.<locals>.convert_force_pure´  s2   € ä�1—8‘8—=‘=Ó! AÓ%Ð%Ð%Ü”s˜1Ÿ6™6›8“}Ó%Ð%r   r   )r   r5   r7   r¢   r3   rx   rD   Úobject_r†  r2   r   )r?  r  r   r¤  r€   r   s         r   Ú(test_convert_objects_leave_decimal_aloner§  ­  sº   € ÜŒu�Q‹xÓ€AÜ�XŠXÒ/°sÑ;€Fò&ò&ð
 �i‰i˜Ó€Gà�[‰[˜Ó&€FØ�<‰<œ2Ÿ:™:Ó%Ð%Ð%Ü�f—k‘k !‘n¤g×.Ñ.Ð.Ð.à�[‰[Ð+Ó,€FØ�<‰<œ2Ÿ:™:Ó%Ð%Ð%Ü�f—k‘k !‘n¤g×.Ñ.Ð.Ñ.r   c            	      óR  • [        / [        R                  " SSS9S.5      n U S   R                  [        R                  :X  d   eU R                  S5      R                  5       n[        / S[        R                  S9n[        S[        / USS905      n[        R                  " XS	S
9  g )Nr   rE   r•   )rQ   r5   rQ   ©rj   rD   r5   rL   T)Ú	by_blocks)r   r7   r8   rD   rG   r3   rÀ   r
   r   r9   r:   )r>   r   Ú	exp_indexr   s       r   Ú"test_groupby_dtype_inference_emptyr¬  Ä  s†   € ä	˜¤b§i¢i°¸Ñ&AÑBÓ	C€BØˆc‰7�=‰=œBŸJ™JÓ&Ð&Ð&à�Z‰Z˜‹_×"Ñ"Ó$€FÜ�b˜s¬"¯*©*Ñ5€IÜ˜'¤6¨"°IÀWÑ#MÐNÓO€HÜ×Ò˜&°dÓ;r   c                  óæ   • [        S/S/S/S.5      n U R                  SS/5      S   R                  5       n[        S/[        R
                  " S/S//SS/S9SS9n[        R                  " X5        g )	NrX   l    4;PUÑ  )rÀ   r/  r˜   rÀ   r/  r˜   r—  r¦  )r   r3   rÀ  r   r   Úfrom_productr9   ry   r¬  s      r   Ú$test_groupby_unit64_float_conversionr¯  Ï  s|   € ä	˜a˜S¨Q¨CÐ;OÐ:PÑQÓ	R€BØ�Z‰Z˜ (Ð+Ó,¨WÑ5×9Ñ9Ó;€FÜØ	ÐÜ×Ò !  q c 
°7¸HÐ2EÑFØñ€Hô
 ×Ò˜6Õ,r   c                 ó€  • U R                  [        U S   5      5      R                  SS9nU R                  U S   5      R                  SS9n[        R                  " XSS9  [
        R                  " [        SS9   U R                  [        U S   S S 5      5        S S S 5        [        S	S
/SS/[        R                  R                  S5      R                  S5      S.5      n U R                  SS/5      R                  5       nU R                  U S   U S   /5      R                  5       S/   ng ! , (       d  f       Nš= f)Nr   Trf  FrÙ   z^'foo'$rV   r)   r   rX   rK   rô   r$   )r‘   r’   Úvalr‘   r’   r±  )r3   r4   rk   r9   r:   r|   r}   ÚKeyErrorr   r7   rp   rq   r¡   r¬  s      r   Ú"test_groupby_list_infer_array_liker³  Û  s  € Ø�Z‰Zœ˜R ™W›Ó&×+Ñ+¸Ð+Ð>€FØ�z‰z˜"˜S™'Ó"×'Ñ'°TÐ'Ð:€HÜ×Ò˜&¸Ò>ä	�Š”x zÓ	2Ø
�
‰
”4˜˜3™  ˜Ó%Ô&÷ 
3ô 
à�q�6Ø�q�6Ü—9‘9×(Ñ(¨Ó+×;Ñ;¸AÓ>ñ	
ó
€Bð �Z‰Z˜ ˜Ó'×,Ñ,Ó.€FØ�z‰z˜2˜e™9 b¨¡iÐ0Ó1×6Ñ6Ó8¸%¸ÑA�H÷ 
3Õ	2ús   Á:!D/Ä/
D=c                  ó4  • Sn [        [        S5      SU S9n[        SS/SS//S	S
/US9nUR                  [	        SU S9S	/5      R                  5       nUR                  UR                  S	/5      R                  [        5      n[        R                  " X45        g )Nr?  z2015-09-29T11:34:44-0700r$   )Ústartr"   rø   r   re   r   é   Úmetricr  rù   r   )r   rø   )r   r   r   r3   r	   rk   r(  r+   r‹   r  r9   r:   )rø   r+   r>   r   r   s        r   Ú$test_groupby_keys_same_size_as_indexr¸  ð  s“   € à€DÜÜÐ2Ó3¸QÀTñ€Eô 
�S˜"�I  R˜yÐ)°H¸hÐ3GÈuÑ	U€BØ�Z‰Zœ q¨tÑ4°hÐ?Ó@×EÑEÓG€FØ�|‰|˜RŸX™X xÐ0Ó1×8Ñ8¼Ó?€Hä×Ò˜&Õ+r   c                  ó  • Sn [        [        R                  R                  S5      R	                  S5      [        S5      S9n[        R                  " [        U S9   UR                  S5        S S S 5        [        [        R                  R                  S5      R	                  S5      [        S5      S9n[        R                  " [        U S9   UR                  S5        S S S 5        g ! , (       d  f       N�= f! , (       d  f       g = f)	Nz^'Z'$r$   )rX   rô   rõ   r¥  rV   ÚZ)r$   rô   )
r   r7   rp   rq   r¡   r4   r|   r}   r²  r3   )rƒ   Údf1r6  s      r   Útest_groupby_one_rowr¼  ý  s¸   € à
€CÜ
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó8Ä$ÀvÃ,ñ€Cô 
�Š”x sÓ	+Ø�‰�CÔ÷ 
,ä
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó8Ä$ÀvÃ,ñ€Cô 
�Š”x sÓ	+Ø�‰�CÔ÷ 
,Ð	+÷ 
,Õ	+ú÷
 
,Õ	+ús   ÁC(ÃC9Ã(
C6Ã9
Dc                  ó`	  • [        [        R                  R                  S5      R	                  S5      [        R
                  [        S5      [        R
                  [        S5      [        R
                  [        S5      [        R
                  [        S5      /[        R
                  S[        R
                  S[        R
                  S[        R
                  S/S.5      n U R                  S5      n[        S	S
/5      [        SS/5      /n[        UR                  R                  5       5      n[        U5      S:X  d   e[        X25       H)  u  pE[        R                  " UR                  U   U5        M+     [        R                   " UR"                  R$                  S   R&                  U 5        UR(                  S:X  d   e[        S5      [        R*                  " S	S
/[        R,                  S9[        S5      [        R*                  " SS/[        R,                  S90nUR.                   H)  n[        R0                  " UR.                  U   X$   5        M+     [        R                   " UR3                  [        S5      5      U R4                  S	S
/   5        [        R                   " UR3                  [        S5      5      U R4                  SS/   5        [6        R8                  " [:        SS9   UR3                  [<        R>                  5        S S S 5        [        [        R
                  [        R
                  [        R
                  /[<        R>                  [<        R>                  [<        R>                  /S.5      nUS   R@                  S:X  d   eUS   R@                  S:X  d   eS HÌ  nUR                  U5      nUR                  0 :X  d   eUR(                  S:X  d   eUR.                  0 :X  d   e[6        R8                  " [:        SS9   UR3                  [        R
                  5        S S S 5        [6        R8                  " [:        SS9   UR3                  [<        R>                  5        S S S 5        MÎ     g ! , (       d  f       GNt= f! , (       d  f       Nf= f! , (       d  f       GM  = f)Nr$   r”   z
2013-01-01z
2013-02-01r  r  )r  ÚdtrŸ  r¾  rX   r^   rK   r#   r   z2013-01-01 00:00:00r•   z2013-02-01 00:00:00z^NaT$rV   )rÁ   ÚnatrÁ   rG   r¿  zdatetime64[ns]z^nan$)!r   r7   rp   rq   r¡   rÁ   r   r3   r
   ÚsortedrQ  r„  rt   rà  r9   rú  r:   Ú_grouperr  r±  Úngroupsr¢   ÚintprR  Úassert_numpy_array_equalr«  r2   r|   r}   r²  r-   r1   rD   )r>   r€   r   r„  r�   rÂ   Únan_dfr   s           r   Útest_groupby_nat_excluderÆ    s_  € ä	ä—i‘i×+Ñ+¨AÓ.×>Ñ>¸qÓAä—‘Ü˜,Ó'Ü—‘Ü˜,Ó'Ü—‘Ü˜,Ó'Ü—‘Ü˜,Ó'ð	ô —F‘F˜C¤§¡¨¬b¯f©f°c¼2¿6¹6À3ÐGñ	
ó
€Bð  �j‰j˜Ó€Gä�q˜!�f“œu a¨ V›}Ð-€HÜ�'—.‘.×%Ñ%Ó'Ó(€DÜˆt‹9˜‹>Ðˆ>Ü�DÖ#‰ˆô 	×Ò˜gŸn™n¨QÑ/°Ö3ñ $ô ×Ò˜'×*Ñ*×4Ñ4°QÑ7×;Ñ;¸RÔ@Ø�?‰?˜aÓÐÐô 	Ð'Ó(¬"¯(ª(°A°q°6ÄÇÁÑ*IÜÐ'Ó(¬"¯(ª(°A°q°6ÄÇÁÑ*Ið€Hð
 �_Œ_ˆÜ
×#Ò# G§O¡O°AÑ$6¸¹ÖDñ ô ×Ò˜'×+Ñ+¬I°lÓ,CÓDÀbÇgÁgÈqÐRSÈfÁoÔVÜ×Ò˜'×+Ñ+¬I°lÓ,CÓDÀbÇgÁgÈqÐRSÈfÁoÔVä	�Š”x xÓ	0Ø×Ñœ"Ÿ&™&Ô!÷ 
1ô Ü—‘œŸ™¤§¡Ð(´"·&±&¼"¿&¹&Ä"Ç&Á&Ð1IÑJó€Fð �%‰=×Ñ )Ó+Ð+Ð+Ø�%‰=×ÑÐ"2Ó2Ð2Ð2ãˆØ—.‘. Ó%ˆØ�~‰~ Ó#Ð#Ð#Ø�‰ !Ó#Ð#Ð#Ø�‰ "Ó$Ð$Ð$Ü�]Š]œ8¨8Ó4Ø×ÑœbŸf™fÔ%÷ 5ä�]Š]œ8¨8Ó4Ø×ÑœbŸf™fÔ%÷ 5Ñ4ò ÷ 
1Ö	0ú÷ 5Õ4úç4×4ús$   Ë- Q:Ð RÑ RÑ:
R	Ò
R	Ò
R-	c                  óè   • [        [        R                  [        R                  /[        R                  [        R                  /SS/S.5      n U R                  SS/5      R                  nU0 :X  d   eg )NrX   r$   r4  r  r  )r   r7   rÁ   r3   rR  )r>   r   s     r   Ú#test_groupby_two_group_keys_all_nanrÈ  K  sU   € ä	œ"Ÿ&™&¤"§&¡&Ð)´·±¼¿¹Ð0@ÈÈ1ÀvÑNÓ	O€BØ�Z‰Z˜˜c˜
Ó#×+Ñ+€FØ�R‹<Ð‰<r   c                  óp  • [        [        S5      S9n SS/U S'   SS/U S'   SS/U S	'   S
S/U S'   U R                  S/5      R                  SS9n[        R
                  " SS/SS//5      n[        R                  " UR                  [        SS	/5      5        [        R                  " UR                  U5        g )Nr$   r*   Úg1Úg2r�   r   ÚzerosrX   r  Úl1Úl2ÚlabelTrf  ç        r  )r   r5   r3   rk   r7   r¢   r9   rú  rí   r
   rÄ  r  )rR  ÚtmpÚ
res_valuess      r   Útest_groupby_2d_malformedrÓ  R  s¯   € Üœ˜a›Ñ!€AØ˜�€A€g�JØ�Q�€A€g�JØ�A�€A€f�IØ˜�€A€g�JØ
�)‰)�W�IÓ
×
#Ñ
#°Ð
#Ð
6€CÜ—’˜C ˜:¨¨S zÐ2Ó3€JÜ×Ò˜#Ÿ+™+¤u¨g°vÐ->Ó'?Ô@Ü×Ò §
¡
¨JÕ7r   c            	      ó  • [         R                  " [         R                  " S5      [         R                  " S5      [         R                  " S5      45      n [         R                  " S5      n[        UU UU [         R                  R                  S5      R                  S5      S.5      nUR                  / SQ5      R                  5       nUR                  / SQ5      R                  5       n[        U5      [        U5      :X  d   eg )Nr    iˆ  i¨a  r$   )r   r   r(   r—   r‚  r–   )r—   r(   r   r   )
r7   Úconcatenater8   r   rp   rq   r¡   r3   r\   rt   )r   r   r>   r¶  rÎ  s        r   Útest_int32_overflowrÖ  ^  s¿   € Ü
�ŠœŸ	š	 %Ó(¬"¯)ª)°EÓ*:¼B¿IºIÀd»OÐLÓM€AÜ
�	Š	�%Ó€AÜ	àØØØÜ—‘×&Ñ& qÓ)×9Ñ9¸%Ó@ñ	
ó
€Bð �:‰:Ò*Ó+×/Ñ/Ó1€DØ�J‰JÒ+Ó,×0Ñ0Ó2€EÜˆt‹9œ˜E›
Ó"Ð"Ñ"r   c                  óì  • [        / SQ/ SQ/ SQ[        R                  R                  S5      R	                  S5      S.5      n U / SQ   R
                   Vs/ s H  n[        U5      PM     nn[        R                  " U5      nU R                  / SQSS	9R                  5       n[        R                  " UR                  R
                  U/ S
Q   5        U / SQ   R
                   Vs/ s H  n[        U5      PM     nn[        R                  " U5      nU R                  / SQSS	9R                  5       n[        R                  " UR                  R
                  U5        U / SQ   R
                   Vs/ s H  n[        U5      PM     nn[        R                  " U5      nU R                  / SQSS	9R                  5       n[        R                  " UR                  R
                  U/ SQ   5        [        / SQ/ SQ[        R                  R                  S5      R	                  S5      S.5      n U R                  SS/5      S   nUR                  5       nS 4S jnU" XSS/S5        g s  snf s  snf s  snf )N©r‘   r’   r'  )rK   r$   rX   rh   r$   rK   ©r  r  r#  rR  r4  TrL  )rX   r$   r   )r#  r  r  )r  r#  r  )r$   rX   r   ©r   rX   r$   r   rX   r$   )r   r   r   rX   rX   rX   rl  )r  r  rR  r  r  rR  c                 ó"   • U R                  5       $ rZ   r[   rP   s    r   rR   Ú)test_groupby_sort_multi.<locals>.<lambda>“  s
   € ¸A¿E¹E¼Gr   c                 ó  • X   R                    Vs/ s H  n[        U5      PM     nn[        R                  " U5      nU" U R	                  U5      U   5      nUR                  5        H  u  p‰X   U	:X  a  M   e   g s  snf rZ   )r  ÚtupleÚcomÚasarray_tuplesafer3   rS  )
r>   r   r„  ÚfieldrË   ÚrowÚtupsr   r�   r‚   s
             r   Ú_check_groupbyÚ/test_groupby_sort_multi.<locals>._check_groupby“  sn   € Ø&(¡h§o¢oÓ6¢o˜s”�c–
¡oˆÐ6Ü×$Ò$ TÓ*ˆÙ�R—Z‘Z Ó% eÑ,Ó-ˆØ—N‘NÖ$‰DˆAØ‘9 •>Ð!�>ò %ùò 7s   ‘A<)r   r7   rp   rq   r¡   r  rÞ  rß  rà  r3   r\   r9   rÄ  r+   )r>   râ  rã  r   rQ   r€   rä  s          r   Útest_groupby_sort_multiræ  p  sÿ  € Ü	â&ÚÚÜ—‘×&Ñ& qÓ)×9Ñ9¸!Ó<ñ		
ó
€Bð #%¢_Ñ"5×"<Ò"<Ó=Ò"<˜3ŒE�#ŽJÑ"<€DÐ=Ü× Ò  Ó&€DØ�Z‰Zš¨dˆZÐ3×7Ñ7Ó9€FÜ×Ò §¡× 3Ñ 3°Tº)±_ÔEà"$¢_Ñ"5×"<Ò"<Ó=Ò"<˜3ŒE�#ŽJÑ"<€DÐ=Ü× Ò  Ó&€DØ�Z‰Zš¨dˆZÐ3×7Ñ7Ó9€FÜ×Ò §¡× 3Ñ 3°TÔ:à ¢Ñ1×8Ò8Ó9Ò8˜ŒE�!ŽHÑ8€DÐ9Ü× Ò  Ó&€DØ�Z‰Zš¨dˆZÐ3×7Ñ7Ó9€FÜ×Ò §¡× 3Ñ 3°Tº)±_ÔEä	â#Ú#Ü—‘×&Ñ& qÓ)×9Ñ9¸!Ó<ñ	
ó
€Bð �j‰j˜#˜s˜Ó$ SÑ)€GØ�[‰[‹]€Fá2Cô "ñ �2  S˜z¨3Õ/ùòA >ùò
 >ùò
 :s   ÁI'Ã&I,Å1I1c                  ó  • [        / SQ/ SQS-  S.5      n Sn[        R                  " [        US9   U R	                  SSS	9R                  S
 5      nS S S 5        [        R                  " WU 5        g ! , (       d  f       N&= f)N)r  r  r  r  r  r  rØ  r$   )r   rj   r    rV   r   FrT   c                 ó   • U $ rZ   rO   rP   s    r   rR   Ú/test_dont_clobber_name_column.<locals>.<lambda>¤  s   € ÁQr   )r   r9   ru   rv   r3   rz   r:   )r>   rƒ   r   s      r   Útest_dont_clobber_name_columnrê  �  sn   € Ü	Ú.Ò8MÐPQÑ8QÑRó
€Bð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜E¨e�Ð4×:Ñ:¹;ÓGˆ÷ 
>ä×Ò˜& "Õ%÷ 
>Õ	=ús   ±!A2Á2
B c            
      ó¢  • [        [        R                  R                  S5      R	                  S5      [        [        S5      [        S9[        SSSS9S	9n U R                  S
 SS9nUR                  S 5      nU VVs/ s H  u  p4UR                  SS9S S PM     nnn[        R                  " U5      n[        R                  " X&5        U S   R                  S SS9nUR                  S 5      nU VVs/ s H  u  p4UR                  5       S S PM     nnn[        R                  " U5      n[        R                   " X&5        g s  snnf s  snnf )Nr$   ró   rõ   r•   rö   re   r   r÷   rù   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   Ú&test_skip_group_keys.<locals>.<lambda>¯  s   €  A§G¢Gr   FrT   c                 ó&   • U R                  SS9S S $ )Nr   ©rµ  rK   ©Úsort_valuesrP   s    r   rR   rí  °  s   €  Q§]¡]°c ]Ð%:¸2¸AÑ%>r   r   rï  rK   c                 ó   • U R                   $ rZ   rÑ   rP   s    r   rR   rí  ·  rô  r   c                 ó(   • U R                  5       S S $ rN   rð  rP   s    r   rR   rí  ¸  s   €  Q§]¡]£_°R°aÑ%8r   )r   r7   rp   rq   r¡   r
   r4   r  r   r3   rz   rñ  r-   r…  r9   r:   ry   )Útsfr€   r   r   r�   Úpiecesr   s          r   Útest_skip_group_keysrö  ¨  s%  € Ü
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9Ü”d˜6“l¬&Ñ1Ü˜¨r¸Ñ<ñ€Cð �k‰kÑ+¸ˆkÐ>€GØ�]‰]Ñ>Ó?€Fá>EÔFºg±
°ˆe×Ñ 3ÐÐ'¨¨Ó+¹g€FÑFä�yŠy˜Ó €HÜ×Ò˜&Ô+à�#‰h×ÑÑ0¸UÐÐC€GØ�]‰]Ñ8Ó9€Fá8?Ô@º©*¨#ˆe×ÑÓ! " 1Ó%¹€FÑ@ä�yŠy˜Ó €HÜ×Ò˜6Õ,ùó Gùó As   Á>EÃ6Ec                 óœ   • U S   R                  5       nS Ul        UR                  U S   5      R                  S5      nUR                  b   eg )Nr(   r   r\   )r0   rj   r3   rx   )Úfloat_framer?  r   s      r   Útest_no_nonsense_namerù  À  sJ   € à�CÑ×ÑÓ€AØ€A„Fà�Y‰Y�{ 3Ñ'Ó(×,Ñ,¨UÓ3€FØ�;‰;ÑÐÑr   c                  ó
  • [        [        R                  " S5      R                  SS5      5      n SU S'   / SQU S'   U R	                  S5      nUR                  SSS	.5      nUS   R                  [        R                  :X  d   eg )
NrJ   rK   r   Útest)gÍÌÌÌÌÌô?rG  gš™™™™™ù?Úflr\   rÓ  )rü  r$   )r   r7   r8   Úreshaper3   rx   rD   rG   )rQ   r€   r   s      r   Útest_multifunc_sum_bugrþ  É  sp   € ä”"—)’)˜A“,×&Ñ& q¨!Ó,Ó-€AØ€A€f�IÚ€A€d�Gà�i‰i˜Ó€GØ�[‰[ ¨&Ñ1Ó2€FØ�$‰<×Ñ¤§¡Ó+Ð+Ñ+r   c                 óö   • S nS nU R                  S5      S   R                  U5      nU R                  S5      S   R                  U5      n[        U[        5      (       d   e[        R
                  " X45        g )Nc                 óD   • U R                  5       U R                  5       S.$ ©N©rÀ  r  r  rœ   s    r   rË   Ú(test_handle_dict_return_value.<locals>.fÕ  s   € Ø—y‘y“{¨5¯9©9«;Ñ7Ð7r   c                 óV   • [        U R                  5       U R                  5       S.5      $ r  )r   rÀ  r  rœ   s    r   rÞ   Ú(test_handle_dict_return_value.<locals>.gØ  s   € Ü˜eŸi™i›k°%·)±)³+Ñ>Ó?Ð?r   r   r(   )r3   rz   r†  r   r9   ry   )r>   rË   rÞ   r   r   s        r   Útest_handle_dict_return_valuer  Ô  sj   € ò8ò@ð �Z‰Z˜‹_˜SÑ!×'Ñ'¨Ó*€FØ�z‰z˜#‹˜sÑ#×)Ñ)¨!Ó,€Hä�fœf×%Ñ%Ð%Ð%Ü×Ò˜6Õ,r   Úgrouperr   r   c                 óÚ  ^• S nS mU4S jnU R                  USS9nSn[        R                  " [        US9   UR	                  U5        S S S 5        UR                  T5        UR                  TTS.5        UR                  U5        US	   R	                  U5        US	   R                  T5        US	   R                  TU/5        US	   R                  U5        g ! , (       d  f       N—= f)
Nc                 ó$   • U R                   c   eU $ rZ   r¦  rœ   s    r   rË   Útest_set_group_name.<locals>.fä  s   € Ø�z‰zÑ%Ð%Ð%Øˆr   c                 ó@   • U R                   c   eU R                  5       $ rZ   )rj   r\   rœ   s    r   ÚfreduceÚ$test_set_group_name.<locals>.freduceè  s   € Ø�z‰zÑ%Ð%Ð%Ø�y‰y‹{Ðr   c                 ó   >• T" U 5      $ rZ   rO   )rQ   r  s    €r   ÚfreducexÚ%test_set_group_name.<locals>.freducexì  s   ø€ Ù�q‹zÐr   FrT   r    rV   rh  r(   )r3   r9   ru   rv   rz   rw   r{   )r>   r  rË   r  r€   rƒ   r  s         @r   Útest_set_group_namer  â  sÔ   ø€ òòõð �j‰j˜¨UˆjÐ3€Gð D€CÜ	×	#Ò	#¤M¸Ó	=Ø�‰�aÔ÷ 
>à×Ñ�gÔØ×Ñ˜G¨'Ñ2Ô3Ø×Ñ�aÔàˆC�L×Ñ�qÔØˆC�L×Ñ˜7Ô#ØˆC�L×Ñ˜G XÐ.Ô/ØˆC�L×Ñ˜1Õ÷ 
>Õ	=ús   ¹CÃ
C*c                  ó   ^• [        / SQ[        R                  " S5      S.5      n / mU4S jnSn[        R                  " [
        US9   U R                  SSSS	9R                  U5        S S S 5        / S
QnTU:X  d   eg ! , (       d  f       N= f)N)r   r   rX   rX   r$   r$   rl  r  c                 óZ   >• TR                  U R                  5        U R                  5       $ rZ   )r˜  rj   r0   )r�   r&  s    €r   rË   Ú6test_group_name_available_in_inference_pass.<locals>.f  s   ø€ Ø�‰�U—Z‘ZÔ Ø�z‰z‹|Ðr   r    rV   r  F)rM  rU   rh   )r   r7   r8   r9   ru   rv   r3   rz   )r>   rË   rƒ   Úexpected_namesr&  s       @r   Ú+test_group_name_available_in_inference_passr  ÿ  s}   ø€ ä	Ò+´"·)²)¸A³,Ñ?Ó	@€Bà€Eõð D€CÜ	×	#Ò	#¤M¸Ó	=Ø
�
‰
�3˜U¨uˆ
Ð5×;Ñ;¸AÔ>÷ 
>ò €NØ�NÓ"Ð"Ñ"÷	 
>Õ	=ús   Á	!A?Á?
Bc                 ó<  • U R                  U S   R                  5      R                  5       nUR                  R                  b   eU R                  U S   R                  U S   R                  /5      R                  5       nUR                  R
                  S:X  d   eg )Nr   r   )NN)r3   r  r\   r+   rj   r&  rv  s      r   Útest_no_dummy_key_namesr    s{   € à�Z‰Z˜˜3™Ÿ™Ó'×+Ñ+Ó-€FØ�<‰<×ÑÑ$Ð$Ð$à�j‰j˜"˜S™'Ÿ.™.¨"¨S©'¯.©.Ð9Ó:×>Ñ>Ó@€GØ�=‰=×Ñ ,Ó.Ð.Ñ.r   c                  óŒ  • [        SS/SS/// SQ/ SQ/SS/S9n [        / SQU S	9n[        SS/SS/// S
Q/ SQ/SS/S9n [        / SQU S	9nUR                  SS/SS9R                  5       n[        R
                  " X25        UR                  SS/SS9R                  5       n[        R
                  " X2R                  5       5        g )NrX   r$   )r   r   r   r   rX   rX   )rX   rX   r   r   r   r   r  r  r$  )r   rX   r$   rK   rô   r#   r*   r(  )rX   r   r   ©r   r$   rô   F©r   rM  T)r   r   r3   rÀ   r9   ry   Ú
sort_index)r+   ÚmseriesÚmseries_resultr   s       r   Ú#test_groupby_sort_multiindex_seriesr    sÕ   € ô Ø�A�˜˜A˜ÐÚ!Ò#5Ð6Ø�Cˆjñ€Eô
 Ò'¨uÑ5€GÜØ�A�˜˜A˜Ðª	²9Ð'=ÀcÈ3ÀZñ€Eô šI¨UÑ3€Nà�_‰_ C¨ :°Eˆ_Ð:×@Ñ@ÓB€FÜ×Ò˜6Ô2Ø�_‰_ C¨ :°Dˆ_Ð9×?Ñ?ÓA€FÜ×Ò˜6×#<Ñ#<Ó#>Õ?r   c                  ó€  • Sn [        SSU S9n[        [        R                  " U 5      [        R                  " U 5      S.US9nSS jnUR	                  S 5      nUR                  S	U" [        R                  5      05      nUR                  S	U" [        R                  S
5      05      n[        R                  " XV5        g )Néè  z2012/1/1Ú5min)rµ  rø   r"   )ÚhighÚlowr*   c                 ó   ^ ^• UU 4S jnU$ )z.
Run an aggregate func on the subset of data.
c                 óÒ   >• U R                   U R                  R                  S 5         R                  5       nT(       a  X R                  S        [	        U5      S:X  a  g T" U5      $ )Nc                 ó    • U R                   S:  $ )Nr�  )ÚhourrP   s    r   rR   ÚYtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._func.<locals>.<lambda>:  s   € °!·&±&¸2²+r   r   )rš   r+   r™  Údropnart   )r   rR  ÚfixÚfuncs     €€r   Ú_funcÚGtest_groupby_reindex_inside_function.<locals>.agg_before.<locals>._func9  sP   ø€ Ø—‘˜Ÿ™Ÿ™Ñ(=Ó>Ñ?×FÑFÓHˆAÞØ—Z‘Z ‘]Ò#Ü�1‹v˜‹{ØÙ˜“7ˆNr   rO   )r,  r+  r-  s   `` r   Ú
agg_beforeÚ8test_groupby_reindex_inside_function.<locals>.agg_before4  s   ù€ ö
	ð ˆr   c                 óX   • [        U R                  U R                  U R                  5      $ rZ   )r   rü   rÒ   r  rP   s    r   rR   Ú6test_groupby_reindex_inside_function.<locals>.<lambda>C  s   € ¤8¨A¯F©F°A·G±G¸Q¿U¹UÔ#Cr   r#  T)F)	r   r   r7   r8   r3   rx   rÀ  r9   r:   )r"   Úindr>   r/  r€   Úclosure_badÚclosure_goods          r   Ú$test_groupby_reindex_inside_functionr6  /  s—   € Ø€GÜ
˜:¨F¸GÑ
D€CÜ	œBŸIšI gÓ.´r·y²yÀÓ7IÑJÐRUÑ	V€Bôð �j‰jÑCÓD€GØ—+‘+˜v¡z´"·&±&Ó'9Ð:Ó;€KØ—;‘; ©
´2·6±6¸4Ó(@ÐAÓB€Lä×Ò˜+Õ4r   c                  ó  • [        / SQ/ SQ/ SQS.5      n U R                  SS/5      n U R                  SS/SS9nUR                  S	5      n[        R
                  " / S
QSS/S9n[        S/S/S//US/S9n[        R                  " X$5        g )N)r  r  r  r  )r#  r#  rR  r#  )rX   rX   rX   r#   )Úgroup1Úgroup2r˜   r8  r9  Tr  r\   ))r  r#  )r  rR  ©r  r#  r—  r$   rX   r#   r˜   rH  )r   r(  r3   rx   r   r™  r9   r:   )r>   rå   rï   rY  r¢  s        r   Ú$test_groupby_multiindex_missing_pairr;  J  sš   € ä	â*Ú*Ú!ñ	
ó
€Bð 
�‰�x Ð*Ó	+€BØ—‘ 8¨XÐ"6¸T�ÐB€Jà
�.‰.˜Ó
€CÜ
×
 Ò
 Ú,°X¸xÐ4Hñ€Cô �a�S˜1˜# ˜s�O¨3¸¸	Ñ
B€Cä×Ò˜#Õ#r   c                  óZ  • [         R                  " / SQSS/S9n [        / SQ/U S9nUR                  R	                  5       (       d   e[        / SQ/ SQ/ S	Q/S
9nUR                  SSS/SS9nUR                  5       nUR                  R	                  5       (       a   eUR                  S5      R                  5       n[        R                  " [        5         UR                  S5      R                  5       nS S S 5        [        R                  " UW5        [        / SQ/ SQ/ SQS.5      R                  SS/5      nUR                  R	                  5       (       a   eSSSS/4 H²  nS H©  nUR                  XgSS9R                  [        R                   5      nUn[        R                  " X45        UR#                  5       R                  XgSS9R                  [        R                   5      nUR#                  5       n[        R                  " X45        M«     M´     g ! , (       d  f       GN+= f)N))r  Ú )Úb1Úc1)Úb2Úc2r  r#  r—  ©rX   rK   rô   r¥  rÙ  )rX   r>  r?  rK   )rX   r@  rA  rô   )rí   r   r  rR  )r+   rí   r  )r  r  r  r  ©rX   rX   r$   r$   ©rX   r$   rK   rô   ©rQ   r*  ÚzrQ   r*  r   rX   )FTF)r   rM  rU   )r   r™  r   rí   Ú_is_lexsortedÚpivot_tablerÇ  r3   rk   r9   ru   r   r:   r(  r+   rz   Údrop_duplicatesr  )Úlexsorted_miÚlexsorted_dfÚnot_lexsorted_dfr   r   r>   r   rM  s           r   Ú%test_groupby_multiindex_not_lexsortedrM  _  só  € ô ×)Ò)Ú/¸¸S°zñ€Lô ši˜[°,Ñ?€LØ×Ñ×-Ñ-×/Ñ/Ð/Ð/ô !Ú$Ò,>Ò@RÐ+SñÐð (×3Ñ3Ø˜C ˜:¨cð 4ð Ðð (×3Ñ3Ó5ÐØ×'Ñ'×5Ñ5×7Ñ7Ð7Ð7à×#Ñ# CÓ(×-Ñ-Ó/€HÜ	×	#Ò	#Ô$6Õ	7Ø!×)Ñ)¨#Ó.×3Ñ3Ó5ˆ÷ 
8ä×Ò˜( FÔ+ô 
Ú"ªºLÑIó
ç�i��c�
Óð ð �x‰x×%Ñ%×'Ñ'Ð'Ð'à�Q˜˜A˜“ˆÛ!ˆDØ—Z‘Z eÀ5�ZÐI×OÑOÜ×)Ñ)óˆFð ˆHÜ×!Ò! (Ô3ð —‘“ß‘˜u¸E�ÐBß‘”y×0Ñ0Ó1ð ð
 —}‘}“ˆHÜ×!Ò! (Ö3ó "ò  ÷ 
8Ö	7ús   Ã HÈ
H*c                  ó*  • [        [        S5      / SQS9n U R                  [        S5      5      nUR                  S 5      nU R                  / SQ   n[
        R                  " X#5        U S   nUR                  [        S5      5      nUR                  S 5      nUR                  / SQ5      n[
        R                  " X#5        U R                  R                  [        5      U l	        U R                  [        S5      5      nUR                  S	 5      nU R                  / SQ   n[
        R                  " X#5        U S   nUR                  [        S5      5      nUR                  S
 5      nUR                  / SQ5      n[
        R                  " X#5        g )NÚABCDE)r$   r   r$   rX   rX   r*   Úababbc                 ó   • [        U 5      S:„  $ ro   ©rt   rP   s    r   rR   Ú4test_index_label_overlaps_location.<locals>.<lambda>•  ó   € ¤ A£¨¢
r   rB  r   c                 ó   • [        U 5      S:„  $ ro   rR  rP   s    r   rR   rS  ›  rT  r   c                 ó   • [        U 5      S:„  $ ro   rR  rP   s    r   rR   rS  ¢  rT  r   c                 ó   • [        U 5      S:„  $ ro   rR  rP   s    r   rR   rS  ¨  rT  r   )r   r4   r3   Úfilterr2   r9   r:   rT  ry   r+   r‹   r  )r>   rÞ   Úactualr   r=   s        r   Ú"test_index_label_overlaps_locationrZ  �  s0  € ô 
”4˜“=ªÑ	8€BØ
�
‰
”4˜“=Ó!€AØ�X‰XÑ*Ó+€FØ�w‰w’yÑ!€HÜ×Ò˜&Ô+à
ˆQ‰%€CØ�‰”D˜“MÓ"€AØ�X‰XÑ*Ó+€FØ�x‰xš	Ó"€HÜ×Ò˜6Ô,ð �x‰x�‰œuÓ%€B„HØ
�
‰
”4˜“=Ó!€AØ�X‰XÑ*Ó+€FØ�w‰w’yÑ!€HÜ×Ò˜&Ô+à
ˆQ‰%€CØ�‰”D˜“MÓ"€AØ�X‰XÑ*Ó+€FØ�x‰xš	Ó"€HÜ×Ò˜6Õ,r   c                  óN  • Sn [         R                  " U 5      n[        US-  SU-  SU-  S.5      n[        US-  S-  SU-  SU-  S.5      nUR                  S5      nUR	                  S5      nUR                  S5      nUR	                  S5      n[
        R                  " XW5        g )	Nrl  r$   r  ç      @r4  r  r  rk   )r7   r8   r   r3   r{   r9   r:   )ÚnrQ   r>   r6  r?   r   Úgb2r   s           r   Ú"test_transform_doesnt_clobber_intsr_  ­  s—   € à	€AÜ
�	Š	�!‹€AÜ	˜˜a™ c¨A¡g°C¸!±GÑ<Ó	=€BÜ
˜!˜q™& 3™,¨S°1©W¸3À¹7ÑCÓ
D€Cà	�‰�C‹€BØ�\‰\˜&Ó!€Fà
�+‰+�cÓ
€CØ�}‰}˜VÓ$€HÜ×Ò˜&Õ+r   Úsort_columnÚintsÚfloatsÚstringsÚgroup_columnÚ
int_groupsÚstring_groupsc                 ó  ^ • [        / SQ/ SQ/ SQ/ SQ/ SQS.5      nUR                  T S9nUR                  U5      nU 4S jnS	n[        R                  " [
        US
9   UR                  U5        S S S 5        g ! , (       d  f       g = f)N)rK   rX   r   rX   r   rK   rK   rK   )rF  r  rF  r  r  rÞ   rÞ   rÞ   )r”   r^   rô   r#   r$   rJ   rX   rX   )gffffff@g333333@gÍÌÌÌÌÌ@g333333Àgš™™™™™@çš™™™™™ñ?rh  r#   )rF  rR  r  rÂ   ÚwordÚword2Ú42Ú47)re  rf  ra  rb  rc  rï  c                 óL   >• [         R                  " X R                  TS95        g )Nrï  )r9   r:   rñ  )rQ   r`  s    €r   Ú	test_sortÚ.test_groupby_preserves_sort.<locals>.test_sortÖ  s   ø€ Ü
×Ò˜a§¡°+ Ð!>Õ?r   r    rV   )r   rñ  r3   r9   ru   rv   rz   )r`  rd  r>   rÞ   rn  rƒ   s   `     r   Útest_groupby_preserves_sortrp  ¼  sy   ø€ ô 
â2ÚEÚ,Ú=ÚHñ	
ó
€Bð 
�‰˜;ˆÐ	'€BØ
�
‰
�<Ó €Aõ@ð D€CÜ	×	#Ò	#¤M¸Ó	=Ø	�‰�	Ô÷ 
>×	=Ö	=ús   ÁA9Á9
Bc                  óÌ  • [        [        [        R                  " 5       SSS9R	                  5       [        S5      S.5      n U R                  S5      R                  R                  U S'   U R                  S5      R                  R                  U S'   [        R                  " [        SS	9   U R                  5       R                  SSS
SS9  S S S 5        g ! , (       d  f       g = f)Nrf   ÚMEr÷   )Ú	eventDateÚthenamers  rü   rÒ   z	'badname'rV   ÚbadnamerÁ  )r+   rí   r  Úaggfunc)r   r   r   ÚtodayÚtolistr5   r(  r+   rü   rÒ   r|   r}   r²  rÇ  rH  r  s    r   Ú!test_pivot_table_values_key_errorry  Þ  s¯   € ä	ä#¤H§N¢NÓ$4¸bÀtÑL×SÑSÓUÜ˜R“yñ	
ó
€Bð —‘˜kÓ*×0Ñ0×5Ñ5€B€v�JØ—,‘,˜{Ó+×1Ñ1×7Ñ7€B€w�Kä	�Š”x {Ó	3Ø
�‰Ó×$Ñ$Ø '°)ÀWð 	%ñ 	
÷ 
4×	3Ö	3ús   Â+!CÃ
C#rí   r(   r„  r  rÐ  r  rX   z
US/Easternr&   ú
2016-01-01rK   r—   r÷   ÚInt64r•   ÚFloat64Úboolean)ÚboolÚintr  rŸ  rX  Údt64Údt64tzÚperiodr{  r|  r}  )ÚidsÚmethod)rÍ  rx   rz   )r›   Úidxminr  rÀ  r\   r	  r  c                 óx  ^^^^^^• S n[        T[        5      (       a  TS;   a  Sn[        TS   [        5      (       a  TS;   a  Sn[        TTTS.[	        S5      S9n	[        TS	5      (       a.  U	R                  TR                  :H  R                  5       (       d   eU	R                  S S n	U	R                  TS
US
S9U    mUUU4S jn
UUU4S jn[        U	R                  R                  S   [        R                  5      nU	R                  R                  S   R                  S:H  n[        T[        5      n[        U	R                  R                  S   [        R                  5      n[        T[        5      (       a›  TR                   (       dŠ  TS;   a„  TS;   a  ST S3n["        nOST S3n[$        n[&        R(                  " UUS9   U
" 5         S S S 5        TS;   a9  [        U [        5      (       a$  U
" SS9nU" 5       n[*        R,                  " UU5        g TS;   aå  U(       d  U(       d  U(       d  U(       aÉ  TS:w  aÃ  U(       a  SnOU(       a  SnOU(       a  ST S3nOSnTS:X  a  S R/                  US!/5      n[&        R(                  " ["        US9   U
" 5         S S S 5        [        U [        5      (       d  g TS:X  a  g U
" SS9nU	R1                  T5      /    nU(       a  U" 5       n[*        R,                  " UU5        g U
" 5       nU	R1                  T5      U    nTS";   a%  UR3                  U	R4                  R                  5      nUb  UR3                  U5      n[7        T5      S#:X  a  TS   UR4                  l        [*        R,                  " UU5        g ! , (       d  f       GNÏ= f! , (       d  f       GN= f)$N)r\   r	  r{  r   )r	  r\   rE   r,   ÚABCr¥  rD   F)rU   r*  Úobservedc                  óZ   >• TS:X  a  [        TT5      " S0 U D6$ [        TT5      " T40 U D6$ )NrÍ  rO   )rE  )Úkwargsr?   r„  r“  s    €€€r   Ú
get_resultÚ&test_empty_groupby.<locals>.get_result+  s6   ø€ Ø�VÓÜ˜2˜r”?Ñ, VÑ,Ð,ä˜2˜vÔ& rÑ4¨VÑ4Ð4r   c                  óÔ   >• [        S/TR                  S9n [        T5      S:w  a  [        R                  " X /TS9nO[        U TS   S9nT(       a  [        / SS9nO/ n[        / X!S9nU$ )Nr   r•   rX   r—  r¦  rŸ  rù   )r   rD   rt   r   r®  r
   r   )ÚlevrY  rí   r   r„  r‘  r  s       €€€r   Ú get_categorical_invalid_expectedÚ<test_empty_groupby.<locals>.get_categorical_invalid_expected1  sm   ø€ ô
 ˜1˜# V§\¡\Ñ2ˆÜˆt‹9˜‹>Ü×)Ò)¨3¨*¸DÑA‰Cô ˜ $ q¡'Ñ*ˆCæÜ˜B eÑ,‰GàˆGÜ˜R¨Ñ<ˆØˆr   ÚM)r  rÀ  r…  r›   )r  rÀ  zCannot perform z with non-ordered Categoricalz
Can't get z/ of an empty group due to unobserved categoriesrV   Trf  )r	  r\   r  r\   z datetime64 type does not supportzPeriod type does not supportr  r  zcategory type does not supportr  Ú|z!does not support reduction 'skew')r›   r…  rX   )r†  r   r~  r   r4   Úhasattrr£   rD   rU  r2   r3   r-   ÚPeriodDtypeÚkindr   ÚStringDtypeÚorderedr�  rë  r|   r}   r9   Úassert_equalÚjoinr(  r‹   r+   rt   rj   )rí   r„  r  r„  r“  Úusing_array_managerr*  r‘  Úoverride_dtyper>   r‹  r�  Úis_perÚis_dt64Úis_catÚis_strrƒ   r  r   r   r?   s    ````  `            @r   Útest_empty_groupbyr   ð  s  ý€ ðN €Nä�&œ,×'Ñ'¨B°/Ó,Aà ˆä�&˜‘)œT×"Ñ" r¨_Ó'<à ˆä	˜ f°6Ñ:ÄDÈÃKÑ	P€Bäˆv�w×Ñà—	‘	˜VŸ\™\Ñ)×.Ñ.×0Ñ0Ð0Ð0à	�‰��!ˆ€Bà	�‰�D U°6ÀEˆÐ	JÈ7Ñ	S€B÷5÷ô( ˜Ÿ	™	Ÿ™ qÑ)¬2¯>©>Ó:€FØ�i‰i�n‰n˜QÑ×$Ñ$¨Ñ+€GÜ˜¤Ó,€FÜ˜Ÿ	™	Ÿ™ qÑ)¬2¯>©>Ó:€Fô 	�6œ;×'Ñ'Ø——ØÐ4Ó4à�ÓØ# B 4Ð'DÐEˆCÜ‰Eà˜r˜dÐ"QÐRˆCÜˆEÜ�]Š]˜5¨Ó,ÙŒL÷ -ð Ð3Ó3¼
À7ÌD×8QÑ8Qá¨TÑ2ˆFÙ7Ó9ˆHÜ�OŠO˜F HÔ-Øà	Ð$Ó$æ–f¦®6°b¸E³kö Ø8‘ÞØ4‘ÞØ@ÀÀÀAÐF‘à6�Ø�V‹|Ø—h‘h Ð%HÐIÓJ�Ü—’œy°Ó4Ù”÷ 5ô ˜g¤t×,Ñ,àØ�v“àñ $°Ñ6�ð Ÿ<™<¨Ó-¨bÑ1�ÞÙ?ÓA�HÜ—’ ¨Ô1Øá‹\€FØ�|‰|˜DÓ! 'Ñ*€HØ	Ð!Ó!Ø—?‘? 2§8¡8§>¡>Ó2ˆØÑ!Ø—?‘? >Ó2ˆÜ
ˆ4ƒy�Aƒ~Ø" 1™gˆ�‰ÔÜ‡O‚O�F˜HÕ%÷s -Ö,ú÷2 5Ö4ús   ÇNÊN*Î
N'Î*
N9c                  óÞ  • [        [        R                  R                  S5      R	                  S5      5      n U S   R                  [        R                  5      U S'   / SQU l        U R                  U S   SS9nSn[        R                  " [        US	9   UR                  S
 5      nS S S 5        WR                  U R                  :H  R                  5       (       d   eg ! , (       d  f       N== f)Nr$   )r   rô   rK   ©r   rX   r$   r   rX   FrT   r    rV   c                 ó   • U $ rZ   rO   rP   s    r   rR   Ú<test_empty_groupby_apply_nonunique_columns.<locals>.<lambda>™  s   € ¡r   )r   r7   rp   rq   r¡   r‹   rE   rí   r3   r9   ru   rv   rz   r£   rU  )r>   r?   rƒ   rï   s       r   Ú*test_empty_groupby_apply_nonunique_columnsr¥  ‘  s°   € ä	”2—9‘9×(Ñ(¨Ó+×;Ñ;¸FÓCÓ	D€BØˆq‰E�L‰LœŸ™Ó"€B€q�EÚ€B„JØ	�‰�B�q‘E eˆÐ	,€BØ
C€CÜ	×	#Ò	#¤M¸Ó	=Ø�h‰h‘{Ó#ˆ÷ 
>à�J‰J˜"Ÿ)™)Ñ#×(Ñ(×*Ñ*Ð*Ñ*÷ 
>Õ	=ús   ÂCÃ
C,c            	      ó`  • [        / SQ/ SQ/ SQ/ SQS.5      n [        R                  " [        SS9   U / SQ   R	                  S5        S S S 5        U R	                  S5      S   R                  5       n[        S	/S[        S
/SS9S9n[        R                  " X5        g ! , (       d  f       N\= f)N)rX   rX   rX   rX   )r$   r$   r$   r$   )r  r  r  r#  z
('a', 'b')rV   r4  r  r#  rô   rX   r¦  rª  )
r   r|   r}   r²  r3   r\   r   r
   r9   ry   r¬  s      r   Útest_tuple_as_groupingr§  �  s“   € ä	â$ÚÚÚñ		
ó
€Bô 
�Š”x }Ó	5Ø
Š?Ñ×#Ñ# JÔ/÷ 
6ð �Z‰Z˜
Ó# CÑ(×,Ñ,Ó.€FÜ�q�c ¬5°!°¸:Ñ+FÑG€HÜ×Ò˜6Õ,÷ 
6Õ	5ús   ²BÂ
B-c            	      ó  • [        S[        S5      [        R                  " SS/SS//5      S9n [        R
                  " [        SS9   U R                  S5      R                  5         S S S 5        g ! , (       d  f       g = f)	NrX   rK   r$   rô   rH  z
^\(7, 8\)$rV   )r^   r”   )	r   r5   r   r®  r|   r}   r²  r3   rk   r  s    r   Útest_tuple_correct_keyerrorr©  °  s]   € ä	�1œE !›H¬j×.EÒ.EÈÈ1ÀvÐPQÐSTÈvÐFVÓ.WÑ	X€BÜ	�Š”x }Ó	5Ø
�
‰
�6Ó×ÑÔ!÷ 
6×	5Ö	5ús   Á A1Á1
A?c                  ó&  • [        S/S//[        S/SS9[        SSSSS	9S
9n [        / SQ/ SQ/[        R                  " S/ SQS9[        SSSSS	9S
9nU R                  [        SS95      R                  SS/5      n[        R                  " X!5        g )NrX   r‘   Úmycolsr¦  ú
2018-01-01r$   r—   Údti)r"   rø   rj   rù   )rX   rX   rX   rX   rX   ))r‘   r\   r‘   )r‘   ÚohlcÚopen)r‘   r®  r#  )r‘   r®  r$  )r‘   r®  Úclose)r«  NNr—  )rø   r\   r®  )
r   r
   r   r   r™  r3   r	   rx   r9   r:   rN  s      r   Útest_groupby_agg_ohlc_non_firstr±  ·  sŸ   € ä	Ø
ˆˆqˆcˆ
Ü�u�g HÑ-Ü˜¨q°sÀÑGñ
€Bô Ú	š/Ð*Ü×&Ò&ðò )ñ	
ô ˜¨q°sÀÑGñ€Hð �Z‰Zœ SÑ)Ó*×.Ñ.°°v¨Ó?€Fä×Ò˜&Õ+r   c                  óF  • [         R                  S4[        SSS5      S4[        SSS5      S4[        SSS5      S4/n [        R                  " U SS /S9n[        / S	QUS
9nUR                  SS9R                  5       n[        SS/SS/S
9n[        R                  " X45        g )Nr  iÜ  rX   r$   r  rK   Údater—  )rK   r$   ç      @rô   r*   r  r\  r´  )
r-   r1   r   r   r™  r   r3   rk   r9   ry   )r  rž  r=   r   r   s        r   Útest_groupby_multiindex_natrµ  Ó  s¨   € ô 
�‰�ˆÜ	�$˜˜1Ó	˜sÐ#Ü	�$˜˜1Ó	˜sÐ#Ü	�$˜˜1Ó	˜sÐ#ð	€Fô 
×	Ò	 ¨v°t¨nÑ	=€BÜ
’ rÑ
*€Cà�[‰[˜qˆ[Ð!×&Ñ&Ó(€FÜ�s˜C�j¨¨c¨
Ñ3€HÜ×Ò˜6Õ,r   c                  óæ   • [        [        S5      [        S5      5      n [        U SS/S9nSn[        R                  " [
        US9   UR                  / /5        S S S 5        g ! , (       d  f       g = f)Nre   Úappler  r¥  z$Grouper and axis must be same lengthrV   )rà  r5   r   r|   r}   rë  r3   )r  r>   rƒ   s      r   Útest_groupby_empty_list_raisesr¸  ã  sS   € ä”�r“œE "›IÓ&€FÜ	�6 G¨S >Ñ	2€BØ
0€CÜ	�Š”z¨Ó	-Ø
�
‰
�B�4Ô÷ 
.×	-Ö	-ús   ÁA"Á"
A0c                  ó"  • SS/SS/SS//n / SQn[         R                  " XS9n[        SS/US	9nUR                  S
S/5      R	                  5       nS/S//n S
S/n[         R                  " XS9n[        S/US9n[
        R                  " XF5        g )NrQ   r  r  r�   )rÀ   r/  Úthirdr—  rX   r$   rC  rÀ   rº  rK   r*   )r   Úfrom_arraysr   r3   r\   r9   ry   )Úindex_arrayÚindex_namesÚrir?  r   Úeir   s          r   Ú8test_groupby_multiindex_series_keys_len_equal_group_axisrÀ  ì  sž   € à˜�:  S˜z¨C°¨:Ð6€KÚ.€KÜ	×	Ò	 Ñ	?€BÜ�Q˜�F "Ñ%€AØ�Y‰Y˜ Ð)Ó*×.Ñ.Ó0€Fà�5˜3˜%�.€KØ˜GÐ$€KÜ	×	Ò	 Ñ	?€BÜ�q�c Ñ$€Hä×Ò˜6Õ,r   c                  ó„  • [         R                  " SS/SS//SS/S9n [        / SQ/ S	QS
.U S9nUR                  [	        SS9S/5      nUR                  SS/5      nUR
                  UR
                  :X  d   eUR                  S[	        SS9/5      nUR                  SS/5      nUR
                  UR
                  :X  d   eg )Nr   r   r(   r—   r´  Úbetar—  )rX   r$   rX   r$   rD  ri  r*   r  )r   r®  r   r3   r	   rQ  )rž  r>   r   r   s       r   Ú"test_groupby_groups_in_BaseGrouperrÃ  ü  s»   € ô 
×	 Ò	  3¨ *¨s°C¨jÐ!9À'È6ÐARÑ	S€BÜ	š<²Ñ=ÀRÑ	H€BØ�Z‰Zœ wÑ/°Ð8Ó9€FØ�z‰z˜7 FÐ+Ó,€HØ�=‰=˜HŸO™OÓ+Ð+Ð+à�Z‰Z˜¤¨wÑ!7Ð8Ó9€FØ�z‰z˜6 7Ð+Ó,€HØ�=‰=˜HŸO™OÓ+Ð+Ñ+r   Ú
group_namerQ   c                 óÄ  • [        [        R                  " S5      R                  SS5      / SQ/ SQS9nSUR                  l        SUR                  l        S	n[        R                  " [        US
9   UR                  U SS9nS S S 5        WR                  5       nUR                  R                  U 5      R                  5       R                  n[        R                  " XE5        / SQSS//n[        R                  " USS/S9n[        [        R                  " S5      R                  SS5      / SQUS9n[        R                  " [        US
9   UR                  U SS9nS S S 5        UR                  5       nUR                  R                  U 5      R                  5       R                  n[        R                  " XE5        g ! , (       d  f       GND= f! , (       d  f       Nz= f)Nr_   rK   rô   ©r   rX   r   )re   rf   re   rf   rH  r*  rQ   r]  rV   rX   rÆ   )r’   r'  r‘   rc   rd   Úx1)Ú	iterablesr&  é   rl  )r   r7   r8   rý  r+   rj   rí   r9   ru   rv   r3   r\   rî   r:   r   r®  )rÄ  r>   r7  r?   Úresultsr   rÈ  rž  s           r   Útest_groupby_axis_1rË  
	  sk  € ô 
Ü
�	Š	�"‹×Ñ˜a Ó#ª9Ò>Nñ
€Bð €B‡H�H„MØ€B‡J�J„Oà<€HÜ	×	#Ò	#¤M¸Ó	BØ�Z‰Z˜
¨ˆZÐ+ˆ÷ 
Cð �f‰f‹h€GØ�t‰t�|‰|˜JÓ'×+Ñ+Ó-×/Ñ/€HÜ×Ò˜'Ô,ò '¨°¨Ð7€IÜ	×	 Ò	 ¨9¸SÀ$¸KÑ	H€BÜ	”2—9’9˜R“=×(Ñ(¨¨AÓ.²iÈÑ	L€BÜ	×	#Ò	#¤M¸Ó	BØ�Z‰Z˜
¨ˆZÐ+ˆ÷ 
Cà�f‰f‹h€GØ�t‰t�|‰|˜JÓ'×+Ñ+Ó-×/Ñ/€HÜ×Ò˜'Õ,÷ 
CÖ	Bú÷ 
CÕ	Bús   Á1F?ÅGÆ?
GÇ
Gzop, expectedÚshiftÚtimeú2019-01-01 12:00:00ú2019-01-01 12:30:00Úbfillú2019-01-01 14:00:00ú2019-01-01 14:30:00Úffillc           	      óJ  ^• U m/ SQ[        S5      [        S5      S S [        S5      [        S5      /S.n[        U5      R                  U4S jS9nUR                  S	5      n[	        XQ5      " 5       n[        U5      R                  U4S
 jS9n[
        R                  " Xb5        g )N)r   r   r   r   r   r   rÎ  rÏ  rÑ  rÒ  )rš  rÍ  c                 óN   >• U R                   R                  R                  T5      $ rZ   ©rÍ  r¾  Útz_localize©rQ   r'   s    €r   rR   Ú+test_shift_bfill_ffill_tz.<locals>.<lambda>`	  s   ø€ ¨q¯v©v¯y©y×/DÑ/DÀRÔ/Hr   )rÍ  rš  c                 óN   >• U R                   R                  R                  T5      $ rZ   rÖ  rØ  s    €r   rR   rÙ  d	  s   ø€ ¸¿¹¿¹×9NÑ9NÈrÔ9Rr   )r   r   Úassignr3   rE  r9   r:   )Útz_naive_fixturer“  r   r   r>   r€   r   r'   s          @r   Útest_shift_bfill_ffill_tzrÝ  &	  s    ø€ ð\ 
€Bâ,äÐ+Ó,ÜÐ+Ó,ØØÜÐ+Ó,ÜÐ+Ó,ð
ñ
€Dô 
�4‹×	Ñ	Ô%HÐ	Ð	I€Bà�j‰j˜Ó€GÜ�WÔ!Ó#€FÜ˜Ó"×)Ñ)Ô/RÐ)ÐS€HÜ×Ò˜&Õ+r   c                  óÆ   • [        S /SS.5      n U R                  S5      S   R                  S5      n[        [        R
                  /SS9n[        R                  " X5        g )NrX   )rÞ   rQ   rÞ   rQ   r\   r¦  )r   r3   r{   r   r7   rÁ   r9   ry   )r>   rY  r   s      r   Útest_groupby_only_none_grouprß  h	  sR   € ô 
˜$˜ aÑ(Ó	)€BØ�Z‰Z˜‹_˜SÑ!×+Ñ+¨EÓ2€FÜ”r—v‘v�h SÑ)€Hä×Ò˜6Õ,r   c                  ó¦   • [        / SQ/ SQS9n U R                  SS9nUR                  5       n[        / SQ/ SQS9n[        R                  " X#5        g )N)r$   r#   rl  r”   )r  r  r  rQ  r*   r   r  )r$   g      @r”   )r  r  rQ  )r   r3   rk   r9   ry   )r=   r?   r   r   s       r   Útest_groupby_duplicate_indexrá  r	  sD   € ä
’Ò%9Ñ
:€CØ	�‰˜1ˆÐ	€Bà�W‰W‹Y€FÜ’kªÑ9€HÜ×Ò˜6Õ,r   c                 óÎ  • [        S[        S5      SS/// SQS9nUS   R                  [        5      US'   US   R                  [        5      US'   UR	                  S	S
/5      nU S:X  a  SnOSnU S:X  a  [
        OS nSn[        R                  " XES9   UR                  S S R                  S	/5      R                  " U /UQ76 nS S S 5        [        R                  " XES9   UR                  S	/5      R                  " U /UQ76 R                  S S nS S S 5        U S;   a  WR                  [        5      n[        R                  " WW5        Sn[        R                  " XES9   US   R                  S S R                  S	/5      R                  " U /UQ76 nS S S 5        Sn[        R                  " XES9   US   R                  S	/5      R                  " U /UQ76 R                  S S nS S S 5        U S;   a  UR                  [        5      n[        R                  " Xg5        g ! , (       d  f       GNd= f! , (       d  f       GN)= f! , (       d  f       N¶= f! , (       d  f       Nu= f)NrX   rw  rK   rô   )Úcol_1Úcol_2Úcol_3Úcol_4©r   rí   rå  ræ  rã  rä  Úfillna)rÓ  rO   ú%DataFrameGroupBy.fillna is deprecatedrV   r   )ÚdiffrÌ  z"SeriesGroupBy.fillna is deprecated)r   r   r‹   r  r(  rv   r9   ru   r2   r3   r{   r˜  )Útransformation_funcÚrequestr>   Úargsræ   Úwarn_msgr   r   s           r   Útest_group_on_empty_multiindexrï  |	  s7  € ô 
Ø”)˜GÓ$ a¨Ð+Ð,Ú4ñ
€Bð �W‘+×$Ñ$¤SÓ)€B€w�KØ�W‘+×$Ñ$¤SÓ)€B€w�KØ	�‰�w Ð(Ó	)€BØ˜hÓ&Ø‰àˆØ/°8Ó;�=À€DØ6€HÜ	×	#Ò	# DÓ	9Ø—‘˜˜!�×$Ñ$ g YÓ/×9Ò9Ð:MÐUÐPTÒUˆ÷ 
:ä	×	#Ò	# DÓ	9Ø—:‘:˜w˜iÓ(×2Ò2Ð3FÐNÈÒN×SÑSÐTVÐUVÐWˆ÷ 
:àÐ/Ó/Ø—?‘?¤3Ó'ˆÜ‡O‚O�F˜HÔ%à3€HÜ	×	#Ò	# DÓ	9àˆw‰Kß‰T�"�1ðç‰W�g�YÓß‰Yðð +ð3ð .2ò3ð 	÷ 
:ð 4€HÜ	×	#Ò	# DÓ	9àˆw‰Kß‰W�g�YÓß‰Yðà*ð3à-1ò3÷ ‰T�"�1ðð 	÷ 
:ð Ð/Ó/Ø—?‘?¤3Ó'ˆÜ‡O‚O�FÕ%÷5 
:Ö	9úç	9Ö	9ú÷ 
:Õ	9ú÷ 
:Õ	9ús0   Â1H!Ã 1H3Å!4IÆ34IÈ!
H0È3
IÉ
IÉ
I$c                 óê  • [        SSSS9n[        SS/SS/SS/S.5      nS	UR                  l        Xl        UR                  U 5      nU(       d  UR                  nS
nOSn[        R                  " [        US9   UR                  USS9nS S S 5        WR                  5       n[        SS/SS/S.US9nSUR                  l        U(       d  UR                  n[        R                  " Xg5        US:X  a;  [        R                  " [        US9   U/    R                  USS9nS S S 5        U/    n	Ok[        R                  " [        US9   UR                  /    R                  USS9nS S S 5        UR                  /    R                  [         R"                  5      n	WR                  5       n
[        R                  " X©5        g ! , (       d  f       GN== f! , (       d  f       N¸= f! , (       d  f       N„= f)Nrz  r$   r‘   )r"   rj   rX   rK   r   )ru  )r   r(   )r—   r   )r’   r'  r`  r]  rV   )rÇ   r   )r   r—   r*   r’   )r   r   rí   r&  r+   Ú_get_axis_numberrî   r9   ru   rv   r3   Únuniquerj   r:   rš   r‹   r7   rG   )rÇ   r­  r>   Úaxis_numberrƒ   r?   r   r   r^  r¢  rï   s              r   Útest_groupby_crash_on_nuniquerô  ©	  sž  € ä
�\¨1°5Ñ
9€CÜ	  A °Q¸°FÈÈAÈÑOÓ	P€BØ%€B‡J�JÔØ„Hà×%Ñ% dÓ+€KÞØ�T‰TˆØE‰à;ˆä	×	#Ò	#¤M¸Ó	=Ø�Z‰Z˜[°ˆZÐ2ˆ÷ 
>à�Z‰Z‹\€Fä  1˜v¨Q°¨FÑ3¸3Ñ?€HØ!€H×ÑÔÞØ—:‘:ˆä×Ò˜&Ô+à�aÓä×'Ò'¬¸SÓAØ�R‘&—.‘. k¸�.Ð;ˆC÷ Bà�r‰l‰ô ×'Ò'¬¸SÓAØ—&‘&˜‘*×$Ñ$¨+¸QÐ$Ð?ˆC÷ Bð �l‰l˜2Ñ×%Ñ%¤b§j¡jÓ1ˆà
�+‰+‹-€CÜ×Ò˜#Õ#÷1 
>Ö	=ú÷ BÕAú÷
 BÕAús$   Á:GÄGÅG$Ç
GÇ
G!Ç$
G2c                  óÒ   • [        [        R                  " SS5      R                  SS5      [        S9n U R                  S/S9R                  5       n[        R                  " X5        g )Nr   rJ   rK   r•   r  )	r   r7   r8   rý  r  r3   rk   r9   r:   )r   r   s     r   Útest_groupby_list_levelrö  Ò	  sQ   € äœŸš 1 a›×0Ñ0°°AÓ6¼eÑD€HØ×Ñ Q CÐÐ(×-Ñ-Ó/€FÜ×Ò˜&Õ+r   zmax_seq_items, expected))r#   z({0: [0], 1: [1], 2: [2], 3: [3], 4: [4]})rô   z%{0: [0], 1: [1], 2: [2], 3: [3], ...})rX   z{0: [0], ...}c                 óð  • [        [        R                  R                  S5      R	                  S5      5      nUR
                  US'   [        R                  " SU 5         UR                  S5      R                  R                  5       nX1:X  d   eUR                  [        R                  " UR                  5      5      R                  R                  5       nX1:X  d   e S S S 5        g ! , (       d  f       g = f)Nr$   )r#   rX   r  zdisplay.max_seq_items)r   r7   rp   rq   r¡   r+   r-   Úoption_contextr3   rQ  Ú__repr__r¢   r  )Úmax_seq_itemsr   r>   r   s       r   Útest_groups_repr_truncatesrû  Ù	  s°   € ô 
”2—9‘9×(Ñ(¨Ó+×;Ñ;¸FÓCÓ	D€BØ�h‰h€B€s�Gä	×	Ò	Ð2°MÕ	BØ—‘˜C“×'Ñ'×0Ñ0Ó2ˆØÓ!Ð!Ð!à—‘œBŸHšH R§T¡T›NÓ+×2Ñ2×;Ñ;Ó=ˆØÓ!Ð!Ñ!÷ 
C×	BÖ	Bús   ÁA?C'Ã'
C5c                  óB  • [        SSSS.SSSS./5      n U R                  SS/5      n U R                  SS/5      nUR                  nS[        R
                  " S	S/[        R                  S
90n[        U5      S:X  d   eSnX$   X4   :H  R                  5       (       d   eg )NrX   r$   éc   r4  éX   r  r  rì   r   r•   )	r   r(  r3   rR  r7   r¢   rE   rt   rU  )r>   r®   r   r   r   s        r   Ú6test_group_on_two_row_multiindex_returns_one_tuple_keyrÿ  î	  sž   € ä	˜! !¨"Ñ-°Q¸QÀRÑ/HÐIÓ	J€BØ	�‰�s˜C�jÓ	!€Bà
�*‰*�c˜3�ZÓ
 €CØ�[‰[€FØœŸš ! Q ¬r¯x©xÑ8Ð9€Häˆv‹;˜!ÓÐÐØ
€CØ‰K˜8™=Ñ(×-Ñ-×/Ñ/Ð/Ñ/r   zklass, attr, valuer   rM  rU   rˆ  r*  c                 óØ   • [        S/S/S/S.5      nUS:w  a  UR                  S5      nUR                  " S0 X0D6nU [         L a  US/   OUS   n[        XQ5      [        XA5      :X  d   eg )	NrX   r$   rK   r4  rÇ   r  r  )r  )r   r(  r3   rE  )r  rÍ  r˜   r>   r   r   s         r   Ú#test_subsetting_columns_keeps_attrsr  ü	  ss   € ô& 
˜!˜ A 3¨a¨SÑ1Ó	2€BØˆvƒ~Ø�\‰\˜#Óˆà�zŠzÑ/ $ Ñ/€HØ %¬Ò 2ˆX�s�eŠ_¸À¹€FÜ�6Ó ¤G¨HÓ$;Ó;Ð;Ñ;r   c                  óJ  • [        S/S/S/S.5      n Sn[        R                  " [        US9   U R	                  / SQSS9nS S S 5        S	n[
        R                  " [        US9   WS
S/   R                  5         S S S 5        g ! , (       d  f       NH= f! , (       d  f       g = f)NrX   r$   rK   r,   r]  rV   r(  rÆ   z'Cannot subset columns when using axis=1r   r   )	r   r9   ru   rv   r3   r|   r}   rë  r\   )r>   rƒ   rÞ   rW   s       r   Útest_subsetting_columns_axis_1r  
  s†   € ä	˜!˜ A 3¨a¨SÑ1Ó	2€BØ
7€CÜ	×	#Ò	#¤M¸Ó	=Ø�J‰J’y qˆJÐ)ˆ÷ 
>à5€EÜ	�Š”z¨Ó	/Ø	ˆ3�ˆ*‰×ÑÔ÷ 
0Ð	/÷ 
>Õ	=ú÷ 
0Õ	/ús   ®BÁ$BÂ
BÂ
B"r,  )r\   ÚanyrÌ  c                 ó¶   • [        S/SS9n[        S//US9nUR                  S/5      n[        X05      " 5       R                  n[
        R                  " XA5        g )Nr  rY  r¦  rX   r¥  )r
   r   r3   rE  rí   r9   rú  )r,  r   r>   rå   r   s        r   Ú#test_groupby_column_index_name_lostr  #
  sR   € ô �c�U Ñ'€HÜ	�Q�C�5 (Ñ	+€BØ—‘˜Q˜C“€JÜ�ZÔ&Ó(×0Ñ0€FÜ×Ò˜&Õ+r   Úinfer_stringÚpyarrow)Úmarksc                 óÆ  • U (       a  [         R                  " S5        [        / SQ/ SQ/ SQS.5      R                  [        5      n/ SQUl        [        R                  " SU 5         UR                  / SQ5      R                  5       nS S S 5        [        / S	Q/[        R                  " S
/5      / SQ[        S9n[        R                  " WU5        g ! , (       d  f       NP= f)Nr  )rË   rÂ   rÞ   rS  rÙ  rD  r,   )r   r   r   zfuture.infer_string)r   r   r   r   )rÂ   r  rX   r   )r+   rí   rD   )r|   Úimportorskipr   r‹   r  rí   r-   rø  r3   r  r7   r¢   r9   r:   )r  r>   r   r   s       r   Útest_groupby_duplicate_columnsr  -
  s¨   € ö Ü×Ò˜IÔ&Ü	Ú"Ò)=ÂLÑQó
ç�fŒVƒnð ò !€B„JÜ	×	Ò	Ð0°,Õ	?Ø—‘šLÓ)×-Ñ-Ó/ˆ÷ 
@äÚ	ˆœrŸxšx¨¨›}²oÌVñ€Hô ×Ò˜& (Õ+÷ 
@Õ	?ús   Á&"CÃ
C c                  óê   • [        / SQ/ SQSS9n SU R                  l        U R                  SS9R	                  5       n[        SS	/S
S/SS9nSUR                  l        [
        R                  " X5        g )NrD  rC  )r  r  ©r+   rj   )r  r  r   r  r$   rô   rX   )r   r+   rj   r3   Úlastr9   ry   )r=   r   r   s      r   Ú#test_groupby_series_with_tuple_namer  D
  sd   € ä
’¢\¸
Ñ
C€CØ€C‡I�I„NØ�[‰[˜qˆ[Ð!×&Ñ&Ó(€FÜ�q˜!�f Q¨ F°Ñ<€HØ$€H‡N�NÔÜ×Ò˜6Õ,r   zfunc, valuesr\   ç     @X@ç     €X@rk   g     @8@g     €8@c                 óÊ   • / SQn[        SS/S-  X"S.5      n[        UR                  S5      U 5      " 5       n[        XS.[        SS/SS9S	9n[        R
                  " XE5        g )
N©ç €à7yÃACr  éa   éb   ç €à7yÃ1Ãr  r  r  rX   r$   rô   ©r�   r  r  r�   r  r¦  r*   )r   rE  r3   r
   r9   r:   )r,  r  r   r>   r   r   s         r   Ú)test_groupby_numerical_stability_sum_meanr  N
  s`   € ò
 <€DÜ	˜a ˜V a™Z¨dÑ>Ó	?€BÜ�R—Z‘Z Ó(¨$Ô/Ó1€FÜ˜vÑ3¼5À!ÀQÀÈgÑ;VÑW€HÜ×Ò˜&Õ+r   c                  óÞ   • / SQn [        SS/S-  X S.5      nUR                  S5      R                  5       nS/S-  SS	/-   S
S/-   SS/-   n[        X3S.5      n[        R                  " X$SS9  g )Nr  rX   r$   rô   r  r�   r  g0€à7yÃACg1€à7yÃACga€à7yÃ1Cgb€à7yÃ1Cr  r  r  T)Úcheck_exact)r   r3   r¨  r9   r:   )r   r>   r   Úexp_datar   s        r   Ú'test_groupby_numerical_stability_cumsumr  Z
  s   € â;€DÜ	˜a ˜V a™Z¨dÑ>Ó	?€BØ�Z‰Z˜Ó ×'Ñ'Ó)€Fà	ˆ�‰
�i Ð+Ñ+¨y¸)Ð.DÑDÈÈdÀ|ÑSð ô ˜xÑ7Ó8€HÜ×Ò˜&¸Ó=r   c                  ót  • [         R                  R                  S5      R                  S5      n [	        U 5      n[        S5       H!  n[         R                  UR                  X"4'   M#     SUS'   UR                  S5      nUR                  SS9nU/ SQ   R                  SS9n[        R                  " XE5        g )	Nr$   )r#   r#   r#   rX   r   F©Úskipnare  )r7   rp   rq   r¡   r   r5   rÁ   r2   r3   r¨  r9   r:   )r’  r>   Úir?   rï   r   s         r   Ú test_groupby_cumsum_skipna_falser#  f
  s™   € ä
�)‰)×
Ñ
 Ó
"×
2Ñ
2°6Ó
:€CÜ	�3‹€BÜ�1ŽXˆÜŸ™ˆ�‰��‹ñ ð €B€s�GØ	�‰�C‹€Bà
�)‰)˜5ˆ)Ð
!€Cà’/Ñ"×)Ñ)°Ð)Ð7€HÜ×Ò˜#Õ(r   c            	      ó  • [        SSS9n [        U 5      U S   -
  n[        R                  US'   [	        SUS.5      nUR                  S5      nUR                  S	S
S9n[	        SUS   US   [        R                  US   US   S-  /05      n[        R                  " XE5        UR                  S	S	S9n[	        SUS   US   [        R                  [        R                  [        R                  /05      n[        R                  " XE5        g )Nrz  r#   r!   r   r$   rX   ru  r   FT)rg  r!  r   rô   )	r   r   r-   r1   r   r3   r¨  r9   r:   )r­  r=   r>   r?   rï   r¢  s         r   Útest_groupby_cumsum_timedelta64r%  v
  sé   € ä
�\¨1Ñ
-€CÜ
�‹+˜˜A™Ñ
€CÜ�V‰V€Cˆ�Fä	˜ Ñ%Ó	&€BØ	�‰�C‹€Bà
�)‰) ¨tˆ)Ð
4€CÜ
�S˜3˜q™6 3 q¡6¬2¯6©6°3°q±6¸3¸q¹6ÀA¹:ÐFÐGÓ
H€CÜ×Ò˜#Ô#à
�)‰) ¨uˆ)Ð
5€CÜ
�S˜3˜q™6 3 q¡6¬2¯6©6´2·6±6¼2¿6¹6ÐBÐCÓ
D€CÜ×Ò˜#Õ#r   c                 óÀ   • U nUR                  SS9R                  5       nUR                  UR                  5      R                  5       n[        R                  " X#5        g )Nr   r  )r3   rk   r+   r9   ry   )Ú(rand_series_with_duplicate_datetimeindexÚdupsr   r   s       r   Ú!test_groupby_mean_duplicate_indexr)  ˆ
  sI   € Ø3€DØ�\‰\ ˆ\Ð"×'Ñ'Ó)€FØ�|‰|˜DŸJ™JÓ'×,Ñ,Ó.€HÜ×Ò˜6Õ,r   c                  óV  • [        / SQ[        R                  [        R                  [        R                  /5      n U R                  U R                  5      R                  5       n[        / [        / [        R                  S9[        R                  S9n[        R                  " X5        g )Nr
  r•   rL   )r   r7   rÁ   r3   r+   r\   r
   rG   rE   r9   ry   ©r?  r   r   s      r   Ú test_groupby_all_nan_groups_dropr,  �
  sg   € äŠyœ2Ÿ6™6¤2§6¡6¬2¯6©6Ð2Ó3€AØ�Y‰Y�q—w‘wÓ×#Ñ#Ó%€FÜ�b¤ b´·
±
Ñ ;Ä2Ç8Á8ÑL€HÜ×Ò˜6Õ,r   c                 ó,  • [        / / SQS9nUR                  SS/U S9nUR                  US9nU (       a&  [        / / // / /SS/S9nU(       d  S/O	[	        / S	S
9nO[        S5      nU(       d  / SQOSS/n[        / XeS9n[        R                  " XG5        g )Nr,   rç  r   r   rÖ   rf  r—  r(   rŸ  r•   r   rù   )r   r3   r\   r   r
   r   r9   r:   )r×   rg  r>   r?   r   r+   rí   r   s           r   Útest_groupby_empty_multi_columnr.  —
  s•   € ô 
˜¢OÑ	4€BØ	�‰�S˜#�J¨ˆÐ	2€BØ�V‰V ˆVÐ.€FÞÜ˜B ˜8 b¨" X°c¸3°ZÑ@ˆÞ+�3‘%´°rÀÑ1G‰ä˜1“ˆÞ)5“/¸CÀ¸:ˆÜ˜ WÑ:€HÜ×Ò˜&Õ+r   c                  óà   • [        SS//SS//SS//SS///SS/S9n [        SSS/SS//0[        SS/SS	9S
9nU R                  S/S9nUR                  5       n[        R
                  " X15        g )Nr‘  rX   ÚWre   rf   ÚMWr‚   r¥  r¦  r*   rï  )r   r
   r3   r\   r9   r:   )r>   r   r?   r   s       r   Ú*test_groupby_aggregation_non_numeric_dtyper2  §
  s–   € ä	Ø
�ˆsˆ�c˜A˜3�Z #¨ t ¨s°R°D¨kÐ:ÀTÈ3ÀKñ
€Bô à�1�a�&˜2˜r˜(Ð#ð	
ô �S˜#�J TÑ*ñ	€Hð 
�‰˜�vˆÐ	€BØ�V‰V‹X€FÜ×Ò˜&Õ+r   c                  ó  • [        / SQ[        SS5       V s/ s H  n [        U S5      PM     sn [        SS5       V s/ s H  n [        U S-  S5      PM     sn S.5      n[        [        SS5       V s/ s H  n [        U S5      PM     sn [        SS5       V s/ s H  n [        U S-  S5      PM     sn S	.[        S
S/SSS9S9nUR	                  S/S9nUR                  5       n[        R                  " XB5        g s  sn f s  sn f s  sn f s  sn f )N©rX   r   rX   rX   r   rX   rl  Údaysre   rE  r^   rJ   ©r*  rF  r   rE   rQ   ©rD   rj   r*   rï  )r   r5   r   r
   r3   r\   r9   r:   ©r"  r>   r   r?   r   s        r   Ú0test_groupby_aggregation_multi_non_numeric_dtyper9  ¹
  sø   € ä	â Ü05°a¸´Ó<²¨1”)˜A˜vÖ&±Ñ<Ü5:¸1¸a´[ÓA²[°”)˜A ™F FÖ+±[ÑAñ	
ó
€Bô ä05°a¸´Ó<²¨1”)˜A˜vÖ&±Ñ<Ü5:¸1¸a´[ÓA²[°”)˜A ™F FÖ+±[ÑAñ	
ô �Q˜�F '°Ñ4ñ€Hð 
�‰˜�uˆÐ	€BØ�V‰V‹X€FÜ×Ò˜&Õ+ùò =ùÚAùò =ùÚAs   —C;
½D Á2DÂD

c            
      ól  • [        / SQ[        SS5       V s/ s H  n [        U S5      PM     sn [        [        SS5      5      S.5      n[        [        SS5      [        SS5      /SS/S.[	        S	S/S
SS9S9nUR                  S/S9nUR                  5       n[        R                  " XB5        g s  sn f )Nr4  rX   rl  r5  rE  r^   r”   r6  r   rE   rQ   r7  r*   rï  )	r   r5   r   r4   r
   r3   r\   r9   r:   r8  s        r   Ú7test_groupby_aggregation_numeric_with_non_numeric_dtyper;  Ð
  s®   € ä	â Ü05°a¸´Ó<²¨1”)˜A˜vÖ&±Ñ<Ü”e˜A˜q“kÓ"ñ	
ó
€Bô Ü˜˜FÓ#¤Y¨q°&Ó%9Ð:À!ÀQÀÑHÜ�Q˜�F '°Ñ4ñ€Hð
 
�‰˜�uˆÐ	€BØ�V‰V‹X€FÜ×Ò˜&Õ+ùò =s   —B1
c            	      óö   • SSSSS.SSSSS.SSSSS./n [        U 5      nXS   S:H     nUR                  S5      nUR                  5       n[        / S	Q// S
Q[        S/SS9S9n[        R
                  " XE5        g )NFTg      %@)Ú
filter_colÚgroupby_colÚbool_colÚ	float_colg     €4@g     €>@r=  r>  )rÐ  rÐ  g$+¿ÆH@)r=  r?  r@  r¦  rù   )r   r3   r6   r
   r9   r:   )Údictsr>   Ú	df_filterÚdfgbr   r   s         r   Útest_groupby_filtered_df_stdrD  ä
  sš   € ð ¨T¸tÐRVÑWØ¨D¸dÐQUÑVØ¨D¸dÐQUÑVð€Eô
 
�5Ó	€Bà�lÑ# tÑ+Ñ,€IØ×Ñ˜]Ó+€DØ�X‰X‹Z€FÜÚ	ÐÚ7Ü�T�F Ñ/ñ€Hô
 ×Ò˜&Õ+r   c            	      ó°  • [        [        [        S5      5      [        [        / SQ5      SS9[        R
                  " / SQSS/S9S	.5      n U R                  S
S/SS9R                  nS
[        S5      4[        R                  " S/5      S[        S5      4[        R                  " S/5      S[        S5      4[        R                  " S/5      0nX:X  d   eg )NÚabc)r¬  z
2018-02-01z
2018-03-01Úcategoryr•   )r)   r   rX   r   rX   )Ú
categoriesr4  r  r  F©rˆ  z2018-01-01 00:00:00z2018-02-01 00:00:00r#  z2018-03-01 00:00:00r$   )r   r   r4   r   r   Ú
from_codesr3   rR  r   r7   r¢   r¬  s      r   Ú2test_datetime_categorical_multikey_groupby_indicesrK  ø
  sÈ   € ä	äœ˜U›Ó$ÜÜÒFÓGØ ñô ×'Ò'ª
ÀÀ1¸vÑFñ	
ó	
€Bð �Z‰Z˜˜c˜
¨UˆZÐ3×;Ñ;€Fà	ŒiÐ-Ó.Ð/´·²¸1¸#³Ø	ŒiÐ-Ó.Ð/´·²¸1¸#³Ø	ŒiÐ-Ó.Ð/´·²¸1¸#³ð€Hð
 ÓÐÑr   c                  ó˜  • S/S-  S/S-  -   n [         R                  [         R                  SSS/[         R                  SSSS/-   n[        X/5      R                  nSS	/Ul        S
n[
        R                  " [        US9   UR                  S5      S	   R                  SSS9R                  5         S S S 5        g ! , (       d  f       g = f)NÚAlicer#   ÚBobrX   r$   rK   rô   rj   r±  z@^[a-zA-Z._]*\(\) got an unexpected keyword argument 'min_period'rV   )ÚwindowÚ
min_period)r7   rÁ   r   rî   rí   r|   r}   r�  r3   Úrollingr\   )Úname_lÚval_lÚtest_dfÚresult_error_msgs       r   Ú#test_rolling_wrong_param_min_periodrV    s³   € àˆY˜‰]˜e˜W q™[Ñ(€FÜ�V‰V”R—V‘V˜Q  1Ð%¬¯©°°A°q¸!Ð(<Ñ<€EÜ˜˜Ó(×*Ñ*€GØ˜u�o€G„Oð 	Lð ô 
�Š”yÐ(8Ó	9Ø�‰˜Ó Ñ&×.Ñ.°aÀAÐ.ÐF×JÑJÔL÷ 
:×	9Ö	9ús   Â1B;Â;
C	c           	      ó  • [        / SQ/ SQ[        / SQU S9S.5      n[        R                  SS.nUR                  S/5      R	                  U5      n[        S	S
/S	/SS/SS/S.5      R                  S5      n[        R                  " X45        g )N)ÚThomasrX  úThomas John)i°  i  é„  )ÚsadÚhappyr\  r•   )ÚNameÚCreditÚMoodr\   )r_  r^  r]  r\  r[  iÄ	  rZ  rX  rY  )r_  r^  r]  )r   r   Úmoder3   rx   r(  r9   r:   )Úany_string_dtyper>   Úaggregate_detailsr   Úexpected_results        r   Ú.test_by_column_values_with_same_starting_valuerd    sš   € ä	â7Ú'ÜÒ4Ð<LÑMñ	
ó
€Bô "(§¡¸Ñ>Ðà�Z‰Z˜˜Ó!×%Ñ%Ð&7Ó8€FÜà˜uÐ% wÐ/Ø˜S�kØ˜}Ð-ñ	
ó÷ �i�Óð ô ×Ò˜&Õ2r   c                  ó  • / SQ/ SQ/n [        S[        R                  " U SS/S9S9nUR                  SS/S	9R	                  5       n[        SS
/[        R
                  " SS/SS/S95      n[        R                  " X#5        g )N)NrX   r   rX   )r$   rK   r$   rK   rX   r  r  r—  r*   r   r  r$   )rÐ  r$   )r  rK   )r   r   r»  r3   r\   r™  r9   ry   )r’  r=   r   r   s       r   Ú#test_groupby_none_in_first_mi_levelrf  2  s   € âšLÐ
)€CÜ
�œ*×0Ò0°¸SÀ#¸JÑGÑ
H€CØ�[‰[  1˜vˆ[Ð&×*Ñ*Ó,€FÜØ	
ˆAˆ”
×&Ò&¨°(Ð';ÀCÈÀ:ÑNó€Hô ×Ò˜6Õ,r   c                 ó
  • [        / SQ/ SQ/ SQS.5      nU (       a  [        R                  /OS /nUR                  US9nUR	                  5       n[        SS/SS	/S
.[        SS/US   S9S9n[        R                  " XE5        g )NrC  )rX   rX   r$   rK   )rô   r#   rl  r^   )Nr  r#  rï  r$   r#   rJ   é   r:  rX   r   r¦  r*   )r   r7   rÁ   r3   r\   r
   r9   r:   )r‘  r>   rµ  r?   r   r   s         r   Útest_groupby_none_column_nameri  =  sv   € ä	š,ª\ÂÑMÓ	N€BÞ'Œ"�&‰&‰¨d¨V€BØ	�‰�rˆÐ	€BØ�V‰V‹X€FÜ  1˜v¨Q°¨GÑ4¼EÀ1ÀaÀ&ÈrÐRSÉuÑ<UÑV€HÜ×Ò˜&Õ+r   Ú	selectionc                 ó
  • [        SS/[        R                  S/[        R                  S/S.SS/S9nU c  UR                  S/5      OUR                  S/5      U    nU VVs/ s H  u  p4UPM	     nnnS	S
/nXV:X  d   eg s  snnf )NrX   r$   r#   r4  rQ   r*  r*   r  ©rX   )r$   )r   r7   rÁ   r3   )rj  r>   r€   r   r`  r   r   s          r   Ú!test_single_element_list_groupingrm  G  s‡   € ô 
˜!˜Q˜¤r§v¡v¨q k¼¿¹À¸ÑDÈSÐRUÈJÑ	W€BØ#,Ñ#4ˆb�j‰j˜#˜Ô¸"¿*¹*ÀcÀUÓ:KÈIÑ:V€GÙ 'Ô(¢‘f�c‹c¡€FÑ(à�dˆ|€HØÓÐÑùó )s   Á"A?c                  ó  • [        / SQ/ SQS.5      n U S   R                  S5      U S'   [        / SQ/ SQS.5      nUS   R                  S5      US'   U R                  SSS	9nUR                  5       n[        R
                  " X15        g )
N)r  r  r#  r  )rX   r$   rK   r$   )Ústr_colÚnum_colro  Ústringr4  )rG  r  r\  FrÖ   )r   r‹   r3   rk   r9   r:   )r>   r   r€   r   s       r   Útest_groupby_string_dtyperr  R  sŠ   € ä	Ò3ÂÑMÓ	N€BØ�y‘M×(Ñ(¨Ó2€B€y�MÜòò
 'ñ	
ó	€Hð # 9Ñ-×4Ñ4°XÓ>€HˆYÑØ�j‰j˜¨UˆjÐ3€GØ�\‰\‹^€FÜ×Ò˜&Õ+r   zlevel_arg, multiindex)©r   F)rs  Tc                 ó   • [        SS/SS/SS/S.SS	/S
9nU(       a  UR                  SS/5      nSn[        R                  " [        US9   UR                  U S9 VVs/ s H  u  pEUPM	       nnS S S 5        g s  snnf ! , (       d  f       g = f)NrX   r$   rK   rô   r#   rl  r4  rQ   r*  r*   r  r  zÏCreating a Groupby object with a length-1 list-like level parameter will yield indexes as tuples in a future version. To keep indexes as scalars, create Groupby objects with a scalar level parameter instead.rV   r  )r   r(  r9   ru   rv   r3   )Ú	level_argr+  r>   r7  r   r`  s         r   Ú7test_single_element_listlike_level_grouping_deprecationrv  f  s�   € ô
 
˜!˜Q˜ q¨! f°A°q°6Ñ:À3ÈÀ*Ñ	M€BÞØ�\‰\˜3 ˜*Ó%ˆð	,ð ô 
×	#Ò	#¤M¸Ó	BØŸ:™:¨I˜:Ñ6Ô7Ò6‘�‹Ñ6Ò7÷ 
CÐ	BùÛ7÷ 
CÕ	Bús   ÁA?ÁA9Á-A?Á9A?Á?
B)r\   r¨  Úcumprodr	  c                 óî   • Sn[        SU/S.5      n[        UR                  S5      U 5      " 5       U-
  n[        SS/0[        S/SS9S9nU S	;   a  UR	                  S
S9n[
        R                  " X45        g )Nl   ÌL™33ffrX   r  r  r  r   r¦  r*   )r¨  rw  TrÂ  )r   rE  r3   r
   rÇ  r9   r:   )r,  r±  r>   r   r   s        r   Ú#test_groupby_avoid_casting_to_floatry  x  s{   € ð €CÜ	˜ # Ñ'Ó	(€BÜ�R—Z‘Z “_ dÔ+Ó-°Ñ3€FÜ˜# ˜s˜¬5°!°¸3Ñ+?Ñ@€HØÐ$Ó$Ø×'Ñ'¨TÐ'Ð2ˆÜ×Ò˜&Õ+r   z	func, val)r\   rK   )r	  r$   c           	      óÜ   • [        SSS[        R                  /S.U S9n[        UR	                  S5      U5      " 5       n[        SU/0[        S/SU S9U S9n[        R                  " XE5        g )	NrX   r$   r  r•   r  r  r©  rL   )r   r-   ÚNArE  r3   r
   r9   r:   )Úany_numeric_ea_dtyper,  r±  r>   r   r   s         r   Útest_groupby_sum_support_maskr}  „  sl   € ô 
˜ ! Q¬¯© Ñ/Ð7KÑ	L€BÜ�R—Z‘Z “_ dÔ+Ó-€FÜØ	ˆsˆeˆÜ�Q�C˜cÐ)=Ñ>Ø"ñ€Hô
 ×Ò˜&Õ+r   z
val, dtype)éo   r  )éÞ   Úuintc           	      ó  • [        SX /S.U S3S9nUR                  S5      R                  5       n[        SU S-  /0[        S/SU S3S9U S	3S
9n[        R
                  " X45        UR                  S5      R                  5       n[        SX S-  /0U S	3S9n[        R
                  " X45        UR                  S5      R                  5       n[        SX -  /0[        S/SU S3S9U S	3S
9n[        R
                  " X45        g )NrX   r  Ú8r•   r  r  r$   r©  Ú64rL   )r   r3   r\   r
   r9   r:   r¨  r	  )r±  rD   r>   r   r   s        r   Útest_groupby_overflowr„  ‘  s  € ô 
˜ # Ñ,°u°g¸Q°KÑ	@€BØ�Z‰Z˜‹_× Ñ Ó"€FÜØ	ˆs�Q‰wˆiÐÜ�Q�C˜c¨E¨7°!¨Ñ5Ø��rˆlñ€Hô
 ×Ò˜&Ô+à�Z‰Z˜‹_×#Ñ#Ó%€FÜ˜# ¨1¡W˜~Ð.¸¸¸r°lÑC€HÜ×Ò˜&Ô+à�Z‰Z˜‹_×!Ñ!Ó#€FÜØ	ˆs‰yˆkÐÜ�Q�C˜c¨E¨7°!¨Ñ5Ø��rˆlñ€Hô
 ×Ò˜&Õ+r   zskipna, val)TrK   c                 óâ   • [        SS[        R                  S/S.U S9nUR                  S5      R	                  US9n[        SS[        R                  U/0U S9n[
        R                  " XE5        g )NrX   r$   r  r•   r  r   r  )r   r-   r{  r3   r¨  r9   r:   )r|  r!  r±  r>   r   r   s         r   Útest_groupby_cumsum_maskr†  ª  sj   € ô 
˜ !¤R§U¡U¨A Ñ/Ð7KÑ	L€BØ�Z‰Z˜‹_×#Ñ#¨6Ð#Ð2€FÜØ	ˆq”"—%‘%˜ˆoÐØ"ñ€Hô ×Ò˜&Õ+r   zval_in, index, val_out)r  r  r\  r  rQ  )r‘   r‘   r’   r'  Úblah)r\  r  rQ  r\  )r  r  r\  r  rQ  g      @)r‘   r‘   r’   r'  r‡  r‡  )r\  r  g      &@r\  c           	      ód  • [        U S[        USS9S9nUR                  S5      R                  5       n[        US[        / SQSS9S9n[        R
                  " XE5        UR                  5       R                  S5      R                  5       nUR                  5       n[        R                  " XE5        g )Nr  r‡  r¦  )r   rj   r+   )r’   r'  r‡  r‘   )r   r
   r3   r\   r9   ry   r/   r:   )Úval_inr+   Úval_outÚseriesr   r   s         r   Ú(test_groupby_index_name_in_index_contentrŒ  ¶  s—   € ô" ˜ h´e¸EÈÑ6OÑP€FØ�^‰^˜FÓ#×'Ñ'Ó)€FÜØØÜÒ1¸Ñ?ñ€Hô
 ×Ò˜6Ô,à�_‰_Ó×&Ñ& vÓ.×2Ñ2Ó4€FØ× Ñ Ó"€HÜ×Ò˜&Õ+r   r]  )rX   re   é    rº  r!  c                 óì   • [        SS/U -  S.5      nUS   R                  S5      US'   UR                  S5      R                  5       n[        SU /0[	        S/SS9S9n[
        R                  " X#5        g )NrX   T)r>  r~  r~  r>  r¦  r*   )r   Úeqr3   r\   r
   r9   r:   )r]  r>   r   r   s       r   Útest_sum_of_booleansr�  Õ  so   € ô 
 1¨t¨f°q©jÑ9Ó	:€BØ�F‘—‘˜tÓ$€B€v�JØ�Z‰Z˜Ó&×*Ñ*Ó,€FÜ˜& 1 #˜¬e°Q°C¸mÑ.LÑM€HÜ×Ò˜&Õ+r   z<ignore:invalid value encountered in remainder:RuntimeWarning)rO  ÚtailrÆ  rÀ   r  c                 ó°  • [        S[        R                  S[        R                  S/[        S5      S.5      nU S:X  a   [	        UR                  S5      U 5      " SS	9nO [	        UR                  S5      U 5      " 5       nU S
;   a)  [        S/ SQ05      R                  [        / SQSS95      nO[        / SQ/ SQS./ SQS9n[        R                  " X#5        g )Nr  r  r#  r#   ru  rÆ  r   r   )r]  )rÀ   r  r   r  r4  r¦  r*   )
r   r7   rÁ   r5   rE  r3   r(  r   r9   r:   )r„  r>   r   r   s       r   Útest_groupby_method_drop_nar“  ß  s¯   € ô 
˜#œrŸv™v s¬B¯F©F°CÐ8¼uÀQ»xÑHÓ	I€Bà�ƒÜ˜Ÿ™ C›¨&Ô1°AÑ6‰ä˜Ÿ™ C›¨&Ô1Ó3ˆàÐ"Ó"Ü˜c¢9Ð-Ó.×8Ñ8Ü’?¨Ñ-ó
‰ô ¢?ºÑCÊ9ÑUˆÜ×Ò˜&Õ+r   c                  óØ  • [         R                  " SSSS9n [        [        S5      5      S-  nU R	                  5       nUR                  U5      n[        R                  " [        SS9   UR                  5         S S S 5        [        R                  " [        SS9   UR                  5         S S S 5        [        R                  " [        S	S9   UR                  5         S S S 5        [        R                  " [        S
S9   UR                  5         S S S 5        UR                  5       nUSS  n[        [        S5      [        S9Ul        ["        R$                  " XE5        UR'                  5       nUS S n[        [        S5      [        S9Ul        ["        R$                  " XE5        g ! , (       d  f       GN4= f! , (       d  f       GN= f! , (       d  f       Nó= f! , (       d  f       NÒ= f)Nrz  rº  r—   r÷   re   z+Period type does not support sum operationsrV   z.Period type does not support cumsum operationsz,Period type does not support prod operationsz/Period type does not support cumprod operationsiöÿÿÿr•   )r-   Úperiod_ranger4   r5   Ú	to_seriesr3   r|   r}   r�  r\   r¨  r	  rw  rÀ  r
   r  r+   r9   ry   r  )ÚpiÚgrpsr=   r?   rï   r   s         r   Útest_groupby_reduce_periodr™  õ  sY  € ä	�Š˜¨s¸Ñ	=€BÜ”�b“	‹?˜RÑ€DØ
�,‰,‹.€CØ	�‰�TÓ	€Bä	�Š”yÐ(UÓ	VØ
�‰Œ÷ 
Wä	�ŠÜÐIó
ð 	�	‰	Œ÷
ô 
�Š”yÐ(VÓ	WØ
�‰Œ	÷ 
Xä	�ŠÜÐJó
ð 	�
‰
Œ÷
ð
 �&‰&‹(€CØ�3�4ˆy€HÜœ5 ›9¬CÑ0€H„NÜ×Ò˜3Ô)à
�&‰&‹(€CØ�3�Bˆx€HÜœ5 ›9¬CÑ0€H„NÜ×Ò˜3Õ)÷+ 
WÖ	Vú÷
ö 
ú÷ 
XÕ	Wú÷
õ 
ús0   Á(F&ÂF8ÃG
Ã>GÆ&
F5Æ8
GÇ

GÇ
G)c                  óÂ   • [        / SQ/5      n / SQU l        U R                  U S   5      nUR                  nU R	                  / SQSS9n[
        R                  " X#5        g )N)r   rX   r$   rK   r¢  rX   )r   r$   rK   rÆ   )r   rí   r3   Ú_obj_with_exclusionsrT  r9   r:   )r>   r?   r   r   s       r   Ú*test_obj_with_exclusions_duplicate_columnsrœ    sR   € ä	’L�>Ó	"€BÚ€B„JØ	�‰�B�q‘EÓ	€BØ×$Ñ$€FØ�w‰w’y qˆwÐ)€HÜ×Ò˜&Õ+r   c                 óN  • SSS.SSS./n[        U[        S9nUR                  SSSS	9nU (       a3  UR                  S
S9n[        SS/S/S9n[        R
                  " XE5        g [        R                  " [        SS9   UR                  U S9  S S S 5        g ! , (       d  f       g = f)Nr‘   r’   r  ÚcarÚdarr•   r  F)r×   rM  Trf  r¥  z(could not convert string to float: 'bar'rV   )	r   r  r3   r6   r9   r:   r|   r}   rë  )rg  Údicts_non_numericr>   rC  r   Úexpected_dfs         r   Ú'test_groupby_numeric_only_std_no_resultr¢    sŸ   € ð  %¨5Ñ1¸ÀUÑ3KÐLÐÜ	Ð$¬FÑ	3€BØ�:‰:�c E°ˆ:Ð6€DæØ—‘ t�Ð,ˆÜ ¨ ¸¸Ñ>ˆÜ
×Ò˜fÕ2ä�]Š]ÜÐHó
ð �H‰H ,ˆHÑ/÷
÷ 
ö 
ús   Á=BÂ
B$z7ignore:invalid value encountered in cast:RuntimeWarningc                  ó®  • [        / SQ/ SQS.5      n [        R                  " U S   [        R                  " SSS5      S9nU R                  US	/S
S9S   R                  S5      n[        [        SSSS9[        SSSS9[        SSSS9[        SSSS9/SS9n/ SQn[        R                  " X4/SS	/S9n[        [        R                  " S[        R                  S[        R                  S[        R                  S[        R                  [        R                  S[        R                  [        R                  /5      USS9n[        R                  " X&5        g )N)çš™™™™™¹?çš™™™™™É?ç333333Ó?çš™™™™™Ù¿ç      à?)r  r  r  r#  r  )rQ   ÚwrQ   r   rX   r#   rÔ   r©  FrI  rk   gD‹lçû©Ù¿r¤  rÎ  )Úclosedr¥  r¦  r¨  T)r—  r4  r—  r§  r  )r   r-   Úqcutr7   Úlinspacer3   rx   r   r   r   r®  r   r¢   rÁ   r9   ry   )r>   Úqqr   Úcategorical_index_level_1Úindex_level_2rž  r   s          r   Ú/test_grouping_with_categorical_interval_columnsr°  0  s9  € ô 
Ò3Ò:SÑTÓ	U€BÜ	�Š��C‘œBŸKšK¨¨1¨aÓ0Ñ	1€BØ�Z‰Z˜˜S˜	¨EˆZÐ2°3Ñ7×;Ñ;¸FÓC€FÜ +ä�V˜S¨Ñ1Ü�S˜# gÑ.Ü�S˜# gÑ.Ü�S˜# gÑ.ð		
ð ñ!Ðò $€MÜ	×	 Ò	 Ø	"Ð2¸3À¸*ñ
€Bô Ü
�ŠàÜ—‘ØÜ—‘ØÜ—‘ØÜ—‘Ü—‘ØÜ—‘Ü—‘ðó	
ð  Øñ%€Hô( ×Ò˜6Õ,r   Úbug_varc                 ó:  • [        SX U [        R                  /05      n[        U [        5      (       a  UR                  [        5      nUR                  S 5      nUR                  SS9n[        X U S /S/US   R                  S9n[        R                  " X45        g )Nr   c                 ó   • U $ rZ   rO   rP   s    r   rR   Ú;test_groupby_sum_on_nan_should_return_nan.<locals>.<lambda>`  s   € ¡r   rX   )Ú	min_count)rí   rD   )r   r7   rÁ   r†  rŸ  r‹   r  r3   r\   rD   r9   r:   )r±  r>   rC  r   r¡  s        r   Ú)test_groupby_sum_on_nan_should_return_nanr¶  Z  s‰   € ô 
�C˜'¨G´R·V±VÐ<Ð=Ó	>€BÜ�'œ3×ÑØ�Y‰Y”vÓˆØ�:‰:‘kÓ"€DØ�X‰X ˆXÐ"€FäØ	˜7 DÐ)°C°5ÀÀ3ÁÇÁñ€Kô ×Ò˜&Õ.r   )rÁ  ÚcorrÚcummaxÚcumminrw  rC  ÚrankrÛ   rê  rÌ  rU  r  r…  r›   rÓ  rÐ  Ú
pct_changec                 óþ   • [        S[        U 5      S9nX l        U R                  S/5      S/   nU S/   R                  U S   5      n[	        X15      " 5       n[	        XA5      " 5       n[
        R                  " XV5        g )NÚ2014r!   r   r(   )r   rt   r+   r3   rE  r9   r:   )r>   r„  ÚrngrÞ   Úg_exprï   r¢  s          r   Ú#test_groupby_selection_with_methodsrÀ  i  sv   € ô0 �V¤S¨£WÑ
-€CØ„Hà
�
‰
�C�5Ó˜3˜%Ñ €AØ�ˆu‰I×Ñ˜b ™gÓ&€Eô �!Ô
Ó
€CÜ
�%Ô
 Ó
"€Cô ×Ò˜#Õ#r   c                 ól  • [        S[        U 5      S9nSU R                  l        Xl        U R                  S/5      S/   nU S/   R                  U S   5      nSn[        R                  " [        US9   [        R                  " UR                  S5      UR                  S5      5        S S S 5        S	n[        R                  " [        US9   [        R                  " UR                  UR                  5        S S S 5        [        R                  " UR                  S
 5      UR                  S 5      5        [        R                  " UR                  S5      R                  5       UR                  S5      R                  5       5        [        R                  " UR                  S5      R                  5       UR                  S5      R                  5       5        [        R                  " UR!                  S 5      UR!                  S 5      5        g ! , (       d  f       GNo= f! , (       d  f       GN2= f)Nr½  r!   r‘   r   r(   ré  rV   r   z%DataFrameGroupBy.dtypes is deprecatedc                 ó"   • U R                  5       $ rZ   r[   rP   s    r   rR   Ú6test_groupby_selection_other_methods.<locals>.<lambda>Ÿ  s
   € ¨A¯E©E¬Gr   c                 ó"   • U R                  5       $ rZ   r[   rP   s    r   rR   rÃ  Ÿ  s
   € ÈAÏEÉEÌGr   r—   c                 ó   • [        U 5      S:H  $ rN   rR  rP   s    r   rR   rÃ  ¥  s   € œ3˜q›6 Qš;r   c                 ó   • [        U 5      S:H  $ rN   rR  rP   s    r   rR   rÃ  ¥  s   € ÄÀAÃÈ!Âr   )r   rt   rí   rj   r+   r3   r9   ru   rv   r:   rè  r£   rz   Úresamplerk   r®  rX  )r>   r¾  rÞ   r¿  rî  rƒ   s         r   Ú$test_groupby_selection_other_methodsrÈ  �  s†  € ä
�V¤S¨£WÑ
-€CØ€B‡J�J„OØ„Hà
�
‰
�C�5Ó˜3˜%Ñ €AØ�ˆu‰I×Ñ˜b ™gÓ&€Eð 7€HÜ	×	#Ò	#¤M¸Ó	BÜ
×Ò˜aŸh™h q›k¨5¯<©<¸«?Ô;÷ 
Cà
1€CÜ	×	#Ò	#¤M¸Ó	=Ü
×Ò˜aŸh™h¨¯©Ô5÷ 
>ä×Ò˜!Ÿ'™'Ñ"3Ó4°e·k±kÑBSÓ6TÔUä×Ò˜!Ÿ*™* S›/×.Ñ.Ó0°%·.±.ÀÓ2E×2JÑ2JÓ2LÔMÜ×Ò˜!Ÿ*™* S›/×.Ñ.Ó0°%·.±.ÀÓ2E×2JÑ2JÓ2LÔMä×ÒØ	�‰Ñ&Ó'¨¯©Ñ6KÓ)Lõ÷ 
CÖ	Bú÷ 
>Ö	=ús   Á46HÃ,H$È
H!È$
H3c                 ó:  • [        / SQ5      R                  U 5      n[        / SQ/ SQUS.5      n[        SSSU S9n[        U/ SQ/ SQS	.5      nUR	                  [        S
SS95      nUR                  5       R                  5       n[        R                  " Xd5        g )N)z2016-08-31 22:08:12.000z2016-08-31 22:09:12.200z2016-08-31 22:20:12.400)r  r  r\  )ÚquantÚquant2Útime2z2016-08-31 22:08:00rh  Ú1min)r"   rø   Úunit)rX   rX   r   r   r   r   r   r   r   r   r   r   rX   )rÌ  rÊ  rË  rÌ  )r   rø   )
r   Úas_unitr   r   r3   r	   rÁ  rÇ  r9   r:   )rÎ  Úidx2Ú	test_datarÌ  Úexpected_outputr?   r   s          r   Útest_groupby_with_Time_GrouperrÓ  ©  s›   € Üò	
ó÷ �gˆdƒmð 	ô Ú!ª_ÀtÑLó€Iô Ð,°b¸vÈDÑQ€EÜàÚ<Ú=ñ	
ó€Oð 
×	Ñ	œ7 w°VÑ<Ó	=€BØ�X‰X‹Z×#Ñ#Ó%€Fä×Ò˜&Õ2r   c                  óÒ   • [        / SQ[        SSS9SS9n U R                  U 5      R                  5       n[        SS/SS	9nSUR                  l        [        R                  " X5        g )
NrÆ  z
2022-01-01rK   r!   Újanr  r$   rX   r¦  )r   r   r3   rÁ  r+   rj   r9   ry   r+  s      r   Ú1test_groupby_series_with_datetimeindex_month_namerÖ  Å  sW   € äŠy¤
¨<ÀÑ CÈ%ÑP€AØ�Y‰Y�q‹\×ÑÓ!€FÜ�q˜!�f 5Ñ)€HØ€H‡N�NÔÜ×Ò˜6Õ,r   Útest_serieszkwarg, value, name, warn)rµ  r  rX   Nrµ  rl  )r   r   rX   Nc                 ó�  • [        S/ SQ0[        / SQSS9S9nU (       a  US   nUR                  " S0 X0D6nSn[        R                  " XGS9   UR                  U5      nS S S 5        U (       a  [        S	S
/[        SS/SS9SS9n	O[        SS	S
/0[        SS/SS9S9n	[        R                  " WU	5        g ! , (       d  f       N]= f)Nr  r°  r¯  r  r¦  r*   z&you will need to pass a length-1 tuplerV   rK   rô   rX   r  rO   )r   r
   r3   r9   ru   r«  r   r˜  )
r×  Úkwargr˜   rj   ræ   r±  r?   rƒ   r   r   s
             r   Ú$test_depr_get_group_len_1_list_likesrÚ  Î  s·   € ô �Sš)Ð$¬E²)À#Ñ,FÑ
G€CÞØ�#‰hˆØ	�ŠÑ	&˜�~Ñ	&€BØ
2€CÜ	×	#Ò	# DÓ	4Ø—‘˜dÓ#ˆ÷ 
5æÜ˜1˜a˜&¬¨q°!¨f¸3Ñ(?ÀcÑJ‰ä˜c A q 6˜]´%¸¸A¸ÀSÑ2IÑJˆÜ‡O‚O�F˜HÕ%÷ 
5Õ	4ús   ÁB7Â7
Cc                  óØ   • [        [        [        R                  /5      S/S.5      n U R	                  SS/SSS9R                  5       n[        S/5      n[        R                  " X5        g )NrX   r  r  r  F)r*  rˆ  r   )	r   r   r7   rÁ   r3   rÒ  r   r9   ry   r¬  s      r   Útest_groupby_ngroup_with_nanrÜ  ê  sX   € ä	œ¤b§f¡f XÓ.°a°SÑ9Ó	:€BØ�Z‰Z˜˜c˜
¨5¸5ˆZÐA×HÑHÓJ€FÜ�q�c‹{€HÜ×Ò˜6Õ,r   c                  ó6  • [        / SQ/ SQ/ SQ/ SQ/ SQS.5      n [        R                  " [        SS9   U R	                  S	/ S
QS9nS S S 5        WR                  S	5      n[        / SQ/ SQS.5      n[        R                  " X#5        g ! , (       d  f       NH= f)N)r   rK   r$   rK   )rô   rX   rl  r^   )rK   r”   r$   re   )rX   rh  rl  r¶  )éüÿÿÿr#   rl  iùÿÿÿ)ry  rz  Úcol3Úcol4Úcol5Ú
deprecatedrV   rX   )rX   r$   rK   r$   rX   )rÇ   rµ  )ry  rá  )r   r9   ru   rv   r3   r«  r:   rä  s       r   Útest_get_group_axis_1rã  ò  s‰   € ä	â Ú Ú!Ú"Ú"ñ	
ó
€Bô 
×	#Ò	#¤M¸Ó	FØ—*‘* !ª�*Ð8ˆ÷ 
Gà×Ñ˜qÓ!€FÜâ Ú"ñ	
ó€Hô ×Ò˜&Õ+÷ 
GÕ	Fús   µB
Â

Bc            	      óè   • [        SSSSS[        R                  [        R                  /0/ SQS9n U R                  SS	9R	                  5       n[        S/ S
Q0/ SQS9n[
        R                  " XSS9  g )Nr  rX   r$   rK   rô   rÚ  r*   r   r  )rX   r$   rK   rô   r$   rK   Fr  )r   r7   rÁ   r3   rÓ  r9   r:   r¬  s      r   Ú(test_groupby_ffill_with_duplicated_indexrå  	  se   € ä	�C˜!˜Q  1¤b§f¡f¬b¯f©fÐ5Ð6Ò>PÑ	Q€Bà�Z‰Z˜aˆZÐ ×&Ñ&Ó(€FÜ˜#Ò1Ð2Ò:LÑM€HÜ×Ò˜&¸Ó>r   c           	      ó   • [        [        R                  [        5      (       a   e[	        [        S5      [        S5      S S /[        S5      [        S5      [        S5      [        S5      /S.5      nUR                  SSS	9nU (       a  US
   nUR                  R                  n[        [        S5      S /SS9n[        R                  " X45        g )NrX   r$   rK   rô   r#   )r   r˜   r   F)r*  r˜   r¦  )r†  ÚdecimalÚInvalidOperationr�  r   r   r3   rÁ  Úresult_indexr
   r9   rú  )r×  r>   r?   r   r   s        r   Útest_decimal_na_sortrê    s®   € ô
 œ'×2Ñ2´I×>Ñ>Ð>Ð>Ü	ä˜A“J¤¨£
¨D°$Ð7Ü˜a“j¤'¨!£*¬g°a«j¼'À!»*ÐEñ	
ó
€Bð 
�‰�E %ˆÐ	(€BÞØ�‰[ˆØ�[‰[×%Ñ%€FÜ”g˜a“j $Ð'¨eÑ4€HÜ×Ò˜&Õ+r   )År   rç  r   rŽ  Únumpyr7   r|   Úpandas.errorsr   r   Úpandas.util._test_decoratorsÚutilÚ_test_decoratorsÚtdÚpandasr-   r   r   r	   r
   r   r   r   r   r   r   r   r   Úpandas._testingÚ_testingr9   Úpandas.core.arraysr   Úpandas.core.commonÚcoreÚcommonrß  ÚmarkÚfilterwarningsÚ
pytestmarkr   rC   Úparametrizer‡   rŽ   r¥   rÃ   rè   rñ   r  r  r  r   r:  rG  r[  rd  rj  r{  r}  rˆ  r’  r£  r­  r²  r·  rÏ  rÖ  rÙ  rÝ  râ  rå  rì  rû  rþ  r  r  r  r  r  r   r$  r-  r0  r;  r@  rD  rI  rO  rV  ra  rc  rs  rw  r|  r~  r‰  r‹  r�  r”  rœ  r§  r¬  r¯  r³  r¸  r¼  rÆ  rÈ  rÓ  rÖ  ræ  rê  rö  rù  rþ  r  r  r  r  r  r6  r;  rM  rZ  r_  rp  ry  r•  r¢   r   r¥  r§  r©  r±  rµ  r¸  rÀ  rÃ  rË  rÝ  rß  rá  rï  rô  rö  rû  rÿ  r  r  r  ÚparamÚ
skip_if_nor  r  r  r  r#  r%  r)  r,  r.  r2  r9  r;  rD  rK  rV  rd  rf  ri  rm  rr  rv  ry  r}  r„  r{  r†  rŒ  r�  r“  r™  rœ  r¢  r°  r¶  rÀ  rÈ  rÓ  rÖ  rv   rÚ  rÜ  rã  rå  rê  rO   r   r   Ú<module>rþ     sŒ  ðÝ Û Ý Û 	ã Û ÷÷ *Ð )ã ÷÷ ÷ ó õ Ý +ß  Ð  à�[‰[×'Ñ'Ð(SÓT€
òò,ð6 ‡�×Ñ˜Ò"JÓKñ>+ó Lð>+òBDò-ò.E&òP2Iðj ‡�×Ñ˜ d¨E ]Ó3ñ)ó 4ð)ò,$ò,òð ‡�×ÑØÒFóñ,óð,ò6:'òz ò0%&òP#ò.8ò6ò8+ò-+ò`6ðr ‡�×Ñ˜Ñ 1Ñ3EÐFÓGñ-ó Hð-ò@-ò 0ò*ò@+òF,òD.ò2&ò,ò.,ò	Dò6ò0	+ò<ð8 ‡�×ÑØØ
ˆE€Nóñ,ó	ð,ð ‡�×ÑØÚ:óð ‡�×Ñ˜¨$°¨Ó7ñ0ó 8ó	ð
0ò@
òò'ò0(ò+ò0(ò.ò.ò@-ò,ò$,ò.'ò*;òZ,ò,ò(
ò,ò-ò"(ò.,ò	,òòò/ò.<ò	-òBò*
,òò<&ò~ò	8ò#ò$*0òZ&ò-ò0ò,ò-ð ‡�×Ñ˜ S¨3°¨*Ð$5Ó6ñó 7ðò8#ò$/ò@ò*5ò6$ò*.4òb-ò:,ð ‡�×ÑØØˆX�y 6¨8Ð"4°v¸yÐ6IÐJóð ‡�×ÑØ�\ ?°\À?Ð4SÐTóñóó	ðò6
ð$ ‡�×Ñ˜ S¨3¨% LÓ1Ø‡�×Ñ˜ 3 %¨#¨s¨Ð!4Ó5Ø‡�×ÑØà	ˆØ	
ˆØ	ˆØ	ˆÙ�Q�CÓÙ	�Q‹ÐÙ�1�a˜˜|Ñ,Ø
�‹˜¨a°cÑ:Ø
�‹�!�˜GÑ$Ø
�‹�!�˜IÑ&Ø
�‹�%� 	Ñ*ðò	ð ð ð: ‡�×Ñ˜Ò#;Ó<Ø‡�×ÑØÒ
Cóñ{&óó =ó;ó 6ó 2ðF{&ò|	+ò-ò&"ò,ò8-ò ò-ò ,ð ‡�×Ñ˜¨¨c¨U |Ó4ñ-ó 5ð-ð6 ‡�×ÑØð àØØÙÐ3Ó4ÙÐ3Ó4ØØðð	ð	
ð àÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ðð	ð	
ð àÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ÙÐ3Ó4ðð	ð	
ð7(ó+ñX,óY+ðX,ò,-ò-ò*&òZ&$òR,ð ‡�×ÑØòóñ
"óð
"ò0ð ‡�×ÑØà	�G˜SÐ!Ø	�J Ð&Ø	�F˜EÐ"Ø	�L %Ð(Ø	�J Ð%Ø	�H˜eÐ$Ø	�˜#ÐØ	�˜UÐ#Ø	�˜ÐØ	�˜uÐ%Ø	�˜TÐ"Ø	�˜5Ð!ðóñ"<ó#ð"<òð ‡�×Ñ˜Ò!8Ó9ñ,ó :ð,ð ‡�×ÑØàØ�‹�T §£¨yÓ!9Ñ:ðóñ,óð,ò -ð ‡�×ÑØ�e˜d D˜\Ð*¨V°e¸T°]Ð,CÐDóñ,óð,ò	>ò)ò $ò$-ò-ð ‡�×Ñ˜¨$°¨Ó7ñ,ó 8ð,ò,ò$,ò.,ò(,ò(ò*Mò3ò.-ò,ð ‡�×Ñ˜ t¨S°3°%Ð&8Ó9ñó :ðò,ð( ‡�×ÑØ ˜s E˜l¨M¸Q¸CÀ¸;ÈÐUóñ8óð8ð ‡�×Ñ˜Ò!EÓFñ,ó Gð,ð ‡�×Ñ˜ z°;Ð&?Ó@ñ	,ó Að	,ð ‡�×Ñ˜¨°mÐ'DÓEñ,ó Fð,ð0 ‡�×Ñ˜¨°U¸B¿EºE°NÐ(CÓDñ,ó Eð,ð ‡�×ÑØò &Ú0Ú ð	
ò +Ú8Ú!ð	
ðóñ,óð,ð  ‡�×Ñ˜Ò4Ó5ñ,ó 6ð,ð ‡�×ÑØBóð ‡�×Ñ˜Ò#KÓLñ,ó Móð,ò$*ò>,ð ‡�×Ñ˜¨$°¨Ó7ñ0ó 8ð0ð" ‡�×ÑÐUÓVñ&-ó Wð&-ðR ‡�×Ñ˜ Q¨ HÓ-ñ/ó .ð/ð ‡�×ÑØòóñ,$ó-ð,$ò ò43ó8-ð ‡�×Ñ™¨¨u¨Ó6Ø‡�×ÑÙáÙ	�ˆu�a˜Ð'Ù	�ˆu‘d˜DÐ!ÙØ	�1�#�q˜-Ð(Ø	�1�#‘t˜TÐ"ðó
ò&ó
ó 7ð&ó -ó,ó.?ð ‡�×Ñ™¨¨u¨Ó6ò,ó 7ñ,r   