a
    DBìj,’  ã                   @   sb  d dl Z d dl mZ d dl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mZmZ d dlmZmZ ejjgZe d¡Zej d¡dd	„ ƒZd
d„ Z dd„ Z!dd„ Z"dd„ Z#dd„ Z$dd„ Z%dd„ Z&dd„ Z'dd„ Z(dd„ Z)ej *dg d¢¡d d!„ ƒZ+d"d#„ Z,ej-d$d%„ ƒZ.d&d'„ Z/d(d)„ Z0d*d+„ Z1d,d-„ Z2d.d/„ Z3d0d1„ Z4dS )2é    N©Ú	timedelta)Ú	Timestamp)Ú	DataFrameÚIndexÚSeriesÚ_testingÚconcatÚ
date_rangeÚread_hdf)Ú_maybe_removeÚensure_clean_storeÚtablesz!ignore::tables.NaturalNameWarningc              
   C   s¦  t | ƒ��†}ttj d¡ d¡ttdƒƒtdddd�d�}t	|d	ƒ | 
d	|d d
… ¡ | 
d	|d
d … ¡ t |d	 |¡ t	|dƒ |jd|d d
… dd� | 
d|d
d … ¡ t |d |¡ t	|dƒ | 
d|d d
… ¡ | 
d|d
d … ¡ t |d |¡ t	|dƒ | 
d|d d
… ¡ | 
d|d
d … ¡ t |d |¡ tddgddgddgddggd�}d|d< tj|jd< t	|dƒ | 
d|¡ t |d |¡ tttj d¡jdddd�tjd�ttj d¡jdddd�tjd�ttj d¡jdddd�tjd�tg d¢tjd�d œt d¡d!�}t	|d"ƒ | 
d"|¡ tj|d" |d#d$� t	|d"ƒ |j
d"|g d%¢d&� tj|d" |d#d$� W d   ƒ n1 �s˜0    Y  d S )'Né   )é   é   ÚABCDú
2000-01-01r   ÚB©ÚperiodsÚfreq©ÚcolumnsÚindexÚdf1é
   Údf2Útable)ÚformatÚdf3z/df3z/df3 foozdf3 fooé   r   )ÚdataZtestingÚmixed_column)r   r#   Údféÿ   é   )ÚhighÚsize©Údtypeiÿÿ  i   @)l           l          @l            l            l            )Úu08Úu16Úu32Zu64©r   ZuintsT©Zcheck_index_type)r+   r,   r-   ©Údata_columns)r   r   ÚnpÚrandomÚdefault_rngÚstandard_normalr   Úlistr
   r   ÚappendÚtmÚassert_frame_equalÚputÚnanÚlocr   ZintegersZuint8Zuint16Zuint32Zuint64Úarange)Ú
setup_pathÚstorer$   Z	uint_data© r@   úc/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/pandas/tests/io/pytables/test_append.pyÚtest_append   sl    
ý



"
þþþþóí

rB   c           	      C   sü  t | ƒ��Ü}ttdƒtjdd„ tdƒD ƒd�}ttjdtjd�tddd�d	�}tt d
¡ƒ}| d|¡ |d }t 	||¡ |j
d u sŠJ ‚| d|¡ |d }t 	||¡ |j
d u s¸J ‚d|_
| d|¡ |d }t 	||¡ |j
|j
ksîJ ‚||dk }| dd¡}t 	||¡ ||dk|jdk @  }| dd¡}tj	||dd� ttj d¡ d¡dgd�}t t|ƒ¡|d< d|d< d|jdd…df< |jddgdd� |jdd �}|j d¡|_| d!|¡ tj	|d! |dd� W d   ƒ n1 �sî0    Y  d S )"Nr   c                 S   s   g | ]}d |› �‘qS )Zi_r@   ©Ú.0Úir@   r@   rA   Ú
<listcomp>k   ó    z&test_append_series.<locals>.<listcomp>)r*   r   r   r)   z
2020-01-01©r   r.   éd   ÚssÚtsÚfooÚnsé<   zfoo>60éF   éZ   zfoo>70 and index<90Tr/   r   )r&   r!   ÚA©r   r   ÚCÚbaré   r&   ©Zinplace)Zfuture_stackÚmi)r   r   Úranger2   Úfloat64r=   r
   r7   r8   Úassert_series_equalÚnameÚselectr   r   r3   r4   r5   Úlenr<   Ú	set_indexÚstackZ	droplevel)	r>   r?   rJ   rK   rM   ÚresultÚexpectedrW   Úsr@   r@   rA   Útest_append_seriesh   sD    "ÿrc   c                 C   s   t | ƒ��à}tttj d¡ d¡ƒ d¡tj d¡ d¡tj d¡ d¡ddtdƒ 	d¡tdƒ 	d¡d	œt 
