1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
U
­ý°d4Eã@sàddlZddlZddlmZmZddlZddlZddlm    Z    ddl
m Z ddl Z ddl mZmZmZmZmZmZddlmZmZddlmZdZejjZd    d
„Zd d „Z d d„Z!dd„Z"dd„Z#dd„Z$dd„Z%dd„Z&dd„Z'ej (d¡dd„ƒZ)dd„Z*d d!„Z+ej (d¡d"d#„ƒZ,d$d%„Z-ej .d&d'ej/d(ej0d)g¡d*d+„ƒZ1d,d-„Z2ej .d.ej3ej4e5d/d0g¡d1d2„ƒZ6d3d4„Z7d5d6„Z8ej .d&d'ej/d(ej0d)g¡d7d8„ƒZ9dEd9d:„Z:dFd;d<„Z;d=d>„Z<d?d@„Z=dAdB„Z>dCdD„Z?dS)GéN)Úcatch_warningsÚ simplefilter)Ú    Timestamp)Úis_platform_windows)Ú    DataFrameÚIndexÚSeriesÚ_testingÚ bdate_rangeÚread_hdf)Ú _maybe_removeÚensure_clean_store)Ú_test_decoratorsZbloscc    s¾t ¡¬‰‡fdd„}t ¡}t ||d|ƒ¡t ¡}t ||d|ƒ¡t ¡}t ||d|ƒ¡ttdƒtdƒdœƒ}|j    ˆdd    d
t
ˆdd gd }t ||j d k|¡W5QRXdS)Ncs|jˆ|f|Žtˆ|ƒS)N)Úto_hdfr )ÚkeyÚobjÚkwargs©Úpath©ú_d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/tests/io/pytables/test_round_trip.pyÚ    roundtrip&sz'test_conv_read_write.<locals>.roundtripZseriesZ string_seriesÚframeé©ÚAÚBÚtableT©Úappendzindex>2)Úwhereé) ÚtmZ ensure_cleanÚmakeTimeSeriesÚassert_series_equalÚmakeStringSeriesÚ makeDataFrameÚassert_frame_equalrÚrangerr Úindex)rÚoÚdfÚresultrrrÚtest_conv_read_write#s
 r-c    Csdtdtjddditjdddd}t|ƒ.}|jd|dgd| d¡}t ||¡W5QRXdS)NÚaédé
)Úsize©r)r+)Z data_columns)rr"Z rands_arrayr rÚselectr')Ú
setup_pathr+Ústorer,rrrÚtest_long_strings:s ÿ
 
r6cCs¨||}t ¡}|jdd…j|dddd|jdd…j|ddddt t|dƒ|¡|jdd…j|dddd|jdd…j|ddddt t|dƒ|¡dS)Nr0r+Tr©rÚformatF©r"r&Úilocrr'r ©Útmp_pathr4rr+rrrÚtest_apiGsr=cCs¤||}t ¡}|jdd…j|ddd|jdd…j|ddddt t|dƒ|¡|jdd…j|dddd|jdd…j|dddt t|dƒ|¡dS)Nr0r+Trrr7Fr9r;rrrÚtest_api_appendWsr>c    Cs
||}t ¡}|j|ddddt t|dƒ|¡|j|ddddt t|dƒ|¡|j|dddt t|dƒ|¡| |d¡t t|dƒ|¡t|ƒ^}t ¡}t|dƒ|jd|jdd…dd    d|jd|jdd…dd    dt |     d¡|¡t|dƒ|jd|jdd…dd    d|jd|jdd…dd    dt |     d¡|¡t|dƒ|jd|jdd…dd    d|jd|jdd…dd    dt |     d¡|¡t|dƒ|jd|jdd…dd    d|jd|jdd…dddt |     d¡|¡W5QRXdS)
Nr+FÚfixedr7Úfrr0Tr)
r"r&rr'r r r rr:r3)r<r4rr+r5rrrÚ
test_api_2es8  
 
 
 
rAc    Cs||}t ¡}d}tjt|d|j|ddddW5QRXtjt|d|j|ddddW5QRXd}tjt|d|j|ddd    dW5QRXtjt|d|j|dd
d    dW5QRXd }d |›d }tjt|dt|dƒW5QRXdS)NzCan only append to Tables©Úmatchr+Tr@r7r?z)invalid HDFStore format specified \[foo\]ÚfooFÚzFile z does not exist)    r"r&ÚpytestÚraisesÚ
ValueErrorrÚ    TypeErrorÚFileNotFoundErrorr )r<r4rr+ÚmsgrrrÚtest_api_invalids  rLc
Cs„t|ƒr}t ¡|d<| d¡}|d}t ||¡| d¡}|d}t ||¡tjtdd| d¡W5QRXW5QRXdS)Nr.z/az'No object named b in the file'rBÚb)r r"r#Úgetr$rFrGÚKeyError)r4r5ÚleftÚrightrrrÚtest_get¬s
 
 
 rRcCs$ttj dd¡ƒ}t|tj|ƒdS)Né2r/)rÚnpÚrandomÚrandnÚ_check_roundtripr"r')r4r+rrrÚtest_put_integer»srXc CsÒt|ƒ¾}tddddgidd}| d|¡t |j|dj¡tddddgidd}| d    |¡t |j|d    j¡t d
