
    Mh"                        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  S SKJr  S SKJr  \R&                  S 5       r\R&                  S 5       r\R&                  S	 5       rS
 rS rS rS rS rS rS r\R<                  R?                  SS/SS//5      S 5       r S r!\R<                  R?                  S/ SQ5      S 5       r"S r#S r$S r%S r&\R<                  R?                  SSS/5      S 5       r'S  r(\R<                  R?                  S!S" S# /S$S%/S&9S' 5       r)S( r*S) r+S* r,\R&                  S+ 5       r-\R&                  S, 5       r.\R&                  S- 5       r/\R&                  S. 5       r0\R&                  S/ 5       r1\R&                  S0 5       r2\R&                  S1 5       r3\R&                  S2 5       r4\R&                  S3 5       r5\R&                  S4 5       r6\R&                  S5 5       r7\R&                  S6 5       r8\R&                  S7 5       r9\R&                  S8 5       r:\R&                  " / S9QS:9S; 5       r;S< r<\R<                  R?                  S=S!\Rz                  \R|                  S>.0S\Rz                  4S?\R|                  4S>.\" S\Rz                  5      \" S?\R|                  5      S>./5      S@ 5       r?SA r@\R<                  R?                  S=S!SBSC/0SBSCSD./5      SE 5       rA\R<                  R?                  S=SSBSCSD.0SBSCSD.SBSCSF.S>./5      SG 5       rBSH rC\R<                  R?                  S=S!\R                  SI S>.0S\R                  4S?SJ 4S>.\" S\R                  5      \" S?SK 5      S>./5      SL 5       rE\R<                  R?                  S=S!\R                  \Rz                  SM.0SN\R                  4SO\Rz                  4S>.\" SN\R                  5      \" SO\Rz                  5      S>./5      SP 5       rF\R<                  R?                  SQSSCSR/SBSR/S>./SS?/SCSR/SBSR/S>.//5      SS 5       rG\R<                  R?                  S=SSCSR/0SCSR/SBSR/S>./5      ST 5       rHSU rI\R<                  R?                  S!SV/SBSW/SSC0SXSYS>./5      SZ 5       rJS[ rKS\ rLS] rMS^ rN\R<                  R?                  S_/ S`Q5      Sa 5       rOSb rP\R<                  R?                  ScSdSeSf/ SgQShSiS/ SjQSkSl4
SmSnSoSp/Sq-  SfSiSr/ SsQStSu4
SdSeSf/ SgQShSiSv/ SwQSxSy4
SdSeSf/ SgQShSzS/ S{QS|Sl4
/5      S} 5       rQ\R<                  R?                  S~/ SCSSS/04PSCSS/S/S.4PSC\R                  S/S/S.4PSXSSS/04PSPSX\R                  S4PSVSSSy/04PSVSS/Sy/S.4PSV\R                  S/Sy/S.4PSWSSS/04PSWSS/S/S.4PSW\R                  S/S/S.4PSSSSy/04PSSS/Sy/S.4PS\R                  S/Sy/S.4PSSSS/04PSSS/S/S.4PS\R                  S/S/S.4PSBSSS/04PSPSB\R                  S4PSYSSS/04PSPSY\R                  S4PSRSSS/04PSPSR\R                  S4PSSSS/04PSPS\R                  S4PSSSS/04PSPS\R                  S4P5      S 5       rS\R<                  R?                  S~SSCSS/4SC\R                  S/4SSSX\R                  S4SSVSS/4SV\R                  S/4SSWSS/4SW\R                  S/4SSSS/4S\R                  S/4SSSS/4S\R                  S/4/5      S 5       rT\R<                  R?                  S/ SQ5      S 5       rUS rVS rWS rXg)    )datetimeN)lib)UnsupportedFunctionCall)	DataFrameNamedAggSeries)
date_rangec                  D    [        [        SSS5      [        SSS5      SS9$ )N     
   Min)startendfreq)r	   r        Y/var/www/html/env/lib/python3.13/site-packages/pandas/tests/resample/test_resample_api.pydtir      s$    HT1a0htQ6KRWXXr   c                     [        [        R                  R                  S5      R                  [	        U 5      5      U 5      $ )N   )r   nprandomdefault_rnglen)r   s    r   _test_seriesr      s-    "))''*11#c(;SAAr   c           	      X    [        X[        R                  " [        U 5      5      S.5      $ )NABC)r   r   aranger   )r   r   s     r   
test_framer#      s    <3s8ATUVVr   c                     U R                  S5      nS[        U5      ;   d   eU R                  SSS9nS[        U5      ;   d   eg )NhziDatetimeIndexResampler [freq=<Hour>, axis=0, closed=left, label=left, convention=start, origin=start_day]
2000-01-01)originzsDatetimeIndexResampler [freq=<Hour>, axis=0, closed=left, label=left, convention=start, origin=2000-01-01 00:00:00])resamplestr)r   rs     r   test_strr+   #   sd    c"A	:=@V	D	D 	c,7A	DGJ1v	N	Nr   c                 D   U R                  S5      nUR                  5       n[        U[        5      (       d   e[	        U5      S:X  d   eU R                  5       R                  S5      nUR                  5       n[        U[        5      (       d   e[	        U5      S:X  d   eg )Nr%      )r(   mean
isinstancer   r   to_framer   )r   r*   results      r   test_apir2   1   s    c"AVVXFff%%%%v;#((-AVVXFfi((((v;#r   c                  6   [        [        SSSS9/ SQ/ SQS.5      R                  S5      n [        S	S
S9R                  5       [        SS
S9R                  5       -   n[        R
                  R                  S/S
-  S/S
-  -   U/SS/S9n[        SS/S-  S/-   S/S-  -   S
/-   0US9nSn[        R                  " [        US9   U R                  S5      R                  S 5      S/   nS S S 5        [        R                  " WU5        g ! , (       d  f       N&= f)N
2016-01-01   W)r   periodsr   )r   r   r   r   )            )dategroupvalr<   z
2016-01-03r;   r7   z
2016-01-17r   r   r=   namesr>   r8   r:   r9   indexz7DataFrameGroupBy.apply operated on the grouping columnsmatchc                 @    U R                  S5      R                  5       $ )N1D)r(   ffillxs    r   <lambda>+test_groupby_resample_api.<locals>.<lambda>R   s    QZZ5E5K5K5Mr   )r   r	   	set_indextolistpd
MultiIndexfrom_arraystmassert_produces_warningDeprecationWarninggroupbyapplyassert_frame_equal)dfirC   expectedmsgr1   s         r   test_groupby_resample_apir\   =   s#    
\13G!	

 i  	<+224