d¡d
�}t|dƒ tj|jdd…g d¢f< | d|d d… ¡ | d|dd … ¡ tj|d |dd� | ¡ }tj|d< t|dƒ | d|d d… ¡ | d|dd … ¡ tj|d |dd� | ¡ }tj|d< t|dƒ | d|d d… ¡ | d|dd … ¡ tj|d |dd� | ¡ }tj|d< t|dƒ | d|d d… ¡ | d|dd … ¡ tj|d |dd� W d   ƒ n1 �sò0    Y  d S )Nr   r   Zint32rL   rT   ú
2001-01-01rM   ú
2001-01-02)rQ   ÚA1ÚA2r   rS   ÚDÚEr.   r   r   é   )rf   r   rh   ri   r   Tr/   rf   rg   r   ri   r    )r   r   r   r2   r3   r4   r5   Úastyper   Úas_unitr=   r   r;   r<   r7   r8   r9   Úcopy)r>   r?   r$   r   r   r    r@   r@   rA   Útest_append_some_nans—   sJ    ÿ÷ô






rn   c                 C   s  t | ƒ��ô}ttj d¡ d¡tj d¡ d¡dœt d¡d�}tj|jdd…d d …f< t	|dƒ |j
d|d d… d	d
� |j
d|dd … d	d
� tj|d |dd … d	d� t	|dƒ |j
d|d d… dd
� |j
d|dd … dd
� tj|d |d	d� t dd¡�R t	|dƒ | 
d|d d… ¡ | 
d|dd … ¡ t |d |¡ W d   ƒ n1 �sb0    Y  t dd	¡��d t	|dƒ | 
d|d d… ¡ | 
d|dd … ¡ t |d |dd … ¡ ttj d¡ d¡tj d¡ d¡dddœt d¡d�}tj|jdd…d d …f< t	|dƒ |j
d|d d… d	d
� |j
d|dd … d	d
� |d }|}|�rn|dd … }tj||d	d� t	|dƒ |j
d|d d… dd
� |j
d|dd … dd
� tj|d |d	d� ttj d¡ d¡tj d¡ d¡ddtdƒ d¡tdƒ d¡dœt d¡d�}tj|jdd…d d …f< t	|dƒ |j
d|d d… d	d
� |j
d|dd … d	d
� tj|d |d	d� t	|dƒ |j
d|d d… dd
� |j
d|dd … dd
� tj|d |d	d� W d   ƒ n1 �sæ0    Y  W d   ƒ n1 �s0    Y  d S )Nr   r   )rf   rg   r.   r   rj   r$   r   T)Údropnaéüÿÿÿr/   r   Fúio.hdf.dropna_tabler    Zdf4rL   rT   )rf   rg   r   rS   rd   rM   re   )rf   rg   r   rS   rh   ri   )r   r   r2   r3   r4   r5   r=   r;   r<   r   r7   r8   r9   ÚpdÚoption_contextr   rl   )r>   Úusing_infer_stringr?   r$   r`   ra   r@   r@   rA   Útest_append_all_nansÇ   s„    þû


0
üù


ú÷

ru   c              	   C   sf  t | ƒ��F}ttj d¡ d¡ttdƒƒtdddd�d�}|j	 
d ¡|_	t|d	ƒ |jd	|jd d …d d…f d
gd� | d	|jd d …dd …f ¡ t |d	 |¡ | d	d¡}|jdgd�}t ||¡ | d	d¡}|jdg|j	dd… d�}t ||¡ t d¡}tjt|d�� | d	d¡ W d   ƒ n1 �s80    Y  W d   ƒ n1 �sX0    Y  d S )Nr   ©r   r   r   r   r   r   r   r   r   r   )Zaxesú	columns=ArQ   rR   )rw   zindex=df.index[0:4]r   r   zOpassing a filterable condition to a non-table indexer [Filter: Not Initialized]©Úmatchzcolumns=A and index>df.index[4])r   r   r2   r3   r4   r5   r   r6   r
   r   Z
_with_freqr   r7   Úilocr8   r9   r\   ÚreindexÚreÚescapeÚpytestÚraisesÚ	TypeError)r>   r?   r$   r`   ra   Úmsgr@   r@   rA   Ú!test_append_frame_column_oriented#  s,    
ý
$ÿr‚   c              	   C   s^  t | ƒ�ô}tdƒD ]Ú}ttj d¡ d¡tdƒd�}tdƒ|d< |d  |d 7  < tdgt	|ƒ dd	�|d< tdgt	|ƒ d
d	�|d
< |d dkr´|d= tdgt	|ƒ dd	�|d< |d dkrÒ| 
d¡}||d< |jddd� | d|¡ qW d   ƒ n1 �s0    Y  t | ƒ��0}ttj d¡ d¡tdƒdd�}tdgt	|ƒ dd	�|d< tdgt	|ƒ d
d	�|d
< | d|¡ tdgt	|ƒ d
d	�|d< t d¡}tjt|d�� | d|¡ W d   ƒ n1 �sÐ0    Y  tdgt	|ƒ dd	�|d< t d¡}tjt|d�� | d|¡ W d   ƒ n1 �s00    Y  W d   ƒ n1 �sP0    Y  d S )Nr   r   )r   r   ZABrR   r   r!   Zint64r)   Zint16r   rU   rQ   TrV   r$   rY   )r   r*   Zint16_2zCcannot match existing table structure for [int16] on appending datarx   ç      ð?Zfloat_3zAcannot match existing table structure for [A,B] on appending data)r   rX   r   r2   r3   r4   r5   r6   r   r]   Úpopr^   r7   r|   r}   r~   r   Ú
ValueError)r>   r?   rE   r$   Úar�   r@   r@   rA   Ú)test_append_with_different_block_orderingD  sL    
ÿ
.ýÿ,ÿr‡   c              	      s.  t | ƒ��:‰ ‡ fdd„}tddgddggƒ}ˆ  d|¡ t ˆ  d¡|¡ |ddd	ƒ td
dgddggƒ}ˆ  d|¡ t||gƒ}t ˆ  d¡|¡ |ddd	ƒ tddgddggƒ}ˆ jd|ddid� t ˆ  d¡|¡ |dddƒ ˆ  d|¡ td
dgddggƒ}d}tjt	|d�� ˆ  d|¡ W d   ƒ n1 �s<0    Y  tg d¢g d¢t
g d¢ƒtddd�dœƒ d¡}ˆ jd|d  d!d"id� t ˆ  d¡|d  ¡ ˆ jd#|d  d$d!d"id%� t ˆ  d#¡|d  ¡ ˆ jd&|d'd!d(id)� | ¡  ¡ jd*d+� d¡}ˆ  d&|¡ t ˆ  d&¡t||gƒ¡ ˆ jd,|d  d'd!d(id)� ˆ  d,|d  ¡ t ˆ  d,¡t|d  |d  gƒ¡ tˆ d-ƒ ttj d.¡ d/¡t
td0ƒƒtd1d2d d3�d4�}d5|d6< tj|j|jd7d"… d6f< d8|d9< tj|j|jd"d:… d9f< d;|d<< tj|j|jd7d … d<f< ˆ  d-|¡ ˆ  d-¡}t ||¡ W d   ƒ n1 �sL0    Y  t | ƒ��¸‰ td5d8d=œtd2ƒd>�}tˆ d-ƒ ˆ jd-|d?d@id� |d-d?d@ƒ ˆ  d-¡jd?gk�sºJ ‚tˆ d-ƒ ˆ jd-|d gd?d@id%� |d-d?d@ƒ ˆ  d-¡jd d?gk�sJ ‚tˆ d-ƒ ˆ jd-|d gdd@id%� |d-d d@ƒ |d-dAd@ƒ ˆ  d-¡jd gk�sTJ ‚tˆ d-ƒ ˆ jd-|d d… d@d� ˆ jd-|dd … d@d� t ˆ d- |¡ tg dB¢d?gdC�}tˆ d-ƒ t dD¡}tjt	|d��& ˆ jd-|dEdEdFœd� W d   ƒ n1 �s 0    Y  W d   ƒ n1 �s 0    Y  d S )GNc                    s"   t ˆ  | ¡jj|ƒj|ksJ ‚d S ©N©ÚgetattrÚ
get_storerr   ÚdescriptionÚitemsize©Úkeyr[   r(   ©r?   r@   rA   Ú	check_col{  s    ÿz+test_append_with_strings.<locals>.check_colé{   Z	asdqwertyiY  ZdggnhebbsdfbdfbZdf_bigÚvalues_block_1rj   é|   ZasdqyiZ  ZdggnhefbdfbZdf_big2Úvaluesé2   ©Úmin_itemsizeÚdf_newZ
abcdefqhijZabcdefghijklmnopqrtsuvwxyzz¯Trying to store a string with len \[26\] in \[values_block_1\] column but\nthis column has a limit of \[15\]!\nConsider using min_itemsize to preset the sizes on these columnsrx   )ç        rƒ   g       @g      @g      @)rš   rƒ   rš   rƒ   rš   )Zfoo1Zfoo2Zfoo3Zfoo4Zfoo5Ú20130101r&   rH   )rQ   r   rS   rh   rS   rJ   r   r   r   Zss2T©r1   r˜   Zss3r   é   )r   r˜   Zlonger)rS   Zss4r$   r   rv   r   r   r   r   r   rL   Ústringr!   rT   Ústring2é   ZbahZstring3©rQ   r   r.   rQ   éÈ   Zvalues_block_0)rL   rL   rL   Úbarhr£   r£   rR   zBmin_itemsize has the key [foo] which is not an axis or data_columnr   )rL   Zfoobar) r   r   r7   r8   r9   r\   r	   r~   r   r…   r   r
   r^   rZ   r:   rm   Zreset_indexZassignr   r2   r3   r4   r5   r6   r;   r<   r   rX   r‹   r1   r|   r}   )r>   r‘   r$   r   ra   r™   r�   r`   r@   r�   rA   Útest_append_with_stringsx  s¤    ÿ,

üÿù"

ý
,




ÿr¤   c                 C   s†   t | ƒ�j}tdg d¢iƒ}|jd|d d… ddid� |jd|dd … ddid� t | d¡|¡ W d   ƒ n1 sx0    Y  d S )NÚx)r†   ÚbÚcÚdÚeÚfÚ r$   éÿÿÿÿr!   r—   )r   r   r7   r8   r9   r\   )r>   r?   r$   r@   r@   rA   Útest_append_with_empty_stringó  s
    
r­   c           	   	      sà  t | ƒ��Â‰ ttj d¡ d¡ttdƒƒtdddd�d�}d	|j	d
|j
 d¡f< tˆ dƒ ˆ jd|d d… dgd� ˆ  d|dd … ¡ t ˆ d |¡ ˆ jjjjjjjdu s²J ‚ˆ jjjjjjjdu sÌJ ‚ˆ  dd¡}||jd
k }t ||¡ ˆ  dd¡}|j|jdd … d�}||jd
k }t ||¡ | ¡ }d|d< tj|j|jdd… df< d|j|jdd… df< tˆ dƒ ˆ jd|dgd� ˆ  dd¡}||jdk }t ||¡ ‡ fdd„}W d   ƒ n1 �sÔ0    Y  t | ƒ�–‰ tˆ dƒ ˆ jd|dgddid� |dddƒ tˆ dƒ ˆ jd|dgdd� |dddƒ tˆ dƒ ˆ jd|dgddid� |dddƒ W d   ƒ n1 �s„0    Y  t | ƒ�t‰ d|d< d |d!< d"|d#< tˆ dƒ ˆ jd|ddgdd$d%d&œd� |dddƒ |ddd$ƒ |dd'd%ƒ W d   ƒ n1 �s0    Y  t | ƒ��N‰ | ¡ }d	|j	d
|j
 d(¡f< d)|j	d
|j
 d¡f< d|d< |j
 d¡}tj|j	dd…|f< d|j	dd…|f< d|d< |j
 d¡}tj|j	dd…|f< d|j	d*d+…|f< tˆ dƒ ˆ jd|g d,¢d� ˆ  dd-¡}||jdk|jdk@ |jd
k@ |jd
k @  }tj||d.d/� ˆ  dd0¡}||jdk|jd1k@  }t ||¡ W d   ƒ n1 �s|0    Y  t | ƒ��‰ | ¡ }d|d< tj|j|jdd… df< d|j|jd*d2… df< d1|d< t d3ƒ !d4¡|d5< tj|j|jd6d… g d7¢f< tˆ d8ƒ ˆ jd8|g d9¢d� ˆ  d8d¡}||jd
k }t ||¡ ˆ  d8g d:¢¡}||jd
k|j"d
k@ |jdk@  }tj||d.d/� W d   ƒ n1 �s¨0    Y  t | ƒ��‰ td;d+d<�}ttj d¡ d=¡|g d>¢d?�}d|d< tj|j|jdd… df< d|j|jd*d2… df< |dd@g  #¡ |dd@g< d1|d< ˆ jd8|g dA¢d� ˆ  d8d¡}||jd
k }t ||¡ ˆ  d8g dB¢¡}||jd
k|j"d
k@ |jdk@  }t ||¡ W d   ƒ n1 �sÒ0    Y  d S )CNr   rv   r   r   r   r   r   r   rƒ   r   r$   r0   TúB>0zB>0 and index>df.index[3]r   r.   rL   rž   r!   rT   r&   r�   zstring='foo'c                    s"   t ˆ  | ¡jj|ƒj|ksJ ‚d S rˆ   r‰   rŽ   r�   r@   rA   r‘   $  s    ÿz0test_append_with_data_columns.<locals>.check_colé   rœ   r•   Z	foobarbahrŸ   Z
foobarbah1Zstring_block1Z
foobarbah2Zstring_block2é(   r–   )rž   rŸ   r•   r“   rQ   g      ð¿é   r    )rQ   r   rž   rŸ   z.string='foo' and string2='foo' and A>0 and B<0F)Z
check_freqzstring='foo' and string2='cool'Úcoolé	   Z20010102rM   ÚdatetimerU   )rQ   r   r´   Údf_dc)r   rS   rž   rŸ   r´   )úB > 0úC > 0zstring == fooz1/1/2000rH   )r    rU   )rQ   r   rS   )r   r   rS   )r   rS   rž   rŸ   )r¶   r·   zstring == "foo")$r   r   r2   r3   r4   r5   r   r6   r
   rz   r   Zget_locr   r7   r8   r9   Z_handleÚrootr$   r   Úcolsr   Z
is_indexedr   r\   r{   rm   r;   r<   rž   rŸ   rQ   r   rl   rS   Úabs)	r>   r$   r`   ra   r™   r‘   Úslrµ   r   r@   r�   rA   Útest_append_with_data_columnsü  sî    
ý

