a
    DBìj:õ  ã                
   @  s
  d dl mZ d dlmZmZ d dlmZ d dlmZ d dlZd dl	m
Z
 d dlZd dlZd dlmZ d dlmZ d dlZd dlZd d	lmZ d dlm  mZ d dlZd d
lmZmZmZmZm Z  d dl!m"Z# eƒ rÜej$j%Z&g d¢Z'ej(de )d¡gd�ej(de )d¡gd�ej(de )d¡gd�ej(de )d¡d�ej(de )d¡d�ej(de )d¡d�gZ*dddœdd„Z+dd„ Z,ej-dd„ e*D ƒe.d�dd„ ƒZ/ej-dd „ ƒZ0ej-d!d"„ ƒZ1ej-d#d$„ ƒZ2dd%dd&œd'd(„Z3d)ddd*d+œd,d-„Z4d.d/„ Z5G d0d1„ d1ƒZ6G d2d3„ d3ƒZ7dS )4é    )Úannotations)ÚdatetimeÚtime)Úpartial)ÚBytesION)ÚPath)ÚURLError)Ú
BadZipFile)Úis_platform_windows)Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚread_csv)ú.xlsú.xlsxú.xlsmú.xlsbú.odsÚxlrd©ÚmarksÚopenpyxlÚpyxlsbÚodfÚcalamineÚpython_calamineÚstrÚbool)Úread_extÚreturnc                 C  s†   | j d } | dkr|dkrdS | dkr2|dkr2dS |dkrF| dvrFdS | dkrZ|d	krZdS |d	krn| d
vrndS | dkr‚|dkr‚dS dS )zm
    Filter out invalid (engine, ext) pairs instead of skipping, as that
    produces 500+ pytest.skips.
    r   r   r   Fr   r   >   r   r   r   r   >   r   r   r   T)Úvalues)Úenginer   © r#   úa/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/io/excel/test_readers.pyÚ_is_valid_engine_ext_pair@   s    
r%   c                 C  s    | j |f }tj|| jd�}|S )z�
    engine gives us a pytest.param object with some marks, read_ext is just
    a string.  We need to generate a new pytest.param inheriting the marks.
    r   )r!   ÚpytestÚparamr   )r"   r   r!   Ú	new_paramr#   r#   r$   Ú_transfer_marksU   s    r)   c                 C  s*   g | ]"}t D ]}t||ƒrt||ƒ‘qqS r#   )Úread_ext_paramsr%   r)   )Ú.0ZengÚextr#   r#   r$   Ú
<listcomp>`   s   
ýr-   )ÚparamsZidsc                 C  s   | j S )zS
    Fixture for Excel reader engine and read_ext, only including valid pairs.
    )r'   )Úrequestr#   r#   r$   Úengine_and_read_ext_   s    r0   c                 C  s   | \}}|S ©Nr#   ©r0   r"   r   r#   r#   r$   r"   o   s    r"   c                 C  s   | \}}|S r1   r#   r2   r#   r#   r$   r   u   s    r   c                 C  s"   | ddddƒ}t |dddd�}|S )	zI
    Obtain the reference data from read_csv with the Python engine.
    ÚioÚdataÚcsvz	test1.csvr   TÚpython)Ú	index_colZparse_datesr"   )r   )ÚdatapathÚfilepathÚdf_refr#   r#   r$   r:   {   s    r:   z
str | None)r   r"   r    c                 C  s   dS )NÚnsr#   )r   r"   r#   r#   r$   Úget_exp_unit…   s    r<   r   ÚNone)Úexpectedr   r"   r    c                 C  s$   d | j _t||ƒ}| j  |¡| _ d S r1   )ÚindexÚnamer<   Zas_unit)r>   r   r"   Úunitr#   r#   r$   Úadjust_expected‰   s    
rB   c                 C  s    | dkr|  tjjdd�¡ d S )Nr   z3Sheets containing datetimes not supported by pyxlsb©Úreason)Úapplymarkerr&   ÚmarkÚxfail)r"   r/   r#   r#   r$   Úxfail_datetimes_with_pyxlsb�   s    ÿÿrH   c                   @  sˆ  e Zd Zejdd�dd„ ƒZdd„ Zdd„ Zd	d
„ Zdd„ Z	dd„ Z
ej dg d¢g d¢g d¢g d¢g d¢g d¢g¡dd„ ƒZej dddgddgg¡dd„ ƒZdd„ Zdd„ Zd d!„ Zd"d#„ Zd$d%„ Zd&d'„ Zej d(d)d*g¡d+d,„ ƒZd-d.„ Zd/d0„ Zd1d2„ Zd3d4„ Zd5d6„ Zd7d8„ Zd9d:„ Zd;d<„ Zej d=d)eg d>¢g d?¢g d>¢d@dAej dBgdCœƒfdDdEe!e!dCœee"g d>¢dDdF�e"g d?¢dEdF�e"g dG¢dHdF�e"dIdJej dKgdHdF�dCœƒfg¡dLdM„ ƒZ#dNdO„ Z$dPdQ„ Z%dRdS„ Z&ej dTi dUfdVdWidUfg¡dXdY„ ƒZ'dZd[„ Z(ej d\d]ed^d_giƒfd`edagdb�fg¡dcdd„ ƒZ)dedf„ Z*dgdh„ Z+didj„ Z,dkdl„ Z-dmdn„ Z.dodp„ Z/ej 0dq¡drds„ ƒZ1dtdu„ Z2dvdw„ Z3dxdy„ Z4ej dzd{d|d{gd{d|gd}d~d}gd}d~gg¡dd€„ ƒZ5d�d‚„ Z6dƒd„„ Z7ejj8ejj9d…d†„ ƒƒZ:e;j<ejj9d‡dˆ„ ƒƒZ=ejj9d‰dŠ„ ƒZ>ejj?d‹dŒ„ ƒZ@d�dŽ„ ZAe; Bd�¡d�d‘„ ƒZCd’d“„ ZDd”d•„ ZEd–d—„ ZFej d˜d™ej dšd›dšgfdœej gd� fg¡dždŸ„ ƒZGd d¡„ ZHd¢d£„ ZId¤d¥„ ZJd¦d§„ ZKd¨d©„ ZLdªd«„ ZMd¬d­„ ZNd®d¯„ ZOej d°d±d²d|dUgd|d)fd±d³d)d|dUgd)fd±d´d|dUgd|dUgd)fd±dµd|dUgd|d)fd¶d·d)d)d|d*gfd¶d·d)d)d¸d¹„ fg¡dºd»„ ƒZPd¼d½„ ZQd¾d¿„ ZRdÀdÁ„ ZSdÂdÃ„ ZTdÄdÅ„ ZUdÆdÇ„ ZVdÈdÉ„ ZWdÊdË„ ZXd)S )ÌÚTestReadersT©Zautousec                 C  s2   t tj|d�}| |dddƒ¡ | td|¡ dS )zG
        Change directory and set engine for read_excel calls.
        ©r"   r3   r4   ÚexcelÚ