\1
-
4
4
6	7  MM%%sQw!q'8!&<WfDU%VE%!qA3!q!8A3!>?uMH
CC		#	#$6c	BG$**+MNPUwW 
C&(+ 
C	Bs   &D


Dc                     [        SS/S-  [        SSS9[        R                  R	                  S5      R                  S5      S.5      n U R                  S	5      R                  S
5      R                  S5      R                  5       nU R                  S
5      R                  SS	S9R                  5       n[        R                  " X!5        g )Nr   r    r8   r4   r   r?   r   )keydatesvaluesr_   r^   Don)r   r	   r   r   r   standard_normalrM   rU   r(   r.   rR   rW   rX   rZ   r1   s      r   test_groupby_resample_on_apirf   V   s     
:>b9ii++A.>>rB	

B ||G$,,U3<<SAFFHHZZ'''8==?F&+r   c                  h   [        SSS.[        SSS9S9n U R                  5       nU R                  SS	S
9nUR	                  S 5      n[
        R                  " X15        U R                  S5      nUR	                  S 5      n[
        R                  " X15        [        R                  R                  [        R                  " SS/5      R                  S5      R                  S5      UR                  /5      Ul        U R                  SSS
9nUR	                  S 5      n[
        R                  " X15        g )Nr   r   r   r    2000r   r?   rB   5DF
group_keysc                     U $ Nr   rI   s    r   rK   *test_resample_group_keys.<locals>.<lambda>m       qr   c                     U $ rn   r   rI   s    r   rK   ro   r   rp   r   r&   z
2000-01-06nsr8   Tc                     U $ rn   r   rI   s    r   rK   ro   }   rp   r   )r   r	   copyr(   rV   rR   rW   rO   rP   rQ   to_datetimeas_unitrepeatrC   )rX   rZ   gr1   s       r   test_resample_group_keysry   g   s    	#:fb+I	JBwwyH 	DU+AWW[!F&+ 	DAWW[!F&+ ]]..NNL,78@@FMMaPNN	
HN 	DT*AWW[!F&+r   c                 l   UR                  S5      nUR                  5       UR                  5       -
  nUR                  S 5      n[        R
                  " XC5        U R                  S5      nUR                  5       UR                  5       -
  nUR                  S 5      n[        R                  " XC5        g )Nr%   c                 D    U R                  5       U R                  5       -
  $ rn   maxr.   rI   s    r   rK   test_pipe.<locals>.<lambda>       aeeg0r   c                 D    U R                  5       U R                  5       -
  $ rn   r|   rI   s    r   rK   r~      r   r   )r(   r}   r.   piperR   assert_series_equalrW   )r#   r   r*   rZ   r1   s        r   	test_piper      s     	c"Auuw!HVV01F6, 	C Auuw!HVV01F&+r   c                 B   U R                  S5      n[        R                  " UR                  R                  U R                  5        U R                  S5      S   nUR                  R
                  U R                  S   :X  d   eU R                  S5      S   n[        R                  " UR                  R                  U R                  SS/   5        U R                  S5      S   n[        R                  " UR                  R                  U R                  SS/   5        g )Nr%   r    r   rh   r   )r(   rR   assert_index_equal_selected_objcolumnsnamer#   r*   s     r   test_getitemr      s    C A!//11:3E3EFC %A??:#5#5a#8888 	C *A!//11:3E3Eq!f3MNC *A!//11:3E3Eq!f3MNr   r^   ra   r   c                     UR                  S5      nSn[        R                  " [        US9   X      S S S 5        g ! , (       d  f       g = f)Nr%   z^\"Columns not found: 'D'\"$rD   )r(   pytestraisesKeyError)r^   r#   rx   r[   s       r   test_select_bad_colsr      s8    C A *C	xs	+	 
,	+	+s	   ;
A	c                     U R                  S5      n[        R                  " UR                  R	                  5       US   R	                  5       5        g )Nr%   r   )r(   rR   r   r   sumr   s     r   test_attribute_accessr      s6    C A133779afjjl3r   attr)groupsngroupsindicesc                     [        SSSS9n[        [        R                  " [	        U5      5      US9nUR                  S5      n[        X05        UR                  5         [        X05        g )N1/1/2012d   sr7   r   rB   30s)r	   r   r   r"   r   r(   getattrr.   )r   rngtsrss       r   test_api_compat_before_user      sV     Z3
7C			#c(#3	/B	U	B B GGIBr   c                 >   U nSUS'   UR                  S5      nUSS/   R                  5       n[        R                  " UR                  R                  5       UR
                  R                  5       /SS9n[        R                  " X45        U/ SQ   R                  5       n[        R                  " S	5      n[        R                  " [        US
9   UR                  5         S S S 5        UR                  SS9n[        R                  " X45        g ! , (       d  f       N4= f)Nfoora   r%   r   r    r   axisr   z&agg function failed [how->mean,dtype->rD   Tnumeric_only)r(   r.   rO   concatr   r    rR   rW   reescaper   r   	TypeError)r#   rX   r*   r1   rZ   r[   s         r   tests_raises_on_nuisancer      s    	BBsG
CASz]!Fyy!##((*acchhj1:H&+!&&(H
))<
=C	y	,	 
-VVV&F&+ 
-	,s   D
Dc            	          [        SSSS9n [        [        R                  " [	        U 5      SS9U S9nUR                  S5      R                  5       n[        / S	Q[        S
SSS9S9n[        R                  " X#5        g )Nr   r   r   r   int64dtyperB   20s)r      (   <   P   2012-01-01 00:00:00r8   r   r7   )	r	   r   r   r"   r   r(   asfreqrR   r   )r   r   r1   rZ   s       r   'test_downsample_but_actually_upsamplingr      sl    
Z3
7C			#c('2#	>B[[&&(F.UAFH 6,r   c            	      T   [        SSSS9n [        [        R                  " [	        U 5      5      U S9nUR
                  / SQ   nUR                  S5      R                  5       R                  5       n[        / SQ[        R                  " / S	QS
SS9S9n[        R                  " X45        g )Nr   r   r   r   rB   )r   r   r      r8   r:                  2s)g      ?g      @g      @      @r         &@r   g      .@      0@r   r   r         9@r   r   g      >@)r   z2012-01-01 00:00:02z2012-01-01 00:00:04z2012-01-01 00:00:06z2012-01-01 00:00:08z2012-01-01 00:00:10z2012-01-01 00:00:12z2012-01-01 00:00:14z2012-01-01 00:00:16z2012-01-01 00:00:18z2012-01-01 00:00:20z2012-01-01 00:00:22z2012-01-01 00:00:24z2012-01-01 00:00:26z2012-01-01 00:00:28z2012-01-01 00:00:30zdatetime64[ns])r   r   )r	   r   r   r"   r   ilocr(   r.   rH   rO   DatetimeIndexrR   r   )r   r   ts2r1   rZ   s        r   *test_combined_up_downsampling_of_irregularr      s    
 Z3
7C			#c(#3	/B
''8
9C\\$$$&,,.F	
$ $ #)
')HT 6,r   c                     U R                  S5      nU R                  [        R                  " SS95      R	                  S5      nUR	                  S5      n[
        R                  " X25        g )N20minr   r.   )r(   rU   rO   Grouper	transformrR   r   )r   r*   rZ   r1   s       r   test_transform_seriesr     sR    g&A##BJJG$<=GGOH[[ F6,r   rc   r<   c                    [        [        SSS5      [        SSS5      SS9nSUl        [        [        R
                  R                  S5      R                  S5      [        S	5      US
9nUR                  [        R                  " SS95      R                  S5      nU S:X  a  UR                  SS9nUR                  5       nUR                  SU S9nUR                  S5      n[        R                  " XS5        g )Nr   r   r   ra   r   r<   r   r   r   ABr   rC   r   r.   T)droprb   )r	   r   r   r   r   r   r   listrU   rO   r   r   reset_indexr(   rR   rW   )rc   rC   rX   rZ   r*   r1   s         r   test_transform_framer     s     xa+XdAr-BMEEJ	
		a ''0$t*E
B zz"**'23==fEH	V|''T'2^^
G#A[[ F&+r   c                      [        SSSS9n [        [        R                  " [	        U 5      SS9U S9nUR                  S5      nUR                  5       nS	n[        R                  " [        US
9   UR                  SS9nS S S 5        [        R                  " WU5        UR                  5       n[        R                  " [        US
9   UR                  SS9nS S S 5        [        R                  " XS5        Sn[        R                  " [        US
9   [        R                  " [        US
9   UR                  S5        S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       N= f! , (       d  f       N9= f! , (       d  f       g = f)Nr   r   r   r   r   r   rB   r   z+DatetimeIndexResampler.fillna is deprecatedrD   rH   )methodbfillzTInvalid fill method\. Expecting pad \(ffill\), backfill \(bfill\) or nearest\. Got 0r   )r	   r   r   r"   r   r(   rH   rR   rS   FutureWarningfillnar   r   r   r   
ValueError)r   r   r*   rZ   r[   r1   msg2s          r   test_fillnar   ,  s$   
Z$
7C			#c('2#	>B
CAwwyH
7C		#	#M	=) 
>68,wwyH		#	#M	=) 
>6,	( 	 
z	.''SAHHQK B 
/	. 
>	=
 
>	= BA 
/	.s<   .EEE?)E.;E?
E
E+.
E<	8E??
Ffuncc                 "    U R                  SSS9$ )Nr   Frk   r(   rI   s    r   rK   rK   I  s    !**W*7r   c                 F    U R                  [        R                  " SS9SS9$ )Nr   r   Frk   rU   rO   r   rI   s    r   rK   rK   J  s    !))BJJG4)Gr   r(   rU   )idsc                 d    U " U5      nUR                  S 5      n[        R                  " X15        g )Nc                     U $ rn   r   rI   s    r   rK   0test_apply_without_aggregation.<locals>.<lambda>Q  rp   r   )rV   rR   r   )r   r   tr1   s       r   test_apply_without_aggregationr   F  s*     	\AWW[!F60r   c                     U R                  SS9R                  SSS9nUS   R                  S 5      n[        R                  " X R                  S5      5        g )Nr   )r   r   Frk   c                     U $ rn   r   rI   s    r   rK   1test_apply_without_aggregation2.<locals>.<lambda>W  s    Ar   )r0   r(   rV   rR   r   rename)r   groupedr1   s      r   test_apply_without_aggregation2r   U  sR    ###/88U8SGU^!!+.F6#6#6u#=>r   c            	      <   [        [        R                  R                  S5      R	                  S5      [        SSSS9/ SQS9n U R                  S	5      nS
n[        R                  " [        US9   UR                  SSS.5        S S S 5        g ! , (       d  f       g = f)Nr   )  r   r   r   r   r   r   rC   r   3minz'Column\(s\) \['r1', 'r2'\] do not existrD   r.   r   r1r2r   r   r   r   rd   r	   r(   r   r   r   aggrX   r*   r[   s      r   test_agg_consistencyr   [  sz     

		a 00;#t<
B 	FA
4C	xs	+	V5)* 
,	+	+   /B
Bc            	      <   [        [        R                  R                  S5      R	                  S5      [        SSSS9SS/S	9n U R                  S
5      nSn[        R                  " [        US9   UR                  SSS.5        S S S 5        g ! , (       d  f       g = f)Nr   )r   r   r   r   r   r   r   ar   r   z#Column\(s\) \[2, 'b'\] do not existrD   r.   r   )r   br   r   s      r   'test_agg_consistency_int_str_column_mixr   k  s|    	
		a 00;#t<C
B 	FA
0C	xs	+	&u%& 
,	+	+r   c                  V    [        [        SSS5      [        SSS5      SS9n SU l        U $ )Nr   r   r   ra   r   r<   )r	   r   r   rB   s    r   rC   rC   ~  s.    xa+XdAr-BMEEJLr   c                     [        [        R                  R                  S5      R                  S5      [	        S5      U S9nU$ )Nr   r   r   r   )r   r   r   r   r   )rC   frames     r   rX   rX     s8    
		a ''0$t*EE Lr   c                 "    U R                  5       $ rn   )r   rX   s    r   df_colr    s    >>r   c                     U R                  5       n[        R                  R                  [	        S5      U/SS/S9Ul        U$ )Nr   rC   r<   r@   )rt   rO   rP   rQ   rangerC   )r  rC   df_mults      r   r	  r	    sB    kkmGMM--	rE7F"3 . GM Nr   c                 F    U R                  S5      S   R                  5       $ N2Dr   r(   r.   r  s    r   a_meanr        ;;tS!&&((r   c                 F    U R                  S5      S   R                  5       $ r  r(   stdr  s    r   a_stdr        ;;tS!%%''r   c                 F    U R                  S5      S   R                  5       $ r  r(   r   r  s    r   a_sumr    r  r   c                 F    U R                  S5      S   R                  5       $ Nr  r    r  r  s    r   b_meanr    r  r   c                 F    U R                  S5      S   R                  5       $ r  r  r  s    r   b_stdr    r  r   c                 F    U R                  S5      S   R                  5       $ r  r  r  s    r   b_sumr    r  r   c                 $    U R                  S5      $ )Nr  r   r  s    r   df_resampler     s    ;;tr   c                 "    U R                  SSS9$ )Nr  r<   rb   r   )r  s    r   df_col_resampler"    s    ??4F?++r   c                 "    U R                  SSS9$ )Nr  r<   levelr   )r	  s    r   df_mult_resampler&    s    D//r   c                 H    U R                  [        R                  " SS95      $ )Nr  r   r   r  s    r   df_grouper_resampler(    s    ::bjjd+,,r   )r   r"  r&  r(  )paramsc                 8    U R                  U R                  5      $ rn   )getfixturevalueparam)requests    r   casesr.    s     ""7==11r   c                    [         R                  " XX4/SS9n[         R                  R                  SS/SS//5      Ul        SnSUR
                  R                  R                  ;   ag  U S	   R                  5       nU S	   R                  5       n	[         R                  " XU/SS9n[         R                  R                  / S
QSS//5      Ul        [        R                  " [        US9   U R                  [        R                  [        R                  /5      n
S S S 5        [        R                  " W
U5        g ! , (       d  f       N&= f)Nr   r   r   r    r.   r  using SeriesGroupBy.[mean|std]r	  r<   )r<   r   r    rD   )rO   r   rP   from_productr   nodecallspecidr.   r  rR   rS   r   	aggregater   rW   )r.  r  r  r  r  r-  rZ   r[   	date_meandate_stdr1   s              r   !test_agg_mixed_column_aggregationr8    s    yy&7a@H}}11C:2OPH
*CGLL)),,,&M&&(	=$$&99i8<1E==55&%1
 
	#	#M	="''266!23 
>&(+ 
>	=s   (0D88
Er   rh   r    c                     Sn[         R                  " X/SS9n[        R                  " [        US9   U R
                  " S0 UD6nS S S 5        [        R                  " WUSS9  g ! , (       d  f       N%= f)Nr0  r   r   rD   T
check_liker   )rO   r   rR   rS   r   r5  rW   )r.  r  r  r   r[   rZ   r1   s          r   #test_agg_both_mean_std_named_resultr<    s\     +Cyy&q1H		#	#M	='3' 
>&(t< 
>	=s   A$$
A2c                     [         R                  " X/SS9n[         R                  R                  SS/5      Ul        U R                  SSS/05      n[        R                  " XC5        g )Nr   r   r   r.   r   r  r   r.   r  rO   r   rP   from_tuplesr   r5  rR   rW   )r.  r  r  rZ   r1   s        r   #test_agg_both_mean_std_dict_of_listrB    sU    yy&q1H}}00-1NOH__cFE?34F&+r   r.   r   )r.   r   c                     [         R                  " X/SS9nSS/Ul        U S   R                  " S0 UD6n[        R
                  " XT5        g )Nr   r   r.   r   r   r   )rO   r   r   r5  rR   rW   )r.  r  r  r   rZ   r1   s         r   test_agg_both_mean_sumrD    sG     yy&q1HH3Z!!(C(F&+r   )mean2sum2c                     Sn[         R                  " [        R                  R                  US9   U R                  U5        S S S 5        g ! , (       d  f       g = f)Nnested renamer is not supportedrD   )r   r   rO   errorsSpecificationErrorr5  r.  r   r[   s      r   (test_agg_dict_of_dict_specificationerrorrL    s:     ,C	ryy333	? 
@	?	?s   A
Ac                     [         R                  " XX4/SS9n[         R                  R                  / SQ5      Ul        U R                  SS/SS/S.5      n[        R                  " XeSS9  g )	Nr   r   )r>  r?  r    r.   r    r  r.   r  rh   Tr:  r@  )r.  r  r  r  r  rZ   r1   s          r   test_agg_dict_of_listsrP    s^    yy&7a@H}}00BH __FE?&%IJF&t<r   c                 ,    [         R                  " U SS9$ Nr   )ddofr   r  rI   s    r   rK   rK   "  s    bffQQ.?r   c                 ,    [         R                  " U SS9$ rR  rT  rI   s    r   rK   rK   #  s    "&&2Cr   c                 ,    [         R                  " U SS9$ rR  rT  rI   s    r   rK   rK   $  s    "&&QRBSr   c                 8   SnU S   R                  S 5      n[        R                  " U S   R                  5       U/SS9n[        R
                  " [        US9   U R                  " S
0 UD6nS S S 5        [        R                  " WUSS	9  g ! , (       d  f       N%= f)Nzusing SeriesGroupBy.sumr    c                 ,    [         R                  " U SS9$ rR  rT  rI   s    r   rK   &test_agg_with_lambda.<locals>.<lambda>*  s    ):r   r   r   r   rD   Tr:  r   )	rV   rO   r   r   rR   rS   r   r   rW   )r.  r   r[   rcustomrZ   r1   s         r   test_agg_with_lambdar[    s     $CCj:;Gyy%*..*G41=H		#	#M	=!S! 
>&(t< 
>	=s   B
B)result1result2r\  r]  c                     Sn[         R                  " [        US9   U SS/   R                  " S0 UD6  S S S 5        g ! , (       d  f       g = f)Nz1Column\(s\) \['result1', 'result2'\] do not existrD   r   r    r   r   r   r   r   rK  s      r   test_agg_no_columnr`  1  s=     ?C	xs	+sCj$$ 
,	+	+s	   =
Az	cols, aggr  c                     [         R                  " X4XV/SS9n[         R                  R                  / SQ5      Ul        Ub  X   nOU nUR                  U5      n	[        R                  " XSS9  g )Nr   r   ))r   r   r?  rN  rO  Tr:  )rO   r   rP   rA  r   r   rR   rW   )
r.  colsr   r  r  r  r  rZ   objr1   s
             r   "test_agg_specificationerror_nestedrd  ?  sd      yy%6Q?H}}00AH kWWS\F&t<r   c                     Sn[         R                  " [        R                  R                  US9   U S   R                  U5        S S S 5        g ! , (       d  f       g = f)NrH  rD   r   )r   r   rO   rI  rJ  r   rK  s      r   "test_agg_specificationerror_seriesrf  \  s@     ,C 
ryy333	?c
s 
@	?	?s   A
Ac                     Sn[         R                  " [        US9   U S/   R                  SS/SS/S.5        S S S 5        g ! , (       d  f       g = f)Nz Column\(s\) \['B'\] do not existrD   r   r   r  r.   rh   r_  )r.  r[   s     r   )test_agg_specificationerror_invalid_namesrh  g  sD     .C	xs	+seu~VUODE 
,	+	+s   A
Aminr}   prodmedianc                    [        [        SSS5      [        SSS5      SS9nSUl        [        [        R
                  R                  S5      R                  S5      [        S	5      US
9R                  nSn[        R                  " [        US9   UR                  SSS9n[        R                  " [        SS9   UR!                  U 5        S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       g = f)Nr   r   r   ra   r   r<   r   r   r   r   -DataFrame.resample with axis=1 is deprecated.rD   MEr   z"axis other than 0 is not supported)r	   r   r   r   r   r   r   r   TrR   rS   r   r(   r   r   NotImplementedErrorr   )r   rC   rX   warning_msgress        r   test_multi_agg_axis_1_raisesrs  o  s     xa+XdAr-BMEEJ	
		a ''0$t*E
a  BK		#	#M	Ekk$Qk']]'K
 GGDM
 
F	E
 
 
F	Es$   *C,8C
C,
C)	%C,,
C:c            	         [        [        SSS5      [        SSS5      SS9n SU l        [        [        R
                  R                  S5      R                  S5      [        S	5      U S
9nUR                  5       nUR                  5       n[        R                  R                  [        S5      UR                  /SS/S9Ul        UR                  S5      nUUR                  SSS9UR                  SSS9UR!                  [        R"                  " SS95      /nSnU HU  n[$        R&                  " [        R(                  R*                  US9   UR-                  SSS/0SSS/0S.5        S S S 5        MW     U H  n[$        R&                  " [        R(                  R*                  US9   USS/   R/                  SSS/0SSS/0S.5        S S S 5        [$        R&                  " [        R(                  R*                  US9   UR/                  SSS/0SSS/0S.5        S S S 5        M     g ! , (       d  f       GM  = f! , (       d  f       Nx= f! , (       d  f       M  = f)Nr   r   r   ra   r   r<   r   r   r   r   rC   r@   r  rb   r$  rH  rD   r   r.   r   r    r   rar  rbrh   )r	   r   r   r   r   r   r   r   r   rt   rO   rP   rQ   r  rC   r(   rU   r   r   r   rI  rJ  r5  r   )rC   rX   r  r	  r*   r.  r[   r   s           r   test_agg_nested_dictsrw    s   xa+XdAr-BMEEJ	
		a ''0$t*E
B ^^FkkmGMM--	rBHHgv%6 . GM 	DA	(V,


2::4()	E ,C]]29977sCKKfe_5cFE?=STU DC  ]]29977sCsCjMfe_-TFE?4KL D
 ]]29977sCEE/tfe_6MNO DC  DC DC
 DCs$   H'&"H:=I'
H7	:
I	
I	c                  Z   [        SSSS5      SSS.[        SSSS5      SSS.[        SSSS5      S	S
S./n [        U 5      R                  S5      nSn[        R                  " [
        US9   UR                  S5      R                  S/S/S/S.5        S S S 5        g ! , (       d  f       g = f)Ni  r9   r   r   g      ?g       @)dtrJ   yr   g      @g      ?ry  z Column\(s\) \['z'\] do not existrD   30minr.   rk  r   )rJ   rz  z)r   r   rM   r   r   r   r(   r   )datarX   r[   s      r   &test_try_aggregate_non_existing_columnr~    s     aA&Ss;aA&Ss;aA&Ss;D
 
4	"	"4	(B .C	xs	+
G  xxjw!OP 
,	+	+s   +(B
B*c            	         [        S/ SQ0[        SSSS9S9n SS jnSS	 jnS
n[        R                  " [        US9   U R                  S5      R                  X/SSSS9  S S S 5        U R                  S5      R                  X/SSS9n[        SS/SS/SS//[        SSSS9[        R                  R                  SS/5      S9n[        R                  " XE5        g ! , (       d  f       N= f)NrJ   )r   r   r   
2020-01-01r   ra   r   rB   c                     X-   U-   $ rn   r   )rJ   r   cs      r   foo1/test_agg_list_like_func_with_args.<locals>.foo1      uqyr   c                     X-   U-   $ rn   r   )rJ   r   r  s      r   foo2/test_agg_list_like_func_with_args.<locals>.foo2  r  r   z/foo1\(\) got an unexpected keyword argument 'b'rD   r5   )r   r  )r  r;   	   r   )rJ   r  )rJ   r  r   )r   r   )r   r   )r   r	   r   r   r   r(   r   rO   rP   rA  rR   rW   )rX   r  r  r[   r1   rZ   s         r   !test_agg_list_like_func_with_argsr    s    		i
< M
B =C	y	,
Cd\1Q7 
- [[!!4,Q!7F
Q!Q"b"qs;))=-*HIH
 &+ 
-	,s   #C
C*c                     [        [        SSS5      [        SSS5      SS9n [        R                  " [	        U 5      [        R
                  S9n[        XS.[        R                  R                  X/SS	/S
9S9n[        SU0U S9nSn[        R                  " [        US9   UR                  SSS9  S S S 5        Sn[        R                  " [        US9   UR                  SSS	S9  S S S 5        Sn[        R                  " [        US9   UR                  SSS/S9  S S S 5        Sn[        R                  " [        US9   UR                  SSS/S9  S S S 5        Sn[        R                  " [        US9   UR                  SS	S9R!                  5         S S S 5        [        R                  " [        US9   UR                  SSS9R!                  5         S S S 5        UR                  S5      R#                  5       nSUR$                  l        UR                  SSS9R#                  5       n[(        R*                  " XV5        S	UR$                  l        [        R                  " [        SS9   UR                  SS	S9R#                  5         S S S 5        UR                  SS	S9R#                  SS9n[(        R*                  " XV5        g ! , (       d  f       GN= f! , (       d  f       GN= f! , (       d  f       GN= f! , (       d  f       GN= f! , (       d  f       GN= f! , (       d  f       GNR= f! , (       d  f       N= f)Nr   r   r   ra   r   r   )r<   r   vdr@   rB   r   z\Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex, but got an instance of 'Index'rD   r  r$  z2The Grouper cannot specify both a key and a level!r<   )rc   r%  zunhashable type: 'list'rb   z#\"Level \['a', 'date'\] not found\"z|Upsampling from level= or on= selection is not supported, use \.set_index\(\.\.\.\) to explicitly set index to datetime-likez$datetime64 type does not support sumTr   )r	   r   r   r"   r   r   r   rO   rP   rQ   r   r   r   r(   r   r   r   r   rC   r   rR   rW   )rC   r   rX   df_expr[   expr1   s          r   test_selection_api_validationr    s   xa+XdAr-BME
))CJbhh
/C	!mm''S#J'G
B Sz/F	)  
y	,
D$ 
- ?C	z	-
DV3/ 
. $C	y	,
Dc6]+ 
- 1C	xs	+
Df. 
,
	J  
z	-
D$++- 
.	z	-
DV$++- 
. //$

#
#
%CCIIN[[&[)--/F#&CIIN	y(N	O
D$((* 
P[[S[)--4-@F#&E 
-	, 
.	- 
-	, 
,	+ 
.	-	-	- 
P	OsT    KK	K)?K;5L5L*L1
K
K&)
K8;
L

L
L.1
L?col_name)t2t2xt2qT_2Mt2pt2mt2m1T2Mc           
      &   [        [        [        S5      5      [        SSSSS9U /S9nUR	                  S5      R                  S/5      n[        / S	Q[        SS
SSS9[        R                  " U /S//S/S//S9S9n[        R                  " X#5        g )N   z
2017-01-0115minzEurope/Berlin)r   r   r7   tzr   1dr.   )g     G@g     a@g     ph@ra   r   r   )levelscodes)
r   r   r  r	   r(   r5  rO   rP   rR   rW   )r  rX   r1   rZ   s       r   *test_agg_with_datetime_index_list_agg_funcr    s     
U3ZWco
 

B [[((&2F|#q_Uxj6(%;QC!:NH
 &+r   c                  D   [        SSSS9n [        R                  " U 5      nUR                  SS9  [	        XS9nUR                  S5      n[	        [        R                  " S	5      [        R                  " S	5      /U S S S
2   S9nUR                  S5      n[        R                  " XT5        UR                  S5      n[        R                  " XT5        UR                  S5      n[        R                  " XT5        UR                  S5      n[        R                  " XT5        g )Nr  z
2020-01-021hr   F)writerB   rG   r      lastfirstr}   ri  )r	   r   
zeros_likesetflagsr   r(   rO   	Timestampr   rR   r   )rC   arrserr   rZ   r1   s         r   test_resample_agg_readonlyr    s    |\=E
--
CLLuL

"C	d	Br||AQ8ddLHVVF^F6,VVG_F6,VVE]F6,VVE]F6,r   zLstart,end,freq,data,resample_freq,origin,closed,exp_data,exp_end,exp_periodsz2000-10-01 23:30:00z2000-10-02 00:26:007min)	r   r   r9   r     r         r  17minr   )r   r     ?   z20001002 00:26:00r5   z20200101 8:26:35z20200101 9:31:5877sr   3   right)
r   r9   r8   r9   r8   r9   r8   r9   r8   r9   z2020-01-01 09:30:45r   left)r   r  r  '   r  z20001002 00:43:00r8   end_day)r   r   -   r  z2000-10-02 00:29:00c
           	          [        XUS9n
[        X:S9nUR                  XEUS9R                  5       n[        U[        XU	S9S9n[        R
                  " X5        g )Nr   rB   )r'   closed)r   r   r7   )r	   r   r(   r   rR   r   )r   r   r   r}  resample_freqr'   r  exp_dataexp_endexp_periodsr   r   rr  rZ   s                 r   test_end_and_end_day_originr  3  s]    B Ud
+C		 B
++m6+
B
F
F
HCW+NH
 3)r   z#method, numeric_only, expected_dataTnumr   F
cat_1cat_2catr  r   )rj  Fcan't multiply sequencer  cat_1r   cat_2r  r  g      )@)r.   FCould not convertr  )rk  F-Cannot convert \['cat_1' 'cat_2'\] to numericr  gH6%@)r  F!could not convert string to floatr  varg      \@)r  Fr  semg      @)r  Fr  c                    [        SSSS9n[        SSSS9n[        SS	/S
S/S.US9nUR                  S5      nU[        R                  L a  0 nOSU0n[        X`5      n[        U[        5      (       aU  U S;   a!  [        n	[        R                  " SU  S35      n
O[        n	Un
[        R                  " XS9   U" S0 UD6nS S S 5        g U" S0 UD6n[        X$S9n[        R                  " X5        g ! , (       d  f       g = f)N
2018-01-01r   ra   r   
2018-12-31r   YEr  r  r8   r   r  rB   r   )r  r.   rk  rj  zagg function failed [how->z,dtype->rD   r   )r	   r   r(   r   
no_defaultr   r/   r)   r   r   r   r   r   r   rR   rW   )r   r   expected_datarC   expected_indexrX   	resampledkwargsr   klassr[   _r1   rZ   s                 r   test_frame_downsample_methodr    s    T |QS9EadCN	GW-q"g>e	LBD!Is~~% ,/9%D-%%66E))8IJCEC]]5,vA -, ]A
f/ -,s   6	C00
C>)r   Tr   )rj  Tr   )rj  Fr   r   )ri  Tr   )r}   Tr   )r  Tr   )r  Tr   c                 f   [        SSSS9n[        SSSS9n[        SS	/US
9nUR                  S5      nU[        R                  L a  0 OSU0n[        X`5      nU(       aC  U[        R                  La0  SU  3n	[        R                  " [        U	S9   U" S0 UD6  S S S 5        g U S:X  aA  [        R                  " S5      n	[        R                  " [        U	S9   U" S0 UD6  S S S 5        g U" S0 UD6n
[        X$S
9n[        R                  " X5        g ! , (       d  f       g = f! , (       d  f       g = f)Nr  r   ra   r   r  r   r  r  r  rB   r   z1Cannot use numeric_only=True with SeriesGroupBy\.rD   rj  z&agg function failed [how->prod,dtype->r   )r	   r   r(   r   r  r   r   r   r   r   r   rR   r   )r   r   r  rC   r  rX   r  r  r   r[   r1   rZ   s               r   test_series_downsample_methodr    s   4 |QS9EadCN	'"%	0BD!I3>>1R7UF9%DCNN:B6(K]]9C0N6N 10	6	ii@A]]9C0N6N 10 ->
v0 10 10s   	D	D"
D"
D0zmethod, raises))r   T)rj  T)ri  T)r}   T)r  F)r  F)rk  F)r.   T)r  T)r  T)r  F)ohlcF)nuniqueFc                 h   [        SSSS9n[        / SQUS9nUR                  S5      nSn[        X@5      nS	nS
nSU  3n	U(       aU  [        R
                  " [        U	S9   [        R                  " [        US9   U" / UQSPSPSPSP76   S S S 5        S S S 5        g [        R
                  " [        U	S9   [        R                  " [        US9   U" / UQSPSPSPSP76   S S S 5        S S S 5        g ! , (       d  f       Nl= f! , (       d  f       g = f! , (       d  f       N9= f! , (       d  f       g = f)N20180101r   r%   r   )r   r5   r9   rB   r{  r   z-numpy operations are not valid with resample.ztoo many arguments passed inz2Passing additional args to DatetimeIndexResampler.rD   r   r   r5   )r	   r   r(   r   rR   rS   r   r   r   r   r   )
r   r   rC   rX   r  argsr   	error_msgerror_msg_typewarn_msgs
             r   test_args_kwargs_deprr    s   & z137E			'BG$ID9%D?I3NCF8LH''XF6iH'd'A'q'!'Q' I GF ''XFy?'d'A'q'!'Q' @ GF IH GF
 @? GFsH   D9C0
D4D#DD#0
C>	:D
D
D 	D##
D1c                     [        [        SSS5      [        SSS5      SS9n SU l        [        [        R
                  R                  S5      R                  S5      [        S	5      U S
9R                  nSn[        R                  " [        US9   UR                  SSS9  S S S 5        UR                  nSn[        R                  " [        US9   UR                  SSS9  S S S 5        g ! , (       d  f       NO= f! , (       d  f       g = f)Nr   r   r   ra   r   r<   r   r   r   r   rm  rD   rn  r   z_The 'axis' keyword in DataFrame.resample is deprecated and will be removed in a future version.r   )r	   r   r   r   r   r   r   r   ro  rR   rS   r   r(   )rC   rX   rq  s      r   test_df_axis_param_deprr    s    xa+XdAr-BMEEJ	
		a ''0$t*E
a 
 BK		#	#M	E
Dq! 
F 
B	/  
	#	#M	E
Dq! 
F	E 
F	E 
F	Es   C(C9(
C69
Dc                     Sn[         R                  " [        US9   U R                  SSS9  S S S 5        g ! , (       d  f       g = f)Nz\The 'axis' keyword in Series.resample is deprecated and will be removed in a future version.rD   r%   r   r   )rR   rS   r   r(   )r   rq  s     r   test_series_axis_param_deprr  0  s>    	>  
	#	#M	Ec* 
F	E	Es	   6
Ac                      [        [        R                  " / SQ5      S9n [        [        R                  " / SQ5      S9nU R                  S5      R	                  5       n[
        R                  " X!5        g )N)2018-01-01 00:00:00z2018-01-01 12:00:002018-01-02 00:00:00rB   )r  z2018-01-01 08:00:00z2018-01-01 16:00:00r  8h)r   rO   ru   r(   r.   rR   rW   re   s      r   test_resample_emptyr  9  s_    	nnQ

B
 nn
	H [[##%F&+r   )Yr   r   numpyr   r   pandas._libsr   pandas.errorsr   pandasrO   r   r   r   pandas._testing_testingrR   pandas.core.indexes.datetimesr	   fixturer   r   r#   r+   r2   r\   rf   ry   r   r   markparametrizer   r   r   r   r   r   r   r   r   r   r   r   r   rC   rX   r  r	  r  r  r  r  r  r  r   r"  r&  r(  r.  r8  r.   r  r<  rB  rD  rL  rP  r   r[  r`  rd  rf  rh  rs  rw  r~  r  r  r  r  r  r  r  r  r  r  r  r  r   r   r   <module>r     s    	    1  
  4 Y Y B B W W	,2,",4, O #c
 34 54
 !AB C, 	-4-n- f~., /,$4 
7G 
Y  11?+ '&         ) ) ( ( ( ( ) ) ( ( ( (   , , 0 0 - - X22," 		rwwRVV,-BGGnC=1sBGG$8C+@A==, 	Vfe_%u'EF,, 		ve,- /!51	
		= 		rvv$?@ABFFm3(C"DEsBFF#(38S*TU== 		RVV89"&&!BGG(<=y"&&)BGG0LM%% 	eU^65/:;  %.7	
	==  	S5%.!%vuo#NOF 
eWvuoU|65QR"PDQ,22'j I,,,-0 R "!,	
 C"H*!	
 "!,	
 "!,!	
K14j*k4j*0 )"	urdm$"	~rd;<" 
t DE" 
u~&	"
 	3" 
!:;" 
uqcl#" 
y!56" 
	1# >?" 
urdm$" 
y"67" 
	2$ ?@" 
$%" 
%'A378" 
#..7)QC"@A"  
t}%!"" 
	2$78#"$ 
'B4!@A%"& 
v''"( 	-)"* 
!45+", 
4%$)-". 	L/"0 
3>>#ST1"2 
u12343"4 	<5"6 
 CD7"8 
uug&'9": 	<;"< 
 CD="> 
usen%?"@ 	<A"B 
 CDC"&N0O&N08 )	~&	/	$	y!		*	y!		*	%'#	#..7),		"	'+%.1/.10 $(%$(,",+,r   