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 :  C:/Python312/Lib/site-packages/pandas/tests/frame/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : C:/Python312/Lib/site-packages/pandas/tests/frame/__pycache__/test_reductions.cpython-312.pyc
�

/	�gP-���ddlmZddlmZddlZddlmZddlZddl	Z	ddl
mZddlm
Z
mZddlmZddlmcmZddlZddlmZmZmZmZmZmZmZmZmZm Z m!Z!m"Z"m#Z#m$Z$ddl%m&Z'dd	l(m)Z)m*Z*e�xrexse
Z+e�xse
Z,d2d
�Z-						d3d
�Z.e	j^d��Z0e	j^d��Z1Gd�d�Z2Gd�d�Z3Gd�d�Z4Gd�d�Z5d�Z6e	jnjqe�d��d��Z9e	jnjudgd��e	jnjuddd g�d!���Z;e	jnjud"ed#�ejxg�d$��Z=d%�Z>e	jnjudgd&��e	jnjudddg�e	jnjud'd(d)g�d*����Z?e	jnjud+gd,��d-��Z@e	jnjudgd.��e	jnjud/dd0g�d1���ZAy)4�)�	timedelta)�DecimalN)�tzlocal)�using_pyarrow_string_dtype)�IS64�is_platform_windows)�np_version_gt2)�Categorical�CategoricalDtype�	DataFrame�
DatetimeIndex�Index�PeriodIndex�
RangeIndex�Series�	Timestamp�
date_range�isna�notna�to_datetime�to_timedelta)�
algorithms�nanopsc�&����r�fd�}|S�fd�}|S)a`
    Create a function for calling on an array.

    Parameters
    ----------
    alternative : function
        The function to be called on the array with no NaNs.
        Only used when 'skipna_alternative' is None.
    skipna_alternative : function
        The function to be called on the original array

    Returns
    -------
    function
    c�(���|j�S�N��values)�x�skipna_alternatives ��DC:\Python312\Lib\site-packages\pandas/tests/frame/test_reductions.py�skipna_wrapperz+make_skipna_wrapper.<locals>.skipna_wrapper?s���%�a�h�h�/�/�c�p��|j�}t|�dk(rtjS�|�S)Nr)�dropna�len�np�nan�r�nona�alternatives  �r!r"z+make_skipna_wrapper.<locals>.skipna_wrapperDs-����8�8�:�D��4�y�A�~��v�v�
��t�$�$r#�)r+r r"s`` r!�make_skipna_wrapperr--s"��� �	0���
	%��r#TFc	���t||�}	|r�tdtdd��i�}
tjd�5t|
|��}ddd�tt�sJ�tt|
��|
d<tjd�5t|
|��}ddd�t|t�sJ�t|�sJ�|ry�fd�}t�|�}
|	dd	�
�}|	dd	�
�}tj||j|�|||��tj||j|d�
�||��n�}
|	d�
�}|	d�
�}tj||j|
�|||��|dvr-|j|
d�
�}tj||d	||��|r8|jj}||jk(sJ�||jk(sJ�tjt d��5|	d�
�ddd�|r�|t"j$z}t||�d�
�}t||�d�
�}|dvrz|dk(rdnd}t
||j&|j��}tj||�t
||j&|j��}tj||�yyy#1swY���xYw#1swY��AxYw#1swY��xYw)a�
    Check that operator opname works as advertised on frame

    Parameters
    ----------
    opname : str
        Name of the operator to test on frame
    alternative : function
        Function that opname is tested against; i.e. "frame.opname()" should
        equal "alternative(frame)".
    frame : DataFrame
        The object that the tests are executed on
    has_skipna : bool, default True
        Whether the method "opname" has the kwarg "skip_na"
    check_dtype : bool, default True
        Whether the dtypes of the result of "frame.opname()" and
        "alternative(frame)" should be checked.
    check_dates : bool, default false
        Whether opname should be tested on a Datetime Series
    rtol : float, default 1e-5
        Relative tolerance.
    atol : float, default 1e-8
        Absolute tolerance.
    skipna_alternative : function, default None
        NaN-safe version of alternative
    �bz1/1/2001���periodsN�ac�(���|j�Srr�rr+s �r!�wrapperz$assert_stat_op_calc.<locals>.wrapper������q�x�x�(�(r#rF��axis�skipna�)�check_dtype�rtol�atol�r9)r=r>)�sum�prod�No axis named 2��matchrA��index�dtype)�getattrrr�tm�assert_produces_warning�
isinstancer�ranger&r-�assert_series_equal�applyrrG�pytest�raises�
ValueErrorr'r(rF)�opnamer+�frame�
has_skipnar<�check_datesr=r>r �f�df�resultr6r"�result0�result1�expected�	lcd_dtype�all_na�r0�r1�units `                    r!�assert_stat_op_calcraMs����J	��v��A��
��Z�
�A�>�?�
@��
�
'�
'��
-�	+�(�W�R��(�*�F�	+��&�&�)�)�)���B��.��3��
�
'�
'��
-�	+�(�W�R��(�*�F�	+��&�&�)�)�)��6�{��{��	)�-�[�:L�M����5�)����5�)��
����U�[�[��)�{��TX�	
�	�����K�K��a�K�(���		
�%���Q�i�G��Q�i�G�����
���N�#��
�
���� ��;�;�~�A�;�6��
����X�5�t�$�	
�
��L�L�&�&�	��G�M�M�)�)�)��G�M�M�)�)�)�
���z�):�	;��	�q�	���������
$�W�V�V�
$�!�
,��
$�W�V�V�
$�!�
,���_�$��&�(�1�a�D��d�"�(�(�"�(�(�C�H��"�"�2�x�0��d�"�(�(�"�(�(�C�H��"�"�2�x�0�%�	�s	+�	+��
	+�	+��`��s#�K�K&�
K3�K#�&K0�3K<c
���ttjtjdt��tj
dt��gd��t
td�D�cgc]}d|����	c}t��t
td�t��t��}tj|jd	d
tj|jdd�d
d�f<|Scc}w)z�
    Fixture for DataFrame of booleans with index of unique strings

    Columns are ['A', 'B', 'C', 'D']; some entries are missing
    )���rGrr?��foo_�ABCD)rF�columnsrG��
rc����N)rr'�concatenate�ones�bool�zerosrrL�object�listr(�iloc��irWs  r!�bool_frame_with_narw�s���
�
���
�W�W�W�D�
)�2�8�8�G�4�+H�I�PQ�	
���r��3�A�t�A�3�Z�3�6�B��d�6�l�&�1��

�B��F�F�B�G�G�A�b�M��&�&�B�G�G�B�r�E�2�3�J��
�I��4s�"C c
��ttjjd�j	d�tt
d�D�cgc]}d|����	c}t��ttd�t����}tj|jdd	tj|jd
d�dd
�f<|Scc}w)z�
    Fixture for DataFrame of floats with index of unique strings

    Columns are ['A', 'B', 'C', 'D']; some entries are missing
    r0)rfrdrfrgrerh�rFrirjrkrcrlrmN)rr'�random�default_rng�standard_normalrrLrrrsr(rtrus  r!�float_frame_with_nar}�s���
�
�	�	���a� �0�0��9���r��3�A�t�A�3�Z�3�6�B��d�6�l�&�1�
�B��F�F�B�G�G�A�b�M��&�&�B�G�G�B�r�E�2�3�J��
�I��
4s�B>c� �eZdZejjdddg�ejjdddddd	d
ddd
ddejdejd���ejdejd���g
�d���Z	ejjdddg�ejjdddddd	d
dd
ddejdejd���ejdejd���g�d���Z
d�Zd�Zd�Z
ejjdgd��ejjdegd�gd�gd�d�gd �d!�"�eej d#gej d$gej d%gd&�e�'�g�ejj%d(�d)����Zejjd*gd+��d,��Zejj+e�d-�.�d/��Zd0�Zejjd1d2d3g�d4��Zejjd1d2d3g�d5��Zd6�Zd7�Zejjd8gd9��d:��Zd;�Zejjd<d=d>gd?gd@gdAgedAgdAg�B�e dCgdD�'�e!dEg�dF�fdGd>gd?gej gejDej ge�'�eej gdAg�B�e e#jHgdD�'�e!e#jHg�dF�fd=dHdIej ej gdHdIej ej gdej ej ej gedAej ej ej gdAg�B�e gdJ�dD�'�e!gdK��gdL�dM�fdGdHdIej ej gdHdIej ej gdej ej ej geej dAej ej gdAg�B�e gdN�dD�'�e!gdO��gdL�dM�fg�dP��Z%dQ�Z&dR�Z'dS�Z(dT�Z)ejjdUdVdWe#jHdXgd%e#jHgzg�dY��Z*dZ�Z+ejjd[e,d�e g�e-gej\�'�e-gej^�'�e gd\�]�e0gd^�]�g�d_��Z1ejjd`dadbg�ejjdcgdd��de���Z2df�Z3dg�Z4ejjdhgdi��ejjdjdd#dk�dldmej gfdd$dk�ej ej ej gfddGdn�dldmej gfg�do���Z5ejjdhgdi��ejjdjdd#dk�dpdqej gfdd$dk�ej ej ej gfddGdn�dpdqej gfg�dr���Z6ds�Z7dt�Z8du�Z9dv�Z:dw�Z;dx�Z<dy�Z=dz�Z>d{�Z?ejjd|d=dGg�ejjdddg�d}���Z@ejjdddg�ejj%d~�d���ZAejjdcd=dGg�d���ZBd��ZCejjd|d=dGg�ejjdddg�d����ZDejjdddg�ejj%d~�d����ZEejjdcd=dGg�d���ZFd��ZGd��ZHd��ZIejjd�d�dd%gfd�dd�gfg�d���ZJd��ZKejjdd�d�g�ejjdddg�ejjd�dGd=g�d�����ZLejjdd�d�g�ejjdddg�d����ZMejj%d��ejjdd�d�g�d����ZNd��ZOejjdddg�ejjd�d�d�g�ejjd|d=dGg�d�����ZPejj%d��d���ZQd��ZRejjd�gej�idGf�ej�id=f�ej�d�gidGf�ej�d�gid=f�ej�d�dGdGgidGf�ej�d�dGdGgidGf�ej�d�d=dGgid=f�ej�d�d=dGgidGf�ej�d�d=d=gid=f�ej�d�d=d=gid=f�ej�dGgdGgd��dGf�ej�dGgdGgd��dGf�ej�dGdGgdGd=gd��d=f�ej�dGdGgdGd=gd��dGf�ej�d�eUd�d@gd��'�idGf�ej�d�eUd�d@gd��'�id=f�ej�d�eUddgeV�'�idGf�ej�d�eUddgeV�'�id=f�ejej�d�eUddgdD�'�idG��ejej�d�eUddgd��'�idG��ejej�d�eUddgdD�'�id=��ejej�d�eUddgd��'�id=��ejej�d�eUdd#gdD�'�id=��ejej�d�eUdd#gd��'�id=��ejej�d�eUdd#gdD�'�id=��ejej�d�eUdd#gd��'�id=��ejej�d�eUddgd��'�idG��ejej�d�eUddgd��'�id=��ejej�d�eUdd#gd��'�id=��ejej�d�eUdd#gd��'�id=��ej�d�eUddgd��'�id=f�ej�d�eUddgd��'�idGf�ej�d�eUdd#gd��'�id=f�ej�d�eUdd#gd��'�idGf�ejej�eUd�d�gdD�'�eUd�d�gd��'�d��d=���d���ZWd��ZXd��ZYd��ZZy2)��TestDataFrameAnalyticsr9rr;rR�countr@�mean�product�median�min�max�nunique�var�std�sem�skew�scipy)�marks�kurtc�.�|dvr|dk(s|dvr|r|dk(st||�|��n�|dvrd}nj|dk(r|d	k(rd
}n]d}nZ|dk(rd}nR|d
k(r|dk(rdjddg�}n4d}n1|dvrd}n*|dk(r%tjdtj��}ttj�s|dz}tjt|��5t||�|��ddd�|dk7rt||�|d��yy#1swY�$xYw)N)r@r�r�r�r�r�r@r?)r�r�r�r�r�z(could not convert string to float: 'bar'r�r;z2can't multiply sequence by non-int of type 'float'z0can't multiply sequence by non-int of type 'str'z7unsupported operand type\(s\) for \+: 'float' and 'str'r��|z%Could not convert \['.*'\] to numericz/Could not convert string '(bar){30}' to numeric�r�r�z<'[><]=' not supported between instances of 'float' and 'str'r�z1Cannot convert \[.*\] to numeric|does not support)�flagsz|does not supportrCr�T�r9�numeric_only)
rH�join�re�compile�SrK�PatternrOrP�	TypeError)�self�float_string_framer9rR�using_infer_string�msgs      r!�#test_stat_op_api_float_string_framez:TestDataFrameAnalytics.test_stat_op_api_float_string_frame�s@��.�,�
,�������
&�&�E�/�/�G�&��/�T�:��>�>�@���9�$��1�9�N�C�L�C��5��P���6�!��1�9��(�(�D�M���C�U�C��>�)�T���8�#��j�j�H�PR�PT�PT����c�2�:�:�.��/�/�����y��4�
?�3��*�F�3��>�
?��Y��/�G�&��/�T��M��
?�
?�s�D�Dc�,�t||�|d��y)NFr��rH)r��float_framer9rRs    r!�test_stat_op_api_float_framez3TestDataFrameAnalytics.test_stat_op_api_float_frame&s��&	%���V�$�$�U�Cr#c���d�}d�}d�}d�}d�}td||ddd�	�td
tj|jd�dd�
�td
tj|tj��tdtj
|d��tdtj|tj��td||�td||�td||�td||ddd�	�y)Nc�4�t|�j�Sr)rr@��ss r!r�z7TestDataFrameAnalytics.test_stat_op_calc.<locals>.count<s����8�<�<�>�!r#c�Z�ttj|j���Sr)r&r�unique1dr%r�s r!r�z9TestDataFrameAnalytics.test_stat_op_calc.<locals>.nunique?s���z�*�*�1�8�8�:�6�7�7r#c�0�tj|d��S�Nr;��ddof)r'r��rs r!r�z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.varB����6�6�!�!�$�$r#c�0�tj|d��Sr�)r'r�r�s r!r�z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.stdEr�r#c�n�tj|d��tjt|��zSr�)r'r��sqrtr&r�s r!r�z5TestDataFrameAnalytics.test_stat_op_calc.<locals>.semHs$���6�6�!�!�$�r�w�w�s�1�v��6�6r#r�FT)rTr<rUr@�float32g����MbP?)r<r=)r r��rUr�r�r�r�r�)rar'r@�astype�nansumr�rA�nanprod)r�r}�mixed_float_framer�r�r�r�r�s        r!�test_stat_op_calcz(TestDataFrameAnalytics.test_stat_op_calc;s���	"�	8�	%�	%�	7�	�������
	