,



,


ü,
ÿþýÿ,

ÿ"0ý"r¼   c                 C   sÎ   |}d |j _t|ƒ�`}| d|¡ | d¡}t ||¡ |jdddgd�}|jddgd�}t ||¡ W d   ƒ n1 sz0    Y  | d }|j|ddd� t	|dddgd�}|jddgd�}t ||¡ d S )	NrW   rQ   r   rR   ztest.hdfr$   r   )r�   r   )
r   r[   r   r7   r\   r8   r9   r{   Zto_hdfr   )Ztmp_pathr>   Z multiindex_dataframe_random_datar$   r?   r`   ra   Úpathr@   r@   rA   Útest_append_hierarchical—  s    

*r¾   c                 C   s°   t | ƒ�”}tdt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}|jd	|d
d� | 	d	¡}t
 ||¡ |jd|dd� | 	d¡}t
 ||¡ W d   ƒ n1 s¢0    Y  d S )Nçš™™™™™ñ?éx   ©r¯   r   r   c                 S   s   g | ]}d |› �‘qS ©zi-r@   rC   r@   r@   rA   rF   ±  rG   z$test_append_misc.<locals>.<listcomp>r¯   r   r$   r!   ©Ú	chunksizer   r   )Zexpectedrows)r   r   r2   r=   Úreshaper   r6   rX   r7   r\   r8   r9   )r>   r?   r$   r`   r@   r@   rA   Útest_append_misc¬  s    

ý

rÆ   rÄ   )r   r¢   iè  c                 C   sä   t dt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}d	|d
< d|d< |d  d¡|d< |d dk|d< tdƒ 	d¡|d< tdƒ 	d¡|d< t
| dd��6}|jd||d� | d¡}t ||¡ W d   ƒ n1 sÖ0    Y  d S )Nr¿   rÀ   rÁ   r   c                 S   s   g | ]}d |› �‘qS rÂ   r@   rC   r@   r@   rA   rF   Â  rG   z.test_append_misc_chunksize.<locals>.<listcomp>r¯   r   rL   rž   rƒ   Zfloat322Zfloat32r   Úboolr›   rM   Ztime1Z20130102Ztime2Úw)ÚmodeÚobjrÃ   )r   r2   r=   rÅ   r   r6   rX   rk   r   rl   r   r7   r\   r8   r9   )r>   rÄ   r$   r?   r`   r@   r@   rA   Útest_append_misc_chunksize¼  s    
ý
rË   c              	   C   s  t | ƒ�è}ttdƒd�}| d|¡ tjtdd�� | d¡ W d   ƒ n1 sR0    Y  ttj	 
d¡ 	d¡tdƒd�}| d|¡ t | d¡|¡ | d|¡ t | d¡|¡ ttdƒd�}| d|¡ t | d¡|¡ W d   ƒ n1 sö0    Y  d S )	NÚABCrR   r$   z 'No object named df in the file'rx   r   )r   rU   r   )r   r   r6   r7   r~   r   ÚKeyErrorr\   r2   r3   r4   r8   r9   r:   )r>   r?   Zdf_emptyr$   r@   r@   rA   Útest_append_misc_empty_frameÐ  s    
(rÎ   c              	   C   s–  t | ƒ��v}tdt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}d	ggt|ƒ |d
< |j	d
 tj
