a
    DBìj“’  ã                   @   s$  d dl Z d dlZd dlZd dlZd dlZd dlZd dlZd dl	Z
d dl	mZmZmZmZmZmZmZmZmZmZ d dlmZ d dlmZmZ d dlmZmZ ejjgZ e !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dhe*ƒ fe*ƒ ddhfdhddhfe*ƒ dhfdœfddhddhfe*ƒ dhfdœfg¡dd „ ƒZ+d!d"„ Z,d#d$„ Z-d%d&„ Z.d'd(„ Z/ej )d)d*d+g¡d,d-„ ƒZ0d.d/„ Z1d0d1„ Z2d2d3„ Z3d4d5„ Z4d6d7„ Z5d8d9„ Z6d:d;„ Z7d<d=„ Z8ej )d>dd?g¡ej )d@d+d*g¡dAdB„ ƒƒZ9dCdD„ Z:dEdF„ Z;dGdH„ Z<dIdJ„ Z=dKdL„ Z>dMdN„ Z?dOdP„ Z@dQdR„ ZAej )dSg dT¢¡dUdV„ ƒZBdWdX„ ZCdYdZ„ ZDd[d\„ ZEej )d]d^d_g¡d`da„ ƒZFdbdc„ ZGddde„ ZHdfdg„ ZIej Jdh¡ej )died djgejKdk�edldmgejLdk�edndodp�edqdodp�edndodrds�g¡dtdu„ ƒƒZMej )dvddwg¡dxdy„ ƒZNdzd{„ ZOd|d}„ ZPdS )~é    N)
Ú	DataFrameÚDatetimeIndexÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚconcatÚ
date_rangeÚperiod_rangeÚtimedelta_range)Ú_maybe_removeÚensure_clean_store©ÚHDFStoreÚread_hdfÚtablesc              	   C   s4  t  | ¡�X}z4t|ƒ�}tdƒ‚W d   ƒ n1 s40    Y  W n tyR   Y n0 W d   ƒ n1 sh0    Y  t  | ¡�¢}t|ƒ�x}tdt d¡ d¡ tt	dƒt
d�tdd„ td	ƒD ƒt
d�d
�|d< t|ƒdksÜJ ‚t|d ƒtksðJ ‚W d   ƒ n1 �s0    Y  W d   ƒ n1 �s&0    Y  d S )NZblahçš™™™™™ñ?éx   ©é   é   ÚABCD©Údtypec                 S   s   g | ]}d |› �‘qS ©zi-© ©Ú.0Úir   r   úb/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/io/pytables/test_store.pyÚ
<listcomp>3   ó    z test_context.<locals>.<listcomp>r   ©ÚcolumnsÚindexÚaé   )ÚtmÚensure_cleanr   Ú
ValueErrorr   ÚnpÚarangeÚreshaper   ÚlistÚobjectÚrangeÚlenÚtype)Ú
setup_pathÚpathZtblr   r   r   Útest_context'   s    
*$
ý
r4   c                    st   t jdfdd„‰ ‡ ‡fdd„}|| dd�}|| dd�}t d	¡ || dd�}|| dd�}||ksdJ ‚||kspJ ‚d S )
Né€   c                    s^   |ƒ ‰t | dƒ�6‰t‡ ‡‡fdd„dƒD ]}ˆ |¡ q(W d   ƒ n1 sL0    Y  ˆ ¡ S )NÚrbc                      s   ˆ  ˆ ˆj ¡S ©N)ÚreadÚ
block_sizer   ©Úchunk_num_blocksÚfÚhr   r   Ú<lambda>@   r!   z7test_no_track_times.<locals>.checksum.<locals>.<lambda>r!   )ÚopenÚiterÚupdateÚdigest)ÚfilenameZhash_factoryr;   Úchunkr   r:   r   Úchecksum=   s
    *z%test_no_track_times.<locals>.checksumc              	      s`   | ˆ }t ddgiƒ}t|dd��&}|jd|ddd |d� W d   ƒ n1 sN0    Y  ˆ |ƒS )Nr%   r&   Úw©ÚmodeÚtableT)ÚformatÚdata_columnsr$   Útrack_times)r   r   Úput)Útmp_pathrL   r3   ÚdfZhdf©rE   r2   r   r   Úcreate_h5_and_return_checksumD   s    ú$	z:test_no_track_times.<locals>.create_h5_and_return_checksumF)rL   Tr&   )ÚhashlibÚmd5ÚtimeÚsleep)rN   r2   rQ   Zchecksum_0_tt_falseZchecksum_0_tt_trueZchecksum_1_tt_falseZchecksum_1_tt_truer   rP   r   Útest_no_track_times9   s    
rV   c                 C   s<   t | ƒ� }t|ƒg ksJ ‚W d   ƒ n1 s.0    Y  d S r7   )r   r-   ©r2   Ústorer   r   r   Útest_iter_emptyd   s    
rY   c              	   C   sÜ  t | ƒ��,}t|ƒ | ¡  ttjdtjd�tddd�d�|d< ttdƒddd	„ tdƒD ƒd
�|d< t	dt d¡ 
d¡ ttdƒtd�tdd	„ tdƒD ƒtd�d�|d< t	dt d¡ 
d¡ ttdƒtd�tdd	„ tdƒD ƒtd�d�}d|d< d|d< |d dk|d< |d dk|d< d|d< d |d!< d"|d#< td$ƒ|d%< td&ƒ|d'< t d(d d"dd¡|d)< t d(d d*dd¡|d+< tj|j|jd*d,… dgf< | ¡ }|�r¢d ntjj}d-}tj||d.�� ||d/< W d   ƒ n1 �sÜ0    Y  |j |jjd0¡ |jt|ƒv �sJ ‚|jt|ƒv �s J ‚| ¡  W d   ƒ n1 �s>0    Y  t | ƒ�v}t	dt d¡ 
d¡ ttdƒtd�td1d	„ tdƒD ƒtd�d�}| d/|¡ |  d/¡}t|ƒ t|ƒ W d   ƒ n1 �sÎ0    Y  d S )2Né
   r   ú
2020-01-01©Úperiods©r$   r%   Úfloat64c                 S   s   g | ]}d |› �‘qS )Zi_r   r   r   r   r   r    r   r!   ztest_repr.<locals>.<listcomp>)r   r$   Úbr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    w   r!   r   r"   Úcc                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    }   r!   ÚfooÚobj1ÚbarÚobj2ÚAr   Úbool1ÚBÚbool2TÚbool3r&   Úint1é   Úint2Ú20010102Ú
timestamp1Ú20010103Ú
timestamp2iÑ  Ú	datetime1é   Ú	datetime2é   z0cannot
map directly to c-types .* dtype='object'©ÚmatchrO   Zbahc                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ž   r!   )!r   ÚreprÚinfor   r*   r+   r_   r	   r/   r   r,   r   r-   r.   r   ÚdtÚdatetimeÚnanÚlocr$   Ú_consolidateÚpdÚerrorsZPerformanceWarningr'   Úassert_produces_warningÚ_handleZcreate_groupÚrootrC   ÚstrÚappendÚ
get_storer)r2   Úusing_infer_stringrX   rO   ÚwarningÚmsgÚsr   r   r   Ú	test_reprj   sd    ÿ
ÿ
ý
ý((
ý
r‹   c              	   C   s¸  t | ƒ��˜}ttjdtjd�tddd�d�|d< tdt d¡ d	¡ tt	d
ƒt
d�tdd„ tdƒD ƒt
d�d�|d< tdt d¡ d	¡ tt	d
ƒt
d�tdd„ tdƒD ƒt
d�d�|d< d|v sÄJ ‚d|v sÐJ ‚d|vsÜJ ‚d|v sèJ ‚d|v sôJ ‚d|v�sJ ‚d|v�sJ ‚tjtjdd��T tdt d¡ d	¡ tt	d
ƒt
d�tdd„ tdƒD ƒt
d�d�|d< W d   ƒ n1 �s|0    Y  d|v �s”J ‚W d   ƒ n1 �sª0    Y  d S )NrZ   r   r[   r\   r^   r%   r   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ¯   r!   z!test_contains.<locals>.<listcomp>r   r"   r`   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ´   r!   zfoo/barra   z/foo/barz/foo/brd   F)Zcheck_stacklevelc                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    Å   r!   znode()))r   r   r*   r+   r_   r	   r   r,   r   r-   r.   r/   r'   r�   r   ZNaturalNameWarningrW   r   r   r   Útest_contains§   s<    ÿ
ý
ý
ÿý*rŒ   c              	   C   sž  t | ƒ��~}ttjdtjd�tddd�d�|d< tdt d¡ d	¡ tt	d
ƒt
d�tdd„ tdƒD ƒt
d�d�|d< ttj d¡ d¡tt	d
ƒt
d�tdddd�d�}t|dƒ | d|d d… ¡ | d|dd … ¡ |jjjjdksìJ ‚|jjjjdk�sJ ‚|jjjjdk�sJ ‚t|dƒ | d|¡ d | d¡j_d}tjt|d�� | d¡ W d   ƒ n1 �sp0    Y  W d   ƒ n1 �s�0    Y  d S )NrZ   r   r[   r\   r^   r%   r   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    Ò   r!   z#test_versioning.<locals>.<listcomp>r   r"   r`   rl   )é   r   ú
2000-01-01r�   rh   ©r]   ÚfreqÚdf1z0.15.2Údf2z/'NoneType' object has no attribute 'startswith'rv   )r   r   r*   r+   r_   r	   r   r,   r   r-   r.   r/   ÚrandomÚdefault_rngÚstandard_normalr   r…   rƒ   r%   Z_v_attrsZpandas_versionr`   r‘   Zget_nodeÚpytestÚraisesÚ	ExceptionÚselect)r2   rX   rO   r‰   r   r   r   Útest_versioningÊ   s4    ÿ
ý
ý

rš   zwhere, expectedú/Zfirst_groupZsecond_groupr‘   r’   Zthird_groupÚdf3Ús1Údf4)Ú ú/first_groupú/second_groupú/second_group/third_groupr¡   )r¡   r¢   c                 C   sú  t g d¢ƒt g d¢ƒt g d¢ƒt g d¢ƒtg d¢ƒt g d¢g d¢g¡tjddgdd�tjdd	gdd�d
œ}tddd���j}| d|d ¡ | d|d ¡ | d|d ¡ | d|d ¡ | d|d ¡ |j dd|d ¡ |jjdd|d d� |jjdd|d d� t	t
|j| d�ƒƒt	|ƒk�s.J ‚|j| d�D ]š\}}}||v �sRJ ‚|| \}}|t|ƒk�spJ ‚|t|ƒk�s‚J ‚|D ]J}	d ||	g¡}
| |
¡}d |	v �r¾t |||	 ¡ nt |||	 ¡ �q†�q:W d   ƒ n1 �sì0    Y  d S )!N)r&   rl   rs   )r   é   ru   )ru   é   é   )é	   rZ   é   )rZ   r¦   r¥   zi,i,ir   )r¤   r¥   r¦   )rZ   r§   é   )r‘   r’   rœ   rž   r�   Úa1Útb1Útb2zwalk_groups.hdfrF   rG   z/first_group/df1r‘   z/first_group/df2r’   z/second_group/df3rœ   z/second_group/s1r�   z/second_group/third_group/df4rž   r    r©   rª   )Úobjr¡   r«   ©Úwherer›   rO   )r   r   r*   Úarrayr   rM   r‚   Zcreate_arrayZcreate_tabler0   r-   ÚwalkÚsetÚjoinÚgetr'   Úassert_frame_equalÚassert_series_equal)r®   ÚexpectedZobjsrX   r3   ÚgroupsÚleavesZexpected_groupsZexpected_framesÚleafZ
frame_pathr¬   r   r   r   Ú	test_walkî   s<    




÷"

rº   c              
   C   s0  t | ƒ��}ttjdtjd�tddd�d�}||d< |j}t ||¡ t	|dƒ}t ||¡ t
tj d¡ d¡ttd	ƒƒtd
ddd�d�}||d< |j}t ||¡ dD ]H}d|› d�}tjt|d�� t	||ƒ W d   ƒ q¨1 sæ0    Y  q¨dD ]}t	|d|› �ƒ qöW d   ƒ n1 �s"0    Y  d S )NrZ   r   r[   r\   r^   r%   rl   ©rZ   r   r   rŽ   rh   r�   r"   rO   )ÚdrH   r3   ÚhandleÚcomplibz$'HDFStore' object has no attribute 'ú'rv   )rH   r3   r½   r¾   Ú_)r   r   r*   r+   r_   r	   r%   r'   rµ   Úgetattrr   r“   r”   r•   r   r-   rO   r´   r–   r—   ÚAttributeError)r2   rX   rŠ   ÚresultrO   Úxr‰   r   r   r   Útest_getattr+  s.    ÿ

ý*rÅ   c                 C   sÚ   t dtjdgdtjtjgdœtdƒd�}t ddgdtjgdœtdƒd�}| | }|j|dd	d
� t|dƒ}t ||¡ | | }|j|dd	dd� t|dƒ}t ||¡ | | }|j|dd	dd� t|dƒ}t ||¡ d S )Nç        ç       @ç      ð?)Zcol1Zcol2Úabcr^   ÚacrO   rI   ©ÚkeyrJ   F)rÌ   rJ   ZdropnaT)r   r*   r|   r-   Úto_hdfr   r'   r´   )rN   r2   Zdf_with_missingZdf_without_missingr3   Zreloadedr   r   r   Útest_store_dropnaL  s&    þÿ


rÎ   c                 C   sf   | | }d}t ddddœddddœgƒ}tjt|d�� | |d¡ W d   ƒ n1 sX0    Y  d S )NztStarting with pandas version 3.0 all arguments of to_hdf except for the argument 'path_or_buf' will be keyword-only.r&   rl   rs   )rf   rh   ÚCrv   rÌ   )r   r'   r�   ÚFutureWarningrÍ   )rN   r2   r3   r‰   rO   r   r   r   Útest_keyword_deprecationg  s    ÿrÑ   c                 C   sê   | | }t g d¢g d¢tg d¢ƒtddd�dœƒ d¡}|j|d	d
ddid� | ¡  ¡ jdd� d¡}|j|d	dd
d� t 	t
|d	ƒt||gƒ¡ |d j|dd
ddid� |d j|ddd
d� t t
|dƒt|d |d gƒ¡ d S )N)rÆ   rÈ   rÇ   g      @g      @)rÆ   rÈ   rÆ   rÈ   rÆ   )Zfoo1Zfoo2Zfoo3Zfoo4Zfoo5Ú20130101r£   r\   )rf   rh   rÏ   ÚDrÏ   Zss3rI   r$   ru   )rÌ   rJ   Zmin_itemsizeZlonger)rÏ   T)rÌ   r…   rJ   rh   Zss4)r   r   r	   Ú	set_indexrÍ   ÚcopyZreset_indexZassignr'   r´   r   r   rµ   )rN   r2   r3   rO   r’   r   r   r   Útest_to_hdf_with_min_itemsizeu  s"    

üÿùrÖ   rJ   ÚfixedrI   c           
      C   s„   dg}t |t|dd�dd�}| | }|j|d|dd� t|ddd�}|rZtjd	tjd
�}nd}t |t||d�|d�}	t 	||	¡ d S )Nu   í €foor.   r   )r$   r   rI   Úsurrogatepass)rÌ   rJ   r€   )r€   Úpython)ZstorageZna_value)
r   r   rÍ   r   r   ZStringDtyper*   r|   r'   rµ   )
rN   rJ   r2   r‡   ÚdataZserr3   rÃ   r   r¶   r   r   r   Útest_to_hdf_errors�  s    rÛ   c              	      sr  t | ƒ��R‰ ‡ fdd„}ttj d¡ d¡ttdƒƒtdddd	�d
�}d|d< d|d< ˆ j	d|ddgd� |ddƒj
du s~J ‚|ddƒj
du s’J ‚|ddƒj
du s¦J ‚ˆ j	d|dgddgd� |ddƒj
du sÒJ ‚|ddƒj
du sæJ ‚|ddƒj
du súJ ‚tˆ dƒ ˆ  d|¡ d}tjt|d�� ˆ  d¡ W d   ƒ n1 �sD0    Y  W d   ƒ n1 �sd0    Y  d S )Nc                    s   t ˆ  | ¡jj|ƒS r7   ©rÁ   r†   rI   Úcols©ÚtÚcolumn©rX   r   r   Úcol¤  s    z$test_create_table_index.<locals>.colrl   r»   r   rŽ   rZ   rh   r�   r"   rb   Ústringrd   Ústring2r<   ©rK   r$   TÚf2)r$   rK   Fz1cannot create table index on a Fixed format storerv   )r   r   r*   r“   r”   r•   r   r-   r	   r…   Ú
is_indexedr   rM   r–   r—   Ú	TypeErrorÚcreate_table_index©r2   râ   rO   r‰   r   rá   r   Útest_create_table_index¡  s,    
ý
rë   c              	      s6  t | ƒ��‰ ‡ fdd„}ttj d¡ d¡ttdƒƒtdddd	�d
�}d|d< d|d< ˆ j	d|dgd� |ddƒj
du s|J ‚|ddƒj
du s�J ‚d}tjt|d�� |ddƒj
 W d   ƒ n1 sÄ0    Y  d}tjt|d��  ˆ jddgd� W d   ƒ n1 �s0    Y  W d   ƒ n1 �s(0    Y  d S )Nc                    s   t ˆ  | ¡jj|ƒS r7   rÜ   rÞ   rá   r   r   râ   Ç  s    z:test_create_table_index_data_columns_argument.<locals>.colrl   r»   r   rŽ   rZ   rh   r�   r"   rb   rã   rd   rä   r<   rå   r$   Tz('Cols' object has no attribute 'string2'rv   z¥column string2 is not a data_column.
In order to read column string2 you must reload the dataframe 
into HDFStore and include string2 with the data_columns argument.©r#   )r   r   r*   r“   r”   r•   r   r-   r	   r…   rç   r–   r—   rÂ   ré   rê   r   rá   r   Ú-test_create_table_index_data_columns_argumentÂ  s&    
ý*ÿrí   c                 C   s    t jtddd�tdƒgddgd�}tdg d¢i|d	�}t| ƒ�N}|jd
|dd� |jd
dd�}|jdgd d …f }t	 
||¡ W d   ƒ n1 s’0    Y  d S )NrŽ   r£   r\   ÚdateÚid)Únamesr%   )r   g333333ó?gÍÌÌÌÌÌô?gffffffö?g      ø?r^   rO   Trå   zid == 1r­   r&   )r   Zfrom_arraysr	   r/   r   r   r…   r™   Úilocr'   r´   )r2   ÚidxrO   rX   Úactualr¶   r   r   r   Útest_mi_data_columnsä  s    ÿ
rô   c                 C   s8  t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}d	|d
< d|d< |d dk|d< |d dk|d< d|d< d|d< d|d< tdƒ d¡|d< tdƒ d¡|d< tdƒ d¡|d< tdƒ d¡|d< tj	|j
|jdd … d
gf< | ¡ }t| ƒ�.}| d!|¡ t | d!¡|¡ W d   ƒ n1 �s*0    Y  d S )"Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ø  r!   z+test_table_mixed_dtypes.<locals>.<listcomp>r   r"   rb   rc   rd   re   rf   r   rg   rh   ri   Trj   r&   rk   rl   rm   rn   Únsro   rp   rq   rr   rt   rs   ru   Z	df1_mixed)r   r*   r+   r,   r   r-   r/   r   Úas_unitr|   r}   r$   r~   r   r…   r'   r´   r™   ©r2   rO   rX   r   r   r   Útest_table_mixed_dtypesó  s*    
ý
rø   c           	      C   sÔ   d}dt  ddd¡t d¡g}tjj||d�}t  ddd	¡}t|d|d
�}t|j	|ƒ 
td ¡ ƒ¡}t| ƒ�T}| d|¡ | d¡}t ||¡ | d|¡ | d¡}t ||¡ W d   ƒ n1 sÆ0    Y  d S )NzSun Mon Tue Wed Thuz
2012-05-01iÝ  r£   r&   z
2014-05-01)ÚholidaysZweekmaskr   r   r�   zMon Tue Wed Thu Fri Sat Sunr×   rI   )rz   r{   r*   Z
datetime64r   ÚoffsetsZCustomBusinessDayr	   r   ÚweekdayÚmapÚsplitr   rM   r™   r'   rµ   r…   )	r2   Zweekmask_egyptrù   Z
bday_egyptZmydtÚdtsrŠ   rX   rÃ   r   r   r   Útest_calendar_roundtrip_issue  s$    ýÿ


rÿ   c              	   C   s¤  t | ƒ��„}ttjdtjd�tddd�d�}tdt d¡ d¡ tt	d	ƒƒtd
d„ t
dƒD ƒƒd�}||d< ||d< t|dƒ t|ƒdksŽJ ‚t ||d ¡ t|dƒ t|ƒdks¸J ‚tjtdd�� | d¡ W d   ƒ n1 sæ0    Y  ||d< ||d< t|dƒ t|dƒ t|ƒdk�s&J ‚||d< ||d< t|dƒ t|ƒdk�sRJ ‚||d< ||d< |d= |d= t|ƒdk�s€J ‚W d   ƒ n1 �s–0    Y  d S )NrZ   r   r[   r\   r^   r   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    0  r!   ztest_remove.<locals>.<listcomp>r   r"   r%   r`   r&   r   z1'No object named a_nonexistent_store in the file'rv   Za_nonexistent_storezb/foorb   )r   r   r*   r+   r_   r	   r   r,   r   r-   r/   r   r0   r'   r´   r–   r—   ÚKeyErrorÚremove)r2   rX   ÚtsrO   r   r   r   Útest_remove(  sD    ÿ
ý

