o ╒йZh<Пу@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|ГРПF}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ГdS1РsOwYdS)'Nщ)щщ┌ABCDй┌dtype· 2000-01-01r┌Bй┌periods┌freqй┌columns┌index┌df1щ ┌df2┌table)┌format┌df3z/df3z/df3 foozdf3 fooщr)┌data┌testing┌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йrB·[/var/www/html/lang_env/lib/python3.10/site-packages/pandas/tests/io/pytables/test_append.py┌test_appendsn¤ " ■■■■єэ $╝rDc Cs·t|ГПя}ttdГtjddДtdГDГdН}ttjdtjdНtdddНd Н}ttаd бГ}|аd|б|d}tа ||б|j dusDJВ|аd|б|d}tа ||б|j dus[JВd |_ |аd|б|d}tа ||б|j |j ksvJВ||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ГdS1sЎwYdS)"NrcSєg|]}d|ЫЭСqS)Zi_rBй┌.0┌irBrBrC┌ kєz&test_append_series..)rrrrz 2020-01-01йrr/щd┌ss┌ts┌foo┌nsщ<zfoo>60щFщZzfoo>70 and index<90Tr0r)r)r#┌Aйrr┌C┌barщr)йZinplace)Zfuture_stack┌mi)r r┌ranger3┌float64r?r r9r:┌assert_series_equal┌name┌selectrrr4r5r6┌lenr>┌ set_index┌stackZ droplevel) r@rArMrNrP┌result┌expectedrZ┌srBrBrC┌test_append_serieshsF " "╒rfcCs■t|ГПё}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ГdS1s°wYdS)NrrZint32rOrW· 2001-01-01rP· 2001-01-02)rT┌A1┌A2rrV┌D┌Er/rrщ)rirrkrlrTr0rirjrrlr")r rrr3r4r5r6┌astyper┌as_unitr?rr=r>r9r:r;┌copy)r@rAr'rrr"rBrBrC┌test_append_some_nansЧsL ўЇ "╘rqcCs 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бП)t |dГ|а d|ddЕб|а d|ddЕбtа|d|бWdГn1s░wYt аdd бРП%t |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хwYWdГdSWdГdS1Рs■wYdS)Nrr)rirjr/rrmr'rT)┌dropnaщ№ r0rF·io.hdf.dropna_tabler"Zdf4rOrW)rirjrrVrgrPrh)rirjrrVrkrl)r rr3r4r5r6r?r=r>rr9r:r;┌pd┌option_contextrroйr@rAr'rBrBrC┌test_append_all_nans╟sЖ■√ № №∙ ·ў ╦у$уrxc Csvt|ГПн}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Гn1sЬwYWdГdSWdГdS1s┤wYdS)Nrйrrrrrrrrrrr)Zaxes· columns=ArTrU)rzzindex=df.index[0:4]rrzOpassing a filterable condition to a non-table indexer [Filter: Not Initialized]й┌matchzcolumns=A and index>df.index[4])r rr3r4r5r6rr7r8r rZ _with_freqrr9┌ilocr:r;r_┌reindex┌re┌escape┌pytest┌raises┌ TypeError)r@rAr'rcrd┌msgrBrBrC┌!test_append_frame_column_orienteds4 ¤ $ ф"фrЕc Csjt|ГПz}tdГD]m}ttjаdбаdбtdГdН}tdГ|d<|d|d7<tdgt |Гdd Н|d<tdgt |Гd d Н|d <|ddkrZ|d=tdgt |Гdd Н|d<|ddkri|а d б}||d <|jdddН|аd|бq WdГn1sБwYt|ГПа}ttjаdбаdбtdГddН}tdgt |Гdd Н|d<tdgt |Гd d Н|d <|аd|бtdgt |Гd d Н|d<t аdб}tjt|dНП|аd|бWdГn1sхwYtdgt |Гdd Н|d<t аdб}tjt|dНП|аd|бWdГn1РswYWdГdSWdГdS1Рs.wYdS)Nrr)rrZABrUrr#Zint64rZint16rrXrTTrYr'r\)rrZint16_2zCcannot match existing table structure for [int16] on appending datar{чЁ?Zfloat_3zAcannot match existing table structure for [A,B] on appending data)r r[rr3r4r5r6r7rr`┌poprar9rrАrБrВ┌ ValueError)r@rArHr'┌arДrBrBrC┌)test_append_with_different_block_ordering>sZ ю ¤ щ$щrКc sDt|ГРПаЙЗ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Гn1sЭwYtgdв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Гn 1РsйwYt|ГПхЙ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РsJВ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РsВwYWdГdSWdГdS1РsЫwYdS)HNcє"tИа|бjj|Гj|ksJВdSйNй┌getattr┌ get_storerr ┌description┌itemsizeй┌keyr^r+йrArBrC┌ check_coluє"z+test_append_with_strings..check_colщ{Z asdqwertyiYZdggnhebbsdfbdfbZdf_big┌values_block_1rmщ|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 columnsr{)чrЖg@g@g@)rЯrЖrЯrЖrЯ)Zfoo1Zfoo2Zfoo3Zfoo4Zfoo5r┌20130101r)rK)rTrrVrkrVrMrrrZss2Tйr2rЭZss3r щ)r!rЭZlonger)rVZss4r'rryrrrrrrO┌stringr#rW┌string2щZbahZstring3йrTrr/rTщ╚Zvalues_block_0)rOrOrO┌barhrиrиrUzBmin_itemsize has the key [foo] which is not an axis or data_columnr)rOZfoobar)!r rr9r:r;r_r rБrВrИrr8r rar]r<rpZreset_indexZassignrr3r4r5r6r7r=r>rr[rПr2rrА)r@rХr'rrdrЮrДrcrBrФrC┌test_append_with_stringsrs░ № ∙" ¤ о T ▐"$▐rйcCsИt|ГП6}tdgdвiГ}|jd|ddЕddidН|jd|ddЕddidНtа|аdб|бWdГdS1s=wYdS)N┌x)rЙ┌b┌c┌d┌e┌f┌r'щ r#rЬ)r rr9r:r;r_rwrBrBrC┌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|бИjjjjjjjdusZJВИjjjjjjjdusgJВИа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Гn1sъwYt|ГПKЙt ИdГИjd|dgddidН|dddГt ИdГИjd|dgddН|dddГt ИdГИjd|dgddidН|dddГWdГn 1РsBwYt|ГП:Йd|d <d!|d"<d#|d$<t ИdГИjd|dd gdd%d&d'ЬdН|dddГ|dd d%Г|dd(d&ГWdГn 1РsЙwYt|ГПзЙ|аб}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Гn 1Рs=wYt|ГПИЙ|аб}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Гn 1Рs╥wYt|ГПИЙ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ГdS1РsgwYdS)DNrryrrrrrrrrЖrr'r1T·B>0zB>0 and index>df.index[3]rr/rOrгr#rWr)rвzstring='foo'crЛrМrНrТrФrBrCrХrЦz0test_append_with_data_columns..check_colщrбrЪZ foobarbahrдZ foobarbah1Z string_block1Z foobarbah2Z string_block2щ(rЫ)rгrдrЪrШrTgЁ┐щrе)rTrrгrдz.string='foo' and string2='foo' and A>0 and B<0F)Z check_freqzstring='foo' and string2='cool'┌coolщ Z20010102rP┌datetimerX)rTrr╣┌df_dc)rrVrгrдr╣)·B > 0·C > 0z string == fooz1/1/2000rK)rеrX)rTrrV)rrrV)rrVrгrд)r╗r╝zstring == "foo")%r rr3r4r5r6rr7r8r r}rZget_locrr9r:r;Z_handle┌rootr'r ┌colsrZ is_indexedrr_r~rpr=r>rгrдrTrrorV┌abs) r@r'rcrdrЮrХ┌slr║rrBrФrC┌test_append_with_data_columnsЎs· ¤ ┘ , ў №є ■¤ т "ы ¤"$шr┴cCs╬|}d|j_t|ГП0}|аd|б|аdб}tа||б|jdddgdН}|jddgdН}tа||бWdГn1s=wY|d}|j|dddНt |dddgdН}|jddgdН}tа||бdS) NrZrTrrUztest.hdfr'r )rУr!) rr^r r9r_r:r;r~Zto_hdfr)Ztmp_pathr@Z multiindex_dataframe_random_datar'rArcrd┌pathrBrBrC┌test_append_hierarchicalСs ° r├cCs║t|ГПO}tdtаdбаdбttdГtdНtddДtdГDГtdНd Н}|j d |ddН|а d б}tа||б|j d |ddН|а d б}tа||бWdГdS1sVwYdS)NчЪЩЩЩЩЩё?щxйr┤rrrcSrEйzi-rBrFrBrBrCrIлrJz$test_append_misc..r┤rr'r#й┌ chunksizerr)Zexpectedrows) r rr3r?┌reshaperr7r8r[r9r_r:r;)r@rAr'rcrBrBrC┌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НП}|jd||dН|а dб}tа||бWdГdS1spwYdS)Nr─r┼r╞rrcSrEr╟rBrFrBrBrCrI╝rJz.test_append_misc_chunksize..r┤rrOrгrЖZfloat322Zfloat32r┌boolrаrPZtime1Z20130102Ztime2┌w)┌mode┌objr╚)rr3r?r╩rr7r8r[rnrror r9r_r:r;)r@r╔r'rArcrBrBrC┌test_append_misc_chunksize╢s ¤ "¤r╨c Cst|ГПu}ttdГdН}|аd|бtjtddНП |аdбWdГn1s)wYttj а dба dбtdГdН}|аd|бtа|аdб|б|аd|бtа|аdб|бttdГdН}|а d|бtа|аdб|бWdГdS1s|wYdS) N┌ABCrUr'z 'No object named df in the file'r{r)rrXr)r rr7r9rБrВ┌KeyErrorr_r3r4r5r:r;r<)r@rAZdf_emptyr'rBrBrC┌test_append_misc_empty_frame╩s "яr╙c Cs║t|ГРП═}tdtаdбаdбttdГtdНtddДtdГDГtdНd Н}d ggt |Г|d<|j dtjks:JВtа dб}tjt|d НП|аd|бWdГn1sWwYd ggt |Г|d<d ggt |Г|d<tjt|d НП|аd|бWdГn1sИwYtdtаdбаdбttdГtdНtddДtdГDГtdНd Н}ttаdddб|jdН}|аtб}tj|ddЕ<||d<|j dtjks╙JВd}tjt|d НП|аd|бWdГn1sэwYd}tjt|d НП|аdtаdббWdГn 1РswYtа dб}tjt|d НП|аdttаdбГбWdГn 1Рs8wYtdtаdбаdбttdГtdНtddДtdГDГtdНd Н}|аd|бd|d<tа dб}tjt|d НП|аd|бWdГn 1РsЕwYt|dГtdГ|d<|аd|бd |d<tа d!б}tjt|d НП|аd|бWdГn1Рs╜wYWdГdSWdГdS1Рs╓wYdS)"Nr─r┼r╞rrcSrEr╟rBrFrBrBrCrIьrJz%test_append_raise..r┤rrЙ┌invalidziCannot serialize the column [invalid] because its data contents are not [string] but [mixed] object dtyper{r'Zinvalid2Zinvalid3cSrEr╟rBrFrBrBrCrIrJi╤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->]cSrEr╟rBrFrBrBrCrIrJrOzЙinvalid combination of [non_index_axes] on appending data [(1, ['A', 'B', 'C', 'D', 'foo'])] vs current table [(1, ['A', 'B', 'C', 'D'])]rаrWainvalid 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 rr3r?r╩rr7r8r[r`ZdtypesZobject_rrАrБrВrГr9rr╣rrnr=rИrr)r@rAr'rДrerBrBrC┌test_append_raiseуsК¤ ¤ ¤ оR$о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ГdS1s╔wYdS)NrаrPcsg|] }Иt|ddНСqS)r)┌days┌secondsrrFйrNrBrCrICsz.test_append_with_timedelta..rrжrTrrVrXr)r'Tr1zC<100000)┌wherezCr rr9r_r:r;r}rrr<)r@r'rArcrBr╪rC┌test_append_with_timedelta;s<■ "тr┌c Cs░ttjаdбаdбttdГtdНtddddНd Н}|а бj d jdН}d|d <t||gddН}t |ГПЬ}d}tjt|dНП|jddgddЬ|ddНWdГn1sTwYtjt|dНП|jdddЬ|ddНWdГn1svwYd}tjt|dНП|аd|dбWdГn1sЦwY|jddgddЬ|ddН|jddgddgddН}||jdk|jdk@}tа||бWdГdS1s╤wYdS)Nrryrrrrrrr·{}_2rUrWrOr#йZaxisz=append_to_multiple requires a selector that is in passed dictr{rTйrrr")┌selectorzQappend_to_multiple must have a dictionary specified as the way to split the valuerrzA>0r│)r┘r▐r)rr3r4r5r6rr7r8r rp┌renamer!r r rБrВrИ┌append_to_multiple┌select_as_multiplerTrr:r;)r@rrr'rArДrcrdrBrBrC┌test_append_to_multiplejs<¤ "ш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|ГП8}|jd dgddЬ|dddН|аddgб}|аб}tj||ddНtа|аdбj|аdбjбWdГdS1sМwYdS)Nrryrrrrrrrr█rUr#rTr▄r▌rTйr▐rrrr0)rr3r4r5r6rr7r8r r▀r!r=r}r┌get_indexerr r rрrсrrr:r;Zassert_index_equalr_r)r@rrr'rArcrdrBrBrC┌test_append_to_multiple_dropnaПs.¤¤№ "°rхc CsTttjаdбаdбttdГtdНtddddНd Н}|а бj d jdН}tj|j d|jаd dgбf<t||gddН}t|ГПd}tаddбПE|jd dgddЬ|dddНd}tjt|dНП|аddgбWdГn1smwY|аdбjа|аdбjбrБJВWdГn1sЛwYWdГdSWdГdS1sгwYdS)Nrryrrrrrrrr█rUr#rTr▄rtT)┌df1a┌df2arцFrуz,all tables must have exactly the same nrows!r{rч)rr3r4r5r6rr7r8r rpr▀r!r=r}rrфr r rurvrрrБrВrИrсr_r┌equals)r@rrr'rArДrBrBrC┌$test_append_to_multiple_dropna_falseиs(¤ PЇrщc Cs╪ttаddбtаddбtаddбdddДtdГDГddДtdГDГdЬГ}|jd g}t|ГП2}|jd gddgd dgdЬ|jd gdddddЬdН|аgdвб}tj ||ddНWdГdS1sewYdS)Nr#щщXcSєg|]}dСqS)rЙrBйrG┌_rBrBrCrI╚єz8test_append_to_multiple_min_itemsize..rcSrь)ZabcderBrэrBrBrCrI╔rя)┌IX┌Num┌BigNum┌Str┌LongStrrrЁrёrЄrєrЇ)r┌nums┌strsrrrLr)rєrЇrёrЬTr0) rr3r?r[r}r rрrсr:r;)r@r'rdrArcrBrBrC┌$test_append_to_multiple_min_itemsize┴s, √ ¤ ° "Їrў)4r╣rr┌numpyr3rБZpandas._libs.tslibsrZpandas.util._test_decorators┌utilZ_test_decorators┌tdZpandasrurrrrr:r r rZpandas.tests.io.pytables.commonrr ┌markZ single_cpuZ pytestmarkZimportorskipr┌filterwarningsrDrfrqrxrЕrКrйr▓r┴r├r╦Zparametrizer╨r╙Z&skip_array_manager_not_yet_implementedr╒r┌rтrхrщrўrBrBrBrC┌sF$ H/0V!4{ W/%