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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

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

/	�gsD���ddlmZddlZddlZddlmZddlZddlmZm	Z	m
Z
mZmZddl
mZddlmZej$d��Zej$d��Zej$d��Zej$d	��Zej$d
��Zej$d��Zej$d��Zej4j7d
ddeddgddgd�ddg��fddeddgddgd�ddg��fddegd�ddej8gd�gd���fddegd�ej8ddgd�gd���fddeej8ddggd�d�gd ���fddeddej8ggd!�d�gd"���fd#dedddej8gej8ddd$gd�gd%���fd#dedddej8gej8ddd$gd�gd%���fg�d&��Zd'�Zd(�Zej4j7d)d*d+g�d,��Z d-�Z!d.�Z"d/�Z#d0�Z$d1�Z%d2�Z&d3�Z'd4�Z(d5�Z)d6�Z*ej4j7d7ddg�d8��Z+Gd9�d:�Z,y);�)�datetimeN)�
MergeError)�	DataFrame�Index�
MultiIndex�
date_range�period_range)�concatc	��ttjd�jdd�t	d�tddd����S)	N����abcde�2000�Y)�start�freq�periods��data�columns�index)r�np�arange�reshape�listr	���FC:\Python312\Lib\site-packages\pandas/tests/frame/methods/test_join.py�frame_with_period_indexr s:���
�Y�Y�r�]�
"�
"�1�a�
(��W�
���c�1�=��rc�(�tdgd�igd���S)N�a�r�
r���r�r�rrrr�leftr*s���c�;�'�y�9�9rc�(�tdgd�igd���S)N�b��,�d����r'r&r(r)rrr�rightr3"s���c�?�+�9�=�=rc�<�tgd�gd�d�td���S)N�r"r,�c�d��cat�dog�weasel�horse�r"r,r
r()r�rangerrr�left_no_dupr?'s���"�)J�K��A�h��rc�Z�tgd�gd�d�td���jd�S)N)r"r,r6r7�e)�meow�bark�um... weasel noise?�nay�chirp�r"r6rr(r")rr>�	set_indexrrr�right_no_duprI/s.���*�H�	
��A�h���i��n�
rc�B�t|tdgdgd�dg��gd��S)Nr"�cowr=r2r(T)�sort)r
r)r?s r�left_w_dupsrM:s+���	�i�s�e�5�'� :�1�#�F�G�d��rc�\�t|tdgdgd�dg��g�jd�S)NrA�moorGr2r(r")r
rrH)rIs r�right_w_dupsrPAs2���	�y��u�E�7�!;�A�3�G�H���i��n�rzhow, sort, expected�innerFrr$r0r/r=r&r'r(Tr*r#r%�rr$r)rr'r&r3r-r1�r/r0r.�r'r&r2�outerr.)rr'r&r2c�Z�|j|||d��}tj||�y)N�1:1)�howrL�validate)�join�tm�assert_frame_equal)r*r3rXrL�expected�results      r�	test_joinr_Hs+��X�Y�Y�u�#�D�5�Y�
A�F����&�(�+rc��tdgd�i�}tgd�gd�d��}tgd�gd�d��}d}tjt|��5|j	|gd	�
�ddd�tjt|��5|j	||gd��ddd�tjt|��5|j	||gd	d�
�ddd�tjtd��5|j	||g�ddd�|j	|g�}|j	|�}tj||�y#1swY��xYw#1swY��xYw#1swY��xYw#1swY�gxYw)N�key)r'r&r2r
r)r'�r2r&r)ra�v1)rr&r2r
r')�keys�v2z7Suffixes not supported when joining multiple DataFrames��match�y)�lsuffix�x)�rsuffix�rirkzIndexes have overlapping values)r�pytest�raises�
ValueErrorrZr[r\)�first�second�third�msg�
arr_joined�norm_joineds      r�test_suffix_on_list_joinrvxs@���u�o�.�/�E�
��o�F�
G�F���o�F�G�E�D�C�	���z��	-�*�
�
�
�F�8�S�
�)�*�	���z��	-�1�
�
�
�F�E�?�C�
�0�1�	���z��	-�>�
�
�
�F�E�?�C��
�=�>�	���z�)J�	K�$�
�
�
�F�E�?�#�$����U�G�$�J��*�*�U�#�K����*�k�2�*�*��1�1��>�>��$�$�s0�E�	E�E*�<E6�E�E'�*E3�6E?c��d}tjt|��5|j|dd��ddd�y#1swYyxYw)Nz�"invalid" is not a valid argument. Valid arguments are:
- "1:1"
- "1:m"
- "m:1"
- "m:m"
- "one_to_one"
- "one_to_many"
- "many_to_one"
- "many_to_many"rfr"�invalid��onrY)rmrnro�merge)r?rIrss   r�test_join_invalid_validater|�sJ��		��
���z��	-�D����,�3���C�D�D�D�s	�<�A�dtype�object�string[pyarrow]c�N�|dk(rtjd�|j|�}|jj|�|_|j	|dd��d}tj
t|��5|j	|dd��ddd�y#1swYyxYw)	Nr�pyarrowr"�one_to_manyryzBMerge keys are not unique in right dataset; not a one-to-one mergerf�
one_to_one)rm�importorskip�astyperrZrnr)r?rPr}rss    r�$test_join_on_single_col_dup_on_rightr��s���
�!�!����I�&��$�$�U�+�K�%�+�+�2�2�5�9�L����������O�C�	���z��	-�
������!�	�	
�
�
�
�s�=B�B$c��|j|dd��d}tjt|��5|j|dd��ddd�y#1swYyxYw)Nr"�many_to_oneryzAMerge keys are not unique in left dataset; not a one-to-one mergerfr��rZrmrnr)rMrIrss   r�#test_join_on_single_col_dup_on_leftr��sg����������N�C�	���z��	-�
������!�	�	
�
�
�
�s�A�Ac�D�|j|dd��d}tjt|��5|j|dd��ddd�d}tjt|��5|j|dd��ddd�y#1swY�DxYw#1swYyxYw)	Nr"�many_to_manyryzCMerge keys are not unique in right dataset; not a many-to-one mergerfr�zBMerge keys are not unique in left dataset; not a one-to-many merger�r�)rMrPrss   r�#test_join_on_single_col_dup_on_bothr��s������\�c�N��C�P�C�	���z��	-�
������"�	�	
�
�O�C�	���z��	-�
������"�	�	
�
�
�
�
��
�
�s�B
�,B�
B�Bc��tgd�gd�gd�d�td���jddg�}tgd	�gd
�gd�d�td
���jddg�}tgd	�gd
�gd�gd�d�td
���jddg�}|j|dd��}t	j
||�y)N)r"r"r,r,)rr'rr'r8�r"r,r6r
r(r"r,)r"r"r,)rr'r)rBrCrD)r"r,r7r2)r9r:r;r5rQrW)rXrY)rr>rHrZr[r\)r*r3�expected_multir^s    r� test_join_on_multi_col_check_dupr��s����%��2�	
�
�A�h�
��i��c�
��	�
� ��8�	
�
�A�h�

��i��c�
��
�� ��)�8�		
��A�h���i��c�
����Y�Y�u�'�E�Y�
:�F����&�.�1rc��|j|jddddgf}|j|jddddgfjddd�}|j|�}t	j
|j|j�t
gd��}t	j
|j|�|j|d	�
�}t	j
|j|j�t	j
|j|�|j|d�
�}t	j
|j|j�t	j
|j|�|j|d�
�}t	j
|j|jdd�t	j
|j|�|j|d
�
�}t	j
|j|jj��t	j
|j|�tjtd��5|j|d�
�ddd�d}dD]9}tjt|��5|j||�
�ddd��;y#1swY�JxYw#1swY�RxYw)Nr$�A�Br�C�D���)r�r�r�r�r*�rXr3rQrUzjoin methodrf�foozcolumns overlap but no suffix)rUr*rQ)�locr�ilocrZr[�assert_index_equalrr�sort_valuesrmrnro)�float_frame�f�f2�joined�expected_columnsrsrXs       r�test_join_indexr�s6��	����)�)�#�2�.��c�
�:�;�A�	����*�*�1�2�.��c�
�:�	;�	@�	@��2��	F�B�
�V�V�B�Z�F����!�'�'�6�<�<�0��1�2�����&�.�.�*:�;�
�V�V�B�F�V�
#�F����&�,�,����0����&�.�.�*:�;�
�V�V�B�G�V�
$�F����&�,�,����1����&�.�.�*:�;��V�V�B�G�V�
$�F����&�,�,�����"�
�6����&�.�.�*:�;��V�V�B�G�V�
$�F����&�,�,��(9�(9�(E�(E�(G�H����&�.�.�*:�;�	���z��	7��	���r�u����*�C�)�3��
�]�]�:�S�
1�	3����[�c��2�	3�	3�3����	3�	3�s�J6�K�6J?�K	c���|jdd�ddgf}|jddd�ddgf}|j�}|dddd�|d<|dddd�|d<|j|�}tj||�|j|d��}tj||ddd��|j|d��}tj||jdd�|j
f�y)Nr�r�r&r�r�r3r�)r��copyrZr[r\r)r��af�bfr]r^s     r�test_join_index_morer�1s���	����S�#�J��	'�B�	����1��s�C�j��	)�B��w�w�y�H���$�S�q�S�)�H�S�M���$�S�q�S�)�H�S�M�
�W�W�R�[�F����&�(�+�
�W�W�R�W�W�
%�F����&�(�3�Q�3�-�0�
�W�W�R�W�W�
%�F����&�(�,�,�q�&�.�.�/@�"A�Brc�>�|j�}|j|jd�}|j|�}t	j
||�d|_tjtd��5|j|�ddd�y#1swYyxYw)Nr�zmust have a namerf)
r��poprrZr[r\�namermrnro)r��df�serr�s    r�test_join_index_seriesr�Cs|��	�	�	�	�B�
�&�&��$�$�R�(�
)�C�
�W�W�S�\�F����&�+�.��C�H�	���z�);�	<��
��������s�8B�Bc���|jdd�gd�f}|jdd�gd�f}|j|dd��}|jdd�ddgfjd�}|jdd�ddgfjd�}|jdd�dd	gf}|j|�j|�}tj||jdd�|j
f�y)
N)r�r�r�)r�r�r��_df1�_df2rlr�r�r�r�)r�rZ�
add_suffixr[r\r)r��df1�df2r��df1_suf�df2_suf�
no_overlapr]s        r�test_join_overlapr�Os���
�/�/�!�_�,�
-�C�
�/�/�!�_�,�
-�C�
�X�X�c�6�6�X�
:�F��g�g�a�#�s��m�$�/�/��7�G��g�g�a�#�s��m�$�/�/��7�G�����S�#�J��/�J��|�|�G�$�)�)�*�5�H����&�(�,�,�q�&�.�.�/@�"A�Brc�<�|jd���}tj|jgdzd��}|jj|j�}|j
|�}t|||j��}tj||�y)Nc��|�|��S)Nr)ras r�<lambda>z(test_join_period_index.<locals>.<lambda>_s��#��s�e�}�r�rr&r')�axisr)�renamer�concatenate�valuesr�appendrZrrr[r\)r �other�
joined_values�joined_colsr�r]s      r�test_join_period_indexr�^s���#�*�*�3L�*�M�E��N�N�$;�$B�$B�#C�a�#G�a�P�M�)�1�1�8�8����G�K�
$�
)�
)�%�
0�F��
�K�7N�7T�7T��H����&�(�+rc�Z�tdgd�igd���}tdgd�igd���}tdgd	�igd
���}|j||gd��}tgd
�tjdddgtjddtjgd�gd���}t	j
||�y)Nr"rRrTr(r,rS)r
r2r&r6)���iX)r&r&r
r*r�)rr$r$rr.r0r�r�r�)r'r&r&r2)rrZr�nanr[r\)r�r��df3r�r]s     r�(test_join_left_sequence_non_unique_indexr�ms���
�S�+�&�i�
8�C�
�S�/�*�)�
<�C�
�S�/�*�)�
<�C�
�X�X�s�C�j�f�X�
-�F�� ��&�&�#�s�C�(��&�&�#�s�B�F�F�+�	
�
�
�H����&�(�+rc��|jj�}|j|ddgg}|j|�}t	j
||�y)Nr�r�)r��to_framer�rZr[r\)r�r*r3r^s    r�test_join_list_seriesr��sK���=�=�!�!�#�D�
�]�]�K��c�
�3�4�E�
�Y�Y�u�
�F����&�+�.r�sort_kwc	��tdddgiddg��}tddd	gid
dg��}tddd
gidd
g��}tdtd�dd�ddtd�d�ddtd�d�d��}|dur|jgd���}tjd�5|j||gd|��}ddd�tj|�y#1swY� xYw)N�col1r'r&r6r"r(�col2r
rr,�col3�rb�@r���?r�g@g@g@g @�r�r�r�F)r6r"r,rU)rXrL)r�float�reindexr[�assert_produces_warningrZr\)r�r"r,r6r]r^s      r�)test_suppress_future_warning_with_sort_kwr��s����6�A�q�6�"�3��*�5�A��6�A�q�6�"�3��*�5�A��6�A�q�6�"�3��*�5�A���E�%�L�s�;��C�e�E�l�;��C�e�E�l�;�	
��H��%���#�#�/�#�:��	�	#�	#�D�	)�;�����A��G�'��:��;����&�(�+�;�;�s�C�Cc�6�eZdZd�Zd�Zd�Zd�Zd�Zd�Zd�Z	y)	�TestDataFrameJoinc�\�|}|j|jdddgf}|j|jddddgf}|j|d��j|j�}|j	�j
j	�}tj|t
j|j
�<t||j|j��}t
j|j
�j�rJ�tj||�y)	Nrr�r&r�r�rUr��rr)r�rrZr�r�r�rr��isnanrr�allr[r\)�self� multiindex_dataframe_random_data�framer"r,r�r]s       rr_zTestDataFrameJoin.test_join�s���0���I�I�e�k�k�"�1�o��u�,�-���I�I�e�k�k�!�"�o��S�z�1�2������w��'�/�/����<���:�:�<�&�&�+�+�-��,.�F�F�����&�-�-�(�)��X�U�[�[�%�-�-�P���8�8�F�M�M�*�.�.�0�0�0�
���f�h�/rc���tddgddgddgd��}tddgddgddgd��}|jddg�}|jddg�}dD]}|j||���y)	Nr'r&)r"r,rj)r"r,rhr"r,)r*r3rUr�)rrHrZ)r�r�r�rXs    r�test_join_segfaultz$TestDataFrameJoin.test_join_segfault�s���q�!�f�A�q�6��A��?�@���q�!�f�A�q�6��A��?�@���m�m�S�#�J�'���m�m�S�#�J�'��-�	#�C��H�H�S�c�H�"�	#rc���ddg}tddd�tddd�g}t|td�dg��}td	dgd
dgg||��}|j|d��}t	|j
�d
k(sJ�y)
N�20120209�20120222i�r&�	��aar�r'r2r
�rz)rrr>rZ�lenr)r��	str_dates�dt_datesr�r��tsts      r�test_join_str_datetimez(TestDataFrameJoin.test_join_str_datetime�s�����,�	��T�1�a�(�(�4��B�*?�@���i�u�Q�x�$��@����1�v��1�v�&�i��J���f�f�Q�4�f� ���3�;�;��1�$�$�$rc�P�tgd�gd�gd�gd�gd�gd�gd�gd�gd	�g	gd
���jdd
g�}tddgddggddg��jdg�}tddgddgddgddgddgddgdtjgdtjgdtjgg	|jddg��}tj|j|d��|�tj|j|d ��|ddg�tjddggd!�gdd
g�"�}tddgddgddgddgddgddgg|ddg��}tj|j|d ��|�tj|j|d��|ddg�y)#N)r"rj�R
���1�?)r"rh�����?)r"�z�<�+J	�?)r,rj��4�ֿ)r,rh�^�9�S��?)r,r��?�����)r6rjr')r6rhr&)r6r�r2)rprq�value1r�rprqr"r$r,r�value2r�r�r�r�r�r�r�r�g@r�r�r*r�r3)rjrhr���names)
rrHrr�rr[r\rZr�from_product)r�r�r��exp�exp_idxs     r�test_join_multiindex_leftrightz0TestDataFrameJoin.test_join_multiindex_leftright�s����$�$�$�%�$�%����

