a Pкf<Пу@sXddlZddlmZddlZddlZddlZddlmZddlm m ZddlZ ddlmZmZmZmZmZmZmZddlmZmZejjZeаdбZejаdбdd ДГZd dДZ dd ДZ!ddДZ"ddДZ#ddДZ$ddДZ%ddДZ&ddДZ'ddДZ(ddДZ)ejа*dgdвбd d!ДГZ+d"d#ДZ,ej-d$d%ДГZ.d&d'ДZ/d(d)ДZ0d*d+ДZ1d,d-ДZ2d.d/ДZ3dS)0щNй┌ timedelta)┌ Timestamp)┌ DataFrame┌Index┌Series┌_testing┌concat┌ date_range┌read_hdf)┌ _maybe_remove┌ensure_clean_store┌tablesz!ignore::tables.NaturalNameWarningc Csкt|ГРПК}ttjаdбаdбttdГtdНt ddddНd Н}t |d Г|аd |ddЕб|аd |ddЕбtа |d |бt |dГ|jd|ddЕd dН|аd|ddЕбtа |d|бt |dГ|аd|ddЕб|аd|ddЕбtа |d|бt |dГ|аd|ddЕб|аd|ddЕбtа |d|бtddgddgddgddggdН}d|d<tj|jd<t |dГ|аd|бtа |d|бtttjаdбjddddНtjdНttjаdбjddddНtjdНttjаdбjddddНtjdНtgdвtjdНd Ьtаdбd!Н}t |d"Г|аd"|бtj |d"|d#d$Нt |d"Г|jd"|gd%вd&Нtj |d"|d#d$НWdГn1РsЬ0YdS)'Nщ)щщ┌ABCDй┌dtype· 2000-01-01r┌Bй┌periods┌freqй┌columns┌index┌df1щ ┌df2┌table)┌format┌df3z/df3z/df3 foozdf3 fooщr)┌dataZtesting┌mixed_column)rr%┌dfщ щ)┌high┌sizei i@)l l@lll)┌u08┌u16┌u32Zu64йrZuintsTйZcheck_index_type)r+r,r-й┌data_columns)r r┌np┌random┌default_rng┌standard_normalr┌list┌objectr r┌append┌tm┌assert_frame_equal┌put┌nan┌locrZintegersZuint8Zuint16Zuint32Zuint64┌arange)┌ setup_path┌storer&Z uint_dataйrA·]/var/www/ai-form-bot/venv/lib/python3.9/site-packages/pandas/tests/io/pytables/test_append.py┌test_appendsl¤ " ■■■■єэ rCc Cs№t|ГРП▄}ttdГtjddДtdГDГdН}ttjdtjdНtdddНd Н}ttаd бГ}|аd|б|d}tа ||б|j dusКJВ|аd|б|d}tа ||б|j dus╕JВd |_ |аd|б|d}tа ||б|j |j ksюJВ||dk}|аddб}tа ||б||dk|jdk@}|аddб}tj ||ddНt tjаdбаdбdgdН}tаt|Гб|d<d |d<d|jddЕdf<|jddgddН|jdd Н}|jаdб|_|аd!|бtj |d!|ddНWdГn1Рsю0YdS)"NrcSsg|]}d|ЫЭСqS)Zi_rAй┌.0┌irArArB┌ kєz&test_append_series..)rrrrz 2020-01-01йrr.щd┌ss┌ts┌foo┌nsщ<zfoo>60щFщZzfoo>70 and index<90Tr/r)r(r#┌Aйrr┌C┌barщr(йZinplace)Zfuture_stack┌mi)r r┌ranger2┌float64r>r r8r9┌assert_series_equal┌name┌selectrrr3r4r5┌lenr=┌ set_index┌stackZ droplevel) r?r@rKrLrN┌result┌expectedrX┌srArArB┌test_append_serieshsD" rdcCst|ГРПр}tttjаdбаdбГаdбtjаdбаdбtjаdбаdбddtdГа dбtdГа dбd Ьtа dбd Н}t|dГtj|j dd Еgdвf<|аd|ddЕб|аd|ddЕбtj|d|ddН|аб}tj|d<t|dГ|аd|ddЕб|аd|ddЕбtj|d|ddН|аб}tj|d<t|dГ|аd|ddЕб|аd|ddЕбtj|d|ddН|аб}tj|d<t|dГ|аd|ddЕб|аd|ddЕбtj|d|ddНWdГn1РsЄ0YdS)NrrZint32rMrU· 2001-01-01rN· 2001-01-02)rR┌A1┌A2rrT┌D┌Er.rrщ)rgrrirjrTr/rgrhrrjr")r rrr2r3r4r5┌astyper┌as_unitr>rr<r=r8r9r:┌copy)r?r@r&rrr"rArArB┌test_append_some_nansЧsJ ўЇ rocCs·t|ГРП┌}ttjаdбаdбtjаdбаdбdЬtаdбdН}tj|jddЕddЕf<t |dГ|j d|ddЕd d Н|j d|ddЕd d Нtj|d|ddЕd dНt |d Г|j d |ddЕdd Н|j d |ddЕdd Нtj|d |d dНt аddбПRt |dГ|а d|ddЕб|а d|ddЕбtа|d|бWdГn1Рsb0Yt аdd бРПJt |dГ|а d|ddЕб|а d|ddЕбtа|d|ddЕбttjаdбаdбtjаdбаdбdddЬtаdбdН}tj|jddЕddЕf<t |dГ|j d|ddЕd d Н|j d|ddЕd d Нtj|d|d dНt |d Г|j d |ddЕdd Н|j d |ddЕdd Нtj|d |d dНttjаdбаdбtjаdбаdбddtdГаdбtdГаdбdЬtаdбdН}tj|jddЕddЕf<t |dГ|j d|ddЕd d Н|j d|ddЕd d Нtj|d|d dНt |d Г|j d |ddЕdd Н|j d |ddЕdd Нtj|d |d dНWdГn1Рs╠0YWdГn1Рsь0YdS)Nrr)rgrhr.rrkr&rT)┌dropnaщ№ r/rF·io.hdf.dropna_tabler"Zdf4rMrU)rgrhrrTrerNrf)rgrhrrTrirj)r rr2r3r4r5r>r<r=rr8r9r:┌pd┌option_contextrrmйr?r@r&rArArB┌test_append_all_nans╟s|■√ 0 №∙ ·ў rvc Csjt|ГРПJ}ttjаdбаdбttdГtdНt ddddНd Н}|j аdб|_ t|d Г|j d |jddЕddЕfdgdН|а d |jddЕddЕfбtа|d |б|аd d б}|jdgdН}tа||б|аd dб}|jdg|j ddЕd Н}tа||бtаdб}tjt|dНП|аd dбWdГn1Рs<0YWdГn1Рs\0YdS)Nrйrrrrrrrrrrr)Zaxes· columns=ArRrS)rxzindex=df.index[0:4]rrzOpassing a filterable condition to a non-table indexer [Filter: Not Initialized]й┌matchzcolumns=A and index>df.index[4])r rr2r3r4r5rr6r7r rZ _with_freqrr8┌ilocr9r:r]┌reindex┌re┌escape┌pytest┌raises┌ TypeError)r?r@r&rarb┌msgrArArB┌!test_append_frame_column_orienteds,¤ $ rГc Cs^t|ГПЇ}tdГD]┌}ttjаdбаdбtdГdН}tdГ|d<|d|d7<tdgt |Гdd Н|d<tdgt |Гd d Н|d <|ddkr┤|d=tdgt |Гdd Н|d<|ddkr╥|а d б}||d <|jdddН|аd|бqWdГn1Рs0Yt|ГРП0}ttjаdбаdбtdГddН}tdgt |Гdd Н|d<tdgt |Гd d Н|d <|аd|бtdgt |Гd d Н|d<t аdб}tjt|dНП|аd|бWdГn1Рs╨0Ytdgt |Гdd Н|d<t аdб}tjt|dНП|аd|бWdГn1Рs00YWdГn1РsP0YdS)Nrr)rrZABrSrr#Zint64rZint16rrVrRTrWr&rZ)rrZint16_2zCcannot match existing table structure for [int16] on appending dataryчЁ?Zfloat_3zAcannot match existing table structure for [A,B] on appending data)r rYrr2r3r4r5r6rr^┌popr_r8r}r~rrА┌ ValueError)r?r@rFr&┌arВrArArB┌)test_append_with_different_block_ordering>sL .¤ , rИc s6t|ГРПBЙЗfddД}tddgddggГ}Иаd|бtаИаdб|б|ddd Гtd dgdd ggГ}Иаd|бt||gГ}tаИаdб|б|ddd ГtddgddggГ}Иjd|ddidНtаИаdб|б|dddГИаd|бtd dgddggГ}d}tjt |dНПИаd|бWdГn1Рs<0Ytgdвgdвt gdвtdНtdddНdЬГа dб}Иjd |d!d"d#idНtаИаd б|d!бИjd$|d!d%d"d#id&НtаИаd$б|d!бИjd'|d(d"d)id*Н|абабjd+d,На dб}Иаd'|бtаИаd'бt||gГбИjd-|d!d(d"d)id*НИаd-|d!бtаИаd-бt|d!|d!gГбtИd.Гttjаd/баd0бt td1ГtdНtd2d3d!d4Нd5Н}d6|d7<tj|j|jd8d#Еd7f<d9|d:<tj|j|jd#d;Еd:f<d<|d=<tj|j|jd8dЕd=f<Иаd.|бИаd.б}tа||бWdГn1РsT0Yt|ГРП╕Йtd6d9d>Ьtd3Гd?Н}tИd.ГИjd.|d@dAidН|d.d@dAГИаd.бjd@gkРs┬JВtИd.ГИjd.|d!gd@dAid&Н|d.d@dAГИаd.бjd!d@gkРs JВtИd.ГИjd.|d!gddAid&Н|d.d!dAГ|d.dBdAГИаd.бjd!gkРs\JВtИd.ГИjd.|ddЕdAdНИjd.|ddЕdAdНtаИd.|бtgdCвd@gdDН}tИd.Гtа dEб}tjt |dНП&Иjd.|dFdFdGЬdНWdГn1Рs0YWdГn1Рs(0YdS)HNcs"tИа|бjj|Гj|ksJВdSйNй┌getattr┌ get_storerr ┌description┌itemsizeй┌keyr\r*йr@rArB┌ check_colus z+test_append_with_strings..check_colщ{Z asdqwertyiYZdggnhebbsdfbdfbZdf_big┌values_block_1rkщ|ZasdqyiZZdggnhefbdfbZdf_big2┌valuesщ2й┌min_itemsize┌df_newZ abcdefqhijZabcdefghijklmnopqrtsuvwxyzzп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 columnsry)чrДg@g@g@)rЫrДrЫrДrЫ)Zfoo1Zfoo2Zfoo3Zfoo4Zfoo5r┌20130101r(rI)rRrrTrirTrKrrrZss2Tйr1rЩZss3r щ)r!rЩZlonger)rTZss4r&rrwrrrrrrM┌stringr#rU┌string2щZbahZstring3йrRrr.rRщ╚Zvalues_block_0)rMrMrM┌barhrдrдrSzBmin_itemsize has the key [foo] which is not an axis or data_columnr)rMZfoobar)!r rr8r9r:r]r rrАrЖrr7r r_r[r;rnZreset_indexZassignrr2r3r4r5r6r<r=rrYrМr1r}r~)r?rТr&rrbrЪrВrarArСrB┌test_append_with_stringsrsд , № ∙" ¤ , rеcCsЖt|ГПj}tdgdвiГ}|jd|ddЕddidН|jd|ddЕddidНtа|аdб|бWdГn1sx0YdS)N┌x)rЗ┌b┌c┌d┌e┌f┌r&щ r#rШ)r rr8r9r:r]rurArArB┌test_append_with_empty_stringэs rоc sфt|ГРП╞ЙttjаdбаdбttdГtdНt ddddНd Н}d |j d|jаdбf<t ИdГИjd|ddЕdgd НИаd|ddЕбtаИd|бИjjjjjjjdus╢JВИjjjjjjjdus╨JВИаddб}||jdk}tа||бИаddб}|j|jddЕdН}||jdk}tа||б|аб}d|d<tj|j|jddЕdf<d|j|jddЕdf<t ИdГИjd|dgd НИаddб}||jdk}tа||бЗfddД}WdГn1Рs╪0Yt|ГПЦЙt ИdГИjd|dgddidН|dddГt ИdГИjd|dgddН|dddГt ИdГИjd|dgddidН|dddГWdГn1РsИ0Yt|ГПtЙd|d <d!|d"<d#|d$<t ИdГИjd|dd gdd%d&d'ЬdН|dddГ|dd d%Г|dd(d&ГWdГn1Рs0Yt|ГРПNЙ|аб}d |j d|jаd)бf<d*|j d|jаdбf<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ГИjd|gd-вd НИаdd.б}||jdk|jdk@|j dk@|jdk@}tj||d/d0НИаdd1б}||jdk|jd2k@}tа||бWdГn1РsА0Yt|ГРПЙ|аб}d|d<tj|j|jddЕdf<d|j|jd+d3Еdf<d2|d <t!d4Га"d5б|d6<tj|j|jd7dЕgd8вf<t Иd9ГИjd9|gd:вd НИаd9dб}||jdk}tа||бИаd9gd;вб}||jdk|j#dk@|jdk@}tj||d/d0НWdГn1Рsм0Yt|ГРПЙt dб|gd?вd@Н}d|d<tj|j|jddЕdf<d|j|jd+d3Еdf<|ddAgа$б|ddAg<d2|d <Иjd9|gdBвd НИаd9dб}||jdk}tа||бИаd9gdCвб}||jdk|j#dk@|jdk@}tа||бWdГn1Рs╓0YdS)DNrrwrrrrrrrrДrr&r0T·B>0zB>0 and index>df.index[3]rr.rMrЯr#rUr(rЮzstring='foo'cs"tИа|бjj|Гj|ksJВdSrЙrКrПrСrArBrТs z0test_append_with_data_columns..check_colщrЭrЦZ foobarbahrаZ foobarbah1Z string_block1Z foobarbah2Z string_block2щ(rЧ)rЯrаrЦrФrRgЁ┐щrб)rRrrЯrаz.string='foo' and string2='foo' and A>0 and B<0F)Z check_freqzstring='foo' and string2='cool'┌coolщ Z20010102rN┌datetimerV)rRrr╡┌df_dc)rrTrЯrаr╡)·B > 0·C > 0z string == fooz1/1/2000rI)rбrV)rRrrT)rrrT)rrTrЯrа)r╖r╕zstring == "foo")%r rr2r3r4r5rr6r7r r{rZget_locrr8r9r:Z_handle┌rootr&r ┌colsrZ is_indexedrr]r|rnr<r=rЯrаrRrrmrT┌abs) r?r&rarbrЪrТ┌slr╢rrArСrB┌test_append_with_data_columnsЎsю¤ , , №, ■¤ , "0¤"r╜cCs╬|}d|j_t|ГП`}|аd|б|аdб}tа||б|jdddgdН}|jddgdН}tа||бWdГn1sz0Y|d}|j|dddНt |dddgdН}|jddgdН}tа||бdS) NrXrRrrSztest.hdfr&r )rРr!) rr\r r8r]r9r:r|Zto_hdfr)Ztmp_pathr?Z multiindex_dataframe_random_datar&r@rarb┌pathrArArB┌test_append_hierarchicalСs *r┐cCs╕t|ГПЬ}tdtаdбаdбttdГtdНtddДtdГDГtdНd Н}|j d |ddН|а d б}tа||б|j d |ddН|а d б}tа||бWdГn1sк0YdS)NчЪЩЩЩЩЩё?щxйr░rrrcSsg|]}d|ЫЭСqSйzi-rArDrArArBrGлrHz$test_append_misc..r░rr&r#й┌ chunksizerr)Zexpectedrows) r rr2r>┌reshaperr6r7rYr8r]r9r:)r?r@r&rarArArB┌test_append_miscжs ¤ r╟r┼)rrгiшcCsьtdtаdбаdбttdГtdНtddДtdГDГtdНd Н}d |d<d|d <|d аdб|d <|d dk|d<t dГа dб|d<t dГа dб|d<t|ddНП6}|jd||dН|а dб}tа||бWdГn1s▐0YdS)Nr└r┴r┬rrcSsg|]}d|ЫЭСqSr├rArDrArArBrG╝rHz.test_append_misc_chunksize..r░rrMrЯrДZfloat322Zfloat32r┌boolrЬrNZtime1Z20130102Ztime2┌w)┌mode┌objr─)rr2r>r╞rr6r7rYrlrrmr r8r]r9r:)r?r┼r&r@rarArArB┌test_append_misc_chunksize╢s¤ r╠c Cst|ГПш}ttdГdН}|аd|бtjtddНП|аdбWdГn1sR0Yttj а dба dбtdГdН}|аd|бtа|аdб|б|аd|бtа|аdб|бttdГdН}|а d|бtа|аdб|бWdГn1sЎ0YdS) N┌ABCrSr&z 'No object named df in the file'ryr)rrVr)r rr6r8rrА┌KeyErrorr]r2r3r4r9r:r;)r?r@Zdf_emptyr&rArArB┌test_append_misc_empty_frame╩s (r╧c Csоt|ГРПО}tdtаdбаdбttdГtdНtddДtdГDГtdНd Н}d ggt |Г|d<|j dtjkstJВtа dб}tjt|d НП|аd|бWdГn1sо0Yd ggt |Г|d<d ggt |Г|d<tjt|d НП|аd|бWdГn1Рs0YtdtаdбаdбttdГtdНtddДtdГDГtdНd Н}ttаdddб|jdН}|аtб}tj|ddЕ<||d<|j dtjkРsкJВd}tjt|d НП|аd|бWdГn1Рsр0Yd}tjt|d НП"|аdtаdббWdГn1Рs&0Ytа dб}tjt|d НП&|аdttаdбГбWdГn1Рsv0YtdtаdбаdбttdГtdНtddДtdГDГtdНd Н}|аd|бd|d<tа dб}tjt|d НП|аd|бWdГn1Рs0Yt|dГtdГ|d<|аd|бd |d<tа d!б}tjt|d НП|аd|бWdГn1РsА0YWdГn1Рsа0YdS)"Nr└r┴r┬rrcSsg|]}d|ЫЭСqSr├rArDrArArBrGьrHz%test_append_raise..r░rrЗ┌invalidziCannot serialize the column [invalid] because its data contents are not [string] but [mixed] object dtyperyr&Zinvalid2Zinvalid3cSsg|]}d|ЫЭСqSr├rArDrArArBrGrHi╤r#rr.rr(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->]cSsg|]}d|ЫЭСqSr├rArDrArArBrGrHrMzЙinvalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]rЬrUainvalid 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 rr2r>r╞rr6r7rYr^ZdtypesZobject_r}r~rrАrБr8rr╡rrlr<rЖrr)r?r@r&rВrcrArArB┌test_append_raiseуsv¤ *,¤ ,2 6¤ , r╤csвtdГаdбЙtИЗfddДtdГDГdЬГ}|d|d|d <tj|jd dЕd f<t|ГРП,}t|dГ|j d|d dН|а dб}tа||б|j dddН}tа||б|j dddН}tа||j d dЕб|а ddб}tа||j d dЕб|а ddб}|jd gdН}tа||j ddЕб|а ddб}|j ddЕ}tа||j ddЕбt|dГ|аd|б|а dб}tа||бWdГn1РsФ0YdS)NrЬrNcsg|]}Иt|ddНСqS)r)┌days┌secondsrrDйrLrArBrGCrHz.test_append_with_timedelta..rrвrRrrTrVr(r&Tr0zC<100000)┌wherezC0rп)r╒r┌r)rr2r3r4r5rr6r7r rn┌renamer!r r rrАrЖ┌append_to_multiple┌select_as_multiplerRrr9r:)r?rrr&r@rВrarbrArArB┌test_append_to_multiplejs4¤ $4 . r▐cCs&ttjаdбаdбttdГtdНtddddНd Н}ttjаdбаdбttdГtdНtddddНd Нj d j dН}tj|jd|j аd dgбf<t||gddН}t|ГПn}|jd dgddЬ|dddН|аddgб}|аб}tj||ddНtа|аdбj|аdбjбWdГn1Рs0YdS)Nrrwrrrrrrrr╫rSr#rRr╪r┘rTйr┌rprr/)rr2r3r4r5rr6r7r r█r!r<r{r┌get_indexerr r r▄r▌rpr9r:Zassert_index_equalr]r)r?rrr&r@rarbrArArB┌test_append_to_multiple_dropnaПs,¤¤№ rсc CsHttjаdбаdбttdГtdНtddddНd Н}|а бj d jdН}tj|j d|jаd dgбf<t||gddН}t|ГП║}tаddбПМ|jd dgddЬ|dddНd}tjt|dНП|аddgбWdГn1s┌0Y|аdбjа|аdбjбРrJВWdГn1Рs0YWdГn1Рs:0YdS)Nrrwrrrrrrrr╫rSr#rRr╪rrT)┌df1a┌df2arтFr▀z,all tables must have exactly the same nrows!ryrу)rr2r3r4r5rr6r7r rnr█r!r<r{rrрr r rsrtr▄rrАrЖr▌r]r┌equals)r?rrr&r@rВrArArB┌$test_append_to_multiple_dropna_falseиs$¤ ,rхc Cs╓ttаddбtаddбtаddбdddДtdГDГddДtdГDГdЬГ}|jd g}t|ГПb}|jd gddgd dgdЬ|jd gdddddЬdН|аgdвб}tj ||ddНWdГn1s╚0YdS)Nr#щщXcSsg|]}dСqS)rЗrAйrE┌_rArArBrG╚rHz8test_append_to_multiple_min_itemsize..rcSsg|]}dСqS)ZabcderArшrArArBrG╔rH)┌IX┌Num┌BigNum┌Str┌LongStrrrъrыrьrэrю)rZnums┌strsrrrJr)rэrюrыrШTr/) rr2r>rYr{r r▄r▌r9r:)r?r&rbr@rarArArB┌$test_append_to_multiple_min_itemsize┴s* √ ¤ ° rЁ)4r╡rr}┌numpyr2rZpandas._libs.tslibsrZpandas.util._test_decorators┌utilZ_test_decorators┌tdZpandasrsrrrrr9r r rZpandas.tests.io.pytables.commonrr ┌markZ single_cpuZ pytestmarkZimportorskipr┌filterwarningsrCrdrorvrГrИrеrоr╜r┐r╟Zparametrizer╠r╧Z&skip_array_manager_not_yet_implementedr╤r╓r▐rсrхrЁrArArArB┌sD$ H/0V!4{ W/%