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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : C:/Python312/Lib/site-packages/pandas/tests/io/parser/__pycache__/test_header.cpython-312.pyc
�

0	�g%R���dZddlmZddlmZddlZddlZddlm	Z	ddl
mZmZm
Z
ddlmZej"j%d�Zej"j)d�Zej"j)d	�Zed
��Zd�Zej"j3dgd
�ddgg�d��Zej"j3dddg�d��Zed��Zd�Zed��Zej"j3ddddgidfddgddgd�dfddgddgd�dfg�d ��Zed!d"d#g�Z eej"j3d$dddgid%gd&�d'�d%e d(d)�e d(d*�e d(d+�e d,d-�e d.d/�e d.d0�gd'�g�d1���Z!eej"j3d$dddgid2gd&�d'�d2e d(d)�e d(d*�e d(d+�e d,d-�e d.d/�e d.d0�gd'�g�d3���Z"eej"j3d$dddgid2gd&�d'�d2e d(d)�e d(d*�e d(d+�e d,d-�e d.d/�e d.d0�gd'�g�d4���Z#ed5��Z$ed6��Z%ed7��Z&ed8��Z'ej"j3d9d:d;g�d<��Z(eej"j3d$iddig�d=���Z)ej"j3d>igd?�fd@gdA�igdA�fg�dB��Z*ej"j3dd(d,gdCg�dD��Z+edE��Z,eej"j3dFdGegdH�ge
jZgdI���J�fdKegdH�ge
jZgdL���J�fdMegdN�ge
jZgdO���J�fg�dP���Z.eej"j3dddgg�ej"j3dQddRdSgdSdRgdSdTgg�dU����Z/edV��Z0edW��Z1edX��Z2edY��Z3edZ��Z4d[�Z5ed\��Z6ed]��Z7ed^��Z8d_�Z9y)`zx
Tests that the file header is properly handled or inferred
during parsing for all of the parsers defined in parsers.py
�)�
namedtuple)�StringION)�ParserError)�	DataFrame�Index�
MultiIndexz=ignore:Passing a BlockManager to DataFrame:DeprecationWarning�
pyarrow_xfail�pyarrow_skipc��|}d}tjt|��5td�}|j	|dg��ddd�y#1swYyxYw)Nzbut only \d+ lines in file��matchz,,�
��header)�pytest�raises�
ValueErrorr�read_csv)�all_parsers�parser�msg�ss    �DC:\Python312\Lib\site-packages\pandas/tests/io/parser/test_header.py�test_read_with_bad_headerrsJ��
�F�
'�C�	���z��	-�(��T�N������2�$��'�(�(�(��� A	�	Ac��|}d}tjtd��5|jt	|�d��ddd�y#1swYyxYw)N�$1,2,3,4,5
6,7,8,9,10
11,12,13,14,15
zUPassing negative integer to header is invalid. For no header, use header=None insteadr���r�rrrrr�rr�datas   r�test_negative_headerr"'sO��
�F��D�
����1�
�3�
	������r��2�3�3�3���A�Ar)r�����c��|}d}tjtd��5|jt	|�|��ddd�y#1swYyxYw)Nz<1,2,3,4,5
        6,7,8,9,10
        11,12,13,14,15
        z8cannot specify multi-index header with negative integersrrr)rrrr!s    r� test_negative_multi_index_headerr(6sO���F��D�
����T�
�7�	������v��6�7�7�7�r#TFc��|}d}d}tjt|��5|jt	|�|��ddd�y#1swYyxYw)NzMyColumn
a
b
a
bz#Passing a bool to header is invalidrr)rr�	TypeErrorrr)rrrr!rs     r�test_bool_header_argr+DsN���F��D�0�C�	���y��	,�7�������v��6�7�7�7���A�Ac��|}d}gd�}|jt|�|��}tgd�gd�gd�ggd�gd���}tj||�y)	Nzfoo,1,2,3
bar,4,5,6
baz,7,8,9
��A�B�C��names��r$�)r%��)���	)�foo�bar�baz��index�columns�rrr�tm�assert_frame_equal)rrr!r3�result�expecteds      r�test_header_with_index_colrGSsW��
�F��D�
�E�
�_�_�X�d�^�5�_�
9�F��	�I�y�)�#���H�
���&�(�+�c��|}d}d}|jt|�dd��}|jt|�dd��}tj||�y)Nzggot,to,ignore,this,line
got,to,ignore,this,line
index,A,B,C,D
foo,2,3,4,5
bar,7,8,9,10
baz,12,13,14,15
z7index,A,B,C,D
foo,2,3,4,5
bar,7,8,9,10
baz,12,13,14,15
r$r�r�	index_col�rrrCrD)rrr!�data2rErFs      r�test_header_not_first_linerNesW��
�F��D�
�E��_�_�X�d�^�A��_�
C�F����x���q�A��F�H����&�(�+rHc��|}d}|jt|�gd�ddg��}d�}td�D��cgc]"}td�D�cgc]}|||���
c}��$}}}tjtd�D�cgc]}d	|����	c}td�D�cgc]}d
|����	c}gddg�
�}tjtd�D�cgc]}d|����	c}td�D�cgc]}d|����	c}td�D�cgc]}d|����	c}td�D�cgc]}d|����	c}ggd��
�}	t||	|��}
t
j||
�ycc}wcc}}wcc}wcc}wcc}wcc}wcc}wcc}w)N�C0,,C_l0_g0,C_l0_g1,C_l0_g2

C1,,C_l1_g0,C_l1_g1,C_l1_g2
C2,,C_l2_g0,C_l2_g1,C_l2_g2
C3,,C_l3_g0,C_l3_g1,C_l3_g2
R0,R1,,,
R_l0_g0,R_l1_g0,R0C0,R0C1,R0C2
R_l0_g1,R_l1_g1,R1C0,R1C1,R1C2
R_l0_g2,R_l1_g2,R2C0,R2C1,R2C2
R_l0_g3,R_l1_g3,R3C0,R3C1,R3C2
R_l0_g4,R_l1_g4,R4C0,R4C1,R4C2
�rr5r$r6rr5rJc��d|�d|��S)N�Rr1�)�r�cs  r�<lambda>z)test_header_multi_index.<locals>.<lambda>�s���!��A�a�S�k�rHr7r6�R_l0_g�R_l1_g�R0�R1r2�C_l0_g�C_l1_g�C_l2_g�C_l3_g)�C0�C1�C2�C3)rAr@)rr�ranger�from_arraysrrCrD)rrr!rE�
data_gen_frUrV�ir@rArFs           r�test_header_multi_indexrhys`��
�F��D��_�_�X�d�^�L�Q�PQ�F�_�
S�F�)�J�:?��(�C�Q�u�Q�x�0�!�Z��1�
�0�C�D�C��"�"� %�a��	)�1�F�1�#�,�	)�%��(�+K�Q�f�Q�C�L�+K�L��T�l�
�E��$�$�#(��8�,�a�v�a�S�\�,�#(��8�,�a�v�a�S�\�,�#(��8�,�a�v�a�S�\�,�#(��8�,�a�v�a�S�\�,�		
�'��G���w�e�<�H����&�(�+��
1��C��	)��+K��

-��,��,��,s;�E�	E�E�=E%�E*
�E/�'E4
�E9�E>�Ez
kwargs,msgrKr<r=zLindex_col must only contain row numbers when specifying a multi-index headerr5)rKr3z9cannot specify names when specifying a multi-index header)rK�usecolsz;cannot specify usecols when specifying a multi-index headerc��d}|}tjt|��5|jt	|�fdgd�i|��ddd�y#1swYyxYw)NrPrrrQr)r�kwargsrr!rs     r�test_header_multi_index_invalidrl�sS��,�D��F�	���z��	-�G��������F�|�F�v�F�G�G�G�s�!A
�
A�
_TestTuple�first�secondrkr6�)�a�q)rqrU)rqr)�b�t)rV�u)rV�v)�skiprowsr3rqrrrUrrsrtrVrurvc���|}tgd�gd�gddgtjgd����}d}|jt	|�fdd	i|��}tj||�y)
N�r5r$r6r%r7r8�r9r:r;r���one�tworpr?zC,a,a,a,b,c,c
,q,r,s,t,u,v
,,,,,,
one,1,2,3,4,5,6
two,7,8,9,10,11,12rKr�rr�from_tuplesrrrCrD�rrkrrFr!rEs      r�&test_header_multi_index_common_format1r��sk��<�F��	�2�3��e�n��&�&�T�
��H��D��V�_�_�X�d�^�
C�q�
C�F�
C�F����&�(�+rHr$c���|}tgd�gd�gddgtjgd����}d}|jt	|�fdd	i|��}tj||�y)
Nryrzr}r~rpr?z<,a,a,a,b,c,c
,q,r,s,t,u,v
one,1,2,3,4,5,6
two,7,8,9,10,11,12rKrrr�s      r�&test_header_multi_index_common_format2r��sk��<�F��	�2�3��e�n��&�&�T�
��H��D�
�V�_�_�X�d�^�
C�q�
C�F�
C�F����&�(�+rHc���|}tgd�gd�gddgtjgd����}|jd��}d	}|jt|�fd
di|��}t
j||�y)Nryrzr}r~rpr?T)�drop�2a,a,a,b,c,c
q,r,s,t,u,v
1,2,3,4,5,6
7,8,9,10,11,12rK)rrr��reset_indexrrrCrDr�s      r�&test_header_multi_index_common_format3r�*s���<�F��	�2�3��e�n��&�&�T�
��H��#�#��#�.�H��D�
�V�_�_�X�d�^�
F�t�
F�v�
F�F����&�(�+rHc
��|}ttjgd�gd�gd��tddg�t	gd�gd�ggd	�gd
�gddg�
���}d}|jt
|�ddgd��}tj||�y)N�r$r6r%r7r8�r:r;rr{r|�int64��dtyper5r9�rqrsrV�rUrrtrurv�rrr5r$r$�rr5r$r6r%rqrr��levels�codesr3r?r�rrJ�	r�np�arrayrrrrrCrD�rrrFr!rEs     r�0test_header_multi_index_common_format_malformed1r�Zs���
�F��
���/�#5�6�g�F��Q��F�m��#�%>�?�"�O�4���*�
��H��D�
�_�_�X�d�^�Q��F�a�_�
H�F����(�F�+rHc
��|}ttjgd�gd�gd��tddg�t	gd�gd�ggd	�gd
�gddg���
�}d}|jt
|�ddgd��}tj||�y)Nr�r�r�r�r5r9r�r�r�r�rrr�r?�1,a,a,b,c,c
q,r,s,t,u,v
1,2,3,4,5,6
7,8,9,10,11,12rrJr�r�s     r�0test_header_multi_index_common_format_malformed2r�os���
�F��
���/�#5�6�g�F��Q��F�m��#�%>�?�"�O�4���+�
��H��D�
�_�_�X�d�^�Q��F�a�_�
H�F����(�F�+rHc
�.�|}ttjgd�gd�gd��tddgddggd	dgd	dgg�
�tgd�gd�ggd
�gd�gddg����}d}|j	t|�d	dgd	dg��}t
j||�y)N)r6r%r7r8)r;rr{r|r�r�r5r9r$r:r)r�r�r�)rrtrurv)rr5r$r$rQrrr�r?r�rJ)rr�r�rrrrCrDr�s     r�0test_header_multi_index_common_format_malformed3r��s���
�F��
���,��0��@��!�Q��!�Q�� 0�!�Q��!�Q��8H�I��#�%9�:���.���+�
��H��D�
�_�_�X�d�^�Q��F�q�!�f�_�
M�F����(�F�+rHc���|}ddgddgddgg}tjddg�}t||��}d}|jt	|�d	dg�
�}tj||�y)Nr5r$r6r%)rqr/)rsr0�rAza,b
A,B
,
1,2
3,4rr)rr�rrrrCrD)rrr!rArFrEs      r�"test_header_multi_index_blank_liner��sq���F�
�4�L�1�a�&�1�a�&�)�D��$�$�j�*�%=�>�G���w�/�H�"�D�
�_�_�X�d�^�Q��F�_�
;�F����(�F�+rHzdata,header)�1,2,3
4,5,6N)zfoo,bar,baz
1,2,3
4,5,6rc�2�|}|jdk(r3|�1tjjd��}|j	|�|jt
d�gd���}|jt
|�gd�|��}tj||�y)N�pyarrowzDataFrame.columns are different)�reasonr�r�r2�r3r)	�enginer�mark�xfail�applymarkerrrrCrD)rr!r�requestrr�rFrEs        r�!test_header_names_backward_compatr��s��
�F�
�}�}�	�!�f�&8��{�{� � �(I� �J�����D�!����x��7���O�H�
�_�_�X�d�^�?�6�_�
R�F����&�(�+rHc��|}tgd���}|jtd�fi|��}tj||�y)Nr�r�za,b,c�rrrrCrD)rrkrrFrEs     r�test_read_only_header_no_rowsr��s=���F���1�H�
�V�_�_�X�g�.�
9�&�
9�F����&�(�+rHzkwargs,namesr�r3)r<r=r>�quux�pandac��|}d}tgd�gd�gd�g|��}|jt|�fddi|��}tj||�y)Nr)r5r$r6r%r7)r8r9r:r;r)r{r|�
��r�rr�)rrkr3rr!rFrEs       r�test_no_headerr��sZ���F��D��	�*�,@�A�5��H��V�_�_�X�d�^�
C�D�
C�F�
C�F����&�(�+rH�
string_headerc��d}d}|}tjt|��5|jt	|�|��ddd�y#1swYyxYw)Nz*header must be integer or list of integersz1,2
3,4rrr)rrrr!rs     r�test_non_int_headerr��sJ��7�C��D�
�F�	���z��	-�7�������v��6�7�7�7�r,c��d}|}tddgddgddgd��}|jt|�dg��}tj||�y)Nza,b,c
0,1,2
1,2,3rr5r$r6r�rr�)rr!rrFrEs     r�test_singleton_headerr��sS��%�D�
�F���1�v�Q��F�!�Q��@�A�H�
�_�_�X�d�^�Q�C�_�
8�F����&�(�+rHz
data,expectedz#A,A,A,B
one,one,one,two
0,40,34,0.1)r�(�"皙�����?)�r/r}�r/zone.1)r/zone.2�r0r~r�z%A,A,A,B
one,one,one.1,two
0,40,34,0.1)r�r��r/zone.1.1r�z/A,A,A,B,B
one,one,one.1,two,two
0,40,34,0.1,0.1)rr�r�r�r�)r�r�r�r�)r0ztwo.1c�p�|}|jt|�ddg��}tj||�y)Nrr5rrL)rr!rFrrEs     r�test_mangles_multi_indexr��s4��R�F�
�_�_�X�d�^�Q��F�_�
;�F����&�(�+rHrA��Unnamed�
NotUnnamedc���|}ddg}|�dj|xsddg�dz}ndjdg|xsddgz�dz}|jt|�||��}g}|�gd�}t|�D]%\}}	|	s
d	|�|n|dz�d
�}	|j	|	��'tjt|ddg��}td
dgddgg|��}
tj||
�y)Nrr5�,r�z
0,1
2,3
4,5
z
,0,1
0,2,3
1,4,5
rJ)r�r�r�z	Unnamed: �_level_0�0�1r$r6r%r7r�)�joinrr�	enumerate�appendrr��ziprrCrD)rrKrArrr!rE�exp_columnsrg�colrFs           r�test_multi_index_unnamedr�s	���F���V�F����x�x��+�B��8�,�/B�B���x�x���� 3�B��8�4�5�8P�P��
�_�_�X�d�^�F�i�_�
P�F��K������G�$� ���3���9�#4�a�!�a�%�@��I�C����3��	 ��$�$�S��s�C�j�%A�B�G��1�a�&�1�a�&�)�7�;�H����&�(�+rHc��|}d}|jt|�dgd���}tddgddgd	d
gd��}tj||�y)Nza, b
1,2,3
5,6,4
rr.)rr3r5r7r$r8r6r%rB�rrr!rErFs     r�6test_names_longer_than_header_but_equal_with_data_rowsr�EsW���F��D��_�_�X�d�^�A�_�_�
M�F���1�v�Q��F�!�Q��@�A�H����&�(�+rHc�N�|}d}d}tjgd��}tgd�gd�g|��}|jt	|�ddg�	�}tj||jdd�|jt	|�ddg�	�}tj||�y)
NzFMale, Male, Male, Female, Female
R, R, L, R, R
.86, .67, .88, .78, .81z^Male, Male, Male, Female, Female
R, R, L, R, R
.86, .67, .88, .78, .81
.86, .67, .88, .78, .82))�MalerS)� Male� R)r�z L)� Femaler�)r�z R.1)��Q���?�q=
ףp�?�)\��(�?�(\���?g�Q����?)r�r�r�r�g=
ףp=�?r�rr5r)rr�rrrrCrD�iloc)rr�s1�s2�mirF�df1�df2s        r� test_read_csv_multiindex_columnsr�Rs����F�	S�B�	"��
�	�	�	
�
�B��	'�)G�H�RT��H��/�/�(�2�,��1�v�/�
6�C����#�x�}�}�R�a�0�1�
�/�/�(�2�,��1�v�/�
6�C����#�x�(rHc��|}d}tjtd��5|jt	|�ddg��ddd�y#1swYyxYw)Nz1row11,row12,row13
row21,row22, row23
row31,row32
z1Header rows must have an equal number of columns.rrr$r�rrrrr)rr�cases   r�'test_read_csv_multi_header_length_checkr�rsS���F��D�

����N�
�7�	�������1�v��6�7�7�7�s�A�Ac���|}d}|jt|�ddgd��}tgd�dtjtjgd�gd��	�}tj||�y)
Nzx,1,5
y,2
z,3
rqrsr�r4r7�rqrs)�x�y�z)r@)rrrr��nanrCrDr�s     r�#test_header_none_and_implicit_indexr��s_���F��D�
�_�_�X�d�^�C��:�d�_�
K�F���q�"�&�&�"�&�&�1�2�/��H����&�(�+rHc��|}d}tjtd��5|jt	|�ddgd��ddd�y#1swYyxYw)N�x,1
y,2,5
z,3
z"Expected 2 fields in line 2, saw 3rrqrsr�r�r s   r�1test_header_none_and_implicit_index_in_second_rowr��sP���F��D�	���{�*N�	O�G�������s�C�j���F�G�G�G�rc��|}d}|jt|�ddgdd��}tddgdd	gd
��}tj||�y)Nr�rqrs�skip)r3r�on_bad_linesr�r�r5r6r�rBr�s     r�&test_header_none_and_on_bad_lines_skipr��sY��
�F��D�
�_�_����s�C�j��F���F���S�z��A��7�8�H����&�(�+rHc��|}d}d}tjt|��5|jt	|�gd���ddd�y#1swYyxYw)Nza,b
1,2
z;Passed header=\[0,1,2\], len of 3, but only 2 lines in filer)rr5r$rr)rrr!rs    r�test_header_missing_rowsr��sO���F��D�I�C�	���z��	-�:�������y��9�:�:�:�s�A
�
Ac��|}d}|jt|�d��}tdgddd��}tj||�y)Nz1aa    bb(1,1)   cc(1,1)
                0  2  3.5z\s+)�seprr$g@)�aazbb(1,1)zcc(1,1)rBr�s     r� test_header_multiple_whitespacesr�sK���F��D��_�_�X�d�^��_�
8�F�����c�B�C�H����&�(�+rHc���|}d}d}tjt|d��5|jt	|�d��}ddd�tddd	gi�}tj|�y#1swY�/xYw)
Nza,b
1,2
3,4
    z;The 'delim_whitespace' keyword in pd.read_csv is deprecatedF)r
�check_stacklevelT)�delim_whitespaceza,bz1,2z3,4)rC�assert_produces_warning�
FutureWarningrrrrD)rrr!�depr_msgrErFs      r�test_header_delim_whitespacer�s����F��D�
M�H�	�	#�	#��X��
�H�����$��$��G��H��%�%���0�1�H����&�(�+�H�H�s�A.�.A7c��|}d}|jt|�dddgddd��}tddgd	d
ggd��}tj||�y)Nz
a,i,x
b,j,y
rr5zstring[pyarrow]r�)rrir��
dtype_backendr�rqrgrs�jr�rB)�pyarrow_parser_onlyrr!rErFs     r�test_usecols_no_header_pyarrowr�si��
 �F��D��_�_������A�����
��F��3��*�s�C�j�1�9J�K�H����&�(�+rH):�__doc__�collectionsr�ior�numpyr�r�
pandas.errorsr�pandasrrr�pandas._testing�_testingrCr��filterwarnings�
pytestmark�usefixtures�
xfail_pyarrow�skip_pyarrowrr"�parametrizer(r+rGrNrhrlrmr�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�r�rrrrTrHr�<module>rsc���
#���
�%���
�
�[�[�
'�
'�C��
����'�'��8�
��{�{�&�&�~�6���(��(�3�������Z�B��7�#<�=�
7�>�
7�������D�%�=�1�7�2�7��,��,�",�(�",��",�J�������5�%�.�)�'�	
��a�&�E�5�>�:�
H�	
�
�a�&�e�U�^�<�
J�	
���*G�+�*G�(��w��&9�
:�
��������	�A�q�6����
	
���3��$��3��$��3��$��3��$��3��$��3��$�
�
	
���8,�9��:,�&�������	�A�q�6����
	
���3��$��3��$��3��$��3��$��3��$��3��$�
�
	
���8,�9��:,�$�������	�A�q�6����
	
���3��$��3��$��3��$��3��$��3��$��3��$�
�
	
���8,�9��:,�&�,��,�(�,��,�*�,��,�(�,��,�������*�,L�M��,��,��������B��e�(<�#=�>�,�?��,�������	�_��
�<�=�2�	
��	�
,�	�
,�������S�#�J��#@�A�7�B�7��,��,��������
4��!�"�.�
�.�.�P��
�	
�
6��!�"�.�
�.�.�R��
�	
�
@��&�'�.�
�.�.���
�	
�'"�%�L,�M%��N,��������t�a�S�k�2������
���I��9�b�/�i��=V�X��,��3��
,�D�	,��	,��)��)�>�7��7��,��,��G��G�,��:��:��,��,��,��,�",rH

Youez - 2016 - github.com/yon3zu
LinuXploit