�2�

��)�W�h�'�
(�	��#�r��S�"�I�.��(�8K�L�V�V�
�I�
����2���2���2���B���2���B���2�6�6�"��2�6�6�"��2�6�6�"�

��)�)��x�(�
��"	���c�h�h�s��h�7��=�
���c�h�h�s��h�8�#�x��>R�:S�T��)�)��3�Z��)�'�8�1D�
����2���2���2���B���2���B��

���x�(�
��	���c�h�h�s��h�8�#�>�
���c�h�h�s��h�7��h��=Q�9R�Src��tjddd�j�}tjd|fgddg��}tddgi|��}tjd|fgddg��}td	dgi|��}tjd|fgddg��}td
dgi|��}|j
||g�}tjd|fgddg��}	tdgdgdgd�|	��}
tj||
�y)Ni�r'r�index_0�dater�r�r(r�r�r�)	�pd�	Timestamprr�from_tuplesrrZr[�assert_equal)r�r�	df1_indexr��	df2_indexr��	df3_indexr�r^�expected_indexr]s           r�test_join_multiindex_datesz,TestDataFrameJoin.test_join_multiindex_datess���|�|�D�!�Q�'�,�,�.���*�*�Q��I�;�y�&�>Q�R�	���!��
�Y�7���*�*�Q��I�;�y�&�>Q�R�	���!��
�Y�7���*�*�Q��I�;�y�&�>Q�R�	���!��
�Y�7�����3��*�%��#�/�/�!�T���I�v�CV�W����S�1�#��s�3�>�
��	�����)rc��tddgddgddgg��}tjdd	g�}t|dd
gddgg��}tjt
d�
�5t
j||d��ddd�tjt
d�
�5|j|d��ddd�y#1swY�AxYw#1swYyxYw)Nr"r,r'�rr�)rr)r"�)r6�c1�!�,z-Not allowed to merge between different levelsrfr�)	rrrrmrnrrr{rZ)r�r�rr�s    r�'test_merge_join_different_levels_raisesz9TestDataFrameJoin.test_merge_join_different_levels_raisess���
��c�
�1�b�'�A�r�7�1C�D���(�(�)�[�)A�B�����2�w��B��.@�A���]�]��M�
�	'�
�H�H�S�#�#�&�	'��]�]��M�
�	"�
�H�H�S�S�H�!�	"�	"�
	'�	'��	"�	"�s�B4�C�4B=�C	c	���ttjd�tdddd����}ttjd�tdd	d
