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/reshape/merge/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : C:/Python312/Lib/site-packages/pandas/tests/reshape/merge/__pycache__/test_join.cpython-312.pyc
�

0	�g’���ddlZddlZddlZddlmcmZddlZ	ddlm
Z
mZmZm
Z
mZmZmZmZmZmZddlmZd,d�ZGd�d�Zd-d�Zd�Zd	�Zd
�Zd.d�Zd�Zej>jAd
dddgfdddgfg�d��Z!d�Z"ej>jAdddggd�fddggd�fddggd�fed�ed�ged�ed�ed�gfg�d ��Z#ej>jAd!gd"��d#��Z$d$�Z%ej>jAd%d&gd'�fd(gd'�fdgd'�fd)gd*�fg�d+��Z&y)/�N)
�Categorical�	DataFrame�Index�
MultiIndex�Series�	Timestamp�bdate_range�concat�merge�option_contextc	�^�tt|��}tjtj|||z��}t|�|kr0tjt|�|d|t|�z
z�}tjjd�j|�|S)N�)	�list�range�np�asarray�tile�len�random�default_rng�shuffle)�ngroups�n�
unique_groups�arrs    �FC:\Python312\Lib\site-packages\pandas/tests/reshape/merge/test_join.py�
get_test_datars�����w��(�M�
�*�*�R�W�W�]�A��L�9�
:�C�
�3�x�!�|��j�j��c��]�>�Q��S��\�%B�B�C���I�I���!��$�$�S�)��J�c
���eZdZejd��Zejd��Zejd��Zd�Zd�Z	d�Z
d�Zd�Zd	�Z
ejjd
dej dej$d
���g�d��Zd�Zd�Zd�Zejjddddej0ddg�g�d��Zd�Zd�Zd�Zd�Zd�Zd�Zd �Z d!�Z!d"�Z"d#�Z#d$�Z$d%�Z%d&�Z&d'�Z'd(�Z(ejjd
dej dej$d
���g�d)��Z)d*�Z*d+�Z+d,�Z,d-�Z-d.�Z.d/�Z/d0�Z0d1�Z1d2�Z2d3�Z3y)4�TestJoinc��tt�t�tjj	d�jd�tjj	d�jd�d��}||ddkD}|S)Nr�2)�key1�key2�data1�data2r$��rrrrr�standard_normal)�self�dfs  rr+zTestJoin.df%sn��
�%��%�����.�.�q�1�A�A�"�E����.�.�q�1�A�A�"�E�	
�
����6�
�Q��
���	rc��ttd��tdd��tjj	d�jd�d��S)N�
)r�)rrr)r#r$�valuer()r*s r�df2zTestJoin.df24sC���%��+�%�a�2�6����.�.�q�1�A�A�"�E�
�
�	
rc��gd�gd�gd�tdd��d�}t|tgd�t�	��
�}t|d|dd
�|d�
�}||fS)N)���?g@g@g@)r2r3r2r3r2)�foo1�foo2�foo3�foo4�foo5z1/1/2009�)�periods��A�B�C�D)�a�b�c�d�e��dtype��indexr<r?)�MergedA�MergedDr>)r	rr�object)r*�data�target�sources    r�
target_sourcezTestJoin.target_source>sb��+�*�9��Z��3�	
���4�u�-F�f�'U�V����S�	�d�3�i�8��S�	�
���v�~�rc�~�t||d��}t|||dgd��t||�}t|||ddgd��y)Nr$��on�left��howr#�r�_check_join�r*r+r0�joined_key2�joined_boths     r�test_left_outer_joinzTestJoin.test_left_outer_joinOsB���B���/���B��[�6�(��?��B��n���B��[�6�6�*:��Grc��t||dd��}t|||dgd��t||d��}t|||ddgd��y)Nr$�right�rRrUrTr#rVrXs     r�test_right_outer_joinzTestJoin.test_right_outer_joinV�G���B���G�<���B��[�6�(��@��B���1���B��[�6�6�*:��Hrc��t||dd��}t|||dgd��t||d��}t|||ddgd��y)Nr$�outerr^rTr#rVrXs     r�test_full_outer_joinzTestJoin.test_full_outer_join]r`rc��t||dd��}t|||dgd��t||d��}t|||ddgd��y)Nr$�innerr^rTr#rVrXs     r�test_inner_joinzTestJoin.test_inner_joindr`rc�:�t||dd��}d|vsJ�d|vsJ�y)Nr$�z.fooz.bar)rR�suffixes�key1.foozkey1.bar�r�r*r+r0�joineds    r�test_handle_overlapzTestJoin.test_handle_overlapks/���r�3�6�4D�E���V�#�#�#��V�#�#�#rc�<�t||ddd��}d|vsJ�d|vsJ�y)Nr$r#rh)�left_on�right_onrirjzkey2.barrkrls    r�!test_handle_overlap_arbitrary_keyz*TestJoin.test_handle_overlap_arbitrary_keyqs9�������%�
���V�#�#�#��V�#�#�#r�infer_stringFT�pyarrow)�marksc���|\}}|j|d��}tj|d|dd��tj|d|dd��td	gd
�i�}tdgd�igd
���}|j|d	��}tgd
�gd�d��}	tj||	�tdgdgdgggd
�dg��}
tdgdggddgdg��}tdgdggddgdg��}|
j|d��}|j|d��}tj|dd�sJ�tj|dd�sJ�tjtd��5|j|d��ddd�|j�}
d}tjt|��5|j|
d��ddd�y#1swY�SxYw#1swYyxYw)Nr>rQrIr<F)�check_namesrJr?�key�r@r@rArArBr/�rr'r�r@rArBrG)rrr'r'r�rxr/r'r��one�rH�columns�foo�bar�two�threerBz^'E'$��match�EzyYou are trying to merge on float64 and object|string columns for key 'A'. If you wish to proceed you should use pd.concat)�join�tm�assert_series_equalr�assert_frame_equalr�isnan�pytest�raises�KeyError�copy�
ValueError)r*rOrsrMrN�mergedr+r0rm�expected�df_a�df_b�df_c�source_copy�msgs               r�test_join_onzTestJoin.test_join_on|s���'�������V���,��
���v�i�0�&��+�5�Q�
���v�i�0�&��+�5�Q���8�9�
:����)�,�O�D��������'���-��H�
��	���f�h�/��1�#��s�Q�C���%��Q���5�'�E�7�+�A�q�6�E�7�K���1�#��s��A�q�6�G�9�E�����4�E��*�����T�e��,���x�x��u�
�c�*�+�+�+��x�x��w���,�-�-�-��]�]�8�7�
3�	(��K�K��3�K�'�	(��k�k�m��
C�	��]�]�:�S�
1�	-��K�K���K�,�	-�	-�	(�	(��	-�	-�s�.G�7G �G� G)c�r�ttjjd�j	ddgd��tjjd�jd�d��}ttjjd�j	ddgd��tjjd�jd�d�t
jtd�d	d
gg���}d}tjt|�
�5t||dd��ddd�y#1swYyxYw)Nr�m�fr}��size�r@rAr-r9r<r=rG�Flen\(left_on\) must equal the number of levels in the index of "right"r�r@T�rp�right_index�
rrrr�choicer)r�from_productrr�r�r�r�r*r+r0r�s    r�-test_join_on_fails_with_different_right_indexz6TestJoin.test_join_on_fails_with_different_right_index�s���
��Y�Y�*�*�1�-�4�4�c�3�Z�a�4�H��Y�Y�*�*�1�-�=�=�a�@�
�
����Y�Y�*�*�1�-�4�4�c�3�Z�b�4�I��Y�Y�*�*�1�-�=�=�b�A�
��)�)�5��8�c�3�Z�*@�A�
��X��
�]�]�:�S�
1�	:��"�c�3�D�9�	:�	:�	:�s�D-�-D6c	��ttjjd�j	ddgd��tjjd�jd�d�t
jtd�td�g���}ttjjd�j	ddgd	��tjjd�jd	�d��}d
}tjt|��5t||dd
��ddd�y#1swYyxYw)Nrr�r�r}r�r��abcrGr-zFlen\(right_on\) must equal the number of levels in the index of "left"r�rAT)rq�
left_index)rrrrr�r)r�from_arraysrrr�r�r�rr�s    r�,test_join_on_fails_with_different_left_indexz5TestJoin.test_join_on_fails_with_different_left_index�s���
��Y�Y�*�*�1�-�4�4�c�3�Z�a�4�H��Y�Y�*�*�1�-�=�=�a�@�
��(�(�%��(�D��K�)@�A�
����Y�Y�*�*�1�-�4�4�c�3�Z�b�4�I��Y�Y�*�*�1�-�=�=�b�A�
�
��X��
�]�]�:�S�
1�	:��"�c�C�D�9�	:�	:�	:�s�D4�4D=c�v�ttjjd�j	ddgd��tjjd�jd�d��}ttjjd�j	ddgd��tjjd�jd�d�t
jtd�d	d
gg���}d}tjt|�
�5t||dddg��ddd�y#1swYyxYw)Nrr�r�r}r�r�r-r9r<r=rGz)len\(right_on\) must equal len\(left_on\)r�r@rA)rqrpr�r�s    r�/test_join_on_fails_with_different_column_countsz8TestJoin.test_join_on_fails_with_different_column_counts�s��
��Y�Y�*�*�1�-�4�4�c�3�Z�a�4�H��Y�Y�*�*�1�-�=�=�a�@�
�
����Y�Y�*�*�1�-�4�4�c�3�Z�b�4�I��Y�Y�*�*�1�-�=�=�b�A�
��)�)�5��8�c�3�Z�*@�A�
��;��
�]�]�:�S�
1�	=��"�c�C�#�s��<�	=�	=�	=�s�D/�/D8�
wrong_typer�strNrr'c�<�tdddgi�}dt|��d�}tjt|��5t||dd��ddd�tjt|��5t||dd��ddd�y#1swY�=xYw#1swYyxYw)Nr@r'z.Can only merge Series or DataFrame objects, a z was passedr�)rprq)r�typer�r��	TypeErrorr)r*r�r+r�s    r�)test_join_on_fails_with_wrong_object_typez2TestJoin.test_join_on_fails_with_wrong_object_type�s�����a��V�}�
%��
��j�!�"�+�
/�	��]�]�9�C�
0�	=��*�b�#��<�	=�
�]�]�9�C�
0�	=��"�j�#��<�	=�	=�	=�	=��	=�	=�s�B�-B�B�Bc���|\}}|j|d��}|jddi��}|gd�}|jd�}|j||��}tj||�y)Nr>rQ�key_0�r�)r�r<r=r?rIrJ)r��rename�popr�r�)r*rOrMrNr��join_col�results       r�test_join_on_pass_vectorz!TestJoin.test_join_on_pass_vector�sk��&�����;�;�v�#�;�.���?�?�C��>�?�:���J�K���:�:�c�?�����V���1��
���f�h�/rc�l�|\}}|j|jg�d��}|D]+}||vsJ�||j�j�r�+J�|j|jg�dd��}t	j
|j|j�t|�dk(sJ�y)Nr>rQrer^r)r��reindex�isna�allr��assert_index_equalr�r)r*rOrMrNr��col�merged2s       r�test_join_with_len0zTestJoin.test_join_with_len0�s���&�������V�^�^�B�/�C��8���	,�C��&�=� �=��#�;�#�#�%�)�)�+�+�+�	,��+�+�f�n�n�R�0�S�g�+�F��
���g�o�o�v�~�~�>��7�|�q� � � rc��tdgd�i�}tdddgiddg��}|j|dd	�
�}|j|d��}||dj�}tj|d|d�tj|d|dd�
�tj
|j|j�y)Nrx)r@r@rCrArArBr/rr'r@rArGrer^rQF)�check_dtype)rr��notnar�r�r�rH�r*r+r0rmr�s     r�test_join_on_innerzTestJoin.test_join_on_inners���
��=�>�
?����1�a�&�)�#�s��<�������G��4���7�7�3�5�7�)���H�W�-�3�3�5�6��
���v�e�}�h�u�o�>�
���v�g����0A�u�U�
���f�l�l�H�N�N�;rc���tdgd�i�}tdgd�igd���}|j|dg��}|j|d��}tj||�y)Nrxryr/rzr{rGrQ�rr�r�r�r�s     r�test_join_on_singlekey_listz$TestJoin.test_join_on_singlekey_lists[��
��8�9�
:����)�,�O�D������%���)���7�7�3�5�7�)��
���f�h�/rc��|\}}|j|dd��}|j|dgd��}tj||�y)NrIr>rQ)r�r�r�)r*rOrMrNr�r�s      r�test_join_on_serieszTestJoin.test_join_on_seriessK��&�������V�I�.�3��7���;�;�v�y�k�2�s�;�;��
���f�h�/rc���tdddgi�}tdgdgd��}|j|d��}tddgddgd�|j��}t	j
||�y)	Nr@r'rrA�rH�namerQr�rG)rrr�rHr�r�)r*r+�dsr�r�s     r�test_join_on_series_bugletz#TestJoin.test_join_on_series_bugletse��
��a��V�}�
%��
�Q�C��s��
-��������$���A�q�6��A��7�r�x�x�H��
���f�h�/rc��ttjd���}d|d<d|d<ttjdd���}d	|d
<d|d<|j||�
�}t	|||�
�}tj||�|j||�
�}t	|||�
�}tj||�y)Nr-rGT�boolr��stringr9�r'�intr3�floatrT)rr�aranger��
_join_by_handr�r�)r*�	join_type�df1r0rmr�s      r�test_join_index_mixedzTestJoin.test_join_index_mixed&s����b�i�i��m�,����F����H�
��b�i�i��2�.�/����E�
���G�����#�9��-�� ��c�y�9��
���f�h�/����#�9��-�� ��c�y�9��
���f�h�/rc���tddddd�tjd�gd���}|djtjk(sJ�|d	jtj
k(sJ�tddddd�tjd
dd�gd���}|j
|dd�
�}gd�}|dd|_|dd|_t||�}tj||�y)Nr3rr�Tr;r-rr=r?r�_one�_two��lsuffix�rsuffix)�A_one�B_one�C_one�D_one�A_two�B_two�C_two�D_twor.)rrr�rF�int64�bool_r�r�r�r�r�)r*r�r0rm�expected_columnsr�s      r�test_join_index_mixed_overlapz&TestJoin.test_join_index_mixed_overlap8s�����A�E��5��)�)�B�-�(�
��
�3�x�~�~����)�)�)��3�x�~�~����)�)�)���A�E��5��)�)�A�r�1�%�(�
�����#�v�v��>��	
��'�r��*���&�q�r�*��� ��c�*��
���f�h�/rc�\�t�}|jtdgdgdg��d��y)Nr}rr<rrbrT)rr�)r*�xs  r�test_join_empty_bugzTestJoin.test_join_empty_bugXs(���K��	���y�!��Q�C�#��7�W��Erc��ttjjd�j	d�ddg��}ttjjd�j	d��}||d<ttjjd�j	d�d	g��}|j
|�|j
|�y)
Nr)�rr@rAr�r�rB)r�r'�q)rrrrr)rr�)r*r@rBrCs    r�test_join_unconsolidatedz!TestJoin.test_join_unconsolidated]s�����I�I�!�!�!�$�4�4�W�=��S�z�
��
�2�9�9�(�(��+�;�;�B�?�@����#���b�i�i�+�+�A�.�>�>�w�G�RU�QV�W��	
���q�	�	���q�	rc�X�tjgd�gd�gddg��}tjgd�gd�gddg��}ttjjd�j
d�|d	g�
�}ttjjd�j
d�|dg�
�}|jd�
�}|jd�
�}|j|d��}t|j�jt|j��}|j|�j|j|��}|j|j_
tj ||�|jj|jk(sJ�|jd�
�}|jd�
�}|j|d��jd�
�}t|j�jt|j��}|j|�j|j|��}|j|j_
tj ||�|jj|jk(sJ�y)N)r@r@r@rArArA)r'rr}r'rr}�first�second��names)rArArArBrBrBr�zvar X)rLrHr�zvar Yr)�levelrbrTr')rr�rrrrr)�
sort_indexr�r�values�unionr�r�rHr�r�)r*�index1�index2r�r0rm�ex_indexr�s        r�test_join_multiindexzTestJoin.test_join_multiindexjs���'�'�
+�-?�@��H�%�
��
�'�'�
+�-?�@��H�%�
��
����&�&�q�)�9�9�!�<���I�
��
����&�&�q�)�9�9�!�<���I�
���n�n�1�n�%���n�n�1�n�%�����#�7��+������'�-�-�e�F�M�M�.B�C���;�;�x�(�-�-�c�k�k�(�.C�D��%�|�|�����
���f�h�/��|�|�!�!�V�\�\�1�1�1��n�n�1�n�%���n�n�1�n�%�����#�7��+�6�6�Q�6�?������'�-�-�e�F�M�M�.B�C���;�;�x�(�-�-�c�k�k�(�.C�D��%�|�|�����
���f�h�/��|�|�!�!�V�\�\�1�1�1rc���gd�}gd�}tjjd�jt	|��}t|||d��}|}ttjjd�jd�|gd���}|j
|dd	gd
��}t||j�dd	gdd
gd
d��}t||dd	gdd
d��}	tj||	j|��t||dd	gdd
d��}	|jdd
gd��}|j|_
|jjsJ�tj||�y)N)
r�r�r�r�r��bazr�quxr�snap)
r�r~r�r~r�r~r�r�r�r~r)r#r$rL)r-r})�j_one�j_two�j_threerr#r$rer^r�r�F)rprqrU�sortT)rqr�rUr
r'��axis)rrrr)rrr�r�reset_indexr�r��reindex_like�droprH�is_monotonic_increasing)
r*�%lexsorted_two_level_string_multiindexr#r$rLrH�to_joinrmr��	expected2s
          r�test_join_inner_multiindexz#TestJoin.test_join_inner_multiindex�sh��V��
���y�y�$�$�Q�'�7�7��D�	�B���$��d�C�D��5����I�I�!�!�!�$�4�4�W�=��1�
�����7���'7�W��E�������!��V�$��x�(���

������f�%����

�	�	���f�i�&<�&<�V�&D�E�����f�%����

�	��=�=�'�8�!4�1�=�=��������|�|�3�3�3�3�
���f�h�/rc�^�tddggd���}|jdg�jdddgi�}tdd	ggd
���}|jdd��t	j
tjjd
��5t||dd��ddd�y#1swYyxYw)N)r'rr})r.r9r�r{r�r@rA�mean�sum)�r-r��r@rArCT)�inplacez-Not allowed to merge between different levelsr��r�r�)
r�groupby�agg�	set_indexr�r��pd�errors�
MergeErrorr)r*r+�new_df�other_dfs    r�#test_join_hierarchical_mixed_raisesz,TestJoin.test_join_hierarchical_mixed_raises�s����	�9�-��
G�����S�E�"�&�&��f�e�_�'=�>���i��4�o�N�����3���-�
�]�]��I�I� � �(W�
�	G�
�&�(�t��F�	G�	G�	G�s�
B#�#B,c� �ttjjd�j	d�ddgtj
��}ttjjd�j	d�dgtj��}|j|�}|jddk(sJ�|jddk(sJ�|jdd	k(sJ�tjjd�jd
dd�jd
�}tjjd�jd�jd�}tjjd�jd�jd	�}t|||d��}t|||d��}ttjjd�jd�jd	�dg��}|j|dd��}|jdd
k(sJ�|jddk(sJ�|jdd	k(sJ�|jdd	k(sJ�|j|dd��}	tj||	�y)Nr)r-rr@rA�r�rF)r-r'rB�float64�float32rr9�dr�r{�mdr�Tr�)rrrrr)r*r+r��dtypes�integers�astyperr�r�)
r*r@rArmrBr+�xpdf�s�rs�xps
          r�test_join_float64_float32z"TestJoin.test_join_float64_float32�s,����I�I�!�!�!�$�4�4�W�=��#�J��*�*�
��

��I�I�!�!�!�$�4�4�W�=��E��*�*�
��
�������}�}�S�!�Y�.�.�.��}�}�S�!�Y�.�.�.��}�}�S�!�Y�.�.�.��I�I�!�!�!�$�-�-�a��C�8�?�?��H���I�I�!�!�!�$�+�+�C�0�7�7�	�B���I�I�!�!�!�$�+�+�C�0�7�7�	�B��
�Q�Q�Q�/�
0���q�q�q�1�2����I�I�!�!�!�$�+�+�A�.�5�5�i�@�4�&�
���X�X�a��$�X�
7���y�y��~��(�(�(��y�y��~��*�*�*��y�y��~��*�*�*��y�y���)�+�+�+�
�Z�Z��3�D�Z�
9��
���b�"�%rc���tddgddgddgd��}tddgddgddgd��}tddgddgd	d
gd��}|jdd
g�}|jdd
g�}|jdd
g�}|j||gd��}t||dd
gd��}t||dd
gd��}	|j	�}|	|j
}	|	jjd�|	d<|	jjd�|	d
<tj||	�tgd�gd�gd�d��}tgd�gd�gd�d��}tgd�gd�gd�d��}|jdd
g�}|jdd
g�}|jdd
g�}|j||gd��}t||dd
gd��}t||dd
gd��}	|j	�}tj||	jdd�|j
f�tgd�gd�tjjd�jd�tjjd�jd�d��}
t!tj"tj$d�d�tj"tj$d�d�d��}|
j|d��}|
j|d��}
|
j|d��}|
j|d��}tj||
�tj||�tj||�y) Nr'r-�r{rr,��r����)r@rArDr@rArbrTr^r�)r'r'r')r-r7r�)r'r'r)r,r8i,)r9r:i�re)r�r�r�r�r�r�r�r�)r~r~r�r�r�r�r~r��r;�TESTr�rSr])rr!r�rrr�r@r0rAr�r��locrrrr)r�repeatr�)r*r�r0�df3�idf1�idf2�idf3r��df_partially_mergedr�r+r2rerbrSr]s                r�test_join_many_non_unique_indexz(TestJoin.test_join_many_non_unique_indexs	���q�!�f�A�q�6��R��A�B���q�!�f�A�q�6��c�
�C�D���q�!�f�A�q�6��t��E�F���}�}�c�3�Z�(���}�}�c�3�Z�(���}�}�c�3�Z�(�����D�$�<�W��5��#�C��#�s���I���,�c�s�C�j�g�N���#�#�%���F�N�N�+�� �
�
�)�)�'�2���
� �
�
�)�)�'�2���
�
���f�h�/��i�i�l�K�L���i�i�o�N�O���i�i�>P�Q�R���}�}�c�3�Z�(���}�}�c�3�Z�(���}�}�c�3�Z�(�����D�$�<�W��5��#�C��#�s���I���,�c�s�C�j�g�N���#�#�%��
���f�h�l�l�1�f�n�n�3D�&E�F��M�Q��Y�Y�*�*�1�-�=�=�a�@��Y�Y�*�*�1�-�=�=�a�@�	
�
��
��I�I�b�i�i��l�A�&�b�i�i��	�	�!��a�.H�v�
������w��'������w��'���w�w�q�f�w�%������w��'��
���e�U�+�
���e�T�*�
���e�U�+rc	��td|�5tgd�gd�d��}tdgd�igd���}|j|d	d
��}tgd�gd
�gd�d�gd���}tj||�|j|d	d��}tj
|jttd��d
��ddd�y#1swYyxYw)Nzfuture.infer_string)r�r�rr��r'rr}r.r|�value2r{)r�rr�rGrxT)rRr
)r�rr�r�)rr}r'r.)r@rArBrB)rxr/rG)r'rrr}Fr.)�exact)	rrr�r�r�r�rHrr)r*rsrSr]rmr�s      r�test_join_sortzTestJoin.test_join_sort7s����1�<�
@�	M��4�|�L��D��x��9�AV�W�E��Y�Y�u��T�Y�:�F� �7�)�2��
#�
�H�
�!�!�&�(�3��Y�Y�u��U�Y�;�F��!�!�&�,�,��e�A�h��t�L�'	M�	M�	M�s�B1C�Cc���tdgd�igd���}tdgd�igd���}|j|�}tgd�d	tjd
dtjgd�gd
���}t	j
||�tdgd�igd���}tdgd�igd���}|j|�}tgd�d	d
d
tjgd�gd���}t	j
||�y)Nr@rF)r'rr}r@rGrA)r9r�rr;)r'r}r}r.)r'rr}r}r.r9r�rr�)r'rr}r}r@)r'rrr@)rr�r�nanr�r�)r*r�r0r�r�r?�df4s       r� test_join_mixed_non_unique_indexz)TestJoin.test_join_mixed_non_unique_indexPs�����l�+�>�B����l�+�<�@�����#����!��B�F�F�A�q�"�&�&�(A�B�#�
��	���f�h�/���l�+�>�B����l�+�<�@�����#�����a��A�r�v�v�%6�7�~�
��	���f�h�/rc	���tjddd��}ttt	t|���|dg��}t
||g�}|j|dd�	�}ttjtjdtj�
�jd�jdd
�d�ddg|j�j��}t!j"||�y)Nz
2016-01-01��M)r:�freq�pnumrre�_df2)rUr�rEr���r'�pnum_df2�r�rH)r"�period_rangerrrrr
r�rrr�r�r>�reshaper�rHr�r�)r*rHr+r0r�r�s      r�!test_join_non_unique_period_indexz*TestJoin.test_join_non_unique_period_indexcs�������b�s�C��
�t�E�#�e�*�-�.�e�f�X�
N���b�"�X�������'�6��:����G�G�B�I�I�b����1�8�8��;�C�C�B��J�A�N��Z�(��.�.�"�(�(�
��
	���f�h�/rc��ttjjd�j	d�gd���}|jddd�|jddd	�|j
d�}tjd
�}tjt|��5|j�ddd�|jd�
�}|j�}|j|d��y#1swY�?xYw)Nr)r7r�)r@rArBrCrDr�r�r�idr9�dtr�z&agg function failed [how->mean,dtype->r�T)�numeric_only�_right�r�)rrrrr)�insertr�re�escaper�r�r�r�countr�)r*r+�groupedr��mn�cns      r� test_mixed_type_join_with_suffixz)TestJoin.test_mixed_type_join_with_suffixps���
��I�I�!�!�!�$�4�4�W�=�2�
��	�	�	�!�T�1��
�	�	�!�T�5�!��*�*�T�"���i�i�@�A��
�]�]�9�C�
0�	��L�L�N�	�
�\�\�t�\�
,��
�]�]�_��	����H��%�
	�	�s�#C2�2C;c��ttjjd�j	d�td���}|ddg|ddg|d	d
