o
    &zh,                     @   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 | D}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    d S 1 sMw   Y  d S )'N   )      ABCD
2000-01-01r   Bperiodsfreqcolumnsindexdf1
   df2table)formatdf3z/df3z/df3 foozdf3 foo   r   )datatestingmixed_column)r   r$   df      )highsizedtypei  i   @)l           l          @l            l            l            )u08u16u32u64r   uintsT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   integersuint8uint16uint32uint64arange)
setup_pathstorer%   	uint_data rJ   _/var/www/html/kangema/venv/lib/python3.10/site-packages/pandas/tests/io/pytables/test_append.pytest_append   sn   




"


$rL   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 sDJ |d| |d }t	|| |j
d u s[J d|_
|d| |d }t	|| |j
|j
ksvJ ||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    d S 1 sw   Y  d S )"Nr   c                 S      g | ]}d | qS )i_rJ   .0irJ   rJ   rK   
<listcomp>k       z&test_append_series.<locals>.<listcomp>)r+   r   r   r*   z
2020-01-01r   r0   d   sstsfoons<   zfoo>60F   Z   zfoo>70 and index<90Tr2   r   )r'   r!   Ar   r   Cbar   r'   inplace)future_stackmi)r   r   ranger6   float64rF   r
   r;   r<   assert_series_equalnameselectr   r   r7   r8   r9   lenr@   	set_indexstack	droplevel)	rG   rH   rV   rW   rY   resultexpectedre   srJ   rJ   rK   test_append_seriesh   sF   
""rr   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    d S 1 sw   Y  d S )Nr   r   int32rX   r`   
2001-01-01rY   
2001-01-02)r]   A1A2r   r_   DEr0   r   r      )rv   r   rx   ry   r   Tr2   rv   rw   r   ry   r    )r   r   r   r6   r7   r8   r9   astyper   as_unitrF   r   r?   r@   r;   r<   r=   copy)rG   rH   r%   r   r   r    rJ   rJ   rK   test_append_some_nans   sL   







"r~   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) t	|d |
d|d d  |
d|dd   t|d | W d    n1 sw   Y  tdd	2 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 }|}|r6|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 sw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   )rv   rw   r0   r   rz   r%   r   T)dropnar2   r   Fio.hdf.dropna_tabler    df4rX   r`   )rv   rw   r   r_   rt   rY   ru   )rv   rw   r   r_   rx   ry   )r   r   r6   r7   r8   r9   rF   r?   r@   r   r;   r<   r=   pdoption_contextr   r|   )rG   using_infer_stringrH   r%   ro   rp   rJ   rJ   rK   test_append_all_nans   s   








 $r   c              	   C   sr  t | }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 sw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r   r   r   )axes	columns=Ar]   r^   )r   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   r6   r7   r8   r9   r   r:   r
   r   
_with_freqr   r;   ilocr<   r=   rj   reindexreescapepytestraises	TypeError)rG   rH   r%   ro   rp   msgrJ   rJ   rK   !test_append_frame_column_oriented#  s4   


$"r   c              	   C   sj  t | z}tdD ]m}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rZ|d= tdgt	| dd	|d< |d dkri|
d}||d< |jddd |d| q	W d    n1 sw   Y  t | }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 sw   Y  tdgt	| dd	|d< td}tjt|d |d| W d    n1 sw   Y  W d    d S W d    d S 1 s.w   Y  d S )Nr   r   )r   r   ABr^   r   r!   int64r*   int16r   ra   r]   Trb   r%   rg   )r   r+   int16_2zCcannot match existing table structure for [int16] on appending datar         ?float_3zAcannot match existing table structure for [A,B] on appending data)r   rf   r   r6   r7   r8   r9   r:   r   rk   poprl   r;   r   r   r   r   
ValueError)rG   rH   rQ   r%   ar   rJ   rJ   rK   )test_append_with_different_block_orderingD  sZ   


 $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 sw   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 sw   Y  t |  td5d8d=td2d>}t d-  jd-|d?d@id |d-d?d@  d-jd?gksJ t d-  jd-|d gd?d@id% |d-d?d@  d-jd d?gksJ t d-  jd-|d gdd@id% |d-d d@ |d-dAd@  d-jd gks(J 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~w   Y  W d    d S W d    d S 1 sw   Y  d S )GNc                    "   t  | jj|j|ksJ d S Ngetattr
