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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

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

/	�g@���ddlmZddlmZmZddlmZddlZddlZddl	Z	ddl
mZddlm
Z
mZmZddlmcmZddlmZddlZddlmZmZmZmZmZmZmZmZm Z m!Z!m"Z"ddl#m$Z%d	Z&Gd
�d�Z'Gd�d
�Z(d�Z)dZ*dZ+Gd�d�Z,Gd�d�Z-dd�Z.e	j^jade1dfdg�dd��Z2d�Z3Gd�d�Z4y)�)�
namedtuple)�datetime�	timedelta)�DecimalN)�iNaT)�InvalidIndexError�PerformanceWarning�SettingWithCopyError)�
is_integer)�Categorical�	DataFrame�
DatetimeIndex�Index�
MultiIndex�Series�	Timestamp�
date_range�isna�notna�to_datetimezBslice indices must be integers or None or have an __index__ methodc	��eZdZd�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
ejjd	gd
�gd�gd�g�d
��Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Ze jBd��Z"d �Z#d!�Z$d"�Z%e jBd#��Z&d$�Z'e jBd%��Z(d&�Z)d'�Z*d(�Z+d)�Z,d*�Z-d+�Z.d,�Z/d-�Z0d.�Z1d/�Z2d0�Z3d1�Z4d2�Z5d3�Z6d4�Z7ejjd5d6d7g�d8��Z8d9�Z9d:�Z:d;�Z;d<�Z<d=�Z=d>�Z>d?�Z?d@�Z@dA�ZAdB�ZBdC�ZCdD�ZDdE�ZEdF�ZFdG�ZGejj�dH�ejjdIeIj�eIj�j�dJ�eIj�j�dK�g�dL���ZLdM�ZMdN�ZNejjdOdPdQdRgfdSdTdRgfg�dU��ZOe jBdV��ZPdW�ZQejjdXdYdYgeIj�eIj�gg�dZ��ZSejjdXdYeIj�g�d[��ZTejjd\eUeVeWj�g�d]��ZYd^�ZZejjd_dRgdRg�ejjd`idadTig�db���Z[ejjd`idcdRig�dd��Z\de�Z]df�Z^dg�Z_ejjd_d6dhg�ejjdie`djg�dk���Zaejjdld7d6g�ejjd_dmdmgg�dn���Zbejjdoecj�dTfecj�dpfg�dq��ZfyY)r�TestDataFrameIndexingc���|dd}t|j�dk(sJ�|j�D]I\}}t|j�dk(sJ�tj|j|j��K|j
j�D]\}}||��J�d|vsJ�t
jtd��5|dddd�y#1swYyxYw)N��random��match)	�len�index�items�tm�assert_index_equal�_series�pytest�raises�KeyError)�self�float_frame�sl�_�series�keys      �KC:\Python312\Lib\site-packages\pandas/tests/frame/indexing/test_indexing.py�test_getitemz"TestDataFrameIndexing.test_getitem+s���
��"�
���2�8�8�}��"�"�"�����	:�I�A�v��v�|�|�$��*�*�*��!�!�&�,�,����9�	:�"�)�)�/�/�1�	0�F�C���s�#�/�/�/�	0��{�*�*�*�
�]�]�8�8�
4�	"���!�	"�	"�	"�s�C�Cc���|}tgd�|��}tgd�gd�g|��}|d}tddgdd	ggtddg|����}tj||d
��y)N��rr1��dtype�r1��������columnsr1r6r8r:T��check_exact�rr
r!�assert_frame_equal)r'�any_numeric_dtyper3�idx�df�result�expecteds       r-�6test_getitem_numeric_should_not_fallback_to_positionalzLTestDataFrameIndexing.test_getitem_numeric_should_not_fallback_to_positional<sc��!���I�U�+��
�	�9�-�s�
;���A����q�!�f�q�!�f�-�u�a��V�5�7Q�R��
���f�h�D�A�c��|j�}tjjd�j	t|��|d<tjjd�j	t|��}||d<t
jttjd���5|jd�ddd�|d}tj||j�y#1swY�/xYw)Nr5z$10z@awesome_domainz'df["$10"]'rz	df["$10"])�copy�npr�default_rng�standard_normalrr$r%r&�re�escape�__getitem__r!�assert_numpy_array_equal�values)r'r(rC�ad�ress     r-�
test_getitem2z#TestDataFrameIndexing.test_getitem2Es���
�
�
�
���I�I�)�)�!�,�<�<�S��W�E��5�	�
�Y�Y�
"�
"�1�
%�
5�
5�c�"�g�
>�� "����
�]�]�8�2�9�9�_�+E�
F�	(��N�N�;�'�	(��"�#��
�#�#�B��
�
�3�		(�	(�s�5C5�5C>c��|}tgd�|��}tgd�gd�g|��}d|d<tgd�gd	�g|��}tj||d
��y)Nr0r2r4r7r;�
r1)rVr5rV)rVr9rVTr=r?)r'rAr3rBrCrEs      r-�6test_setitem_numeric_should_not_fallback_to_positionalzLTestDataFrameIndexing.test_setitem_numeric_should_not_fallback_to_positionalRsP��!���I�U�+��
�	�9�-�s�
;����1���k�;�7��E��
���b�(��=rGc��d|d<|ddg}||ddg<tj|d|dd��tj|d|dd��d}tjt|��5|ddg|dg<ddd�tt
|j�d	z
�}d
t
|��dt
|��d�}tjt|��5||d<ddd�y#1swY�oxYw#1swYyxYw)
N�foo�E�A�BF��check_namesz"Columns must be same length as keyrr1zLength of values \(z$\) does not match length of index \(z\))r!�assert_series_equalr$r%�
ValueError�rangerr)r'r(�data�msg�
newcolumndatas     r-�test_setitem_listz'TestDataFrameIndexing.test_setitem_list[s�� ��C���C��:�&��"&��S�#�J��
���{�3�/��c���N�
���{�3�/��c���N�2��
�]�]�:�S�
1�	2�%�s�C�j�1�D�#��K�	2��c�$�*�*�o��1�2�
�"�3�}�#5�"6�71�14�T���2�
?�	��]�]�:�S�
1�	&�%�D��I�	&�	&�	2�	2��	&�	&�s�-C'�C3�'C0�3C<c��tdtd�ddgt��}ddg|jdddgf<|j|jdddgf}tddg|jtd��}tj||�d	x|d<|d<d
dg|j|jdddgf<|j|jdddgf}td
dg|jd��}tj||�y)
Nrr6�tt1�tt2)rr<r3r1r5)r3�name�0�1�2�ri)	r
ra�int�locrrr<r!r_�r'rCrDrEs    r-�test_setitem_list2z(TestDataFrameIndexing.test_setitem_list2ns���
�q��a��5�%�.��
L��%&��F����q�5�%�.� �!���������e�U�^�3�4���1�a�&�"�*�*�C�a�@��
���v�x�0� #�#��5�	�B�u�I�/2�C�j����r�x�x��{�U�E�N�*�+���������e�U�^�3�4���3��*�b�j�j�q�9��
���v�x�0rGc��|jd}|j|kD}|jt�}|j|}||}tj||j�tjtd��5||ddddd�||}	tj|	|�tjtd��5||ddd�t||j�}||}	tj|	|�tjt�5|j|jddd��}||}	tj|	|�ddd�|||fD�]&}
|
j�}|
|
dkD}t|jD�
cic]1}
|
t!j"||
dkD||
t j$���3c}
|j|j��}|
jD]}
|
|vs�|
|
||
<�|j|
j��}tj||d	�
�|
jD]C}
||
j&||
j&k7s�#||
j&|
|
j&k(r�CJ���)y#1swY��
xYw#1swY���xYw#1swY��TxYwcc}
w)NrVzItem wrong lengthr���zBoolean array expectedr�rr<r;F)�check_dtype)r�astype�objectr!r"r$r%r`r@r�assert_produces_warning�UserWarning�reindex�_get_numeric_datar
r<rJ�where�nanr3)r'�mixed_float_frame�mixed_int_frame�datetime_frame�d�indexer�indexer_obj�subindex�subframe�subframe_objrCrb�bif�c�bifws               r-�test_getitem_booleanz*TestDataFrameIndexing.test_getitem_boolean|s���� � ��$�� �&�&��*���n�n�V�,��!�'�'��0��!�'�*��
���h����7�
�]�]�:�-@�
A�	)��7�3�B�<�(�	)�&�k�2��
���l�H�5�
�]�]�:�-E�
F�	+��>�*�	+��[�.�*>�*>�?��%�k�2��
���l�H�5��
'�
'��
4�	:�%�-�-�n�.B�.B�4�R�4�.H�I�K�)�+�6�L��!�!�,��9�	:�
���
�	7�B�
�'�'�)�D��R�!�V�*�C��DH�L�L�Q�q��B�H�H�T�!�W�q�[�$�q�'�2�6�6�:�:�Q��j�j�����D��Z�Z�
$���D�=� ��e�D��G�
$��<�<��
�
�<�3�D��!�!�#�t��?��Z�Z�
7���q�6�<�<�4��7�=�=�0��q�6�<�<�2�a�5�;�;�6�6�6�
7�)	7�3	)�	)��	+�	+��	:�	:��Rs*�	J�
J$�"=J1�6J>
�J!�$J.�1J;c��|j�}d|d<|djd�|d<|dj�|d<d|d<|djd�|d<|dj�|d<||dkD}|j}tt	j
d	�gd
zt	j
d�gdzzt	j
d�gdzzgd��
�}t
j||�d|j|jddddgf<||dkD}|j}tt	j
d	�gd
zt	j
d�gzt	j
d	�gzt	j
d�gzt	j
d	�gzgd��
�}t
j||�y)Nr1rZ�int32�E1�F�int64�F1r�float64r8r5)r[r\�C�DrZr�r�r��rr6)
rIrv�dtypesrrJr3r!r_ror)r'r�rC�castedrDrEs      r-�test_getitem_boolean_castingz2TestDataFrameIndexing.test_getitem_boolean_casting�s���
�
 �
 �
"����3���S�'�.�.��)��3���c�7�<�<�>��4����3���S�'�.�.��)��3���c�7�<�<�>��4���B��F��������
�X�X�i�
 �!�A�%��x�x�� �!�A�%�
&��x�x�� �!�A�%�
&�=�	
��	���v�x�0�/0����r�x�x��!�}�t�T�l�*�+��B��F��������
�X�X�i�
 �!�A�%��x�x�� �!�
"��x�x�	�"�#�
$��x�x�� �!�
"��x�x�	�"�#�	
$�
=�

��	���v�x�0rG�lst�TFT)TTT)FFFc���ttjd�jdd��}||}|j|j
|}t
j||�y)N�r6r8)r
rJ�arange�reshaperorr!r@)r'r�rCrDrEs     r-�test_getitem_boolean_listz/TestDataFrameIndexing.test_getitem_boolean_list�sR���r�y�y��}�,�,�Q��2�
3���C����6�6�"�(�(�3�-�(��
���f�h�/rGc��tjjd�jd�}t	|j�gd���}||dkxxdz
cc<||dkxxdz
cc<t
j|j|�y)Nr5�r9r9)r[r\r�r�rZr;rr1)	rJrrKrLr
rIr!�assert_almost_equalrQ)r'�arrrCs   r-�test_getitem_boolean_iaddz/TestDataFrameIndexing.test_getitem_boolean_iadd�sk���i�i�#�#�A�&�6�6�v�>��
�s�x�x�z�+D�
E��
�2��6�
�a��
��C�!�G�����
���r�y�y�#�.rGc��ttjddg�dgtg���}tjgt
�}||d||<y)Nrr1r[�r<r)r
rJ�emptyr�array�bool)r'�blah�ks   r-�test_boolean_index_empty_cornerz5TestDataFrameIndexing.test_boolean_index_empty_corner�sF������1�a�&�)�C�5�
�b�@Q�R��
�H�H�R�����Q����Q�rGc��ttjjd�j	d�gd�gd���}|j
dd}|j|jdd}tj||�|jddg}|jtddg�}tj||�y)	Nr5)r8r6)r1rVr�rZr4rtrsr1rV)r
rJrrKrL�ilocrorr!r@rrps    r-�test_getitem_ix_mixed_integerz3TestDataFrameIndexing.test_getitem_ix_mixed_integer�s���
��I�I�!�!�!�$�4�4�V�<�#��
������"����6�6�"�(�(�3�B�-�(��
���f�h�/�����B�����6�6�%��B��.�)��
���f�h�/rGc��tdgd�gd�gd�d�gd���}|dg}|jdd�dgf}tj||�|d	g}|jdd�d
gf}tj||�y)N)��?g������@g������	@�@)���$�()rV��+�")rrVr�)�rna����r��r;r�r6r�r1�r
r�r!r@rps    r-�test_getitem_ix_mixed_integer2z4TestDataFrameIndexing.test_getitem_ix_mixed_integer2s���
�+�'�#�%�	
�,�
���T�F����7�7�1�q�c�6�?��
���f�h�/��U�G����7�7�1�q�c�6�?��
���f�h�/rGc���tj|j|d�d}tjt
|��5|jddd�y#1swYyxYw)Nr[z6'DataFrame' object has no attribute 'NONEXISTENT_NAME'r)r!r_r[r$r%�AttributeError�NONEXISTENT_NAME)r'r(rcs   r-�test_getattrz"TestDataFrameIndexing.test_getattrsL��
���{�}�}�k�#�.>�?�F��
�]�]�>��
5�	)��(�(�	)�	)�	)�s�
A�A c��tdditd���}d|_|jdk(j�sJ�y)N�foobarr1rVr�r9)r
rar��all�r'rCs  r-�test_setattr_columnz)TestDataFrameIndexing.test_setattr_columns7��
��!�}�E�"�I�
6����	��	�	�Q��#�#�%�%�%rGc�6�|dddd�}||d<d|vsJ�t|�dk(sJ�t|�dk(sJ�tjtj|jtj
gdzf��}t
||jd��}tj|d|�|d}||d<tj||dd�	�tjjd�jt|��}||d
<|d
|k(j�sJ�d|d<|ddk(j�sJ�d
|d<|dd
k(j�sJ�d|d<|ddk(j�sJ�|dd}d}	|s|rddg|d<n+tjt |	��5ddg|d<ddd�|r|dj"dk(s$J�|dj"tj$k(sJ�|dddgk(j�sJ�y#1swY�\xYw)Nr[r5�col5�r��rri�col6Fr]�col9r9�col7g��Q�	@�col0rY�col8zC\nA value is trying to be set on a copy of a slice from a DataFramerkrl�col10r�string)rrJ�ravel�column_stackrQr}rrr!r_rrKrLr�r$r%r
r3�object_)
r'r(�using_copy_on_write�warn_copy_on_write�using_infer_stringr+�expr��smallerrcs
          r-�test_setitemz"TestDataFrameIndexing.test_setitem#sC���S�!�#�A�#�&��$��F����$�$�$��6�{�b� � � ��;��2�%�%�%��h�h�r����
�
����x�"�}�'E�F�G���S�� 1� 1��?��
���{�6�2�C�8��S�!��$��F��
���v�{�6�':��N��i�i�#�#�A�&�6�6�s�;�7G�H��!��F���F�#�s�*�/�/�1�1�1���F���F�#�q�(�-�-�/�/�/�"��F���F�#�t�+�0�0�2�2�2�#��F���F�#�u�,�1�1�3�3�3��b�q�/��T���"4� #�S�z�G�G�����3�3�?�
.�$'��:��� �
.���7�#�)�)�X�5�5�5��7�#�)�)�R�Z�Z�7�7�7��� �S�#�J�.�3�3�5�5�5�
.�
.�s�,H�Hc�\�tddgg�}tj|jd<ttjtjgg�}t	j
||�tddgg�}tj|jd<t	j
||�y)Nr)r
rJr}r�r!r@ro�r'rCrEs   r-�
test_setitem2z#TestDataFrameIndexing.test_setitem2Vs~��
��A��x�
 ���V�V�����
��r�v�v�r�v�v�.�/�0��
���b�(�+�
��A��x�
 ���F�F����q�	�
���b�(�+rGc�F�|j�}|jj�}d||ddkD<d||dd�dfdkD<tj|j|�|ddk(}|j	|j
ddd��}d||<d||dd�dfdk(<tj|j|�d||dkD<d||dkD<tj|j|�d||dk(<d||dk(<tj|j|�d||dddk<t
j|dd|dddkd�tj|j|�d||ddd�dk(<d||dk(<tj|j|�d	}tjt|�
�5d||dz<ddd�|j�}|t
j|�kD}tj||t
j|�kD<|jj�}tj||j<t||j
|j��}tj||�|dz||t
j|�kD<t
j||j|jdz�t||j
|j��}tj||�y#1swY��OxYw)Nr8r[rrsr1r9r5r6z;Must pass DataFrame or 2-d ndarray with boolean values onlyrrt)rIrQr!r�rzrrJ�putmaskr$r%�	TypeError�absr}r
r<r@)	r'r(rCrQr+rc�df_orig�maskrEs	         r-�test_setitem_booleanz*TestDataFrameIndexing.test_setitem_booleanas���
�
�
�
���#�#�(�(�*����2�c�7�Q�;��#$��v�a��d�|�a�� �
���r�y�y�&�1��C��A����������2���/����6�
�$%��v�a��d�|�q� �!�
���r�y�y�&�1���2��6�
���v��z��
���r�y�y�&�1���2��7����v��{��
���r�y�y�&�1���2�c�r�7�Q�;��
�
�
�6�#�2�;��s���a���3�
���r�y�y�&�1���2�d��d�8�q�=����v��{��
���r�y�y�&�1�K��
�]�]�9�C�
0�	��B�r�A�v�J�	��'�'�)���B�F�F�2�J��� �f�f��2����r�
�?�����$�$�&�� �f�f��t�{�{���V�7�=�=�'�/�/�R��
���b�(�+�!�1�f��2����r�
�?��
�
�
�6�4�;�;��	�	�A�
�6��V�7�=�=�'�/�/�R��
���b�(�+�!	�	�s�	L�L c��|djd�|d<|djtjk(sJ�d|d<|djtjk(sJ�tjt|��|d<t
|djjtj�sJ�d|d<d|d<|djtjk(sJ�d|d<d|d<|djtjk(sJ�d|d<|djtjk(sJ�d	|d<|djtjk(sJ�d|d<|djtjk(sJ�y)
Nr��i8rr\�barrY�@�	somethingr5)
rvr3rJr�r�r�
issubclass�type�integerr�)r'r(s  r-�test_setitem_castz'TestDataFrameIndexing.test_setitem_cast�sx��&�s�+�2�2�4�8��C���3��%�%����1�1�1�
��C���3��%�%����1�1�1��9�9�S��%5�6��C���+�c�*�0�0�5�5�r�z�z�B�B�B�"��E����E���5�!�'�'�2�8�8�3�3�3�"��E�� ��E���5�!�'�'�2�:�:�5�5�5�#$��K� ��;�'�-�-����9�9�9�#$��K� ��;�'�-�-����9�9�9�#&��K� ��;�'�-�-����;�;�;rGc��tgd�gd�d�tjd���}|d=gd�|d<d|vsJ�t|j�dk(sJ�d|d	<d
|d<d|d
<d|tj�<d|tj�<t|j��}d
|d	<d|d<t|j�dk(sJ�|jjtjk(sJ�d|d<|djtjk(sJ�d|d<|djtjk(sJ�d|d	<d|d	jdk(sJ�ttjd���}d|d	<d|d
<|d
=d|d
<|r|d
jdk(s$J�|d
jtjk(sJ�gd�|d<|r|djdk(sJ�y|djtjk(sJ�y)N)��?�@�@��a�br�)r\r�r6r�r\r5�	beginningr[rYrZr�r��date�@r1r�r�rr��rkrl�3�	coercible)r
rJr�rr<r�nowrrQr3r�r�r�r�)r'r(r�rC�dms     r-�test_setitem_cornerz)TestDataFrameIndexing.test_setitem_corner�s���
�_�?�C�2�9�9�UV�<�
X���s�G�!��3���b�y��y��2�:�:��!�#�#�#���3����3����3��#��8�<�<�>�� ��8�<�<�>���[�.�.�
/����3����3���2�:�:��!�#�#�#��y�y���"�*�*�,�,�,���3���#�w�}�}����(�(�(���3���#�w�}�}��
�
�*�*�*���3����3����Q��'�'�'�
�R�Y�Y�q�\�
*����3����5�	��u�I���5�	���e�9�?�?�h�.�.�.��e�9�?�?�b�j�j�0�0�0�)��;����k�?�(�(�H�4�4�4��k�?�(�(�B�J�J�6�6�6rGc�P�gd�dgdzztjjd�jd�d�}t|�}||ddk(j}d|j
|dgf<d	|j
|d
gf<|j
ddk(sJ�|j
dd	k(sJ�y)
N)r�r�r�r��r5r)�title�cruftrr�rr)r1r)r1r)rJrrKr
rro)r'rbrC�ixs    r-�test_setitem_corner2z*TestDataFrameIndexing.test_setitem_corner2�s���0�H�:��?�B��Y�Y�*�*�1�-�4�4�R�8�
��
�t�_��
��7��u�$�
%�
+�
+�� (����r�G�9�}�� !����r�G�9�}���v�v�j�!�X�-�-�-��v�v�j�!�Q�&�&�&rGc�:�ttd�td���}ttd�D�cgc]
}td���c}td���}tgd�td���}t	j
d�|d<t
|j�dk(sJ�||d<t
|j�dk(sJ�||d<t
|j�dk(sJ�|r|djdk(sJ�y|djtjk(sJ�ycc}w)	Nr6rtr1r�)rY�bzr�bazrr5r�)
r
rarrrJ�onesrr<r3r�)r'r�r�r*�coercable_series�uncoercable_seriess      r-�test_setitem_ambigz(TestDataFrameIndexing.test_setitem_ambig�s����U�1�X�u�Q�x�
8��!�u�Q�x�"@�!�7�1�:�"@��a��Q��#�$9��q��J������
��1���2�:�:��!�#�#�#� ��1���2�:�:��!�#�#�#�"��1���2�:�:��!�#�#�#���a�5�;�;�(�*�*�*��a�5�;�;�"�*�*�,�,�,��#As�Dc�(�|d|d<|sdntj}tj|jdd�df|dd��tj|j
dd�|f|dd��tj|||dd��y)Nr[rsFr])rJr}r!r_r�ro)r'r(r�r,s    r-�test_setitem_Nonez'TestDataFrameIndexing.test_setitem_Nones���'��,��D��,�d�"�&�&��
������Q��U�#�[��%5�5�	
�	����O�O�A�s�F�#�[��%5�5�	
�	���{�3�/��S�1A�u�UrGc��tgd�gd�gd�d��}|j�}|jj�|j|jj�df<t
j||�y)Nr�)�11�22�33)�111�222�333r�r�)r
rIr�ror�rr!r@)r'rCrDs   r-�&test_loc_setitem_boolean_mask_allfalsez<TestDataFrameIndexing.test_loc_setitem_boolean_mask_allfalses\��
�!�(:�AV�W�
�������+1�8�8�=�=�?��
�
�6�8�8�=�=�?�C�'�(�
���f�b�)rGc�@�ttjjd�j	d��}|j
ddd�tj|j
ddd�<t|j
ddd��jj�sJ�y)Nr5�rVr9�)
r
rJrrKrLr�r}rrQr�r�s  r-�&test_getitem_fancy_slice_integers_stepz<TestDataFrameIndexing.test_getitem_fancy_slice_integers_steps{��
�r�y�y�,�,�Q�/�?�?��H�
I��	�����1��
���������1��
��B�G�G�D�Q�q�D�M�"�)�)�-�-�/�/�/rGc���ttjjd�j	d�tddd���}|j
�}d|jdd|jdddk(jj�sJ�|j
�}d|jdd	|jdd	dk(jj�sJ�|jdd
}|jdd	}|jgd��}tj||�tj||�|jttd��ttdd��ddd
�z}tj t"d��5|jdd	ddd�tj t"d��5d|jdd	ddd�y#1swY�=xYw#1swYyxYw)Nr5rrrr�r8rVr6r�r:)r8r:rrVr9rsz^3$r)r
rJrrKrLrarIr�rQr�rorzr!r@�listr$r%r&)r'rC�cprD�result2rE�df2s       r-�,test_getitem_setitem_integer_slice_keyerrorszBTestDataFrameIndexing.test_getitem_setitem_integer_slice_keyerrors$s���
��I�I�!�!�!�$�4�4�W�=�U�1�b�RS�_�
��
�W�W�Y�������"�
�����"�
��"�*�*�.�.�0�0�0��W�W�Y�������"�
�����"�
��"�*�*�.�.�0�0�0�����1����&�&��2�,���:�:�m�,��
���f�h�/�
���g�x�0��g�g�d�5��8�n�t�E�!�R�L�'9�$�B�$�'?�?�@��
�]�]�8�6�
2�	��G�G�A�b�M�	�
�]�]�8�6�
2�	��C�G�G�A�b�M�	�	�	�	��	�	�s�G�G(�G%�(G1c�\�|jdd�dd�f}|djtjk(sJ�|j	�}|jdd�dd�f}tj
|dj|dj�sJ�tj|�5d|jdd�df<ddd�|sI|ddk(j�sJ�tj
|dj|dj�ytj||�y#1swY�kxYw)N���r�r��@r8)r�r3rJr�rI�
shares_memory�_valuesr!�assert_cow_warningror�r@)r'r(�float_string_framer�r��sliced�originals       r-�test_fancy_getitem_slice_mixedz4TestDataFrameIndexing.test_fancy_getitem_slice_mixedAs��$�(�(��B�C��0���c�{� � �B�J�J�.�.�.��#�#�%���!�!�!�R�S�&�)������s�� 3� 3�[��5E�5M�5M�N�N�N�
�
"�
"�#5�
6�	%�!$�F�J�J�q�#�v��	%�"���$��)�.�.�0�0�0�
���V�C�[�0�0�+�c�2B�2J�2J�K��!�!�+�x�8�	%�	%�s�$D"�"D+c���ttd�tdd����}|jddg\}}|j||}|||}|dd}tj||�tj||�|j�}d|j|||j�}d||||j�}d|ddtj||�tj||�y)	Nrz
2020-01-01��periodsr�r9rVr�r)r
rarrror!r@rI)r'rC�start�endrDrrEs       r-�"test_getitem_setitem_non_ix_labelsz8TestDataFrameIndexing.test_getitem_setitem_non_ix_labelsYs���
�u�R�y�
�<��(L�
M���X�X�q�"�g�&�
��s�����c�"���U�3�-���a��8��
���f�h�/�
���g�x�0������ !��
�
�5����'�'�)�����c���7�7�9�����2��
���f�h�/�
���g�x�0rGc��ttjjd�j	d��}|j
|jdk(dd�f}|jdg�}tj||�ttjjd�j	d��}|j
|jdk(|jdk(f}|jdgdg��}tj||�y)Nr5�r6r5rr1rt)r
rJrrKrLrorrzr!r@r<)r'rC�rs�xps    r-�test_ix_multi_takez(TestDataFrameIndexing.test_ix_multi_takems���
�r�y�y�,�,�Q�/�?�?��G�
H��
�V�V�B�H�H��M�1�$�
%��
�Z�Z���_��
���b�"�%��r�y�y�,�,�Q�/�?�?��G�
H��
�V�V�B�H�H��M�2�:�:��?�2�
3��
�Z�Z�q�c�A�3�Z�
/��
���b�"�%rGc��|}|j}|jD]-}||}|jddd�D]}|||f||k(r�J��/y)Nr9)ror<r)r'r(�fr�col�tsrBs       r-�test_getitem_fancy_scalarz/TestDataFrameIndexing.test_getitem_fancy_scalarysc����
�U�U���9�9�	/�C��3��B��w�w�s��s�|�
/���#�s�(�|�r�#�w�.�.�.�
/�	/rGc��|}|j�}|j}t|j�D]�\}}|||jddd�D]x}|jj|�}tjjd�j�}	|	|j||f<|	|||f<tj||��z��y)Nr9r5)
rIro�	enumerater<r�get_locrJrrKrLr�r!r@)
r'r(r6rEr�jr7rB�i�vals
          r-�test_setitem_fancy_scalarz/TestDataFrameIndexing.test_setitem_fancy_scalar�s������#�#�%��
�U�U�� ��	�	�*�	3�F�A�s�
�c�F��w�w�s��s�|�
3���G�G�O�O�C�(���i�i�+�+�A�.�>�>�@��&)��
�
�a��d�#�"��3��8���%�%�a��2�

3�	3rGc��|}|j}|jddg��}|dd�gd�f}tj||�|j|jddddg��}||jddgd�f}tj||�|j|jdkD}|j|j|�	�}||}tj||�||dd�f}tj||�|||j
d
df}|j|j|ddg��}tj||�y)Nr\r�r;)FTFTr9rVrt�r�r5r�)rorzr!r@rr<)r'r(r6rrErD�boolvecs       r-�test_getitem_fancy_booleanz0TestDataFrameIndexing.test_getitem_fancy_boolean�s;����
�U�U���9�9�c�3�Z�9�0���A�1�1�2��
���f�h�/��9�9�1�7�7�1�R�=�3��*�9�E���A�G�G�A�b�M�#=�=�>��
���f�h�/��'�'�A�G�G�A�J�&���9�9�1�7�7�7�#3�9�4���G���
���f�h�/��G�Q�J���
���f�h�/��G�Q�Y�Y�q�r�]�*�+���9�9�1�7�7�7�#3�c�3�Z�9�H��
���f�h�/rGc�d�|j�}|j�}|jj�}|ddkD}d|j|<d||j<t||j|j
��}t
j||�|j�}|j�}|jj�}d|j|ddgf<d||jdd�f<t||j|j
��}t
j||�y)Nr[r�rtr\r5)rIrQror
rr<r!r@)r'r(�framerErQr�s      r-�test_setitem_fancy_booleanz0TestDataFrameIndexing.test_setitem_fancy_boolean�s��� � �"���#�#�%�����%�%�'���S�z�A�~����	�	�$��!��t�{�{���V�8�>�>�8�CS�CS�T��
���e�X�.�� � �"���#�#�%�����%�%�'��&)��	�	�$��c�
�"�#�"%��t�{�{�B�Q�B����V�8�>�>�8�CS�CS�T��
���e�X�.rGc�(�|jgd�}|j|jgd�}tj||�|jdd�gd�f}|jdd�|j
gd�f}tj||�y)N)r1r8rB)r5rr1)r�rorr!r@r<)r'r(rDrEs    r-�test_getitem_fancy_intsz-TestDataFrameIndexing.test_getitem_fancy_ints�s}���!�!�)�,���?�?�;�#4�#4�Y�#?�@��
���f�h�/��!�!�!�Y�,�/���?�?�1�k�&9�&9�)�&D�#D�E��
���f�h�/rGc�<�|dddd�dkD}|j|}|j|ddd�}tj||�|j�}|j�}d|j|<d|j|<tj||�y)Nr[rsr1r)ror!r@rI)r'r(r�rDrErs      r-�'test_getitem_setitem_boolean_misalignedz=TestDataFrameIndexing.test_getitem_setitem_boolean_misaligned�s����3���"��%��)������&���?�?�4��"��:�.��
���f�h�/�
�
�
�
���#�#�%������t������T��
���b�(�+rGc�.�ttjjd�j	d��}tj
gd��}tj
ddg�}|j||f}|jddgdgf}tj||�|j�}d|jtj
gd��tj
ddg�f<d|jddgdgf<tj||�y)	Nr5r1r�FTrr1r9)
r
rJrrKrLr�ror!r@rI)r'rC�k1�k2rDrEs      r-�"test_getitem_setitem_boolean_multiz8TestDataFrameIndexing.test_getitem_setitem_boolean_multi�s���
�r�y�y�,�,�Q�/�?�?��G�
H���X�X�)�
*��
�X�X�u�d�m�
$������B�����6�6�1�a�&�1�#�+�&��
���f�h�/��7�7�9��IJ����r�x�x�+�,�b�h�h��t�}�.E�E�F�$%����a��V�a�S�[�!�
���b�(�+rGc�
�tgd��}ttjj	d�jd�|��}|jdd}|jgd��}tj||�t|�dk(sJ�|jdd}|jddg�}tj||d	�
�t|�dk(sJ�|jdd}|jddg�}tj||�t|�dk(sJ�|jd
d}|jdd}tj||�|jdd}d}tjt|��5|d
d}ddd�tj||�tgd��}ttjj	d�jd�|��}d}tjt |��5|jddddd�|jdd}|jdg�}tj||�t|�d
k(sJ�|j#�}tjt t$��5d|jddddd�tjt |��5|jdddk(}ddd�|j&j)�sJ�|jdd
|jdd
k(j&j)�sJ�|j#�}d|jdd|jdddk(j&j)�sJ�|jdd|jddk(j&j)�sJ�|jdd}|}tj||�t|�dk(sJ�|jdd}|jgd��}tj||�t|�dk(sJ�|jdd}|jdg�}tj||�t|�d
k(sJ�|jdd}|jgd��}tj||�t|�dk(sJ�|j#�}d|jdd|jdd}|dk(j&j)�sJ�y#1swY���xYw#1swY��xYw#1swY���xYw#1swY��fxYw)N)r�r5r6r8r9r5r�r�r�r8)r�r5r6r8r9F)�check_index_typer"r�r1rz3The behavior of obj\[i:j\] with a float-dtype indexr)r�r��@r�r�zPcannot do positional indexing on Index with these indexers \[1.0\] of type floatr�g�������?)r�rSr�r�g
ףp=
@)rr
rJrrKrLrorzr!r@rr�rx�
FutureWarningr$r%r�rI�
_slice_msgrQr�)r'�using_array_managerrrCrDrErcrs        r-�!test_getitem_setitem_float_labelsz7TestDataFrameIndexing.test_getitem_setitem_float_labels�s����'�(��
�r�y�y�,�,�Q�/�?�?��G�u�
U������A����:�:�n�-��
���f�h�/��6�{�a��������!����:�:�q�!�f�%��
���f�h��G��6�{�a��������!����:�:�s�C�j�)��
���f�h�/��6�{�a��������!����7�7�1�Q�<��
���f�h�/��7�7�1�Q�<��D��
�
'�
'�
�S�
A�	���!�W�F�	�
���f�h�/��/�0��
�r�y�y�,�,�Q�/�?�?��G�u�
U��
4�	��]�]�9�C�
0�	��G�G�C��N�	�����1����:�:�s�e�$��
���f�h�/��6�{�a����
�W�W�Y��
�]�]�9�J�
7�	��B�G�G�C��N�	��]�]�9�C�
0�	)��W�W�S��^�q�(�F�	)��}�}� � �"�"�"�����!������!��,�4�4�8�8�:�:�:�
�W�W�Y�������!������!���!�)�)�-�-�/�/�/�����!������!��,�4�4�8�8�:�:�:�����A�����
���f�h�/��6�{�a��������A����:�:�2�3��
���f�h�/��6�{�a��������Q����:�:�s�e�$��
���f�h�/��6�{�a��������C����:�:�7�8��
���f�h�/��6�{�a����
�W�W�Y������s�3������C����!��#�#�'�'�)�)�)�{	�	��	�	��	�	��	)�	)�s0�T�T&�T3�	U�T#�&T0�3T=�U
c��ttjjd�j	d�gd�gd���}td�|d<|j}ttjd�gd	ztjd
�gzgd���}tj||�tjtd
��5t|jd<ddd�t|jd�rJ�|djtj k(sJ�|jdtk(sJ�tj"|jd<t|jd�sJ�tj"|jddd�f<t|jddd�f�j%�rJ�y#1swY��xYw)Nr5�r9r6)r�r�r�r��e)rYr�rrt�20010102�	timestampr�r6z
datetime64[s])rYr�rr\r��%Setting an item of incompatible dtyper)r�r\)r�r\r�r�)r
rJrrKrLrr�rr3r!r_rxrTrrorr�r}r�rps    r-�)test_setitem_single_column_mixed_datetimez?TestDataFrameIndexing.test_setitem_single_column_mixed_datetime?s���
��I�I�!�!�!�$�4�4�V�<�+�)�
��$�J�/��;�������
�X�X�i�
 �!�A�%����/�)B�(C�C�4�
��	���v�x�0��
'�
'��!H�
�	,�(,�B�F�F�#�$�	,�����/�0�1�1�1��+��$�$��
�
�2�2�2��v�v�&�'�4�/�/�/�$&�6�6����� ��B�F�F�+�,�-�-�-�������s�A�v������s�A�v��'�+�+�-�-�-�-�	,�	,�s�F<�<Gc
��tgd�tddd�dddtddd�tddd�gd��}td	td
�td���}tj
|d
<tddd�|jd<tjtd��5d|jd<ddd�d|jddgd
f<tjdtjd�gdtjd�gg�}||jddgdd
gf<tj||�y#1swY��xYw)N)rrrr�
�i�r1�x�yi�i��r�r�r�abr:r�r��rr�r]r)r1r��rbrcr5r6r`z2013-01-01T00:00:00raz2014-01-01T00:00:00r8r9r�)r
rrra�pd�NaTror!rxrTrJr��
datetime64r@)r'rErCr[s    r-�test_setitem_mixed_datetimez1TestDataFrameIndexing.test_setitem_mixed_datetimeas5���)��T�1�a�(�����T�1�a�(��T�1�a�(�
�

�
���q�$�t�*�E�!�H�
=���&�&��3��!�$��1�-����v��
�
'�
'��!H�
�	��B�F�F�6�N�	�'�����1�v�s�{���H�H��R�]�]�#8�9�:��R�]�]�#8�9�:�
�
��&'�����1�v��S�z�!�"�
���b�(�+�	�	�s� D8�8Ec�4�|j|jddddgf}|j|j|jdd�ddgf<|j|jddddgfj}|j}tj||�y�Nr5r[r\���)rorrQr!r��r'r(�piecerDrEs     r-�test_setitem_frame_floatz.TestDataFrameIndexing.test_setitem_frame_float�s������� 1� 1�"�1� 5��S�z� A�B��?D�|�|�����)�)�"�-�/�#�s��;�<�����!2�!2�2�3�!7�#�s��!C�D�K�K���<�<��
���v�x�0rGc�R�|j�}tddgddgg|jddddg�	�}|jtdd�ddgf}||j|<tj|j|jddddgfj|j�y)
Nr�r�r�r"rr5r[r\rt)rIr
r�sliceror!r�rQ�r'r&r6rpr,s     r-�test_setitem_frame_mixedz.TestDataFrameIndexing.test_setitem_frame_mixed�s���
�#�#�%����3�Z�#�s��$�A�G�G�A�a�L�3��*�
���w�w�u�T�1�~�&��c�
�3������c�
�
���q�u�u�Q�W�W�Q�q�\�C��:�%=�>�E�E�u�|�|�TrGc��|j�}tddgddgddgddggt|jd	d
�ddgzd
dg��}|jt	dd
�d
dgf}||j
|<t
j|j
|jd	d
d
dgfj|jd	d
�y)Nr�r�r�r"r�g@g@g @rr5rYr�r[r\rt)	rIr
rrrsror!r�rQrts     r-�'test_setitem_frame_mixed_rows_unalignedz=TestDataFrameIndexing.test_setitem_frame_mixed_rows_unaligned�s����#�#�%����3�Z�#�s��c�3�Z�#�s��<��q�w�w�q��|�$��u�~�5��#�J�
��
�w�w�u�T�1�~�&��c�
�3������c�
�
���
�E�E�!�'�'�!�A�-�#�s��+�,�3�3�U�\�\�!�A�5F�	
rGc��|j�}|j|jdddgf}|jdd|_|jtdd�ddgf}||j|<tj
|d<t
j|j|jddddgfj|j�y)Nr5r[rnr\)	rIrorrsrJr}r!r�rQrts     r-�&test_setitem_frame_mixed_key_unalignedz<TestDataFrameIndexing.test_setitem_frame_mixed_key_unaligned�s����#�#�%�����a�g�g�b�q�k�C�5�(�)���g�g�b�c�l����w�w�u�R���'�#�s��4������c�
��V�V��c�
�
���q�u�u�Q�W�W�R�S�\�C��:�%=�>�E�E�u�|�|�TrGc�`�|j�}|j|jddddgf}|jtdd�ddgf}|j|j|<tj|j|jddddgfj|j�yrm)rIrorrsrQr!r�rts     r-� test_setitem_frame_mixed_ndarrayz6TestDataFrameIndexing.test_setitem_frame_mixed_ndarray�s����#�#�%��"�&�&�q�w�w�r��{�S�#�J�'>�?���w�w�u�R���'�#�s��4���\�\����c�
�
���q�u�u�Q�W�W�R�S�\�C��:�%=�>�E�E�u�|�|�TrGc�r�tgd�gd�ggd���}|j�}tjtd��5|j
dd�ddgfd	z|j
dd�ddgf<ddd�|j
ddg��}|d	z
}|d
|d
<tj||�y#1swY�AxYw)N)r1r5rY)r6r8r��r[r\r�r;�incompatible dtyperr[r\��?r�)r
rIr!rxrTrorzr@)r'rCrrEs    r-�test_setitem_frame_upcastz/TestDataFrameIndexing.test_setitem_frame_upcast�s���
�
�}�5��
O���g�g�i��
�
'�
'�
�=Q�
R�	A�%'�V�V�A��S�z�M�%:�S�%@�C�G�G�A��S�z�M�"�	A��:�:�s�C�j�:�1���C����3����
�
���c�8�,�	A�	A�s�,B-�-B6c�V�|j|jddddgf}|jdd|_ddg|_||j|jddddgf<|j|jddddgfj}|j}t	j
||�yrm)rorr<rQr!r�ros     r-�test_setitem_frame_alignz.TestDataFrameIndexing.test_setitem_frame_align�s������� 1� 1�"�1� 5��S�z� A�B��!�'�'���,����c�
��
�>C�����)�)�"�#�.��c�
�:�;�����!2�!2�2�3�!7�#�s��!C�D�K�K���<�<��
���v�x�0rGc��ttjjd�j	d�gd���}|j
d}|dd}t
j||�|j
d}|jddg}t
j||�|j
d}|jd	}t
j||�y)
Nr5rY�rYrYr�rr�r�rYr�r8rr6)
r
rJrrKrLror!r@r�r_rps    r-�"test_getitem_setitem_ix_duplicatesz8TestDataFrameIndexing.test_getitem_setitem_ix_duplicates�s���
��I�I�!�!�!�$�4�4�V�<�5�
��
�������b�q�6��
���f�h�/��������7�7�A�q�6�?��
���f�h�/��������7�7�1�:��
���v�x�0rGc��ttjjd�j	d�gd���}|j
dg}|jddg}tj||�|j
|ddkD}||ddkD}tj||�|j
|ddkD}||ddkD}tj||�y)	Nr5rYr�r�r�r8r1r)	r
rJrrKrLror�r!r@)r'rCrDr�s    r-�+test_getitem_ix_boolean_duplicates_multiplezATestDataFrameIndexing.test_getitem_ix_boolean_duplicates_multiple�s���
��I�I�!�!�!�$�4�4�V�<�5�
��
��������g�g�q�!�f�o��
���f�c�*�����1���	�"����A����m��
���f�c�*�����1���	�"����A����m��
���f�c�*rG�
bool_valueTFc�,�tdgd�i�}|�d�}tjt|��5|j|ddd�d}tjt|��5d|j|<ddd�y#1swY�?xYw#1swYyxYw)Nr�r4z7: boolean label can not be used without a boolean indexrz.cannot use a single bool to index into setitemr)r
r$r%r&ro)r'r�rC�messagercs     r-�%test_getitem_setitem_ix_bool_keyerrorz;TestDataFrameIndexing.test_getitem_setitem_ix_bool_keyerror�s�����Y�'�
(���L� W�X��
�]�]�8�7�
3�	��F�F�:��	�?��
�]�]�8�3�
/�	#�!"�B�F�F�:��	#�	#�		�	��	#�	#�s�A>�%B
�>B�
Bc��d|d<t|djjttj
f�sJ�|j|jddf}t|�sJ�tddgi�}d|d<|jd}t|�sJ�tdgd	gd�
�}|jd	gdf}tj||�y)Nr1rZr9r�g�G�z��?i�r�rfrrm)
r�r3r�rnrJr�rorrr
rr!r_)r'r(rDrCrEs     r-�"test_single_element_ix_dont_upcastz8TestDataFrameIndexing.test_single_element_ix_dont_upcast�s�����C���+�c�*�0�0�5�5��R�Z�Z�7H�I�I�I�����!2�!2�1�!5�s�!:�;���&�!�!�!���d�V�}�
%����3���������&�!�!�!��3�%�!��3�/�������S��!��
���v�x�0rGc�~�ttjd�jdd�t	ddd���}d}tjt|�	�5|jd
�ddd�tjt|�	�5d|jd�<ddd�y#1swY�>xYw#1swYyxYw)
Nr�rVr8rrr5r�zcallable with ilocrc��y�N)r��r*s r-�<lambda>zMTestDataFrameIndexing.test_iloc_callable_tuple_return_value.<locals>.<lambda>��rGr1c��yr�r�r�s r-r�zMTestDataFrameIndexing.test_iloc_callable_tuple_return_value.<locals>.<lambda>r�rG)	r
rJr�r�rar!rxrTr�)r'rCrcs   r-�%test_iloc_callable_tuple_return_valuez;TestDataFrameIndexing.test_iloc_callable_tuple_return_value
s���
�r�y�y��}�,�,�R��3�5��B��?�
K��"��
�
'�
'�
�S�
A�	$��G�G�N�#�	$�
�
'�
'�
�S�
A�	(�&'�B�G�G�N�#�	(�	(�	$�	$��	(�	(�s�B'�
B3�'B0�3B<c�f�ttjjd�j	d�tddd���}|jd}|jd}tj||�|jd}|jd}tj||�|jtdd�}|jdd	}tj||�|jgd
�}|j|jgd
��}tj||�y)Nr5�rVr8rrr�r1r8rra�r1r5r8r:)r
rJrrKrLrar�ror!r_rsr@rzr�r'rCrDr�rEs     r-�
test_iloc_rowz#TestDataFrameIndexing.test_iloc_rows���
��I�I�!�!�!�$�4�4�W�=�U�1�b�RS�_�
���������f�f�Q�i��
���v�s�+��������f�f�Q�i��
���v�s�+�����q�!��%���6�6�!�B�<��
���f�h�/�����&���:�:�b�h�h�|�4�5��
���f�h�/rGc�J�ttjjd�j	d�tddd���}|j
�}|jtdd�}tj|d|d�sJ�|dj
�}tj|�5d|jdd�df<ddd�|s-d|jddtj|d|d�sJ�tj|d|�y#1swY�RxYw)	Nr5r�rrr�r8rrF)r
rJrrKrLrarIr�rsr#r!r%ror$r_)r'r�r�rCr(�subset�exp_cols       r-�test_iloc_row_slice_viewz.TestDataFrameIndexing.test_iloc_row_slice_view-s��
��I�I�!�!�!�$�4�4�W�=�U�1�b�RS�_�
���7�7�9������q�!��%������1��v�a�y�1�1�1��1�+�"�"�$��
�
"�
"�#5�
6�	#�"�F�J�J�q�!�t��	#�"�#&�G�O�O�A�a� ��#�#�B�q�E�6�!�9�5�5�5�
���r�!�u�g�.�	#�	#�s�4D�D"c��ttjjd�j	d�tddd���}|jdd�df}|jdd�df}tj||�|jdd�df}|jdd�df}tj||�|jdd�tdd�f}|jdd�dd	�f}tj||�|jdd�gd
�f}|j|jgd
���}tj||�y)Nr5�r8rVrrr;r1r8rrar�)r
rJrrKrLrar�ror!r_rsr@rzr<r�s     r-�
test_iloc_colz#TestDataFrameIndexing.test_iloc_colCs��
��I�I�!�!�!�$�4�4�W�=�u�Q�PR�TU��
������A�����f�f�Q��T�l��
���v�s�+�����A�����f�f�Q��T�l��
���v�s�+�����E�!�Q�K��(���6�6�!�Q�r�T�'�?��
���f�h�/�����L��)���:�:�b�j�j��&>�:�?��
���f�h�/rGc�0�ttjjd�j	d�tddd���}|j
�}|jdd�tdd�f}|s�|s�tj|dj|dj�sJ�tj|�5d|jdd�df<ddd�|ddk(j�sJ�tj|dj|dj�sJ�y|r2tj|dj|dj�sJ�d|d<|ddk(j�sJ�tj||�y#1swY��xYw)	Nr5r�rrr;r8rrF)r
rJrrKrLrarIr�rsr#r$r!r%ror�r@)r'rVr�r�rCr(r�s       r-�test_iloc_col_slice_viewz.TestDataFrameIndexing.test_iloc_col_slice_viewZsd����I�I�!�!�!�$�4�4�W�=�u�Q�PR�TU��
���7�7�9������E�!�Q�K��(��"�+>��#�#�B�q�E�M�M�6�!�9�3D�3D�E�E�E��&�&�'9�:�
'�#&��
�
�1�a�4� �
'��q�E�Q�J�#�#�%�%�%��#�#�B�q�E�M�M�6�!�9�3D�3D�E�E�E�"��'�'��1��
�
�v�a�y�7H�7H�I�I�I��F�1�I��1�I��N�'�'�)�)�)��!�!�"�h�/�
'�
'�s�=F�Fc���ttddd��tddd����}|jdtddd����}td|dd	g�
�}t	j
gd��}d|j||df<tgd
�gd�d�|��}tj||�td|dd	g�
�}|j||dfxxdz
cc<tj||�y)Ni�r1)�year�month�dayr9)r-r.)ro�itemrr[r\rt)FFFFFTr:)rrrrr:r:)rrrrrr�r[r\r�)	rr�insertr
rJr�ror!r@)r'�trangerC�bool_idxrEs     r-�test_loc_duplicatesz)TestDataFrameIndexing.test_loc_duplicatesxs������Q�A�6��t�1�!�4�
��
���1�9�$�a�Q�+O��P��
�q���c�
�
;���8�8�E�F��)*����v�h���$�%��$�+=�>�f�
��	���b�(�+��q���c�
�
;��
���v�h���$�%��*�%�
���b�(�+rGc��ttddd��d��}td|i�}|gd�|d<tj|d|�td|i�}|gd�|j
gd�df<tj|d|�y)	Nz
2015-01-01r6�utc)r,�tz�datesrm)r1rr5)rr1r5)rrr
r!r_ro)r'�columnrCs   r-�4test_setitem_with_unaligned_tz_aware_datetime_columnzJTestDataFrameIndexing.test_setitem_with_unaligned_tz_aware_datetime_column�s����
�<��u�E�G�T��
���(�
)���Y�'��7��
���r�'�{�F�3�
���(�
)��%+�I�%6����y�'�!�"�
���r�'�{�F�3rGc�,�td��}ttdd����}tjd|zgdzd��|d	<tjd
|zgdzd��|j
dd�df<tjd|zgdzd��|j
|jddd
f<tjd|zgdzd��|j
dd�df<tjd|zgdzd��|j
|jdddf<tjd�|d<tjd|zgdzd��|j
|jdddf<tdd��|j
|jdd�df<tjd�|d<|j}ttjd�gdztjd�gd
zztd���}tj||�y)Nr1)�hours�20130101r8r+r��m8[ns]r2r[r5r\r6r�r�r9rZrir�r:rsr!�G�Hztimedelta64[ns]zdatetime64[ns]�ABCDEFGH)rr
rrJr�ror�timedelta64rjr�rr3rr!r_)r'�one_hourrCrDrEs     r-�,test_loc_setitem_datetimelike_with_inferencezBTestDataFrameIndexing.test_loc_setitem_datetimelike_with_inference�s����1�%��
�Z�
�A�>�
?���(�(�A��L�>�A�-�X�>��3�����1�x�<�.�1�"4�H�E����q�#�v��$&�H�H�a�(�l�^�a�-?�x�$P����r�x�x���|�S� �!����1�x�<�.�1�"4�H�E����q�#�v��$&�H�H�a�(�l�^�a�-?�x�$P����r�x�x���|�S� �!��.�.��'��3��%'�X�X�q�8�|�n�q�.@��%Q����r�x�x���}�c�!�"�&0��Q�&G����r�x�x��|�~�s�"�#��-�-��&��3�������
�X�X�'�
(�)�A�-����:J�1K�0L�q�0P�P��z�"�
��	���v�x�0rGc
��ttjtjtjtjtjd�tjdtjddd�tjtjdtjtjd�tjtjtjtjtjd�dtjtjtjtjd�dddddd�d��}|j�}d||d	kD<|j�}d|jd
<d|jd<d|jd<d|jd
<tj||�d|d<d}tjt|��5d||d	kD<ddd�y#1swYyxYw)N)�#r�r��1�2gj�B�z��?g% t��?g���k��?g�������?rr1)rr1r5r6r8rcg333333�?)r�r1)r�r1)r�r1)r�r8�testrYz1not supported between instances|unorderable typesr)
r
rJr}rIror!r@r$r%r�)r'rCrrErcs     r-�#test_getitem_boolean_indexing_mixedz9TestDataFrameIndexing.test_getitem_boolean_indexing_mixed�sx��
����B�F�F����B�F�F����O����+����+�+��������+�����������B�F�F����B�F�F����O�+�����������������q�a�8�1
�
��<�g�g�i����C�#�I���7�7�9������U������U������U������U��
���c�8�,���5�	�A��
�]�]�9�C�
0�	��B�r�C�x�L�	�	�	�s�+	G=�=Hc�p�tjddgddggddg��}tgd�gd�g|tddgd	�
���}t	j
td�
�5|dd�dfddd�ttd�d	�
�}tddgddggddgddggddg��}tddgddgg||��}|jdd�td�dff}tj||�d}ttd�d	�
�}tddg||��}|d}tj||�y#1swY��xYw)Nrbrcrr1r���names)r1r1r5r5)r6r6r8r8r>rmr�rsrr5)�levels�codesr�r6r8)rbrr�)r�from_productr
rr$r%rrarorsr!r@rr_)r'�mi�dgrr<rErDris        r-�test_type_error_multiindexz0TestDataFrameIndexing.test_type_error_multiindex�sA��
�
$�
$�s�C�j�1�a�&�%9�$���
M��
�
�<�(�"�E�1�a�&�s�<S�
���]�]�,�G�
<�	��q�!�t�H�	��e�A�h�S�)����#�J��A��'��A���A��/?��c�{�
���q�!�f�q�!�f�-�w�e�L������E�$�K��+�+�,��
���f�h�/����e�A�h�S�)���1�a�&��D�9���F���
���v�x�0�#	�	�s�
D,�,D5c�R�ttjd�tjjtjd����}|jdd�df}|d}tj||�|jdd�df}tj||�y)N�r6r8r9r;rr)r
rJrrh�
IntervalIndex�from_breaksr�r�r!r_ro)r'rCrErSs    r-�,test_getitem_interval_index_partial_indexingzBTestDataFrameIndexing.test_getitem_interval_index_partial_indexing�s��
��G�G�F�O�R�%5�%5�%A�%A�"�)�)�A�,�%O�
���7�7�1�a�4�=����g��
���s�H�-��f�f�Q��V�n��
���s�H�-rGc�2�tddgt��}tjd�tjd�d�|jd<ttjd�gtjd�gd��}tj||�y)Nr�r�)r<r3)r5)r5r5rdr)r
rwrJ�zerosror!r@r�s   r-� test_setitem_array_as_cell_valuez6TestDataFrameIndexing.test_setitem_array_as_cell_valuesk��
��S�z��
8���(�(�4�.�r�x�x��/?�@����q�	��B�H�H�T�N�#3�2�8�8�F�;K�:L�M�N��
���b�(�+rGc��tdgd�id��}|j�}|jdd�ddd�f|jddt	j
||�tjjj|jdd�ddd�f�|jddt	j
||�|jdd�dd�fj�|jddt	j
||�y)Nr[r4�Int64r2rs)r
rIrQror!r@rh�core�arrays�NumpyExtensionArrayr�)r'rC�origs   r-�$test_iloc_setitem_nullable_2d_valuesz:TestDataFrameIndexing.test_iloc_setitem_nullable_2d_valuess���
��Y�'�w�
7���w�w�y���I�I�a��2��g�&����q�	�
���b�$�'��G�G�N�N�6�6�r�y�y��D�b�D��7I�J����q�	�
���b�$�'��W�W�Q��T�]�'�'�)�����
�
���b�$�'rGc��ttjdt���}tj|d�|d<|dgy)N�r1r1r2r)r
rJr�rw�
empty_liker�s  r-�,test_getitem_segfault_with_empty_like_objectzBTestDataFrameIndexing.test_getitem_segfault_with_empty_like_objects6��
�r�x�x��f�5�
6���
�
�b��e�$��1��
�A�3�rGz.ignore:Setting a value on a view:FutureWarning�null�M8[ns]r�c��tdgd�i|��}|dj�}|j}djgd��}t	j
t|��5||d<ddd�t	j
t|��5||g|ddddd�t	j
t|��5||d<ddd�t	j
t|��5||g|ddddd�t	j
t|��5||jd<ddd�t	j
t|��5||g|jddddd�t	j
t|��5||jd	<ddd�t	j
t|��5||g|jdd�df<ddd�|j�}|j�|d
<t	j
t|��5||jd	<ddd�t	j
t|��5||g|jdd�df<ddd�y#1swY���xYw#1swY���xYw#1swY���xYw#1swY���xYw#1swY��oxYw#1swY��GxYw#1swY��!xYw#1swY��xYw#1swY��xYw#1swYyxYw)Nr[r4r2�|)z@timedelta64\[ns\] cannot be converted to (Floating|Integer)Dtypez?datetime64\[ns\] cannot be converted to (Floating|Integer)Dtypez 'values' contains non-numeric NAz1Invalid value '.*' for dtype (U?Int|Float)\d{1,2}rrr5�rrr\)r
rIr$�joinr$r%r�r�)r'r��any_numeric_ea_dtyperC�serr�rcrs        r-�.test_setting_mismatched_na_into_nullable_failszDTestDataFrameIndexing.test_setting_mismatched_na_into_nullable_fails&sn����Y�'�/C�
D����g�l�l�n���k�k���h�h�
�
���]�]�9�C�
0�	��C��F�	��]�]�9�C�
0�	#��T�l�C���G�	#��]�]�9�C�
0�	��C��F�	��]�]�9�C�
0�	#��T�l�C���G�	#��]�]�9�C�
0�	��C�H�H�Q�K�	��]�]�9�C�
0�	(� �$�<�C�H�H�R�a�L�	(��]�]�9�C�
0�	!� �B�G�G�D�M�	!��]�]�9�C�
0�	*�"�D�\�B�G�G�B�Q�B��E�N�	*��g�g�i���8�8�:��C��
�]�]�9�C�
0�	"�!�C�H�H�T�N�	"��]�]�9�C�
0�	+�#�T�l�C�H�H�R�a�R��U�O�	+�	+�=	�	��	#�	#��	�	��	#�	#��	�	��	(�	(��	!�	!��	*�	*��	"�	"��	+�	+�sx�I�I�3I*�I7�J�:J�/J�"J+�>J7�1K�I�I'�*I4�7J�J�J�J(�+J4�7K�Kc��tdgtgd����}d|jd<tddgitdgd����}tj||�y)Nr�r�rmr�r1rr�)r
rror!r@r�s   r-�+test_loc_expand_empty_frame_keep_index_namezATestDataFrameIndexing.test_loc_expand_empty_frame_keep_index_name[sO��
��u�E�"�3�,?�
@������q�	��c�A�3�Z�u�a�S�s�/C�D��
���b�(�+rGc���tdgtjggd�����}d|jd<tddgitjdggd�����}t	j
||�y)Nr�r�r�r�rYr4r��r
r�from_tuplesror!r@r�s   r-�+test_loc_expand_empty_frame_keep_midx_nameszATestDataFrameIndexing.test_loc_expand_empty_frame_keep_midx_namesbsg��
��E��!7�!7��/�!R�
��"����y���
�5�'�N��(�(�)��O�L�
��	���b�(�+rGz	val, idxr)rbr�rbr�)r1r�r1c�0�tdddgi�}tjtd��5td|dgiddg��|jdd�|f<ddd�tdt
j|gi�}tj||�y#1swY�=xYw)Nr�r1r5r]rr�r�)r
r!rxrTrorJr}r@)r'�idxrr?rCrEs     r-�test_loc_setitem_rhs_framez0TestDataFrameIndexing.test_loc_setitem_rhs_framens�����a��V�}�
%��
�
'�
'��!H�
�	H�(��s�B�i�(8��A��G�B�F�F�1�d�7�O�	H��c�B�F�F�C�=�1�2��
���b�(�+�	H�	H�s�%B�Bc���tddg��}|j�}|dd}tjddgtj��|j
dd�df<t
j||�y)Nr�r�r;r1r5r2r)r
rIrJr�r�r�r!r@)r'r�rCrE�views     r-�$test_iloc_setitem_enlarge_no_warningz:TestDataFrameIndexing.test_iloc_setitem_enlarge_no_warning�sZ����S�z�
*���7�7�9���!�u�����!�Q��r�z�z�:�����1��
�
���d�H�-rGc��tdddd�tjddgddggddg���	�}d
g}d|d<d
|j|df<|j|df|j|ddgfd|j|df<|j|df}t	dtjdgdggddg��d��x}}tj||�y)NTr1r�)�bool_colr�r�r5�idx1�idx2r�r�r�r6r�rr�r�r�r�)r
r�from_arraysrorr!r_)r'rCrBrDrEs     r-�(test_loc_internals_not_updated_correctlyz>TestDataFrameIndexing.test_loc_internals_not_updated_correctly�s���
��A�C�0��(�(�1�a�&�1�a�&�)9�&�&�AQ�R�
���h����3������s�C�x��
���s�C�x��
���s�S�#�J�������s�C�x������S��!�����(�(�1�#��s��F�F�;K�L��
�	
��2�
	���v�x�0rGr?Nc��tdgd�id��}||jdgdd�f<tdtjddgid��}t	j