ÿ(


r  c                 C   s¸   t | ƒ�œ}ttj d¡ d¡tddd�d�}|jd|dd	� ||jt	d
ƒk }| 
dd¡}t ||¡ | 
dd¡}t ||¡ | 
dd¡}t ||¡ W d   ƒ n1 sª0    Y  d S )Nrl   )r�   rl   rÒ   r�   r\   r^   rO   rI   ©rJ   Z20130105z!index>datetime.datetime(2013,1,5)zindex>datetime(2013,1,5))r   r   r*   r“   r”   r•   r	   rM   r$   r   r™   r'   r´   )r2   rX   rO   r¶   rÃ   r   r   r   Útest_same_name_scopingU  s    

þr  c                 C   sˆ   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}d	|j_t	| ƒ�,}||d
< |d
 }t
 ||¡ W d   ƒ n1 sz0    Y  d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    p  r!   z)test_store_index_name.<locals>.<listcomp>r   r"   rb   Úframe)r   r*   r+   r,   r   r-   r/   r$   Únamer   r'   r´   )r2   rO   rX   Úreconsr   r   r   Útest_store_index_namel  s    
ý
r	  Útzz
US/PacificÚtable_formatc           
      C   sÐ   t t ddd¡t ddd¡gdd� |¡}t t ddd¡t ddd¡gdd� |¡ |¡}tt d¡ dd¡||d	�}| | }|j	|d