d��t	d	d���}|j|d�
�}|jj|j�}tj|j|�|jjjdk(sJ�y)N)�r2z2012-11-15 00:00:00r�100msz
US/Central)rr�tzr()r2r2r2�250msr�rUr�)rr�zerosrr>rZr�unionr[r�r�zone)r��test1�test2r^r]s     r�test_frame_join_tzawarez)TestDataFrameJoin.test_frame_join_tzaware-s�����H�H�V���%�q�w�<��
����H�H�V���%�q�w�<���!�Q�K�
�����E�w��/���;�;�$�$�U�[�[�1��
���f�l�l�H�5��|�|���#�#�|�3�3�3rN)
�__name__�
__module__�__qualname__r_r�r�rrrr rrrr�r��s'��
0�#�	%�:T�x*�("�.4rr�)-r�numpyrrm�
pandas.errorsr�pandasrrrrrr	�pandas._testing�_testingr[�pandas.core.reshape.concatr
�fixturer r*r3r?rIrMrP�mark�parametrizer�r_rvr|r�r�r�r�r�r�r�r�r�r�r�r�r�rrr�<module>r-s�����
�$�����-����������:��:����>��>�������������������������������	�%��"�b���c�
�#C�A�q�6�R�S�	�$�	��R���S�z�"B�1�a�&�Q�R����K�s�C����.@�A��S�	
�
���K�r�v�v�s�C�.@�A��S�	
�
���R�V�V�R��,�?�C�9�U�	
�
���R��R�V�V�,�?�C�9�U�	
�
����"�b�"�&�&�)�����c�3�0G�H�"�
�	
�
����"�b�"�&�&�)�����c�3�0G�H�"�
�	
�?'�*�V,�W*�V,�
3�,D�&������8�->�"?�@�
�A�
�.
�&
�0!2�H&3�RC�$	�C�,�,�(/�������T�5�M�2�,�3�,�,_4�_4r

Youez - 2016 - github.com/yon3zu
LinuXploit