Ë
    ¤eh¹  ã                   ó@  — d dl Z d dlZd dlZd dlmZ d dlZd dlm	Z
 d dlmZ d dlmZ  ej                  d«      Z e«       rej"                  j$                  Z ej(                  dg¬«      d„ «       Zd	„ Zd
„ Zd„ Zej"                  j3                  dg d¢«      d„ «       Zy)é    N)Úis_platform_windows)Ú	ExcelFile)Úinspect_excel_formatÚxlrdz.xls)Úparamsc                 ó   — | j                   S )z�
    Valid extensions for reading Excel files with xlrd.

    Similar to read_ext, but excludes .ods, .xlsb, and for xlrd>2 .xlsx, .xlsm
    )Úparam)Úrequests    ú]/var/www/skyplay_api_hub/venv/lib/python3.12/site-packages/pandas/tests/io/excel/test_xlrd.pyÚread_ext_xlrdr      s   € ð �=‰=Ðó    c                 óH  — d}d} |dddd«      }t         j                  |«      5 }t        ||¬«      5 }t        j                  ||d¬	«      }d d d «       t        j                  |||d¬
«      }d d d «       t        j                  «       y # 1 sw Y   ŒAxY w# 1 sw Y   Œ,xY w)Nr   ÚSheet1ÚioÚdataÚexcelz	test1.xls©Úenginer   )Ú
sheet_nameÚ	index_col)r   r   r   )r   Úopen_workbookr   ÚpdÚ
read_excelÚtmÚassert_frame_equal)	r   Údatapathr   r   ÚpthÚbookÚxlÚresultÚexpecteds	            r   Útest_read_xlrd_bookr"      s£   € Ø€FØ€JÙ
�4˜ ¨+Ó
6€CÜ	×	Ñ	˜CÓ	 ð 
 DÜ�t FÔ+ð 	K¨rÜ—]‘] 2°*ÈÔJˆF÷	Kô —=‘=Ø˜Z°À!ô
ˆ÷	
ô ×Ñ˜& (Õ+÷	Kð 	Kú÷
ð 
ús"   ¥B³BÁ!BÂB	ÂBÂB!c                 ó¬   — ddl m}  | dddd«      }t        j                  |d¬«      5  t	        j
                  |d	¬
«       d d d «       y # 1 sw Y   y xY w)Nr   )Ú	XLRDErrorr   r   r   z
test1.xlsxzExcel xlsx file; not supported)Úmatchr   r   )Ú
xlrd.biffhr$   ÚpytestÚraisesr   r   )r   r$   Úpaths      r   Útest_read_xlsx_failsr*   ,   sG   € å$á�D˜& '¨<Ó8€DÜ	�‰�yÐ(HÔ	Iñ +Ü
�‰�d 6Õ*÷+÷ +ñ +ús   ©A
Á
Ac                 ó&  —  | dddd«      }t        j                  t        j                  d   j	                  d«      t        j                  dt        j
                  f   dœ«      }t        j                  |d ¬	«      }t        j                  ||«       y )
Nr   r   r   z	test6.xls)r   é   Úint64é   )r   r.   )Úheader)	r   Ú	DataFrameÚnpÚr_ÚastypeÚnanr   r   r   )r   r)   r!   r    s       r   Útest_nan_in_xlsr5   5   si   € á�D˜& '¨;Ó7€Dä�|‰|¤§¡ d¡× 2Ñ 2°7Ó ;ÄÇÁÀaÌÏÉÀiÑ@PÑQÓR€Hä�]‰]˜4¨Ô-€Fä×Ñ˜& (Õ+r   Úfile_header)s   	    s   	    s   	    s   ÐÏà¡±ác                 óN   — t        j                  | «      }t        |«      dk(  sJ ‚y )NÚxls)r   ÚBytesIOr   )r6   Úfs     r   Útest_read_old_xls_filesr;   @   s%   € ô 	�
‰
�;Ó€AÜ Ó" eÒ+Ð+Ñ+r   )r   Únumpyr1   r'   Úpandas.compatr   Úpandasr   Úpandas._testingÚ_testingr   Úpandas.io.excelr   Úpandas.io.excel._baser   Úimportorskipr   ÚmarkÚ
single_cpuÚ
pytestmarkÚfixturer   r"   r*   r5   Úparametrizer;   © r   r   ú<module>rJ      sŸ   ðÛ 	ã Û å -ã Ý å %Ý 6à€v×Ñ˜6Ó"€áÔØ—‘×'Ñ'€Jð €‡�˜�xÔ ñó !ðò,ò+ò,ð ‡�×ÑØòóñ,óñ,r   