
    bMhZ                        d dl mZ d dlZd dlZd dlmZ d dlZd dlm	Z	m
Z
mZmZmZ d dlmZ d dlmZ ej        d             Zd Zd Zd	 Zd
 Zd Zd Zd Zej                            dg d          d             Zd Zej                            dddg          d             Z d Z!d Z"d Z#d Z$d Z%d Z&d Z'd Z(d Z)d Z*ej                            dd gd d!gg          d"             Z+ej                            d#d$d%g          d&             Z,d' Z-ej                            dd gd d!gg          d(             Z.d) Z/d* Z0d+ Z1d, Z2d- Z3ej                            d.d/d0g          d1             Z4dS )2    )dedentN)is_platform_windows)	DataFrameIndexSeriesTimedeltaIndex	Timestamp)
date_rangec                      t          dgdz  dgdz  z   dgdz  z   t          j        d          dt          d	d
d                    S )N                  (   AB1/1/2000sfreqperiodsindex)r   nparanger
        l/var/www/html/test/jupyter/venv/lib/python3.11/site-packages/pandas/tests/resample/test_resampler_grouper.py
test_framer"      sZ    cBh!r!QC!G+")B--@@#r:::   r    c                 N   ddl m} t          d          }|                     |           t	          j        d d          5   |d          5  t          | j                            dd                     d d d            n# 1 swxY w Y   d d d            d S # 1 swxY w Y   d S )	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      s>   ;;;;;;		 	D KK 
	#D%	H	H	H 5 5!!(++ 	5 	5))%33444	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	5 	55 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5s6   B)B6BB	B	B	
BB!Bc                     g dg dg dg dg dg dg dg dg d	g d
g
} t          | g d          }t          j        |j                  |_        d }d}t	          j        t          |          5  |                    d                              |          }d d d            n# 1 swxY w Y   d}t	          j        t          |          5  |	                    d                              d          
                    d                                          }d d d            n# 1 swxY w Y   t	          j        ||           t          t          ddd          g dg dd          	                    d          }d }d}t	          j        t          |          5  |                    d                              |          }d d d            n# 1 swxY w Y   d}t	          j        t          |          5  |                    d          
                    d                                          }d d d            n# 1 swxY w Y   t	          j        ||           d S )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                 v    |                      d                              d                                          S )Nr5   D)	set_indexresampleasfreqxs    r!   f_0z'test_deferred_with_groupby.<locals>.f_0E   s.    {{6""++C00779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                 P    |                      d                                          S )N1D)r=   ffillr?   s    r!   f_1z'test_deferred_with_groupby.<locals>.f_1X   s     zz$%%'''r    rM   rP   )r   pdto_datetimer5   r)   r*   FutureWarninggroupbyapplyr<   r=   r>   assert_frame_equalr
   rQ   )datadfrA   msgexpectedresultrR   s          r!   test_deferred_with_groupbyr^   2   s    	D 
4!8!8!8	9	9	9BnRW%%BG: : : DC		#M	=	=	= / /::d##))#../ / / / / / / / / / / / / / /
FC		#M	=	=	= K Kf%%--d33<<SAAHHJJK K K K K K K K K K K K K K K&(+++	\13GGG!\\<<	
 	

 
 i ( ( ( DC		#M	=	=	= 2 2::g&&,,S112 2 2 2 2 2 2 2 2 2 2 2 2 2 2
FC		#M	=	=	= < <G$$--d3399;;< < < < < < < < < < < < < < <&(+++++sI   2)B''B+.B+AD))D-0D-#)GGG ;IIIc                 V   |                      d          }|j                            d           }|                    d          j                                        }t          j        ||           |j                            d                                          }t          j        ||           d}t          j        t          |          5  |                    d                                          j        }d d d            n# 1 swxY w Y   t          j        ||           d S )Nr   c                 P    |                      d                                          S N2s)r=   meanr?   s    r!   <lambda>ztest_getitem.<locals>.<lambda>g   s    1::d#3#3#8#8#:#: r    rb   rE   rC   )	rV   r   rW   r=   rc   r)   assert_series_equalr*   rU   )r"   gr\   r]   r[   s        r!   test_getitemrg   d   s:   3Asyy::;;HZZ$$&&F68,,,S\\$$$&&F68,,,
FC		#M	=	=	= + +D!!&&((*+ + + + + + + + + + + + + + +68,,,,,s   -D		DDc                     ddddddg} t          | t          dd                    }|                    d	                              d
          }|d                                         }t
          j                            ddg|j        gd          }t          ddg|d          }t          j        ||           |d                                         }t          j        ||           d S )Nr   r   )r6   buyerr   r   rF   r   r   r6   rP   ri   )r6   Nnamesr   name)r   r
   rV   r=   countrS   