get_storerr   descriptionitemsizekeyri   r)   rH   rJ   rK   	check_col{     "z+test_append_with_strings.<locals>.check_col{   	asdqwertyiY  dggnhebbsdfbdfbdf_bigvalues_block_1rz   |   asdqyiZ  dggnhefbdfbdf_big2values2   min_itemsizedf_new
abcdefqhijabcdefghijklmnopqrtsuvwxyzzTrying 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 columnsr   )        r   g       @g      @g      @)r   r   r   r   r   )foo1foo2foo3foo4foo520130101r'   rT   )r]   r   r_   rx   r_   rV   r   r   r   ss2Tr5   r   ss3r      )r   r   longer)r_   ss4r%   r   r   r   r   r   r   r   rX   stringr!   r`   string2   bahstring3r]   r   r0   r]      values_block_0)rX   rX   rX   barhr   r   r^   zBmin_itemsize has the key [foo] which is not an axis or data_columnr   )rX   foobar) r   r   r;   r<   r=   rj   r	   r   r   r   r   r
   rl   rh   r>   r}   reset_indexassignr   r6   r7   r8   r9   r:   r?   r@   r   rf   r   r5   r   r   )rG   r   r%   r   rp   r   r   ro   rJ   r   rK   test_append_with_stringsx  s   

"



T




 "$r   c                 C   s   t | 6}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    d S 1 s=w   Y  d S )Nx)r   bcdef r%   r!   r   )r   r   r;   r<   r=   rj   )rG   rH   r%   rJ   rJ   rK   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 sXJ  jjjjjjjdu seJ  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 sw   Y  t | K 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@w   Y  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 sw   Y  t |  | }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;w   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 sw   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    d S 1 sew   Y  d S )CNr   r   r   r   r   r   r   r   r   r   r%   r4   TB>0zB>0 and index>df.index[3]r   r0   rX   r   r!   r`   r'   r   zstring='foo'c                    r   r   r   r   r   rJ   rK   r   $  r   z0test_append_with_data_columns.<locals>.check_col   r   r   	foobarbahr   
foobarbah1string_block1
foobarbah2string_block2(   r   )r   r   r   r   r]   g         r   )r]   r   r   r   z.string='foo' and string2='foo' and A>0 and B<0F)
check_freqzstring='foo' and string2='cool'cool	   20010102rY   datetimera   )r]   r   r   df_dc)r   r_   r   r   r   )B > 0C > 0zstring == fooz1/1/2000rT   )r   ra   )r]   r   r_   )r   r   r_   )r   r_   r   r   )r   r   zstring == "foo")$r   r   r6   r7   r8   r9   r   r:   r
   r   r   get_locr   r;   r<   r=   _handlerootr%   r   colsr   
is_indexedr   rj   r   r}   r?   r@   r   r   r]   r   r|   r_   abs)	rG   r%   ro   rp   r   r   slr   r   rJ   r   rK   test_append_with_data_columns  s   




,








 

"
"$r   c                 C   s   |}d |j _t|0}|d| |d}t|| |jdddgd}|jddgd}t|| W d    n1 s=w   Y  | d }|j|ddd t	|dddgd}|jddgd}t|| d S )	Nre   r]   r   r^   ztest.hdfr%   r   )r   r   )
r   ri   r   r;   rj   r<   r=   r   to_hdfr   )tmp_pathrG    multiindex_dataframe_random_datar%   rH   ro   rp   pathrJ   rJ   rK   test_append_hierarchical  s   


r   c                 C   s   t | K}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    d S 1 sRw   Y  d S )N皙?x   r   r   r   c                 S   rM   zi-rJ   rO   rJ   rJ   rK   rR     rS   z$test_append_misc.<locals>.<listcomp>r   r   r%   r!   	chunksizer   r   )expectedrows)r   r   r6   rF   reshaper   r:   rf   r;   rj   r<   r=   )rG   rH   r%   ro   rJ   rJ   rK   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}|jd||d |d}t|| W d    d S 1 slw   Y  d S )Nr   r   r   r   c                 S   rM   r   rJ   rO   rJ   rJ   rK   rR     rS   z.test_append_misc_chunksize.<locals>.<listcomp>r   r   rX   r   r   float322float32r   boolr   rY   time120130102time2w)modeobjr  )r   r6   rF   r  r   r:   rf   r{   r   r|   r   r;   rj   r<   r=   )rG   r  r%   rH   ro   rJ   rJ   rK   test_append_misc_chunksize  s    