kslJ ‚t d¡}tjt|d�� | d|¡ W d   ƒ n1 s¦0    Y  d	ggt|ƒ |d< d	ggt|ƒ |d< tjt|d�� | d|¡ W d   ƒ n1 �s
0    Y  tdt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}tt ddd¡|jd�}| t¡}tj|dd…< ||d
< |j	d
 tj
k�sšJ ‚d}tjt|d�� | d|¡ W d   ƒ n1 �sÐ0    Y  d}tjt|d��" | dt d¡¡ W d   ƒ n1 �s0    Y  t d¡}tjt|d��& | dtt d¡ƒ¡ W d   ƒ n1 �sf0    Y  tdt d¡ d¡ ttdƒƒtdd„ tdƒD ƒƒd�}| d|¡ d|d< t d¡}tjt|d�� | d|¡ W d   ƒ n1 �sø0    Y  t|dƒ tdƒ|d< | d|¡ d|d< t d ¡}tjt|d�� | d|¡ W d   ƒ n1 �sh0    Y  W d   ƒ n1 �sˆ0    Y  d S )!Nr¿   rÀ   rÁ   r   c                 S   s   g | ]}d |› �‘qS rÂ   r@   rC   r@   r@   rA   rF   ò  rG   z%test_append_raise.<locals>.<listcomp>r¯   r   r†   ÚinvalidziCannot serialize the column [invalid]
because its data contents are not [string] but [mixed] object dtyperx   r$   Zinvalid2Zinvalid3c                 S   s   g | ]}d |› �‘qS rÂ   r@   rC   r@   r@   rA   rF     rG   iÑ  r!   r   r.   r   r&   z>too many timezones in this block, create separate data columnsz(value must be None, Series, or DataFramer   z]cannot properly create the storer for: [group->df,value-><class 'pandas.core.series.Series'>]c                 S   s   g | ]}d |› �‘qS rÂ   r@   rC   r@   r@   rA   rF   #  rG   rL   z‰invalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]r›   rT   zmCannot serialize the column [foo] because its data contents are not [string] but [datetime64[s]] object dtype)r   r   r2   r=   rÅ   r   r6   rX   r]   ZdtypesZobject_r|   r}   r~   r   r€   r7   r   r´   r   rk   Úobjectr;   r…   r   r   )r>   rt   r?   r$   r�   rb   r@   r@   rA   Útest_append_raiseé  sv    
ýÿ*,
ý
,2ÿ6
ýÿ,
ÿrÑ   c                    s¢  t dƒ d¡‰ tˆ ‡ fdd„tdƒD ƒdœƒ}|d |d  |d	< tj|jd
d…d	f< t| ƒ��,}t|dƒ |j	d|dd� | 
d¡}t ||¡ |j
ddd�}t ||¡ |j
ddd�}t ||jd
d … ¡ | 
dd¡}t ||jd
d … ¡ | 
dd¡}|jd	gd�}t ||jdd … ¡ | 
dd¡}|jdd … }t ||jdd … ¡ t|dƒ | d|¡ | 
d¡}t ||¡ W d   ƒ n1 �s”0    Y  d S )Nr›   rM   c                    s   g | ]}ˆ t |d d� ‘qS )r   )ÚdaysÚsecondsr   rC   ©rK   r@   rA   rF   F  rG   z.test_append_with_timedelta.<locals>.<listcomp>r   r¡   rQ   r   rS   rU   r&   r$   Tr0   zC<100000)ÚwherezC<pd.Timedelta('-3D')zC<'-3D'zC<'-500000s')Zsubsetr�   z	C<'-3.5D'r!   r   r   )r   rl   r   rX   r2   r;   r<   r   r   r7   r\   r8   r9   rz   ro   r:   )r>   r$   r?   r`   r@   rÔ   rA   Útest_append_with_timedelta>  s:    þÿ



rÖ   c              	   C   s°  t tj d¡ d¡ttdƒƒtdddd�d�}| ¡ j	d	j
d
�}d|d< t||gdd�}t| ƒ��8}d}tjt|d��* |jddgd dœ|dd� W d   ƒ n1 s¦0    Y  tjt|d��& |jd d dœ|dd� W d   ƒ n1 sê0    Y  d}tjt|d�� | d|d¡ W d   ƒ n1 �s,0    Y  |jddgd dœ|dd� |jddgddgdd�}||jdk|jdk@  }t ||¡ W d   ƒ n1 �s¢0    Y  d S )Nr   rv   r   r   r   r   r   r   ú{}_2rR   rT   rL   r!   ©Zaxisz=append_to_multiple requires a selector that is in passed dictrx   rQ   ©r   r   r    )ÚselectorzQappend_to_multiple must have a dictionary specified as the way to split the valuer   r   zA>0r®   )rÕ   rÚ   r   )r   r2   r3   r4   r5   r   r6   r
   rm   Úrenamer   r	   r   r~   r   r…   Úappend_to_multipleÚselect_as_multiplerQ   r   r8   r9   )r>   r   r   r$   r?   r�   r`   ra   r@   r@   rA   Útest_append_to_multiplem  s4    