gg}|dj
|dd�}tj||�|ddgdd
|ddgdd|d	d
gddg}d�}|dj
|ddd��}||||j�|dj
|dd�}||||dj�|dj
|ddd��}||||jdd�d}tjt|��5|dj
|ddd��ddd�y#1swYyxYw)Nr)r-r��abcdefr�r@rArBrCrDr�rr'����	c��|D�cgc]}|j|���}}|dj|dd�}tj||�ycc}w)Nrr')r�r�r�r�)�df_listr��	exp_indexr��	reindexedr�s      r�_check_diff_indexz2TestJoin.test_join_many.<locals>._check_diff_index�sN��7>�?�!����9�-�?�I�?� ��|�(�(��1�2��7�H��!�!�&�(�3��@s�A
rbrTrer;z?Joining multiple DataFrames only supported for joining on indexr�rQ)
rrrrr)rr�r�r�rHr�r�r�)r*r+rmrmrpr�s      r�test_join_manyzTestJoin.test_join_many�s���
��I�I�!�!�!�$�4�4�W�=�t�H�~�
���s�C�j�>�2�s�C�j�>�2�s�C�j�>�B�����������-��
���f�b�)��s�C�j�>�#�2�&��C��:��q�r�(:�B��S�z�N�1�Q�<O�P��	4����������'��:���'�6�2�8�8�4����������-���'�6�7�1�:�+;�+;�<����������'��:���'�6�2�8�8�A�a�=�9�O��
�]�]�:�S�
1�	1��A�J�O�O�G�A�B�K�C�O�0�	1�	1�	1�s�E/�/E8c�\�ttjjd�j	d�gd���}ddgdz|d<|j
dd�d	d
gf}|j
dd�ddgf}|j
dd�dgf}|j
||g�}tj||�y)
Nr)r;r.r;r�r�r�r.rxr<r=r>r?)	rrrrr)r=r�r�r�)r*r+r�r0r?r�s      r�test_join_many_mixedzTestJoin.test_join_many_mixed�s���
��I�I�!�!�!�$�4�4�V�<�(�
���E�N�Q�&��5�	��f�f�Q��c�
�]�#���f�f�Q��c�
�]�#���f�f�Q���Z� �����3��*�%��
���f�b�)rc
��tttjj	d�jd�gd���ttjj	d�j
ddd��jdd�d	d
g��gd��}t||gd��}|j|d
��}|j|_	tj||�ttjj	d�jd�ddg��}ttjj	d�jd�ddg��}ttjj	d�jd�ddg��}ttjj	d�jd�ddg��}|j|dd��j|ddd��}tjtj j"d��5|j|dd��ddd�y#1swYyxYw)Nr)r-r.)r<r<r=r=r�rr-r7r�r<r>r'r�_2r_)r.rr��yTrrb)r�r�rUz0Passing 'suffixes' which cause duplicate columnsr�)r
rrrrr)r/rXr�r�r�r�rr�r�r"r#r$)	r*r+r�r��wr�rv�z�dtas	         r�test_join_dupszTestJoin.test_join_dups�s���
���I�I�)�)�!�,�<�<�W�E�0����I�I�)�)�!�,�5�5�a��"�5�E�M�M�b�RS�T� �#�J��	
��
���2�r�(��+������T��*��!�)�)���
���f�h�/�
��I�I�!�!�!�$�4�4�V�<�s�C�j�
��
��I�I�!�!�!�$�4�4�V�<�s�C�j�
��
��I�I�!�!�!�$�4�4�V�<�s�C�j�
��
��I�I�!�!�!�$�4�4�V�<�s�C�j�
���g�g�a�D�d�g�;�A�A�
�$�D�g�B�
���]�]��I�I� � �D�
�	<�
�I�I�a�D�d�I�;�		<�	<�	<�s� H>�>Ic�B�tjtd�td�ddgggd���}tdt	d�i|�	�}tjtd�td�gddg��}td
t	dd�D�cgc]}d|z��	c}i|�	�}|j|ddg|�
�}|j
�j|j
�ddg|�
�jgd��}tj||�d}	tjt|	��5|j|d|�
�ddd�tjt|	��5|j|ddg|�
�ddd�ycc}w#1swY�IxYw#1swYyxYw)Nr��xyr'r)r�r|�numr��v1�rG�v2rr,r^r�r�)rr�rrrr�rrr!r�r�r�r�r�)
r*r��	leftindexrS�
rightindex�ir]r�r�r�s
          r�test_join_multi_to_multiz!TestJoin.test_join_multi_to_multi�ss���+�+�
�%�[�$�t�*�q�!�f�-�5I�
�	��$��b�	�*�)�<���,�,�
�%�[�$�t�*�%�e�T�]�
�
��4�5��A�;�!?�a�#��'�!?�@�
�S�����5�e�T�]�	��B������
�U�5�$�$�&�E�4�=�i�U�
H�
�Y�+�
,�	�
	���h��/�W��
�]�]�:�S�
1�	5��I�I�e��)�I�4�	5��]�]�:�S�
1�	>��J�J�t���
�9�J�=�	>�	>��"@�	5�	5��	>�	>�s�
F
�,F	�$F�	F�Fc��ttjddd��td�d��}ttjddd��td�d	��}|j	|jd
�d
��}|j
�}ttjgdztd
�z�|d<tj||�y)Nz
2018-01-01r9zAmerica/Chicago)�startr:�tz�abcde)�date�valsz
2018-01-03�tuvwx)r��vals_2r�rQr�tuvr�)rr"�
date_rangerr�r!r�rrrKr�r�)r*r�r0r�r�s     r�#test_join_on_tz_aware_datetimeindexz,TestJoin.test_join_on_tz_aware_datetimeindex�s�����
�
�&��6G���W�
�	
�
����
�
�&��6G���w�-�	
�
�����#�-�-��/�F��;���8�8�:��#�R�V�V�H�q�L�4��;�$>�?����
���f�h�/rc��tgd�gd�gd�gd�ggd���}tj|d�jd�|d<tgd	�gd
�ggd�dd
g��}tj|d�jd�|d<|j	|jddg�ddg��}tt
d�dddgt
d�dddggdd
ggd���}|djd�|d<tj||�y)N)�
2012-08-02�Lr-)r��Jr�)�
2013-04-06r�r7)r�r��)r�rvr@r�r�zM8[ns])r�r�r')r�r�r)r�rvrxrr.rVrvrQz2012-08-02 00:00:00r�r'r�z2013-04-06 00:00:00r�r7)r�rvrxr@r)	rr"�to_datetimer0r�r!rr�r�)r*�dfa�dfbr�r�s     r�test_join_datetime_stringz"TestJoin.test_join_datetime_strings���'�'�'�'�	
�$�
���>�>�#�c�(�+�2�2�8�<��C���
#�%;�<�#��a�&�
��
�>�>�#�c�(�+�2�2�8�<��C�����#�-�-��c�
�3��c�
��C����0�1�3��2�>��0�1�3��2�>�
��a�&�(�

��!��
�,�,�X�6���
�
���f�h�/rc��ddg}tj||��}tjt|�t|���}td|i|��}tdt|�i|��}|j	|�}tddgddgd�tjddgddg����}tj||�y)Nr@rA��
categories�c1rG�c2)r�r�)r"�CategoricalIndex�reversedrr�r�r�)r*�ix�id1�id2r�r0r�r�s        r� test_join_with_categorical_indexz)TestJoin.test_join_with_categorical_index,s����3�Z���!�!�"��4���!�!�(�2�,�8�B�<�H����r�
�#�.����x��|�,�C�8�����#������:�c�3�Z�0��%�%�s�C�j�c�3�Z�H�
��	���f�h�/r)4�__name__�
__module__�__qualname__r��fixturer+r0rOr[r_rcrfrnrr�mark�parametrize�param�td�
skip_if_nor�r�r�r�r�arrayr�r�r�r�r�r�r�r�r�r�r�rrr'r5rDrIrMrYrgrqrsrzr�r�r�r��rrr r #s����^�^�����^�^�
��
��^�^���� H�I�I�I�$�	$��[�[���������T�����y�9Q� R�S��$-��$-�L:�$:�$=�$�[�[���\�A�u�d�H�B�H�H�a��V�<L�+M�N�=�O�=� 0�
!�
<�0�0�0�0�$0�@F�
�)2�V:0�|G�&�B4,�l�[�[���������T�����y�9Q� R�S��M��M�,0�&0�&�&1�<*�+<�Z>�60�00�<
0rr rSc��|D]%}||j�j�r�%J�|j|�}|j|�}	|j|�D]o\}
}t||j|�}t||j|�}
	|j|