read_excelN)r   ÚpdrM   ÚchdirÚsetattr©Úselfr"   r8   ÚmonkeypatchÚfuncr#   r#   r$   Úcd_and_set_engineš   s    zTestReaders.cd_and_set_enginec           	      C  sŽ   dd„ }|  tjd|¡ ddddddœ}td	| d
ƒ�}t |¡}W d   ƒ n1 sV0    Y  |d urn|}n||dd …  }||ksŠJ ‚d S )Nc                 _  s   | j S r1   rK   )rR   ÚargsÚkwargsr#   r#   r$   Úparser¥   s    z,TestReaders.test_engine_used.<locals>.parserÚparser   r   r   r   ©ÚxlsxZxlsmZxlsbÚxlsZodsÚtest1Úrbé   )rP   rN   Ú	ExcelFileÚopenrM   )	rR   r   r"   rS   rX   Úexpected_defaultsÚfÚresultr>   r#   r#   r$   Útest_engine_used£   s    û(zTestReaders.test_engine_usedc              	   C  s²   ddiddiddiddiddidœ}|dv r8t  d¡}n|d	krLt  d
¡}n
t  d¡}|d ur®tjt|d��2 tjd| dd||dd …  d� W d   ƒ n1 s¤0    Y  d S )NÚfooÚabcdé{   ÚTrueTrZ   >   r   r   z8open_workbook() got an unexpected keyword argument 'foo'r   z/load() got an unexpected keyword argument 'foo'z8load_workbook() got an unexpected keyword argument 'foo'©Úmatchr]   ÚSheet1r   r_   )Ú
sheet_namer7   Zengine_kwargs)ÚreÚescaper&   ÚraisesÚ	TypeErrorrN   rM   )rR   r   r"   rb   Úmsgr#   r#   r$   Útest_engine_kwargs»   s&    û
üzTestReaders.test_engine_kwargsc                 C  s”   d}t jt|d��& tjd| dddd� W d   ƒ n1 s>0    Y  t jt|d��* tjd| dd	gddd
� W d   ƒ n1 s†0    Y  d S )Nz Passing an integer for `usecols`rj   r]   rl   r   é   ©rm   r7   ÚusecolsÚSheet2r_   ©rm   Úskiprowsr7   rv   ©r&   rp   Ú
ValueErrorrN   rM   ©rR   r   rr   r#   r#   r$   Útest_usecols_intÕ   s    ÿ$ûzTestReaders.test_usecols_intc                 C  sv   t ||ƒ |ddg }t|||ƒ tjd| ddg d¢d�}tjd| dd	gdg d¢d
�}t ||¡ t ||¡ d S )NÚBÚCr]   rl   r   )r   é   rt   ru   rw   r_   rx   ©rH   rB   rN   rM   ÚtmÚassert_frame_equal)rR   r/   r"   r   r:   r>   Údf1Údf2r#   r#   r$   Útest_usecols_listç   s    
ÿû	zTestReaders.test_usecols_listc                 C  s  t ||ƒ |g d¢ }t|||ƒ tjd| dddd�}tjd| ddgddd	�}t ||¡ t ||¡ |d
dg }t|||ƒ tjd| dddd�}tjd| ddgddd	�}t ||¡ t ||¡ tjd| dddd�}tjd| ddgddd	�}t ||¡ t ||¡ d S )N©ÚAr~   r   r]   rl   r   zA:Dru   rw   r_   rx   r~   r   zA,C,DzA,C:Dr�   )rR   r/   r"   r   r:   r>   r…   Údf3r#   r#   r$   Útest_usecols_strü   sR    
ÿû	ÿûÿûzTestReaders.test_usecols_strrv   )r   r_   rt   )r   rt   r_   )r_   r   rt   )r_   rt   r   )rt   r   r_   )rt   r_   r   c                 C  sH   t ||ƒ |ddg }t|||ƒ tjd| dd|d�}t ||¡ d S )Nrˆ   r   r]   rl   r   ru   r�   )rR   r/   r"   r   rv   r:   r>   rd   r#   r#   r$   Ú.test_usecols_diff_positional_int_columns_order/  s    
ÿz:TestReaders.test_usecols_diff_positional_int_columns_orderr~   ÚDc                 C  s>   |ddg }t t|ƒƒ|_tjd| d|d�}t ||¡ d S )Nr~   rŒ   r]   rl   ©rm   rv   )ÚrangeÚlenr?   rN   rM   r‚   rƒ   )rR   r   rv   r:   r>   rd   r#   r#   r$   Ú.test_usecols_diff_positional_str_columns_order?  s    z:TestReaders.test_usecols_diff_positional_str_columns_orderc                 C  s>   t ||ƒ |}t|||ƒ tjd| ddd�}t ||¡ d S ©Nr]   rl   r   ©rm   r7   r�   ©rR   r/   r"   r   r:   r>   rd   r#   r#   r$   Útest_read_excel_without_slicingG  s
    
z+TestReaders.test_read_excel_without_slicingc                 C  sH   t ||ƒ |ddg }t|||ƒ tjd| dddd�}t ||¡ d S )Nr   rŒ   r]   rl   r   zA,D:Eru   r�   r“   r#   r#   r$   Útest_usecols_excel_range_strP  s    
ÿz(TestReaders.test_usecols_excel_range_strc                 C  sJ   d}t jt|d��$ tjd| ddd� W d   ƒ n1 s<0    Y  d S )NzInvalid column name: E1rj   r]   rl   zD:E1r�   rz   r|   r#   r#   r$   Ú$test_usecols_excel_range_str_invalid[  s    z0TestReaders.test_usecols_excel_range_str_invalidc                 C  sR   d}t jt|d��, tjd| ddgddgd� W d   ƒ n1 sD0    Y  d S )Nz(list indices must be integers.*, not strrj   r]   rl   rˆ   r   ru   ©r&   rp   rq   rN   rM   r|   r#   r#   r$   Útest_index_col_label_errora  s    üz&TestReaders.test_index_col_label_errorc                 C  s<   t jd| ddd�}tg d¢tg dd�d�}t ||¡ d S )Nr]   ÚSheet3rˆ   r’   )r~   r   rŒ   ÚEÚF©r@   ©Úcolumnsr?   )rN   rM   r   r   r‚   rƒ   ©rR   r   rd   r>   r#   r#   r$   Útest_index_col_strl  s
    ÿzTestReaders.test_index_col_strc                 C  sR   t jd| dg d¢d�}tg d¢tg gd g gd g d¢d�d�}t ||¡ d S )	Nr]   r™   r‡   r’   )rŒ   rš   r›   rt   ©ZlevelsÚcodesÚnamesr�   )rN   rM   r   r   r‚   rƒ   rŸ   r#   r#   r$   Útest_index_col_emptyt  s    ÿþz TestReaders.test_index_col_emptyr7   Nr€   c                 C  sT   t jd| d|d�}tg d¢g d¢gg d¢d�}|rD| |j| ¡}t ||¡ d S )Nr]   ÚSheet4r’   )Úi1ÚaÚx)Úi2ÚbÚy)z
Unnamed: 0Zcol1Zcol2©rž   )rN   rM   r   Ú	set_indexrž   r‚   rƒ   )rR   r   r7   rd   r>   r#   r#   r$   Útest_index_col_with_unnamed  s    
ÿÿz'TestReaders.test_index_col_with_unnamedc                 C  sJ   d}t jt|d��$ tjd| dgd� W d   ƒ n1 s<0    Y  d S )NzEUsecols do not match columns, columns expected but not found: \['E'\]rj   r]   rš   ©rv   rz   r|   r#   r#   r$   Ú%test_usecols_pass_non_existent_column�  s    ÿz1TestReaders.test_usecols_pass_non_existent_columnc                 C  sL   d}t jt|d��& tjd| ddgd� W d   ƒ n1 s>0    Y  d S )Nz['usecols' must either be list-like of all strings, all unicode, all integers or a callable.rj   r]   ZE1r   r¯   rz   r|   r#   r#   r$   Útest_usecols_wrong_type—  s    ÿz#TestReaders.test_usecols_wrong_typec                 C  s8   t jd| dd�}tddggddgd�}t ||¡ d S )	NZtest2rl   ©rm   ZaaaaZbbbbbÚTestZTest1r¬   ©rN   rM   r   r‚   rƒ   )rR   r   Úparsedr>   r#   r#   r$   Útest_excel_stop_iterator   s    z$TestReaders.test_excel_stop_iteratorc                 C  sd   t ||ƒ |dkr.|dkr.| tjjdd�¡ tjd| dd�}ttj	ggdgd	�}t
 ||¡ d S )
