Owg<ddlZddlmZddlZddlZddlZddlmZddlm cm Z ddl Z ddl mZmZmZmZmZmZmZddlmZmZej2j4Zej8dZej2j=ddZd Z d Z!d Z"d Z#d Z$dZ%dZ&dZ'dZ(dZ)ej2jUdgddZ+dZ,e jZdZ.dZ/dZ0dZ1dZ2dZ3y)N) timedelta) Timestamp) DataFrameIndexSeries_testingconcat date_rangeread_hdf) _maybe_removeensure_clean_storetablesz!ignore::tables.NaturalNameWarningc zt|5}ttjj dj dt tdttddd }t|d |jd |dd |jd |d dtj|d |t|d |jd |dd d |jd |d dtj|d |t|d|jd|dd |jd|d dtj|d|t|d|jd|dd |jd|d dtj|d|tddgddgddgddgg}d|d<tj|j d<t|d|jd|tj|d|tt#tjj dj%dddtj&t#tjj dj%dddtj(t#tjj dj%dddtj*t#gdtj,d tj.d!}t|d"|jd"|tj|d"|d#$t|d"|jd"|gd%&tj|d"|d#$dddy#1swYyxYw)'N)ABCDdtype 2000-01-01rBperiodsfreqcolumnsindexdf1 df2table)formatdf3z/df3z/df3 foozdf3 foor)datatesting mixed_column)rr'df)highsizeii@)l l@lll)u08u16u32u64ruintsTcheck_index_type)r-r.r/ data_columns)r rnprandom default_rngstandard_normalrlistobjectr r appendtmassert_frame_equalputnanlocrintegersuint8uint16uint32uint64arange) setup_pathstorer( uint_datas [/var/www/horilla/myenv/lib/python3.12/site-packages/pandas/tests/io/pytables/test_append.py test_appendrMs0 J 'DP5 II ! !! $ 4 4W =$v,f5\2C@  eU# UBsG$ UBrsG$ eElB/eU# %CR 1 UBrsG$ eElB/eU# VRW% VRW% eElB/ eZ( ZCR) ZBC) eI.3aVaVaVaV< =&>$&FF !eT" T2 eDk2.II))!,55ac5J((II))!,55ae!5L))II))!,55ae!5L))7)) $))A,' * eW% Wi( eGni$O eW% Wi6K L eGni$OIDPDPDPs NN11N:c t|5}ttdtjtdDcgc]}d| c}}ttj dtjt dd}ttj d }|jd ||d }tj|||jJ|jd ||d }tj|||jJd |_ |jd ||d }tj|||j|jk(sJ||dkD}|jd d}tj||||dkD|jdkz}|jd d}tj||dttjjdj!ddg}tj t#||d<d |d<d|j$dddf<|j'ddgd|j)d} | jj+d| _ |jd | tj|d | ddddycc}w#1swYyxYw)!Nri_)rrrrz 2020-01-01rr1dsstsfoons<zfoo>60FZzfoo>70 and index<90Tr3r)r*r$ArrCbarr*inplace) future_stackmi)r rranger7float64rHr r=r>assert_series_equalnameselectrrr8r9r:lenrB set_indexstack droplevel) rIrJirRrSrUresultexpectedrass rLtest_append_seriesrohsu J '+F5 E"IRZZ%PR)7TQ"QC7T U  IIb +:lTV3W BIIcN # T2t vr*{{""" T2t vr*{{""" T2t vr*{{bgg%%%b2g;dH- vx0rBw288b=12d$9: vx$Gryy,,Q/??GRUQV W))CG$33 qsCx c3Z . HH$H '''##A& T1 uT{AEW+F+F7T+F+Fs,K K I?K KKc t|5}tttjj dj djdtjj dj dtjj dj dddtdjdtdjdd tjd }t|d tj|jd d gdf<|jd |dd|jd |ddtj |d |d|j#}tj|d<t|d |jd |dd|jd |ddtj |d |d|j#}tj|d<t|d|jd|dd|jd|ddtj |d|d|j#}tj|d<t|d|jd|dd|jd|ddtj |d|ddddy#1swYyxYw)Nrrint32rTr\ 2001-01-01rU 2001-01-02)rYA1A2rr[DEr1rr)rtrrvrwrTr3rtrur rwr#)r rrr7r8r9r:astyperas_unitrHr rArBr=r>r?copy)rIrJr(rr r#s rLtest_append_some_nansr|sf J ',H5 BII11!4DDRHIPPii++A.>>rBii++A.>>rB|,44T:|,44T: ))B-   eU#.0ffqt**+ UBsG$ UBrsG$ eElBFggiFFD eU# UCH% UCH% eElC$GggiFFD eU# UCH% UCH% eElC$Gggi66CeU# UCH% UCH% eElC$GY,H,H,Hs KKK#c V t|5}ttjj dj dtjj dj ddtj d}tj|jddddf<t|d|jd|ddd |jd|ddd tj|d|d dd t|d |jd |ddd |jd |ddd tj|d |d tjdd5t|d|jd|dd|jd|ddtj|d|dddtjdd 5t|d|jd|dd|jd|ddtj|d|d dttjj dj dtjj dj ddddtj d}tj|jddddf<t|d|jd|ddd |jd|ddd tj|d|d t|d |jd |ddd |jd |ddd tj|d |d ttjj dj dtjj dj dddtdj!dtdj!ddtj d}tj|jddddf<t|d|jd|ddd |jd|ddd tj|d|d t|d |jd |ddd |jd |ddd tj|d |d ddddddy#1swYJxYw#1swYxYw#1swYyxYw)Nrr)rtrur1rrxr(rT)dropnar3r Fio.hdf.dropna_tabler#df4rTr\)rtrurr[rrrUrs)rtrurr[rvrw)r rr7r8r9r:rHrArBr r=r>r?pdoption_contextrrzrIrJr(s rLtest_append_all_nansrs J 'RK5 ii++A.>>rBii++A.>>rB ))B-  &&qtQw eT" T2cr74 0 T2bc74 0 eDk2bc7TJ eU# UBsGE 2 UBrsGE 2 eElBF  4e < 4 % ' LL3B ( LL23 (  ! !%, 3  4   4d ;5 K % ' LL3B ( LL23 (  ! !%,23 8))//2BB2F))//2BB2F  iimB!ffBFF1R47O % & LLr#2wtL 4 LLr"#wtL 4  ! !%+rD I % ' LL3BL 6 LL23L 6  ! !%,T J))//2BB2F))//2BB2F"<088>"<088> iim B!ffBFF1R47O % & LLr#2wtL 4 LLr"#wtL 4  ! !%+rD I % ' LL3BL 6 LL23L 6  ! !%,T Jk5 K;RKRK. 4 4 5 K5 K;RKRKs>E"T.AT>TLT5TT TT TT(c t|5}ttjj dj dt tdttddd }|jjd|_ t|d |jd |jddddfd g |jd |jddddftj |d ||j#d d }|j%dg}tj |||j#d d}|j%dg|jdd }tj ||t'j(d}t+j,t.|5|j#d dddddddy#1swYxYw#1swYyxYw)Nrrrrrrrrrrrr)axes columns=ArYrZ)rzindex=df.index[0:4]rrzOpassing a filterable condition to a non-table indexer [Filter: Not Initialized]matchzcolumns=A and index>df.index[4])r rr7r8r9r:rr;r<r r _with_freqr r=ilocr>r?rfreindexreescapepytestraises TypeError)rIrJr(rlrmmsgs rL!test_append_frame_column_orientedrs J 'C5  II ! !! $ 4 4W =$v,f5\2C@  88&&t,eU# UBGGArrEN) = UBGGAqrEN+ eElB/e[1::se:, h/e%IJ::se288Aa=:A h/ii ( ]]9C 0 C LL A B C9CC8 C C9CCs$F%G!1GG!G G!!G*ct|5}tdD]}ttjj dj dtd}td|d<|dxx|dzz cc<tdgt|zd |d<tdgt|zd |d <|dzd k(r |d=tdgt|zd |d<|d zd k(r|jd }||d <|jdd|jd|  dddt|5}ttjj dj dtdd}tdgt|zd |d<tdgt|zd |d <|jd|tdgt|zd |d<tjd}tj t"|5|jd|dddtdgt|zd |d<tjd}tj t"|5|jd|ddddddy#1swY~xYw#1swYxYw#1swY+xYw#1swYyxYw)Nrr)rrABrZrr$int64rint16rr]rYTr^r(rc)rrint16_2zCcannot match existing table structure for [int16] on appending datar?float_3zAcannot match existing table structure for [A,B] on appending data)r rbrr7r8r9r:r;rrgpoprhr=rrrr ValueError)rIrJrkr(ars rL)test_append_with_different_block_orderingr>s~ J '#5r #A %%a(88A4PT:B )BwK wK1r6 !K !s2wg>BwK !s2wg>BwK1uzwK$aS3r7]'B7 1uzFF3K3 LL$L / LLr "% ##. J '#5  II ! !! $ 4 4W =J  aS3r7]':7 aS3r7]':7  T2sSW}G<9 ii Q ]]:S 1 # LLr " #us2wi@9 ii O ]]:S 1 # LLr " #/##/##L # # # #/##sJDJ!8CKJ.(AK=J:K!J+.J7 3K:K ?KKc  t|5fd}tddgddgg}jd|tjj d||dddtd d gd d gg}jd|t ||g}tjj d||dddtddgddgg}jd |dditjj d ||d ddjd|td dgd dgg}d}tjt|5jd|dddtgdgdtgdttdddjd}jd|d d!d"itjj d|d jd#|d d$d!d"i%tjj d#|d jd&|d'd!d(i)|j!j#j%d*+jd}jd&|tjj d&t ||gjd,|d d'd!d(i)jd,|d tjj d,t |d |d gt'd-tt(j*j-d.j/d/tt1d0ttd1d2d 34}d5|d6<t(j2|j4|j6d7d"d6f<d8|d9<t(j2|j4|j6d"d:d9f<d;|d<<t(j2|j4|j6d7dd}t'd-jd-|d?d@id-d?d@j;d-j<d?gk(sJt'd-jd-|d gd?d@i%|d-d?d@j;d-j<d d?gk(sJt'd-jd-|d gdd@i%|d-d d@|d-dAd@j;d-j<d gk(sJt'd-jd-|ddd@jd-|ddd@tjd-|tgdBd?gC}t'd-t?j@dD}tjt|5jd-|dEdEdFddddddy#1swYxYw#1swYxYw#1swY,xYw#1swYyxYw)GNctj|jj|j|k(sJyNgetattr get_storerr! descriptionitemsizekeyrer,rJs rL check_colz+test_append_with_strings..check_colu8((-33??FOOSWW W{ asdqwertyiYdggnhebbsdfbdfbdf_bigvalues_block_1rx|asdqyiZ dggnhefbdfbdf_big2values2 min_itemsizedf_new abcdefqhijabcdefghijklmnopqrtsuvwxyzzTrying 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)rg@g@g@)rrrrr)foo1foo2foo3foo4foo5r20130101r*rP)rYrr[rvr[rRrrrss2Tr6rss3r!)r"rlonger)r[ss4r(rrrrrrrrTstringr$r\string2bahstring3rYrr1rYvalues_block_0)rTrTrTbarhrrrZzBmin_itemsize has the key [foo] which is not an axis or data_columnr)rTfoobar)!r rr=r>r?rfr rrrrr<r rhrdr@r{ reset_indexassignr r7r8r9r:r;rArBrrbrr6rr) rIrr(r rmrrrlrJs @rLtest_append_with_stringsrrs J 'R*5  k*S2C,DE F Xr" ell84b9(,b1#w#})=>? Xs#2s)$ ell84h?(,b1k*S2C,DE F Y(B @ ell95r:)-r2  Xr"S,/#7S1TUV  ]]:S 1 + LL6 * +..C6R A6    )C.   T2c7'1 > u||D12c7;  UBsG$gq\ R u||E2BsG<  %G7A, Gggi##%,,x,8BB3G UC  ell5162s)3DE  %C| L UCH% u||E2FBsGSX;N4OP eT"  II ! !! $ 4 4W =$v,f5\2C@  8 *,&&rxx!}h&'9 +-66rxx!}i'(9 *,&&rxx|Y&' T2d# fb)eR*h J '#K5 U/uRy A eT" T2S#J 7$S!%22se;;; eT" T2SEc K$S!%22sCj@@@ eT" T2SE3 P$S!$(#.%22se;;; eT" T2bq6 4 T2ab6 4 eDk2.Dse TeT"ii P ]]:S 1 K LLrb0IL J KE#K#Ka + +IR*R*l K KE#K#KsJE Y Y-K;Y ;F/Y9*Y-Y9Y Y  Y*-Y6 2Y99Zct|5}tdgdi}|jd|ddddi|jd|dddditj|j d|dddy#1swYyxYw)Nx)rbcdefr(r$r)r rr=r>r?rfrs rLtest_append_with_empty_stringrs J '65 ?@ A T2cr7#q : T2bc7#q : ell40"5 666s A'A<<Bc 0 t|5 ttjj dj dt tdttddd }d |jd |jjdf<t d  jd |dddg  jd |ddtj d | j"j$j&j(j*j,j.dusJ j"j$j&j(j*j0j.dusJ j3d d}||j0d kD}tj || j3d d}|j5|j,dd}||j0d kD}tj |||j7}d|d<tj8|j:|j,dddf<d|j:|j,dddf<t d  jd |dg  j3d d}||j<dk(}tj || fd}dddt|5 t d  jd dgddid ddt d  jd |dgd|d ddt d  jd |dgddi|d dddddt|5 dd<d |d!<d"|d#<t d  jd |ddgdd$d%d&d dd|d dd$|d d'd%dddt|5 j7}d |jd |jjd(f<d)|jd |jjdf<d|d<|jjd}tj8|jdd|f<d|jdd|f<d|d<|jjd}tj8|jdd|f<d|jd*d+|f<t d  jd |gd,  j3d d-}||j<dk(|j>dk(z|j@d kDz|j0d kz}tj ||d./ j3d d0}||j<dk(|j>d1k(z}tj ||dddt|5 j7}d|d<tj8|j:|j,dddf<d|j:|j,d*d2df<d1|d<tCd3jEd4|d5<tj8|j:|j,d6dgd7f<t d8 jd8|gd9  j3d8d}||j0d kD}tj || j3d8gd:}||j0d kD|jFd kDz|j<dk(z}tj ||d./dddt|5 td;d+<}ttjj dj d=|gd>?}d|d<tj8|j:|j,dddf<d|j:|j,d*d2df<|dd@gjI|dd@g<d1|d< jd8|gdA  j3d8d}||j0d kD}tj || j3d8gdB}||j0d kD|jFd kDz|j<dk(z}tj ||dddy#1swYxYw#1swYlxYw#1swYxYw#1swY&xYw#1swYxYw#1swYyxYw)CNrrrrrrrrrrrr(r5TB>0zB>0 and index>df.index[3]rr1rTrr$r\r*rz string='foo'ctj|jj|j|k(sJyrrrs rLrz0test_append_with_data_columns..check_colrrrr foobarbahr foobarbah1 string_block1 foobarbah2 string_block2(r)rrrrrYgr)rYrrrz.string='foo' and string2='foo' and A>0 and B<0F) check_freqzstring='foo' and string2='cool'cool 20010102rUdatetimer])rYrrdf_dc)rr[rrr)B > 0C > 0z string == fooz1/1/2000rP)rr])rYrr[)rrr[)rr[rr)rrzstring == "foo")%r rr7r8r9r:rr;r<r rrget_locr r=r>r?_handlerootr(r!colsr is_indexedrrfrr{rArBrrrYrrzr[abs) rIr(rlrmrrslrrrJs @rLtest_append_with_data_columnsrsk J '*5  II ! !! $ 4 4W =$v,f5\2C@  /22::%%c**+eT" T2bq6 6 T2ab6" eDk2.}}!!$$**//55@@DHHH}}!!$$**//11<<DDDdE*bddQh< fh/d$?@"((12,/&((Q,' fh/ x24&& 6<<!$h./27 6<<!$h./eT" T6 ;dN3&--501 fh/ O*X J ' &5eT" T6 (TV X$"%eT" T6  L$"%eT" T6 (TV X$"% & J ' .5'y".".eT"  "I.$&2D  $"%$ 2&$("- . J '0569 Av~~--c2236: Av~~--c223 x ^^ # #H -!vv AaCG$ AaCG!y ^^ # #I .!vv AaCG$ AaCGeT" T60O Pd$TU ]]e #~~& (xx!| xx!|   fh5Ad$EF6==E1fnn6NOP fh/=0@ J 'B5 h02 %++a"H,-05 %++a"H,-!i%j199$?j>@ff %++a"$::;eW% U)T  gu-1% fh/g'JK%''A+%''A+6%,,%:OPQ fh5A+B2 J '05:q1 II ! !! $ 4 4V <#   h02 %++a"H,-05 %++a"H,-!3*-113sCj!i  We2Q Rgu-1% fh/g'LM%''A+%''A+6%,,%:OPQ fh/100**X & & . .00@BB200sMKc %B cAc%)G%c2!E*c?E$d  cc"%c/2c<?d  dc|}d|j_t|5}|jd||j d}t j |||j dddg}|jddg}t j ||ddd|dz }|j|ddt|dddg}|jddg}t j ||y#1swY]xYw) NrarYrrZztest.hdfr(r!)rr") rrer r=rfr>r?rto_hdfr )tmp_pathrI multiindex_dataframe_random_datar(rJrlrmpaths rLtest_append_hierarchicalrs )BBJJO J '05 T2d# fb)dS#J7::sCj:1 fh/0 j DIIdWI- dD3* 5Fzz3*z-H&(+00s A9C44C=c "t|5}tdtjdj dzt t dtt tdDcgc]}d| c}t}|jd |d |jd }tj|||jd |d |jd }tj||dddycc}w#1swYyxYw)N皙?xrrrrri-rr(r$ chunksizerr) expectedrows) r rr7rHreshaperr;r<rbr=rfr>r?)rIrJrkr(rls rLtest_append_miscr s J ' *5  "))C.((1 1$v,f5595a2aS5VD   T2 +d# fb) UBR 0e$ fb) * *6 * *sAD# D/BDDDr )rric |tdtjdjdzt t dt t tdDcgc]}d| c}t }d |d <d |d <|d jd |d <|d dkD|d<tdjd|d<tdjd|d<t|d5}|jd|||jd}tj||dddycc}w#1swYyxYw)NrrrrrrrrrTrrfloat322float32rboolrrUtime120130102time2w)modeobjr)rr7rHr rr;r<rbryrrzr r=rfr>r?)rIr rkr(rJrls rLtest_append_misc_chunksizers!  biin$$W--d6l&1uRy1!r!X1@ B BxLBzN ^**95BzNJ!#BvJJ'//5BwKJ'//5BwK JS 1*U UB) 4e$ fb)**2**s D-(r?r@)rIrJdf_emptyr(s rLtest_append_misc_empty_framers# J '75T%[1 T8$ ]]8+M N  LL  ryy,,Q/66w?e U T2 ell40"5 T8$ ell40"5tE{ + % ell5126#77   77s%AE;E.!DE;.E8 3E;;Fc  t|5}tdtjdj dzt t dtt tdDcgc]}d| c}t}d ggt|z|d <|jd tjk(sJtjd }tjt | 5|j#d |dddd ggt|z|d<d ggt|z|d<tjt | 5|j#d |dddtdtjdj dzt t dtt tdDcgc]}d| c}t}t%t'j&ddd|j(}|j+t}tj,|dd||d <|jd tjk(sJd}tjt | 5|j#d |dddd}tjt | 5|j#d tjddddtjd}tjt | 5|j#d t%tjddddtdtjdj dzt t dtt tdDcgc]}d| c}t}|j#d |d|d<tjd}tjt.| 5|j#d |dddt1|d t3d|d<|j#d |d|d<tjd}tjt.| 5|j#d |ddddddycc}w#1swYxYw#1swYPxYwcc}w#1swY;xYw#1swYxYw#1swYxYwcc}w#1swYxYw#1swYnxYw#1swYyxYw)NrrrrrrrrrinvalidziCannot serialize the column [invalid] because its data contents are not [string] but [mixed] object dtyperr(invalid2invalid3ir$rr1rr*z>too many timezones in this block, create separate data columnsz(value must be None, Series, or DataFramerz]cannot properly create the storer for: [group->df,value->]rTzinvalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]rr\ainvalid combination of [values_axes] on appending data [name->values_block_1,cname->values_block_1,dtype->bytes24,kind->string,shape->(1, 30)] vs current table [name->values_block_1,cname->values_block_1,dtype->datetime64[s],kind->datetime64[s],shape->None])r rr7rHr rr;r<rbrgdtypesobject_rrrrrr=rrrryrArr r)rIrJrkr(rrns rLtest_append_raiser#s J 'S#5 "))C.((1 1$v,f5595a2aS5VD  #b')9 yy#rzz111ii G ]]9C 0 # LLr " #%3r7*:%3r7*: ]]9C 0 # LLr " # "))C.((1 1$v,f5595a2aS5VD  8$$T1a0 A HHV !A9 yy#rzz111N ]]9C 0 # LLr " #9 ]]9C 0 . LLryy} - .ii E ]]9C 0 6 LLvbiim4 5 6 "))C.((1 1$v,f5595a2aS5VD   T25 ii *  ]]:S 1 # LLr " # eT"j)5  T25 ii D ]]:S 1 # LLr " #eS#S#6 # #  # #6 # #  . . 6 66 # #  # #eS#S#sAS9# R/A7S9&R9A S9R#AS93 R0?B*S9)R5<%S9!&S8S9?/S.AS9 SAS91S!A)S9-S-S9S9R S9#R- ( S95R? :S9S S9S  S9!S* &S9-S6 2S99Tc tdjd}t|tdDcgc]}|t |dzc}d}|d|dz |d<t j |jd d df<t|5}t|d |jd |d |jd }tj|||jd d}tj|||jd d}tj||jd d|jd d}tj||jd d|jd d}|jdg}tj||jdd|jd d}|jdd}tj||jddt|d|j!d||jd}tj||dddycc}w#1swYyxYw)NrrUr)dayssecondsrrYrr[r]r*r(Tr5zC<100000)wherezCr?rr~r@)rIrSrkr(rJrls rLtest_append_with_timedeltar);s :  & &t ,B >CBiH"ya44H  B g3BsGvvBFF1Q38 J '*5eT" T2D 1d# fb)d*5 fb)d*AB fbggabk2dI. fbggabk2dN3se, fbggabk2dK0QR fbggabk2 eU# %e$ fb)=** I **sH> F-II c ttjjdj dt t dttddd }|jjd j }d |d <t||gd}t|5}d}tjt |5|j#ddgdd|ddddtjt |5|j#ddd|ddddd}tjt |5|j#d|dddd|j#ddgdd|d|j%ddgddgd}||j&dkD|j(dkDz}t+j,||dddy#1swYxYw#1swYxYw#1swYxYw#1swYyxYw)Nrrrrrrrrr{}_2rZr\rTr$axisz=append_to_multiple requires a selector that is in passed dictrrYrr r#)selectorzQappend_to_multiple must have a dictionary specified as the way to split the valuerr zA>0r)r'r/r)rr7r8r9r:rr;r<r r{renamer"r r rrrappend_to_multipleselect_as_multiplerYrr>r?)rIrr r(rJrrlrms rLtest_append_to_multipler3js  a 009d6l&1r< C ((*  FMM  2CCJ c  #B J '05M ]]:S 1   $ $c 40"u %   ]]:S 1 U  $ $T$%?e $ T U  ]]:S 1 7  $ $UB 6 7   #sD!A2PU V)) EN5%.5* rttaxBDD1H-. fh/100    U U 7 700sU(G2G #G2G%G2G&A1G2G G2G# G2&G/ +G22G;c ttjjdj dt t dttddd }ttjjdj dt t dttddd jd j }tj|jd |jjd dgf<t||gd }t!|5}|j#d dgdd|dd|j%ddg}|j'}t)j*||dt)j,|j/dj0|j/dj0dddy#1swYyxYw)Nrrrrrrrrrr+rZr$rYr,r.rTr/r~r r3)rr7r8r9r:rr;r<r r0r"rArr get_indexerr r r1r2r~r>r?assert_index_equalrfr)rIrr r(rJrlrms rLtest_append_to_multiple_dropnar8s  a 009d6l&1r< C  a 009d6l&1r<  fV]]f#  8:vvCHHQ ''c 3 34 c  #B J 'T5   #Jt ,b5 ! ))5%.999; fhF ell5177e9L9R9RSTTTs +BGGc ttjjdj dt t dttddd }|jjd j }tj|jd |jjd dgf<t!||gd }t#|5}t%j&dd5|j)d dgdd|ddd}t+j,t.|5|j1ddgddd|j3dj4j7|j3dj4rJ ddddddy#1swY`xYw#1swYxYw#1swYyxYw)Nrrrrrrrrrr+rZr$rYr,rT)df1adf2ar:Fr5z,all tables must have exactly the same nrows!rr;)rr7r8r9r:rr;r<r r{r0r"rArrr6r r rrr1rrrr2rfrequals)rIrr r(rJrs rL$test_append_to_multiple_dropna_falser=s  a 009d6l&1r< C ((*  FMM  2C79vvCHHQ ''c 3 34 c  #B J ' Q5"2C2Ct3 Q   3Z .VE ! = ]]:S 1 7  $ $ff%5 6 7<<'--44U\\&5I5O5OPPPP Q Q Q 7 7 Q Q Q Qs=F748F+,FA F+F7F( $F++F4 0F77Gc *ttjddtjddtjdddztdDcgc]}dc}tdDcgc]}dc}d}|jdg}t |5}|j d gd d gd d gd|jdgddddd|jgd}tj||ddddycc}wcc}w#1swYyxYw)Nr$Xrrabcde)IXNumBigNumStrLongStrrrBrCrDrErF)rnumsstrsrrrQr)rErFrCrTr3) rr7rHrbrr r1r2r>r?)rI_r(rmrJrls rL$test_append_to_multiple_min_itemsizerJs ))Ar"99Q#ii2&+!&r+AC+).r3A3   Bwws|H J ' G5   ) *  GGQCL !#A> ! ))*CD fhF G G ,3 G Gs C?- DAD  D)4rrrnumpyr7rpandas._libs.tslibsrpandas.util._test_decoratorsutil_test_decoratorstdpandasrrrrrr>r r r pandas.tests.io.pytables.commonr r mark single_cpu pytestmark importorskiprfilterwarningsrMror|rrrrrrrr  parametrizerr&skip_array_manager_not_yet_implementedr#r)r3r8r=rJrrLr[s'  ))) [[ # #   X &?@EPAEPP,F^-H`SKlCB1#hxKv6X0v,* * o6*7*&72**T#+T#n,*^"0JT2Q2Gr