403Webshell
Server IP : 209.209.40.120  /  Your IP : 216.73.217.112
Web Server : Microsoft-IIS/10.0
System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586
User : NEWWWW$ ( 0)
PHP Version : 8.3.30
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /Python312/Lib/site-packages/pandas/tests/resample/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /Python312/Lib/site-packages/pandas/tests/resample/__pycache__/test_datetime_index.cpython-312.pyc
�

0	�g#���UddlmZddlmZddlZddlZddlZddlmZddl	m
Z
ddlmZddl
mcmZddlZddlmZmZmZmZmZmZmZddlmZddlmZdd	lm Z dd
l!m"Z"m#Z#ddl$m%Z%m&Z&ddl'm(Z(dd
l)m*Z*ejV�d��Z,ejVd��Z-ejVd��Z.ejVgd���d��Z/ejVd��Z0d�Z1d�Z2ejfjiddg�ejfjiddd�fdd�fg�d���Z5d�Z6d �Z7ejfjqd!�ejfjiddg�ejfjid"gd#��d$����Z9ejfjiddg�d%��Z:ejfjiddg�d&��Z;d'�Z<d(�Z=d)�Z>d*�Z?ejfjid+gd,��d-��Z@ejfjid.d/d0g�d1��ZAejfjid.d2d0g�d3��ZBd4�ZCd5�ZDd6�ZEd7�ZFejfjid.gd8��ejfjid9gd:��d;���ZGd<�ZHd=�ZId>�ZJd?�ZKd@�ZLdA�ZMejfjidBdCdDdEdFdG�gdHdDdEdIdG�gd0dJdKdLdG�gg�dM��ZNdN�ZOdO�ZPdP�ZQdQ�ZRejfjid.gdR��dS��ZSejfjidTdUdVg�dW��ZTdX�ZUdY�ZVejfjidZd[d\id[ed]�id^d_d`�d[daidbdcig�dd��ZWejfjid[dedfdgdhdieX�g�dj��ZYejfjidbdedkdieX�g�dl��ZZdm�Z[dn�Z\do�Z]dp�Z^dq�Z_dr�Z`ds�Zadt�Zbdu�Zcdv�Zddw�Zedx�Zfdy�Zgdz�Zhd{�Zid|�Zjejfjid.gd}��d~��Zkejfjiddd�gdd�gg�d���Zld��Zmd��Znd��Zod��Zpd��Zqejfjid�d�d�d�ej�d�ejfj�d�������g�d���Ztd��Zud��Zvd��Zwed�d�dU�ed�d�d��ed�d�d��ed�d�d��ed�d�d��ed�d�d��gZxeye
ezd�<exddVej�gzexdVd�zej�gzexd�dzZ|eye
ezd�<ej�gexzej�gzZ}ejfjid�exe|e}g�d���Z~ejfjid�exe|e}g�d���Zd��Z�d��Z�ejfjid�d��d��d��ggd�����d���Z�ejfjid�d�d�g�ejfjid�gd���d����Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�d��Z�ejfjid�gd���ejfjid�gd���d„��Z�ejfjid�gdĢ�dń�Z�ejfjid�d�d�g�dɄ�Z�ejfjid�gdˢ�d�e�d�e�d�e�d�e�d�e�f
dф�Z�ejfjid�gdҢ�dӄ�Z�dԄZ�dՄZ�dքZ�ejfjid�gdآ�dل�Z�ejfjid�gdڢ�dۄ�Z�d܄Z�ejfjid.d�d�g�d.e�fd߄�Z�d�Z�e�j>d�ejfjid�dej�d�ejfj�e�d�����g�d���Z�y)��)�datetime)�partialN)�lib)�DatetimeNaTType)�is_platform_windows)�	DataFrame�Index�Series�	Timedelta�	Timestamp�isna�notna)�Grouper��
date_range)�Period�period_range)�
DatetimeIndex�_get_timestamp_range_edges)�offsets)�Minutec��tS�Nr���KC:\Python312\Lib\site-packages\pandas/tests/resample/test_datetime_index.py�_index_factoryr's���rc��y)N�Minrrrr�_index_freqr ,s��rc�p�tjjd�jt|��S)N�)�np�random�default_rng�len��indexs r�_static_valuesr)1s&��
�9�9� � ��#�*�*�3�u�:�6�6r)�s�ms�us�ns)�paramsc��|jSr)�param)�requests r�unitr26s���=�=�rc��dd�}|S)zI
    Series with date range index and random data for test purposes.
    c��t|||��}ttjj	d�jt