MultiIndexfrom_arraysr   r   r)   re   )rY   rZ   rr]   exp_mir\   s         r!   test_getitem_multiplert   u   s     s##A%<%<=D	4z,BBB	C	C	CB


4!!$''AwZF]&&A'9&NNF	
A  H
 68,,,wZF68,,,,,r    c                     t          t          d          t          dd          dd          } |                     d                              d                              d	          d
                                         }|                     d                              d	d          d
                                         }t          j        ||           d S )Naabbbz1-1-2016r4   rj   r   )r6   r5   rY   r5   r6   2DrY   on)	r   r+   r
   r<   rV   r=   sumr)   re   )rZ   expr]   s      r!   )test_groupby_resample_on_api_with_getitemr|      s    	G}}jQ&G&G&GQRSS
 
B ,,v


&
&t
,
,
5
5d
;
;F
C
G
G
I
ICZZ&&t&77?CCEEF63'''''r    c                     d} d\  }}d}t          ||d          }t          t          j                            d                              t          |                    |          }|||         }t          j        |           }|	                    |          
                    d          }|||         }|	                    |          
                    d          }	t          j        t          d	
          5  t          j        |j        |	j                   d d d            n# 1 swxY w Y   t#          d          }
t          j        | |
          }|	                    |          
                    d          }|||         }|	                    |          
                    d          }t          j        ||           t#          d          t          j        d          dz  z   }t          j        | |          }|	                    |          
                    d          }|||         }|	                    |          
                    d          }t          j        ||           t          j        ||           d S )N1399min)z1/1/2000 00:00:00z1/31/2000 00:00z1/15/2000 00:00:001231minr   r   r   ro   zIndex are differentrC   r   )r   origini0u  )r
   r   r   randomdefault_rngstandard_normallenrS   GrouperrV   aggpytestraisesAssertionErrorr)   assert_index_equalr   r	   re   	Timedelta)r   rI   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7JE3!F
UCi
0
0
0C		%%a((88SBB#	N	N	NB
VCZ.C ZT***Nzz.))--g66Hs
#HN++//88I	~-B	C	C	C ? ?
hnio>>>? ? ? ? ? ? ? ? ? ? ? ? ? ? ? q\\FztF;;;

#34488AA)&*5%566::7CC,.@AAA aLL2<	#:#:V#CCM
]CCC$566::7CC+F3J7++&788<<WEE-/BCCC ,.ABBBBBs   > D**D.1D.c                  .   t          ddd          } t          t          d          |                               d                                          }t          g dt          j        g dd	d
                    }t          j        ||           d S )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=   nearestrS   DatetimeIndexr)   re   )r   r]   r\   s      r!   test_nearestr      s     z15999EE!HHE***33E::BBDDF   #
 
 
  H  68,,,,,r    f)firstlastmediansemrz   rc   r   maxsizero   r   bfillrQ   r>   ohlcc                     |                     d          }|                    d          }d}t          j        t          |          5   t          |                       }d d d            n# 1 swxY w Y   d}t          j        t          |          5  |                     fd          }d d d            n# 1 swxY w Y   t          j        ||           d S )Nr   rb   rE   rC   rB   c                 Z     t          |                     d                                S ra   getattrr=   r@   r   s    r!   rd   ztest_methods.<locals>.<lambda>   s&    %AWQZZ-=-=q%A%A%C%C r    )rV   r=   r)   r*   rU   r   rW   assert_equalr   r"   rf   rr   r[   r]   r\   s   `      r!   test_methodsr      s`   * 	3A	

4A
FC		#M	=	=	= ! !A! ! ! ! ! ! ! ! ! ! ! ! ! ! !
CC		#M	=	=	= E E77CCCCDDE E E E E E E E E E E E E E EOFH%%%%%s$   	A..A25A2B;;B?B?c                     |                      d          }|                    d          }|j                                        }|j                            d           }t          j        ||           d S )Nr   rb   c                 P    |                      d                                          S ra   )r=   nuniquer?   s    r!   rd   z&test_methods_nunique.<locals>.<lambda>   s    1::d#3#3#;#;#=#= r    )rV   r=   r   r   rW   r)   re   )r"   rf   rr   r]   r\   s        r!   test_methods_nuniquer      se    3A	

4AS[[]]Fsyy==>>H68,,,,,r    stdvarc                     |                     d          }|                    d          }d}t          j        t          |          5   t          |           d          }d d d            n# 1 swxY w Y   d}t          j        t          |          5  |                     fd          }d d d            n# 1 swxY w Y   t          j        ||           d S )	Nr   rb   rE   rC   r   ddofrB   c                 ^     t          |                     d                    d          S )Nrb   r   r   r   r   s    r!   rd   z&test_methods_std_var.<locals>.<lambda>  s+    %AWQZZ-=-=q%A%Aq%I%I%I r    )rV   r=   r)   r*   rU   r   rW   rX   r   s   `      r!   test_methods_std_varr      sf   3A	

4A
FC		#M	=	=	= ' 'AA&&&' ' ' ' ' ' ' ' ' ' ' ' ' ' '
CC		#M	=	=	= K K77IIIIJJK K K K K K K K K K K K K K K&(+++++s$   	A00A47A4B==CCc                    |                      d          }|                    d          }d}t          j        t          |          5  |                    d                                          }d d d            n# 1 swxY w Y   d }d}t          j        t          |          5  |                    |          }d d d            n# 1 swxY w Y   t          j        ||           d }d}t          j        t          |          5  |                    |          }d d d            n# 1 swxY w Y   |                    d          }t          j        ||           d S )	Nr   rb   rE   rC   c                 P    |                      d                                          S ra   )r=   rz   r?   s    r!   rA   ztest_apply.<locals>.f_0  s     zz$##%%%r    c                 T    |                      d                              d           S )Nrb   c                 *    |                                  S Nrz   )ys    r!   rd   z)test_apply.<locals>.f_1.<locals>.<lambda>  s     r    )r=   rW   r?   s    r!   rR   ztest_apply.<locals>.f_1  s&    zz$%%&7&7888r    rB   int64)	rV   r=   r)   r*   rU   rz   rW   rX   astype)r"   rf   rr   r[   r\   rA   r]   rR   s           r!   
test_applyr     s   3A	

4A GC		#M	=	=	= * *::d##''))* * * * * * * * * * * * * * *& & & GC		#M	=	=	=                &(+++9 9 9 DC		#M	=	=	=                 w''H&(+++++s6   (A<<B B 'C		CC	D++D/2D/c                     t          ddd          } t          dt          j                            d                              t          |                     i|           }d }|                    t          j        d	                    	                    |          }|
                    d	          	                    |          }t          j        ||           |d                             t          j        d	          d
          	                    |          }|d         
                    d	          	                    |          }t          j        ||           d S )Nz1-1-2015z12-31-15r;   r   col1r   rY   r   c                 0    t          ddgddg          }|S )Nr   r   abr   )r   )r@   r   s     r!   r   z(test_apply_with_mutated_index.<locals>.f/  s!    Aq6#s,,,r    MEF)
group_keys)r
   r   r   r   r   r   rV   rS   r   rW   r=   r)   rX   re   )r   rZ   r   r\   r]   s        r!   test_apply_with_mutated_indexr   (  s?   z:C888E	bi++A..55c%jjAAB%
 
 
B   zz"*$///0066q99H[[$$Q''F&(+++ &z!!"*$"7"7"7E!JJPPQRSSHZ  &&,,Q//F68,,,,,r    c                     t           j                            ddg          } t          ddd          }t	          t          j        dgdz                                dd	          || 
          }d |j        D             |	                    d          
                    fd          }t	          d	ddggz  t          ddd	          t           j                            ddg          
          }t          j        ||           d S )N)r   r    one)r   r   itwoz
2017-01-0115Minr   )rI   r   r   r      r   r   r9   c                 X    i | ]'}||d          dk    rt           j        nt           j        (S )r   r   )r   rz   rc   ).0cols     r!   
<dictcomp>z1test_apply_columns_multilevel.<locals>.<dictcomp>C  s.    TTT#A%bffRWTTTr    hc                 0     | j                  |           S r   rn   )r@   agg_dicts    r!   rd   z/test_apply_columns_multilevel.<locals>.<lambda>D  s    .>hqv.>q.A.A r    g        1h)rS   rp   from_tuplesr
   r   r   arrayreshaper9   r=   rW   r)   rX   )colsindrZ   r]   r\   r   s        @r!   test_apply_columns_multilevelr   >  s   =$$&;=S%TUUD
<gq
A
A
AC	28QC"H%%--a333	M	M	MBTTTTTH[[##$A$A$A$ABBF	aXJ|$BBB))"$:;
 
  H &(+++++r    c                  H   d } t          dddd          }t          g d|          }t          g d	|          }|                    d
                              | |d          }t          ddd
d          }t          dg|          }t	          j        ||           d S )Nc                     |                                  } |                    | j                                      d                                          }|j        d         |z  }| ||k             j        d         S )Nr   )sort_valuesreindexr   fillnacumsumiloc)seriesweightsqr   cutoffs        r!   weighted_quantilez5test_apply_non_naive_index.<locals>.weighted_quantileP  sh    ##%%..55a88??AAR1$f&',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=   rW   r)   re   )r   timesrY   r   r]   r   r\   s          r!   test_apply_non_naive_indexr  O  s    0 0 0 (!'eLLLE,,,E:::D666eDDDG]]3%%&7C%PPF
#%@su  C se3'''H68,,,,,r    c                 Z   t          ddd|           }t          |g dg dd          }d	}t          j        t          |
          5  |                    d                              dd                                          }d d d            n# 1 swxY w Y   t          j	        g dt          j
                  t          j	        g dd|  d          g}t          j                            |dd g          }t          g dg dd|          }t          j        ||           d S )Nz