Nr   r   z+Calamine can't extract error from ods filesrC   Ztest3rl   r²   r³   r¬   )rH   rE   r&   rF   rG   rN   rM   r   ÚnpÚnanr‚   rƒ   )rR   r/   r"   r   rµ   r>   r#   r#   r$   Útest_excel_cell_error_na¥  s    
ÿz$TestReaders.test_excel_cell_error_nac           	      C  sŽ   t ||ƒ |}t|||ƒ tjd| ddd�}tjd| ddgdd�}t ||¡ t ||¡ tjd| dddd�}t ||jd d	… ¡ d S )
Nr]   rl   r   r’   rw   r_   ©rm   ry   r7   ©rm   r7   Ú
skipfooteréÿÿÿÿ)rH   rB   rN   rM   r‚   rƒ   Úiloc)	rR   r/   r"   r   r:   r>   r„   r…   r‰   r#   r#   r$   Útest_excel_table²  s    
ÿÿzTestReaders.test_excel_tablec                 C  sV  t ||ƒ t||ƒ}t g d¢g d¢g d¢g d¢g d¢ttdddƒtddd	ƒtd
ddƒtdddƒtdddƒgd|› d�d�dœ¡}d}tj|| dd�}t 	||¡ | 
¡ }d|j|jd df< tj|| dd�}t 	||¡ t|jƒD ]2\}	}
tj|| d|	d�}| |
¡}t 	||¡ qè|d  t¡|d< tj|| ddtid�}t 	||¡ d S )N)r_   r€   éýÿÿÿé   r   )g      ô?g      @gHáz®Gý?g¸…ëQ¸þ?g•Ö&è.>)TFTTF)r_   r€   rt   rÁ   é   )r§   rt   ÚcÚdÚeiÝ  é
   é   é   iq  r_   é   é   iß  rt   úM8[ú]©Údtype)ÚIntColÚFloatColÚBoolColÚStrColÚStr2ColZDateColZ
test_typesrl   r²   g      @rÓ   r’   rÒ   ©rm   Ú
converters)rH   r<   r   Ú	from_dictr   r   rN   rM   r‚   rƒ   ÚcopyÚlocr?   Ú	enumeraterž   r­   Úapplyr   )rR   r/   r"   r   rA   r>   ÚbasenameÚactualZfloat_expectedZicolr@   Úexpr#   r#   r$   Útest_reader_special_dtypesÅ  sJ    






û
øúÿ
ÿ
ÿz&TestReaders.test_reader_special_dtypesc              
   C  sz   d}t  g d¢dtjdddgg d¢dtjd	d
dgdœ¡}dd„ dd„ dd„ dd„ dœ}tj|| d|d�}t ||¡ d S )NZtest_converters)r_   r€   rÀ   éüÿÿr   g      )@gÍÌÌÌÌL2@g3333333@g:Œ0âŽy5>)ÚFoundrà   rà   ú	Not foundrà   Ú1Ú3Ú4Ú5)rÏ   rÐ   rÑ   rÒ   c                 S  s   | dkrt | ƒS dS )NÚ rß   )Úint©r¨   r#   r#   r$   Ú<lambda>  ó    z4TestReaders.test_reader_converters.<locals>.<lambda>c                 S  s   | rd|  S t jS )NrÆ   )r·   r¸   rè   r#   r#   r$   ré     rê   c                 S  s   | dkrdS dS )Nræ   rà   rá   r#   rè   r#   r#   r$   ré     rê   c                 S  s   | rt | ƒS dS )Nræ   )r   rè   r#   r#   r$   ré     rê   )rÏ   rÐ   r€   rt   rl   rÔ   )r   rÖ   r·   r¸   rN   rM   r‚   rƒ   )rR   r   rÛ   r>   rÕ   rÜ   r#   r#   r$   Útest_reader_converters÷  s"    üÿ
ü	
ÿz"TestReaders.test_reader_convertersc                 C  sð   d}t  || ¡}tg d¢g d¢g d¢ddtjdgdœƒ}t ||¡ t j|| dd	td
œd�}|d  d¡|d< |d  d	¡|d< t	g d¢dd�|d< t ||¡ d}t
jt|d��& t j|| ddid� W d   ƒ n1 sâ0    Y  d S )NÚ	testdtype©r_   r€   rt   rÁ   ©ç      @ç      @ç      @ç      @ç      ð?ç       @ç      @©r§   rª   rÃ   rÄ   Úfloat64Úfloat32)r§   rª   rÃ   rÍ   r§   rª   ©Z001Z002Z003Z004r   rÃ   z(Unable to convert column d to type int64rj   rÄ   Úint64)rN   rM   r   r·   r¸   r‚   rƒ   r   Úastyper   r&   rp   r{   )rR   r   rÛ   rÜ   r>   rr   r#   r#   r$   Útest_reader_dtype  s(    üÿ	ÿzTestReaders.test_reader_dtypezdtype,expectedrí   rî   ró   rô   rõ   rö   r÷   rø   rÍ   rù   r   râ   Ú2rä   c                 C  s&   d}t j|| |d�}t ||¡ d S )Nrì   rÍ   ©rN   rM   r‚   rƒ   )rR   r   rÎ   r>   rÛ   rÜ   r#   r#   r$   Útest_reader_dtype_str.  s    z!TestReaders.test_reader_dtype_strc                   s¸  |dv rt  d|› d�¡ ttddgdd�tdd	gd
d�tddgdd�tddgdd�ttjdgdd�ttjdgd
d�ttjdgdd�ttjdgdd�tt d¡gd ƒttjtjgdd�dœ
ƒ‰t |¡�0}ˆj	|ddd� tj
|d|d�}W d   ƒ n1 �s0    Y  |dk�r€dd l‰ddlm‰  t‡ ‡‡fdd„ˆjD ƒƒ}ˆ |d jj ˆjdd �¡ƒ|d< ˆ ˆ d d g¡ƒ|d!< n(ˆ}t||ƒ}|d  d"|› d#�¡|d< t ||¡ d S )$N©r   r   úNo engine for filetype: 'ú'r_   rt   ZInt64rÍ   rï   rñ   ZFloat64TFÚbooleanr§   rª   Ústringé   g      @z
2019-12-31r€   )
r§   rª   rÃ   rÄ   rÅ   rc   ÚgÚhÚiÚjÚtest©rm   r?   ©rm   Údtype_backendÚpyarrowr   )ÚArrowExtensionArrayc                   s$   i | ]}|ˆ ˆj ˆ| d d�ƒ“qS )T)Zfrom_pandas)Úarray)r+   Úcol©r  ÚdfÚpar#   r$   Ú
<dictcomp>n  s   ÿz2TestReaders.test_dtype_backend.<locals>.<dictcomp>r  Úus)rA   r	  rË   rÌ   )r&   Úskipr   r   rN   ÚNAÚ	Timestampr‚   Úensure_cleanÚto_excelrM   r  Zpandas.arraysr  rž   r  Z	_pa_arrayÚcastÚ	timestampr<   rû   rƒ   )rR   r   r  r"   Ú	file_pathrd   r>   rA   r#   r  r$   Útest_dtype_backendP  sH    öÿÿ&
þÿÿ
zTestReaders.test_dtype_backendc                 C  s�   |dv rt  d|› d�¡ ttjdgdtjgdœƒ}t |¡�2}|j|ddd	� tj	|dd
dd�}W d   ƒ n1 sv0    Y  t 
||¡ d S )Nr   r  r  ró   rï   ©r§   rª   r
  Fr  Únumpy_nullabler÷   )rm   r  rÎ   )r&   r  r   r·   r¸   r‚   r  r  rN   rM   rƒ   )rR   r   r  r  rd   r#   r#   r$   Útest_dtype_backend_and_dtype€  s    ü$z(TestReaders.test_dtype_backend_and_dtypec              	   C  s  |dv rt  d|› d�¡ t d|¡�Ì ttjddgtjd�tjdtjgtjd�d	œƒ}t	 