|d� t
|d
ƒ}	tj||	dd� t|	jjtƒsºJ ‚t|	jjtƒsÌJ ‚d S )NiÐ  r&   rl   u   cols×’)r  iÚ  u   rows×�r   r"   rO   rË   T)Zcheck_names)r   rz   rî   Ztz_localizerö   r   r*   r+   r,   rÍ   r   r'   r´   Ú
isinstancer$   r  r„   r#   )
rN   r  r2   Úunitr
  rò   Zidx1rO   r3   r’   r   r   r   Útest_store_index_name_numpy_strz  s,    þýþüûÿ
r  c                 C   sˆ   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}|d	 }t| ƒ�,}||d
< |d
 }t 	||¡ W d   ƒ n1 sz0    Y  d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ›  r!   z*test_store_series_name.<locals>.<listcomp>r   r"   rf   Úseries)
r   r*   r+   r,   r   r-   r/   r   r'   rµ   )r2   rO   r  rX   r  r   r   r   Útest_store_series_name—  s    
ý
r  c              	   C   s–   t | ƒ�z}ttj d¡ d¡ttdƒƒtdddd�d�|d	< t	tj
dtjd
�tddd�d�}||d	< t |d	 |¡ W d   ƒ n1 sˆ0    Y  d S )Nrl   r»   r   rŽ   rZ   rh   r�   r"   r%   r   r[   r\   r^   )r   r   r*   r“   r”   r•   r   r-   r	   r   r+   r_   r'   rµ   )r2   rX   r  r   r   r   Útest_overwrite_node¥  s    