2000-01-01rw   r4   )r   r   unit)r   r   r   r   r   )r   r   r   r   r   )col0r   )r   rY   rE   rC   r  1Wleft)label)r   r   r   r   r   )z
1999-12-26
2000-01-02r  r  zM8[]rk   )r   r   r   r   )r   r   r   r   r   )r
   r   r)   r*   rU   rV   r=   rz   r   r   r   rS   rp   rq   rX   )r  r   rZ   r[   r]   mimindexr\   s           r!    test_resample_groupby_with_labelr  b  s   |$EEEE	ooo%W%W	X	X	XB
FC		#M	=	=	= G GF##,,T,@@DDFFG G G G G G G G G G G G G G G 	RX...
DDD---	
 	
 	

B ]&&r&$&@@F"llLLL99  H &(+++++s   	=BBBc                 ^   | }t          g dd          }d}t          j        t          |          5  |                    d                              d                                          }d d d            n# 1 swxY w Y   |j        j        dk    sJ t          j	        |j        j
        d         |           |                    d                              d	                                          }|j        j        dk    sJ t          j	        |j        j
        d         |           d S )
N)r   r   r   r   r   rE   rC   rb   r   r   r   )r   r)   r*   rU   rV   r=   rc   r   nlevelsr   levelsrolling)r"   rZ   r\   r[   r]   s        r!   test_consistency_with_windowr  y  sK   	BYYYS)))H
FC		#M	=	=	= 7 7C))$//44667 7 7 7 7 7 7 7 7 7 7 7 7 7 7<1$$$$&,-a0(;;;ZZ__$$R((--//F<1$$$$&,-a0(;;;;;s   ;A::A>A>c            	         t          t          j                            d                              d          t          d          t          ddd                    } |                                 }g d	|_        |	                    d
          
                                }| 	                    d
          
                                }|j        |_        t          j        ||           d S )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)   rX   )rZ   df2r\   r]   s       r!   test_median_duplicate_columnsr    s     

	a  0099Ur<<<
 
 