||�y�Nr�r�r�r2rr�r��r
r�rh�NAr!r@�r'r?rCrEs    r-� test_iloc_setitem_string_list_naz6TestDataFrameIndexing.test_iloc_setitem_string_list_na�sT����_�-�X�
>��������Q����c�B�E�E�3��#4�5�X�F��
���b�(�+rGc��tdgd�id��}||jddd�f<tdtjddgid��}t	j
||�yr�r�rs    r-�test_iloc_setitem_string_naz1TestDataFrameIndexing.test_iloc_setitem_string_na�sR����_�-�X�
>�������1��
��c�B�E�E�3��#4�5�X�F��
���b�(�+rG�funcc��tdgd�id��}d|jdd�|dg�f<tdgd�id��}tj||�y)Nr�r4r�r2r9r)r9r9r9r�)r'rrCrEs    r-�/test_iloc_setitem_ea_null_slice_length_one_listzETestDataFrameIndexing.test_iloc_setitem_ea_null_slice_length_one_list�sN����Y�'�w�
7�� !�����4���9����c�9�-�W�=��
���b�(�+rGc�J�ttjddggd�gddg����}td|jj
�}|dd	d
g��}|j|dd�f}ttjdd
gddg����}tj||�y)Nr[r\r��first�secondr�r��Indexerr�r�)rr	)r[r�)r[r�)
r
rr�rrr�ror�r!r@)r'rC�
indexer_tupler�rDrEs      r-�test_loc_named_tuple_for_midxz3TestDataFrameIndexing.test_loc_named_tuple_for_midx�s���
��)�)��s��_�-�g�x�5H��
��
#�9�b�h�h�n�n�=�
��3��S�z�:������a������(�(��Z�(��(�0C��
��
	���f�h�/rGr�r7r�c��tdtd�td�gi|��}|dtjd��z|jdg|f<tdtd�td�gi|��}tj||�y)Nr�z
2022-12-29z
2022-12-30r1)�daysz
2022-12-31)r
rrh�	Timedeltaror!r@)r'r7r�rCrEs     r-�test_set_2d_casting_date_to_intz5TestDataFrameIndexing.test_set_2d_casting_date_to_int�s����
�9�\�*�I�l�,C�D�L��L�
�� "�#�w����1�)=�=�����s�G�|���
�9�\�*�I�l�,C�D�L��L�
��	���b�(�+rGric���d}ti|�t|�t|�d���}|j�}|ddg|j|dgzddgf<t	j
||�y)NrrgrbrcT)r
rarIror!r@)r'r7�nrCrEs     r-�1test_loc_setitem_reordering_with_all_true_indexerzGTestDataFrameIndexing.test_loc_setitem_reordering_with_all_true_indexer�sh��
��
�<�#�<�E�!�H�5��8�<�
=���7�7�9��)+�S�#�J�����q�D�6�z�C��:�%�&�
���b�(�+rGc��tddg��}|j�}tdg��}tjd�5||jdd�df<ddd�tj
||�y#1swY� xYw)Nr�r�r;)r
rIr!rxror@)r'rCrE�rhss    r-�test_loc_rhs_empty_warningz0TestDataFrameIndexing.test_loc_rhs_empty_warning�sk��
��S�z�
*���7�7�9�����&��
�
'�
'��
-�	!� �B�F�F�1�c�6�N�	!�
���b�(�+�	!�	!�s�A4�4A=c�F�tgd�gd�g�}tddgd��}tdgd��}|j||f}tddggdg�	�}tj||�|j|j
|j
f}tj||�y)
N�rr1r5r6r8�r9r:rBr�	rr1r�r2r9r:r�)r
rr�r!r@rQ)r'rCr��row_indexerrDrEs      r-�test_iloc_ea_series_indexerz1TestDataFrameIndexing.test_iloc_ea_series_indexer�s���
���9�
:���!�Q��w�/���a�S��0������g�-�.���q�!�f�X�a�S�1��
���f�h�/�����+�+�W�^�^�;�<��
���f�h�/rGc��tgd�gd�g�}tdtjgd��}d}t	j
t|��5|jdd�|fddd�t	j
t|��5|jdd�|jfddd�y#1swY�KxYw#1swYyxYw)Nrrrr�r2zcannot convertr)	r
rrhr�r$r%r`r�rQ)r'rCr�rcs    r-�#test_iloc_ea_series_indexer_with_naz9TestDataFrameIndexing.test_iloc_ea_series_indexer_with_na�s���
���9�
:���!�R�U�U��7�3����
�]�]�:�S�
1�	 ��G�G�A�w�J��	 �
�]�]�:�S�
1�	'��G�G�A�w�~�~�%�&�	'�	'�	 �	 ��	'�	'�s�B*�B6�*B3�6B?)Tr3�booleanc��tjtgd�|��tgd�|��gddg��}tdgd�i|�	�}t	j
tt|t��5|j|}ddd�tdd
dgitdd
gd|���	�}t	j|�y#1swY�?xYw)N)TTFFr2)TFTFr�r�r�r�)r1r5r6r8r�r1r5TF)rir3)rr�rr
r!�maybe_produces_warningr	�
isinstance�tuplerorr@)r'r3r��midxrCrDrEs       r-�test_loc_bool_multiindexz.TestDataFrameIndexing.test_loc_bool_multiindexs����%�%��1��?��1��?�
���*�
����\�*�$�
7��
�
&�
&�'9�:�g�u�;U�
V�	%��V�V�G�_�F�	%��
�1�a�&�M���e�}�3�e�!L�
��	���f�h�/�	%�	%�s�/B=�=Cr�r�c
��tttddd�tddd�g|��ddgd��}|jd�	�}||d
}|d|j|d
|f<tj||�y)Ni�r1rr�)r�TF)r��update)�deepr'r�)r
rrrIror!r@)r'r�r�rCrE�	update_dfs      r-�2test_loc_datetime_assignment_dtype_does_not_changezHTestDataFrameIndexing.test_loc_datetime_assignment_dtype_does_not_changes����#��d�A�r�*�H�T�1�b�,A�B��� ��-�	
�
���7�7��7�%���r�(�|�$�	�(1�&�(9����r�(�|�W�$�%�
���b�(�+rGzindexer, idxr5c��tdtjgdtjgdtjggt��}tdtjgdtjgg�}|||�d|�dd�f<tdtjgdtjgdtjggt��}t	j
||�y)Nrkrlr�r2r1r5)r
rJr}rwr!r@)r'r�rBrCrrEs      r-�"test_setitem_value_coercing_dtypesz8TestDataFrameIndexing.test_setitem_value_coercing_dtypes's�����b�f�f�
��R�V�V�}�s�B�F�F�m�D�F�
S���!�R�V�V��q�"�&�&�k�2�3��"����D�S�D�!�G���q�"�&�&�k�A�r�v�v�;��b�f�f�
�F�f�U��
���b�(�+rG)g�__name__�
__module__�__qualname__r.rFrTrWrerqr�r�r$�mark�parametrizer�r�r�r�r�r�r�r�r�r�r�r�rrr
rrr�td�skip_array_manager_invalid_testr)r/r4r9r@rDrHrJrLrPrWr^rkrqrurwryr{r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r��filterwarningsrhri�to_numpyr�r�r�r�r�r�r�rrrrrJr�rrrrrrrr�r%r*r!ror�r,r�rGr-rr*s���"�"B�4�>�&�&1�97�v 1�D�[�[���
�#�%7�9N�O��0��0�/��
0�0�$)�&�16�f	,�2,�h<�:.7�`
'�-�*
V�*�0��:�'�'�9�(�9�.1�(
&�/��'�'�3�(�3� 0�.�'�'�/�(�/�(0�,�
,�W*�r .�D,�@1�
U�
�U�U�	-�1�1�&+�&�[�[���\�D�%�=�9�	#�:�	#�1�$(�0�./�,0�.0�<,�64�1�,,�\1�2.�,�(���[�[��� P�Q��[�[�������������2�B�F�F�O�O�H�4M�N��/+��R�/+�b,�
,��[�[�����
�3�%�L��
���J�		
��	,��	,��'�'�.�(�.�1�.�[�[���U�T�D�6�2�5�5�2�5�5�'�$B�C�,�D�,��[�[���U�T�2�5�5�M�2�,�3�,��[�[���V�d�F�B�H�H�%=�>�,�?�,�0�"�[�[���Y�#����5��[�[���U�R�#�q��N�3�	,�4�6�	,��[�[���U�R�&�#��$7�8�,�9�,�,�
0�'��[�[���Y��w��8��[�[���W�t�Y�&7�8�0�9�9�0�"�[�[���U�U�D�M�2��[�[���Y��&��(:�;�,�<�3�,�$�[�[���^�r�v�v�q�k�B�G�G�Q�<�-H�I�,�J�,rGrc��eZdZd�Zy)�TestDataFrameIndexingUInt64c
��ttjd�gd�d�tj��}|dj	d�}d|j
vsJ�||d<t
j|dt|d���d	|j
vsJ�d|d	<||d	<t
j|d	t|d	���|d	=|j�}t
jtd
��5tj|jd<tj|jd
<ddd�|d}t
jt|�tgd�d���t
j|j ttj"d�tj"d�tj"d�ggd����y#1swY��xYw)Nr6)lll
r�r2r[rYr�rmr�r~rr��r1r5r\r��uint64�Or}r�)r
rJr�r:�renamer<r!r_rrIrxrTrhrir�rr�r3)r'rCrBrrDs     r-r�z(TestDataFrameIndexingUInt64.test_setitem2su��
��)�)�A�,�%C�D��)�)�
����g�n�n�U�#���"�*�*�$�$�$���3��
���r�#�w��s��(=�>��"�*�*�$�$�$���3����3��
���r�#�w��s��(=�>��s�G��g�g�i��
�
'�
'�
�=Q�
R�	$��V�V�C�H�H�T�N��V�V�C�H�H�T�N�	$��S���
���u�V�}�f�5H�s�.S�T�
����J�J�����(�#�R�X�X�c�]�B�H�H�S�M�B�%�
�	
�	$�	$�s�-;G�GN)r-r.r/r�r�rGr-r7r71s�� 
rGr7c��tddgtdd��tjdd��d��}|jd}t|jdt�sJ�t|jdtj�sJ�|jd}t|jdt�sJ�t|jdtj�sJ�|jdd��}t|jdt�sJ�t|jdtj�sJ�|ry|j}|j�|jd�j}t|dt�sJ�t|dtj�sJ�|j|j d}|j"d	k(sJ�|j%d
�}t|t�sJ�|j|j d}|j"dk(sJ�|j%d
�}t|tj�sJ�y)Nr1r5�2000r+z1 Dayr}r)�axisr�r�r�)r
rrh�timedelta_rangeror"rQrrr��xs�_mgr�_rebuild_blknos_and_blklocs�fast_xsr��blocks�blknosr3�iget)rVrCr��mgrr��blkr?s       r-�/test_object_casting_indexing_wraps_datetimelikerJUs���	��Q���F�A�.��#�#�G�Q�7�	
�
�B�
�&�&��)�C��c�j�j��m�Y�/�/�/��c�j�j��m�R�\�\�2�2�2�
�'�'�!�*�C��c�j�j��m�Y�/�/�/��c�j�j��m�R�\�\�2�2�2�
�%�%���%�
�C��c�j�j��m�Y�/�/�/��c�j�j��m�R�\�\�2�2�2���
�'�'�C��#�#�%�

�+�+�a�.�
�
�C��c�!�f�i�(�(�(��c�!�f�b�l�l�+�+�+�

�*�*�S�Z�Z��]�
#�C��9�9�� � � �

�(�(�6�
�C��c�9�%�%�%�

�*�*�S�Z�Z��]�
#�C��9�9�� � � �

�(�(�6�
�C��c�2�<�<�(�(�(rGzFCannot setitem on a Categorical with a new category( \(.*\))?, set thezCCannot set a Categorical with another, without identical categoriesc��eZdZejd��Zejd��Zejd��Zejd��Zejd��Z	ejjdejejg�d��Zejjdejejej ej"g�d��Zejjdejejg�d	��Zejjdejejg�d
��Zejjdejejg�d��Zejjdejejg�d��Zejjdej.ejejg�d
��Zd�Zy)�TestLocILocDataFrameCategoricalc�j�tgd�ddg��}tgd��}gd�}t||d�|��}|S)	N)r�r�r�r�r�r�r�r�r���
categories��hr>r=r��l�mr�r1r1r1r1r1r1r1��catsrQr��rrr
)r'rVrBrQr�s     r-r�z$TestLocILocDataFrameCategorical.orig�s:���>�C�QT�:�V���7�8��&���$�&�9��E���rGc�j�tgd�ddg��}tgd��}gd�}t||d�|��}|S)	N�r�r�r�r�r�r�r�r�r�rNrP)r1r1r5r1r1r1r1rUr�rW)r'�cats1r��values1�exp_single_rows     r-r\z.TestLocILocDataFrameCategorical.exp_single_row�s=���?�S�RU�J�W���8�9��'��"�E�W�#E�T�R���rGc�j�tgd�ddg��}tgd��}gd�}t||d�|��}|S)	N�r�r�r�r�r�r�r�r�r�rNrP)r1r1r5r5r1r1r1rUr�rW)r'�cats2r��values2�
exp_multi_rows     r-raz-TestLocILocDataFrameCategorical.exp_multi_row�s=���?�S�RU�J�W���8�9��'��!�5�G�"D�D�Q�
��rGc�j�tgd�ddg��}tgd��}gd�}t||d�|��}|S)	Nr^r�r�rNrPrTrUr�rW)r'�cats3�idx3�values3�exp_parts_cats_cols     r-rfz2TestLocILocDataFrameCategorical.exp_parts_cats_col�s?���?�S�RU�J�W���8�9��'��&���'I�QU�V��!�!rGc�j�tgd�ddg��}tgd��}gd�}t||d�|��}|S)	NrYr�r�rNrPrTrUr�rW)r'�cats4�idx4�values4�exp_single_cats_values     r-rkz5TestLocILocDataFrameCategorical.exp_single_cats_value�sC���?�S�RU�J�W���8�9��'�� )��g�.�d�!
��%�$rGr�c��|j�}tdd�}|tjurtdd�}ddgddgg||�|dd�f<tj||�|j�}tjtt��5ddgddgg||�|dd�f<ddd�y#1swYyxYw)Nr5r8r=r�r�rr�)	rIrsr!ror@r$r%r��msg1)r'r�rar�rCr,s      r-�#test_loc_iloc_setitem_list_of_listszCTestLocILocDataFrameCategorical.test_loc_iloc_setitem_list_of_lists�s����Y�Y�[���A�q�k���b�f�f����S�/�C� #�Q�x�#�q��2����C��F��
���b�-�0�
�Y�Y�[��
�]�]�9�D�
1�	7�$'��8�c�1�X�"6�G�B�K��Q���	7�	7�	7�s�B4�4B=c�h�|j�}d}|tjtjfvr|jd|j
df}d||�|<tj||�tjtt��5d||�|<ddd�y#1swYyxYw)N)r5rr5rr�rr�)rIr!ro�atrr<r@r$r%r�rm)r'r�rkr�rCr,s      r-�7test_loc_iloc_at_iat_setitem_single_value_in_categorieszWTestLocILocDataFrameCategorical.test_loc_iloc_at_iat_setitem_single_value_in_categories�s���
�Y�Y�[�����r�v�v�r�u�u�o�%��8�8�A�;��
�
�1�
�.�C�����C��
���b�"7�8��]�]�9�D�
1�	#�"�G�B�K���	#�	#�	#�s�B(�(B1c���|j�}|jdk(}d}|tjur|j|}d||�||f<tj
||�y)Nr=rr�)rIrr!ror<r@)r'r�rkr�rCr�r,s       r-�5test_loc_iloc_setitem_mask_single_value_in_categorieszUTestLocILocDataFrameCategorical.test_loc_iloc_setitem_mask_single_value_in_categories�s]��
�Y�Y�[���x�x�3������b�f�f���*�*�S�/�C�!$����D�#�I��
���b�"7�8rGc�B�|j�}d}|tjur|jd}ddg||�|dd�f<tj||�tjtt��5ddg||�|dd�f<ddd�y#1swYyxYw)Nr5r�rr�)	rIr!rorr@r$r%r�rm)r'r�r\r�rCr,s      r-�2test_loc_iloc_setitem_full_row_non_categorical_rhszRTestLocILocDataFrameCategorical.test_loc_iloc_setitem_full_row_non_categorical_rhs�s���
�Y�Y�[�����b�f�f���(�(�1�+�C� #�A�h����C��F��
���b�.�1��]�]�9�D�
1�	+�#&��(�G�B�K��Q���	+�	+�	+�s�:B�Bc�v�|j�}tdd�df}|tjurtdd�|jdf}tddgddg��}|||�|<tj||�ttd	�td
���}tjtt��5|||�|<ddd�ttd�td
���}tjtt��5|||�|<ddd�y#1swY�\xYw#1swYyxYw)
Nr5r8rr=r�r�r�rN�bb�abcr�cc)rIrsr!ror<rr@rr$r%r��msg2)	r'r�rfr�rCr,�compat�semi_compat�incompats	         r-�1test_loc_iloc_setitem_partial_col_categorical_rhszQTestLocILocDataFrameCategorical.test_loc_iloc_setitem_partial_col_categorical_rhs�s
���Y�Y�[���Q��{�A����b�f�f����c�?�B�J�J�q�M�2�C��c�3�Z�S�#�J�?��!����C��
���b�"4�5�"�$�t�*��e��E��
�]�]�9�D�
1�	+� +�G�B�K���	+��t�D�z�d�5�k�B��
�]�]�9�D�
1�	(�'�G�B�K���	(�	(�	+�	+��	(�	(�s�<D#�D/�#D,�/D8c�b�|j�}tdd�df}|tjurtdd�|jdf}ddg||�|<tj
||�t
jtt��5ddg||�|<ddd�y#1swYyxYw)	Nr5r8rr=r�r�rr�)
rIrsr!ror<r@r$r%r�rm)r'r�rfr�rCr,s      r-�)test_loc_iloc_setitem_non_categorical_rhszITestLocILocDataFrameCategorical.test_loc_iloc_setitem_non_categorical_rhss���
�Y�Y�[���Q��{�A����b�f�f����c�?�B�J�J�q�M�2�C� ��:����C��
���b�"4�5��]�]�9�D�
1�	*� #�S�z�G�B�K���	*�	*�	*�s�B%�%B.c�<�tdd��jt�}tdgd�i|��}|jj
tk(sJ�|tjur||�d}n||�dd�df}|jj
tk(sJ�y)N�2012r6r+rr4r�)rrvrwr
rr3r!�getitem)r'r�rBrCr�s     r-�-test_getitem_preserve_object_index_with_dateszMTestLocILocDataFrameCategorical.test_getitem_preserve_object_index_with_dates*s������+�2�2�6�:��
��9�~�S�
1���x�x�~�~��'�'�'��b�j�j� ��"�+�a�.�C��"�+�a��d�#�C��y�y���&�(�(�(rGc���tdgdggtjddgdg����}tdggtjdgdg����}|jd}t	j
||�y)	Nrr1)r�)r�rr�)rbrr�r�)r'rCrErDs    r-� test_loc_on_multiindex_one_levelz@TestLocILocDataFrameCategorical.test_loc_on_multiindex_one_level9ss��
��#��s���(�(�&�&�)9�'��K�
����#��j�4�4�f�X�g�Y�O�
��������
���f�h�/rGN)r-r.r/r$�fixturer�r\rarfrkr0r1r!ror�rnrp�iatrqrsrur~r�r�r�r�r�rGr-rLrL�s����^�^�����^�^�����^�^�����^�^�"��"��^�^�%��%��[�[���Y�������(9�:�
7�;�
7��[�[���Y�������"�%�%����(H�I�#�J�#�$�[�[���Y�������(9�:�9�;�9��[�[���Y�������(9�:�+�;�+�$�[�[���Y�������(9�:�(�;�(�:�[�[���Y�������(9�:�*�;�*�$�[�[���Y����R�V�V�R�W�W�(E�F�)�G�)�
0rGrLc���eZdZejjddhddidhdfddidfddhfdddifg�d��Zejjddhddidhdfdfddidfdfddhfdddifg�d��Zejjddhddidhdfddidfddhfdddifg�d��Zejjddhddidhdfdfddidfdfddhfdddifg�d	��Z	y
)�TestDeprecatedIndexersr,r1r�c��tddgddggddg��}tjtd�	�5|j|ddd�y#1swYyxYw�
Nr1r5r6r8r�r�r;�as an indexer is not supportedr�r
r$r%r�ro�r'r,rCs   r-�$test_getitem_dict_and_set_deprecatedz;TestDeprecatedIndexers.test_getitem_dict_and_set_deprecatedGsP��
��A���A��'�#�s��
<��
�]�]�9�,L�
M�	��F�F�3�K�	�	�	���A
�
Ar5r9c���tddgddggddgtjddg��	�}tjt
d
��5|j|ddd�y#1swYyxYw�Nr1r5r6r8r�r�r9r�r�r�r�r
rr�r$r%r�ror�s   r-�/test_getitem_dict_and_set_deprecated_multiindexzFTestDeprecatedIndexers.test_getitem_dict_and_set_deprecated_multiindexPsi�����V�a��V���#�J��(�(�&�&�)9�:�
��
�]�]�9�,L�
M�	��F�F�3�K�	�	�	���A � A)c��tddgddggddg��}tjtd�	�5d|j|<ddd�y#1swYyxYwr�r�r�s   r-�$test_setitem_dict_and_set_disallowedz;TestDeprecatedIndexers.test_setitem_dict_and_set_disallowedesR��
��A���A��'�#�s��
<��
�]�]�9�,L�
M�	��B�F�F�3�K�	�	�	�r�c���tddgddggddgtjddg��	�}tjt
d
��5d|j|<ddd�y#1swYyxYwr�r�r�s   r-�/test_setitem_dict_and_set_disallowed_multiindexzFTestDeprecatedIndexers.test_setitem_dict_and_set_disallowed_multiindexnsk�����V�a��V���#�J��(�(�&�&�)9�:�
��
�]�]�9�,L�
M�	��B�F�F�3�K�	�	�	�r�N)
r-r.r/r$r0r1r�r�r�r�r�rGr-r�r�Fs����[�[���
���a��V�q�c�3�Z�1�a�&�#���S�E�
�Q��c�
�O�T������[�[���
�
�C�
��F��c�1�X�s�O��!�f�a�[�#��
�c�U�O�
�c�3�Z� �
	
�
��
���[�[���
���a��V�q�c�3�Z�1�a�&�#���S�E�
�Q��c�
�O�T������[�[���
�
�C�
��F��c�1�X�s�O��!�f�a�[�#��
�c�U�O�
�c�3�Z� �
	
�
��
�rGr�c�6�tddgi�}d|j|ddk(df<tdgdgd��}tj||�tddgi�}d�}||j|ddk(df<tdg|gd��}tj||�y)Nrbr1rkrcrgc��|S)Nr�)rbs r-r�z4test_adding_new_conditional_column.<locals>.<lambda>�s��a�rG)r
ror!r@)rCrE�values   r-�"test_adding_new_conditional_columnr��s���	�C�!��:�	�B� #�B�F�F�2�c�7�a�<������s�#��/�0�H����"�h�'�	�C�!��:�	�B��E� %�B�F�F�2�c�7�a�<������s�%��1�2�H����"�h�'rG)r3�infer_stringF)�string[pyarrow_numpy]Tc�d�tjd�tddgddgd��}tjd|�5d|j
|d	dk(d
f<ddd�tddgddgdt
d�gd��jd
d
|d��}tj||�y#1swY�QxYw)N�pyarrowr1r5r6r8rd�future.infer_stringrkr�r�r}r�r�)
r$�importorskipr
rh�option_contextro�floatrvr!r@)r3r�rCrEs    r-�.test_adding_new_conditional_column_with_stringr��s������	�"�	�!�Q��q�!�f�-�	.�B�	�	�	�0�,�	?�(�$'����r�#�w�!�|�S� �!�(���1�v�Q��F�#�u�U�|�9L�M�N�U�U��G�%�0��H����"�h�'�(�(�s�B&�&B/c�V�tjd�tddgi�}tjdd�5d|j
|ddk(df<ddd�tdgt
dgd�	�d
�tddgt�	���}tj||�y#1swY�NxYw)Nr�rbr1r�Trkrcr�r2rgr;)r$r�r
rhr�rorrrwr!r@)rCrEs  r-� test_add_new_column_infer_stringr��s���
���	�"�	�C�!��:�	�B�	�	�	�0�$�	7�(�$'����r�#�w�!�|�S� �!�(���c���u�,C�D�E��s�C�j��/��H����"�h�'�
(�(�s�B�B(c
��eZdZd�Zddddej
ejd�ejd�gZ	ddge
dd�gd	�e
d
d
d
�gZejjde	ddejd�ej d�gz�ejjd
e�d���Zejjde	ddej d�gz�ejjd
e�d���Zejjde	dgz�ejjd
e�d���Zy
)�TestSetitemValidationc��d}tj|�}|j�}tj||��5||j
|df<|j�}ddd�tj||��5||j|df<|j�}ddd�y#1swY�KxYw#1swYyxYw)Nz3Setting an item of incompatible dtype is deprecatedrrr�)rMrNrIr!rxr�ro)r'rC�invalidr��warnrc�orig_dfs       r-�_check_setitem_invalidz,TestSetitemValidation._check_setitem_invalid�s���C���i�i��n���'�'�)���
'�
'��C�
8�	 �")�B�G�G�G�Q�J������B�	 �
�
'�
'��C�
8�	 �#*�B�F�F�7�C�<� �����B�	 �	 �	 �	 ��
	 �	 �s�"B+�"B7�+B4�7Cy�?@�Truerkz1.0rirr1�TFFNr�r�r�c�V�tdgd�id��}|j|||t�y)Nr�r�r�r2�r