ý
ÿr  c              	   C   s<  t tj d¡ d¡ttdƒƒtdddd�d�}t| ƒ��"}t	|d	ƒ | 
d	|¡ | d	¡}|jt t|jƒ¡k ¡ sxJ ‚t	|d	ƒ t td
ƒtd
ƒdœƒ}| 
d	|¡ | d	dg¡}|jt d¡k ¡ sÊJ ‚|jd	|d�}|jdd…d d …f }t ||¡ | d	ddg¡}|jt d¡d k ¡ �s(J ‚|jd	|d�}|jdd…d d …f }t ||¡ t|tƒ�shJ ‚t	|dƒ t	|dƒ t tj d¡ d¡ttdƒƒtdddd�d�}| ¡ jdjd�}|j
d|ddgd� | 
d|¡ | dddg¡}| d|¡}| d|¡}	t||	gdd�}t||gdd�}||jdk|jdk@  }tj||dd� W d   ƒ n1 �sb0    Y  t| ƒ��°}t tj d¡ d¡td d!d"�d#�}| 
d	|¡ | d	d$¡}|t|ƒjd
k j}
|j |
 }|jd	|
d�}t ||¡ |jd	|
d�}t ||¡ d%}t!j"t#|d&��, |jd	tjt|ƒd'd(�d� W d   ƒ n1 �sJ0    Y  t!j"t#|d&��, |jd	t t|ƒd ¡d� W d   ƒ n1 �s–0    Y  t!j"t#|d&��* |jd	t t|ƒ¡d
d)� W d   ƒ n1 �sà0    Y  t!j"t#|d&��, |jd	t t|ƒ¡d
dd*� W d   ƒ n1 �s,0    Y  td d+d"�}|jd	d,d�}||j $|¡ }t ||¡ t tj d¡ d-¡ƒ}| 
d|¡ |jdg d.¢d�}|j g d.¢ }t ||¡ d/gd }
d|
d0< |jd|
d�}|j|
 }t ||¡ |jdd
