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/io/pytables/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /Python312/Lib/site-packages/pandas/tests/io/pytables/__pycache__/test_append.cpython-312.pyc
�

0	�g<�����ddlZddlmZddlZddlZddlZddlmZddlm	cm
ZddlZ
ddlmZmZmZmZmZmZmZddlmZmZej2j4Zej8d�Zej2j=d�d��Zd	�Z d
�Z!d�Z"d�Z#d
�Z$d�Z%d�Z&d�Z'd�Z(d�Z)ej2jUdgd��d��Z+d�Z,ejZd��Z.d�Z/d�Z0d�Z1d�Z2d�Z3y)�N)�	timedelta)�	Timestamp)�	DataFrame�Index�Series�_testing�concat�
date_range�read_hdf)�
_maybe_remove�ensure_clean_store�tablesz!ignore::tables.NaturalNameWarningc�z�t|�5}ttjj	d�jd�t
td�t��tddd���	�}t|d
�|jd
|dd�|jd
|dd�tj|d
|�t|d�|jd|ddd
��|jd|dd�tj|d|�t|d�|jd|dd�|jd|dd�tj|d|�t|d�|jd|dd�|jd|dd�tj|d|�tddgddgddgddgg��}d|d<tj|j d<t|d�|jd|�tj|d|�tt#tjj	d�j%ddd��tj&��t#tjj	d�j%ddd��tj(��t#tjj	d�j%ddd��tj*��t#gd�tj,��d �tj.d��!�}t|d"�|jd"|�tj|d"|d#�$�t|d"�|jd"|gd%��&�tj|d"|d#�$�ddd�y#1swYyxYw)'N�)���ABCD��dtype�
2000-01-01r�B��periods�freq��columns�index�df1�
�df2�table)�format�df3z/df3z/df3 foozdf3 foo�r)�data�testing�mixed_column)rr'�df��)�high�sizei��i@)l l@lll)�u08�u16�u32�u64�r�uintsT��check_index_type)r-r.r/��data_columns)r
r�np�random�default_rng�standard_normalr�list�objectr
r�append�tm�assert_frame_equal�put�nan�locr�integers�uint8�uint16�uint32�uint64�arange)�
setup_path�storer(�	uint_datas    �FC:\Python312\Lib\site-packages\pandas/tests/io/pytables/test_append.py�test_appendrMs0��	�J�	'�DP�5���I�I�!�!�!�$�4�4�W�=��$�v�,�f�5��\�2�C�@�
��
	�e�U�#�
���U�B�s��G�$�
���U�B�r�s�G�$�
���e�E�l�B�/��e�U�#�
�	�	�%��C�R���	�1�
���U�B�r�s�G�$�
���e�E�l�B�/��e�U�#�
���V�R���W�%�
���V�R���W�%�
���e�E�l�B�/�	�e�Z�(�
���Z��C�R��)�
���Z��B�C��)�
���e�I�.��3��a��V�a��V�a��V�a��V�<�
=��&��>��$&�F�F���� �!��e�T�"�
���T�2��
���e�D�k�2�.����I�I�)�)�!�,�5�5�a�c��5�J��(�(����I�I�)�)�!�,�5�5�a�e�!�5�L��)�)����I�I�)�)�!�,�5�5�a�e�!�5�L��)�)���7��)�)��
�$�)�)�A�,�'
�	�*	�e�W�%�
���W�i�(�
���e�G�n�i�$�O�	�e�W�%�
���W�i�6K��L�
���e�G�n�i�$�O�IDP�DP�DP�s�NN1�1N:c
��t|�5}ttd�tjtd�D�cgc]}d|����	c}��}ttj
dtj��t
dd����}ttj
d	��}|jd
|�|d
}tj||�|j�J�|jd|�|d}tj||�|j�J�d|_
|jd
|�|d
}tj||�|j|jk(sJ�||dkD}|jd
d�}tj||�||dkD|jdkz}|jd
d�}tj||d��ttjjd�j!d�dg��}tj
t#|��|d<d|d<d|j$dd�df<|j'ddgd��|j)d��}	|	jj+d�|	_|jd |	�tj|d |	d��ddd�ycc}w#1swYyxYw)!Nr�i_)rrrrz
2020-01-01�rr1�d�ss�ts�foo�ns�<zfoo>60�F�Zzfoo>70 and index<90Tr3r)r*r$�A�rr�C�bar�r*��inplace)�future_stack�mi)r
r�ranger7�float64rHr
r=r>�assert_series_equal�name�selectrrr8r9r:�lenrB�	set_index�stack�	droplevel)
rIrJ�irRrSrU�result�expectedra�ss
          rL�test_append_seriesrohsu��	�J�	'�+F�5�
�E�"�I�R�Z�Z�%�PR�)�7T�Q�"�Q�C��7T�
U��
��I�I�b��
�
�+�:�l�TV�3W�
���B�I�I�c�N�
#��
���T�2���t���
���v�r�*��{�{�"�"�"�
���T�2���t���
���v�r�*��{�{�"�"�"����
���T�2���t���
���v�r�*��{�{�b�g�g�%�%�%��b�2�g�;�����d�H�-��
���v�x�0��r�B�w�2�8�8�b�=�1�2�����d�$9�:��
���v�x�$�G��r�y�y�,�,�Q�/�?�?��G�RU�QV�
W���)�)�C��G�$��3����3�� ����q��s�C�x��
���c�3�Z���.��H�H�$�H�'���'�'�#�#�A�&���
���T�1��
���u�T�{�A��E�W+F�+F��7T�+F�+F�s�,K�K�I?K�K�Kc���t|�5}tttjjd�j
d��jd�tjjd�j
d�tjjd�j
d�ddtd�jd�td�jd�d	�tjd��
�}t|d�tj|jdd
�gd�f<|jd|dd�|jd|dd�tj |d|d��|j#�}tj|d<t|d�|jd|dd�|jd|dd�tj |d|d��|j#�}tj|d<t|d�|jd|dd�|jd|dd�tj |d|d��|j#�}tj|d<t|d�|jd|dd�|jd|dd�tj |d|d��ddd�y#1swYyxYw)Nrr�int32rTr\�
2001-01-01rU�
2001-01-02)rY�A1�A2rr[�D�Er1rr�)rtrrvrwrTr3rtrur rwr#)r
rrr7r8r9r:�astyper�as_unitrHrrArBr=r>r?�copy)rIrJr(rr r#s      rL�test_append_some_nansr|�sf��	�J�	'�,H�5�
��B�I�I�1�1�!�4�D�D�R�H�I�P�P����i�i�+�+�A�.�>�>�r�B��i�i�+�+�A�.�>�>�r�B����|�,�4�4�T�:��|�,�4�4�T�:�

��)�)�B�-�

��	�e�U�#�.0�f�f����q��t�*�*�+�
���U�B�s��G�$�
���U�B�r�s�G�$�
���e�E�l�B��F��g�g�i���F�F��D�	��e�U�#�
���U�C���H�%�
���U�C���H�%�
���e�E�l�C�$�G��g�g�i���F�F��D�	��e�U�#�
���U�C���H�%�
���U�C���H�%�
���e�E�l�C�$�G��g�g�i���6�6��C���e�U�#�
���U�C���H�%�
���U�C���H�%�
���e�E�l�C�$�G�Y,H�,H�,H�s�KK�K#c�V
�t|�5}ttjj	d�jd�tjj	d�jd�d�tjd���}tj|jdd�dd�f<t|d�|jd|ddd	�
�|jd|ddd	�
�tj|d|ddd	��t|d
�|jd
|ddd�
�|jd
|ddd�
�tj|d
|d	��tjdd�5t|d�|jd|dd�|jd|dd�tj|d|�ddd�tjdd	�5t|d�|jd|dd�|jd|dd�tj|d|dd�ttjj	d�jd�tjj	d�jd�ddd�tjd���}tj|jdd�dd�f<t|d�|jd|ddd	�
�|jd|ddd	�
�tj|d|d	��t|d
�|jd
|ddd�
�|jd
|ddd�
�tj|d
|d	��ttjj	d�jd�tjj	d�jd�ddtd�j!d�td�j!d�d�tjd���}tj|jdd�dd�f<t|d�|jd|ddd	�
�|jd|ddd	�
�tj|d|d	��t|d
�|jd
|ddd�
�|jd
|ddd�
�tj|d
|d	��ddd�ddd�y#1swY��JxYw#1swY�xYw#1swYyxYw)Nrr)rtrur1rrxr(rT)�dropna���r3r F�io.hdf.dropna_tabler#�df4rTr\)rtrurr[rrrUrs)rtrurr[rvrw)r
rr7r8r9r:rHrArBrr=r>r?�pd�option_contextrrz�rIrJr(s   rL�test_append_all_nansr��s���	�J�	'�RK�5�
��i�i�+�+�A�.�>�>�r�B��i�i�+�+�A�.�>�>�r�B�
��)�)�B�-�
���&�&����q��t�Q�w��	�e�T�"�
���T�2�c�r�7�4��0�
���T�2�b�c�7�4��0�
���e�D�k�2�b�c�7�T�J�	�e�U�#�
���U�B�s��G�E��2�
���U�B�r�s�G�E��2�
���e�E�l�B��F��
�
�4�e�
<�	4��%��'��L�L���3�B��(��L�L���2�3��(��!�!�%��,��3�		4��
�
�4�d�
;�5	K��%��'��L�L���3�B��(��L�L���2�3��(��!�!�%��,��2�3��8���)�)�/�/��2�B�B�2�F��)�)�/�/��2�B�B�2�F���	��i�i��m��B�!�f�f�B�F�F�1�R�4��7�O��%��&��L�L��r�#�2�w�t�L�4��L�L��r�"�#�w�t�L�4��!�!�%��+�r�D�I��%��'��L�L���3�B���L�6��L�L���2�3���L�6��!�!�%��,��T�J���)�)�/�/��2�B�B�2�F��)�)�/�/��2�B�B�2�F���"�<�0�8�8��>�"�<�0�8�8��>�
��i�i��m�
�B�!�f�f�B�F�F�1�R�4��7�O��%��&��L�L��r�#�2�w�t�L�4��L�L��r�"�#�w�t�L�4��!�!�%��+�r�D�I��%��'��L�L���3�B���L�6��L�L���2�3���L�6��!�!�%��,��T�J�k5	K�;RK�RK�.	4�	4��5	K�5	K��;RK�RK�s>�E"T�.AT�>T�LT�5T�T	�T�T	�T�T(c
���t|�5}ttjj	d�jd�t
td�t��tddd���	�}|jjd�|_
t|d
�|jd
|jdd�dd�fdg��|jd
|jdd�dd�f�tj |d
|�|j#d
d
�}|j%dg��}tj ||�|j#d
d�}|j%dg|jdd�	�}tj ||�t'j(d�}t+j,t.|��5|j#d
d�ddd�ddd�y#1swY�xYw#1swYyxYw)Nr�rrrrrrrrrrr)�axes�	columns=ArYrZ)r�zindex=df.index[0:4]rrzOpassing a filterable condition to a non-table indexer [Filter: Not Initialized]��matchzcolumns=A and index>df.index[4])r
rr7r8r9r:rr;r<r
r�
_with_freqrr=�ilocr>r?rf�reindex�re�escape�pytest�raises�	TypeError)rIrJr(rlrm�msgs      rL�!test_append_frame_column_orientedr�s���	�J�	'�C�5�
��I�I�!�!�!�$�4�4�W�=��$�v�,�f�5��\�2�C�@�
��
�8�8�&�&�t�,����e�U�#�
���U�B�G�G�A�r��r�E�N�)���=�
���U�B�G�G�A�q�r�E�N�+�
���e�E�l�B�/����e�[�1���:�:�s�e�:�,��
���h��/����e�%I�J���:�:�s�e�2�8�8�A�a�=�:�A��
���h��/��i�i�
(�
���]�]�9�C�
0�	C��L�L�� A�B�	C�9C�C�8	C�	C��9C�C�s$�F%G!�1G�G!�G	�G!�!G*c��t|�5}td�D�]}ttjjd�j
d�td���}td�|d<|dxx|dzz
cc<tdgt|�zd�	�|d<tdgt|�zd
�	�|d
<|dzdk(r |d=tdgt|�zd�	�|d<|dzdk(r|jd
�}||d
<|jdd��|jd|���	ddd�t|�5}ttjjd�j
d�td�d��}tdgt|�zd�	�|d<tdgt|�zd
�	�|d
<|jd|�tdgt|�zd
�	�|d<tjd�}tj t"|��5|jd|�ddd�tdgt|�zd�	�|d<tjd�}tj t"|��5|jd|�ddd�ddd�y#1swY��~xYw#1swY��xYw#1swY�+xYw#1swYyxYw)Nrr)rr�ABrZrr$�int64r�int16rr]rYTr^r(rc)rr�int16_2zCcannot match existing table structure for [int16] on appending datar���?�float_3zAcannot match existing table structure for [A,B] on appending data)r
rbrr7r8r9r:r;rrg�poprhr=r�r�r�r��
ValueError)rIrJrkr(�ar�s      rL�)test_append_with_different_block_orderingr�>s~��	�J�	'�#�5��r��	#�A���	�	�%�%�a�(�8�8��A�4�PT�:��B� ��)�B�w�K��w�K�1�r�6�!�K� �!��s�2�w��g�>�B�w�K� �!��s�2�w��g�>�B�w�K��1�u��z��w�K�$�a�S�3�r�7�]�'�B��7���1�u��z��F�F�3�K����3���L�L��$�L�/��L�L��r�"�%	#�#�.
�J�	'�#�5�
��I�I�!�!�!�$�4�4�W�=���J��
��
�a�S�3�r�7�]�'�:��7���a�S�3�r�7�]�'�:��7��
���T�2����s�S��W�}�G�<��9�
��i�i�Q�
���]�]�:�S�
1�	#��L�L��r�"�	#���u�s�2�w��i�@��9�
��i�i�O�
���]�]�:�S�
1�	#��L�L��r�"�	#�/#�#�/#�#��L	#�	#��	#�	#��/#�#�sJ�DJ!�8CK�J.�(AK�=J:�K�!J+�.J7	�3K�:K	�?K�Kc
�

��t|�5��fd�}tddgddgg�}�jd|�tj�jd�|�|ddd�td	d
gddgg�}�jd|�t
||g�}tj�jd�|�|ddd�tddgddgg�}�jd
|ddi��tj�jd
�|�|d
dd��jd|�td	dgddgg�}d}tjt|��5�jd|�ddd�tgd�gd�tgd�t��tdd��d��jd�}�jd|d d!d"i��tj�jd�|d ��jd#|d d$d!d"i�%�tj�jd#�|d ��jd&|d'd!d(i�)�|j!�j#�j%d*�+�jd�}�jd&|�tj�jd&�t
||g���jd,|d d'd!d(i�)��jd,|d �tj�jd,�t
|d |d g��t'�d-�tt(j*j-d.�j/d/�tt1d0�t��td1d2d �3��4�}d5|d6<t(j2|j4|j6d7d"d6f<d8|d9<t(j2|j4|j6d"d:d9f<d;|d<<t(j2|j4|j6d7dd<f<�jd-|��jd-�}tj||�ddd�t|�5�td5d8d=�t9d2��>�}t'�d-��jd-|d?d@i��d-d?d@��j;d-�j<d?gk(sJ�t'�d-��jd-|d gd?d@i�%�|d-d?d@��j;d-�j<d d?gk(sJ�t'�d-��jd-|d gdd@i�%�|d-d d@�|d-dAd@��j;d-�j<d gk(sJ�t'�d-��jd-|ddd@���jd-|ddd@��tj�d-|�tgdB�d?g�C�}t'�d-�t?j@dD�}tjt|��5�jd-|dEdEdF���ddd�ddd�y#1swY���xYw#1swY���xYw#1swY�,xYw#1swYyxYw)GNc���t�j|�jj|�j|k(sJ�y�N��getattr�
get_storerr!�description�itemsize��keyrer,rJs   �rL�	check_colz+test_append_with_strings.<locals>.check_colu�8�����(�(��-�3�3�?�?��F�O�O�SW�W�
�W��{�	asdqwertyiY�dggnhebbsdfbdfb�df_big�values_block_1rx�|�asdqyiZ�dggnhefbdfb�df_big2�values�2��min_itemsize�df_new�
abcdefqhij�abcdefghijklmnopqrtsuvwxyzz�Trying to store a string with len \[26\] in \[values_block_1\] column but\nthis column has a limit of \[15\]!\nConsider using min_itemsize to preset the sizes on these columnsr�)�r�g@g@g@)r�r�r�r�r�)�foo1�foo2�foo3�foo4�foo5r�20130101r*rP)rYrr[rvr[rRrrr�ss2T�r6r��ss3r!�)r"r��longer)r[�ss4r(rr�rrrrrrT�stringr$r\�string2��bah�string3�rYrr1rY���values_block_0)rTrTrT�barhr�r�rZzBmin_itemsize has the key [foo] which is not an axis or data_columnr)rT�foobar)!r
rr=r>r?rfr	r�r�r�rr<r
rhrdr@r{�reset_index�assignrr7r8r9r:r;rArBrrbr�r6r�r�)	rIr�r(r rmr�r�rlrJs	        @rL�test_append_with_stringsr�rs���	�J�	'�R*�5�	���k�*�S�2C�,D�E�
F��
���X�r�"�
���e�l�l�8�4�b�9��(�,�b�1��#�w��#�}�)=�>�?��
���X�s�#��2�s�)�$��
���e�l�l�8�4�h�?��(�,�b�1���k�*�S�2C�,D�E�
F��
���Y��(�B���@�
���e�l�l�9�5�r�:��)�-�r�2�	���X�r�"��S�,�/�#�7S�1T�U�V��
�	��]�]�:�S�
1�	+��L�L��6�*�	+��.�.��C�6�R��
�A�6�	
�
��)�C�.�	�	���T�2�c�7�'�1���>�
���u�|�|�D�1�2�c�7�;�	���U�B�s�G�$�g�q�\��R�
���u�|�|�E�2�B�s�G�<�	�	�	�%��G�7�A�,�	�G��g�g�i�#�#�%�,�,�x�,�8�B�B�3�G��
���U�C� �
���e�l�l�5�1�6�2�s�)�3D�E�	�	�	�%��C�����|�	�L�
���U�C��H�%�
���u�|�|�E�2�F�B�s�G�S��X�;N�4O�P�	�e�T�"�
��I�I�!�!�!�$�4�4�W�=��$�v�,�f�5��\�2�C�@�
��
��8��*,�&�&����r�x�x��!�}�h�&�'���9�
�+-�6�6����r�x�x��!�}�i�'�(���9�
�*,�&�&����r�x�x���|�Y�&�'�
���T�2�����d�#��
���f�b�)�eR*�h
�J�	'�#K�5�
�U��/�u�R�y�
A��	�e�T�"�
���T�2�S�#�J��7��$��S�!�����%�2�2�s�e�;�;�;�	�e�T�"�
���T�2�S�E��c�
��K��$��S�!�����%�2�2�s�C�j�@�@�@�	�e�T�"�
���T�2�S�E��3���P��$��S�!��$�(�#�.�����%�2�2�s�e�;�;�;�	�e�T�"�
���T�2�b�q�6���4�
���T�2�a�b�6���4�
���e�D�k�2�.��D�s�e�
T���e�T�"��i�i�P�
���]�]�:�S�
1�	K��L�L��r��b�0I�L�J�	K�E#K�#K�a	+�	+��IR*�R*��l	K�	K��E#K�#K�sJ�E
Y �Y�-K;Y �;F/Y9�*Y-�Y9�Y	�Y � Y*�-Y6	�2Y9�9Zc��t|�5}tdgd�i�}|jd|ddddi��|jd|ddddi��tj|jd�|�ddd�y#1swYyxYw)N�x)r��b�c�d�e�f�r(���r$r�)r
rr=r>r?rfr�s   rL�test_append_with_empty_stringr��s���	�J�	'�6�5�
��?�@�
A��
���T�2�c�r�7�#�q���:�
���T�2�b�c�7�#�q���:�
���e�l�l�4�0�"�5�6�6�6�s�A'A<�<Bc
�0�	�t|�5�	ttjj	d�jd�t
td�t��tddd���	�}d
|jd|jjd�f<t�	d��	jd|dddg�
��	jd|dd�tj �	d|��	j"j$j&j(j*j,j.dusJ��	j"j$j&j(j*j0j.dusJ��	j3dd�}||j0dkD}tj ||��	j3dd�}|j5|j,dd��}||j0dkD}tj ||�|j7�}d|d<tj8|j:|j,dddf<d|j:|j,dddf<t�	d��	jd|dg�
��	j3dd�}||j<dk(}tj ||��	fd�}ddd�t|�5�	t�	d��	jddgddi��ddd�t�	d��	jd|dgd��|ddd�t�	d��	jd|dgddi��|ddd�ddd�t|�5�	dd<d |d!<d"|d#<t�	d��	jd|ddgdd$d%d&���ddd�|ddd$�|dd'd%�ddd�t|�5�	j7�}d
|jd|jjd(�f<d)|jd|jjd�f<d|d<|jjd�}tj8|jdd�|f<d|jdd�|f<d|d<|jjd�}tj8|jdd�|f<d|jd*d+�|f<t�	d��	jd|gd,��
��	j3dd-�}||j<dk(|j>dk(z|j@dkDz|j0dkz}tj ||d.�/��	j3dd0�}||j<dk(|j>d1k(z}tj ||�ddd�t|�5�	j7�}d|d<tj8|j:|j,dddf<d|j:|j,d*d2df<d1|d<tCd3�jEd4�|d5<tj8|j:|j,d6dgd7�f<t�	d8��	jd8|gd9��
��	j3d8d�}||j0dkD}tj ||��	j3d8gd:��}||j0dkD|jFdkDz|j<dk(z}tj ||d.�/�ddd�t|�5�	td;d+�<�}ttjj	d�jd=�|gd>��?�}d|d<tj8|j:|j,dddf<d|j:|j,d*d2df<|dd@gjI�|dd@g<d1|d<�	jd8|gdA��
��	j3d8d�}||j0dkD}tj ||��	j3d8gdB��}||j0dkD|jFdkDz|j<dk(z}tj ||�ddd�y#1swY���xYw#1swY��lxYw#1swY��xYw#1swY��&xYw#1swY���xYw#1swYyxYw)CNrr�rrrrrrrr�rr(r5T�B>0zB>0 and index>df.index[3]rr1rTr�r$r\r*r�zstring='foo'c���t�j|�jj|�j|k(sJ�yr�r�r�s   �rLr�z0test_append_with_data_columns.<locals>.check_colr�r��r�r��	foobarbahr��
foobarbah1�
string_block1�
foobarbah2�
string_block2�(r�)r�r�r�r�rYg��r�)rYrr�r�z.string='foo' and string2='foo' and A>0 and B<0F)�
check_freqzstring='foo' and string2='cool'�cool�	�20010102rU�datetimer])rYrr��df_dc)rr[r�r�r�)�B > 0�C > 0z
string == fooz1/1/2000rP)r�r])rYrr[)rrr[)rr[r�r�)r�r�zstring == "foo")%r
rr7r8r9r:rr;r<r
r�r�get_locrr=r>r?�_handle�rootr(r!�colsr�
is_indexedrrfr�r{rArBr�r�rYrrzr[�abs)
rIr(rlrmr�r��slr�rrJs
         @rL�test_append_with_data_columnsr��sk���	�J�	'�*�5�
��I�I�!�!�!�$�4�4�W�=��$�v�,�f�5��\�2�C�@�
��
/2�����2�:�:�%�%�c�*�*�+��e�T�"�
���T�2�b�q�6����6�
���T�2�a�b�6�"�
���e�D�k�2�.��}�}�!�!�$�$�*�*�/�/�5�5�@�@�D�H�H�H��}�}�!�!�$�$�*�*�/�/�1�1�<�<��D�D�D����d�E�*���b�d�d�Q�h�<��
���f�h�/����d�$?�@�����"�(�(�1�2�,��/���&�(�(�Q�,�'��
���f�h�/������ ��x��24�&�&��
�
�6�<�<��!�$�h�.�/�27��
�
�6�<�<��!�$�h�.�/��e�T�"�
���T�6��
��;����d�N�3���&�-�-�5�0�1��
���f�h�/�	�O*�X
�J�	'�	&�5��e�T�"�
���T�6��
�(�TV���X��$��"�%��e�T�"�
���T�6��
���L��$��"�%��e�T�"�
���T�6��
�(�TV���X��$��"�%�	&�
�J�	'�
.�5�'��y��".����".�����e�T�"�
�����"�I�.�$&�2��D�		�	
�	�$��"�%��$�	�2�&��$�(�"�-�
.�
�J�	'�0�5������69����A�v�~�~�-�-�c�2�2�3�6:����A�v�~�~�-�-�c�2�2�3� ��x��
�^�^�
#�
#�H�
-��!�v�v����A�a�C��G��$����A�a�C��G��!��y��
�^�^�
#�
#�I�
.��!�v�v����A�a�C��G��$����A�a�C��G���e�T�"�
���T�6�0O��P����d�$T�U���
�]�]�e�
#��~�~��&�
(��x�x�!�|�
��x�x�!�|�
�
��	���f�h�5�A����d�$E�F���6�=�=�E�1�f�n�n��6N�O�P��
���f�h�/�=0�@
�J�	'�B�5����	����h��02����	�	�%�+�+�a��"�H�,�-�05��	�	�%�+�+�a��"�H�,�-�!��i��%�j�1�9�9�$�?��j��>@�f�f��	�	�%�+�+�a��"�$:�:�;��e�W�%�
����U�)T�	�	
����g�u�-������1��%��
���f�h�/����g�'J�K���%�'�'�A�+�%�'�'�A�+�6�%�,�,�%�:O�P�Q��
���f�h�5�A�+B�2
�J�	'�0�5��:�q�1����I�I�!�!�!�$�4�4�V�<��#�
��
 ��h��02����	�	�%�+�+�a��"�H�,�-�05��	�	�%�+�+�a��"�H�,�-�!�3��*�-�1�1�3��s�C�j��!��i��	���W�e�2Q��R����g�u�-������1��%��
���f�h�/����g�'L�M���%�'�'�A�+�%�'�'�A�+�6�%�,�,�%�:O�P�Q��
���f�h�/�10�0�*�*��X	&�	&��
.�
.��0�0��@B�B��20�0�sM�Kc�%B	c�Ac%�)G%c2�!E*c?�E$d�c�c"�%c/�2c<�?d	�dc��|}d|j_t|�5}|jd|�|j	d�}tj||�|j	dddg��}|jddg��}tj||�ddd�|dz}|j|dd��t|dddg��}|jddg��}tj||�y#1swY�]xYw)	NrarYrrZztest.hdfr(r!)r�r")
rrer
r=rfr>r?r��to_hdfr)�tmp_pathrI� multiindex_dataframe_random_datar(rJrlrm�paths        rL�test_append_hierarchicalr�s���	)�B��B�J�J�O�	�J�	'�0�5�
���T�2�����d�#��
���f�b�)����d�S�#�J��7���:�:�s�C�j�:�1��
���f�h�/�0��j� �D��I�I�d��W�I�-�
�d�D�3��*�
5�F��z�z�3��*�z�-�H����&�(�+�0�0�s�A9C4�4C=c�"�t|�5}tdtjd�j	d�ztt
d�t��ttd�D�cgc]}d|����	c}t����}|jd	|d
��|jd	�}tj||�|jd|d
��|jd�}tj||�ddd�ycc}w#1swYyxYw)N皙�����?�x�r�rrrr��i-rr(r$��	chunksizerr)�expectedrows)
r
rr7rH�reshaperr;r<rbr=rfr>r?)rIrJrkr(rls     rL�test_append_miscr�s���	�J�	'�*�5�
��"�)�)�C�.�(�(��1�1��$�v�,�f�5��5��9�5�a�2�a�S��5�V�D�
��
	���T�2���+����d�#��
���f�b�)�
���U�B�R��0����e�$��
���f�b�)�*�*��6�	*�*�s�AD�#D�/BD�D�Dr	)rr�i�c�|�tdtjd�jd�zt	td�t��t	td�D�cgc]}d|����	c}t����}d	|d
<d|d<|djd
�|d<|ddkD|d<td�jd�|d<td�jd�|d<t|d��5}|jd||��|jd�}tj||�ddd�ycc}w#1swYyxYw)Nrrrrrr�rrrTr�r��float322�float32r�boolr�rU�time1�20130102�time2�w)�mode�objr)rr7rHrrr;r<rbryrrzr
r=rfr>r?)rIr	rkr(rJrls      rL�test_append_misc_chunksizer�s!��
��b�i�i��n�$�$�W�-�-��d�6�l�&�1��u�R�y�1�!�r�!��X�1��@�
�B�
�B�x�L��B�z�N��
�^�*�*�9�5�B�z�N��J��!�#�B�v�J��J�'�/�/��5�B�w�K��J�'�/�/��5�B�w�K�	�J�S�	1�*�U�
���U�B�)��4����e�$��
���f�b�)�*�*��2�*�*�s�D-�(<D2�2D;c��t|�5}ttd���}|jd|�t	j
td��5|jd�ddd�ttjjd�jd�td���}|jd|�tj|jd�|�|jd|�tj|jd�|�ttd���}|jd|�tj|jd�|�ddd�y#1swY��xYw#1swYyxYw)	N�ABCrZr(z 'No object named df in the file'r�r)rr]r )r
rr;r=r�r��KeyErrorrfr7r8r9r>r?r@)rIrJ�df_emptyr(s    rL�test_append_misc_empty_framer�s#��	�J�	'�7�5��T�%�[�1��
���T�8�$�
�]�]�8�+M�
N�	��L�L���	��r�y�y�,�,�Q�/�6�6�w�?��e��
U��
���T�2��
���e�l�l�4�0�"�5�
���T�8�$�
���e�l�l�4�0�"�5��t�E�{�
+��
�	�	�%���
���e�l�l�5�1�2�6�#7�7�	�	��	7�7�s%�AE;�E.�!DE;�.E8	�3E;�;Fc�

�t|�5}tdtjd�j	d�ztt
d�t��ttd�D�cgc]}d|����	c}t����}d	ggt|�z|d
<|jd
tjk(sJ�tjd�}tjt |��5|j#d
|�ddd�d	ggt|�z|d<d	ggt|�z|d<tjt |��5|j#d
|�ddd�tdtjd�j	d�ztt
d�t��ttd�D�cgc]}d|����	c}t����}t%t'j&ddd�|j(��}|j+t�}tj,|dd||d
<|jd
tjk(sJ�d}tjt |��5|j#d
|�ddd�d}tjt |��5|j#d
tjd��ddd�tjd�}tjt |��5|j#d
t%tjd���ddd�tdtjd�j	d�ztt
d�t��ttd�D�cgc]}d|����	c}t����}|j#d
|�d|d<tjd�}tjt.|��5|j#d
|�ddd�t1|d
�t3d�|d<|j#d
|�d|d<tjd�}tjt.|��5|j#d
|�ddd�ddd�ycc}w#1swY���xYw#1swY��PxYwcc}w#1swY��;xYw#1swY���xYw#1swY���xYwcc}w#1swY��xYw#1swY�nxYw#1swYyxYw)Nrrrrrr�rrr��invalidziCannot serialize the column [invalid]
because its data contents are not [string] but [mixed] object dtyper�r(�invalid2�invalid3i�r$rr1rr*z>too many timezones in this block, create separate data columnsz(value must be None, Series, or DataFramerz]cannot properly create the storer for: [group->df,value-><class 'pandas.core.series.Series'>]rTz�invalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]r�r\ainvalid combination of [values_axes] on appending data [name->values_block_1,cname->values_block_1,dtype->bytes24,kind->string,shape->(1, 30)] vs current table [name->values_block_1,cname->values_block_1,dtype->datetime64[s],kind->datetime64[s],shape->None])r
rr7rHrrr;r<rbrg�dtypes�object_r�r�r�r�r�r=rr�rryrAr�rr)rIrJrkr(r�rns      rL�test_append_raiser#�s��	�J�	'�S#�5���"�)�)�C�.�(�(��1�1��$�v�,�f�5��5��9�5�a�2�a�S��5�V�D�
��
���#�b�'�)��9�
��y�y��#�r�z�z�1�1�1��i�i�
G�
���]�]�9�C�
0�	#��L�L��r�"�	#��%��3�r�7�*��:���%��3�r�7�*��:��
�]�]�9�C�
0�	#��L�L��r�"�	#���"�)�)�C�.�(�(��1�1��$�v�,�f�5��5��9�5�a�2�a�S��5�V�D�
��

�8�$�$�T�1�a�0����A��
�H�H�V�������!�A����9�
��y�y��#�r�z�z�1�1�1�N��
�]�]�9�C�
0�	#��L�L��r�"�	#�9��
�]�]�9�C�
0�	.��L�L��r�y�y��}�-�	.��i�i�
E�
���]�]�9�C�
0�	6��L�L��v�b�i�i��m�4�5�	6���"�)�)�C�.�(�(��1�1��$�v�,�f�5��5��9�5�a�2�a�S��5�V�D�
��
	���T�2����5�	��i�i�
*�
��
�]�]�:�S�
1�	#��L�L��r�"�	#�	�e�T�"��j�)��5�	�
���T�2����5�	��i�i�
D�
���]�]�:�S�
1�	#��L�L��r�"�	#�eS#�S#��6�	#�	#��	#�	#��6�	#�	#��
	.�	.��	6�	6��6�	#�	#�� 	#�	#��eS#�S#�s��AS9�#R�/A7S9�&R�9A	S9�R#�AS9�3R0�?B*S9�)R5�<%S9�!&S�8S9�?/S�.AS9�S�AS9�1S!�A)S9�-S-�S9�S9�R 	�S9�#R-	�(
S9�5R?	�:S9�S	�S9�S	�
S9�!S*	�&S9�-S6	�2S9�9Tc��td�jd�}t|td�D�cgc]}|t	|d��z��c}d��}|d|dz
|d<t
j|jd	d
�df<t|�5}t|d�|jd|d�
�|jd�}tj||�|jdd��}tj||�|jdd��}tj||jd	d�|jdd�}tj||jd	d�|jdd�}|jdg��}tj||jdd�|jdd�}|jdd}tj||jdd�t|d�|j!d|�|jd�}tj||�ddd�ycc}w#1swYyxYw)Nr�rUr)�days�secondsr�rYrr[r]r*r(Tr5zC<100000)�wherezC<pd.Timedelta('-3D')zC<'-3D'zC<'-500000s')�subsetr�z	C<'-3.5D'r$rr )rrzrrbrr7rArBr
rr=rfr>r?r�r~r@)rIrSrkr(rJrls      rL�test_append_with_timedeltar);s��
�:�	�	&�	&�t�	,�B�	��>C�B�i�H��"�y�a��4�4�H�	
�
�B���g��3���B�s�G��v�v�B�F�F�1�Q�3��8��	�J�	'�*�5��e�T�"�
���T�2�D��1����d�#��
���f�b�)����d�*��5��
���f�b�)����d�*A��B��
���f�b�g�g�a�b�k�2����d�I�.��
���f�b�g�g�a�b�k�2����d�N�3�����s�e��,��
���f�b�g�g�a�b�k�2����d�K�0�����Q�R���
���f�b�g�g�a�b�k�2�	�e�U�#�
�	�	�%������e�$��
���f�b�)�=*�*��
I�*�*�s�H>
�F-I�Ic	��ttjjd�j	d�tt
d�t��tddd���	�}|j�jd
j��}d|d
<t||gd��}t|�5}d}tjt |��5|j#ddgdd�|d��ddd�tjt |��5|j#ddd�|d��ddd�d}tjt |��5|j#d|d�ddd�|j#ddgdd�|d��|j%ddgddgd��}||j&dkD|j(dkDz}t+j,||�ddd�y#1swY��xYw#1swY��xYw#1swY��xYw#1swYyxYw)Nrr�rrrrrrr�{}_2rZr\rTr$��axisz=append_to_multiple requires a selector that is in passed dictr�rY�rr r#)�selectorzQappend_to_multiple must have a dictionary specified as the way to split the valuerr zA>0r�)r'r/r)rr7r8r9r:rr;r<r
r{�renamer"r	r
r�r�r��append_to_multiple�select_as_multiplerYrr>r?)rIrr r(rJr�rlrms        rL�test_append_to_multipler3js���
�
�	�	���a� �0�0��9��d�6�l�&�1���r��<��C�
�(�(�*�
�
�F�M�M�
�
2�C��C��J�	��c�
��	#�B�	�J�	'�0�5�M��
�]�]�:�S�
1�	��$�$��c�
�4�0�"�u�
%�
�	�
�]�]�:�S�
1�	U��$�$�T�$�%?��e�$�T�	U�
�	��]�]�:�S�
1�	7��$�$�U�B��6�	7�	� � �#�s��D�!A�2�PU� �V��)�)�
�E�N�5�%�.�5�*�
���r�t�t�a�x�B�D�D�1�H�-�.��
���f�h�/�10�0�	�	��
	U�	U��	7�	7��0�0�sU�(G2�G� #G2�G�%G2�G&�A1G2�G	�G2�G#	�G2�&G/	�+G2�2G;c	��ttjjd�j	d�tt
d�t��tddd���	�}ttjjd�j	d�tt
d�t��tddd���	�jd
j��}tj|jd|jjd
dg�f<t||gd��}t!|�5}|j#d
dgdd�|dd��|j%ddg�}|j'�}t)j*||d��t)j,|j/d�j0|j/d�j0�ddd�y#1swYyxYw)Nrr�rrrrrrrr+rZr$rYr,r.rT�r/r~r r3)rr7r8r9r:rr;r<r
r0r"rAr�r�get_indexerr	r
r1r2r~r>r?�assert_index_equalrfr)rIrr r(rJrlrms       rL�test_append_to_multiple_dropnar8�s���
�
�	�	���a� �0�0��9��d�6�l�&�1���r��<��C�
�
�	�	���a� �0�0��9��d�6�l�&�1���r��<��
�f�V�]�]�f�#�	�
8:�v�v�C�H�H�Q����'�'��c�
�3�
3�4�	��c�
��	#�B�	�J�	'�T�5�
� � ��#�J�t�,�b�5��	!�	
��)�)�5�%�.�9���9�9�;��
���f�h��F�
���e�l�l�5�1�7�7����e�9L�9R�9R�S�T�T�T�s
�+BG�Gc	��ttjjd�j	d�tt
d�t��tddd���	�}|j�jd
j��}tj|jd|jjd
dg�f<t!||gd��}t#|�5}t%j&dd�5|j)d
dgdd�|dd��d}t+j,t.|��5|j1ddg�ddd�|j3d�j4j7|j3d�j4�rJ�	ddd�ddd�y#1swY�`xYw#1swY�xYw#1swYyxYw)Nrr�rrrrrrrr+rZr$rYr,r�T)�df1a�df2ar:Fr5z,all tables must have exactly the same nrows!r�r;)rr7r8r9r:rr;r<r
r{r0r"rAr�rr6r	r
r�r�r1r�r�r�r2rfr�equals)rIrr r(rJr�s      rL�$test_append_to_multiple_dropna_falser=�s���
�
�	�	���a� �0�0��9��d�6�l�&�1���r��<��C�
�(�(�*�
�
�F�M�M�
�
2�C�79�v�v�C�H�H�Q����'�'��c�
�3�
3�4�	��c�
��	#�B�	�J�	'�Q�5�"�2C�2C��t�3�Q�	� � ��3�Z��.��V�E�	!�	
�=��
�]�]�:�S�
1�	7��$�$�f�f�%5�6�	7��<�<��'�-�-�4�4�U�\�\�&�5I�5O�5O�P�P�P�P�Q�Q�Q�	7�	7��Q�Q��Q�Q�s=�F7�48F+�,F�A
F+�F7�F(�$F+�+F4	�0F7�7Gc
�*�ttjdd�tjdd�tjdd�dztd�D�cgc]}d��c}td�D�cgc]}d��c}d��}|jdg}t|�5}|j
d	gd
dgdd
gd�|jdgddddd���|jgd��}tj||d��ddd�ycc}wcc}w#1swYyxYw)Nr$��Xrr��abcde)�IX�Num�BigNum�Str�LongStrrrBrCrDrErF)r�nums�strsrrrQr)rErFrCr�Tr3)
rr7rHrbr�r
r1r2r>r?)rI�_r(rmrJrls      rL�$test_append_to_multiple_min_itemsizerJ�s��	��)�)�A�r�"��9�9�Q��#��i�i��2�&��+�!&�r��+�A�C�+�).�r��3�A��3�	
�
�B��w�w��s�|�H�	�J�	'�G�5�
� � �����)��	�*�
�

�G�G�Q�C�L��!#��A�>�	!�		
��)�)�*C�D��
���f�h��F�G�G��
,��3�
G�G�s�	C?�-	D�AD	�	D)4r�rr��numpyr7r��pandas._libs.tslibsr�pandas.util._test_decorators�util�_test_decorators�td�pandasr�rrrrr>r	r
r�pandas.tests.io.pytables.commonrr
�mark�
single_cpu�
pytestmark�importorskipr�filterwarningsrMror|r�r�r�r�r�r�rr�parametrizerr�&skip_array_manager_not_yet_implementedr#r)r3r8r=rJ�r�rL�<module>r[s'����	��
�)�)�)������
�[�[�
#�
#�
�	��	�	�X�	&�������?�@�EP�A�EP�P,F�^-H�`SK�lC�B1#�hxK�v6�X0�v,�*
*� ������o�6�*�7�*�&7�2�*�*�T#�+�T#�n,*�^"0�JT�2Q�2Gr�

Youez - 2016 - github.com/yon3zu
LinuXploit