ýÿ$4ÿ.ÿrÞ   c                 C   s  t tj d¡ d¡ttdƒƒtdddd�d�}t tj d¡ d¡ttdƒƒtdddd�d�jd	j	d
�}tj
|jd|j ddg¡f< t||gdd�}t| ƒ�n}|jddgd dœ|ddd� | ddg¡}| ¡ }tj||dd� t | d¡j| d¡j¡ W d   ƒ n1 �s0    Y  d S )Nr   rv   r   r   r   r   r   r   r×   rR   r!   rQ   rØ   rÙ   r   T©rÚ   ro   r   r/   )r   r2   r3   r4   r5   r   r6   r
   rÛ   r   r;   rz   r   Úget_indexerr	   r   rÜ   rÝ   ro   r8   r9   Zassert_index_equalr\   r   )r>   r   r   r$   r?   r`   ra   r@   r@   rA   Útest_append_to_multiple_dropna’  s,    
ý
ýü
ÿrá   c              
   C   sB  t tj d¡ d¡ttdƒƒtdddd�d�}| ¡ j	d	j
d
�}tj|jd|j ddg¡f< t||gdd�}t| ƒ�¸}t dd¡�Š |jddgd dœ|ddd� d}tjt|d�� | ddg¡ W d   ƒ n1 sÖ0    Y  | d¡j | d¡j¡rþJ ‚W d   ƒ n1 �s0    Y  W d   ƒ n1 �s40    Y  d S )Nr   rv   r   r   r   r   r   r   r×   rR   r!   rQ   rØ   rq   T)Údf1aÚdf2arâ   Frß   z,all tables must have exactly the same nrows!rx   rã   )r   r2   r3   r4   r5   r   r6   r
   rm   rÛ   r   r;   rz   r   rà   r	   r   rr   rs   rÜ   r~   r   r…   rÝ   r\   r   Úequals)r>   r   r   r$   r?   r�   r@   r@   rA   Ú$test_append_to_multiple_dropna_false«  s$    
ýÿÿ,rå   c              	   C   sÖ   t t dd¡t dd¡t dd¡d dd„ tdƒD ƒdd„ tdƒD ƒdœƒ}|jd	g }t| ƒ�b}|jd
gddgddgdœ|jd	g dddddœd� | g d¢¡}tj	||dd� W d   ƒ n1 sÈ0    Y  d S )Nr!   é   éX   c                 S   s   g | ]}d ‘qS )r†   r@   ©rD   Ú_r@   r@   rA   rF   Ë  rG   z8test_append_to_multiple_min_itemsize.<locals>.<listcomp>r   c                 S   s   g | ]}d ‘qS )Zabcder@   rè   r@   r@   rA   rF   Ì  rG   )ÚIXÚNumÚBigNumÚStrÚLongStrr   rê   rë   rì   rí   rî   )r   ZnumsÚstrsr   r   rI   r   )rí   rî   rë   r—   Tr/   )
r   r2   r=   rX   rz   r   rÜ   rÝ   r8   r9   )r>   r$   ra   r?   r`   r@   r@   rA   Ú$test_append_to_multiple_min_itemsizeÄ  s*    