|¡�0}|j|d
dd� tj|d
dd�}W d   ƒ n1 s˜0    Y  ttddgt |¡d�tdd gt |¡d�d	œƒ}t	j||dd� W d   ƒ n1 sø0    Y  d S )Nr   r  r  zmode.string_storager§   rª   rÍ   r¨   r   r
  Fr  r!  r  )Zcheck_column_type)r&   r  rN   Úoption_contextr   r·   r  Zobject_r  r‚   r  r  rM   r   ZStringDtyperƒ   )rR   r   Zstring_storager  r  rd   r>   r#   r#   r$   Útest_dtype_backend_string�  s&    þÿÿ$þÿz%TestReaders.test_dtype_backend_stringzdtypes, exp_valuer_   úa.1rú   c           	      C  st   d}dt i|¥}| ¡ }tj|| |d�}ttdgt d�t|g|sFt nd d�dœƒ}||ksdJ dƒ‚t ||¡ d S )NZdf_mangle_dup_col_dtypesr§   rÍ   r_   )r§   r%  zdtype dict changed)Úobjectr×   rN   rM   r   r   r‚   rƒ   )	rR   r   ZdtypesZ	exp_valuerÛ   Z
dtype_dictZdtype_dict_copyrd   r>   r#   r#   r$   Útest_dtype_mangle_dup_cols­  s    þÿz&TestReaders.test_dtype_mangle_dup_colsc                 C  s2   d}t  || ¡}tdg d¢iƒ}t ||¡ d S )NZtest_spacesZtestcol)zthis is greatz4    spacesz1 trailing z
 1 leadingz2  spaces  multiple  timesr´   )rR   r   rÛ   rÜ   r>   r#   r#   r$   Útest_reader_spaces¾  s    ÿÿzTestReaders.test_reader_spaceszbasename,expectedzgh-35802ZCOLUMNzTest (1)zgh-36122z
got 2nd sar¬   c                 C  s6   |dkrt  d|› �¡ t || ¡}t ||¡ d S )Nr   zSkipped for engine: )r&   r  rN   rM   r‚   rƒ   )rR   r"   r   rÛ   r>   rÜ   r#   r#   r$   Útest_read_excel_ods_nested_xmlÑ  s    	z*TestReaders.test_read_excel_ods_nested_xmlc                 C  sF   d}t j|| d d�}g d¢}t || ¡ ¡ |t| ¡ ƒksBJ ‚d S )NÚtest_multisheetr²   )ÚCharlieÚAlphaÚBeta)rN   rM   r‚   Úassert_contains_allÚkeysÚlist©rR   r   rÛ   ÚdfsÚexpected_keysr#   r#   r$   Útest_reading_all_sheetsà  s
    z#TestReaders.test_reading_all_sheetsc                 C  sV   d}g d¢}t j|| |d�}tt|ƒƒ}t || ¡ ¡ t|ƒt| ¡ ƒksRJ ‚d S )Nr*  )r€   r+  r+  r²   )rN   rM   r0  Úsetr‚   r.  r/  r�   )rR   r   rÛ   r3  r2  r#   r#   r$   Ú%test_reading_multiple_specific_sheetsí  s    z1TestReaders.test_reading_multiple_specific_sheetsc                 C  s2   d}t j|| d d�}g d¢}t || ¡ ¡ d S )NÚblank_with_headerr²   )rl   rw   r™   )rN   rM   r‚   r.  r/  r1  r#   r#   r$   Ú"test_reading_all_sheets_with_blankû  s    z.TestReaders.test_reading_all_sheets_with_blankc                 C  s$   t jd| dd�}t |tƒ ¡ d S )NÚblankrl   r²   )rN   rM   r‚   rƒ   r   )rR   r   rÜ   r#   r#   r$   Útest_read_excel_blank  s    z!TestReaders.test_read_excel_blankc                 C  s0   t ddgd�}tjd| dd�}t ||¡ d S )NZcol_1Zcol_2r¬   r7  rl   r²   )r   rN   rM   r‚   rƒ   )rR   r   r>   rÜ   r#   r#   r$   Ú!test_read_excel_blank_with_header	  s    z-TestReaders.test_read_excel_blank_with_headerc                 C  sŽ   t jtdd��& tjd| dgd d� W d   ƒ n1 s:0    Y  t jtdd��( tjd| dd„ d d	� W d   ƒ n1 s€0    Y  d S )
Nz \(sheet: Sheet1\)$rj   r7  r_   )Úheaderrm   r]   c                 S  s   dd S )Nr_   r   r#   rè   r#   r#   r$   ré     rê   zHTestReaders.test_exception_message_includes_sheet_name.<locals>.<lambda>)rv   rm   )r&   rp   r{   rN   rM   ÚZeroDivisionError©rR   r   r#   r#   r$   Ú*test_exception_message_includes_sheet_name  s    4z6TestReaders.test_exception_message_includes_sheet_namez-ignore:Cell A4 is marked:UserWarning:openpyxlc                 C  s–   t ||ƒ tt d¡dgt d¡dgddggddgd	�}|d
krT| tjjdd�¡ |d u rx|dv rx| tjjdd�¡ t d| ¡}t	 
||¡ d S )Nz
2016-03-12zMarc Johnsonz
2016-03-16z
Jack Blackg@Œµx¯DzTimothy BrownZDateColWithBigIntZ	StringColr¬   r   zMaybe not supported by openpyxlrC   )r   r   z)Defaults to openpyxl, maybe not supportedZtestdateoverflow)rH   r   rN   r  rE   r&   rF   rG   rM   r‚   rƒ   )rR   r/   r"   r   r>   rd   r#   r#   r$   Útest_date_conversion_overflow  s$    
ýú	ÿÿz)TestReaders.test_date_conversion_overflowc           
      C  sf   t ||ƒ d}d}|}t|||ƒ tj|| |dd�}tj|| d|d�}	t ||¡ t |	|¡ d S ©Nr]   rl   r   r’   )r7   rm   r�   )
rR   r/   r   r"   r:   Úfilenamerm   r>   r„   r…   r#   r#   r$   Útest_sheet_name1  s    

ÿzTestReaders.test_sheet_namec                 C  sb   d| }t j|ddd�}t|dƒ�,}t j|ddd�}t ||¡ W d   ƒ n1 sT0    Y  d S )Nr]   rl   r   r’   r^   )rN   rM   ra   r‚   rƒ   )rR   r   Úpthr>   rc   rÜ   r#   r#   r$   Útest_excel_read_bufferB  s
    z"TestReaders.test_excel_read_bufferc                 C  sD   d}t jtdd�� tjd|d� W d   ƒ n1 s60    Y  d S )Nrf   zUnknown engine: foorj   ræ   rK   rz   )rR   Z
bad_enginer#   r#   r$   Útest_bad_engine_raisesI  s    z"TestReaders.test_bad_engine_raisesrm   rt   r   r¥   rl   c                 C  sH   d}t jt|d��" tjd| |d� W d   ƒ n1 s:0    Y  d S ©Nz?Worksheet index 3 is invalid|Worksheet named 'Sheet4' not foundrj   r9  r²   rz   )rR   r   rm   rr   r#   r#   r$   Útest_bad_sheetname_raisesN  s    z%TestReaders.test_bad_sheetname_raisesc                 C  sT   d|› �}d  g d¢¡}tjt|d�� t |¡ W d   ƒ n1 sF0    Y  d S )Nrf   ú|)z(No such file or directoryu   æ²¡æœ‰é‚£ä¸ªæ–‡ä»¶æˆ–ç›®å½•zFile o directory non esistente)rj   )Újoinr&   rp   ÚFileNotFoundErrorrN   rM   )rR   r   Zbad_filerk   r#   r#   r$   Útest_missing_file_raisesX  s    
ÿz$TestReaders.test_missing_file_raisesc                 C  sš   d}|d u rt }d}nD|dkr4ddlm} |}d}n&|dkrRddlm} |}d	}nt}d
}tj||d�� t 	t
|ƒ¡ W d   ƒ n1 sŒ0    Y  d S )Ns   foozLExcel file format cannot be determined, you must specify an engine manually.r   r   )Ú	XLRDErrorzFUnsupported format, or corrupt file: Expected BOF record; found b'foo'r   ©ÚCalamineErrorzCannot detect file formatzFile is not a zip filerj   )r{   r   rM  r   rO  r	   r&   rp   rN   rM   r   )rR   r"   Z
bad_streamÚerrorrr   rM  rO  r#   r#   r$   Útest_corrupt_bytes_raisese  s$    ÿÿz%TestReaders.test_corrupt_bytes_raisesc                 C  sh   t d| dƒ� }|j| ¡ d� W d   ƒ n1 s40    Y  t |j¡}t d| ¡}t ||¡ d S )Nr]   r^   )Úcontent)ra   Zserve_contentÚreadrN   rM   Úurlr‚   rƒ   )rR   Z
httpserverr   rc   Ú	url_tableÚlocal_tabler#   r#   r$   Útest_read_from_http_url€  s
    .z#TestReaders.test_read_from_http_urlc                 C  s~   t d| dƒ�"}|jd| |d� W d   ƒ n1 s60    Y  d|j› d�| }tj||d�}t d| ¡}t ||¡ d S )Nr]   r^   ©ÚKeyZBodyús3://ú/test1)Zstorage_options)ra   Ú