dd1�}|d
d… }t ||¡ W d   ƒ n1 �s.0    Y  d S )2Nrl   r»   r   rŽ   rZ   rh   r�   r"   rO   r£   ©rf   rh   zindex<3rs   r­   r   zindex>=3zindex<=4r   r‘   r’   z{}_2rì   rf   rå   zA>0zB>0r&   )ZaxisF)Z
check_freq)éè  rl   Z20000101r  r\   r^   r$   zLwhere must be passed as a string, PyTablesExpr, or list-like of PyTablesExprrv   r_   r   )r®   Ústart)r®   r  Ústopiô  zindex in selection©rZ   rl   )r   rs   r£   Téþÿÿÿ©r  r  )%r   r*   r“   r”   r•   r   r-   r	   r   r   r…   Zselect_as_coordinatesÚvaluesr+   r0   r$   Úallr/   r™   r}   r'   r´   r  rÕ   ÚrenamerJ   r   rf   rh   Zselect_columnr   Úmonthrñ   r–   r—   rè   Úisin)r2   rO   rX   ra   rÃ   r¶   r‘   r’   Z
df1_resultZ
df2_resultr®   r‰   Z	selectionr   r   r   Útest_coordinates´  s¢    
ý





ý0
þ
ÿ<<:<

r  c                 C   sÖ   t | ƒ�º}ttj d¡ d¡tj d¡ d¡dœƒ}| d|¡ |jddddd�}|jdd	…d
gf }t 	||¡ |jddddd�}t
|ƒdks”J ‚|jdd…d
gf }t 	||¡ W d   ƒ n1 sÈ0    Y  d S )Nrl   r�   r  rO   zcolumns=['A']r   r£   r  r   rf   r   é(   )r   r   r*   r“   r”   r…   r™   r}   r'   r´   r0   ©r2   rX   rO   rÃ   r¶   r   r   r   Útest_start_stop_table*  s    
þÿr!  c                 C   s�   t | ƒ�t}tddgddgdœƒ}|jdgd dœ|dd� |jddgdd	dd
�}|jd	gddgf }t ||¡ W d   ƒ n1 s‚0    Y  d S )Nr&   rl   )rb   rd   rb   )ÚselectorrÚ   r"  )r"  rÚ   r   )r"  r  r  rd   )r   r   Zappend_to_multipleZselect_as_multipler}   r'   r´   r   r   r   r   Útest_start_stop_multiple@  s    
ÿÿr#  c                 C   sÒ  t | ƒ��²}ttj d¡ d¡tj d¡ d¡dœtddd�d�}| d|¡ |jddd	d
�}|jdd	…d d …f }t	 
||¡ |jdd	dd
�}|jd	d…d d …f }t	 
||¡ |jdddd
�}|jdd…d d …f }t	 
||¡ |j}| d|¡ |jddd	d
�}|jdd	… }t	 ||¡ |jdd	dd
�}|jd	d… }t	 ||¡ tdt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}tj|jdd	…dd…f< tj|jdd…df< W d   ƒ n1 �sÄ0    Y  d S )Nrl   r�   r  rÒ   r\   r^   rO   r   r£   r  rZ   r   r  rŠ   r   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    w  r!   z)test_start_stop_fixed.<locals>.<listcomp>r"   rs   r&   r¥   r  )r   r   r*   r“   r”   r	   rM   r™   rñ   r'   r´   rf   rµ   r+   r,   r   r-   r/   r|   )r2   rX   rO   rÃ   r¶   rŠ   r   r   r   Útest_start_stop_fixedO  s@    þ
û
ýr$  c              
   C   sä   t tj d¡ d¡ƒ}dd„ |jD ƒ|_dd„ |jD ƒ|_t| ƒ�Ž}|jd|dd� d	}| 	d|g¡}t
 ||jd d …|jd d