¡}tj    t
|d | d    |¡W5QRXtt j dgdgdggd dd gd}| d|¡t |j|dj¡|jddksþt ‚tdd„dDƒƒ}d|d<d|d<|d d¡|d<|ddk|d<tdƒ|d<tdƒ|d<| d|¡| d¡j ¡}dd „|jDƒ|_tdddddddddd!œ    d"d#}| ¡}| ¡}t ||¡W5QRXdS)$Nr.ér!éZf8©ÚdtypeZdf_f8Úi8Zdf_i8zñinvalid combination of [values_axes] on appending data [name->values_block_0,cname->values_block_0,dtype->float64,kind->float,shape->(1, 3)] vs current table [name->values_block_0,cname->values_block_0,dtype->int64,kind->integer,shape->None]rBZf4r©ÚcolumnsZdf_f4rÚfloat32cSs"i|]}|ttj d¡|d“qS)rr[)rrTrUÚrandint)Ú.0ÚcrrrÚ
<dictcomp>àsÿz6test_table_values_dtypes_roundtrip.<locals>.<dictcomp>)r`Úfloat64Úint32Úint64Úint16Úint8rDÚstringçð?Zfloat322ÚboolZ20130101Ztime1Z20130102Ztime2Zdf_mixed_dtypes1cSsg|] }t|ƒ‘qSr)Ústr)rbÚirrrÚ
<listcomp>îsz6test_table_values_dtypes_roundtrip.<locals>.<listcomp>)    r`rerfrlrhrirgÚobjectzdatetime64[ns]Úcount)Úname)r rrr"r$ZdtypesÚreÚescaperFrGrHrTÚarrayÚAssertionErrorZastyperr3Z value_countsr)rZ
sort_index)r4r5Údf1Údf2rKr,ÚexpectedrrrÚ"test_table_values_dtypes_roundtripÁs\   ÿ$ þÿ   ÷ ôrzz(ignore::pandas.errors.PerformanceWarningcCsŒt ¡}t|tj|dt ¡}t|tj|dt|jt|jtdƒ}t|tj|dt|j    tt
j |jtdtdƒ}t|tj|dddS)Nrr[F)rÚcheck_index_type) r"r%rWr$r#rr)rrpÚvaluesrTZasarray)r4ÚsÚtsZts2Zts3rrrÚ test_seriess ÿrcCs4tj d¡}ttj d¡|d}t|tj|ddS)Nr0r2r)rTrUrVrrWr"r$)r4r)r}rrrÚtest_float_indexs r€c    Cslt d¡}dddg}tj d¡ d¡}t|||d}tdd    $td
tj    j
ƒt |t j |d W5QRXdS) Nr0)grk)ç@ç@)g@g@é)rZr0)r)r_T©ÚrecordÚignorer)rTZarangerUrVZreshaperrrÚpdÚerrorsÚPerformanceWarningrWr"r')r4ÚcolÚidxÚdataZDFrrrÚtest_tuple_indexs
 
 rc    Cstddtj d¡}dd„}W5QRXtdd"t|ddgƒ}t|||dW5QRXtdd(t|tj ¡dgƒ}t|||dW5QRXtdd"t|ddgƒ}t|||dW5QRXtdd(t|tj ¡d    gƒ}t|||dW5QRXtddt|ddgƒ}t|||dt|tj ¡dgƒ}t|||dt|ddgƒ}t|||dt|tj ¡d    gƒ}t|||dt|d