B
 ''))C!//CK||D!!((**H[[%%''F~H&(+++++r    c                     t          t          d          t          dd          dt          ddd                    } |                     d                              d	           }t          g d
t          ddd                    }t          j        ||           |                     d                              d           }t          j        ||           d S )Nr  r   )r   r   r  20minr   r   r   c                 4    | j                                         S r   )r   rz   rM   s    r!   rd   z0test_apply_to_one_column_of_df.<locals>.<lambda>  s    %)--// r    )r   r      	   rG   c                 6    | d                                          S )Nr   r   r!  s    r!   rd   z0test_apply_to_one_column_of_df.<locals>.<lambda>  s    %,2B2B2D2D r    )r   r   r
   r=   rW   r   r)   re   )rZ   r]   r\   s      r!   test_apply_to_one_column_of_dfr%    s    	b		5R==11r@@@
 
 
B [[##$A$ABBFjqsKKK  H 68,,, [[##$D$DEEF68,,,,,r    c                  T   t          g dg dg dd          } t          j        | d                   | d<   |                     d                              dd          }|d	g                                         }|                    d	d
i          }t          j        ||           d S )N)cat_1r'  cat_2r'  r(  r'  r(  r'  )r4   r      r   rG      r  2   )z2019-2-1z
2018-02-03	2020-3-112019-2-2r-  z	2018-12-4r,  z
2020-12-12)catnumr5   r5   r.  YErx   r/  rz   )	r   rS   rT   rV   r=   rz   r   r)   rX   )rZ   	resampledr\   r]   s       r!   test_resample_groupby_aggr2    s    		 	 	 100	 	 		
 	

 
B2 6
++BvJ