put_objectr@   rN   rM   r‚   rƒ   )rR   r   Ús3_public_bucketÚs3sorc   rT  rU  rV  r#   r#   r$   Útest_read_from_s3_url‰  s    0z!TestReaders.test_read_from_s3_urlc           	      C  s¸   t d| dƒ�"}|jd| |d� W d   ƒ n1 s60    Y  dd l}|jf i |¤Ž}|  d|j› d�| ¡�}t |¡}W d   ƒ n1 s�0    Y  t d| ¡}t ||¡ d S )Nr]   r^   rX  r   rZ  r[  )	ra   r\  Ús3fsZS3FileSystemr@   rN   rM   r‚   rƒ   )	rR   r   r]  r^  rc   r`  Zs3rU  rV  r#   r#   r$   Útest_read_from_s3_object–  s    0(z$TestReaders.test_read_from_s3_objectc                 C  s|   t j |dddƒd| ¡}t |¡}zt d| ¡}W n4 tyj   d t ¡ ¡ ¡ }t	 
d|› �¡ Y n0 t ||¡ d S )Nr3   r4   rL   r]   zfile://localhost/ú zfailing on )ÚosÚpathrJ  rN   rM   r   ÚplatformÚunameÚstripr&   r  r‚   rƒ   )rR   r   r8   Z
localtablerV  rU  Zplatform_infor#   r#   r$   Útest_read_from_file_url§  s    
z#TestReaders.test_read_from_file_urlc                 C  sD   d| }t j|ddd�}td| ƒ}t j|ddd�}t ||¡ d S r‘   )rN   rM   r   r‚   rƒ   )rR   r   Ústr_pathr>   Úpath_objrÜ   r#   r#   r$   Útest_read_from_pathlib_path¶  s
    z'TestReaders.test_read_from_pathlib_pathzpy.pathc                 C  s\   ddl m} tj d| ¡}tj|ddd�}|ƒ  d| ¡}tj|ddd�}t ||¡ d S )Nr   )Úlocalr]   rl   r’   )	Zpy.pathrl  rc  rd  rJ  rN   rM   r‚   rƒ   )rR   r   Z	LocalPathri  r>   rj  rÜ   r#   r#   r$   Útest_read_from_py_localpathÀ  s    z'TestReaders.test_read_from_py_localpathc                 C  sX   t j d| ¡}t|dƒ�*}tj|ddd�}~| ¡  W d   ƒ n1 sJ0    Y  d S )Nr]   r^   rl   r   r’   )rc  rd  rJ  ra   rN   rM   rS  )rR   r   ri  rc   r¨   r#   r#   r$   Útest_close_from_py_localpathÍ  s
    z(TestReaders.test_close_from_py_localpathc                 C  sü   t ||ƒ |dkr.|dkr.| tjjdd�¡ t dtdddƒtdd	d
dƒtddddƒtddddƒtddddƒtddddƒtddddƒtddd d!ƒtd d"dd#ƒtd$d%d&d'ƒtd(d)d*ƒgi¡}tj	d+| d,d-�}t
 ||¡ tj	d.| d,d-�}t
 ||¡ d S )/Nr   r   z0ODS file contains bad datetime (seconds as text)rC   ZTimer_   r€   rt   é-   é8   i † rÁ   é   é1   i@ r  é   é*   ià“ é   é9   é#   i€ é	   é)   é   i ¡ é   é   é   iÀ'	 rÊ   i`®
 é5   i 5 é   é%   r   i » é   é   é6   Z
times_1900rl   r²   Z
times_1904)rH   rE   r&   rF   rG   r   rÖ   r   rN   rM   r‚   rƒ   )rR   r/   r"   r   r>   rÜ   r#   r#   r$   Útest_reader_secondsÖ  s6    
ÿÿ

õÿÿzTestReaders.test_reader_secondsc           	   	   C  sJ  t ||ƒ t||ƒ}t ddgddgg¡}d| }tddt d¡d	gd
dt d¡dgddt d¡dgddt d¡d	gg|d�}||d
   d|› d�¡||d
 < tj|dddgdd�}t	 
||¡ ||_g d¢|_tj|dddgd�}t	 
||¡ ||_tj|dddgddgd�}t	 
||¡ g d¢|_| dd g¡|_tj|d!ddgd�}t	 
||¡ ttdƒƒ|_| d"d#g¡|_tj|d$ddgdd�}t	 
||¡ |jdd
gdd%� d"d#g¡|_tj|d&dddgd�}t	 
||¡ | d"d#g¡|_| dd g¡|_tj|d'ddgddgd�}t	 
||¡ tj|d(ddgddgd
d)�}t	 
||¡ d S )*Nrf   Úbarr§   rª   Útestmultiindexr_   rï   ú
2015-01-01Tr€   rð   ú
2015-01-02Frt   rñ   ú
2015-01-03rÁ   rò   ú
2015-01-04r¬   rË   rÌ   Ú	mi_columnr   )rm   r<  r7   rö   Úmi_indexr’   Úboth©rm   r7   r<  Úilvl1Úilvl2Zmi_index_nameÚc1Úc2Úmi_column_name)ÚlevelZname_with_intZ	both_nameZboth_name_skiprows)rm   r7   r<  ry   )rH   r<   r   Úfrom_productr   rN   r  rû   rM   r‚   rƒ   r?   rž   Z	set_namesr0  rŽ   Z
set_levels)	rR   r/   r"   r   rA   ÚmiÚmi_filer>   rÜ   r#   r#   r$   Útest_read_excel_multiindexú  sn    

üù	"ÿ
ÿ
ÿÿÿûz&TestReaders.test_read_excel_multiindexzsheet_name,idx_lvl2Zboth_name_blank_after_mi_namerª   r§   Zboth_name_multiple_blanksrÁ   c              	   C  sê   t ||ƒ d| }tjddgddggddgd�}t||ƒ}td	d
t d¡dgddt d¡dgddt d¡dgddt d¡dgg|tjg d¢|fddgd�d�}	|	|d   d|› d�¡|	|d < tj	||dd	gdd	gd�}
t
 |
|	¡ d S )Nr†  rf   r…  r§   rª   r‘  r’  ©r£   r_   rï   r‡  Tr€   rð   rˆ  Frt   rñ   r‰  rÁ   rò   rŠ  )rf   rf   r…  r…  r�  r�  r�   rË   rÌ   r   rŽ  )rH   r   r•  r<   r   rN   r  Úfrom_arraysrû   rM   r‚   rƒ   )rR   r/   r"   r   rm   Zidx_lvl2r—  r–  rA   r>   rd   r#   r#   r$   Ú+test_read_excel_multiindex_blank_after_nameN  s0    

ü
þø"üz7TestReaders.test_read_excel_multiindex_blank_after_namec                 C  sP   d| }t j|dddgd�}t ddg¡}tg d¢gd	 |d
�}t ||¡ d S )Nr†  Úindex_col_noner   r_   ©rm   r<  ©rˆ   r~   ©ÚkeyÚvalrí   r€   r¬   )rN   rM   r   r•  r   r‚   rƒ   )rR   r   r—  rd   Zexp_columnsr>   r#   r#   r$   Ú&test_read_excel_multiindex_header_onlyv  s
    z2TestReaders.test_read_excel_multiindex_header_onlyc           	      C  sš  d| }t jt jt jt jt jt jgg d¢g d¢g d¢g d¢g d¢gtd�}g d¢}tg d	¢g d