ûÿ	
ý

ø
rð   c              	   C   sV  t dddœt d¡d�}| ¡ }tj|jdd…d d …f< d}t| ƒ�ü}| d	|d
 ¡ tj	t
|d��  | d	|d
 ¡ W d   ƒ n1 sŠ0    Y  |jd|d dd� tj	t
|d��  | d|d ¡ W d   ƒ n1 sÜ0    Y  |jd|d
 dd� | d|d
 ¡ |d }t|d
 |d
 gƒ}t ||¡ W d   ƒ n1 �sH0    Y  d S )Nr†   rL   r¡   r   r.   r   r   z8NaN representation is too large for existing column sizeÚsarQ   rx   Úsbr   Zbars)Znan_repÚscÚn)r   r2   r=   rm   r;   r<   r   r7   r~   r   r…   r	   r8   rZ   )r>   r$   Zdf_nanr�   r?   r`   ra   r@   r@   rA   Útest_append_string_nan_repà  s     
..rõ   )5r´   r   r|   Únumpyr2   r~   Zpandas._libs.tslibsr   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsÚtdZpandasrr   r   r   r   r   r8   r	   r
   r   Zpandas.tests.io.pytables.commonr   r   ÚmarkZ
single_cpuZ
pytestmarkZimportorskipr   ÚfilterwarningsrB   rc   rn   ru   r‚   r‡   r¤   r­   r¼   r¾   rÆ   ZparametrizerË   rÎ   Z&skip_array_manager_not_yet_implementedrÑ   rÖ   rÞ   rá   rå   rð   rõ   r@   r@   r@   rA   Ú<module>   sF   $	



H/0\!4{	 

T/%