!h<ddlZddlmZddlZddlZddlZddlmZddlm cm Z ddl Z ddl mZmZmZmZmZmZmZddlmZmZejjZejdZejddZd Z d Z!d Z"d Z#d Z$dZ%dZ&dZ'dZ(dZ)ej*dgddZ+dZ,e j-dZ.dZ/dZ0dZ1dZ2dZ3dS)N timedelta) Timestamp) DataFrameIndexSeries_testingconcat date_rangeread_hdf) _maybe_removeensure_clean_storetablesz!ignore::tables.NaturalNameWarningc t|5}ttjddt tdttddd }t|d | d |dd | d |d dtj |d |t|d |d |dd d | d |d dtj |d |t|d| d|dd | d|d dtj |d|t|d| d|dd | d|d dtj |d|tddgddgddgddgg}d|d<tj|jd<t|d| d|tj |d|tt#tjddddtjt#tjddddtjt#tjddddtjt#gdtjd tjd!}t|d"| d"|tj |d"|d#$t|d"| d"|gd%&tj |d"|d#$ddddS#1swxYwYdS)'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/r0 data_columns)rrnprandom default_rngstandard_normalrlistobjectr r appendtmassert_frame_equalputnanlocrintegersuint8uint16uint32uint64arange) setup_pathstorer) uint_datas ^c:\xampp_lite_8_4\www\timesheet\venv\Lib\site-packages\pandas/tests/io/pytables/test_append.py test_appendrNs J ' 'DP5 I ! !! $ $ 4 4W = =$v,,f555\2C@@@    eU### UBssG$$$ UBrssG$$$ eElB///eU### %CRC 111 UBrssG$$$ eElB///eU### VRW%%% VRW%%% eElB/// eZ((( ZCRC))) ZBCC))) eI.333aVaVaVaV< = = =&>$&F !eT""" T2 eDk2...I))!,,55ac5JJ(I))!,,55ae!5LL)I))!,,55ae!5LL)777)  $)A,,'   * eW%%% Wi((( eGni$OOOO eW%%% Wi6K6K6K LLL eGni$OOOOIDPDPDPDPDPDPDPDPDPDPDPDPDPDPDPDPDPDPsP9QQQc t|5}ttdtjdtdD}ttjdtjt dd}ttjd }|d ||d }tj |||j J|d ||d }tj |||j Jd |_ |d ||d }tj |||j |j ksJ||dk}| d d}tj ||||dk|j dkz}| d d}tj ||dttjdddg}tjt#||d<d |d<d|jdddf<|ddgd|d}|j d|_ |d |tj |d |dddddS#1swxYwYdS)!Nrcg|]}d|S)i_.0is rM z&test_append_series..ks7T7T7TQQ7T7T7T)rrr rz 2020-01-01rr2dsstsfoons<zfoo>60FZzfoo>70 and index<90Tr4r)r+r%ArrCbarr+inplace) future_stackmi)rrranger8float64rIr r>r?assert_series_equalnameselectrrr9r:r;lenrC set_indexstack droplevel) rJrKrZr[r]resultexpectedriss rMtest_append_seriesrvhs* J ' '+F5 E"IIRZ7T7T%PR))7T7T7T U U U  Ib + + +:lTV3W3W3W   BIcNN # # T2t vr***{""" T2t vr***{""" T2t vr***{bg%%%%b2g;dH-- vx000rBw28b=12d$9:: vx$GGGGry,,Q//??GGRUQV W W W)CGG$$33 qsCx c3Z ... HH$H ' ''##A&& T1 uT{AEEEEW+F+F+F+F+F+F+F+F+F+F+F+F+F+F+F+F+F+FsKK77K;>K;c t|5}tttjdddtjddtjddddtd dtd dd tj d }t|d tj |j d d gdf<|d |dd|d |ddtj|d |d|}tj |d<t|d |d |dd|d |ddtj|d |d|}tj |d<t|d|d|dd|d|ddtj|d|d|}tj |d<t|d|d|dd|d|ddtj|d|dddddS#1swxYwYdS)Nrrint32r\rd 2001-01-01r] 2001-01-02)raA1A2rrcDEr2rr)r{rr}r~r Tr4r{r|r!r~r$)rrrr8r9r:r;astyperas_unitrIr rBrCr>r?r@copy)rJrKr)rr!r$s rMtest_append_some_nansrsf J ' ',H5 BI11!44DDRHHIIPPi++A..>>rBBi++A..>>rBB|,,44T::|,,44T::  )B--     eU###.0fqt****+ UBssG$$$ UBrssG$$$ eElBFFFFggiiFD eU### UCH%%% UCH%%% eElC$GGGGggiiFD eU### UCH%%% UCH%%% eElC$GGGGggii6CeU### UCH%%% UCH%%% eElC$GGGGY,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,H,HsMM  M$'M$c . t|5}ttjddtjdddtjd}tj|jddddf<t|d| d|ddd | d|ddd tj |d|d dd t|d | d |ddd | d |ddd tj |d |d tjdd5t|d| d|dd| d|ddtj |d|dddn #1swxYwYtjdd 5t|d| d|dd| d|ddtj |d|d dttjddtjdddddtjd}tj|jddddf<t|d| d|ddd | d|ddd tj |d|d t|d | d |ddd | d |ddd tj |d |d ttjddtjddddtddtdddtjd}tj|jddddf<t|d| d|ddd | d|ddd tj |d|d t|d | d |ddd | d |ddd tj |d |d dddn #1swxYwYddddS#1swxYwYdS)Nrr)r{r|r2rrr)r T)dropnar4r!Fio.hdf.dropna_tabler$df4r\rd)r{r|rrcryr]rz)r{r|rrcr}r~)rrr8r9r:r;rIrBrCr r>r?r@pdoption_contextrrrJrKr)s rMtest_append_all_nansrs J ' 'RK5 i++A..>>rBBi++A..>>rBB  )B--    &qtQQQw eT""" T2crc74 000 T2bcc74 000 eDk2bcc7TJJJJ eU### UBssGE 222 UBrssGE 222 eElBFFFF 4e < < 4 4 % ' ' ' LL3B3 ( ( ( LL233 ( ( (  !%, 3 3 3  4 4 4 4 4 4 4 4 4 4 4 4 4 4 4  4d ; ;5 K5 K % ' ' ' LL3B3 ( ( ( LL233 ( ( (  !%,233 8 8 8)//22BB2FF)//22BB2FF  immB!fBF1R47O % & & & LLr#2#wtL 4 4 4 LLr"##wtL 4 4 4  !%+rD I I I I % ' ' ' LL3B3L 6 6 6 LL233L 6 6 6  !%,T J J J J)//22BB2FF)//22BB2FF"<0088>>"<0088>> imm   B!fBF1R47O % & & & LLr#2#wtL 4 4 4 LLr"##wtL 4 4 4  !%+rD I I I I % ' ' ' LL3B3L 6 6 6 LL233L 6 6 6  !%,T J J J Jk5 K5 K5 K5 K5 K5 K5 K5 K5 K5 K5 K5 K5 K5 K5 K;RKRKRKRKRKRKRKRKRKRKRKRKRKRKRKRKRKRKs\FX (A(H X H X #H $X df.index[4])rrr8r9r:r;rr<r=r r _with_freqr r>ilocr?r@rnreindexreescapepytestraises TypeError)rJrKr)rsrtmsgs rM!test_append_frame_column_orientedrs J ' 'C5  I ! !! $ $ 4 4W = =$v,,f555\2C@@@    8&&t,,eU### UBGAAArrEN) === UBGAAAqrrEN+++ eElB///e[11::se:,, h///e%IJJ::se28AaC=:AA h///i (  ]9C 0 0 0 C C LL A B B B C C C C C C C C C C C C C C C9CCCCCCCCCCCCCCCCCCs6GH H7 HH H H HH"Hct|5}tdD]A}ttjddtd}td|d<|dxx|dzz cc<tdgt|zd |d<tdgt|zd |d <|dzd kr(|d=tdgt|zd |d<|d zd kr| d }||d <| dd| d|C dddn #1swxYwYt|5}ttjddtdd}tdgt|zd |d<tdgt|zd |d <| d|tdgt|zd |d<tjd}tjt"|5| d|dddn #1swxYwYtdgt|zd |d<tjd}tjt"|5| d|dddn #1swxYwYddddS#1swxYwYdS)Nr r)r rABrbrr%int64rint16rreraTrfr)rk)rrint16_2zCcannot match existing table structure for [int16] on appending datar?float_3zAcannot match existing table structure for [A,B] on appending data)rrjrr8r9r:r;r<rropoprpr>rrrr ValueError)rJrKrUr)ars rM)test_append_with_different_block_orderingr>s- J ' '#5r # #A %%a((88AA4PT::B ))BwK wKKK1r6 !KKK !s2wwg>>>BwK !s2wwg>>>BwK1uzzwK$aS3r77]'BBB7 1uzzFF3KK3 LL$L / / / LLr " " " "% ################. J ' '#5  I ! !! $ $ 4 4W = =JJ    aS3r77]':::7 aS3r77]':::7  T2sSWW}G<<<9 i Q  ]:S 1 1 1 # # LLr " " " # # # # # # # # # # # # # # #us2wwi@@@9 i O  ]:S 1 1 1 # # LLr " " " # # # # # # # # # # # # # # #/##################snEE00E47E4 DM J1% M 1J5 5M 8J5 9AM L3' M 3L7 7M :L7 ;M  MMc t|5fd}tddgddgg}d|tjd||dddtd d gd d gg}d|t ||g}tjd||dddtddgddgg}d |dditjd ||d ddd|td dgd dgg}d}tjt|5d|dddn #1swxYwYtgdgdtgdttddd d}d|d d!d"itjd|d d#|d d$d!d"i%tjd#|d d&|d'd!d(i)|d*+ d}d&|tjd&t ||gd,|d d'd!d(i)d,|d tjd,t |d |d gt'd-tt(jd.d/tt1d0ttd1d2d 34}d5|d6<t(j|j|jd7d"d6f<d8|d9<t(j|j|jd"d:d9f<d;|d<<t(j|j|jd7dd}t'd-d-|d?d@i|d-d?d@d-jd?gksJt'd-d-|d gd?d@i%|d-d?d@d-jd d?gksJt'd-d-|d gdd@i%|d-d d@|d-dAd@d-jd gksJt'd-d-|ddd@d-|ddd@tjd-|tgdBd?gC}t'd-t?j dD}tjt|5d-|dEdEdFdddn #1swxYwYddddS#1swxYwYdS)GNcxt|jj|j|ksJdSNgetattr get_storerr" descriptionitemsizekeyrmr-rKs rM check_colz+test_append_with_strings..check_colu<((--3?FFOSWWWWWWWrW{ asdqwertyiYdggnhebbsdfbdfbdf_bigvalues_block_1r|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+rX)rarrcr}rcrZrrrss2Tr7rss3r")r#rlonger)rcss4r)rrrrr rrr\stringr%rdstring2bahstring3rarr2ravalues_block_0)r\r\r\barhrrrbzBmin_itemsize has the key [foo] which is not an axis or data_columnr)r\foobar)!rrr>r?r@rnr rrrrr=r rprlrAr reset_indexassignr r8r9r:r;r<rBrCrrjrr7rr) rJrr)r!rtrrrsrKs @rMtest_append_with_stringsrrs J ' 'R*5      k*S2C,DE F F Xr""" ell844b999 (,b111#w#})=>?? Xs###2s)$$ ell844h??? (,b111k*S2C,DE F F Y(B @@@ ell955r::: )-r222  Xr"""S,/#7S1TUVV  ]:S 1 1 1 + + LL6 * * * + + + + + + + + + + + + + + +......CCC6RRR A666      )C..   T2c7'1 >>> u||D112c7;;;  UBsG$gq\ RRR u||E22BsG<<<  %G7A, GGGggii##%%,,x,88BB3GG UC    ell51162s)3D3DEEE  %C| LLL UCH%%% u||E22FBsGSX;N4O4OPPP eT"""  I ! !! $ $ 4 4W = =$v,,f555\2C@@@    8 *,&rx!}h&'9 +-6rx!}i'(9 *,&rx|Y&' T2d## fb)))eR*R*R*R*R*R*R*R*R*R*R*R*R*R*R*h J ' '#K5 U//uRyy A A A eT""" T2S#J 777 $S!!!%%2se;;;; eT""" T2SEc KKK $S!!!%%2sCj@@@@ eT""" T2SE3 PPP $S!!! $(#...%%2se;;;; eT""" T2bqb6 444 T2abb6 444 eDk2...DDDse T T TeT"""i P  ]:S 1 1 1 K K LLrb0I0IL J J J K K K K K K K K K K K K K K KE#K#K#K#K#K#K#K#K#K#K#K#K#K#K#K#K#K#KsnFT+F7+ T+7F; ;T+>F; ?M T++T/2T/G:]??]' ]?']+ +]?.]+ /]??^^cTt|5}tdgdi}|d|ddddi|d|dddditj|d|ddddS#1swxYwYdS)Nx)rbcdefr)r%r)rrr>r?r@rnrs rMtest_append_with_empty_stringrs J ' '65 ???@ A A T2crc7#q ::: T2bcc7#q ::: ell400"555 666666666666666666sBBB!$B!c \ t|5 ttjddt tdttddd }d |j d |j df<t d  d |dddg  d |ddtj d | jjjjjjjdusJ jjjjjjjdusJ d d}||jd k}tj|| d d}||jdd}||jd k}tj|||}d|d<tj|j|jdddf<d|j|jdddf<t d  d |dg  d d}||jdk}tj|| fd}dddn #1swxYwYt|5 t d  d |dgddi|d ddt d  d |dgd|d ddt d  d |dgddi|d dddddn #1swxYwYt|5 d|d<d |d!<d"|d#<t d  d |ddgdd$d%d&|d dd|d dd$|d d'd%dddn #1swxYwYt|5 |}d |j d |j d(f<d)|j d |j df<d|d<|j d}tj|j dd|f<d|j dd|f<d|d<|j d}tj|j dd|f<d|j d*d+|f<t d  d |gd,  d d-}||jdk|jdkz|j d kz|jd kz}tj||d./ d d0}||jdk|jd1kz}tj||dddn #1swxYwYt|5 |}d|d<tj|j|jdddf<d|j|jd*d2df<d1|d<tCd3"d4|d5<tj|j|jd6dgd7f<t d8 d8|gd9  d8d}||jd k}tj|| d8gd:}||jd k|j#d kz|jdkz}tj||d./dddn #1swxYwYt|5 td;d+<}ttjdd=|gd>?}d|d<tj|j|jdddf<d|j|jd*d2df<|dd@g$|dd@g<d1|d< d8|gdA  d8d}||jd k}tj|| d8gdB}||jd k|j#d kz|jdkz}tj||ddddS#1swxYwYdS)CNrrrrrr rrrrrr)r6TB>0zB>0 and index>df.index[3]rr2r\rr%rdr+rz string='foo'cxt|jj|j|ksJdSrrrs rMrz0test_append_with_data_columns..check_colrrWrr foobarbahr foobarbah1 string_block1 foobarbah2 string_block2(r)rrrrragr)rarrrz.string='foo' and string2='foo' and A>0 and B<0F) check_freqzstring='foo' and string2='cool'cool 20010102r]datetimere)rarrdf_dc)rrcrrr)B > 0C > 0z string == fooz1/1/2000rX)rre)rarrc)rrrc)rrcrr)rrzstring == "foo")%rrr8r9r:r;rr<r=r rrget_locr r>r?r@_handlerootr)r"colsr is_indexedrrnrrrBrCrrrarrrcabs) rJr)rsrtrrslrrrKs @rMtest_append_with_data_columnsrs J ' '*5  I ! !! $ $ 4 4W = =$v,,f555\2C@@@    /22:%%c***+eT""" T2bqb6 666 T2abb6""" eDk2...}!$*/5@DHHHH}!$*/1<DDDDdE**bdQh< fh///d$?@@"(122,//&(Q,' fh/// x24& 6<!$h./27 6<!$h./eT""" T6 ;;;dN33&-501 fh///     O***************X J ' ' &5eT""" T6 (TV XXX $"%%%eT""" T6  LLL $"%%%eT""" T6 (TV XXX $"%%% & & & & & & & & & & & & & & & J ' ' .5'y".".eT"""  "I.$&2DD     $"%%% $ 2&&& $("--- . . . . . . . . . . . . . . . J ' '0569 Av~--c22236: Av~--c2223 x ^ # #H - -!v AaCG$ AaCG!y ^ # #I . .!v AaCG$ AaCGeT""" T60O0O0O PPPd$TUU ]e #~& (x!| x!|   fh5AAAAd$EFF6=E1fn6NOP fh///=000000000000000@ J ' 'B5 h02 %+ac"H,-05 %+ac"H,-!i%j1199$??j>@f %+ac"$:$:$::;eW%%% U)T)T)T    gu--1% fh///g'J'J'JKK%'A+%'A+6%,%:OPQ fh5AAAA+BBBBBBBBBBBBBBB2 J ' '05:q111 I ! !! $ $ 4 4V < <#OO     h02 %+ac"H,-05 %+ac"H,-!3*-1133sCj!i  We2Q2Q2Q RRRgu--1% fh///g'L'L'LMM%'A+%'A+6%,%:OPQ fh///1000000000000000000sqJ.K  KK%B*NN"N5A&P''P+.P+F;XX X "E#^^^+E)d!!d%(d%c8|}d|j_t|5}|d||d}t j|||dddg}|ddg}t j||dddn #1swxYwY|dz }||ddt|dddg}|ddg}t j||dS) Nrirarrbztest.hdfr)r")rr#) rrmrr>rnr?r@rto_hdfr )tmp_pathrJ multiindex_dataframe_random_datar)rKrsrtpaths rMtest_append_hierarchicalrsY )BBJO J ' '05 T2d## fb)))dS#J77::sCj:11 fh///000000000000000 j DIIdWI--- dD3* 5 5 5Fzz3*z--H&(+++++sBB11B58B5c jt|5}tdtjddzt t dtt dtdDt}| d |d | d }tj ||| d |d | d }tj ||ddddS#1swxYwYdS)N皙?xrrrrcg|]}d|Szi-rRrSs rMrVz$test_append_misc..555aa555rWrrr)r% chunksizerr ) expectedrows) rrr8rIreshaperr<r=rjr>rnr?r@)rJrKr)rss rMtest_append_miscrsX J ' ' *5  ")C..((11 1$v,,f55555599555VDDD     T2 +++d## fb))) UBR 000e$$ fb))) * * * * * * * * * * * * * * * * * *sD D((D,/D,r)r ric tdtjddzt t dt t dtdDt }d |d <d |d <|d d |d <|d dk|d<td d|d<td d|d<t|d5}| d||| d}tj||ddddS#1swxYwYdS)Nr r r rrcg|]}d|SrrRrSs rMrVz.test_append_misc_chunksize..s111!X!XX111rWrrr\rrfloat322float32rboolrr]time120130102time2w)modeobjr)rr8rIrrr<r=rjrrrrr>rnr?r@)rJrr)rKrss rMtest_append_misc_chunksizer s  binn$$W---d6ll&11111uRyy111@@@   B BxLBzN ^**955BzNJ!#BvJJ''//55BwKJ''//55BwK JS 1 1 1*U UB) 444e$$ fb)))******************sAE))E-0E-ct|5}ttd}|d|t jt d5|ddddn #1swxYwYttj d dtd}|d|tj |d||d|tj |d|ttd}| d|tj |d|ddddS#1swxYwYdS) NABCrbr)z 'No object named df in the file'rr)r rer!)rrr<r>rrKeyErrorrnr8r9r:r?r@rA)rJrKdf_emptyr)s rMtest_append_misc_empty_framer%s J ' '75T%[[111 T8$$$ ]8+M N N N   LL                  ry,,Q//66w??e U U U T2 ell400"555 T8$$$ ell400"555tE{{ + + + % ell5112666#777777777777777777s7AF>B5 F>B F>B D(F>>GGc  t|5}tdtjddzt t dtt dtdDt}d ggt|z|d <|j d tj ksJtj d }tjt | 5|d |dddn #1swxYwYd ggt|z|d<d ggt|z|d<tjt | 5|d |dddn #1swxYwYtdtjddzt t dtt dtdDt}t%t'jddd|j}|t}tj|dd<||d <|j d tj ksJd}tjt | 5|d |dddn #1swxYwYd}tjt | 5|d tjddddn #1swxYwYtj d}tjt | 5|d t%tjddddn #1swxYwYtdtjddzt t dtt dtdDt}|d |d|d<tj d}tjt.| 5|d |dddn #1swxYwYt1|d t3d|d<|d |d|d<tj d }tjt.| 5|d |dddn #1swxYwYddddS#1swxYwYdS)!Nr r r rrcg|]}d|SrrRrSs rMrVz%test_append_raise..rrWrrrinvalidziCannot serialize the column [invalid] because its data contents are not [string] but [mixed] object dtyperr)invalid2invalid3cg|]}d|SrrRrSs rMrVz%test_append_raise..rrWir%rr2rr+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->]cg|]}d|SrrRrSs rMrVz%test_append_raise..rrWr\zinvalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]rrdainvalid 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])rrr8rIrrr<r=rjrodtypesobject_rrrrrr>rrrrrBrr r)rJrKr)rrus rMtest_append_raiser/s J ' 'S#5 ")C..((11 1$v,,f55555599555VDDD    #b'')9 y#rz1111i G  ]9C 0 0 0 # # LLr " " " # # # # # # # # # # # # # # #%3r77*:%3r77*: ]9C 0 0 0 # # LLr " " " # # # # # # # # # # # # # # # ")C..((11 1$v,,f55555599555VDDD    8$T1a00 A A A HHV  !A#9 y#rz1111N ]9C 0 0 0 # # LLr " " " # # # # # # # # # # # # # # #9 ]9C 0 0 0 . . LLry}} - - - . . . . . . . . . . . . . . .i E  ]9C 0 0 0 6 6 LLvbimm44 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 ")C..((11 1$v,,f55555599555VDDD     T25 i *   ]:S 1 1 1 # # LLr " " " # # # # # # # # # # # # # # # eT"""j))5  T25 i D  ]:S 1 1 1 # # LLr " " " # # # # # # # # # # # # # # #eS#S#S#S#S#S#S#S#S#S#S#S#S#S#S#S#S#S#sC*U%:D U%D! !U%$D! %A U%1F U%F U%F DU%9K U%K U%#K $ U%)L9- U%9L= =U%L= 2U%36N5) U%5N9 9U%<N9 =CU%R3' U%3R7 7U%:R7 ;A/U%*U  U% U U%U U%%U),U)ctddtfdtdDd}|d|dz |d<tj|jd d df<t|5}t|d | d |d | d }tj ||| d d}tj ||| d d}tj ||j d d| d d}tj ||j d d| d d}|dg}tj ||j dd| d d}|j dd}tj ||j ddt|d|d|| d}tj ||ddddS#1swxYwYdS)Nrr]c8g|]}t|dzS)r )dayssecondsr)rTrUr[s rMrVz.test_append_with_timedelta..Cs+HHH"ya4444HHHrWr rrarrcrer+r)Tr6zC<100000)wherezCrnr?r@rrrA)rJr)rKrsr[s @rMtest_append_with_timedeltar6;s :   & &t , ,B HHHHeBiiHHH    B g3BsGvBF1Q38 J ' '*5eT""" T2D 111d## fb)))d*55 fb)))d*ABB fbgabbk222dI.. fbgabbk222dN33se,, fbgabbk222dK00QRR fbgabbk222 eU### %e$$ fb)))=******************s GI--I14I1c tttjddt t dttddd }| d j }d |d <t||gd}t|5}d}tjt |5|ddgdd|ddddn #1swxYwYtjt |5|ddd|ddddn #1swxYwYd}tjt |5|d|ddddn #1swxYwY|ddgdd|d|ddgddgd}||jdk|jdkz}t+j||ddddS#1swxYwYdS)Nrrrrrr rrr{}_2rbrdr\r%axisz=append_to_multiple requires a selector that is in passed dictrrarr!r$)selectorzQappend_to_multiple must have a dictionary specified as the way to split the valuerr!zA>0r)r4r<r)rr8r9r:r;rr<r=r rrenamer#r rrrrappend_to_multipleselect_as_multiplerarr?r@)rJrr!r)rKrrsrts rMtest_append_to_multipler@js_  a  0099d6ll&111r<<<   C ((**  FM  2 2CCJ c  # # #B J ' '05M ]:S 1 1 1    $ $c 400"u %                   ]:S 1 1 1 U U  $ $T$%?%?e $ T T T U U U U U U U U U U U U U U U  ]:S 1 1 1 7 7  $ $UB 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7   #sD!A!A2PU VVV)) EN5%.5*  rtaxBD1H-. fh///1000000000000000000sH-&D H-D H-D H-6E H-E" "H-%E" & H-F* H-*F. .H-1F. 2A.H--H14H1c $ttjddt t dttddd }ttjddt t dttddd  d j }tj |j d |j d dgf<t||gd }t!|5}|d dgdd|dd|ddg}|}t)j||dt)j|dj|djddddS#1swxYwYdS)Nrrrrrr rrrr8rbr%rar9r;rTr<rr!r4)rr8r9r:r;rr<r=r r=r#rBrr get_indexerr rr>r?rr?r@assert_index_equalrnr)rJrr!r)rKrsrts rMtest_append_to_multiple_dropnarEs6  a  0099d6ll&111r<<<   C  a  0099d6ll&111r<<<    fV]f##  8:vCHQ ''c 33 34 c  # # #B J ' 'T5   #Jt , ,b5 !   ))5%.9999;; fhFFFF ell5117e9L9L9RSSSTTTTTTTTTTTTTTTTTTsB&HH  H c ttjddt t dttddd }| d j }tj |j d |jd dgf<t!||gd }t#|5}t%jdd5|d dgdd|ddd}t+jt.|5|ddgdddn #1swxYwY|dj|djrJ dddn #1swxYwYddddS#1swxYwYdS)Nrrrrrr rrrr8rbr%rar9rT)df1adf2arGFrBz,all tables must have exactly the same nrows!rrH)rr8r9r:r;rr<r=r rr=r#rBrrrCr rrrr>rrrr?rnrequals)rJrr!r)rKrs rM$test_append_to_multiple_dropna_falserJs  a  0099d6ll&111r<<<   C ((**  FM  2 2C79vCHQ ''c 33 34 c  # # #B J ' ' Q5"2Ct33 Q Q   3Z . .VE !   = ]:S 1 1 1 7 7  $ $ff%5 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7<<''-44U\\&5I5I5OPPPPPP Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Q Qs[3G  .s+++AC+++rWrcg|]}dS)abcderRrOs rMrVz8test_append_to_multiple_min_itemsize..s333A333rW)IXNumBigNumStrLongStrrrSrTrUrVrW)rnumsstrsrr rYr)rVrWrTrTr4) rr8rIrjrrr>r?r?r@)rJr)rtrKrss rM$test_append_to_multiple_min_itemsizerZs )Ar""9Q##i2&&+++r+++33r333     Bws|H J ' ' G5   ) *   GQCL !#A>> ! ))*C*C*CDD fhFFFF G G G G G G G G G G G G G G G G G GsA!D  DD)4rrrnumpyr8rpandas._libs.tslibsrpandas.util._test_decoratorsutil_test_decoratorstdpandasrrrrr r?r r r pandas.tests.io.pytables.commonr rmark single_cpu pytestmark importorskiprfilterwarningsrNrvrrrrrrrrr parametrizer r%&skip_array_manager_not_yet_implementedr/r6r@rErJrZrRrWrMrjs  ))))))))))))))) [ #  X & &?@@EPEPA@EPP,F,F,F^-H-H-H`SKSKSKlCCCB1#1#1#hxKxKxKv666X0X0X0v,,,* * * * ooo66**76*&7772*T#T#+*T#n,*,*,*^"0"0"0JTTT2QQQ2GGGGGrW