�	���F�F��$�$�Y�/���	
�	��2�6�6�.�2�9�9�	
�	�F�B�G�G�-@�d�S���r�w�w� 3��
�
�	
�	�E�3�(;�<��E�3�(;�<��E�3�(;�<��������
	
r#c�x��tjd���fd�}�fd�}td||�td||�y)N�scipy.statsc�f��t|�dkrtjS�j|d��S)N�F��bias)r&r'r(r��r�sp_statss �r!�skewnesszHTestDataFrameAnalytics.test_stat_op_calc_skew_kurtosis.<locals>.skewnessvs*����1�v��z��v�v�
��=�=���=�/�/r#c�f��t|�dkrtjS�j|d��S)NrdFr�)r&r'r(�kurtosisr�s �r!r�zDTestDataFrameAnalytics.test_stat_op_calc_skew_kurtosis.<locals>.kurt{s-����1�v��z��v�v�
��$�$�Q�U�$�3�3r#r�r�)rO�importorskipra)r�r}r�r�r�s    @r!�test_stat_op_calc_skew_kurtosisz6TestDataFrameAnalytics.test_stat_op_calc_skew_kurtosisss9����&�&�}�5��	0�
	4�
	�F�H�.A�B��F�D�*=�>r#c�H�d�}td||d��td||dd��y)Nc�~�t|�j�rtjStj|�Sr)r�anyr'r(r�r�s r!r6z3TestDataFrameAnalytics.test_median.<locals>.wrapper�s&���A�w�{�{�}��v�v�
��9�9�Q�<�r#r�Tr�F)r<rU)ra)r�r}�	int_framer6s    r!�test_medianz"TestDataFrameAnalytics.test_median�s,��	 �
	�H�g�/B�PT�U���g�y�e��	
r#�method)r@r�rAr�r�r�r�r�rW)gȃw@Ba@�gC�V�Z�g
?Z��.F?)rr�)g�94��c4?g�@�}�jX?g���N��r3r/�c��foo�bar�baz�OrEr0r�rd�rr;r0rez0ignore:Mismatched null-like values:FutureWarningc�H�|jjtjk(sJ�t	||�|��}t	|jd�|�|��jt�}|dvr|dvrd||j�<tj||�y)Nr?�f8)r;rir�)
rrGr'�object_rHr�rrrrIrM)r�r�rWr9rXr[s      r!�%test_stat_operators_attempt_obj_arrayz<TestDataFrameAnalytics.test_stat_operators_attempt_obj_array�s���:�y�y���"�*�*�,�,�,�$���V�$�$�/��3�7�2�9�9�T�?�F�3��>�E�E�f�M���>�!�f��&>�(,�H�X�]�]�_�%�
���v�x�0r#�op)r�r�r�r�r�r�c���tgd�gd�gd�d��}djgd��}tjt|��5t||��ddd�t
jdd	�5djgd��}tjt|��5t||��ddd�ddd�y#1swY�qxYw#1swY�xYw#1swYyxYw)
N�r;r0r�rd)��?�@�@�@�r3r/r��d)�int�float�strr�)zCould not convert�could not convertz"can't multiply sequence by non-intzdoes not supportrC�use_bottleneckF)rr�rOrPr�rH�pd�option_context)r�r�rWr�s    r!�test_mixed_opsz%TestDataFrameAnalytics.test_mixed_ops�s����#�-�+�
�
���h�h�
�
���]�]�9�C�
0�	��G�B��O��	��
�
�/��
7�
	"��(�(���C����y��4�
"����B��!�
"�
	"�
	"�	�	��
"�
"��
	"�
	"�s0�C�4/C�#C�5C�C�C	�C�C'z"sum doesn't work for arrow strings��reasonc�T�tgd�gd�gd�d��}|jgd���|jd��}tj|j
t
jgd�t�	��|jjd
��}tj||�y)N)TTFFF)rkrlrf�(�2)r3r/r�r��e)�	bool_data�int_data�string_data�rirr?)r0��abcderer;)r�reindexr@rI�assert_numpy_array_equalrr'�arrayrr�TrM)r�rW�test�alts    r!�test_reduce_mixed_framez.TestDataFrameAnalytics.test_reduce_mixed_frame�s���
�>�0�8�
�
��	�
�
�C�
�D��v�v�1�v�~��
�#�#��K�K����"3�6�B�	
��d�d�h�h�A�h���
���t�S�)r#c	���tgd�gd�dtjdgd��}tj|j�t
dddd���tj|jd��t
dddd���tj|jd�	�t
dddd
���tj|jdd��t
dddd
���y)N�r;r;r;�r;r0r�r;r���A�B�Cr0F�r%r?r�)r9r%)rr'r(rIrMr�r�r�rWs  r!�test_nuniquez#TestDataFrameAnalytics.test_nunique�s���
�Y�Y�a�����^�L�
M��
���r�z�z�|�V�!�!�!�4L�-M�N�
����J�J�e�J�$�f�1�1�1�-E�&F�	
�	���r�z�z�q�z�1�6�a�A�!�:L�3M�N�
����J�J�A�e�J�,�f��q�Q�5G�.H�	
r#�tzN�UTCc���tddgtd|��gdzd��}|j�}tdtd|��gddg�	�}t	j
||�y)
Nr;�2000�rr0�rrr�rr�rF�rrr�rrIrM�r�rrWrXr[s     r!� test_mean_mixed_datetime_numericz7TestDataFrameAnalytics.test_mean_mixed_datetime_numeric�s]���a��V�9�V��+C�*D�q�*H�I�
J��������3�	�&�R� 8�9�#�s��L��
���v�x�0r#c��tdtd|��gdzi�}|j�}ttd|��gdg��}t	j
||�y)Nrrrr0rrrs     r!�test_mean_includes_datetimesz3TestDataFrameAnalytics.test_mean_includes_datetimes�sU��
��i��2�6�7�!�;�<�
=��������9�V��3�4�S�E�B��
���v�x�0r#c�8�ddtd�d�ddtd�d�ddtd�d�ddtd�d�d	dtd
�d�ddtd�d�ddtd
�d�d	dtd�d�ddtd�d�ddtd�d�g
}t|�}tjtd��5|j�ddd�|ddgj�}t
ddgddgt��}tj||�y#1swY�KxYw)Nr0z628.00rr;z383.00r�z651.00z575.00rdz1114.00�TESTz241.00z572.00z609.00z820.00rjz1223.00z)unsupported operand type|does not supportrCrrg������@g�����L�@rE)
rrrOrPr�r�rrrrIrM)r�r�rWrXr[s     r!�test_mean_mixed_string_decimalz5TestDataFrameAnalytics.test_mean_mixed_string_decimals��
�$�W�X�%6�7��$�W�X�%6�7��$�W�X�%6�7��$�W�X�%6�7��$�W�Y�%7�8��&�w�x�'8�9��$�W�X�%6�7��$�W�X�%6�7��$�W�X�%6�7��$�W�Y�%7�8�
���q�\��
�]�]��H�
�	�
�G�G�I�	��S�#�J��$�$�&���3��,�s�C�j��G��
���v�x�0�
	�	�s�5D�Dc�z�|jd��}|jd��}tj||�|j	d��}|jd��}tj||�tjt
