+
    xȇi                        ^ RI t ^ RIt^ RIt^ RIt^ RIt^ RIt^ RIt^ RI	H
t
 ^ RIt^ RIHtHtHtHtHtHtHtHtHtHt ^ RIHt ^ RIHt ^ RIHtHt ]P>                  P@                  .t!]PD                  ! R4      t#R t$R t%R	 t&R
 t'R t(R t)R t*]P>                  PW                  RRRRR0],! 4       3R],! 4       RR03RR0RR03R],! 4       R03/3RRR0RR03R],! 4       R03/3.4      R 4       t-R t.R t/R t0]P>                  PW                  R R!R".4      R# 4       t1R$ t2R% t3R& t4R' t5R( t6R) t7R* t8R+ t9]P>                  PW                  R,RR-.4      ]P>                  PW                  R.R"R!.4      R/ 4       4       t:R0 t;R1 t<R2 t=R3 t>R4 t?R5 t@R6 tAR7 tBR8 tCR9 tDR: tE]P>                  PW                  R;. RYO4      R< 4       tFR= tGR> tH]P>                  PW                  R?R@RA.4      RB 4       tIRC tJRD tKRE tL]P>                  P                  RF4      ]P>                  PW                  RG]! ^ ^.]P                  RH7      ]! RIRJ.]P                  RH7      ]! RK^RL7      ]! RM^RL7      ]! RK^RNRO7      .4      RP 4       4       tP]P>                  PW                  RQRRR.4      RS 4       tQRT tRRU tS]P>                  PW                  RV. RZO4      RW 4       tTRX tUR# )[    N)PY312)
	DataFrameDatetimeIndexIndex
MultiIndexSeries	Timestampconcat
date_rangeperiod_rangetimedelta_range)CategoricalDtypeHDFStoreread_hdftablesc                 V    \        V 4      ;_uu_ 4       p\        R 4      h  + '       g   i     M; i  \         d     Mi ; i\        T 4      ;_uu_ 4       p\        R\        P                  ! ^x4      P                  R4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRT 2NK
  	  Mu upi up\        R7      R7      TR&   \        T4      ^8X  g   Q h\        TR,          4      \        8X  g   Q h RRR4       R#   + '       g   i     R# ; i)	blahN皙?ABCDdtypei-columnsindexa      )r   
ValueErrorr   nparangereshaper   listobjectrangelentype)temp_h5_pathtblis   &  s/Users/max/.openclaw/workspace/postharvest/venv/lib/python3.14/site-packages/pandas/tests/io/pytables/test_store.pytest_contextr.   (   s    l##sV$$ $# 	,		3"))C.((11$v,f55959a2aS95VD
C
 3x1}}CH~*** 
 			s9   4 !1	4 4 AAAD4CA