"r  c              	   C   s  t | u}ttdd}|d| tjtdd |d W d    n1 s)w   Y  ttj	
d	dtdd}|d| t|d| |d| t|d| ttdd}|d| t|d| W d    d S 1 s|w   Y  d S )	NABCr^   r%   z 'No object named df in the file'r   r   )r   ra   r   )r   r   r:   r;   r   r   KeyErrorrj   r6   r7   r8   r<   r=   r>   )rG   rH   df_emptyr%   rJ   rJ   rK   test_append_misc_empty_frame  s   
"r  c              	   C   s  t | }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s6J td}tjt|d |d| W d    n1 sSw   Y  d	ggt| |d< d	ggt| |d< tjt|d |d| W d    n1 sw   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sJ d}tjt|d |d| W d    n1 sw   Y  d}tjt|d |dtd W d    n	1 sw   Y  td}tjt|d |dttd W d    n	1 s0w   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 syw   Y  t|d td|d< |d| d|d< td }tjt|d |d| W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )!Nr   r   r   r   c                 S   rM   r   rJ   rO   rJ   rJ   rK   rR     rS   z%test_append_raise.<locals>.<listcomp>r   r   r   invalidziCannot serialize the column [invalid]
because its data contents are not [string] but [mixed] object dtyper   r%   invalid2invalid3c                 S   rM   r   rJ   rO   rJ   rJ   rK   rR     rS   i  r!   r   r0   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   rM   r   rJ   rO   rJ   rJ   rK   rR   #  rS   rX   zinvalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]r   r`   zmCannot serialize the column [foo] because its data contents are not [string] but [datetime64[s]] object dtype)r   r   r6   rF   r  r   r:   rf   rk   dtypesobject_r   r   r   r   r   r;   r   r   r   r{   objectr?   r   r   r   )rG   r   rH   r%   r   rq   rJ   rJ   rK   test_append_raise  s   




 O$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    d S 1 sw   Y  d S )Nr   rY   c                    s   g | ]
} t |d d qS )r   )dayssecondsr   rO   rW   rJ   rK   rR   F  s    z.test_append_with_timedelta.<locals>.<listcomp>r   r   r]   r   r_   ra   r'   r%   Tr4   zC<100000)wherezC<pd.Timedelta('-3D')zC<'-3D'zC<'-500000s')subsetr   z	C<'-3.5D'r!   r   r   )r   r|   r   rf   r6   r?   r@   r   r   r;   rj   r<   r=   r   r   r>   )rG   r%   rH   ro   rJ   r  rK   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| }d}tjt|d |jddgd d|dd W d    n1 sRw   Y  tjt|d |jd d d|dd W d    n1 stw   Y  d}tjt|d |d|d W d    n1 sw   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    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   {}_2r^   r`   rX   r!   axisz=append_to_multiple requires a selector that is in passed dictr   r]   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   r6   r7   r8   r9   r   r:   r
   r}   renamer   r	   r   r   r   r   append_to_multipleselect_as_multipler]   r   r<   r=   )rG   r   r   r%   rH   r   ro   rp   rJ   rJ   rK   test_append_to_multiplem  s<   

"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| 8}|jddgd d|ddd |ddg}| }tj||dd t|dj|dj W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r!  r^   r!   r]   r"  r$  r   Tr%  r   r   r2   )r   r6   r7   r8   r9   r   r:   r
   r&  r   r?   r   r   get_indexerr	   r   r'  r(  r   r<   r=   assert_index_equalrj   r   )rG   r   r   r%   rH   ro   rp   rJ   rJ   rK   test_append_to_multiple_dropna  s.   


"r-  c              
   C   sP  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| d}tddE |jddgd d|ddd d}tjt|d |ddg W d    n1 skw   Y  |dj|djrJ W d    n1 sw   Y  W d    d S W d    d S 1 sw   Y  d S )Nr   r   r   r   r   r   r   r   r!  r^   r!   r]   r"  r   T)df1adf2ar.  Fr*  z,all tables must have exactly the same nrows!r   r/  )r   r6   r7   r8   r9   r   r:   r
   r}   r&  r   r?   r   r   r+  r	   r   r   r   r'  r   r   r   r(  rj   r   equals)rG   r   r   r%   rH   r   rJ   rJ   rK   $test_append_to_multiple_dropna_false  s(   
 Pr1  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| 2}|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    d S 1 sew   Y  d S )Nr!      X   c                 S      g | ]}d qS )r   rJ   rP   _rJ   rJ   rK   rR         z8test_append_to_multiple_min_itemsize.<locals>.<listcomp>r   c                 S   r4  )abcderJ   r5  rJ   rJ   rK   rR     r7  )IXNumBigNumStrLongStrr   r9  r:  r;  r<  r=  )r   numsstrsr   r   rU   r   )r<  r=  r:  r   Tr2   )
r   r6   rF   rf   r   r   r'  r(  r<   r=   )rG   r%   rp   rH   ro   rJ   rJ   rK   $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 sEw   Y  |jd|d dd tj	t
|d |d|d  W d    n1 snw   Y  |jd|d
 dd |d|d
  |d }t|d
 |d
 g}t|| W d    d S 1 sw   Y  d S )Nr   rX   r   r   r0   r   r   z8NaN representation is too large for existing column sizesar]   r   sbr   bars)nan_repscn)r   r6   rF   r}   r?   r@   r   r;   r   r   r   r	   r<   rh   )rG   r%   df_nanr   rH   ro   rp   rJ   rJ   rK   test_append_string_nan_rep  s&   
"rH  )5r   r   r   numpyr6   r   pandas._libs.tslibsr   pandas.util._test_decoratorsutil_test_decoratorstdpandasr   r   r   r   r   r<   r	   r
   r   pandas.tests.io.pytables.commonr   r   mark
single_cpu
pytestmarkimportorskipr   filterwarningsrL   rr   r~   r   r   r   r   r   r   r   r  parametrizer  r  &skip_array_manager_not_yet_implementedr  r   r)  r-  r1  r@  rH  rJ   rJ   rJ   rK   <module>   sH    $	



H/0\!4{	 

T/%