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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

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

/	�g_|���ddlmZddlZddlZddlZddlZddlmZddlm	Z	ddl
Zddl
mZm
Z
mZmZmZmZmZddlmZddlmZej2ddg�	�d
��ZGd�d�Zej8j;d
ddg�d��Zd�Zd�Z d�Z!ej8jEd�ej8j;dddejFg�d���Z$ej8jEd�ej8j;dddejFg�ej8j;dddg�d����Z%d�Z&d�Z'ej8jEd�d��Z(d�Z)ej8jEd�d��Z*ej8jEd�d��Z+Gd�d �Z,d!�Z-ej8j;d"dej\fdej\fdej^fd#ej^fg�ej8j;d$ddg�d%���Z0y)&�)�datetimeN)�lib)�PerformanceWarning)�	DataFrame�Index�
MultiIndex�Period�Series�	Timedelta�
date_range)�reshapeTF)�paramsc��|jS�N)�param)�requests �GC:\Python312\Lib\site-packages\pandas/tests/frame/test_stack_unstack.py�future_stackrs���=�=��c�`�eZdZd�Zej
j
d�d��Zd�Zej
j
d�d��Z	d�Z
d�Zd�Zd	�Z
d
�Zd�Zej
j!dd
gd�gd�gd�gd�gej$gd�ddg��ej$gd�dd
g��fdgd�gd�geddgd��ej$gd�gd���fg�d��Zd�Zej
j
d�d��Zej
j
d�d��Zej
j
d�d ��Zd!�Zej
j
d�d"��Zd#�Zd$�Zej
j!d%ej<d&�ej<d&�fej>d&d'�(�ej>d&d)d'�(�ff�d*��Z ej
j
d�d+��Z!d,�Z"ej
j!d-d.gd/�ejFd0d1gejFd&d2gfd2gd3�ejFd&d2gejFd0d1gff�d4��Z$ej
j!d5d6dge%d�g�d7��Z&d8�Z'd9�Z(d:�Z)ej
j!d;d<d=g�ej
j!d>e*e+d1���d?���Z,ej
j!d;e-j\gd@���ej
j!d>e*e+d���ej
j!dAdBdCg�dD����Z/dE�Z0dF�Z1dG�Z2dH�Z3dI�Z4ej
j
d�ej
j!dJgdK�gdL�gdM�gdN�gdO�gdP�d.d2gd.d1gd.dgd.gd1gdggdQ�gdR�gdS�gdT�gdU�gdV�d2d.gd1d.gdd.gg�ej
j!dWdXd.d2d.d2gd2d.gf�dY����Z5ej
j
d�dZ��Z6ej
j!d[d\d]g�d^��Z7ej
j
d�ej
j!d[d\d]g�ej
j!d_e*d`�gda�fe*db�gdc�fg�dd����Z8de�Z9ej
j
d�ej
j
df�ej
j!dggdh�ejtd2d1gd0digg�fgdj�ejtd2d1gd0digg�fgdL�ejtd2d1gd0digg�fg�dk����Z;ej
j
d�ej
j!dld2d1gdmdngdodpdpfd2d1gdqdrgdodsdtfg�du���Z<ej
j!dWd.d2g�dv��Z=ej
j!dWd.dwg�dx��Z>y)y�TestDataFrameReshapec�h�|j�}tjtj|j��j|j�|dd|j
|��}t||d��}|j�}|j�}tj||�tj|d|�|jd�}|jd�}	tj|j|�tj|	dj|�y)N�r)�foo�barrr)�copy�np�arange�prod�shaper
�stackr�unstack�tm�assert_frame_equal�T)
�self�float_framer�df�stacked�
stacked_df�	unstacked�unstacked_df�unstacked_cols�unstacked_cols_dfs
          r�test_stack_unstackz'TestDataFrameReshape.test_stack_unstacks���
�
�
�
���	�	�"�'�'�"�(�(�+�,�4�4�R�X�X�>��1���(�(��(�5���w�w�?�@�
��O�O�%�	�!�)�)�+��
���i��,�
���l�5�1�2�6� ����+��&�.�.�q�1��
���n�.�.��3�
���/��6�8�8�"�=r�9ignore:The previous implementation of stack is deprecatedc	�H�td�gd�ddgg}td|d|d��}|j|��}tdt	j
|dd���}t
j||�td|dt	j
|dd���}|jd|��}tdt	j
|d|dg�|d��}t
j||�|d	d
gjd|��}|d	d
g}t
j||�y)N�)r2�a�b��r��index�columnsr�r8r3r4)	�rangerr!r
r�from_productr#�assert_series_equalr$)r&r�levelsr(�result�expecteds      r�test_stack_mixed_levelz+TestDataFrameReshape.test_stack_mixed_level1s#��
��(�M�A�q�6�2���q��q�	�6�!�9�
=�����|��4���!�:�#:�#:�6�"�1�:�#F�G��
���v�x�0��q��q�	�:�3J�3J�6�RS�RT�:�3V�
W�����!�,��7���
�Z�,�,�f�Q�i����-C�D�f�UV�i�
��	���f�h�/��S�#�J��%�%�a�l�%�C���S�#�J�'��
���f�h�/rc�8�tddtjgddtjgd��}|dg}|d|d<|s$t|jj
�dk(sJ�|j
�}|j
�}tj||�y)Nr5r6�@���x�yrFrG)	rr�nan�len�_mgr�blocksr"r#r=)r&�using_array_managerr(�df2�resr@s      r�test_unstack_not_consolidatedz2TestDataFrameReshape.test_unstack_not_consolidatedKs���
�a��B�F�F�^�3��2�6�6�2B�C�
D���#��i���c�7��C��"��s�x�x���'�1�,�,�,��k�k�m���:�:�<��
���s�H�-rc��tgd�tj��}tjgd��|_|j
d��}tgd�gd�d�gd	�tj�
�}tj||�|j
d��}tgd�gd
�d�gd	�t�
�}tj||�tgd�gd�gd�gd�d��jgd	��}|j
ddgd��}d}||}tgd�|j
|��}tj||�|jddg|��}|j
j|j
j�|_|j!tj"�}|j$|j
}tj||�|d}	|	j
ddgd��}|d}tj||�y)N)r5r6rD���dtype�)rFr3)rFr4)rGr4)�zr3�����
fill_value)r5rVrQ)r6rDrV�r3r4�rFrGrU�r8rS��?)r5r\rQ)r6rDr\�r3r3r4)�j�kr^�rr5r6)rFrGrU�wrFrGr)rar4r^)rrr6)r8�namerra)r
r�int16r�from_tuplesr8r"rr#r$�float�	set_indexr=r!�reorder_levels�names�astype�int64�loc)
r&r�datar?r@r(r+�keyr)�ss
          r�test_unstack_fillz&TestDataFrameReshape.test_unstack_fillWs����l�"�(�(�3���+�+�<�
��
������,����:�.�o�R�X�X�
��	���f�h�/������-����K�0��u�
��	���f�h�/��!��i�i�X�
�
�)�O�
$�	��J�J��S�z�a�J�8�	����S�>���	����s�C��
���v�x�0��/�/�3��*�<�/�H���
�
�4�4�R�X�X�^�^�D��
��.�.����*�����R�X�X�&��
���f�b�)�
�s�G�����C��:�!��4���S�>��
���f�h�/rc���ddgddgddgddgg}t|td	�tj�
�}t	j
gd��|_|jd�
�}gd�gd�gd�g}t|td�tj��}t	j
gd��|_tj||�|djtj�|d<|djtj�|d<|jd�
�}|djtj�|d<|djtj�|d<tj||�|jd�
�}gd�gd�gd�g}t|td�t��}t	j
gd��|_tj||�y)Nr5r6r2rDrQ����AB)r9rSrTrVrW)r5r2r6rD)rVrQrVrq)rrrVrsrV�xyzr[)��Ar3)rwr4)�Br3�rxr4rwrxr\)r\rQr\rq)rrr\rsr\)r�listr�int32rrdr8r"r9r#r$rirc�float64re)r&�rowsr(r?r@s     r�test_unstack_fill_framez,TestDataFrameReshape.test_unstack_fill_frame�s����A���A���A���A��/��
�t�T�$�Z�r�x�x�
@���)�)�<�
������r��*���n�n�=���T��e��B�H�H�E��%�1�1�<�
���	���f�h�/��S�'�.�.����*��3���S�'�.�.����,��3�����r��*�� ��
�,�,�R�X�X�6���
� ��
�,�,�R�Z�Z�8���
�
���f�h�/����s��+���.�0@�A���T��e��E�B��%�1�1�<�
���	���f�h�/rc��tdd��j}t|�}tjgd��|_|j
�}t|dtj|dg|d|dtjgd	�gd
���}tj||�|j
|d��}t|d|d|dg|d|d|dgd	�gd
���}tj||�y)
N�
2012-01-01rD��periodsrTrr2r5r6rYrZr:rW)r�valuesr
rrdr8r"r�pd�NaTr#r$)r&�dvrlr?r@s     r� test_unstack_fill_frame_datetimez5TestDataFrameReshape.test_unstack_fill_frame_datetime�s���
��a�
0�
7�
7���b�z���+�+�<�
��
��������a�5�"�&�&�"�Q�%�(��1��r�!�u�b�f�f�/E�F�!�
��	���f�h�/�����A���/����a�5�"�Q�%��A��'�r�!�u�b��e�R��U�.C�D�!�
��	���f�h�/rc��td�D�cgc]}t|����}}t|�}tjgd��|_|j
�}t|dtj|dg|d|dtjgd�gd	��
�}tj||�|j
|d��}t|d|d|dg|d|d|dgd�gd	��
�}tj||�ycc}w)NrD)�daysrTrr2r5r6rYrZr:rW)r;rr
rrdr8r"rr�r�r#r$)r&�i�tdrlr?r@s      r�!test_unstack_fill_frame_timedeltaz6TestDataFrameReshape.test_unstack_fill_frame_timedelta�s���).�q��
2�A�i�Q��
2��
2��b�z���+�+�<�
��
��������a�5�"�&�&�"�Q�%�(��1��r�!�u�b�f�f�/E�F�!�
��	���f�h�/�����A���/����a�5�"�Q�%��A��'�r�!�u�b��e�R��U�.C�D�!�
��	���f�h�/��%3s�Dc���td�td�td�td�g}t|�}tjgd��|_|j�}t
|dd|dg|d|d	dgd
�gd���}tj||�|j|d�
�}t
|d|d|dg|d|d	|dgd
�gd���}tj||�y)Nz2012-01z2012-02z2012-03z2012-04rTrr2r5r6rYrZr:rW)	r	r
rrdr8r"rr#r$)r&r�rlr?r@s     r�test_unstack_fill_frame_periodz3TestDataFrameReshape.test_unstack_fill_frame_period�s��
�9���9���9���9��	
���g����+�+�<�
��
��������1�:�t�W�Q�Z�0���
�G�A�J�PT�7U�V�!�
��	���f�h�/��������4����a�j�'�!�*�g�a�j�9��a�j�'�!�*�g�a�j�9�
�"�
��	���f�h�/rc	��tgd�d��}tjgd��|_|j	�}tt
jtd�td���t
jtd�td���d	�td
���}tj||�d}tjt|�
�5|j	d��ddd�|j	d��}tt
jtd�td���t
jtd�td���d	�td
���}tj||�y#1swY��xYw)N�r3r4�cr3�categoryrRrT�axa�abc��
categories�bcxrYrur:z9Cannot setitem on a Categorical with a new category \(d\)��match�drWr��aca�bcc)r
rrdr8r"rr��Categoricalrzr#r$�pytest�raises�	TypeError)r&rlr?r@�msgs     r�#test_unstack_fill_frame_categoricalz8TestDataFrameReshape.test_unstack_fill_frame_categorical�s(���*�*�=���+�+�<�
��
�
�������^�^�D��K�D��K�H��^�^�D��K�D��K�H�
��u�+�
��	���f�h�/�K��
�]�]�9�C�
0�	)��L�L�C�L�(�	)������-����^�^�D��K�D��K�H��^�^�D��K�D��K�H�
��u�+�
��	���f�h�/�	)�	)�s�F�F
c�:�tjgd�gd�gddg��}tdgdzdgdzd	�|�
�}|jd�}tgd�gd�gd�gtjgd�ddg��tgd�d�
���}t
j||�y)N�r3r4r��r5r6r2rvry�rhr5�	r6�r��er:)r5r5r5r6r6r6)�r�r3�r�r4)r�r��r�r3�r�r4)r�r��rb�r9r8)rr<rr"rdrr#r$�r&�idxr(r?r@s     r�$test_unstack_tuplename_in_multiindexz9TestDataFrameReshape.test_unstack_tuplename_in_multiindexs����%�%�
�i�(��Z�0H�
���a�S�1�W�A�3��7�3�3�
?�����J�'���
�!3�5G�H��*�*���Z�(�
��	�
�3�
��	���f�h�/rz>unstack_idx, expected_values, expected_index, expected_columnsrv)r5r5r6r6))r5r2)r5rD�r6r2)r6rDrx�Cr�)r�r�r�r�N)rvrx)r5r5r5r5r6r6r6r6r2rDr�))r�r3r5)r�r3r6)r�r4r5)r�r4r6)r�r3r5)r�r3r6)r�r4r5)r�r4r6)Nrvrxc���tjddgddgddgggd���}tdgd	zdgd	zd
�|��}|j|�}t|||��}t	j
||�y)
Nr3r4r5r6r2rD)rvrxr�r�rsr�r:r�)rr<rr"r#r$)	r&�unstack_idx�expected_values�expected_index�expected_columnsr�r(r?r@s	         r�*test_unstack_mixed_type_name_in_multiindexz?TestDataFrameReshape.test_unstack_mixed_type_name_in_multiindex1s��L�%�%��3�Z�!�Q��!�Q��(�0F�
���a�S�1�W�A�3��7�3�3�
?�����K�(����%5�^�
��	���f�h�/rc���tgd�gd�tgd��jd�tjjd�j	d�ddt
jd�tgd	��jd
�tgd��jd�d
tgd��jd�d��}d�}|jddg�}||d�|jddg�}||d�|jddg�}||d�|jgd��}||d�|jddg�}||d�|jddg�}|d}||d�y)N)�IL�MI�NCr�r�r6r2r5r�20010102)��?�I@gY@�float32)rC�@�@r|F)r5��i2�int8)�stater8�some_categoriesrwrxr��D�E�F�G�Hc�v�|j|g�}|j|�}tj||�yr�r"r#r$)r(�column_name�
unstacked1�
unstacked2s    r�unstack_and_comparezNTestDataFrameReshape.test_unstack_preserve_dtypes.<locals>.unstack_and_comparets0�����[�M�2�J����K�0�J��!�!�*�j�9rr�r8r�r�r�)r�rxr�rxr�rw)	rr
rir�random�default_rngr��	Timestamprf)r&r(r��df1rns     r�test_unstack_preserve_dtypesz1TestDataFrameReshape.test_unstack_preserve_dtypesbsQ��
�+�(�#)�/�#:�#A�#A�*�#M��Y�Y�*�*�1�-�4�4�Q�7����\�\�*�-��.�/�6�6�y�A��O�,�3�3�I�>���,�-�4�4�V�<�
�
�� 	:�
�l�l�G�W�-�.���C��)��l�l�G�%6�7�8���C�!2�3��l�l�C��:�&���C��%��l�l�.�/���C��%��l�l�C��:�&���C��%��l�l�G�W�-�.����H���A�w�'rc	�$�tjttjtd�d����}t
tjjd�jd�|��}tj|jddg|��|jd|��jd|���tj|jdd	g|��|jd|��jd|���|j�}|jj!td�d
��}|�J�tj|jddg|��|jd|��jd|���y)Nr2��repeatr6)���r9r5��levelr���rVT)�inplace)rrdrz�	itertools�productr;rrr�r��standard_normalr#r$r!rr9�	set_names)r&rr9r(�df_named�return_values      r�test_stack_intsz$TestDataFrameReshape.test_stack_ints�sf���(�(��i�.?�.?��a��QR�.S�)T�U��
��I�I�!�!�!�$�4�4�X�>��
��	����H�H�A�q�6��H�=��H�H�1�<�H�8�>�>��l�
?�
�	
�	����H�H�B��8�,�H�?��H�H�1�<�H�8�>�>��l�
?�
�	
��7�7�9���'�'�1�1�%��(�D�1�I���#�#�#�
����N�N�!�Q��l�N�C��N�N���N�>�D�D��l�
E�
�	
rc��tjgd�gd���}ttjjd�j
d�|��}|jddg|�	�}|jd
dg|�	�}|j�}gd�|j_
tj|jddg|�	�|d
��tj|jd
dg|�	�|d
��d}tjt|��5|jddg|�	�ddd�|j�}gd�|j_
tj|jddg|�	�|d
��y#1swY�XxYw)N�)rw�cat�long)rxr�r�)rw�dog�short)rxr�r���exp�animal�hair_lengthr�r6�rDrDr�r�r�r�r�)r�r�r5r5F��check_nameszSlevel should contain all level names or all level numbers, not a mixture of the twor�r)r�r�r)rrdrrr�r�r�r!rr9rhr#r$r�r��
ValueError)	r&rr9r(�animal_hair_stacked�exp_hair_stackedrMr��df3s	         r�test_stack_mixed_levelsz,TestDataFrameReshape.test_stack_mixed_levels�s|���(�(�
�3�
����I�I�!�!�!�$�4�4�V�<�g�
��!�h�h��]�+�,�'�
���8�8��-�(�|�$�
���g�g�i��0�����
����I�I�X�q�M��I�E���	
�
	����I�I�U�A�J�\�I�B���	
�
#�	��]�]�:�S�
1�	F��I�I�X�q�M��I�E�	F�
�g�g�i��0�����
����I�I�X�q�M��I�E���	
�	F�	F�s�F�Fc��tjgd�gd���}ttjjd�j
d�|��}|jddg|�	�}|jdd
g|�	�}|jdd
g|�	�}|j�}gd�|j_
tj|jddg|�	�|d
��tj|jddg|�	�|d
��tj|jddg|�	�|d
��|j�}gd�|j_
tj|jddg|�	�|d
��tj|jddg|�	�|d
��tj|jddg|�	�|d
��y)Nr�r�r�r6r�r�r�r�r�r�r`r5Fr�r)r6rr5)
rrdrrr�r�r�r!rr9rhr#r$)	r&rr9r(�exp_animal_stackedr�r�rMr�s	         r�test_stack_int_level_namesz/TestDataFrameReshape.test_stack_int_level_names�s����(�(�
�3�
����I�I�!�!�!�$�4�4�V�<�g�
�� �X�X��(�#�,�&�
��!�h�h��]�+�,�'�
���8�8��-�(�|�$�
���g�g�i��%�����
����I�I�Q��F��I�>���	
�
	����I�I�Q��F��I�>���	
�
	����I�I�Q��F��I�>���	
��g�g�i��%�����
����I�I�Q��F��I�>���	
�
	����I�I�Q��F��I�>���	
�
	����I�I�Q��F��I�>���	
rc	�l�tddgtjddgddgg�dg��}|j�}tt	j
dtjgtjdggt��ddgtjddgddgg���}tj||�y)	NFr3r4r��l�colr7rR)
rr�from_arraysr"r�arrayrH�objectr#r$)r&r(�rs�xps    r�test_unstack_boolz&TestDataFrameReshape.test_unstack_bool(s���
�
�E�N��(�(�3��*�s�C�j�)A�B��G�
��
�Z�Z�\��
��H�H�u�b�f�f�o������7�v�F���*��*�*�U�E�N�S�#�J�+G�H�
��
	���b�"�%rc	��tddgddgddgggd�gd�gd	�ggd
���}td|�
�}|jddg�jd|��}tddgddgggd�gd�gddg��}t	tjdt
jgt
jdgdt
jgt
jdggt
j��|tddgd����}tj||�y)Nrr�one�twor3r4�rrr5r5�rr5rr5)r5rr5r)�first�second�third�r>�codesrhrr:r5r6rr
rrRrr�r7)rr
r"r!rrrrHr|rr#r$)r&r�mirnr?�expected_mir@s       r�test_unstack_level_bindingz/TestDataFrameReshape.test_unstack_level_binding6s���
��E�N�U�E�N�S�#�J�?���|�<�.�
��

�1�B������A�q�6�"�(�(���(�F�� ��E�N�U�E�N�3���.��H�%�
����H�H��R�V�V��r�v�v�q�k�A�r�v�v�;������D�B�J�J�
���3��*�7�3�
��	���f�h�/rc��|j�}t|t�sJ�|j�j}t	j
||�t
ddtjgddtjgd��}tgd��|_
|j�}tddggd�ggd	�gd
�g��}tddtjddtjg|�
�}t	j||�|j�}td�D]}|j�}�t	j
||�y)Nr5r6rCrDrEr�rFrG)rrrr5r5r5)rr5r6rr5r6�r>rr2r:)r"�
isinstancer
r%r#r$rrrHrr8rr=rr;)	r&r'rl�undor?�midxr@�old_data�_s	         r�test_unstack_to_seriesz+TestDataFrameReshape.test_unstack_to_seriesSs���"�"�$���$��'�'�'��|�|�~����
���d�K�0���1�b�f�f�~�S�!�R�V�V�4D�E�F���?�+��
��������#�J��0�%�'9�:�
���1�a�����A�r�v�v�6�d�C��
���v�x�0��9�9�;���q��	"�A��<�<�>�D�	"�
���h��-rc�j�gd�gd�gd�gd�g}t|td���}|j}tt	j
d�gdztd��	�}t
j||�|jd
dg�}|jd�}|j}tt	j
d�gdztjgd�gd
�gd���	�}t
j||�|jd
dg�}d|d<|jd�}|j}tt	j
d�gdzt	j
d�gdzztjgd�gd
�gd���	�}t
j||�d|d<|jd�}|j}|rdnt	j
d�}tt	j
d�gdz|gdzztjgd�gd
�gd���	�}t
j||�y)N)r5r5r2rD�r5r6r2rD)r6r5r2rD)r6r6r2rD�ABCDr�rjrDr:rwrx)r�r�r�r�)r5r6r5r6)Nrxr�rCr�r|r6rr��stringr)rrz�dtypesr
rrSr#r=rfr"rr)	r&�using_infer_stringr}r(r?r@rMr�rSs	         r�test_unstack_dtypesz(TestDataFrameReshape.test_unstack_dtypesns����l�L�,�G��
�t�T�&�\�
2�������2�8�8�G�,�-��1��f��F��
���v�x�0��l�l�C��:�&���k�k�#��������
�X�X�g�
��!�#��(�(�%�|�4�K��
��	���v�x�0��l�l�C��:�&����C���k�k�#��������
�X�X�i�
 �!�A�%����'�):�(;�a�(?�?��(�(�%�|�4�K��
��	���v�x�0���C���k�k�#�������.��B�H�H�X�4F���
�X�X�i�
 �!�A�%���!��3��(�(�%�|�4�K��
��	���v�x�0rzc, drQ�f8rR�
c	���tdgdz||tdd��d��}|jddjd��}|j	d	d
g�}|djd�|d<|jddj
d
�}|j	d	d
g�j
d
�}|djd�|d<|jdk(sJ�tj||�y)Nr3rQr�r�)rwr�r�rxr2T)�deeprwrxr�rjr)r�r3)r2r6)
rr�ilocrrfrir"r r#r$)r&r�r�r(�right�lefts      r�test_unstack_dtypes_mixed_datez3TestDataFrameReshape.test_unstack_dtypes_mixed_date�s�����U�Q�Y�����a�8�	
�
�������� � �d� �+��
�\�\�3��*�
%���S�'�.�.��)��3���w�w�r��{�"�"�1�%������c�
�+�3�3�A�6��!�*�-�4�4�W�=��j���z�z�V�#�#�#�
���d�E�*rc�x�tjddgddg��}tddg|��}d}tjt
|�	�5|j
d�ddd�tjt
|�	�5|jjd|�
�ddd�y#1swY�KxYw#1swYyxYw)NrY)r�r��c1r�r5r6r:z5The name c1 occurs multiple times, use a level numberr�r)	rrdrr�r�r�r"r%r!)r&rr�r(r�s     r�#test_unstack_non_unique_index_namesz8TestDataFrameReshape.test_unstack_non_unique_index_names�s����$�$�j�*�%=�d�D�\�R��
��1�v�S�
)��E��
�]�]�:�S�
1�	��J�J�t��	��]�]�:�S�
1�	8��D�D�J�J�t�,�J�7�	8�	8�	�	��	8�	8�s�B$�=B0�$B-�0B9c�`�tjdggd�g�dd}tddggdz|��}|j�}tjddggd�g�}tgd	�gdg|�
�}t	j
||�|jjd|jdk(j�sJ�gd�gd�g}gd
�gd�g}t||�}tjd�jdd�}ttj||dzg�|��}|j�}ttj|dz|dzdzgd��|��}t	j
||�|jjd|jdk(j�sJ�y)Nr3)rwrxr�r�rVr5rr2r:�rwrxr�)r5r5r5rrrr7)rr5rr�rr5r6r2r�rr6rr6rDr6��axisr�)
rr<rr"r#r$r9r>�allrrr
�concatenate)	r&r�r(r?�exp_colr@r>r�blocks	         r�test_unstack_unused_levelsz/TestDataFrameReshape.test_unstack_unused_levels�s}���%�%��u�.B�&C�D�S�b�I��
��A��x�!�|�3�
/��������)�)�A�q�6�?�*C�D���0�1�#���P��
���f�h�/����%�%�a�(�C�J�J�q�M�9�>�>�@�@�@��\�*���|�,�����'���	�	�!��$�$�Q��*��
�r�~�~�u�e�a�i�&8�9��
E���������N�N�E�A�I�u�q�y�1�}�5�A�>��
��	���f�h�/����%�%�a�(�C�J�J�q�M�9�>�>�@�@�@rz"level, idces, col_level, idx_levelr)�
�rqr�r6rQrs�r3r6r5)rsr<r5rD��r:r;c��gd�gd�g}gd�gd�g}t||�}tjd�}t|j	dd�|��}	|	j|�	�}
tjd
�tjz}|||<tjddg|g�}t|j	d
d�||��}
tj|
|
�y)N)r3r6r�)r5r2rQrr)rrVr5r5)rr6rVr6rsrDr6r:�r��rr5r2rqr7)rrrrr
r"�zerosrHr<r#r$)r&r��idces�	col_level�	idx_levelr>rr�rlr(r?�exp_data�colsr@s              r�)test_unstack_unused_levels_mixed_with_nanz>TestDataFrameReshape.test_unstack_unused_levels_mixed_with_nan�s��� ��.���
�.�����'���y�y��|��
�t�|�|�A�q�)��
5�����%��(���8�8�B�<�"�&�&�(�������&�&��A��	�':�;���X�-�-�a��3�9�d�S��
���f�h�/rrGrwc��tgd�gd�ggd���}|jgd�d��}|jtd�td�df|f}|j	�}|j
dg|}t
j|jdggdd	g�
�|_|jjd	�|_	tj||�y)N)i�r3�I)i�r4�IIr0r�F)�droprJrr�r�)
rrfrk�slicer"r(rr<r9r8�	droplevelr#r$)r&rGr(�ind�	selectionr?r@s       r�test_unstack_unused_levelz.TestDataFrameReshape.test_unstack_unused_level�s����(�*;�<�o�
V���l�l�?��l�7���G�G�U�4�[�%��+�s�;�T�A�B�	��"�"�$���8�8�Q�C�=��&��%�2�2�
�
�
��u�%�d�C�[�
���"���1�1�#�6���
���f�h�/rc	�F�tdggtjdggdg��tjgd�ggd�����}|jgd��}tdggtjgd�ggd	���t	dgd
����}tj||�y)Nr5rr-r�)rrr5rrrr5)�i1�i2�i3�i4�i5�i6�i7r�)rTrUrVrWrXrY)r-rTrUrVrWrXrYrSr�)rrrdr"rr#r$�r&r(r?r@s    r�test_unstack_long_indexz,TestDataFrameReshape.test_unstack_long_indexs�����S�E��*�*�Q�C�5���?��(�(�&�'�@��
�����@�A����S�E��*�*�&�'�@�����$�'�

��	���f�h�/rc	��tddgddggtjddgddggddg��tjgd�gd	�ggd
�����}|jdd
g�jj
dddd
gk(sJ�y)N�rxr�r�r-�c2r�)r%�r�)r%r_�(�rSrTrUr�rTrSr�)rrrdr"r9rh)r&r(s  r�test_unstack_multi_level_colsz2TestDataFrameReshape.test_unstack_multi_level_colss���
��3�Z�#�s��$��*�*��s��c�3�Z�(��t����(�(��|�,�4F��
���z�z�4��,�'�/�/�5�5�b�c�:�t�T�l�J�J�Jrc�F�tddgddgddgddggtjgd	�gd
�g�tjgd�gd�gd
�gd�ggd�����}|jddg�}|jdg�jdg�}t	j
||�y)Nr5r6r2rDrVr�������r�)r�r��f)�m1�P3��)rg�A5�o)�m2rhri)rlrjrkrar�r�rUrT)rrrdr"r#r$rZs    r�&test_unstack_multi_level_rows_and_colsz;TestDataFrameReshape.test_unstack_multi_level_rows_and_cols)s���
���V�a��V�b�"�X��B�x�0��*�*�O�_�+M�N��(�(�%�%�%�%�	�)��
�����T�4�L�)���:�:�t�f�%�-�-�t�f�5��
���f�h�/rr���jim�joe)rpro�levc�d�d�}tddtjdggd�gd�d��}|jdd	g�j	�d
}|jd	dg�j	�d
j
}t
j||�|jt|��}|j	|��}|j�jj�t|�k(sJ�d�}	|d
j�jj�\}
}t|
|�D]~\}}
t|d
j ||
fj#d
��}|	|d
j$|�|	|d
j&|
�z}tt)||��}||k(r�~J�y)Nc��||k7rdn|}|d�S�N��1���val�val_strs  r�castz:TestDataFrameReshape.test_unstack_nan_index1.<locals>.cast@����3�J�b�C�G��a�[�!rr3r4r�)rarFrGrU)za.wzb.xz .yzd.z)rorp�jolierorpr}r@c�>�t|t�rt|�S|gSr�r�tuplerz�r3s r�<lambda>z>TestDataFrameReshape.test_unstack_nan_index1.<locals>.<lambda>S���z�!�U�';�D��G��!��r�.)rrrHrfr"r%r#r$rz�notnar��sumrI�nonzero�zip�sortedr(�splitr8r9�map)r&r�rqr{r(r*r)r�udf�mk_listr}rGr�r^s              r�test_unstack_nan_index1z,TestDataFrameReshape.test_unstack_nan_index1<s���	"���S�"�&�&�#�.�+�5�
�
���|�|�U�E�N�+�3�3�5�g�>�����e�U�^�,�4�4�6�w�?�A�A��
���d�E�*�
�\�\�$�s�)�
$���j�j�s�j�#���y�y�{�!�!�%�%�'�3�r�7�2�2�2�D����\�'�'�)�0�0�8�8�:�
��d���d�O�	!�D�A�q��#�g�,�+�+�A�q�D�1�7�7��<�=�D��C��L�.�.�q�1�2�W�S��\�=Q�=Q�RS�=T�5U�U�E��3�t�U�+�,�E��5�=� �=�		!r��1st�2nd�3rdr�4th�5thc����d��tdgdztjgdzzdgdzzdgdzzdgdzzd	gdzzd
gdzdgdzztjgdzzdgd
zztjgdzzdgdzztjgdzzgd�d��}|j�fd�d��|j�fd�d��c|d<|d<|j	t|��}|j
|��}|j�jj�dt|�zk(sJ�d�}||j�jj�\}}	t||	�D]~\}
}t||j|
|fjd��}|||j |
�|||j"|�z}
tt%�|
��}
||
k(r�~J�y)Nc��||k7rdn|}|d�Srtrwrxs  rr{zATestDataFrameReshape.test_unstack_nan_index_repeats.<locals>.cast_r|rr�r2rQr3r6r�r�r4rGrarUrDrF)�C�'�5�H�9�P�rAr<r��;�2�>r��L�4�r��<�3r�c�:��djt�|��S)Nr�)�joinr���rr{s �rr�zETestDataFrameReshape.test_unstack_nan_index_repeats.<locals>.<lambda>�s���s�x�x��D�!��5�rr5r3c	�Z��djt�|jddd���S)Nr�rV)r�r�r(r�s �rr�zETestDataFrameReshape.test_unstack_nan_index_repeats.<locals>.<lambda>�s#���s�x�x��D�!�&�&��2��,�(?�@�rr�r�r@c�>�t|t�rt|�S|gSrrr�s rr�zETestDataFrameReshape.test_unstack_nan_index_repeats.<locals>.<lambda>�r�rr�)rrrH�applyrfrzr"r�r�r�rIr�r�r�r(r�r8r9r�)r&r�rqrr(rr�r�r}rGr�r^r*r)r{s              @r�test_unstack_nan_index_repeatsz3TestDataFrameReshape.test_unstack_nan_index_repeats[s#���	"���u�q�y��6�6�(�Q�,���%�!�)���%�!�)���%�!�)�	�
�%�!�)���u�q�y��%�!�)���6�6�(�Q�,���%�!�)���6�6�(�Q�,�	�
�%�!�)���6�6�(�Q�,�
��$
�&
��R
�H�H�5�A�H�>��H�H�@�q�H�I�	��5�	�2�e�9�
�\�\�$�s�)�
$���j�j�s�j�#���y�y�{�!�!�%�%�'�1�s�2�w�;�6�6�6�D����X�^�^�%�,�,�4�4�6�
��d���d�O�	!�D�A�q��#�c�(�-�-��1��-�3�3�C�8�9�D��C��H�N�N�1�-�.���S��9I�9I�!�9L�1M�M�E��3�t�U�+�,�E��5�=� �=�		!rc
�V�ttd�td�td�d��}|jddi�}tj
|jd<|jddg�jd�}d	dd
dtj
tj
tj
tj
gtj
tj
tj
tj
dd
ddgg}tttt|���}ttj
dd
ddd
ddgd��}tdgddggddgdd
ggddg��}t|||��}tj||�ttd�ttd��dztd�d��}|jddi�}tj
|jd<|jddg�jd�}dtj
gddgd
d
gtj
dgd	dgg}tdgddggddgdd
ggddg��}ttj
dd
dd	gd��}t|||��}tj||�ttd�ttd��dztd�d��}|jddi�}tj
|jd<|jddg�jd�}d	tj
gddgd
d
gddgtj
dgg}tdgddggddgdd
ggddg��}ttj
dd
dd	gd��}t|||��}tj||�y)N�aaaabbbbrsr0rxre�r2r5rwrr2r5r6rDrQrqrrr�r�r3r4rr�)r6r5)rrzr;rirrHr(rfr"r�r�rrr#r$)r&r(r*�valsr�rGr)s       r�test_unstack_nan_index2z,TestDataFrameReshape.test_unstack_nan_index2�s.��
�T�*�-�E�!�H�5��8�L�
M��
�Y�Y��W�~�
&���������
��|�|�S�#�J�'�/�/��2����1�a�������������8�
�V�V�R�V�V�R�V�V�R�V�V�Q��1�a�8�
���C��c�4�j�)�*���R�V�V�Q��1�a��A�q�1��<����E�C��:�&��1�v��1�v�.>�t�S�k�
���$��C�8��
���d�E�*�
�T�*�-�D��q��N�Q�4F�U�ST�X�V�
W��
�Y�Y��W�~�
&���������
��|�|�S�#�J�'�/�/��2���B�F�F��a��V�a��V�b�f�f�a�[�1�a�&�A����E�C��:�&��1�v��1�v�.>�t�S�k�
���R�V�V�Q��1�a�(�s�3���$��C�8��
���d�E�*�
�T�*�-�D��q��N�Q�4F�U�ST�X�V�
W��
�Y�Y��W�~�
&���������
��|�|�S�#�J�'�/�/��2���B�F�F��a��V�a��V�a��V�b�f�f�a�[�A����E�C��:�&��1�v��1�v�.>�t�S�k�
���R�V�V�Q��1�a�(�s�3���$��C�8��
���d�E�*rc	��ttd�tdd��j�dzt	j
d�d��}tj|jd<|jd	d
g�j�}t	jddd
dtjdgtjdddddgg�}tddgd	��}tdgtdd��ggd�gd�gdd
g��}t|||��}|r5|jgd�}||j|dj�||<t!j"||�y)N�
aaaaabbbbbr�rQr�r6r%r0r�rwrxr2rr5rDrqrrrsr�r3r4r�r�)rrrrrr)rVrr5r6r2rDrr�)r5r6r2rQ)rrzr�tolistrrrHr(rfr"rrrr9rirSr#r$)r&rLr(r*r�r�rGr)s        r�test_unstack_nan_index3z,TestDataFrameReshape.test_unstack_nan_index3�s+��
��,�'� ��q�9�@�@�B�Q�F��Y�Y�r�]�
�
���������
��|�|�S�#�J�'�/�/�1���x�x�!�Q��1�b�f�f�a�0�2�6�6�1�a��A�q�2I�J�K���S�#�J�S�)����E�:�l�A�>�?�%�':�;���+�
���$��C�8����=�=��.�D���+�,�,�R��W�]�]�;�E�$�K�
���d�E�*rc�*�dtjtjdgddtjdgddtjdggd�gd�gd	�g}t|gd
�gd���}|j�j	gd
��j�}tjtjdtjdgddtjdtjgg}t
ddgdggddgddggddg��}t
dggd�ggd�gd�gddg��}t|||��}tj||�|jddj�j	gd
��}tj|j�|�y)N�Hgi��(�Ur]�Pbg�	V�Z��>)�Sn��@���>��]K�=�?�)=�()�Agr]r�r�)r��a2U0*�#�r�r�)�agent�change�dosage�s_id)ioC�pCiqCirCisCitCr�)r�r�r�r�r�r�r�rr5rVr�r�rr�)r�r�r�r�r�)rrrrr�rr5r6r2rDr�r�)
rrHrrrfr"rr#r$rk)r&r�r(r*r�rGr)s       r�test_unstack_nan_index4z,TestDataFrameReshape.test_unstack_nan_index4�sk���2�6�6�2�6�6�9�-�
�#�r�v�v�y�)�
�8�R�V�V�Y�/�1�*�/�

����9�<�
���w�w�y�"�"�#>�?�G�G�I���V�V�R�V�V�X�r�v�v�s�3�
�(�B�F�F�J����7�
��
��	�*�V�H�5��q�6�B��7�#��8�$�
����J� =�>�"�O�4���/�
���$��C�8��
���d�E�*��v�v�e�f�~�"�"�$�.�.�/J�K��
���d�l�l�n�e�4rc��tgd�tddd��dtjd�ztjjd�j
d�dzjd�d	��}|d
tjd�z
|d<tjx|jd
<|jd<tjx|jd<|jd<|jgd��jd
dg�}|j�jj!�dt#|�zk(sJ�dD]A}|j%�D],\}}|d||d
|dff}|||j|k(r�,J��Cy)N)r5r6r5r6r5r6z
2014-02-01rqr�)r��freq�dr6r%)r�r�rorpr�z
2014-02-02r�)r5r�)r2r�)r5r�)rDr�r�rnr�)rrrrr�r�r��roundr�r�rHrkrfr"r�r�r�rI�iterrows)r&r(r*rrr�rms       r�test_unstack_nan_index5z,TestDataFrameReshape.test_unstack_nan_index5sc��
�)�!�,���D��R�Y�Y�q�\�)��	�	�-�-�a�0�@�@��C�b�H�O�O�PQ�R�	
�
���u�I����\� :�:��5�	�.0�f�f�4����x��2�6�6�(�+�.0�f�f�4����x��2�6�6�(�+��|�|�1�2�:�:�E�5�>�J���z�z�|�"�"�&�&�(�A��B��K�7�7�7�!�	/�C����
�
/���1���h��a��h��%�� 9�9����v����#��.�.�.�
/�	/rc��tddd�}tgd�tj|ddfg���}|rdnt}d}tj||��5|j|�	�}ddd�tjd
dg�}tj|dfg�}tgd�||��}	tj|	�y#1swY�_xYw)
Ni�r5rrwrxr�z2The previous implementation of stack is deprecatedr�rr1)rxr7)
rrrrd�
FutureWarningr#�assert_produces_warningr!r<r$)
r&r�tr(�warnr�r?�eidx�ecolsr@s
          r�%test_stack_datetime_column_multiIndexz:TestDataFrameReshape.test_stack_datetime_column_multiIndex(s����T�1�a� ��
�|�Z�-C�-C�a��c�]�O�-T�
U��#�t���B��
�
'�
'��C�
8�	9��X�X�<�X�8�F�	9��&�&��f�'=�>���&�&��C��z�2���\��u�E��
���f�h�/�
	9�	9�s�C�C�multiindex_columnsr�r1)rr5r6rDr`r�)r6r2rD)rDr2r6r5r)r2r6r5r)rDr6r5r)r6r5r)r2r6r5)rDr2r6r�rVc��|sdntj}tjgd�ddg��}||}t	tjdt|�z�jdt|��|��}|j|||��}t|t�rS|sQ|j|d	|��}	t|	t�rtj||	�ntj||	�tj|j j#�|j j$��|_|j|||��}	t|	t�rtj||	�ytj||	�y)
NF�)rxrF)rxrU)rwrG)r�rF)r��u�Upper�Lowerr�r2r�)r��dropnarT)r�
no_defaultrrdrrrrIr
r!r�intr
r#r=r$r9�to_numpyrh)
r&r�r�rr��full_multiindex�
multiindexr(r?r@s
          r�test_stack_partial_multiIndexz2TestDataFrameReshape.test_stack_partial_multiIndex6s=��@+������$�0�0�H��G�$�
��%�%7�8�
�
��I�I�a�#�j�/�)�*�2�2�1�c�*�o�F��
������f�<��P���e�S�!�,��x�x�e�D�|�x�T�H��(�F�+��&�&�v�x�8��%�%�f�h�7��+�+��J�J���!����)9�)9�
��
��8�8�%��\�8�R���h��'��"�"�6�8�4��!�!�&�(�3rc	�4�tjgd�ddg��}ttjd�jdd�|gd��	�}|sd
ntj}|j||��}tddgd
tjgddgdtjggtdd
ggd�ggd�gd�gddg��tddgd����}|dj|jjd�|d<tj||�y)Nr�r�r�r�rqr6r2)rr5r2r�F�r�rrr5rQrD)r�rFrGrUr)r5r2r5r2rrxr�r�r7)rrdrrrr
rr�r!rHrrir!r(r#r$)r&rr�r(r�r?r@s       r�test_stack_full_multiIndexz/TestDataFrameReshape.test_stack_full_multiIndexus���
%�0�0�H��G�$�
���r�y�y��|�+�+�A�q�1�?�9�;U�
V��*����������l��C�����V�a����[�1�a�&�1�b�f�f�+�6���A�� 4�5�#�\�2��W�o��
�3��*�7�3�
��!��
�,�,�R�Y�Y�^�^�A�->�?���
�
���f�h�/r�orderedFTc�(�tjtd�td�|��}tgd�g|��}|j	|��}tj|j|g�}tgd�|��}tj||�y)N�yxzru�r�r�)r%r<r=r�rr:)r��CategoricalIndexrzrr!rr<r8r
r#r=)r&r�r�cidxr(r?rr@s        r�%test_stack_preserve_categorical_dtypez:TestDataFrameReshape.test_stack_preserve_categorical_dtype�sv���"�"�4��;�4��;�PW�X��
��~�t�
4�����|��4���&�&����$�'7�8���,�d�3��
���v�x�0rzlabels,dataru)r%r<r=r:r�r>�zyx)r�r>r=r:r%r<c���tj|t|�|��}tjddg|��}tj||g�}tt|�g|��}|j
ddg|��}	|r|n
t|�}tj||��}
|rt|�n|}t|tjdg|
|g��	�}tj|	|�y)
Nr�r��v)r�r�rr5rr:)
r�r�r�rr<rr!r
r#r=)
r&r��labelsrlrr��cidx2rr(r?�s_cidx�
expected_datar@s
             r�+test_stack_multi_preserve_categorical_dtypez@TestDataFrameReshape.test_stack_multi_preserve_categorical_dtype�s����"�"�6�f�V�n�g�V���#�#�S�#�J��@���&�&��e�}�5��
��t��~�t�
4�����1�a�&�|��<��'��V�F�^���$�$�V�W�=��(4��t��$�
����!8�!8�1�#�v�u�9M�!N�
��	���v�x�0rc��tjgd��}t||d��}|j|��}t	j
gd�ddgg�}t
tjgd��|��}tj||�y)	N)r3r3r4r��rwrxrr1rwrx)r3r3r3r3r4r4r�r�r:)	r�r�rr!rr<r
r#r=)r&rr�r(r?r8r@s       r�,test_stack_preserve_categorical_dtype_valueszATestDataFrameReshape.test_stack_preserve_categorical_dtype_values�st���n�n�1�2��
�S�s�+�
,�����|��4���'�'���S�z�(B�C����N�N�C�D�E�
��	���v�x�0rz4ignore:Downcasting object dtype arrays:FutureWarningzindex, columnsrr4)rrr6r2c���t||��jd�}|j|��}tj|j
j
��}t|j
�||j��}tj||�tj|j
j�}tj|j�}	tj||	�y)Nr7r5r)r�fillnar!rrdr8r�r9r#r$r�asarrayr�assert_numpy_array_equal)
r&r8r9rr(r)�	new_indexr@�
stacked_codes�expected_codess
          r�)test_stack_multi_columns_non_unique_indexz>TestDataFrameReshape.test_stack_multi_columns_non_unique_index�s����U�G�
4�
;�
;�A�
>���(�(��(�5���*�*�7�=�=�+A�+A�+C�D�	������i����
��	���g�x�0��
�
�7�=�=�#6�#6�7�
����I�O�O�4��
�#�#�M�>�Brz,vals1, vals2, dtype1, dtype2, expected_dtyperCr��Int64�Float64rrr rc��tt||��t||��d��}|j|��}|jt�j|��j|�}	tj||	�y)NrR)�rwr5)rwr6r)rr
r!rirr#r$)
r&�vals1�vals2�dtype1�dtype2�expected_dtyperr(r?r@s
          r�.test_stack_multi_columns_mixed_extension_typeszCTestDataFrameReshape.test_stack_multi_columns_mixed_extension_types�su��� ��f�5� ��f�5�
�
�����|��4���I�I�f��#�#��#�>�E�E�n�U�	�	���f�h�/rc���tjgd�ddg��}ttjgd�d��tj
gd��d	�|�
�}|j
|��}|jt�j
|��}|dk(r&|d	jtj�|d	<n%|d
jtj�|d
<t|jjgdz|jjgdzz|j�
�}t!j"|j$|�t!j&|jt�|�y)N)�rwrr)rxr5r3r4r�)rr5NrrRr]r�r:r@rrr6)rrdrr�rr�r"rirr��NAr
rwrSrxr9r#r=r!r$)r&r�r8r(r?r@�expected_dtypess       r�"test_unstack_mixed_extension_typesz7TestDataFrameReshape.test_unstack_mixed_extension_types�s���&�&�'E�c�SV�Z�X��
��X�X�l�'�:��^�^�O�4�
��
�����%��(���9�9�V�$�,�,�5�,�9���A�:�#+�J�#7�#>�#>�r�u�u�#E�H�Z� �!)�(�!3�!:�!:�2�5�5�!A�H�X�� �
�T�T�Z�Z�L�1�����
�
�|�a�/�/�v�~�~�
��	���v�}�}�o�>�
���f�m�m�F�3�X�>r�bazc��tjdgddggddg��}tddgdd	gg|d
dg��}d
|j_tgd�gtj
gd�dd
g����}d|j_|j�jd��jd|��}tj||�y)Nrr�r�rrr�r6r5r2rxrwr7r)r2r5r6r))r�rw)r�rx)r�rw)r�rxr�r3)r4r�)rr<rr9rbrdr8r"�	swaplevel�
sort_indexr#r$)r&r�rr(r@r?s      r� test_unstack_swaplevel_sortlevelz5TestDataFrameReshape.test_unstack_swaplevel_sortlevels����
$�
$�q�c�C��:�%6�u�e�n�
M��
��A���A��'�r�C��:�
F����
�
���
�N��*�*�@��PU���
��$���������'�'�Q�'�/�:�:���:�O��
���f�h�/r)?�__name__�
__module__�__qualname__r/r��mark�filterwarningsrArOror~r�r�r�r�r��parametrizerrdrr�r�r�r�r�rrrr#rrBrr+r.r9rHrHrMrQr[rbrmrzr;r�r��permutationsr�r�r�r�r�r�r�r�r�r�r�r<r�r	rrrwrrrrs8��>�$�[�[���C��0��0�.
.��[�[���C��,0��,0�\"0�H0�,0�,0�< 0�D0�2�[�[���H���|�\�<�H�&�
�&�&�4�S�#�J��'�
�&�&�D���,��

�"�)�+C�D��q�!�f�3�'�&�
�&�&�	�2��	
�	
�!�D
0�E!�D
0�((�T�[�[���C��
��
�<�[�[���C��6
��6
�p�[�[���C��;
��;
�z&��[�[���C��0��0�4.�6+1�Z�[�[����
�R�X�X�a�[�(�"�(�(�1�+�&�
�R�Y�Y�q��
%�y�r�y�y��B�d�'C�D�	
��+��+�.�[�[���C��8��8�A�0�[�[���,�
�+�b�f�f�c�1�-=�����1�~�N�
�-�����1�~�����Q�?O�P�	
��0��0�"�[�[���V�s�C�j�%��+�%>�?�
0�@�
0�0�,K�0�&�[�[���U�^�^�$D�E��[�[���U�D��q��N�3�!�4�F�!�:�[�[���U�$:�I�$:�$:�;P�$Q�R��[�[���U�D��q��N�3��[�[���U�U�E�N�3�;!�4�4�S�;!�z/+�b+�8'5�R/�.0��[�[���C���[�[����������
��F�
��F�
��F�
�C�
�C�
�C�������
��F�
��F�
��F�+	
��4�[�[���W�r�1�a�!�Q��!�Q��&@�A�4�B�5��<4�B�[�[���C��0��0�*�[�[���Y���
�6�1�7�1��[�[���C���[�[���Y���
�6��[�[����
�%�[�2�3�
�%�[�2�3�	
��1��7��1�&	1��[�[���C���[�[��� V�W��[�[����
�2�:�2�2�Q��F�S�#�J�3G�H�I�
�2�:�2�2�Q��F�S�#�J�3G�H�I�
�2�:�2�2�Q��F�S�#�J�3G�H�I�	
��C��X��C��[�[���C���[�[���6���V�c�3�Z��)�Y�?���V�e�U�^�W�h��A�	
��0���0� �[�[���W�q�!�f�-�?�.�?�.�[�[���W�q�%�j�1�0�2�0rrrSr|rc���tjgd��}|tjdd�||��}|j	dd��}|t
urtjdd	g�}nd
dg}tdtjgtjdgd
tjgtjdgg|tjgd��|��}tj||�|j	ddgd��}|t
urtjddg�}ntjddg�}tddgd
dggddg||��}tj||�y)N))r
rUr4)r
rGr3)r	rUr4)r	rGr3r�r�r[rVF)r��sort�rr4)rr3r4r3�@rCr�))r
rU)r
rG)r	rU)r	rG�r9r8rSr5r6)rrUr4)rrGr3)rUr4)rGr3r
r	)r8r9rS)	rrdrrr"rrHr#r$)�frame_or_seriesrSr8�objr?r�r@s       r�test_unstack_sort_falser"#sP��
�"�"�T�
�E��"�)�)�C��-�U�%�
H�C�
�[�[�r��[�
.�F��)�#�%�1�1�8�X�2F�G����:���

�r�v�v������
��R�V�V�}�r�v�v�s�m�D� ��$�$�D�
��
�H����&�(�+�
�[�[��1�v�E�[�
2�F��)�#�%�1�1�=�-�2P�Q��%�1�1�:�z�2J�K���

�s��c�3�Z� ��e�n� ��	�H����&�(�+rc��tgd�d��}tjgd��|_|j	�}tdtjdgddtjgd�td	�t�
�}tj||�|j	d��}tgd
�gd�d�td	�t�
�}tj||�y)Nr�rrRrTr3r4r�rYrur[r�rW)r3r�r3)r4r�r�)r
rrdr8r"rrrHrzrr#r$)rlr?r@s   r�test_unstack_fill_frame_objectr$Is����&�h�7�D��'�'�8��D�J�
�\�\�^�F���B�F�F�C� ��S�"�&�&�'9�:��5�k���H�
���&�(�+��\�\�S�\�
)�F���O�4�D��K�v��H����&�(�+rc
�b�ttjdd��gdgdgdgd�gd���}|jddg�j	�}ttjdd��dggtdgd�	�t
d
dgdggddgddggddg�
���}tj||�y)Nz2017-08-27 01:00:00.709949+0000�UTC)�tzr3r4r�)�	timestampr3r4r�r�r�r(rr5rr7)	rr�r�rfr"rrr#r$)r(r?r@s   r�"test_unstack_timezone_aware_valuesr)as���	��,�,�'H�U�S�T�������		
�-�
�B��\�\�3��*�
%�
-�
-�
/�F��
�,�,�8�U�
C�S�	I�J��S�E��$�� �#�&���.��q�6�A�q�6�"���+�
��H����&�(�+rc	���tdddd��}td|igd���}|j|�	�}t|t	gd�dgggd
�gd�g����}tj||�y)
Nr��20180101�20180103zAmerica/New_York)r��start�endr'rwr�r:rr`�rrrr)rrr!r
rr#r=)r�tsr(r?r@s     r� test_stack_timezone_aware_valuesr1ysh��	��J�J�CU�	V�B�	�C��9�O�	4�B�
�X�X�<�X�
0�F��
���3�%� 8��I�@V�W��H����6�8�,rr0r�c�J�tjgtj��tjgtj��g}ttjt|ggg����}|rb|tjurPtjtd��5ttj��j||��ddd�yttj��j||��}tj||�y#1swYyxYw)NrRr)rSr8�dropna must be unspecifiedr�r�)rrrjr
r|rrr�r�r�r�rr!r#r=)r�rr>r@r?s     r�test_stack_empty_framer4�s����h�h�r����*�B�H�H�R�r�x�x�,H�
I�F��B�J�J�j��r�SU�h�.W�X�H���c�n�n�4�
�]�]�:�-I�
J�	X��B�J�J�'�-�-�V�,�-�W�	X�	X�����,�2�2���3�
��	���v�x�0�
	X�	X�s�",D�D"rXc���|rr|tjur`tjtd��5ttj��j||��j|��ddd�yttj��j||��j|��}ttj��}tj||�y#1swYyxYw)Nr3r�rRr�rW)rr�r�r�r�rrrjr!r"r#r$)r�rXrr?r@s     r�test_stack_unstack_empty_framer6�s���
��c�n�n�4�
�]�]�:�-I�
J�	-��B�H�H�%�+�+��L�
,�
��g��g�,�	-�	-�
�B�H�H�%�
�U�&�|�U�
<�
�W�
�W�
+�	�
�2�8�8�,��
���f�h�/�	-�	-�s�<C!�!C*c��d}tjt|��5ttj
��j
�ddd�y#1swYyxYw)Nz'index must be a MultiIndex to unstack.*r�rR)r�r�r�r
rrjr")r�s r� test_unstack_single_index_seriesr8�s?��
4�C�	���z��	-�)��R�X�X��&�&�(�)�)�)�s�)A�Ac	��tddgddgddgddgdd	gd
��}|jgd��}|jdgd�
�}|jdd�
�jdd�
�}|jddgd�
�}tgd�gd�gtddgd��t	j
gd�gd�����}t
j||�y)N�Alice�Bob�#@rsFTr�female�male)rb�score�employed�kids�gender)rbr@rArBrBrWr@rA)r<r]r]r])r]r]r]g @rbr�))r?r=Fr)r?r=Tr)r?r>Fr)r?r>Tr)NrBr@rAr�r7)rrfr"rrrdr#r$)r(r@r?s   r�test_unstacking_multi_index_dfrC�s���	��e�$��1�X���
���F���(�	
�
�B�
���<�	=�B�	���X�J�1��	-�B��z�z�*��z�3�;�;�F�q�;�Q�H�
�Z�Z��V�,��Z�
;�F��	�3�4��W�e�$�6�2��&�&�
�7�
��H����&�(�+rc�(�tjddgddg��}tgd�g|��}|jd|��}t	d	d
gd��}tj
dd
gddg��}tddgddgg||��}t
j||�y)NrE)rGrUr3r��r5r5r5r5r�rrrGrUr�)rrF)rrGr5r7)rr<rr!rrdr#r$)rr9r(r?�new_columnsr�r@s       r�2test_stack_positional_level_duplicate_column_namesrG�s����%�%�z�:�&>�s�C�j�Q�G�	�L�>�7�	3�B�
�X�X�a�l�X�
3�F���c�
��-�K��&�&��(�';�D�#�;�O�I��1�a�&�1�a�&�)��K�P�H����&�(�+rc�B�tjtd�gd�g�}ttj
j
d�jd�tj
j
d�jd�jtj�tj
j
d�jd�tj
j
d�jd�d�|��}|s(td�|jjD��sJ�|j�}tjtd�D�cgc]}||j���c}td�d	�
�}t!j"||�ycc}w)NrQr0r6r>r1r:c3�JK�|]}|jj���y�wr)�mgr_locs�
is_slice_like)�.0rFs  r�	<genexpr>z5test_unstack_non_slice_like_blocks.<locals>.<genexpr>�s����H�A�q�z�z�/�/�/�H�s�!#rDr5)�keysr4)rr<r;rrr�r�r�rirj�anyrJrKr"r��concatr#r$)rLrr(rN�nr@s      r�"test_unstack_non_slice_like_blocksrR�s%��
�	 �	 �%��(�O�!<�	=�B�	��y�y�$�$�Q�'�7�7��;��y�y�$�$�Q�'�7�7��;�B�B�2�8�8�L��y�y�$�$�Q�'�7�7��;��y�y�$�$�Q�'�7�7��;�		
��
�B���H������H�H�H�H�
�*�*�,�C��y�y�5��8�<�a�"�Q�%�-�-�/�<�5��8�RS�T�H����#�x�(��=s�Fc	��gd�gd�ddtjtjgg}t|tddgddgggd	�gd
�g����}|rind
di}|jd d|d�|��}|rRtdddddtjgdddddtjgd�tj
gd�gd�g���}n-tgd�gd�d�tj
gd�gd�g���}t
j||�t|tj
gd�gd�g���}|rind
di}|jd d|d�|��}t
j||�y)!N)r5r6rCr�)r6r2r�r�r2rDrxrwrFrGrrrr�rFrr�r�rCrr�r�rE)rrr5r5r6r6)rxrwrxrwrxrwr:)r�rCrr�rC)rr�rCr�r�)rrr5r5r6)rxrwrxrwrx)rxrxrwrw)rFrGrFrGrw)rrHrrr!rr#r$)rrlr(�kwargsr?r@s      r�test_stack_sort_falserU�sb��
�.��A�r�v�v�r�v�v�0F�G�D�	����#�J��c�
�+�L�,�3O�
�
�B� �R�f�e�_�F�
�R�X�X�
C�A�L�
C�F�
C�F����3��S�#�r�v�v�6��3��S�#�r�v�v�6�
��(�(�#�%C�D��
���+�2K�L��(�(�/�;T�)U�V�
�����&�(�+�
���&�&�(<�>R�'S�T�
�B� �R�f�e�_�F�
�R�X�X�
C�A�L�
C�F�
C�F����&�(�+rc��tjddg�}tddgddggddg|�	�}|rind
di}|jdd
gfd|i|��}tjgd��}t	gd�|��}tj||�y)N)�weight�kg)�height�mr�rrCr�r�r�r7rFrr5r))r�rWrX)r�rYrZ)r�rWrX)r�rYrZ)r�rrCr�r:)rrdrr!r
r#r=)rr�r(rTr?r�r@s       r�!test_stack_sort_false_multi_levelr[s����
 �
 �"2�O�!D�
E�C�	�S�#�J��c�
�+�E�5�>�3�	O�B��R�f�e�_�F�
�R�X�X�q�!�f�
B�<�
B�6�
B�F��+�+�	
��N��*�.�A�H����6�8�,rc�	�eZdZd�Zej
j
dgd�gd�ggd�dgd�fgd�gd	�ggd
�dgd�fgd�gd�ggd
�d
gd�fg�d��Zd�Zej
jd�d��Z
ej
j
ded�gd�eddgddgge
je
jd�j!d�d�e
jgd�d�g��gej"d�gd�eddgddgddgge
je
jd�j!d�d�e
j gd�gd ��e
jgd�d�g��gg�d!��Zej
jd�d"��Zej
jd�d#��Zd$�Zej
jd�d%��Zej
j
d&d'd(g�d)��Zd*�Zej
jd�d+��Zej
jd�d,��Zej
jd�d-��Zej
jd�d.��Zd/�Zd0�Zej
jd�d1��Zej
jd�d2��Z d3�Z!d4�Z"ej
jd�d5��Z#ej
jHd6��Z%ej
jd�ej
j
d7e&jNjQd8�d9D���ej
j
d:e)d��ej
j
d;d<d=g�d>�����Z*ej
jd�d?��Z+ej
jd�d@��Z,ej
jd�dA��Z-dB�Z.dC�Z/dD�Z0dE�Z1ej
jd�dF��Z2ej
jd�dG��Z3ej
jd�dH��Z4dI�Z5ej
jd�dJ��Z6ej
jd�dK��Z7dL�Z8y
)M�TestStackUnstackMultiLevelc���|}|j�}|j�|jt�j�|jtj�j�yr)r"rir�rr{)r&�/multiindex_year_month_day_dataframe_random_data�ymdr+s    r�test_unstackz'TestStackUnstackMultiLevel.test_unstack.sO��=���K�K�M�	�����	�
�
�3����!�	�
�
�2�8�8��$�$�&rz5result_rows,result_columns,index_product,expected_row)r5r5NN�>@N)r6r6NNrbN)�ix1�ix2�col1�col2�col3�col4r6)NNrbN)r5r5NNrb)r6r6NNrb)rcrdrerfrg)NNrb)r6NNNrbNc��t||��jddg�}|jddjd�}t|gt	j
|dd|ggddg��t
dgd����}tj||�y)	Nr�rcrdr5r6r�r�r�)	rrfr(r"rr<rr#r$)r&�result_rows�result_columns�
index_product�expected_rowr?r@s       r�test_unstack_partialz/TestStackUnstackMultiLevel.test_unstack_partial;s���<�;��?�I�I�
�E�N�
�����Q�q�!�)�)�%�0���
�N��+�+����#�m�_�5�d�E�]�����%�(�
��	���f�h�/rc��tjgd��}ttjjd�j
d�|��}|jddg�}|jdd��}tj||�y)N))rrr)rrr)r5rr5)r5�quxr5r6rDr:r5r5�r4�how)rrdr
rr�r�r�r"r�r#r$)r&r8rnr+r@s     r�&test_unstack_multiple_no_empty_columnszATestStackUnstackMultiLevel.test_unstack_multiple_no_empty_columnsfst���&�&�H�
��
�2�9�9�(�(��+�;�;�A�>�e�L���I�I�q�!�f�%�	��#�#���#�6��
���i��2rr0c��|}|j�}|j|��}|r|jd��}tj||�|jd��}|jd�}|j|��}|r|jd��}tj|jd��|�|ddd�}|jd�}|j|��j
dd�}|r|jd��}tj|jd��|�|j
dd�}|jd�j
ddd�	�}|jd|��j
dd�}|r|jd��}tj|jd��|�|j�}|j|��}|r|jd��}tj||�|jd�jd�}|jd|��}|j�}tj||�|jd|��}|jd�}tj||�|jd|��}|j|��jd�jd�}tj||�|jd�jdd�ddd
�f}|j|��j|��}	|j|��}
|r$|	jd��}	|
jd��}
tj|	|
j|	j��|jd�jd|��}|jd�jd|��}tj||�y)Nrr5�rrr6r@rrVr5r3r2r�)r"r!r�r#r$rrrkr=�reindexr8�assert_equal)r&r_rr`r+�	restacked�unlexsortedr?r@r)�ymd_stackeds           r�
test_stackz%TestStackUnstackMultiLevel.test_stackqs���>���K�K�M�	��O�O��O�>�	��!�(�(�U�(�3�I�
���i��-��n�n�1�n�-���'�'��*�	��O�O��O�>�	��!�(�(�U�(�3�I�
���i�2�2��2�;�S�A�!�$�B�$�'���'�'��*�	��O�O��O�>�H�H��A�N�	��!�(�(�U�(�3�I�
���i�2�2��2�;�S�A�!�+�+�A�q�1���'�'��*�4�4�Q���4�B�	��O�O�A�L�O�A�K�K�A�q�Q�	��!�(�(�U�(�3�I�
���i�2�2��2�;�S�A��K�K�M�	��O�O��O�>�	��!�(�(�U�(�3�I�
���i��-��K�K��N�*�*�1�-�	�������>���;�;�=��
���f�h�/�������>���;�;�q�>��
���f�h�/�������>���9�9�,�9�7�?�?��B�J�J�1�M��
���f�h�/��K�K��N�&�&�q�#�A�#�v�.�	��/�/�|�/�<�B�B�%�C�
���i�i�\�i�:����n�n��n�/�G�%�,�,��,�7�K�
���w��(;�(;�G�M�M�(J�K����Q��%�%�b�|�%�D���;�;�q�>�'�'���'�E��
�����)rzidx, columns, exp_idx�abab)r�r�r�r3r4r�r�r2)rr5rrDr)�r3r6�r4r5�r3r5)r4r6r5)r5rr5)r2rqr2c��ttjd�jdd�||��}|r9d}t	j
t|��5|j|��ddd�y|j|��}ttjd�|��}tj||�|jjd	usJ�|j|j}
}	tj|	|
�y#1swYyxYw)
Nr=rDr2r7z8Columns with duplicate values are not supported in stackr�rr:F)rrrr
r�r�r�r!r
r#r=r8�	is_unique�assert_index_equal)r&r�r9�exp_idxrr(r�r?r@�li�ris           r�test_stack_duplicate_indexz5TestStackUnstackMultiLevel.test_stack_duplicate_index�s���6��I�I�b�M�!�!�!�Q�'���
��
�L�C����z��5�
4����l��3�
4�
4��X�X�<�X�8�F��b�i�i��m�7�;�H��"�"�6�8�4��<�<�)�)�U�2�2�2��\�\�8�>�>��B��!�!�"�b�)�
4�
4�s�C>�>Dc���tjdgdzdgdzzdgdzzdgdzzdgdzd	gdzzdgd
zzd	gdzzddgdzgd
�zggd���}ttjdd��tjdd��d�|��}|jd�}|j
|��}|r|jd��}tj||�y)N�FrirD�Satr6�Sun�Thur2�Dinner�LunchrQ�No�Yes)r�r�r�)�day�time�smokerr�r<r|rR)r�rIr:rr5ru)
rrrrrr"r!r�r#r$)r&rrr(r?�reconss      r�test_unstack_odd_failurez3TestStackUnstackMultiLevel.test_unstack_odd_failure�s����
#�
#���!��u�g��k�)�U�G�a�K�7�5�'�A�+�E��
�Q��'��Q��.�(��a��?�7�)�a�-�O��u�
��!�$7�7�
�
,�

����y�y��9�5��y�y��9�5�
��
�����A������<��8����]�]�u�]�-�F�
���f�b�)rc�P�|}|j}d|d<|jdd��}|j|��}|dj|��j�}tj|d|d��|j
�J�|djtjk(sJ�y)	Nr)r�fourr5)r�r4rFr�r)	r%rr!r#r=rbrSrr|)r&� multiindex_dataframe_random_datar�framer(r)r?s       r�test_stack_mixed_dtypez1TestStackUnstackMultiLevel.test_stack_mixed_dtypes���1��
�W�W��!��=��
�]�]���]�
+���(�(��(�5���E����l��;�F�F�H��
���w�u�~�v�5�I��{�{�"�"�"��u�~�#�#�r�z�z�1�1�1rc	���tgd�gd�gd�gd�tjd�d��}d}tjt
|��5|j
gd	��jt�}ddd�j�}|j|�
�}tj||j|j�jt��y#1swY�nxYw)N)�naiver�r��activer�r�)r3r4r4r4r3r3)r5r6r2rDr5r2)�hir��byer�r��peaceg@)r�r��barcoder��extraz7DataFrameGroupBy.apply operated on the grouping columnsr�)r�r�r�r�r)rrrr#r��DeprecationWarning�groupbyr�rIr"r!r=rvr8rire)r&rr(r�r?r+rxs       r�test_unstack_bugz+TestStackUnstackMultiLevel.test_unstack_bugs���
�R�5�-�?����3��
�
��H��
�
'�
'�(:�#�
F�	M��Z�Z� @�A�G�G��L�F�	M��N�N�$�	��O�O��O�>�	�
���y�&�.�.����*I�*P�*P�QV�*W�X�	M�	M�s�
'C�C'c��|}|j�}|jjdk(sJ�|jjddgk(sJ�|j|��}|jj|jjk(sJ�y)Nr
r�rr)r"r8rbr9rhr!)r&r�rr�r+rxs      r�!test_stack_unstack_preserve_namesz<TestStackUnstackMultiLevel.test_stack_unstack_preserve_names+s}��1���M�M�O�	����#�#�w�.�.�.�� � �&�&�5�(�*;�;�;�;��O�O��O�>�	����$�$����(9�(9�9�9�9r�methodr!r"c�v�|}|jd}|dk(rd|ini}tjtd��5t	||�di|��ddd�|dk(rJ|j
dd�df}tjtd��5t	||�di|��ddd�yy#1swY�YxYw#1swYyxYw)	Nrr!rzdoes not match index namer�r"r)�mistake)rkr�r��KeyError�getattrr()r&r�r�rr�r(rTrns        r�#test_stack_unstack_wrong_level_namez>TestStackUnstackMultiLevel.test_stack_unstack_wrong_level_name:s���
1���Y�Y�u�
��39�W�3D�.�,�/�"��
�]�]�8�+F�
G�	5��G�B���4�V�4�	5��Y������1��
�A����x�/J�K�
8�"���6�"�7��7�
8�
8��	5�	5��
8�
8�s�B#�B/�#B,�/B8c�z�|}|jd�}|jd��}tj||�y)Nrr5r@r�)r&r�r�r?r@s     r�test_unstack_level_namez2TestStackUnstackMultiLevel.test_unstack_level_nameNs5��0�����x�(���=�=�q�=�)��
���f�h�/rc�4�|}|jd�}|jd|��}|j�jd|��}tj||�|jd|��}|j|��}tj||�y)Nrr�rr)r"r!r#r$r=)r&r�rr�r+r?r@s       r�test_stack_level_namez0TestStackUnstackMultiLevel.test_stack_level_nameUs���1���M�M�(�+�	�����\��B���=�=�?�(�(���(�F��
���f�h�/����U���>���;�;�L�;�9��
���v�x�0rc�<�|}|jddg�}|jd�jd�}tj||�|jj|jjk(sJ�|d}|jddg�}tj||d�|jddg|��}|r|j
d��}|jdd�jdd	�}|jd�
�}tj||�|jj|jjk(sJ�|jdd	g�}|jd�jd�j
dd��}tj||�|jd	dg�}|jd	�jd�j
dd��}tj||jdd�|jf�y)N�year�monthrwrr5rurr5r6r@rq)r"r#r$r9rhr!r�rrr8rk)	r&r_rr`r+r@rn�s_unstackedrxs	         r�test_stack_unstack_multiplez6TestStackUnstackMultiLevel.test_stack_unstack_multipleds���>���K�K��� 1�2�	��;�;�v�&�.�.�w�7��
���i��2�� � �&�&�(�*:�*:�*@�*@�@�@�@�
��H���i�i��� 1�2��
���k�8�C�=�9��O�O�V�W�$5�L�O�Q�	��!�(�(�U�(�3�I��'�'��1�-�7�7��1�=�	��(�(�q�(�1�	�
���i��-����$�$��	�	���7�7�7��K�K��A��'�	��;�;�q�>�)�)�!�,�3�3���3�F��
���i��2��K�K��A��'�	��;�;�q�>�)�)�!�,�3�3���3�F��
���i����a��9J�9J�6J�)K�Lrc��|}|jddg�}tjtd��5|j	ddg|��ddd�y#1swYyxYw)Nr�r�zlevel should containr�rr)r"r�r�r�r!�r&r_rr`r+s     r�test_stack_names_and_numbersz7TestStackUnstackMultiLevel.test_stack_names_and_numbers�sZ��>���K�K��� 1�2�	��]�]�:�-C�
D�	E��O�O�Q��L�|�O�D�	E�	E�	E�s�A�Ac�B�|}|jddg�}tjtd��5|j	ddg|��ddd�tjtd��5|j	d	d
g|��ddd�y#1swY�CxYw#1swYyxYw)Nr�r�zToo many levelsr�r6r2rznot a valid level numberrerd)r"r�r��
IndexErrorr!r�s     r�!test_stack_multiple_out_of_boundsz<TestStackUnstackMultiLevel.test_stack_multiple_out_of_bounds�s���>���K�K��� 1�2�	�
�]�]�:�->�
?�	?��O�O�Q��F��O�>�	?�
�]�]�:�-G�
H�	A��O�O�R��H�<�O�@�	A�	A�	?�	?��	A�	A�s�B	�*B�	B�Bc
���tjgd�dd��}tddgdzd�	�}gd
�}tj||g�}t||��}|j
�}|j
d�
�}|j
d�
�}tjgd�dd��}	tgd�gd�d�|	ddg��}
d|
j_	tj||
�tj||
�tj||
j�tjgd�dd��}tjgd�dd��}tj||g�}t||��}|j
�}|j
d�
�}|j
d�
�}tjgd�dd��}	tjgd�dd��}ttjtjtjtjddgtjtjddtjtjgddtjtjtjtjgg|	|��}
tj||
�tj||
�tj||
j�y)N)�2013-01r��2013-02r��2013-03r��M�period�r�rbrwrxr2�strr��r5r6r2rDrQrqr:r5r@r)r�r�r�)r5r2rQ)r6rDrqr�r7�period1)�2013-12�2013-11�2013-10�2013-09�2013-08�2013-07�period2)r�r�r�r�r�r�r6rDrqrQ)r��PeriodIndexrrrr
r"rr9rbr#r$r%rrH)r&�idx1�idx2�valuer�rn�result1�result2�result3�e_idxr@�e_colss            r�test_unstack_period_seriesz5TestStackUnstackMultiLevel.test_unstack_period_series�sN���~�~�N���
��
�c�3�Z�!�^�%�0��"���$�$�d�D�\�2���5��$���)�)�+���)�)�!�)�$���)�)�!�)�$�����-�C�h�
����)�,�E�C��:�
��!&�����
���g�x�0�
���g�x�0�
���g�x�z�z�2��~�~�N���
���~�~�N���
��
�$�$�d�D�\�2���5��$���)�)�+���)�)�!�)�$���)�)�!�)�$�����-�C�i�
�����N���
��
��������������A�6��������A�r�v�v�r�v�v�6��A�r�v�v�r�v�v�r�v�v�r�v�v�6�
�
��
��	���g�x�0�
���g�x�0�
���g�x�z�z�2rc�l�tjgd�dd��}tjgd�dd��}gd�gd�d	�}tj||g�}t	||�
�}|j�}|jd��}|jd
��}tjddgdd��}	tjgd�dd��}
tjdj
�|
g�}t	gd�gd�g|	|��}tj||�tj||�tjgd�dd��}	tjgd�dd��}
tjdj
�|	g�}t	gd�gd�gd�g|
|��}tj||�y)N)�2014-01�2014-02r�r�r�r�r�r�r�)r�r�r�r�r�r�r�r�)rqrQrDr2r6r5r�r:r5r@rr�r�)r�r�r�r�r�r�zA A A B B B)rQr5rqr6rqr5)rDr6r2r2rQrDr7)r�r�r�r�)r�r�r�zA A B B)rQrDr6r2)r5r6rqrQ)rqr2r5rD)	r�r�rrrr"r�r#r$)
r&r�r�r�r�r(r�r�r��e_1�e_2r�r@s
             r�test_unstack_period_framez4TestStackUnstackMultiLevel.test_unstack_period_frame�s����~�~�N���
��
�~�~�N���
��
)�/A�B���$�$�d�D�\�2��
�u�C�
(���*�*�,���*�*�1�*�%���*�*�1�*�%���n�n�i��3�#�I�N���n�n�N���
��
�'�'��)<�)<�)>��(D�E���
�!3�4�C��
��	���g�x�0�
���g�x�0��n�n�8�s��
���n�n�-�C�i�
���'�'����):�C�(@�A���
�<��6�c�6�
��	���g�x�0rc�X�dgdzdgdzz}dgdzdgdzz}tjgd�dz�}tjj	d�jddd	�}t
||||d
��}|jddg�}d
|j_	|jd�}tjd�}	tjt|	��5|j!d�j#�ddd�|j!d�j#d��}
|
j%d|��}|j&dd�dgfj!d�j#�j%d|��}d
|j_	t)j*||�y#1swY��xYw)Nr5r2r6r3r4)z
2013-01-03z
2013-01-04z
2013-01-05rr�rq)�ID�NAME�DATE�VAR1r�r��Paramsz&agg function failed [how->mean,dtype->r�zW-THUT)�numeric_onlyrr�)r��to_datetimerr�r��integersrrfr9rbr"�re�escaper�r�r��resample�meanr!rkr#r$)
r&r�id_colrb�date�var1r(�multi�unstr��downrrs
             r�test_stack_multiple_bugz2TestStackUnstackMultiLevel.test_stack_multiple_bugsn��
�#��'�q�c�A�g�&�����	�s�e�a�i�(���~�~�H�1�L�M���y�y�$�$�Q�'�0�0��C��;��
�f�d�D�$�O�
P�����f�d�^�,��%��
�
���}�}�T�"���i�i�@�A��
�]�]�9�C�
0�	*��M�M�'�"�'�'�)�	*��}�}�W�%�*�*��*�=��
�Z�Z��<�Z�
8���H�H�Q���[�!�
�X�g�
�
�T�V�
�U�4�l�U�
3�		�#��
�
��
���b�"�%�	*�	*�s� F � F)c�>�tddgddgddgd��}|jddg�}|sd	ntj}|j	�j||�
�}t
|�t
|j��kDsJ�|rFtjtd��5|j	�jd
|�
�ddd�y|j	�jd
|�
�}tj||j��y#1swYyxYw)N�a1�a2�b1�b2r5r0rwrxFr�r3r�T)
rrfrr�r"r!rIr�r�r�r�r#r$)r&rr(r�r)s     r�test_stack_dropnaz,TestStackUnstackMultiLevel.test_stack_dropna7s���
�d�D�\��t��A�q�6�J�
K��
�\�\�3��*�
%��*�������*�*�,�$�$�F��$�N���7�|�c�'�.�.�"2�3�3�3�3�����z�1M�N�
K��
�
��"�"�$�\�"�J�
K�
K��j�j�l�(�(��<�(�P�G��!�!�'�7�>�>�+;�<�	
K�
K�s�""D�Dc��tgd�gd�gd�ggd�gd�g��}gd�|j_dd	g|j_|j	d
dg�y)N)rrrrr5r5r5r5)rrr5r5rrr5r5�rr5rr5rr5rr5rrr7r�r�r�r4r�)rr8rhr9r")r&rr(s   r�"test_unstack_multiple_hierarchicalz=TestStackUnstackMultiLevel.test_unstack_multiple_hierarchicalJsS��
�(�(�(��
"�<�0�

��)�������:��
�
��	�
�
�C��:�rc
��d}ttjjd�j	d|��tjjd�j	d|��tjjd�j	dd	|��tjjd
�j	dd|��tjjd
�j	d|��tjjd	�j|�d��}|j
gd��}|jd�y)N��r6r�)�sizer2i,rDi����rrrQi���rqi�)rwrxr�r�r�r�)rwrxr�r�r�r�)rrr�r�r�r�rfr")r&�NUM_ROWSr(�idfs    r�test_unstack_sparse_keyspacez7TestStackUnstackMultiLevel.test_unstack_sparse_keyspaceZs����
��Y�Y�*�*�1�-�6�6�s��6�J��Y�Y�*�*�1�-�6�6�s��6�J��Y�Y�*�*�1�-�6�6�r�1�8�6�L��Y�Y�*�*�1�-�6�6�s�B�X�6�N��Y�Y�*�*�1�-�6�6�t�(�6�K��Y�Y�*�*�1�-�=�=�h�G�

�	
���l�l�4�5��	���C�rc�R�ddggd�g}gd�gd�g}t||�}ttjj	d�jd�|��}|j
�}t|j�d	k(sJ�|j|�
�}tj||�y)Nrr5r1rr2r6)rDr6r:rDr)rrrr�r�r�r"rIr9r!r#r$)r&rr>rr8r(r?r�s        r�test_unstack_unobserved_keysz7TestStackUnstackMultiLevel.test_unstack_unobserved_keysos���
�a�&�,�'���|�,���6�5�)��
�r�y�y�,�,�Q�/�?�?��G�u�
U��������6�>�>�"�a�'�'�'����<��8��
���f�b�)rc�"�Gd�dtj�}|j�5}|jtd|�t	tjd�tjd�tjd�g��}d}tjt|��5tjtd	��5|j�ddd�ddd�ddd�y#1swY�xYw#1swY�xYw#1swYyxYw)
Nc� ��eZdZd�fd�Z�xZS)�aTestStackUnstackMultiLevel.test_unstack_number_of_levels_larger_than_int32.<locals>.MockUnstackerc�8��t�|�|i|��td��)N�Don't compute final result.)�super�__init__�	Exception)r&�argsrT�	__class__s   �rr	zjTestStackUnstackMultiLevel.test_unstack_number_of_levels_larger_than_int32.<locals>.MockUnstacker.__init__�s!����� �$�1�&�1�� =�>�>r)�returnN)rrrr	�
__classcell__)rs@r�
MockUnstackerr�s
���
?�
?rr�
_Unstacker)�r6rr:z$The following operation may generater�r)�reshape_libr�context�setattrrrrBrr#r�rr�r�r
r")r&�monkeypatchrrZr(r�s      r�/test_unstack_number_of_levels_larger_than_int32zJTestStackUnstackMultiLevel.test_unstack_number_of_levels_larger_than_int32�s���
	?�K�2�2�	?��
 �
 �
"�		!�a�
�I�I�k�<��?������$��y�y��'����5�)9�:��B�9�C��+�+�,>�c�J�
!��]�]�9�4Q�R�!��J�J�L�!�
!�		!�		!�!�!��
!�
!��		!�		!�s<�A=D�'C9�C-�C9�D�-C6�2C9�9D	�>D�Dr>c#�vK�|]1}tjtjgd�|�d�����3y�w)r`r6r�N)r�r�r)rL�widths  rrMz$TestStackUnstackMultiLevel.<genexpr>�s5����&
��
���i�4�4�Y��F�q�Q�Q�&
�s�79r��	stack_levrTFc�F�t|gd�gd�g��}t|td�g��}|rind|i}|j|fd|i|��}|jD]K}	|j
D]:}
|j|	|
f}|	|
|f}|
d|z
}
|j||
f}||k(r�:J��My)	NrrrrD)r9rlrrr5)rrr;r!r8r9rk)r&r>rrrr9r(rT�
df_stacked�rowrr@�
result_row�
result_colr?s               r�%test_stack_order_with_unsorted_levelsz@TestStackUnstackMultiLevel.test_stack_order_with_unsorted_levels�s���"�F�<��2N�O��
�w�e�A�h�Z�
8��#��&�$����R�X�X�i�M�l�M�f�M�
��8�8�	*�C��z�z�
*���6�6�#�s�(�+�� �#�i�.�0�
� ��Y��/�
�#���
�J�(>�?����)�)�)�
*�	*rc
�t���tgd�gd�gtjtd�d�tjtd�d�g��}t|td�tjdt|�z�jdd����t��fd��jD��sJ�y)	N)rwr�rx)rxrwr�r2rrQrV)r9r8rlc3��K�|]Q}�jD]@}�j||f�jd���j||df|dfk(���B�Sy�w)rrr5N)r9rkr!)rLrrr(rs   ��rrMz]TestStackUnstackMultiLevel.test_stack_order_with_unsorted_levels_multi_row.<locals>.<genexpr>�sv�����
���z�z�	
��
�F�F�3��8���x�x���x�5�9�9�3��A��-��Q��:O�P�
Q�
�
Q�
�s�AA)rrr�r;�tilerrrIr
r5r8)r&rrr(s ` @r�/test_stack_order_with_unsorted_levels_multi_rowzJTestStackUnstackMultiLevel.test_stack_order_with_unsorted_levels_multi_row�s�����#�_�5��9�9�U�1�X�q�)�2�7�7�5��8�Q�+?�@�
����e�A�h�R�Y�Y�q�3�r�7�{�-C�-K�-K�A�r�-R�
���
��x�x�
�
�	
�
rc�&�d}d}t|gd�gd�g��}t|td�ggd���}|rind	d
i}|j|fd|i|��}tgd�d
dgggd�gd�g��}tgd�gd�d�|��}	t	j
||	�y)N)�rr5)r5rr5rrrrD)r5rr6r2)r9rlr8rTrr1r)r5r5rrr6r6r2r2)r5rr5rr5rr5rr�)r6r2r6r2r6r2r6r2r%r:)rrr;r!r#r$)
r&rr>rr9r(rTr?r�r@s
          r�1test_stack_order_with_unsorted_levels_multi_row_2zLTestStackUnstackMultiLevel.test_stack_order_with_unsorted_levels_multi_row_2�s���
"���	��F�<��2N�O��
�w�e�A�h�Z�|�
L��#��&�$�������)�I�,�I�&�I��#� �1�a�&�)�+�-E�F�
���+�+�
�!�
��	���f�h�/rc	��tjd�}tj|D�cgc]}d|����	c}|D�cgc]}d|����	c}g�}t|jddg��}d|j
_d|i}tj|d��}d	dg|j
_	|jt|j
�d��}|jdd	g|�
�jdd	g�}tddgd
dgddgddgddgggd�tjddgdd	g����}	t!j"||	�ycc}wcc}w)NrQr4r3r�r
rFr5r3rr�a0�b0r�r�r�r��a3�b3�a4�b4r�)r3rF)r4rFr�r7)rr�vstackrr%r9rbr�rPrhrvr�r!r"rrdr#r$)
r&rr�rFrlr(�second_level_dict�multi_level_dfr?r@s
          r�'test_stack_unstack_unordered_multiindexzBTestStackUnstackMultiLevel.test_stack_unstack_unordered_multiindex�sM��
���1����y�y�"(�)�Q�1�Q�C��)�"(�)�Q�1�Q�C��)�
�
���t�v�v��S�z�
2��!��
�
�� �"�I�����#4�1�=��(0�'�':����$�
�
#�
#�F�>�+A�+A�$B��
#�
K�����7�H�-�L��I�Q�Q�
�h��
����D�\�D�$�<�$����d�|�d�D�\�R�!��*�*��Z�(��(�0C��
��	���f�h�/��)*��)s
�E�E
c��|}d|d<d|d<|jd�}|djtjk(sJ�|s"|djtjk(sJ�	|djtjk(sJ�y)	Nrr�r6r�r�r)r�r5)r�r5)r"rSrr|�object_)r&r_r"r`r+s     r�test_unstack_preserve_typesz6TestStackUnstackMultiLevel.test_unstack_preserve_types�s���>����C����C���K�K��(�	��� �&�&�"�*�*�4�4�4�&�
�f��#�#�r�z�z�1�	
�
���� �&�&�"�*�*�4�4�4rc�.�tjtjd�d�}tjd�}t|gdzddggz|gdztjd�j	d�gz��}ttjd�|��}|j
�}|jd	k(sJ�|j|�
�}tj||j|j��tddgg|gdzztjd�j	d�g|gdzz��}ttjd�|��}|j
d�}|jd	k(sJ�t|gdzddggz|gdzz|gdztjd�j	d�gz|gdzz��}ttjd�|��}|j
d�}|jd	k(sJ�y)N��r6rsrr5rr�r:)r6r6rrD)
rr"rrr�r
r"r r!r#r=rvr8)r&rrr�r8rnr?r)s        r�!test_unstack_group_index_overflowz<TestStackUnstackMultiLevel.test_unstack_group_index_overflow	s�������	�	�#���*���	�	�#�����7�Q�;�1�a�&��)��'�A�+����1��!4�!4�S�!9� :�:�
��

�2�9�9�T�?�%�0��������|�|�x�'�'�'��,�,�L�,�9��
���q�'�/�/�!�'�'�":�;����F�8�u�g��k�)��9�9�Q�<�&�&�s�+�,��w��{�:�
��

�2�9�9�T�?�%�0�����1����|�|�x�'�'�'���7�Q�;�1�a�&��)�U�G�a�K�7��7�Q�;�"�)�)�A�,�"5�"5�c�":�!;�;�u�g��k�I�
��

�2�9�9�T�?�%�0�����1����|�|�x�'�'�'rc	��tgd�gd�dgdzd��jddg�}d|d	<|s$t|jj�d
k(sJ�|jd�}|dj
d�|d<tgd
�tjdddggtddgd��tjgd�ddg����}|r.|djd�|d<|djd�|d<tj||�y)N)rwrwrx)�ca�cbr:r%r2)r3r4r�r3r4r5�is_r6�r;r9r)�$@r=r�r�r=r]r�rwrxr�))r�r9�r�r:r<�r;r:r�r7r>rjr?)rrfrIrJrKr"r�rrHrrrdrir#r$)r&rLr(r?r@s     r�+test_unstack_with_missing_int_cast_to_floatzFTestStackUnstackMultiLevel.test_unstack_with_missing_int_cast_to_float5	s��
�$�'��T�A�X�
�
��)�S�#�J�
�
	���5�	�"��r�w�w�~�~�&�!�+�+�+����C��� &�}� 5� <� <�Q� ?��}���
#�b�f�f�d�C��%=�>���c�
��-��*�*�H��S�k��
���$,�[�$9�$@�$@��$I�H�[�!�&.�}�&=�&D�&D�W�&M�H�]�#�
���f�h�/rc��tgd�gd�gd�gd�d��}|jgd��}gd�}|jj|d��|_|jj|d	��|_|j	d
�dj�j}t
gd�gd�ggd�gd
�gdd	g��}tj||�y)Nr)r2rDr5r6rE)�L1�L2�L3rF)rBrCrD)�n1�n2�n3NrB)r>r�rCrD)rFr5r1)r6r2rr5r)	rrfr8�
set_levelsr"rrr#r�)r&r��
new_levelsr?r@s     r�test_unstack_with_level_has_nanz:TestStackUnstackMultiLevel.test_unstack_with_level_has_nanU	s����"�"�"�!�	
�
���m�m�.�/��-�
��I�I�(�(�
�$�(�G��	��I�I�(�(�
�$�(�G��	����T�"�8�,�7�7�9�?�?���,�.F�G���.���,�
��	���f�h�/rc��ttjddg�tjgd����}|jd|��}|r1tdgdd	gggd
�gd�g��}tdgdd
gggd
�gd�g��}nt
gd��}t
gd��}tdtjtjgtjddgtjddgg||��}tj||�y)Nr5rQ))rNN)rr6r)rr6r5)rr2r)rr2r5r�r6rrr]r�r/)rVrr5rr2)�rN)rrr%)rL)rr6)rr2r7)
rrrBrrdr!rrHr#r$)r&rr(r?r8r9r@s       r�$test_stack_nan_in_multiindex_columnsz?TestStackUnstackMultiLevel.test_stack_nan_in_multiindex_columnsm	s���
��H�H�a��V���*�*���
�����!�,��7�����s�S�#�J�&7�	�:�?V�W�E� �!��q�!�f�
�i��=T�U�G��5�6�E��7�8�G���2�6�6�2�6�6�
"�R�V�V�S�#�$6�����c�8J�K���
��
	���f�h�/rc
�:�tjdgdzdgdzztjt	d��tjt	d��g�}tt
jd�jdd�|��}|jd	dg|�
�}|r�tdtjgd	tjgtjdgtjdgdtjgd
tjgtjdgtjdggddgtjdgdzd	gdzztjt	d��tjt	d��g���}n�tdtjgtjdgd	tjgtjdgdtjgtjdgd
tjgtjdggddgtjdgdzd	gdzztjt	d��tjt	d��g���}tj||�y)Nrwr6rxr|�ccddrsrDr�r5rrr2rQrqrr�abababab�ccddccddr��aabbaabb�cdcdcdcd)
rrr�r�rzrrrr
r!rHr#r$)r&rrr(r?r@s      r�"test_multi_level_stack_categoricalz=TestStackUnstackMultiLevel.test_multi_level_stack_categorical�	s��
�%�%����	�S�E�A�I�%����t�F�|�,����t�F�|�,�
�
���r�y�y��|�+�+�A�q�1�4�
@�����1�a�&�|��<��� �����K�����K��V�V�Q�K��V�V�Q�K�����K�����K��V�V�Q�K��V�V�Q�K�	��c�
� �,�,���a��1�#��'�)����t�J�'7�8����t�J�'7�8����H�*!�����K��V�V�Q�K�����K��V�V�Q�K�����K��V�V�Q�K�����K��V�V�Q�K�	��c�
� �,�,���a��1�#��'�)����t�J�'7�8����t�J�'7�8����H�(	���f�h�/rc���ttjd�jdd�t	j
dtjfdgddg��tdd	gd
��tj��}|j|�
�}|r+t	dd	gtjdgggd�gd�gd
dg��}n=t	j
dtjfdd	tjfdgd
dg��}tdtjgtjd	gdtjgtjdggtddgd��|��}tj||�y)NrDr6rwryr�r�r�rr5�Numr�rrr4rrrr)r5r4r]rrCrxr�)rrrr
rrdrHrr|r!r#r$)r&r�df_nanr?r8r@s      r�test_stack_nan_levelz/TestStackUnstackMultiLevel.test_stack_nan_level�	s5��
��I�I�a�L� � ��A�&��*�*��r�v�v��
�+�G�W�3E����A��U�+��*�*�

�����<��8�����A������
�.�#�\�2��g�&��E��*�*��R�V�V��h��B�F�F��X�>�u�g�FV��E���2�6�6�]�R�V�V�Q�K�#�r�v�v������
�F��3��*�7�3��
��
	���f�h�/rc��tjdgddgg�}tdtjddg�i|��}|j�}ttjdgddg��tjdgddg��d	�dg��}tjd
dg�|_tj||�y)Nrwrr5r�r3r4r:r�r%)r�r)r�r5)
rr<rr�r�r"rdr9r#r$r�s     r� test_unstack_categorical_columnsz;TestStackUnstackMultiLevel.test_unstack_categorical_columns�	s����%�%��u�q�!�f�o�6��
��r�~�~�s�C�j�9�:�#�
F���������>�>�3�%�S�#�J�?��>�>�3�%�S�#�J�?�
��%�
��&�1�1�:�z�2J�K���
���f�h�/rc��ddg}ddg}gd�}tj|||ggd���}ttt	|���}t||dg�	�}|j
d
dg�}|jjd�|_d
|jdd�df<|jd
dg|��j�}|jd��jd
dg|��j�}	tj||	�y)N�ITA�FRA�A1�A2)�CRT�DBT�NET)�PAE�VAR�TYPr��VALUE)rlr8r9rdreri')�A0rbrr5r3)rr<rzr;rIrr"r9rNrkr!rr#r=)
r&rrcrdrer��V�DFr?r@s
          r�test_stack_unsortedz.TestStackUnstackMultiLevel.test_stack_unsorted�	s���
�e�n���T�l��#��
�
$�
$�c�3��_�<Q�
R����s�2�w�� ��
�A�R�'��
;��
�Z�Z����
'���Z�Z�)�)�!�,��
�#'����q�-�� ����5�%�.�|��D�O�O�Q���M�M�q�M�!�
�U�E�5�>��U�
=�
�Z�\�	�
	���v�x�0rc���tjddgddggddg��}tgd�d	�
�}tjgd�gd�gd
�g�}t|||t
j���}|jd|��}|jtj�jd|��jt
j��}tj||�||jdjt
j��||jd<|jd|��}tt
jgd�t
j���t
jgd�t
j���d�tj||jdg���}d|j_tj||�y)N�54511�54515r��t_mean�station�elementr�r�r�r�)r���r%��)r%rrr���)i1��rkrsrrr)r�r=r=g"@gs@g�[@rR)rqrrrrrsrtrs)r�rnr:)rr<rrrrr��
Int64Dtyper!rirjr#r$r9�Float64Dtyper>rb)r&rr9r8�arrr(r?r@s        r�test_stack_nullable_dtypez4TestStackUnstackMultiLevel.test_stack_nullable_dtype
s���
�)�)��w�
�#�x��1�)�Y�9O�
���i�f�-���h�h�*�,=�?S�T�U��
�s�G�5��
�
��
P�����)�,��?��
�I�I�b�h�h��
�U�9�<�U�
8�
�V�B�M�M�O�
$�	�
	���f�h�/��r�z�z�!�}�-�4�4�R�_�_�5F�G��2�:�:�a�=�����)�,��?����X�X�9����AR���(�(�2�"�-�-�/��	
��)�)�5�'�.�.��2C�*D�E�

��!*�����
���f�h�/rc	�>�ddgddgddgg}tj|d��}tdddgi|�	�}|jd
�}tdgdggtjdgdd
g��tjdd
gddg����}tj||�y)Nr3r5r6�red�blue)rFrrGr�rZr:rF)rZr3)r5rz)r6r{rrGr�)rrrr"rdr#r$)r&�arraysr�r(r?r@s      r�test_unstack_mixed_level_namesz9TestStackUnstackMultiLevel.test_unstack_mixed_level_names5
s�����*�q�!�f�u�f�o�6���$�$�V�=�A��
��a��V�}�C�
0�����C�����S�1�#�J��*�*�J�<��c�{�K��(�(�*�k�)B�1�c�(�S�
��
	���f�h�/r)9rrrrar�rrrnrsrr{rzrrr"rr�rdr�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�rr�slowrr��chain�
from_iterabler;rr#r&r1r4r7r@rJrMrTrXrZrjrxr}rwrrr]r]-s���'��[�[���?�0�1O�P�>��(�	
�*�+C�D�6��"�	
�*�+F�G�6��"�	
�	
��.0�/�.0�(	3��[�[���C��J*��J*�X�[�[�����V��%�� �#�J����7�"�2�7�7�9�2�9�9�Q�<�#6�#6�q�#9�1�=�w�r�w�w�y�RS�?T�U��
�'�
�&�&�'O�P�%�� �#�J��A�����?�����	��	�	�!�� 3� 3�A� 6��:�!��	�	�)�Y�7�����	�1�-���
�	
��2*�3�2*�&�[�[���C��*��*�2�[�[���C��2��2�Y�&�[�[���C��
:��
:��[�[���X���';�<�8�=�8�&0��[�[���C��
1��
1��[�[���C�� M�� M�D�[�[���C��	E��	E��[�[���C��A��A�C3�J-1�^�[�[���C��&��&�2�[�[���C��=��=� � �*�[�[���C��
*��
*��[�[���!��!�*�[�[���C���[�[�������%�%�&
��&
�	
���[�[���[�%��(�3��[�[���V�d�E�]�3�*�4�4���*�"�[�[���C��
��
�$�[�[���C��0��0�*�[�[���C��0��0�65�"#(�J0�@0�0�[�[���C��0��0�8�[�[���C��50��50�n�[�[���C��0��0�8
0��[�[���C��1��1�,�[�[���C��#0��#0�J0rr]c	���tgd�gd�gd�ggd���}|j|��}tgd�tgd�gd�ggd	�gd
�g����}t	j
||�y)
Nr�)rDrQrq)rrrsr�)rr}r~r�r)	r5r6r2rDrQrqrrrsr�r`)	rrrr5r5r5r6r6r6)	rr5r6rr5r6rr5r6rr:)rr!r
rr#r=)rr(r?r@s    r�test_stack_tuple_columnsr�C
sd��	�	�I�y�)�3Q�
�B��X�X�<�X�
0�F��#���=�>�.�0K�L�
��H����6�8�,rzdtype, na_valuer�test_multiindexc���|r&tjdt|g|��gz�}nt|g|��}tddgi|��}|j	d��}|r;tjt|g|��t|g|��tdg�g�}n-tjt|g|��tdg�g�}td|��}t
j||�y)Nr6rRr3r5r:Tr)rrrrr!r
r#r=)rS�na_valuer�r8r(r?r�r@s        r�test_stack_preserves_nar�S
s�����&�&�q�E�8�*�E�,J�+K�'K�L���x�j��.��	�C�!��:�U�	+�B�
�X�X�4�X�
(�F��#�/�/��x�j��.��x�j��.��s�e��
�
��$�/�/��x�j��.��s�e��
�
���a�~�.�H����6�8�,r)1rr�r��numpyrr��pandas._libsr�
pandas.errorsr�pandasr�rrrr	r
rr�pandas._testing�_testingr#�pandas.core.reshaper
r�fixturerrrrr"r$r)r1rr�r4r6r8rCrGrRrUr[r]r�rHrr�rwrr�<module>r�s[����	��
��,������6������e�}�%��&��B0�B0�J(������9�i�"8�9�",�:�",�J,�0,�0	-������W�X�������D�%����#@�A�1�B�Y�1������W�X�������D�%����#@�A��������a�y�1�0�2�B�Y�0�")�,�>�����W�X�
,�Y�
,�)�,�����W�X�#,�Y�#,�L�����W�X�-�Y�-�$S0�S0�l 
-� ������	�B�F�F��	�B�F�F��	�B�E�E��	�"�%�%��	�������*�T�5�M�:�-�;��-r

Youez - 2016 - github.com/yon3zu
LinuXploit