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/groupby/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

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

/	�g����ddlZddlZddlmZddlZddlZddlm	Z	ddl
mZddlm
Z
ddlZddlmZmZmZmZmZmZddlmZddlmZej8j;dd	d
g�ej8j;dgd�gd
�gd�gd�gd�gd�gd�gd�gd�gd�gd�gd�ej<ej<ej<gg
�d���Zd�Z ej8j;dd	d
g�d��Z!ej8j;dd	d
g�ej8j;dgd�gd�ejDejDejDgdejDdgdejDdgdejDdgg�d���Z#ej8j;d d!d"ejHdge%�#�ejHejDgd$�#�fd%d!ejHejDgd$�#�ejHdge%�#�fd%d%ejHejDgd$�#�ejHejDgd$�#�fd"d$ejHejDgd$�#�ejHejDgd$�#�fg�d&��Z&ej8j;dd	d
g�ej8j;d'gd(��d)���Z'ej8j;d*d	ejDej<gdfd	ejDd+ej<gdfd
ejDejPgdfd
ejDdejPgdfg�d,��Z)ej8j;dd	d
g�d-��Z*ej8j;dd	d
g�d.��Z+ej8j;d/d0d1g�d2��Z,ej8j;d/d0d1g�d3��Z-ej8j;d4d0dd5gd+d6gd+d5gd7�fd1d+d6gdd5gdd6gd7�fg�ej8j;d8ddg�d9���Z.ej8j;ded:�ed;�fd<g�ej8j;d=gd>��d?���Z/ej8j;d/d@dAg�dB��Z0dC�Z1dD�Z2dE�Z3dF�Z4dG�Z5dH�Z6dI�Z7dJ�Z8dK�Z9dL�Z:ej8j;dMdNdOg�dP��Z;ej8j;dMdNdOg�dQ��Z<dR�Z=ej8j;dMdNdOg�dMe>fdS��Z?ej8j;d'gdT��dU��Z@dV�ZAej8j;dMgdW��dX��ZBej8j;dMdNdOg�dY��ZCdZ�ZDej8j�ej8j;d[ddg�ej8j;d\ddg�ej8j;d]ddg�ej8j;d^ddg�ej8j;d_d`gd`dagg�db�������ZFdc�ZGdd�ZHde�ZIdf�ZJej8j;dggdh�edi�ejPedi�gded+gej�djgdk�l�d�m�fgdh�ej�dnd+d+�ejPej�dnd+d+�gded+gej�djgdk�l�d�m�fgdo�ej�dnd+d+�ejPej�dnd+d+�ejPej�dnd+d+�gded5d5gej�djdpgdk�l�d�m�fgdq�ej�dnd+d+�ejPej�dnd+d+�ejPej�dnd+d+�gded5d+gej�djdpgdk�l�d�m�fg�dr��ZMds�ZNdt�ZOdu�ZPdv�ZQej8j;dwddxg�dy��ZRdz�ZSd{�ZTej8j;d'gd|��ej8j;d}d@d~d+d+d�d5d6d�gifdAd~d+d5d�d5d�d�gifdNd~d+d+d�d5d6d�gifdOd~d+d5d�d5d�d�gifd�d+d5d�d5d5d�gd�d��fg�d����ZUd��ZVej8j;d�d�ej�fd�ej�fd�ej�fd�ej�fd�ej�fd�ej�fdNej�fdOej�fd@d��fdAd��fd�ej�fej�d�eVej�d�����g�d���Zbej8j;d�gd��d+ejDd5d+ejDd5d+ejDd5g	d�gd��gd��d�g�ej8j;d�gd���d����Zcej8j;d�gd���ej8j;d�dd+g�ej8j;d�ddg�ej8j;d[ddg�d������Zdd��Zey)��N)�ascii_lowercase)�iNaT)�pandas_dtype)�na_value_for_dtype)�	DataFrame�
MultiIndex�Series�	Timestamp�
date_range�isna)�_test_decorators�agg_func�any�all�vals)�foo�bar�baz)r�r)rrr����)rrr�rrr)��?�@�@)r�r)rrr)TTT)TFF)FFFc�f�tdgdzdgdzz|dzd��}tt|�|�}|rtt	|��r|dk(rd}t|gdzdgtjddgd	�
���}t|jd	�|�|��}tj||�y)
N�ar�br)�key�valrFr#r"��name��columns�index��skipna)
r�getattr�builtinsrr�pd�Index�groupby�tm�assert_frame_equal)r*rr�df�exp�expected�results       �FC:\Python312\Lib\site-packages\pandas/tests/groupby/test_reductions.py�test_groupby_bool_aggsr7s���(
�C�5�1�9��u�q�y�0����B�	C�B�&�'�(�H�
%�d�
+�C��#�d�4�j�/�h�%�&7����	���	�E�7�"�(�(�C��:�E�*J��H�2�W�R�Z�Z��&��
1��
@�F����&�(�+�c�,�tgd�dtjdgdtjdgggd���}tddgd	dggd
dgddg��}d
|j_|jd
�j
�}tj||�y)N)rrrrrrr��A�B�C�r'TFr<r=r&r;)	r�np�nanr(r%r/rr0r1�r2r4r5s   r6�test_anyrB>s���	�	��B�F�F�E�*�Q�����,>�?��
�B��
����t�}�%��S�z�!�Q���H��H�N�N��
�Z�Z��_�
 �
 �
"�F����&�(�+r8�
bool_agg_funcc���tddggddg��}|jdg�}t||��}|jt	j
dg��}t
j||�y)NTr r>r)rr/r+�set_axisr?�arrayr0r1)rCr2�grp_byr5r4s     r6� test_bool_aggs_dup_column_labelsrHKsb��
�T�4�L�>�C��:�	6�B�
�Z�Z���_�F�
+�W�V�]�
+�
-�F��{�{�2�8�8�Q�C�=�)�H����&�(�+r8�dataFTc��t|d��}t||�|��}t|tjdg�d��}|j	gd��j||��}t
j||�y)N�boolean��dtyper)r�r(rMr)r	r+r?rFr/�aggr0�assert_series_equal)rCr*rI�ser�
expected_datar4r5s       r6�test_masked_kleene_logicrSVsk����Y�
'�C�0�G�C��/�v�>�M��m�2�8�8�Q�C�=�	�J�H�
�[�[��
#�
'�
'�
�f�
'�
E�F����6�8�,r8zdtype1,dtype2,exp_col1,exp_col2�float�Float64rLrK�Int64c�T�dtjg}ttj||��tj||��d��}|jddg�j
dd��}t||d�tjdg���}tj||�y)	NrrL)�col1�col2rrFr)�r()	r?r@rr-rFr/rOr0r1)�dtype1�dtype2�exp_col1�exp_col2rIr2r5r4s        r6�test_masked_mixed_typesr_os���>
����=�D�	����$�f�-�r�x�x��F�7S�T�
�B��Z�Z��A��
�
#�
#�E�%�
#�
8�F��(�H�=�R�X�X�q�c�]�S�H����&�(�+r8rM)rVrUrKc��|tjdg|��}d}|s|dk(rtj}||gtjdg�d��}|j	ddg�j||��}t
j||�y)NrrLTrrKrNr))r-�NAr?rFr/rOr0�assert_equal)rCrMr*�frame_or_series�obj�expected_resr4r5s        r6�test_masked_bool_aggs_skipnarf�sz���2�5�5�!�*�E�
2�C��L��m�u�,��u�u����~�R�X�X�q�c�]�)�T�H�
�[�[�!�Q��
 �
$�
$�]�6�
$�
B�F��O�O�F�H�%r8zbool_agg_func,data,expected_resrc���||t��}|jdgt|�z�j|�}||gt	j
dg�d��}t
j||�y)NrLr�boolrN)�objectr/�lenrOr?rFr0rb)rCrIrercrdr5r4s       r6�test_object_type_missing_valsrk�s[���$�f�
-�C�
�[�[�!��s�4�y��
)�
-�
-�m�
<�F���~�R�X�X�q�c�]�&�Q�H��O�O�F�H�%r8c���ttjgt��}t	j
td��5|jdg�j|d��ddd�y#1swYyxYw)NrLz boolean value of NA is ambiguous��matchrFr))	r	r-rari�pytest�raises�	TypeErrorr/rO)rCrQs  r6�'test_object_NA_raises_with_skipna_falserr�sX���"�%�%���
'�C�	���y�(J�	K�:����Q�C����]�5��9�:�:�:�s�$A)�)A2c���|turddginddi}|di|�dti��}t|j|j�|��}|di|�dt
i��}t
j||�y)Nr'r r%rM�)rrir+r/r(rhr0rb)rcrC�kwargsrdr5r4s      r6�
test_emptyrv�sm��$3�i�#?�i�#��
�f�c�]�F�
�
1�F�
1�&�
1�C�
;�W�S�[�[����+�]�
;�
=�F��4��4�t�4�H��O�O�F�H�%r8�how�idxmin�idxmaxc��|tus|turyd|vrtjntj}||�j
}||�j}tgd�||||gd�|��}|jd�}t||��}tdddgitjdd	gd|�
���}tj||�y)N�int)rrrr�r r!rLr r!rrr�r%rMrZ)r{rTr?�iinfo�finfo�min�maxrr/r+r-r.r0r1)	rw�any_real_numpy_dtype�info�	min_value�	max_valuer2�gbr5r4s	         r6�test_idxmin_idxmax_extremesr��s����s�"�&:�e�&C��� 4�4�2�8�8�"�(�(�D��)�*�.�.�I��)�*�.�.�I�	��)�Y�	�9�!M�N�"�
�B�
���C��B�
�W�R��
�
�F��	�q�!�f�
�R�X�X�q�!�f�3�>R�S��H����&�(�+r8c�\�tj|�j}tj|�j}t	ttjtdd�d��d��ttj|tj||tj|tjtjtjg
|��d��}|jd�}|rdnt}d	|�d
�}tj||��5t||�|��}	ddd�|rdd
ddtjg}
ntj}
t	d|
itjtdd�dd����}tj 	|�y#1swY�wxYw)Nr�r)�repeats�intprLr|r z!The behavior of DataFrameGroupBy.z with all-NA valuesrmr)r�r!r}rZ)r?rr�r�rr	�repeat�ranger@r/�
FutureWarningr0�assert_produces_warningr+r-r.r1)r*rw�float_numpy_dtyper�r�r2r��warn�msgr5�valuesr4s            r6�"test_idxmin_idxmax_extremes_skipnar��sW�����*�+�/�/�I����*�+�/�/�I�	���	�	�%��1�+�q�9��H���F�F���F�F����F�F���F�F��F�F��F�F��(��	
�
�B�(
���C��B��4�}�D�-�c�U�2E�
F�C�	�	#�	#�D��	4�1�!���S�!��0��1�
��Q��1�b�f�f�%�������	�f�
�R�X�X�e�A�q�k��6�J��H����&�(�+�1�1�s�F"�"F+zfunc, valuesrr)�c_int�c_float�c_date�numeric_onlyc��tgd�gd�gd�gd�d��}tj|d�|d<|djj	d�|d<|d|dj
d	z
|d
<|djj
d�|d<|d
jd�|d<|djd�|d<t|jd�|�|��}t|tjddgd����}|r|jdg��}n|d|d<|d|d
<|d|d<|d
|d<|d|d<tj||�y)N�r;r;r<r<�rrrr�)g�G�z@g=
ףp=@gR���Q@g�������?)�2019�2018�2016�2017)r%r�r�r�r�z
US/Pacific�	c_date_tzr�c_timedelta�W�c_periodr�rV�	c_Integerr�rU�
c_Floatingr%�r�r;r<r$rZr>)rr-�to_datetime�dt�tz_localize�iloc�	to_period�astyper+r/r.�dropr0r1)�funcr�r�r2r5r4s      r6�$test_idxmin_idxmax_returns_int_typesr�si��
�(�!�/�6�		
�
�B��>�>�"�X�,�/�B�x�L���l�o�o�1�1�,�?�B�{�O��8��r�(�|�'8�'8��';�;�B�}����\�_�_�.�.�s�3�B�z�N���k�(�(��1�B�{�O��)�}�+�+�I�6�B�|��
.�W�R�Z�Z��'��
.�L�
I�F���r�x�x��c�
��'H�I�H���=�=�(��=�4�� (�� 2����"*�8�"4����'��1����$�W�-�H�[��%�i�0�H�\�����&�(�+r8z2011-01-15 12:50:28.502376z2011-01-20 12:50:28.593448)l m;-L�l m;-L��method)�countr�r��first�lastc�D�tddg|d��}|jd�}t||��}|dk(rd}n*|dk(r|d}n|dk(r|d}nt|d	|��}td	|gitjdgd�
���}tj||�y)Nrr|r r�rr�rr�r!r$rZ)rr/r+r-r.r0r1)r�rIr2�groupedr5�expected_valuer4s       r6�2test_groupby_non_arithmetic_agg_int_like_precisionr�/s���
�!�Q��d�+�	,�B��j�j��o�G�
%�W�W�f�
%�
'�F�
�����	�7�	��a���	�6�	��a���1���C��&�1�3���#��/�0����!��3�8O�P�H����&�(�+r8r�r�c
���tt|��}tgd�|d|dtjtjg|d|dtjtjgd�|��}|jd|��}t
||�}||��}gd	�gd
�gd�gd�d
�||f}	|j|	jd�}
|r|
j�}
tj||
�y)N)rrrrrrr�@�r r!�crLr )�sortr))rrr�)rrr�)rr�)rrr�))r�T)r�F)r�T)r�F)rrrr?r@r/r+r��	set_index�
sort_indexr0r1)�any_real_nullable_dtyper�r*rw�na_valuer2r�r�r5�ilocsr4s           r6�test_first_last_skipnar�Ms���"�,�/F�"G�H�H�	�#��C��3�������?��C��3�������?�	
�
&�

�B�
���C�d��	#�B�
�R��
�F�
�6�
"�F�#�#�!�"�	
�

�6�k�
�E��w�w�u�~�'�'��,�H���&�&�(�����&�(�+r8c�,�ttjjd�j	d�gd���}gd�|d<|jd�}d}t
jt|��5|jd	�
�}ddd�|jdd�d	d�fjd	�
�}jjd	�}t
j|||jd��tdd�
�|d<|jd�}d}t!j"t$|��5t
jt|��5|jd	�
�ddd�ddd�y#1swY��xYw#1swY�xYw#1swYyxYw)Nr)�
r�)r;r<r=�Dr>)
rrrrrrrrrr�r;z1DataFrameGroupBy.idxmax with axis=1 is deprecatedrmr��axisz
2016-01-01r���periods�Ez>'>' not supported between instances of 'Timestamp' and 'float')rr?�random�default_rng�standard_normalr/r0r�r�ryr�r(�get_level_valuesrP�	droplevelrrorprq)r2r��warn_msg�res�alt�indexer�gb2r�s        r6�test_idxmin_idxmax_axis1r�isO��	�
�	�	���a� �0�0��9�CW�
�B�-�B�s�G�	���C��B�B�H�	�	#�	#�M��	B� ��i�i�Q�i��� �
�'�'�!�Q�R�%�.�
�
�Q�
�
'�C��i�i�(�(��+�G����3�w�<����s�);�<���r�2�B�s�G�
�*�*�S�/�C�
J�C�	���y��	,��
�
'�
'�
�X�
F�	��J�J�A�J��	��� � ��	�	����s0�1E2�2F
�E>�!F
�2E;�>F	�F
�
Fc�|�tgd�gd�d��}|jd�dj�ddk(sJ�y)N)r;r;r;r;r;)iji�ioi`l@�~��)�user�connectionsr�r�r;l,f�L�)rr/�mean)r2s r6�test_groupby_mean_no_overflowr��sD��	�-�I�	
�
�B��:�:�f��m�,�1�1�3�C�8�<O�O�O�Or8c�F�ttjtd��ddgdzd��}|j	d�dj�}t
tjddg�dtjddgd�	��
�}tj||�y)Nr�r;r<r�)�time�catr�r�r�r$�r%r()
rr-�to_timedeltar�r/r�r	r.r0rP�r2r5r4s   r6�test_mean_on_timedeltar��s���	�B�O�O�E�"�I�6��S�z�A�~�N�	O�B�
�Z�Z��
�v�
&�
+�
+�
-�F��
����A���f�B�H�H�c�3�Z�e�4T��H����6�8�,r8c��tjjd�jd�}tj|ddd�<t|�}tjjd�j
ddd��jt�}tj|ddd�<|j|�j�}d}tjt|��5|j|�jtj�}ddd�tj |�ttjjd�jd	��}d}tjt|��5|j|�jtj�}ddd�|j|�j�}tj |�y#1swY��xYw#1swY�KxYw)
Nr��r�2��size�zusing DataFrameGroupBy.medianrm)r�r�)r?r�r�r�r@r�integersr�rTr/�medianr0r�r�rO�	nanmedianr1)�arrr2�labelsr5r�r3�rs�xps        r6�test_cython_medianr��s}��
�)�)�
�
��
"�
2�
2�4�
8�C��v�v�C��!��H�	�3��B�
�Y�Y�
"�
"�1�
%�
.�
.�q�"�4�
.�
@�
G�
G��
N�F��6�6�F�4�R�4�L�
�Z�Z��
�
&�
&�
(�F�
)�C�	�	#�	#�M��	=�3��j�j�� �$�$�R�\�\�2��3����&�#�&�	�2�9�9�(�(��+�;�;�I�F�	G�B�
)�C�	�	#�	#�M��	=�/�
�Z�Z��
�
#�
#�B�I�I�
.��/�	���F�	�	"�	"�	$�B����"�b�!�3�3��/�/�s�&/G4�/H�4G=�H	c�v�ttjjd�j	ddd��}tddd�}t
j|d|�}|j||��j�}|j||��jd��}tj||�y)	Nrr�,���7r���observedc�"�|j�S)N)r���xs r6�<lambda>z(test_median_empty_bins.<locals>.<lambda>�s������r8)
rr?r�r�r�r�r-�cutr/r�rOr0r1)r�r2�grps�binsr5r4s      r6�test_median_empty_binsr��s���	�2�9�9�(�(��+�4�4�Q��C�@�	A�B���B��?�D�
�6�6�"�Q�%���D�
�Z�Z��x�Z�
0�
7�
7�
9�F��z�z�$��z�2�6�6�7K�L�H����&�(�+r8c�b�tgd�gd�ddgzd��}|jd�j�}d|vsJ�|jd�jd�	�}d|vsJ�|jd�j�}d|vsJ�|jd�jd�	�}d|vsJ�y)
N)�r�rr�r��mama)�nn�ii�ssrrFr�)rr/r�r�)�aar5s  r6�test_max_min_non_numericr�s���	�*�,�a�6�(�l�S�	T�B�
�Z�Z��
�
!�
!�
#�F��6�>��>�
�Z�Z��
�
!�
!�u�
!�
5�F��6�>��>�
�Z�Z��
�
!�
!�
#�F��6�>��>�
�Z�Z��
�
!�
!�u�
!�
5�F��6�>��>r8c��tgd�gd�gd�d��}|j�|s$t|jj�dk(sJ�|jd�}|dgj
�}tjgd�d�	�}tdgd
�i|��}tj||�|dgj�}tjgd�d�	�}tdgd�i|��}tj||�y)
N)rrrrr)rrrrF)r r!r��d�er:rr;r=rr$)r!r
rrZ)r r�r)r�_consolidate_inplacerj�_mgr�blocksr/r�r-r.r0r1r�)�using_array_managerr2r�r5�eir4s      r6�$test_max_min_object_multiple_columnsr�s���

� �,�*�	
�
�B�������2�7�7�>�>�"�a�'�'�'�	���C��B�
���Y�]�]�_�F�	���)�#�	&�B��#��/�r�:�H����&�(�+�
���Y�]�]�_�F�	���)�#�	&�B��#��/�r�:�H����&�(�+r8c�L�tjtgd��d��jj}ttjdtjggd�|d��}|jdd�	�d
j�d
}tjtddgd
��d��jj}tj||�|jd�d
j�}d|j_
tj||�y)
N)�
2019-05-09rrz%Y-%m-%d)�format�1)rrrr�r!F��as_indexr�rr$)r-r�r	r��daterr?r@r/r�r0rPr(r%)�datesr2r5r4s    r6�test_min_date_with_nansr�s����N�N��9�:�:�
��b���
�
�"�&�&�#�r�v�v�.�Y�U�K�	L�B�
�Z�Z��e�Z�
,�S�
1�
5�
5�
7��
<�F��~�~���l�+�#�6�z���b���
����6�8�,�
�Z�Z��_�S�
!�
%�
%�
'�F��H�N�N�����6�8�,r8c�D�tdtg�}tjddgtj��}|j|�}|j
d��}tdditj��}tj||d��|jd��}tdtitj��}tj||d��|jd��}tdtji�}tj||d��y)NrrLr��	min_countT��check_exactr)r	rr?rF�int64r/r�r0rPr�r@)rQr"r�r5r4s     r6�
test_max_inatr!�s���
�!�T��
�C�
�(�(�A�q�6����
*�C�	���S�	�B�
�V�V�a�V�
 �F��q�!�f�B�H�H�-�H����6�8��>�
�V�V�a�V�
 �F��q�$�i�r�x�x�0�H����6�8��>��V�V�a�V�
 �F��q�"�&�&�k�"�H����6�8��>r8c�^�tdtdtdzg�}|jgd��}|jd��}ttj
tj
tdzd��}|jjt�|_tj||d��y)Nrr)rrrrrrTr)r	rr/r�r?r@r(r�r{r0rP)rQr�r5r4s    r6�test_max_inat_not_all_nar#s����!�T�1�d�Q�h�'�
(�C�	���\�	"�B�
�V�V�a�V�
 �F��"�&�&�R�V�V��q��9�:�H��^�^�*�*�3�/�H�N����6�8��>r8r�r�r�c��ddg}tjddd��}t||d��}t|j	d�d|��}tj
ddgd�	�}t
||d�
�}tj||�y)Nrr�2020�Y�r��freqr|r r!r$�r(r%)	r-�period_rangerr+r/r.r	r0rP�r��groupsr�r2r5�idxr4s       r6�$test_groupby_aggregate_period_columnr.s~����V�F��o�o�f�a�c�:�G�	��g�.�	/�B�
0�W�R�Z�Z��_�S�)�4�
0�
2�F�
�(�(�A�q�6��
$�C��g�S�s�3�H����6�8�,r8c��ddg}tjddd��}t||d��}t|j	d�|��}tj
ddgd��}td	|i|�
�}t
j||�y)Nrrr%r&r'r|r r$r!rZ)r-r*rr+r/r.r0r1r+s       r6�#test_groupby_aggregate_period_framer0+s{����V�F��o�o�f�a�c�:�G�	��g�.�	/�B�
+�W�R�Z�Z��_�d�
+�
-�F�
�(�(�A�q�6��
$�C��#�w��s�3�H����&�(�+r8c���tgd�td�tjgdzd��j	t
�}|j
d�j�}tddgdd	gtjtjgd��jd�j	t
�}tj||�tgd�td�td�d��j	t
�}|j
d�j�}tddgdd	gd
dgd��jd�j	t
�}tj||�y)Nr��abcdr�)r"rXrYr"r;r<r r�rr)r�listr?r@r�rir/r�r�r0r1r�r�s   r6�#test_aggregate_numeric_object_dtyper49s&��
�$�d�6�l�R�V�V�H�q�L�Q�
��f�V�n���Z�Z��
�
"�
"�
$�F���#�J��c�
�R�V�V�R�V�V�<L�M�	
�
��5�	�	����
����&�(�+�
�$�d�6�l�E�!�H�M�
��f�V�n���Z�Z��
�
"�
"�
$�F��3��*�s�C�j�1�a�&�I�J�	��5�	�	����
�
���&�(�+r8c�l�tdgd��jj�}tdg|d��}|j	d�jd|i�}tddgit
jdgd���	�}|dj|j�|d<tj||�y)
Nr!�categoryrLi��r;r<r;r<r$rZ)r	r��
as_orderedrr/rOr-r.r�rMr0r1)r��dsr2r5r4s     r6�%test_aggregate_categorical_lost_indexr:Ws���
���Z�	(�	,�	,�	7�	7�	9�B�	�$��b�)�	*�B�
�Z�Z��_�
 �
 �#�t��
-�F��#��u��R�X�X�t�f�3�-G�H�H��S�M�(�(����2�H�S�M����&�(�+r8)rV�Int32rU�Float32rKc�t�|dk(rd}n
|dk(rd}nd}tddg||dzgd��}|d	j|�|d	<|jd
�}|j�}|jddjd
�}t
j||�|j�}|jddjd
�}t
j||�|jd��}td	tjgi|j|�
�}	t
j||	�|jd��}
t
j|
|	�tgd�|tj|dzgd��}|d	j|�|d	<|jd
�}|j�}
t
j|
|�|j�}t
j||�|jd��}t
j||	�|jd��}t
j||	�y)NrVl�.�D��3rKrr�rr)�id�tsr?r>rrrN)rrr�d)rr�r/r�r�r�r0r1r�r-rar()rMr?r2r�r5r4�res_max�expected_max�result2�	expected2�res_max2�df2r��result3�res_max3�result4�res_max4s                 r6�test_groupby_min_max_nullablerKes������
 ��	�)�	�
��
��	�1�a�&��R�!�V��5�	6�B��$�x���u�%�B�t�H�	���D�	�B�
�V�V�X�F��w�w�r��{�$�$�T�*�H����&�(�+��f�f�h�G��7�7�1�2�;�(�(��.�L����'�<�0��f�f�q�f�!�G��4�"�%�%��/����u�M�I����'�9�-��v�v��v�"�H����(�I�.��9�R�����Q��,?�@�
A�C��D�	� � ��'�C��I�

�+�+�d�
�C��g�g�i�G����'�8�,��w�w�y�H����(�L�1��g�g��g�$�G����'�9�-��w�w��w�%�H����(�I�.r8c	�R�tjdgdzddg��}t|tjt	j
dtj���d��}|jdd�	�}|j�}tjddg|jd�
�}tdtjdtjgd��i|�
�}tj||�|j�}d|jd<tj||�y)Nrr�r)�
categoriesrLr7r;Fr��rMr%r<�UInt64rZ�	)rr)r-�CategoricalrrFr?�arange�uint64r/r��CategoricalIndexrMrar0r1r�r�)r�r2r�r�r-r4s      r6�(test_min_max_nullable_uint64_empty_grouprU�s���
�.�.�!��r��q�!�f�
5�C�	��2�8�8�B�I�I�b��	�	�,J�#K�L�	M�B�	���C�%��	(�B�
�&�&�(�C�
�
�
�q�!�f�C�I�I�C�
@�C��#�r�x�x��B�E�E�
�(�C�D�C�P�H����#�x�(�
�&�&�(�C��H�M�M�$�����#�x�(r8)r�r�r�r�c��ttjdgtd�d��tjdgddgd��dd��}t	|jd	d
��|��}tjddgd	d�
�}ttjddgddgd��ddgd�|��}tj||�y)Nr;�ABT)rM�orderedrrg�������?)rXrY�valuerXFr�r<)rIr%rX)rYrYrZ)	rr-rQr3r+r/rTr0r1)r�r2r5r-r4s     r6� test_groupby_min_max_categoricalrZ�s���
��N�N�C�5�T�$�Z��N��N�N�A�3�A�q�6�4�H��	
�
�B�?�W�R�Z�Z���Z�7��
>�
@�F�
�
�
�C��:�F�D�
I�C���N�N�A�t�9�!�Q���N��4�[�	
���H����&�(�+r8c	�(�tjd�d}tdgddd�|��jdd}t	|jd�|��}tddg|t
jg|d�	��
�}tj||�y)N�pyarrowzstring[pyarrow_numpy]r r�rLrr!r�rN)r'rMr()
ro�importorskiprr�r+r/r-r.r0r1)r�rMr2r5r4s     r6�test_min_empty_string_dtyper^�s������	�"�#�E�	�#��S�s�3�5�	A�	F�	F�r��	J�B�
+�W�R�Z�Z��_�d�
+�
-�F���c�
�%�r�x�x��%�c�/R��H����&�(�+r8c	�~�tgd�gd�ttjtjdg�gd�d��}|j	d�}|dgj�}|dj�j
�}tj||�|dj�j�rJ�y)N)z-04-23z-05-06z-05-07)z2013-04-23 00:00:00z2013-05-06 00:00:00z2013-05-07 00:00:00�OE)z
log080001.logzlog.log�xlsx)z
Unnamed: 0�Date�app�Filerbrd)rr	r?r@r/r��to_framer0r1rr)r2r��rrs    r6�test_max_nan_bugrg�s���	�8��
�2�6�6�2�6�6�4�0�1�8�		
�
�B�
���F�	�B�
�F�8�����A�
�6�
����!�!�#�A����!�Q����y�~�~��#�#�%�%�%�%r8r��dropnar�with_nan�keys�joe�jimc	��d}d}tdd��}ttjj	d�jt
t�|�tjj	d�j||�tjj	d�jd||�d��}|r{|jdti�}d|jd	dd
�df<d|jddd
�df<d|jddd�df<d|jddd�df<d|jddd�df<|j�}	|j|||��}
|
dj|��}|j|||��}
|
djt j|��}|s|j#d��}|rt%j&||d��nt%j(||d��t%j(||	�y)Nr@r�z
2015-08-23r�rr)rlrk�juliernrr�rlr�%rk���rP)rr��rhT)r�F)�check_names)rrr?r�r��choicer3rr�r�rT�loc�copyr/�nunique�applyr	�reset_indexr0rPr1)
r�rhrrirj�n�m�daysr2�original_df�gr�left�rights
             r6�test_series_groupby_nuniquer��s���	�A�
�A��l�B�/�D�	��9�9�(�(��+�2�2�4��3H�!�L��9�9�(�(��+�2�2�4��;��Y�Y�*�*�1�-�6�6�q�!�Q�?�	
�
�B��
�Y�Y���'�
(��#����q�u�"�u�e�|��#����q�u�"�u�e�|��!%����q�u�"�u�g�~��!%����q�u�"�u�g�~��!%����q�u�"�u�g�~���'�'�)�K�	���D�8�$��	7�B�
�g�;���f��-�D�	���D�8�$��	7�B��w�K���f�n�n�V��<�E���!�!�t�!�,���
���t�U��>�
���d�E�u�=����"�k�*r8c�N�ttd�td�td�d��}ttd�gd�gd�d��}|jdd	�
�j�}t	j
||�td�|_d|j_|jd��}|jd�j�}t	j
||�|jddi�jd�jd	�
�}t	j
||�tdgdzdgdzd�td���}d|j_|jddi�jd�j�}t	j
||�y)N�abbacc�abxacc�abbacxr:�abc)rrr)rrrr;Frr>r�rsrr)r<r=rZ)
rr3r/rxr0r1r(r%r��replacerAs   r6�test_nuniquer�sP��	��h��d�8�n�4��>�R�	S�B��t�E�{���K�L�H�
�Z�Z��e�Z�
,�
4�
4�
6�F����&�(�+��%�[�H�N��H�N�N���}�}�S�}�)�H�
�Z�Z��_�
$�
$�
&�F����&�(�+��Z�Z��d��
$�
,�
,�S�
1�
9�
9��
9�
G�F����&�(�+���s�Q�w�a�S�1�W�5�T�%�[�I�H��H�N�N��
�Z�Z��d��
$�
,�
,�S�
1�
9�
9�
;�F����&�(�+r8c�.�tgd�gd�gd�gd�gd�ggd���}|jdd	g�d
j�}tj|j
|jg�}tdgdzd
|�
�}tj||�y)N)r@r�Alice)��r�Bob)i,r�Charlie)ip���r��Dan)r�r��Edith)�amountr>r%r>r>r�r%rr�r�)
rr/rxr�from_arraysr>r�r	r0rP)rIr5r(r4s    r6�test_nunique_with_objectr�s���������	
�)�	�D��\�\�4��*�
+�F�
3�
;�
;�
=�F��"�"�D�G�G�T�[�[�#9�:�E��q�c�A�g�F�%�8�H����6�8�,r8c��tdt��}|jd��j�}tdd��}t	j
||�y)Nr%r}r��levelr )r	rir/rxr0rP)rIr5r4s   r6�test_nunique_with_empty_seriesr�2sC���v�V�,�D�
�\�\��\�
"�
*�
*�
,�F��6��1�H����6�8�,r8c��ttd�td�td�ggd�d��jd�}|jt	j
d���d	j
�}|jt	j
d���d	jtj�}tj||�y)
Nz2016-06-28 09:35:35z2016-06-28 16:09:30z2016-06-28 16:46:28)r�2�3)r�rIr��h)r(rI)rr
r�r/r-�Grouperrxryr	r0rP��testr5r4s   r6�test_nunique_with_timegrouperr�:s�����/�0��/�0��/�0��
$�
	
�	��i���	��\�\�"�*�*�#�.�
/��
7�
?�
?�
A�F��|�|�B�J�J�C�0�1�&�9�?�?����O�H����6�8�,r8zkey, data, dropna, expected)r�r�r�z
2019-01-01r�r"r$r)i�)r�r�r��yr�r�)r�r�r�r�r�c��t||d��}|jdg�dj|��}tj||�y)N)r"rIr"rIrs)rr/rxr0rP)r"rIrhr4r2r5s      r6�test_nunique_with_NaTr�KsG��V
�3��-�	.�B�
�Z�Z���
 ��
(�
0�
0��
0�
?�F����6�8�,r8c��tgd�tjdgd����}|jgd��j	�}tdgtjdg�|j�	�}tj||�y)
N)rrrr;�level_0r$r>rrr)r(r')
rr-r.r/rxr?rFr'r0r1r�s   r6�)test_nunique_preserves_column_level_namesr�{s`���Y����#��Y�(G�H�D�
�\�\�)�
$�
,�
,�
.�F��!��B�H�H�a�S�M�4�<�<�H�H����&�(�+r8c���ttdd�dg��}|jgd��djd�}t	gd�d��}tj||�y)	Nz
2008-12-31z
2009-01-02rr>)rrrrx)rrrr$)rrr/�	transformr	r0rPr�s   r6�$test_nunique_transform_with_datetimer��sQ��	�:�l�L�9�F�8�	L�B�
�Z�Z�	�
"�6�
*�
4�
4�Y�
?�F��i�f�-�H����6�8�,r8c��tdg�jd�}|dd}|j||��}|j�}|rtg|ddd��}ntdg|d��}t	j
||�y)Nrr6rr�r rN)r	r�r/rxr0rP)r�r�rQr�r5r4s      r6�test_empty_categoricalr��sw��
�!��+�
�
�Z�
(�C�

�b�q�'�C�	���S�8��	,�B�
�Z�Z�\�F���"�C���G�7�;���1�#�S��8�����6�8�,r8c� �tddtjdg�}|jgd��}d}t	j
t|��5|jtj�}ddd�d}t	j
t|��5|jtj�}ddd�|j�}t	j|�t	j|�y#1swY��xYw#1swY�RxYw)Nrrr)rrrrzusing SeriesGroupBy.sumrmzusing np.sum)r	r?r@r/r0r�r�rOr,�sumryrP)�sr�r�r5rCr4s      r6�test_intercept_builtin_sumr��s�����S�"�&�&�#�&�'�A��i�i��%�G�
#�C�	�	#�	#�M��	=�+����X�\�\�*��+��C�	�	#�	#�M��	=�.��-�-����-��.��{�{�}�H����6�8�,����7�H�-�+�+��.�.�s� C8� D�8D�D
rr�c	�B�d}d}tj}tj|||||||gd��}t	gd�|d��}|jd�j
|��}|d	k(rTt	d
tjgd�d��itjgd
�d����}tj||�yt	d
tjtjgdzd��itjgd
�d����}tj||�y)NTFrKrL)rrrrrrrr7r;rrr<)rrrrVrr$rZr)r?r@r-rFrr/r�r.r0r1ra)rr!r �na�dfgr2r5r4s        r6�!test_groupby_sum_mincount_booleanr��s����A�
�A�	���B�
�(�(�A�q�"�b�!�Q��*�)�
<�C�	�.�S�9�	:�B�
�Z�Z��_�
 �
 �9�
 �
5�F��A�~��
�"�(�(�9�G�4�5��(�(�9�3�/�
��	���f�h�/��
�"�(�(�B�E�E�7�Q�;�g�6�7��(�(�9�3�/�
��	���f�h�/r8c���tgd�gd�gd�d�d��}|jd�}tjgd�dd��}|dj	d�	�}ttjgd
zd|d��}tj||�|j	d�	�}ttjgd
ztjgd
zd�d|�
�}tj||�y)N)rrrr�rVrLr r}r!rrr)rMr(r%)r!r�)rMr()
rr/r-r.r�r	rar0rPr1)r2r�r-r5r4s     r6�0test_groupby_sum_below_mincount_nullable_integerr��s���	����C�7�	S�B��j�j��o�G�
�(�(�9�3�g�
6�C�
�S�\�
�
��
�
*�F��r�u�u�g��k���#�F�H����6�8�,�
�[�[�1�[�
%�F�����w��{�"�%�%��1��=�W�TW�X�H����&�(�+r8c��tgd�tjd�tjd�tjd�tjgd��}tjd��}|j	d�}|j�}td	||gitjd
dgd���
�}tj||�|d	j�}tj||d	�|d	jd��}t|tjgdd	|j��}tj||�y)N)rrrr�1d�2d�3dr|r)r}r r!rrr$rZrzm8[ns])rMr%r()rr-�	Timedelta�NaTr/r�r.r0r1rPr	r()r2�td3r�r�r4s     r6�#test_groupby_sum_timedelta_with_natr��s���	���,�,�t�$�b�l�l�4�&8�"�,�,�t�:L�b�f�f�U�	
�
�B�
�,�,�A�
�C�	���C��B�
�&�&�(�C��#��S�z�*�"�(�(�A�q�6��2L�M�H����#�x�(�
�S�'�+�+�-�C����3���
�.�
�S�'�+�+��+�
"�C��s�B�F�F�m�8�#�X�^�^�T�H����3��)r8)�int8�int16�int32r �float32�float64rSzmethod,datar2r|r�r�r )r2�out_typec��tddd�ddd�ddd�ddd�g�}|jj|�|d<d|vrg|d<d|vr|d}n|}|d	}t|�}|jj|�|d<|jd
d��|j	d
�}t||�|d�}t
j||�y)
Nrr|rrr�r!�argsr�r2r T)�inplace)rr!r�r�r/r+r0r1)	rMr�rIr2r�r3�df_out�grpd�ts	         r6�%test_groupby_non_arithmetic_agg_typesr��s���
��q�	���+�1�1�-=�Q�Q�?O�P�
�B��d�d�k�k�%� �B�s�G�
�T����V���T���
�#����
�t�*�C�
�s�^�F��(�(�/�/�(�+�F�3�K�
���S�$��'�
�:�:�c�?�D����f��t�F�|�,�A����!�V�$r8c�"�ddlm}||ddi|��S)Nr)�sem�ddofr)�scipy.statsr�)r�rur�s   r6�	scipy_semr�s�����'�1�'��'�'r8z	op,targopr�r��std�varr��prodc� �|jdS)Nr�r�r�s r6r�r� s��A�F�F�1�I�r8c� �|jdS)N���r�r�s r6r�r�!s��1�6�6�"�:�r8r��scipy)�marksc� �ttjjd�j	d��}tjjd�jddd��j
t�}t|j|�|��}|dvrdnt}d|��}tj||��5|j|�j|�}ddd�tj|�y#1swY� xYw)	Nrr�rr�r�)r�r�r�r�zusing DataFrameGroupBy.rm)rr?r�r�r�r�r�rTr+r/r�r0r�rOr1)�op�targopr2r�r5r�r�r4s        r6�test_ops_generalr�s���$
�2�9�9�(�(��+�;�;�D�A�	B�B�
�Y�Y�
"�
"�1�
%�
.�
.�q�"�4�
.�
@�
G�
G��
N�F�
,�W�R�Z�Z��'��
,�
.�F��:�:�4�
�D�#�B�4�
(�C�	�	#�	#�D��	4�2��:�:�f�%�)�)�&�1��2����&�(�+�2�2�s�!D�D
r�)	rrrrrrrrr)rrrrrr)rrrrrr�function)r�r�r�c�"�|dk(rdnd}tj|gdzt��}tjgd�dd�	�}td
|i|��j
d�}t|d��jd�}t||��}tj||�|j|�}tj||�|j|g�}tjd
|fg�|_tj||�y)
Nr�g�?g�?rrLrr rVr}r!rZrU)r?rFrTr-r.rr�r/r+r0r1rOr�from_tuplesr')r�r��outputr�r-r4r,r5s        r6�,test_apply_to_nullable_integer_returns_floatr�2s�����%�S�3�F�
�(�(�F�8�a�<�u�
-�C�
�(�(�9�3�g�
6�C��#�s��3�/�6�6�y�A�H�
�v�W�
-�
5�
5�c�
:�F�
&�W�V�X�
&�
(�F����&�(�+�
�Z�Z��
!�F����&�(�+�
�Z�Z��
�
#�F�!�-�-��X��.?�@�H�����&�(�+r8r�)
r�r�r�r�r�r��skewr�r�r�r�r*c�l����tdg�}�dk(r|}d}n|j}d}tjt|��5|jd�|��}ddd��dk(rdt
�����}|jd��j���fd	��}	|r|	j��
�}	tj||	�yt
���}|jd��j��fd��}	|r|	j��
�}	tj||	�y#1swY��xYw)NrzAThe 'axis' keyword in DataFrame.groupby is deprecated and will bez+DataFrame.groupby with axis=1 is deprecatedrm)r�r�r�r�r)r�c�,��t|������S)N)r�r*�r+)r�r�r�r*s ���r6r�z3test_regression_allowlist_methods.<locals>.<lambda>vs���n�g�a��n�$�v�>�r8r�c�*��t|�����S)Nr�r�)r�r�r�s ��r6r�z3test_regression_allowlist_methods.<locals>.<lambda>}s���.�'�!�R�.�d�:S�r8)
r�Tr0r�r�r/r+ryr�r1)
r�r�r*r��	raw_frame�framer�r�r5r4s
```       r6�!test_regression_allowlist_methodsr�Qs���,�1�#��I��q�y���Q������;��	�	#�	#�M��	=�?��-�-�a�d��-�>��?�
�V�|�%���"�%�V�4���=�=�q�=�)�/�/�>�
����*�*��*�5�H�
���f�h�/�%���"�%�'���=�=�q�=�)�/�/�0S�T����*�*��*�5�H�
���f�h�/�#?�?�s�D*�*D3c�(�ddgddgddgddgddgddgddgdd	gdd
gddgddgdd
gddgddgg}t|ddgd��}|jdg�j�j�}tdgdgd�d��}t	j
||�y)Nrr�)r�rorp��rr�+r��/rq�Xr;r<r )r'rMl�N+R@r7rL)rr/r�rzr0r1)rIr2r5r4s    r6�"test_groupby_prod_with_int64_dtyper��s���
�B��	
�B��	
�B��	
�B��	
�A��	
�B��	
�B��	
�A��	
�A��	
�B��	
�A��	
�B��	
�B��	
�B���D� 
�4�#�s��7�	;�B�
�Z�Z���
�
#�
#�
%�
1�
1�
3�F���s�*<�)=�>�g�N�H����&�(�+r8)fr,�datetimer��stringr�numpyr?ro�pandas._libs.tslibsr�pandas.core.dtypes.commonr�pandas.core.dtypes.missingr�pandasr-rrr	r
rr�pandas._testing�_testingr0�pandas.utilr
�td�mark�parametrizer@r7rBrHrarSrFrhr_rfr�rkrrrvr�r�r�r�r�r�r�r�r�r�rrrr!r#r.r0r4�strr:rKrUrZr^rg�slowr�r�r�r�r�r.rr�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r��param�
skip_if_nor�r�r�r�rtr8r6�<module>rs�����"��
�$�2�9�����.�������e�U�^�4������
�������������	��������� ���$,�%�5�&,�"
,�������5�%�.�9�,�:�,�������5�%�.�9������
���	������r�u�u��	����u��	
�r�u�u�d��	
�r�u�u�e��
�
�
-�
�:�
-������%�
���B�H�H�d�V�4�(��B�H�H�b�e�e�W�I�.�		
�
���B�H�H�b�e�e�W�I�.��B�H�H�d�V�4�(�		
�
���B�H�H�b�e�e�W�I�.��B�H�H�b�e�e�W�I�.�		
�
���B�H�H�b�e�e�W�I�.��B�H�H�b�e�e�W�I�.�		
�'��:	,�;�:	,�������5�%�.�9�������"A�B�	&�C�:�	&������%�	���������'�	�����2�6�6�"�D�)�	���������&�	�����r�v�v�&��.�	��&��&�������5�%�.�9�:�:�:�������5�%�.�9�&�:�&��������8� 4�5�,�6�,�(�������8� 4�5�%,�6�%,�P������	�a��V��A��1�a�&�I�J�	�a��V��A��1�a�&�I�J���������$���7�,�8��,�@�����
�
�2�3��2�3�	
�	/��	�������#K�L�,�M�	�,�&�������&� 1�2�,�3�,�6�4P�-�"�,,��",�>-�$?�(?�������%���0�
-�1�
-�������%���0�
,�1�
,�,�<������%���0�
,��
,�1�
,�������"U�V�,/�W�,/�^)�"������!@�A�,�B�,�,������%���0�	,�1�	,�&�(�����������%���/�������E�4�=�1�������d�E�]�3�������d�E�]�3�������5�'�E�5�>�!:�;�+�<�4�4�2�0��+�D,�2-�&-�-�"�����!�
�
�|�
$�b�f�f�i��.E�F���A�3�h�b�h�h��u�5�9��G�		
�
�
�R�W�W�T�1�a�
 �"�&�&�'�"�'�'�$��1�*=�>���A�3�h�b�h�h��u�5�9��G�		
�
&������a��#���������a��#���������a��#�
�
��A�q�6�����3��*�5�!A��O�	
�
&������a��#���������a��#���������a��#�
�
��A�q�6�����3��*�5�!A��O�	
�3%�(�R-�S(�R-�,�-�
-�.�"������q�"�g�.�0�/�0�,,�*�0������
P��������	�4���*�!�!�,<�=�>�?�	�$�q�q�)���+;�<�=�>�	��a�a�(���*:�;�<�=�	��a�a�(���*:�;�<�=�	���*�!�!�,<�=�7�S�T��	�%�	��%�6(�������	�����	�2�9�9��	�����	�����	�����	�����	�����	�����	�%�&�	�%�&�	�"�'�'������U�I�]�R�]�]�7�-C�D�
��"	,�#�"	,�������-��R�U�U�A�q�"�%�%��A�r�u�u�a�8�	
�!�'9�:��	�������%>�?�,�@�	�,�(��������������!�Q��(�������D�%�=�1�������$���/�0�0�2�)��$0�@,r8

Youez - 2016 - github.com/yon3zu
LinuXploit