ó
    ­œ‘hH³  ã                   ó  • S r SSKJrJr  SSKrSSKrSSKrSSKJ	r	J
r
JrJrJrJrJrJrJr  SSKJr  SSKJr   " S S5      r " S S	5      r " S
 S5      r " S S5      rS rS r\R:                  R=                  S/ SQ5      S 5       rg)zG
test where we are determining what we are grouping, or getting groups
é    )ÚdateÚ	timedeltaN)	ÚCategoricalIndexÚ	DataFrameÚGrouperÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚ
date_rangeÚperiod_range)ÚGroupingc                   ó�   • \ rS rSrS rS rS rS rS rS r	S r
\R                  R                  S	S
 S /5      S 5       rS rSrg)ÚTestSelectioné   c                 ó*  • [        SS//SS/S9nUR                  S5      n[        R                  " [        SS9   US/     S S S 5        [        R                  " [        S	S9   USS/     S S S 5        g ! , (       d  f       N8= f! , (       d  f       g = f)
Né   é   ÚAÚB©Úcolumnsz"Columns not found: 'C'"©ÚmatchÚCz^[^A]+$)r   ÚgroupbyÚpytestÚraisesÚKeyError)ÚselfÚdfÚgs      ÚfC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/groupby/test_grouping.pyÚtest_select_bad_colsÚ"TestSelection.test_select_bad_cols    s{   € Ü˜˜A˜�x¨#¨s¨Ñ4ˆØ�J‰J�s‹OˆÜ�]Š]œ8Ð+GÓHØˆsˆeŠH÷ Iô �]Š]œ8¨9Ó5ð ˆs�CˆjŠM÷ 6Ð5÷ IÕHú÷ 6Õ5ús   ºA3Á"BÁ3
BÂ
Bc           
      ó(  • [        / SQ[        S5      [        SS5      [        SSS5      /S9nSn[        R                  " [        US	9   UR                  S
5        S S S 5        [        R                  " [        US	9   UR                  S
S/5        S S S 5        UR                  S5      nUR                  5       nUR                  R                  S:X  d   eUR                  R                  S:X  d   eg ! , (       d  f       N�= f! , (       d  f       Ny= f)N)r   r   r   r   é   r   é   r   é   )r   Údataz!Grouper for 'A' not 1-dimensionalr   r   r   r   é   )
r   Úranger   r   Ú
ValueErrorr   Úcountr   ÚnlevelsÚsize)r    r!   ÚmsgÚgroupedÚcs        r#   Ú'test_groupby_duplicated_column_errormsgÚ5TestSelection.test_groupby_duplicated_column_errormsg+   sÌ   € äÚ(´°a³¼%ÀÀ1»+ÄuÈQÐPQÐSTÃ~Ð/Vñ
ˆð 2ˆÜ�]Š]œ:¨SÓ1Ø�J‰J�sŒO÷ 2ä�]Š]œ:¨SÓ1Ø�J‰J˜˜S�zÔ"÷ 2ð —*‘*˜S“/ˆØ�M‰M‹OˆØ�y‰y× Ñ  AÓ%Ð%Ð%Ø�y‰y�~‰~ Ó"Ð"Ñ"÷ 2Õ1úç1Õ1ús   Á	C2Á<DÃ2
D Ä
Dc                 ó‚  • UR                  S5      R                  R                  5       nUR                  S5      S   R                  5       n[        R                  " X#5        SUS'   UR                  S5      R                  SS9nUR                  S5      / SQ   R                  S5      n[        R                  " X#5        g )Nr   r   g      ø?ÚmeanT©Únumeric_only)r   ÚDr7   )r   r   ÚsumÚtmÚassert_series_equalr7   ÚaggÚassert_frame_equal©r    r!   ÚresultÚexpecteds       r#   Útest_column_select_via_attrÚ)TestSelection.test_column_select_via_attr<   s—   € Ø—‘˜C“×"Ñ"×&Ñ&Ó(ˆØ—:‘:˜c“? 3Ñ'×+Ñ+Ó-ˆÜ
×Ò˜vÔ0àˆˆ6‰
Ø—‘˜C“×%Ñ%°4Ð%Ð8ˆØ—:‘:˜c“?Ò#5Ñ6×:Ñ:¸6ÓBˆÜ
×Ò˜fÕ/ó    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5      SS/   R                  5       nUR                  S5      UR                  SS	    R                  5       nUR                  S S 2/ S
Q4   R                  S5      R                  5       n[        R                  " X$5        [        R                  " X45        g )N©ÚfooÚbarrH   rI   rH   rI   rH   rH   ©ÚonerK   ÚtwoÚthreerL   rL   rK   rM   r   r)   ©r   r   r   r:   ÚEr   r   r:   r'   )r   r   r:   )r   ÚnpÚrandomÚdefault_rngÚstandard_normalr   r7   r   Úlocr<   r?   ©r    r!   rA   Úresult2rB   s        r#   Útest_getitem_list_of_columnsÚ*TestSelection.test_getitem_list_of_columnsF   s÷   € ÜâMÚQÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Ü—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Ü—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@ñó
ˆð —‘˜C“ # s Ñ,×1Ñ1Ó3ˆØ—*‘*˜S“/ "§*¡*¨Q¨q /Ñ2×7Ñ7Ó9ˆà—6‘6š!š_Ð,Ñ-×5Ñ5°cÓ:×?Ñ?ÓAˆä
×Ò˜fÔ/Ü
×Ò˜gÕ0rE   c                 óP  • [        [        S5      S-  [        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5      UR                  SS    R                  5       nUR                  S5      SS/   R                  5       nUR                  S S 2/ S	Q4   R                  S5      R                  5       n[        R                  " X$5        [        R                  " X45        [        R                  " [        S
S9   UR                  S5      S   R                  5         S S S 5        g ! , (       d  f       g = f)NÚabcdr   r)   )r   r   r'   r(   r   r   r+   r'   ©r   r   r'   ú"Cannot subset columns with a tupler   )r   r'   )r   ÚlistrP   rQ   rR   rS   r   r   r7   rT   r<   r?   r   r   r-   rU   s        r#   Ú!test_getitem_numeric_column_namesÚ/TestSelection.test_getitem_numeric_column_namesY   s3  € ää˜“< !Ñ#Ü—9‘9×(Ñ(¨Ó+×;Ñ;¸AÓ>Ü—9‘9×(Ñ(¨Ó+×;Ñ;¸AÓ>Ü—9‘9×(Ñ(¨Ó+×;Ñ;¸AÓ>ñ	ó
ˆð —‘˜A“˜rŸz™z¨!¨A˜Ñ/×4Ñ4Ó6ˆØ—*‘*˜Q“-  A Ñ'×,Ñ,Ó.ˆà—6‘6š!šY˜,Ñ'×/Ñ/°Ó2×7Ñ7Ó9ˆä
×Ò˜fÔ/Ü
×Ò˜gÔ0ô �]Š]œ:Ð-QÓRØ�J‰J�q‹M˜$Ñ×$Ñ$Ô&÷ S×RÖRús   Å+#FÆ
F%c                 ó®   • [         R                  " [        SS9   UR                  S5      S   R	                  5         S S S 5        g ! , (       d  f       g = f)Nr\   r   r   )r   r:   )r   r   r-   r   r7   ©r    r!   s     r#   Ú+test_getitem_single_tuple_of_columns_raisesÚ9TestSelection.test_getitem_single_tuple_of_columns_raiseso   s7   € ä�]Š]œ:Ð-QÓRØ�J‰J�s‹O˜HÑ%×*Ñ*Ô,÷ S×RÖRús   š#AÁ
Ac           	      ó4  • [        / 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5      S   R                  5       nUR                  S S 2SS/4   R                  S5      R                  5       nUR                  S S 2S4   nUn[        R                  " X%5        g )	NrG   rJ   r   r)   rN   r   r   r   )r   rP   rQ   rR   rS   r   r7   rT   Úilocr<   r=   )r    r!   rA   Úas_frameÚ	as_seriesrB   s         r#   Útest_getitem_single_columnÚ(TestSelection.test_getitem_single_columnt   sÚ   € ÜâMÚQÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Ü—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Ü—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@ñó
ˆð —‘˜C“ Ñ%×*Ñ*Ó,ˆà—6‘6š!˜c 3˜Z˜-Ñ(×0Ñ0°Ó5×:Ñ:Ó<ˆØ—M‘M¢! Q $Ñ'ˆ	Øˆä
×Ò˜vÕ0rE   Úfuncc                 ó"   • U R                  5       $ ©N©r;   ©Úxs    r#   Ú<lambda>ÚTestSelection.<lambda>ˆ   s
   € ˜1Ÿ5™5œ7rE   c                 ó&   • U R                  S 5      $ )Nc                 ó"   • U R                  5       $ rl   rm   )Úys    r#   rp   Ú(TestSelection.<lambda>.<locals>.<lambda>ˆ   s
   € ¸a¿e¹e¼grE   )r>   rn   s    r#   rp   rq   ˆ   s   € ¨a¯e©eÑ4EÔ.FrE   c                 óè   • [        / SQSSSS.5      nUR                  SS/5      SS/   n[        R                  " S	S
/SS/S9n[        SS/SS/S.US9nU" U5      n[        R
                  " Xe5        g )N©r   r   r   r+   r'   é   ©ÚaÚbr3   Údrz   r{   r3   )r   r+   )r   r+   ©Únamesr   r)   )rz   r3   ©Úindex)r   r   r	   Úfrom_tuplesr<   r?   )r    rj   r!   ÚgbÚidxrB   rA   s          r#   Útest_getitem_from_grouperÚ'TestSelection.test_getitem_from_grouper‡   s}   € ô
 šY¨Q°Q¸QÑ?Ó@ˆØ�Z‰Z˜˜c˜
Ó# S¨# JÑ/ˆä×$Ò$ f¨fÐ%5¸cÀ3¸ZÑHˆÜ A q 6°°A°Ñ7¸sÑCˆÙ�b“ˆä
×Ò˜fÕ/rE   c                 óÖ   ^• [        SS S 5       05      mTR                  S5      nTR                  U4S j5      nUR                  nUR                  n[        R                  " XC5        g )NÚTuplesc              3   ó˜   #   • U  H@  n[         R                  R                  S 5      R                  SSS5        H  nX4v •  M
     MB     g7f©r   r+   rx   N©rP   rQ   rR   Úintegers©Ú.0ro   rt   s      r#   Ú	<genexpr>ÚJTestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<genexpr>™   óD   é € ð â#˜ÜŸY™Y×2Ñ2°1Ó5×>Ñ>¸qÀ!ÀQ×G˜ð •FáGñ Ú#ùó   ‚AA
©r   r   c                 ó&   >• TR                   U S4   $ ©Nr   ©re   ©ro   r!   s    €r#   rp   ÚITestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<lambda>¢   ó   ø€ ¨¯©°°A°ªrE   )r   r   Úindicesr<   Úassert_dict_equal©r    r‚   Ú	gb_lambdarB   rA   r!   s        @r#   Ú)test_indices_grouped_by_tuple_with_lambdaÚ7TestSelection.test_indices_grouped_by_tuple_with_lambda•   sc   ø€ äàñ á#óðó
ˆð �Z‰Z˜Ó!ˆØ—J‘JÔ6Ó7ˆ	à—:‘:ˆØ×"Ñ"ˆä
×Ò˜VÕ.rE   © N)Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__r$   r4   rC   rW   r^   rb   rh   r   ÚmarkÚparametrizer„   r�   Ú__static_attributes__rŸ   rE   r#   r   r      sY   † ò	ò#ò"0ò1ò&'ò,-ò
1ð& ‡[�[×ÑØÑ"Ñ$FÐGóñ	0óð	0õ/rE   r   c                   ób  • \ rS rSr\R
                  R                  S\" \" S5      5      \" \	R                  " S5      5      \" \	R                  " S\S95      \" SSS9\" SSS9/5      S 5       rS	 rS
 rS rS r\R
                  R                  SSS/5      S 5       rS rS rS rS rS rS rS rS r\R
                  R                  S/ SQ/ SQ\" S5       V VVs/ s H  n[;        SSSU-   5      PM     snnn /5      S 5       rS  rS! r S" r!S# r"S$ r#S% r$S& r%S' r&S( r'\R
                  R                  S)SS/5      S* 5       r(S+ r)\R
                  R                  S)SS/5      S, 5       r*S- r+\R
                  R                  S.S/ S/Q/S/ S0Q//5      S1 5       r,S2 r-S3 r.\R
                  R                  S4S5\/" S6\	R`                  S794S8\/" S6\	R`                  \" / \	R`                  S9S:9S;94S<\/" S6\	R`                  \" / \	R`                  S9S:9S;94/5      S= 5       r1S> r2S? r3S@ r4SAr5gBs  snnn f )CÚTestGroupingé®   r€   Úabcderx   ©Údtypez
2020-01-01©Úperiodsc                 óF  • [        [        R                  " S5      R                  SS5      [	        S5      US9nUR                  [	        S5      SS9R                  S	 5        UR                  S S S
2   Ul        UR                  [	        S5      SS9R                  S 5        g )Né
   rx   r   ÚAB)r   r€   rª   F©Ú
group_keysc                 ó   • U $ rl   rŸ   rn   s    r#   rp   Ú7TestGrouping.test_grouper_index_types.<locals>.<lambda>¾   ó   € ÁArE   éÿÿÿÿc                 ó   • U $ rl   rŸ   rn   s    r#   rp   rµ   Á   r¶   rE   )r   rP   ÚarangeÚreshaper]   r   Úapplyr€   )r    r€   r!   s      r#   Útest_grouper_index_typesÚ%TestGrouping.test_grouper_index_types¯   s|   € ô ”r—y’y “}×,Ñ,¨Q°Ó2¼DÀ»JÈeÑTˆà
�
‰
”4˜“=¨Uˆ
Ð3×9Ñ9¹+ÔFà—8‘8™D˜b˜D‘>ˆŒØ
�
‰
”4˜“=¨Uˆ
Ð3×9Ñ9¹+ÕFrE   c                 óÚ  • [         R                  " 5       [        SS9-
  n[        U[         R                  " 5       5      n[        R
                  " X"/SS/S9n[        [        R                  R                  S5      R                  SSS	5      US
9nUR                  5       R                  [        SSS9[        SSS9/5      R                  5       n[        S/SS9Ul        UR                  [        SSS9[        SSS9/5      R                  5       n["        R$                  " Xe5        UR                  [        SSS9[        SSS9/5      R                  5       n["        R$                  " Xe5        g )Né   )ÚdaysrH   rI   r}   r   r   éd   éá   r   ÚW©ÚkeyÚfreqÚint64r«   ©ÚlevelrÆ   r   )r   Útodayr   r   r	   Úfrom_productr   rP   rQ   rR   r‹   Úreset_indexr   r   r;   r   r   r<   r?   )r    Úd0ÚdatesÚ
date_indexr!   rB   rA   s          r#   Útest_grouper_multilevel_freqÚ)TestGrouping.test_grouper_multilevel_freqÃ   s3  € ô �ZŠZ‹\œI¨2Ñ.Ñ.ˆÜ˜2œtŸzšz›|Ó,ˆÜ×,Ò,¨e¨^ÀEÈ5À>ÑRˆ
Ü”r—y‘y×,Ñ,¨QÓ/×8Ñ8¸¸CÀÓEÈZÑXˆð �N‰NÓß‰W”g %¨cÑ2´GÀÈCÑ4PÐQÓRß‰S‹Uð 	ô ! ! ¨GÑ4ˆÔà—‘Ü˜5 sÑ+¬W¸5ÀsÑ-KÐLó
ç
‰#‹%ð 	ô 	×Ò˜fÔ/ð —‘Ü˜1 3Ñ'¬°q¸sÑ)CÐDó
ç
‰#‹%ð 	ô 	×Ò˜fÕ/rE   c                 óÄ  • [        / SQ/ SQS.5      nUR                  S5      nUR                  5       nUR                  [        SS95      nUR                  5       n[        R
                  " XC5        Sn[        R                  " [        US9   [        SSS	9nS S S 5        UR                  W5      nUR                  5       n[        R
                  " XC5        S
n[        R                  " [        US9   UR                  S 5      nS S S 5        / SQUS'   UR                  S S 2SS/4   n[        R
                  " XC5        g ! , (       d  f       N®= f! , (       d  f       NR= f)N)r   r   r   r   r   r   ©r   r   r+   r'   rx   r(   ©r   r   r   ©rÅ   z6Grouper axis keyword is deprecated and will be removedr   r   )rÅ   Úaxisz7DataFrameGroupBy.apply operated on the grouping columnsc                 ó"   • U R                  5       $ rl   rm   rn   s    r#   rp   Ú8TestGrouping.test_grouper_creation_bug.<locals>.<lambda>ò   s
   €  q§u¡u¤wrE   r[   r   )
r   r   r;   r   r<   r?   Úassert_produces_warningÚFutureWarningr»   rT   )r    r!   r"   rB   rA   r1   Úgprs          r#   Útest_grouper_creation_bugÚ&TestGrouping.test_grouper_creation_bugß   s  € äÒ/Ò6HÑIÓJˆØ�J‰J�s‹OˆØ—5‘5“7ˆà�J‰J”w 3Ñ'Ó(ˆØ—‘“ˆÜ
×Ò˜fÔ/àFˆÜ×'Ò'¬¸SÓAÜ˜c¨Ñ*ˆC÷ Bà�J‰J�s‹OˆØ—‘“ˆÜ
×Ò˜fÔ/àGˆÜ×'Ò'¬¸SÓAØ—W‘WÑ.Ó/ˆF÷ Bâ!ˆ�‰Ø—<‘<¢ C¨ : Ñ.ˆÜ
×Ò˜fÕ/÷ BÕAú÷ BÕAús   ÂE Ã2EÅ 
EÅ
Ec                 óº  • [        / SQ/ SQ/ SQS.5      nUR                  S5      R                  5       nUR                  [        SS9/5      nUR                  5       n[        R
                  " XB5        UR                  SS/5      R                  5       nUR                  [        SS9[        SS9/5      nUR                  5       n[        R
                  " XB5        UR                  S[        SS9/5      nUR                  5       n[        R
                  " XB5        UR                  [        SS9S/5      nUR                  5       n[        R
                  " XB5        g )N)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!   rB   r"   rA   s        r#   Útest_grouper_creation_bug2Ú'TestGrouping.test_grouper_creation_bug2÷   s  € ô Ú$Ò+=ÒDVÑWó
ˆð —:‘:˜c“?×&Ñ&Ó(ˆØ�J‰Jœ CÑ(Ð)Ó*ˆØ—‘“ˆÜ
×Ò˜fÔ/ð —:‘:˜s C˜jÓ)×-Ñ-Ó/ˆð �J‰Jœ CÑ(¬'°cÑ*:Ð;Ó<ˆØ—‘“ˆÜ
×Ò˜fÔ/ð �J‰J˜œW¨Ñ-Ð.Ó/ˆØ—‘“ˆÜ
×Ò˜fÔ/ð �J‰Jœ CÑ(¨#Ð.Ó/ˆØ—‘“ˆÜ
×Ò˜fÕ/rE   c                 óL  • [        SSUS9n[        R                  " [        S5      [	        S5      U// SQS9n[        [        R                  " SSS	9US
9nUR                  [        SSS95      R                  5       n[        R                  " [        S5      /SSS9R                  U5      n[        S/US
9n[        R                   " XW5        UR                  [        SS95      R                  5       nUR                  SS9R                  5       n[        R                   " XW5        g )NÚ20130101r   )r®   ÚunitÚab)rK   rL   rM   r}   r)   rÇ   r«   r   rM   ÚMErÈ   z
2013-01-31)rÆ   Únameé   rK   ©rÉ   )r   r	   rË   r]   r,   r
   rP   r¹   r   r   r;   ÚpdÚDatetimeIndexr   Úas_unitr<   r=   )r    rä   ÚdtiÚmiÚserrA   Úexp_dtirB   s           r#   Útest_grouper_creation_bug3Ú'TestGrouping.test_grouper_creation_bug3  s  € ä˜¨Q°TÑ:ˆÜ×$Ò$Ü�$‹Zœ˜q› 3Ð'Ú)ñ
ˆô Ü�IŠI�a˜wÑ'Øñ
ˆð —‘œW¨7¸Ñ>Ó?×CÑCÓEˆÜ×"Ò"Ü�|Ó$Ð%¨D°wñ
ç
‰'�$‹-ð 	ô ØˆDØñ
ˆô 	×Ò˜vÔ0ð —‘œW¨5Ñ1Ó2×6Ñ6Ó8ˆØ—;‘; U�;Ð+×/Ñ/Ó1ˆÜ
×Ò˜vÕ0rE   rj   FTc                 óR  ^• [        / SQ/ SQS.5      n[        [        [        S5      SS/S-  5      5      mU(       a  UR	                  U4S jS	S
9nOUR	                  TS	S
9n[        [        U5      5      u  pEUS:X  d   eUR                  U5      n[        R                  " Xe5        g )N©r   r   r   r   )r   r'   r+   r   )ÚXÚYr'   )r   rx   )r:   r(   r   c                 ó   >• TU    $ rl   rŸ   )rƒ   Úmappings    €r#   rp   Ú<TestGrouping.test_grouper_returning_tuples.<locals>.<lambda>7  s	   ø€ ¨7°3ª<rE   F)ÚbyÚsort)
r   ÚdictÚzipr,   r   ÚnextÚiterÚ	get_groupr<   r?   )r    rj   r!   r‚   rç   rB   rA   rø   s          @r#   Útest_grouper_returning_tuplesÚ*TestGrouping.test_grouper_returning_tuples0  s•   ø€ ô Ò1ºÑEÓFˆÜ”sœ5 ›8 h°Ð%9¸AÑ%=Ó>Ó?ˆæØ—‘Ô7¸e�ÐD‰Bà—‘˜w¨U�Ð3ˆBäœd 2›h›‰ˆØ�xÓÐÐØ—‘˜dÓ#ˆä
×Ò˜fÕ/rE   c                 ó  • [         R                  " / SQ5      nSS/Ul        [        [        R
                  " S5      / SQS.US9nUR                  S[        SS	9/5      R                  S
S9nUR                  5       R                  SS/5      R                  S
S9n[        R                  " X45        UR                  [        SS	9S/5      R                  S
S9nUR                  5       R                  SS/5      R                  S
S9n[        R                  " X45        UR                  S5      nUR                  S[        SS	9/5      R                  S
S9nUR                  5       R                  SS/5      R                  S
S9n[        R                  " X45        UR                  [        SS	9S/5      R                  S
S9nUR                  5       R                  SS/5      R                  S
S9n[        R                  " X45        g )N)©rz   r   )rz   r   )rz   r+   ©r{   r   ©r{   r   )r{   r+   ÚouterÚinnerr(   )rK   rK   rL   rL   rK   rK   rÔ   r   r   ré   Tr8   )r	   r�   r~   r   rP   r¹   r   r   r7   rÌ   r<   r?   )r    rƒ   Údf_multirA   rB   Ú	df_singles         r#   Útest_grouper_column_and_indexÚ*TestGrouping.test_grouper_column_and_indexA  s  € ô
 ×$Ò$ÚHó
ˆð ˜gÐ&ˆŒ	ÜÜ—)’)˜A“,Ò%OÑPØñ
ˆð ×!Ñ! 3¬°gÑ(>Ð"?Ó@×EÑEÐSWÐEÐXˆà× Ñ Ó"×*Ñ*¨C°¨>Ó:×?Ñ?ÈTÐ?ÐRð 	ô 	×Ò˜fÔ/ð ×!Ñ!¤7°Ñ#9¸3Ð"?Ó@×EÑEÐSWÐEÐXˆà× Ñ Ó"×*Ñ*¨G°S¨>Ó:×?Ñ?ÈTÐ?ÐRð 	ô 	×Ò˜fÔ/ð ×(Ñ(¨Ó1ˆ	Ø×"Ñ" C¬°wÑ)?Ð#@ÓA×FÑFØð Gð 
ˆð ×!Ñ!Ó#×+Ñ+¨S°'¨NÓ;×@Ñ@ÈdÐ@ÐSð 	ô 	×Ò˜fÔ/ð ×"Ñ"¤G°'Ñ$:¸CÐ#@ÓA×FÑFØð Gð 
ˆð ×!Ñ!Ó#×+Ñ+¨W°c¨NÓ;×@Ñ@ÈdÐ@ÐSð 	ô 	×Ò˜fÕ/rE   c                 ó²  • SS/n[         R                  " / SQUS9n[        [        R                  " S5      R                  SS5      US9nUR                  US	9R                  5       nUR                  5       R                  U5      R                  5       nUR                  R                  [        R                  5      Ul	        [        R                  " XE5        g )
Nro   rt   )©r   r   ©r   r   )r+   r'   )rx   r(   r}   é   r·   r+   r   ré   )r	   r�   r   rP   r¹   rº   r   r7   rÌ   r   ÚastyperÇ   r<   r?   )r    Ú	idx_namesrƒ   r!   Ú	by_levelsÚ
by_columnss         r#   Útest_groupby_levels_and_columnsÚ,TestGrouping.test_groupby_levels_and_columnso  s¥   € à˜#�Jˆ	Ü×$Ò$Ò%EÈYÑWˆÜ”r—y’y “}×,Ñ,¨R°Ó3¸3Ñ?ˆà—J‘J Y�JÐ/×4Ñ4Ó6ˆ	à—^‘^Ó%×-Ñ-¨iÓ8×=Ñ=Ó?ˆ
ð (×/Ñ/×6Ñ6´r·x±xÓ@ˆ
ÔÜ
×Ò˜iÕ4rE   c                 ó  • / SQnSS/n[         R                  " / SQ/ SQ/ SQ/ SQ/ SQ/[        5      n[        X#SS9n[	        XES9nSn[
        R                  " [        US	9   UR                  S
SUS9R                  5       nS S S 5        [         R                  " SS/SS/SS/SS/SS//[        5      n	[        X3SS9n
[	        XšS9n[
        R                  " WU5        [	        UR                  US9nSn[
        R                  " [        US	9   UR                  SSUS9R                  5       nS S S 5        [	        U	R                  U
S9n[
        R                  " X‹5        g ! , (       d  f       Nä= f! , (       d  f       NJ= f)Nrô   r   r   )r   r   r   r   T)Ú
categoriesÚordered)r*   r   ú+DataFrame.groupby with axis=1 is deprecatedr   r   r   )rÖ   rÉ   Úobservedr'   r   r   ú5The 'axis' keyword in DataFrame.groupby is deprecated)r*   r€   )rP   ÚarrayÚintr   r   r<   rÙ   rÚ   r   r;   r?   ÚT)r    r  r   r  r*   Úcat_columnsr!   Údepr_msgrA   Úexpected_dataÚexpected_columnsrB   r1   s                r#   Ú*test_groupby_categorical_index_and_columnsÚ7TestGrouping.test_groupby_categorical_index_and_columns}  sW  € â&ˆØ˜3�Zˆ
Ü�xŠxÚš<ª²|Â\ÐRÔTWó
ˆô ' wÈtÑTˆÜ˜DÑ6ˆØ@ˆÜ×'Ò'¬¸XÓFØ—Z‘Z Q¨a¸(�ZÐC×GÑGÓIˆF÷ GäŸš 1 a &¨1¨a¨&°1°a°&¸1¸a¸&À1ÀaÀ&Ð!IÌ3ÓOˆÜ+Ø°tñ
Ðô  -ÑJˆÜ
×Ò˜f hÔ/ô �t—v‘v [Ñ1ˆØEˆÜ×'Ò'¬¸SÓAØ—Z‘Z Q¨a¸(�ZÐC×GÑGÓIˆF÷ Bä -§/¡/Ð9IÑJˆÜ
×Ò˜fÕ/÷ GÕFú÷ BÕAús   Á! EÄ E0Å
E-Å0
E>c                 óf  • [        SS0[        R                  " [        S5      [	        SSS9/SS/S	9S
9nUR                  [        SS9[        SSS9/5      R                  5       n[        S/ SQ0[        R                  " [        S5      [	        SSSS9/SS/S	9S
9n[        R                  " X#5        g )Nr   r   rå   rã   éP   r­   rK   rL   r}   r   ré   ræ   rÈ   )r   rè   é   r   rè   r(  r+   )rÆ   r®   )
r   r	   rË   r]   r   r   r   r;   r<   r?   r@   s       r#   Ú#test_grouper_getting_correct_binnerÚ0TestGrouping.test_grouper_getting_correct_binner˜  sº   € ô Ø�!ˆHÜ×)Ò)Ü�d“œZ¨
¸BÑ?Ð@ÈÐPUÈññ
ˆð —‘Ü˜5Ñ!¤7°¸TÑ#BÐCó
ç
‰#‹%ð 	ô ØÒ*Ð+Ü×)Ò)Ü�d“œZ¨
¸ÀqÑIÐJØ˜e�nññ
ˆô 	×Ò˜fÕ/rE   c                 óÔ   • UR                  S5      nSn[        R                  " [        US9   UR                  nS S S 5        [        W5      nSS/nXV:X  d   eg ! , (       d  f       N%= f)Nr   ú&DataFrameGroupBy.grouper is deprecatedr   rI   rH   )r   r<   rÙ   rÚ   ÚgrouperÚsorted)r    r!   r‚   r1   r-  rA   rB   s          r#   Útest_grouper_iterÚTestGrouping.test_grouper_iter®  s[   € Ø�Z‰Z˜‹_ˆØ6ˆÜ×'Ò'¬¸SÓAØ—j‘jˆG÷ Bä˜“ˆØ˜5�>ˆØÓ!Ð!Ñ!÷	 BÕAús   ­AÁ
A'c                 óŒ   • [         R                  " [        SS9   UR                  / 5        S S S 5        g ! , (       d  f       g = f)NzNo group keys passed!r   )r   r   r-   r   ra   s     r#   Útest_empty_groupsÚTestGrouping.test_empty_groups·  s)   € ä�]Š]œ:Ð-DÓEØ�J‰J�rŒN÷ F×EÖEús	   š5µ
Ac                 ó.  • UR                  S5      nSn[        R                  " [        US9   UR                  nS S S 5        UR                  W5      R                  SS9nUR                  SS9n[        R                  " XV5        g ! , (       d  f       NR= f)Nr   r,  r   Tr8   )r   r<   rÙ   rÚ   r-  r7   r?   )r    r!   r2   r1   r-  rA   rB   s          r#   Útest_groupby_grouperÚ!TestGrouping.test_groupby_grouper¼  sw   € Ø—*‘*˜S“/ˆØ6ˆÜ×'Ò'¬¸SÓAØ—o‘oˆG÷ Bà—‘˜GÓ$×)Ñ)°tÐ)Ð<ˆØ—<‘<¨T�<Ð2ˆÜ
×Ò˜fÕ/÷	 BÕAús   ­BÂ
Bc                 óÐ  • [        SS05      nUR                  SS05      R                  S5      nUR                  S/5      R                  S5      n[        R                  " X#5        [        / SQ[        S5      S9nSSS	S	S
.nUR                  U5      R                  5       nUR                  U5      R                  S5      n[        R                  " / SQ[        R                  S9nUR                  U5      R                  5       nUR                  U5      R                  5       n[        R                  " X#5        [        R                  " X%5        [        R                  " X'5        g )NÚT1rx   ÚT2r;   )ç      ð?ç       @g      @g      @rZ   r   r   r   ry   r7   )r   r   r   r   r«   )
r
   r   r>   r<   r=   r]   r7   rP   r  rÇ   )r    ÚsrA   rB   rø   rV   Úexp_keyÚ	expected2s           r#   Útest_groupby_dict_mappingÚ&TestGrouping.test_groupby_dict_mappingÅ  s  € ä�D˜!�9ÓˆØ—‘˜D $˜<Ó(×,Ñ,¨UÓ3ˆØ—9‘9˜d˜VÓ$×(Ñ(¨Ó/ˆÜ
×Ò˜vÔ0äÒ'¬t°F«|Ñ<ˆØ ¨°Ñ2ˆà—‘˜7Ó#×(Ñ(Ó*ˆØ—)‘)˜GÓ$×(Ñ(¨Ó0ˆÜ—(’(š<¬r¯x©xÑ8ˆØ—9‘9˜WÓ%×*Ñ*Ó,ˆØ—I‘I˜gÓ&×+Ñ+Ó-ˆ	Ü
×Ò˜vÔ0Ü
×Ò˜vÔ/Ü
×Ò˜vÕ1rE   ©r   r   r   r+   ry   r'   iå  é   rè   c                 óÐ   • U" / SQUS9n[        / SQUSS9nUR                  U5      R                  5       nU" SS/5      nSUR                  l        [
        R                  " XV5        g )N©r   r   r+   r'   r   )r   r   r   r   )rz   rz   )r€   rç   r'   r+   )r
   r   Úlastr€   rç   r<   Úassert_equal)r    Úframe_or_seriesr€   ÚobjÚgroupsrA   rB   s          r#   Ú$test_groupby_series_named_with_tupleÚ1TestGrouping.test_groupby_series_named_with_tupleØ  s[   € ñ šl°%Ñ8ˆÜš¨E¸
ÑCˆØ—‘˜VÓ$×)Ñ)Ó+ˆÙ" A q 6Ó*ˆØ(ˆ�‰ÔÜ
�Š˜Õ)rE   c                 óô  • [        SSSS9n[        [        R                  R	                  S5      R                  S5      US9nSn[        R                  " [        US9   UR                  S	 5        S S S 5        UR                  S
 5      R                  5       nUR                  UR                  5      R                  5       nS UR                  l        [        R                  " XE5        g ! , (       d  f       N= f)Nz01-Jan-2013r  ÚMS©r®   rÆ   r   r   z''Timestamp' object is not subscriptabler   c                 ó   • U SS $ )Nr   r(   rŸ   rÕ   s    r#   rp   ÚDTestGrouping.test_groupby_grouper_f_sanity_checked.<locals>.<lambda>ñ  s
   €  3 q¨¡8rE   c                 ó   • U $ rl   rŸ   rn   s    r#   rp   rP  ó  s   € ¡arE   )r   r
   rP   rQ   rR   rS   r   r   Ú	TypeErrorr   r;   r€   rÆ   r<   r=   )r    rÎ   Útsr1   rA   rB   s         r#   Ú%test_groupby_grouper_f_sanity_checkedÚ2TestGrouping.test_groupby_grouper_f_sanity_checkedé  s´   € Ü˜=°"¸4Ñ@ˆÜ”B—I‘I×)Ñ)¨!Ó,×<Ñ<¸RÓ@ÈÑNˆð 8ˆÜ�]Š]œ9¨CÓ0Ø�J‰JÑ+Ô,÷ 1ð —‘™KÓ(×,Ñ,Ó.ˆØ—:‘:˜bŸh™hÓ'×+Ñ+Ó-ˆØ"ˆ�‰ÔÜ
×Ò˜vÕ0÷ 1Õ0ús   ÁC)Ã)
C7c           	      ó‚  • [        SS/S-  [        SSSS9S.5      n[        SS	S
9nUR                  US/5      n[	        S5      S4SS/[	        S5      S4S/[	        S5      S4S/[	        S5      S4SS/0n[
        R                  " UR                  U5        [        UR                  R                  5       5      S:X  d   eg )Nrz   r{   r+   z
2000-01-01z
2000-01-03Ú9h©rÆ   )Úidr{   r:   rÄ   rY  r   r   r   z
2000-01-02r'   rx   )
r   r   r   r   r   r<   rš   rI  ÚlenÚkeys)r    r!   r-  r‚   rB   s        r#   Útest_groupby_with_datetime_keyÚ+TestGrouping.test_groupby_with_datetime_keyø  sÏ   € äà˜C�j 1‘nÜ ¨lÀÑFñó
ˆô ˜c¨Ñ,ˆØ�Z‰Z˜ $˜Ó(ˆô �|Ó$ cÐ*¨Q°¨FÜ�|Ó$ cÐ*¨Q¨CÜ�|Ó$ cÐ*¨Q¨CÜ�|Ó$ cÐ*¨Q°¨Fð	
ˆô 	×Ò˜RŸY™Y¨Ô1ô �2—9‘9—>‘>Ó#Ó$¨Ó)Ð)Ñ)rE   c                 ó¤   • Sn[         R                  " [        US9   [        UR                  USS/   5        S S S 5        g ! , (       d  f       g = f)NzEGrouper for '<class 'pandas.core.frame.DataFrame'>' not 1-dimensionalr   r   )r   r   r-   r   r€   ©r    r!   r1   s      r#   Ú%test_grouping_error_on_multidim_inputÚ2TestGrouping.test_grouping_error_on_multidim_input  s7   € ØUˆÜ�]Š]œ:¨SÓ1Ü�R—X‘X˜r 3¨ *™~Ô.÷ 2×1Ö1ús   œAÁ
Ac                 ó@  • [        / SQ/ SQ/ SQ/5      n[        R                  " / SQ5      Ul        Sn[        R
                  " [        US9   UR                  SSS/S	9nS S S 5        WR                  5       n[        R                  " XA5        g ! , (       d  f       N5= f)
N©r   r   r+   )r'   rx   r(   )rB  r)   é	   )r’   r  )r   r   r  r   r   r   ©rÖ   rÉ   )
r   r	   r�   r   r<   rÙ   rÚ   r   Úfirstr?   )r    r!   r!  r‚   rA   s        r#   Útest_multiindex_passthruÚ%TestGrouping.test_multiindex_passthru  s|   € ô š	¢9ªiÐ8Ó9ˆÜ×+Ò+Ò,DÓEˆŒ
à@ˆÜ×'Ò'¬¸XÓFØ—‘ ¨1¨a¨&�Ð1ˆB÷ Gà—‘“ˆÜ
×Ò˜fÕ)÷ GÕFús   ÁBÂ
Bc                 óv  • UR                  SS9R                  5       nUR                  SS9R                  5       n[        R                  " X#5        UR                  SS9R                  5       nUR                  SS9R                  5       n[        R                  " X#5        UR                  SS/S9R                  5       nUR	                  5       n[        R                  " X#5        UR                  SS/S9R                  5       nUR                  SS/S9R                  5       n[        R                  " X#5        g )Nr·   ré   Úsecondéþÿÿÿrf  )r   r;   r<   r?   Ú
sort_index)r    Ú multiindex_dataframe_random_datarA   rB   s       r#   Útest_multiindex_negative_levelÚ+TestGrouping.test_multiindex_negative_level   s!  € à1×9Ñ9ÀÐ9ÐC×GÑGÓIˆØ3×;Ñ;À(Ð;ÐK×OÑOÓQˆÜ
×Ò˜fÔ/à1×9Ñ9ÀÐ9ÐC×GÑGÓIˆØ3×;Ñ;À'Ð;ÐJ×NÑNÓPˆÜ
×Ò˜fÔ/à1×9Ñ9ÀÀRÀÐ9ÐI×MÑMÓOˆØ3×>Ñ>Ó@ˆÜ
×Ò˜fÔ/à1×9Ñ9ÀÀWÀÐ9ÐN×RÑRÓTˆØ3×;Ñ;Ø˜WÐ%ð <ð 
ç
‰#‹%ð 	ô 	×Ò˜fÕ/rE   c                 ó.  • [         R                  " [        UR                  5      5      Ul        Sn[        R
                  " [        US9   UR                  SSS9S   R                  S[         R                  05        S S S 5        g ! , (       d  f       g = f)Nz7Passing a dictionary to SeriesGroupBy.agg is deprecatedr   r   F©Úas_indexr   ÚQ)
rP   r¹   rZ  r   r<   rÙ   rÚ   r   r>   r7   r_  s      r#   Ú&test_multifunc_select_col_integer_colsÚ3TestGrouping.test_multifunc_select_col_integer_cols4  sg   € Ü—Y’Yœs 2§:¡:›Ó/ˆŒ
ð HˆÜ×'Ò'¬¸SÓAØ�J‰J�q 5ˆJÐ)¨!Ñ,×0Ñ0°#´r·w±w°Ô@÷ B×AÖAús   Á
3BÂ
Bc                 óN  • SS/SS//n[         R                  " U5      n[        SS//US9nUR                  S5      R                  nUS   S/:X  d   eUR                  S	/5      R                  nUS   S/:X  d   e[        SS/S
S//US9nUR                  S5      R                  nUR                  S	/5      R                  nXe:X  d   e[        SS/S
S//US9nUR                  S5      R                  nUR                  S	/5      R                  n[
        R                  " Xe5        g )Nr.   Úvaluesú	to filterÚ r   r   r   r   )rx  ry  r   r   )r	   r�   r   r   rI  r<   rš   )r    ÚlstÚmidxr!   r2   rB   rA   s          r#   Ú#test_multiindex_columns_empty_levelÚ0TestGrouping.test_multiindex_columns_empty_level<  s0  € Ø˜Ð" [°"Ð$5Ð6ˆÜ×%Ò% cÓ*ˆä˜˜C˜�z¨4Ñ0ˆà—*‘*˜[Ó)×0Ñ0ˆØ�s‰| ˜sÓ"Ð"Ð"à—*‘*Ð/Ð0Ó1×8Ñ8ˆØ�s‰| ˜sÓ"Ð"Ð"ä˜˜C˜ 1 c (Ð+°TÑ:ˆà—:‘:˜kÓ*×1Ñ1ˆØ—‘Ð.Ð/Ó0×7Ñ7ˆØÓ!Ð!Ð!ä˜˜C˜ 1 c (Ð+°TÑ:ˆà—:‘:˜kÓ*×1Ñ1ˆØ—‘Ð.Ð/Ó0×7Ñ7ˆÜ
×Ò˜VÕ.rE   c                 ó´  • [        / SQ/ SQ/ SQ/[        R                  " / SQ/ SQ/5      S9nUR                  S/5      R                  nUR                  S5      R                  n[
        R                  " X#5        [        UR                  [        R                  " / SQ/ SQ/5      S9nUR                  S	/5      R                  nUR                  S5      R                  n[
        R                  " X#5        [        UR                  / S
QS9nUR                  S	/5      R                  nUR                  S5      R                  n[
        R                  " X#5        g )NrD  ©r+   r'   rx   r(   ©r   r'   r   r+   ©rz   r{   r{   r3   ©r   r   r   r   r   r  )r|   r|   Úerƒ  ©r{   r|   ))rz   r|   r„  )r{   rƒ  r3   )r   r	   Úfrom_arraysr   rI  r<   rš   rw  )r    r!   rB   rA   Údf2Údf3s         r#   Útest_groupby_multiindex_tupleÚ*TestGrouping.test_groupby_multiindex_tupleT  s  € äÚš<ªÐ6Ü×*Ò*Ò,@Â,Ð+OÓPñ
ˆð —:‘:˜x˜jÓ)×0Ñ0ˆØ—‘˜HÓ%×,Ñ,ˆÜ
×Ò˜XÔ.äØ�I‰IÜ×*Ò*Ú%Ò';Ð<óñ
ˆð —;‘; 
˜|Ó,×3Ñ3ˆØ—‘˜HÓ%×,Ñ,ˆÜ
×Ò˜XÔ.ä˜Ÿ	™	Ò+TÑUˆØ—;‘; 
˜|Ó,×3Ñ3ˆØ—‘˜HÓ%×,Ñ,ˆÜ
×Ò˜XÕ.rE   c                 ó¶  • [        / SQ/ SQ/ SQ/[        R                  " / SQ/ SQ/5      S9nUR                  S/5      SS	/   R	                  5       nUR                  S/5      S
   R	                  5       n[
        R                  " X#5        UR                  S/5      SS	/   R                  5       nUR                  S/5      S
   R                  5       n[
        R                  " XE5        UR                  S/5      SS	/   R                  5       nUR                  S/5      S
   R                  5       n[
        R                  " Xg5        UR                  S/5      SS	/   R                  5       nUR                  S/5      S
   R                  5       n	[
        R                  " X‰5        UR                  S/5      SS	/   R                  5       n
UR                  S/5      S
   R                  5       n[
        R                  " X«5        UR                  S/5      SS	/   R                  nUR                  S/5      S
   R                  n[
        R                  " XÍ5        g )NrD  r  r€  r�  r‚  r   r  r  r  r{   )r   r	   r…  r   r7   r<   r?   r;   r.   ÚminÚmaxrI  rš   )r    r!   Úexpected_meanÚresult_meanÚexpected_sumÚ
result_sumÚexpected_countÚresult_countÚexpected_minÚ
result_minÚexpected_maxÚ
result_maxÚexpected_groupsÚresult_groupss                 r#   Ú4test_groupby_multiindex_partial_indexing_equivalenceÚATestGrouping.test_groupby_multiindex_partial_indexing_equivalencem  s   € äÚš<ªÐ6Ü×*Ò*Ò,@Â,Ð+OÓPñ
ˆð
 Ÿ
™
 H :Ó.°¸(Ð/CÑD×IÑIÓKˆØ—j‘j ( Ó,¨SÑ1×6Ñ6Ó8ˆÜ
×Ò˜mÔ9à—z‘z 8 *Ó-¨x¸Ð.BÑC×GÑGÓIˆØ—Z‘Z  
Ó+¨CÑ0×4Ñ4Ó6ˆ
Ü
×Ò˜lÔ7àŸ™ X JÓ/°¸8Ð0DÑE×KÑKÓMˆØ—z‘z 8 *Ó-¨cÑ2×8Ñ8Ó:ˆÜ
×Ò˜nÔ;à—z‘z 8 *Ó-¨x¸Ð.BÑC×GÑGÓIˆØ—Z‘Z  
Ó+¨CÑ0×4Ñ4Ó6ˆ
Ü
×Ò˜lÔ7à—z‘z 8 *Ó-¨x¸Ð.BÑC×GÑGÓIˆØ—Z‘Z  
Ó+¨CÑ0×4Ñ4Ó6ˆ
Ü
×Ò˜lÔ7àŸ*™* h ZÓ0°(¸HÐ1EÑF×MÑMˆØŸ
™
 H :Ó.¨sÑ3×:Ñ:ˆÜ
×Ò˜_Õ<rE   rû   c                 ó
  • UnUR                  5       nUR                  SUS9R                  5       nUR                  SUS9R                  5       nUR                  US   R                  US9R                  5       nUR                  US   R                  US9R                  5       n	SUR                  l        SU	R                  l        UR                  R
                  S:X  d   eUR                  R
                  S:X  d   e[        R                  " Xh5        [        R                  " Xy5        UR                  R
                  UR                  R                  S   :X  d   eUR                  R
                  UR                  R                  S   :X  d   eUR                  SUS9R                  5       nUR                  SUS9R                  5       n[        R                  " Xh5        [        R                  " Xy5        Sn
[        R                  " [        U
S9   UR                  R                  SSUS	9R                  5       nUR                  R                  SSUS	9R                  5       nS S S 5        [        R                  " XhR                  5        [        R                  " XyR                  5        S
n
[        R                  " [        U
S9   UR                  SS9  S S S 5        g ! , (       d  f       N‚= f! , (       d  f       g = f)Nr   ©rÉ   rû   r   rf  )rû   rj  r  r   )rÉ   rÖ   rû   z2level > 0 or level < -1 only valid with MultiIndexré   )rÌ   r   r;   rw  r€   rç   r<   r?   r~   rÙ   rÚ   r  r   r   r-   )r    rû   rm  r!   ÚframeÚ	deleveledÚresult0Úresult1Ú	expected0Ú	expected1r1   s              r#   Útest_groupby_levelÚTestGrouping.test_groupby_levelŒ  sc  € ð 1ˆØ×%Ñ%Ó'ˆ	à—-‘- a¨d�-Ð3×7Ñ7Ó9ˆØ—-‘- a¨d�-Ð3×7Ñ7Ó9ˆà—M‘M )¨GÑ"4×";Ñ";À$�MÐG×KÑKÓMˆ	Ø—M‘M )¨HÑ"5×"<Ñ"<À4�MÐH×LÑLÓNˆ	à&ˆ	�‰ÔØ'ˆ	�‰Ôà�}‰}×!Ñ! WÓ,Ð,Ð,Ø�}‰}×!Ñ! XÓ-Ð-Ð-ä
×Ò˜gÔ1Ü
×Ò˜gÔ1Ø�}‰}×!Ñ! U§[¡[×%6Ñ%6°qÑ%9Ó9Ð9Ð9Ø�}‰}×!Ñ! U§[¡[×%6Ñ%6°qÑ%9Ó9Ð9Ð9ð —-‘- g°D�-Ð9×=Ñ=Ó?ˆØ—-‘- h°T�-Ð:×>Ñ>Ó@ˆÜ
×Ò˜gÔ1Ü
×Ò˜gÔ1ð <ˆÜ×'Ò'¬¸SÓAØ—g‘g—o‘o¨A°A¸D�oÐA×EÑEÓGˆGØ—g‘g—o‘o¨A°A¸D�oÐA×EÑEÓGˆG÷ Bô 	×Ò˜g§{¡{Ô3Ü
×Ò˜g§{¡{Ô3ð CˆÜ�]Š]œ:¨SÓ1Ø�J‰J˜QˆJÑ÷ 2Ð1÷ BÕAú÷ 2Õ1ús   ÈAK#Ë
K4Ë#
K1Ë4
Lc                 ó.  • [        S/S-  S/S-  -   [        S5      S.5      R                  S5      nUS;   a  UR                  nSnOS	n[        R
                  " [        US
9   UR                  SUS9  S S S 5        SUR                  U5       3n[        R                  " [        US
9   [        R
                  " [        US
9   UR                  SUS9  S S S 5        S S S 5        g ! , (       d  f       Nw= f! , (       d  f       N(= f! , (       d  f       g = f)Nr   r+   r   r(   )ÚexpÚvar1r¦  )r   r   r  r  r   )rÉ   rÖ   z&level name foo is not the name of the rH   )r   r,   Ú	set_indexr  r<   rÙ   rÚ   r   Ú_get_axis_namer   r   r-   )r    rÖ   r!   r!  r1   s        r#   Útest_groupby_level_index_namesÚ+TestGrouping.test_groupby_level_index_names¶  sè   € ä ˜u q™y¨C¨5°1©9Ñ4¼eÀA»hÑGÓH×RÑRØó
ˆð �>Ó!Ø—‘ˆBØD‰HàNˆHÜ×'Ò'¬¸XÓFØ�J‰J˜U¨ˆJÑ.÷ Gà6°r×7HÑ7HÈÓ7NÐ6OÐPˆÜ�]Š]œ:¨SÓ1Ü×+Ò+¬MÀÓJØ—
‘
 ¨T�
Ñ2÷ K÷ 2Ð1÷ GÕFú÷ KÕJú÷ 2Õ1ús0   Á"C$Â(DÃC5ÃDÃ$
C2Ã5
D	Ã?DÄ
Dc                 óÜ  • [        SS// SQ// SQ/ SQ/S9n[        [        R                  " S5      US9nUR	                  SUS	9R                  5       n[        S
S/SS/S9n[        R                  " XE5        [        SS// SQ// SQ/ SQ/S9n[        [        R                  " S5      US9nUR	                  SUS	9R                  5       n[        S
S/SS/S9n[        R                  " XE5        g )Nr   r   rA  )r   r   r   r   r   r   r   r   )r   r   r   r+   r   r   r   r+   )ÚlevelsÚcodesg       @r   rœ  g      @g      6@)r   r   r   r   r·   r   r   r   g      2@g        r:  )r	   r
   rP   r¹   r   r;   r<   r=   )r    rû   r€   r<  rA   rB   s         r#   Útest_groupby_level_with_nasÚ(TestGrouping.test_groupby_level_with_nasÇ  sè   € ô Ø˜�FšLÐ)Ú+Ò-EÐFñ
ˆô ”2—9’9˜S“>¨Ñ/ˆØ—‘ ¨�Ð.×2Ñ2Ó4ˆÜ˜3 ˜+¨a°¨VÑ4ˆÜ
×Ò˜vÔ0äØ˜�FšLÐ)Ú,Ò.FÐGñ
ˆô ”2—9’9˜S“>¨Ñ/ˆØ—‘ ¨�Ð.×2Ñ2Ó4ˆÜ˜3 ˜+¨c°3¨ZÑ8ˆÜ
×Ò˜vÕ0rE   c                 ó  • UnSn[         R                  " [        US9   UR                  5         S S S 5        Sn[         R                  " [        US9   UR                  S S S9  S S S 5        g ! , (       d  f       NC= f! , (       d  f       g = f)Nz*You have to supply one of 'by' and 'level'r   )rú   rÉ   )r   r   rR  r   )r    rm  r�  r1   s       r#   Útest_groupby_argsÚTestGrouping.test_groupby_argsà  sg   € à0ˆà:ˆÜ�]Š]œ9¨CÓ0Ø�M‰MŒO÷ 1ð ;ˆÜ�]Š]œ9¨CÓ0Ø�M‰M˜T¨ˆMÑ.÷ 1Ð0÷	 1Õ0ú÷ 1Õ0ús   žA,ÁA=Á,
A:Á=
Bzsort,labels©
r   r   r   r   r   r   r   r+   r+   r+   )
r   r   r   r   r   r   r   r+   r+   r+   c                 óÊ   • UR                  SUS9n[        R                  " U[        R                  5      n[        R
                  " UR                  R                  S   U5        g )Nr   rœ  )r   rP   r  Úintpr<   Úassert_almost_equalÚ_grouperr®  )r    rû   Úlabelsrm  r2   Ú
exp_labelss         r#   Útest_level_preserve_orderÚ&TestGrouping.test_level_preserve_orderì  sN   € ð 3×:Ñ:ÀÈÐ:ÐNˆÜ—X’X˜f¤b§g¡gÓ.ˆ
Ü
×Ò˜w×/Ñ/×5Ñ5°aÑ8¸*ÕErE   c                 óþ   • UR                  UR                  R                  S5      5      n[        R                  " / SQ[        R
                  S9n[        R                  " UR                  R                  S   U5        g )Nr   r´  r«   )
r   r€   Úget_level_valuesrP   r  r¶  r<   r·  r¸  r®  )r    rm  r2   rº  s       r#   Útest_grouping_labelsÚ!TestGrouping.test_grouping_labelsù  s^   € Ø2×:Ñ:Ø,×2Ñ2×CÑCÀAÓFó
ˆô —X’XÒ<ÄBÇGÁGÑLˆ
Ü
×Ò˜w×/Ñ/×5Ñ5°aÑ8¸*ÕErE   c           	      ó²  • [        S[        SSSS905      n[        R                  UR                  S'   [        SSS9nUR                  U/5      n[        S	5      [        [        [        S
5      5      5      0n[        R                  " UR                  U5        UR                  U5      n[        S	5      S0n[        R                  " UR                  U5        g )Nr   z1/1/2011im  r:   rN  r·   ÚYSrÄ   z
2011-01-01il  )r   r   rê   ÚNaTre   r   r   r   r   r]   r,   r<   rš   rI  )r    r!   r-  rA   rB   s        r#   Útest_list_grouper_with_natÚ'TestGrouping.test_list_grouper_with_nat   s­   € ä˜¤
¨:¸sÈÑ MÐNÓOˆÜ—f‘fˆ�‰�‰Ü˜f¨4Ñ0ˆð —‘˜W˜IÓ&ˆÜ˜lÓ+¬U´4¼¸c»
Ó3CÓ-DÐEˆÜ
×Ò˜VŸ]™]¨HÔ5ð —‘˜GÓ$ˆÜ˜lÓ+¨SÐ1ˆÜ
×Ò˜VŸ]™]¨HÕ5rE   zfunc,expectedÚ	transformr   ©rç   r¬   r>   r   ©r¬   rç   )rç   r¬   r€   r»   c                 ó˜   • [        / / S.5      nUR                  SSS9n[        US   U5      " S 5      n[        R                  " XR5        g )Nr  r   Fr²   r   c                 ó   • U $ rl   rŸ   rn   s    r#   rp   Ú>TestGrouping.test_evaluate_with_empty_groups.<locals>.<lambda>,  s   € ©qrE   )r   r   Úgetattrr<   r=   )r    rj   rB   r!   r"   rA   s         r#   Útest_evaluate_with_empty_groupsÚ,TestGrouping.test_evaluate_with_empty_groups  sG   € ô4 ˜2 "‘~Ó&ˆØ�J‰J�q UˆJÐ+ˆÜ˜˜1™˜tÔ$¡[Ó1ˆÜ
×Ò˜vÕ0rE   c           	      óº  • [        / SSS9nUR                  / 5      nUR                  5       nUR                  [	        / [
        R                  S95      n[        R                  " X45        [        UR                  R                  5      S:X  d   e[        R                  " UR                  R                  S   [
        R                  " / [
        R                  " [
        R                  5      S95        [        R                  " UR                  R                  S   [
        R                  " / [
        R                  " [
        R                  5      S95        UR                  R                  S   S:X  d   eUR                  U5      nSn[        R                   " ["        US	9   UR$                  nS S S 5        WR&                  nS/nX4:X  d   eg ! , (       d  f       N%= f)
Nrç   Úfloat64rÇ  r«   r   r   r   z#SeriesGroupBy.grouper is deprecatedr   )r
   r   r7   Úset_axisr   rP   r¶  r<   r=   rZ  r¸  Ú	groupingsÚassert_numpy_array_equalÚ
group_infor  r¬   rÙ   rÚ   r-  r~   )r    r<  ÚgrrA   rB   r‚   r1   r-  s           r#   Útest_groupby_emptyÚTestGrouping.test_groupby_empty/  s\  € ä�2˜F¨)Ñ4ˆØ�Y‰Y�r‹]ˆà—‘“ˆØ—:‘:œe B¬b¯g©gÑ6Ó7ˆÜ
×Ò˜vÔ0ô �2—;‘;×(Ñ(Ó)¨QÓ.Ð.Ð.Ü
×#Ò#Ø�K‰K×"Ñ" 1Ñ%¤r§x¢x°¼"¿(º(Ä2Ç7Á7Ó:KÑ'Lô	
ô 	×#Ò#Ø�K‰K×"Ñ" 1Ñ%¤r§x¢x°¼"¿(º(Ä2Ç7Á7Ó:KÑ'Lô	
ð �{‰{×%Ñ% aÑ(¨AÓ-Ð-Ð-ð �Y‰Y�q‹\ˆØ3ˆÜ×'Ò'¬¸SÓAØ—j‘jˆG÷ Bà—‘ˆØ�8ˆØÓ!Ð!Ñ!÷	 BÕAús   Æ GÇ
Gc                 óJ  • [        S[        R                  S/S [        R                  S/// SQS9R                  SS/5      nUR	                  SS/S9R                  5       n[        / [        [        S/S	S
9[        / SS
9// / /SS/S9S/SS9n[        R                  " X#5        g )Nro   r°   é   rß   r   r   r   ré   Ústrr«   rÐ  )r­  r®  r~   r   rÇ   )r*   r€   r   r¬   )
r   rP   Únanr¨  r   r;   r	   r   r<   r?   r@   s       r#   Ú%test_groupby_level_index_value_all_naÚ2TestGrouping.test_groupby_level_index_value_all_naM  s±   € äØ”2—6‘6˜2Ð ¤r§v¡v¨rÐ 2Ð3º_ñ
ç
‰)�S˜#�JÓ
ð 	ð —‘ 3¨ *�Ð-×1Ñ1Ó3ˆÜØÜÜ˜s˜e¨5Ñ1´5¸À9Ñ3MÐNØ˜2�hØ˜C�jñð
 �EØñ	
ˆô 	×Ò˜fÕ/rE   c           
      ó   • [        / SQ/ SQ// SQS9nUR                  SS/5      nXR                  S:     nUR                  S5      R	                  5       n[        SS	/[        / [        R                  SS
9S9n[        R                  " X45        g )N)é{   rz   r:  )rß  r{   r;  )rY  ÚcategoryÚvaluer   rY  rà  r   rÐ  rá  rÈ  )r¬   r   r€   )
r   r¨  rá  r   r;   r   rP   rÇ   r<   r?   )r    r!   ÚemptyrA   rB   s        r#   Ú#test_groupby_multiindex_level_emptyÚ0TestGrouping.test_groupby_multiindex_level_empty_  s…   € äÚšoÐ.Ò8Sñ
ˆð �\‰\˜4 Ð,Ó-ˆØ—8‘8˜a‘<Ñ ˆØ—‘˜tÓ$×(Ñ(Ó*ˆÜØØ�IÜ˜¤"§(¡(°Ñ6ñ
ˆô
 	×Ò˜fÕ/rE   rŸ   N)6r    r¡   r¢   r£   r   r¤   r¥   r   r]   rP   r¹   Úfloatr   r   r¼   rÐ   rÜ   rà   rñ   r  r  r  r$  r)  r/  r2  r5  r?  r,   r   rJ  rT  r\  r`  rg  rn  rt  r|  rˆ  r™  r£  rª  r¯  r²  r»  r¿  rÄ  r
   rÐ  rÍ  rÖ  rÜ  rã  r¦   )r�   Úir   s   000r#   r¨   r¨   ®   s­  † Ø‡[�[×ÑØá‘$�w“-Ó Ù�"—)’)˜A“,ÓÙ�"—)’)˜A UÑ+Ó,Ù�|¨QÑ/Ù˜¨qÑ1ð	
ó	ñGó	ðGò0ò80ò00ò>1ð4 ‡[�[×Ñ˜V e¨T ]Ó3ñ0ó 4ð0ò ,0ò\5ò0ò60ò,"òò
0ò2ð& ‡[�[×ÑØâÚ Ù16°q´Õ:²¨AŒY�t˜Q  Q¡Ö'±Ó:ð	
óñ*óð*ò1ò*ò./ò

*ò0ò(Aò/ò0/ò2=ð> ‡[�[×Ñ˜V d¨E ]Ó3ñ' ó 4ð' òR3ð" ‡[�[×Ñ˜V d¨E ]Ó3ñ1ó 4ð1ò0
/ð ‡[�[×ÑØàÒ1Ð2ØÒ2Ð3ð	
óñFóðFòFò6ð  ‡[�[×ÑØð Ù˜A R§Z¡ZÑ0ðð
 ÙØ "§*¡*±E¸"ÀBÇJÁJÐUVÑ4Wñðð ÙØ "§*¡*±E¸"ÀBÇJÁJÐUVÑ4Wñðð	
óñ*1ó+ð*1ò"ò<0õ$0ùôE ;s   ÃH*r¨   c                   ó>   • \ rS rSrS rS rS rS rS rS r	S r
S	rg
)ÚTestGetGroupis  c                 óö  • [        [        R                  " / SQ5      / SQ/ SQS.5      nUR                  S5      n[	        [        UR                  5      5      nUR                  U5      nUR                  [        U5      R                  5       5      nUR                  [        [        U5      5      5      n[        R                  " XE5        [        R                  " XF5        UR                  SS/5      n[	        [        UR                  5      5      nUR                  U5      nUR                  [        US   5      R                  5       US   45      nUR                  [        [        US   5      5      US   45      n[        R                  " XE5        [        R                  " XF5        S	n[        R                  " [        US
9   UR                  S5        S S S 5        [        R                  " [        US
9   UR                  S5        S S S 5        Sn[        R                  " [        US
9   UR                  S5        S S S 5        g ! , (       d  f       Nw= f! , (       d  f       NU= f! , (       d  f       g = f)N)ú10-Oct-2013rê  rê  ú11-Oct-2013rë  rë  )rH   rH   rI   rH   rH   rI   rÓ   )ÚDATEÚlabelÚVALrì  rí  r   r   z<must supply a tuple to get_group with multiple grouping keysr   rH   zHmust supply a same-length tuple to get_group with multiple grouping keys)rH   rI   Úbaz)r   rê   Úto_datetimer   rþ   rÿ   rI  r   r   Úto_pydatetimerÚ  r<   r?   r   r   r-   )r    r!   r"   rÅ   r   rV   Úresult3r1   s           r#   Útest_get_groupÚTestGetGroup.test_get_groupt  sÏ  € ô äŸšòó	ò DÚ)ñó
ˆð" �J‰J�vÓˆÜ”4˜Ÿ™“>Ó"ˆØ—+‘+˜cÓ"ˆØ—+‘+œi¨›n×:Ñ:Ó<Ó=ˆØ—+‘+œc¤)¨C£.Ó1Ó2ˆÜ
×Ò˜gÔ/Ü
×Ò˜gÔ/à�J‰J˜ Ð(Ó)ˆä”4˜Ÿ™“>Ó"ˆØ—+‘+˜cÓ"ˆØ—+‘+œy¨¨Q©Ó0×>Ñ>Ó@À#ÀaÁ&ÐIÓJˆØ—+‘+œs¤9¨S°©VÓ#4Ó5°s¸1±vÐ>Ó?ˆÜ
×Ò˜gÔ/Ü
×Ò˜gÔ/ð MˆÜ�]Š]œ:¨SÓ1Ø�K‰K˜Ô÷ 2ä�]Š]œ:¨SÓ1Ø�K‰K˜Ô÷ 2àXˆÜ�]Š]œ:¨SÓ1Ø�K‰KÐ-Ô.÷ 2Ð1÷ 2Õ1úç1Õ1ú÷ 2Õ1ús$   ÇIÇ8IÈ-I*É
IÉ
I'É*
I8c                 óÀ  • [        / SQ5      n/ SQnUR                  [        R                  " US   U5      US9nUR	                  [        R
                  " SS5      5      n[        SS/SS/S9n[        R                  " XV5        S	n[        R                  " [        US
9   UR	                  [        R
                  " SS5      5        S S S 5        g ! , (       d  f       g = f)N)r+   r   rB  r(   )r   rx   r°   é   r   )r  rx   r+   r   r   z"Interval\(10, 15, closed='right'\)r   r°   rö  )r   r   rê   Úcutr   ÚIntervalr<   r?   r   r   r   )r    r  r|   Úbinsr"   rA   rB   r1   s           r#   Útest_get_group_empty_binsÚ&TestGetGroup.test_get_group_empty_bins£  s¥   € Ü’lÓ#ˆÚˆØ�I‰I”b—f’f˜Q˜q™T 4Ó(°8ˆIÐ<ˆð —‘œRŸ[š[¨¨AÓ.Ó/ˆÜ˜a ˜V¨A¨q¨6Ñ2ˆÜ
×Ò˜fÔ/à3ˆÜ�]Š]œ8¨3Ó/Ø�K‰KœŸš B¨Ó+Ô,÷ 0×/Ö/ús   Â'CÃ
Cc                 óÚ  • [        / SQ/S/S9R                  nUR                  S5      n[        SSS/0SS/S9nUR                  S5      n[        R
                  " XC5        [        R                  " / SQ5      n[        SU Vs/ s H  of4PM     sn05      nUR                  S5      nUR                  S5      n[        SUS   4US   4/0SS/S9n[        R
                  " XC5        g s  snf )	N)©r   r  rý  r  Úidsr   rý  r   r   )ú
2010-01-01ú
2010-01-02rÿ  r   )rÿ  )r   r  r   r   r<   r?   rê   rð  )r    r!   rÕ  rB   rA   Údtro   s          r#   Útest_get_group_grouped_by_tupleÚ,TestGetGroup.test_get_group_grouped_by_tuple²  sß   € äÒ4Ð5¸e¸WÑE×GÑGˆØ�Z‰Z˜ÓˆÜ˜e d¨D \Ð2¸1¸a¸&ÑAˆØ—‘˜dÓ#ˆÜ
×Ò˜fÔ/ä�^Š^ÒTÓUˆÜ˜©bÓ1ªb¨£©bÑ1Ð2Ó3ˆØ�Z‰Z˜ÓˆØ—‘˜oÓ.ˆÜ˜e r¨!¡u h°°A±°Ð%9Ð:À1ÀaÀ&ÑIˆÜ
×Ò˜fÕ/ùò	  2s   ÂC(
c                 ó’  ^• [        SS S 5       05      mTR                  S5      nTR                  U4S j5      nUR                  [        [	        UR
                  R                  5       5      5      5      nUR                  [        [	        UR
                  R                  5       5      5      5      n[        R                  " XC5        g )Nr‡   c              3   ó˜   #   • U  H@  n[         R                  R                  S 5      R                  SSS5        H  nX4v •  M
     MB     g7fr‰   rŠ   rŒ   s      r#   rŽ   ÚKTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<genexpr>Å  r�   r‘   r’   c                 ó&   >• TR                   U S4   $ r”   r•   r–   s    €r#   rp   ÚJTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<lambda>Î  r˜   rE   )	r   r   r   rþ   rÿ   rI  r[  r<   r?   r›   s        @r#   Ú+test_get_group_grouped_by_tuple_with_lambdaÚ8TestGetGroup.test_get_group_grouped_by_tuple_with_lambdaÁ  s›   ø€ äàñ á#óðó
ˆð �Z‰Z˜Ó!ˆØ—J‘JÔ6Ó7ˆ	à—<‘<¤¤T¨"¯)©)¯.©.Ó*:Ó%;Ó <Ó=ˆØ×$Ñ$¤T¬$¨y×/?Ñ/?×/DÑ/DÓ/FÓ*GÓ%HÓIˆä
×Ò˜fÕ/rE   c                 ó´   • [         R                  " S5      nSn[        X![        S9n[	        SS9nUR                  U5      n[        [        U5      S 5      b   eg )NrŸ   r«   r:   rX  )rê   rë   r
   Úobjectr   r   rþ   rÿ   )r    r€   r*   Úseriesr-  r2   s         r#   Útest_groupby_with_emptyÚ$TestGetGroup.test_groupby_with_emptyÕ  sR   € Ü× Ò  Ó$ˆØˆÜ˜¬6Ñ2ˆÜ˜sÑ#ˆØ—.‘. Ó)ˆÜ”D˜“M 4Ó(Ñ0Ð0Ñ0rE   c                 óL  • [        S[        S5      05      n[        R                  " UR	                  S5      R                  S5      UR                  SS/   5        [        [        / SQSS9[        / SS9S	9n[        R                  " UR	                  S5      R                  5       U5        [        R                  " UR	                  S5      R                  5       U5        UR                  / S
Q   n[        R                  " UR	                  S5      R                  S5      U5        g )Nrz   Úabssbabr   rx   )rz   r{   r<  )rç   rÚ  r«   )r€   r   ©r+   r'   rx   r   )r   r]   r<   r?   r   r   re   r   r.   r;   Únth)r    r!   r¦  s      r#   Útest_groupby_with_single_columnÚ,TestGetGroup.test_groupby_with_single_columnÝ  sÖ   € Ü˜œT )›_Ð-Ó.ˆÜ
×Ò˜bŸj™j¨›o×7Ñ7¸Ó<¸b¿g¹gÀqÈ!Àf¹oÔNäÜš¨cÑ2¼EÀ"ÈEÑ<Rñ
ˆô 	×Ò˜bŸj™j¨›o×3Ñ3Ó5°sÔ;Ü
×Ò˜bŸj™j¨›o×1Ñ1Ó3°SÔ9à�g‰g’iÑ ˆÜ
×Ò˜bŸj™j¨›o×1Ñ1°!Ó4°cÕ:rE   c                 óê   • [        / SQ/ SQ/ SQ// SQS9nUR                  SS/5      nUR                  / SQ5      R                  5       nUR                  S	   S
:X  d   eUR                  S   S:X  d   eg )N)rH   rI   r   r   )rH   rI   r   r   )rH   rï  r   r+   )rf  rj  ÚthirdrK   r   rf  rj  )rf  rj  r  )rH   rI   r   r   )rH   rï  r   r   )r   r¨  r   r0   rT   ra   s     r#   Útest_gb_key_len_equal_axis_lenÚ+TestGetGroup.test_gb_key_len_equal_axis_lenê  sz   € ô Ú#Ò%;Ò=SÐTÚ7ñ
ˆð �\‰\˜7 HÐ-Ó.ˆØ�Z‰ZÒ4Ó5×:Ñ:Ó<ˆØ�v‰vÐ)Ñ*¨aÓ/Ð/Ð/Ø�v‰vÐ)Ñ*¨aÓ/Ð/Ñ/rE   rŸ   N)r    r¡   r¢   r£   ró  rú  r  r	  r  r  r  r¦   rŸ   rE   r#   rè  rè  s  s&   † ò-/ò^-ò0ò0ò(1ò;õ0rE   rè  c                   ó>   • \ rS rSrS rS rS rS rS rS r	S r
S	rg
)ÚTestIterationiü  c                 óR  • UR                  S/5      nUR                  nX2R                  L d   eUR                  R                  5        H/  u  pEUR                  U   S   U:H  R	                  5       (       a  M/   e   UR                  SS/5      nUR                  nX2R                  L d   eUR                  R                  5        H_  u  pEUR                  U   S   US   :H  R	                  5       (       d   eUR                  U   S   US   :H  R	                  5       (       a  M_   e   g )Nr   r   r   r   )r   rI  ÚitemsrT   Úall)r    r!   r2   rI  ÚkÚvs         r#   Útest_groupsÚTestIteration.test_groupsý  s  € Ø—*‘*˜c˜UÓ#ˆØ—‘ˆØŸ™Ò'Ð'Ð'à—N‘N×(Ñ(Ö*‰DˆAØ—F‘F˜1‘I˜c‘N aÑ'×,Ñ,×.Ó.Ð.Ð.ñ +ð —*‘*˜c 3˜ZÓ(ˆØ—‘ˆØŸ™Ò'Ð'Ð'à—N‘N×(Ñ(Ö*‰DˆAØ—F‘F˜1‘I˜c‘N a¨¡dÑ*×/Ñ/×1Ñ1Ð1Ð1Ø—F‘F˜1‘I˜c‘N a¨¡dÑ*×/Ñ/×1Ó1Ð1Ð1ò +rE   c                 ón   • UR                  S S /5      nUR                  R                  S    H  nM     g )Nc                 ó"   • U R                  5       $ rl   )Úweekdayrn   s    r#   rp   Ú9TestIteration.test_grouping_is_iterable.<locals>.<lambda>  s
   € ¨Q¯Y©Y¬[rE   c                 ó   • U R                   $ rl   )Úyearrn   s    r#   rp   r&    s   € ÀAÇFÂFrE   r   )r   r¸  rÒ  )r    Útsframer2   r"   s       r#   Útest_grouping_is_iterableÚ'TestIteration.test_grouping_is_iterable  s9   € ð —/‘/Ñ#8Ñ:JÐ"KÓLˆð ×!Ñ!×+Ñ+¨AÔ.ˆAÙò /rE   c                 ó®  • [        [        R                  " S5      5      n[        R                  " / SQ5      n[        R                  " / SQ5      nUR	                  X#/5      n[        U5      nSSUSS/   4SSUS	/   4S
SUS/   4S
SUSS/   4/n[        U5       H6  u  nu  u  p‰n
Xg   u  p¼nX¸:X  d   eXÉ:X  d   e[        R                  " X­5        M8     g )Nr(   )rz   rz   rz   r{   r{   r{   ©Ú1Ú2r.  r/  r.  r/  rz   r.  r   r   r/  r   r{   r'   r+   rx   )	r
   rP   r¹   r  r   r]   Ú	enumerater<   r=   )r    r<  Úk1Úk2r2   ÚiteratedrB   ræ  rK   rL   rM   Úe1Úe2Úe3s                 r#   Útest_multi_iterÚTestIteration.test_multi_iter  sà   € Ü”2—9’9˜Q“<Ó ˆÜ�XŠXÒ4Ó5ˆÜ�XŠXÒ4Ó5ˆà—)‘)˜R˜HÓ%ˆä˜“=ˆà�#�q˜!˜Q˜‘yÐ!Ø�#�q˜!˜‘vÐØ�#�q˜!˜‘vÐØ�#�q˜!˜Q˜‘yÐ!ð	
ˆô '0°Ö&9Ñ"ˆAÑ"‘
�˜EØ!™‰JˆB�BØ“9Ð�9Ø“9Ð�9Ü×"Ò" 5Ö-ò	 ':rE   c                 ó¬  • [         R                  " / SQ5      n[         R                  " / SQ5      n[        [         R                  R	                  S5      R                  S5      [         R                  R	                  S5      R                  S5      UUS./ SQS9nUR                  SS	/5      n[        U5      nUR                  nS
SUR                  US/      4S
SUR                  USS/      4SSUR                  USS/      4SSUR                  US/      4/n[        U5       H6  u  n	u  u  p«nX‰   u  pÞnXÚ:X  d   eXë:X  d   e[        R                  " XÏ5        M8     [         R                  " / SQ5      US'   [         R                  " / SQ5      US	'   UR                  SS	/5      nU VVs0 s H	  u  nnUU_M     nnn[        U5      S:X  d   eUR                  / SQ5      R                  5       nSn[        R                  " [         US9   UR"                  R                  SSS9nS S S 5        U H  u  nnM     g s  snnf ! , (       d  f       N!= f)N)r{   r{   r{   rz   rz   rz   r-  r   r(   )Úv1Úv2r1  r2  )rK   rL   rM   ÚfourÚfiveÚsixr   r1  r2  rz   r.  r'   r/  r+   rx   r{   r   r   )r.  r.  r.  r/  r/  r/  rß   r  r   r  re  )rP   r  r   rQ   rR   rS   r   r]   r€   rT   r0  r<   r?   rZ  r7   rÙ   rÚ   r  )r    Úthree_groupr1  r2  r!   r2   r3  rƒ   rB   ræ  rK   rL   rM   r4  r5  r6  rÅ   ÚgprI  Úthree_levelsr!  Úgroups                         r#   Útest_multi_iter_frameÚ#TestIteration.test_multi_iter_frame*  s/  € Ü�XŠXÒ4Ó5ˆÜ�XŠXÒ4Ó5ˆÜä—i‘i×+Ñ+¨AÓ.×>Ñ>¸qÓAÜ—i‘i×+Ñ+¨AÓ.×>Ñ>¸qÓAØØñ	ò Añ
ˆð —*‘*˜d D˜\Ó*ˆô ˜“=ˆØ�h‰hˆà�#�r—v‘v˜c 1 #™hÑ'Ð(Ø�#�r—v‘v˜c 1 a &™kÑ*Ð+Ø�#�r—v‘v˜c 1 a &™kÑ*Ð+Ø�#�r—v‘v˜c 1 #™hÑ'Ð(ð	
ˆô '0°Ö&9Ñ"ˆAÑ"‘
�˜EØ!™‰JˆB�BØ“9Ð�9Ø“9Ð�9Ü×!Ò! %Ö,ñ	 ':ô —8’8Ò:Ó;ˆˆ4‰Ü—8’8Ò:Ó;ˆˆ4‰Ø—*‘*˜d D˜\Ó*ˆñ *1Ô1ª™g˜c 2�#�r’'©ˆÑ1Ü�6‹{˜aÓÐÐð #×*Ñ*ª?Ó;×@Ñ@ÓBˆØ@ˆÜ×'Ò'¬¸XÓFØ"—n‘n×,Ñ,°!¸6Ð,ÐBˆG÷ Gã!‰JˆC�Ùò "ùó 2÷ GÕFús   Æ/H?ÈIÉ
Ic           	      óÞ  • [        [        UR                  S5      5      5        [        [        UR                  SS/5      5      5        [        [        US   R                  US   5      5      5        [        [        US   R                  US   US   /5      5      5        [        [        UR                  S5      S   5      5        [        [        UR                  SS/5      S   5      5        g )Nr   r   r   )rü   rÿ   r   ra   s     r#   Útest_dictifyÚTestIteration.test_dictifyZ  s¯   € ÜŒT�"—*‘*˜S“/Ó"Ô#ÜŒT�"—*‘*˜c 3˜ZÓ(Ó)Ô*ÜŒT�"�S‘'—/‘/ " S¡'Ó*Ó+Ô,ÜŒT�"�S‘'—/‘/ 2 c¡7¨B¨s©GÐ"4Ó5Ó6Ô7ÜŒT�"—*‘*˜S“/ #Ñ&Ó'Ô(ÜŒT�"—*‘*˜c 3˜ZÓ(¨Ñ-Ó.Õ/rE   c                 óè  • [        SS/SS/S.[        R                  " SS/5      S9nUR                  [	        SS	9S
/5      n[        UR                  5      S:X  d   eUR                  S:X  d   e[        S5      S4UR                  ;   d   e[        S5      S4UR                  ;   d   eUR                  [        S5      S45      n[        R                  " X1R                  S/S S 24   5        UR                  [        S5      S45      n[        R                  " X1R                  S/S S 24   5        [        / SQ/ SQS.[        R                  " / SQ5      S9nUR                  [	        SS	9S
/5      n[        UR                  5      S:X  d   eUR                  S:X  d   e[        S5      S4UR                  ;   d   e[        S5      S4UR                  ;   d   eUR                  [        S5      S45      n[        R                  " X1R                  SS/S S 24   5        UR                  [        S5      S45      n[        R                  " X1R                  S/S S 24   5        [        / SQ/ SQS.[        R                  " / SQ5      S9nUR                  [	        SS	9S
/5      n[        UR                  5      S:X  d   eUR                  S:X  d   e[        S5      S4UR                  ;   d   e[        S5      S4UR                  ;   d   e[        S5      S4UR                  ;   d   eUR                  [        S5      S45      n[        R                  " X1R                  S/S S 24   5        UR                  [        S5      S45      n[        R                  " X1R                  S/S S 24   5        UR                  [        S5      S45      n[        R                  " X1R                  S/S S 24   5        g )NÚstartéÒ  é.  )ÚeventÚchangeú
2014-09-10ú
2013-10-10r   ræ   rX  rL  r   z
2014-09-30z
2013-10-31r   r   )rI  rI  rI  )rJ  rK  i£#  )rN  rO  z
2014-09-15)rN  rO  z
2014-08-05r+   z
2014-08-31)r   rê   rë   r   r   rZ  rI  Úngroupsr   r   r<   r?   re   )r    r!   r2   Úress       r#   Útest_groupby_with_small_elemÚ*TestIteration.test_groupby_with_small_elemb  s‚  € ô Ø Ð(°T¸4°LÑAÜ×"Ò" L°,Ð#?Ó@ñ
ˆð —*‘*œg¨4Ñ0°'Ð:Ó;ˆÜ�7—>‘>Ó" aÓ'Ð'Ð'Ø�‰ !Ó#Ð#Ð#Ü˜,Ó'¨Ð1°W·^±^ÓCÐCÐCÜ˜,Ó'¨Ð1°W·^±^ÓCÐCÐCà×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨3²¨6¡?Ô3Ø×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨3²¨6¡?Ô3äÚ1Ò=OÑPÜ×"Ò"Ò#MÓNñ
ˆð —*‘*œg¨4Ñ0°'Ð:Ó;ˆÜ�7—>‘>Ó" aÓ'Ð'Ð'Ø�‰ !Ó#Ð#Ð#Ü˜,Ó'¨Ð1°W·^±^ÓCÐCÐCÜ˜,Ó'¨Ð1°W·^±^ÓCÐCÐCà×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨q¨6²1¨9Ñ#5Ô6Ø×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨3²¨6¡?Ô3ô Ú1Ò=OÑPÜ×"Ò"Ò#MÓNñ
ˆð —*‘*œg¨4Ñ0°'Ð:Ó;ˆÜ�7—>‘>Ó" aÓ'Ð'Ð'Ø�‰ !Ó#Ð#Ð#Ü˜,Ó'¨Ð1°W·^±^ÓCÐCÐCÜ˜,Ó'¨Ð1°W·^±^ÓCÐCÐCÜ˜,Ó'¨Ð1°W·^±^ÓCÐCÐCà×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨3²¨6¡?Ô3Ø×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨3²¨6¡?Ô3Ø×Ñ¤¨<Ó!8¸'Ð BÓCˆÜ
×Ò˜c§7¡7¨A¨3²¨6¡?Õ3rE   c                 óú   • [         R                  " [        S5      [        S5      /5      n[        / SQ/US9nUR	                  US   5      nUR
                  R                  S   R                  5       nSnXE:X  d   eg )NÚAABÚabarc  r   )r   rz   r   zGrouping(('A', 'a')))r	   r…  r]   r   r   r¸  rÒ  Ú__repr__)r    rî   r!   rÕ  rA   rB   s         r#   Útest_grouping_string_reprÚ'TestIteration.test_grouping_string_repr–  sm   € ä×#Ò#¤T¨%£[´$°u³+Ð$>Ó?ˆÜš	�{¨BÑ/ˆØ�Z‰Z˜˜:™Ó'ˆà—‘×&Ñ& qÑ)×2Ñ2Ó4ˆØ)ˆØÓ!Ð!Ñ!rE   rŸ   N)r    r¡   r¢   r£   r!  r*  r7  rC  rF  rR  rX  r¦   rŸ   rE   r#   r  r  ü  s'   † ò2ò ò.ò(.ò`0ò24õh"rE   r  c                  ó  • [        / SQ/ SQ/ SQS.5      R                  S5      n U R                  [        SS9[        SS9/SS	9nUR                  R
                  S
   R                  (       a   eUR                  R
                  S   R                  (       d   eSn[        R                  " [        US9   UR                  5       nS S S 5        [        SS/SS/S.5      n[        R                  " WU5        g ! , (       d  f       N8= f)Nrw   r  )rz   r{   r3   rz   ré   r{   rÕ   Frq  r   r   z*A grouping .* was excluded from the resultr   r   rB  rx   )r{   r3   )r   r¨  r   r   r¸  rÒ  Úin_axisr<   rÙ   rÚ   r;   r?   )r!   r‚   r1   rA   rB   s        r#   Útest_grouping_by_key_is_in_axisr\  ¡  sÒ   € ä	šªºÑCÓ	D×	NÑ	NÈsÓ	S€BØ	�‰”W 3Ñ'¬°SÑ)9Ð:ÀUˆÐ	K€BØ�{‰{×$Ñ$ QÑ'×/×/Ð/Ð/Ø�;‰;× Ñ  Ñ#×+×+Ð+Ð+ð 7€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘“ˆ÷ 
>ä  1˜v¨Q°¨FÑ3Ó4€HÜ×Ò˜& (Õ+÷ 
>Õ	=ús   Â4C7Ã7
Dc                  óF  • [        / SQSS.5      n [        SS9nU R                  U5      nSn[        R                  " [
        US9   UR                  nS S S 5        WUR                  L d   eSn[        R                  " [
        US9   UR                  nS S S 5        XBR                  L d   eS	n[        R                  " [
        US9   UR                  nS S S 5        XBR                  L d   eS
n[        R                  " [
        US9   UR                    S S S 5        Sn[        R                  " [
        US9   UR                    S S S 5        g ! , (       d  f       GN= f! , (       d  f       NÑ= f! , (       d  f       N¢= f! , (       d  f       Ns= f! , (       d  f       g = f)Nrc  r   ©rz   r{   rz   rÕ   zUse GroupBy.groups insteadr   zUse GroupBy.grouper insteadz-Grouper.obj is deprecated and will be removedzUse Resampler.ax insteadzGrouper.indexer is deprecated)r   r   r   r<   rÙ   rÚ   rI  r-  r¸  rH  ÚaxÚindexer)r!   Úgrperr‚   r1   rQ  s        r#   Útest_grouper_groupsrb  ±  s6  € ä	š¨Ñ+Ó	,€BÜ˜Ñ€EØ	�‰�EÓ	€Bà
&€CÜ	×	#Ò	#¤M¸Ó	=Ø�l‰lˆ÷ 
>à�"—)‘)ÒÐÐà
'€CÜ	×	#Ò	#¤M¸Ó	=Ø�m‰mˆ÷ 
>à—+‘+ÒÐÐà
9€CÜ	×	#Ò	#¤M¸Ó	=Ø�i‰iˆ÷ 
>à—&‘&Š=Ðˆ=à
$€CÜ	×	#Ò	#¤M¸Ó	=Ø�Š÷ 
>ð *€CÜ	×	#Ò	#¤M¸Ó	=Ø�Š÷ 
>Ð	=÷' 
>Ö	=ú÷
 
>Õ	=ú÷
 
>Õ	=ú÷
 
>Õ	=ú÷ 
>Õ	=ús<   ÁEÂEÃE0ÄFÄ7FÅ
EÅ
E-Å0
E>Æ
FÆ
F Úattr)Úgroup_indexÚresult_indexÚgroup_arraylikec                 ó   • [        / SQ/ SQS.5      nUR                  S5      nU  S3n[        R                  " [        US9   [        UR                  R                  S   U 5        S S S 5        g ! , (       d  f       g = f)Nrw   r  r^  rz   z is deprecatedr   r   )r   r   r<   rÙ   rÚ   rÌ  r¸  rÒ  )rc  r!   r‚   r1   s       r#   Útest_depr_grouping_attrsrh  Ï  sa   € ô 
šªÑ3Ó	4€BØ	�‰�C‹€BØˆF�.Ð
!€CÜ	×	#Ò	#¤M¸Ó	=Ü�—‘×%Ñ% aÑ(¨$Ô/÷ 
>×	=Ö	=ús   Á$A/Á/
A=) Ú__doc__Údatetimer   r   ÚnumpyrP   r   Úpandasrê   r   r   r   r   r	   r
   r   r   r   Úpandas._testingÚ_testingr<   Úpandas.core.groupby.grouperr   r   r¨   rè  r  r\  rb  r¤   r¥   rh  rŸ   rE   r#   Ú<module>rp     s–   ðñ÷ó
 Û ã ÷
÷ 
õ 
õ Ý 0÷H/ñ H/÷^~
0ñ ~
0÷JB0ñ B0÷Rb"ñ b"òJ,ò ð< ‡�×Ñ˜Ò!SÓTñ0ó Uñ0rE   