jjd�jd�dd�}tj|d�	�}|dkj�rJ�tjd
d�5tj|d�	�}|dkj�rJ�	ddd�y#1swYyxYw)Nrdr�c�&�|jd��S�Nrdr�)r�r�s r!�<lambda>z5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>"���!�%�%�Q�%�-�r#c�&�|jd��Sr)r�r�s r!rz5TestDataFrameAnalytics.test_var_std.<locals>.<lambda>&rr#r0�r;��rrr?r�F)r�rNrI�assert_almost_equalr�r'�repeatrzr{r�nanvarr�r�r��r��datetime_framerXr[�arrs     r!�test_var_stdz#TestDataFrameAnalytics.test_var_std s���#�#��#�+��!�'�'�(?�@��
���v�x�0��#�#��#�+��!�'�'�(?�@��
���v�x�0��i�i��	�	�-�-�a�0�7�7�	�B�D�!�L�����s��+���Q�J�#�#�%�%�%�
�
�
�/��
7�	*��]�]�3�Q�/�F���
�'�'�)�)�)�)�	*�	*�	*�s�:-D1�1D:�meth)r�r�r�c��ttjjd�j	d�gd���}|jdti�}d|jd<ttjjd�j	d�gd���}|jdti�}d|jd<t||�d	d
��}t|dd
g|�d	��}tj||�t||�d	d
��}t|dd
g|�d	��}tj||�d}tjt|��5t||�d	d��ddd�d}tjt|��5t||�d	d��ddd�y#1swY�DxYw#1swYyxYw)Nr0)rjr�r�r�r��100)rr�r3r;Tr�r�r�r?z6unsupported operand type\(s\) for -: 'float' and 'str'rCFz&could not convert string to float: 'a')rr'rzr{r|r�rr�locrHrIrMrOrPr�)r�r&�df1�df2rXr[r�s       r!�test_numeric_only_flagz-TestDataFrameAnalytics.test_numeric_only_flag1s�����I�I�!�!�!�$�4�4�V�<�)�
��
�j�j�%���)��!��������I�I�!�!�!�$�4�4�V�<�)�
��
�j�j�%���)��������#���d�#���>��5�7�3��u�~�.��5�1�=��
���x��0�#���d�#���>��5�7�3��u�~�.��5�1�=��
���x��0�H��
�]�]�9�C�
0�	;��G�C���A�E�:�	;�6��
�]�]�9�C�
0�	;��G�C���A�E�:�	;�	;�	;�	;��	;�	;�s�$F<�G�<G�Gc��|jd��}|jd��}tj||�t	j
tjjd�j
d�dd�}tj|d��}|dkj�rJ�tjd	d
�5tj|d��}|dkj�rJ�	ddd�y#1swYyxYw)Nrdr�c�d�|jd��tjt|��zSr)r�r'r�r&r�s r!rz1TestDataFrameAnalytics.test_sem.<locals>.<lambda>Xs!��!�%�%�Q�%�-�"�'�'�#�a�&�/�2Q�r#r0rrrr?r�F)
r�rNrIrr'r rzr{r�nansemr�r�r�r"s     r!�test_semzTestDataFrameAnalytics.test_semVs����#�#��#�+��!�'�'�(Q�R��
���v�x�0��i�i��	�	�-�-�a�0�7�7�	�B�D�!�L�����s��+���Q�J�#�#�%�%�%�
�
�
�/��
7�	*��]�]�3�Q�/�F���
�'�'�)�)�)�)�	*�	*�	*�s�-C7�7Dzdropna, expectedT�g$@r�r3)�
categories�
2000-01-02�M8[ns]�1 days)rrr�D�E�F�GF��	)r3�NaTr<r<�r5r(r(r(�rr;r0r�)�H�I�J�K�L�M�N�r<r3r<r<)r(r5r(r(c�b�tgd�ddtjdgdtjtjtjgttjtjdtjgt��ttjtjdtjg�t
gd�d��tgd	��gd
�gd�ddtjtjgtdtjdtjg�t
gd�d��tgd
��tjdd��d��}|t|j��j|��}t|�}tj||�y)N)r1r1��rkr�r;r3rerFr4r=)r:r:r;r;)r;r;r:r:)r3r3r<r<)r5r(r5r(rd�int64)rrrr6r7r8r9r?r@rArBrCrDrEr)rr'r(rrrr
r
r�arange�sorted�keys�moderI�assert_frame_equal)r�r%r[rWrXs     r!�test_mode_dropnaz'TestDataFrameAnalytics.test_mode_dropnacs'��t�%��"�b�f�f�a�(�����������0��R�V�V�R�V�V�S�"�&�&�9��H� �"�&�&�"�&�&�#�r�v�v�!>�?�"�#F�h�W�!�"A�B�!�!���B�F�F�B�F�F�+� �#�r�v�v�s�B�F�F�!;�<�"�>�h��"�"D�E��Y�Y�q��0�!
�
��*�F�8�=�=�?�+�,�1�1��1�@���X�&��
���f�h�/r#c��tdtjtjddgi�}tddtjgi�}|rdnt}t	j
|�5|j
d��}|jd��jd��}ddd�t	j|�y#1swY� xYw)Nrr3Fr)�byT)�drop)
rr'r(�UserWarningrIrJrN�sort_values�reset_indexrO)r�r�rWr[�warningrXs      r!�test_mode_sortwarningz,TestDataFrameAnalytics.test_mode_sortwarning�s�����b�f�f�b�f�f�c�3�7�8�
9���c�C����=�1�2��,�$�+��
�
'�
'��
0�	G��W�W�E�W�*�F��'�'�3�'�/�;�;��;�F�F�	G�	���f�h�/�		G�	G�s�*5B>�>Cc��tgddg��}|j�}tgddgtgtj����}tj||�y)Nr3r/r�re�rirF)rrNrr'rJrIrO�r�rWrXr[s    r!�test_mode_empty_dfz)TestDataFrameAnalytics.test_mode_empty_df�sJ��
�r�C��:�
.��������R�#�s��5��2�8�8�;T�U��
���f�h�/r#c
��ttddd��tddd��td�tdd��z
d	��}t|d
|dz
|d
|dz
d
��}|j	�}|j
d|jdk(sJ�|j
d|jdk(sJ�|j	d��}||jdk(j�sJ�|j�}|j
d|jdk(sJ�|j
d|jdk(sJ�|jd��}||d
k(j�sJ�|j�}t|�}t|d
|dz
|d|d
z
d
��}tj||�tj||�|j�}d|d<d|d<d|d<td�|d<|j	�}ttjtd���tjtd���dddtd�g|j ��}tj"||�|j	dd� �}tgd!�gd"���}tj"||�|d
dgj	d�}ttd��gdz�}tj"||�|d
dgj	�}ttd��td��gd
dg��}tj"||�ttd#d�$�td%d�$�d&��}|d'|d(z
|d)<|d)j$d*k(sJ�|d(|d'z
|d+<|j'�|d)j$d*k(sJ�|d+j$d*k(sJ�y),Nz2012-1-1r�r6�r2�freqz2012-1-2�20120101rj)�minutes�secondsrrrrr
r)rrr;)rrr?)r0r)r0rr�r�r7�20130101r8i1�rb���)�daysrTr�)r;r;r�r��20130102r1�20130105)�time�time2rjri�off1�timedelta64[ns]�off2)rrrrr�rtr)�allr��absrIrO�copyrr��	TimedeltarirMrG�_consolidate_inplace)r�rW�diffsrX�result2r[�mixeds       r!�test_operators_timedelta64z1TestDataFrameAnalytics.test_operators_timedelta64�s���
��
�A�C�@��
�A�C�@��z�*�Y�q�!�-L�L�
�
����3��"�S�'� 1��3��"�S�'�8I�J�K��������{�{�1�~����6�!2�2�2�2��{�{�1�~����6�!2�2�2�2������"���%�)�)�F�+�+�0�0�2�2�2�������{�{�1�~����6�!2�2�2�2��{�{�1�~����6�!2�2�2�2������"���%��*�$�)�)�+�+�+�������e�*���2�c�7�R��W�#4�2�c�7�R��W�;L�M�N��
���f�h�/�
���g�x�0��
�
�����c�
���c�
���c�
��z�*��c�
����������Y�z�:�;����Y�B�/�0�����*�%�

��-�-�

��	���v�x�0�������5���+�Y�7��
���v�x�0���S�z�"�&�&�q�)���9�"�-�.��2�3��
���v�x�0���S�z�"�&�&�(���
�z�
*�I�2�,>�?��S�z�
��	���v�x�0��"�:�q�9�#�J��:�
�
����[�2�f�:�-��6�
��&�z���#4�4�4�4���Z�"�W�+�-��6�
�
���!��&�z���#4�4�4�4��&�z���#4�4�4�4r#c� �tjdd��}t||d�d��}tj|jd<|jd�	�}t
|d
j�tjgd
dgd�
�}tj||�|jdd��}t
tjd�gdztjtjd�gz�}tj||�y)Nz1 Dayrkr1r
T�rp)rmreF�r:rrrlrEr;r8rr:)
r��timedelta_rangerr<rtr�rrIrMrq)r��tdirWrXr[s     r!�!test_std_timedelta64_skipna_falsez8TestDataFrameAnalytics.test_std_timedelta64_skipna_false!s���� � ��"�5��
�S�s�+�$�
7���&�&���������u��%���
��W�[�[�]�B�F�F�#�C��:�=N�
��	���v�x�0����Q�u��-���2�<�<��?�+�a�/�2�6�6�2�<�<��?�2K�K�L��
���v�x�0r#rz
2022-01-01z
2022-01-02z
2022-01-03c���|rE|rtd�|D��r1tjjd��}|j	|�t|�j
|�}td|i�}|j|��}	|rtd�|D��r"tdtjid|�d��	�}
ntdd
id|�d��	�}
tj|	|
�y)Nc3�@K�|]}|tju���y�wr�r�r<��.0�values  r!�	<genexpr>zFTestDataFrameAnalytics.test_std_datetime64_with_nat.<locals>.<genexpr>9s����B�%�e�r�v�v�o�B���z=GH#51446: Incorrect type inference on NaT in reduction resultr�r3ryc3�@K�|]}|tju���y�wrrr�s  r!r�zFTestDataFrameAnalytics.test_std_datetime64_with_nat.<locals>.<genexpr>Bs����A��U�b�f�f�_�A�r�ztimedelta64[�]rel�"R:)rnrO�mark�xfail�applymarkerr�as_unitrr�rr�r<rIrM)r�rr:�using_array_manager�requestr`r��dtirWrXr[s           r!�test_std_datetime64_with_natz3TestDataFrameAnalytics.test_std_datetime64_with_nat1s�����#�B�6�B�B��;�;�$�$�V�%��D�
����%��&�!�)�)�$�/��
��S�z�
"�����v��&����A�&�A�A��s�B�F�F�m�\�$��q�3I�J�H��s�N�3�\�$��q�;Q�R�H�
���v�x�0r#c���t�}|jd�}|jd�}t|t�sJ�t|t�sJ�t	|�dk(sJ�t	|�dk(sJ�y)Nrr;)rr@rKrr&)r��empty_frame�axis0�axis1s    r!�test_sum_cornerz&TestDataFrameAnalytics.test_sum_cornerIse���k������"������"���%��(�(�(��%��(�(�(��5�z�Q�����5�z�Q���r#rF�ME)r_r6c��tdg|��}t||�d��}|dvrd}n
|dk(rd}nd	}tg||�
�}tj||�y)Nr3rZr;r?)r�rnrpr�rJrrrE�rrHrrIrM)r��all_reductionsrFrWrX�expected_dtyper[s       r!�test_axis_1_emptyz(TestDataFrameAnalytics.test_axis_1_emptySsb����u�E�
2��,���^�,�!�4���^�+�#�N�
�w�
&�$�N�%�N��"�E��@��
���v�x�0r#zmethod, unit)r@r)rAr;r�)NTFc��gd�}t||g|tjgtjtjgd��}t||�|��}t	|||g|d��}tj||�t||�|d��}t	||tjg|��}tj||�t||�|d��}t	|||g|d��}tj||�t|jdd|�|d��}t	|tjtjg|��}tj||�t|gd	z|gd
ztjgd
zzd��}t||�|d
��}t	|dd
g��}tj||�t||�|d��}t	|dd
g��}tj||�y)Nr��r��float64rEr;)r��	min_countrrrkrjr
rr�)rr'r(rHrrIrMrt)r�r�r`r��idxrWrXr[s        r!�test_sum_prod_nanopsz+TestDataFrameAnalytics.test_sum_prod_nanopsjs�����
�d�D�\��r�v�v��b�f�f�b�f�f�EU�V�
W��$���V�$�,�?���4��t�,�C�y�I��
���v�x�0�%���V�$�,�!�L���4��r�v�v�.�c�:��
���v�x�0�%���V�$�,�!�L���4��t�,�C�y�I��
���v�x�0�-��������f�-�<�ST�U���4�������0��<��
���v�x�0��d�V�b�[��v��z�R�V�V�H�q�L�/H�I�
J��$���V�$�,�!�L���&��c�
�3��
���v�x�0�$���V�$�,�!�L���&��c�
�3��
���v�x�0r#c��gd�}tddgdtjgtjtjgd��}|jt�}|j�}t
gd�d|��}tj||�|jd��}tj||�|jd��}t
ddtjgd|��}tj||�y)Nr�r)rrr�m8[ns]�rGrF�r�r;)	rr'r(rNrr@rrIrM)r�r�rWr+rXr[s      r!�test_sum_nanops_timedeltaz0TestDataFrameAnalytics.test_sum_nanops_timedelta�s�����
�a��V�1�b�f�f�+�R�V�V�R�V�V�<L�M�
N���h�h�|�$��������)�8�3�?��
���v�x�0����1��%��
���v�x�0����1��%���1�a����.���D��
���v�x�0r#c���tgd�gd�d��}|jd��}ttjtjgddg��}tj||�y)	Nr�rdrjr�)r�yrkr�rr�r)rr@rr'r(rIrMr[s    r!�test_sum_nanops_min_countz0TestDataFrameAnalytics.test_sum_nanops_min_count�sN��
�Y�Y�7�
8�����"��%���2�6�6�2�6�6�*�3��*�=��
���v�x�0r#�
float_type)�float16r�r�zkwargs, expected_result)r9r�g������	@g333333@r8c���tgd�ddtjgd�|��}|jdi|��}t	|�j|�}t
j||�y)N)r�gffffff@皙����@g������@r��r3r/rer,)rr'r(r@rr�rIrM�r�r��kwargs�expected_resultrWrXr[s       r!�test_sum_nanops_dtype_min_countz6TestDataFrameAnalytics.test_sum_nanops_dtype_min_count�sX���_�C��B�F�F�3C�D�J�
W������!�&�!���/�*�1�1�*�=��
���v�x�0r#r�r�c���tgd�ddtjgd�|��}|jdi|��}t	|�j|�}t
j||�y)N)r�r�r�r�r�rer,)rr'r(rArr�rIrMr�s       r!� test_prod_nanops_dtype_min_countz7TestDataFrameAnalytics.test_prod_nanops_dtype_min_count�s]���!��c�2�6�6�(:�;�:�
������"�6�"���/�*�1�1�*�=��
���v�x�0r#c���|jjt�}t||j|j
��}|t
d�z}|j�y)Nryr;)rr�r�rrFrirr@)r�r�rrS�deltass     r!�test_sum_objectz&TestDataFrameAnalytics.test_sum_object�sI���#�#�*�*�3�/���&��(9�(9�;�CV�CV�W����1��%���
�
�r#c�r�tj|�}|jd�|jd�y)Nr;r)r'�isnanr@)r�r��boolss   r!�
test_sum_boolz$TestDataFrameAnalytics.test_sum_bool�s&������%��
�	�	�!��
�	�	�!�r#c���ttdd��gd�d��jgd��}tjt
d��5|j
�ddd�y#1swYyxYw)	Nrrdr1r�r
)r0r�rdz does not support reduction 'sum'rC)rrr�rOrPr�r@rs  r!�test_sum_mixed_datetimez.TestDataFrameAnalytics.test_sum_mixed_datetime�sU��
�Z���:��N�
O�
W�
W��
���]�]�9�,N�
O�	��F�F�H�	�	�	�s�A"�"A+c��d}tjt|��5|jd��ddd�tjtd��5|jd��ddd�|ddkD|d<|jd�}|d|djj�k(sJ�y#1swY��xYw#1swY�WxYw)	Nz"Could not convert|does not supportrCrr?�unsupported operand typer;rrp)rOrPr�r�r)r�r�r�r��meanss     r!�test_mean_cornerz'TestDataFrameAnalytics.test_mean_corner�s���2��
�]�]�9�C�
0�	,��#�#��#�+�	,��]�]�9�,F�
G�	,��#�#��#�+�	,�*�#�.��2��F��� � ��#���V�}��F� 3� :� :� ?� ?� A�A�A�A�	,�	,��	,�	,�s�B1�B=�1B:�=Cc
��ttjd�tdd��t	j
dd��t	jddd��d��}|jd	�
�}tddi�}tj||�tjtd
��5|j�ddd�y#1swYyxYw)Nr��
2016-01-01r1�1D�2016�Yr^)rrrr6Tr�rr�z'mean is not implemented for PeriodArrayrC)rr'rKrr�rz�period_ranger�rrIrMrOrPr�r[s    r!�test_mean_datetimelikez-TestDataFrameAnalytics.test_mean_datetimelike�s���
��Y�Y�q�\���a�8��'�'��a�8��_�_�V�Q�S�A�	
�
�����d��+���3��*�%��
���v�x�0�
�]�]�9�,U�
V�	��G�G�I�	�	�	�s�*C�C
c���ttjd�tdd��t	j
dd��d��}|j
d��}td|jd	|jd
d��}tj||�t	jddd�
�|d<tjtd��5|j
d��ddd�y#1swYyxYw)Nr�r�r1r�rFr�r;)r;r)r;rr�r�r^r6z"mean is not implemented for PeriodrC)rr'rKrr�rzr�rr)rIrMr�rOrPr�r[s    r!�)test_mean_datetimelike_numeric_only_falsez@TestDataFrameAnalytics.test_mean_datetimelike_numeric_only_falses���
��Y�Y�q�\���a�8��'�'��a�8�
�
�����e��,�������v��R�V�V�F�^�L�M��
���v�x�0��/�/�&�!�#�>��3��
�]�]�9�,P�
Q�	(��G�G��G�'�	(�	(�	(�s�
C&�&C/c��tjjd�jdd��}t	|d��}|jd��}t	|�j�j
d	�}tj||�y)
Nr0r)rkrj)�size�Int64reTr��Float64)	r'rzr{�integersrr�r�rIrM)r�r$rWrXr[s     r!�*test_mean_extensionarray_numeric_only_truezATestDataFrameAnalytics.test_mean_extensionarray_numeric_only_trueso���i�i�#�#�A�&�/�/��7�/�C��
�s�'�
*�����d��+���S�>�&�&�(�/�/�	�:��
���v�x�0r#c��tjtd��5|jd�ddd�tjtd��5|j	d�ddd�tjtd��5|jd�ddd�tjtd��5|j
d�ddd�y#1swY��xYw#1swY��xYw#1swY�WxYw#1swYyxYw)Nr�rCr;r�)rOrPr�r�r�r�r�)r�r�s  r!�test_stats_mixed_typez,TestDataFrameAnalytics.test_stats_mixed_types���
�]�]�9�,?�
@�	&��"�"�1�%�	&�
�]�]�9�,?�
@�	&��"�"�1�%�	&�
�]�]�9�,F�
G�	'��#�#�A�&�	'�
�]�]�9�,?�
@�	'��#�#�A�&�	'�	'�
	&�	&��	&�	&��	'�	'��	'�	'�s/�C�C"�C.�;C:�C�"C+�.C7�:Dc��ttd�td���}t|�}|jd��ddk(sJ�y)Nr;rkryr?r)rrLrr@)r�rWr�s   r!�test_sum_boolsz%TestDataFrameAnalytics.test_sum_bools's=��
�U�1�X�u�R�y�
9���R����y�y�a�y� ��#�r�)�)�)r#r:c�`�|}tj|jddtj|jdd�dd�f<||fD]�}d}|dus|dk(r||urdnt}d}t	j
||�	�5|j
||�
�}	ddd�d}
t	j
||
�	�5|jtj||�
�}ddd�j|jj�}t	j	|���y#1swY��xYw#1swY�SxYw)NrjrkrcrlrmFr;z3The behavior of DataFrame.idxmin with all-NA valuesrCr8zThe behavior of Series.idxmin)
r'r(rt�
FutureWarningrIrJ�idxminrNrr�rFrGrM�r�r�r�r:r9rSrW�warnr�rX�msg2r[s            r!�test_idxminz"TestDataFrameAnalytics.test_idxmin/������6�6��
�
�1�R��!#����
�
�2�b�5�"�#�:���)�$�	5�B��D����$�!�)�!�Y��t�M��G�C��+�+�D��<�
=�����V��<��
=�3�D��+�+�D��=�
M��8�8�F�M�M��V�8�L��
M����r�x�x�~�~�6�H��"�"�6�8�4�	5�

=�
=��
M�
M���:D�/#D$�D!	�$D-	z3ignore:PeriodDtype\[B\] is deprecated:FutureWarningc��|dk(r
t|��}nt|��}|j||��}t|j��}t	j
||�y�Nrrr�r8re)rr�rrGrIrM�r�rFr:r9rSrXr[s       r!�test_idxmin_emptyz(TestDataFrameAnalytics.test_idxmin_emptyC�O���1�9��E�*�E��e�,�E����4���7������,��
���v�x�0r#c���tgd�gd�td�d��}|j|��}|rtddgdd	g�
�}ntgd�gd��
�}t	j
||�y)N�r0r�r;�r0r;r;�xyxr�r�r0r;r3r/r)r0r;r)rrsr�rrIrM�r�r�rWrXr[s     r!�test_idxmin_numeric_onlyz/TestDataFrameAnalytics.test_idxmin_numeric_onlyP�Z��
�Y�Y�T�%�[�I�
J�������5����q�!�f�S�#�J�7�H��i��?�H�
���v�x�0r#c��|}d}tjt|��5|jd��ddd�y#1swYyxYw�Nz)No axis named 2 for object type DataFramerCr0r?)rOrPrQr��r�r�rSr�s    r!�test_idxmin_axis_2z)TestDataFrameAnalytics.test_idxmin_axis_2Z�=����9��
�]�]�:�S�
1�	!��L�L�a�L� �	!�	!�	!��	�<�Ac�`�|}tj|jddtj|jdd�dd�f<||fD]�}d}|dus|dk(r||urdnt}d}t	j
||�	�5|j
||�
�}	ddd�d}
t	j
||
�	�5|jtj||�
�}ddd�j|jj�}t	j	|���y#1swY��xYw#1swY�SxYw)NrjrkrcrlrmFr;z3The behavior of DataFrame.idxmax with all-NA valuesrCr8zThe behavior of Series.idxmax)
r'r(rtr�rIrJ�idxmaxrNrr�rFrGrMr�s            r!�test_idxmaxz"TestDataFrameAnalytics.test_idxmax`r�r�c��|dk(r
t|��}nt|��}|j||��}t|j��}t	j
||�yr�)rr�rrGrIrMr�s       r!�test_idxmax_emptyz(TestDataFrameAnalytics.test_idxmax_emptytr�r#c���tgd�gd�td�d��}|j|��}|rtddgdd	g�
�}ntgd�gd��
�}t	j
||�y)Nr�r�r�r�r�r;rr3r/r)r;rr;)rrsr�rrIrMr�s     r!�test_idxmax_numeric_onlyz/TestDataFrameAnalytics.test_idxmax_numeric_only�r�r#c�0�tjd�tgd�gd�d�d��}|j�}t	ddgd	d
g��}tj||�|j�}t	ddgd	d
g��}tj||�td	gd
�id��}|jd��}t	dgd	g��}tj||�|jd��}t	dgd	g��}tj||�y)N�pyarrowr�r�r�zint64[pyarrow]rer;rr3r/rr0)r/r�r3zstring[pyarrow]Fr�)rOr�rr�rrIrMr�r[s    r!�test_idxmax_arrow_typesz.TestDataFrameAnalytics.test_idxmax_arrow_types�s������I�&�
�Y�Y�7�?O�
P��������1�a�&��c�
�3��
���v�x�0�������1�a�&��c�
�3��
���v�x�0�
��_�-�5F�
G�������.���1�#�c�U�+��
���v�x�0������.���1�#�c�U�+��
���v�x�0r#c��|}d}tjt|��5|jd��ddd�y#1swYyxYwr�)rOrPrQr�r�s    r!�test_idxmax_axis_2z)TestDataFrameAnalytics.test_idxmax_axis_2�r�r�c��tdd��}tgd�td�ddd�|jd��d��}|j	�}tgd	�gd��
�}t
j||�|j�}tgd�gd��
�}t
j||�tj|jd<|j	�}tgd	�gd��
�}t
j||�|j�}tgd�gd��
�}t
j||�|ddd�|d
<|j�|j	�}tgd�gd��
�}t
j||�|j�}tgd�gd��
�}t
j||�y)Nr�r�r1)rr0r;reT)�deepr)r;rr0r)rr0r)rr�rd)r;rr0rr�)rr0r;r0)
rrrLrpr�rrIrMr�r�r<r)rr�r�r�rWrXr[s     r!�test_idxmax_mixed_dtypez.TestDataFrameAnalytics.test_idxmax_mixed_dtype�sT����q�1���9��q��$�B�$��C�H�H�$�H�<O�P�
Q��������)�9�5��
���v�x�0�������)�9�5��
���v�x�0��v�v����t��������)�9�5��
���v�x�0�������)�9�5��
���v�x�0��D�b�D�	��1��
���!�������,�l�;��
���v�x�0�������,�l�;��
���v�x�0r#zop, expected_valuer�r�rjc���tgd�gd�d�d��}|jd�}t||��}td|itdd	gdd�
���}t	j
||�y)N)�drr��rr)rrrr;r0r)�IDr�r�rerr�rr)�namerGr)r�groupbyrHrrIrO)r�r��expected_valuerWrXr[s      r!�!test_idxmax_idxmin_convert_dtypesz8TestDataFrameAnalytics.test_idxmax_idxmin_convert_dtypes�sr���4�+�
��
���Z�Z��
�� ���R��"���
�n�%���c�
��W�=�
��	���f�h�/r#c�x�tdd��}t||ddd�d�d��}tj|jd<|j�|j
d	�
�}tgd��}tj||�|jd	�
�}tgd��}tj||�y)
Nr�r�r1re)r�rdTrx)rrr;r?)rdr�r�)rdr�rd)rrr�r<rtrrr�rrIrMr�r�s     r!�"test_idxmax_dt64_multicolumn_axis1z9TestDataFrameAnalytics.test_idxmax_dt64_multicolumn_axis1�s�����q�1��
�3�3�t��t�9�-�D�
9���������
�
���!������"���)�$��
���v�x�0������"���)�$��
���v�x�0r#r�rn�	bool_onlyc��|}tjjd�jt	|��dkD|d<t||�||��y)Nr0g�?�_bool_�r9r
)r'rzr{r|r&rH)r�rRr9r
r�rus      r!�test_any_all_mixed_floatz/TestDataFrameAnalytics.test_any_all_mixed_float�sI��
#���)�)�/�/��2�B�B�3�u�:�N�QT�T��h�����v��D�I�>r#c�,�t||�|d��y)NFr
r�)r�rRr9rws    r!�test_any_all_bool_with_naz0TestDataFrameAnalytics.test_any_all_bool_with_na�s��	,��"�F�+���Gr#z4ignore:Downcasting object dtype arrays:FutureWarningc�t��|jd�}tt|��t||�}�fd�}�fd�}|dd��}|dd��}tj||j|��tj||j|d���|d��}|d��}tj||j|��tj||j|d��d�	�t
jtd
��5|d��ddd�|tjz}	t|	|�d��}
t|	|�d��}|d
k(r%|
j�rJ�|j�rJ�y|
j�sJ�|j�sJ�y#1swY��xYw)NTc�H��|j�j}�|�Sr)r%rr)s  �r!r"zFTestDataFrameAnalytics.test_any_all_bool_frame.<locals>.skipna_wrapper
s����8�8�:�$�$�D��t�$�$r#c�(���|j�Srrr5s �r!r6z?TestDataFrameAnalytics.test_any_all_bool_frame.<locals>.wrapperr7r#rFr8r;r?)r<rBrCr0r�)�fillnarHr'rIrMrNrOrPrQr(r�rn)
r�rRrwrSrVr"r6rYrZr]r^r_r+s
            @r!�test_any_all_bool_framez.TestDataFrameAnalytics.test_any_all_bool_framesu���
#�)�)�$�/���b�&�)���E�6�"��	%�	)���5�)����5�)��
���w����G�(<�=�
���w����G�!��(D�E���)����)��
���w����N�(C�D�
����U�[�[��a�[�8�e�	
�
�]�]�:�->�
?�	�
�1�I�	�������
$�W�V�V�
$�!�
,��
$�W�V�V�
$�!�
,���U�?��v�v�x��<��v�v�x��<�x��6�6�8�O�8��6�6�8�O�8�	�	�s�
F.�.F7c��tgd�gd�gd�d�gd���}|ddgjd	�
�}tgd�gd���}tj||�|ddgjd	d��}tj||�|jd	�}tgd�gd���}tj||�|jd	d�
�}tj||�|jd�
�j
�}|dusJ�|jd�
�j
�}|dusJ�|dgjd�
�j
�}|dusJ�y)N)TFF)TTF)TTTrr�rrrr;r?Tr
�r
Fr)rr�rrIrMrn�itemr[s    r!�test_any_all_extraz)TestDataFrameAnalytics.test_any_all_extra1sI��
�)�(�'�
�
"�

���S�#�J��#�#��#�+���-�_�E��
���v�x�0��S�#�J��#�#��d�#�;��
���v�x�0��������.�o�F��
���v�x�0�����T��*��
���v�x�0����T��"�'�'�)����������T��"�'�'�)����~��~��S�E����D��)�.�.�0����~��~r#�
bool_agg_funcc	��tdtjtjdgtjdtjdgtjtjtjdgtjtjdtjgg��}|r|dk(xr
|xr|dk(}nd}t||�||��}t	dd|dg�}tj||�y)	Nr;Tr0�5��datarrnr8)rr'r(rHrrIrM)	r�r9rr:r�rW�valrXr[s	         r!�test_any_all_object_dtypez0TestDataFrameAnalytics.test_any_all_object_dtypeRs�����B�F�F�B�F�F�D�)�����B�F�F�D�)�����������.��������b�f�f�-�	�
����a�i�-�I��J�I�=�E�3I�C��C�+���]�+��f�E���4��s�D�1�2��
���v�x�0r#zAignore:'any' with datetime64 dtypes is deprecated.*:FutureWarningc�6�dtjdtjg}td�td�tjtjg}t||d��}|j
d��}tgd��}tj||�y)Nr;r�z
1960-02-15z
1960-02-16r
r?)TTTF)
r'r(rr�r<rr�rrIrM)r��
float_data�
datetime_datarWrXr[s      r!�test_any_datetimez(TestDataFrameAnalytics.test_any_datetimeksz��
�����B�F�F�+�
��l�#��l�#��F�F��F�F�	
�
��Z�m�<�
=�����Q�����3�4��
���v�x�0r#c�t�tgd�gd�gd�d�tgd�t����}|jd��}t	t
jg�	�}tj||�tgd�gd�gd�gd
�d��}|jd��}t	dd
i�}tj||�y)Nrr�)NNN)�col1�col2�col3rer�Trr�)FFT)r&r'r(�col4r)F)	rrrrrnrr'�bool_rIrMr[s    r!�test_any_all_bool_onlyz-TestDataFrameAnalytics.test_any_all_bool_only~s���
��	�;M�N��2�&�A�
��
���$��'�������3��
���v�x�0�
�!�!�*�,�	
�
�����$��'���6�5�/�*��
���v�x�0r#zfunc, data, expectedrr
r�r�zM8[ns, UTC]r��categoryrkrlc��t|�}td�|jD��rwtjt
d��5||�ddd�tjt
d��5t
t|�|j�d��ddd�yd}|jjd��j�rt}nd}tj||d��5||�}ddd�ttj�sJ�|j�|usJ�tj||��5t
t|�|j�d��}ddd�t|tj�sJ�|j�|usJ�y#1swY��ZxYw#1swYyxYw#1swY��xYw#1swY�_xYw)	Nc3�<K�|]}t|t����y�wr)rKr)r�rs  r!r�z>TestDataFrameAnalytics.test_any_all_np_func.<locals>.<genexpr>�s����D�1�z�!�-�.�D�s�z)dtype category does not support reductionrCr?z0'(any|all)' with datetime64 dtypes is deprecatedc� �|jdk(S)NrD)�kindr�s r!rz=TestDataFrameAnalytics.test_any_all_np_func.<locals>.<lambda>�s��1�6�6�S�=�r#F)rD�check_stacklevel)rr��dtypesrOrPr�rH�__name__rNr�rIrJrKr'r*r)r��funcrr[r�r�rXs       r!�test_any_all_np_funcz+TestDataFrameAnalytics.test_any_all_np_func�s���j�����D����D�D�����!L��
��T�
�
�����!L��
C�8��	�$�����7�T�B�
C�
C�
E�C��{�{� � �!8�9�=�=�?�$�����+�+�D��e�T�
$��d���
$��f�b�h�h�/�/�/��;�;�=�H�,�,�,��+�+�D��<�
L�@���4��$�-�-�@�d�K��
L��f�b�h�h�/�/�/��;�;�=�H�,�,�,�9
�
��
C�
C��
$�
$��
L�
L�s0�	F$�/'F1�,	F=�'G	�$F.�1F:�=G�	Gc���tjtddg���j�}|dusJ�tjtddg���j�}|dusJ�y)Nr3r/r�TF)r'rnrrr�)r�rXs  r!�test_any_all_objectz*TestDataFrameAnalytics.test_any_all_object�sZ�����	�3��*�5�6�;�;�=����~��~����	�3��*�5�6�;�;�=������r#c��tddgddgd��jt�}|j�t	ddg�|d<|djd�|d<|j�}|dg}t
j||�|jdd	�
�}t	dgdg��}t
j||�|ddgjdd	�
�}t
j||�|jdd�
�sJ�|jdd	�
�}t	dgdg��}t
j||�|dgjdd	�
�}t
j||�|jdd�
�sJ�y)
Nr�r0TFr
rr,r6r)r
r9rr)rr�rrrrr�_get_bool_datarIrOrnrMr�)r�rW�resr[s    r!�test_any_all_object_bool_onlyz4TestDataFrameAnalytics.test_any_all_object_bool_only�sn��
�e�Q�Z�t�U�m�<�
=�
D�
D�V�
L��
���!��$���&��3���S�'�.�.��,��3�����!���s�e�9��
���c�8�,��f�f�t�!�f�,���4�&���.��
���s�H�-��#�s��n� � �4�a� �8��
���s�H�-��v�v��4�v�0�0�0��f�f�t�!�f�,���4�&���.��
���s�H�-��#��i�m�m�d��m�3��
���s�H�-��v�v��4�v�0�0�0r#c��tgd��}tdtjdtjgi�}tgd��}ttjtjdg�}t	j
d�5|j
|d��dD]}t||�|d�	��	ddd�y#1swYyxYw)
N)r�r�r�rr�r�r;r)�lowerr9)�lt�le�gt�ge�eq�ner?)rr'r(rrIrJ�cliprH)r�rW�df_nanr��s_nanr�s      r!�test_series_broadcastingz/TestDataFrameAnalytics.test_series_broadcastings�����
'���C�"�&�&�#�r�v�v�!6�7�8���9�����������*�+��
�
'�
'��
-�	/��K�K�a�a�K�(�:�
/�����B���A�.�
/�	/�	/�	/�s�/B?�?C)[r3�
__module__�__qualname__rOr��parametrize�param�td�
skip_if_nor�r�r�r�r�rr'r(rr�filterwarningsr�r�r�rr�rrrrr%r,r0r
r
rr�r�r<rPrXr\rvr|r�r�rrrJr�rr�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�rr	rrrrr r$r+r�rnrr�r5r7r;rGr,r#r!rr�s����[�[���V�a��V�,��[�[����������������F�L�L��}�r�}�}�W�'=�>��F�L�L��}�r�}�}�W�'=�>�	
��$,N�%�-�&,N�\�[�[���V�a��V�,��[�[���������������F�L�L��}�r�}�}�W�'=�>��F�L�L��}�r�}�}�W�'=�>�
	
��"D�#�-�$D�6
�p?� 	
��[�[����M���[�[������
'���,��
�"
�2�6�6�1�+�2�6�6�1�+�2�6�6�1�+�F�f�U�%	
��.�[�[��� R�S�1�T�/��61��[�[���T�#P�Q�"�R�"�@�[�[���"�$�-Q���*��*�"	
��[�[���T�D�%�=�1�1�2�1��[�[���T�D�%�=�1�1�2�1�1�6*�"�[�[���V�%:�;�";�<�";�H*��[�[�������������$�c�U��u�=�&��~�X�F�%�x�j�1��
�������&�&��!����2�6�6�(�&�9�$�b�f�f�X�3�%�@�&����x�x�@�%�r�v�v�h�/��
���Q�������/��Q�������/��R�V�V�R�V�V�R�V�V�4�$�c�2�6�6�2�6�6�2�6�6�%B�PS�u�U�&�;�8��&�&E�F�%�
�

���Q�������/��Q�������/��R�V�V�R�V�V�R�V�V�4�$�b�f�f�c�2�6�6�2�6�6�%B�PS�u�U�&�;�8��&�&E�F�%�
�

�O5	
�8�r0�s8�r0�40�0�U5�n1� �[�[����L�,�����E�q�B�F�F�8�|�T��1��1�*��[�[�����q�M��"���"�B�H�H�%��"�B�J�J�'��"�4�(����%�
	
�
�
1�
�
1��[�[���^�j�+�-F�G��[�[���^�-@�A�1�B�H�1�@1�*1��[�[���\�+L�M��[�[���!��a�
(�3��R�V�V�*<�=��a�
(�2�6�6�2�6�6�2�6�6�*B�C��5�
)�C��b�f�f�+=�>�	
��1��N�1��[�[���\�+L�M��[�[���!��a�
(�3��R�V�V�*<�=��a�
(�2�6�6�2�6�6�2�6�6�*B�C��5�
)�C��b�f�f�+=�>�	
��1��N�1����
B��((�(1�'�*��[�[���X��e�}�5��[�[���V�a��V�,�5�-�6�5�$�[�[���V�a��V�,��[�[��� V�W�	1�X�-�	1��[�[���^�d�E�]�;�1�<�1�!��[�[���X��e�}�5��[�[���V�a��V�,�5�-�6�5�$�[�[���V�a��V�,��[�[��� V�W�	1�X�-�	1��[�[���^�d�E�]�;�1�<�1�1�,!�$1�L�[�[����
�Q��F�	�h��A��/�0��0�	�0�$
1�$�[�[���X��u�~�6��[�[���V�a��V�,��[�[���[�5�$�-�8�?�9�-�7�?��[�[���X��u�~�6��[�[���V�a��V�,�H�-�7�H��[�[��� V�W��[�[���X��u�~�6�)�7�X�)�V�B�[�[���V�a��V�,��[�[���_�u�e�n�=��[�[���X��e�}�5�1�6�>�-�1�,�[�[���K��1��1� 1�0�[�[����/	
�
�V�V�R���/	
�
�V�V�R���/	
��V�V�c�2�Y��&�/	
��V�V�c�2�Y��%�	/	
�
�V�V�c�E�5�>�*�E�2�/	
��V�V�c�E�5�>�*�E�2�
/	
��V�V�c�D�%�=�)�4�0�/	
��V�V�c�D�%�=�)�5�1�/	
��V�V�c�D�$�<�(�$�/�/	
��V�V�c�D�$�<�(�$�/�/	
��V�V�E�7�%��1�5�9�/	
��V�V�E�7�%��1�5�9�/	
��V�V�E�5�>���
�>��E�/	
��V�V�E�5�>���
�>��F�/	
� �V�V�c�6�3��*�G�<�=�u�E�!/	
�"�V�V�c�6�3��*�G�<�=�t�D�#/	
�$�V�V�c�6�1�a�&��4�5�u�=�%/	
�&�V�V�c�6�1�a�&��4�5�t�<�'/	
�(
�F�L�L����#�v�q�!�f�H�'E�!F��N�)/	
�*
�F�L�L����#�v�q�!�f�M�'J�!K�U�S�+/	
�,
�F�L�L����#�v�q�!�f�H�'E�!F��M�-/	
�.
�F�L�L����#�v�q�!�f�M�'J�!K�T�R�//	
�0
�F�L�L����#�v�q�!�f�H�'E�!F��M�1/	
�2
�F�L�L����#�v�q�!�f�M�'J�!K�T�R�3/	
�4
�F�L�L����#�v�q�!�f�H�'E�!F��M�5/	
�6
�F�L�L����#�v�q�!�f�M�'J�!K�T�R�7/	
�8
�F�L�L����#�v�q�!�f�H�'E�!F��N�9/	
�:
�F�L�L����#�v�q�!�f�H�'E�!F��M�;/	
�<
�F�L�L����#�v�q�!�f�H�'E�!F��M�=/	
�>
�F�L�L����#�v�q�!�f�H�'E�!F��M�?/	
�D�V�V�c�6�1�a�&�
�;�<�d�C�E/	
�F�V�V�c�6�1�a�&�
�;�<�e�D�G/	
�H�V�V�c�6�1�a�&�
�;�<�d�C�I/	
�J�V�V�c�6�1�a�&�
�;�<�e�D�K/	
�N
�F�L�L������R���9���R���9���

�O/	
�2�f!-�g2�f!-�F� 1�J/r#rc�P�eZdZd�Zd�Zd�Zd�Zejjdddg�ejjdd	d
g�de
fd���Zejjdd	d
g�d��Zd
�Z
d�Zej d��Zej$d��Zy)�TestDataFrameReductionsc���tdtjtjtd�gi�}|j	�}ttd�gdg��}t
j||�|j�}ttd�gdg��}t
j||�tdtjtjgi�}|j	�}ttjgdg��}t
j||�|j�}ttjgdg��}t
j||�y)Nr�z
2012-05-01r)	rr�r<rr�rrIrMr�)r�rWr:�exps    r!�test_min_max_dt64_with_NaTz2TestDataFrameReductions.test_min_max_dt64_with_NaT(s��
��������	�,�0G�H�I�
J���f�f�h���i��-�.�u�g�>��
���s�C�(��f�f�h���i��-�.�u�g�>��
���s�C�(���������/�0�
1���f�f�h���b�f�f�X�e�W�-��
���s�C�(��f�f�h���b�f�f�X�e�W�-��
���s�C�(r#c��|}t|t�rt�rtjd�tt
d|��t
d|��gt
d|��tjgd��}|jdd�	�}t|jd
tjg�}|j|djk(sJ�tj||�|jdd�	�}t|jdtjg�}|j|djk(sJ�tj||�y)
NzSGH#37659 OSError raised within tzlocal bc Windows chokes in times before 1970-01-01z2020-01-01 08:00:00rz1920-02-01 09:00:00z2020-02-01 08:00:00r�r;Fr8)rr3r3)rr/)rKrrrO�skiprrr�r<r�rr)rGrIrMr�)r�r��tz_naive_fixturerrWr:r[s       r!�'test_min_max_dt64_with_NaT_skipna_falsez?TestDataFrameReductions.test_min_max_dt64_with_NaT_skipna_false?s��
���b�'�"�':�'<��K�K�4�
�
��3��;��3��;�� � 5�"�=�r�v�v�F�
�
���f�f�!�E�f�*���2�6�6�&�>�2�6�6�2�3���~�~��C����.�.�.�
���s�H�-��f�f�!�E�f�*���2�6�6�&�>�2�6�6�2�3���~�~��C����.�.�.�
���s�H�-r#c�,�tdtg�i�}ttg��}|jd��jt
ju|j�t
juk(sJ�|jd��jt
ju|j�t
juk(sJ�tj|jd��|�tj|jd��|�y)Nrrr?r;)
rrrr�rr�r<r�rIrM)r�rW�expected_dt_seriess   r!�*test_min_max_dt64_api_consistency_with_NaTzBTestDataFrameReductions.test_min_max_dt64_api_consistency_with_NaT]s���
��[��_�-�
.��#�K��O�4�����A��� � �B�F�F�*�0B�0F�0F�0H�B�F�F�0R�S�S�S����A��� � �B�F�F�*�0B�0F�0F�0H�B�F�F�0R�S�S�S�	���r�v�v�1�v�~�/A�B�
���r�v�v�1�v�~�/A�Br#c�,�tdgi�}tgt��}tj|jd��j�tj|j��k(sJ�tj|jd��j�tj|j��k(sJ�tj|jd��|�tj|jd��|�y)Nrrerr?r;)
rrr�r'r�r�rr�rIrM)r�rW�expected_float_seriess   r!�*test_min_max_dt64_api_consistency_empty_dfzBTestDataFrameReductions.test_min_max_dt64_api_consistency_empty_dfls�����R�y�
!�� &�r�� 7���x�x����A���(�(�)�R�X�X�6K�6O�6O�6Q�-R�R�R�R��x�x����A���(�(�)�R�X�X�6K�6O�6O�6Q�-R�R�R�R�
���r�v�v�1�v�~�/D�E�
���r�v�v�1�v�~�/D�Er#�initialz2018-10-08 13:36:45+00:00z2018-10-08 13:36:45+03:00r�r�r�c��t|�}t|g�}t|g�}t||�d��}t	j
||�y)Nr;r?)rrrrHrIrM)r�r^r��
initial_dtr[rWrXs       r!�test_preserve_timezonez.TestDataFrameReductions.test_preserve_timezonexsI��!��)�
��:�,�'��
��z�
"��$���V�$�!�,��
���v�x�0r#c��tdd��}tttjtj|g�ttj||g�d��}t||�}|d|��}|rttj||g�}n*ttjtj|g�}t
j||�y)Nz
1900-01-01T)�utcr�r;r8)rrrr�r<rHrIrM)r�r�r:rrWr�rXr[s        r!�!test_minmax_tzaware_skipna_axis_1z9TestDataFrameReductions.test_minmax_tzaware_skipna_axis_1�s����,�D�1��
��"�&�&�"�&�&�#�.�/�f�b�f�f�c�3�=O�6P�Q�
���R��
 ����6�*����r�v�v�s�C�0�1�H��r�v�v�r�v�v�s�3�4�H�
���v�x�0r#c
�R�ttddg�ttdd�tdd�g�d��}|jd��}tddgd	d
g��}t	j
||�|jd��}tddg��}t	j
||�y)
Nrr�r;�ms)r3�tr?FTr3rg)rrFr)rrrr�rIrMr[s    r!�test_frame_any_with_timedeltaz5TestDataFrameReductions.test_frame_any_with_timedelta�s���
��Q��F�^��\�!�S�1�<��4�3H�I�J�
�
�����Q������t�}�S�#�J�?��
���v�x�0����Q������t�}�-��
���v�x�0r#c�
�|dk(r/|jtjjd���|gd��}d}tjt
|��5t
||�d��ddd�y#1swYyxYw)Nr�zCount does not accept skipnar�rzAFor argument "skipna" expected type bool, received type NoneType.rCry)r�rOr�r�rPrQrH)r�r��frame_or_seriesr��objr�s      r!�"test_reductions_skipna_none_raisesz:TestDataFrameReductions.test_reductions_skipna_none_raises�su���W�$�������!�!�)G�!�H�
��i�(��Q��
�]�]�:�S�
1�	6�(�G�C��(��5�	6�	6�	6�s�A9�9Bc��tttd�gd��ttd�gd��d��}|j�}ttd�td�gdddg�	�}t	j
||�y)
Nz
2019-12-31z
datetime64[s]rez2019-12-31 00:00:00.123zdatetime64[ms]r�r3r/r�)rrrr�rIrMr[s    r!�&test_reduction_timestamp_smallest_unitz>TestDataFrameReductions.test_reduction_timestamp_smallest_unit�s�����Y�|�4�5�_�M���8�9�:�BR��
�
��������
�|�
$�i�0I�&J�K�"���*�
��
	���v�x�0r#c�X�tttjd�gd��ttjd�gd��d��}|j	�}ttjd�tjd�gdddg��}tj||�y)	Nr5ztimedelta64[s]reztimedelta64[ms]r�r3r/r�)rrr�rqr�rIrMr[s    r!�&test_reduction_timedelta_smallest_unitz>TestDataFrameReductions.test_reduction_timedelta_smallest_unit�s�����R�\�\�(�3�4�<L�M��R�\�\�(�3�4�<M�N�
�
��������
�\�\�(�
#�R�\�\�(�%;�<�#���*�
��
	���v�x�0r#N)r3rHrIrSrWrZr]rOr�rJr�rardrhrlrL�skip_array_manager_invalid_testrn�&skip_array_manager_not_yet_implementedrpr,r#r!rPrP's���)�..�<
C�
F��[�[����	$�&A�B���[�[���X��u�~�6�1�c�1�7�	�
1��[�[���X��u�~�6�1�7�1�1�"
6��'�'�1�(�1�$�.�.�1�/�1r#rPc��eZdZejjdddg�d��Zd�Zejjdddg�d��Zy	)
�TestNuisanceColumnsr�r�rnc���tddgdd��}|j�}tjtd��5t||��ddd�tjtd��5tt|�|�ddd�tjtd��5t||�d�	�ddd�tjtd��5t||�d�	�ddd�tjtd��5tt|�|d�
�ddd�y#1swY��xYw#1swY��xYw#1swY��xYw#1swY�jxYw#1swYyxYw)Nrr;r,r)rGr�does not support reductionrCFrr?)r�to_framerOrPr�rHr')r�r��serrWs    r!�.test_any_all_categorical_dtype_nuisance_columnzBTestNuisanceColumns.test_any_all_categorical_dtype_nuisance_column�s9���a��V�:�C�8��
�\�\�^���]�]�9�,H�
I�	#� �G�C�� �"�	#��]�]�9�,H�
I�	%��G�B����$�	%��]�]�9�,H�
I�	1��G�B���%�0�	1��]�]�9�,H�
I�	0��G�B���$�/�	0��]�]�9�,H�
I�	,��G�B�����+�	,�	,�	#�	#��	%�	%��	1�	1��	0�	0��	,�	,�s;�D;�1E�+E�"E�E+�;E�E�E�E(�+E4c��tdtgd��i�}|d}tjtd��5|j�ddd�tjtd��5|jd��ddd�tjtd��5|j�ddd�|dj
t�|d<tjtd��5|jd��ddd�tjtd��5|j�ddd�y#1swY��xYw#1swY��xYw#1swY��xYw#1swY�bxYw#1swYyxYw)Nr)r;r0r0r0r�rvrCFr�r)rr
rOrPr�r�r�r�)r�rWrxs   r!�-test_median_categorical_dtype_nuisance_columnzATestNuisanceColumns.test_median_categorical_dtype_nuisance_column�s/��
��[��9�:�
;����g���]�]�9�,H�
I�	��J�J�L�	��]�]�9�,H�
I�	*��I�I�5�I�)�	*��]�]�9�,H�
I�	��I�I�K�	��S�'�.�.��%��3��
�]�]�9�,H�
I�	*��I�I�5�I�)�	*��]�]�9�,H�
I�	��I�I�K�	�	�	�	��	*�	*��	�	��	*�	*��	�	�s;�E�-E�#E�2E&�(E2�E�E�E#�&E/�2E;r�r�c�N�tgd�d��}t|�}|jd�}tjt
d��5t
||��ddd�tjt
d��5t
t|�|�ddd�tjt
d��5t
||�d��ddd�tjt
d��5t
||��ddd�tjt
d��5t
t|�|d�	�ddd�|djt�|d
<tjt
d��5t
||��ddd�tjt
d��5t
t|�|d�	�ddd�y#1swY��yxYw#1swY��LxYw#1swY��"xYw#1swY��xYw#1swY��xYw#1swY��xYw#1swYyxYw)N)r3r/r�r/F)�orderedrzis not ordered for operationrCr�rr?r)
r
rrwrOrPr�rHr'r�rr)r�r��catrxrWs     r!�:test_min_max_categorical_dtype_non_ordered_nuisance_columnzNTestNuisanceColumns.test_min_max_categorical_dtype_non_ordered_nuisance_columns����.��>���S�k��
�\�\�#�
���]�]�9�,J�
K�	#� �G�C�� �"�	#��]�]�9�,J�
K�	%��G�B����$�	%��]�]�9�,J�
K�	4��G�B���U�3�	4��]�]�9�,J�
K�	"��G�B���!�	"��]�]�9�,J�
K�	,��G�B�����+�	,��S�'�.�.��(��3��
�]�]�9�,J�
K�	"��G�B���!�	"��]�]�9�,J�
K�	,��G�B�����+�	,�	,�)	#�	#��	%�	%��	4�	4��	"�	"��	,�	,��
	"�	"��	,�	,�sT�G�<G�6G*�-G7�"H�9H�.H�G�G'�*G4�7H�H�H�H$N)	r3rHrIrOr�rJryr{rr,r#r!rtrt�sW���[�[���X��u�~�6�,�7�,�*�6�[�[���X��u�~�6�,�7�,r#rtc��eZdZejjddejdejfdejdejfdejdejfdejdejfdejdejfdejdejfdejdejfdejdejfdejdejfdejdejfdejdejfg�d��Zejjddejejfdejejfdejejfdejejfdejejfdejejfdejejfdejejfdejejfdejejfdejejfg�d��Zejjddd	derd
ndfdd	derd
ndfdd	derd
ndfdd
ddderdndfddderdndfdddddg�d��Zejjddd	erd
ndfdd	erd
ndfdddderdndfdderdndfdddddg�d��Zy) �TestEmptyDataFrameReductionsz#opname, dtype, exp_value, exp_dtyper@rrAr;c��tggd�|��}t||�d��}t||g|��}tj||�y�N�rr;rerr�r��r�rRrG�	exp_value�	exp_dtyperWrXr[s        r!�test_df_empty_min_count_0z6TestEmptyDataFrameReductions.test_df_empty_min_count_0)sH��"�2�"�~�U�
3��$���V�$�q�1���9�i�0�	�B��
���v�x�0r#zopname, dtype, exp_dtypec���tggd�|��}t||�d��}ttjtjg|��}tj||�y�Nr�rer;r�)rrHrr'r(rIrM�r�rRrGr�rWrXr[s       r!�test_df_empty_min_count_1z6TestEmptyDataFrameReductions.test_df_empty_min_count_1@sP��"�2�"�~�U�
3��$���V�$�q�1���2�6�6�2�6�6�*�)�<��
���v�x�0r#�Int8�Int32r�)r@r�rr�)rAr�r;r��UInt8�UInt32�UInt64)r@r�rr�)rAr�r;r�)r@�Float32rr�)rAr�r;r�)r@r�rr�c��tggd�|��}t||�d��}t||g|��}tj||�yr�r�r�s        r!�"test_df_empty_nullable_min_count_0z?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_0WsH��$�2�"�~�U�
3��$���V�$�q�1���9�i�0�	�B��
���v�x�0r#)r@r�r�)rAr�r�)r@r�r�)rAr�r�)r@r�r�)rAr�r�)r@r�r�c���tggd�|��}t||�d��}ttjtjg|��}tj||�yr�)rrHrr��NArIrMr�s       r!�"test_df_empty_nullable_min_count_1z?TestEmptyDataFrameReductions.test_df_empty_nullable_min_count_1qsO��"�2�"�~�U�
3��$���V�$�q�1���2�5�5�"�%�%�.�	�:��
���v�x�0r#N)r3rHrIrOr�rJr'�int8rJ�int_�uint8�uint64�uintr�r�r�r��is_windows_np2_or_is32r��is_windows_or_is32r�r,r#r!r�r�(s	���[�[���-�
�B�G�G�Q����)�
�R�W�W�a����)�
�B�H�H�a����*�
�R�X�X�q�"�(�(�+�
�B�H�H�a����+�
�R�X�X�q�"�'�'�*�
�B�I�I�q�"�)�)�,�
�R�Y�Y��2�9�9�-�
�B�J�J��2�:�:�.�
�R�Z�Z��B�J�J�/�
�B�J�J��2�:�:�.�	
�� 1�!� 1��[�[���"�
�B�G�G�R�Z�Z�(�
�R�W�W�b�j�j�)�
�B�H�H�b�j�j�)�
�R�X�X�r�z�z�*�
�B�H�H�b�j�j�)�
�R�X�X�r�z�z�*�
�B�I�I�r�z�z�*�
�R�Y�Y��
�
�+�
�B�J�J��
�
�+�
�R�Z�Z����,�
�B�J�J��
�
�+�	
�� 1�!� 1��[�[���-�
�F�A�+A��w�P�
�V�Q�,B���Q�
�V�Q�,B���Q�(�)�
�G�Q�-C���S�
�W�a�.D�(�(�T�*�+�,�-�,�
	
��"1�#�"1��[�[���"�
�F�(:�W��I�
�V�);�g��J�%�&�
�G�*<�h�(�L�
�W�+=�x�8�M�'�(�)�*�)�	
�� 1�!� 1r#r�c��|r1tjjd��}|j|�t	j
d�j
tj�jd�jdd�}d|d<t|�}|j|jk(j�sJ�|jd	�
�}tt!j"d��t j$gd�
�}t'j(||�|jdd	��}t'j(||�|jdd	��}tt!j"d��t!j"d��t!j"d��t j$gd�
�}t'j(||�y)Nz3Incorrect type inference on NaT in reduction resultr�r:zm8[s]rdr0�Nat)rereFryr1rdrerr8r;rjr;)rOr�r�r�r'rKr�rJ�view�reshaperr2rGrnr@rr�rqr<rIrM)r�r�r�r$rWrXr[s       r!�!test_sum_timedelta64_skipna_falser��sY����{�{� � �H�!�
��	���D�!�
�)�)�A�,�
�
�b�h�h�
'�
,�
,�W�
5�
=�
=�a��
C�C��C��K�	�3��B��I�I����"�'�'�)�)�)�
�V�V�5�V�
!�F��r�|�|�B�/����8��H�H����6�8�,�
�V�V��5�V�
)�F����6�8�,�
�V�V��5�V�
)�F���L�L��#��L�L��#��L�L��#��F�F�		
���H����6�8�,r#z#sum doesn't work with arrow stringsr�c���tddggtd���}|jddi�}|j�}t	ddgddg��}tj||�y)Nr3r;�abr�r/r�r)rrsr�r@rrIrM)rWrXr[s   r!�!test_mixed_frame_with_integer_sumr��s[��

�S�!�H�:�t�D�z�	2�B�	���C��>�	"�B�
�V�V�X�F��s�A�h�s�C�j�1�H����6�8�,r#r�)TFNr�r�r�c�L�tjd�}t|jd|jgtj���}td|i�}t||�|��}tt||�gdtdg���}tj||�y)NrJrer�r�r�)r'�iinforr�r�r��
Int64DtyperrHrrIrM)r�r��
int64_inforxrWrXr[s       r!�test_minmax_extensionarrayr��s������'�"�J�
�*�.�.�$�
���7�r�}�}��
O�C�	�G�S�>�	"�B�
 �W�R��
 �l�
;�F��	��V�	$�%���W�I���H�
���6�8�,r#�ts_valuez
2000-01-01c��tdgdgdg|gd��}tjtd��5|j	�ddd�y#1swYyxYw)Nr;g�������?r�r�rvrC)rrOrPr�r@)r�rWs  r!�.test_frame_mixed_numeric_object_with_timestampr��sL��
�!��C�5��w�h�Z�H�	I�B�	���y�(D�	E��
�������s�A
�
Ac�H�tgd��}|jddd��}tdgt��}t	j
||�t
jd�}tjt|�	�5|jddd��ddd�y#1swYyxYw)
N)r;r3Trr;F)r9r�r�r3rez2unsupported operand type(s) for +: 'int' and 'str'rC)rrArrrrIrMr��escaperOrPr�r@)rWrXr[r�s    r!�$test_prod_sum_min_count_mixed_objectr��s���	�>�	"�B�
�W�W�!�q�u�W�
=�F��s�e�6�*�H����6�8�,�
�)�)�H�
I�C�	���y��	,�8�
���A����7�8�8�8�s�:B�B!)r�r�r�r�r�r�rGr�r�c��ttjjd�j	d�|��}t||�d|��}|j
tj��}|dvrHtjd�}|dk(rd}t||�|d	d�
�}tj||�ytt|�|d��}||k(sJ�y)Nr0)rdrdrer�>r�r�r�r�r�F)r�r9r?)rr'rzr{r|rH�to_numpyr�rOr�rIr)r�r�rGrWrX�np_arr�comp_modr[s        r!�'test_reduction_axis_none_returns_scalarr��s���
�2�9�9�(�(��+�;�;�F�C�5�	Q�B�
 �W�R��
 �d��
F�F�
�[�[�r�z�z�[�
*�F�
�!�!��&�&�}�5���V���F�,�7�8�V�,�V�%�d�K��
���v�x�0�&�7�2�v�&�v�D�9����!�!�!r#�kernel)�corr�corrwith�covr�r�r�r�r�r�r�rA�quantiler�r�r�r@r�c��tgd�td��}|dk(r|fnd}djgd��}|dk(rd}d	}dj||g�}tjt
|�
�5t
||�|�ddd�y#1swYyxYw)Nrr�r�r,r�)znot allowed for this dtypez%argument must be a string or a numberz"not supported between instances ofr�z*argument must be a string or a real numberr�zTCannot convert \[\[<class 'object'> <class 'object'> <class 'object'>\]\] to numericzPCannot convert \[<class 'object'> <class 'object'> <class 'object'>\] to numericrC)rrrr�rOrPr�rH)r�rW�argsr��msg1r�s      r!�test_fails_on_non_numericr��s���0
���0�	1�B��j�(�B�5�b�D�

�(�(�	
��C����
/�	
�

-�	
��h�h��d�|�$��	���y��	,�#����F��T�"�#�#�#�s�)B�B)rnr�r�r�r�r�r�r�r�r�r�r�rAr�r�r�r�r@r�r�r0c	��ttgd�|��tddtjdg|��d��}tgd�dd	tj
d
gd��}|dvrd}n!|d
vrd}n|dvr|j
d�sd}n|}i}|dvr||d<|dvr||d<d}d}	|s|dvrt}d|�d�}	tj||	��5t||�dddi|��}
ddd�tj||	��5t||�dddi|��}ddd�|dvrj|�}tj
�y#1swY�ixYw#1swY�AxYw)Nr>rerr;r�r�)r�r�r�r�r�r�r�r�rJ)rnr��boolean)r�r�r�r�r�r�r�r��Floatr�)r�r�r�r:)rAr�r@r�)r�r�zThe behavior of DataFrame.z with all-NA valuesrCr9r,)
rrr�r�r'r(�
startswithr�rIrJrHr�rM)r�r:r��any_numeric_ea_dtyperW�expected_dfr�r�r�r�rXr[s            r!�test_numeric_ea_axis_1r�#s���6
���,@�A���A�r�u�u�a�(�0D�E�	
�
�B��%��s�B�F�F�C�(�	
��K��%�%� ��	�>�	!�"��	�	�	
�#�-�-�g�6�"��-��
�F�
�5�5�!��x��
�+�+�'��{���D�
�C��f� 4�4���*�6�(�2E�F��	�	#�	#�D��	4�7�$���V�$�6�!�6�v�6��7�	�	#�	#�D��	4�B�/�7�;��/�A�Q�A�&�A��B�
�)�)��?�?�>�2�����6�8�,�
7�7��B�B�s�E�8E
�E
�
Er)TTFg�h㈵��>g:�0�yE>N)B�datetimer�decimalrr��dateutil.tzr�numpyr'rO�pandas._configr�
pandas.compatrr�pandas.compat.numpyr	�pandas.util._test_decorators�util�_test_decoratorsrL�pandasr�r
rrr
rrrrrrrrrr�pandas._testing�_testingrI�pandas.corerrr�r�r-ra�fixturerwr}rrPrtr�r�r�r�r�rJr�r<r�r�r�r�r�r,r#r!�<module>r�s�����	���
�5��/�)�)������ ��
.�/�F��4F�S�t�8��(�*�6�$�h���H���	
�	
��k1�\������(������"B/�B/�J*l1�l1�^O,�O,�d^1�^1�B-�D������ �)N���-��-�������)<�=�������E�5�>�2�-�3�>�-�������i��&=�r�v�v�%F�G��H��
8�������#S�T�������$���7�������9�i�"8�9�"�:�8�U�"�$��������,#�-�,#�8��������0������q�!�f�-�1-�.�1�21-r#

Youez - 2016 - github.com/yon3zu
LinuXploit