ó
    ®œ‘h‚]  ã                   ó   • S SK Jr  S SKrS SKrS SKJr  S SKrS SKJ	r	J
r
JrJrJr  S SKJr  S SKJr  \R&                  S 5       rS rS rS	 rS
 rS rS rS r\R8                  R;                  S/ SQ5      S 5       rS r\R8                  R;                  SSS/5      S 5       r S r!S r"S r#S r$S r%S r&S r'S r(S r)S r*\R8                  R;                  SS /S S!//5      S" 5       r+\R8                  R;                  S#S$S%/5      S& 5       r,\R8                  R;                  S'S S(/5      S) 5       r-S* r.\R8                  R;                  SS /S S!//5      S+ 5       r/S, r0S- r1S. r2S/ r3S0 r4\R8                  R;                  S1S2S3/5      S4 5       r5g)5é    )ÚdedentN)Úis_platform_windows)Ú	DataFrameÚIndexÚSeriesÚTimedeltaIndexÚ	Timestamp)Ú
date_rangec            	      óz   • [        S/S-  S/S-  -   S/S-  -   [        R                  " S5      S.[        S	S
SS9S9$ )Né   é   é   é   é   é   é(   ©ÚAÚBú1/1/2000Ús©ÚfreqÚperiods©Úindex)r   ÚnpÚaranger
   © ó    ÚpC:\Users\psant\Downloads\Noiseback\school\venv\Lib\site-packages\pandas/tests/resample/test_resampler_grouper.pyÚ
test_framer"      sG   € äØˆc�B‰h˜!˜˜r™Ñ! Q C¨!¡GÑ+´"·)²)¸B³-Ñ@Ü˜¨#°rÑ:ñð r    c                 ó4  • SSK Jn  [        S5      nU R                  U5        [        R
                  " S SS9   U" S5         [        U R                  R                  SS5      5        S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       g = f)	Nr   )Úprovisionalcompleterzã    import numpy as np
    from pandas import Series, date_range
    data = np.arange(10, dtype=np.float64)
    index = date_range("2020-01-01", periods=len(data))
    s = Series(data, index=index)
    rs = s.resample("D")
    F)Úraise_on_extra_warningsÚignorezrs.r   )	ÚIPython.core.completerr$   r   Úrun_cellÚtmÚassert_produces_warningÚlistÚ	CompleterÚcompletions)Úipr$   Úcodes      r!   Ú"test_tab_complete_ipython6_warningr0      st   € Ý;äð	ó	€Dð ‡K�K�Ôô 