… f ¡ d}| 	d|g¡}t
 ||jd d …|jd d
d… f ¡ W d   ƒ n1 sÖ0    Y  d S )Nrl   )é2   éd   c                 S   s   g | ]}|d ›‘qS ©Z3dr   ©r   ra   r   r   r   r      r!   z-test_select_filter_corner.<locals>.<listcomp>c                 S   s   g | ]}|d ›‘qS r'  r   r(  r   r   r   r    €  r!   r  rI   r  zcolumns=df.columns[:75]éK   zcolumns=df.columns[:75:2])r   r*   r“   r”   r•   r$   r#   r   rM   r™   r'   r´   r}   )r2   rO   rX   ÚcritrÃ   r   r   r   Útest_select_filter_corner}  s    
$r+  c                     s`   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�‰ t ‡ fd	d
„dd
„ ¡} t 	ˆ | ¡ d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ’  r!   z%test_path_pathlib.<locals>.<listcomp>r   r"   c                    s   ˆ j | dd�S ©NrO   ©rÌ   ©rÍ   ©Úp©rO   r   r   r>   –  r!   z#test_path_pathlib.<locals>.<lambda>c                 S   s
   t | dƒS ©NrO   ©r   r/  r   r   r   r>   –  r!   ©
r   r*   r+   r,   r   r-   r/   r'   Zround_trip_pathlibr´   ©rÃ   r   r1  r   Útest_path_pathlibŽ  s    
ýÿr6  zstart, stop))r   rl   )r&   rl   )NNc                 C   sz   t tg d¢ƒtg d¢ƒdœƒ}t|ƒ�@}| d|¡ |jd| |d�}t || |… |¡ W d   ƒ n1 sl0    Y  d S )N)i¢Þ2i£Þ2i¤Þ2)ÚabÚcdr7  ©r%   r`   Ztest_datasetr  )r   r   r   r…   r™   r'   r´   )r  r  r2   rO   rX   rÃ   r   r   r   Ú test_contiguous_mixed_data_table›  s    