DD(	c                    a \         P                  ^3R loV3R lpV! V RR7      pV! V RR7      p\        P                  ! ^4       V! V RR7      pV! V RR7      pW$8X  g   Q hW58w  g   Q hR# )   c                   aaa V! 4       o\        V R 4      ;_uu_ 4       o\        VVV3R lR4       F  pSP                  V4       K  	  RRR4       SP                  4       #   + '       g   i     SP                  4       # ; i)rbc                  H   < SP                  S SP                  ,          4      # N)read
block_size)chunk_num_blocksfhs   r-   <lambda>7test_no_track_times.<locals>.checksum.<locals>.<lambda>?   s    aff-=-L&M    r<   N)openiterupdatedigest)filenamehash_factoryr7   chunkr8   r9   s   &&f @@r-   checksum%test_no_track_times.<locals>.checksum<   sa    N(D!!QMsS T " xxz "! xxzs   +A""B	c                    < \        R ^./4      p\        V RR7      ;_uu_ 4       pVP                  RVRRRVR7       RRR4       S! V 4      #   + '       g   i     L; i)r   w)modetableTN)formatdata_columnsr   track_times)r   r   put)r*   rL   dfhdfrD   s   &&  r-   create_h5_and_return_checksum:test_no_track_times.<locals>.create_h5_and_return_checksumC   s`    aSz"l--GG!'   . %% .-s   AA	F)rL   TN)hashlibmd5timesleep)r*   rP   checksum_0_tt_falsechecksum_0_tt_truechecksum_1_tt_falsechecksum_1_tt_truerD   s   &     @r-   test_no_track_timesrZ   8   s{     )0c & 8RWX6|QUV 	JJqM7RWX6|QUV 555 333r<   c                 *    \        V 4      . 8X  g   Q hR # r4   )r%   )temp_hdfstores   &r-   test_iter_emptyr]   b   s    "$$$r<   c                 `   T p\        V4       VP                  4        \        \        P                  ! ^
\        P
                  R7      \        R^
R7      R7      VR&   \        \        ^
4      R\        ^
4       Uu. uF  pRV 2NK
  	  upR7      VR	&   \        R
\        P                  ! ^x4      P                  R(4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R7      VR&   \        R
\        P                  ! ^x4      P                  R(4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R7      pRVR&   RVR&   VR,          ^ 8  VR&   VR,          ^ 8  VR&   RVR&   ^VR&   ^VR&   \        R4      VR&   \        R4      VR&   \        P                  ! R^^^ ^ 4      VR &   \        P                  ! R^^^ ^ 4      VR!&   \        P                   VP"                  VP$                  R",          R.3&   VP'                  4       pV'       d   R#MTpR$p\(        P*                  ! WgR%7      ;_uu_ 4        WSR&&   R#R#R#4       VP,                  P/                  VP,                  P0                  R'4       VP2                  \        V4      9   g   Q hVP2                  \5        V4      9   g   Q hVP                  4        R## u upi u upi u upi   + '       g   i     L; i))
   r   
2020-01-01periodsr   r   float64i_)r   r   br   r   r   r   cfooobj1barobj2Abool1Bbool2Tbool3int1int220010102
timestamp120010103
timestamp2i  	datetime1	datetime2      NNz0cannot
map directly to c-types .* dtype='object'matchrN   bahr   )reprinfor   r"   r#   rd   r   r'   r   r$   r   r%   r&   r	   dtdatetimenanlocr   _consolidatetmassert_produces_warning_handlecreate_grouprootrA   str)r\   performance_warningusing_infer_stringstorer,   rN   warningmsgs   &&&     r-   	test_reprr   g   s   EK	JJL
		"BJJ'z,PR/SE#J b	USUY:WYRs8Y:WXE#Jbiin$$W--d6l&1uRy1y!r!Xy1@E#J 
biin$$W--d6l&1uRy1y!r!Xy1@
B
 BvJBvJS'A+BwKS'A+BwKBwKBvJBvJ ,B| ,B|kk$1a3B{Okk$1a3B{O&(ffBFF288C=6("#		B(d.AG
=C		#	#G	7	7d 
8 
MMu}}1159>>T%[(((>>SZ'''	JJLI ;X 2 2$ 
8	7s   :L.L,LLL-	c                 x   \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      \        R7      \	        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R7      pV P                  RV4       V P                  R4      p\        V4       \        V4       R# u upi )r   r   r   r   r   rN   Nr   )r   r"   r#   r$   r   r%   r&   r'   append
get_storerr   r   )r\   r,   rN   ss   &   r-   test_repr_get_storerr      s    	biin$$W--d6l&1uRy1y!r!Xy1@
B
 r"  &AGF 2s   B7c                    T p\        \        P                  ! ^
\        P                  R7      \	        R^
R7      R7      VR&   \        R\        P                  ! ^x4      P                  R4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R	7      VR
&   \        R\        P                  ! ^x4      P                  R4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R	7      VR&   RV9   g   Q hR
V9   g   Q hRV9  g   Q hRV9   g   Q hRV9   g   Q hRV9  g   Q hRV9  g   Q h\        P                  ! \        P                  RR7      ;_uu_ 4        \        R\        P                  ! ^x4      P                  R4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R	7      VR&   RRR4       RV9   g   Q hR# u upi u upi u upi   + '       g   i     L*; i)r_   r   r`   ra   rc   r   r   r   r   r   rf   zfoo/barrg   z/foo/barz/foo/brj   F)check_stacklevelznode())Nr   )r   r"   r#   rd   r   r   r$   r   r%   r&   r'   r   r   r   NaturalNameWarning)r\   r   r,   s   &  r-   test_containsr      s   E
		"BJJ'z,PR/SE#J biin$$W--d6l&1uRy1y!r!Xy1@E#J
 !biin$$W--d6l&1uRy1y!r!Xy1@E)
 %<<%<<e5    
	#	#F$=$=PU	V	V$"))C.((11$v,f55959a2aS95VD
i 
W - 2
 2 6	 
W	Vs+   H=I+AIIIII	c                    T p\        \        P                  ! ^
\        P                  R7      \	        R^
R7      R7      VR&   \        R\        P                  ! ^x4      P                  R4      ,          \        \        R4      \        R7      \        \        ^4       Uu. uF  pRV 2NK
  	  up\        R7      R	7      VR
&   \        \        P                  P                  ^4      P                  R4      \        \        R4      \        R7      \	        R^RR7      R	7      pVP                  RVR,          4       VP                  RVR,          4       VP                  P                   P"                  P$                  R8X  g   Q hVP                  P&                  P"                  P$                  R8X  g   Q hVP                  P(                  P"                  P$                  R8X  g   Q hVP                  RV4       RVP+                  R4      P"                  n        Rp\,        P.                  ! \0        VR7      ;_uu_ 4        VP3                  R4       RRR4       R# u upi   + '       g   i     R# ; i)r_   r   r`   ra   rc   r   r   r   r   r   rf   
2000-01-01rn   rb   freqdf1:Nr_   N:r_   NNz0.15.2df2Nz/'NoneType' object has no attribute 'startswith'r|   r   )   r    )r   r"   r#   rd   r   r   r$   r   r%   r&   r'   randomdefault_rngstandard_normalr   r   r   _v_attrspandas_versionrf   r   get_nodepytestraises	Exceptionselect)r\   r   r,   rN   r   s   &    r-   test_versioningr      s   E
		"BJJ'z,PR/SE#J biin$$W--d6l&1uRy1y!r!Xy1@E#J
 

		a 009d6l&1r<
B
 
LL3 	LL3 ::<<  //8;;;::<<  //8;;;::>>""11X=== 
LL 59ENN5""1
;C	y	,	,U 
-	,- 2, 
-	,	,s   I;II-	zwhere, expected/ first_groupsecond_group/first_groupr   r   /second_groupthird_groupdf3s1z/second_group/third_groupdf4c                    R \        . RO4      R\        . RO4      R\        . RO4      R\        . RO4      R\        . RO4      R\        P                  ! . RO. RO.4      R\        P                  ! RR.RR7      R	\        P                  ! RR.RR7      /pTpVP	                  R
VR ,          4       VP	                  RVR,          4       VP	                  RVR,          4       VP	                  RVR,          4       VP	                  RVR,          4       VP
                  P                  RRVR,          4       VP
                  P                  RRVR,          R7       VP
                  P                  RR	VR	,          R7       \        \        VP                  V R7      4      4      \        V4      8X  g   Q hVP                  V R7       F  w  rVpWQ9   g   Q hW,          w  rV\        V4      8X  g   Q hV	\        V4      8X  g   Q hV Fi  p
RP                  WZ.4      pVP                  V4      pRV
9   d    \        P                  ! WV
,          4       KL  \        P                   ! WV
,          4       Kk  	  K  	  R# )r   r   r   r   r   a1tb1zi,i,ir   tb2z/first_group/df1z/first_group/df2z/second_group/df3z/second_group/s1z/second_group/third_group/df4r   )objr   wherer   rN   N      rz   )r       r{   )r{         )	   r_      )r_   r   r   )r   r   r   )r_   r      )r   r   r"   arrayrM   r   create_arraycreate_tabler(   r%   walksetjoingetr   assert_frame_equalassert_series_equal)r   expectedr\   objsr   pathgroupsleavesexpected_groupsexpected_framesleaf
frame_pathr   s   &&&          r-   	test_walkr      s   0 	y#y#y#y%fZ bhh	9-.rxxI.g>rxxL1A
D E	II $u+.	II $u+.	II!4;/	II $t*-	II-tE{;	MM~tT$Z@	MM~u$u+F	MM4;GtEJJUJ+,-X>>> %


 7f+3>(#f+---#f+---D4,/J))J'Ct|%%c:6&&sJ7  !8r<   c           
         T p\        \        P                  ! ^
\        P                  R7      \	        R^
R7      R7      pW!R&   VP
                  p\        P                  ! W24       VP
                  p\        P                  ! W24       \        \        P                  P                  ^4      P                  R4      \        \        R4      4      \	        R^
RR	7      R
7      pWAR&   VP                  p\        P                  ! W44       R FA  pRV R2p\         P"                  ! \$        VR7      ;_uu_ 4        \'        W4       RRR4       KC  	  R F  p\'        VRV 24       K  	  R#   + '       g   i     Kp  ; i)r_   r   r`   ra   rc   r   r   r   rn   r   r   rN   z$'HDFStore' object has no attribute ''r|   N_r_   r    )drH   r   handlecomplib)rH   r   r   r   )r   r"   r#   rd   r   r   r   r   r   r   r   r   r   r%   rN   r   r   r   AttributeErrorgetattr)r\   r   r   resultrN   xr   s   &      r-   test_getattrr   #  s(   E
		"BJJ'z,PR/S	A #J WWF6%WWF6%	
		a 009d6l#r<
B
 $KXXF&% 84QCq9]]>55E 65 8 31#w 3	 655s   4E&&E7c                 :   \        R R\        P                  R.RR\        P                  \        P                  ./\        R4      R7      p\        R RR.RR\        P                  ./\        R4      R7      pVP	                  V RR	R
7       \        V R4      p\        P                  ! W4       VP	                  V RR	RR7       \        V R4      p\        P                  ! W4       VP	                  V RR	RR7       \        V R4      p\        P                  ! W#4       R# )col1               @col2      ?abcrc   acrN   rI   keyrJ   F)r   rJ   dropnaTN)r   r"   r   r%   to_hdfr   r   r   )r*   df_with_missingdf_without_missingreloadeds   &   r-   test_store_dropnar   D  s    	#rvvs#Vc266266-BC5kO #	#sVc266]34: <T'Bd+H/4<T'%Pd+H/4<T'$Od+H,7r<   c                    \        R . ROR. ROR\        . RO4      R\        R^R7      /4      P                  R4      pVP	                  V RRR^/R	7       VP                  4       P                  4       P                  R
R7      P                  R4      pVP	                  V RRRR7       \        P                  ! \        V R4      \        W.4      4       VR,          P	                  V RRR^/R	7       VR,          P	                  V RRRR7       \        P                  ! \        V R4      \        VR,          VR,          .4      4       R# )rl   rn   CD20130101ra   ss3rI   r   )r   rJ   min_itemsizelonger)r   T)r   r   rJ   ss4N)r   r   r   g      @g      @)r   r   r   r   r   )foo1foo2foo3foo4foo5)r   r   r   	set_indexr   copyreset_indexassignr   r   r   r
   r   )r*   rN   r   s   &  r-   test_to_hdf_with_min_itemsizer  \  s   	**?@J2		

 in  IIlgWaLIQ
'')


!
(
(8
(
4
>
>s
CCJJ|tGJD(<7	9JK sGNN<U7'STNVHOOLeDOI8L%8&"S'3s8AT:UVr<   rJ   fixedrI   c                 B   R .p\        V\        VRR7      RR7      pVP                  VRV RR7       \        VRRR7      pV'       d(   \        P
                  ! R\        P                  R	7      pMRp\        V\        W6R7      VR7      p\        P                  ! WW4       R
# )u   foor&   r   )r   r   rI   surrogatepass)r   rJ   errors)r  python)storagena_valueN)
r   r   r   r   pdStringDtyper"   r   r   r   )rJ   r*   r   dataserr   r   r   s   &&&     r-   test_to_hdf_errorsr  r  s    =D
U4x8
ICJJ|JPlGODF x"&&Ad%":%HH6,r<   c           
      0  a V oV3R  lp\        \        P                  P                  ^4      P	                  R4      \        \        R4      4      \        R^
RR7      R7      pRVR&   RVR	&   SP                  R
VRR	.R7       V! R
R4      P                  RJ g   Q hV! R
R4      P                  RJ g   Q hV! R
R	4      P                  RJ g   Q hSP                  RVR.RR	.R7       V! RR4      P                  RJ g   Q hV! RR4      P                  RJ g   Q hV! RR	4      P                  RJ g   Q hSP                  RV4       Rp\        P                  ! \        VR7      ;_uu_ 4        SP                  R4       RRR4       R#   + '       g   i     R# ; i)c                 b   < \        SP                  V 4      P                  P                  V4      # r4   r   r   rI   colstcolumnr   s   &&r-   col$test_create_table_index.<locals>.col  '    u''*0055v>>r<   r   r   rn   r   r   rh   stringrj   string2r8   rK   r   Tf2)r   rK   Fz1cannot create table index on a Fixed format storer|   Nr   )r   r"   r   r   r   r   r%   r   r   
is_indexedrM   r   r   	TypeErrorcreate_table_indexr\   r  rN   r   r   s   &   @r-   test_create_table_indexr&    s{   E? 

		a 009d6l#r<
B
 BxLByM	LLb)'<L=sG''4///sH((D000sI))T111 
LLr(8Y:OLPtW((E111tX))T111tY**e333 
IIdB
=C	y	,	,  & 
-	,	,	,s   (FF	c           
        a V oV3R  lp\        \        P                  P                  ^4      P	                  R4      \        \        R4      4      \        R^
RR7      R7      pRVR&   RVR	&   SP                  R
VR.R7       V! R
R4      P                  RJ g   Q hV! R
R4      P                  RJ g   Q hRp\        P                  ! \        VR7      ;_uu_ 4        V! R
R	4      P                   RRR4       Rp\        P                  ! \        VR7      ;_uu_ 4        SP                  R
R	.R7       RRR4       R#   + '       g   i     LU; i  + '       g   i     R# ; i)c                 b   < \        SP                  V 4      P                  P                  V4      # r4   r  r  s   &&r-   r  :test_create_table_index_data_columns_argument.<locals>.col  r  r<   r   r   rn   r   r   rh   r  rj   r  r8   r   r   Tz('Cols' object has no attribute 'string2'r|   Nzcolumn string2 is not a data_column.
In order to read column string2 you must reload the dataframe 
into HDFStore and include string2 with the data_columns argument.r   r   )r   r"   r   r   r   r   r%   r   r   r"  r   r   r   r$  r%  s   &   @r-   -test_create_table_index_data_columns_argumentr+    s)    E? 

		a 009d6l#r<
B
 BxLByM	LLbzL2sG''4///sH((D000
4C	~S	1	1C&& 
2
	L 
 
~S	1	1  yk : 
2	1 
2	1 
2	1	1s   D:E:E
	E	c                 .   \         P                  ! \        R ^R7      \        ^4      .RR.R7      p\	        R. RO/VR7      pV P                  RVRR	7       V P                  RR
R7      pVP                  ^.R3,          p\        P                  ! W44       R# )r   ra   dateidnamesr   rc   rN   Tr   zid == 1r   NNNN)r   g333333?g?gffffff?g      ?)
r   from_arraysr   r'   r   r   r   ilocr   r   )r\   idxrN   actualr   s   &    r-   test_mi_data_columnsr6    s    

 
 	L!	,eAh7~C 
C233	?Br5!!$i!8FwwsAvH&+r<   c                 6   \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      pRVR&   RVR&   VR,          ^ 8  VR	&   VR
,          ^ 8  VR&   RVR&   ^VR&   ^VR&   \        R4      P                  R4      VR&   \        R4      P                  R4      VR&   \        R4      P                  R4      VR&   \        R4      P                  R4      VR&   \        P                  VP                  VP                  R,          R.3&   VP                  4       pV P                  RV4       \        P                  ! V P!                  R4      V4       R# u upi )r   r   r   r   rh   ri   rj   rk   rl   rm   rn   ro   Trp   rq   rr   rs   nsrt   ru   rv   rw   rx   ry   	df1_mixedNr   )r   r"   r#   r$   r   r%   r'   r	   as_unitr   r   r   r   r   r   r   r   )r\   r,   rN   s   &  r-   test_table_mixed_dtypesr;    sh   	biin$$W--d6l#uRy1y!r!Xy12
B
 BvJBvJS'A+BwKS'A+BwKBwKBvJBvJ ,44T:B| ,44T:B|
+33D9B{O
+33D9B{O&(ffBFF288C=6("#		Bb)-..{;R@# 2s   Fc                 P   R pR\         P                  ! R^^4      \        P                  ! R4      .p\        P
                  P                  W!R7      p\         P                  ! R^^4      p\        V^VR7      p\        VP                  V4      P                  \        RP                  4       4      4      pV P                  RV4       V P                  R4      p\        P                  ! Wv4       V P!                  RV4       V P                  R4      p\        P                  ! Wv4       R	# )
zSun Mon Tue Wed Thuz
2012-05-01i  z
2014-05-01)holidaysweekmaskr   zMon Tue Wed Thu Fri Sat Sunr  rI   N)r   r   r"   
datetime64r  offsetsCustomBusinessDayr   r   weekdaymapsplitrM   r   r   r   r   )r\   weekmask_egyptr=  
bday_egyptmydtdtsr   r   s   &       r-   test_calendar_roundtrip_issuerI    s     +N
D!Q
l#H
 -- . J ;;tQ#D
T1:
6Cs{{C $$V,I,O,O,Q%RSAgq!!!'*F6%!$!!'*F6%r<   c                    T p\        \        P                  ! ^
\        P                  R7      \	        R^
R7      R7      p\        R\        P                  ! ^x4      P                  R4      ,          \        \        R4      4      \        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      pW!R	&   WAR
&   VP                  R	4       \        V4      ^8X  g   Q h\        P                  ! WAR
,          4       VP                  R
4       \        V4      ^ 8X  g   Q h\        P                  ! \         RR7      ;_uu_ 4        VP                  R4       RRR4       W!R	&   WAR&   VP                  R4       \        V4      ^8X  g   Q hW!R	&   WAR&   VP                  R
4       \        V4      ^8X  g   Q hW!R	&   WAR
&   VR	 VR
 \        V4      ^ 8X  g   Q hR# u upi   + '       g   i     L; i)r_   r   r`   ra   rc   r   r   r   r   r   rf   z1'No object named a_nonexistent_store in the file'r|   a_nonexistent_storeNzb/foor   )r   r"   r#   rd   r   r   r$   r   r%   r'   remover(   r   r   r   r   KeyError)r\   r   tsr,   rN   s   &    r-   test_removerO    s   E	
		"BJJ'z,PR/S
B 
biin$$W--d6l#uRy1y!r!Xy12
B
 #J#J	LLu:??"Cj)	LLu:?? 
K
 
 	*+
 #J'N	LLu:??#J'N	LLu:?? #J#Jc
c
u:??C 2
 
s   G=GG$	c           	         \        \        P                  P                  ^4      P	                  R4      \        R^RR7      R7      pV P                  RVRR7       WP                  \        R4      8  ,          pV P                  RR	4      p\        P                  ! W24       V P                  RR	4      p\        P                  ! W24       V P                  RR
4      p\        P                  ! W24       R# )r   r   r8  )rb   unitrc   rN   rI   rJ   20130105z!index>datetime.datetime(2013,1,5)zindex>datetime(2013,1,5)N)r   r   )r   r"   r   r   r   r   rM   r   r	   r   r   r   )r\   rN   r   r   s   &   r-   test_same_name_scopingrT  4  s    	
		a 009Rd;
B dBw/((Yz223H!!$(KLF&+ !!$(KLF&+!!$(BCF&+r<   c                 V   \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      pRVP                  n        W R&   V R,          p\        P                  ! W24       R# u upi )r   r   r   r   rh   frameNr   )r   r"   r#   r$   r   r%   r'   r   namer   r   )r\   r,   rN   reconss   &   r-   test_store_index_namerY  J  s    	biin$$W--d6l#uRy1y!r!Xy12
B
 BHHM'7#F&% 2s   B&tzz
US/Pacifictable_formatc                    \        \        P                  ! R ^^4      \        P                  ! R ^^4      .RR7      P                  V4      P	                  V4      p\        \        P                  ! R^^4      \        P                  ! R^^4      .RR7      P	                  V4      P                  V4      p\        \        P                  ! ^4      P                  ^^4      WER7      pVP                  VRV R7       \        VR4      p\        P                  ! WgRR	7       \        VP                  P                  \         4      '       g   Q h\        VP"                  P                  \         4      '       g   Q hR
# )i  u   colsג)rW  i  u   rowsאr   rN   r   T)check_namesN)r   r   r-  tz_localizer:  r   r"   r#   r$   r   r   r   r   
isinstancer   rW  r   r   )r[  r*   rQ  rZ  r4  idx1rN   r   s   &&&&    r-   test_store_index_name_numpy_strra  W  s   
 	WWT1a "''$1"56	
 
R	  	WWT1a "''$1"56	
 
	R 	 
299Q<''1-s	GB IIl\I:
<
&C"t4ciinnc****ckk&&,,,,r<   c                 F   \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      pVR,          pW0R&   V R,          p\        P                  ! WC4       R# u upi )r   r   r   r   rl   seriesNr   )	r   r"   r#   r$   r   r%   r'   r   r   )r\   r,   rN   rc  rX  s   &    r-   test_store_series_namerd  w  s    	biin$$W--d6l#uRy1y!r!Xy12
B
 WF$(8$F6* 2s   Bc           
      x   \        \        P                  P                  ^4      P	                  R4      \        \        R4      4      \        R^
RR7      R7      V R&   \        \        P                  ! ^
\        P                  R7      \        R^
R	7      R
7      pWR&   \        P                  ! V R,          V4       R# )r   r   r   rn   r   r   r   r   r`   ra   rc   Nr   )r   r"   r   r   r   r   r%   r   r   r#   rd   r   r   )r\   rN  s   & r-   test_overwrite_noderf    s    "
		a 009d6l#r<M#
 

		"BJJ'z,PR/S
B #=-r2r<   c           
         \        \        P                  P                  ^4      P	                  R4      \        \        R4      4      \        R^
RR7      R7      pT pVP                  RV4       VP                  R4      pVP                  \        P                  ! \        VP                  4      4      8H  P                  4       '       g   Q hR# )	r   r   r   rn   r   r   rN   Nr   )r   r"   r   r   r   r   r%   r   r   select_as_coordinatesvaluesr#   r(   r   all)r\   rN   r   rg   s   &   r-   test_coordinatesrk    s    	
		a 009d6l#r<
B E	LLr 	##D)AHH		#bhh-00557777r<   c                    T p\        R \        ^4      R\        ^4      /4      pVP                  RV4       VP                  RR.4      pVP                  \
        P                  ! ^4      8H  P                  4       '       g   Q hVP                  RVR7      pVP                  R,          p\        P                  ! WE4       VP                  RRR.4      pVP                  \
        P                  ! ^4      ^,           8H  P                  4       '       g   Q hVP                  RVR7      pVP                  R	,          p\        P                  ! WE4       \        V\        4      '       g   Q hR# )
rl   rn   rN   zindex<3r   zindex>=3zindex<=4N):r   r   Nr1  ):rz   r    Nr1  )r   r'   r   rh  ri  r"   r#   rj  r   r   r   r   r_  r   )r\   r   rN   rg   r   r   s   &     r-   test_coordinates2rm    s   E	Cq3a1	2B	LLr##D9+6AHH		!$))++++\\$a\(Fvvf~H&+##D:z*BCAHH		!q((--////\\$a\(Fvvf~H&+ar<   c           
         T p\        \        P                  P                  ^4      P	                  R4      \        \        R4      4      \        R^
RR7      R7      pVP                  4       P                  RP                  R7      pVP                  RVR	R.R
7       VP                  RV4       VP                  RRR.4      pVP                  RV4      pVP                  RV4      p\        WV.^R7      p\        W#.^R7      pWP                  ^ 8  VP                   ^ 8  ,          ,          p\"        P$                  ! WxRR7       R# )r   r   r   rn   r   r   z{}_2r*  r   rl   r   r   zA>0zB>0)axisF)
check_freqNr   )r   r"   r   r   r   r   r%   r   r  renamerJ   r   rh  r   r
   rl   rn   r   r   )	r\   r   r   r   rg   
df1_result
df2_resultr   r   s	   &        r-    test_coordinates_multiple_tablesrt    s	   E

		a 009d6l#r<C
 ((*

FMM

2C	LL3*L5	LL##EE5>:AeQ'JeQ'JZ,15Fsjq)HaHJJN;<H&u=r<   c           
      V   T p\        \        P                  P                  ^4      P	                  R4      \        RRR7      R7      pVP                  RV4       VP                  RR4      pV\        V4      P                  ^8H  ,          P                  pVP                  V,          pVP                  RVR7      p\        P                  ! We4       VP                  RVR7      p\        P                  ! We4       Rp\        P                   ! \"        VR	7      ;_uu_ 4        VP                  R\        P$                  ! \'        V4      R
R7      R7       RRR4       \        P                   ! \"        VR	7      ;_uu_ 4        VP                  R\        P$                  ! \'        V4      ^,           4      R7       RRR4       \        P                   ! \"        VR	7      ;_uu_ 4        VP                  R\        P$                  ! \'        V4      4      ^R7       RRR4       \        P                   ! \"        VR	7      ;_uu_ 4        VP                  R\        P$                  ! \'        V4      4      ^^
R7       RRR4       \        RRR7      pVP                  RRR7      pW"P                  P)                  V4      ,          p\        P                  ! We4       \        \        P                  P                  ^4      P	                  R4      4      pVP                  RV4       VP                  R. ROR7      pVP                  . RO,          p\        P                  ! We4       R.^
,          pRVR&   VP                  RVR7      pVP*                  V,          p\        P                  ! We4       VP                  R^^
R7      pVR,          p\        P                  ! We4       R#   + '       g   i     EL; i  + '       g   i     ELB; i  + '       g   i     EL; i  + '       g   i     EL; i)r     20000101ra   rc   rN   r   r   zLwhere must be passed as a string, PyTablesExpr, or list-like of PyTablesExprr|   rd   r   N)r   start)r   rx  stopi  zindex in selectionr   TFrx  ry  r   r_   N)rv  r   r_   r   )r   rz   r   )r   r"   r   r   r   r   r   select_columnr   monthr   r3  r   r   r   r   r   r#  r#   r(   isinr   )	r\   r   rN   rg   r   r   r   r   	selections	   &        r-   test_coordinates_array_maskr    s   E	
		a 00;T2
B 
LLrD'*AmA$$)*00Ewwu~H \\$e\,F&+ \\$e\,F&+ YC	y	,	,T3r7)!DE 
- 
y	,	,T3r7Q;!78 
- 
y	,	,T3r7!31= 
- 
y	,	,T3r7!312F 
- :s3I\\$&:\;F((--	*+H&+ 
299((+;;GD	EB	LL\\%y\1Fwwy!H&+ FRKEE"I\\%u\-Fvve}H&+ \\%qr\2F$xH&+G 
-	,	, 
-	,	, 
-	,	, 
-	,	,s0   3O>8O/"2P 3PO,	/P 	P	P(	c                     \        R \        P                  P                  ^4      P                  ^4      R\        P                  P                  ^4      P                  ^4      /4      pV P	                  RV4       V P                  RR^ ^R7      pVP                  RR .3,          p\        P                  ! W#4       V P                  RR^^(R7      p\        V4      ^ 8X  g   Q hVP                  RR .3,          p\        P                  ! W#4       R# )rl   rn   rN   zcolumns=['A']rz  :r   r    Nr   (   NN)
r   r"   r   r   r   r   r   r   r   r(   r\   rN   r   r   s   &   r-   test_start_stop_tabler    s    	&&q)004&&q)004	

B r"!!$qq!IFvvcC5j!H&+ !!$r!KFv;!vvecUl#H&+r<   c                     \        R ^^.R^^./4      pV P                  RR .RR/VRR7       V P                  RR.R^ ^R7      pVP                  ^ .R R.3,          p\        P
                  ! W#4       R# )rh   rj   selectorr  N)r  )r  rx  ry  )r   append_to_multipleselect_as_multipler   r   r   r  s   &   r-   test_start_stop_multipler    s    	EAq651a&1	2B$$	eWfd+R* %  --	Vz . F vvqcE5>)*H&+r<   c                    T p\        R \        P                  P                  ^4      P                  ^4      R\        P                  P                  ^4      P                  ^4      /\	        R^R7      R7      pVP                  RV4       VP                  R^ ^R7      pVP                  R,          p\        P                  ! W44       VP                  R^^
R7      pVP                  R,          p\        P                  ! W44       VP                  R^^(R7      pVP                  R,          p\        P                  ! W44       VP                  pVP                  R	V4       VP                  R	^ ^R7      pVP                  R,          p\        P                  ! W44       VP                  R	^^
R7      pVP                  R,          p\        P                  ! W44       \        R
\        P                  ! ^x4      P                  R4      ,          \        \        R4      4      \        \!        ^4       Uu. uF  pRV 2NK
  	  up4      R7      p\        P"                  VP                  R&   \        P"                  VP                  R&   R# u upi )rl   rn   r   ra   rc   rN   rz  r   r   Nr{  r   r   r   r   r   N)r  r1  )r{  r1  )r  r1  r   ):rz   r   N:r   rz   N):r   r_   Nr}  )r   r"   r   r   r   rM   r   r3  r   r   rl   r   r#   r$   r   r%   r'   r   )r\   r   rN   r   r   r   r,   s   &      r-   test_start_stop_fixedr  *  s   E	&&q)004&&q)004	
 R0
B 
IIdB\\$aa\0FwwvH&+\\$ab\1FwwwH&+ \\$br\2Fwwx H&+ 	A	IIc1\\#QQ\/Fvvc{H6,\\#QR\0Fvvd|H6, 
biin$$W--d6l#uRy1y!r!Xy12
B
 BGGHBGGH 2s   -Jc                    \        \        P                  P                  ^4      P	                  R4      4      pVP
                   Uu. uF  q3R NK  	  upVn        VP                   Uu. uF  q3R NK  	  upVn        V P                  RVRR7       VP                  \        P                  P                  \        R\        R7      4       RpV P                  RV.4      p\        P                   ! WRP"                  RVP                  R	,          3,          4       R
pV P                  RV.4      p\        P                   ! WRP"                  RVP                  R,          3,          4       R# u upi u upi )r   3drV  rI   rR  zAST change in PY312)reasonr   zcolumns=df.columns[:75]r1  :NK   Nzcolumns=df.columns[:75:2]:Nr  r   N)2   d   )r   r"   r   r   r   r   r   rM   applymarkerr   markxfailr   r!   r   r   r   r   )r\   requestrN   rg   critr   s   &&    r-   test_select_filter_cornerr  X  s*   	299((+;;IF	GB#%88,8aR&	8,BH%'ZZ0ZrF)Z0BJgr'2( 	 	
 %D!!'D62F&&&BJJsO);"<=&D!!'D62F&&&BJJu,=)=">?% -0s   E)(E.c                 X  a \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      o\        P                  ! V3R lR V 4      p\        P                  ! SV4       R# u upi )r   r   r   r   c                 *   < SP                  V R R7      # rN   r   r   prN   s   &r-   r:   #test_path_pathlib.<locals>.<lambda>w      "))A4)(r<   c                     \        V R 4      # rN   r   r  s   &r-   r:   r  w      HQ4Er<   Nr   
r   r"   r#   r$   r   r%   r'   r   round_trip_pathlibr   r*   r,   r   rN   s   &  @r-   test_path_pathlibr  o  s    	biin$$W--d6l#uRy1y!r!Xy12
B ""(*E|F "f% 2   B'zstart, stopc           	          \        R \        . RO4      R\        . RO4      /4      pVP                  RV4       VP                  RWR7      p\        P
                  ! W0V V4       R# )r   rf   test_datasetrz  N)i2i2i2)abcdr  )r   r   r   r   r   r   )rx  ry  r\   rN   r   s   &&&  r-    test_contiguous_mixed_data_tabler  |  sd     
67*+	

B ,!!.!IF"4.&1r<   c                 ^  a \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      oV3R lpR p\        P                  ! W#V 4      p\        P                  ! SV4       R# u upi )r   r   r   r   c                    < \        V 4      ;_uu_ 4       pSP                  VR R7       RRR4       R#   + '       g   i     R# ; i)rN   r  N)r   r   )r   r   rN   s   & r-   writer*test_path_pathlib_hdfstore.<locals>.writer  s*    d^^uIIeI& ^^^s	   3A	c                 ~    \        V 4      ;_uu_ 4       p\        VR 4      uuRRR4       #   + '       g   i     R# ; i)rN   Nr   )r   r   s   & r-   reader*test_path_pathlib_hdfstore.<locals>.reader  s#    d^^uE4( ^^^s   +<	Nr   r  )r*   r,   r  r  r   rN   s   &    @r-   test_path_pathlib_hdfstorer    s    	biin$$W--d6l#uRy1y!r!Xy12
B') ""6<@F"f% 2s   B*c                 X  a \        R \        P                  ! ^x4      P                  R4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      o\        P                  ! V3R lR V 4      p\        P                  ! SV4       R# u upi )r   r   r   r   c                 *   < SP                  V R R7      # r  r  r  s   &r-   r:   ,test_pickle_path_localpath.<locals>.<lambda>  r  r<   c                     \        V R 4      # r  r  r  s   &r-   r:   r    r  r<   Nr   r  r  s   &  @r-   test_pickle_path_localpathr    s    	biin$$W--d6l#uRy1y!r!Xy12
B
 ""(*E|F "f% 2r  propindexesTFc                    \        R \        P                  ! ^x4      P                  R	4      ,          \	        \        R4      4      \	        \        ^4       Uu. uF  pRV 2NK
  	  up4      R7      p\        V4      ;_uu_ 4       pVP                  RVR.R7       RRR4       \        P                  ! 4       ;_uu_ 4       p\        V4      ;_uu_ 4       p\        P                  ! VP                  VP                  RV R7      4      ;_uu_ 4       pVP                  4       p\!        V4      \!        VP                  4       4      8X  g   Q hVP                  4        F  p	VP#                  V	4      P$                  '       g   K&  VP#                  V	4      p
VP#                  V	4      pVP&                  V
P&                  8X  g   Q hV '       g   Ko  VP(                   F;  pVP*                  '       g   K  WP                  ,          P*                  '       d   K;  Q h	  K  	  RRR4       RRR4       RRR4       R# u upi   + '       g   i     EL; i  + '       g   i     L;; i  + '       g   i     LF; i  + '       g   i     R# ; i)
r   r   r   r   rN   rl   r   N)keysr  r   )r   r"   r#   r$   r   r%   r'   r   r   tempfileNamedTemporaryFile
contextlibclosingr  rW  r  r   r   is_tablenrowsaxesr"  )r  	temp_filer,   rN   stnew_fr   tstorer  knew_torig_tr   s   &&           r-   	test_copyr    s   	biin$$W--d6l#uRy1y!r!Xy12
B 
)		
		$#	/ 
		$	$	&	&%i  E##

5::Dk
J zz|4yC$6666A((+444 & 1 1! 4!&!1!1!!4%||u{{::: ';%+[[#$<<<+0=+C+C+C$C+C &1 ' ! 
'	& 2 
		  !  
'	&	&sh   H/H4>I.;I	A+I=AII)III	I.4I	II	I+&I..I?	c                    \        R R .^ ^ ..R7      pRp\        P                  ! \        VR7      ;_uu_ 4        VP	                  V RRR7       RRR4       VP	                  V RRR7       \        V R4      p\        P                  ! W4       VP                  V4      '       g   Q hVP                  V4      '       g   Q hR#   + '       g   i     Lz; i)	r   )r   r  z/Columns index has to be unique for fixed formatr|   rN   r  r   NrI   )	r   r   r   r!   r   r   r   r   equals)r*   rN   r   others   &   r-   test_duplicate_column_namer    s    	C:aVH	5B
;C	z	-	-
		,D	9 
. IIlWI5\4(E"$99U<< 
.	-s   C  C	c                     \        \        P                  P                  ^4      P	                  RR7      4      p\        R^
RRVR7      Vn        W R&   \        P                  ! V R,          V4       R# )	r   )size0s1sexample)rx  rb   r   rW  rQ  rN   N)r_   r   )	r   r"   r   r   normalr   r   r   r   )r\   rQ  rN   s   && r-   !test_preserve_timedeltaindex_typer    s_    	299((+222@	ABBT	BH $--r2r<   c           	         \        \        P                  P                  ^4      P                  R4      \	        R4      \	        R4      R7      pRVP
                  n        VP                  RRR7      pVP
                  P                  VP                  P                  4       ,           pVP                  V RR	RVR
R7       \	        R4      p\	        V4      p\        V RVR7       WC8X  g   Q hR# )r   abcdABCDE)r   r   lettersET)r  r   rN   r   F)r   rH   r   rK   r   BCDr*  N)r    r   )r   r"   r   r   r%   r   rW  r  r0  r   tolistr   r   )r*   rN   rK   	cols2loadcols2load_originals   &    r-    test_columns_multiindex_modifiedr    s     

		a ''/6lW
B
 BHHM	3t	,B88>>BJJ$5$5$77LII!   UIi\43***r<   z3ignore:PeriodDtype\[B\] is deprecated:FutureWarningr   r   r   r   r`   ra   z1 dayr   r   c           	      (   \        \        P                  P                  ^4      P	                  R	4      VR7      pRp\
        P                  ! \        VR7      ;_uu_ 4        VP                  V RRRR7       RRR4       R#   + '       g   i     R# ; i)
r   r*  z-cannot have non-object label DataIndexableColr|   rN   rI   Tr   rJ   rK   Nr|  )	r   r"   r   r   r   r   r   r!   r   )r*   r   rN   r   s   &&  r-   0test_to_hdf_with_object_column_names_should_failr    sc     
299((+;;GDg	VB
9C	z	-	-
		,Dt	L 
.	-	-	-s    B  B	r   categoryc                 (   \        \        P                  P                  ^4      P	                  R4      \        RR.VR7      R7      pVP                  V RRRR7       \        V RR	VP                  ^ ,           R
2R7      p\        V4      '       g   Q hR# )r   r   rf   r   r*  rN   rI   Tr  z	index = []r   Nr|  )
r   r"   r   r   r   r   r   r   r   r(   )r*   r   rN   r   s   &&  r-   /test_to_hdf_with_object_column_names_should_runr    s|     

		a 009sCj.
B IIlW4IHlD)BHHQK=0JKFv;;;r<   c                     \        R . ROR. RO/4      pV P                  RV4       VR ,          P                  P                  V R,          R ,          P                  P                  8X  g   Q hR# )r   rf   rN   N)r   r   rz   r    )r   r{   r   r   )r   rM   ri  strides)r\   rN   s   & r-   test_hdfstore_stridesr     sW    	CsL9	:BdBc7>>!!]4%8%=%D%D%L%LLLLr<   c           	          \        ^..R.\        R.RR7      R7      pVP                  4       pVP                  V RR7       \	        V R4      p\
        P                  ! W#4       R# )	r   TFboolr   r   r   r  N)r   r   r  r   r   r   r   )r*   rN   r   r   s   &   r-   test_store_bool_indexr  '  sV    	QC54&ugV0L	MBwwyH IIlI$lC(F(+r<   modelc                    \        . ROR7      p\        R. R	OR. R
O/4      P                  RVR\        /4      pV P	                  RVR.R7       V P                  RR4      pW3R,          V8H  ,          p\        P                  ! WE4       R# )rW  )
categoriesmodelIdvaluerN   r   zmodelId == modelNrW  longnameverylongname)rW  r  r  r   )r   r   astypeintr   r   r   r   )r\   r  modelsrN   r   r   s   &&    r-   &test_select_categorical_string_columnsr   3  s     )MNF		4gyI
fi#./  r<!!$(:;FY-5()H&+r<   c                     \         P                  ! RR.RR.R7      p\        R^^./VR7      pVP                  V RR7       \	        V RR7      p\
        P                  ! W#RR	7       R
# )r   level1level2r/  r  rc   testr  F)check_dtypeN)r   r   )rf   y)r   from_tuplesr   r   r   r   r   )r*   r   rN   r   s   &   r-   )test_to_hdf_multiindex_string_dtype_crashr  C  s_    ""J
#;HhCWXE	GaV$E	2BIIlI'l/F"%8r<   ))r   r   )r   r   )NNr  )Vr  r   r   rR   r  rT   numpyr"   r   pandas.compatr   pandasr  r   r   r   r   r   r	   r
   r   r   r   pandas._testing_testingr   pandas.api.typesr   pandas.io.pytablesr   r   r  
single_cpu
pytestmarkimportorskipr   r.   rZ   r]   r   r   r   r   parametrizer   r   r   r   r  r  r&  r+  r6  r;  rI  rO  rT  rY  ra  rd  rf  rk  rm  rt  r  r  r  r  r  r  r  r  r  r  r  r  r  filterwarningsint64rd   r  r  r  r  r   r   r<   r-   <module>r     sp              
 kk$$%
			X	&+ '4T%
+\BD  m^4ce< 7=/E4=!A+ceeW-=		
 =/E4=!A+ceeW-=	
*%8+*%8P B80W, GW#56- 7-$'@;D,A2&4)X,,
& l34'7);<- = 5-<
+38 (>.8,v,*,+\@.
& (FG2 H2&&	& u6D 7D@3+6 RSq!fBHH%sCj

+<++\137	M	 TM 4"45 6M	, "FG, H,9r<   