|��|��S)N��freqr"r')rr
r#r$r%�standard_normalr&)�start�endr6�rngs    r�_simple_date_range_seriesz;simple_date_range_series.<locals>._simple_date_range_seriesAs<�����$�/���b�i�i�+�+�A�.�>�>�s�3�x�H�PS�T�Tr��Dr)r;s r�simple_date_range_seriesr>;s��U�%�$rc�:�|j|�}ttjdgt	|�z�|d��}tt
d���}|j|�}|j�gd�}|D]}|j|dd���tt
d�d	d	�
�}|j|�}|j�gd�}|D]}|j|dd���|jdk(sJ�t|j��j�sJ�dgdgdzz}|d
dd�}	|	j|dd�}	t|	d��j|�}	t||	��}
|j!d�}t#j$||
�y)N��int64�r(�dtype�r5��sum�mean�prod�min�max�varT��alt�numeric_only�right�r6�closed�label�!
i 
r����5minr'rF)�as_unitr
r#�arrayr&rr�groupby�ohlc�_cython_agg_general�ngroupsrrG�all�appendr�agg�tm�assert_series_equal)r(r2�dtir*�b�g�funcs�f�arr�idx�expect�results            r�test_custom_grouperrjHs|��
�-�-��
�C��r�x�x���c�#�h��'�s�'�B�A��V�A�Y��A�	�	�	�!��A��F�F�H�8�E�
�>��	���a�T���=�>�	�V�A�Y�w�g�>�A�	�	�	�!��A��F�F�H�8�E�
�>��	���a�T���=�>�
�9�9����������?��� � � �
�#���d�
�
�C�

�a��1�f�+�C�

�*�*�S���X�
�C�
��&�
)�
1�
1�$�
7�C�
�C�s�
#�F��U�U�5�\�F����6�6�*rc��ttd�dd��}|j|�}ttj
j
d�jt|�df�|d��}|j|�jd�}t|j�dk(sJ�t|j�d	k(sJ�y)
NrDrOrPr"�
�float64rBrFrS)rrrVrr#r$r%r&rXr^�columnsr()r(r2rbra�df�rs      r�test_custom_grouper_dfrqls����V�A�Y�w�g�>�A�
�-�-��
�C�	�
�	�	���a� �'�'��S��2��7�s�)�
�B�	�
�
�1�
���%� �A��q�y�y�>�R�����q�w�w�<�4���rz#_index_start,_index_end,_index_name)�1/1/2000 00:00:00z1/1/2000 00:13:00r(zclosed, expectedrOc	��t|jd|ddj�|ddj�|ddj�gtdddd�	��
�S)Nrr@���1/1/2000�rUr(��periodsr6�namer')r
�ilocrGr�r*s r�<lambda>r}�sQ��f������A�a��F�K�K�M�1�Q�r�7�<�<�>�1�R�S�6�;�;�=�I� ��Q�V�'�R��r�leftc	��t|ddj�|ddj�|ddj�gtdddd����S)	NrDrl�1/1/2000 00:05�rUr(rxr')r
rGrr|s rr}r}�sJ��f��2�A�����q��2�w�|�|�~�q���v�{�{�}�=� �$�a�f�7���rc��|}|jj|�|_||�}|jj|�|_|jd|d��j�}t	j
||�y)NrUrO�rQrR)r(rV�resamplerGr_r`)�seriesrQ�expectedr2r*ris      r�test_resample_basicr�xsi��4	�A��g�g�o�o�d�#�A�G���{�H��^�^�+�+�D�1�H�N�
�Z�Z��v�W�Z�
=�
B�
B�
D�F����6�8�,rc���ttd�tddd��j|�d��}|j	d�j�}tgd�tdd	d��j|�d��}t
j||�|j	d�j�}tgd
�tdd	d��j|�d��}t
j||�y)N�	rvrI�ryr6�Int64rB�3min)r���r�)r@rw��Float64)	r
�rangerrVr�rFr_r`rG)r2�tsrir�s    r�test_resample_integerarrayr��s���	�
�a����Q�U�;�C�C�D�I��
�B�
�[�[��
 �
$�
$�
&�F�����Q�V�<�D�D�T�J���H�
���6�8�,�
�[�[��
 �
%�
%�
'�F�����Q�V�<�D�D�T�J���H�
���6�8�,rc�"�|}|jj|�|_|jd�j�}t	td�dd��}|j
|�jd��}tj||�y)N�5MinrDr~rPc� �|jdS�NrT�r{��xs rr}z-test_resample_basic_grouper.<locals>.<lambda>�s�����r�
�r)
r(rVr��lastrrrXr^r_r`)r�r2r*ri�grouperr�s      r�test_resample_basic_grouperr��sn���A��g�g�o�o�d�#�A�G�
�Z�Z��
�
$�
$�
&�F��6�!�9�V�6�B�G��y�y��!�%�%�&:�;�H����6�8�,rz@ignore:The 'convention' keyword in Series.resample:FutureWarningz
keyword,value))rR�righttt)rQr�)�
convention�startttc���|jj|�|_d|�d|�d�}tjt|��5|j
di||i��ddd�y#1swYyxYw)NzUnsupported value z for `�`��match�rU)r(rV�pytest�raises�
ValueErrorr�)r��keyword�valuer2�msgs     r�test_resample_string_kwargsr��sg���<�<�'�'��-�F�L��u�g�V�G�9�A�
6�C�	���z��	-�6�����5�G�U�#3�5�6�6�6�s�A#�#A,c���|dk(rtjd�|}|jj|�|_t	j
|�}d|d<d|ddd|ddd|dd|j
|�j|�}td	d
dd�
�j|�|_t|jddd��|��}tj||�y)NrYz!covered by test_resample_how_ohlcrr@rtr"rur�rvrwrUr(rxrOr�)
r��skipr(rVr#�	ones_likerXr^r�getattrr�r_r`)r��downsample_methodr2r*�	grouplistr�ris       r�test_resample_howr��s���
�F�"����7�8��A��g�g�o�o�d�#�A�G����Q��I��I�a�L��I�a��N��I�a��O��I�b�c�N��y�y��#�'�'�(9�:�H���A�F���
�g�d�m�
�N��W�	�
�
�6�'��
�9�;L���F����6�8�,rc	���|}|jj|�|_tj|�}d|d<d|ddd|ddd|ddd�}t	|j|�j
|�jj�tdd	d
d��j|�gd
���}|jd
dd��j�}tj||�y)Nrr@rtr"rur�c���t|�j�r$tjtjd�S|j
d|j
�|j�|j
dgS�NrwrrT�r
r\r#�repeat�nanr{rJrI��groups r�_ohlcz%test_resample_how_ohlc.<locals>._ohlc��P����;�?�?���9�9�R�V�V�Q�'�'��
�
�1�
�u�y�y�{�E�I�I�K����B��H�HrrvrwrUr(rx)�open�high�low�close�r(rnrOr�)r(rVr#r�rrXr^�values�tolistrr�rYr_�assert_frame_equal)r�r2r*r�r�r�ris       r�test_resample_how_ohlcr��s���
	�A��g�g�o�o�d�#�A�G����Q��I��I�a�L��I�a��N��I�a��O��I�b�c�N�I�
�	�	�	�)�� � ��'�.�.�5�5�7���Q�V�'�J�R�R��
�1��H��Z�Z��w�g�Z�
>�
C�
C�
E�F����&�(�+rc��tjdtj��}tdt	|�d��j|�}t
||d�|��}dd�}Gd	�d
�}|jd�j|�}|jd�jd��}|jd�jt|��}|jd�jt|d
���}	|jd�j|��}
tj||�tj||�tj||	�tj||
�y)NrD�rC�
2014-01-01�d�r8ryr6��A�Br'c�*�tt|��Sr��str�type)r��as  r�fnz'test_resample_how_callables.<locals>.fn
s���4��7�|�rc��eZdZd�Zy)�,test_resample_how_callables.<locals>.FnClassc�*�tt|��Srr�)�selfr�s  r�__call__z5test_resample_how_callables.<locals>.FnClass.__call__s���t�A�w�<�rN)�__name__�
__module__�__qualname__r�rrr�FnClassr�s��	 rr��MEc�*�tt|��Srr�r�s rr}z-test_resample_how_callables.<locals>.<lambda>s��#�d�1�g�,�rr")r�)r@)r#�arangerArr&rVrr��applyrr_r�)r2�data�indror�r��df_standard�	df_lambda�
df_partial�df_partial2�df_classs           r�test_resample_how_callablesr�s ��
�9�9�Q�b�h�h�'�D�
�<��T���
E�
M�
M�d�
S�C�	��D�)��	5�B�� � ��+�+�d�#�)�)�"�-�K����D�!�'�'�(>�?�I����T�"�(�(����5�J��+�+�d�#�)�)�'�"��*:�;�K��{�{�4� �&�&�w�y�1�H����+�y�1����+�z�2����+�{�3����+�x�0rc�b�gd�}tddgdzitj|���}|jj	|�|_|jd�j
�}tdgd�itddd	�
�j	|���}tj||�|jd�j
�}tdgd�itddd	�
�j	|���}tj||�|jd
�j
�}tdddgitdd
d�
�j	|���}tj||�|jd�j
�}tdddgitddd�
�j	|���}tj||�|jd�j
�}tdddgitddd�
�j	|���}tj||�y)N)z2014-11-08 00:00:01�2014-11-08 00:00:02r�z2014-11-08 00:00:03�2014-11-08 00:00:07r��2014-11-08 00:00:08r�r�z2014-11-08 00:00:09z2014-11-08 00:00:10�2014-11-08 00:00:11r�z2014-11-08 00:00:13z2014-11-08 00:00:14z2014-11-08 00:00:15z2014-11-08 00:00:17z2014-11-08 00:00:20z2014-11-08 00:00:21r�r@�r'�6s)rwr�rwr"z
2014-11-08rw�r6ry�7s)rwrlrwr@�11sru�r"�13s�
rt�17s�r�)
r�pd�to_datetimer(rVr�rFrr_r�)r2r�rorir�s     r�test_resample_roundingr� s���
�B�*
�G�a�S�2�X�&�b�n�n�R�.@�	A�B��x�x����%�B�H�
�[�[��
�
"�
"�
$�F��	�,����D�!�<�D�D�T�J��H����&�(�+�
�[�[��
�
"�
"�
$�F��	�-� ���D�!�<�D�D�T�J��H����&�(�+�
�[�[��
�
#�
#�
%�F��	�2�q�'����E�1�=�E�E�d�K��H����&�(�+�
�[�[��
�
#�
#�
%�F��	�2�q�'����E�1�=�E�E�d�K��H����&�(�+�
�[�[��
�
#�
#�
%�F��	�2�q�'����E�1�=�E�E�d�K��H����&�(�+rc�	�ttddd�tddd�dd��j|�}ttj
j
d�jt|��|�}|jd�j�}t|�d	k(sJ�|jjgd
�k(j�sJ�|jd|dk(sJ�|jd|d
k(sJ�|jd|jdk(sJ�|jd�j�}t|�dk(sJ�|jjddgk(j�sJ�|jd|dk(sJ�|jd|dk(sJ�|jd�j�}t|�dk(sJ�|jjddgk(j�sJ�|jd|dk(sJ�|jd|dk(sJ�|jd�j�}t|�dk(sJ�|jjddgk(j�sJ�|jd|dk(sJ�|jd|dk(sJ�|jd�j�}t|�dk(sJ�|jjd	d	gk(j�sJ�|jd|dk(sJ�|jd|dk(sJ�|jd�j�}t|�dk(sJ�|jjddgk(j�sJ�|jd|dk(sJ�|jd|dk(sJ�|jd�j�}t|�dk(sJ�|jjgd�k(j�sJ�|jd|dk(sJ�|jd|dk(sJ�|jd|d
k(sJ�|jjdk(sJ�y)N��r@rlr=r(�r8r9r6rzr"zw-sunr�)rtrtrtrz1/2/2005z1/9/2005rT�W-MONz1/3/2005z	1/10/2005zW-TUEz1/4/2005�W-WEDz1/5/2005zW-THUz1/6/2005zW-FRIrwz1/7/2005r�r�)rwrr@r"r�rwrrD)rrrVr
r#r$r%r&r�r�r(�	dayofweekr\r{rz�r2rar*ris    r�test_resample_basic_from_dailyr`s9��
��t�Q��"���q�"�(=�C�g��
�g�d�m��	�r�y�y�$�$�Q�'�.�.�s�3�x�8�#�>�A��Z�Z��
 �
%�
%�
'�F��v�;�!�����L�L�"�"�i�/�4�4�6�6�6��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�V�V�B�Z�'�'�'�
�Z�Z��
 �
%�
%�
'�F��v�;�!�����L�L�"�"�q�!�f�,�1�1�3�3�3��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�{�^�+�+�+�
�Z�Z��
 �
%�
%�
'�F��v�;�!�����L�L�"�"�q�!�f�,�1�1�3�3�3��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�{�^�+�+�+�
�Z�Z��
 �
%�
%�
'�F��v�;�!�����L�L�"�"�q�!�f�,�1�1�3�3�3��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�{�^�+�+�+�
�Z�Z��
 �
%�
%�
'�F��v�;�!�����L�L�"�"�q�!�f�,�1�1�3�3�3��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�{�^�+�+�+�
�Z�Z��
 �
%�
%�
'�F��v�;�!�����L�L�"�"�q�!�f�,�1�1�3�3�3��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�{�^�+�+�+��Z�Z��_�
!�
!�
#�F��v�;�!�����L�L�"�"�&;�;�@�@�B�B�B��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�z�]�*�*�*��;�;�q�>�Q�z�]�*�*�*��<�<����'�'�'rc
�z�tddd��j|�}td|��}|jd�j	�}|j
d|dk(sJ�tt
jdd	�tdd	�D�cgc]}td
d|dd���c}��}|j
j|�|_tt
jdd	�tdd
d��j|���}|jd�j�}tj|td|j
���|jd�j�}|jd�j	�}tj||�tj||�ycc}w)Nz01-Jan-2014z05-Jan-2014r=r5r@r'r��?rti�r��19750101rDr�)rrVr
r�rGr(r#r�r�r�countr_r`rF)	r2�datesr�ri�ir*r��result1�result2s	         r�/test_resample_upsampling_picked_but_not_correctr�s]���}�m�#�>�F�F�t�L�E�
�A�U�
#�F�
�_�_�S�
!�
&�
&�
(�F��<�<��?�e�A�h�&�&�&�	�
�	�	�#�q��u�Q�PQ�{�!S�!�(�4��A�r�1�"=�!S�	�A��g�g�o�o�d�#�A�G��
�	�	�#�q����Q�S�9�A�A�$�G��H�
�Z�Z��_�
"�
"�
$�F����6�6�!�8�>�>�#B�C��j�j��o�!�!�#�G��j�j��o�"�"�$�G����7�H�-����7�H�-��"Ts�	F8
rerEc	�b�ttjjd�j	d�tt
d�t��tddd���	�}|jj|�|_	td
��}|j|�}|j|dd�
�y)Nr"��2rw�ABCDr��
2000-01-01rr�r��rnr(r�r5TrL)rr#r$r%r7r	�list�objectrr(rVrrXrZ)rer2rorbrcs     r�"test_resample_frame_basic_cy_funcsr�s���	�
�	�	���a� �0�0��9��d�6�l�&�1���r��<�
�B�
�x�x����%�B�H��T��A�
�
�
�1�
�A����!��D��9rr6�YEr�c	��ttjjd�j	d�tt
d�t��tddd���	�}|jj|�|_	|j|�j�}tj|d
|d
j|�j��y)Nr"rrr�rrr�r�rr�)rr#r$r%r7r	rrrr(rVr�rGr_r`)r6r2roris    r�test_resample_frame_basic_M_Ar�s���	�
�	�	���a� �0�0��9��d�6�l�&�1���r��<�
�B�
�x�x����%�B�H�
�[�[��
�
#�
#�
%�F����6�#�;��3��(8�(8��(>�(C�(C�(E�Frrc	��ttjjd�j	d�tt
d�t��tddd���	�}|jj|�|_	d
}tjt|��5|j|d�
�j�ddd�y#1swYyxYw)Nr")rlrwrr�rrlr�r�r�6The 'kind' keyword in DataFrame.resample is deprecatedr��period��kind)rr#r$r%r7r	rrrr(rVr_�assert_produces_warning�
FutureWarningr�rG)r6r2ror�s    r�test_resample_frame_basic_kindr �s���	�
�	�	���a� �0�0��9��d�6�l�&�1���r��<�
�B�
�x�x����%�B�H�
B�C�	�	#�	#�M��	=�0�
���D�x��(�-�-�/�0�0�0�s�"C�Cc��ttddd�tddd�dd��j|�}ttj
j
d�jt|��|�}|jd�j�}t|�d	k(sJ�|jd
|jd
k(sJ�|jd|jdk(sJ�|jjdk(sJ�y)Nr�r@rlr=r(r�r"ri�2rrT)
rrrVr
r#r$r%r&r��ffillr{r(rzrs    r�test_resample_upsampler#�s���
��t�Q��"���q�"�(=�C�g��
�g�d�m��	�r�y�y�$�$�Q�'�.�.�s�3�x�8�#�>�A��Z�Z��
�
$�
$�
&�F��v�;�%�����;�;�q�>�Q�V�V�A�Y�&�&�&��;�;�r�?�a�f�f�R�j�(�(�(��<�<����'�'�'rc��tddgtd�td�g��}|jj|�|_tdtj
tj
tj
tj
tj
dgt
td�td�td�td	�td
�td�td�gd
����}|jj|�|_tj|jd
�j�|�y)Nru�z2015-03-31 21:48:52.672000z2015-03-31 21:49:52.739000r'z2015-03-31 21:48:50z2015-03-31 21:49:00z2015-03-31 21:49:10z2015-03-31 21:49:20z2015-03-31 21:49:30z2015-03-31 21:49:40z2015-03-31 21:49:50�10sr5)r
rr(rVr#r�rr_r`r�rG)r2r*r�s   r�test_resample_how_methodr'�s����	�R���2�3��2�3�
�	�A��g�g�o�o�d�#�A�G��	�R�V�V�R�V�V�R�V�V�R�V�V�R�V�V�R�8���/�0��/�0��/�0��/�0��/�0��/�0��/�0�
��
��H��^�^�+�+�D�1�H�N����1�:�:�e�,�1�1�3�X�>rc
�n�tddd��j|�}tdtgd�|��i�}tddd��j|�}tdtt	t|��|��id	�
�}|j
d�j�}tj||�y)N�20150101�20150331�BME�r8r9r6r�)r��)�?r'r�rAr�)
rrVrr
r�r&r�r�r_r�)r2r(r�roris     r�test_resample_extra_index_pointr/s����Z�Z�e�D�L�L�T�R�E��#�v�l�%�@�A�B�H��Z�Z�c�B�J�J�4�P�E�	�C���c�%�j� 1��?�@��	P�B�
�[�[��
�
$�
$�
&�F����&�(�+rc�j�tddd��j|�}ttjjd�j
t|��|�}|jd�jd��}|j|jdd�	�}tj||�y)
Nrvr�rUr�r"rI��limitr"��methodr2)rrVr
r#r$r%r7r&r�r"�reindexr(r_r`�r2r:r�rir�s     r�test_upsample_with_limitr7s���
�Z���
8�
@�
@��
F�C�	��	�	�%�%�a�(�8�8��S��B�C�	H�B�
�[�[��
�
%�
%�A�
%�
.�F��z�z�&�,�,�w�a�z�@�H����6�8�,r)�1D�10hr�r&�rule)r�3ME�15D�30h�15Min�30sc�l�tdd||��j|�}ttjjd�j
t|��|�}|j|�jd��}|j|jdd��}tj||�y)Nrvr�)ryr6�tzr"r1�nearestr3)rrVr
r#r$r%r7r&r�rBr5r(r_r`)�tz_aware_fixturer6r:r2r:r�rir�s        r� test_nearest_upsample_with_limitrD#s����Z���:J�
K�
S�
S���C�
��	�	�%�%�a�(�8�8��S��B�C�	H�B�
�[�[��
�
&�
&�Q�
&�
/�F��z�z�&�,�,�y��z�B�H����6�8�,rc�$�|}|jj|�|_ttd���}|j	|�jd��}|j
d�j�}t|�t|�k(sJ�t|j�dk(sJ�|jd}|d|jdk(sJ�|d	|dd
j�k(sJ�|d|dd
j�k(sJ�|d|jdk(sJ�|jd
}|d|jd
k(sJ�|d	|ddj�k(sJ�|d|ddj�k(sJ�|d|jdk(sJ�y)NrDr5c� �|jdSr�r�r�s rr}z$test_resample_ohlc.<locals>.<lambda>6s��a�f�f�R�j�rr�rw���r�i����r�rTr�r�r)
r(rVrrrXr^r�rYr&rnr{rJrI)r�r2r*r�rhri�xss       r�test_resample_ohlcrI1s����A��g�g�o�o�d�#�A�G��6�!�9�%�G�
�Y�Y�w�
�
#�
#�$8�
9�F�
�Z�Z��
�
$�
$�
&�F��v�;�#�f�+�%�%�%��v�~�~��!�#�#�#�	���R��B�
�f�:������#�#�#�
�f�:��2�b�����'�'�'�
�e�9��"�R�����&�&�&�
�g�;�!�&�&��*�$�$�$�	���Q��B�
�f�:������"�"�"�
�f�:��2�A�����$�$�$�
�e�9��"�1��	�	��#�#�#�
�g�;�!�&�&��)�#�#�#rc���tddd��j|�}|jtddd��j|��}tt	t|��|��}|jddjd�j�}t|t�sJ�|jdd	jd�j�}t|t�sJ�y)
N�1-1-2000�	2-15-2000�hr5�	4-15-2000�	5-15-2000r'�30minz	4-14-2000)rrV�unionr
r�r&�locr�rY�
isinstancer)r2r(r*r�rbs     r�test_resample_ohlc_resultrTIs����z�;�S�9�A�A�$�G�E��K�K�
�;��#�F�N�N�t�T�U�E��u�S��Z� ��.�A�	���l�{��$�$�W�-�2�2�4�A��a��#�#�#�	���l�{��$�$�W�-�2�2�4�A��a��#�#�#rc���tdd�j|�}|jtd�td�td�td�g�}t	tjt|��|��}|jd�j�}|jt|d	|d
d��j|���}tj||�y)
Nz
2013-12-30z
2014-01-07r�z
2013-12-31z
2014-01-04z
2014-01-05)r�r(r�rrTr5r')
rrV�droprrr#r�r&r�rGr5r_r�)r2r:r(rorir�s      r�$test_resample_ohlc_result_odd_periodrWVs����\�<�
0�
8�
8��
>�C��H�H��l�#��l�#��l�#��l�#�		
�
�E�
��	�	�#�e�*�-�U�	;�B�
�[�[��
�
"�
"�
$�F��z�z�
�3�q�6�3�r�7�� E� M� M�d� S�z�T�H����&�(�+rc��ttdd��dtdd��dtdd��ditdd��dtdd��dtdd��d	id
��jddgd
��}|jj	|�|_d|j
_|jd�j�}tj|djd�j�|djd�j�gd
|j
��}|j
jddk(sJ�tj||�ddgddgg|_|jd�j�}tjjgd��|_tj||�y)Nz2011-01-06 10:59:05�rAi�az2011-01-06 12:43:33i�cz2011-01-06 12:54:09i/hYlrTi�)�PRICE�VOLUMEr[rZr@��axis�ColsrM)r]�keysrr�rb�cr�))r�r`r�)r�r`r�)r�r`r�)r�r`r�)rbr�r�)rbr�r�)rbr�r�)rbr�r�)rrr5r(rVrnrzr�rYr��concat�namesr_r��
MultiIndex�from_tuples)r2ro�res�exps    r�test_resample_ohlc_dataframerghs�����3��=�u��3��=�u��3��=�u���3��=�z��3��=�z��3��=�y��

�
	
��g�x��!��g�*�� �x�x����%�B�H��B�J�J�O�
�+�+�c�
�
�
�
!�C�
�)�)�	�H��	�	�s�	#�	(�	(�	*�B�w�K�,@�,@��,E�,J�,J�,L�M�
�
�Z�Z��C�
�;�;���Q��6�)�)�)����#�s�#���*�s�C�j�)�B�J�
�+�+�c�
�
�
�
!�C��-�-�+�+�		
��C�K����#�s�#rc���ttjjd�j	d�gd�td�D�cgc]}t
d|dzd����c}�	�}tj|jd
dd�f<d}tjt|��5|jd
d��j�}ddd�d}tjt|��5|jd�d��j�}ddd�td�D�cgc]}t
d|dzd����c}_tj |�ycc}w#1swY��xYw#1swY�^xYwcc}w)Nr")rwr�)��riririr�rir@�M)�year�monthr6r�r��-DataFrame.resample with axis=1 is deprecated.r��QEr\z+DataFrame.groupby with axis=1 is deprecatedc�8�t|jdz
dz�S)Nr@r�)�intrlr�s rr}z)test_resample_dup_index.<locals>.<lambda>�s���Q�W�W�q�[�A�,=�(>�rrw�Q)rk�quarterr6)rr#r$r%r7r�rr�r{r_rrr�rGrXrnr�)r	ro�warning_msgrir�r�s      r�test_resample_dup_indexrt�s2��
�
�	�	���a� �0�0��9�&�CH��9�M�a��T��Q��S�9�M�
�B�
�F�F�B�G�G�A�q�D�M�A�K�	�	#�	#�M��	E�2����T���*�/�/�1��2�8�C�	�	#�	#�M��	=�O��:�:�>�Q�:�G�L�L�N��O�LQ�RS�H�U�q��D�!�a�%�c�B�U�H�����&�(�+��N�2�2��O�O��Us$�E�!"E�(#E(� E4�E%�(E1c�J�ttddd�tddd�d��j|�}ttj
j
d�jt|��|�}|jddd�	�j�}|jd
�j�}t|�dk(sJ�t|jjtj�sJ�|jjtjd�k(sJ�y)
Nr�r@rlr=r,r"r�rOr��8h�r�)rrrVr
r#r$r%r&r�rGrSr(r6r�
DateOffset�Hour)r2rar*�bsris     r�test_resample_reresampler{�s���
��t�Q��"���q�"�(=�C��
�g�d�m��	�r�y�y�$�$�Q�'�.�.�s�3�x�8�#�>�A�	
���C��w��	7�	<�	<�	>�B�
�[�[��
�
#�
#�
%�F��v�;�"�����f�l�l�'�'��);�);�<�<�<��<�<������Q��/�/�/rzfreq, expected_kwargszYE-DEC�1990�2000zY-DECr,zYE-JUNzY-JUNz1990-01z2000-01rjc��|dd�}|jj|�|_d}tjt|��5|j|d��j
�}ddd�|j|�j
�}tdi|��|_tj|�y#1swY�OxYw)Nz1/1/1990rv�3The 'kind' keyword in Series.resample is deprecatedr�rrr)	r(rVr_rrr�rGrr`)r>r6�expected_kwargsr2r�r�rir�s        r�!test_resample_timestamp_to_periodr��s���
"�*�j�	9�B��x�x����%�B�H�
?�C�	�	#�	#�M��	=�9����T���1�6�6�8��9��{�{�4� �%�%�'�H�!�4�O�4�H�N����6�8�,�	9�9�s�"B7�7Cc��d�}tddd��j|�}ttjjd�j
t|��|��}|jdd	d	�
�j�}|jd|jdk(j�sJ�||d
d�}|jd|k(j�sJ�||dd�}|jd|k(j�sJ�y)Nc���t|�j�r$tjtjd�S|j
d|j
�|j�|j
dgSr�r�r�s rr�ztest_ohlc_5min.<locals>._ohlc�r�rrrz1/1/2000 5:59:50r&r5r"r'rUrOr�z1/1/2000 00:00rr@�r�z1/1/2000 5:55:01z1/1/2000 6:00:00)
rrVr
r#r$r%r7r&r�rYrRr{r\)r2r�r:r��	resampledrfs      r�test_ohlc_5minr��s���I�
�(�*<�5�
I�
Q�
Q�RV�
W�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B����F�7�'��B�G�G�I�I��M�M�*�+�r�w�w�q�z�9�>�>�@�@�@�
��1�R��/�C��M�M�*�+�s�2�7�7�9�9�9�
��%�&�'�
(�C��M�M�,�-��4�9�9�;�;�;rc�*�tdd�j|�}|jd�j}t	t
jjd�jt|��|��}|jd�j�}|jd��j�}t|�dk(sJ�tj|jd|d	�tj|jd	|d�y)
Nrv�	2/29/2000rDr"r'r�c��|jSr)rlr�s rr}z,test_downsample_non_unique.<locals>.<lambda>�s
��A�G�G�rrr@)rrVr�r�r
r#r$r%r7r&r�rGrXr_�assert_almost_equalr{)r2r:�rng2r�rir�s      r�test_downsample_non_uniquer��s���
�Z��
-�
5�
5�d�
;�C��:�:�a�=���D�	��	�	�%�%�a�(�8�8��T��C�4�	P�B�
�[�[��
�
#�
#�
%�F��z�z�+�,�1�1�3�H��v�;�!�������6�;�;�q�>�8�A�;�7����6�;�;�q�>�8�A�;�7rc�z�tdd�j|�}|jd�j}t	t
jjd�jt|��|��}d}tjt|��5|jd�ddd�y#1swYyxYw)Nrvr�r"r'z/cannot reindex on an axis with duplicate labelsr�r�)rrVr�r�r
r#r$r%r7r&r�r�r��asfreq)r2r:r�r�r�s     r�test_asfreq_non_uniquer��s���
�Z��
-�
5�
5�d�
;�C��:�:�a�=���D�	��	�	�%�%�a�(�8�8��T��C�4�	P�B�
;�C�	���z��	-��
�	�	�#�����s�B1�1B:c��tdd�j|�}ttjjd�j
dt|�f�|gd���}d}tjt|��5|jd	d
��j�}ddd�|jjd	�j�j}tj|�y#1swY�SxYw)Nrvr�r"r��r�rbr`rrmr�r�r@r\)rrVrr#r$r%r7r&r_rrr�rG�Tr�)r2r:rorsrir�s      r�test_resample_axis1r��s���
�Z��
-�
5�
5�d�
;�C�	�
�	�	���a� �0�0�!�S��X��?���
�B�B�K�	�	#�	#�M��	E�2����T���*�/�/�1��2��t�t�}�}�T�"�'�'�)�+�+�H����&�(�+�2�2�s�"C4�4C=)rIrU�15minrP�4h�12hc��tddd��j|�}ttjjd�j
t|��|��}tj|dd|ddj|dd��j�}|j|dd��j�}tj||�y)	Nz1/1/2000 04:00:00�Qr*r�r"r'r~r��
rrVr
r#r$r%r7r&r�r�rGr_r`)r6r2r:r�rir�s      r�test_resample_anchored_ticksr�	s����(�%�c�
B�
J�
J�4�
P�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�
�V�V�B�r��F�
���V�_�_�T�&��_�
?�
D�
D�
F�F��{�{�4��f�{�=�B�B�D�H����6�8�,rr9r@r"c�r�d�}tdd|�d�d��j|�}ttjjd�j
t|��|��}tj|jd	�j�|jd	�j|��y)
Nc�"�|j�Sr)rFr�s rr}z,test_resample_single_group.<locals>.<lambda>s��a�e�e�g�rz2000-1-1z2000-z-10r=r5r"r'r�)
rrVr
r#r$r%r7r&r_r`r�rFr�)r9r2�mysumr:r�s     r�test_resample_single_groupr�s����E�
�Z�5���S�!1��
<�
D�
D�T�
J�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B����2�;�;�t�,�0�0�2�B�K�K��4E�4K�4K�E�4R�Src�\�tddgtd�td�g��}|jj|�|_tdgt	td�gd�	�j|���}|jd�j
d
��}tj||�y)Ng�����>@g������?@z20070915 15:30:00z20070915 15:40:00r'g�?�20070915r=r5c�,�tj|�Sr)r#�stdr�s rr}z0test_resample_single_group_std.<locals>.<lambda>+s��R�V�V�A�Y�r)	r
rr(rVrr�r�r_r`)r2r*r�ris    r�test_resample_single_group_stdr�!s����	
�t���,�-�y�9L�/M�N�	�A��g�g�o�o�d�#�A�G��	
��m�Y�z�%:�$;�#�F�N�N�t�T��H��Z�Z��_�
"�
"�#6�
7�F����6�8�,rc�~�tddd��j|�}ttjjd�j
t|��|��}|jdd�	�j�}td
dd��j|�}tj|j|�y)Nrrz1/1/2000 02:00r*r5r"r'rU�2min��offset�12/31/1999 23:57:00z1/1/2000 01:57�
rrVr
r#r$r%r7r&r�rGr_�assert_index_equalr()r2r:r�r��exp_rngs     r�test_resample_offsetr�/s����(�*:��
E�
M�
M�d�
S�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B����F�6��2�7�7�9�I��.�0@�v�N�V�V���G����)�/�/�7�3r�kwargs�origin�1999-12-31 23:57:00z1970-01-01 00:02:00�epoch�2m�r�r�z1999-12-31 12:02:00r�z-3mc�|�tddd��j|�}ttjjd�j
t|��|��}tddd	��j|�}|jd
i|��j�}tj|j|�y)N�2000-01-01 00:00:00�2000-01-01 02:00r*r5r"r'r��2000-01-01 01:57rUr�r�)r�r2r:r�r�r�s      r�test_resample_originr�<s����*�,>�S�
I�
Q�
Q�RV�
W�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B���1���
�g�d�m������-�f�-�2�2�4�I����)�/�/�7�3r�
invalid_value�epch�startday�starttz
2000-30-30c�T�tddd��j|�}ttjjd�j
t|��|��}d|�d�}tjt|�	�5|jd
|��ddd�y#1swYyxYw)Nr�r�r*r5r"r'z|'origin' should be equal to 'epoch', 'start', 'start_day', 'end', 'end_day' or should be a Timestamp convertible type. Got '�
' instead.r�rU�r��rrVr
r#r$r%r7r&r�r�r�r�)r�r2r:r�r�s     r�test_resample_bad_originr�Ts����*�,>�S�
I�
Q�
Q�RV�
W�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�	��8�:�	��

���z��	-�+�
���F�6��*�+�+�+���B�B'�12dayysc�T�tddd��j|�}ttjjd�j
t|��|��}d|�d�}tjt|�	�5|jd
|��ddd�y#1swYyxYw)Nr�r�r*r5r"r'z6'offset' should be a Timedelta convertible type. Got 'r�r�rUr�r�)r�r2r:r�r�s     r�test_resample_bad_offsetr�cs���
�*�,>�S�
I�
Q�
Q�RV�
W�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�B�6�(�*�
U�C�	���z��	-�+�
���F�6��*�+�+�+�r�c�@�d\}}t||d��j|�}ttjjd�j
t|��|��}tddd��j|�}|jd�j�}tj|j|�|jdd	�
�j�}tj|j|�tddd��j|�}|jdd
�
�j�}tj|j|�|jdd��j�}tj|j|�|jdd	d��j�}tj|j|�tddd��j|�}|jdd�
�j�}tj|j|�tddd��j|�}|jdd�
�j�}tj|j|�y)N)�2000-10-01 23:30:00z2000-10-02 00:30:00�7minr5r"r'z2000-10-01 23:14:00z2000-10-02 00:22:00�17min�	start_dayr�r�z2000-10-02 00:21:00r8�23h30minr�r�z2000-10-01 23:18:00z2000-10-02 00:26:00r�z2000-10-01 23:24:00z2000-10-02 00:15:00rr�)r2r8r9r:r�r�r�s       r�test_resample_origin_prime_freqr�ls��=�J�E�3�
�U�C�f�
-�
5�
5�d�
;�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B���4�7��
�g�d�m�����G�$�)�)�+�I����)�/�/�7�3����G�K��8�=�=�?�I����)�/�/�7�3���4�7��
�g�d�m�����G�G��4�9�9�;�I����)�/�/�7�3����G�J��7�<�<�>�I����)�/�/�7�3����G�K�
��K�P�P�R�I����)�/�/�7�3���4�7��
�g�d�m�����G�G��4�9�9�;�I����)�/�/�7�3���4�7��
�g�d�m�����G�L��9�>�>�@�I����)�/�/�7�3rc��d}d}tddd|��j|�}ttjjd�j
t|��|��}td	d
d|��j|�}|jdd�
�j�}tj|j|�|jdd�
�j�}tj|j|�|jddd��j�}tj|j|�tjt|��5|jdd�
�j�ddd�tddd��j|�}ttjjd�j
t|��|��}tjt|��5|jdd�
�j�ddd�y#1swY��xYw#1swYyxYw)Nz4The origin must have the same timezone as the index.�Europe/Parisr�r�r*�r6rAr"r'r�r�rUz1999-12-31 23:57:00+00:00r�z1999-12-31 12:02:00+03:00r�r�r�r�r�r5z12/31/1999 23:57:00+03:00)rrVr
r#r$r%r7r&r�rGr_r�r(r�r�r�)r2r�rAr:r�r�r�s       r�test_resample_origin_with_tzr��s���
@�C�	�B�
��1����
�g�d�m��
��	�	�%�%�a�(�8�8��S��B�#�	N�B���1��2��
�g�d�m�����F�+F��G�L�L�N�I����)�/�/�7�3����F�+F��G�L�L�N�I����)�/�/�7�3����F�7�4��@�E�E�G�I����)�/�/�7�3�	���z��	-�A�
���F�#8��9�>�>�@�A��*�,>�S�
I�
Q�
Q�RV�
W�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�	���z��	-�G�
���F�#>��?�D�D�F�G�G�
A�A��G�G�s�""H1�"H=�1H:�=Ic��d\}}t||d��j|�}tjj	d�jt
|��}t||��}|jdd��j�}|jd	d��j�}tj||�|jd�}|jdd��j�}	|jd	d��j�}
tj||	j|j�d
��tj||
j|j�d
��d\}}t||d��j|�}t||��}|jdd��j�}|jd	d��j�}
tj|jd�|jd��tj|jd�|
jd��y)
N)z2000-10-01 23:30:00+0500z2000-12-02 00:30:00+0500r�r5r"r'r=r�r��24hF)�
check_freq)z2000-10-01 23:30:00+0200z2000-12-02 00:30:00+0200)rrVr#r$r%r7r&r
r�rGr_r`�tz_localizerA)r2r8r9r:�
random_values�ts_1�result_1�result_2�ts_no_tz�result_3�result_4�ts_2�result_5�result_6s              r�-test_resample_origin_epoch_with_tz_day_vs_24hr��s���G�J�E�3�
�U�C�f�
-�
5�
5�d�
;�C��I�I�)�)�!�,�<�<�S��X�F�M��-�s�+�D��}�}�S��}�1�6�6�8�H��}�}�U�7�}�3�8�8�:�H����8�X�.�����%�H�� � ��W� �5�:�:�<�H�� � ��w� �7�<�<�>�H����8�X�%9�%9�#�&�&�%A�e�T����8�X�%9�%9�#�&�&�%A�e�T�H�J�E�3�
�U�C�f�
-�
5�
5�d�
;�C��-�s�+�D��}�}�S��}�1�6�6�8�H��}�}�U�7�}�3�8�8�:�H����8�/�/��5�x�7K�7K�D�7Q�R����8�/�/��5�x�7K�7K�D�7Q�Rrc���
�d�
d$�
�fd�	}td�
��}td�
��}t||d��j��}tt	j
t
|��|�	�}|d
dgddg�}d
dd|dfD]9}|jd|��j�}tj||��;td�
��}td�
��}t||d��j��}tt	j
t
|��|�	�}ddg}	|ddg|	�}|jddd��j�}tj||�ddg}	|ddg|	d��}|jddd��j�}tj||�ddg}	|ddg|	�}|jddd��j�}tj||�ddg}	|d
d g|	�}|jddd!��j�}tj||�d"d#g}	|d d
g|	�}|jddd��j�}tj||�y)%N�America/Chicagor=c���t|t|D�cgc]}t|�����c}|d��j����Scc}w)NrYT)r6�	ambiguousr')r
rrrV)r��
timestampsr6�trAr2s    ��r�_create_serieszAtest_resample_origin_with_day_freq_on_dst.<locals>._create_series�sC������.8�9���1��$�9��PT���g�d�m�	
�	
��:s�A�
2013-11-02rYz2013-11-03 23:59�1hr5r'g8@g9@z
2013-11-03r�r8r�r�z2013-11-02 22:00-05:00z2013-11-03 22:00-06:00g7@�@z-2hr�z2013-11-03 21:00-06:00g6@�@r�z2013-11-02 02:00-05:00z2013-11-03 02:00-06:00�2hz2013-11-02 23:00-05:00z2013-11-03 23:00-06:00rz-1hz2013-11-02 01:00-05:00z2013-11-03 01:00:00-0500r<)rrrVr
r#�onesr&r�rFr_r`)r2r�r8r9r:r�r�r�ri�expected_tsrAs`         @r�)test_resample_origin_with_day_freq_on_dstr��sk���	�B�
�
�l�r�*�E�
�&�2�
.�C�
�U�C�d�
+�
3�
3�D�
9�C�	�����C��!��	-�B��t�T�l�\�<�,H�I�H��G�[�%��>�1�����S���0�4�4�6��
���v�x�0�1�

�l�r�*�E�
�&�2�
.�C�
�U�C�d�
+�
3�
3�D�
9�C�	�����C��!��	-�B�+�-E�F�K��t�S�k�;�7�H�
�[�[��W�U�[�
;�
?�
?�
A�F����6�8�,�+�-E�F�K��t�S�k�;�U�C�H�
�[�[��w�u�[�
=�
A�
A�
C�F����6�8�,�+�-E�F�K��s�D�k�;�7�H�
�[�[��W�T�[�
:�
>�
>�
@�F����6�8�,�+�-E�F�K��t�S�k�;�7�H�
�[�[��W�U�[�
;�
?�
?�
A�F����6�8�,�+�-G�H�K��s�D�k�;�7�H�
�[�[��W�T�[�
:�
>�
>�
@�F����6�8�,rc��tddd��j|�}ttjjd�j
t|��|��}tj|dd|ddjddd�	�j�}|jddd�	�j�}tj||�y)
Nz1/1/2000 0:00:00�'rIr�r"r'r=r~r�r�r6s     r�test_resample_daily_anchoredr�s���
�'��U�
C�
K�
K�D�
Q�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�
�V�V�B�r��F�
���V�_�_�S��v�_�
>�
C�
C�
E�F��{�{�3�v�V�{�<�A�A�C�H����6�8�,rc��tdd�j|�}ttjjd�j
t|��|��}d}tjt|��5|jdd�	�j�}ddd�td
dd�
�}tjj|�y#1swY�8xYw)Nrvz
12/31/2000r"r'rr�r�rrzJan-2000zDec-2000rjr5)rrVr
r#r$r%r7r&r_rrr�rGrr�r()r2r:r�r�ri�	exp_indexs      r�&test_resample_to_period_monthly_bugletr�s����Z��
.�
6�
6�t�
<�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�
?�C�	�	#�	#�M��	=�9����T���1�6�6�8��9��Z��#�>�I����&�,�,�	�2�9�9�s�;"C�Cc���ttjjd�j	ddd�tddd��d�	�}|j
�jd
�j�j�}d}tjt|��5|jd
�}ddd�jd
��}tj||�y#1swY�2xYw)Nr"rrDrz
2012-01-01rMr�rmrBr=z+Resampling with a PeriodIndex is deprecatedr�c�"�|j�Sr�rGr�s rr}z&test_period_with_agg.<locals>.<lambda>(s��a�f�f�h�r)r
r#r$r%�integersr�to_timestampr�rG�	to_periodr_rrr^r`)�s2r�r��rsris     r�test_period_with_aggr�s���	�
�	�	���a� �)�)�!�Q��3��<�c�2�>��
�B���� �)�)�#�.�3�3�5�?�?�A�H�
7�C�	�	#�	#�M��	=��
�[�[��
���
�V�V�&�
'�F����6�8�,���s�!C$�$C-c��dtddddd�ddfdtddddd�ddfdtddddd	�ddfdtdddddd
�ddfg}tj|d��jd
�}|jj|�|_d}t
jt|��5|jd�jd�j�}ddd�d}t
jt|��5|jd�jd��}ddd�t
j�y#1swY�gxYw#1swY�,xYw)Nr@i�rlr��rr"��r�)�ID�	timestampr�r��rnr�:DataFrameGroupBy.resample operated on the grouping columnsr�rrUz7DataFrameGroupBy.apply operated on the grouping columnsc�@�|jd�j�S)NrU)r�rFr�s rr}z(test_resample_segfault.<locals>.<lambda>?s��A�J�J�v�4F�4J�4J�4L�r)rr�from_records�	set_indexr(rVr_r�DeprecationWarningrXr�rFr�r�)r2�all_wins_and_wagersror�rir�s      r�test_resample_segfaultr
,sU��
�H�T�2�q�"�b�)�1�a�0�	
�H�T�2�q�"�b�)�1�a�0�	
�H�T�2�q�"�b�)�1�a�0�	
�H�T�2�q�"�b�"�-�q�!�4�	��
�	�	��%B�
��i�����x�x����%�B�H�
F�C�	�	#�	#�$6�c�	B�9����D�!�*�*�6�2�6�6�8��9�
C�C�	�	#�	#�$6�c�	B�N��:�:�d�#�)�)�*L�M��N����&�(�+�9�9��N�N�s�//E�"E�E
�Ec�6�ttddd��j|�gd�tgd�d��d	��j	d
�}|jd�j
�}|jjtjk(sJ�d}tjt|�
�5|jd�jd�j
�}ddd�|jjtjk(sJ�y#1swY�3xYw)Nz
2016-01-01rw�Wr�)r@r@r"r")rDrtr�r��int32r�)�dater��valrr8rr�r�)rrrVr
rr�r"rrCr#r
r_rrrX)r2rorir�s    r� test_resample_dtype_preservationrCs���
��\�1�3�G�O�O�PT�U�!��,�g�6�	
�
��i���
��[�[��
�
$�
$�
&�F��:�:���r�x�x�'�'�'�
F�C�	�	#�	#�$6�c�	B�<����G�$�-�-�d�3�9�9�;��<��:�:���r�x�x�'�'�'�<�<�s�./D�Dc�"�tjd�dgd�i}t|tdd�j	|���}|jd�j
d�j�djd	�}|j
d�dj�jd	�}tj||�|j
d�j�djd	�}tj||�y)
Nzscipy.interpolater�)r@r�r@rwz
2017-01-01z
2017-01-04r'rmrM�cubic)r��importorskiprrrV�astyper�rG�interpolater_r`)r2ror�ris    r�test_resample_dtype_coercionrXs���
���+�,��|�	�B�	�2�Z��l�C�K�K�D�Q�	R�B��y�y��#�,�,�S�1�6�6�8��=�I�I�'�R�H�
�[�[��
�c�
"�
'�
'�
)�
5�
5�g�
>�F����6�8�,�
�[�[��
�
"�
"�
$�S�
)�
5�
5�g�
>�F����6�8�,rc�j�tddd��j|�}ttjjd�j
t|��|��}|jd�j�}|jd�j�}tj||�y)	Nrvr�r�r�r"r'rzW-SUN)rrVr
r#r$r%r7r&r�rGr_r`)r2r:r�r�r�s     r�test_weekly_resample_bugletrhs���
�Z�c�2�
6�
>�
>�t�
D�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B����C� �%�%�'�I��{�{�7�#�(�(�*�H����9�h�/rc���tddd��j|�}ttjjd�j
t|��|��}|jd�y)N�4/16/2012 20:00i�rMr�r"r'r�)	rrVr
r#r$r%r7r&r��r2rr�s   r�test_monthly_resample_errorrrsR���(�$�S�A�I�I�$�O�E�	��	�	�%�%�a�(�8�8��U��D�E�	R�B��K�K��rc���d}d}ttj|�dd��}tt	t|��|��}|j
tjjjd��}|jd�}ttj|�dd��}tt	t|��|t�	�}tj||�y)
Nl�*dG@l�*dG@rl�100nsr�r'�drGrB)rr�r�r
r�r&r��tseriesr�Nanor^�floatr_r`)r8�	exp_start�indxr�rpri�exp_indxrfs        r�test_nanosecond_resample_errorr&zs���
�E��I��B�N�N�5�1�2�G�L�D�	��c�$�i� ��	-�B�
���B�J�J�&�&�+�+�C�0�1�A�
�U�U�6�]�F�����y� 9�2�G�T�H�
��s�8�}�%�X�U�
C�C����6�3�'rc���tddd��j|�}t|j|��}|j	d�j�}d}t
jt|��5|j	dd	�
�j�jd��}ddd�xjtd
d�td
d�z
z
c_
|jj|�jd�|_
|jjdk(sJ�t
j||�|j	dd��j�}d}t
jt|��5|jd
d��j	dd	�
�j�}ddd�jd��}|jtd
d�ztd
d�z
|_
|jj|�jd�|_
|jjdk(sJ�t
j||�y#1swY���xYw#1swY��xYw)N�1/1/2012�4/1/2012�100minr5r'r�rr�rrr9��howr@r-r=�inferr~�rQ)rrVrrlr�rGr_rrr�r(r�
_with_freqr6r��shift)r2r:rorir�r�rfs       r�test_resample_anchored_intradayr1�s����Z��(�
;�
C�
C�D�
I�C�	�3�9�9�C�	(�B�
�[�[��
�
#�
#�
%�F�
B�C�	�	#�	#�M��	=�S��;�;�t�(�;�3�8�8�:�G�G�E�G�R��S��N�N�i��4�(�9�Q��+<�<�<�N��^�^�+�+�D�1�<�<�W�E�H�N��>�>���$�&�&�&����&�(�+�
�[�[��f�[�
-�
2�
2�
4�F�
B�C�	�	#�	#�M��	=�I��h�h�q�s�h�#�,�,�T��,�A�F�F�H��I�

�
�
�u�
�
%�C��	�	�I�a��.�.��1�c�1B�B�C�I��	�	�!�!�$�'�2�2�7�;�C�I��9�9�>�>�T�!�!�!����&�#�&�!S�S��I�I�s�12I�53I�I�I$c��tddd��j|�}t|j|��}|j	d�j�}d}t
jt|��5|j	dd	�
�j�jd��}ddd�xjtd
d�td
d�z
z
c_
d|jj_
tj|j_|jj|�|_
t
j"||�|j	dd��j�}d}t
jt|��5|j%d
d��j	dd	d��j�}ddd�|jd��}|xjtd
d�td
d�z
z
c_
d|jj_
tj|j_|jj|�|_
t
j"||�y#1swY���xYw#1swY��xYw)Nr(r)r*r5r'rnrr�rrr9r+r@r-r=r~r.)rrQ)rrVrrlr�rGr_rrr�r(r�_datar6r�
no_default�_freqr�r0)r2r:rorir�r�s      r� test_resample_anchored_intraday2r6�s���
�Z��(�
;�
C�
C�D�
I�C�	�3�9�9�C�	(�B�
�[�[��
�
#�
#�
%�F�
B�C�	�	#�	#�M��	=�S��;�;�t�(�;�3�8�8�:�G�G�E�G�R��S��N�N�i��4�(�9�Q��+<�<�<�N� $�H�N�N�����>�>�H�N�N���^�^�+�+�D�1�H�N����&�(�+�
�[�[��f�[�
-�
2�
2�
4�F�
B�C�	�	#�	#�M��	=�
��H�H�Q�S�H�!�*�*�4�h�v�*�N�S�S�U�	�
��$�$��$�/�H��N�N�i��4�(�9�Q��+<�<�<�N� $�H�N�N�����>�>�H�N�N���^�^�+�+�D�1�H�N����&�(�+�'S�S��
�
�s�12I0�4I=�0I:�=Jc��|ddd��}|jj|�|_|jd�j�}t	|�dk(sJ�y)Nz2012-04-29 23:00z2012-04-30 5:00rMr5r�r@)r(rVr�rGr&)r>r2r�r�s    r� test_resample_anchored_intraday3r8�sQ��	!�"4�6G�c�	R�B��x�x����%�B�H����D�!�&�&�(�I��y�>�Q���r)�MS�BMSzQS-MARzYS-DECzYS-JUNc��|dd�}|jj|�|_|j|�j�y)Nrvz
12/31/2002)r(rVr�rG)r>r6r2r�s    r�!test_resample_anchored_monthstartr<�s9��	!�*�l�	;�B��x�x����%�B�H��K�K�����rz
label, secr�z4.2c�T�tddd��}tddd��}|j|�}ttjjd�j
d�|�	�}|jd|�
�j�}|jdtd|�d
��k(sJ�y)Nz2014-10-14 23:06:23.206r��400msr�z2014-10-15 23:00:00r"�2200msrDr')rRrTz2014-10-15 23:00:�00)rrQr
r#r$r%r7r�rGr(r)rR�sec�index1�index2r(r*ris       r�test_resample_anchored_multidayrD�s����1�1�7�
K�F�
�-�q�x�
H�F��L�L�� �E��r�y�y�$�$�Q�'�7�7��:�%�H�A��Z�Z���Z�
.�
3�
3�
5�F��<�<���y�+<�S�E��)D�E�E�E�Erc��tddd��j|�}ttjjd�j
t|��|��}|jddd	�
�j�}tddd��j|�}tj|j|�y)
Nrvr�rIr�r"r'rUrOr~r�z1999-12-31 23:55rwr�)r2r:r�ri�ex_indexs     r�test_corner_casesrG�s����Z��%�
8�
@�
@��
F�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�
�[�[���v�[�
>�
C�
C�
E�F��,�a�f�E�M�M�d�S�H����&�,�,��1rc�^�|ddd��}|jj|�|_d}tjt|��5|jdd�	�j
�}ddd�t�d
k(sJ�|jdtdd
��k(sJ�y#1swY�9xYw)Nz
2000-04-28z2000-04-30 11:00rMr5rr�r�rrr@rz2000-04rj)	r(rVr_rrr�rGr&r)r>r2r�r�ris     r�test_corner_cases_daterI�s���	!�,�0B��	M�B��x�x����%�B�H�
?�C�	�	#�	#�M��	=�9����T���1�6�6�8��9��v�;�!�����<�<��?�f�Y�S�9�9�9�9�9�9�s�	"B#�#B,c��tddd��j|�}ttjjd�j
t|��|��}|jd�j�y)NriP�r*r�r"r'r�)
rrVr
r#r$r%r7r&r�rGrs   r�test_anchored_lowercase_bugletrK�s[���(�%�c�B�J�J�4�P�E�	��	�	�%�%�a�(�8�8��U��D�E�	R�B��K�K�����rc�*�tddd��j|�}ttjjd�j
t|��|��}|jd�jdd	g�}t|t�sJ�y)
N�
2012-06-12rwrMr�r"r'�20minrGrF)rrVr
r#r$r%r7r&r��	aggregaterSr)r2r:r�ris    r�test_upsample_apply_functionsrP�sr��
�\�1�3�
7�
?�
?��
E�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�
�[�[��
!�
+�
+�V�U�O�
<�F��f�i�(�(�(rc��tddd��j|�}ttjjd�j
t|��|��}|jtjjd�jt|���}|jd�j�}|j�jd�j�}tj||�y)NrM��rMr�r"r'r=)rrVr
r#r$r%r7r&�take�permutationr�rF�
sort_indexr_r`)r2r:r�rirfs     r�test_resample_not_monotonicrV	s���
�\�3�S�
9�
A�
A�$�
G�C�	��	�	�%�%�a�(�8�8��S��B�#�	N�B�	������&�&�q�)�5�5�c�"�g�>�	?�B�
�[�[��
�
!�
!�
#�F�
�-�-�/�
"�
"�3�
'�
+�
+�
-�C����6�3�'rrCrAr
rm�float32z-Empty groups cause x.mean() to return float64)�reason)�marksc��ttdddddd�tdddddd�g�j|�}tddg||��}|j	d�jd��}|j
d�}tj||�|j	d�j�}|j
d�}tj||�y)	N��r@rrDr"rBrIc�"�|j�Srr�r�s rr}z/test_resample_median_bug_1688.<locals>.<lambda>-�������r)
rrrVrr�r�r�r_r��median)rCr2rarorirfs      r�test_resample_median_bug_1688r_s��� �	�$��1�a��A�	&���q�!�Q��1�(E�F��
�g�d�m��
�	
�A����
�B��[�[��
�
%�
%�&8�
9�F�
�)�)�E�
�C����&�#�&�
�[�[��
�
&�
&�
(�F�
�)�)�E�
�C����&�#�&rc��|dd�}|jj|�|_|jd�jd��}|jd�j	�}tj||�|jd�j	�}d|_|jd�j�}d|_|jd�jd�d�g�}ddg|_	tj|d|�tj|d|�|jd�jd	�d
�d��}tj|d|d�
�tj|d|d�
�y)Nrvz4/1/2000r�c�"�|j�Srr�r�s rr}z+test_how_lambda_functions.<locals>.<lambda>:s��q�v�v�x�r�foo�barc�"�|j�Srr�r�s rr}z+test_how_lambda_functions.<locals>.<lambda>Cr]rc�&�|jd��S�Nr@)�ddof�r�r�s rr}z+test_how_lambda_functions.<locals>.<lambda>Cs��A�E�E�q�E�M�rc�"�|j�Srr�r�s rr}z+test_how_lambda_functions.<locals>.<lambda>Ks��!�&�&�(�rc�&�|jd��Srfrhr�s rr}z+test_how_lambda_functions.<locals>.<lambda>Ks��Q�U�U��U�]�r)rbrcF)�check_names)r(rVr�r�rGr_r`rzr�rnrO)r>r2r�rirf�foo_exp�bar_exps       r�test_how_lambda_functionsrn6sF��	!�*�j�	9�B��x�x����%�B�H�
�[�[��
�
$�
$�%7�
8�F�
�+�+�d�
�
 �
 �
"�C����6�3�'��k�k�$��$�$�&�G��G�L��k�k�$��#�#�%�G��G�L�
�[�[��
�
$�
$�&8�:Q�%R�
S�F��U�^�F�N����6�%�=�'�2����6�%�=�'�2��[�[��
�
(�
(�"�+B�C��F����6�%�=�'�u�E����6�%�=�'�u�Erc���tdddd�}tdddd�}t||d	�
�j|�}tddi|��}|j	d
�j�y)Ni�r�r@rDr[r�r�rwrPr5r�r'�YS)rrrVrr�rF)r2r8r9�bad_indros     r�test_resample_unequal_timesrrQsb���T�1�a��#�E�
�4��B��
"�C����'�2�:�:�4�@�G�	�G�Q�<�w�	/�B��K�K�����rc�x�tddd��j|�}ttjd�|��}tj
|jd<t|d|d	d
��j|�}|j|d�
�}|j|dd��}|j|dd��}|jd�jd��}|jd�j�}tj||�tj||�tj||�y)Nz
2002-02-02rwrPr��@r'r"rrT�10minr5�bfill)r(r4)r(r4r2r3�10Minr1)
rrVr
r#r�r�r{r5�reindex_liker�rvr_r`)	r2�i30r*�i10�s10�s10_2�rl�r10_2�r10s	         r�test_resample_consistencyr�]s���\�1�7�
;�
C�
C�D�
I�C��r�y�y��~�S�)�A����A�F�F�1�I��S��V�S��W�7�
3�
;�
;�D�
A�C�
�)�)�#�g�)�
.�C�
�I�I�C��q�I�9�E�	
����G�1��	5�B�
�J�J�w��%�%�A�%�.�E�
�*�*�W�
�
#�
#�
%�C����5�#�&����5�%�(����5�"�%r��rlr�r�rurDr�r�r�dates1rw�dates2rc�v�t|�j|�}t|tjt|��d��}|j
d�jd�j�}tgd�dd��j|�}tdgd�i|��}|dj�j�r |jjd�|_tj||�|jt!dd�	��j�}tj||�y)
Nr�r�r��z
2014-07-31z
2014-08-31z
2014-09-30z
2014-10-31z
2014-11-30�r6rzr��r@rr"r"r@r'�r6�key�rrVrr#r�r&rr�rr
�anyr(r/r_r�rXr�rr2rori�exp_idxr�s      r�test_resample_timegrouperr��s���
�%� �(�(��.�E�	��R�Y�Y�s�5�z�%:�;�	<�B�
�\�\�#�
�
'�
'��
-�
3�
3�
5�F��N�
�
���g�d�m�	�
�#��/�w�?�H�	�#�w�|�|�~����!���2�2�4�8������&�(�+�
�Z�Z��T�s�3�
4�
:�
:�
<�F����&�(�+rc	��t|�j|�}t|tjt|��tjt|��d��}|j
d�jd�j�}tgd�dd��j|�}tgd�gd�d�|dd	g�
�}|dj�j�r |jjd�|_tj||�|jt!dd���j�}tj||�y)N)r�r��Cr�r�r�r�r�)r�r�r�r�r�r�r�r�s      r�test_resample_timegrouper2r��s���%� �(�(��.�E�	��R�Y�Y�s�5�z�%:����3�u�:�AV�W�	X�B�
�\�\�#�
�
'�
'��
-�
3�
3�
5�F��N�
�
���g�d�m�	�
��O�4���c�
��H�

�#�w�|�|�~����!���2�2�4�8������&�(�+�
�Z�Z��T�s�3�
4�
:�
:�
<�F����&�(�+rc��ttd�dtd�ditd�dtd�did��}|jj|�|_|j	d�}|jt
d�	��}|jt
d�	��jjd
��}|jdk(sJ�||fD]2}|jj�}tj||��4|jj	d�j�}tj||�|jjt
d�	��j�}tj||�y)Nz2015-06-05 00:00:00�
0010100903z2015-06-08 00:00:00�
0010150847z
2015-06-05z
2015-06-08)r�DATEr=r5c�"�|j�Sr��nuniquer�s rr}z'test_resample_nunique.<locals>.<lambda>�s���	�	��rr)
rrr(rVr�rXrrr�rzr�r_r`)r2rorprcr�r�ris       r�test_resample_nuniquer��sJ��	��/�0�,��/�0�,��
�/�0�,��/�0�,��		
�
�B��x�x����%�B�H�
���C��A�
�
�
�7��$�%�A��z�z�'�s�+�,�/�/�5�5�6K�L�H��=�=�D� � � ���V�1���������
���v�x�0�1��U�U�^�^�C�
 �
(�
(�
*�F����6�8�,�
�U�U�]�]�7��,�
-�
5�
5�
7�F����6�8�,rc	�6�ttjjd�j	d�tt
d�t��tddd���	�j�}|jj|�|_
tjj|jj!�gdzd
dg��|_|j#d
�j%�}t'j(|j|j�y)Nr")rDrwrr�rrDr=r�r�lev0�lev1)rbr�)rr#r$r%r7r	rrr�absr(rVr�rc�from_arraysrnr�r�r�r_r�)r2roris   r�2test_resample_nunique_preserves_column_level_namesr��s���	�
�	�	���a� �0�0��8��d�6�l�&�1���q�s�;�
�
�c�e�	�
�x�x����%�B�H����*�*�	���	�	�	���!�&�&�)9�+��B�J��[�[��
�
&�
&�
(�F����"�*�*�f�n�n�5r�funcc�"�|j�Srr�r�s rr}r}�s��!�)�)�+�rc�@�|jtj�Sr)r^r
r�r�s rr}r}�s��!�%�%����'�rc�$�|jd�S)Nr�)r^r�s rr}r}�s��!�%�%�	�"�r)r��series_nunique�nunique_str)�idsc�X�tddd��j|�}tddd��j|�}|j|�}tt	t|��|d��}|j
d	�}|j�}||�}tj||�y)
NrKrLrMr5rNrOrArBr�)
rrVr]r
r�r&r�rr_r`)	r�r2r(rC�index3r*rprir�s	         r�#test_resample_nunique_with_date_gapr��s���
�z�;�S�9�A�A�$�G�E�
��[�s�
;�
C�
C�D�
I�F�
�\�\�&�
!�F��u�S��[�!��w�?�A�	�
�
�4��A�
�W�W�Y�F��A�w�H����6�8�,r�nr�i���k)rlri�c��tjjd�}td|dzd��j	|�}t|j
d||z|�jd�|j||���}|jd	�j�}t|jj�|jj�d	�
�j	|�}|j}tj|j|jd��}	tj ||	f�}
||
|	|
}	}tj"d
|dd|ddk7f}|tj"d
|	dd|	ddk7fz}tj$|	|dz
t'|���jdd��}t||��}
t)j*||
�y)Nr"z
2015-08-27rlrIr�rrAr'rPr,rO��sideTr@rT��	minlengthF��copy)r#r$r%rrVr
r�r�choicer�r�r(rIrJr��searchsorted�lexsort�r_�bincountr&r_r`)r�r�r2�prng�drr�r~�ix�vals�bins�sorter�maskrfrOs              r�test_resample_group_infor��s����9�9� � ��#�D�	�,��R��e�	D�	L�	L�T�	R�B�	��
�
�a��a���+�2�2�7�;�4�;�;�r�ST�CU�	V�B�
�;�;�w��'�'�)�D�	�"�(�(�,�,�.�b�h�h�l�l�n�7�	K�	S�	S��
�B��9�9�D�
�?�?�2�9�9�b�h�h�W�=�D�
�Z�Z��t��
%�F��f��t�F�|�$�D�
�5�5��t�A�B�x�4���9�,�,�-�D��B�E�E�$��Q�R��D��"�I�-�-�.�.�D�
�+�+�d�4�j�1�n��B��
8�
?�
?��e�
?�
T�C��3�b�!�E����4��'rc��d}td|d��j|�}ttjjd�j
|�tjjd�j||���}|jd�j�}t|jj�|jj�d��j|�}tj|j|jjd	�
�}tj|t!|�dz��ddj#d
d��}t||��}t%j&||�y)Nr�z
2015-09-19rIr�r"r'r�r,rOr�r@r�rAFr�)rrVr
r#r$r%r7r�r��sizer(rIrJr�r�r�r&rr_r`)	r2r�r�r�r~r�r�rrOs	         r�test_resample_sizer�s��
�A�	�L�!�%�	8�	@�	@��	F�B�	�
�	�	���a� �0�0��3��i�i�#�#�A�&�-�-�b�!�4�
�B�
�;�;�v��#�#�%�D�	�$�*�*�.�.�*�������V�	L�	T�	T��
�B��?�?�2�9�9�b�h�h�o�o�G�D�D�
�+�+�d�c�"�g��k�
2�1�2�
6�
=�
=�g�E�
=�
R�C��3�b�!�E����4��'rc�`�tddgdg��}ttj|jd��j
j
d�j
jd��}td	d
gdg��}ttj|jd��j
j
d�j
jd�d��}td
d
g|��}|jd��j�}td
d
g|��}tj||�y)Nid=XitKXr�rr*�r2�UTCz
Europe/Madridi8XiFXrMr5rDr'�r:)rrr�r�r��dtr��
tz_convertr�rFr_r�)�df1�dti1�df2�dti2rorir�s       r�test_resample_across_dstr�'s����Z��,�t�f�
=�C��
���s�v�v�C�(�	��K�K���	��J�J��'��D��Z��,�t�f�
=�C��
���s�v�v�C�(�	��K�K���	��J�J��'�
�	�D�
�A�q�6��	&�B�
�[�[�c�[�
"�
&�
&�
(�F��!�Q��t�,�H����&�(�+rc��tddgd��jd�j|�}tddg|��}|j	td	�
��j
�}tddd
d��j|�}t|�}tdgtjgdzzdgz|��}tj||�y)Nl@j�$l�S*~�Q$r�rYr�r@r"r'�1dr5z
2016-11-02z
2016-11-24r�r�rr�r�)rr�rVrrXrr�rr#r�r_r�)r2r(rori�expected_index_valuesr�s      r�!test_groupby_with_dst_time_changer�Gs���	�*�,?�@�U�K�	��%�	&�	����
�
�A�q�6��	'�B�
�Z�Z��T�*�
+�
0�
0�
2�F�&��l��1B��
�g�d�m��
�/�0�E��#��2�6�6�(�R�-�0�C�5�8��F�H����&�(�+rc
�l�ttdddd�gd��j|�}tdg|��}t|jj�d	�
�j|�}tdg|��}t
j|jd	��j�|�|jd��j�t
j|jd��j�tdgttddd
�gdd��j|����y)Nr[rurw�z
US/EasternrYrDr'r=r5r�r9r@�rAr6)
rrrVrr(�	normalizer_r�r�rF)r2raror�s    r�test_resample_dst_anchorr�Zs���
��$��A�r�2�3��
E�
M�
M�d�
S�C�	�A�3�c�	"�B�
����*�*�,�3�
7�
?�
?��
E�C��!��C�(�H����"�+�+�3�+�/�3�3�5�x�@��K�K�T�K���� ����
������"�"�$��
�C���$��A�&�'�L�t���g�d�m�		
�rc	��tdddd��j|�}t|j�}t	|||d�|d��}d	d
dd�}|jd�}|j
|�gd�}t	gd
�gd�gd�d�tdddd��j|���}tj||d�|jd�}|j
|�gd�}	t	gd�gd�gd�d�tdddd��j|���}
tj|	|
d�|jd�}|j
|�gd�}t	gd�gd�gd�d�tdddd��j|���}
tj||
d �|jd!�}|j
|�gd�}t	d"d#gd$d%gd#d&gd�tddd!d��j|���}tj||d'�|d(d)}|jd*�}|j
d	d
dd��gd�}t	gd+�gd,�gd-�d�td(d)d*d��j|���}tj||d.�y)/Nz
2013-09-30r��30Minr�r�r�rArBrIrJrr�)r�0i���i �r)�/i��i�q�2)r��Pr�r�iR�z	9/30/2013z	11/4/2013r'zW-MON Frequencyz2W-MON)rr�r�r�)r�r�r�r�)r�i�i�r�z
11/11/2013z2W-MON Frequencyr9)rr��)r��r�)r�i��1z9/1/2013z	11/1/2013zMS Frequency�2MSrr�r�r�r�z
2MS Frequencyz
10/26/2013z
10/29/2013r=)i�iiBr�)iiAr�i�)r�rr�r�zD Frequency)	rrVr�r�rr�r^r_r�)r2rar�ror,r�rir��rs2r�	expected2�rs3�result3�	expected3�rs4�result4�	expected4�df_daily�rs_d�result_d�
expected_ds                     r�test_resample_dst_anchor2r�ns���
��l��^��
�g�d�m���3�8�8�_�F�	��f�6�:�#�W�	U�B��E��
0�C�	���W�	�B�
�V�V�C�[��
)�F��.�1�.�	
�
���7�~�
�
�'�$�-�	�H��������
�+�+�h�
�C��g�g�c�l�?�+�G��#�&�$�	
�
���H��
�
�'�$�-�	�I��������
�+�+�d�
�C��g�g�c�l�?�+�G���"2��H���[�t��O�W�W��
��I��������
�+�+�e�
�C��g�g�c�l�?�+�G���$�i�t�T�l�$���<����%�N�
�
�'�$�-�	�I���������,�|�,�H����S�!�D��x�x�e�%�g�>�?��P�H��)�)�!�	
�
��,�S�^�
�
�'�$�-�	�J�������rc��tjd�}tddd�}t|j	|�dd��j|�}t
d|�	�jd
�j�}t
dtjgdzdgzt|j	|�d
d
��j|��	�}tj||�y)Nz
Europe/Berlinr�rl�rwr�r�rDr'rM�@r�r�)
�pytz�timezonerr�localizerVr
r�rGr#r�r_r`)r2rAr�rrir�s      r�test_downsample_across_dstr��s���	
����	'�B�	�$��B�	�B��r�{�{�2����=�E�E�d�K�E�
�A�U�
#�
,�
,�S�
1�
6�
6�
8�F��	�b�f�f�
���S�E�!�����R��!�#�>�F�F�t�L��H����6�8�,rc��ttgd�d��j|�gd���}|jd�j	�}tddgtd	d
gdd��j|��
�}tj||�y)N)z
2017-03-25�
2017-03-26z
2017-03-27z
2017-03-28z
2017-03-29�Europe/AmsterdamrY)rur�r��r)r(r��1Wr��*r�z
2017-04-02rr�r')rrrVr�rFr_r�)r2rorir�s    r�!test_downsample_across_dst_weeklyr�s���	��R�!�
��'�$�-�
!�
�B��[�[��
�
"�
"�
$�F��	�R���
�<�(�-?�c�
�
�'�$�-�	�H����&�(�+rc�N�tdddd��j|�}t|tj��}|jd�j
�}ttddd	d�
�j|�tj��}tj||�y)Nz
2013-04-01z
2013-05-01z
Europe/LondonrMr�rBrz
2013-04-07rD)r6ryrA)	rrVr
r#rmr�rGr_r`)r2rgr*rir�s     r�#test_downsample_across_dst_weekly_2r�s���
�\�<�O�#�
N�
V�
V���C�	�S��
�
�+�A�
�Z�Z��_�
!�
!�
#�F����C���O�W�W��
��j�j�	�H����6�8�,rc��tdddd�}tdddd�}t||d��j|�}|jd�j	d	�}tt
t|���}t||�
�}|jtd���j�}tdd�
�jd	d��}t|d��j|�}tgd�|�
�}tj||�y)Ni�rur�r�rDr�r5r�zAmerica/Havanar'r8z
2018-11-03�ryT)r�r=)g@g<@g@F@)rrrVr�r�rr�r&rrXrrGrr_r�)	r2r8r9r(r��	dataframerirar�s	         r�test_downsample_dst_at_midnightr�s����T�2�q�"�%�E�
�4��Q��
#�C��u�c��-�5�5�d�;�E����e�$�/�/�0@�A�E���c�%�j�!�"�D��$�e�,�I�
�
�
�w�D�1�
2�
7�
7�
9�F�
�\�1�
-�
9�
9��D�:��C���#�
&�
.�
.�t�
4�C��*�#�6�H����&�(�+rc�.�ttjdtjddg�j|�}t	gd�|��}tgd��j|�}t	gd�|��}tj|jd�j�|�tddg�j|�}t	d	d
g|��}tj|jd�j�|�tdg�j|�}t	dg|��}tj|jd
�j�|�tj|jd�j�|�y)N�1970-01-01 00:00:00�1970-01-01 00:00:01�1970-01-01 00:00:02)r"r�rDr�rur')rr	r
)r��@�&@�1sr�r�2sr�3s�60s)	rr��NaTrVrr_r�r�rG)	r2r(�frame�index_1s�frame_1s�index_2s�frame_2s�index_3s�frame_3ss	         r�test_resample_with_natrsM����F�F�!��F�F�!�!�	
�
��g�d�m�
�
�&�e�4�E��M��
�g�d�m�
��)��:�H����%�.�.��.�3�3�5�x�@��3�5J�K�L�T�T���H��#�t��H�5�H����%�.�.��.�3�3�5�x�@��3�4�5�=�=�d�C�H��#��h�/�H����%�.�.��.�3�3�5�x�@����%�.�.��/�4�4�6��Arc	��tddd�tddd�g}td|i|��}|jj|�|_t	tddd�t
jtddd�gtddd	�
�j|�d��}|jd	�j�d}tj||�|djd	�j�}tj||�y)Ni�r@rr�rr'z
2016-01-15r��2Dr�)r(rz)rrr(rVr
r�rrr��firstr_r`)r2rrorfres     r�test_resample_datetime_valuesr,s���
�d�A�r�
"�H�T�1�b�$9�:�E�	�K��'�u�	5�B��x�x����%�B�H�
�	�$��2�	������q�"�(=�>���q�t�<�D�D�T�J�
��C�
�+�+�d�
�
!�
!�
#�K�
0�C����3��$�
�[�/�
"�
"�4�
(�
.�
.�
0�C����3��$rc���d�}|jj|�|_d}|jd�j||�}|jd�j	�j|�}t
j||�|jd�j||��}|jd�j	�j|�}t
j||�y)Nc�2�tj|�|zSr�r#rG�r��add_args  rrez3test_resample_apply_with_additional_args.<locals>.fC����w�w�t�}�w�&�&rrlr=)r")r(rVr�r�rG�multiplyr_r`)r�r2re�
multiplierrir�s      r�(test_resample_apply_with_additional_argsr&As���'��<�<�'�'��-�F�L��J�
�_�_�S�
!�
'�
'��:�
6�F����s�#�(�(�*�3�3�J�?�H����6�8�,��_�_�S�
!�
'�
'��:�
'�
>�F����s�#�(�(�*�3�3�J�?�H����6�8�,rc�8�d�}d}tddd�tdd����}d	}tjt|�
�5|jd�j
d�j||�jt�}ddd�d	}tjt|�
�5|jd�j
d�j�j|�}ddd�tj�y#1swY��xYw#1swY�,xYw)
Nc�2�tj|�|zSrr r!s  rrez4test_resample_apply_with_additional_args2.<locals>.fUr#rrlr@r"r��2017rr'rr�r�r=)
rrr_rrrXr�r^rr"rGr$r�)rer%ror�rir�s      r�)test_resample_apply_with_additional_args2r*Ss���'��J�	���#�:�f�b�+I�	J�B�
F�C�	�	#�	#�$6�c�	B�P����C��)�)�#�.�2�2�1�j�A�H�H��O��P�
F�C�	�	#�	#�$6�c�	B�M��:�:�c�?�+�+�C�0�5�5�7�@�@��L��M����&�(�+�P�P��M�M�s�AD�'>D�D
�D)r@r"r�zn1, freq1, n2, freq2)
)�r*��?r)�<r*r@r)ir*r@rM)r-rr@rM)i`Tr*g�?r=)r�r*r@r=)i��r*r,r=)i�rr@r=)r�rMr,r=)�rMr@r=c�h�||z}||z}tdd|��j|�}ttt	|��|��}	|	jt
|�|z�j�}
|	jt
|�|z�j�}tj|
|�y)Nz
1991-09-05z
1991-09-12r5r')
rrVr
r�r&r�r�rGr_r`)�n1�freq1�n2�freq2r�r2�n1_�n2_ra�serr
rs            r� test_resample_equivalent_offsetsr7ds���$
�q�&�C�
�q�&�C�
�\�<�e�
<�
D�
D�T�
J�C�
��s�3�x���
,�C��l�l�3�s�8�e�+�,�1�1�3�G��l�l�3�s�8�e�+�,�1�1�3�G����7�G�,rz"first,last,freq,exp_first,exp_last))�19910905�19920406r=r8�19920407)z19910905 00:00�19920406 06:00r=r8r:)�19910905 06:00r;rMr<z19920406 07:00)�19910906r9r��19910831�19920430)r>r?r�r>�19920531)z1991-08z1992-04r�r>r@c��t|�}|j|j�j|�}t|�}|j|j�j|�}t	|�}t	|�}t
jjj|�}t|||d��}||f}||k(sJ�y)Nr-r�)
rr�r6rVrr�r �frequencies�	to_offsetr)rr�r6�	exp_first�exp_lastr2rir�s        r�test_get_timestamp_range_edgesrF�s���
�5�M�E����u�z�z�*�2�2�4�8�E��$�<�D����T�Y�Y�'�/�/��5�D��)�$�I���"�H�
�:�:�!�!�+�+�D�1�D�
'��t�T��
E�F��8�$�H��X���r�
duplicatesTFc	�T�tddd��j|�}ttd�|��}t	||dzd��}|r	ddg|_d	}t
jt|�
�5|jd�jtj�}ddd�t	tjdd
gddgddgddggtj��tgd�d��j|�|j
��}t
j |�y#1swY��xYw)Nz
2012-01-31r�r��r8r6ryr'r"r�r�z!using DatetimeIndexResampler.prodr�rnrr.r-��r�r�i�i�r�)z
2012-03-31z
2012-06-30z
2012-09-30z
2012-12-31�QE-DECr5r�)rrVr
r�rrnr_rrr�r�r#rHrWrArr�)rGr2r(r�ror�rir�s        r�test_resample_apply_productrL�s���
�\��b�A�I�I�$�O�E�	��b�	��	'�B�	��"�q�&�)�	*�B���3�Z��
�
-�C�	�	#�	#�M��	=�2����T�"�(�(����1��2��
���1�b�'�B��9�s�C�j�3��+�>�b�h�h�O��D�8�
�
�'�$�-��
�
��H����&�(�+�2�2�s�-/D�D'z$first,last,freq_in,freq_out,exp_last))�
2020-03-28�
2020-03-31r=r�z2020-03-30 01:00)rM�
2020-10-27r=r��2020-10-27 00:00)�
2020-10-25rOr=r�z2020-10-26 23:00)rMrNr�r=z2020-03-30 00:00)rMrOr�r=rP)rQrOr�r=z2020-10-26 00:00rr��freq_in�freq_outrEc	��tdt|||d��j|��}|j|�j	�}tdt|||d��j|��}tj||�y)Nrr�r�)r
rrVr�r"r_r`)	rr�rRrSrEr2r�rir�s	         r�#test_resample_calendar_day_with_dstrU�s��N
��Z��t�'�6H�
I�
Q�
Q�RV�
W�
�B��[�[��
"�
(�
(�
*�F����5�(��6H�I�Q�Q�RV�W��H����6�8�,r)rIrJrr�c�r�tddd��j|�}tdtjtjg|�}t|j
d�|�d��}ttjgtd	gd
��j|���}tj||�y)
N�2020r�r�rIr@rnr")�	min_countrNrKr5r')
rrVr
r#r�r�r�rr_r`)r�r2r(r6rir�s      r�+test_resample_aggregate_functions_min_countrY�s���
�V�$��:�B�B�4�H�E�
�!�R�V�V�R�V�V�$�e�
,�C�
.�W�S�\�\�$�'��
.��
;�F��	�����\�N��:�B�B�4�H��H����6�8�,rc	��ttddd��j|�dggd�dz|��}|j|jd	k|jd
kDzdd�f}|jd�j
�}tdtjd
gdgtddd��j|���}tj||�y)Nrz
2000-01-03 23r�r,r�)rr@rr")r(rnr�rCz
2000-01-02z
2000-01-03r=r@rr)rrrVrRr(r�rJr#r�r_r�)�any_unsigned_int_numpy_dtyper2rorir�s     r�test_resample_unsigned_intr\�s���	��|��u�M�U�U��
���
��]�*�

�B�
������L�(�R�X�X��-D�E�q�H�	I�B�
�[�[��
�
!�
!�
#�F��	
�B�F�F�A�����|��s�K�S�S��
��H����&�(�+rc�*�tdddd��}tgd�|��}|jd�j�}t	tjgd	��jd
�d��}tgd
�|��}tj||�y)Nz
0300-01-01rr*�100YE)r2r6)r@rwr"r�rDr�r@rwr"r�rDr�r@rwr"r�rDr'�200YE)	z
0300-12-31z
0500-12-31z
0700-12-31z
0900-12-31z
1100-12-31z
1300-12-31z
1500-12-31z
1700-12-31z
1900-12-31z
datetime64[s]z	200YE-DECr5)	rr��@rtr�r`rtr�r`)
rr
r�rGrr#rWrr_r`)rgr6ri�expected_idxr�s     r�test_long_rule_non_nanorbs��
�\�<�c��
H�C�
�D�C�
P�C�
�\�\�'�
"�
'�
'�
)�F� �
���

�	
��&��
!�
��L� �C�<�X�H����6�8�,rc��tggd��jddi�}|jddddd��dj�}t	gddd�	�}tg|dd
��}t
j||�y)N)r�r�r�zdatetime64[ns, Atlantic/Faroe]r�r~r8)�onrQrRr�r�)r6rzrCrm)r(rzrC)rrr�rFrr
r_r`)rorirar�s    r�"test_resample_empty_series_with_tzre!s���	�"��+�	,�	3�	3�	
�/�0�
�B��[�[��4��f�W�[�
U���	�c�e��!�
��T�)I��L��b��8�9�M�H����6�8�,rzfreq, freq_depr))�2ME�2M)�2QE�2Q)z2QE-SEPz2Q-SEP)�1YE�1Y)�2YE-MARz2Y-MAR)rj�1A)rlz2A-MARc�t�d|dd�d�}d|dd�d�ttd�tddd�	��
�}|j|�j	�}tjt|��5|j|�j	�}ddd�tj|�y#1swY� xYw�N�'r@z$' is deprecated and will be removed z!in a future version, please use 'r�rl�20130101r�r�r'r��	r
r�rr�rGr_rrr`�r6�	freq_depr�depr_msgr*r�ris      r� test_resample_M_Q_Y_A_deprecatedrv1s����9�Q�R�=�/�!E�F�H�'��Q�R��z��<��u�R�y�
�:�C�� L�M�A��z�z�$��$�$�&�H�	�	#�	#�M��	B�.����I�&�+�+�-��.����6�8�,�.�.���/ B.�.B7))�2BME�2BM)�2BQE�2BQ)z2BQE-MARz2BQ-MARc�t�d|dd�d�}d|dd�d�ttd�tddd�	��
�}|j|�j	�}tjt|��5|j|�j	�}ddd�tj|�y#1swY� xYwrorrrss      r�test_resample_BM_BQ_deprecatedr}Is����9�Q�R�=�/�!E�F�H�'��Q�R��z��<��u�R�y�
�:�C�� L�M�A��z�z�$��$�$�&�H�	�	#�	#�M��	B�.����I�&�+�+�-��.����6�8�,�.�.�rwc��tddd|��}td|i|��}|jdd�	�}|j�}t	td
dd�td
dd�gd�
�j
|�}tdtd
dd�td
dddd�gi|��jd|�d��}tj||�y)N�
2020-01-31�1min�p�r8r6ryr2r�r'r9rOr.��r@r"r5rwr��;�M8[�]�
rrr�r�rrrVrr_r�)r2raro�groupedri�exp_dtir�s       r�test_resample_ms_closed_rightr�]s���
�<�f�d��
N�C�	�D�#�;�c�	*�B��k�k�$�w�k�/�G�
�\�\�^�F��	�$��1�	�x��a��3�4�4��
�g�d�m���	
���q�!�$�h�t�Q��1�b�&A�B�C���
�f�s�4�&��]��
����&�(�+rr�r�c
���tddd|��}td|i|��}|j|d��}|j�}t	td	d
d�td	d
d�td	d
d�td	d
d�g|��j
|�}tdtd	d
d�td	d
d�td	d
d�td	d
ddd�gi|��jd|�d��}tj||�y)Nrr�r�r�r�r'rOr.r�r@r+r�r"r�rwr5r�r�r�r�)r6r2raror�rir�r�s        r�test_resample_c_b_closed_rightr�ms���<�f�d��
N�C�	�D�#�;�c�	*�B��k�k�$�w�k�/�G�
�\�\�^�F���T�1�b�!��T�1�b�!��T�1�a� ��T�1�a� �		
����g�d�m������q�"�%���q�!�$���q�!�$���q�!�Q��+�	�	
��
�
�f�s�4�&��]��
����&�(�+rc
�f�tddd|��}tgd�|��}|jddd�	�j�}t	td
dd�td
dd
�td
dd�td
dd�gd��j
|�}tgd�|��}tj||�y)Nz
2023-09-26rtr�)ryr6r2)r@r"r�rwrDrtr'r�rOr�i�r�r����r5)rg@g@g@)	rr
r�rGrrrVr_r`)r2rar6rir�r�s      r�test_resample_b_55282r��s���
�\�1�5�t�
D�C�
�#�3�
/�C�
�\�\�#�g�W�\�
=�
B�
B�
D�F���T�1�b�!��T�1�b�!��T�1�b�!��T�1�b�!�		
����g�d�m������H����6�8�,r�pyarrowrAr�z/TODO: Set ARROW_TIMEZONE_DATABASE env var in CI)�	conditionrXc�8�ttdd��d��}|�|jj|�}tt	j
dtj��|��}|jd�j�}tj||�y)Nz
2020-01-01rDrztimestamp[ns][pyarrow]r�r'r8)r
rr�r�r#r�rmr�rGr_r`)rArgr�ris    r�test_arrow_timestamp_resampler��su�� ��L�!�4�<T�
U�C�	�~��f�f� � ��$���b�i�i�����4�C�@�H�
�
�
�t�
$�
)�
)�
+�F����6�8�,r)�r�	functoolsr�numpyr#r�r��pandas._libsr�pandas._typingr�
pandas.compatr�pandas.util._test_decorators�util�_test_decorators�td�pandasr�rr	r
rrr
r�pandas._testing�_testingr_�pandas.core.groupby.grouperr�pandas.core.indexes.datetimesr�pandas.core.indexes.periodrr�pandas.core.resamplerr�pandas.tseriesr�pandas.tseries.offsetsr�fixturerr r)r2r>rjrq�mark�parametrizer�r�r��filterwarningsr�r�r�r�r�rrrrr r#r'r/r7rDrIrTrWrgrtr{r�r�r�r�r�r�r�r�r�r�rr�r�r�r�r�r�r�r�r�r
rrrrr&r1r6r8r<rDrGrIrKrPrVr0�xfailr_rnrrr�r�r�__annotations__rr��dates3r�r�r�r�r�r�r�r�r�r�r�r�rrrrrr&r*r7rFrLr�rUrYr\rbrervr}r�r�r��
skip_if_nor�rrr�<module>r�s�	�����
���*�-�)�)������/�4���
#�)������������������7��7�����.�/��0�����	%��	%�!+�H	 ������)�8�9��������
�
�	
�
�
�	
���*-�+�	�2-�-�0-������F�������)�8�9��������L��6�	�	��6������)�8�9��-�	�-�,�����)�8�9��,�	�,�41�2=,�@7(�t.�<������J�K�:�L�:�������$���.�G�/�G�������'�4��1�	0�2�	0�(�"?�:,�-�������!=�>�������!L�M�	-�N�?�	-�$�0
$�,�$*$�`,�(	0�������	�V�F�G�D�E�	�V�F�G�D�E�	
��9�c�B�C���-��-�<�(
8��,�������!O�P�-�Q�-��������A��'�T�(�T�-�
4�������	�(�)�	�9�2�3�4��d�+�	�(�)�	�5��
�
�
4�
�
4���������
�H�l�F�H�U��	+��	+�������O�Y��f�h�#W�X�+�Y�+�"4�JG�BS�84-�n-�
3�
-� ,�.(�*
-� 0��
(� '�6,�8�������!L�M��N���������s��g�u�5E�'F�G�F�H�F�$2�:��)�(����������������+�+�#�#�F�$��	
�	
�
�'�
�'�(F�6	�&�0
�T�2�q���T�1�a���T�2�q���T�1�a���T�2�q���T�1�b��
!���_����2�A�J�"�&�&���F�1�Q�K�'�2�6�6�(�2�V�A�B�Z�?���_���
�&�&��F�	�b�f�f�X�	%��������6�6�6�":�;�,�<�,�&������6�6�6�":�;�,�<�,�0-�>6������
��'�"��
	5���
-��
-�������u�f�o�.�������o�.�(�/�/�(�:(�(,�@,�&�(Y�x
-�,�&
-� ,�$B�@%�*-�$,�"������i�(���������	-��)� 	-������(��
��
���������e�}�5�,�6�,�,�����*��"�F-��-��-�$'�-�36�-�BE�-�G"�F-�������!@�A�	-�B�	-�,�0-�2
-� ��������	-��	-���������	-��	-�
,� ������#�s��,�,��,�-�,�<-�,����y���������������+�+�#�#�-�/�H�$��	
�	��-���-r

Youez - 2016 - github.com/yon3zu
LinuXploit