5!!**4F*;;I%!%%''H]]E5>**F&(+++++r    c                     t          d          } t          dgdgdt          | gd                    }|                    d                              d	          d
         }|                    ddg          }t          ddggt          j                            d| fgddg          ddg          }t          j
        ||           d S )Nz2021-02-28 00:00:00betaE   )classvaluer5   r   r   r6  r   r7  rz   r   r   rk   r   )r	   r   r   rV   r=   r   rS   rp   r   r)   rX   )r   rZ   r1  r]   r\   s        r!   "test_resample_groupby_agg_listliker8    s    	(	)	)B	fX55UB4f=U=U=U	V	V	VB

7##,,T227;I]]E6?++F
a	m''&"w>O'PP  H
 &(+++++r    keysr   r   c                 R   t          g ddgt          g                     }d}t          j        t          |          5  |                    |                               t          j        d                    	                                }d d d            n# 1 swxY w Y   t          ddg          
                    | d	
          
                    t          g           d          }t          |           dk    r| d         |j        _        t          j        ||           d S )Nr   r   r  rE   rC   00:00:01ruler8   FdropT)appendr   r   )r   r   r)   r*   rU   rV   r=   rS   to_timedeltarc   r<   r   r   rn   rX   r9  rZ   r[   r]   r\   s        r!   
test_emptyrC    sX    
2Sz1C1C	D	D	DB
FC		#M	=	=	= T TD!!**
0K0K*LLQQSST T T T T T T T T T T T T T T 	3*%%%	4e	$	$	>"%%d	3	3 
 4yyA~~"1g&(+++++s   ABB BconsolidateTFc                 >   t          ddd          }t          d|t          d          dd          }t          d|t          d          d	          }t          j        ||gd
          }| r|                                }d}t          j        t          |          5  |	                    dg          
                    dd                                          }d d d            n# 1 swxY w Y   t          j                            dgdz  dgdz  z   t          j        g ddz                                d          gddg          }t          dgdz  dgdz  z   g ddz  dgdz  t           j        gdz  z   d|          }t          j        ||           d S )Nz