þÿ
r:  c                     sh   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�‰ ‡ fd	d
„} dd„ }t | |¡}t 	ˆ |¡ d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    °  r!   z.test_path_pathlib_hdfstore.<locals>.<listcomp>r   r"   c                    s:   t | ƒ�}ˆ j|dd� W d   ƒ n1 s,0    Y  d S r,  ©r   rÍ   ©r3   rX   r1  r   r   Úwriter³  s    
z*test_path_pathlib_hdfstore.<locals>.writerc                 S   s6   t | ƒ�}t|dƒW  d   ƒ S 1 s(0    Y  d S r2  r   r<  r   r   r   Úreader·  s    
z*test_path_pathlib_hdfstore.<locals>.readerr4  ©r=  r>  rÃ   r   r1  r   Útest_path_pathlib_hdfstore¬  s    
ýr@  c                     s`   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�‰ t ‡ fd	d
„dd
„ ¡} t 	ˆ | ¡ d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    Ã  r!   z.test_pickle_path_localpath.<locals>.<listcomp>r   r"   c                    s   ˆ j | dd�S r,  r.  r/  r1  r   r   r>   Æ  r!   z,test_pickle_path_localpath.<locals>.<lambda>c                 S   s
   t | dƒS r2  r3  r/  r   r   r   r>   Æ  r!   r4  r5  r   r1  r   Útest_pickle_path_localpath¿  s    
ýÿrA  c                     sh   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�‰ ‡ fd	d
„} dd„ }t | |¡}t 	ˆ |¡ d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    Ï  r!   z0test_path_localpath_hdfstore.<locals>.<listcomp>r   r"   c                    s:   t | ƒ�}ˆ j|dd� W d   ƒ n1 s,0    Y  d S r,  r;  r<  r1  r   r   r=  Ò  s    
z,test_path_localpath_hdfstore.<locals>.writerc                 S   s6   t | ƒ�}t|dƒW  d   ƒ S 1 s(0    Y  d S r2  r   r<  r   r   r   r>  Ö  s    
z,test_path_localpath_hdfstore.<locals>.reader)
r   r*   r+   r,   r   r-   r/   r'   Zround_trip_localpathr´   r?  r   r1  r   Útest_path_localpath_hdfstoreË  s    
ýrB  ÚpropindexesTFc                 C   s¾  t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}t ¡ ��f}t	|ƒ�"}|j
d	|d
gd� W d   ƒ n1 st0    Y  t ¡ �� }t	|ƒ�Ö}t |j|jd | d�¡�œ}| ¡ }t|ƒt| ¡ ƒksÎJ ‚| ¡ D ]b}| |¡jrÖ| |¡}	| |¡}
|
j|	jk�sJ ‚| rÖ|
jD ] }|j�r|	|j j�sJ ‚�qqÖW d   ƒ n1 �sP0    Y  W d   ƒ n1 �sp0    Y  W d   ƒ n1 �s�0    Y  W d   ƒ n1 �s°0    Y  d S )Nr   r   r   r   c                 S   s   g | ]}d |› �‘qS r   r   r   r   r   r   r    ã  r!   ztest_copy.<locals>.<listcomp>r   r"   rO   rf   rå   )ÚkeysrC  )r   r*   r+   r,   r   r-   r/   r'   r(   r   r…   ÚtempfileÚNamedTemporaryFileÚ
contextlibÚclosingrÕ   r  rD  r±   r†   Zis_tableZnrowsZaxesrç   )rC  rO   r3   ÚstÚnew_frX   ZtstorerD  ÚkZnew_tZorig_tr%   r   r   r   Ú	test_copyÞ  s2    
ý
0
ÿ


rL  c                 C   s¦   t ddgddggd�}| | }d}tjt|d��  |j|ddd� W d   ƒ n1 sV0    Y  |j|dd	d� t|dƒ}t ||¡ | |¡s”J ‚| |¡s¢J ‚d S )
Nr%   r   )r#   rÚ   z/Columns index has to be unique for fixed formatrv   rO   r×   rË   rI   )	r   r–   r—   r)   rÍ   r   r'   r´   Úequals)rN   r2   rO   r3   r‰   Úotherr   r   r   Útest_duplicate_column_name   s    .
rO  c                 C   sn   t tj d¡jdd�ƒ}tddddd�|_t| ƒ�(}||d	< t 	|d	 |¡ W d   ƒ n1 s`0    Y  d S )
Nrl   )rZ   r£   )ÚsizeZ0srZ   Z1sZexample)r  r]   r�   r  rO   )
r   r*   r“   r”   Únormalr   r$   r   r'   r´   r÷   r   r   r   Ú!test_preserve_timedeltaindex_type  s
    
