ó
    ®œ‘hun ã                   ón  • S SK JrJ r Jr  S SKJr  S SKrS SKrS SKrS SK	J
r
  S SKJr  S SKrS SKJrJrJrJrJrJrJrJr  S SKJr  S SKJr  S SKJr  S S	KJ r   \RB                  " S
S/S9S 5       r"\RB                  " S /S-  S/S-  4\#" S5      \#" SS5      4/S9S 5       r$ " S S5      r% " S S5      r&g)é    )ÚdateÚdatetimeÚ	timedelta)ÚproductN)Úusing_string_dtype)ÚPerformanceWarning)ÚCategoricalÚ	DataFrameÚGrouperÚIndexÚ
MultiIndexÚSeriesÚconcatÚ
date_range)ÚCategoricalDtype)Úreshape©Úpivot_tableTF)Úparamsc                 ó   • U R                   $ ©N)Úparam)Úrequests    ÚcC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/reshape/test_pivot.pyÚdropnar   !   s   € à�=‰=Ðó    é   é   é   c                 óp   • U R                   u  p#[        [        R                  R	                  X#U5      5      $ r   )r   r	   ÚpdÚIntervalIndexÚfrom_arrays)r   ÚclosedÚleftÚrights       r   Úinterval_valuesr'   &   s+   € à—-‘-�K€DÜ”r×'Ñ'×3Ñ3°DÀÓHÓIÐIr   c                   óð  • \ rS rSr\R
                  S 5       rS rS rS r	S r
S rS rS	 rS
 rS rS rS rS rS rS r\R*                  R-                  SSSS/4S/ SQ4S/ SQ4/5      S 5       rS rS rS r\R*                  R-                  SSS/5      S 5       r\R*                  R-                  SSS/5      S 5       r\R*                  R-                  SSS/5      S  5       rS! r\R*                  R-                  SSS/5      S" 5       rS# r \R*                  R-                  S$S%S&/\!RD                  " S%S&/5      \#" S%S&/5      \$" S%S&/5      /5      \R*                  R-                  SSS/5      S' 5       5       r%\R*                  R-                  S$S(S%/\!RD                  " S(S%/5      \#" S(S%/5      \$" S(S%/5      /5      \R*                  R-                  SSS/5      S) 5       5       r&S* r'\R*                  RQ                  S+S,9\R*                  R-                  SSS/5      S- 5       5       r)\R*                  R-                  SSS/5      S. 5       r*S/S0/S1/S24S3 jr+S4 r,S5 r-\R*                  R-                  S6S/S7/ S8Q/ S9Q/\$" / S:QS/S;94S/S0/S</ S=Q/ S>Q/\.R^                  " / S?QS/S0/S@94/5      SA 5       r0SB r1SC r2\R*                  R-                  SD/ SEQ5      SF 5       r3SG r4SH r5SI r6SJ r7SK r8SL r9SM r:SN r;SO r<\R*                  R-                  SPSQSRSSSTSUSV//5      SW 5       r=SX r>SY r?SZ r@S[ rAS\ rBS] rCS^ rDS_ rES` rFSa rGSb rHSc rISd rJSe rKSf rLSg rMSh rN\R*                  R-                  SiS<\!Rž                  4S7\!R                   4Sj\!R¢                  4S<S7/\!Rž                  \!R                   /4S<Sj/\!Rž                  \!R¢                  /4SjS7/\!R¢                  \!R                   /4/5      Sk 5       rR\R*                  R¦                  Sl 5       rTSm rUSn rV\R*                  R-                  SoSS/5      Sp 5       rWSq rXSr rYSs rZSt r[Su r\Sv r]\R*                  R-                  SwSS/5      Sx 5       r^Sy r_Sz r`S{ raS|rbgT)}ÚTestPivotTableé,   c           
      ó:  • [        / 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©Úfoor-   r-   r-   Úbarr.   r.   r.   r-   r-   r-   ©Úoner0   r0   Útwor0   r0   r0   r1   r1   r1   r0   )Údullr2   Úshinyr2   r2   r3   r3   r2   r3   r3   r3   é   é   )ÚAÚBÚCÚDÚEÚF)r
   ÚnpÚrandomÚdefault_rngÚstandard_normal)Úselfs    r   ÚdataÚTestPivotTable.data-   s}   € äòòòô —Y‘Y×*Ñ*¨1Ó-×=Ñ=¸bÓAÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸bÓAÜ—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸bÓAñU+ó-
ð -	
r   c                 ó^  • SS/nSn[        USX4US9nUR                  SX4US9n[        R                  " XV5        [        USX1S9  [        U5      S:”  a&  UR                  R
                  [        U5      :X  d   eOUR                  R                  US   :X  d   e[        U5      S:”  a  UR                  R
                  U:X  d   eOUR                  R                  US   :X  d   eUR                  X4/-   5      S   R                  S	5      R                  5       n[        R                  " XW5        g )
Nr6   r7   r8   r9   )ÚvaluesÚindexÚcolumnsÚobserved)rD   rE   rG   r   r   Úmean)r   ÚtmÚassert_frame_equalÚlenrE   ÚnamesÚtupleÚnamerF   ÚgroupbyÚaggÚunstack)r@   rG   rA   rE   rF   ÚtableÚtable2Úexpecteds           r   Útest_pivot_tableÚTestPivotTable.test_pivot_table^   s  € Ø�c�
ˆØˆÜØ˜ EÀXñ
ˆð ×!Ñ!Ø˜e¸xð "ð 
ˆô 	×Ò˜eÔ,ô 	�D ¨EÒEäˆu‹:˜‹>Ø—;‘;×$Ñ$¬¨e«Ó4Ð4Ñ4à—;‘;×#Ñ# u¨Q¡xÓ/Ð/Ð/äˆw‹<˜!ÓØ—=‘=×&Ñ&¨'Ó1Ð1Ñ1à—=‘=×%Ñ%¨°©Ó3Ð3Ð3à—<‘< ¨	Ñ 1Ó2°3Ñ7×;Ñ;¸FÓC×KÑKÓMˆÜ
×Ò˜eÕ.r   c           	      óÄ  • [        [        S5      [        S5      / SQS.5      nUR                  SSSSS	S
9nUR                  R	                  S5      Ul        UR
                  R	                  S5      Ul        UR                  R	                  S5      Ul        UR                  R	                  S5      Ul        UR                  SSSSS	US9n[        R                  " XC5        g )NÚabcdeÚfghij©r   r4   r   r   é   ©Úcol1Úcol2Úcol3r]   r_   r^   Úsumr   )rE   rD   rF   ÚaggfuncÚ
fill_valueÚcategory)rE   rD   rF   ra   rb   rG   )
r
   Úlistr   rE   ÚastyperF   r]   r^   rI   rJ   )r@   rG   ÚdfrT   Úresults        r   Ú+test_pivot_table_categorical_observed_equalÚ:TestPivotTable.test_pivot_table_categorical_observed_equalz   sÍ   € äÜ˜'“]¬D°«MÂ?ÑSó
ˆð —>‘>Ø °ÀÐSTð "ð 
ˆð "Ÿ™×.Ñ.¨zÓ:ˆŒØ#×+Ñ+×2Ñ2°:Ó>ˆÔà—'‘'—.‘. Ó,ˆŒØ—'‘'—.‘. Ó,ˆŒà—‘ØØØØØØð  ð 
ˆô 	×Ò˜fÕ/r   c                 ó6  • [        / SQ/ SQ/ SQS.5      nUR                  SSS9nUR                  SSS9R                  n[        R                  " X#5        UR                  SS	S
0S9nUR                  SS	S
0S9R                  n[        R                  " X#5        g )N©ÚaÚbÚc©ÚxÚyÚz©r   r4   r   )ÚrowsÚcolsrD   ru   r`   )rF   ra   ©rE   ra   rD   rH   )r
   r   ÚTrI   rJ   )r@   rf   ÚrsÚxps       r   Útest_pivot_table_nocolsÚ&TestPivotTable.test_pivot_table_nocols•   s’   € ÜÚ$ªoÊÑSó
ˆð �^‰^ F°Eˆ^Ð:ˆØ�^‰^ &°%ˆ^Ð8×:Ñ:ˆÜ
×Ò˜bÔ%à�^‰^ F°X¸vÐ4Fˆ^ÐGˆØ�^‰^ &°8¸VÐ2Dˆ^ÐE×GÑGˆÜ
×Ò˜bÕ%r   c                 ó^  • [        SSSSS.SSSSS.S	S
SSS.SSSSS.SSSSS.S.5      nUR                  SSSS/SS9nUR                  SSS/SSS9n[        R                  " / SQSS/S9n[        R
                  " UR                  U5        [        R
                  " UR                  U5        g )Ni`ê  i † iPÃ  i0u  )r   r   r4   r   r6   r7   r8   i[ i] i\ i^ rl   rm   rn   Údi€„ i ¡ i@B )ÚamountÚcustomerÚmonthr   Úquantityr�   r€   r   r   F)r   ))r6   rl   )r6   rm   )r6   rn   )r6   r}   )r7   rl   )r7   rm   )r7   rn   )r7   r}   )r8   rl   )r8   rm   )r8   rn   )r8   r}   ©rL   )r
   r   r   Úfrom_tuplesrI   Úassert_index_equalrF   rE   )r@   rf   Úpv_colÚpv_indÚms        r   Útest_pivot_table_dropnaÚ&TestPivotTable.test_pivot_table_dropna¡   sÞ   € Üà#¨°5¸UÑCØ #¨°¸Ñ<Ø#¨°6¸fÑEØ" s¨s°sÑ;Ø '¨F°wÀ7ÑKñó
ˆð —‘Ø˜ *¨iÐ!8Àð  ð 
ˆð —‘Ø˜ YÐ/°Àð  ð 
ˆô ×"Ò"òð ˜yÐ)ñ
ˆô" 	×Ò˜fŸn™n¨aÔ0Ü
×Ò˜fŸl™l¨AÕ.r   c                 ó`  • [        / SQ/ SQSS9n[        / SQ/ SQSS9n[        X/ SQS.5      nS	n[        R                  " [        US
9   [        USSS/SS9nS S S 5        [        R                  " X/SS/S9n[        S/ SQ0US9n[        R                  " WU5        g ! , (       d  f       NL= f)N©rl   rl   rm   rm   )rl   rm   rr   T©Ú
categoriesÚordered)rn   r}   rn   r}   )rn   r}   rq   ©r   r4   r   r   )r6   r7   rD   ú1The default value of observed=False is deprecated©ÚmatchrD   r6   r7   )rD   rE   r   r‚   )ç      ð?ç       @ç      @ç      @©rE   )	r	   r
   rI   Úassert_produces_warningÚFutureWarningr   r   r#   rJ   )r@   Úcat1Úcat2rf   Úmsgrg   Ú	exp_indexrT   s           r   Útest_pivot_table_categoricalÚ+TestPivotTable.test_pivot_table_categoricalÆ   s¬   € ÜÚ ª_Àdñ
ˆô Ú ª_Àdñ
ˆô ˜TºÑEÓFˆØAˆÜ×'Ò'¬¸SÓAÜ  ¨H¸SÀ#¸JÈtÑTˆF÷ Bô ×*Ò*¨D¨<ÀÀS¸zÑJˆ	Ü˜hÒ(<Ð=ÀYÑOˆÜ
×Ò˜f hÕ/÷ BÕAús   Á
BÂ
B-c                 ó$  • / SQn[        / SQ/ SQ[        S5      S.5      nUS   R                  [        USS95      US'   S	n[        R
                  " [        US
9   UR                  SSSUS9nS S S 5        [        / SQSS9nUR                  [        USS95      n[        / SQSS9n[        / SQ/ SQ/ SQ/UUS9nU(       d'  UR                  [        U5      S9R                  S5      n[        R                  " WU5        g ! , (       d  f       N™= f)N©rl   rm   rn   r}   )	rl   rl   rl   rm   rm   rm   rn   rn   rn   )	r   r4   r   r   r4   r   r   r4   r   é	   ©r6   r7   r8   r6   F©rŽ   r�   r‘   r7   r8   )rE   rF   rD   r   rk   ©rN   rs   )ç        r•   ç      @)r“   r–   ç      @)r”   ç      @ç       @©rE   rF   ©rF   Úfloat)r
   Úrangere   r   rI   r˜   r™   r   r   Úreindexr	   rJ   )	r@   r   r�   rf   rœ   rg   Úexpected_columnsÚexpected_indexrT   s	            r   Ú$test_pivot_table_dropna_categoricalsÚ3TestPivotTable.test_pivot_table_dropna_categoricalsÖ   s  € â)ˆ
äâBÚ0Ü˜1“Xñó
ˆð �S‘'—.‘.Ô!1°*ÀeÑ!LÓMˆˆ3‰ØAˆÜ×'Ò'¬¸SÓAØ—^‘^¨#°sÀ3Èv�^ÐVˆF÷ Bä!¢/¸Ñ<ÐØ+×2Ñ2Ü˜Z°Ñ7ó
Ðô  ¢	°Ñ4ˆÜÚšoªÐ?Ø Ø$ñ
ˆö
 à×'Ñ'´¸JÓ0GÐ'ÐH×OÑOÐPWÓXˆHä
×Ò˜f hÕ/÷! BÕAús   ÁDÄ
Dc                 óž  • [        [        [        R                  SSSS/SS/SS9/ SQS.5      nSn[        R
                  " [        US9   UR                  S	S
US9nS S S 5        U(       a	  SS/nSS/nO/ SQn/ SQn[        S
U0[        [        R                  " USS/US9S	S9S9n[        R                  " WU5        g ! , (       d  f       Nh= f)NÚlowÚhighTrŒ   )r¦   r“   r”   r•   r–   ©r6   r7   r�   r‘   r6   r7   ©rE   rD   r   r”   r•   r   r   ©r”   r•   r¦   )r   r   éÿÿÿÿr¥   r—   )r
   r	   r<   ÚnanrI   r˜   r™   r   r   Ú
from_codesrJ   )r@   r   rf   rœ   rg   rD   ÚcodesrT   s           r   Ú%test_pivot_with_non_observable_dropnaÚ4TestPivotTable.test_pivot_with_non_observable_dropnaö   sà   € ää Ü—V‘V˜U F¨E°6Ð:Ø % v˜Ø ñò
 /ñó	
ˆð BˆÜ×'Ò'¬¸SÓAØ—^‘^¨#°cÀ&�^ÐIˆF÷ BæØ˜3�ZˆFØ˜�F‰Eò %ˆFÚˆEÜØ�&ˆMÜÜ×&Ò&Ø u¨f o¸vñð ñ	ñ
ˆô 	×Ò˜f hÕ/÷' BÕAús   Á
B>Â>
Cc                 ó¦  • [        [        / SQ/ SQSS9[        S5      S.5      nSn[        R                  " [
        US9   UR                  S	S
US9nS S S 5        [        S
/ SQ0[        [        R                  " / SQ/ SQSS9S	S9S9nU(       d  US
   R                  [        5      US
'   [        R                  " WU5        g ! , (       d  f       Nv= f)N)r%   rµ   r¶   rµ   r¶   )rµ   r¶   r%   TrŒ   r[   r·   r�   r‘   r6   r7   r¸   r¹   )r   r   r4   r¥   r—   )r
   r	   r®   rI   r˜   r™   r   r   r¼   re   r­   rJ   )r@   r   rf   rœ   rg   rT   s         r   Ú/test_pivot_with_non_observable_dropna_multi_catÚ>TestPivotTable.test_pivot_with_non_observable_dropna_multi_cat  sÉ   € ää Ú:Ú6Ø ñô
 ˜1“Xñó	
ˆð BˆÜ×'Ò'¬¸SÓAØ—^‘^¨#°cÀ&�^ÐIˆF÷ BäØ’/Ð"ÜÜ×&Ò&ÚÒ*AÈ4ñð ñ	ñ
ˆö Ø$ S™M×0Ñ0´Ó7ˆH�S‰Mä
×Ò˜f hÕ/÷ BÕAús   Á CÃ
Cc                 óV  • [        USS.5      nSn[        R                  " [        US9   UR	                  SSUS9nS S S 5        [        SS0[        UR                  5       SS	9S
9nU(       d  UR                  [        5      n[        R                  " WU5        g ! , (       d  f       Nd= f)Nr   r·   r�   r‘   r6   r7   r¸   r“   r¥   r—   )
r
   rI   r˜   r™   r   r   Úuniquere   r­   rJ   )r@   r'   r   rf   rœ   rg   rT   s          r   Útest_pivot_with_interval_indexÚ-TestPivotTable.test_pivot_with_interval_index7  s�   € ä˜_°1Ñ5Ó6ˆàAˆÜ×'Ò'¬¸SÓAØ—^‘^¨#°cÀ&�^ÐIˆF÷ BäØ�#ˆJœe O×$:Ñ$:Ó$<À3ÑGñ
ˆö Ø—‘¤uÓ-ˆHÜ
×Ò˜f hÕ/÷ BÕAús   ªBÂ
B(c           
      ó<  • [         R                  R                  / SQ/ SQ5      n[        [        R
                  " SSS[        R                  S9/ SQ[        USS	9R                  S
S9S.5      nSn[        R                  " [        US9   [        USSSSSS9nS S S 5        WS   n[        / SQ[        [         R                  " SS5      [         R                  " SS5      S/SS9S[        R                  S9n[        R                   " XV5        g ! , (       d  f       N{= f)N©r   r   r   r   ©r   r   r4   r4   r   r   rº   ©Údtype©rl   rm   rl   rm   Tr¤   F)Ú	ascendingr£   r�   r‘   r8   r7   r6   r`   ©rE   rF   rD   ra   ÚmarginsÚAll)r   é   é
   r   r4   r¥   )rE   rN   rË   )r!   r"   r#   r
   r<   ÚarangeÚintpr	   Úsort_valuesrI   r˜   r™   r   r   r   ÚIntervalÚassert_series_equal)r@   Úordered_catrf   rœ   Ú	pivot_tabrg   rT   s          r   Ú&test_pivot_with_interval_index_marginsÚ5TestPivotTable.test_pivot_with_interval_index_marginsE  sù   € ä×&Ñ&×2Ñ2²<ÂÓNˆÜä—Y’Y˜q ! R¬r¯w©wÑ7Ú)Ü  °dÑ;×GÑGØ#ð Hð ñó