d gƒ}t|||dt|d d gƒ}t|||dt|d dgƒ}t|||dt|t dd d ¡t dd d¡gƒ}t|||dW5QRXdS)NTr„r!cSstj||ddS)NT)r{)r"r$)ÚlhsÚrhsrrrÚ<lambda>+óz"test_index_types.<locals>.<lambda>rÚyrr.g®Gáz®ó?rMrYg{®Gázø?riÜ)    rrTrUrVrrWÚdatetimeÚtodayÚdate)r4r|ÚfuncZserrrrÚtest_index_types&sF      ÿr—cCsltddƒ}ttj t|ƒ¡|d}zt|tj|dWn0t    k
rft
ƒr`|j   t j d¡¡‚YnXdS)Nz1/1/1940z1/1/1960r2rz'known failure on some windows platforms)r
rrTrUrVÚlenrWr"r$Ú OverflowErrorrÚnodeZ
add_markerrFÚmarkZxfail)r4ÚrequestZdrr~rrrÚtest_timeseries_preepochYs
 
ÿrÚ compressionFT)Zmarksc    CsÀt ¡}tj|jd<tj|jd<t|tj||dt|tj||dt ¡}t|tj||dt    |ƒ8}tj
  t |ƒ¡|d<||d<|d}|j  ¡sšt‚W5QRXt|dd…tj|ddS)N)rr)rrZ©rržrDr+rr)r"r&rTÚnanr:Ú_check_roundtrip_tabler'rWZmakeTimeDataFramer rUrVr˜Z_mgrZis_consolidatedrv)ržr4r+Ztdfr5ÚreconsrrrÚ
test_framefs8  ÿÿÿ
r£cCsttd}tdtd}tƒ}tdddgd}tdd    d
gd }t|tj|d t|tj|d t|tj|d t|tj|d t|tj|d dS) Nr[Zmyseries)rrr\r.rMrcr2ÚdÚer@r^r)rrprrWr"r$r')r4Ús0Ús1Zdf0rwrxrrrÚtest_empty_series_frame‡s
 r¨r\zm8[ns]zM8[ns]cCst|d}t|tj|ddS)Nr[r)rrWr"r$)r\r4r}rrrÚtest_empty_series•s
r©cCsBdd„tddƒDƒ}ttj t|ƒd¡|d}t|tj|ddS)NcSsg|] }| ¡‘qSr)r•)rbÚxrrrroœsz,test_can_serialize_dates.<locals>.<listcomp>z1/1/2000z    1/30/2000ér2r)    r
rrTrUrVr˜rWr"r')r4ÚrngrrrrÚtest_can_serialize_dates›sr­c    Csn|}t|tj|dt|jtj|dt|dtj|dt|ƒ"}||d<|d}t ||¡W5QRXdS)Nrrr)rWr"r'ÚTr$r )r4Z multiindex_dataframe_random_datarr5r¢rrrÚtest_store_hierarchical¢s
r¯c    Cs¾dd„}|ƒ}|ƒ}t|tj|dt|tj|dt|ƒ6}||d<t |d|¡||d<t |d|¡W5QRXt|dtj||dt|dtj||dt|dtj||ddS)    NcSsPt ¡}d|d<d|d<|ddk|d<|ddk|d    <d
|d <d |d <| ¡S)NrDÚobj1ÚbarÚobj2rrÚbool1rZbool2rYÚint1r!Zint2)r"r&Z _consolidate)r+rrrÚ    _make_one´sz#test_store_mixed.<locals>._make_onerrr°rŸr³r´)rWr"r'r r$)ržr4rµrwrxr5rrrÚtest_store_mixed°s8
 
üüür¶c    KsLi}|rt|d<t|df|Ž$}||d<|d}|||f|ŽW5QRXdS)NÚcomplibÚwr)Ú_default_compressorr )rÚ
comparatorrržrÚoptionsr5Ú    retrievedrrrrWßsrWc    CsPi}|rt|d<t|df|Ž(}|jd|dd|d}|||ƒW5QRXdS)Nr·r¸rr©r8)r¹r Úput)rrºrržr»r5r¼rrrr¡êsr¡c    CsVddg}tdd:tdtjjƒttj t    |ƒ¡|ƒ}t
|t j |dW5QRXdS)NuσuσσTr„r†r) rrr‡rˆr‰rrTrUrVr˜rWr"r$)r4Zunicode_valuesr}rrrÚtest_unicode_indexös
 r¿c    Cs¤d}td|giƒ}t|ƒ.}|jd|ddd| d¡}t ||¡W5QRXtd|gddgd    œƒ}t|ƒ.}|jd|ddd| d¡}t ||¡W5QRXdS)
NuΔrr+rzutf-8)r8Úencodingr.rMr)rr r¾rNr"r')r4Úcharr+r5r,rrrÚtest_unicode_longer_encodeds
 
 
 
rÂcCsPtdddgdddgddd    gd
œƒ}t ¡}|jdd…|d <t|tj|d dS) NrYr!rZrkrr‚r.rMrc)r.rMrcr¤r)rr"r#r)rWr')r4r+r~rrrÚtest_store_datetime_mixeds"rÃcCsdtddgddgdœƒ}||}|j|dddt|dƒ}t ||¡| |¡sRt‚| |¡s`t‚dS)    NrYr!rªr’)rrr+rr½)rrr r"r'Úequalsrv)r<r4r+rÚotherrrrÚtest_round_trip_equalss
 rÆ)F)F)@r“rsÚwarningsrrÚnumpyrTrFZpandas._libs.tslibsrZ pandas.compatrZpandasr‡rrrr    r"r
r Zpandas.tests.io.pytables.commonr r Z pandas.utilrÚtdr¹r›Z
single_cpuZ
pytestmarkr-r6r=r>rArLrRrXrzÚfilterwarningsrr€rr—rZ parametrizeÚparamZskip_if_windowsr£r¨rgrerpr©r­r¯r¶rWr¡r¿rÂrÃrÆrrrrÚ<module>sb     *A
 
 
 
2 ÿ
 
ÿ
,