¢gg d¢g d¢gd d gd�}tg d	¢d d�}t|||d�}tj|ddd�}t	 
||¡ ||_tj|dddgd�}t	 
||¡ t  g d¢g d¢g d¢g d¢g d¢g¡}g d¢}tg d¢g d¢gg d¢g d¢gd d gd�}tg d¢d d�}t|||d�}tj|ddd�}t	 
||¡ ||_tj|dddgd�}t	 
||¡ d S )NZtest_index_name_pre17)ZR0C0ZR0C1ZR0C2ZR0C3ZR0C4)ZR1C0ZR1C1ZR1C2ZR1C3ZR1C4)ZR2C0ZR2C1ZR2C2ZR2C3ZR2C4)ZR3C0ZR3C1ZR3C2ZR3C3ZR3C4)ZR4C0ZR4C1ZR4C2ZR4C3ZR4C4rÍ   )ZC_l0_g0ZC_l0_g1ZC_l0_g2ZC_l0_g3ZC_l0_g4)ZR0ÚR_l0_g0ÚR_l0_g1ÚR_l0_g2ÚR_l0_g3ÚR_l0_g4)ZR1ÚR_l1_g0ÚR_l1_g1ÚR_l1_g2ÚR_l1_g3ÚR_l1_g4)r   r_   r€   rt   rÁ   rÂ   r¡   rœ   ©r?   rž   Zsingle_namesr   r’   Zmulti_namesr_   )r£  r¤  r¥  r¦  r§  )r¨  r©  rª  r«  r¬  )r   r_   r€   rt   rÁ   Zsingle_no_namesZmulti_no_names)r·   r  r¸   r&  r   r   r   rN   rM   r‚   rƒ   r?   )	rR   r   rB  r4   rž   r–  Úsir>   rÜ   r#   r#   r$   Útest_excel_old_index_format�  sf    ú÷þúÿûÿ	þúz'TestReaders.test_excel_old_index_formatc              	   C  sR   d}dD ]D}t jt|d��" tjd| |d� W d   ƒ q1 sB0    Y  qd S )Nz#Passing a bool to header is invalid)TFrj   r]   ©r<  r—   )rR   r   rr   Úargr#   r#   r$   Útest_read_excel_bool_header_argÊ  s    z+TestReaders.test_read_excel_bool_header_argc              	   C  st  t ||ƒ t||ƒ}tjd| dddgd�}tddt d¡d	gdd
t d¡dgddt d¡dgddt d¡d	ggg d¢d�}|d  d|› d�¡|d< t ||¡ tjd| dt	 
ddg¡d�}t ||¡ tjd| ddd„ d�}t ||¡ tjd| ddg d¢d�}tdd
t d¡dgddt d¡dgddt d¡d	ggg d¢d�}|d  d|› d�¡|d< t ||¡ d S )NÚtestskiprowsÚskiprows_listr   r€   ©rm   ry   r_   rï   r‡  Trð   rˆ  Frt   rñ   r‰  rÁ   rò   rŠ  rö   r¬   rÃ   rË   rÌ   c                 S  s   | dv S ©N)r   r€   r#   rè   r#   r#   r$   ré   ñ  rê   z6TestReaders.test_read_excel_skiprows.<locals>.<lambda>)rm   ry   r£   )rH   r<   rN   rM   r   r  rû   r‚   rƒ   r·   r  ©rR   r/   r"   r   rA   rÜ   r>   r#   r#   r$   Útest_read_excel_skiprowsÑ  sT    

ÿüù	ýýüüù	z$TestReaders.test_read_excel_skiprowsc                 C  s†   t ||ƒ t||ƒ}tjd| ddd„ d�}tddt d¡d	gd
dt d¡dggg d¢d�}|d  d|› d�¡|d< t ||¡ d S )Nr³  r´  c                 S  s   | dvS )N)r_   rt   rÂ   r#   rè   r#   r#   r$   ré     rê   zFTestReaders.test_read_excel_skiprows_callable_not_in.<locals>.<lambda>rµ  r_   rï   r‡  Trt   rñ   r‰  Frö   r¬   rÃ   rË   rÌ   )	rH   r<   rN   rM   r   r  rû   r‚   rƒ   r·  r#   r#   r$   Ú(test_read_excel_skiprows_callable_not_in  s    

ýýù	z4TestReaders.test_read_excel_skiprows_callable_not_inc                 C  s@   d}t jd| |d�}t  d| ¡}|d |… }t ||¡ d S )NrÂ   r]   ©Únrowsrþ   )rR   r   Únum_rows_to_pullrÜ   r>   r#   r#   r$   Útest_read_excel_nrows  s
    z!TestReaders.test_read_excel_nrowsc                 C  s@   t  d| ¡}t|ƒ}|d }t jd| |d�}t ||¡ d S )Nr]   rÆ   rº  )rN   rM   r�   r‚   rƒ   )rR   r   r>   Znum_records_in_filer¼  rÜ   r#   r#   r$   Ú0test_read_excel_nrows_greater_than_nrows_in_file%  s
    z<TestReaders.test_read_excel_nrows_greater_than_nrows_in_filec                 C  sH   d}t jt|d��" tjd| dd� W d   ƒ n1 s:0    Y  d S )Nz'nrows' must be an integer >=0rj   r]   rå   rº  rz   r|   r#   r#   r$   Ú+test_read_excel_nrows_non_integer_parameter-  s    z7TestReaders.test_read_excel_nrows_non_integer_parameterz-filename,sheet_name,header,index_col,skiprowsr†  r‹  rŒ  r�  r“  r³  r´  c                 C  s   | dv S r¶  r#   rè   r#   r#   r$   ré   ;  rê   zTestReaders.<lambda>c           	      C  sL   t j|| ||||d�jdd… }t j|| ||||dd�}t ||¡ dS )z—
        For various parameters, we should get the same result whether we
        limit the rows during load (nrows=3) or after (df.iloc[:3]).
        )rm   r<  r7   ry   Nrt   )rm   r<  r7   ry   r»  )rN   rM   r¾   r‚   rƒ   )	rR   r   rB  rm   r<  r7   ry   r>   rÜ   r#   r#   r$   Útest_read_excel_nrows_params3  s$    ûúúz(TestReaders.test_read_excel_nrows_paramsc                 C  sD   t jtdd��" t d| dd¡ W d   ƒ n1 s60    Y  d S )Nzbut 3 positional argumentsrj   r]   rl   r   r—   r>  r#   r#   r$   Útest_deprecated_kwargsW  s    z"TestReaders.test_deprecated_kwargsc                 C  sV   d| }g d¢}t jg d¢dd�}t||dd�}tj|dd	d
gd d�}t ||¡ d S )Nr†  ))r~   r~   rŸ  ©rt   rÁ   rÂ  ))rˆ   rˆ   rŸ  ©r_   r€   rÃ  )r   r_   r™  )r€   rt   r­  rœ  r   r_   rŽ  )r   Úfrom_tuplesr   rN   rM   r‚   rƒ   )rR   r   Ú	file_namer4   Úidxr>   rd   r#   r#   r$   Ú"test_no_header_with_list_index_col[  s    ÿÿz.TestReaders.test_no_header_with_list_index_colc                 C  s>   d| }dt jddg}t|dgd�}t |¡}t ||¡ d S )NZone_col_blank_lineg      à?r_   r€   Únumbersr¬   )r·   r¸   r   rN   rM   r‚   rƒ   )rR   r   rÅ  r4   r>   rd   r#   r#   r$   Útest_one_col_noskip_blank_lineh  s
    