×	#Ò	# DÀ%Ó	HÙ! (Õ+Ü�—‘×)Ñ)¨%°Ó3Ô4÷ ,÷ 
IÐ	Hß+Õ+ú÷ 
IÕ	Hús#   ¸	B	Á&A8Á'B	Á8
B	ÂB	Â	
Bc                  ód  • / SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ SQ/ S	Q/ S
Q/
n [        U / SQS9n[        R                  " UR                  5      Ul        S nSn[        R
                  " [        US9   UR                  S5      R                  U5      nS S S 5        Sn[        R
                  " [        US9   UR                  S5      R                  S5      R                  S5      R                  5       nS S S 5        [        R                  " WW5        [        [        SSSS9/ SQ/ SQS.5      R                  S5      nS nSn[        R
                  " [        US9   UR                  S5      R                  U5      nS S S 5        Sn[        R
                  " [        US9   UR                  S5      R                  S5      R                  5       nS S S 5        [        R                  " XT5        g ! , (       d  f       GNb= f! , (       d  f       GN= f! , (       d  f       N›= f! , (       d  f       NZ= f)N)ú
2010-01-01r   r   )z
2010-01-02r   r   )z
2010-01-05r   r   )z
2010-01-10r   é   )z
2010-01-13r   r   )r2   r   é   )z
2010-01-03r   r   )z
2010-01-04r   r   )z
2010-01-11r   r3   )z
2010-01-14r   r   )ÚdateÚidÚscore©Úcolumnsc                 ó^   • U R                  S5      R                  S5      R                  5       $ )Nr5   ÚD)Ú	set_indexÚresampleÚasfreq©Úxs    r!   Úf_0Ú'test_deferred_with_groupby.<locals>.f_0E   s%   € Ø�{‰{˜6Ó"×+Ñ+¨CÓ0×7Ñ7Ó9Ð9r    ú7DataFrameGroupBy.apply operated on the grouping columns©Úmatchr6   ú:DataFrameGroupBy.resample operated on the grouping columnsr5   r;   ú
2016-01-01é   ÚW)Ústartr   r   ©r   r   r   r   )r4   é   r3   r   ©r5   ÚgroupÚvalc                 ó@   • U R                  S5      R                  5       $ )NÚ1D)r=   Úffillr?   s    r!   Úf_1Ú'test_deferred_with_groupby.<locals>.f_1X   s   € Ø�z‰z˜$Ó×%Ñ%Ó'Ð'r    rN   rQ   )r   ÚpdÚto_datetimer5   r)   r*   ÚFutureWarningÚgroupbyÚapplyr<   r=   r>   Úassert_frame_equalr
   rR   )ÚdataÚdfrA   ÚmsgÚexpectedÚresultrS   s          r!   Útest_deferred_with_groupbyr`   2   s·  € ò 	ÚÚÚÚÚÚÚÚÚð€Dô 
�4Ò!8Ñ	9€BÜ�nŠn˜RŸW™WÓ%€B„Gò:ð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—:‘:˜dÓ#×)Ñ)¨#Ó.ˆ÷ 
>à
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜fÓ%×-Ñ-¨dÓ3×<Ñ<¸SÓA×HÑHÓJˆ÷ 
>ä×Ò˜& (Ô+ä	ä \¸1À3ÑGÚ!Úñ	
ó
÷ �i�Óð ò(ð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—:‘:˜gÓ&×,Ñ,¨SÓ1ˆ÷ 
>à
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜GÓ$×-Ñ-¨dÓ3×9Ñ9Ó;ˆ÷ 
>ä×Ò˜&Õ+÷1 
>Ö	=ú÷ 
>Ö	=ú÷  
>Õ	=ú÷ 
>Õ	=ús0   Á0!G,Â4>G>Å!HÆ/H!Ç,
G;Ç>
HÈ
HÈ!
H/c                 óB  • U R                  S5      nUR                  R                  S 5      nUR                  S5      R                  R	                  5       n[
        R                  " X25        UR                  R                  S5      R	                  5       n[
        R                  " X25        Sn[
        R                  " [        US9   UR                  S5      R	                  5       R                  nS S S 5        [
        R                  " X25        g ! , (       d  f       N%= f)Nr   c                 ó@   • U R                  S5      R                  5       $ ©NÚ2s)r=   Úmeanr?   s    r!   Ú<lambda>Útest_getitem.<locals>.<lambda>g   s   €  1§:¡:¨dÓ#3×#8Ñ#8Ô#:r    rd   rF   rD   )	rX   r   rY   r=   re   r)   Úassert_series_equalr*   rW   )r"   Úgr^   r_   r]   s        r!   Útest_getitemrj   d   sÇ   € Ø×Ñ˜3Ó€Aà�s‰s�y‰yÑ:Ó;€Hà�Z‰Z˜Ó×Ñ×$Ñ$Ó&€FÜ×Ò˜6Ô,à�S‰S�\‰\˜$Ó×$Ñ$Ó&€FÜ×Ò˜6Ô,à
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜DÓ!×&Ñ&Ó(×*Ñ*ˆ÷ 
>ä×Ò˜6Õ,÷ 
>Õ	=ús   Ã*DÄ
Dc                  ó’  • SSS.SSS./n [        U [        SSS9S9nUR                  S	5      R                  S
5      nUS   R	                  5       n[
        R                  R                  SS/UR                  /SS9n[        SS/USS9n[        R                  " X55        US   R	                  5       n[        R                  " X55        g )Nr   r   )r6   Úbuyerr   r   rG   ©r   r   r6   rQ   rl   )r6   N©Únames©r   Úname)r   r
   rX   r=   ÚcountrU   Ú
MultiIndexÚfrom_arraysr   r   r)   rh   )r[   r\   Úrr_   Úexp_mir^   s         r!   Útest_getitem_multiplerw   u   sÃ   € ð ˜sÑ#¨A¸Ñ%<Ð=€DÜ	�4œz¨,ÀÑBÑ	C€BØ
�
‰
�4Ó×!Ñ! $Ó'€AØˆw‰Z×ÑÓ€Fä�]‰]×&Ñ&¨¨A¨°·±Ð'9ÀÐ&ÐN€FÜØ	
ˆAˆØØñ€Hô
 ×Ò˜6Ô,àˆw‰Z×ÑÓ€FÜ×Ò˜6Õ,r    c                  óP  • [        [        S5      [        SSS9SS.5      n U R                  S5      R	                  S5      R                  S	5      S
   R                  5       nU R	                  S5      R                  S	SS9S
   R                  5       n[        R                  " X!5        g )NÚaabbbz1-1-2016r4   rm   r   )r6   r5   r[   r5   r6   Ú2Dr[   ©Úon)	r   r+   r
   r<   rX   r=   Úsumr)   rh   )r\   Úexpr_   s      r!   Ú)test_groupby_resample_on_api_with_getitemr   ‰   s�   € ä	Ü�G‹}¤j°ÀQÑ&GÐQRÑSó
€Bð �,‰,�vÓ
×
&Ñ
& tÓ
,×
5Ñ
5°dÓ
;¸FÑ
C×
GÑ
GÓ
I€CØ�Z‰Z˜Ó×&Ñ& t°Ð&Ð7¸Ñ?×CÑCÓE€FÜ×Ò˜6Õ'r    c                  ód  • Sn Su  pSn[        XSS9n[        [        R                  R	                  S5      R                  [        U5      5      US9nXSU n[        R                  " U S9nUR                  U5      R                  S5      nXƒU nUR                  U5      R                  S5      n	[        R                  " [        S	S
9   [        R                  " UR                   U	R                   5        S S S 5        [#        S5      n
[        R                  " X
S9nUR                  U5      R                  S5      nXÃU nUR                  U5      R                  S5      n[        R$                  " XÍ5        [#        S5      [        R&                  " S5      S-  -   n[        R                  " XS9nUR                  U5      R                  S5      nUX2 nUR                  U5      R                  S5      n[        R$                  " UU5        [        R$                  " UU5        g ! , (       d  f       GN4= f)NÚ1399min)z1/1/2000 00:00:00z1/31/2000 00:00z1/15/2000 00:00:00Ú1231min©r   r   r   rr   zIndex are differentrD   r   )r   Úorigini0u  )r
   r   r   ÚrandomÚdefault_rngÚstandard_normalÚlenrU   ÚGrouperrX   ÚaggÚpytestÚraisesÚAssertionErrorr)   Úassert_index_equalr   r	   rh   Ú	Timedelta)r   rJ   ÚendÚmiddleÚrngÚtsÚts2Úsimple_grouperÚcount_tsÚ	count_ts2r„   Úadjusted_grouperÚadjusted_count_tsÚadjusted_count_ts2Úorigin_futureÚadjusted_grouper2Úadjusted2_count_tsÚadjusted2_count_ts2s                     r!   Útest_groupby_with_originrŸ   “   sÕ  € ð €DØ7�J€EØ!€Fä
�U iÑ
0€CÜ	”—	‘	×%Ñ% aÓ(×8Ñ8¼¸S»ÓBÈ#Ñ	N€BØ
�Cˆ.€Cô —Z’Z TÑ*€NØ�z‰z˜.Ó)×-Ñ-¨gÓ6€HØ˜sÐ#€HØ—‘˜NÓ+×/Ñ/°Ó8€IÜ	�Š”~Ð-BÓ	CÜ
×Ò˜hŸn™n¨i¯o©oÔ>÷ 
Dô �q‹\€FÜ—z’z tÑ;ÐØŸ
™
Ð#3Ó4×8Ñ8¸ÓAÐØ)°Ð5ÐØŸ™Ð%5Ó6×:Ñ:¸7ÓCÐÜ×ÒÐ,ÔAô ˜a“L¤2§<¢<°	Ó#:¸VÑ#CÑC€MÜŸ
š
¨ÑCÐØŸ™Ð$5Ó6×:Ñ:¸7ÓCÐØ+¨FÐ7ÐØŸ+™+Ð&7Ó8×<Ñ<¸WÓEÐÜ×ÒÐ-Ð/BÔCô ×ÒÐ,Ð.AÕB÷+ 
DÖ	Cús   Ã,H È 
H/c            	      óê   • [        SSSS9n [        [        S5      U S9R                  S5      R	                  5       n[        / SQ[
        R                  " / SQS	SS
9S9n[        R                  " X5        g )Nr   r   Úmin©r   r   r   Ú20s)r   r   r   r   r   r   r   )z2000-01-01 00:00:00z2000-01-01 00:00:20z2000-01-01 00:00:40z2000-01-01 00:01:00z2000-01-01 00:01:20z2000-01-01 00:01:40z2000-01-01 00:02:00zdatetime64[ns])Údtyper   )	r
   r   Úranger=   ÚnearestrU   ÚDatetimeIndexr)   rh   )r   r_   r^   s      r!   Útest_nearestr¨   ¼   sn   € ô �z¨1°5Ñ9€EÜ”E˜!“H EÑ*×3Ñ3°EÓ:×BÑBÓD€FäÚÜ×Òòð #Øñ
ñ€Hô  ×Ò˜6Õ,r    Úf)ÚfirstÚlastÚmedianÚsemr}   re   r¡   ÚmaxÚsizerr   r¦   ÚbfillrR   r>   Úohlcc                 ó˜  ^ • UR                  S5      nUR                  S5      nSn[        R                  " [        US9   [        UT 5      " 5       nS S S 5        Sn[        R                  " [        US9   UR                  U 4S j5      nS S S 5        [        R                  " WW5        g ! , (       d  f       N_= f! , (       d  f       N7= f)Nr   rd   rF   rD   rC   c                 óD   >• [        U R                  S5      T5      " 5       $ rc   ©Úgetattrr=   ©r@   r©   s    €r!   rf   Útest_methods.<locals>.<lambda>ò   s   ø€ ¤W¨Q¯Z©Z¸Ó-=¸qÔ%AÔ%Cr    )rX   r=   r)   r*   rW   rµ   rY   Úassert_equal©r©   r"   ri   ru   r]   r_   r^   s   `      r!   Útest_methodsrº   Õ   s“   ø€ ð* 	×Ñ˜3Ó€AØ	�
‰
�4Ó€Aà
F€CÜ	×	#Ò	#¤M¸Ó	=Ü˜˜A”“ˆ÷ 
>à
C€CÜ	×	#Ò	#¤M¸Ó	=Ø—7‘7ÔCÓDˆ÷ 
>ä‡O‚O�F˜HÕ%÷ 
>Õ	=ú÷ 
>Õ	=ús   ¿B*Á4B;Â*
B8Â;
C	c                 óà   • U R                  S5      nUR                  S5      nUR                  R                  5       nUR                  R	                  S 5      n[
        R                  " X45        g )Nr   rd   c                 ó@   • U R                  S5      R                  5       $ rc   )r=   Únuniquer?   s    r!   rf   Ú&test_methods_nunique.<locals>.<lambda>û   s   €  1§:¡:¨dÓ#3×#;Ñ#;Ô#=r    )rX   r=   r   r½   rY   r)   rh   )r"   ri   ru   r_   r^   s        r!   Útest_methods_nuniquer¿   ö   sP   € à×Ñ˜3Ó€AØ	�
‰
�4Ó€AØ�S‰S�[‰[‹]€FØ�s‰s�y‰yÑ=Ó>€HÜ×Ò˜6Õ,r    ÚstdÚvarc                 ó–  ^ • UR                  S5      nUR                  S5      nSn[        R                  " [        US9   [        UT 5      " SS9nS S S 5        Sn[        R                  " [        US9   UR                  U 4S j5      nS S S 5        [        R                  " WW5        g ! , (       d  f       N_= f! , (       d  f       N7= f)	Nr   rd   rF   rD   r   ©ÚddofrC   c                 óB   >• [        U R                  S5      T5      " SS9$ )Nrd   r   rÃ   r´   r¶   s    €r!   rf   Ú&test_methods_std_var.<locals>.<lambda>  s   ø€ ¤W¨Q¯Z©Z¸Ó-=¸qÔ%AÀqÒ%Ir    )rX   r=   r)   r*   rW   rµ   rY   rZ   r¹   s   `      r!   Útest_methods_std_varrÇ   ÿ   s–   ø€ à×Ñ˜3Ó€AØ	�
‰
�4Ó€AØ
F€CÜ	×	#Ò	#¤M¸Ó	=Ü˜˜A” AÑ&ˆ÷ 
>à
C€CÜ	×	#Ò	#¤M¸Ó	=Ø—7‘7ÔIÓJˆ÷ 
>ä×Ò˜& (Õ+÷ 
>Õ	=ú÷ 
>Õ	=ús   ¿B)Á3B:Â)
B7Â:
Cc                 ó�  • U R                  S5      nUR                  S5      nSn[        R                  " [        US9   UR                  S5      R                  5       nS S S 5        S nSn[        R                  " [        US9   UR                  U5      nS S S 5        [        R                  " WW5        S nSn[        R                  " [        US9   UR                  U5      nS S S 5        UR                  S5      n[        R                  " Xd5        g ! , (       d  f       N½= f! , (       d  f       N–= f! , (       d  f       NX= f)	Nr   rd   rF   rD   c                 ó@   • U R                  S5      R                  5       $ rc   )r=   r}   r?   s    r!   rA   Útest_apply.<locals>.f_0  s   € Ø�z‰z˜$Ó×#Ñ#Ó%Ð%r    c                 óD   • U R                  S5      R                  S 5      $ )Nrd   c                 ó"   • U R                  5       $ ©N©r}   )Úys    r!   rf   Ú)test_apply.<locals>.f_1.<locals>.<lambda>  s
   € °·±´r    )r=   rY   r?   s    r!   rS   Útest_apply.<locals>.f_1  s   € Ø�z‰z˜$Ó×%Ñ%Ñ&7Ó8Ð8r    rC   Úint64)	rX   r=   r)   r*   rW   r}   rY   rZ   Úastype)r"   ri   ru   r]   r^   rA   r_   rS   s           r!   Ú
test_applyrÔ     sû   € Ø×Ñ˜3Ó€AØ	�
‰
�4Ó€Að G€CÜ	×	#Ò	#¤M¸Ó	=Ø—:‘:˜dÓ#×'Ñ'Ó)ˆ÷ 
>ò&ð G€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜“ˆ÷ 
>ä×Ò˜& (Ô+ò9ð D€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜“ˆ÷ 
>ð �‰˜wÓ'€HÜ×Ò˜&Õ+÷' 
>Õ	=ú÷ 
>Õ	=ú÷ 
>Õ	=ús#   ¾ DÂD&ÃD7Ä
D#Ä&
D4Ä7
Ec                  óL  • [        SSSS9n [        S[        R                  R	                  S5      R                  [        U 5      5      0U S9nS nUR                  [        R                  " S	S95      R                  U5      nUR                  S	5      R                  U5      n[        R                  " XC5        US   R                  [        R                  " S	S9S
S9R                  U5      nUS   R                  S	5      R                  U5      n[        R                  " XC5        g )Nz1-1-2015z12-31-15r;   rƒ   Úcol1r   ©r[   r   c                 ó"   • [        SS/SS/S9nU$ )Nr   r   ÚaÚbr   )r   )r@   r   s     r!   r©   Ú(test_apply_with_mutated_index.<locals>.f/  s   € Ü�A�q�6 # s Ñ,ˆØˆr    ÚMEF)Ú
group_keys)r
   r   r   r…   r†   rˆ   rX   rU   r‰   rY   r=   r)   rZ   rh   )r   r\   r©   r^   r_   s        r!   Útest_apply_with_mutated_indexrÞ   (  sï   € ä�z :°CÑ8€EÜ	Ø”b—i‘i×+Ñ+¨AÓ.×5Ñ5´c¸%³jÓAÐBÈ%ñ
€Bòð �z‰zœ"Ÿ*š*¨$Ñ/Ó0×6Ñ6°qÓ9€Hà�[‰[˜Ó×$Ñ$ QÓ'€FÜ×Ò˜&Ô+ð �&‰z×!Ñ!¤"§*¢*°$Ñ"7ÀEÐ!ÐJ×PÑPÐQRÓS€HØ�‰Z× Ñ  Ó&×,Ñ,¨QÓ/€FÜ×Ò˜6Õ,r    c            	      ó:  ^• [         R                  R                  SS/5      n [        SSSS9n[	        [
        R                  " S/S-  5      R                  SS	5      XS
9nUR                   Vs0 s H,  o3US   S:X  a  [
        R                  O[
        R                  _M.     snmUR                  S5      R                  U4S j5      n[	        S	SS//-  [        SSS	S9[         R                  R                  SS/5      S
9n[        R                  " XE5        g s  snf )N)r   rÙ   Ú Úone)r   rÚ   ÚiÚtwoz
2017-01-01Ú15Minr   )rJ   r   r   r   é   r   ©r   r9   r   rá   Úhc                 ó.   >• TU R                      " U 5      $ rÍ   ©rq   )r@   Úagg_dicts    €r!   rf   Ú/test_apply_columns_multilevel.<locals>.<lambda>D  s   ø€ ¨h°q·v±vÒ.>¸qÔ.Ar    g        Ú1h)rU   rs   Úfrom_tuplesr
   r   r   ÚarrayÚreshaper9   r}   re   r=   rY   r)   rZ   )ÚcolsÚindr\   Úcolr_   r^   rê   s         @r!   Útest_apply_columns_multilevelró   >  sñ   ø€ ä�=‰=×$Ñ$Ð&;Ð=SÐ%TÓU€DÜ
˜<¨g¸qÑ
A€CÜ	”2—8’8˜Q˜C "™HÓ%×-Ñ-¨a°Ó3¸3Ñ	M€BØIKÏÊÓTÊÀ#  A¡¨%£”b—f’f´R·W±WÒ<ÉÑT€HØ�[‰[˜Ó×#Ñ#Ô$AÓB€FÜØ	ˆa�ˆXˆJ‰Ü˜|°$ÀÑBÜ—‘×)Ñ)Ø"Ð$:Ð;ó
ñ€Hô ×Ò˜&Õ+ùò Us   Á.3Dc                  óê   • S n [        SSSSS9n[        / SQUS9n[        / S	QUS9nUR                  S
5      R                  XSS9n[        SSS
SS9n[        S/US9n[        R
                  " XF5        g )Nc                 óÞ   • U R                  5       n UR                  U R                  5      R                  S5      R	                  5       nUR
                  S   U-  nXU:¬     R
                  S   $ )Nr   éÿÿÿÿ)Úsort_valuesÚreindexr   ÚfillnaÚcumsumÚiloc)ÚseriesÚweightsÚqrú   Úcutoffs        r!   Úweighted_quantileÚ5test_apply_non_naive_index.<locals>.weighted_quantileP  sa   € Ø×#Ñ#Ó%ˆØ—‘ §¡Ó.×5Ñ5°aÓ8×?Ñ?ÓAˆØ—‘˜R‘ 1Ñ$ˆØ Ñ&Ñ'×,Ñ,¨QÑ/Ð/r    z2017-6-23 18:00r   Ú15minÚUTC)r   r   Útz)ç      ð?r   r   r   r   r   r   r   r   )g      d@é[   éA   é+   é   é
   r   r   r;   g      à?)rý   rþ   z2017-06-23 00:00:00+00:00)r   r  r  )r
   r   r=   rY   r)   rh   )r   Útimesr[   rý   r_   rñ   r^   s          r!   Útest_apply_non_naive_indexr  O  s…   € ò0ô Ð(°!¸'ÀeÑL€EÜÒ,°EÑ:€DÜÒ6¸eÑD€Gà�]‰]˜3Ó×%Ñ%Ð&7ÈCÐ%ÐP€FÜ
Ø#Ð%@ÀsÈuñ€Cô �s�e 3Ñ'€HÜ×Ò˜6Õ,r    c                 ó  • [        SSSU S9n[        U/ SQ/ SQS.S9nS	n[        R                  " [        US
9   UR                  S5      R                  SSS9R                  5       nS S S 5        [        R                  " / SQ[        R                  S9[        R                  " / SQSU  S3S9/n[        R                  R                  USS /S9n[        / SQ/ SQS.US9n[        R                  " WU5        g ! , (       d  f       N—= f)Nú
2000-01-01rz   r4   )r   r   Úunit)r   r   r   r   r   )r   r   r   r   r   )Úcol0rÖ   )r   r[   rF   rD   r  Ú1WÚleft)Úlabel)r   r   r   r   ©r¤   )z
1999-12-26ú
2000-01-02r  r  zM8[Ú]rn   )r   r   r   r   )r   r   r   r   r×   )r
   r   r)   r*   rW   rX   r=   r}   r   rî   rÒ   rU   rs   rt   rZ   )r  r   r\   r]   r_   ÚmiÚmindexr^   s           r!   Ú test_resample_groupby_with_labelr  b  sç   € ä�|¨$¸ÀÑE€EÜ	˜ªoÂÑ%WÑ	X€BØ
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜FÓ#×,Ñ,¨T¸Ð,Ð@×DÑDÓFˆ÷ 
>ô 	�Š’¤R§X¡XÑ.Ü
�ŠÚDØ˜�v˜Q�-ñ	
ð
€Bô �]‰]×&Ñ& r°&¸$°Ð&Ð@€FÜÚ"ªLÑ9Àñ€Hô ×Ò˜& (Õ+÷ 
>Õ	=ús   ¹.C8Ã8
Dc                 ój  • U n[        / SQSS9nSn[        R                  " [        US9   UR	                  S5      R                  S5      R                  5       nS S S 5        WR                  R                  S:X  d   e[        R                  " UR                  R                  S   U5        UR	                  S5      R                  S	5      R                  5       nUR                  R                  S:X  d   e[        R                  " UR                  R                  S   U5        g ! , (       d  f       NÑ= f)
N©r   r   r   r   ré   rF   rD   rd   r   r   r   )r   r)   r*   rW   rX   r=   re   r   ÚnlevelsrŽ   ÚlevelsÚrolling)r"   r\   r^   r]   r_   s        r!   Útest_consistency_with_windowr  y  sæ   € à	€BÜ’Y SÑ)€HØ
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×)Ñ)¨$Ó/×4Ñ4Ó6ˆ÷ 
>à�<‰<×Ñ 1Ó$Ð$Ð$Ü×Ò˜&Ÿ,™,×-Ñ-¨aÑ0°(Ô;à�Z‰Z˜‹_×$Ñ$ RÓ(×-Ñ-Ó/€FØ�<‰<×Ñ 1Ó$Ð$Ð$Ü×Ò˜&Ÿ,™,×-Ñ-¨aÑ0°(Õ;÷ 
>Õ	=ús   ª/D$Ä$
D2c            
      ó’  • [        [        R                  R                  S5      R	                  S5      [        S5      [        SSSS9S9n U R                  5       n/ S	QUl        UR                  S
5      R                  5       nU R                  S
5      R                  5       nUR                  Ul        [        R                  " X25        g )Nr   )r   r   Úaaaú
2012-01-01r   r   r¢   ©r9   r   )rÙ   rÚ   ÚcÚ5s)r   r   r…   r†   r‡   r+   r
   Úcopyr9   r=   r¬   r)   rZ   )r\   Údf2r^   r_   s       r!   Útest_median_duplicate_columnsr(  ˆ  sš   € ô 
Ü
�	‰	×Ñ˜aÓ ×0Ñ0°Ó9Ü�U“Ü˜¨r¸Ñ<ñ
€Bð
 �'‰'‹)€CÚ!€C„KØ�|‰|˜DÓ!×(Ñ(Ó*€HØ�[‰[˜Ó×%Ñ%Ó'€FØ—~‘~€HÔÜ×Ò˜&Õ+r    c            	      ó\  • [        [        S5      [        SS5      S.[        SSSS9S9n U R                  S5      R	                  S	 5      n[        / S
Q[        SSSS9S9n[        R                  " X5        U R                  S5      R	                  S 5      n[        R                  " X5        g )Nr
  r   )rò   rÖ   r"  Ú20minr¢   r   rç   c                 ó6   • U R                   R                  5       $ rÍ   )rò   r}   ©rN   s    r!   rf   Ú0test_apply_to_one_column_of_df.<locals>.<lambda>   s   € °%·)±)·-±-´/r    )r   r   é   é	   rH   c                 ó(   • U S   R                  5       $ )Nrò   rÎ   r,  s    r!   rf   r-  §  s   € °%¸±,×2BÑ2BÔ2Dr    )r   r¥   r
   r=   rY   r   r)   rh   )r\   r_   r^   s      r!   Útest_apply_to_one_column_of_dfr1  ˜  s˜   € ä	Ü�b“	¤5¨¨R£=Ñ1Ü˜¨r¸Ñ@ñ
€Bð �[‰[˜Ó×#Ñ#Ñ$AÓB€FÜÚœj¨¸qÀsÑKñ€Hô ×Ò˜6Ô,ð �[‰[˜Ó×#Ñ#Ñ$DÓE€FÜ×Ò˜6Õ,r    c                  ó  • [        / SQ/ SQ/ SQS.5      n [        R                  " U S   5      U S'   U R                  S5      R	                  SSS9nUS	/   R                  5       nUR                  S	S
05      n[        R                  " X25        g )N)Úcat_1r3  Úcat_2r3  r4  r3  r4  r3  )r4   r   é   r   rH   é   r
  é2   )z2019-2-1z
2018-02-03ú	2020-3-11ú2019-2-2r9  z	2018-12-4r8  z
2020-12-12)ÚcatÚnumr5   r5   r:  ÚYEr{   r;  r}   )	r   rU   rV   rX   r=   r}   rŠ   r)   rZ   )r\   Ú	resampledr^   r_   s       r!   Útest_resample_groupby_aggr>  «  s‹   € ä	ò	ò 1ò	ñ	
ó
€Bô2 —’  6¡
Ó+€B€v�Jà—
‘
˜5Ó!×*Ñ*¨4°FÐ*Ð;€IØ˜%˜Ñ!×%Ñ%Ó'€HØ�]‰]˜E 5˜>Ó*€Fä×Ò˜&Õ+r    c                  óD  • [        S5      n [        S/S/S.[        U /SS9S9nUR                  S5      R	                  S	5      S
   nUR                  SS/5      n[        SS//[        R                  R                  SU 4/SS/S9SS/S9n[        R                  " X45        g )Nz2021-02-28 00:00:00ÚbetaéE   )ÚclassÚvaluer5   ré   r   rB  rÜ   rC  r}   r¯   r   rn   ræ   )r	   r   r   rX   r=   rŠ   rU   rs   rí   r)   rZ   )r“   r\   r=  r_   r^   s        r!   Ú"test_resample_groupby_agg_listlikerD  Ï  s§   € ä	Ð(Ó	)€BÜ	˜f˜X°°Ñ5¼UÀBÀ4ÈfÑ=UÑ	V€BØ—
‘
˜7Ó#×,Ñ,¨TÓ2°7Ñ;€IØ�]‰]˜E 6˜?Ó+€FÜØ
ˆaˆˆ	Ü�m‰m×'Ñ'¨&°"¨¨¸wÈÐ>OÐ'ÐPØ˜�ñ€Hô
 ×Ò˜&Õ+r    ÚkeysrÙ   rÚ   c                 óî  • [        / SS/[        / 5      S9nSn[        R                  " [        US9   UR                  U 5      R                  [        R                  " S5      S9R                  5       nS S S 5        [        SS/S9R                  U S	S
9R                  [        / 5      SS9n[        U 5      S:X  a  U S   UR                  l        [        R                  " WU5        g ! , (       d  f       Ny= f)NrÙ   rÚ   r#  rF   rD   ú00:00:01©Úruler8   F©ÚdropT)Úappendr   r   )r   r   r)   r*   rW   rX   r=   rU   Úto_timedeltare   r<   rˆ   r   rq   rZ   ©rE  r\   r]   r_   r^   s        r!   Ú
test_emptyrO  Ý  sÍ   € ô 
�2  S˜z´ÀÓ1CÑ	D€BØ
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜DÓ!×*Ñ*´·²À
Ó0KÐ*ÐL×QÑQÓSˆ÷ 
>ô 	˜3 ˜*Ñ%ß	‰�4˜eˆÐ	$ß	‰”> "Ó%¨dˆÐ	3ð ô
 ˆ4ƒy�Aƒ~Ø" 1™gˆ�‰Ôä×Ò˜& (Õ+÷ 
>Õ	=ús   ²AC&Ã&
C4ÚconsolidateTFc                 óâ  • [        SSSS9n[        SU[        S5      SS.5      n[        SU[        S5      S	.5      n[        R                  " X#/S
S9nU (       a  UR                  5       nSn[        R                  " [        US9   UR                  S/5      R                  SSS9R                  5       nS S S 5        [        R                  R                  S/S-  S/S-  -   [        R                  " / SQS-  5      R                  S5      /SS/S9n[        S/S-  S/S-  -   / SQS-  S/S-  [         R"                  /S-  -   S.US9n[        R$                  " WU5        g ! , (       d  f       N²= f)Nz
2020-01-01é   r;   r¢   r   rO   )Úkeyr5   rÖ   Ú
col_objectr   )rS  r5   rÖ   T)Úignore_indexrF   rD   rS  rI   r5   r{   r   )z
2020-01-05z
2020-01-12z
2020-01-19r   Únsrn   )r   r4   r   )rS  rÖ   rT  r   )r
   r   r¥   rU   ÚconcatÚ_consolidater)   r*   rW   rX   r=   r¡   rs   rt   rV   Úas_unitr   ÚnanrZ   )	rP  ÚdatesÚdf1r'  r\   r]   r_   Úidxr^   s	            r!   Ú.test_resample_groupby_agg_object_dtype_all_nanr^  ï  sb  € ô �|¨R°cÑ:€EÜ
˜C¨¼¸b»	ÐQVÑWÓ
X€CÜ
˜C¨¼¸b»	ÑBÓ
C€CÜ	�Š�C�:¨DÑ	1€BÞØ�_‰_Óˆà
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜U˜GÓ$×-Ñ-¨c°fÐ-Ð=×AÑAÓCˆ÷ 
>ä
�-‰-×
#Ñ
#àˆE�A‰I˜˜ ™	Ñ!Ü�NŠNÒEÈÑIÓJ×RÑRØóð	
ð �fˆoð $ð €Cô à�5˜1‘9 ˜u q™yÑ(Ú ‘NØ ˜' A™+¬¯©¨°1©Ñ4ñ	
ð
 ñ€Hô ×Ò˜& (Õ+÷' 
>Õ	=ús   Â/E Å 
E.Ú	min_countr   c                 ó¾  • U nUR                  [        R                  " [        R                  /[	        U5      -  US9S9nUR                  S5      R                  SSS9nUR                  US9n[        R                  " / SQ[        R                  " S	S
S9/// SQ/ SQ/SS /S9nUS:X  a  SO[        R                  n[        SU0XcS9n[        R                  " XX5        g )Nr  )r   r   Ú40sF)Úinclude_groups)r_  r  r  rV  )r  )r   r   r   )r   r   r   ©r  Úcodesro   r   rà   r   )r   r¤   )ÚassignrU   rî   ÚNArˆ   rX   r=   r}   rs   rV   r   r)   rZ   )	Ústring_dtype_no_objectr"   r_  r¤   Úgbrsr_   r   rC  r^   s	            r!   Ú&test_groupby_resample_empty_sum_stringri    sÊ   € ð
 #€EØ×"Ñ"¤R§X¢X¬r¯u©u¨g¼¸J»Ñ.GÈuÑ%UÐ"ÐV€JØ×Ñ˜cÓ"×+Ñ+¨EÀ%Ð+ÐH€DØ�X‰X 	ˆXÐ*€Fä�MŠMÚœBŸNšN¨<¸dÑCÐDÐEÚš)Ð$Ø�Dˆkñ€Eð
 ˜q“.‰B¤b§e¡e€EÜ˜#˜u˜¨UÑ@€HÜ×Ò˜&Õ+r    c                  óN  • [        [        SSS9/ SQ/ SQS.S9n U R                  S5      R                  S	S
S9S/   R	                  5       n[
        R                  R                  / SQU S
   R                  S S S2   /SS
/S9n[        S/ SQ0US9n[        R                  " X5        g )NrG   r   ©rJ   r   ©r   r   r   r   r   r   r   r   )r   r3   r4   r   r   r
  r4   r   rM   )r[   rN   rz   r5   r{   rO   ©r   r   r   r   r   rn   )ç      @g      @g      @g      @r×   )r   r
   rX   r=   re   rU   rs   rt   Ú_valuesr)   rZ   ©r\   r_   Úmi_expr^   s       r!   Ú'test_groupby_resample_with_list_of_keysrr  %  s¸   € ä	ä \¸1Ñ=Ú-Ú,ñ
ñ
€Bð �Z‰Z˜Ó ×)Ñ)¨$°6Ð)Ð:¸E¸7ÑC×HÑHÓJ€Fä�]‰]×&Ñ&Ú	�r˜&‘z×)Ñ)©#¨A¨#Ñ.Ð/¸ÀÐ7Hð 'ð €Fô àÒ'ð
ð ñ	€Hô ×Ò˜&Õ+r    c                 ó`  • [        / / SQS9n[        R                  " US   5      US'   UR                  S5      nSn[        R
                  " [        US9   UR                  U 5      R                  [        R                  " S5      S9R                  5       nS S S 5        [        / SQS9R                  U SS	9n[        R                  " US   5      US'   UR                  SS
S
S9n[        U 5      S:X  a  U S   UR                  l        [        R                  " WU5        g ! , (       d  f       N�= f)N)rÙ   rÚ   r5   r8   r5   rF   rD   rG  rH  FrJ  T)rL  rK  r   r   )r   rU   rV   r<   r)   r*   rW   rX   r=   rM  re   rˆ   r   rq   rZ   rN  s        r!   Útest_resample_no_indexrt  <  sû   € ô 
�2Ò1Ñ	2€BÜ—’  6¡
Ó+€B€v�JØ	�‰�fÓ	€BØ
F€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜DÓ!×*Ñ*´·²À
Ó0KÐ*ÐL×QÑQÓSˆ÷ 
>äÒ!3Ñ4×>Ñ>¸tÈ%Ð>ÐP€HÜ—~’~ h¨vÑ&6Ó7€HˆVÑØ×!Ñ! &°¸DÐ!ÐA€HÜ
ˆ4ƒy�Aƒ~Ø" 1™gˆ�‰Ôä×Ò˜& (Õ+÷ 
>Õ	=ús   ÁADÄ
D-c            	      óÞ  • [        [        [        R                  " / SQ5      SS9S9n U R	                  / SQ5      R                  [        R                  " S5      S9R                  5       n[        R                  " / SQ5      n[        [        R                  " [        R                  " S	S
/[        R                  S9U// SQ/ SQ/S S/S9S9n[        R                  " X[        5       (       + S9  g )N)ú2018-01-01 00:00:00ú2018-01-01 12:00:00ú2018-01-02 00:00:00r5   ré   r   )r   r   r   z06:00:00rH  )rv  z2018-01-01 06:00:00rw  rx  r   r   r  )r   r   r   r   )r   r   r   r   rc  )Úcheck_index_type)r   r   rU   rV   rX   r=   rM  re   rs   r   rî   Úintpr)   rZ   r   )r\   r_   r   r^   s       r!   Útest_resample_no_columnsr{  N  sÆ   € ä	ÜÜ�NŠNÚUóð ñ	
ñ
€Bð �Z‰Zš	Ó"×+Ñ+´·²ÀÓ1LÐ+ÐM×RÑRÓT€FÜ�NŠNò	
ó€Eô Ü�mŠmÜ—H’H˜a ˜V¬2¯7©7Ñ3°UÐ;Ú¢Ð.Ø˜�.ñ
ñ€Hô ×Ò˜&ÔATÓAVÔ=VÓWr    c            	      ó
  • [        S/S-  S/S-  -   S/S-  -   S/S-  -   [        R                  " S5      S.[        SSSS9S	9n S
n[        R
                  " [        US9   U R                  S5      R                  S5      R                  5       nS S S 5        [        R                  R                  / SQ[        R                  " SS/S-  SS9/SS /S9n[        SUS	9n[        R                  " WU5        g ! , (       d  f       Nl= f)Nr   r   r   r   r   z31/12/2000 18:00rç   r   r   rF   rD   r   r;   rK   z
2000-12-31z
2001-01-01zM8[ns]r  rn   )r   r   r   r
   r)   r*   rW   rX   r=   r¯   rU   rs   rt   r§   r   rh   )r\   r]   r_   rq  r^   s        r!   Ú)test_groupby_resample_size_all_index_samer}  m  s  € ä	Øˆc�A‰g˜˜˜a™Ñ 1 #¨¡'Ñ)¨Q¨C°!©GÑ3¼"¿)º)ÀB»-ÑHÜÐ+°#¸rÑBñ
€Bð G€CÜ	×	#Ò	#¤M¸Ó	=Ø—‘˜C“×)Ñ)¨#Ó.×3Ñ3Ó5ˆ÷ 
>ô �]‰]×&Ñ&âÜ×Ò˜l¨LÐ9¸AÑ=ÀXÑNð	
ð �Dˆkð 'ð €Fô Ø	Øñ€Hô ×Ò˜6 8Õ,÷ 
>Õ	=ús   Á/C4Ã4
Dc            	      óL  • [        / SQ/ SQS.[        SSSS9S9n U R                  S	5      R                  S
5      S/   R	                  5       n[
        R                  R                  / SQU R                  S S S2   /S	S/S9n[        S/ SQ0US9n[        R                  " X5        g )Nrl  ©r   r   rH   r   r4   r/  r   rL   ©rN   rO   rG   r   r5   ©rJ   r   rq   r×   rN   rz   rO   rm  r   rn   ©g       @g      @g      @rn  ©r   r
   rX   r=   re   rU   rs   rt   r   r)   rZ   rp  s       r!   Ú0test_groupby_resample_on_index_with_list_of_keysr„  …  s°   € ä	â-Ú+ñ
ô ˜|°Q¸VÑDñ
€Bð �Z‰Z˜Ó ×)Ñ)¨$Ó/°°Ñ8×=Ñ=Ó?€Fä�]‰]×&Ñ&Ú	�r—x‘x¡ ! ‘}Ð%¨g°vÐ->ð 'ð €Fô àÒ'ð
ð ñ	€Hô ×Ò˜&Õ+r    c            	      ó`  • [        / SQ/ SQ/ SQ/ SQS.[        SSSS	9S
9n U R                  S5      R                  S5      SS/   R	                  5       n[
        R                  R                  / SQU R                  S S S2   /SS/S9n[        / SQ/ SQS.US
9n[        R                  " X5        g )Nrl  r  )r   r3   r   r   r   r   r   r   )r   rH   r   rH   r   r   r   r4   )rN   Ú	first_valÚ
second_valÚ	third_valrG   r   r5   r�  r×   rN   rz   r†  r‡  rm  r   rn   r‚  )ç      @r‰  g      @r‰  )r†  r‡  rƒ  rp  s       r!   Ú>test_groupby_resample_on_index_with_list_of_keys_multi_columnsrŠ  œ  s¹   € ä	â-Ú1Ú2Ú1ñ	
ô ˜|°Q¸VÑDñ
€Bð �Z‰Z˜Ó ×)Ñ)¨$Ó/°¸lÐ0KÑL×QÑQÓS€Fä�]‰]×&Ñ&Ú	�r—x‘x¡ ! ‘}Ð%¨g°vÐ->ð 'ð €Fô â-Ú.ñ
ð ñ€Hô ×Ò˜&Õ+r    c            
      óü   • [        / SQ/ SQS.[        [        SSS9SS9S	9n U R                  S
5      nUR	                  S5      n[
        R                  " [        SS9   US/     S S S 5        g ! , (       d  f       g = f)Nrl  r  r€  rG   r   rk  r5   ré   r×   rN   rz   zColumns not foundrD   Úval_not_in_dataframe)r   r   r
   rX   r=   r‹   rŒ   ÚKeyError)r\   ÚgbÚrss      r!   Ú?test_groupby_resample_on_index_with_list_of_keys_missing_columnr�  ¶  ss   € ä	â-Ú+ñ
ô Ü˜\°1Ñ5Øñ
ñ	
€Bð 
�‰�GÓ	€BØ	�‰�TÓ	€BÜ	�Š”xÐ':Ó	;Ø
Ð"Ð#Ò$÷ 
<×	;Ö	;ús   ÁA-Á-
A;ÚkindÚdatetimeÚperiodc                 óÀ  • [        [        R                  " / SQ5      / SQ/ SQS.5      nUR                  S5      nUR	                  S5      S   R                  SU S	9R                  5       n[        R                  " S
S/5      nU S:X  a  UR                  SS9n[        R                  R                  SS/U/SS/S9n[        / SQUSS9n[        R                  " X%5        g )N)z20181101 1100z20181101 1200z20181102 1300z20181102 1400)r   r   r   r   )r   r   r   rH   )r’  rN   rC  r’  rN   rC  r;   )r‘  z
2018-11-01z
2018-11-02r“  rƒ   r   r   rn   )r   r   r   rH   rp   )r   rU   rV   r<   rX   r=   r«   r§   Ú	to_periodrs   Úfrom_productr   r)   rh   )r‘  r\   r_   Údt_levelÚexpected_indexr^   s         r!   Útest_groupby_resample_kindr™  È  sá   € ô 
äŸšÚTóò *Ú!ñ	
ó
€Bð 
�‰�jÓ	!€BØ�Z‰Z˜Ó  Ñ)×2Ñ2°3¸TÐ2ÐB×GÑGÓI€Fä×Ò ¨|Ð <Ó=€HØˆxÓØ×%Ñ%¨3Ð%Ð/ˆÜ—]‘]×/Ñ/Ø
ˆsˆ�XÐØ˜
Ð#ð 0ð €Nô ’l¨.¸wÑG€HÜ×Ò˜6Õ,r    )6Útextwrapr   Únumpyr   r‹   Úpandas.compatr   ÚpandasrU   r   r   r   r   r	   Úpandas._testingÚ_testingr)   Úpandas.core.indexes.datetimesr
   Úfixturer"   r0   r`   rj   rw   r   rŸ   r¨   ÚmarkÚparametrizerº   r¿   rÇ   rÔ   rÞ   ró   r  r  r  r(  r1  r>  rD  rO  r^  ri  rr  rt  r{  r}  r„  rŠ  r�  r™  r   r    r!   Ú<module>r¤     sì  ðÝ ã Û å -ã ÷õ õ Ý 4ð ‡�ñó ðò5ò,/,òd-ò"-ò((ò&CòR-ð2 ‡�×ÑØòóñ(
&ó)ð(
&ò-ð ‡�×Ñ˜˜u e˜nÓ-ñ	,ó .ð	,ò,ò8-ò,,ò"-ò&,ò.<ò,ò -ò&!,òH,ð ‡�×Ñ˜ 3 %¨#¨s¨Ð!4Ó5ñ,ó 6ð,ð" ‡�×Ñ˜¨¨u¨Ó6ñ,ó 7ð,ðB ‡�×Ñ˜ q¨! fÓ-ñ,ó .ð,ò&,ð. ‡�×Ñ˜ 3 %¨#¨s¨Ð!4Ó5ñ,ó 6ð,ò"Xò>-ò0,ò.,ò4%ð$ ‡�×Ñ˜ *¨hÐ!7Ó8ñ-ó 9ñ-r    