rR  c                 C   s˜   t tj d¡ d¡tdƒtdƒd�}d|j_|jddd	�}|jj|j	 
¡  }| | }|j|d
dd|dd� tdƒ}t|ƒ}t|d
|d� ||ks”J ‚d S )Nrl   )r   r£   ÚabcdZABCDE)r$   r#   ÚlettersÚET)rD  r…   rO   r%   F)rÌ   rH   r…   rK   r$   ZBCDrì   )r   r*   r“   r”   r-   r$   r  rÔ   rð   r#   ÚtolistrÍ   r   )rN   r2   rO   rK   r3   Z	cols2loadZcols2load_originalr   r   r   Ú test_columns_multiindex_modified  s*    ýúrW  z3ignore:PeriodDtype\[B\] is deprecated:FutureWarningr#   r&   r   rÆ   rÈ   r[   rl   r\   z1 dayrÓ   r�   c                 C   sj   t tj d¡ d¡|d�}| | }d}tjt|d��" |j|dddd	� W d   ƒ n1 s\0    Y  d S )
Nrl   r  rì   z-cannot have non-object label DataIndexableColrv   rO   rI   T©rÌ   rJ   rK   )	r   r*   r“   r”   r•   r–   r—   r)   rÍ   )rN   r2   r#   rO   r3   r‰   r   r   r   Ú0test_to_hdf_with_object_column_names_should_fail6  s
    rY  r   Úcategoryc                 C   sl   t tj d¡ d¡tddg|d�d�}| | }|j|ddd	d
� t|dd|jd › d�d�}t	|ƒshJ ‚d S )Nrl   r  r%   r`   r   rì   rO   rI   TrX  z	index = [r   ú]r­   )
r   r*   r“   r”   r•   r   rÍ   r   r$   r0   )rN   r2   r   rO   r3   rÃ   r   r   r   Ú/test_to_hdf_with_object_column_names_should_runJ  s    þr\  c                 C   sn   t g d¢g d¢dœƒ}t| ƒ�<}| d|¡ |d jj|d d jjksLJ ‚W d   ƒ n1 s`0    Y  d S )N)r&   rl   rs   r   )r£   ru   r¤   r¥   r9  rO   r%   )r   r   rM   r  Ústridesr÷   r   r   r   Útest_hdfstore_stridesW  s    
r^  c                 C   sV   t dggdgtdgdd�d�}| ¡ }| | }|j|dd� t|dƒ}t ||¡ d S )	Nr&   TFÚboolr   r"   r%   r-  )r   r   rÕ   rÍ   r   r'   r´   )rN   r2   rO   r¶   r3   rÃ   r   r   r   Útest_store_bool_index_  s    
r`  )QrG  r{   rz   rR   rE  rT   Únumpyr*   r–   Zpandasr   r   r   r   r   r   r   r   r	   r
   r   Zpandas._testingZ_testingr'   Zpandas.tests.io.pytables.commonr   r   Zpandas.io.pytablesr   r   ÚmarkZ
single_cpuZ
pytestmarkZimportorskipr   r4   rV   rY   r‹   rŒ   rš   Zparametrizer±   rº   rÅ   rÎ   rÑ   rÖ   rÛ   rë   rí   rô   rø   rÿ   r  r  r	  r  r  r  r  r!  r#  r$  r+  r6  r:  r@  rA  rB  rL  rO  rR  rW  ÚfilterwarningsZint64r_   rY  r\  r^  r`  r   r   r   r   Ú<module>   s¬   0

+=#$
üþ

þþöþ
(!
!"-v.

!



ûþ
	