2020-01-01   r;   r   r   rN   )keyr5   r   
col_objectr   )rG  r5   r   T)ignore_indexrE   rC   rG  rH   r5   rx   r   )z
2020-01-05z
2020-01-12z
2020-01-19r   nsrk   )r   r4   r   )rG  r   rH  r   )r
   r   r   rS   concat_consolidater)   r*   rU   rV   r=   r   rp   rq   rT   as_unitr   nanrX   )	rD  datesdf1r  rZ   r[   r]   idxr\   s	            r!   .test_resample_groupby_agg_object_dtype_all_nanrR    s    |Rc:::E
Cb		QVWW
X
XC
Cb		BB
C
CC	C:D	1	1	1B __
FC		#M	=	=	= D DUG$$--cf-==AACCD D D D D D D D D D D D D D D
-
#
#EAI	!NEEEIJJRR 	
 fo $  C 519uqy(JJN 'A+14	
 	

   H &(+++++s   >C))C-0C-c                     t          t          dd          g dg dd          } |                     d                              d	d
          dg                                         }t
          j                            g d| d
         j        d d d         gdd
g          }t          dg di|          }t          j
        ||           d S )NrF   r   rI   r   r   r   r   r   r   r   r   r   )r   r3   r4   r   r   r  r4   r   rL   )rY   rM   rw   r5   rx   rN   r   r   r   r   r   rk   )      @g      @g      @g      @r   )r   r
   rV   r=   rc   rS   rp   rq   _valuesr)   rX   rZ   r]   mi_expr\   s       r!   'test_groupby_resample_with_list_of_keysr[    s   	\1===---,,,
 

 
 
B ZZ  ))$6)::E7CHHJJF]&&	r&z)##A#./7H '  F '''
 	  H &(+++++r    c                    t          g g d          }t          j        |d                   |d<   |                    d          }d}t	          j        t          |          5  |                    |                               t          j	        d                    
                                }d d d            n# 1 swxY w Y   t          g d                              | d	          }t          j        |d                   |d<   |                    dd