�}t
||�	|	j|
�}t
|
|��qy#t$r5}|dvrtd|
�d��|�t||j|�Yd}~�Zd}~wwxYw#t$r5}|dvrtd|
�d��|�t|
|j|�Yd}~��d}~wwxYw)N)rSrezkey z! should not have been in the join)r]re)
r�r�r�_restrict_to_columnsr��	get_group�_assert_same_contentsr��AssertionError�_assert_all_na)rSr]r�r�rUr�r�rB�left_grouped�
right_grouped�	group_key�group�l_joined�r_joined�lgroup�err�rgroups                 rrWrW<sh��
�'���a�y��� �$�$�&�&�&�'��<�<��)�L��M�M�(�+�M�"�N�N�8�4�4��	�5�'��t�|�|�W�E��'��u�}�}�g�F��
	4�!�+�+�I�6�F�
"�(�F�3�
	4�"�,�,�Y�7�F�
"�(�F�3�54���	=��'�'�$��9�+�%F�G����
�8�T�\�\�8�<�<��
	=���	>��(�(�$��9�+�%F�G����
�8�U�]�]�H�=�=��
	>�s0�C�1D�	D�+D
�
D�	E�+E�Ec����|jD�cgc]}||vs|j�d�|vs�|��}}|jdd�|f}|j�fd���}|jdd�|f}|Scc}w)N�c�(��|j�d�S)Nr�)�replace)r��suffixs �r�<lambda>z&_restrict_to_columns.<locals>.<lambda>js���1�9�9�V�R�+@�rr�)r�r�r=r�)r�r�r�rB�founds  `  rr�r�as~����=�=�
��A��L�A�I�I�f�b�4I�W�4T��
�E�
�

�I�I�a��h��E�
�L�L�!@�L�A�E�
�I�I�a��j�!�E��L��
s
�A1�A1c�H��d}|j|�j�j}|j|�j�j}|D�chc]
}t|���c}�t	��t	|�k(sJ�t�fd�|D��sJ�ycc}w)Niy)�c3�8�K�|]}t|��v���y�w�N)�tuple)�.0�row�rowss  �r�	<genexpr>z(_assert_same_contents.<locals>.<genexpr>zs�����5�c�u�S�z�T�!�5�s�)�fillna�drop_duplicatesrr�rr�)�
join_chunkrN�NA_SENTINEL�jvalues�svaluesr�r�s      @rr�r�rs�����K�����,�<�<�>�E�E�G��m�m�K�(�8�8�:�A�A�G�")�*�3�E�#�J�*�D��t�9��F��#�#�#��5�W�5�5�5�5��+s�Bc�b�|D]*}||vr�||j�j�r�*J�yr�)r�r�)r��source_columnsr�rBs    rr�r�}s:��
�*����=���!�}�!�!�#�'�'�)�)�)�*rc�<�|jj|j|��}|j|�}|j|�}|jj	|j�}|j�D]
\}}|||<�|j|��S)NrTr�)rHr�r�r��append�items)	r@rArU�
join_index�a_re�b_re�result_columnsr�r2s	         rr�r��s��������a�g�g�3��/�J��9�9�Z� �D��9�9�Z� �D��Y�Y�%�%�a�i�i�0�N��*�*�,����Q���S�	���<�<��<�/�/rc�:�tdditjdgd����}tdditjd	gd
����}|j|d��}tdgdgd
�tjdgd����}t	j
||�y)NrDr9)r'rr.rr��rLrHr�r�)rr})rArBrerT)rDr�)r'rr.r})r@rArCrBrG�rr�from_tuplesr�r�r�)rSr]r�r�s    r�.test_join_inner_multiindex_deterministic_orderr��s�����1�X��$�$�i�[��H��D�
��1�X�Z�3�3�V�H�J�O�
�E��Y�Y�u�'�Y�
*�F���c�����$�$�l�^�;O�P��H����&�(�+r)�	input_col�output_colsrAr@�a_x�a_yc���tdddgi�}t|ddgi�}|j|ddd��}t|d	gd
�|dgd�i�}tj||�y)Nr@r'r}r.�cross�_x�_y)rUr�r�r)r'r'r}r})r}r.r}r.r�)r�r�rSr]r�r�s      r�test_join_crossr��sj��
�c�A�q�6�]�#�D��y�1�a�&�)�*�E�
�Y�Y�u�'�4��Y�
F�F��+�a�.�,��A���U�V�H����&�(�+rc��tdditjdgd����}tdditjd	gd
����}|j||��}|dk(r+tdgdgd
�tjdgddg����}n*tdgdgd
�tjdgddg����}t	j
||�y)NrBr})r'rr�r�r�rCr.)r)rArTr])rBrC)rr'rAr@rGr�)r�rSr]r�r�s     r�test_join_multiindex_one_levelr��s�����1�X�Z�3�3�V�H�J�O��D�
�C��8�:�+A�+A�4�&�PV�+W�X�E�
�Y�Y�u�)�Y�
,�F��G����#�Q�C� ��(�(�&��#�s��D�
��
��#�Q�C� ��(�(�&��#�s��D�
�����&�(�+rzcategories, values�Y�X)r�r�r�rr')rr'r'�@��?)r�r�r�z
2020-12-31z
2019-12-31c�x�tddgt||��ddgd��jddg�}tgd�t||��gd	�d��jddg�}|j|d
d��}tddgt||��ddgd
dgd��jddg�}t	j
||�y)Nr<r�r'r)r�r�r/r�r�)r<r<r=)r}r.r9�_leftr^r�r}r.)r�r��
value_left�value_right�rrr!r�r�r�)r�rrSr]r�r�s      r�1test_join_multiindex_not_alphabetical_categoricalr��s�����3�Z�!�*��D���V�	
���i��(�#�$�
	�
�$�!�&�Z�@��	
�
��i��(�#�$�

��Y�Y�u�g�x�Y�
@�F���3�Z�!�*��D��a�&��q�6�		
���i��(�#�$�
����&�(�+rzleft_empty, how, exp)
)FrSrS)Fr]�empty)Frer�)FrbrS)Fr�r�)TrSr�)Tr]r])Trer�)Trbr])Tr�r�c��tddgddgd�d��jd�}tdgd	gd
�d��jd�}|r|jd�}n|jd�}|j||��}|d
k(rCtddgddgtj
tj
gd��}|jd�}na|dk(r2ttj
gdgd	gd��}|jd�}n*|dk(r%tddgd��}|dk7r|j
d�}|dk(rj�}tj|�y)Nrr'r}r.)r<r=r�rEr<r9)r<r>rrTrS)r<r=r>r])r=r<r>r�r=r>r)r�rb)
rr!�headr�rrK�rename_axisr�r�r�)�
left_emptyrU�exprSr]r�r�s       r�test_join_emptyr��s9�� �A�q�6��A��/�w�?�I�I�#�N�D��Q�C�q�c�*�'�:�D�D�S�I�E���y�y��|���
�
�1�
��
�Y�Y�u�#�Y�
&�F�
�f�}��A�q�6��A��b�f�f�b�f�f�=M�N�O���%�%�c�*��	����B�F�F�8�1�#�Q�C�@�A���%�%�c�*��	����c�3�Z�w�?���'�>��+�+�C�0�H�
�g�~��&�&�(�����&�(�+rc�B�t�}tdg��}tddg��}||z}tdg��}tj||�||z}tgd���}tj||�||z}tddg��}tj||�y)N�testr�r��r�r)rr�r�)rr�r�)r�r0r?r�r�s     r�$test_join_empty_uncomparable_columnsrs���
�+�C�
�V�H�
%�C�
�U�N�3�
4�C�
�3�Y�F��&��*�H����&�(�+�
�3�Y�F��!@�A�H����&�(�+�
�3�Y�F��.�%�!8�9�H����&�(�+rzhow, valuesrerzrbr]�rrr'c��ttgd��tgd��gd�d��jddg�}ttgd��tgd��gd�d��jddg�}tt|�t|�||d��jddg�}|j||��}t	j
||�y)	Nrzr{r@rArr)r@rArBrCrTr�)rUrr�r0r�r�s      r�3test_join_multiindex_categorical_output_index_dtyper(s�����Y�'��Y�'��	
���i��c�
��
���Y�'��Y�'��	
���i��c�
��
���V�$��V�$���		
���i��c�
��
��X�X�c�s�X�
#�F����&�(�+r)r;r")rSr�r�)rS)'ra�numpyrr��pandas.util._test_decorators�util�_test_decoratorsr��pandasr"rrrrrrr	r
rr�pandas._testing�_testingr�rr rWr�r�r�r�r�r�r�r�r�r�r�rrr�rr�<module>rs���	��
�)�)�������V0�V0�r"4�J�"6�*�
0�,�"����� �C�#�s��#4�s�U�E�N�6K�"L��,��,�,�(������

�s��_�%�
�Q����

�s��_�%�
�|�
$�i��&=�>�
�|�
$�i��&=�y��?V�W�	
�	��,��,�:��������,��,�6,�&������	�)��	�)��	���	�)��	��,��,r

Youez - 2016 - github.com/yon3zu
LinuXploit