z*TestReaders.test_one_col_noskip_blank_linec                 C  sj   d| }t  ddg¡}tjtjgtjtjgddgddgg}t||d�}tj|d	d
dgd�}t ||¡ d S )Nr†  )r§   rˆ   )rª   r~   r_   rt   r€   rÁ   r¬   Zmi_column_empty_rowsr   r�  )	r   rÄ  r·   r¸   r   rN   rM   r‚   rƒ   )rR   r   rÅ  rž   r4   r>   rd   r#   r#   r$   Ú test_multiheader_two_blank_linesp  s    $
ÿz,TestReaders.test_multiheader_two_blank_linesc                 C  s$   d| }t  |¡}|jdks J ‚dS )z›
        Sheets can contain blank cells with no data. Some of our readers
        were including those cells, creating many empty rows and columns
        Ztrailing_blanks)rt   rt   N)rN   rM   Úshape)rR   r   rÅ  rd   r#   r#   r$   Útest_trailing_blanks{  s    
z TestReaders.test_trailing_blanksc                 C  sr   |dkrt  d¡ |dkr.| t jjdd�¡ t jtdd��" tjd| d	d
� W d   ƒ n1 sd0    Y  d S )Nr   ú*chartsheets do not exist in the ODF formatr   ú4pyxlsb can't distinguish chartsheets from worksheetsrC   z"Worksheet named 'Chart1' not foundrj   Ú
chartsheetZChart1r²   ©	r&   r  rE   rF   rG   rp   r{   rN   rM   ©rR   r/   r"   r   r#   r#   r$   Útest_ignore_chartsheets_by_str„  s    
ÿÿz*TestReaders.test_ignore_chartsheets_by_strc                 C  sr   |dkrt  d¡ |dkr.| t jjdd�¡ t jtdd��" tjd| d	d
� W d   ƒ n1 sd0    Y  d S )Nr   rÍ  r   rÎ  rC   z0Worksheet index 1 is invalid, 1 worksheets foundrj   rÏ  r_   r²   rÐ  rÑ  r#   r#   r$   Útest_ignore_chartsheets_by_int‘  s    
ÿÿÿz*TestReaders.test_ignore_chartsheets_by_intc                 C  sF   t jd| ddd�}tg d¢g d¢g d¢gg d¢d	�}t ||¡ d S )
NZtest_decimalú,r_   )Údecimalry   )r_   gAñcÌ�Ä—@gÕ	h¢ïÖAÚABCZpoig2Ø[j‡ô@)r€   gHáz®G^@g{®GáÍ@ZDEFZuytg¥Uq&Ø?)rt   g%�•Cq‹@gçû©ñÖ^ú@ZGHIZrezgÈ)¬ç³â@)ZIdZNumber1ZNumber2ZText1ZText2ZNumber3r¬   r´   rŸ   r#   r#   r$   Útest_euro_decimal_format   s    ýúz$TestReaders.test_euro_decimal_format)YÚ__name__Ú
__module__Ú__qualname__r&   ÚfixturerU   re   rs   r}   r†   rŠ   rF   Úparametrizer‹   r�   r”   r•   r–   r˜   r    r¤   r®   r°   r±   r¶   r¹   r¿   rÞ   rë   rü   r   r·   r¸   r   r   rÿ   r  r"  r$  r'  r(  r)  r4  r6  r8  r:  r;  r?  Úfilterwarningsr@  rC  rE  rF  rH  rL  rQ  ÚnetworkÚ
single_cpurW  ÚtdZskip_if_not_us_localer_  ra  Zslowrh  rk  Ú
skip_if_norm  rn  r„  r˜  r›  r¢  r¯  r²  r¸  r¹  r½  r¾  r¿  rÀ  rÁ  rÇ  rÉ  rÊ  rÌ  rÒ  rÓ  r×  r#   r#   r#   r$   rI   ™   s
  

3(ÿ

	

	2üÿþüÿþôþ
0
þþ



þ




	$Tþþ
!I6úþ
	rI   c                
   @  sþ   e Zd Zdd„ Zejdd�dd„ ƒZdd„ Zd	d
„ Zej	 
dg d¢¡dd„ ƒZdd„ Zdd„ Zej	 
ddddgddgdddgddgg¡dd„ ƒZdd„ Zdd„ Zdd„ Zd d!„ Zd"d#„ Zd$d%„ Zej	 
d&d'd(g¡d)d*„ ƒZd+d,„ Zd-d.„ Zd/d0„ Zd1d2„ Zd3S )4ÚTestExcelFileReadc              	   C  sx   d}t jt|dd��P td| dƒ�"}tj| ¡ |d� W d   ƒ n1 sL0    Y  W d   ƒ n1 sj0    Y  d S )Nz�Passing bytes to 'read_excel' is deprecated and will be removed in a future version. To read from a byte string, wrap it in a `BytesIO` object.F)rk   Zraise_on_extra_warningsr]   r^   rK   )r‚   Úassert_produces_warningÚFutureWarningra   rN   rM   rS  )rR   r"   r   rr   rc   r#   r#   r$   Útest_deprecate_bytes_input¯  s    ÿÿz,TestExcelFileRead.test_deprecate_bytes_inputTrJ   c                 C  s2   t tj|d�}| |dddƒ¡ | td|¡ dS )zH
        Change directory and set engine for ExcelFile objects.
        rK   r3   r4   rL   r`   N)r   rN   r`   rO   rP   rQ   r#   r#   r$   rU   ½  s    z#TestExcelFileRead.cd_and_set_enginec                 C  sr   ddddddœ}t  d| ¡�}|j}W d   ƒ n1 s:0    Y  |d urR|}n||dd …  }||ksnJ ‚d S )Nr   r   r   r   rZ   r]   r_   )rN   r`   r"   )rR   r   r"   rb   rL   rd   r>   r#   r#   r$   re   Æ  s    û$z"TestExcelFileRead.test_engine_usedc                 C  sØ  t  d| ¡�$}t j|dddgd�}W d   ƒ n1 s80    Y  tdgdgdgtjgdggd	gd
�}t ||¡ t  d| ¡�$}t j|dddgd�}W d   ƒ n1 sª0    Y  ttjgdgtjgtjgdggd	gd
�}t ||¡ t  d| ¡�$}t j|dddgd�}W d   ƒ n1 �s"0    Y  tdgdgdgtjgdggd	gd
�}t ||¡ t  d| ¡�$}t j|dddgd�}W d   ƒ n1 �s–0    Y  ttjgdgtjgtjgdggd	gd
�}t ||¡ d S )NZtest4rl   FÚapple©rm   Zkeep_default_naZ	na_valuesr  r_   Úrabbitr³   r¬   TÚtest5ú1.#QNANr¸   )rN   r`   rM   r   r·   r¸   r‚   rƒ   )rR   r   rL   rµ   r>   r#   r#   r$   Útest_excel_passes_naØ  s@    
ÿ$ÿ
ÿ$ ÿ
ÿ&ÿ
ÿ& ÿz&TestExcelFileRead.test_excel_passes_naÚ	na_filter)NTFc                 C  s¼   i }|d ur||d< t  d| ¡�,}t j|fdddgdœ|¤Ž}W d   ƒ n1 sT0    Y  |du r€dgd	gd
gdgdgg}ntjgd	gtjgtjgdgg}t|dgd�}t ||¡ d S )Nrì  ré  rl   Træ  rç  Frê  r_   r¸   rè  r³   r¬   )rN   r`   rM   r·   r¸   r   r‚   rƒ   )rR   r   rì  rW   rL   rµ   r>   r#   r#   r$   Útest_excel_passes_na_filterþ  s$    ÿüû$z-TestExcelFileRead.test_excel_passes_na_filterc           
      C  sœ  t ||ƒ |}t|||ƒ t d| ¡�4}tj|ddd�}tj|ddgdd�}W d   ƒ n1 sb0    Y  t ||¡ t ||¡ t d| ¡�0}|jddd�}|jddgdd�}W d   ƒ n1 sÈ0    Y  t ||¡ t ||¡ t d| ¡�"}tj|dddd�}	W d   ƒ n1 �s"0    Y  t |	|jd d	… ¡ t d| ¡� }|jdddd
�}	W d   ƒ n1 �sx0    Y  t |	|jd d	… ¡ d S )Nr]   r   r’   r_   rº   )r7   )ry   r7   r»   r½   )r7   r¼   )	rH   rB   rN   r`   rM   r‚   rƒ   rY   r¾   )
rR   r/   r"   r   r:   r>   rL   r„   r…   r‰   r#   r#   r$   Útest_excel_table_sheet_by_index  s&    
2020z1TestExcelFileRead.test_excel_table_sheet_by_indexc                 C  s¶   t ||ƒ |}t|||ƒ d}d}t || ¡�}|j|dd�}	W d   ƒ n1 sT0    Y  t || ¡�}|jd|d�}
W d   ƒ n1 s�0    Y  t |	|¡ t |
|¡ d S rA  )rH   rB   rN   r`   rY   r‚   rƒ   )rR   r/   r"   r   r:   r>   rB  rm   rL   Z	df1_parseZ	df2_parser#   r#   r$   rC  2  s    
,,z!TestExcelFileRead.test_sheet_namerm   rt   r   r¥   rl   c              	   C  sp   d}t jt|d��J t d| ¡�}|j|d� W d   ƒ n1 sD0    Y  W d   ƒ n1 sb0    Y  d S rG  )r&   rp   r{   rN   r`   rY   )rR   r   rm   rr   rL   r#   r#   r$   rH  D  s    z+TestExcelFileRead.test_bad_sheetname_raisesc              	   C  sŽ   d| }t j|dd|d�}t|dƒ�J}t  |¡� }t j|ddd�}W d   ƒ n1 sV0    Y  W d   ƒ n1 st0    Y  t ||¡ d S )Nr]   rl   r   ©rm   r7   r"   r^   r’   )rN   rM   ra   r`   r‚   rƒ   )rR   r"   r   rD  r>   rc   r\   rÜ   r#   r#   r$   rE  O  s    Lz(TestExcelFileRead.test_excel_read_bufferc              	   C  sx   t d| dƒ�L}t |¡�"}tj|dd|d� W d   ƒ n1 sB0    Y  W d   ƒ n1 s`0    Y  |jstJ ‚d S )Nr]   r^   rl   r   rï  )ra   rN   r`   rM   Úclosed)rR   r"   r   rc   r[   r#   r#   r$   Útest_reader_closes_fileY  s    Nz)TestExcelFileRead.test_reader_closes_filec              	   C  sr   d}t  d| ¡�L}tjt|d�� t j|dd� W d   ƒ n1 sF0    Y  W d   ƒ n1 sd0    Y  d S )Nz8Engine should not be specified when passing an ExcelFiler]   rj   rf   rK   )rN   r`   r&   rp   r{   rM   )rR   r   rr   Zxlr#   r#   r$   Útest_conflicting_excel_enginesa  s    z0TestExcelFileRead.test_conflicting_excel_enginesc                 C  sj   t jd| |d�}td| dƒ�}| ¡ }W d   ƒ n1 s>0    Y  t jt|ƒ|d�}t ||¡ d S )Nr]   rK   r^   )rN   rM   ra   rS  r   r‚   rƒ   )rR   r"   r   r>   rc   r4   rÜ   r#   r#   r$   Útest_excel_read_binaryi  s
    &z(TestExcelFileRead.test_excel_read_binaryc                 C  s^   t d| dƒ�}tj||d�}W d   ƒ n1 s20    Y  tjd| |d�}t ||¡ d S )Nr]   r^   rK   )ra   rN   rM   r‚   rƒ   )rR   r   r"   rc   rd   r>   r#   r#   r$   Ú%test_excel_read_binary_via_read_excels  s    ,z7TestExcelFileRead.test_excel_read_binary_via_read_excelc              	   C  sn   t ddƒ�P}tjtdd��" tj|ddgd� W d   ƒ n1 sB0    Y  W d   ƒ n1 s`0    Y  d S )Nzdf_header_oob.xlsxr^   zexceeds maximumrj   r   r_   r°  )ra   r&   rp   r{   rN   rM   )rR   r"   rc   r#   r#   r$   Ú)test_read_excel_header_index_out_of_rangez  s    z;TestExcelFileRead.test_read_excel_header_index_out_of_rangerB  zdf_empty.xlsxzdf_equals.xlsxc                 C  s`   t dgdd�}tjddgddgd�}td	d