d
          }t          |           dk    r| d         |j        _        t	          j        ||           d S )N)r   r   r5   r8   r5   rE   rC   r;  r<  Fr>  T)r@  r?  r   r   )r   rS   rT   r<   r)   r*   rU   rV   r=   rA  rc   r   r   rn   rX   rB  s        r!   test_resample_no_indexr]  (  s    
2111	2	2	2B6
++BvJ	f		B
FC		#M	=	=	= T TD!!**
0K0K*LLQQSST T T T T T T T T T T T T T T!3!3!3444>>t%>PPH~hv&677HV!!&D!AAH
4yyA~~"1g&(+++++s   #AB==CCc                     t          t          t          j        g d          d                    } |                     g d                              t          j        d                                                    }t          j        g d          }t          t          j        t          j
        d	d
gt          j                  |gg dg dgd dg                    }t          j        ||t                                  d S )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:00r<  )r_  z2018-01-01 06:00:00r`  ra  r   r   r
  )r   r   r   r   )r   r   r   r   )r  codesrl   )check_index_type)r   r   rS   rT   rV   r=   rA  rc   rp   r   r   intpr)   rX   r   )rZ   r]   r   r\   s       r!   test_resample_no_columnsre  :  s+   	NUUU  	
 
 

 
 
B ZZ			""++1L1L+MMRRTTFN	
 	
 	
 E mHaV27333U;<<..
 
 
  H &(ATAVAV=VWWWWWWr    c                  N   t          dgdz  dgdz  z   dgdz  z   dgdz  z   t          j        d          dt          ddd          	          } d
}t	          j        t          |          5  |                     d                              d          	                                }d d d            n# 1 swxY w Y   t          j                            g dt          j        ddgdz  d          gdd g          }t          d|	          }t	          j        ||           d S )Nr   r   r   r   r   z31/12/2000 18:00r   r   r   rE   rC   r   r;   rJ   z
2000-12-31z
2001-01-01zM8[ns]r
  rk   )r   r   r   r
   r)   r*   rU   rV   r=   r   rS   rp   rq   r   r   re   )rZ   r[   r]   rZ  r\   s        r!   )test_groupby_resample_size_all_index_samerg  Y  s   	cAga1#')QC!G3")B--HH+#rBBB
 
 
B GC		#M	=	=	= 6 6C))#..33556 6 6 6 6 6 6 6 6 6 6 6 6 6 6 ]&&LLlL9A=XNNN	
 Dk '  F 	  H 68,,,,,s   -;B44B8;B8c                     t          g dg ddt          ddd                    } |                     d	                              d
          dg                                         }t
          j                            g d| j        d d d         gd	dg          }t          dg di|          }t          j
        ||           d S )NrU  r   r   rG   r   r4   r#  r   rK   rM   rN   rF   r   r5   rI   r   rn   r   rM   rw   rN   rV  r   rk   g       @g      @g      @rW  r   r
   rV   r=   rc   rS   rp   rq   r   r)   rX   rY  s       r!   0test_groupby_resample_on_index_with_list_of_keysrn  q  s    	---+++
 
 |QVDDD
 
 
B ZZ  ))$//8==??F]&&	rx!}%gv-> '  F '''
 	  H &(+++++r    c                     t          g dg dg dg ddt          ddd	          
          } |                     d                              d          ddg                                         }t
          j                            g d| j        d d d         gddg          }t          g dg dd|
          }t          j
        ||           d S )NrU  ri  )r   r3   r   r   r   r   r   r   )r   rG   r   rG   r   r   r   r4   )rM   	first_val
second_val	third_valrF   r   r5   rk  r   rM   rw   rp  rq  rV  r   rk   rl  )      @rs  g      @rs  )rp  rq  rm  rY  s       r!   >test_groupby_resample_on_index_with_list_of_keys_multi_columnsrt    s   	---111222111	
 
 |QVDDD
 
 
B ZZ  ))$//l0KLQQSSF]&&	rx!}%gv-> '  F ---...
 
   H &(+++++r    c            	      @   t          g dg ddt          t          dd          d          	          } |                     d
          }|                    d          }t          j        t          d          5  |dg          d d d            d S # 1 swxY w Y   d S )NrU  ri  rj  rF   r   rT  r5   r   r   rM   rw   zColumns not foundrC   val_not_in_dataframe)r   r   r
   rV   r=   r   r   KeyError)rZ   gbrss      r!   ?test_groupby_resample_on_index_with_list_of_keys_missing_columnrz    s   	---+++
 
 \1555
 
 
	
 	
 	
B 
G		B	T		B	x':	;	;	; % %
"#$$% % % % % % % % % % % % % % % % % %s   <
BBBkinddatetimeperiodc                    t          t          j        g d          g dg dd          }|                    d          }|                    d          d                             d| 	                                          }t          j        d
dg          }| dk    r|                    d          }t          j	        
                    ddg|gddg          }t          g d|d          }t          j        ||           d S )N)z20181101 1100z20181101 1200z20181102 1300z20181102 1400)r   r   r   r   )r   r   r   rG   )r|  rM   r7  r|  rM   r7  r;   )r{  z
2018-11-01z
2018-11-02r}  r   r   r   rk   )r   r   r   rG   rm   )r   rS   rT   r<   rV   r=   r   r   	to_periodrp   from_productr   r)   re   )r{  rZ   r]   dt_levelexpected_indexr\   s         r!   test_groupby_resample_kindr    s(    
TTT  *))!\\	
 	

 
B 
j	!	!BZZ  )223T2BBGGIIF| <==Hx%%3%//]//
sX
# 0  N lll.wGGGH68,,,,,r    )5textwrapr   numpyr   r   pandas.compatr   pandasrS   r   r   r   r   r	   pandas._testing_testingr)   pandas.core.indexes.datetimesr
   fixturer"   r0   r^   rg   rt   r|   r   r   markparametrizer   r   r   r   r   r   r  r  r  r  r%  r2  r8  rC  rR  r[  r]  re  rg  rn  rt  rz  r  r   r    r!   <module>r     s              - - - - - -                        4 4 4 4 4 4   5 5 5,/, /, /,d- - -"- - -(( ( (&C &C &CR- - -2    (
& 
&) (
&- - - uen--	, 	, .-	,, , ,8- - -,, , ,"- - -&, , ,.< < <, , , - - -&!, !, !,H, , , 3%#s!455, , 65," u66, , 76,B, , ,. 3%#s!455, , 65,"X X X>- - -0, , ,., , ,4% % %$ *h!788- - 98- - -r    