ˆð BˆÜ×'Ò'¬¸SÓAÜ#Ø˜# s°3ÀÈtñˆI÷ Bð
 ˜5Ñ!ˆÜÚÜœŸš Q¨Ó*¬B¯KªK¸¸1Ó,=¸uÐEÈCÑPØÜ—'‘'ñ	
ˆô 	×Ò˜vÕ0÷ BÕAús   Â	DÄ
Dc                 óœ   • UR                  SUR                  UR                  S9nUR                  SSSS9n[        R                  " X#5        g )Nr9   r«   r6   r8   )r   r6   r8   rI   rJ   ©r@   rA   rg   rT   s       r   Útest_pass_arrayÚTestPivotTable.test_pass_arraya  sF   € Ø×!Ñ! #¨T¯V©V¸T¿V¹VÐ!ÐDˆØ×#Ñ# C¨s¸CÐ#Ð@ˆÜ
×Ò˜fÕ/r   c                 ó¤   • UR                  SS UR                  S9nUR                  SUR                  S-  SS9n[        R                  " X#5        g )Nr9   c                 ó   • U S-  $ )Nr[   © ©rp   s    r   Ú<lambda>Ú3TestPivotTable.test_pass_function.<locals>.<lambda>g  s   € °q¸A²vr   r«   r[   r8   )r   r8   rE   rI   rJ   rÝ   s       r   Útest_pass_functionÚ!TestPivotTable.test_pass_functionf  sK   € Ø×!Ñ! #Ñ-=ÀtÇvÁvÐ!ÐNˆØ×#Ñ# C¨t¯z©z¸Q©ÈÐ#ÐLˆÜ
×Ò˜fÕ/r   c                 ó²   • SS/nSn[        XUS9nUR                  X#/-   5      R                  S5      R                  5       n[        R
                  " XE5        g )Nr6   r7   r8   r«   rH   )r   rO   rP   rQ   rI   rJ   )r@   rA   rE   rF   rR   rT   s         r   Útest_pivot_table_multipleÚ(TestPivotTable.test_pivot_table_multiplek  sQ   € Ø�c�
ˆØˆÜ˜D°wÑ?ˆØ—<‘< ¨	Ñ 1Ó2×6Ñ6°vÓ>×FÑFÓHˆÜ
×Ò˜eÕ.r   c           	      ó@  • [        / SQ/ SQ/ SQS.5      nUR                  S   S:X  d   e[        USS/S/S	S
S9nUR                  n[        [        R
                  " S5      /S-  [        [        S5      SS9S9n[        R                  " X45        [        / SQ/ SQ/ SQS.5      nUR                  S   S:X  d   e[        USS/S/S	SS9nUR                  n[        [        R
                  " S5      /S-  [        [        S5      SS9S9n[        R                  " X45        g )N)ÚcatÚbatrì   rí   r�   rÌ   )rl   ÚvÚirî   Úint64rl   rï   r   r`   )rD   rE   rF   rb   ra   r4   Úabr¥   r—   )ç      ø?ç      @ç      @ç      @Úfloat64rH   )
r
   Údtypesr   r   r<   rË   r   rd   rI   r×   )r@   Úfrr   rg   rT   s        r   Útest_pivot_dtypesÚ TestPivotTable.test_pivot_dtypesr  s  € äâ1Ú!Ú)ñó
ˆð �x‰x˜‰} Ó'Ð'Ð'äØ�c # °°À!ÈUñ
ˆð —‘ˆÜœ2Ÿ8š8 GÓ,Ð-°Ñ1¼¼tÀD»zÐPSÑ9TÑUˆÜ
×Ò˜vÔ0ô â1Ú)Ú)ñó
ˆð �x‰x˜‰} 	Ó)Ð)Ð)äØ�c # °°À!ÈVñ
ˆð —‘ˆÜœ2Ÿ8š8 IÓ.Ð/°!Ñ3¼5ÄÀdÃÐRUÑ;VÑWˆÜ
×Ò˜vÕ0r   zcolumns,valuesÚbool1Úfloat1Úfloat2)rü   rý   rû   Úbool2c                 óD  • [         R                  " S[         R                  S9n[        X3S-   US:*  US:*  S.5      nUR	                  5       R                  SXS9n[        UR                  5      nU Vs0 s H  ow[         R                  " S	5      _M     nnXh:X  d   eg s  snf )
Nr[   rÊ   r”   r4   r   )rü   rý   rû   rþ   rE   ©rE   rF   rD   rö   )	r<   rÓ   rö   r
   Úreset_indexr   Údictr÷   rË   )	r@   rF   rD   rî   rf   Údf_resrg   ÚcolrT   s	            r   Útest_pivot_preserve_dtypesÚ)TestPivotTable.test_pivot_preserve_dtypes•  s�   € ô �IŠI�aœrŸz™zÑ*ˆÜØ¨¡G°a¸1±fÀqÈAÁvÑNó
ˆð —‘Ó!×-Ñ-Ø 7ð .ð 
ˆô �f—m‘mÓ$ˆÙ8>Ó?º°œŸš )Ó,Ò,¹ˆÐ?ØÓ!Ð!Ñ!ùò @s   Á3 Bc           	      ó  • [         R                  " / SQ5      n[        S/ SQ0US9nUR                  UR                  R
                  UR                  R                  S9n[        R                  " SS/5      nUR                  UR                  S   R                  [        R                  5      SS	9n[        S
S/S[        R                  //[        SS/[        R                  S9US9n[         R"                  " X55        [        / SQ[%        SSSS9S.US9nUR                  UR                  R
                  ['        SSS9S9n[        R(                  " S/[         R                  " S/SS9/S S/S9n[        SS/[        SS/[        R                  S9US9n[         R"                  " X55        UR                  ['        SS9['        SSS9S9n[        S/[         R                  " S/SS9US9n[         R"                  " X55        g )N)ú
2011-01-01z
2011-02-01ú
2011-01-02r  r	  r6   rZ   r—   r«   )r6   r   )r6   r4   r   )Úlevelró   r–   r”   r4   rÊ   r  r9   r[   )ÚfreqÚperiods)r6   Údtr  ÚME)Úkeyr  z
2011-01-31zM8[ns]r‚   ç      
@ÚYE©r  r•   z
2011-12-31)r!   ÚDatetimeIndexr
   r   rE   r€   Údayr   rƒ   Ú
set_levelsÚlevelsre   r<   Úint32r»   r   rI   rJ   r   r   r#   )r@   Úidxrf   ÚresÚexp_columnsÚexps         r   Útest_pivot_no_valuesÚ#TestPivotTable.test_pivot_no_values¬  sß  € ä×ÒÚRó
ˆô ˜š_Ð-°SÑ9ˆØ�n‰n 2§8¡8§>¡>¸2¿8¹8¿<¹<ˆnÐHˆä ×,Ò,¨h¸Ð-AÓBˆØ!×,Ñ,Ø×Ñ˜qÑ!×(Ñ(¬¯©Ó2¸!ð -ð 
ˆô Ø�3ˆZ˜#œrŸv™v˜Ð'Ü˜˜A˜¤b§h¡hÑ/Øñ
ˆô
 	×Ò˜cÔ'äâ$Ü  °CÀÑCñð ñ
ˆð �n‰n 2§8¡8§>¡>¼7ÀtÐRVÑ;WˆnÐXˆÜ ×,Ò,ØˆU”B×$Ò$ l ^¸8ÑDÐEØ˜�,ñ
ˆô Ø�3ˆKœu a¨ V´2·8±8Ñ<Àkñ
ˆô 	×Ò˜cÔ'à�n‰nÜ˜tÑ$¬g¸$ÀTÑ.Jð ð 
ˆô ØˆEÜ×"Ò" L >¸Ñ=Øñ
ˆô
 	×Ò˜cÕ'r   c                 óŒ   • [        USS/SSS/SS9n[        UR                  S/S	S
9SSS/SS9n[        R                  " X#5        g )Nr9   r:   r6   r7   r8   r   )rD   rE   rF   rb   r;   r   ©Úaxis)rE   rF   rb   )r   ÚdroprI   rJ   rÝ   s       r   Útest_pivot_multi_valuesÚ&TestPivotTable.test_pivot_multi_valuesÚ  sX   € ÜØ˜#˜s˜¨3¸¸c¸
Èqñ
ˆô Ø�I‰I�s�e !ˆIÐ$¨C¸#¸s¸ÐPQñ
ˆô 	×Ò˜fÕ/r   c                 ó  ^• U4S jnU" SS/5      nU" S5      nU" S5      n[        XE/SS/SS9n[        R                  " X65        U4S jnU" SS/5      nU" S5      nU" S5      n[        XE/SS/SS9n[        R                  " X65        g )Nc                 ó&   >• [        TSS/SS/SU S9$ )Nr9   r:   r6   r7   r8   ©rD   rE   rF   ra   r   ©ÚfuncrA   s    €r   rä   Ú;TestPivotTable.test_pivot_multi_functions.<locals>.<lambda>ä  s   ø€ œØ˜#˜s˜¨C°¨:¸sÈDò
r   rH   Ústdr   )Úkeysr   c           	      ó(   >• [        TSS/SS/SU SS9$ )Nr9   r:   r6   r7   r8   T)rD   rE   rF   ra   rÏ   r   r'  s    €r   rä   r)  î  s$   ø€ œØØ˜�:Ø˜�*ØØØò
r   )r   rI   rJ   )r@   rA   rø   rg   ÚmeansÚstdsrT   s    `     r   Útest_pivot_multi_functionsÚ)TestPivotTable.test_pivot_multi_functionsã  s™   ø€ ô
ˆñ �F˜E�?Ó#ˆÙ�&“	ˆÙ�‹xˆÜ˜5˜-¨v°u¨oÀAÑFˆÜ
×Ò˜fÔ/ô
ˆñ �F˜E�?Ó#ˆÙ�&“	ˆÙ�‹xˆÜ˜5˜-¨v°u¨oÀAÑFˆÜ
×Ò˜fÕ/r   ÚmethodTFc           	      ó   • [         R                  n[        SSUS// SQ/ SQS.5      nU(       a  UR                  SSS	S
9nO[        R                  " USSS	S
9n[        X"SU/SX"U/USX"/X"US//[        USSS/SS9[        / SQSS9S9n[        R                  " XE5        [        R                  " UR                  SSS	S
9UR                  5        g )NÚR1ÚR2ÚR4)ÚC1ÚC2ÚC3ÚC4)rÒ   é   é   é   rk   rl   rm   rn   r   r;  rÒ   r:  r<  r¥   r«   )	r<   r»   r
   Úpivotr!   r   rI   rJ   rw   )r@   r1  r»   rf   rg   rT   s         r   Útest_pivot_index_with_nanÚ(TestPivotTable.test_pivot_index_with_nanü  så   € ô �f‰fˆÜà˜D # tÐ,Ú-Ú%ñó
ˆö Ø—X‘X C°¸S�XÐA‰Fä—X’X˜b¨°SÀÑEˆFÜà˜2˜sÐ#Ø�S˜sÐ#Ø�b˜#Ð#Ø˜3 Ð#ð	ô ˜˜d D¨$Ð/°cÑ:ÜÒ2¸Ñ=ñ	
ˆô 	×Ò˜fÔ/Ü
×Ò˜bŸh™h¨S¸#Àc˜hÐJÈHÏJÉJÕWr   c                 ó.  • [        [        SSSS9S[        R                  " S5      -   S.5      nUS   [        R
                  " S5      -
  US	'   [        R                  =UR                  S
'   UR                  S'   [        R                  =UR                  S'   UR                  S'   U(       a  UR                  SS	SS9nO[        R                  " USS	SS9nUR                  5       R                  R                  5       [        U5      :X  d   eUR                  5        H%  u  pEUR                  US   US	   4   US   :X  a  M%   e   U(       a  UR                  S	SSS9nO[        R                  " US	SSS9n[        R                  " XcR                   5        g )Nz
2014-02-01é   r9   )r  r  éd   )rl   rn   rl   z
2014-02-02rm   )r   rl   )r   rl   ©r   rm   )r   rm   rn   r   )r
   r   r<   rÓ   r!   Ú	Timestampr»   Úlocr=  ÚnotnarD   r`   rK   ÚiterrowsrI   rJ   rw   )r@   r1  rf   ÚpvÚ_Úrowrg   s          r   Útest_pivot_index_with_nan_datesÚ.TestPivotTable.test_pivot_index_with_nan_dates  sS  € ô ä °a¸cÑBØœ2Ÿ9š9 Q›<Ñ'ñó
ˆð �S‘'œBŸLšL¨Ó6Ñ6ˆˆ3‰Ü*,¯&©&Ð0ˆ�‰ˆv‰˜Ÿ™ ™Ü*,¯&©&Ð0ˆ�‰ˆv‰˜Ÿ™ ™æØ—‘ ¨S¸�Ð=‰Bä—’˜" C°¸SÑAˆBØ�x‰x‹z× Ñ ×$Ñ$Ó&¬#¨b«'Ó1Ð1Ð1à—k‘k–m‰FˆAØ—6‘6˜#˜c™( C¨¡HÐ,Ñ-°°S±Õ9Ð9Ð9ñ $ö Ø—X‘X C°¸S�XÐA‰Fä—X’X˜b¨°SÀÑEˆFÜ
×Ò˜f§d¡dÕ+r   c                 óÈ  • [        [        R                  " [        SSSSS5      [        SSSSS5      [        SSSSS5      [        SSSSS5      /SU S3S9[        R                  " [        S	SSSS5      [        S	SSSS5      [        S	SSSS5      [        S	SSSS5      /SU S
3S9[        R
                  " SSS9[        R
                  " SSS9S.5      n[        / SQ5      n[        R                  " SS/S-  SSU S
3S9n[        R                  " XE/5      n[        R                  " SS/SSU S3S9n[        / SQ/ SQ/UUS9nU(       a  UR                  SSS9n	O[        R                  " USSS9n	[        R                  " X˜5        [        SS/SS//UUS S S9nU(       a  UR                  SSSS9n	O[        R                  " USSSS9n	[        R                  " X˜5        g )NéÝ  r   r¢   r   r4   zM8[z, US/Pacific]rÊ   éÞ  z, Asia/Tokyo]r   rð   )Údt1Údt2Údata1Údata2©rR  rR  rS  rS  z2014/01/01 09:00z2014/01/02 09:00rQ  ©rN   rË   z2013/01/01 09:00z2013/01/02 09:00rP  ©r   r4   r   r4   ©r   r   r   r   r«   r   rR  r   )r
   r!   r  r   r<   rÓ   r   r   r#   r=  rI   rJ   )
r@   r1  Úunitrf   Úexp_col1Úexp_col2Úexp_colÚexp_idxrT   rH  s
             r   Útest_pivot_with_tzÚ!TestPivotTable.test_pivot_with_tz4  s  € ô ä×'Ò'ä   q¨!¨Q°Ó2Ü   q¨!¨Q°Ó2Ü   q¨!¨Q°Ó2Ü   q¨!¨Q°Ó2ð	ð   ˜v ]Ð3ñô ×'Ò'ä   q¨!¨Q°Ó2Ü   q¨!¨Q°Ó2Ü   q¨!¨Q°Ó2Ü   q¨!¨Q°Ó2ð	ð   ˜v ]Ð3ñô Ÿš 1¨GÑ4ÜŸš 1¨GÑ4ñ)ó
ˆô2 Ò=Ó>ˆÜ×#Ò#ØÐ!3Ð4°qÑ8ØØ˜�v˜]Ð+ñ
ˆô
 ×(Ò(¨(Ð)=Ó>ˆÜ×"Ò"ØÐ!3Ð4ØØ˜�v˜]Ð+ñ
ˆô
 Úš<Ð(ØØñ
ˆö Ø—‘ ¨u�Ð5‰Bä—’˜" E°5Ñ9ˆBÜ
×Ò˜bÔ+äØ�ˆV�a˜�VÐØØ˜R˜a�Lñ
ˆö Ø—‘ ¨u¸W�ÐE‰Bä—’˜" E°5ÀÑIˆBÜ
×Ò˜bÕ+r   c                 óê  • [        S[        R                  " SSS9S.S[        R                  " SSS9S.S[        R                  " SSS9S.S[        R                  " SSS9S.S[        R                  " S	SS9S./5      nUR                  S
5      R	                  5       nUR
                  R                  S 5      n[        UR                  S
5      R	                  5       S
S/U/SS9n[        [        R                  " SSS9[        R                  " SSS9//[        S/SS9[        R                  " [        R                  " SSS9[        R                  " SSS9/S
S9S9n[        R                  " X45        g )NÚaaz2016-08-12 13:00:00-0700z
US/Pacific)Útz)ÚuidÚtsz2016-08-12 08:00:00-0700z2016-08-12 14:00:00-0700z2016-08-25 11:00:00-0700z2016-08-25 13:00:00-0700rc  c                 ó&   • U R                  SSSSS9$ )Nr   )ÚhourÚminuteÚsecondÚmicrosecond)Úreplacerã   s    r   rä   Ú8TestPivotTable.test_pivot_tz_in_values.<locals>.<lambda>�  s   €  1§9¡9°!¸AÀaÐUV 9Ñ#Wr   rb  Úminr&  r¥   z2016-08-12 00:00:00z2016-08-25 00:00:00r«   )r
   r!   rD  Ú	set_indexr  rc  Úmapr   r   r  rI   rJ   )r@   rf   Úminsrg   rT   s        r   Útest_pivot_tz_in_valuesÚ&TestPivotTable.test_pivot_tz_in_valuest  ss  € äð  ÜŸ,š,Ð'AÀlÑSñð
  ÜŸ,š,Ð'AÀlÑSñð
  ÜŸ,š,Ð'AÀlÑSñð
  ÜŸ,š,Ð'AÀlÑSñð
  ÜŸ,š,Ð'AÀlÑSñð#ó
ˆð2 �\‰\˜$Ó×+Ñ+Ó-ˆØ�u‰u�y‰yÑWÓXˆäØ�L‰L˜Ó×*Ñ*Ó,ØØ�'Ø�FØñ
ˆô ô —L’LÐ!;ÀÑMÜ—L’LÐ!;ÀÑMððô ˜˜ UÑ+Ü×$Ò$ä—L’LÐ!6¸<ÑHÜ—L’LÐ!6¸<ÑHðð ññ
ˆô  	×Ò˜fÕ/r   c           
      ó*  • [        [        R                  " SS5      [        R                  " SS5      [        R                  " SS5      [        R                  " SS5      /[        R                  " SS5      [        R                  " SS5      [        R                  " SS5      [        R                  " SS5      /[        R                  " SSS	9[        R                  " SSS	9S
.5      n[        / SQ5      n[        R                  " SS/S-  SSS9n[        R                  " X4/5      n[        / SQ/ SQ/[        R                  " SS/SSS9US9nU(       a  UR                  SSS9nO[        R                  " USSS9n[        R                  " Xv5        [        SS/SS//[        R                  " SS/SSS9[        R                  " SS/SSS9S9nU(       a  UR                  SSSS9nO[        R                  " USSSS9n[        R                  " Xv5        g )Nz
2013-01-01r9   z
2013-01-02z2013-01ÚMz2013-02r   rð   rÊ   )Úp1Úp2rR  rS  rT  r4   rt  )rN   r  rV  rW  rs  r«   r   r   r   rR  r   )r
   r!   ÚPeriodr<   rÓ   r   ÚPeriodIndexr   r#   r=  rI   rJ   )r@   r1  rf   rY  rZ  r[  rT   rH  s           r   Útest_pivot_periodsÚ!TestPivotTable.test_pivot_periods«  sÉ  € äô —I’I˜l¨CÓ0Ü—I’I˜l¨CÓ0Ü—I’I˜l¨CÓ0Ü—I’I˜l¨CÓ0ð	ô —I’I˜i¨Ó-Ü—I’I˜i¨Ó-Ü—I’I˜i¨Ó-Ü—I’I˜i¨Ó-ð	ô Ÿš 1¨GÑ4ÜŸš 1¨GÑ4ñó
ˆô& Ò=Ó>ˆÜ—>’> 9¨iÐ"8¸1Ñ"<À4ÈcÑRˆÜ×(Ò(¨(Ð)=Ó>ˆÜÚš<Ð(Ü—.’. ,°Ð!=ÀDÈsÑSØñ
ˆö
 Ø—‘ ¨d�Ð3‰Bä—’˜" D°$Ñ7ˆBÜ
×Ò˜bÔ+äØ�ˆV�a˜�VÐÜ—.’. ,°Ð!=ÀDÈsÑSÜ—N’N I¨yÐ#9ÀÈ3ÑOñ
ˆö
 Ø—‘ ¨d¸7�ÐC‰Bä—’˜" D°$¸wÑGˆBÜ
×Ò˜bÕ+r   c           
      ó®  • [        / SQ[        R                  " S5      [        R                  " S5      [        R                  " S5      [        R                  " S5      /SS.5      n[        S[        / SQSS9[        [        R                  " S5      [        R                  " S5      S	/S
S9S9nUR	                  SS
SSS9n[
        R                  " X#5        g )NrÉ   Ú2019Q1Ú2019Q2r“   )rl   rm   rp   ©r   r4   rÐ   rl   r¥   rÐ   rm   ©rA   rE   rF   rp   T)rE   rF   rD   rÏ   )r
   r!   ru  r   r   rI   rJ   )r@   rf   rT   rg   s       r   Útest_pivot_periods_with_marginsÚ.TestPivotTable.test_pivot_periods_with_marginsÙ  s±   € äâ!ä—I’I˜hÓ'Ü—I’I˜hÓ'Ü—I’I˜hÓ'Ü—I’I˜hÓ'ð	ð ñ	ó
ˆô ØÜš¨CÑ0Üœ2Ÿ9š9 XÓ.´·	²	¸(Ó0CÀUÐKÐRUÑVñ
ˆð —‘ c°3¸sÈD�ÐQˆÜ
×Ò˜hÕ/r   rD   ÚbazÚzooc                 ód  • [        / SQ/ SQ/ SQ/ SQS.5      nU(       a  UR                  SSUS9nO[        R                  " USSUS9n/ S	Q/ S
Q/n[        SS/SS9n[	        SS// SQ// SQ/ SQ/S S/S9n[        XVUS9nUS   R                  [        5      US'   [        R                  " XH5        g )N©r0   r0   r0   r1   r1   r1   ©r6   r7   r8   r6   r7   r8   ©r   r4   r   r   r[   rA  ©rp   rq   rr   ÚqÚwÚt©r-   r.   r€  r�  r-   r.   r   )r   r4   r   rp   rq   rr   )r   r[   rA  r‡  rˆ  r‰  r0   r1   ©rA   rN   r€  r�  r£   )r   r   r   r   r   r   )r   r   r4   r   r   r4   ©r  r½   rL   r}  )	r
   r=  r!   r   r   re   ÚobjectrI   rJ   ©	r@   rD   r1  rf   rg   rA   rE   rF   rT   s	            r   Ú test_pivot_with_list_like_valuesÚ/TestPivotTable.test_pivot_with_list_like_valuesñ  sÁ   € ô âAÚ5Ú)Ú5ñ	ó
ˆö Ø—X‘X E°5À�XÐH‰Fä—X’X˜b¨°uÀVÑLˆFâ(Ò*BÐCˆÜ˜E 5˜>°Ñ6ˆÜØ˜E�N¢OÐ4Ú%Ò'9Ð:Ø˜�-ñ
ˆô
  $¸WÑEˆØ" 5™/×0Ñ0´Ó8ˆ�‰Ü
×Ò˜fÕ/r   r.   c           	      óä  • [        / SQ/ SQ/ SQ/ SQS.5      nU(       a  UR                  SSUS9nO[        R                  " USSUS9n[        R                  S	[        R                  S
/[        R                  S[        R                  S/[        R                  S[        R                  S/S	[        R                  S[        R                  /S[        R                  S[        R                  /S[        R                  S[        R                  //n[        / SQSS9n[        SS/SS/// SQ/ SQ/S S/S9n[        XVUS9nUS   R                  [        5      US'   [        R                  " XH5        g )Nrƒ  r„  r…  r†  rŠ  r�  r-   r   r6   r   r8   rA  r7   r[   r   r4   r   )r‡  r‰  rˆ  rp   rq   rr   r‹  r.   r€  r0   r1   rÈ   ©r   r   r   r   rŒ  r}  )r
   r=  r!   r<   r»   r   r   re   r�  rI   rJ   rŽ  s	            r   Ú%test_pivot_with_list_like_values_nansÚ4TestPivotTable.test_pivot_with_list_like_values_nans  s9  € ô âAÚ5Ú)Ú5ñ	ó
ˆö Ø—X‘X E°5À�XÐH‰Fä—X’X˜b¨°uÀVÑLˆFô �V‰V�Sœ"Ÿ&™& !Ð$Ü�V‰V�Sœ"Ÿ&™& !Ð$Ü�V‰V�Sœ"Ÿ&™& !Ð$Ø”"—&‘&˜!œRŸV™VÐ$Ø”"—&‘&˜!œRŸV™VÐ$Ø”"—&‘&˜!œRŸV™VÐ$ð
ˆô Ò9ÀÑFˆÜØ˜E�N U¨E NÐ3Ú¢Ð.Ø˜�-ñ
ˆô
  $¸WÑEˆØ" 5™/×0Ñ0´Ó8ˆ�‰Ü
×Ò˜fÕ/r   c                 ó¸   • [        / SQ/ SQ/ SQS.5      nSn[        R                  " [        US9   UR	                  SSS9  S S S 5        g ! , (       d  f       g = f)	Nrk   rs   r\   z=pivot\(\) missing 1 required keyword-only argument: 'columns'r‘   r]   r_   )rE   rD   ©r
   ÚpytestÚraisesÚ	TypeErrorr=  )r@   rf   rœ   s      r   Ú#test_pivot_columns_none_raise_errorÚ2TestPivotTable.test_pivot_columns_none_raise_errorB  sB   € ä¢ºÊIÑVÓWˆØNˆÜ�]Š]œ9¨CÓ0Ø�H‰H˜6¨&ˆHÑ1÷ 1×0Ö0ús   ±AÁ
AzBMultiIndexed unstack with tuple names fails with KeyError GH#19966©Úreasonc                 óz  • [        / SQS9n/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/n[        S	S
/SS/// SQ/ SQ/S9n[        X2USS9nU(       a  UR                  SSSS9nO[        R                  " USSSS9n[        SS/SS/S9[        SS/SS/S9[        SS/SS/S9S.n[        U5      n[        R                  " Xg5        g ) N©r   r   r4   r   r   r[   )rA   )r0   r6   r   rp   )r0   r7   r4   rq   )r0   r8   r   rr   )r1   r6   r   r‡  )r1   r7   r[   rˆ  )r1   r8   rA  r‰  r.   r€  Úfirstrg  rÈ   r’  )r  r½   r�  )rA   rE   rF   rË   )r.   r   )r.   rg  )r€  r   r   r   r   r0   r1   r—   r4   r[   r   rA  r£   )r   r   r
   r=  r!   r   rI   rJ   )r@   r1  rE   rA   rF   rf   rg   rT   s           r   Útest_pivot_with_multiindexÚ)TestPivotTable.test_pivot_with_multiindexI  sð   € ô Ò-Ñ.ˆâ Ú Ú Ú Ú Ú ð
ˆô Ø˜E�N W¨hÐ$7Ð8Ú¢Ð.ñ
ˆô ˜D°wÀhÑOˆÞØ—X‘XØ&Ø)Ø'ð ð ‰Fô —X’XØØ&Ø)Ø'ñ	ˆFô ˜˜A˜ u¨e nÑ5Ü˜˜A˜ u¨e nÑ5Ü˜˜A˜ u¨e nÑ5ñ
ˆô
 ˜T“?ˆÜ
×Ò˜fÕ/r   c                 óú   • [        / SQ/ SQ/ SQ/ SQS.5      n[        R                  " [        SS9   U(       a  UR	                  SS	S
S9  O[
        R                  " USS	S
S9  S S S 5        g ! , (       d  f       g = f)Nrƒ  r„  r…  r†  rŠ  z^\('bar', 'baz'\)$r‘   r�  r-   )r.   r€  r   )r
   r—  r˜  ÚKeyErrorr=  r!   )r@   r1  rf   s      r   Útest_pivot_with_tuple_of_valuesÚ.TestPivotTable.test_pivot_with_tuple_of_valuess  sd   € ô âAÚ5Ú)Ú5ñ	ó
ˆô �]Š]œ8Ð+@ÓAæØ—‘˜u¨e¸N�ÒKä—’˜ 5°%ÀÒO÷ B×AÖAús   ²1A,Á,
A:r6   r7   r8   rÐ   c                 ó  • UR                   UR                  S S U4   nUR                  U5      U   R                  5       n[        R
                  " XxSS9  UR                  U:X  d   eUR                  5       nUR                   US4   R                  S S n	UR                  U5      U   R                  5       n
[        R
                  " XšSS9  U	R                  US4:X  d   eUR                   US4U4   nX2   R                  5       nX¼:X  d   eg )Nrº   F©Úcheck_namesÚ )	rE  rE   rO   rH   rI   r×   rN   Ú
sort_indexÚiloc)r@   rg   Ú
values_colrA   rE   rF   Úmargins_colÚcol_marginsÚexpected_col_marginsÚindex_marginsÚexpected_ix_marginsÚgrand_total_marginsÚexpected_total_marginss                r   Ú_check_outputÚTestPivotTable._check_output…  s  € ð —j‘j §¡¨c¨rÐ!2°KÐ!?Ñ@ˆØ#Ÿ|™|¨EÓ2°:Ñ>×CÑCÓEÐÜ
×Ò˜{ÈeÒTØ×Ñ ;Ó.Ð.Ð.à×"Ñ"Ó$ˆØŸ
™
 K°Ð#4Ñ5×:Ñ:¸3¸BÐ?ˆà"Ÿl™l¨7Ó3°JÑ?×DÑDÓFÐÜ
×Ò˜}ÈuÒUØ×!Ñ! k°2Ð%6Ó6Ð6Ð6à$Ÿj™j¨+°rÐ):¸KÐ)GÑHÐØ!%Ñ!1×!6Ñ!6Ó!8ÐØ"Ó<Ð<Ñ<r   c           	      ó4  • UR                  SSS/SSSS9nU R                  USU5        UR                  SSS/SSSSS	9nU R                  USUSS
9  UR                  SS/SSSS9nUR                  R                  S    H  nU R                  X4   XA5        M     g )Nr9   r6   r7   r8   TrH   )rD   rE   rF   rÏ   ra   ÚTotals)rD   rE   rF   rÏ   ra   Úmargins_name)r®  ©rE   rF   rÏ   ra   r   )r   rµ  rF   r  )r@   rA   rg   rR   Ú	value_cols        r   Útest_marginsÚTestPivotTable.test_marginsž  sÒ   € à×!Ñ!Ø˜s C˜j°#¸tÈVð "ð 
ˆð 	×Ñ˜6 3¨Ô-ð ×!Ñ!ØØ˜�*ØØØØ!ð "ð 
ˆð 	×Ñ˜6 3¨¸(ÐÑCð × Ñ Ø˜�* c°4Àð !ð 
ˆð Ÿ™×-Ñ-¨aÔ0ˆIØ×Ñ˜uÑ/°ÖAò 1r   c                 ó  • UR                    Vs/ s H  o3S-  PM	     snUl         [        R                  " S5      nU(       a  Sn[        R                  " [
        US9   UR                  SS/SSS	9  S S S 5        UR                  S
S9R                  SS/SSS	9nUR                    H,  nUR                  SU4   nXqU   R                  5       :X  a  M,   e   [        R                  " [
        US9   UR                  SS/SSS	9  S S S 5        UR                  S
S9R                  SS/SSS	9nS H,  nUR                  SU4   nXqU   R                  5       :X  a  M,   e   g s  snf ! , (       d  f       N÷= f! , (       d  f       Nw= f)Nr4   ú&agg function failed [how->mean,dtype->ú-dtype 'str' does not support operation 'mean'r‘   ÚAAÚBBTrH   )rE   rÏ   ra   ÚCCr¬   ©rÐ   rª  )ÚDDÚEEÚFF)
rF   ÚreÚescaper—  r˜  r™  r   r!  rE  rH   )	r@   rA   Úusing_infer_stringÚkrœ   rR   r»  ÚtotalsÚitems	            r   Útest_no_colÚTestPivotTable.test_no_col·  sp  € ð (,§|¢|Ó4¢| !˜Aœ¡|Ñ4ˆŒÜ�iŠiÐ@ÓAˆÞØAˆCÜ�]Š]œ9¨CÓ0Ø×Ñ D¨$ <¸ÀvÐÑN÷ 1à—	‘	 $�	Ð'×3Ñ3Ø˜�,¨°fð 4ð 
ˆð ŸœˆIØ—Y‘Y˜{¨IÐ5Ñ6ˆFØ )™_×1Ñ1Ó3Õ3Ð3Ð3ñ 'ô �]Š]œ9¨CÓ0Ø×Ñ D¨$ <¸ÀvÐÑN÷ 1à—	‘	 $�	Ð'×3Ñ3Ø˜�,¨°fð 4ð 
ˆó 'ˆDØ—Y‘Y˜{¨DÐ0Ñ1ˆFØ $™ZŸ_™_Ó.Õ.Ð.Ð.ò 'ùò% 5÷ 1Õ0ú÷ 1Õ0ús   �EÁE"Ã.E3Å"
E0Å3
Fz*columns, aggfunc, values, expected_columnsrH   )ç      @rÐ  çš™™™™™@rÑ  )rª   rª   çš™™™™™@rÒ  )r.   rÐ   r-   rÐ   r¥   r`   )r¢   é   é   r[   rA  r5   )é   é   é    r5   r5   rÔ  ))r.   r0   )r.   r1   )r.   rÐ   )r-   r0   )r-   r1   )r-   rÐ   r‚   c                 óÊ  • [        / SQ/ SQ/ SQ/ SQ/ SQS.5      nUS:w  aR  [        R                  " S5      nU(       a  S	n[        R                  " [
        US
9   UR                  USUS9  S S S 5        SU;  a  UR                  SS9nUR                  SS9R                  USUS9n[        U[        SS/5      US9n	[        R                  " X‰5        g ! , (       d  f       Nn= f)N©	r-   r-   r-   r-   r-   r.   r.   r.   r.   ©	r0   r0   r0   r1   r1   r0   r0   r1   r1   ©	ÚsmallÚlargerÝ  rÜ  rÜ  rÝ  rÜ  rÜ  rÝ  ©	r   r4   r4   r   r   r   r[   rA  rÑ   ©	r4   r   r[   r[   rA  rA  é   r¢   r¢   ©r6   r7   r8   r9   r:   r`   r¿  rÀ  r‘   T)rF   rÏ   ra   r7   r¬   r8   r9   r:   r«   )r
   rÈ  rÉ  r—  r˜  r™  r   r!  r   rI   rJ   )
r@   rF   ra   rD   r°   rÊ  rf   rœ   rg   rT   s
             r   Ú%test_margin_with_only_columns_definedÚ4TestPivotTable.test_margin_with_only_columns_definedÑ  sÝ   € ôD âTÚTò
ò 1Ú0ñó
ˆð& �eÓÜ—)’)ÐDÓEˆCÞ!ØE�Ü—’œy°Ó4Ø—‘ w¸Àg�ÑN÷ 5à�gÓØ—‘ �Ð%ˆBØ—‘ �Ð%×1Ñ1Ø T°7ð 2ð 
ˆô ˜V¬5°#°s°Ó+<ÐFVÑWˆä
×Ò˜fÕ/÷ 5Õ4ús   ÁCÃ
C"c           	      óØ  • UR                  5       n[        R                  " [        U5      S-  5      R	                  [        U5      S5      R                  S5      U/ SQ'   [        [        SS/SS/5      5      S/-   n[        R                  " US	S
9n[        / SQ/ SQS.US9R                  SSS9nUS   US   -   US'   UR                  SSS/SSSSS9n[        R                  " XV5        g )Nr   Úi8)r9   r:   r;   r.   r-   r0   r1   rÄ  r·   r‚   )é   é   r   r¢   é-   )é!   r   é$   é3   éx   ©r2   r3   r—   r8   r   r  r2   r3   rÐ   r9   r6   r7   Tr`   r   ©rD   rE   rF   rÏ   ra   rb   )Úcopyr<   rÓ   rK   r   re   rd   r   r   rƒ   r
   Úrename_axisr   rI   rJ   )r@   rA   rf   Úmi_valÚmirT   rg   s          r   Útest_margins_dtypeÚ!TestPivotTable.test_margins_dtype  sò   € ð �Y‰Y‹[ˆÜ Ÿiši¬¨B«°!©Ó4×<Ñ<¼SÀ»WÀaÓH×OÑOÐPTÓUˆŠ?Ñä”g˜u e˜n¨u°e¨nÓ=Ó>À+ÀÑNˆÜ×#Ò# F°*Ñ=ˆÜÚ'Ò2FÑGÈrñ
ç
‰+�c ˆ+Ð
"ð 	ð # 6Ñ*¨X°gÑ->Ñ>ˆ�‰à—‘ØØ˜�*ØØØØð  ð 
ˆô 	×Ò˜hÕ/r   c           	      ó"  • [        [        SS/SS/5      5      S/-   n[        R                  " USS9n[	        / SQ/ S	QS
.US9R                  SSS9nUS   US   -   US'   UR                  SSS/SS[        SS9n[        R                  " XE5        g )Nr.   r-   r0   r1   rÄ  r·   r‚   )r   r   r4   r   r[   )r4   r   r4   r4   rA  rí  r—   r8   r   r  r2   r3   rÐ   r9   r6   r7   Tr   rî  )
rd   r   r   rƒ   r
   rð  r   rK   rI   rJ   )r@   rA   rñ  rò  rT   rg   s         r   Útest_margins_dtype_lenÚ%TestPivotTable.test_margins_dtype_len-  s®   € Ü”g˜u e˜n¨u°e¨nÓ=Ó>À+ÀÑNˆÜ×#Ò# F°*Ñ=ˆÜÚ$ªÑ?Àrñ
ç
‰+�c ˆ+Ð
"ð 	ð # 6Ñ*¨X°gÑ->Ñ>ˆ�‰à×!Ñ!ØØ˜�*ØØÜØð "ð 
ˆô 	×Ò˜hÕ/r   ru   ))r   r4   ©rl   rm   rC  )rl   r   c           	      óò   • [        US   / SQUS   / SQS/ SQ05      nUR                  SUS9n[        / SQ/[        R                  " / SQUS	9[	        S/US
:X  a  SOSS9S9n[
        R                  " X45        g )Nr   rs   r   rî   )r   r[   rA  )rD   rF   )r–   r©   r§   ))r   r   )r4   r4   )r   r   r‚   rø  Ústrr�  rÊ   ©rF   rE   )r
   r   r   rƒ   r   rI   rJ   )r@   ru   Údf2rg   rT   s        r   Ú test_pivot_table_multiindex_onlyÚ/TestPivotTable.test_pivot_table_multiindex_only@  s{   € ô ˜˜a™¢)¨T°!©W²iÀÂiÐPÓQˆà—‘¨°T�Ð:ˆÜÚÐÜ×*Ò*Ò+CÈ4ÑPÜ˜˜¨d°jÓ.@¡UÀhÑOñ
ˆô 	×Ò˜fÕ/r   c                 ój  • [        SSSS9n[        [        R                  R	                  S5      R                  S5      [        R                  R	                  S5      R                  S5      US.5      nUR                  SS/S	S
9nUR                  R                  S   R                  U5      (       d   eg )Nz
2016-01-01r   zEurope/Amsterdam)r  ra  r4   r£   r7   r8   F)rE   r   r   )
r   r
   r<   r=   r>   r?   r   rE   r  Úequals)r@   Údtirf   rg   s       r   Útest_pivot_table_retains_tzÚ*TestPivotTable.test_pivot_table_retains_tzN  s�   € Ü˜¨qÐ5GÑHˆÜä—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Ü—Y‘Y×*Ñ*¨1Ó-×=Ñ=¸aÓ@Øñó
ˆð —‘ s¨C j¸�Ð?ˆð �|‰|×"Ñ" 1Ñ%×,Ñ,¨S×1Ñ1Ð1Ñ1r   c                 ól  • [         R                  n[        [        SS// SQSS/[	        S5       Vs/ s H  o![        U5      -   PM     snS/5      5      n[        U5      nUR                  S/ S	QS
/S9nUR                  [        S9nUR                  S/ SQS/S9n[        R                  " XWSS9  g s  snf )Nr-   r.   r£   Úx1Úx2r<  r“   r   )r   r   r   r4   )rD   rE   rF   r¬   Ú4)Ú0Ú1Ú3Ú2Fr¨  )r   rk  rd   r   r®   r   r
   r   Úrenamerú  rI   rJ   )r@   r}   rï   rA   rf   rR   rü  rS   s           r   Útest_pivot_integer_columnsÚ)TestPivotTable.test_pivot_integer_columns\  s®   € ô �H‰HˆÜÜØ˜�ÚØ�t�Ü+0°¬9Ó5ª9 a”Y˜q“\Ô!©9Ñ5Ø�óó
ˆô �t‹_ˆØ—‘ aªyÀ1À#�ÐFˆà�i‰i¤ˆiÐ$ˆØ—‘¨²?ÈSÈE�ÐRˆä
×Ò˜e¸Ó?ùò 6s   ±B1c                 ó¢  • [        / SQS-  / SQS-  S/S-  S/S-  -   S-  [        R                  R                  S5      R	                  S5      S.5      nUR                  S	S
SS/S9nUR                  / SQ5      S	   R                  5       nUR                  S5      R                  S5      R                  SSS9n[        R                  " X$5        g )N)rl   rl   rl   rl   rm   rm   rm   rm   r4   )r   r   r   r   r   r   r   r   r-   r   r.   é   )rl   rm   rn   Úvaluer  rl   rm   rn   r«   rk   r   Úall)r   Úhow)r
   r<   r=   r>   r?   r   rO   rH   rQ   r   rI   rJ   )r@   rA   rR   ÚgroupedrT   s        r   Útest_pivot_no_level_overlapÚ*TestPivotTable.test_pivot_no_level_overlapq  sÉ   € ô â=ÀÑAÚ-°Ñ1Ø�g ‘k U G¨a¡KÑ/°1Ñ4ÜŸ™×.Ñ.¨qÓ1×AÑAÀ"ÓEñ	ó
ˆð × Ñ  °¸cÀ3¸ZÐ ÐHˆà—,‘,šÓ/°Ñ8×=Ñ=Ó?ˆØ—?‘? 3Ó'×/Ñ/°Ó4×;Ñ;ÀÈÐ;ÐNˆÜ
×Ò˜eÕ.r   c           
      óž  • Sn[         R                  " S[        4S[        4S[        4S[        4S[        4S[        4S[        4/5      n[         R
                  " / S	QS[        4S[        4/S
9n[         R                  " XS
9n[         R                  R                  S5      R                  S[        U5      U5      nUS   U   US'   US   U   US'   [        [        SSS5      [        SSS5      5      nU[         R                  R                  S5      R                  S[        U5      U5         nUR                  US'   UR                  US'   UR                  US'   [         R                  R                  S5      R!                  SSU5      US'   [#        U5      nUR%                  SSS// SQSS9n	U	R&                  R(                  (       d   eg )Ni'  r   ÚSymbolÚYearÚMonthÚDayÚQuantityÚPrice)	)ÚSP500ÚADBE)r  ÚNVDA)r  ÚORCL)ÚNDQ100ÚAAPL)r"  ÚMSFT)r"  ÚGOOG)ÚFTSEzDGE.L)r&  zTSCO.L)r&  zGSK.LrÊ   r4   r   iÐ  r   iÚ  ræ  é   r–   r”   )r   r  r  rH   ©rE   rF   ra   )r<   rË   r�  Úintr­   ÚarrayÚemptyr=   r>   ÚintegersrK   r   r   Úyearr€   r  Ú	lognormalr
   r   rF   Úis_monotonic_increasing)
r@   ÚnrË   ÚproductsÚitemsÚiproductÚdrÚdatesrf   Úpivoteds
             r   Útest_pivot_columns_lexsortedÚ+TestPivotTable.test_pivot_columns_lexsortedƒ  s°  € Øˆä—’àœ&Ð!Øœ6Ð"Øœ�Øœ#�Øœ�ØœSÐ!Øœ%Ð ðó

ˆô —8’8ò
ð œVÐ$ x´Ð&8Ð9ñ
ˆô —’˜Ñ(ˆÜ—9‘9×(Ñ(¨Ó+×4Ñ4°Q¼¸H»ÀqÓIˆØ! 'Ñ*¨8Ñ4ˆˆg‰Ø" 8Ñ,¨XÑ6ˆˆh‰Üœ˜T 1 aÓ(¬$¨t°R¸Ó*<Ó=ˆØ”2—9‘9×(Ñ(¨Ó+×4Ñ4°Q¼¸B»ÀÓCÑDˆØŸ
™
ˆˆf‰ØŸ™ˆˆg‰Ø—y‘yˆˆe‰ÜŸ™×.Ñ.¨qÓ1×;Ñ;¸CÀÀaÓHˆˆg‰ä�uÓˆà—.‘.ØØ˜EÐ"Ú/Øð	 !ð 
ˆð �‰×6×6Ð6Ñ6r   c                 óÂ   • S/S/S.nUR                  SS/5      R                  U5      R                  S5      nUR                  SSUS9n[        R
                  " XC5        g )Nr*  r`   ©r9   r:   r6   r7   r(  )rO   rP   rQ   r   rI   rJ   )r@   rA   rø   rT   rg   s        r   Útest_pivot_complex_aggfuncÚ)TestPivotTable.test_pivot_complex_aggfunc¶  s]   € Ø�'  Ñ(ˆØ—<‘<  c 
Ó+×/Ñ/°Ó2×:Ñ:¸3Ó?ˆØ×!Ñ!¨°SÀ!Ð!ÐDˆä
×Ò˜fÕ/r   c                 óŠ   • USS/   R                  SS/[        SS9nUR                  5       n[        US S 5      US   :X  d   eg )Nr6   r7   T)rE   ra   rÏ   rº   )r   rK   Útolistr`   )r@   rA   rg   Úresult_lists       r   Útest_margins_no_values_no_colsÚ-TestPivotTable.test_margins_no_values_no_cols½  sV   € à�s˜C�jÑ!×-Ñ-Ø˜�*¤c°4ð .ð 
ˆð —m‘m“oˆÜ�;˜s Ð#Ó$¨°B©Ó7Ð7Ñ7r   c                 ó‚   • U/ SQ   R                  SS/S[        SS9nUR                  R                  5       / SQ:X  d   eg )Nr£   r6   r7   r8   T©rE   rF   ra   rÏ   ©r•   r“   r–   r•   ç      &@©r   rK   rÐ   r>  ©r@   rA   rg   s      r   Útest_margins_no_values_two_rowsÚ.TestPivotTable.test_margins_no_values_two_rowsÅ  sI   € ð ’oÑ&×2Ñ2Ø˜�* c´3Àð 3ð 
ˆð �z‰z× Ñ Ó"Ò&@Ó@Ð@Ñ@r   c                 ó~   • USS/   R                  SS[        SS9nUR                  R                  5       / SQ:X  d   eg )Nr6   r7   TrC  )r–   r¨   rE  rF  rG  s      r   Ú&test_margins_no_values_one_row_one_colÚ5TestPivotTable.test_margins_no_values_one_row_one_colÍ  sI   € ð �s˜C�jÑ!×-Ñ-Ø˜s¬C¸ð .ð 
ˆð �z‰z× Ñ Ó"Ò&6Ó6Ð6Ñ6r   c                 ó”   • / SQUS'   U/ SQ   R                  SS/SS/[        SS9nUR                  R                  5       / S	Q:X  d   eg )
N)rl   rm   rn   r}   Úerø   ÚgÚhrï   ÚjrË  r9   ©r6   r7   r8   r9   r6   r7   r8   TrC  rD  rF  rG  s      r   Ú'test_margins_no_values_two_row_two_colsÚ6TestPivotTable.test_margins_no_values_two_row_two_colsÕ  sX   € ò LˆˆS‰	ØÒ*Ñ+×7Ñ7Ø˜�* s¨C j¼#Àtð 8ð 
ˆð �z‰z× Ñ Ó"Ò&@Ó@Ð@Ñ@r   Úmargin_namer-   r0   iš  Nrl   rm   c           
      ó¦  • SU S3n[         R                  " [        US9   [        USSS/S/SUS	9  S S S 5        [         R                  " [        US9   [        USS/SS/SUS	9  S S S 5        [         R                  " [        US9   [        USS/S/SUS	9  S S S 5        g ! , (       d  f       Nt= f! , (       d  f       NR= f! , (       d  f       g = f)
NzConflicting name "z3" in margins|margins_name argument must be a stringr‘   r9   r6   r7   r8   T)rD   rE   rF   rÏ   r¹  )r—  r˜  Ú
ValueErrorr   )r@   rU  rA   rœ   s       r   Ú-test_pivot_table_with_margins_set_margin_nameÚ<TestPivotTable.test_pivot_table_with_margins_set_margin_nameÞ  sÕ   € ð !  ð .5ð 5ð 	ô �]Š]œ:¨SÓ1äØØØ˜C�jØ˜ØØ(ò÷ 2ô �]Š]œ:¨SÓ1äØØØ�eØ˜c˜
ØØ(ò÷ 2ô �]Š]œ:¨SÓ1äØØØ�eØ˜ØØ(ò÷ 2Ð1÷) 2Õ1ú÷ 2Õ1ú÷ 2Õ1ús#    B ÁB1ÂCÂ 
B.Â1
B?Ã
Cc                 óV	  • [        SR                  5       SR                  5       / SQ[        SSS5      [        SSS5      [        SSS5      [        SSS5      [        SSS5      [        SSS5      [        SSS5      [        SSS5      /S	.5      R                  S
5      n[        [        R
                  " / SQSS9R                  SS5      [        R                  " [        SSS5      /SS9SR                  5       S9nS
UR                  l
        SUR                  l
        [        U[        SS9SSSS9n[        R                  " XC5        [        US[        SS9SSS9n[        R                  " XCR                   5        [        [        R
                  " S[        R"                  SSS[        R"                  /5      R                  SS5      [        R                  " [        SSS5      [        SSS5      /SS9SR                  5       S9nS
UR                  l
        SUR                  l
        U(       a  US   R%                  S5      US'   [        U[        SS9SSSS9n[        R                  " XC5        [        US[        SS9SSS9n[        R                  " XCR                   5        UR'                  5       n[        U[        SS
S9SSSS9n[        R                  " XC5        [        US[        SS
S9SSS9n[        R                  " XCR                   5        Sn[(        R*                  " [,        US9   [        U[        SS S9SSSS9  S S S 5        [(        R*                  " [,        US9   [        US[        SS S9SSS9  S S S 5        UR                  S
5      n[        U[        SS
S!9SSSS9n[        R                  " XC5        [        US[        SS
S!9SSS9n[        R                  " XCR                   5        S"n[(        R*                  " [.        US9   [        U[        SS S!9SSSS9  S S S 5        [(        R*                  " [.        US9   [        US[        SS S!9SSS9  S S S 5        g ! , (       d  f       GN(= f! , (       d  f       GN= f! , (       d  f       Nj= f! , (       d  f       g = f)#NúA A A A A A A Bú$Carl Mark Carl Carl Joe Joe Joe Carl©r   r   r[   r   rà  r   r¢   r   rN  r   rÒ   r4   ræ  )ÚBranchÚBuyerr  ÚDater`  )rÒ   rÖ  r   rð   rÊ   r   r'  r  r  zCarl Joe Markr«   r_  r  r`   ©rE   rF   rD   ra   r¢   rÖ  rÑ   Ú6MSÚCarl©r  r  z#'The grouper name foo is not found'r‘   r-   )r  r
  zThe level foo is not valid)r
   Úsplitr   rl  r<   r*  r   r!   r  rE   rN   rF   r   r   rI   rJ   rw   r»   re   r  r—  r˜  r¤  rW  )r@   Úusing_array_managerrf   rT   rg   rœ   s         r   Útest_pivot_timegrouperÚ%TestPivotTable.test_pivot_timegrouper  sT  € Üà+×1Ñ1Ó3Ø?×EÑEÓGÚ4ä˜T 1 aÓ(Ü˜T 1 aÓ(Ü˜T 2 qÓ)Ü˜T 2 qÓ)Ü˜T 2 qÓ)Ü˜T 2 qÓ)Ü˜T 2 qÓ)Ü˜T 2 qÓ)ð	ñ	ó
÷  ‰)�FÓ
ð! 	ô$ Ü�HŠH’[¨Ñ0×8Ñ8¸¸AÓ>Ü×"Ò"¤H¨T°2°rÓ$:Ð#;À$ÑGØ#×)Ñ)Ó+ñ
ˆð
 %ˆ�‰ÔØ 'ˆ×ÑÔäØÜ˜tÑ$ØØØñ
ˆô 	×Ò˜fÔ/äØØÜ Ñ&ØØñ
ˆô 	×Ò˜f§j¡jÔ1äÜ�HŠH�aœŸ™  A r¬2¯6©6Ð2Ó3×;Ñ;¸A¸qÓAÜ×"Ò"Ü˜$  1Ó%¤x°°a¸Ó';Ð<À5ñð $×)Ñ)Ó+ñ
ˆð %ˆ�‰ÔØ 'ˆ×ÑÔÞà'¨Ñ/×6Ñ6°wÓ?ˆH�VÑäØÜ˜uÑ%ØØØñ
ˆô 	×Ò˜fÔ/äØØÜ Ñ'ØØñ
ˆô 	×Ò˜f§j¡jÔ1ð �^‰^ÓˆÜØÜ˜u¨&Ñ1ØØØñ
ˆô 	×Ò˜fÔ/äØØÜ ¨FÑ3ØØñ
ˆô 	×Ò˜f§j¡jÔ1à3ˆÜ�]Š]œ8¨3Ó/ÜØÜ 5¨eÑ4ØØ!Øò÷ 0ô �]Š]œ8¨3Ó/ÜØØÜ U°Ñ6Ø!Øò÷ 0ð �\‰\˜&Ó!ˆÜØÜ˜u¨FÑ3ØØØñ
ˆô 	×Ò˜fÔ/äØØÜ ¨fÑ5ØØñ
ˆô 	×Ò˜f§j¡jÔ1à*ˆÜ�]Š]œ:¨SÓ1ÜØÜ 5°Ñ6ØØ!Øò÷ 2ô �]Š]œ:¨SÓ1ÜØØÜ U°%Ñ8Ø!Øò÷ 2Ð1÷] 0Ö/ú÷ 0Ö/ú÷< 2Õ1ú÷ 2Õ1ús0   Ì.Q%Í%Q7ÐR	ÑRÑ%
Q4Ñ7
RÒ	
RÒ
R(c                 óv	  • [        SR                  5       SR                  5       / SQ[        SSSSS5      [        SS	SSS
5      [        SSSSS5      [        SSSSS5      [        SSSSS5      [        SSSSS5      [        SSSSS5      [        SSS
SS5      /[        SSSSS5      [        SSSSS
5      [        SS	S
SS5      [        SSSSS5      [        SSSSS5      [        SS	S
SS5      [        SSSSS5      [        SSSSS5      /S.5      n[        U[	        SSS9[	        SSS9SSS9n[        [
        R                  " [
        R                  S[
        R                  [
        R                  S[
        R                  SS	[
        R                  S	[
        R                  [
        R                  [
        R                  [
        R                  S[
        R                  /5      R                  SS5      [        R                  " [        SS	S5      [        SSS5      [        SSS5      [        SSS5      /SS9[        R                  " [        SS	S5      [        SSS5      [        SSS5      [        SSS5      /SS9S 9nSUR                  l        SUR                  l        [        R                  " X#5        [        U[	        SSS9[	        SSS9SSS9n[        R                  " X#R                   5        [        SS	S5      [        SSS5      4[        SSS5      [        SS	S5      4[        SSS5      [        SSS5      4[        SSS5      [        SSS5      4[        SSS5      [        SSS5      4[        SSS5      [        SSS5      4/n["        R$                  " USS/S!9n[        [
        R                  " S[
        R                  S[
        R                  S[
        R                  S	[
        R                  S	[
        R                  [
        R                  S/5      R                  SS5      US"S#/S 9nS$UR                  l        [        U[	        SSS9[	        SSS9/S$/SSS9n[        R                  " X#5        [        US$/[	        SSS9[	        SSS9/SSS9n[        R                  " X#R                   5        g )%Nr[  r\  r]  rN  r5   r   rÓ  r   r¢   r[   rÒ   r<  r4   ræ  rÕ  r   r:  rÑ   é   )r^  r_  r  r`  ÚPayDayr  r`  rd  rk  r  r`   ra  r   rA  r'  r  r«   r‚   r6   r7   r^  )r
   re  r   r   r   r<   r*  r»   r   r!   r  rE   rN   rF   rI   rJ   rw   r   rƒ   )r@   rf   rg   rT   Útuplesr  s         r   Útest_pivot_timegrouper_doubleÚ,TestPivotTable.test_pivot_timegrouper_doubleœ  s‰  € äà+×1Ñ1Ó3Ø?×EÑEÓGÚ4ä˜T 2 q¨"¨aÓ0Ü˜T 1 a¨¨QÓ/Ü˜T 2 q¨"¨aÓ0Ü˜T 2 q¨"¨aÓ0Ü˜T 2 q¨"¨aÓ0Ü˜T 2 q¨"¨aÓ0Ü˜T 2 q¨"¨aÓ0Ü˜T 2 q¨"¨aÓ0ð	ô ˜T 2 q¨!¨QÓ/Ü˜T 2 r¨2¨qÓ1Ü˜T 1 a¨¨QÓ/Ü˜T 2 q¨"¨aÓ0Ü˜T 2 q¨"¨aÓ0Ü˜T 1 a¨¨QÓ/Ü˜T 2 r¨2¨qÓ1Ü˜T 2 r¨2¨qÓ1ð	ñó
ˆô8 ØÜ˜t¨Ñ0Ü ¨8Ñ4ØØñ
ˆô Ü�HŠHä—F‘FØÜ—F‘FÜ—F‘FØÜ—F‘FØØÜ—F‘FØÜ—F‘FÜ—F‘FÜ—F‘FÜ—F‘FØÜ—F‘Fð!ó÷& ‰g�a˜‹mÜ×"Ò"ä˜T 1 bÓ)Ü˜T 2 rÓ*Ü˜T 2 rÓ*Ü˜T 2 rÓ*ð	ð ñô ×$Ò$ä˜T 1 bÓ)Ü˜T 2 rÓ*Ü˜T 2 rÓ*Ü˜T 2 rÓ*ð	ð ññ='
ˆðP %ˆ�‰ÔØ (ˆ×ÑÔä
×Ò˜fÔ/äØÜ˜t¨Ñ2Ü ¨6Ñ2ØØñ
ˆô 	×Ò˜f§j¡jÔ1ô �d˜A˜rÓ"¤H¨T°2°rÓ$:Ð;Ü�d˜B Ó#¤X¨d°A°rÓ%:Ð;Ü�d˜B Ó#¤X¨d°B¸Ó%;Ð<Ü�d˜B Ó#¤X¨d°B¸Ó%;Ð<Ü�d˜B Ó#¤X¨d°B¸Ó%;Ð<Ü�d˜B Ó#¤X¨d°B¸Ó%;Ð<ð
ˆô ×$Ò$ V°F¸HÐ3EÑFˆÜÜ�HŠHØ”B—F‘F˜AœrŸv™v q¬"¯&©&°!´R·V±V¸QÄÇÁÌÏÉÐPQÐRóç‰g�a˜‹mØØ˜#�Jñ
ˆð !)ˆ×ÑÔäØÜ ¨&Ñ1´7ÀÈ(Ñ3SÐTØ�JØØñ
ˆô 	×Ò˜fÔ/äØØ�*Ü $¨FÑ3´WÀ$ÈHÑ5UÐVØØñ
ˆô 	×Ò˜f§j¡jÕ1r   c           
      óD  • [         R                  " / SQSSS9n[         R                  " / SQSS9n[        / SQUU[        R                  " S	S
S9SS/S-  S.5      nUS S n[        SS/5      n[        SS/SS9n[        R                  " XV/5      n[        SS/SS/SS//XGS9n[        US/S/S/S9n	[        R                  " X˜5        [        / SQ5      n[        / SQS-  5      n[         R                  " SS/S -  SS!S9n
[        R                  " XVU
/5      n[        [        R                  " / S"Q/ S#Q/ S$Q/S
S9UUS S  S9n[        [        R                  " / S%Q/ S&Q/ S'Q/5      UUS S  S9n[        X¼/SS(9n[        US/S!/SS)/S*S+/S,9n	[        R                  " X˜5        g )-N©ú2011-07-19 07:00:00ú2011-07-19 08:00:00ú2011-07-19 09:00:00rq  rr  rs  zM8[ns, US/Pacific]rP  ©rË   rN   ©ú2013-01-01 15:00:00rv  rv  ú2013-02-01 15:00:00rw  rw  zM8[ns, Asia/Tokyo]rÊ   ©rl   rl   rl   rm   rm   rm   rA  rð   r   r4   r   ©ÚlabelrP  rQ  Úvalue1Úvalue2r{  rl   rm   rz  r¥   r¦   r•   r“   r–   r”   r©   r«   r   )r`   r`   r`   r`   rH   rH   rH   rH   )r{  r{  r|  r|  rv  rw  r   rQ  )r   r   r   r4   )r   r   r4   r   )r4   r[   r   r4   )r¦   r•   r“   r”   )r“   r–   r”   r“   )r”   r©   r“   r”   r  r|  r`   rH   ra  )r!   r  r
   r<   rÓ   r   r   r#   r   rI   rJ   r*  r   )r@   Údates1Údates2rf   r\  rY  rZ  r[  rT   rg   Úexp_col3Ú	expected1Ú	expected2s                r   Útest_pivot_datetime_tzÚ%TestPivotTable.test_pivot_datetime_tz  s  € Ü×!Ò!òð 'Øñ
ˆô ×!Ò!òð 'ñ

ˆô â7ØØÜŸ)š) A¨WÑ5Ø˜a˜& 1™*ñó
ˆð ˜˜!�*ˆÜ˜( HÐ-Ó.ˆÜ˜#˜s˜¨'Ñ2ˆÜ×(Ò(¨(Ð)=Ó>ˆÜØ�3ˆZ˜#˜s˜ c¨3 ZÐ0¸ñ
ˆô ˜R¨ w¸¸	È8È*ÑUˆÜ
×Ò˜fÔ/äÒUÓVˆÜÒAÀAÑEÓFˆÜ×#Ò#Ø"Ð$9Ð:¸QÑ>Ø&Øñ
ˆô
 ×(Ò(¨(¸hÐ)GÓHˆÜÜ�HŠHòò !Ú ð	ð ñð Ø˜B˜Q�Kñ
ˆ	ô" Ü�HŠHâ(Ú(Ú(ðóð Ø˜A˜B�Kñ

ˆ	ô ˜9Ð0°qÑ9ˆäØØ�'Ø�GØ˜hÐ'Ø˜F�Oñ
ˆô 	×Ò˜fÕ/r   c                 ó¾  • [         R                  " / SQ5      n[         R                  " / SQ5      n[        / SQUU[        R                  " SSS9SS/S	-  S
.5      n[        USUS   R                  R                  SS9n[        SS/SS9n[        SS/SS/SS/S.U[        / SQ[        R                  SS9S9n[        R                  " XF5        [        X3S   R                  R                  US   R                  R                  SS9n[        SS/SS/SS/S.[        SS/[        R                  SS9[        / SQ[        R                  SS9S9n[        R                  " XF5        [        UUS   R                  R                  R                  US   R                  R                  US   R                  R                  /SS9n[        R                   " [        R"                  " / SQ[        R                  S9[        R"                  " SS/S	-  [        R                  S9/SS/S9n[        [        R"                  " / SQ/5      [        S/[        R                  S9US9n[        R                  " XF5        [        U[        R"                  " / S Q5      US   R                  R                  US   R                  R                  /SS9n[        [        R"                  " S!S	S[        R$                  S[        R$                  /[        R$                  [        R$                  [        R$                  S"[        R$                  S#//5      S$S%/US9n[        R                  " XF5        g )&Nrp  ru  rx  rA  rð   rÊ   r   r4   r   ry  rz  rP  r{  r   rl   rm   r¥   r¦   r•   r“   r–   r”   r©   )rÑ   rà  r¢   rt  r«   rQ  )rÑ   rÑ   rà  rà  r¢   r¢   r‚   )r¦   r•   r“   r–   r”   r©   rN  )ÚXr…  r…  r…  ÚYr†  r   r   r[   r…  r†  )r!   r  r
   r<   rÓ   r   r  re  r   r  rI   rJ   r€   r-  rD   r   r#   r*  r»   )r@   r}  r~  rf   rg   r\  rT   r[  s           r   Útest_pivot_dtaccessorÚ$TestPivotTable.test_pivot_dtaccessorv  sã  € ä×!Ò!òó	
ˆô ×!Ò!òó	
ˆô â7ØØÜŸ)š) A¨WÑ5Ø˜a˜& 1™*ñó
ˆô Ø�g r¨%¡y§|¡|×'8Ñ'8Àñ
ˆô ˜˜c˜
¨Ñ1ˆÜØ�c�
  S˜z¨s°C¨jÑ9ØÜš)¬2¯8©8¸%Ñ@ñ
ˆô
 	×Ò˜fÔ/äØ˜‘i—l‘l×(Ñ(°"°U±)·,±,×2CÑ2CÈHñ
ˆô Ø�c�
  S˜z¨s°C¨jÑ9Ü˜˜A˜¤b§h¡h°UÑ;Üš)¬2¯8©8¸%Ñ@ñ
ˆô
 	×Ò˜fÔ/äØØ�U‘)—,‘,×#Ñ#×*Ñ*Ø˜‘Y—\‘\×&Ñ&¨¨5©	¯©×(:Ñ(:Ð;Øñ	
ˆô ×(Ò(ä—’Ò+´2·8±8Ñ<Ü—’˜!˜Q˜ !™¬2¯8©8Ñ4ðð ˜%�.ñ
ˆô Ü�HŠHÒ4Ð5Ó6Ü˜˜¤b§h¡hÑ/Øñ
ˆô
 	×Ò˜fÔ/äØÜ—(’(Ò9Ó:Ø˜‘Y—\‘\×&Ñ&¨¨5©	¯©×(:Ñ(:Ð;Øñ	
ˆô Ü�HŠHØ�Q˜œ2Ÿ6™6 1¤b§f¡fÐ-´·±¼¿¹ÄÇÁÈÌ2Ï6É6ÐSTÐ/UÐVóð ˜�*Øñ
ˆô 	×Ò˜fÕ/r   c                 ó¦  • [        SSSS9n[        [        R                  " [	        U5      5      US9n[        [        U5      UR                  R                  UR                  R                  S9nUR                  R                  S5      Ul
        [        R                  " UR                  R                  5      n0 nUR                  R                  R                  5       R                   H7  nUR                  R                  U:H  n[        UR                  U   XG   S9XV'   M9     [        U[        S9R                   n["        R$                  " X55        g )	Nú1/1/2000ú
12/31/2004r9   r  r—   r«   r   rÊ   )r   r   r<   rÓ   rK   r   r
   rE   r-  Ú	dayofyearrF   Ú	droplevelÚasarrayrÄ   rD   r­   rw   rI   rJ   )r@   Úrngrc  rg   ÚdoyrT   rq   Úmasks           r   Ú
test_dailyÚTestPivotTable.test_dailyÑ  sò   € Ü˜ \¸Ñ<ˆÜ”B—I’Iœc #›hÓ'¨sÑ3ˆäÜ�b‹M §¡§¡¸¿¹×8JÑ8Jñ
ˆð  Ÿ™×1Ñ1°!Ó4ˆŒä�jŠj˜Ÿ™×+Ñ+Ó,ˆàˆØ—‘—‘×%Ñ%Ó'×.Ô.ˆAØ—8‘8—=‘= AÑ%ˆDÜ  §¡¨4¡¸¹	ÑBˆH‹Kñ /ô ˜X¬UÑ3×5Ñ5ˆÜ
×Ò˜fÕ/r   c                 ó¦  • [        SSSS9n[        [        R                  " [	        U5      5      US9n[        [        U5      UR                  R                  UR                  R                  S9nUR                  R                  S5      Ul
        [        R                  " UR                  R                  5      n0 nUR                  R                  R                  5       R                   H7  nUR                  R                  U:H  n[        UR                  U   XG   S9XV'   M9     [        U[        S9R                   n["        R$                  " X55        g )	NrŠ  r‹  r  r  r—   r«   r   rÊ   )r   r   r<   rÓ   rK   r   r
   rE   r-  r€   rF   r�  rŽ  rÄ   rD   r­   rw   rI   rJ   )r@   r�  rc  rg   r€   rT   rq   r‘  s           r   Útest_monthlyÚTestPivotTable.test_monthlyã  sé   € Ü˜ \¸Ñ=ˆÜ”B—I’Iœc #›hÓ'¨sÑ3ˆäœY r›]°"·(±(·-±-ÈÏÉÏÉÑXˆØŸ™×1Ñ1°!Ó4ˆŒä—
’
˜2Ÿ8™8Ÿ>™>Ó*ˆØˆØ—‘—‘×%Ñ%Ó'×.Ô.ˆAØ—8‘8—=‘= AÑ%ˆDÜ  §¡¨4¡¸¹ÑDˆH‹Kñ /ô ˜X¬UÑ3×5Ñ5ˆÜ
×Ò˜fÕ/r   c                 ó  • SSS.n[        US/[        UR                  5       5      US9n[        US/UR                  5       US9n[        R                  " XC5        S U 5       n[        US/XRS9n[        R                  " Xc5        g )Nr`   rH   r:  r6   )rE   rD   ra   c              3   ó$   #   • U  H  ov •  M     g 7fr   râ   )Ú.0r  s     r   Ú	<genexpr>ÚGTestPivotTable.test_pivot_table_with_iterator_values.<locals>.<genexpr>ÿ  s   é € Ð2ªT Eœ%ªTùs   ‚)r   rd   r+  rI   rJ   )r@   rA   ÚaggsÚpivot_values_listÚpivot_values_keysÚagg_values_genÚpivot_values_gens          r   Ú%test_pivot_table_with_iterator_valuesÚ4TestPivotTable.test_pivot_table_with_iterator_valuesò  s‹   € à Ñ(ˆä'Ø˜˜¤d¨4¯9©9«;Ó&7Àñ
Ðô (Ø˜˜ d§i¡i£k¸4ñ
Ðô 	×ÒÐ/ÔCá2©TÓ2ˆÜ&Ø˜˜ nñ
Ðô 	×ÒÐ.ÕBr   c                 ó  • Sn[        / SQ/ SQ/ SQS.5      nUR                  SSSUS	S
/S9n[        SSU/SS9nSSS	SU4SSS
SU4/n[        R                  " U/ SQS9n[        UR
                  XFS9n[        R                  " X75        g )NÚWeekly)ÚbaconÚcheeser¥  r¦  )ró   rõ   gš™™™™™	@gffffff
@)r  r  rw   rw   )rÍ  Úcostr  rÍ  r  TrH   Úmax)rE   rF   rÏ   r¹  ra   r¥  r¦  r¥   )rH   r§  r  )rH   r§  rw   r§  )r¨  r§  r  )r¨  r§  rw   )NNr  r‚   r«   )r
   r   r   r   rƒ   rD   rI   rJ   )r@   r¹  ÚcostsrR   ÚixÚtupsru   rT   s           r   Ú/test_pivot_table_margins_name_with_aggfunc_listÚ>TestPivotTable.test_pivot_table_margins_name_with_aggfunc_list  s¸   € àˆÜâ>Ú,Ú-ñó
ˆð ×!Ñ!ØØØØ%Ø˜U�Oð "ð 
ˆô �G˜X |Ð4¸6ÑBˆà"Ø!Ø�V˜\Ð*Ø!Ø Ø�F˜LÐ)ð
ˆô ×%Ò% dÒ2EÑFˆÜ˜UŸ\™\°ÑBˆÜ
×Ò˜eÕ.r   c                 ód  • [        [        R                  " S5      [        R                  " S5      S-  [        R                  " S5      S-  S.5      n[        / SQ/ SQ/ SQ/5      n[        / SQS	S
9Ul        [        / SQSS
9Ul        UR                  SS	SUSS9n[        R                  " XC5        g )Nrà  r   r4   ro   ©r“   r”   rò   ©r[   rA  rÐ  ©r   r   rô   ©r   r   rÐ   rq   r¥   rr   rp   T©r   rÏ   )	r
   r<   rÓ   r   rE   rF   r   rI   rJ   )r@   rG   rf   rT   rR   s        r   Útest_categorical_marginsÚ'TestPivotTable.test_categorical_margins#  sŽ   € äÜ—)’)˜A“,¤R§Y¢Y¨q£\°QÑ%6¼R¿YºYÀq»\ÈAÑ=MÑNó
ˆô šoª{ºKÐHÓIˆÜš}°3Ñ7ˆŒÜ ¢°SÑ9ˆÔà—‘˜s C¨°XÀt�ÐLˆÜ
×Ò˜eÕ.r   c           	      óP  • [        [        R                  " S5      [        R                  " S5      S-  [        R                  " S5      S-  S.5      n[        / SQ/ SQ/ SQ/5      n[        / SQS	S
9Ul        [        / SQSS
9Ul        UR                  R                  S5      Ul        UR                  R                  S5      Ul        Sn[        R                  " [        US9   UR                  SS	SUSS9nS S S 5        [        R                  " WU5        g ! , (       d  f       N&= f)Nrà  r   r4   ro   r¯  r°  r±  r²  rq   r¥   rr   rc   r�   r‘   rp   Tr³  )r
   r<   rÓ   r   rE   rF   rq   re   rr   rI   r˜   r™   r   rJ   )r@   rG   rf   rT   rœ   rR   s         r   Ú!test_categorical_margins_categoryÚ0TestPivotTable.test_categorical_margins_category0  sÝ   € ÜÜ—)’)˜A“,¤R§Y¢Y¨q£\°QÑ%6¼R¿YºYÀq»\ÈAÑ=MÑNó
ˆô šoª{ºKÐHÓIˆÜš}°3Ñ7ˆŒÜ ¢°SÑ9ˆÔà�t‰t�{‰{˜:Ó&ˆŒØ�t‰t�{‰{˜:Ó&ˆŒØAˆÜ×'Ò'¬¸SÓAØ—N‘N 3¨¨S¸È4�NÐPˆE÷ Bä
×Ò˜e XÕ.÷ BÕAús   Ã#DÄ
D%c                 ó²   • [        / SQ/ SQ/ SQ/ SQS.5      n[        USSS9n[        / S	Q/ S
Q/ SQS.[        / SQSS9S9n[        R                  " X#5        g )N)r4   r   rA  rà  )r   r   r[   rà  )r   r   r   rA  )r…  r…  r†  r†  rR  r9   T)rE   rÏ   )r•   r¨   r[   )ró   g      @rõ   )r”   r©   rô   r£   )r…  r†  rÐ   r¥   r—   ©r
   r   r   rI   rJ   ©r@   rf   rg   rT   s       r   Útest_margins_casted_to_floatÚ+TestPivotTable.test_margins_casted_to_float@  s\   € äâ!Ú!Ú!Ú)ñ	ó
ˆô ˜R s°DÑ9ˆÜÚ¢oºOÑLÜÒ)°Ñ4ñ
ˆô 	×Ò˜fÕ/r   c           	      ó|  • [         R                  SSS[         R                  /n[         R                  SS[         R                  S/n[        [        USS/US9[        USS/US9[	        SS5      S.5      nUR                  S	S
SUS9n[        R                  " SS/US
S9n[        S[         R                  /[         R                  S//US9n[        [        SS/SS/US9S	S9Ul	        [        R                  " Xh5        UR                  S
SUS9n[        SS//U[        S/5      S9n[        R                  " Xh5        g )Nrµ   r¶   r6   r7   rŒ   r   rA  )ÚInÚColÚValr¿  rÀ  rÁ  )rE   rF   rD   rG   )rŽ   rN   r”   r•   )rA   rF   r¥   )rF   rD   rG   rô   )rA   rF   rE   )r<   r»   r
   r	   r®   r   r!   ÚCategoricalIndexr   rE   rI   rJ   )	r@   rG   rŽ   r  r  rf   rg   Úexpected_colsrT   s	            r   Útest_pivot_with_categoricalÚ*TestPivotTable.test_pivot_with_categoricalR  s9  € ä�v‰v�u˜f e¬R¯V©VÐ4ˆÜ�v‰v�s˜C¤§¡¨Ð-ˆÜä! #°5¸&°/È7ÑSÜ" 3°C¸°:ÀwÑOÜ˜Q “{ñó
ˆð —‘Ø ¨e¸hð  ð 
ˆô ×+Ò+¨S°#¨JÀÈeÑTˆä C¬¯© =´2·6±6¸3°-Ð"@È-ÑXˆÜÜ˜ ˜°U¸F°OÈWÑUØñ
ˆŒô
 	×Ò˜fÔ/ð —‘¨°eÀh�ÐOˆäØ˜�*� }¼EÀ5À'»Nñ
ˆô 	×Ò˜fÕ/r   c           	      óÔ  • [        / SQ/ SQ/ SQS.5      nUS   R                  S5      US'   Sn[        R                  " [        US9   UR                  S	SS
USS9nS S S 5        [        R                  " / SQ/ SQSSS9n[        SS/S
S9n[        R                  " SS/SS/SS//[        R                  S9n[        XuUS9n[        R                  " WU5        g ! , (       d  f       Nƒ= f)N)r6   r7   r8   r8   r‹   r�   )r6  r7  ÚVr6  rc   r�   r‘   rÇ  r7  Úcount)rE   rF   r   ra   r£   F©r�   rŽ   rN   rl   rm   r¥   r   r   r4   rÊ   r«   )r
   re   rI   r˜   r™   r   r!   rÂ  r   r<   r*  rð   rJ   )	r@   rG   rf   rœ   rg   r±   r°   Úexpected_datarT   s	            r   Útest_categorical_aggfuncÚ'TestPivotTable.test_categorical_aggfuncu  sé   € äÚ'Ò/CÊ,ÑWó
ˆð �d‘8—?‘? :Ó.ˆˆ4‰ØAˆÜ×'Ò'¬¸SÓAØ—^‘^Ø˜4¨°hÈð $ð ˆF÷ Bô
 ×,Ò,ÚªÀÈTñ
ˆô ! # s °$Ñ7ÐÜŸš 1 a &¨1¨a¨&°1°a°&Ð!9ÄÇÁÑJˆÜØÐ9Iñ
ˆô 	×Ò˜f hÕ/÷ BÕAús   ÁCÃ
C'c                 óŒ  • [        / SQ/ SQ/ SQS.5      n/ SQnUS   R                  S5      R                  R                  U5      US'   UR	                  SSS	US
S9n[        SS/S	SS9n[        R                  " X3SSS9nSS//SS//S-  -   n[        XvUS9nU(       a  UR                  S/   n[        R                  " XH5        g )N)rB  rì  éÜ   )ÚJanuaryrÏ  rÏ  )rN  rO  rN  )ÚSalesr  r  )rÏ  ÚFebruaryÚMarchÚAprilÚMayÚJuneÚJulyÚAugustÚ	SeptemberÚOctoberÚNovemberÚDecemberr  rc   rÐ  r  r`   )rD   rE   rF   rG   ra   rN  rO  rð   rU  FrÉ  i@  rì  r   r5   r«   rÏ  )r
   re   rì   Úset_categoriesr   r   r!   rÂ  rE  rI   rJ   )	r@   rG   rf   Úmonthsrg   r°   r±   rÊ  rT   s	            r   Ú%test_categorical_pivot_index_orderingÚ4TestPivotTable.test_categorical_pivot_index_ordering‹  sé   € äâ(Ú:Ú*ñó
ˆò
ˆð ˜‘k×(Ñ(¨Ó4×8Ñ8×GÑGÈÓOˆˆ7‰Ø—‘ØØØØØð  ð 
ˆô ! $¨ °FÀ'ÑJÐÜ×,Ò,Ø¨u¸7ñ
ˆð ˜s˜˜¨¨A¨ x°"¡}Ñ4ˆÜØÐ9Iñ
ˆö Ø—|‘| Y KÑ0ˆHä
×Ò˜fÕ/r   c           	      óÖ  • [        / SQ/ SQ/ SQS.5      nUR                  SSS/SS	9n[        R                  " / SQ/ SQ/SS/S
9n[        / SQUS/S9n[        R
                  " X$5        UR                  SSSSS9n[        S[        R                  [        R                  /[        R                  S[        R                  /[        R                  [        R                  S//[        / SQSS9[        / SQSS9S9n[        R
                  " X$5        UR                  SSS/S	9n[        R                  " S/S//5      n[        / SQ[        / SQSS9US9n[        R
                  " X$5        g )N)r   r   r[   )r8   r9   r:   )r   r   r¢   r\   r]   r_   r^   r`   rv   r‚   r«   r(  r   r   r[   r¥   )	r
   r   r   r#   rI   rJ   r<   r»   r   )r@   rf   rg   r‡   rT   s        r   Útest_pivot_table_not_seriesÚ*TestPivotTable.test_pivot_table_not_series·  s7  € ô
 ¢	²?ÊIÑVÓWˆà—‘ ¨v°vÐ.>È�ÐNˆÜ×"Ò"¢IªÐ#?ÈÐPVÐGWÑXˆÜšY¨a¸&¸ÑBˆä
×Ò˜fÔ/à—‘ ¨f¸fÈe�ÐTˆÜØ”—‘œŸ™Ð ¤2§6¡6¨1¬b¯f©fÐ"5¼¿¹ÄÇÁÈÐ7JÐKÜš	¨Ñ/Üš/°Ñ7ñ
ˆô 	×Ò˜fÔ/à—‘ ¨f¸u¸g�ÐFˆÜ×"Ò" U G¨f¨XÐ#6Ó7ˆÜšY¬e²IÀFÑ.KÐUVÑWˆä
×Ò˜fÕ/r   c                 óÀ   • Sn[        S/ SQ0[        S/[        S9S9n[        US/[        SUS9n[        SS	S
U/SSS9n[        U/ S9n[
        R                  " X55        g )Nu   Î”Î¿ÎºÎ¹Î¼Î®r-   rs   rÊ   r¬   T)rE   ra   rÏ   r¹  r   r4   r   r�  rt  r«   )r
   r   r�  r   rK   rI   rJ   )r@   ÚgreekÚframerR   rE   rT   s         r   Útest_pivot_margins_name_unicodeÚ.TestPivotTable.test_pivot_margins_name_unicodeÓ  sk   € à6ˆÜ˜5¢)Ð,´e¸U¸GÌ6Ñ6RÑSˆÜØ˜%˜¬#°tÈ%ñ
ˆô �q˜!˜Q Ð&¨h¸UÑCˆÜ 5°"Ñ5ˆÜ
×Ò˜eÕ.r   c                 óÌ  • [        / SQ/ SQ[        S5      S.5      n[        USSSS9n[        S	/S
S//SS/SS//S S/S9n[        SSS.SSS.S.US9R	                  S5      n[
        R                  " X$5        [        USSSS/S9n[        SS/S	/S
S/// SQ/ SQ/ SQ// SQS9n[        SSS.SSS.SSS.SSS.S.US9R	                  S5      n[
        R                  " X$5        g ) Nr,   r/   r5   r£   r6   r7   r`   r(  r8   r0   r1   r   r   rŒ  r:  rÓ  )r.   r-   rÑ   r<  ))r8   r0   )r8   r1   r¬   rH   rÈ   )r   r   r   r   r’  )NNr7   r©   r  r¨   g«ªªªªª@))rH   r8   r0   )rH   r8   r1   )r`   r8   r0   )r`   r8   r1   )r
   r®   r   r   rð  rI   rJ   )r@   rA   rg   rò  rT   s        r   Útest_pivot_string_as_funcÚ(TestPivotTable.test_pivot_string_as_funcÞ  s=  € ô òòô ˜2“Yñ7ó
ˆô@ ˜T¨°cÀ5ÑIˆÜØ�E˜E 5˜>Ð*°A°q°6¸A¸q¸6Ð2BÈ4ÐQTÈ+ñ
ˆô Ø#%¨bÑ1ÈÐSUÑAVÑWØñ
÷ ‰+�cÓ
ð 	ô 	×Ò˜fÔ/ä˜T¨°cÀEÈ6À?ÑSˆÜØ˜F�O c U¨U°E¨NÐ;Ú¢ª|Ð<Ú#ñ
ˆô
 à.1¸$Ñ&?Ø.1Ð:KÑ&LØ-/¸Ñ%;Ø-.°rÑ%:ñ	ð ñ
÷ ‰+�cÓ
ð 	ô 	×Ò˜fÕ/r   z
f, f_numpyr*  c                 óB  • UR                  SS9n[        USSUS9n[        U[        5      (       a  SR	                  U5      OUnSU S3n[
        R                  " [        US	9   [        USSUS9nS S S 5        [
        R                  " UW5        g ! , (       d  f       N&= f)
Nr8   r¬   r6   r7   r(  Ú|zusing DataFrameGroupBy.[Ú]r‘   )	r!  r   Ú
isinstancerd   ÚjoinrI   r˜   r™   rJ   )r@   rø   Úf_numpyrA   rg   Úopsrœ   rT   s           r   Útest_pivot_string_func_vs_funcÚ-TestPivotTable.test_pivot_string_func_vs_func  s�   € ð �y‰y ˆyÐ%ˆÜ˜T¨°cÀ1ÑEˆÜ'¨¬4×0Ñ0ˆc�h‰h�qŒk°aˆØ(¨¨¨QÐ/ˆÜ×'Ò'¬¸SÓAÜ" 4¨s¸CÈÑQˆH÷ Bä
×Ò˜f hÕ/÷ BÕAús   Á#BÂ
Bc           
      ó  •  " S S[         R                  5      nUR                  5        nUR                  [         SU5        [	        [
        R                  " S5      [
        R                  " S5      SS.5      nSn[        R                  " [        US9   [        R                  " [        S	S9   UR                  S
SSSS9  S S S 5        S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       N(= f! , (       d  f       g = f)Nc                   ó,   ^ • \ rS rSrSU 4S jjrSrU =r$ )ÚSTestPivotTable.test_pivot_number_of_levels_larger_than_int32.<locals>.MockUnstackeri6  c                 ó:   >• [         TU ]  " U0 UD6  [        S5      e)NúDon't compute final result.)ÚsuperÚ__init__Ú	Exception)r@   ÚargsÚkwargsÚ	__class__s      €r   rú  Ú\TestPivotTable.test_pivot_number_of_levels_larger_than_int32.<locals>.MockUnstacker.__init__7  s!   ø€ ä‘Ò  $Ð1¨&Ò1ÜÐ =Ó>Ð>r   râ   )ÚreturnN)Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__rú  Ú__static_attributes__Ú__classcell__)rþ  s   @r   ÚMockUnstackerrö  6  s   ø† ÷?õ ?r   r  Ú
_Unstackeri   r   )Úind1Úind2rÈ  z$The following operation may generater‘   rø  r	  r
  rÈ  ra  )Úreshape_libr  ÚcontextÚsetattrr
   r<   rÓ   rI   r˜   r   r—  r˜  rû  r   )r@   Úmonkeypatchr  r‡   rf   rœ   s         r   Ú-test_pivot_number_of_levels_larger_than_int32Ú<TestPivotTable.test_pivot_number_of_levels_larger_than_int322  sÌ   € ô	?œK×2Ñ2ô 	?ð × Ñ Ô" aØ�I‰I”k <°Ô?ÜÜŸš 5Ó)´2·9²9¸UÓ3CÈaÑPóˆBð 9ˆCÜ×+Ò+Ô,>ÀcÓJÜ—]’]¤9Ð4QÓRØ—N‘NØ$¨f¸WÈgð #ñ ÷ S÷ K÷ #Ð"÷ SÕRú÷ KÕJú÷ #Õ"ús<   ªA*C<ÂC+Â.CÃC+Ã	C<Ã
C(Ã$C+Ã+
C9	Ã5C<Ã<
D
c                 ó˜  • [        / SQ/ SQ/ SQS.5      nS nS nS n[        USXEU/US	9nS
S[        R                  [        R                  SS/SS[        R                  [        R                  SS//n[        R
                  " / SQSS//S S/S9n[        USS/US9n	U(       a  U	R                  SS9n	[        R                  " Xi5        g )N)ÚappleÚpeachr  )r   r   r4   )rÑ   rA  rA  )ÚfruitÚsizeÚtastec                 ó   • g)Nr   râ   rã   s    r   Úret_oneÚ?TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_oneS  s   € Ør   c                 ó   • [        U 5      $ r   )r`   rã   s    r   Úret_sumÚ?TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_sumV  s   € Ü�q“6ˆMr   c                 ó"   • [         R                  $ r   )r<   r»   rã   s    r   Úret_noneÚ@TestPivotTable.test_pivot_table_aggfunc_dropna.<locals>.ret_noneY  s   € Ü—6‘6ˆMr   r  ©rF   ra   r   r   r   rÓ  rA  )r  r  r  r  r  r‚   r  r  r«   rF   r  )	r
   r   r<   r»   r   Úfrom_productr   rI   rJ   )
r@   r   rf   r  r  r  rg   rA   r  rT   s
             r   Útest_pivot_table_aggfunc_dropnaÚ.TestPivotTable.test_pivot_table_aggfunc_dropnaI  sÓ   € äâ4Ú!Ú"ñó
ˆò	ò	ò	ô Ø˜¨'¸WÐ)EÈfñ
ˆð �A”r—v‘vœrŸv™v q¨!Ð,¨r°1´b·f±f¼b¿f¹fÀaÈÐ.KÐLˆÜ×%Ò%Ú/°'¸7Ð1CÐDØ˜�/ñ
ˆô ˜T¨&°'Ð):ÀCÑHˆæØ—‘¨I�Ð6ˆHä
×Ò˜fÕ/r   c                 óp  • [        / SQS[        R                  S/S[        R                  [        R                  /S.5      n[        USSUS9nS	[        R                  /S[        R                  //n[	        S
S/SS9n[        USS/US9nU(       a  UR                  SS9n[        R                  " X65        g )N)r0   r1   r0   r   r4   r   )r6   rp   rq   r6   rH   r   ró   r0   r1   r¥   rp   rq   r«   rF   r  )r
   r<   r»   r   r   r   rI   rJ   )r@   r   rf   rg   rA   r  rT   s          r   Ú&test_pivot_table_aggfunc_scalar_dropnaÚ5TestPivotTable.test_pivot_table_aggfunc_scalar_dropnal  sž   € äÚ'¨q´"·&±&¸!¨nÀAÄrÇvÁvÌrÏvÉvÐCVÑWó
ˆô ˜R¨°fÀVÑLˆà”b—f‘f� ¤2§6¡6˜{Ð+ˆÜ�U˜E�N¨Ñ-ˆÜ˜T¨#¨s¨¸SÑAˆæØ—‘¨I�Ð6ˆHä
×Ò˜fÕ/r   rÏ   c                 óÜ   • [        / SQ/ SQ/ SQ/ SQS.5      nUR                  SSS[        R                  US	9n[	        / SS
9n[        [	        / SSS9US9n[
        R                  " X55        g )N)r4   r4   r   r   r4   )r[   rA  rÑ   rà  r¢   )Úpr‡  r‡  r(  r‡  )NNNNN)r6   Úidr8   r9   r6   r9   r)  rÎ   r¥   rð   rt  r«   )r
   r   r<   r  r   rI   rJ   )r@   rÏ   rf   rg   Úexp_colsrT   s         r   Útest_pivot_table_empty_aggfuncÚ-TestPivotTable.test_pivot_table_empty_aggfunc}  st   € ô â$Ú%Ú.Ú3ñ	ó
ˆð —‘Ø˜s¨4¼¿¹È'ð  ð 
ˆô ˜ #Ñ&ˆÜ¤5¨°7ÀÑ#EÈxÑXˆÜ
×Ò˜fÕ/r   c                 ó¾   • S n[        / SQ/ SQ/ SQS.5      n[        R                  " [        SS9   UR	                  SSS	US
9  S S S 5        g ! , (       d  f       g = f)Nc                 ó.   • [         R                  " U 5      $ r   )r<   rH   )Úarrs    r   rP   Ú=TestPivotTable.test_pivot_table_no_column_raises.<locals>.agg‘  s   € Ü—7’7˜3“<Ðr   rÈ   r’  )rÒ   r<  rj  é(   )r…  r†  ÚZÚ
notpresentr‘   r…  r†  )ra   )r
   r—  r˜  r¤  r   )r@   rP   rf   s      r   Ú!test_pivot_table_no_column_raisesÚ0TestPivotTable.test_pivot_table_no_column_raises�  sI   € ò	 ô š\²ÒCSÑTÓUˆÜ�]Š]œ8¨<Ó8Ø�N‰N˜<¨¨c¸3ˆNÑ?÷ 9×8Ö8ús   ²AÁ
Ac                 óÞ  • [        / SQ/ SQ/ SQ/ SQ/ SQS.5      n[        USS/S	S
/S/ SQS.S9n[        R                  " / SQ5      n[        R                  " / SQS	S
/S9n[        R
                  " / SQ/ SQ/ SQ/ SQ/5      n[        XSUS9nUS   R                  [        R                  5      US'   US   R                  [        R                  5      US'   [        R                  " X&5        g )NrÙ  rÚ  rÛ  rÞ  rß  rá  r9   r:   r6   r8   rH   )rk  r¨  rH   r:  )rD   rE   ra   ))r9   rH   ©r:   r¨  )r:   rH   ©r:   rk  ))r.   rÝ  )r.   rÜ  )r-   rÝ  )r-   rÜ  r‚   )rÐ  ç      "@g      @r§   )rÐ  r9  g      !@rª   )r”   r©   rõ   r–   )g["8ªªª@r§   g.UUU@r”   rû  r8  r7  )
r
   r   r   rƒ   r<   r*  re   rð   rI   rJ   )r@   rf   rR   ru   rE   ÚvalsrT   s          r   Ú0test_pivot_table_multiindex_columns_doctest_caseÚ?TestPivotTable.test_pivot_table_multiindex_columns_doctest_case˜  sö   € ô âTÚTò
ò 1Ú0ñó
ˆô( ØØ˜�:Ø˜�*Ø Ò'=Ñ>ñ	
ˆô ×%Ò%ÚFó
ˆô ×&Ò&ÚTØ˜�*ñ
ˆô �xŠxâ$Ú$Ú$Ú2ð	ó
ˆô ˜T°uÑ=ˆØ!)¨,Ñ!7×!>Ñ!>¼r¿x¹xÓ!Hˆ�ÑØ!)¨,Ñ!7×!>Ñ!>¼r¿x¹xÓ!Hˆ�ÑÜ
×Ò˜eÕ.r   c           	      óP  • [        / SQ/ SQ/ SQ/ SQS.5      nUR                  SS/SS	S
SS9n[        S[        R                  /S[        R                  /[        R                  S//[	        SS/SS9[
        R                  " / SQ/ SQ/SS/S9S9n[        R                  " X#5        g )N)Úd1Úd4Úd3rk   )é   rç  é"   )Ú2018rC  Ú2019)rl   r  Únumr-  rl   r  r-  rE  r`   F)rE   rF   rD   ra   ÚsortrA  rç  rB  rC  rD  r¥   r‚   rû  )	r
   r   r<   r»   r   r   r#   rI   rJ   r»  s       r   Útest_pivot_table_sort_falseÚ*TestPivotTable.test_pivot_table_sort_falseÌ  s«   € äâ'Ú&Ú#Ú0ñ	ó
ˆð —‘Ø˜�,¨°uÀeÐRWð  ð 
ˆô Ø”"—&‘&ˆ\˜B¤§¡˜<¬"¯&©&°"¨Ð6Ü˜6 6Ð*°Ñ8Ü×(Ò(Ú#¢_Ð5¸cÀ5¸\ññ
ˆô 	×Ò˜fÕ/r   c           	      óö   • [        SSS/[        SS/SS9S.5      nUR                  S	S
SSS9n[        SS/SS/SS//[        / SQS	S9[        R
                  " SS/S S
/S9SS9n[        R                  " X#5        g )Nr6   r   r4   rÒ   r5   ÚInt64rÊ   )rl   rm   Úsalesrm   rl   Tr`   rº  rç  r|  r¥   ©rK  r6   ©rK  rÐ   r‚   ©rE   rF   rË   )r
   r   r   r   r   rƒ   rI   rJ   r»  s       r   Ú!test_pivot_table_nullable_marginsÚ0TestPivotTable.test_pivot_table_nullable_marginsâ  s™   € äØ˜Q ˜F¬V°R¸°HÀGÑ-LÑMó
ˆð —‘ c°3ÀÈe�ÐTˆÜØ�"ˆX˜˜B�x " b Ð*Üš¨CÑ0Ü×*Ò*ØÐ!1Ð2¸4À¸+ñð ñ
ˆô 	×Ò˜fÕ/r   c           	      óÞ   • [        SS/SS/SS/SS/S	.5      nUR                  S
S/SS/SS9n[        SS/SS//SS/[        R                  " SS/S
S/S9S9n[        R
                  " X#5        g )NÚJohnÚMichaelÚFooÚBaré­   é¶   é/   ré  )Ú	firstnameÚlastnameÚheightÚagerZ  rY  r[  r\  F)rE   rD   rF  g      e@g     €G@g     Àf@g     €@@)rT  rR  )rU  rS  r‚   rû  )r
   r   r   rƒ   rI   rJ   r»  s       r   Ú0test_pivot_table_sort_false_with_multiple_valuesÚ?TestPivotTable.test_pivot_table_sort_false_with_multiple_valuesó  s§   € Üà$ iÐ0Ø" E˜NØ ˜*Ø˜B�xñ	ó
ˆð —‘Ø˜{Ð+°X¸uÐ4EÈEð  ð 
ˆô Ø�Tˆ]˜U D˜MÐ*Ø˜uÐ%Ü×(Ò(Ø Ð"4Ð5Ø! ;Ð/ññ
ˆô 	×Ò˜fÕ/r   c           	      ó(  • [        / SQ/ SQ/ SQ/ SQ/5      n/ SQUl        UR                  SSSS	S
SS9n[        / SQ/ SQ/ SQ/5      n/ SQUl        / SQUl        SUR                  l        SUR                  l        [
        R                  " X#5        g )N©rl   rp   r   ©rl   rq   r4   ©rm   rq   r   ©rm   rr   r   )rÒ   r<  rj  rÒ   r<  rj  r`   r   T©rE   rF   rD   ra   rb   rÏ   ©r   r4   r   r   ©r   r   r   rÑ   ©r   r[   r   rÒ   ©rp   rq   rr   rÐ   ©rl   rm   rÐ   )r
   rF   r   rE   rN   rI   rJ   r»  s       r   Ú1test_pivot_table_with_margins_and_numeric_columnsÚ@TestPivotTable.test_pivot_table_with_margins_and_numeric_columns		  s‡   € äš¢}²mÂ]ÐSÓTˆÚ!ˆŒ
à—‘Ø˜b¨°UÀqÐRVð  ð 
ˆô šlªLº-ÐHÓIˆÚ1ˆÔÚ*ˆŒØ "ˆ×ÑÔØ ˆ�‰Ôä
×Ò˜fÕ/r   r   c           	      óÈ   • [        SS[        SS/SS9S.5      nUR                  SS	S
SUS9n[        S//[        S/SS9[        S/S	S9SS9n[        R
                  " X45        g )Nrl   rm   r<  r1  rJ  rÊ   )rp   rq   r\  rp   rq   r\  rH   )rE   rF   rD   ra   r   rj  r¥   ÚFloat64rN  )r
   r   r   r   rI   rJ   )r@   r   rf   rg   rT   s        r   Útest_pivot_ea_dtype_dropnaÚ)TestPivotTable.test_pivot_ea_dtype_dropna	  s|   € ô ˜S s´6¸2¸r¸(È'Ñ3RÑSÓTˆØ—‘Ø˜s¨5¸&Èð  ð 
ˆô ØˆTˆFÜ˜˜ CÑ(Ü˜3˜% cÑ*Øñ	
ˆô 	×Ò˜fÕ/r   c                 ó  • [        SSS/[        R                  " S5      SS/S.5      n[        R                  " S 5         UR                  SS	/S
SSS9nS S S 5        [        SS/SS/SS//[        R                  " [        / SQSS9[        [        R                  " S5      [        R                  " S5      S/[        S	S9/5      [        R                  " SS/S S
/S9S9n[        R                  " WU5        g ! , (       d  f       N©= f)Nr6   r   r4   z
2019-12-31g      $@r5   )rl   rm   r   rK  rm   r   rl   Tr`   rº  rE  g      5@r|  r¥   rª  rt  rL  rM  r‚   r«   )r
   r!   rD  rI   r˜   r   r   r#   r   r�  rƒ   rJ   r»  s       r   Ú!test_pivot_table_datetime_warningÚ0TestPivotTable.test_pivot_table_datetime_warning)	  s  € äàØ˜�VÜŸš \Ó2Ø ˜ñ	ó
ˆô ×'Ò'¨Õ-Ø—^‘^Ø˜F�m¨S¸$Èð $ð ˆF÷ .ô Ø�Dˆ\˜D $˜<¨$°¨Ð6Ü×(Ò(äš-¨cÑ2ÜÜŸš lÓ3´R·\²\À,Ó5OÐQSÐTÜ$Ø#ñðó	ô ×*Ò*ØÐ!1Ð2¸4À¸+ññ
ˆô  	×Ò˜f hÕ/÷) .Õ-ús   ¿C7Ã7
Dc                 ón  • [        / SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQS.5      n[        USSS	/S
/SS9n[        SS/SS/SS/[        R                  S//[	        SS/S
S9[
        R                  " / SQSS/S-  /SS	/S9S9nU(       a  US   R                  S5      US'   [        R                  " X45        g )NrÙ  rÚ  rÛ  rÞ  rß  )r6   r7   r8   r9   r:   )Úcol5)Úcol6rA  ©rÑ   Úsevenr9   r6   r7   rv  r`   r&  r–   r©   r¨   r§   r“   rÝ  rÜ  r¥   )r.   r.   r-   r-   r0   r1   r4   r‚   rû  rð   )
r
   r   r<   r»   r   r   r#   re   rI   rJ   )r@   rf  rf   rg   rT   s        r   Ú)test_pivot_table_with_mixed_nested_tuplesÚ8TestPivotTable.test_pivot_table_with_mixed_nested_tuplesI	  sà   € äâTÚTò
ò 1Ú0ò
ò
ò
ñM1ó3
ˆôh Ø�s 3¨ *°|°nÈeñ
ˆô Ø�3ˆZ˜#˜s˜ c¨3 Z´"·&±&¸#°Ð?Ü˜7 GÐ,°<Ñ@Ü×(Ò(Ú-°°u¨~ÀÑ/AÐBÈ3ÐPSÈ*ññ
ˆö à (¨Ñ 1× 8Ñ 8¸Ó AˆH�WÑÜ
×Ò˜fÕ/r   c                 ó2  • [        [        S5      [        S5      [        S5      [        S5      S.5      n[        R                  " [        S5       Vs/ s H  nSPM     sn[        S5       Vs/ s H  nSPM     sn[        S5      /SS9n[        R
                  " S[        R                  5      n[        R                  " US5        [        U[        [        S5      S	S
9US9nUR                  S	/S/S/S/S9n[        R                  " Xe5        g s  snf s  snf )NrÒ   r¡   Únuniquern   )NNrm   r‚   )rÒ   rÒ   r“   rl   r¥   r«   rm   ra  )r
   r®   r   r#   r<   Úfullr»   Úfill_diagonalr   r   rI   rJ   )r@   Útestrï   Ú	columnvalÚnparrrT   rg   s          r   Ú6test_pivot_table_aggfunc_nunique_with_different_valuesÚETestPivotTable.test_pivot_table_aggfunc_nunique_with_different_valuesŽ	  s  € Üä˜2“YÜ˜2“YÜ˜2“YÜ˜2“Yñ	ó
ˆô ×*Ò*ä$)¨"¤IÓ.¢I˜q“¡IÑ.Ü# BœiÓ(ši˜“™iÑ(Ü�b“	ðð
 $ñ
ˆ	ô —’˜¤"§&¡&Ó)ˆÜ
×Ò˜ Ô$ä˜U¬%´°b³	ÀÑ*DÈiÑXˆØ×!Ñ!àðð ðð ðð �Kð "ð 
ˆô 	×Ò˜fÕ/ùò/ /ùÚ(s   ÁDÁ-D
râ   )cr  r  r  r  r—  ÚfixturerA   rU   rh   rz   rˆ   rž   r²   r¾   rÁ   rÅ   rÚ   rÞ   ræ   ré   rù   ÚmarkÚparametrizer  r  r"  r/  r>  rK  r]  ro  rw  r~  r<   r*  r   r   r�  r“  rš  Úxfailr¡  r¥  rµ  r¼  rÎ  r   rƒ   râ  ró  rö  rý  r  r  r  r7  r;  r@  rH  rK  rS  rX  rg  rm  r‚  r‡  r’  r•  r¡  r¬  r´  r·  r¼  rÄ  rË  rÞ  rá  ræ  ré  r`   rH   r*  rò  Úslowr  r"  r%  r+  r4  r;  rG  rO  r]  rj  rn  rq  rx  r�  r  râ   r   r   r)   r)   ,   sÄ  † Ø‡^�^ñ.
ó ð.
ò`/ò80ò6
&ò#/òJ0ò 0ò@!0òF0ò<0ò1ò80ò
0ò
/ò!1ðF ‡[�[×ÑØà�x Ð*Ð+ØÒ3Ð4ØÒ3Ð4ð	
óñ"óð"ò,(ò\0ò0ð2 ‡[�[×Ñ˜X¨¨e }Ó5ñXó 6ðXð6 ‡[�[×Ñ˜X¨¨e }Ó5ñ,ó 6ð,ð6 ‡[�[×Ñ˜X¨¨e }Ó5ñ=,ó 6ð=,ò~50ðn ‡[�[×Ñ˜X¨¨e }Ó5ñ+,ó 6ð+,òZ0ð0 ‡[�[×ÑØà�EˆNØ�HŠH�e˜U�^Ó$Ù�E˜5�>Ó"Ù�5˜%�.Ó!ð		
óð ‡[�[×Ñ˜X¨¨e }Ó5ñ0ó 6óð0ð6 ‡[�[×ÑØà�EˆNØ�HŠH�e˜U�^Ó$Ù�E˜5�>Ó"Ù�5˜%�.Ó!ð		
óð ‡[�[×Ñ˜X¨¨e }Ó5ñ 0ó 6óð 0òD2ð ‡[�[×ÑØSð ð ð ‡[�[×Ñ˜X¨¨e }Ó5ñ$0ó 6óð$0ðL ‡[�[×Ñ˜X¨¨e }Ó5ñPó 6ðPð, �CˆjØ�Øô=ò2Bò2/ð4 ‡[�[×ÑØ4ð ØÚ%Ò';Ð<ÙÒ2¸Ñ=ð	ð �c�
Øâ)Ú,ðð ×&Ò&òð  ˜*ñ
ðð	
óñ<$0ó=ð<$0òL0ò00ð& ‡[�[×Ñ˜VÒ%MÓNñ0ó Oð0ò2ò@ò*/ò$17òf0ò8òAò7òAð ‡[�[×Ñ˜]¨U°E¸3ÀÀsÈCÀjÐ,QÓRñ#ó Sð#òJVòp}2ò~Y0òvY0òv0ò$0òCò&/ò</ò/ò 0ò$!0òF0ò,*0òX0ò8	/ò<0ð| ‡[�[×ÑØà�B—F‘FˆOØ�R—W‘WÐØ�B—F‘FˆOØ�Vˆ_˜rŸv™v r§w¡wÐ/Ð0Ø�Uˆ^˜bŸf™f b§f¡fÐ-Ð.Ø�Vˆ_˜rŸv™v r§w¡wÐ/Ð0ð	
ó
ñ	0ó
ð	0ð ‡[�[×Ññó ðò,!0òF0ð" ‡[�[×Ñ˜Y¨¨u¨Ó6ñ0ó 7ð0ò"@ò2/òh0ò,0ò"0ò,0ð" ‡[�[×Ñ˜X¨¨e }Ó5ñ0ó 6ð0ò0ò@C0õJ#0r   r)   c                   ó¬   • \ rS rSrS rS rS rS rS rS r	S r
\R                  R                  \" 5       S	S
9S 5       rS rS rS rS rS rS rSrg)Ú	TestPivoti´	  c                 óò  • / SQ/ SQ/ SQS.n[        U5      nUR                  SSSS9n[        SS	S
S.SS	S
S.S.5      nSu  UR                  l        UR                  l        [
        R                  " X45        UR                  R                  S:X  d   eUR                  R                  S:X  d   eUR                  SSS9nUR                  R                  S:X  d   eUR                  R                  S:X  d   eg )N©r6   r7   r8   r8   r7   r6   ©ÚOner�  r�  ÚTworŽ  rŽ  ©r“   r”   r•   r•   r”   r“   r   rE   rF   rD   r“   r”   r•   r£   ©r�  rŽ  r«   ©NrF   )r
   r=  rE   rN   rF   rI   rJ   rL   )r@   rA   rå  r6  rT   s        r   Ú
test_pivotÚTestPivot.test_pivotµ	  sö   € â3ÚAÚ4ñ
ˆô ˜$“ˆØ—+‘+ G°YÀx�+ÐPˆäà  s°Ñ5Ø  s°Ñ5ñó
ˆð 6HÑ2ˆ�‰Ô˜X×-Ñ-Ô2Ü
×Ò˜gÔ0ð �}‰}×!Ñ! WÓ,Ð,Ð,Ø�‰×#Ñ# yÓ0Ð0Ð0ð —+‘+ G°Y�+Ð?ˆØ�}‰}×!Ñ! WÓ,Ð,Ð,Ø�‰×$Ñ$Ð(9Ó9Ð9Ñ9r   c                 ó¶   • [        / SQ/ SQ/ SQS.5      n[        R                  " [        SS9   UR	                  SSS	S
9  S S S 5        g ! , (       d  f       g = f)N)r.   r.   r-   r-   r-   )r0   r1   r0   r0   r1   )r“   r”   r•   r•   r–   rk   zduplicate entriesr‘   rl   rm   rn   r   )r
   r—  r˜  rW  r=  )r@   rA   s     r   Útest_pivot_duplicatesÚTestPivot.test_pivot_duplicatesÒ	  sJ   € Üâ8Ú8Ú.ñó
ˆô �]Š]œ:Ð-@ÓAØ�J‰J˜S¨#°cˆJÑ:÷ B×AÖAús   ¯A
Á

Ac                 óz   • [        / SQS9nUR                  SSSS9n[        / / S9n[        R                  " X#SS	9  g )
Nrk   r¬   rl   rm   rn   r   r«   Fr¨  )r
   r=  rI   rJ   r»  s       r   Útest_pivot_emptyÚTestPivot.test_pivot_emptyÝ	  s<   € ÜšÑ/ˆØ—‘ ¨S¸�Ð=ˆÜ 2¨rÑ2ˆÜ
×Ò˜f¸EÓBr   c                 óÈ   • [        SS/US9nUR                  SSSS9n[        SS	/SUS
9nUS:X  a  UR                  S5      n[        R
                  " UR                  U5        g )N)r6   r	  ÚA1)r7   r  ÚB2)rA   rË   r   r   r4   r   r6   r7   rU  r�  rú  )r
   r=  r   re   rI   r„   rF   )r@   Úany_string_dtyperf   rg   r°   s        r   Útest_pivot_integer_bugÚ TestPivot.test_pivot_integer_bugã	  sp   € ÜØ"Ð$4Ð5Ð=Mñ
ˆð —‘ ¨1°Q�Ð7ˆÜ  # s °!Ð;KÑLÐØ˜xÓ'Ø/×6Ñ6°uÓ=ÐÜ
×Ò˜fŸn™nÐ.>Õ?r   c                 óÒ  • / SQ/ SQ/ SQS.n[        U5      R                  S5      nUR                  SSS9n[        S	S
SS.S	S
SS.S.5      nSu  UR                  l        UR
                  l        [        R                  " X45        UR                  SS9n[        R                  " SS/S S/S9Ul        SUR                  l        [        R                  " X4SS9  UR                  R                  S:X  d   eUR
                  R                  S:X  d   eUR
                  R                  S5      Ul        UR                  SSS9nSUR
                  l        [        R                  " X45        g )Nr‹  rŒ  r�  r   rE   rF   rD   ©rF   rD   r“   r”   r•   r£   r�  r«   r¬   )rD   r�  )rD   rŽ  r‚   Fr¨  r‘  r   )r
   rl  r=  rE   rN   rF   rI   rJ   r   rƒ   rL   r�  )r@   rA   rå  rg   rT   s        r   Útest_pivot_index_noneÚTestPivot.test_pivot_index_noneî	  sU  € ò 4ÚAÚ4ñ
ˆô ˜$“×)Ñ)¨'Ó2ˆØ—‘ Y°x�Ð@ˆÜà  s°Ñ5Ø  s°Ñ5ñó
ˆð 6HÑ2ˆ�‰Ô˜X×-Ñ-Ô2Ü
×Ò˜fÔ/ð —‘ Y�Ð/ˆä%×1Ò1ØÐ 1Ð2¸4ÀÐ:Kñ
ˆÔð &ˆ�‰ÔÜ
×Ò˜f¸EÒBØ�|‰|× Ñ  GÓ+Ð+Ð+Ø�~‰~×#Ñ#Ð'8Ó8Ð8Ð8Ø#×+Ñ+×5Ñ5°aÓ8ˆÔØ—‘ Y°x�Ð@ˆà )ˆ×ÑÔÜ
×Ò˜fÕ/r   c                 óâ  • [        / SQ/ SQ/ SQ/ SQ/ SQS.5      nSS/nS	/nUR                  X#S
9n[        [        R                  " / SQS[        R                  S[        R                  // SQ[        R                  S[        R                  S//5      [
        R                  " SS/SS/S9[
        R                  " SS/S S	/S9S
9n[        R                  " XE5        USS/:X  d   eUS	/:X  d   eg )N)r   r   r   r4   r4   r4   )r   r   r4   r   r   r4   )r   r4   r   r4   r   r4   r…  rŸ  )Úlev1Úlev2Úlev3Úlev4rD   r¥  r¦  r§  r«   )r“   r”   r¦   r“   r•   r”   )r©   r–   r–   r•   r§   r©   rÉ   )r   r4   r   r4   r‚   )r¨  r¨  rD   rD   )	r
   r=  r<   r*  r»   r   r#   rI   rJ   )r@   rf   rE   rF   rg   rT   s         r   Ú0test_pivot_index_list_values_none_immutable_argsÚ:TestPivot.test_pivot_index_list_values_none_immutable_args
  sý   € äâ*Ú*Ú*Ú*Ú,ñó
ˆð ˜Ð ˆØ�(ˆØ—‘ �Ð7ˆäÜ�HŠHâ(Øœ"Ÿ&™& #¤r§v¡vÐ.Ú(Ü—V‘V˜S¤"§&¡&¨#Ð.ð	óô ×(Ò(Ø˜|Ð,°V¸VÐ4Dñô ×*Ò*Ø5°|ÐDØ˜V�nññ
ˆô$ 	×Ò˜fÔ/à˜ Ð(Ó(Ð(Ð(Ø˜6˜(Ó"Ð"Ñ"r   c                 ó¨   • [        S/SS.5      n[        R                  " [        SS9   UR	                  5         S S S 5        g ! , (       d  f       g = f)Nr   rø  z(missing 1 required keyword-only argumentr‘   r–  )r@   rf   s     r   Útest_pivot_columns_not_givenÚ&TestPivot.test_pivot_columns_not_given8
  s8   € ä˜a˜S qÑ)Ó*ˆÜ�]Š]œ9Ð,VÓWØ�H‰HŒJ÷ X×WÖWús   ©AÁ
Az&TODO(infer_string) None is cast to NaNrœ  c                 óz  • [        S/SSS.5      nUR                  S S9n[        S/SS.5      n[        R                  " X#5        UR                  S SS9n[        S	S0[	        S/SS
9S9n[        R                  " X#5        UR                  S SSS9n[        SS0[	        S/SS
9S9n[        R                  " X#5        g )Nr   r4   r   ©Nrm   rn   r¬   ))rm   r   ©rn   r   rm   rû  r°  r¥   r—   rn   ©rF   rE   rD   )r
   r=  rI   rJ   r   r»  s       r   Útest_pivot_columns_is_noneÚ$TestPivot.test_pivot_columns_is_none@
  sº   € ô
 ˜q˜c¨°Ñ2Ó3ˆØ—‘ $�Ð'ˆÜ¨¨°qÑ9Ó:ˆÜ
×Ò˜fÔ/à—‘ $¨c�Ð2ˆÜ˜h¨˜]´%¸¸À#Ñ2FÑGˆÜ
×Ò˜fÔ/à—‘ $¨c¸#�Ð>ˆÜ˜a ˜V¬5°!°¸3Ñ+?Ñ@ˆÜ
×Ò˜fÕ/r   c           	      ót  • [        S/SSS.5      nUR                  SS S9n[        SS0S/S9nS S/UR                  l        [        R
                  " X45        UR                  SS S	S
9n[        SS/[        S/SS9S9nU(       a  [        R                  UR                  l
        [        R
                  " X45        g )Nr   r4   r   r¯  rm   rû  )rn   r4   r—   rn   r±  r¥   r«   )r
   r=  rF   rL   rI   rJ   r   r<   r»   rE   rN   )r@   rÊ  rf   rg   rT   s        r   Útest_pivot_index_is_noneÚ"TestPivot.test_pivot_index_is_noneR
  s§   € ä˜q˜c¨°Ñ2Ó3ˆà—‘ #¨T�Ð2ˆÜ˜h¨˜]°1°#Ñ6ˆØ"&¨ ˆ×ÑÔÜ
×Ò˜fÔ/à—‘ #¨T¸#�Ð>ˆÜ˜Q q c´5¸!¸À3Ñ3GÑHˆÞÜ"$§&¡&ˆH�N‰NÔÜ
×Ò˜fÕ/r   c           	      ó"  • [        S/SSS.5      nUR                  SSS S9n[        S[        S/SS9[        S/SS9S	9n[        R                  " X#5        UR                  SS S
9n[        SS/[        S/SS9S	9n[        R                  " X#5        g )Nr   r4   r   r¯  rm   rn   r±  r¥   r«   r¡  r   )r
   r=  r   rI   rJ   r»  s       r   Útest_pivot_values_is_noneÚ#TestPivot.test_pivot_values_is_nonea
  s•   € ä˜q˜c¨°Ñ2Ó3ˆà—‘ #¨S¸�Ð>ˆÜØ”U˜A˜3 SÑ)´5¸!¸À3Ñ3Gñ
ˆô 	×Ò˜fÔ/à—‘ #¨d�Ð3ˆÜ˜Q q c´5¸!¸À3Ñ3GÑHˆÜ
×Ò˜fÕ/r   c                 ó�   • [        S/SSS.5      nUR                  SS9nUR                  SSS	S
9  [        R                  " X5        g )Nrl   r   r   )r0   r1   ÚthreeT)Údeepr0   r1   r»  r   )r
   rï  r=  rI   rJ   )r@   rf   rT   s      r   Ú"test_pivot_not_changing_index_nameÚ,TestPivot.test_pivot_not_changing_index_nameo
  sE   € ä ˜u¨Q¸Ñ;Ó<ˆØ—7‘7 �7Ð%ˆØ
�‰�u e°GˆÑ<Ü
×Ò˜bÕ+r   c                 ó˜   • [        / / SQS9nUR                  SSSSS9n[        / SSS	9n[        R                  " UR
                  U5        g )
N)rl   rm   r  r¬   rl   rm   r  rÈ  ra  r�  rt  )r
   r   r   rI   r„   rF   ©r@   rf   r=  rT   s       r   Ú.test_pivot_table_empty_dataframe_correct_indexÚ8TestPivot.test_pivot_table_empty_dataframe_correct_indexv
  sG   € ä�rÒ#6Ñ7ˆØ—‘ S°#¸gÈw�ÐWˆä˜ 8°#Ñ6ˆÜ
×Ò˜eŸm™m¨XÕ6r   c           	      óü  • [        SSSS.SSSS.SS	S
S./5      n[        R                  " US   5      US'   [        R                  " S5         UR                  SS/S/SSS9nS S S 5        [        R                  " S[        R                  " SS5      4S[        R                  " SS5      4S[        R                  " SS5      4S/SS/S9n[        R                  " WR                  U5        g ! , (       d  f       N�= f)Nrp   z
2023-01-01r   )rl   Údate_strr~   rq   z
2023-01-02r4   rr   z
2023-01-03r   rÄ  r   Frl   r~   r`   T)rE   rD   ra   rÏ   z2023-01-01 00:00:00z%Y-%m-%d %H:%M:%Sz2023-01-02 00:00:00z2023-01-03 00:00:00rÄ  r‚   )r
   r!   Úto_datetimerI   r˜   r   r   rƒ   r   Ústrptimer„   rE   rÀ  s       r   Ú0test_pivot_table_handles_explicit_datetime_typesÚ:TestPivot.test_pivot_table_handles_explicit_datetime_types~
  s  € äà |¸qÑAØ |¸qÑAØ |¸qÑAðó
ˆô —^’^ B z¡NÓ3ˆˆ6‰
ä×'Ò'¨Õ.Ø—N‘NØ˜F�m¨X¨JÀÈtð #ð ˆE÷ /ô
 ×)Ò)à”h×'Ò'Ð(=Ð?RÓSÐTØ”h×'Ò'Ð(=Ð?RÓSÐTØ”h×'Ò'Ð(=Ð?RÓSÐTØð	ð ˜�-ñ
ˆô 	×Ò˜eŸk™k¨8Õ4÷ /Õ.ús   ÁC-Ã-
C;c           	      óÖ   • [        / SQ/ SQ/ SQ/ SQ/5      nUR                  SSSSSS	S
9n[        / SQ/ SQ/ SQ/[        / SQSS9[        / SQSS9S9n[        R                  " X#5        g )Nr`  ra  rb  rc  r   r   r4   r`   Trd  re  rf  rg  rh  r¥   ri  rû  rº  r»  s       r   Ú6test_pivot_table_with_margins_and_numeric_column_namesÚ@TestPivot.test_pivot_table_with_margins_and_numeric_column_names™
  sq   € äš¢}²mÂ]ÐSÓTˆà—‘Ø˜Q q°%ÀAÈtð  ð 
ˆô Úš<ªÐ7ÜÒ0°qÑ9ÜÒ)°Ñ2ñ
ˆô
 	×Ò˜fÕ/r   râ   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‰  r‰  ´	  sx   † ò:ò:	;òCò	@ò"0òH$#òLð ‡[�[×ÑÙÓÐ%Mð ð ñ0óð0ò0ò0ò,ò7ò5õ60r   r‰  )'r   r   r   Ú	itertoolsr   rÈ  Únumpyr<   r—  Úpandas._configr   Úpandas.errorsr   Úpandasr!   r	   r
   r   r   r   r   r   r   Úpandas._testingÚ_testingrI   Úpandas.api.typesr   Úpandas.core.reshaper   r  Úpandas.core.reshape.pivotr   rƒ  r   r®   r'   r)   r‰  râ   r   r   Ú<module>rÖ     sÃ   ð÷ñ õ
 Û 	ã Û å -å ,ã ÷	÷ 	ó 	õ Ý -Ý 6Ý 1ð ‡‚˜˜e�}Ñ%ñó &ðð ‡‚˜!˜˜q™ 1 #¨¡'Ð*©U°1«X±u¸QÀ³{Ð,CÐDÑEñJó FðJ÷
E&0ñ E&0÷PLr0ò r0r   