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_grouping.cpython-312.pyc
�

/	�g&����dZddlmZmZddlZddlZddlZddlm	Z	m
Z
mZmZm
Z
mZmZmZmZddlmZddlmZGd�d�ZGd�d	�ZGd
�d�ZGd�d
�Zd�Zd�Zej:j=dgd��d��Zy)zG
test where we are determining what we are grouping, or getting groups
�)�date�	timedeltaN)	�CategoricalIndex�	DataFrame�Grouper�Index�
MultiIndex�Series�	Timestamp�
date_range�period_range)�Groupingc��eZdZd�Zd�Zd�Zd�Zd�Zd�Zd�Z	e
jjdd	�d
�g�d��Z
d�Zy
)�
TestSelectionc�$�tddggddg��}|jd�}tjtd��5|dgddd�tjtd	��5|ddgddd�y#1swY�5xYw#1swYyxYw)
N���A�B��columnsz"Columns not found: 'C'"��match�Cz^[^A]+$)r�groupby�pytest�raises�KeyError)�self�df�gs   �DC:\Python312\Lib\site-packages\pandas/tests/groupby/test_grouping.py�test_select_bad_colsz"TestSelection.test_select_bad_cols s���
��A��x�#�s��
4���J�J�s�O��
�]�]�8�+G�
H�	�
�s�e�H�	��]�]�8�9�
5�	�
�s�C�j�M�	�	�	�	��	�	�s�A:�)B�:B�Bc
��tgd�td�tdd�tddd�g��}d}tjt|�	�5|jd
�ddd�tjt|�	�5|jd
dg�ddd�|jd�}|j
�}|jjdk(sJ�|jjd
k(sJ�y#1swY��xYw#1swY�mxYw)N)rrrr�r�r�)r�dataz!Grouper for 'A' not 1-dimensionalrrrr�)
r�rangerr�
ValueErrorr�countr�nlevels�size)rr �msg�grouped�cs     r"�'test_groupby_duplicated_column_errormsgz5TestSelection.test_groupby_duplicated_column_errormsg+s���
�(��a��%��1�+�u�Q�PQ�ST�~�/V�
��2��
�]�]�:�S�
1�	��J�J�s�O�	�
�]�]�:�S�
1�	#��J�J��S�z�"�	#��*�*�S�/���M�M�O���y�y� � �A�%�%�%��y�y�~�~��"�"�"�	�	��	#�	#�s�C7�D�7D�Dc��|jd�jj�}|jd�dj�}tj||�d|d<|jd�jd��}|jd�gd�j
d�}tj||�y)Nrrg�?�meanT��numeric_only)r�Dr4)rr�sum�tm�assert_series_equalr4�agg�assert_frame_equal�rr �result�expecteds    r"�test_column_select_via_attrz)TestSelection.test_column_select_via_attr<s������C��"�"�&�&�(���:�:�c�?�3�'�+�+�-��
���v�x�0���6�
����C��%�%�4�%�8���:�:�c�?�#5�6�:�:�6�B��
���f�h�/�c	��tgd�gd�tjjd�j	d�tjjd�j	d�tjjd�j	d�d��}|jd�ddgj
�}|jd�|jdd	j
�}|jdd�gd
�fjd�j
�}tj||�tj||�y)N��foo�barrDrErDrErDrD��onerG�two�threerHrHrGrIrr'�rrrr7�Errr7r%)rrr7)r�np�random�default_rng�standard_normalrr4r�locr9r<�rr r>�result2r?s     r"�test_getitem_list_of_columnsz*TestSelection.test_getitem_list_of_columnsFs���
�M�Q��Y�Y�*�*�1�-�=�=�a�@��Y�Y�*�*�1�-�=�=�a�@��Y�Y�*�*�1�-�=�=�a�@�
�
�����C��#�s��,�1�1�3���*�*�S�/�"�*�*�Q�q�/�2�7�7�9���6�6�!�_�,�-�5�5�c�:�?�?�A��
���f�h�/�
���g�x�0rAc�J�ttd�dztjj	d�jd�tjj	d�jd�tjj	d�jd�d��}|j
d�|jddj�}|j
d�ddgj�}|jdd�gd	�fj
d�j�}tj||�tj||�tjtd
��5|j
d�dj�ddd�y#1swYyxYw)
N�abcdrr')rrr%r&rrr)r%�rrr%�"Cannot subset columns with a tupler)rr%)r�listrLrMrNrOrrr4rPr9r<rrr+rQs     r"�!test_getitem_numeric_column_namesz/TestSelection.test_getitem_numeric_column_namesYs?��
���<�!�#��9�9�(�(��+�;�;�A�>��9�9�(�(��+�;�;�A�>��9�9�(�(��+�;�;�A�>�	
�
�����A��r�z�z�!�A��/�4�4�6���*�*�Q�-��A��'�,�,�.���6�6�!�Y�,�'�/�/��2�7�7�9��
���f�h�/�
���g�x�0��]�]�:�-Q�
R�	'��J�J�q�M�$��$�$�&�	'�	'�	'�s�-#F�F"c��tjtd��5|jd�dj	�ddd�y#1swYyxYw)NrWrr)rr7)rrr+rr4�rr s  r"�+test_getitem_single_tuple_of_columns_raisesz9TestSelection.test_getitem_single_tuple_of_columns_raisesos?��
�]�]�:�-Q�
R�	-��J�J�s�O�H�%�*�*�,�	-�	-�	-�s�#A�Ac	�4�tgd�gd�tjjd�j	d�tjjd�j	d�tjjd�j	d�d��}|jd�dj
�}|jdd�ddgfjd�j
�}|jdd�df}|}tj||�y)	NrCrFrr'rJrrr)rrLrMrNrOrr4rP�ilocr9r:)rr r>�as_frame�	as_seriesr?s      r"�test_getitem_single_columnz(TestSelection.test_getitem_single_columnts���
�M�Q��Y�Y�*�*�1�-�=�=�a�@��Y�Y�*�*�1�-�=�=�a�@��Y�Y�*�*�1�-�=�=�a�@�
�
�����C���%�*�*�,���6�6�!�c�3�Z�-�(�0�0��5�:�:�<���M�M�!�Q�$�'�	���
���v�x�0rA�funcc�"�|j�S�N�r8��xs r"�<lambda>zTestSelection.<lambda>�s��1�5�5�7�rAc�&�|jd��S)Nc�"�|j�Srdre)�ys r"rhz(TestSelection.<lambda>.<locals>.<lambda>�s��a�e�e�g�rA)r;rfs r"rhzTestSelection.<lambda>�s��a�e�e�4E�.F�rAc���tgd�dddd��}|jddg�ddg}tjd	d
gddg��}tddgd
dgd�|��}||�}t	j
||�y)N�rrrr)r%���a�br1�drprqr1)rr))rr)��namesrr')rpr1��index)rrr	�from_tuplesr9r<)rrbr �gb�idxr?r>s       r"�test_getitem_from_grouperz'TestSelection.test_getitem_from_grouper�s��
�Y�Q�Q�Q�?�
@��
�Z�Z��c�
�
#�S�#�J�
/���$�$�f�f�%5�c�3�Z�H���A�q�6��A��7�s�C���b���
���f�h�/rAc����tdd�dD�i���jd�}�j�fd��}|j}|j}tj||�y)N�Tuplesc3�K�|]=}tjjd�jddd�D]}||f���
�?y�w�rr)rnN�rLrMrN�integers��.0rgrks   r"�	<genexpr>zJTestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<genexpr>��O�������Y�Y�2�2�1�5�>�>�q�!�Q�G�����F������AA�rrc�&���j|dfS�Nr�r^�rgr s �r"rhzITestSelection.test_indices_grouped_by_tuple_with_lambda.<locals>.<lambda>���������A���rA)rr�indicesr9�assert_dict_equal�rrx�	gb_lambdar?r>r s     @r"�)test_indices_grouped_by_tuple_with_lambdaz7TestSelection.test_indices_grouped_by_tuple_with_lambda�se���
���#��
�
���Z�Z��
!���J�J�6�7�	��:�:���"�"��
���V�X�.rAN)�__name__�
__module__�__qualname__r#r2r@rSrYr\rar�mark�parametrizerzr��rAr"rrsY��	�#�"0�1�&'�,-�
1�&�[�[����"�$F�G��	0��	0�/rArc��eZdZejjdeed��eejd��eejde
���edd��edd��g�d��Z
d�Zd	�Zd
�Zd�Zejjdd
dg�d��Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zejjdgd�gd�ed�D���cgc]}t9ddd|z���c}}}g�d��Zd�Zd �Zd!�Z d"�Z!d#�Z"d$�Z#d%�Z$d&�Z%d'�Z&ejjd(dd
g�d)��Z'd*�Z(ejjd(dd
g�d+��Z)d,�Z*ejjd-dgd.�gd
gd/�gg�d0��Z+d1�Z,d2�Z-ejjd3d4e.d5ej^�6�fd7e.d5ej^egej^d8�9��:�fd;e.d5ej^egej^d8�9��:�fg�d<��Z0d=�Z1d>�Z2d?�Z3y@cc}}}w)A�TestGroupingrv�abcdern��dtypez
2020-01-01��periodsc�V�ttjd�jdd�t	d�|��}|jt	d�d��j
d	��|jddd
�|_|jt	d�d��j
d��y)N�
rnr�AB)rrvr�F��
group_keysc��|Srdr�rfs r"rhz7TestGrouping.test_grouper_index_types.<locals>.<lambda>����A�rA���c��|Srdr�rfs r"rhz7TestGrouping.test_grouper_index_types.<locals>.<lambda>�r�rA)rrL�arange�reshaperXr�applyrv)rrvr s   r"�test_grouper_index_typesz%TestGrouping.test_grouper_index_types�s|���r�y�y��}�,�,�Q��2�D��J�e�
T��
�
�
�4��=�U�
�3�9�9�+�F��8�8�D�b�D�>���
�
�
�4��=�U�
�3�9�9�+�FrAc��tj�td��z
}t|tj��}t	j
||gddg��}t
tjjd�jddd	�|�
�}|j�jtdd��tdd��g�j�}tdgd
��|_|jtdd��tdd��g�j�}t#j$||�|jtdd��tdd��g�j�}t#j$||�y)N�)�daysrDrErsrr�d��ru�W��key�freq�int64r���levelr�r)r�todayrrr	�from_productrrLrMrNr��reset_indexrrr8rrr9r<)r�d0�dates�
date_indexr r?r>s       r"�test_grouper_multilevel_freqz)TestGrouping.test_grouper_multilevel_freq�s9���Z�Z�\�I�2�.�
.���2�t�z�z�|�,���,�,�e�U�^�E�5�>�R�
�
�r�y�y�,�,�Q�/�8�8��C��E�Z�
X��
�N�N��
�W�g�%�c�2�G��C�4P�Q�
R�
�S�U�	�!�!��G�4������
�5�s�
+�W�5�s�-K�L�
�

�#�%�	�	���f�h�/����
�1�3�
'��q�s�)C�D�
�

�#�%�	�	���f�h�/rAc���tgd�gd�d��}|jd�}|j�}|jtd���}|j�}t	j
||�d}t	jt|��5tdd�	�}ddd�|j�}|j�}t	j
||�d
}t	jt|��5|jd��}ddd�gd�|d<|jdd�dd
gf}t	j
||�y#1swY��xYw#1swY�HxYw)N)rrrrrr�rrr)r%rnr&�rrr�r�z6Grouper axis keyword is deprecated and will be removedrr)r��axisz7DataFrameGroupBy.apply operated on the grouping columnsc�"�|j�Srdrerfs r"rhz8TestGrouping.test_grouper_creation_bug.<locals>.<lambda>�s��q�u�u�w�rArVr)rrr8rr9r<�assert_produces_warning�
FutureWarning�DeprecationWarningr�rP)rr r!r?r>r/�gprs       r"�test_grouper_creation_bugz&TestGrouping.test_grouper_creation_bug�s ��
�/�6H�I�
J���J�J�s�O���5�5�7���J�J�w�3�'�(�������
���f�h�/�F��
�
'�
'�
�S�
A�	+��c��*�C�	+��J�J�s�O�������
���f�h�/�G��
�
'�
'�(:�#�
F�	0��W�W�.�/�F�	0�!���
��<�<��C��:�
�.��
���f�h�/�	+�	+��	0�	0�s�E
�<E�
E�Ec���tgd�gd�gd�d��}|jd�j�}|jtd��g�}|j�}t	j
||�|jddg�j�}|jtd��td��g�}|j�}t	j
||�|jdtd��g�}|j�}t	j
||�|jtd��dg�}|j�}t	j
||�y)N)rrrrrr)rrrrr)r)r��rrrrr�r)rrr8rr9r<)rr r?r!r>s     r"�test_grouper_creation_bug2z'TestGrouping.test_grouper_creation_bug2�s$���$�+=�DV�W�
���:�:�c�?�&�&�(���J�J��C�(�)�*�������
���f�h�/��:�:�s�C�j�)�-�-�/��
�J�J��C�(�'�c�*:�;�<�������
���f�h�/�
�J�J��W��-�.�/�������
���f�h�/�
�J�J��C�(�#�.�/�������
���f�h�/rAc�|�tdd|��}tjtd�t	d�|ggd���}tt
jdd�	�|�
�}|jtdd�
��j�}tjtd�gdd��j|�}tdg|�
�}tj ||�|jtd���j�}|jd��j�}tj ||�y)N�20130101r)r��unit�ab)rGrHrIrsr'r�r�rurI�MEr�z
2013-01-31)r��name�rG�r�)rr	r�rXr*r
rLr�rrr8�pd�
DatetimeIndexr�as_unitr9r:)rr��dti�mi�serr>�exp_dtir?s        r"�test_grouper_creation_bug3z'TestGrouping.test_grouper_creation_bug3s
����Q�T�:��
�
$�
$�
�$�Z��q��3�'�)�
����I�I�a�w�'��
�����W�7��>�?�C�C�E���"�"�
�|�
$�%�D�w�
�
�'�$�-�	��
�D��
��	���v�x�0����W�5�1�2�6�6�8���;�;�U�;�+�/�/�1��
���v�x�0rArbFTc�R��tgd�gd�d��}tttd�ddgdz���|r|j	�fd�d	�
�}n|j	�d	�
�}tt
|��\}}|dk(sJ�|j|�}tj||�y)N�rrrr)rr%r)r)�X�Yr%)rrn)r7r&rc����|Srdr�)ry�mappings �r"rhz<TestGrouping.test_grouper_returning_tuples.<locals>.<lambda>7s���7�3�<�rAF)�by�sort)
r�dict�zipr*r�next�iter�	get_groupr9r<)rrbr rxr�r?r>r�s       @r"�test_grouper_returning_tuplesz*TestGrouping.test_grouper_returning_tuples0s�����1��E�
F���s�5��8�h��%9�A�%=�>�?������7�e��D�B����w�U��3�B��d�2�h����h��x�������d�#��
���f�h�/rAc�P�tjgd��}ddg|_tt	j
d�gd�d�|��}|j
dtd�	�g�jd
��}|j�j
ddg�jd
��}tj||�|j
td�	�dg�jd
��}|j�j
ddg�jd
��}tj||�|jd�}|j
dtd�	�g�jd
��}|j�j
ddg�jd
��}tj||�|j
td�	�dg�jd
��}|j�j
ddg�jd
��}tj||�y)N)�rpr)rpr)rpr)�rqr�rqr)rqr)�outer�innerr&)rGrGrHrHrGrGr�rurr�Tr5)r	rwrtrrLr�rrr4r�r9r<)rry�df_multir>r?�	df_singles      r"�test_grouper_column_and_indexz*TestGrouping.test_grouper_column_and_indexAs
��
�$�$�H�
���g�&��	���)�)�A�,�%O�P��
���!�!�3��g�(>�"?�@�E�E�SW�E�X��� � �"�*�*�C��>�:�?�?�T�?�R�	�	���f�h�/��!�!�7��#9�3�"?�@�E�E�SW�E�X��� � �"�*�*�G�S�>�:�?�?�T�?�R�	�	���f�h�/��(�(��1�	��"�"�C��w�)?�#@�A�F�F��G�
��
�!�!�#�+�+�S�'�N�;�@�@�d�@�S�	�	���f�h�/��"�"�G�'�$:�C�#@�A�F�F��G�
��
�!�!�#�+�+�W�c�N�;�@�@�d�@�S�	�	���f�h�/rAc��ddg}tjgd�|��}ttjd�jdd�|��}|j
|�	�j�}|j�j
|�j�}|jjtj�|_	tj||�y)
Nrgrk)�rr�rr)r)r%)rnr&rs�r�r)rur�)r	rwrrLr�r�rr4r�r�astyper�r9r<)r�	idx_namesryr �	by_levels�
by_columnss      r"�test_groupby_levels_and_columnsz,TestGrouping.test_groupby_levels_and_columnsos����#�J�	��$�$�%E�Y�W��
�r�y�y��}�,�,�R��3�3�
?���J�J�Y�J�/�4�4�6�	��^�^�%�-�-�i�8�=�=�?�
�(�/�/�6�6�r�x�x�@�
��
���i��4rAc�(�gd�}ddg}tjgd�gd�gd�gd�gd�gt�}t||d��}t	||��}d}tjt|�	�5|jd
d|��j�}ddd�tjd
dgd
dgd
dgd
dgd
dggt�}	t||d��}
t	|	|
��}tj|�t	|j|��}d}tjt|�	�5|jdd|��j�}ddd�t	|	j|
��}tj||�y#1swY��xYw#1swY�CxYw)Nr�rr)rrrrT)�
categories�ordered)r(r�+DataFrame.groupby with axis=1 is deprecatedrrr)r�r��observedr%rru�5The 'axis' keyword in DataFrame.groupby is deprecated)r(rv)rL�array�intrrr9r�r�rr8r<�T)
rrrr�r(�cat_columnsr �depr_msgr>�
expected_data�expected_columnsr?r/s
             r"�*test_groupby_categorical_index_and_columnsz7TestGrouping.test_groupby_categorical_index_and_columns}st��&���3�Z�
��x�x�
�<��|�\�R�TW�
��'�w�:�t�T��
�D�+�
6��@��
�
'�
'�
�X�
F�	J��Z�Z�Q�a�(�Z�C�G�G�I�F�	J����1�a�&�1�a�&�1�a�&�1�a�&�1�a�&�!I�3�O�
�+��:�t�
���-�9I�J��
���f�h�/��t�v�v�[�
1��E��
�
'�
'�
�S�
A�	J��Z�Z�Q�a�(�Z�C�G�G�I�F�	J��-�/�/�9I�J��
���f�h�/�	J�	J��	J�	J�s�*#E<�##F�<F�Fc��tdditjtd�t	dd��gddg�	��
�}|jt
d��t
dd�
�g�j�}tdgd�itjtd�t	ddd��gddg�	��
�}tj||�y)Nrrr�r��Pr�rGrHrsrur�r�r�)�r��rr�r
r))r�r�)
rr	r�rXrrrr8r9r<r=s    r"�#test_grouper_getting_correct_binnerz0TestGrouping.test_grouper_getting_correct_binner�s����
�!�H��)�)��d��Z�
�B�?�@��PU���
�����
�5�
!�7��T�#B�C�
�

�#�%�	��
�*�+��)�)��d��Z�
��q�I�J��e�n��
��	���f�h�/rAc���|jd�}d}tjt|��5|j}ddd�t�}ddg}||k(sJ�y#1swY� xYw)Nr�&DataFrameGroupBy.grouper is deprecatedrrErD)rr9r�r��grouper�sorted)rr rxr/rr>r?s       r"�test_grouper_iterzTestGrouping.test_grouper_iter�sb��
�Z�Z��_��6��
�
'�
'�
�S�
A�	!��j�j�G�	!������5�>����!�!�!�		!�	!�s�
A�A$c��tjtd��5|jg�ddd�y#1swYyxYw)NzNo group keys passed!r)rrr+rr[s  r"�test_empty_groupszTestGrouping.test_empty_groups�s1��
�]�]�:�-D�
E�	��J�J�r�N�	�	�	�s	�7�Ac�4�|jd�}d}tjt|��5|j}ddd�|j�jd��}|jd��}tj||�y#1swY�SxYw)NrrrTr5)rr9r�r�rr4r<)rr r0r/rr>r?s       r"�test_groupby_grouperz!TestGrouping.test_groupby_grouper�s~���*�*�S�/��6��
�
'�
'�
�S�
A�	&��o�o�G�	&����G�$�)�)�t�)�<���<�<�T�<�2��
���f�h�/�		&�	&�s�
B�Bc���tddi�}|jddi�jd�}|jdg�jd�}tj||�tgd�td���}ddd	d	d
�}|j|�j
�}|j|�jd�}tjgd�tj�
�}|j|�j
�}|j|�j
�}tj||�tj||�tj||�y)N�T1rn�T2r8)��?�@g@g@rUrurrror4)rrrrr�)
r
rr;r9r:rXr4rLrr�)r�sr>r?r�rR�exp_key�	expected2s        r"�test_groupby_dict_mappingz&TestGrouping.test_groupby_dict_mapping�s���D�!�9������D�$�<�(�,�,�U�3���9�9�d�V�$�(�(��/��
���v�x�0��'�t�F�|�<������2�����7�#�(�(�*���)�)�G�$�(�(��0���(�(�<�r�x�x�8���9�9�W�%�*�*�,���I�I�g�&�+�+�-�	�
���v�x�0�
���v�w�/�
���v�y�1rA�rrrr)ror%i��r�c���|gd�|��}tgd�|d��}|j|�j�}|ddg�}d|j_tj||�y)N�rrr)r%ru)rrrr)rprp)rvr�r%r))r
r�lastrvr�r9�assert_equal)r�frame_or_seriesrv�obj�groupsr>r?s       r"�$test_groupby_series_named_with_tuplez1TestGrouping.test_groupby_series_named_with_tuple�s]���l�%�8����E�
�C�����V�$�)�)�+��"�A�q�6�*��(�����
�����)rAc��tddd��}ttjj	d�jd�|��}d}t
jt|��5|jd	��ddd�|jd
��j�}|j|j�j�}d|j_tj||�y#1swY�zxYw)Nz01-Jan-2013r��MS�r�r�rruz''Timestamp' object is not subscriptablerc��|ddS)Nrr&r�r�s r"rhzDTestGrouping.test_groupby_grouper_f_sanity_checked.<locals>.<lambda>�s��3�q��8�rAc��|Srdr�rfs r"rhzDTestGrouping.test_groupby_grouper_f_sanity_checked.<locals>.<lambda>�s��a�rA)rr
rLrMrNrOrr�	TypeErrorrr8rvr�r9r:)rr��tsr/r>r?s      r"�%test_groupby_grouper_f_sanity_checkedz2TestGrouping.test_groupby_grouper_f_sanity_checked�s����=�"�4�@��
�B�I�I�)�)�!�,�<�<�R�@��
N��8��
�]�]�9�C�
0�	-��J�J�+�,�	-����K�(�,�,�.���:�:�b�h�h�'�+�+�-��"�����
���v�x�0�
	-�	-�s�%C1�1C:c	��tddgdztddd��d��}tdd	�
�}|j|dg�}t	d�dfdd
gt	d�dfdgt	d�dfdgt	d�dfddgi}tj|j|�t|jj��dk(sJ�y)Nrprqr)z
2000-01-01z
2000-01-03�9h�r�)�idrqr7r�r6rrrz
2000-01-02r%rn)
rrrrrr9r�r)�len�keys)rr rrxr?s     r"�test_groupby_with_datetime_keyz+TestGrouping.test_groupby_with_datetime_key�s���
��C�j�1�n���l��F�
�
���c��,��
�Z�Z��$��
(���|�
$�c�*�Q��F�
�|�
$�c�*�Q�C�
�|�
$�c�*�Q�C�
�|�
$�c�*�Q��F�	
��	���R�Y�Y��1��2�9�9�>�>�#�$��)�)�)rAc��d}tjt|��5t|j|ddg�ddd�y#1swYyxYw)NzEGrouper for '<class 'pandas.core.frame.DataFrame'>' not 1-dimensionalrr)rrr+rrv�rr r/s   r"�%test_grouping_error_on_multidim_inputz2TestGrouping.test_grouping_error_on_multidim_inputs@��U��
�]�]�:�S�
1�	/��R�X�X�r�3��*�~�.�	/�	/�	/�s�A�Ac�>�tgd�gd�gd�g�}tjgd��|_d}t	j
t|��5|jdddg�	�}ddd�j�}t	j||�y#1swY�0xYw)
N�rrr))r%rnr&)r"r'�	)r�r�)rrr�rrr�r�r�)
rr	rwrr9r�r�r�firstr<)rr rrxr>s     r"�test_multiindex_passthruz%TestGrouping.test_multiindex_passthrus����	�9�i�8�
9���+�+�,D�E��
�@��
�
'�
'�
�X�
F�	2�����1�a�&��1�B�	2������
���f�b�)�	2�	2�s�B�Bc��|jd��j�}|jd��j�}tj||�|jd��j�}|jd��j�}tj||�|jddg��j�}|j	�}tj||�|jddg��j�}|jddg��j�}tj||�y)Nr�r��second���rA)rr8r9r<�
sort_index)r� multiindex_dataframe_random_datar>r?s    r"�test_multiindex_negative_levelz+TestGrouping.test_multiindex_negative_level s)��1�9�9��9�C�G�G�I��3�;�;�(�;�K�O�O�Q��
���f�h�/�1�9�9��9�C�G�G�I��3�;�;�'�;�J�N�N�P��
���f�h�/�1�9�9��R��9�I�M�M�O��3�>�>�@��
���f�h�/�1�9�9��W�
�9�N�R�R�T��3�;�;��W�%�<�
�

�#�%�	�	���f�h�/rAc�,�tjt|j��|_d}t	j
t|��5|jdd��djdtji�ddd�y#1swYyxYw)Nz7Passing a dictionary to SeriesGroupBy.agg is deprecatedrrF��as_indexr�Q)
rLr�r7rr9r�r�rr;r4r;s   r"�&test_multifunc_select_col_integer_colsz3TestGrouping.test_multifunc_select_col_integer_cols4ss���Y�Y�s�2�:�:��/��
�H��
�
'�
'�
�S�
A�	A��J�J�q�5�J�)�!�,�0�0�#�r�w�w��@�	A�	A�	A�s�6B
�
Bc�Z�ddgddgg}tj|�}tddgg|��}|jd�j}|ddgk(sJ�|jd	g�j}|ddgk(sJ�tddgd
dgg|��}|jd�j}|jd	g�j}||k(sJ�tddgd
dgg|��}|jd�j}|jd	g�j}tj||�y)Nr,�values�	to filter�rrrr)rPrQrr)r	rwrrr)r9r�)r�lst�midxr r0r?r>s       r"�#test_multiindex_columns_empty_levelz0TestGrouping.test_multiindex_columns_empty_level<s4����"�[�"�$5�6���%�%�c�*��
��C��z�4�
0���*�*�[�)�0�0���s�|��s�"�"�"��*�*�/�0�1�8�8���s�|��s�"�"�"�
��C��1�c�(�+�T�
:���:�:�k�*�1�1�����.�/�0�7�7����!�!�!�
��C��1�c�(�+�T�
:���:�:�k�*�1�1�����.�/�0�7�7��
���V�X�.rAc���tgd�gd�gd�gtjgd�gd�g���}|jdg�j}|jd�j}tj||�t|jtjgd�gd�g���}|jd	g�j}|jd�j}tj||�t|jgd
���}|jd	g�j}|jd�j}tj||�y)Nr$�r)r%rnr&�rr%rr)�rprqrqr1�rrrrrr�)rrrr�erZ�rqrr))rprrr[)rqrZr1)rr	�from_arraysrr)r9r�rO)rr r?r>�df2�df3s      r"�test_groupby_multiindex_tuplez*TestGrouping.test_groupby_multiindex_tupleTs��
�
�<��6��*�*�,@�,�+O�P�
���:�:�x�j�)�0�0�����H�%�,�,��
���X�v�.���I�I��*�*�%�';�<��
���;�;�
�|�,�3�3�����H�%�,�,��
���X�v�.���	�	�+T�U���;�;�
�|�,�3�3�����H�%�,�,��
���X�v�.rAc��tgd�gd�gd�gtjgd�gd�g���}|jdg�dd	gj	�}|jdg�d
j	�}tj||�|jdg�dd	gj�}|jdg�d
j�}tj||�|jdg�dd	gj�}|jdg�d
j�}tj||�|jdg�dd	gj�}|jdg�d
j�}	tj||	�|jdg�dd	gj�}
|jdg�d
j�}tj|
|�|jdg�dd	gj}|jdg�d
j}
tj||
�y)Nr$rVrWrXrYrr�r�r�rq)
rr	r\rr4r9r<r8r,�min�maxr)r�)rr �
expected_mean�result_mean�expected_sum�
result_sum�expected_count�result_count�expected_min�
result_min�expected_max�
result_max�expected_groups�
result_groupss              r"�4test_groupby_multiindex_partial_indexing_equivalencezATestGrouping.test_groupby_multiindex_partial_indexing_equivalencems��
�
�<��6��*�*�,@�,�+O�P�
��
�
�
�H�:�.��(�/C�D�I�I�K�
��j�j�(��,�S�1�6�6�8��
���m�[�9��z�z�8�*�-�x��.B�C�G�G�I���Z�Z��
�+�C�0�4�4�6�
�
���l�J�7����X�J�/��8�0D�E�K�K�M���z�z�8�*�-�c�2�8�8�:��
���n�l�;��z�z�8�*�-�x��.B�C�G�G�I���Z�Z��
�+�C�0�4�4�6�
�
���l�J�7��z�z�8�*�-�x��.B�C�G�G�I���Z�Z��
�+�C�0�4�4�6�
�
���l�J�7��*�*�h�Z�0�(�H�1E�F�M�M���
�
�H�:�.�s�3�:�:�
�
���_�m�<rAr�c�,�|}|j�}|jd|��j�}|jd|��j�}|j|dj|��j�}|j|dj|��j�}	d|j_d|	j_|jj
dk(sJ�|jj
dk(sJ�t
j||�t
j||	�|jj
|jjdk(sJ�|jj
|jjdk(sJ�|jd|��j�}|jd|��j�}t
j||�t
j||	�d}
t
jt|
��5|jjdd|�	�j�}|jjdd|�	�j�}ddd�t
j||j�t
j||	j�d
}
tjt|
��5|jd��ddd�y#1swY��xYw#1swYyxYw)Nr�r�r�rrA)r�rDr�r)r�r�r�z2level > 0 or level < -1 only valid with MultiIndexr�)r�rr8rOrvr�r9r<rtr�r�rrrr+)rr�rGr �frame�	deleveled�result0�result1�	expected0�	expected1r/s           r"�test_groupby_levelzTestGrouping.test_groupby_level�s���1���%�%�'�	��-�-�a�d�-�3�7�7�9���-�-�a�d�-�3�7�7�9���M�M�)�G�"4�";�";�$�M�G�K�K�M�	��M�M�)�H�"5�"<�"<�4�M�H�L�L�N�	�&�	����'�	�����}�}�!�!�W�,�,�,��}�}�!�!�X�-�-�-�
���g�y�1�
���g�y�1��}�}�!�!�U�[�[�%6�%6�q�%9�9�9�9��}�}�!�!�U�[�[�%6�%6�q�%9�9�9�9��-�-�g�D�-�9�=�=�?���-�-�h�T�-�:�>�>�@��
���g�y�1�
���g�y�1�<��
�
'�
'�
�S�
A�	H��g�g�o�o�A�A�D�o�A�E�E�G�G��g�g�o�o�A�A�D�o�A�E�E�G�G�	H�	���g�y�{�{�3�
���g�y�{�{�3�C��
�]�]�:�S�
1�	 ��J�J�Q�J��	 �	 �	H�	H��	 �	 �s�$AK>�"L
�>L�
Lc�$�tdgdzdgdzztd�d��jd�}|dvr|j}d}nd	}t	j
t|�
�5|jd|��ddd�d|j|���}tjt|�
�5t	j
t|�
�5|jd
|��ddd�ddd�y#1swY�yxYw#1swY�xYw#1swYyxYw)Nrr)rr&)�exp�var1rz)rrr�rr)r�r�z&level name foo is not the name of the rD)rr*�	set_indexrr9r�r�r�_get_axis_namerrr+)rr�r rr/s     r"�test_groupby_level_index_namesz+TestGrouping.test_groupby_level_index_names�s���
��u�q�y�C�5�1�9�4�e�A�h�G�
H�
R�
R��
���>�!����B�D�H�N�H�
�
'�
'�
�X�
F�	/��J�J�U��J�.�	/�6�r�7H�7H��7N�6O�P��
�]�]�:�S�
1�	3��+�+�M��J�
3��
�
��T�
�2�
3�	3�	3�	/�	/��
3�
3��	3�	3�s0�"C.�-D�	C:�D�.C7�:D	�?D�Dc��tddggd�ggd�gd�g��}ttjd�|��}|j	d|�	�j�}td
dgddg��}t
j||�tddggd�ggd�gd�g��}ttjd�|��}|j	d|�	�j�}td
d
gddg��}t
j||�y)Nrrr!)rrrrrrrr)rrrr)rrrr))�levels�codesg @rurqg@g6@)rrrrr�rrrg2@gr)r	r
rLr�rr8r9r:)rr�rvrr>r?s      r"�test_groupby_level_with_nasz(TestGrouping.test_groupby_level_with_nas�s������F�L�)�+�-E�F�
��
�2�9�9�S�>��/��������.�2�2�4���3��+�a��V�4��
���v�x�0����F�L�)�,�.F�G�
��
�2�9�9�S�>��/��������.�2�2�4���3��+�c�3�Z�8��
���v�x�0rAc��|}d}tjt|��5|j�ddd�d}tjt|��5|jdd��ddd�y#1swY�CxYw#1swYyxYw)Nz*You have to supply one of 'by' and 'level'r)r�r�)rrr0r)rrGrrr/s    r"�test_groupby_argszTestGrouping.test_groupby_args�sw��0��:��
�]�]�9�C�
0�	��M�M�O�	�;��
�]�]�9�C�
0�	/��M�M�T��M�.�	/�	/�		�	��	/�	/�s�A3�A?�3A<�?Bzsort,labels�
rrrrrrrr)r)r))
rrrrrrrr)r)r)c���|jd|��}tj|tj�}t	j
|jjd|�y)Nrrq)rrLr�intpr9�assert_almost_equal�_grouperr�)rr��labelsrGr0�
exp_labelss      r"�test_level_preserve_orderz&TestGrouping.test_level_preserve_order�sN��3�:�:���:�N���X�X�f�b�g�g�.�
�
���w�/�/�5�5�a�8�*�ErAc��|j|jjd��}tjgd�tj
��}t
j|jjd|�y)Nrr�r�)
rrv�get_level_valuesrLrr�r9r�r�r�)rrGr0r�s    r"�test_grouping_labelsz!TestGrouping.test_grouping_labels�s^��2�:�:�,�2�2�C�C�A�F�
���X�X�<�B�G�G�L�
�
���w�/�/�5�5�a�8�*�ErAc��tdtddd��i�}tj|jd<tdd��}|j
|g�}td	�tttd
���i}tj|j|�|j
|�}td	�di}tj|j|�y)Nrz1/1/2011imr7r-r��YSr�z
2011-01-01il)rrr��NaTr^rrrrrXr*r9r�r))rr rr>r?s     r"�test_list_grouper_with_natz'TestGrouping.test_list_grouper_with_nats���
��
�:�s�� M�N�
O���f�f�������f�4�0�����W�I�&���l�+�U�4��c�
�3C�-D�E��
���V�]�]�H�5����G�$���l�+�S�1��
���V�]�]�H�5rAz
func,expected�	transformr�r�r�r;r�r�r�)r�r�rvr�c��tggd��}|jdd��}t|d|�d��}tj||�y)Nr�rFr�rc��|Srdr�rfs r"rhz>TestGrouping.test_evaluate_with_empty_groups.<locals>.<lambda>,s��q�rA)rr�getattrr9r:)rrbr?r r!r>s      r"�test_evaluate_with_empty_groupsz,TestGrouping.test_evaluate_with_empty_groupssK��4�2�"�~�
&���J�J�q�U�J�+��$���1��t�$�[�1��
���v�x�0rAc	��tgdd��}|jg�}|j�}|jt	gt
j���}tj||�t|jj�dk(sJ�tj|jjdtjgtjt
j����tj|jjdtjgtjt
j����|jjddk(sJ�|j|�}d}tj t"|�	�5|j$}ddd�j&}dg}||k(sJ�y#1swY� xYw)
Nr��float64r�r�rrrz#SeriesGroupBy.grouper is deprecatedr)r
rr4�set_axisrrLr�r9r:r7r��	groupings�assert_numpy_array_equal�
group_inforr�r�r�rrt)rr�grr>r?rxr/rs        r"�test_groupby_emptyzTestGrouping.test_groupby_empty/se���2�F�)�4��
�Y�Y�r�]��������:�:�e�B�b�g�g�6�7��
���v�x�0��2�;�;�(�(�)�Q�.�.�.�
�#�#��K�K�"�"�1�%�r�x�x��"�(�(�2�7�7�:K�'L�	
�	�#�#��K�K�"�"�1�%�r�x�x��"�(�(�2�7�7�:K�'L�	
��{�{�%�%�a�(�A�-�-�-��Y�Y�q�\��3��
�
'�
'�
�S�
A�	!��j�j�G�	!������8����!�!�!�		!�	!�s�&
G�Gc
�n�tdtjdgdtjdgggd���jddg�}|j	ddg��j�}tgt
tdgd	�
�tgd�
�ggggddg��d
gd��}tj||�y)Nrgr��r�rrrr��objectr�r�)r�r�rtrr�)r(rvrr�)
rrL�nanr|rr8r	rr9r<r=s    r"�%test_groupby_level_index_value_all_naz2TestGrouping.test_groupby_level_index_value_all_naMs���
��2�6�6�2�
��r�v�v�r� 2�3�_�
�
�)�S�#�J�
�	����3��*��-�1�1�3������s�e�8�4�e�B�i�6P�Q��2�h��C�j��
�E��	
��	���f�h�/rAc	�4�tgd�gd�ggd���}|jddg�}||jdk}|jd�j	�}tdd	gtgtjd�
���}tj||�y)N)�{rpr)r�rqr)r6�category�valuerr6r�rr�r�r�)r�rrv)
rr|r�rr8rrLr�r9r<)rr �emptyr>r?s     r"�#test_groupby_multiindex_level_emptyz0TestGrouping.test_groupby_multiindex_level_empty_s���
�
�o�.�8S�
���\�\�4��,�
-���2�8�8�a�<� �����t�$�(�(�*�����I���"�(�(��6�
��
	���f�h�/rAN)4r�r�r�rr�r�rrXrLr��floatrr
r�r�r�r�r�r�r�r�r	rrrrr r*rr*r2r9r<rBrHrMrTr_rorxr~r�r�r�r�r�r
r�r�r�r�r�)r��irs000r"r�r��s����[�[�����$�w�-� ��)�"�)�)�A�,���)�"�)�)�A�U�+�,��|�Q�/���q�1�	
�	�G�	�G�0�80�00�>1�4�[�[���V�e�T�]�3�0�4�0� ,0�\5�0�60�,"��
0�2�&�[�[����� �16�q��:�:�A�Y�t�Q��Q��
'�:�	
��*��*�
1�*�./�

*�0�(A�/�0/�2=�>�[�[���V�d�E�]�3�' �4�' �R3�"�[�[���V�d�E�]�3�1�4�1�0
/��[�[����
�1�2�
�2�3�	
��F��F�F�6� �[�[������A�R�Z�Z�0�
�
���"�*�*�E�"�B�J�J�UV�4W��
����"�*�*�E�"�B�J�J�UV�4W��
�	
��*1�+�*1�"�<0�$
0��E
;s�&H;r�c�6�eZdZd�Zd�Zd�Zd�Zd�Zd�Zd�Z	y)	�TestGetGroupc���ttjgd��gd�gd�d��}|jd�}t	t|j��}|j|�}|jt|�j��}|jtt|���}tj||�tj||�|jddg�}t	t|j��}|j|�}|jt|d�j�|df�}|jtt|d��|df�}tj||�tj||�d	}tjt|�
�5|jd�ddd�tjt|�
�5|jd�ddd�d}tjt|�
�5|jd
�ddd�y#1swY�vxYw#1swY�MxYw#1swYyxYw)N)�10-Oct-2013r�r��11-Oct-2013r�r�)rDrDrErDrDrEr�)�DATE�label�VALr�r�rrz<must supply a tuple to get_group with multiple grouping keysrrDzHmust supply a same-length tuple to get_group with multiple grouping keys)rDrE�baz)rr��to_datetimerr�r�r)r�r�
to_pydatetime�strr9r<rrr+)rr r!r�rurR�result3r/s        r"�test_get_groupzTestGetGroup.test_get_groupts��������	�D�)�

�
��"
�J�J�v����4����>�"���+�+�c�"���+�+�i��n�:�:�<�=���+�+�c�)�C�.�1�2��
���g�w�/�
���g�w�/��J�J���(�)���4����>�"���+�+�c�"���+�+�y��Q��0�>�>�@�#�a�&�I�J���+�+�s�9�S��V�#4�5�s�1�v�>�?��
���g�w�/�
���g�w�/�M��
�]�]�:�S�
1�	�
�K�K���	�
�]�]�:�S�
1�	�
�K�K���	�X��
�]�]�:�S�
1�	/�
�K�K�-�.�	/�	/�	�	��	�	��	/�	/�s$�I
�;I�2I%�
I�I"�%I.c��tgd��}gd�}|jtj|d|�|��}|j	tj
dd��}tddgddg��}t
j||�d	}tjt|�
�5|j	tj
dd��ddd�y#1swYyxYw)
N)r)rr"r&)rrnr��r)rrnr)rruz"Interval\(10, 15, closed='right'\)rr�r�)rrr��cutr��Intervalr9r<rrr)rrrr�binsr!r>r?r/s        r"�test_get_group_empty_binsz&TestGetGroup.test_get_group_empty_bins�s����l�#����
�I�I�b�f�f�Q�q�T�4�(�8�I�<�����R�[�[��A�.�/���a��V�A�q�6�2��
���f�h�/�3��
�]�]�8�3�
/�	-�
�K�K����B��+�,�	-�	-�	-�s�%&C�Cc���tgd�gdg��j}|jd�}tdddgiddg��}|jd�}t	j
||�t
jgd��}td|D�cgc]}|f��c}i�}|jd�}|jd�}td|df|dfgiddg��}t	j
||�ycc}w)	N)�rr�r�r��idsrur�rr)�
2010-01-01�
2010-01-02r�r�)r�)rrrr�r9r<r�r�)rr r�r?r>�dtrgs       r"�test_get_group_grouped_by_tuplez,TestGetGroup.test_get_group_grouped_by_tuple�s���
�4�5�e�W�
E�
G�
G��
�Z�Z��
���e�d�D�\�2�1�a�&�A�����d�#��
���f�h�/�
�^�^�T�
U��
��b�1����1�2�
3��
�Z�Z��
�����o�.���e�r�!�u�h��A���%9�:�1�a�&�I��
���f�h�/��	 2s�
C.
c���tdd�dD�i���jd�}�j�fd��}|jtt	|j
j
����}|jtt	|j
j
����}tj||�y)Nr|c3�K�|]=}tjjd�jddd�D]}||f���
�?y�wr~rr�s   r"r�zKTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<genexpr>�r�r�r�c�&���j|dfSr�r�r�s �r"rhzJTestGetGroup.test_get_group_grouped_by_tuple_with_lambda.<locals>.<lambda>�r�rA)	rrr�r�r�r)r8r9r<r�s     @r"�+test_get_group_grouped_by_tuple_with_lambdaz8TestGetGroup.test_get_group_grouped_by_tuple_with_lambda�s����
���#��
�
���Z�Z��
!���J�J�6�7�	��<�<��T�"�)�)�.�.�*:�%;� <�=���$�$�T�$�y�/?�/?�/D�/D�/F�*G�%H�I��
���f�h�/rAc��tjd�}d}t||t��}t	d��}|j|�}t
t|�d��J�y)Nr�r�r7r5)r�r�r
r�rrr�r�)rrvr(�seriesrr0s      r"�test_groupby_with_emptyz$TestGetGroup.test_groupby_with_empty�sT��� � ��$������e�6�2���s�#���.�.��)���D��M�4�(�0�0�0rAc�@�tdtd�i�}tj|j	d�jd�|jddg�ttgd�d��g��}tj|j	d�j�|�tj|j	d�j�|�|jgd�}tj|j	d�jd	�|�y)
Nrp�abssbabrrn)rprqr)r�)rvr�r)r%rnr)rrXr9r<rr�r^rr,r8�nth)rr rzs   r"�test_groupby_with_single_columnz,TestGetGroup.test_groupby_with_single_column�s���
��T�)�_�-�
.��
���b�j�j��o�7�7��<�b�g�g�q�!�f�o�N��e�O�#�>��K��
���b�j�j��o�3�3�5�s�;�
���b�j�j��o�1�1�3�S�9��g�g�i� ��
���b�j�j��o�1�1�!�4�c�:rAc���tgd�gd�gd�ggd���}|jddg�}|jgd��j�}|jd	d
k(sJ�|jddk(sJ�y)
N)rDrErr)rDrErr)rDr�rr))rArD�thirdrGrrArD)rArDr�)rDrErr)rDr�rr)rr|rr.rPr[s  r"�test_gb_key_len_equal_axis_lenz+TestGetGroup.test_gb_key_len_equal_axis_len�sz���
#�%;�=S�T�7�
���\�\�7�H�-�
.��
�Z�Z�4�
5�
:�
:�
<���v�v�)�*�a�/�/�/��v�v�)�*�a�/�/�/rAN)
r�r�r�r�r�r�r�r�r�r�r�rAr"r�r�ss&��-/�^
-�
0�0�(1�	;�0rAr�c�6�eZdZd�Zd�Zd�Zd�Zd�Zd�Zd�Z	y)	�
TestIterationc�0�|jdg�}|j}||jusJ�|jj�D]*\}}|j|d|k(j	�r�*J�|jddg�}|j}||jusJ�|jj�D]U\}}|j|d|dk(j	�sJ�|j|d|dk(j	�r�UJ�y)Nrrrr)rr)�itemsrP�all)rr r0r)�k�vs      r"�test_groupszTestIteration.test_groups�s
���*�*�c�U�#����������'�'�'��N�N�(�(�*�	/�D�A�q��F�F�1�I�c�N�a�'�,�,�.�.�.�	/��*�*�c�3�Z�(����������'�'�'��N�N�(�(�*�	2�D�A�q��F�F�1�I�c�N�a��d�*�/�/�1�1�1��F�F�1�I�c�N�a��d�*�/�/�1�1�1�	2rAc�j�|jd�d�g�}|jjdD]}�y)Nc�"�|j�Srd)�weekdayrfs r"rhz9TestIteration.test_grouping_is_iterable.<locals>.<lambda>s��Q�Y�Y�[�rAc��|jSrd)�yearrfs r"rhz9TestIteration.test_grouping_is_iterable.<locals>.<lambda>s
��A�F�F�rAr)rr�r�)r�tsframer0r!s    r"�test_grouping_is_iterablez'TestIteration.test_grouping_is_iterables>���/�/�#8�:J�"K�L���!�!�+�+�A�.�	�A��	rAc��ttjd��}tjgd��}tjgd��}|j	||g�}t|�}dd|ddgfdd|d	gfd
d|dgfd
d|dd
gfg}t
|�D]8\}\\}}	}
||\}}}
||k(sJ�||	k(sJ�tj|
|
��:y)Nr&)rprprprqrqrq��1�2r�r�r�r�rpr�rrr�rrqr%r)rn)	r
rLr�rrrX�	enumerater9r:)rr�k1�k2r0�iteratedr?r�rGrHrI�e1�e2�e3s              r"�test_multi_iterzTestIteration.test_multi_iters����2�9�9�Q�<� ��
�X�X�4�
5��
�X�X�4�
5���)�)�R��H�%����=��
�#�q�!�Q��y�!�
�#�q�!��v��
�#�q�!��v��
�#�q�!�Q��y�!�	
��'0��&9�	.�"�A�"�
��c�E�!�!��J�B��B���9��9���9��9��"�"�5�"�-�		.rAc��tjgd��}tjgd��}ttjj	d�jd�tjj	d�jd�||d�gd���}|j
dd	g�}t|�}|j}d
d|j|dgfd
d
|j|ddgfdd|j|ddgfdd
|j|dgfg}t|�D]8\}	\\}
}}||	\}
}}|
|
k(sJ�||k(sJ�tj||��:tjgd��|d<tjgd��|d	<|j
dd	g�}|D��cic]\}}||��
}}}t|�dk(sJ�|j
gd��j�}d}tjt |��5|j"j
dd��}ddd�|D]\}}�ycc}}w#1swY�xYw)N)rqrqrqrprprpr�rr&)�v1�v2r�r�)rGrHrI�four�five�sixrur�r�rpr�r%r�r)rnrqrr)r�r�r�r�r�r�r�r�rr�r@)rLrrrMrNrOrrXrvrPr�r9r<r7r4r�r�r)r�three_groupr�r�r r0r�ryr?r�rGrHrIr�r�r�r��gpr)�three_levelsr�groups                      r"�test_multi_iter_framez#TestIteration.test_multi_iter_frame(sM��
�X�X�4�
5��
�X�X�4�
5��
��i�i�+�+�A�.�>�>�q�A��i�i�+�+�A�.�>�>�q�A���	
�A�
���*�*�d�D�\�*����=���h�h��
�#�r�v�v�c�1�#�h�'�(�
�#�r�v�v�c�1�a�&�k�*�+�
�#�r�v�v�c�1�a�&�k�*�+�
�#�r�v�v�c�1�#�h�'�(�	
��'0��&9�	-�"�A�"�
��c�E�!�!��J�B��B���9��9���9��9��!�!�%��,�		-��8�8�:�;��4���8�8�:�;��4���*�*�d�D�\�*��*1�1�g�c�2�#�r�'�1��1��6�{�a����#�*�*�?�;�@�@�B��@��
�
'�
'�
�X�
F�	C�"�n�n�,�,�!�6�,�B�G�	C�!�	�J�C���	��2�	C�	C�s�/
H>�
I�I
c	���tt|jd���tt|jddg���tt|dj|d���tt|dj|d|dg���tt|jd�d��tt|jddg�d��y)Nrrr)r�r�rr[s  r"�test_dictifyzTestIteration.test_dictifyXs����T�"�*�*�S�/�
"�#��T�"�*�*�c�3�Z�(�
)�*��T�"�S�'�/�/�"�S�'�*�
+�,��T�"�S�'�/�/�2�c�7�B�s�G�"4�5�
6�7��T�"�*�*�S�/�#�&�
'�(��T�"�*�*�c�3�Z�(��-�
.�/rAc���tddgddgd�tjddg���}|jt	d�	�d
g�}t|j�dk(sJ�|jdk(sJ�td�df|jvsJ�td
�df|jvsJ�|jtd�df�}tj||jdgdd�f�|jtd
�df�}tj||jdgdd�f�tgd�gd�d�tjgd����}|jt	d�	�d
g�}t|j�dk(sJ�|jdk(sJ�td�df|jvsJ�td
�df|jvsJ�|jtd�df�}tj||jddgdd�f�|jtd
�df�}tj||jdgdd�f�tgd�gd�d�tjgd����}|jt	d�	�d
g�}t|j�dk(sJ�|jdk(sJ�td�df|jvsJ�td
�df|jvsJ�td�df|jvsJ�|jtd�df�}tj||jdgdd�f�|jtd
�df�}tj||jdgdd�f�|jtd�df�}tj||jdgdd�f�y)N�start���.)�event�change�
2014-09-10�
2013-10-10rur�r5rrz
2014-09-30z
2013-10-31rr)rrr)rri�#)rr	z
2014-09-15)rr	z
2014-08-05r)z
2014-08-31)
rr�r�rrr7r)�ngroupsrr�r9r<r^)rr r0�ress    r"�test_groupby_with_small_elemz*TestIteration.test_groupby_with_small_elem`s������(�T�4�L�A��"�"�L�,�#?�@�
���*�*�g�4�0�'�:�;���7�>�>�"�a�'�'�'����!�#�#�#��,�'��1�W�^�^�C�C�C��,�'��1�W�^�^�C�C�C�����<�!8�'� B�C��
���c�2�7�7�A�3��6�?�3�����<�!8�'� B�C��
���c�2�7�7�A�3��6�?�3�
�1�=O�P��"�"�#M�N�
���*�*�g�4�0�'�:�;���7�>�>�"�a�'�'�'����!�#�#�#��,�'��1�W�^�^�C�C�C��,�'��1�W�^�^�C�C�C�����<�!8�'� B�C��
���c�2�7�7�A�q�6�1�9�#5�6�����<�!8�'� B�C��
���c�2�7�7�A�3��6�?�3��1�=O�P��"�"�#M�N�
���*�*�g�4�0�'�:�;���7�>�>�"�a�'�'�'����!�#�#�#��,�'��1�W�^�^�C�C�C��,�'��1�W�^�^�C�C�C��,�'��1�W�^�^�C�C�C�����<�!8�'� B�C��
���c�2�7�7�A�3��6�?�3�����<�!8�'� B�C��
���c�2�7�7�A�3��6�?�3�����<�!8�'� B�C��
���c�2�7�7�A�3��6�?�3rAc��tjtd�td�g�}tgd�g|��}|j	|d�}|j
jdj�}d}||k(sJ�y)N�AAB�abar>r)rrprzGrouping(('A', 'a')))r	r\rXrrr�r��__repr__)rr�r r�r>r?s      r"�test_grouping_string_reprz'TestIteration.test_grouping_string_repr�so��
�
#�
#�T�%�[�$�u�+�$>�
?��
�	�{�B�
/��
�Z�Z��:��
'�����&�&�q�)�2�2�4��)����!�!�!rAN)
r�r�r�r�r�r�r�rrrr�rAr"r�r��s'��2� �.�(.�`0�24�h"rAr�c��tgd�gd�gd�d��jd�}|jtd��td��gd�	�}|jj
d
jrJ�|jj
djsJ�d}tjt|�
�5|j�}ddd�tddgddgd��}tj|�y#1swY�2xYw)Nrmr�)rprqr1rpr�rqr�FrJrrz*A grouping .* was excluded from the resultrrr"rn)rqr1)rr|rrr�r��in_axisr9r�r�r8r<)r rxr/r>r?s     r"�test_grouping_by_key_is_in_axisr�s���	����C�	D�	N�	N�s�	S�B�	���W�3�'��S�)9�:�U��	K�B��{�{�$�$�Q�'�/�/�/�/�
�;�;� � ��#�+�+�+�+�7�C�	�	#�	#�M��	=����������1�v�Q��F�3�4�H����&�(�+���s�5C7�7Dc�,�tgd�dd��}td��}|j|�}d}tjt
|��5|j}ddd�|jusJ�d}tjt
|��5|j}ddd�||jusJ�d	}tjt
|��5|j}ddd�||jusJ�d
}tjt
|��5|jddd�d}tjt
|��5|jddd�y#1swY��xYw#1swY��xYw#1swY��xYw#1swY�axYw#1swYyxYw)Nr>r�rprqrpr�zUse GroupBy.groups insteadrzUse GroupBy.grouper insteadz-Grouper.obj is deprecated and will be removedzUse Resampler.ax insteadzGrouper.indexer is deprecated)rrrr9r�r�r)rr�r(�ax�indexer)r �grperrxr/rs     r"�test_grouper_groupsr�s_��	���+�	,�B����E�	���E�	�B�
&�C�	�	#�	#�M��	=���l�l����"�)�)����
'�C�	�	#�	#�M��	=���m�m����"�+�+����
9�C�	�	#�	#�M��	=���i�i����"�&�&�=��=�
$�C�	�	#�	#�M��	=��
����*�C�	�	#�	#�M��	=��
�
�
���'���
���
���
�����s<�
E�

E&�
E2�
E>�
F
�E#�&E/�2E;�>F�
F�attr)�group_index�result_index�group_arraylikec��tgd�gd�d��}|jd�}|�d�}tjt|��5t|jjd|�ddd�y#1swYyxYw)Nrmr�rrpz is deprecatedrr)rrr9r�r�r�r�r�)rr rxr/s    r"�test_depr_grouping_attrsr �sj��
���3�	4�B�	���C��B�
�F�.�
!�C�	�	#�	#�M��	=�0�����%�%�a�(�$�/�0�0�0�s�$A1�1A:) �__doc__�datetimerr�numpyrLr�pandasr�rrrrr	r
rrr
�pandas._testing�_testingr9�pandas.core.groupby.grouperrrr�r�r�rrr�r�r r�rAr"�<module>r(s�����
�
��
�
�
��0�H/�H/�^~
0�~
0�J@0�@0�Nb"�b"�J
,� �<������!S�T�0�U�0rA

Youez - 2016 - github.com/yon3zu
LinuXploit