r�rT)r'r�r�rCs    r-�#test_setitem_validation_scalar_boolz9TestSetitemValidation.test_setitem_validation_scalar_bool�s*��
��1�2�&�
A���#�#�B���-�HrGTr�c���tdgd�i|��}t|�r*|tjurt	j
|�sd}nt}|j||||�y)Nr�r4r2)r
rrhrirJ�isnatrTr�)r'r��any_int_numpy_dtyper�rCr�s      r-�"test_setitem_validation_scalar_intz8TestSetitemValidation.test_setitem_validation_scalar_int�sQ����Y�'�/B�
C����=�W�B�F�F�2�2�8�8�G�;L��D� �D��#�#�B���$�?rGc�V�tdgd�i|��}|j|||t�y)Nr�)r1r5Nr2r�)r'r��float_numpy_dtyper�rCs     r-�$test_setitem_validation_scalar_floatz:TestSetitemValidation.test_setitem_validation_scalar_float�s*����\�*�2C�
D���#�#�B���-�HrG)r-r.r/r�rhrirJrjr��_invalid_scalarsrs�	_indexersr$r0r1r�r�r�r�r�r�rGr-r�r��sl�� �"	���
�
�����
�
�e������u�����Q�C��q�!��&:�E�$��d�<S�T�I��[�[����#�q�#�x�r�x�x��{�J�B�J�J�q�M�&J�J���[�[���Y�	�2�I�3��I��[�[���Y�(8�D�#�z�r�z�z�RU��;W�(W�X��[�[���Y�	�2�@�3�Y�@��[�[���Y�(8�D�6�(A�B��[�[���Y�	�2�I�3�C�IrGr�)�returnN)5�collectionsrrr�decimalrrM�numpyrJr$�pandas._libsr�
pandas.errorsrr	r
�pandas.util._test_decorators�util�_test_decoratorsr2�pandas.core.dtypes.commonr�pandasrhrr
rrrrrrrrr�pandas._testing�_testingr!rUrr7rJrmrzrLr�r�r0r1rwr�r�r�r�rGr-�<module>r�s���"���	��
����
*�)�0�������R�
�D,�D,�N0!
�!
�H()�VQ��L��0�0�D;�;�|(�������	���'���
(��
(�
(�4I�4IrG

Youez - 2016 - github.com/yon3zu
LinuXploit