gg||dd�}tj|dddd	gd�}t ||¡ d S )NÚZZI2rœ   rž  )rˆ   zB.1ZI11ZI12r™  r_   rt   rú   )r?   rž   rÎ   rl   r   rŽ  )r   r   rÄ  r   rN   rM   r‚   rƒ   )rR   rB  rÆ  Úcolsr>   rd   r#   r#   r$   Útest_header_with_index_col€  s    ÿz,TestExcelFileRead.test_header_with_index_colc                 C  sÊ   t ||ƒ d| }t |¡�&}tj|ddgd|d�}W d   ƒ n1 sH0    Y  t||ƒ}tjddgd|› d�d	�}tj|d d… |dd … g|d  ¡ |d  ¡ gd
�}	t	g g |	d�}
t
 |
|¡ d S )NZtest_datetime_mir   r_   )r<  r7   r"   z
2020-02-29z
2020-03-01rË   rÌ   rÍ   r™  r­  )rH   rN   r`   rM   r<   ZDatetimeIndexr   rš  Zto_pydatetimer   r‚   rƒ   )rR   r/   r"   r   rc   rL   rÜ   rA   ZdtiZexpected_column_indexr>   r#   r#   r$   Útest_read_datetime_multiindex‹  s    
4


þþz/TestExcelFileRead.test_read_datetime_multiindexc              	   C  sf   t jtdd��D t d|› d�d¡� W d   ƒ n1 s:0    Y  W d   ƒ n1 sX0    Y  d S )NzValue must be one of *rj   zio.excelz.readerÚabc)r&   rp   r{   rN   r#  r>  r#   r#   r$   Útest_engine_invalid_option   s    z,TestExcelFileRead.test_engine_invalid_optionc                 C  sp   |dkrt  d¡ |dkr.| t jjdd�¡ t d| ¡� }|jdgksNJ ‚W d   ƒ n1 sb0    Y  d S )Nr   rÍ  r   rÎ  rC   rÏ  rl   )r&   r  rE   rF   rG   rN   r`   Zsheet_names)rR   r/   r"   r   rL   r#   r#   r$   Útest_ignore_chartsheets¦  s    
ÿÿz)TestExcelFileRead.test_ignore_chartsheetsc              
   C  sî   t f}|d u r t d|› �¡ n8|dkr>dd l}t |jjf}n|dkrXddlm} |f}t 	d|› �¡�r}t
|ƒjddd� t d	¡�6 ztj||d
� W n |y¬   Y n0 W d   ƒ n1 sÂ0    Y  W d   ƒ n1 sà0    Y  d S )NzInvalid test for engine=r   r   r   rN  Zcorruptzutf-8)ÚencodingFrK   )r	   r&   r  r   ZbiffhrM  r   rO  r‚   r  r   Ú
write_textrã  rN   r`   )rR   r"   r   Úerrorsr   rO  Úfiler#   r#   r$   Útest_corrupt_files_closed³  s     z+TestExcelFileRead.test_corrupt_files_closedN)rØ  rÙ  rÚ  rå  r&   rÛ  rU   re   rë  rF   rÜ  rí  rî  rC  rH  rE  rñ  rò  ró  rô  rõ  rø  rù  rû  rü  r  r#   r#   r#   r$   râ  ®  s4   

&
þ




râ  )8Ú
__future__r   r   r   Ú	functoolsr   r3   r   rc  Úpathlibr   re  rn   Úurllib.errorr   Úzipfiler	   Únumpyr·   r&   Zpandas.compatr
   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsrà  ZpandasrN   r   r   r   r   r   Zpandas._testingZ_testingr‚   rF   rß  Z
pytestmarkr*   r'   rá  Zengine_paramsr%   r)   rÛ  r   r0   r"   r   r:   r<   rB   rH   rI   râ  r#   r#   r#   r$   Ú<module>   sˆ   ÿþÿþÿþè
þù	



		          