ó
šxŠ\c           @   sG  d  d l  m Z d  d l Z d  d l m Z d  d l m Z d  d l Z d  d l Z d  d l m	 Z	 m
 Z
 d  d l Z d  d l Z d  d l m Z m Z m Z m Z m Z m Z m Z m Z m Z d  d l j j Z d  d l m Z d  d l Z d  d l m  Z  m! Z! m" Z" m# Z# m$ Z$ m% Z% m& Z& m' Z' m( Z( m) Z) m* Z* m+ Z+ m, Z, m- Z- m. Z. m/ Z/ d  d l0 j j1 Z2 d  d	 l0 m3 Z3 m4 Z4 m5 Z5 m6 Z6 d  d
 l7 m8 Z8 d  d l9 m: Z: d  d l; m< Z< m= Z= m> Z> m? Z? m@ Z@ d  d l; mA ZA e jB d ƒ ZC e jD jE e e jF ƒ e d ƒ k d d ƒZG e eC jF ƒ e d ƒ k rCd n d ZH e jD jI d ƒ ZJ d „  ZK d „  ZL d „  ZM e d eN eN eO d „ ƒ ZP e d „  ƒ ZQ d eC jR _S d eC jR _T d eC jR _U d „  ZV d eW f d „  ƒ  YZX e jD jY e jD jI d  ƒ d! eX f d" „  ƒ  Yƒ ƒ ZZ d# eX f d$ „  ƒ  YZ[ d% eX f d& „  ƒ  YZ\ d S('   iÿÿÿÿ(   t   contextmanagerN(   t	   timedelta(   t   LooseVersion(   t   catch_warningst   simplefilter(	   t   PY35t   PY36t   BytesIOt   is_platform_little_endiant   is_platform_windowst   lranget   ranget	   text_typet   u(   t   is_categorical_dtype(   t   Categoricalt	   DataFramet   DatetimeIndext   Indext
   Int64Indext
   MultiIndext   Panelt
   RangeIndext   Seriest	   Timestampt   bdate_ranget   compatt   concatt
   date_ranget   isnat   timedelta_range(   t   assert_frame_equalt   assert_panel_equalt   assert_series_equalt   set_timezone(   t   pytables(   t   pprint_thing(   t   ClosedFileErrort   HDFStoret   PossibleDataLossErrort   Termt   read_hdf(   t   TableIteratort   tabless   1.16t   reasonsP   gh-25511, gh-24839. pytables needs a release beyong 3.4.4 to support numpy 1.16xs   2.2t   blosct   zlibs7   ignore:object name:tables.exceptions.NaturalNameWarningc         C   s8   |  d  k	 r4 y t j |  ƒ Wq4 t k
 r0 q4 Xn  d  S(   N(   t   Nonet   ost   removet   OSError(   t   path(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   safe_remove9   s
    c         C   s5   y |  d  k	 r |  j ƒ  n  Wn t k
 r0 n Xd  S(   N(   R/   t   closet   IOError(   t   store(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt
   safe_closeA   s
    c         C   s   t  j j t j ƒ  |  ƒ S(   s)    create an unopened named temporary file (   R0   R3   t   joint   tempfilet
   gettempdir(   R3   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   create_tempfileI   s    t   ac      
   c   s‹   zT t  t j j |  ƒ ƒ s* t |  ƒ }  n  t |  d | d | d | d t ƒ} | VWd  t | ƒ | d k sy | d k r† t |  ƒ n  Xd  S(   Nt   modet	   complevelt   complibt
   fletcher32t   wR=   (	   t   lenR0   R3   t   dirnameR<   R&   t   FalseR8   R4   (   R3   R>   R?   R@   RA   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   ensure_clean_storeN   s    	
c         c   su   zR t  |  t ƒ r9 g  |  D] } t | ƒ ^ q } | Vn t |  ƒ g } | d VWd x | D] } t | ƒ q\ WXd S(   s£   
    return essentially a named temporary file that is not opened
    and deleted on existing; if path is a list, then create and
    return list of filenames
    i    N(   t
   isinstancet   listR<   R4   (   R3   t   pt	   filenamest   f(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   ensure_clean_patha   s    i   c         C   s/   y |  j  | ƒ Wn t t f k
 r* n Xd S(   s€   For tests using tables, try removing the table to be sure there is
    no content from previous tests using the same table name.N(   R1   t
   ValueErrort   KeyError(   R7   t   key(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   _maybe_removez   s    t   Basec           B   s8   e  Z e d  „  ƒ Z e d „  ƒ Z d „  Z d „  Z RS(   c         C   s   t  j ƒ  d  S(   N(   t   tmt   reset_testing_mode(   t   cls(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   setup_class…   s    c         C   s   t  j ƒ  d  S(   N(   RR   t   set_testing_mode(   RT   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   teardown_class‹   s    c         C   s   d t  j d ƒ |  _ d  S(   Ns   tmp.__%s__.h5i
   (   RR   t   randsR3   (   t   selft   method(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   setup_method‘   s    c         C   s   d  S(   N(    (   RY   RZ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   teardown_method”   s    (   t   __name__t
   __module__t   classmethodRU   RW   R[   R\   (    (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRQ   ƒ   s   	s   ignore:\nPanel:FutureWarningt   TestHDFStorec           B   s	  e  Z d  „  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z	 d „  Z
 d	 „  Z e d
 „  ƒ Z d „  Z d „  Z d „  Z d „  Z d „  Z d „  Z e j j d d i d d h e ƒ  f d 6e ƒ  d d h f d 6d h d d h f d 6e ƒ  d h f d 6f d i d h d d h f d 6e ƒ  d h f d 6f g ƒ d „  ƒ Z d  „  Z d! „  Z d" „  Z d# „  Z e j d$ „  ƒ Z d% „  Z  d& „  Z! d' „  Z" e# d( „  ƒ Z$ e j j% d) ƒ d* „  ƒ Z& d+ „  Z' d, „  Z( e j j) e* ƒ  d- d. ƒd/ „  ƒ Z+ d0 „  Z, d1 „  Z- d2 „  Z. d3 „  Z/ d4 „  Z0 d5 „  Z1 d6 „  Z2 d7 „  Z3 e j j d8 e j4 d9 d: e# ƒd; g ƒ d< „  ƒ Z5 d= „  Z6 d> „  Z7 d? „  Z8 d@ „  Z9 dA „  Z: dB „  Z; dC „  Z< dD „  Z= dE „  Z> e# dF „  ƒ Z? dG „  Z@ dH „  ZA dI „  ZB dJ „  ZC dK „  ZD e# e j j) eE eF jG ƒ eE dL ƒ k d- dM ƒdN „  ƒ ƒ ZH dO „  ZI dP „  ZJ dQ „  ZK dR „  ZL dS „  ZM dT „  ZN dU „  ZO dV „  ZP dW „  ZQ dX „  ZR dY „  ZS dZ „  ZT d[ „  ZU d\ „  ZV e# d] „  ƒ ZW e# e j j% d^ ƒ d_ „  ƒ ƒ ZX d` „  ZY e# e j j da eZ e j4 e[ d: e j ƒg ƒ db „  ƒ ƒ Z\ e# dc „  ƒ Z] e# e j j dd eF j^ eF j_ eF j` de df g ƒ dg „  ƒ ƒ Za dh „  Zb di „  Zc dj „  Zd dk „  Ze e j j dl d; d9 g ƒ dm „  ƒ Zf dn „  Zg e# e j j da eZ e j4 e[ d: e j ƒg ƒ do „  ƒ ƒ Zh dp „  Zi e j j% dq ƒ dr „  ƒ Zj e j j% dq ƒ ds „  ƒ Zk dt „  Zl du „  Zm dv „  Zn dw „  Zo dx „  Zp dy „  Zq dz „  Zr d{ „  Zs d| „  Zt d} „  Zu e j j% d~ ƒ d „  ƒ Zv e j j% d~ ƒ d€ „  ƒ Zw d „  Zx d‚ „  Zy dƒ „  Zz d„ „  Z{ d… „  Z| d† „  Z} d‡ „  Z~ dˆ „  Z d‰ „  Z€ dŠ „  Z e j j‚ d‹ eZ d- dŒ ƒ d „  ƒ Zƒ dŽ „  Z„ e j j) eE e… jG ƒ eE d ƒ k  d- d ƒd‘ „  ƒ Z† d’ „  Z‡ d“ „  Zˆ d” „  Z‰ d• „  ZŠ d– „  Z‹ e j j d— dÌ dÍ dÏ g ƒ d› „  ƒ Z dœ „  ZŽ d „  Z dž „  Z eZ dŸ „ Z‘ eZ d  „ Z’ eZ d¡ „ Z“ d¢ „  Z” d£ „  Z• e j j) e– oZe— ƒ  d- d¤ ƒd¥ „  ƒ Z˜ e# d¦ „  ƒ Z™ d§ „  Zš d¨ „  Z› d© „  Zœ dª „  Z d« „  Zž d¬ „  ZŸ d­ „  Z  d® „  Z¡ e# d¯ „  ƒ Z¢ d° „  Z£ d± „  Z¤ d² „  Z¥ d³ „  Z¦ d´ „  Z§ dµ „  Z¨ d¶ „  Z© d· „  Zª d¸ „  Z« e d¹ „  ƒ Z¬ dº „  Z­ d» „  Z® d¼ „  Z¯ d½ „  Z° d¾ „  Z± d¿ „  Z² dÀ „  Z³ dÁ „  Z´ e jµ dÂ ƒ dÃ „  ƒ Z¶ e jµ dÄ ƒ dÅ „  ƒ Z· dÆ „  Z¸ dÇ „  Z¹ e j j d8 d9 d; g ƒ dÈ „  ƒ Zº e j j) e» d- dÉ ƒdÊ „  ƒ Z¼ dË „  Z½ RS(Ð   c      
   C   s5   t  |  j ƒ   } t j t t | d d ƒWd  QXd  S(   Nt   formatt   table(   RL   R3   t   pytestt   raisesRM   R&   (   RY   R3   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt    test_format_kwarg_in_constructorœ   s    c         C   sÞ   t  |  j ƒ } z= y% t | ƒ  } t d ƒ ‚ Wd  QXWn t k
 rJ n XWd  t | ƒ Xzr t | ƒ  } t j ƒ  | d <Wd  QXt | ƒ ; } t | ƒ d k s© t ‚ t	 | d ƒ t
 k sÅ t ‚ Wd  QXWd  t | ƒ Xd  S(   Nt   blahR=   i   (   R<   R3   R&   RM   R4   RR   t   makeDataFrameRC   t   AssertionErrort   typeR   (   RY   R3   t   tbl(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_context¡   s     &c      	      sA  t  |  j ƒ ‰  z ‡  f d †  } t j ƒ  } t | | d | ƒ ƒ t j ƒ  } t | | d | ƒ ƒ t j ƒ  } t | | d | ƒ ƒ t d t	 ƒ ' t j
 ƒ  } t | | d | ƒ ƒ Wd  QXt t d t d ƒ d	 t d ƒ ƒ ƒ } | j ˆ  d
 d t	 ƒt ˆ  d
 d d g ƒ} t | | j d k | ƒ Wd  t ˆ  ƒ Xd  S(   Nc            s    | j  ˆ  |  |  t ˆ  |  ƒ S(   N(   t   to_hdfR)   (   RO   t   objt   kwargs(   R3   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   roundtrip¸   s    t   seriest   string_seriest   framet   recordt   panelt   Ai   t   BRb   t   appendt   wheres   index>2i   (   R<   R3   RR   t   makeTimeSeriesR!   t   makeStringSeriesRg   R   R   t   Truet	   makePanelR    R   t   dictR
   Rl   R)   t   indexR4   (   RY   Ro   t   ot   dft   result(    (   R3   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_conv_read_writeµ   s"    'c      	   C   sˆ   t  i t j d d d ƒd 6d t j d d d ƒƒ} t |  j ƒ < } | j d | d d g ƒ| j d ƒ } t | | ƒ Wd  QXd  S(   Nid   t   sizei
   R=   R~   R€   t   data_columns(   R   RR   t   rands_arrayRF   R3   Rw   t   selectR   (   RY   R€   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_long_stringsÓ   s    c         C   s2  t  |  j ƒ Ë } t j ƒ  } | j d  j | d d t d d ƒ| j d j | d d t d d ƒt t | d ƒ | ƒ | j d  j | d d t	 d d ƒ| j d j | d d t d d ƒt t | d ƒ | ƒ Wd  QXt  |  j ƒ ¿ } t j ƒ  } | j d  j | d d t ƒ| j d j | d d t d d ƒt t | d ƒ | ƒ | j d  j | d d t	 d d ƒ| j d j | d d t ƒt t | d ƒ | ƒ Wd  QXt  |  j ƒ É } t j ƒ  } | j | d d t	 d d ƒt t | d ƒ | ƒ | j | d d t	 d d ƒt t | d ƒ | ƒ | j | d d t	 ƒt t | d ƒ | ƒ | j | d ƒ t t | d ƒ | ƒ Wd  QXt
 |  j ƒ À} | j } t j ƒ  } t | d ƒ | j d | j d  d t d d ƒ| j d | j d d t d d ƒt | j d ƒ | ƒ t | d ƒ | j d | j d  d t	 d d ƒ| j d | j d d t d d ƒt | j d ƒ | ƒ t | d ƒ | j d | j d  d t	 d d ƒ| j d | j d d t d d ƒt | j d ƒ | ƒ t | d ƒ | j d | j d  d t	 d d ƒ| j d | j d d t d d  ƒt | j d ƒ | ƒ Wd  QXt  |  j ƒ § } t j ƒ  } t j t | j | d d t d d ƒt j t | j | d d t d d ƒt j t | j | d d t d d ƒt j t | j | d d t	 d d	 ƒWd  QXd
 } t j t j t | d ƒ d  S(   Ni
   R€   Rw   Ra   Rb   t   fixedRK   t   foot   bart    (   RL   R3   RR   Rg   t   ilocRl   R{   R   R)   RE   RF   t   _pathRP   Rw   R†   R/   Rc   Rd   RM   t	   TypeErrorR   t   FileNotFoundError(   RY   R3   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_apiß   st    ######	########c         C   sB  t  |  j ƒ ü } t j ƒ  } t j d d ƒ t | d ƒ | j d | ƒ | j d ƒ j	 sd t
 ‚ t j t | j d | ƒ t j d d ƒ t | d ƒ | j d | ƒ | j d ƒ j	 sÂ t
 ‚ t | d ƒ | j d | ƒ | j d ƒ j	 s÷ t
 ‚ t j d d  ƒ Wd  QXt |  j ƒ  } t j ƒ  } t j d d ƒ | j | d ƒ t | ƒ   } | j d ƒ j	 sst
 ‚ Wd  QXt j t | j | d d t ƒt j d d ƒ | j | d ƒ t | ƒ  } | j d ƒ j	 sßt
 ‚ Wd  QX| j | d d t ƒt | ƒ  } | j d ƒ j	 s"t
 ‚ Wd  QXt j d d  ƒ Wd  QXd  S(	   Ns   io.hdf.default_formatRˆ   R€   t   df2Rb   Rw   t   df3t   df4(   RF   R3   RR   Rg   t   pdt
   set_optionRP   t   putt
   get_storert   is_tableRh   Rc   Rd   RM   Rw   R/   RL   Rl   R&   R{   (   RY   R7   R€   R3   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_api_default_format8  s<    c         C   så   t  |  j ƒ Ð } t j ƒ  | d <t j ƒ  | d <t j ƒ  | d <t d t ƒ % t j ƒ  | d <t j ƒ  | d <Wd  QXt	 | ƒ d k s t
 ‚ d d	 d
 d d h } t | j ƒ  ƒ | k sÃ t
 ‚ t | ƒ | k sÛ t
 ‚ Wd  QXd  S(   NR=   t   bt   cRs   t   ds   foo/bari   s   /as   /bs   /cs   /ds   /foo/bar(   RF   R3   RR   Ry   Rz   Rg   R   R{   R|   RC   Rh   t   sett   keys(   RY   R7   t   expected(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_keysb  s    c         C   s¥   t  |  j ƒ  } t t d t d ƒ d t d ƒ ƒ ƒ } | j d | ƒ | j ƒ  d g k sd t ‚ | j j	 | j j
 d d ƒ | j ƒ  d g k s› t ‚ Wd  QXd  S(   NRu   i   Rv   R€   s   /dft   symlink(   RF   R3   R   R}   R
   R–   Rž   Rh   t   _handlet   create_soft_linkt   root(   RY   R7   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_keys_ignore_hdf_softlinkp  s    'c         C   s4   t  |  j ƒ  } t | ƒ g  k s* t ‚ Wd  QXd  S(   N(   RF   R3   RH   Rh   (   RY   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_iter_empty  s    c         C   sŠ  t  |  j ƒ } t | ƒ | j ƒ  t j ƒ  | d <t j ƒ  | d <t j ƒ  | d <t d t	 ƒ ; t j
 ƒ  | d <t j
 ƒ  | d <| j d t j
 ƒ  ƒ Wd  QXt j ƒ  } d | d	 <d
 | d <| d d k | d <| d d k | d <t	 | d <d | d <d | d <t d ƒ | d <t d ƒ | d <t j d d d d d ƒ | d <t j d d d d d ƒ | d <t j | j d d … d	 g f <| j ƒ  j d t	 ƒ } t d t	 ƒ " t d  t j j ƒ | | d! <Wd  QX| j j | j j d" ƒ | j t | ƒ k st ‚ | j t | ƒ k st ‚ | j ƒ  Wd  QXt  |  j ƒ F } t j ƒ  } | j d! | ƒ | j d! ƒ } t | ƒ t | ƒ Wd  QXd  S(#   NR=   Rš   R›   Rs   Rœ   s   foo/bart   eR‰   t   obj1RŠ   t   obj2Ru   i    t   bool1Rv   t   bool2t   bool3i   t   int1i   t   int2t   20010102t
   timestamp1t   20010103t
   timestamp2iÑ  t	   datetime1i   t	   datetime2i   t   datetimet   ignoreR€   t   bah(   RF   R3   t   reprt   infoRR   Ry   Rz   Rg   R   R{   R|   Rw   R   Rµ   t   npt   nant   loct   _consolidatet   _convertR   R”   t   errorst   PerformanceWarningR¢   t   create_groupR¤   t   filenameRh   t   strR—   (   RY   R7   R€   t   s(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_repr‡  sJ    







c         C   s  t  |  j ƒ í } t j ƒ  | d <t j ƒ  | d <t j ƒ  | d <d | k sT t ‚ d | k sf t ‚ d | k sx t ‚ d | k sŠ t ‚ d | k sœ t ‚ d | k s® t ‚ d | k sÀ t ‚ t d t ƒ  t j ƒ  | d	 <Wd  QXd	 | k sø t ‚ Wd  QXd  S(
   NR=   Rš   s   foo/barR›   s   /foo/bars   /foo/bRŠ   Rs   s   node())(   RF   R3   RR   Ry   Rg   Rh   R   R{   (   RY   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_contains¹  s    c         C   s  t  |  j ƒ 
} t j ƒ  | d <t j ƒ  | d <t j ƒ  } t | d ƒ | j d | d  ƒ | j d | d ƒ | j j	 j
 j d k s‘ t ‚ | j j j
 j d k s¯ t ‚ | j j j
 j d k sÍ t ‚ t | d ƒ | j d | ƒ d  | j d ƒ j
 _ t j t | j d ƒ Wd  QXd  S(   NR=   Rš   t   df1i
   s   0.15.2R‘   (   RF   R3   RR   Ry   Rg   t   makeTimeDataFrameRP   Rw   R¤   R=   t   _v_attrst   pandas_versionRh   Rš   RÇ   R/   t   get_nodeRc   Rd   t	   ExceptionR†   (   RY   R7   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_versioningÍ  s    c            sc   t  j ƒ  ‰  ‡  ‡ f d †  } ‡  ‡ f d †  } | d ƒ | d ƒ | d ƒ | d ƒ | ƒ  d  S(   Nc            s³  t  ˆ j ƒ c ‰ ˆ  d k r: t j t t ˆ d ˆ  ƒn4 t ˆ d ˆ  ƒ} | j j ˆ  k sd t ‚ | j	 ƒ  Wd  QXt  ˆ j ƒ k ‰ ˆ  d k r· ‡  ‡ f d †  } t j t | ƒ n3 t ˆ d ˆ  ƒ } | j j ˆ  k sä t ‚ Wd  QXWd  QXt  ˆ j ƒ ® ‰ ˆ  d	 k rFt j t ˆ j
 ˆ d d ˆ  ƒˆ j
 ˆ d d d ƒn ˆ j
 ˆ d d ˆ  ƒˆ  d
 k r‡t j t t ˆ d d ˆ  ƒn" t ˆ d d ˆ  ƒ} t | ˆ ƒ Wd  QXd  S(   Nt   rs   r+R>   c             s   t  ˆ d ˆ  ƒ }  Wd  QXd  S(   NR>   (   R&   (   R7   (   R>   R3   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRK   ø  s    R€   RB   (   RÎ   s   r+(   RÎ   s   r+(   RÎ   s   r+(   RB   (   RL   R3   Rc   Rd   R6   R&   R¢   R>   Rh   R5   Rl   RM   R)   R   (   R>   R7   RK   R   (   R€   RY   (   R>   R3   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   checkç  s.    $c       	      sN   t  ˆ j ƒ 9 }  ˆ  j |  d d d ƒt |  d ƒ } t | ˆ  ƒ Wd  QXd  S(   NR€   R>   RB   (   RL   R3   Rl   R)   R   (   R3   R   (   R€   RY   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   check_default_mode  s    RÎ   s   r+R=   RB   (   RR   RÈ   (   RY   RÏ   RÐ   (    (   R€   RY   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_modeã  s    +



c         C   s  t  |  j ƒ ò} t | d d ƒ} t j ƒ  | d <t j t | j d ƒ | j	 ƒ  | j
 sd t ‚ | j d ƒ | j
 s€ t ‚ t | ƒ d k s˜ t ‚ | j	 ƒ  | j
 s² t ‚ t | d d ƒ} t j ƒ  | d <| j d ƒ | j
 sð t ‚ t | ƒ d k st ‚ | j d k st ‚ | j	 ƒ  | j
 s7t ‚ | j d ƒ | j
 sSt ‚ t | ƒ d k skt ‚ | j d k s€t ‚ | j	 ƒ  | j
 sšt ‚ | j d ƒ | j
 s¶t ‚ t | ƒ d k sÎt ‚ | j d k sãt ‚ | j	 ƒ  | j
 sýt ‚ Wd  QXd  S(   NR>   R=   RB   i    RÎ   i   (   RL   R3   R&   RR   Ry   Rc   Rd   R'   t   openR5   t   is_openRh   RC   t   _mode(   RY   R3   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_reopen_handle   s>    




c         C   s«   t  |  j ƒ – } t j ƒ  } t | d d d d d d ƒ} | | d <| j d | ƒ t j | d | ƒ t j | d | ƒ | j ƒ  t j j	 | ƒ s¡ t
 ‚ Wd  QXd  S(	   NR>   R=   t   drivert	   H5FD_COREt   driver_core_backing_storei    R€   R‘   (   RL   R3   RR   Rg   R&   Rw   R   R5   R0   t   existsRh   (   RY   R3   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_open_argsN  s    	

c         C   sF   t  |  j ƒ 1 } t j ƒ  | d <| j ƒ  | j d t ƒ Wd  QXd  S(   NR=   t   fsync(   RF   R3   RR   Ry   t   flushR{   (   RY   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt
   test_flushb  s    
c         C   s”   t  |  j ƒ  } t j ƒ  | d <| j d ƒ } | d } t j | | ƒ | j d ƒ } | d } t j | | ƒ t j t | j d ƒ Wd  QXd  S(   NR=   s   /aRš   (	   RF   R3   RR   Ry   t   getR!   Rc   Rd   RN   (   RY   R7   t   leftt   right(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_geti  s    

s   where, expectedt   /t   first_groupt   second_groupR‹   RÇ   R‘   s   /first_groupt   third_groupR’   t   s1s   /second_groupR“   s   /second_group/third_groupc      
   C   sÎ  i t  j d d d g ƒ d 6t  j d d d g ƒ d 6t  j d d	 d
 g ƒ d 6t  j d d d g ƒ d 6t  j d d d
 g ƒ d 6t j d d d g d d d g g ƒ d 6t j d% d& g d d ƒd 6t j d' d( g d d ƒd 6} t d d d ƒÓ} | j d | d ƒ | j d | d ƒ | j d | d ƒ | j d | d ƒ | j d | d ƒ | j j d d | d ƒ | j j	 d d d  | d ƒ| j j	 d! d d  | d ƒt
 t | j d" | ƒ ƒ ƒ t
 | ƒ k sàt ‚ xá | j d" | ƒ D]Í \ } } } | | k st ‚ | | \ } }	 | t | ƒ k s<t ‚ |	 t | ƒ k sTt ‚ xi | D]a }
 d# j | |
 g ƒ } | j | ƒ } d$ |
 k r¨t j | | |
 ƒ q[t j | | |
 ƒ q[WqóWWd  QXd  S()   Ni   i   i   RÇ   i   i   i   R‘   i   i   R’   i	   i
   i   R“   Ræ   t   a1t   dtypes   i,i,it   tb1i   t   tb2s   walk_groups.hdfR>   RB   s   /first_group/df1s   /first_group/df2s   /second_group/df3s   /second_group/s1s   /second_group/third_group/df4s   /first_groupRm   s   /second_groupRx   Râ   R€   (   i   i   i   (   i   i   i   (   i   i   i	   (   i
   i   i   (   R”   R   R   Rº   t   arrayRF   R–   R¢   t   create_arrayt   create_tableRC   RH   t   walkRh   R   R9   RÞ   RR   R   R!   (   RY   Rx   RŸ   t   objsR7   R3   t   groupst   leavest   expected_groupst   expected_framest   leaft
   frame_pathRm   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_walkw  s<    (0"c      
   C   s  t  |  j ƒ û } t j ƒ  } | | d <| j } t j | | ƒ t | d ƒ } t j | | ƒ t j ƒ  } | | d <| j } t j	 | | ƒ t
 j t t | d ƒ x0 d d d d g D] } t
 j t t | | ƒ q¸ Wx+ d d d d g D] } t | d | ƒ që WWd  QXd  S(	   NR=   R€   Rœ   R>   R3   t   handleR@   s   _%s(   RF   R3   RR   Ry   R=   R!   t   getattrRÈ   R€   R   Rc   Rd   t   AttributeError(   RY   R7   RÄ   R   R€   t   x(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_getattrª  s     
	
	c         C   s  t  |  j ƒ ù } t j ƒ  } t j ƒ  } | | d <| d  | d <| d  | d <| d  | d <| d  | d <| j d | d  d d	 ƒt j t | j d | d d
 t	 ƒt j t | j d | d d
 t	 ƒ| j d | d  d d	 d
 t
 ƒt j | d  | d ƒ Wd  QXd  S(   NR=   i
   Rš   s   foo/bar/bahR‰   s   /fooR›   Ra   Rb   Rw   (   RF   R3   RR   Ry   RÈ   R–   Rc   Rd   RM   R{   RE   R   (   RY   R7   t   tsR€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_putÆ  s    
	# c      
   C   sW  t  |  j ƒ B} t g  t d ƒ D] } d | ^ q" ƒ } t t j d ƒ d | ƒ} t i | d 6| d 6ƒ } | | d <t j	 | d | ƒ | | d <t j
 | d | ƒ t d g g  t d ƒ D] } d | ^ qÂ ƒ } t t j d	 ƒ d | ƒ} t i | d 6| d 6ƒ } | | d <t j	 | d | ƒ | | d <t j
 | d | ƒ Wd  QXd  S(
   Ni   s!   I am a very long string index: %sR~   Ru   Rv   R=   Rš   t$   abcdefghijklmnopqrstuvwxyz1234567890i   (   RF   R3   R   R   R   Rº   t   arangeR   RR   R!   R   (   RY   R7   t   iR~   RÄ   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_put_string_indexä  s$    &

	$

c         C   s}   t  |  j ƒ h } t j ƒ  } | j d | d d d d ƒt j | d | ƒ t j t | j d | d d d d ƒWd  QXd  S(   NR›   Ra   Rb   R@   R.   Rš   Rˆ   (	   RF   R3   RR   RÈ   R–   R   Rc   Rd   RM   (   RY   R7   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_put_compressionÿ  s    c         C   s}   t  j ƒ  } t |  j ƒ \ } t j t | j d | d d d d ƒ| j d | d d d d ƒt  j | d | ƒ Wd  QXd  S(   NRš   Ra   Rˆ   R@   R-   R›   Rb   (	   RR   RÈ   RF   R3   Rc   Rd   RM   R–   R   (   RY   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_put_compression_blosc  s    c         C   sn  t  j ƒ  } t |  j ƒ ° } | j | d d d ƒt j | d ƒ } t  j | | ƒ t j	 | d d ƒZ } xP | j
 d d d d	 ƒ D]6 } | j j d k s¥ t ‚ | j j d
 k s‡ t ‚ q‡ WWd  QXWd  QXt |  j ƒ ° } | j | d d d
 ƒt j | d ƒ } t  j | | ƒ t j	 | d d ƒZ } xP | j
 d d d d	 ƒ D]6 } | j j d k sft ‚ | j j d  k sHt ‚ qHWWd  QXWd  QXt |  j ƒ ª } | j | d ƒ t j | d ƒ } t  j | | ƒ t j	 | d d ƒZ } xP | j
 d d d d	 ƒ D]6 } | j j d k s!t ‚ | j j d  k st ‚ qWWd  QXWd  QXt |  j ƒ } t j | ƒ } | j d | d d d d ƒ| j d | ƒ | j ƒ  t j	 | d d ƒ­ } xP | j
 d d d d	 ƒ D]6 } | j j d k sït ‚ | j j d  k sÑt ‚ qÑWxP | j
 d d d d	 ƒ D]6 } | j j d k sBt ‚ | j j d k s$t ‚ q$WWd  QXWd  QXd  S(   NR€   R?   i	   R>   RÎ   Rx   s   /dft	   classnamet   LeafR.   R@   i    t   dfcR-   s   /dfc(   RR   Rg   RL   R3   Rl   R”   R)   R   R+   t	   open_filet
   walk_nodest   filtersR?   Rh   R@   R/   R&   Rw   R5   (   RY   R€   t   tmpfileR   t   h5filet   nodeR7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complibs_default_settings  sJ    (((
c         C   s¥  t  j ƒ  } t j j } t j d ƒ s7 | j d ƒ n  t j d ƒ sV | j d ƒ n  t d d ƒ } g  | D] } | D] } | | f ^ qv ql } x| D]\ } } t |  j	 ƒ è } d } | j
 | | d | d | ƒt j | | ƒ }	 t  j |	 | ƒ t j | d d	 ƒ}
 x{ |
 j d
 d | d d ƒ D]] } | j j | k sJt ‚ | d k rq| j j d  k s‰t ‚ q,| j j | k s,t ‚ q,W|
 j ƒ  Wd  QXq˜ Wd  S(   Nt   lzot   bzip2i    i
   R‰   R@   R?   R>   RÎ   Rx   Râ   R  R  (   RR   Rg   R+   R	  t   all_complibst   which_lib_versionR1   R   RL   R3   Rl   R”   R)   R   R  R  R?   Rh   R@   R/   R5   (   RY   R€   R  t
   all_levelst   libt   lvlt	   all_testsR
  t   gnameR   t   h5tableR  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complibsM  s,    ,c         C   s2   t  t j j d d ƒ ƒ } |  j | t j ƒ d  S(   Ni2   id   (   R   Rº   t   randomt   randnt   _check_roundtripRR   R   (   RY   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_put_integerr  s    c         C   s|  t  j ƒ  } d | d <d | d <| d d k | d <| d d k | d	 <t | d
 <d | d <d | d <t d ƒ | d <t d ƒ | d <t j d d d d d ƒ | d <t j d d d d d ƒ | d <t j | j d d … d g f <| j ƒ  j	 d t ƒ } t
 |  j ƒ l } t | d ƒ t d t ƒ ( t d t j j ƒ | j d | ƒ Wd  QX| j d ƒ } t  j | | ƒ Wd  QXd  S(   NR‰   R¨   RŠ   R©   Ru   i    Rª   Rv   R«   R¬   i   R­   i   R®   R¯   R°   R±   R²   iÑ  R³   i   R´   i   Rµ   R€   Rs   R¶   (   RR   RÈ   R{   R   Rµ   Rº   R»   R¼   R½   R¾   RF   R3   RP   R   R   R”   R¿   RÀ   R–   RÞ   R   (   RY   R€   R7   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_put_mixed_typew  s*    




s7   ignore:object name:tables.exceptions.NaturalNameWarningc         C   sY  t  |  j ƒ D} t d t ƒ ,t j ƒ  } t | d ƒ | j d | d  ƒ | j d | d ƒ t j | d | ƒ t | d ƒ | j	 d | d  d d ƒ| j d | d ƒ t j | d | ƒ t | d ƒ | j d | d  ƒ | j d | d ƒ t j | d | ƒ t | d	 ƒ | j d	 | d  ƒ | j d	 | d ƒ t j | d
 | ƒ t j
 ƒ  } t | d ƒ | j d | j d  d  … d  d … d  d  … f ƒ | j d | j d  d  … d d  … d  d  … f ƒ t | d | ƒ t | d ƒ | j d  d  … d  d … d  d  … f } | j d | ƒ | j d  d  … d d  … d  d  … f j d | j d  d  d … ƒ } | j d | ƒ t | d | ƒ t d d d g d d g d d g d d g g ƒ } d | d <t j | j d( <t | d ƒ | j d | ƒ t j | d | ƒ t i t t j j d d d d d ƒd t j ƒd 6t t j j d d d d d ƒd t j ƒd 6t t j j d d d) d d ƒd t j ƒd 6t d* d+ d, d- d. g d t j ƒd$ 6d% t j d ƒ ƒ} t | d& ƒ | j d& | ƒ t j | d& | ƒ t | d& ƒ | j d& | d' d d d g ƒt j | d& | ƒ Wd  QXWd  QXd  S(/   NRs   RÇ   i
   R‘   Ra   Rb   R’   s   /df3s   /df3 foos   df3 foot   wp1t   itemsiÿÿÿÿt   datai   i   i    t   testingt   mixed_columnR€   t   highiÿ   Rƒ   i   Rè   t   u08iÿÿ  t   u16i   t   u32i:   i;   i<   i=   i>   t   u64R~   t   uintsR„   (   i   R"  i   @I       I       I       I        I       @(   RF   R3   R   R{   RR   RÈ   RP   Rw   R   R–   R|   RŒ   R    t   reindexR  R   Rº   R»   R¼   R   R  t   randintt   uint8t   uint16t   uint32t   uint64Rÿ   (   RY   R7   R€   t   wpt
   wp_append1t
   wp_append2t	   uint_data(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append“  sh    22(D3
!!!"c   	      C   sA  t  |  j ƒ ,} t j ƒ  } t j ƒ  } t t j d ƒ ƒ } | j d | ƒ | d } t j	 | | ƒ | j
 d  k s~ t ‚ | j d | ƒ | d } t j	 | | ƒ | j
 d  k s½ t ‚ d | _
 | j d | ƒ | d } t j	 | | ƒ | j
 | j
 k st ‚ | | d k } | j d d ƒ } t j	 | | ƒ | | d k | j d	 k  @} | j d d
 ƒ } t j	 | | ƒ t t j j d d ƒ d d g ƒ} t j t | ƒ ƒ | d <d | d <d | j d d … d f <| j d d g d t ƒ| j ƒ  } | j j d ƒ | _ | j d | ƒ t j	 | d | ƒ Wd  QXd  S(   Nid   t   ssRü   R‰   t   nsi<   s   foo>60iF   iZ   s   foo>70 and index<90i   i   t   columnsRu   Rv   t   CRŠ   i   t   inplacei   t   mi(   RF   R3   RR   Rz   Ry   R   Rº   Rÿ   Rw   R!   t   nameR/   Rh   R†   R~   R   R  R  RC   R¼   t	   set_indexR{   t   stackt	   droplevel(	   RY   R7   R4  Rü   R5  R   RŸ   R9  RÄ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_seriesá  s@    

	
$
c            sù   t  |  j ƒ ä ‰  ‡  f d †  } x@ t j t j t j t j g D]  } | d | ƒ | d | ƒ q@ W| d t j ƒ t j } t	 j
 r£ | d | ƒ | d | ƒ nL t j t | d | ƒ t d t ƒ % t d t j j ƒ | d | ƒ Wd  QXWd  QXd  S(   Nc            st   t  t j j d d ƒ d t d ƒ ƒ} | t | ƒ ƒ | _ t ˆ  d ƒ ˆ  j d | d |  ƒt	 | ˆ  d ƒ d  S(   Ni
   i   R6  t   ABR€   Ra   (
   R   Rº   R  R  RH   RC   R~   RP   R–   R   (   Ra   R~   R€   (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRÏ     s
    'Rb   Rˆ   Rs   R¶   (   RF   R3   RR   t   makeFloatIndext   makeStringIndext   makeIntIndext   makeDateIndext   makePeriodIndext   makeUnicodeIndexR   t   PY3Rc   Rd   RŽ   R   R{   R   R”   R¿   RÀ   (   RY   RÏ   R~   (    (   R7   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_index_types  s    		R,   s$   reason platform is not little endianc      
   C   sÝ   t  |  j ƒ È } t t d d d d ƒ d t d ƒ ƒ} t j | j d <t j | j d <t | d	 ƒ | j	 d	 | d
 d ƒt
 j | d	 | ƒ | j d d g ƒ } | j d	 t d d
 d ƒƒ } t
 j | | ƒ Wd  QXd  S(   NRu   R‰   Rv   RŠ   R~   i   i   i   R€   t   encodingt   asciiR6  s	   columns=A(   i   Ru   (   i   Rv   (   RF   R3   R   R}   R   Rº   R»   R¼   RP   Rw   RR   R   R)  R†   R(   (   RY   R7   R€   RŸ   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_encoding7  s    'c   
         sz  t  j r t j d ƒ n  d d d d d g d d d d g d d d d d g d d d d d g d d d d g d d d d g d	 d d d d g t j d d d g d	 t j d d d g g	 } d
 d „ } g  | D]% } g  | D] } | | ƒ ^ qÛ ^ qÎ } g  } xA d t g D]3 } x* | D]" } | j t j	 | d | ƒƒ qWqWd d
 d ‡  f d † } x | D] }	 | |	 ƒ qbWd  S(   Ns.   [unicode] is not implemented as a table columns   EÉ, 17R‹   R=   Rš   R›   s   EE, 17s   øüs   Aøüs   latin-1c         S   s*   y |  j  | ƒ SWn t k
 r% |  SXd  S(   N(   t   decodeRù   (   Rú   RH  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   _try_decodeV  s    t   categoryRè   R   c            s©   t  ˆ  j ƒ ” } |  j | | d d d | d | ƒt | | ƒ } |  j | t j ƒ } t | ƒ r’ t | ƒ sv t ‚ t	 | | d t
 d t
 ƒn t	 | | ƒ Wd  QXd  S(   NRa   Rb   RH  t   nan_rept   check_dtypet   check_categorical(   RL   R3   Rl   R)   t   replaceRº   R»   R   Rh   R!   RE   (   RÄ   RO   RH  RN  R7   t   retrt   s_nan(   RY   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRo   c  s    
(
   R   t   PY2Rc   t   skipRº   R»   t   objectRw   R”   R   (
   RY   t   valuesRL  t   yRú   t   examplesRè   t   valRo   RÄ   (    (   RY   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_latin_encodingG  s(    	2$c         C   sz  t  |  j ƒ e} t i t t j j d ƒ ƒ j d ƒ d 6t j j d ƒ d 6t j j d ƒ d 6d d 6d d	 6t d
 ƒ d 6t	 j	 d d d d d ƒ d 6d t j
 d ƒ ƒ} t | d ƒ t j | j d d … d d d d g f <| j d | d  ƒ | j d | d ƒ t j | d | ƒ | j ƒ  } t j | j d  d  … d f <t | d ƒ | j d | d  ƒ | j d | d ƒ t j | d | ƒ | j ƒ  } t j | j d  d  … d f <t | d ƒ | j d | d  ƒ | j d | d ƒ t j | d | ƒ | j ƒ  } t j | j d  d  … d f <t | d ƒ | j d | d  ƒ | j d | d ƒ t j | d | ƒ Wd  QXd  S(   Ni   t   int32Ru   t   A1t   A2R‰   Rv   RŠ   R7  t   20010101t   DiÑ  i   i   i    t   ER~   RÇ   i   i
   R‘   R’   (   RF   R3   R   R   Rº   R  R  t   astypeR   Rµ   Rÿ   RP   R»   R¼   Rw   RR   R   t   copy(   RY   R7   R€   RÇ   R‘   R’   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_some_nansw  s>    ((c   	      C   sÞ  t  |  j ƒ -} t i t j j d ƒ d 6t j j d ƒ d 6d t j d ƒ ƒ} t j | j d d … d  d  … f <t	 | d ƒ | j
 d | d  d	 t ƒ| j
 d | d d	 t ƒt j | d | d
 ƒ t	 | d ƒ | j
 d | d  d	 t ƒ| j
 d | d d	 t ƒt j | d | ƒ t j d t ƒ t	 | d ƒ | j
 d | d  ƒ | j
 d | d ƒ t j | d | ƒ t j d t ƒ t	 | d ƒ | j
 d | d  ƒ | j
 d | d ƒ t j | d | d
 ƒ t i t j j d ƒ d 6t j j d ƒ d 6d d 6d d 6d t j d ƒ ƒ} t j | j d d … d  d  … f <t	 | d ƒ | j
 d | d  d	 t ƒ| j
 d | d d	 t ƒt j | d | ƒ t	 | d ƒ | j
 d | d  d	 t ƒ| j
 d | d d	 t ƒt j | d | ƒ t i t j j d ƒ d 6t j j d ƒ d 6d d 6d d 6t d ƒ d 6t j d d d d d ƒ d 6d t j d ƒ ƒ} t j | j d d … d  d  … f <t	 | d ƒ | j
 d | d  d	 t ƒ| j
 d | d d	 t ƒt j | d | ƒ t	 | d ƒ | j
 d | d  d	 t ƒ| j
 d | d d	 t ƒt j | d | ƒ Wd  QXt i d t j d g d 6d t j t j g d 6ƒ } t |  j ƒ < } | j | d d d ƒt | d ƒ } t j | | ƒ Wd  QXt j t j t j g d t j t j g g t j t j t j g t j d d g g t j t j t j g t j d  t j g g g } t d! t ƒ ˆ t | d" d# d$ d% g d& d d g d' d( d d g ƒ} t |  j ƒ < } | j | d) d d ƒt | d) ƒ } t j | | ƒ Wd  QXWd  QXd  S(*   Ni   R]  R^  R~   i    i   R€   i
   t   dropnaiüÿÿÿR‘   s   io.hdf.dropna_tableR’   R“   R‰   Rv   RŠ   R7  R_  R`  iÑ  i   i   Ra  t   col1t   col2t   df_with_missingRa   Rb   i   i   i   Rs   R  t   Item1t   Item2t   Item3t
   major_axist
   minor_axisRu   t   panel_with_missing(   RF   R3   R   Rº   R  R  Rÿ   R»   R¼   RP   Rw   R{   RR   R   RE   R”   R•   R   Rµ   RL   Rl   R)   R   R   R    (	   RY   R7   R€   Rh  R3   t   reloadedt   matrixRn  t   reloaded_panel(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_all_nans   sŒ    """2*'0	c         C   sH  t  |  j ƒ 3} t j ƒ  } t | d ƒ | j d | j d  d  … d  d … f d d g ƒ| j d | j d  d  … d d  … f ƒ t j | d | ƒ | j d d ƒ } | j	 d d g ƒ } t j | | ƒ | j d d ƒ } | j	 d d g d | j
 d	 d
 !ƒ } t j | | ƒ t j t ƒ  | j d d ƒ Wd  QXWd  QXd  S(   NRÇ   i   t   axesR6  s	   columns=ARu   s   index=df.index[0:4]R~   i    i   s   columns=A and index>df.index[4](   s	   columns=As   index=df.index[0:4](   RF   R3   RR   RÈ   RP   Rw   RŒ   R   R†   R)  R~   Rc   Rd   RŽ   (   RY   R7   R€   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt!   test_append_frame_column_oriented  s     2)%	c         C   sc  t  |  j ƒ ;} x1t d ƒ D]#} t t j j d d ƒ d t d ƒ ƒ} t d ƒ | d <| d c | d 7<t d g t	 | ƒ d d ƒ| d <t d g t	 | ƒ d d	 ƒ| d	 <| d d
 k ró | d =t d g t	 | ƒ d d ƒ| d <n  | d d
 k r| j
 d ƒ } | | d <n  | j d d t ƒ| j d | ƒ q WWd  QXt  |  j ƒ } t t j j d d ƒ d t d ƒ d d ƒ} t d g t	 | ƒ d d ƒ| d <t d g t	 | ƒ d d	 ƒ| d	 <| j d | ƒ t d g t	 | ƒ d d	 ƒ| d <t j t | j d | ƒ t d g t	 | ƒ d d ƒ| d <t j t | j d | ƒ Wd  QXd  S(   Ni
   i   R6  R?  R~   i   Rè   t   int64t   int16i    i   Ru   R8  R€   t   float64t   int16_2g      ð?t   float_3(   RF   R3   R   R   Rº   R  R  RH   R   RC   t   popR;  R{   Rw   Rc   Rd   RM   (   RY   R7   R   R€   R=   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt)   test_append_with_different_block_ordering  s2    '##&####c   	         s¶  t  |  j ƒ g‰  t d t ƒ Ot d t ƒ t j ƒ  } | j d d „  | j	 Dƒ ƒ } ‡  f d †  } ˆ  j
 d | d d ƒˆ  j
 d | ƒ t | | g d	 d
 ƒ} | j d t | j	 ƒ ƒ } t ˆ  d | ƒ | d d d ƒ ˆ  j
 d | d i d d 6ƒˆ  j
 d | ƒ t | | g d	 d
 ƒ} | j d t | j	 ƒ ƒ } t ˆ  d | ƒ | d d d ƒ ˆ  j
 d | d i d d 6ƒt j t ˆ  j
 d | ƒ ˆ  j
 d | ƒ t j t ˆ  j
 d | ƒ t d d g d d g g ƒ } ˆ  j
 d | ƒ t j ˆ  j d ƒ | ƒ | d d d ƒ t d d g d d g g ƒ } ˆ  j
 d | ƒ t | | g ƒ } t j ˆ  j d ƒ | ƒ | d d d ƒ t d d g d d g g ƒ } ˆ  j
 d | d i d d 6ƒt j ˆ  j d ƒ | ƒ | d d d ƒ ˆ  j
 d | ƒ t d d g d d g g ƒ } t j t ˆ  j
 d | ƒ t j ƒ  j d  ƒ } ˆ  j
 d! | d" d i d# d$ 6ƒt j ˆ  j d! ƒ | d" ƒ ˆ  j
 d% | d" d& t d i d# d$ 6ƒt j ˆ  j d% ƒ | d" ƒ ˆ  j d' | d( d) d i d* d$ 6ƒ| j ƒ  j ƒ  j d  d+ ƒ j d  ƒ } ˆ  j
 d' | ƒ t j ˆ  j d' ƒ t j | | g ƒ ƒ ˆ  j d, | d" d( d) d i d* d$ 6ƒˆ  j
 d, | d" ƒ t j ˆ  j d, ƒ t j | d" | d" g ƒ ƒ t ˆ  d- ƒ t j ƒ  } d. | d/ <t j  | j! d0 d# … d/ f <d1 | d2 <t j  | j! d# d3 … d2 f <d4 | d5 <t j  | j! d0 d  … d5 f <ˆ  j
 d- | ƒ ˆ  j d- ƒ } t j | | ƒ Wd  QXWd  QXt  |  j ƒ )‰  ‡  f d6 †  } t t" d7 d. d" d1 ƒ d$ t# d8 ƒ ƒ} t ˆ  d- ƒ ˆ  j
 d- | d i d9 d7 6ƒ| d- d7 d9 ƒ ˆ  j$ d- ƒ j% d7 g k st& ‚ t ˆ  d- ƒ ˆ  j
 d- | d& d" g d i d9 d7 6ƒ| d- d7 d9 ƒ ˆ  j$ d- ƒ j% d" d7 g k s‚t& ‚ t ˆ  d- ƒ ˆ  j
 d- | d& d" g d i d9 d 6ƒ| d- d" d9 ƒ | d- d: d9 ƒ ˆ  j$ d- ƒ j% d" g k söt& ‚ t ˆ  d- ƒ ˆ  j
 d- | d;  d d9 ƒˆ  j
 d- | d; d d9 ƒt j ˆ  d- | ƒ t d. d. d. d< d< d< g d= d7 g ƒ} t ˆ  d- ƒ t j t ˆ  j
 d- | d i d d. 6d d> 6ƒWd  QXd  S(?   NRs   R¶   Rm  c         S   s   i  |  ] } d  | | “ q S(   s   %s_extra(    (   t   .0Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pys
   <dictcomp>N  s   	 c            s1   t  ˆ  j |  ƒ j j | ƒ j | k s- t ‚ d  S(   N(   Rø   R—   Rb   t   descriptiont   itemsizeRh   (   RO   R:  Rƒ   (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   check_colP  s    Ræ   t   min_itemsizei   t   axisi   t   s2t   s3Rl  t   s4i{   t	   asdqwertyiY  t   dggnhebbsdfbdfbt   df_bigt   values_block_1i   i|   t   asdqyiZ  t   dggnhefbdfbt   df_big2i2   RW  t   df_newt
   abcdefqhijt   abcdefghijklmnopqrtsuvwxyzR7  R4  Rv   i   R~   t   ss2R„   t   ss3Ra   Rb   i   t   longert   ss4R€   R‰   t   stringi   RŠ   t   string2i   R·   t   string3c            s1   t  ˆ  j |  ƒ j j | ƒ j s- t | ƒ ‚ d  S(   N(   Rø   R—   Rb   R}  R~  Rh   (   RO   R:  Rƒ   (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyR  ¯  s    Ru   i
   iÈ   t   values_block_0i   t   barhR6  t   foobar('   RF   R3   R   R{   R   t   FutureWarningRR   R|   t   renameRm  Rw   R   R)  t   sortedR    Rc   Rd   RM   R   R   R†   t   makeMixedDataFrameR;  R!   R–   Rc  t   reset_indext   assignR”   RP   RÈ   Rº   R»   R¼   R}   R   R—   R„   Rh   (	   RY   R/  t   wp2R  RŸ   R€   R‘   RŒ  R   (    (   R7   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_with_stringsG  sÀ    			!'


'!&$!c         C   sŸ   t  |  j ƒ Š } t i d d d d d d d g d 6ƒ } | j d	 | d
  d i d d 6ƒ| j d	 | d
 d i d d 6ƒt j | j d	 ƒ | ƒ Wd  QXd  S(   NR=   Rš   R›   Rœ   R§   RK   R‹   Rú   R€   iÿÿÿÿR€  i   (   RF   R3   R   Rw   RR   R   R†   (   RY   R7   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_with_empty_stringÖ  s
    (!!c         C   s<  t  |  j ƒ '} t j ƒ  j d ƒ } | j | d d d d i d d 6ƒ| j ƒ  j ƒ  j d d ƒ j d ƒ } | j | d d	 t	 d d ƒt j
 t j | d ƒ t j | | g ƒ ƒ | d
 j | d d d d i d d 6ƒ| d
 j | d d	 t	 d d ƒt j t j | d ƒ t j | d
 | d
 g ƒ ƒ Wd  QXd  S(   NR7  R  Ra   Rb   R€  i   R~   R‘  Rw   Rv   R’  (   RL   R3   RR   Rœ  R;  Rl   Rc  R  Rž  R{   R   R”   R)   R   R!   (   RY   R3   R€   R‘   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_to_hdf_with_min_itemsizeà  s    #' Ra   Rˆ   t   marksRb   c         C   s‡   d g } t  j | d t  j | ƒ ƒ} t |  j ƒ K } | j | d d | d d ƒt  j | d d d ƒ} t j | | ƒ Wd  QXd  S(   Ns	   \ud800fooR~   Rb   Ra   R¿   t   surrogatepass(	   R”   R   R   RL   R3   Rl   R)   RR   R!   (   RY   Ra   R   t   serR3   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_to_hdf_errorsô  s    	c   
         s
  t  |  j ƒ 
‰  t j ƒ  } d | j d | j j d ƒ f <t ˆ  d ƒ ˆ  j d | d  d d g ƒˆ  j d | d ƒ t j	 ˆ  d | ƒ ˆ  j
 j j j j j j t k s¶ t ‚ ˆ  j
 j j j j j j t k sÝ t ‚ ˆ  j d d ƒ } | | j d k } t j	 | | ƒ ˆ  j d d ƒ } | j d	 | j d
 ƒ } | | j d k } t j	 | | ƒ | j ƒ  } d | d <t j | j d d
 … d f <d | j d d … d f <t ˆ  d ƒ ˆ  j d | d d g ƒˆ  j d d ƒ } | | j d k } t j	 | | ƒ ‡  f d †  } Wd  QXt  |  j ƒ É ‰  t ˆ  d ƒ ˆ  j d | d d g d i d d 6ƒ| d d d ƒ t ˆ  d ƒ ˆ  j d | d d g d d ƒ| d d d ƒ t ˆ  d ƒ ˆ  j d | d d g d i d d 6ƒ| d d d ƒ Wd  QXt  |  j ƒ ™ ‰  d | d <d | d <d | d <t ˆ  d ƒ ˆ  j d | d d d g d i d d 6d d 6d d 6ƒ| d d d ƒ | d d d ƒ | d d d ƒ Wd  QXt  |  j ƒ Ì‰  | j ƒ  } d | j d | j j d ƒ f <d  | j d | j j d ƒ f <d | d <| j j d ƒ } t j | j d d
 … | f <d | j d d … | f <d | d <| j j d ƒ } t j | j d d … | f <d | j d! d" … | f <t ˆ  d ƒ ˆ  j d | d d d d d g ƒˆ  j d d# ƒ } | | j d k | j d k @| j d k @| j d k  @} t j	 | | d$ t ƒˆ  j d d% ƒ } | | j d k | j d& k @} t j	 | | d$ t ƒWd  QXt  |  j ƒ n‰  | j ƒ  } d | d <t j | j d
 d … d f <d | j d! d' … d f <d& | d <t d( ƒ | d) <| j d) t ƒ } t j | j d* d … d d d) g f <t ˆ  d+ ƒ ˆ  j d+ | d d d, d d d) g ƒˆ  j d+ d ƒ } | | j d k } t j	 | | d$ t ƒˆ  j d+ d- d. d/ g ƒ } | | j d k | j  d k @| j d k @} t j	 | | d$ t ƒWd  QXt  |  j ƒ ‰  t j! j" d0 ƒ t# d1 d2 d" ƒ} t$ t j! j% d" d* ƒ d	 | d3 d d d, g ƒ} d | d <t j | j d
 d … d f <d | j d! d' … d f <| j d  d  … d d, g f j& ƒ  | j d  d  … d d, g f <d& | d <ˆ  j d+ | d d d, d d g ƒˆ  j d+ d ƒ } | | j d k } t j	 | | ƒ ˆ  j d+ d- d. d4 g ƒ } | | j d k | j  d k @| j d k @} t j	 | | ƒ Wd  QXt  |  j ƒ R‰  t' d5 t ƒ :t j! j" d0 ƒ t j( ƒ  }	 ˆ  j d6 |	 ƒ t j) ˆ  j d6 ƒ |	 ƒ ˆ  j d7 |	 d t ƒt j) ˆ  j d7 ƒ |	 ƒ ˆ  j d7 d8 d9 ƒ} |	 j* ƒ  } | | d: d k } t j	 | j* ƒ  | ƒ ˆ  j d7 d8 d; ƒ} |	 j* ƒ  } | | d: d k } | | j+ d< d= g ƒ j j, d d g ƒ } t j	 | j* ƒ  | ƒ Wd  QXWd  QXd  S(>   Ng      ð?i    Rv   R€   i   R„   s   B>0s   B>0 and index>df.index[3]R~   i   R‰   R“  i   RŠ   i   i   s   string='foo'c            s1   t  ˆ  j |  ƒ j j | ƒ j | k s- t ‚ d  S(   N(   Rø   R—   Rb   R}  R~  Rh   (   RO   R:  Rƒ   (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyR  )  s    R€  i   RW  t	   foobarbahR”  t
   foobarbah1t   string_block1t
   foobarbah2t   string_block2i(   i2   Rˆ  Ru   g      ð¿i   i   s.   string='foo' and string2='foo' and A>0 and B<0t   check_index_types   string='foo' and string2='cool't   cooli	   R¯   Rµ   i   t   df_dcR7  s   B > 0s   C > 0s   string == fooiÒ  s   1/1/2000t   periodsR6  s   string == "foo"Rs   t   p1t   p2Rx   s   ItemA>0t   ItemAs   ItemA>0 & minor_axis=["A","B"]t   levelt   major(-   RF   R3   RR   RÈ   RŒ   R6  t   get_locRP   Rw   R   R¢   R¤   R€   Rb   t   colsR~   t
   is_indexedR{   Rh   Rv   R†   R)  Rc  Rº   R»   R¼   R“  R”  Ru   RE   R   R¾   R7  R  t   seedR   R   R  t   absR   R|   R    t   to_frameR  t   isin(
   RY   R€   R   RŸ   RŒ  R  t   slR®  R~   RI   (    (   R7   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_with_data_columns  s   ''





		7

%	
>
c            sø  t  |  j ƒ ã‰  t d t ƒ Ë‡  f d †  } t j ƒ  } ˆ  j d | d t ƒˆ  j d d d g ƒ| d d ƒ j	 t k s‡ t
 ‚ | d d ƒ j	 t k s¥ t
 ‚ ˆ  j d | d t ƒ| d d ƒ j	 t k sÙ t
 ‚ | d d ƒ j	 t k s÷ t
 ‚ ˆ  j d ƒ j ƒ  | d d ƒ j j d	 k s+t
 ‚ | d d ƒ j j d
 k sLt
 ‚ ˆ  j d ƒ | d d ƒ j j d	 k szt
 ‚ | d d ƒ j j d
 k s›t
 ‚ ˆ  j d d d ƒ| d d ƒ j j d k sÏt
 ‚ | d d ƒ j j d
 k sðt
 ‚ ˆ  j d d d ƒ| d d ƒ j j d k s$t
 ‚ | d d ƒ j j d k sEt
 ‚ ˆ  j d d d d d ƒ| d d ƒ j j d k st
 ‚ | d d ƒ j j d k s t
 ‚ t j ƒ  } d | d <d | d <ˆ  j d | d d d g ƒ| d d ƒ j	 t k sút
 ‚ | d d ƒ j	 t k st
 ‚ | d d ƒ j	 t k s6t
 ‚ ˆ  j d | d d g d d d g ƒ| d d ƒ j	 t k syt
 ‚ | d d ƒ j	 t k s—t
 ‚ | d d ƒ j	 t k sµt
 ‚ t ˆ  d ƒ ˆ  j d | ƒ t j t ˆ  j d ƒ Wd  QXWd  QXd  S(   NRs   c            s   t  ˆ  j |  ƒ j j | ƒ S(   N(   Rø   R—   Rb   R¶  (   t   tt   column(   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   col¹  s    t   p5R~   R6  Rl  Rm  t   p5ii   t   mediumt   optleveli	   t   kindt   fulli   t   lightR‰   R“  RŠ   R”  RK   R„   t   f2(   RF   R3   R   R{   RR   R|   Rw   RE   t   create_table_indexR·  Rh   R—   t   create_indexR~   RÄ  RÅ  RÈ   RP   R–   Rc   Rd   RŽ   (   RY   RÀ  R/  R€   (    (   R7   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_create_table_index´  sT    !!!!!!!!!!

c         C   sÒ   t  d t ƒ ½ t j ƒ  } | j d  d  … d  d … d  d  … f } | j | j j d d d g ƒ d d  … d  d  … f } t |  j ƒ < } | j	 d | d d ƒt
 j t | j	 d | d	 t ƒWd  QXWd  QXd  S(
   NRs   i
   t   ItemCt   ItemBR²  Rt   Ra   Rb   Rw   (   R   R{   RR   R|   RŒ   R  t   get_indexerRF   R3   R–   Rc   Rd   RM   (   RY   R/  R  RŸ  R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_diff_item_orderñ  s    (c         C   sª  t  d d d d d g d d d g g d	 d
 d
 d
 d d d d d d d g
 d
 d d d
 d d d d
 d d g
 g d d d g ƒ } t t j j d d ƒ d | d d d d g ƒ} t |  j ƒ y } | j d | ƒ | j d ƒ } t	 j
 | | ƒ | j d d d d g ƒ} | j d d d g ƒ } t	 j
 | | ƒ Wd  QXt d ƒ ` } | j | d d d ƒt | d d d d g ƒ} | j d d d g ƒ } t	 j
 | | ƒ Wd  QXd  S(   Nt   levelsR‰   RŠ   t   bazt   quxt   onet   twot   threet   codesi    i   i   i   t   namesi
   R~   R6  Ru   Rv   R7  R9  s   test.hdfR€   Ra   Rb   (   R   R   Rº   R  R  RF   R3   Rw   R†   RR   R   R)  RL   Rl   R)   (   RY   R~   R€   R7   R   RŸ   R3   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_hierarchicalþ  s&    !'c         C   sb  t  j d d d d g d d d g ƒ} t t j d ƒ j d	 d
 ƒ d | ƒ} | j ƒ  } t | j t	 ƒ r t
 | j ƒ | _ n  t |  j ƒ º } | j d | ƒ t j | d | d t d t ƒ| j d | d d ƒt j | d | d t d t ƒt j t | j d | d d d d g ƒt j t | j d | d d d t ƒWd  QXt |  j ƒ G } | j d | ƒ | j d | ƒ t j | d t | | f ƒ ƒ Wd  QXt t j d ƒ j d	 d
 ƒ d t t d ƒ d d ƒƒ} | j ƒ  } t | j t	 ƒ rt
 | j ƒ | _ n  t |  j ƒ = } | j d | d d ƒt j | d | d t d t ƒWd  QXd  S(   NRu   R=   Rš   Rv   R×  t   firstt   secondi   i   i   R6  R€   R¬  t   check_column_typeRÇ   Ra   Rb   R‘   R„   R’   t   ABCDR:  R‰   (   Ru   R=   (   Ru   Rš   (   Rv   R=   (   Rv   Rš   (   R   t   from_tuplesR   Rº   Rÿ   t   reshapeRc  RG   R~   R   R   RF   R3   R–   RR   R   R{   Rc   Rd   RM   Rw   R   R   RH   (   RY   R~   R€   RŸ   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_column_multiindex  sD    '&c         C   s¢  t  |  j ƒ } d  d „ } t | d ƒ t t j d ƒ d d d g d | ƒ  ƒ} | j d | ƒ t j	 | j
 d ƒ | ƒ t | d ƒ t t j d ƒ d d d g d | d	 d  d  g ƒ ƒ} | j d | ƒ t j	 | j
 d ƒ | ƒ t | d
 ƒ t t j d ƒ d | d	 d  d  g ƒ ƒ} | j d
 | ƒ t t j d ƒ d | d	 d d g ƒ ƒ} t j | j
 d
 ƒ | ƒ t | d ƒ t t j d ƒ d d d g d | d	 d d g ƒ ƒ} t j t | j d | ƒ t | d ƒ t t j d ƒ d d d g d | d	 d	 d	 g ƒ ƒ} t j t | j d | ƒ t | d ƒ t t j d ƒ d d d g d | d	 d
 d g ƒ ƒ} | j d | ƒ t j	 | j
 d ƒ | ƒ Wd  QXd  S(   Nc      	   S   sm   t  j g  t d d ƒ D]J } t d ƒ D]7 } t d ƒ D]$ } t j d d | ƒ | | f ^ q6 q& q d |  ƒS(   Ni   i   i   iÝ  i   R×  (   R   RÝ  R   Rµ   (   R×  Rœ   RÄ   R¾  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt
   make_indexO  s
    	:R€   i   i   R6  R=   Rš   R~   t   dateRÄ   t   level_1t   level_2R¾  (   i   i   (   i   i   (   i   i   (   i   i   (   i   i   (   RF   R3   R/   RP   R   Rº   t   zerosRw   RR   R   R†   R   R!   Rc   Rd   RM   (   RY   R7   Rà  R€   RÄ   t   xp(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_multiindexI  s>    	$*$$c         C   sŸ  t  d d d d d g d d d g g d	 d
 d
 d
 d d d d d d d g
 d
 d d d
 d d d d
 d d g
 g d d d g ƒ } t t j j d d ƒ d | d d d d g ƒ} t |  j ƒ k } | j d | d d ƒ| d g } t j	 | j
 d d d g ƒ| ƒ t j	 | j
 d d d ƒ| ƒ Wd  QXt t j j d ƒ d | d d ƒ} t |  j ƒ < } | j d | d d ƒt j | j
 d d d ƒ| ƒ Wd  QXd  S(   NRÐ  R‰   RŠ   RÑ  RÒ  RÓ  RÔ  RÕ  RÖ  i    i   i   i   R×  t   foo_namet   bar_namei
   R~   R6  Ru   Rv   R7  R€   Ra   Rb   Rx   s   columns=['A']R:  RÄ   (   R   R   Rº   R  R  RF   R3   R–   RR   R   R†   R   R!   (   RY   R~   R€   R7   RŸ   RÄ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_columns_in_where€  s$    !'"	c      	   C   sÔ   t  j j t d d d ƒt d ƒ g d d d g ƒ} t  j i d d d	 d
 d g d 6d | ƒ} t |  j ƒ ^ } | j d | d t	 ƒ| j
 d d d ƒ} | j d g d  d  … f } t j | | ƒ Wd  QXd  S(   Ns
   2000-01-01R¯  i   R×  Rá  t   idgš™™™™™ñ?g333333ó?gÍÌÌÌÌÌô?gffffffö?g      ø?R=   R~   R€   R„   Rx   s   id == 1i   (   R”   R   t   from_arraysR   R   R   RF   R3   Rw   R{   R†   RŒ   RR   R   (   RY   t   idxR€   R7   t   actualRŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_mi_data_columnsŸ  s    +c      
   C   sv   t  j ƒ  } t |  j ƒ U } | j d | ƒ t j t | j d d d g ƒt j t | j d d d g ƒWd  QXd  S(   NR€   R6  Ru   Rx   s	   columns=A(	   RR   Rg   RF   R3   R–   Rc   Rd   RŽ   R†   (   RY   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_pass_spec_to_storer¬  s    c            s9  t  ˆ  j ƒ } } t j ƒ  } | j d | d d ƒ| j d ƒ } t j | | ƒ | j d | d d ƒ| j d ƒ } t j | | ƒ Wd  QX‡  f d †  } t j ƒ  } d | d	 <d
 | d <| d j d ƒ | d <| d d k | d <t d ƒ | d <t d ƒ | d <| | t j ƒ t	 d t
 ƒ  t j ƒ  } | | t ƒ Wd  QXt  ˆ  j ƒ Ý} t d t d ƒ ƒ } | j d | ƒ t j t | j d ƒ t t j j d d ƒ d t d ƒ ƒ} | j d | ƒ t | j d ƒ | ƒ | j d | ƒ t | j d ƒ | ƒ t d t d ƒ ƒ } | j d | ƒ t | j d ƒ | ƒ t	 d t
 ƒ Ü t d t d ƒ ƒ } | j d | ƒ t j t | j d ƒ t t j j d d d ƒ d t d ƒ ƒ} | j d | ƒ t | j d ƒ | ƒ | j d | ƒ t | j d ƒ | ƒ | j d | ƒ t | j d ƒ | ƒ Wd  QXWd  QXd  S(   NR€   t	   chunksizei   RÇ   t   expectedrowsi
   c      
      sn   xg d d d g D]V } t  ˆ  j d d ƒ9 } | j d |  d | ƒ| j d ƒ } | | |  ƒ Wd  QXq Wd  S(   Ni
   iÈ   iè  R>   RB   Rm   Rð  (   RF   R3   Rw   R†   (   Rm   t
   comparatorR›   R7   R   (   RY   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRÏ   Ä  s
    R‰   R“  g      ð?t   float322t   float32i    t   boolt   20130101t   time1t   20130102t   time2Rs   R6  t   ABCi   R‘   R  RI   i   i   R±  (   RF   R3   RR   Rg   Rw   R†   R   Rb  R   R   R{   R|   R    R   RH   Rc   Rd   RN   Rº   R  t   randR–   R   R  (   RY   R7   R€   R   RÏ   RI   t   df_emptyt   p_empty(    (   RY   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_misc¶  sV    

'*c         C   sÛ  t  |  j ƒ Æ} t j ƒ  } d g g t | ƒ | d <| j d t j k sT t ‚ t	 j
 t | j d | ƒ d g g t | ƒ | d <d g g t | ƒ | d <t	 j
 t | j d | ƒ t j ƒ  } t t j d d d ƒ d	 | j ƒ} | j t ƒ } t j | d
 d +| | d <| j d t j k s/t ‚ t	 j
 t | j d | ƒ t	 j
 t | j d t j d ƒ ƒ t	 j
 t | j d t t j d ƒ ƒ ƒ t j ƒ  } | j d | ƒ d | d <t	 j
 t | j d | ƒ Wd  QXd  S(   NR=   t   invalidR€   t   invalid2t   invalid3iÑ  i   i   R~   i    i   i
   R‰   (   RF   R3   RR   Rg   RC   t   dtypesRº   t   object_Rh   Rc   Rd   RŽ   Rw   R   Rµ   R~   Rb  RV  R»   Rÿ   RM   (   RY   R7   R€   RÄ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_raiseþ  s,    $
"
c         C   s¡   t  i d d d g d 6ƒ } t  i d d d g d 6d t d	 d
 d ƒƒ} t |  j ƒ B } | j d | d d ƒt j t | j d | d d d t ƒWd  QXd  S(   Ni   i   i   R=   i   i   i   R~   s   1/1/2000R¯  Rr   Ra   Rb   Rw   (	   R   R   RF   R3   R–   Rc   Rd   RŽ   R{   (   RY   RÇ   R‘   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt$   test_table_index_incompatible_dtypes&  s    c         C   s\  t  |  j ƒ G} t i d d d g d 6d d ƒ} | j d | ƒ t | j | d j ƒ t i d d d g d 6d d ƒ} | j d	 | ƒ t | j | d	 j ƒ t j t | j d	 | ƒ t t	 j
 d g d g d g g d d
 ƒd d g ƒ} | j d | ƒ t | j | d j ƒ | j d d k s3t ‚ t d „  d d d d d d g Dƒ ƒ } d | d <d | d <| d j d ƒ | d <| d d k | d <t d ƒ | d <t d ƒ | d <| j d | ƒ | j d ƒ j ƒ  } t i	 d d 6d d 6d d 6d d 6d d 6d d 6d d 6d d  6d d! 6ƒ } | j ƒ  } | j ƒ  } t j | | ƒ Wd  QXd  S("   Ni   i   i   R=   Rè   t   f8t   df_f8t   i8t   df_i8t   f4R6  Ru   t   df_f4i    Rô  c         S   s1   i  |  ]' } t  t j j d  ƒ d | ƒ| “ q S(   i   Rè   (   R   Rº   R  R*  (   R|  R›   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pys
   <dictcomp>G  s   	Rw  R\  Ru  Rv  t   int8R‰   R“  g      ð?Ró  Rõ  Rö  R÷  Rø  Rù  t   df_mixed_dtypes1RV  s   datetime64[ns](   RF   R3   R   Rw   R!   R  Rc   Rd   RM   Rº   Rë   Rh   Rb  R   R†   t   get_dtype_countsR   t
   sort_indexRR   (   RY   R7   RÇ   R‘   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt"   test_table_values_dtypes_roundtrip0  s<    ""3		

c         C   s  t  j ƒ  } d | d <d | d <| d d k | d <| d d k | d	 <t | d
 <d | d <d | d <t d ƒ | d <t d ƒ | d <t j d d d d d ƒ | d <t j d d d d d ƒ | d <t j | j d d … d g f <| j ƒ  j	 d t ƒ } t
 |  j ƒ 0 } | j d | ƒ t  j | j d ƒ | ƒ Wd  QXt d t ƒ m t  j ƒ  } d | d <d | d <| d d k | d <| d d k | d	 <d | d <d | d <| j ƒ  } Wd  QXt d t ƒ C t
 |  j ƒ - } | j d | ƒ t | j d ƒ | ƒ Wd  QXWd  QXd  S(   NR‰   R¨   RŠ   R©   Ru   i    Rª   Rv   R«   R¬   i   R­   i   R®   R¯   R°   R±   R²   iÑ  R³   i   R´   i   Rµ   t	   df1_mixedRs   R²  RÍ  t   p1_mixed(   RR   Rg   R{   R   Rµ   Rº   R»   R¼   R½   R¾   RF   R3   Rw   R   R†   R   R|   R    (   RY   R€   R7   R/  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_table_mixed_dtypesZ  s<    








c      
   C   s+  t  |  j ƒ ” } d t j d d d ƒ f g } t j sU | j d t d ƒ f ƒ n  xG | D]? \ } } t j	 ƒ  } | | | <t
 j t | j d | | ƒ q\ WWd  QXt j	 ƒ  } d | d	 <d
 | d <t j d d d ƒ | d <| j ƒ  j d t ƒ } t  |  j ƒ   } t
 j t | j d | ƒ Wd  QXd  S(   NRá  iÑ  i   i   t   unicodes   \u03c3s   df1_%sR‰   R¨   RŠ   R©   R³   Rµ   t   df_unimplemented(   RF   R3   Rµ   Rá  R   RF  Rw   R   RR   Rg   Rc   Rd   RŽ   R½   R¾   R{   (   RY   R7   R  t   nRK   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt'   test_unimplemented_dtypes_table_columns‚  s     	
!

s   1.15.0sO   Skipping  pytables test when numpy version is exactly equal to 1.15.0: gh-22098c   	      C   s  d } d t  j  d d d ƒ t j d ƒ g } t j j d | d | ƒ } t  j  d d	 d
 ƒ } t | d d d | ƒ} t | j | ƒ j	 t d j
 ƒ  ƒ ƒ } t |  j ƒ _ } | j d | ƒ | j d ƒ } t | | ƒ | j d | ƒ | j d ƒ } t | | ƒ Wd  QXd  S(   Ns   Sun Mon Tue Wed Thus
   2012-05-01iÝ  i   i   s
   2014-05-01t   holidayst   weekmaski   i   R¯  t   freqs   Mon Tue Wed Thu Fri Sat SunRˆ   Rb   (   Rµ   Rº   t
   datetime64R”   t   offsetst   CustomBusinessDayR   R   t   weekdayt   mapt   splitRF   R3   R–   R†   R!   Rw   (	   RY   t   weekmask_egyptR  t
   bday_egyptt   dtt   dtsRÄ   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_calendar_roundtrip_issuež  s     	$c      	   C   s›   t  j d d d ƒ} t  j d d g d | g ƒ } t |  j ƒ S } | j d | d d	 ƒ| d } t j | | ƒ | j d j	 d
 k s‘ t
 ‚ Wd  QXd  S(   Ns   2000-01-01 01:00:00t   tzs
   US/EasternR   i    R~   Rr   Ra   Rˆ   I À–vt`#(   R”   R   R   RF   R3   R–   RR   R   R~   t   valueRh   (   RY   t   timeR€   R7   t   recons(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_roundtrip_tz_aware_index¼  s    
c         C   sø  t  t d t d ƒ d g  t d ƒ D]% } t d ƒ t d | d d ƒ ^ q" ƒ ƒ } | d | d | d <t j | j d d	 … d f <t |  j	 ƒ ^} t
 | d
 ƒ | j d
 | d t ƒ| j d
 ƒ } t | | ƒ | j d
 d d ƒ} t | | ƒ | j d
 d d ƒ} t | | j d ƒ | j d
 d ƒ } t | | j d ƒ | j d
 d ƒ } | j d d g ƒ } t | | j d ƒ | j d
 d ƒ } | j d } t | | j d ƒ t
 | d ƒ | j d | ƒ | j d ƒ } t | | ƒ Wd  QXd  S(   NRu   Rö  Rv   i
   t   dayst   secondsR7  i   i   R€   R„   Rx   s   C<100000s   C<pd.Timedelta('-3D')s   C<'-3D's   C<'-500000s't   subseti   s	   C<'-3.5D'i   i   R‘   (   R   R}   R   R   R   Rº   R»   R¼   RF   R3   RP   Rw   R{   R†   R   RŒ   Re  R–   (   RY   R   R€   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_with_timedeltaÇ  s2    ;c         C   su  t  |  j ƒ `} t j ƒ  } t j ƒ  } | | d <| | d <t | d ƒ t | ƒ d k sc t ‚ t j | | d ƒ t | d ƒ t | ƒ d k sœ t ‚ t	 j
 t | j d ƒ | | d <| | d <t | d ƒ t | d ƒ t | ƒ d k sø t ‚ | | d <| | d <t | d ƒ t | ƒ d k s1t ‚ | | d <| | d <| d =| d =t | ƒ d k skt ‚ Wd  QXd  S(   NR=   Rš   i   i    t   a_nonexistent_stores   b/fooR‰   (   RF   R3   RR   Ry   Rg   RP   RC   Rh   R   Rc   Rd   RN   R1   (   RY   R7   Rü   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_removeñ  s2    







c         C   sF  t  |  j ƒ 1} t d t ƒ d } t j t | j d | g ƒ t j	 d ƒ } | j
 d | d d ƒ| j d d g ƒ | j d ƒ } | j d	 d
 d g ƒ } t | | ƒ t | d ƒ | j
 d | d d ƒ| j d g  ƒ } | d k s÷ t ‚ t | d ƒ | j
 d | d d ƒt j t | j d d g ƒ Wd  QXWd  QXd  S(   NRs   s	   index>fooR=   i   R/  Ra   Rb   s   minor_axis=['A', 'D']Rm  Rv   R7  ix   R‰   (   RF   R3   R   R{   Rc   Rd   RN   R1   RR   R|   R–   R†   R)  R    RP   Rh   RM   (   RY   R7   t   crit1R/  t   rsRŸ   R  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_remove_where	  s$    c         C   s  t  |  j ƒ } t d t ƒ ðt j d ƒ } t | d ƒ | j d | d d ƒ| j d d d ƒ} | d k s{ t	 ‚ | j
 d ƒ } | j d	 | j d  ƒ } t | | ƒ t | d ƒ | j d | d d ƒ| j d d d ƒ} | d k sú t	 ‚ | j
 d ƒ } | j d	 | j d  ƒ } t | | ƒ t | d ƒ | j d | d d ƒ| j d d d ƒ} | d k syt	 ‚ | j
 d ƒ } | j d	 | j d ƒ } t | | ƒ t | d ƒ | j d | d d ƒ| j d d d ƒ} | d  k søt	 ‚ | j
 d ƒ } | j d	 | j d! ƒ } t | | ƒ t | d ƒ | j d | d d ƒ| j d d d d d ƒ} | d" k s}t	 ‚ | j
 d ƒ } | j d	 | j d#  j | j d$ ƒ ƒ } t | | ƒ t | d ƒ | j d | d d ƒ| j d d d d d ƒ} | d k st	 ‚ | j
 d ƒ } | j d	 | j ƒ } t | | ƒ t | d ƒ | j j t j d d d ƒ ƒ } d } | j d | d d ƒ| j d d | g d d ƒ} | d k s½t	 ‚ | j
 d ƒ } | j d	 | j j | j t j d d d ƒ ƒ ƒ } t | | ƒ Wd  QXWd  QXd  S(%   NRs   i   R  Ra   R¾  t   starti    ix   Rl  i   RŸ  iàÿÿÿt   wp3t   stopt   wp4t   wp5i   iðÿÿÿt   wp6i    t   wp7i   s   major_axis=dateRx   iP   i   i   iX   i   iøÿÿÿi   iX   iøÿÿÿiX   i   iüÿÿÿ(   RF   R3   R   R{   RR   R|   RP   R–   R1   Rh   R†   R)  Rl  R    t   uniont   takeRº   Rÿ   t
   difference(   RY   R7   R/  R  R   RŸ   Rá  t   crit(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_remove_startstop7	  sr    	!"c         C   s¬  t  |  j ƒ —} t d t ƒ t j d ƒ } t | d ƒ | j j d d d d d d	 d
 d d g	 ƒ } d } | j	 d | d d ƒ| j
 d d | g ƒ} | d k s± t ‚ | j d ƒ } | j d | j j | ƒ ƒ } t | | ƒ t | d ƒ | j	 d | d d ƒ| j t | j ƒ d } d }	 d }
 | j
 d d |	 g ƒ} | d k s^t ‚ | j
 d d |
 g ƒ} | d k sˆt ‚ | d } | j d | ƒ j d d d g ƒ } t | | ƒ t | d ƒ | j	 d | d d ƒ| j d d !} d }	 | j
 d d |	 g ƒ| j d ƒ } | j d | j j | ƒ ƒ } t | | ƒ | j d } d  }
 | j
 d d |
 g ƒ| d } | j d | j j | ƒ j t | g ƒ ƒ ƒ } t | | ƒ | j d! | j d g } d" } | j
 d d | g ƒ| d } | j d | j j | ƒ j t | g ƒ ƒ j t | ƒ ƒ ƒ } t | | ƒ t | d# ƒ | j	 d# | d d ƒ| j
 d# d d$ ƒ} | j d# ƒ } t | | ƒ Wd  QXWd  QXd  S(%   NRs   i   R5  i    i   i   i   i   i   i   i	   i
   s   major_axis=date4Ra   R¾  Rx   i$   Rl  R/  Rb   s   major_axis>dates   minor_axis=['A', 'D']i8   i    t   aftert   minorRv   R7  RŸ  i   s   major_axis=date1s   major_axis=date2i   s   major_axis=date3R7  s   major_axis>wp.major_axis[-1](   RF   R3   R   R{   RR   R|   RP   Rl  R<  R–   R1   Rh   R†   R)  R=  R    RC   t   truncateR   (   RY   R7   R/  t   date4t   crit4R  R   RŸ   Rá  R1  t   crit2t   date1t   date2t   date3t   crit3(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_remove_critƒ	  st    -	
$	
			
	c         C   s[  t  |  j ƒ 0} t d t ƒ t j ƒ  } d | d <d | j d d … d f <t j ƒ  } | j d | d d	 ƒ| j d
 | d d	 ƒt	 j
 t | j d
 d ƒ t	 j
 t | j d
 d g ƒ t	 j
 t | j d
 d g ƒ t	 j
 t t ƒ t	 j
 t | j d d ƒ t	 j
 t | j d d ƒ t	 j
 t | j d
 d ƒ Wd  QXWd  QXt |  j ƒ ‚ } t t j j d d ƒ d t d ƒ d t d d d ƒƒ} | j | d d d	 d t ƒt | d d d ƒt | d d d ƒWd  QXt |  j ƒ r } t t j j d d ƒ d t d ƒ d t d d d ƒƒ} | j | d d d	 ƒt	 j
 t t | d d d ƒWd  QXd  S(   NRs   R‰   R“  RŠ   i    i   R€   Ra   Rb   R/  s   minor=['A', 'B']s   index=['20121114']s   index=['20121114', '20121114']s   df.index[3]s   index>s,   major_axis<'20000108' & minor_axis['A', 'B']i
   R6  RÜ  R~   Rö  R¯  t   dfqR„   Rx   s0   index>Timestamp('20130104') & columns=['A', 'B']s
   A>0 or C>0(   RF   R3   R   R{   RR   RÈ   R¼   R|   R–   Rc   Rd   RM   R†   RŽ   R(   t   SyntaxErrorRL   R   Rº   R  R  RH   R   Rl   R)   (   RY   R7   R€   R/  R3   RK  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_invalid_termsÑ	  sD    


c   
      C   sG  t  |  j ƒ 2} t d t ƒ t d t ƒ t j ƒ  } t j	 i t j
 ƒ  d 6t j
 ƒ  d 6t j
 ƒ  d 6ƒ } | j d | d d ƒ| j d	 | d d ƒ| j d d
 ƒ } | j d d ƒ j d d d g ƒ } t | | ƒ | j d d d
 ƒ} | j d d ƒ j d d d g ƒ } t j | | ƒ Wd  QXt d t ƒ | d d d" d d d d d# d$ d& d' d g } x | D] } | j d | ƒ qpWt j t d d ƒ | j d d ƒ Wd  QXWd  QXt d t ƒ p | j d	 d ƒ } t i | d d 6ƒ } t j | | ƒ d  }	 t j t d |	 ƒ | j d	 d! ƒ Wd  QXWd  QXWd  QXd  S((   NRs   R¶   iÿÿÿÿi    i   R/  Ra   Rb   t   wpnegs/   major_axis<'20000108' and minor_axis=['A', 'B']R@  t   20000108RA  Ru   Rv   Rx   s   major_axis=20121114s   major_axis>20121114s#   major_axis=['20121114', '20121114']s*   major_axis=datetime.datetime(2012, 11, 14)s   major_axis> 20121114s   major_axis >20121114s   major_axis > 20121114s   minor_axis=['A', 'B']s   minor_axis==['A', 'B']s   items=['ItemA', 'ItemB']s   items=ItemAt   matchs"   Only named functions are supporteds'   major_axis == (lambda x: x)("20130101")s   items == -1s   Unary addition not supporteds   items == +1(   s#   major_axis=['20121114', '20121114'](   s   minor_axis=['A', 'B'](   s   minor_axis=['A', 'B'](   s   minor_axis==['A', 'B'](   (   s   minor_axis==['A', 'B'](   s   items=['ItemA', 'ItemB'](   RF   R3   R   R{   R   R™  RR   R|   R   t   fromDictRg   R–   R†   RB  R)  R    Rc   Rd   RŽ   t   NotImplementedError(
   RY   R7   R/  RN  R   RŸ   t   termsR¾  t   rest   msg(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt
   test_terms
  s^    				
c         C   së  t  |  j ƒ +} t d t ƒ t t j j d d d ƒ d d d g d t d	 d
 d ƒd d d d d g ƒ} | j	 d | ƒ | j
 d d d ƒ} | j d  d  … | j t d ƒ k d d g f } t | | ƒ | j d d ƒ | j
 d ƒ } | j d  d  … | j t d ƒ k d  d  … f } t | | ƒ Wd  QXWd  QXt  |  j ƒ š} t d t ƒ ‚t t j j d d d ƒ d d d g d t d	 d
 d ƒd d d d d g ƒ} | j	 d | ƒ | j
 d d ƒ } | j d  d  … | j t d ƒ k f } t | | ƒ | j
 d d ƒ } | j d  d  … | j t d ƒ k f } t | | ƒ | j
 d d ƒ } | j d  d  … t d ƒ t d ƒ g f } t | | ƒ | j
 d d ƒ } | j d  d  … d  d  … d d g f } t | | ƒ Wd  QXWd  QXd  S(   NRs   i   i   i   R  Ri  Rj  Rl  s   1/1/2000R¯  Rm  Ru   Rv   R7  R`  R/  Rx   s-   major_axis>20000102 and minor_axis=['A', 'B']t   20000102s   major_axis>20000103t   20000103s(   major_axis>datetime.datetime(2000, 1, 2)sU   major_axis=[datetime.datetime(2000, 1, 2, 0, 0), datetime.datetime(2000, 1, 3, 0, 0)]s   minor_axis=['A', 'B'](   RF   R3   R   R{   R   Rº   R  R  R   Rw   R†   R¼   Rl  R   R    R1   (   RY   R7   R/  R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_term_compatG
  sP    '1((	(c         C   s  t  |  j ƒ î } d d  l } t t j j d d ƒ d | j d d d ƒƒ} | j d | d d	 ƒ| | j	 | j
 d
 ƒ k } d d  l } | j d d ƒ } t | | ƒ d d l m } | j d d ƒ } t | | ƒ | j d d ƒ } t | | ƒ Wd  QXd  S(   Niÿÿÿÿi   i   R~   Rö  R¯  R€   Ra   Rb   t   20130105s!   index>datetime.datetime(2013,1,5)(   Rµ   s   index>datetime(2013,1,5)(   RF   R3   t   pandasR   Rº   R  R  R   R–   R~   R   Rµ   R†   R   (   RY   R7   R”   R€   RŸ   Rµ   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_same_name_scoping}
  s    c         C   s¿   t  j ƒ  } |  j | t  j ƒ t  j ƒ  } |  j | t  j ƒ t | j t | j d t ƒƒ } |  j | t  j ƒ t | j	 t t
 j | j d t ƒd t ƒƒ } |  j | t  j d t ƒd  S(   NRè   R¬  (   RR   Rz   R  R!   Ry   R   R~   R   RV  RW  Rº   t   asarrayRE   (   RY   RÄ   Rü   t   ts2t   ts3(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_series”
  s    !$c         C   sž   t  j ƒ  } t j | j d d +| j ƒ  } |  j | t  j d t ƒ| j d d ƒ } |  j | t  j d t ƒ| j d d ƒ } |  j | t  j d t ƒd  S(   Ni   i   t   check_series_typeRÅ  t   integert
   fill_valuei    (	   RR   Rz   Rº   R»   RŒ   t	   to_sparseR  R!   R{   (   RY   RÄ   R4  R  R  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_sparse_series¤
  s    c         C   sÉ   t  j ƒ  } t j | j d d … d d … f <t j | j d d … d f <| j ƒ  } |  j | t  j d t ƒ| j d d	 ƒ } |  j | t  j d t ƒ| j d
 d ƒ } |  j | t  j d t ƒd  S(   Ni   i   i   i   i
   iþÿÿÿt   check_frame_typeRÅ  Rb  Rc  i    (	   RR   Rg   Rº   R»   RŒ   Rd  t   _check_double_roundtripR   R{   (   RY   RÄ   R4  R  R  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_sparse_frame´
  s    "c         C   sG   t  j j d ƒ } t t  j j d ƒ d | ƒ} |  j | t j ƒ d  S(   Ni
   R~   (   Rº   R  R  R   R  RR   R!   (   RY   R~   RÄ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_float_indexÆ
  s    c         C   s‘   t  j d ƒ } d d d g } t  j j d ƒ j d ƒ } t | d
 | d | ƒ} t d t ƒ + t d t	 j
 j ƒ |  j | t j ƒ Wd  QXd  S(   Ni
   g        g      ð?g       @g      @g      @g      @i   i   R~   R6  Rs   R¶   (   g        g      ð?(   g       @g      @(   g      @g      @(   i   i
   (   Rº   Rÿ   R  R  RÞ  R   R   R{   R   R”   R¿   RÀ   R  RR   R   (   RY   RÀ  Rì  R   t   DF(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_tuple_indexÍ
  s    s(   ignore::pandas.errors.PerformanceWarningc         C   s¡  t  d t ƒ   t j j d ƒ } d „  } Wd  QXt  d t ƒ * t | d d g ƒ } |  j | | ƒ Wd  QXt  d t ƒ 3 t | t j j ƒ  d g ƒ } |  j | | ƒ Wd  QXt  d t ƒ * t | d d g ƒ } |  j | | ƒ Wd  QXt  d t ƒ 3 t | t j	 j ƒ  d g ƒ } |  j | | ƒ Wd  QXt  d t ƒ ]t | d d g ƒ } |  j | | ƒ t | t j j ƒ  d g ƒ } |  j | | ƒ t | d d g ƒ } |  j | | ƒ t | t j	 j ƒ  d g ƒ } |  j | | ƒ t | d d g ƒ } |  j | | ƒ t | d	 d
 g ƒ } |  j | | ƒ t | d	 d g ƒ } |  j | | ƒ t | t j d d	 d	 ƒ t j d d	 d ƒ g ƒ } |  j | | ƒ Wd  QXd  S(   NRs   i   c      	   S   s"   t  j |  | d t d t d t ƒS(   NRO  R¬  Ra  (   RR   R!   R{   (   t   lRÎ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   <lambda>á
  s   i    RX  R=   g®Gáz®ó?Rš   i   g{®Gázø?i   iÜ  (
   R   R{   Rº   R  R  R   R  Rµ   t   todayRá  (   RY   RW  t   funcR¥  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_index_typesÚ
  sB    'c         C   so   t  d d ƒ } t t j j t | ƒ ƒ d | ƒ} y |  j | t j ƒ Wn t	 k
 rj t
 j d ƒ n Xd  S(   Ns   1/1/1940s   1/1/1960R~   s&   known failer on some windows platforms(   R   R   Rº   R  R  RC   R  RR   R!   t   OverflowErrorRc   RU  (   RY   t   drRü   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_timeseries_preepoch  s    $t   compressionc         C   sû   t  j ƒ  } t j | j d <t j | j d <|  j | t  j d | ƒ|  j | t  j d | ƒt  j ƒ  } |  j | t  j d | ƒt	 |  j
 ƒ L } t j j t | ƒ ƒ | d <| | d <| d } | j j ƒ  sÚ t ‚ Wd  QX|  j | d  t  j ƒ d  S(	   Ni    i   i   Rt  R‰   R€   (   i    i    (   i   i   (   RR   Rg   Rº   R»   RW  t   _check_roundtrip_tableR   R  RÈ   RF   R3   R  R  RC   t   _datat   is_consolidatedRh   (   RY   Rt  R€   t   tdfR7   R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt
   test_frame  s     

c         C   s´   t  ƒ  } t  d d ƒ } t ƒ  } t d d d d g ƒ } t d d d	 d
 g ƒ } |  j | t j ƒ |  j | t j ƒ |  j | t j ƒ |  j | t j ƒ |  j | t j ƒ d  S(   NR:  t   myseriesR~   R=   Rš   R›   R6  Rœ   R§   RK   (   R   R   R  RR   R!   R   (   RY   t   s0Ræ   t   df0RÇ   R‘   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_empty_series_frame9  s    		Rè   s   m8[ns]s   M8[ns]c         C   s&   t  d | ƒ } |  j | t j ƒ d  S(   NRè   (   R   R  RR   R!   (   RY   Rè   RÄ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_empty_seriesG  s    c         C   sf   g  t  d d ƒ D] } | j ƒ  ^ q } t t j j t | ƒ d ƒ d | ƒ} |  j | t j	 ƒ d  S(   Ns   1/1/2000s	   1/30/2000i   R~   (
   R   Rá  R   Rº   R  R  RC   R  RR   R   (   RY   Rú   t   rngRr   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_can_serialize_datesN  s    ('c         C   s.  t  d d d d d g d d d g g d	 d
 d
 d
 d d d d d d d g
 d
 d d d
 d d d d
 d d g
 g d d d g ƒ } t t j j d d ƒ d | d d d d g ƒ} |  j | t j ƒ |  j | j t j ƒ |  j | d t j	 ƒ t
 |  j ƒ + } | | d <| d } t j | | ƒ Wd  QXd  S(   NRÐ  R‰   RŠ   RÑ  RÒ  RÓ  RÔ  RÕ  RÖ  i    i   i   i   R×  i
   R~   R6  Ru   Rv   R7  Rr   (   R   R   Rº   R  R  R  RR   R   t   TR!   RF   R3   (   RY   R~   Rr   R7   R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_hierarchicalU  s    !'

c         C   sX   t  j ƒ  } d | j _ t |  j ƒ + } | | d <| d } t  j | | ƒ Wd  QXd  S(   NR‰   Rr   (   RR   Rg   R~   R:  RF   R3   R   (   RY   R€   R7   R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_index_nameh  s    

c      	   C   s¡   t  j i d d g d 6ƒ } t  j d d g ƒ | _ | j j d ƒ | _ d | j _ t |  j ƒ 7 } | j d | d	 d
 ƒ| d } t	 j
 | | ƒ Wd  QXd  S(   Ni   i   Ru   Ié}ô"Ié}ô"t   UTCR‰   Rr   Ra   Rb   (   R”   R   R   R~   t   tz_localizeR:  RF   R3   R–   RR   R   (   RY   R€   R7   R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_index_name_with_tzq  s    
t   table_formatc      	   C   sP  t  j t  j t j d d d ƒ t j d d d ƒ g ƒ d t d ƒ ƒ} t  j t  j t j d d d ƒ t j d d d ƒ g ƒ d t d ƒ ƒ} t  j t j d ƒ j	 d d ƒ d	 | d
 | ƒ} t
 |  j ƒ { } | j | d d | ƒt | d ƒ } t | | d t ƒt | j j ƒ t k s(t ‚ t | j j ƒ t k sFt ‚ Wd  QXd  S(   NiÐ  i   i   R:  s
   cols\u05d2iÚ  s
   rows\u05d0i   R6  R~   R€   Ra   t   check_names(   R”   R   t   to_datetimeRµ   Rá  R   R   Rº   Rÿ   RÞ  RL   R3   Rl   R)   R   R{   Ri   R~   R:  R   Rh   R6  (   RY   R‡  Rì  t   idx1R€   R3   R‘   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_index_name_numpy_str}  s    0c         C   sV   t  j ƒ  } | d } t |  j ƒ + } | | d <| d } t  j | | ƒ Wd  QXd  S(   NRu   Rp   (   RR   Rg   RF   R3   R!   (   RY   R€   Rp   R7   R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_series_name’  s    


c         C   sð   d „  } | ƒ  } | ƒ  } |  j  | t j ƒ |  j  | t j ƒ t |  j ƒ C } | | d <t j | d | ƒ | | d <t j | d | ƒ Wd  QX|  j  | d t j d | ƒ|  j  | d t j d | ƒ|  j  | d t j d | ƒd  S(   Nc          S   sf   t  j ƒ  }  d |  d <d |  d <|  d d k |  d <|  d d k |  d	 <d
 |  d <d |  d <|  j ƒ  S(   NR‰   R¨   RŠ   R©   Ru   i    Rª   Rv   R«   i   R­   i   R®   (   RR   Rg   R½   (   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   _make_one¡  s    



Rm   R¨   Rt  Rª   R­   (   R  RR   R   RF   R3   R!   (   RY   Rt  R  RÇ   R‘   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_mixed›  s     	
		

c         C   s6   t  d t ƒ ! t j ƒ  } |  j | t ƒ Wd  QXd  S(   NRs   (   R   R{   RR   R|   R  R    (   RY   R/  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_wide¿  s    s6   ignore:\nduplicate:pandas.io.pytables.DuplicateWarningc         C   sG  t  t j j d d ƒ d d d d d g ƒ} t d d d d d	 ƒ| _ t |  j ƒ ± } | j d
 | ƒ | j	 d
 ƒ } | } t
 | | d t ƒ| j	 d
 d | j ƒ} | } t
 | | d t ƒ| j	 d
 d d g ƒ} | j d  d  … d g f } t
 | | ƒ Wd  QXt t  t j j d d ƒ d d d d d g ƒt  t j j d d d d ƒj d d ƒ d d d g ƒg d d ƒ} t d d d d d	 ƒ| _ t |  j ƒ } | j d
 | ƒ | j	 d
 ƒ } | } t
 | | d t ƒ| j	 d
 d | j ƒ} | } t
 | | d t ƒ| j d  d  … d g f } | j	 d
 d d g ƒ} t
 | | d t ƒ| j d  d  … d d g f } | j	 d
 d d d g ƒ} t
 | | d t ƒWd  QXt |  j ƒ † } | j d
 | ƒ | j d
 | ƒ | j d  d  … d d g f } t | | g ƒ } | j	 d
 d d d g ƒ} t
 | | d t ƒWd  QXd  S(   Ni
   i   R6  Ru   Rv   s   20130101 9:30R¯  R  R  R€   t	   by_blocksi    Rƒ   i   i   R7  R  i   (   R   Rº   R  R  R   R~   RF   R3   Rw   R†   R   R{   R6  R¼   R   R*  RÞ  (   RY   R€   R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_with_dupsÅ  sR    -	c         C   s‡   t  |  j ƒ r } t d t ƒ Z t j ƒ  } | j d | d d ƒ| j d | d d d t ƒ| d } t | | ƒ Wd  QXWd  QXd  S(   NRs   Rt   Ra   Rb   Rw   (   RF   R3   R   R{   RR   R|   R–   R    (   RY   R7   R/  R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_wide_table_dups  s    
c         C   sE   d „  } t  d t ƒ ' t j ƒ  } |  j | j ƒ  | ƒ Wd  QXd  S(   Nc         S   s   t  |  j ƒ  | j ƒ  ƒ d  S(   N(   R    t   to_panel(   Rß   Rà   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   _check  s    Rs   (   R   R{   RR   R|   R  Rº  (   RY   R”  R/  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_long  s    	c         C   sV   t  |  j ƒ A } t j ƒ  | d <t j ƒ  } | | d <t j | d | ƒ Wd  QXd  S(   NR=   (   RF   R3   RR   RÈ   Ry   R!   (   RY   R7   Rü   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_overwrite_node  s
    
c         C   sÌ   t  j j d d d d d d ƒ } t | ƒ j d d	 ƒ } |  j | t j d
 t d t	 ƒ|  j | t j d
 d d t	 ƒt  j
 d ƒ | d	 <|  j | t j d
 t d t	 ƒ|  j | t j d
 d d t	 ƒd  S(   NR  i   RI   g{®Gáz„?Rƒ   iè  i
   Rc  i    Rt  Rf  R.   (   iè  i
   (   Rº   R  t   binomialR   Rd  Rg  RR   R   RE   R{   Rä  (   RY   t   arrR€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_sparse_with_compression#  s    !c         C   s™  t  |  j ƒ „} t d t ƒ lt j ƒ  } t | d ƒ | j d | d d ƒ| j d ƒ t | d ƒ | j d | ƒ | j d ƒ t	 t
 j j d d d ƒ d g  t d ƒ D] } d | ^ q° d	 t d
 d d ƒd g  t d ƒ D] } d | ^ qå ƒ} t | d ƒ | j d | ƒ g  t d ƒ D] } d | ^ q(} | j d d ƒ } | j d | ƒ } t | | ƒ t j ƒ  } t | d ƒ | j d | ƒ | j d d d d g ƒ} | j d d d g ƒ } t j | | ƒ | j d d g ƒ } | j d d d g ƒ } t j | | ƒ t | d ƒ | j d | d d g ƒ| j d d g d d d g ƒ} | | j d k j d d d g ƒ } t j | | ƒ t | d ƒ | j d | d t ƒ| j d d g d d d g ƒ} | | j d k j d d d g ƒ } t j | | ƒ t | d ƒ | j d | d d g ƒ| j d d g d d d g ƒ} | | j d k j d d d g ƒ } t j | | ƒ Wd  QXWd  QXd  S(   NRs   R/  Ra   Rb   RŸ  id   R  s   Item%03dRl  s   1/1/2000R¯  Rm  s   E%03diP   s   items=itemsR€   R6  Ru   Rv   s   columns=['A', 'B']R„   s   A > 0i    R7  R`  (   RF   R3   R   R{   RR   R|   RP   R–   R†   R   Rº   R  R  R   R   Rw   R)  R    RÈ   R   Ru   (   RY   R7   R/  R   R  R   RŸ   R€   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_selectC  sV    #&#!%!%!%c         C   s±  t  |  j ƒ \} t t d t d d d ƒd t j j d ƒ ƒ ƒ } t | d ƒ | j	 d | d d d g ƒ| j
 d d ƒ } | | j t d	 ƒ k } t j | | ƒ t t j j d
 d ƒ d d d g ƒ} d | d <d | j d d
 … d f <| d d k | d <t | d ƒ | j	 d | d t ƒ| | j t k j d d d g ƒ } xO t d d g D]> } | j
 d d t | ƒ d d d g ƒ} t j | | ƒ q_W| | j t k j d d d g ƒ } xO t d d g D]> } | j
 d d t | ƒ d d d g ƒ} t j | | ƒ qÖWt t d t j j d ƒ d t j j d ƒ ƒ ƒ } t | d ƒ | j	 d | ƒ | j
 d d ƒ } | j d t | j ƒ d d !d d g ƒ } t j | | ƒ t t d t j j d ƒ d t j j d ƒ d t j d d d ƒƒ ƒ } t | d ƒ | j	 d | ƒ | j
 d d  ƒ } | j d t | j ƒ d d !d d g ƒ } t j | | ƒ Wd  QXt  |  j ƒ ª} t t d! t d" ƒ d# t d" ƒ ƒ d d$ ƒ} | d! d j t ƒ | d! <| j	 d% | d t ƒ| j
 d% d& d' ƒ} | | d# d( k } t j | | ƒ t j | j d <| | d# d( k } | j	 d) | d t d t ƒ| j
 d) d& d' ƒ} t j | | ƒ t t d! t d" ƒ d# t d" ƒ ƒ d d$ ƒ} | d! d j t ƒ | d! <t j | j d <| | d# d( k } | j	 d* | d t ƒ| j
 d* d& d' ƒ} t j | | ƒ Wd  QXt  |  j ƒ t } t j ƒ  } | | d d k } | j	 d | d t ƒt j d ƒ } | j
 d d& d+ g ƒ} t j | | ƒ Wd  QXd  S(,   NRü   s
   2012-01-01R¯  i,  Ru   R€   R„   s   ts>=Timestamp('2012-02-01')s
   2012-02-01i   i   R6  Rv   R‰   RV  RŠ   i   i    t   boolvt   truei   s   boolv == %st   falsei   t   df_ints   index<10 and columns=['A']R~   i
   Rè   R  t   df_floats   index<10.0 and columns=['A']R¶  i   RW  Rw  RÇ   Rx   s
   values>2.0g       @R‘   R“   s	   A>np_zero(   RF   R3   R   R}   R   Rº   R  R  RP   Rw   R†   Rü   R   RR   R   R¼   R{   R›  R)  RÃ   RE   Rû  RH   R~   Rÿ   R   t   applyR»   RŒ   Rg   Rw  (   RY   R7   R€   R   RŸ   t   vt   np_zero(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_dtypes‡  s’    	'
"3+6+*
*c         C   s£  t  |  j ƒ Ž} t t d t d d d ƒd t j j d ƒ d t d ƒ d d g d	 d
 g d	 d g d g  t d ƒ D] } d | ^ qx ƒ ƒ } t	 | d ƒ | j
 d | d d d d d g ƒ| j d d ƒ } | | j t d ƒ k } t j | | ƒ | j d d ƒ } | | j t d ƒ k | j j d d
 d g ƒ @} t j | | ƒ d d
 d g g  t d ƒ D] } d | ^ ql} | j d d ƒ } | | j t d ƒ k | j j | ƒ @} t j | | ƒ t d d ƒ } | j d d ƒ } | | j j | ƒ } t j | | ƒ t | ƒ d k s-t ‚ t | j d d !j ƒ } | j d d ƒ } | | j j | j ƒ } t j | | ƒ t | ƒ d k s™t ‚ Wd  QXd  S(   NRü   s
   2012-01-01R¯  i,  Ru   Rv   t   usersR=   i2   Rš   R›   id   s   a%03dR€   R„   s   ts>=Timestamp('2012-02-01')s
   2012-02-01s1   ts>=Timestamp('2012-02-01') & users=['a','b','c']i<   s.   ts>=Timestamp('2012-02-01') and users=selectoriÈ   s
   B=selectori    s   ts=selector(   RF   R3   R   R}   R   Rº   R  R  R   RP   Rw   R†   Rü   R   RR   R   R¤  R»  Rv   RC   Rh   R   RW  (   RY   R7   R   R€   R   RŸ   t   selector(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_with_many_inputsô  sD     *"	0	c   
      C   sT  t  |  j ƒ &} t j d ƒ } t | d ƒ | j d | ƒ | j d ƒ } g  | j d d t ƒD] } | ^ qc } t | ƒ } t j	 | | ƒ g  | j d d d ƒD] } | ^ q§ } t
 | ƒ d k sÑ t ‚ t | ƒ } t j	 | | ƒ g  | j d d d ƒD] } | ^ q} t | ƒ } t j	 | | ƒ Wd  QXt |  j ƒ ^ } t j d ƒ } | j | d ƒ t j t t | d d d ƒt j t t | d d t ƒWd  QXt |  j ƒ ¡ } t j d ƒ } | j | d d	 d
 ƒg  t | d d d ƒD] } | ^ qó} t | ƒ } t
 | ƒ d k s)t ‚ t j	 | | ƒ t j	 | t | d ƒ ƒ Wd  QXt  |  j ƒ ç } t j d ƒ } | j d | d t ƒt j d ƒ j d d „  ƒ }	 d |	 d <| j d |	 ƒ t | |	 g d d ƒ} | j d d g d d ƒ} g  | j d d g d d d d ƒD] } | ^ q} t | ƒ } t j	 | | ƒ Wd  QXd  S(   Niô  R€   t   iteratorRð  id   i   i–   t   df_non_tableRa   Rb   RÇ   R„   R6  c         S   s   d |  S(   Ns   %s_2(    (   Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  W  s    RŠ   R‰   R‘   R  i   R¥  (   RF   R3   RR   RÈ   RP   Rw   R†   R{   R   R   RC   Rh   RL   Rl   Rc   Rd   RŽ   R)   Rš  t   select_as_multiple(
   RY   R7   R€   RŸ   RÄ   t   resultsR   R3   RÇ   R‘   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_iterator#  sX    ((((
	+c   
      C   sÄ  d } t  |  j ƒ } t j d d ƒ } t | d ƒ | j d | ƒ | j d } | j d } | j d ƒ } t j | | ƒ d | } | j d d | ƒ} t j | | ƒ d	 | } | j d d | ƒ} t j | | ƒ d
 | | f } | j d d | ƒ} t j | | ƒ Wd  QXt  |  j ƒ –} t j d d ƒ } t | d ƒ | j d | ƒ | j d } | j d } g  | j d d | ƒD] } | ^ qŠ}	 t	 |	 ƒ } t j | | ƒ d | } g  | j d d | d | ƒD] } | ^ qÞ}	 t	 |	 ƒ } t j | | ƒ d	 | } g  | j d d | d | ƒD] } | ^ q2}	 t	 |	 ƒ } t j | | ƒ d
 | | f } g  | j d d | d | ƒD] } | ^ qŒ}	 t	 |	 ƒ } t j | | ƒ Wd  QXd  S(   Ng     ˆÃ@ià† t   SR€   i    iÿÿÿÿs   index >= '%s'Rx   s   index <= '%s's   index >= '%s' & index <= '%s'Rð  (
   RF   R3   RR   RÈ   RP   Rw   R~   R†   R   R   (
   RY   Rð  R7   RŸ   t   beg_dtt   end_dtR   Rx   RÄ   Rª  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt"   test_select_iterator_complete_8014e  sT    

(
	%
	%	%c         C   sW  d } t  |  j ƒ ˜} t j d d ƒ } t | d ƒ | j d | ƒ | j d } | j d } d | } g  | j d d | d	 | ƒD] } | ^ q‡ } t | ƒ }	 | | j | k }
 t j	 |
 |	 ƒ d
 | } g  | j d d | d	 | ƒD] } | ^ qî } t | ƒ }	 | | j | k }
 t j	 |
 |	 ƒ d | | f } g  | j d d | d	 | ƒD] } | ^ q[} t | ƒ }	 | | j | k | j | k @}
 t j	 |
 |	 ƒ Wd  QXt  |  j ƒ “ } t j d d ƒ } t | d ƒ | j d | ƒ | j d } d | } g  | j d d | d	 | ƒD] } | ^ q#} d t
 | ƒ k sMt ‚ Wd  QXd  S(   Ng     ˆÃ@ià† R¬  R€   i   iþÿÿÿs   index >= '%s'Rx   Rð  s   index <= '%s's   index >= '%s' & index <= '%s'iÿÿÿÿs   index > '%s'i    (   RF   R3   RR   RÈ   RP   Rw   R~   R†   R   R   RC   Rh   (   RY   Rð  R7   RŸ   R­  R®  Rx   RÄ   Rª  R   t	   rexpected(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt&   test_select_iterator_non_complete_8014¯  sF    
	%
	%	%
	%c         C   sC  t  d ƒ } t |  j ƒ "} t j d d ƒ } t | d ƒ | j d | ƒ | j d } | j | d } d | } g  | j d d | d	 | ƒD] } | ^ q‘ } t	 | ƒ }	 | | j | k }
 t j
 |
 |	 ƒ d
 | } g  | j d d | d	 | ƒD] } | ^ qø } t | ƒ d k s"t ‚ t	 | ƒ }	 | | j | k }
 t j
 |
 |	 ƒ d | | f } g  | j d d | d	 | ƒD] } | ^ q}} t | ƒ d k s§t ‚ t	 | ƒ }	 | | j | k | j | k @}
 t j
 |
 |	 ƒ d | | f } g  | j d d | d	 | ƒD] } | ^ q} t | ƒ d k s9t ‚ Wd  QXd  S(   Ng     ˆÃ@i † R¬  R€   i    i   s   index >= '%s'Rx   Rð  s   index <= '%s's   index >= '%s' & index <= '%s's   index <= '%s' & index >= '%s'(   t   intRF   R3   RR   RÈ   RP   Rw   R~   R†   R   R   RC   Rh   (   RY   Rð  R7   RŸ   R­  R®  Rx   RÄ   Rª  R   R°  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt&   test_select_iterator_many_empty_framesç  s@    
	%
	%	%		%s9   ignore:\nthe :pandas.io.pytables.AttributeConflictWarningc         C   s1  t  t d t t d ƒ d t d d d d d ƒƒƒ ƒ } t |  j ƒ ã} t | d ƒ | j d | d	 d
 ƒ| j	 d ƒ } t
 j | | ƒ xj d d d g D]Y } xP d d g D]B } t t | | ƒ | d  ƒ t t | | ƒ | d  ƒ k s° t ‚ q° Wq Wt d t ƒ N t  t d t t d ƒ d t d d d d d ƒƒƒ ƒ } | j d | ƒ Wd  QX| j d ƒ j d d d  k st ‚ t | d ƒ t  t d t t d ƒ d t d ƒ t d ƒ t d ƒ g ƒƒ ƒ } | j d | ƒ t  t d t t d ƒ d t d d d d d ƒƒƒ ƒ } | j d | ƒ Wd  QXd  S(   NRu   i   R~   s   2000-1-1R¯  R  t   HR   Ra   Rb   R&  R:  R6  Rs   s   2002-1-1R`  R‘   R_  R¯   t   20020101(   R   R}   R   R
   R   RF   R3   RP   R–   RÞ   RR   R   Rø   R/   Rh   R   R{   Rw   R—   R¹   R   (   RY   R€   R7   R   t   attrRì  R‘   R’   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_retain_index_attributes$  s<    	!,		&		c         C   sð  t  |  j ƒ Û} t d t ƒ t t d t t d ƒ d t d d d d d ƒƒƒ ƒ } | j	 | d	 d
 d d t ƒt t d t t d ƒ d t d d d d d ƒƒƒ ƒ } | j	 | d	 d t ƒt d d d d d ƒ} d | _
 t t d t t d ƒ d | ƒƒ ƒ } | j	 | d	 d
 d d t ƒWd  QXt | d	 ƒ j j
 d k sQt ‚ t d t ƒ c t d d d d d ƒ} d | _
 t t d t t d ƒ d | ƒƒ ƒ } | j	 | d	 d t ƒWd  QXt | d	 ƒ j j
 d  k sæt ‚ Wd  QXd  S(   NRs   Ru   i   R~   s   2000-1-1R¯  R  R´  R   R>   RB   Rw   s   2002-1-1R`  R‰   s   2001-1-1RŠ   (   RL   R3   R   R{   R   R}   R   R
   R   Rl   R:  R)   R~   Rh   R/   (   RY   R3   R€   R‘   Rì  t   idx2(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_retain_index_attributes2Q  s.    				'"!	'c         C   s  t  |  j ƒ ÷ } t d t ƒ ß t j ƒ  } | j d | d d ƒ| j t | j ƒ d } d } d } | j	 d | | g ƒ } | j
 d | ƒ j d	 d
 d g ƒ } t | | ƒ | j	 d d d g ƒ } | j
 d d ƒ j d	 d
 d g ƒ } t | | ƒ Wd  QXWd  QXd  S(   NRs   R/  Ra   Rb   i   s   major_axis>=dates   minor_axis=['A', 'D']t   beforeRA  Ru   R`  s   major_axis>="20000124"s   minor_axis=['A', 'B']t   20000124Rv   (   RF   R3   R   R{   RR   R|   R–   Rl  RC   R†   RB  R)  R    (   RY   R7   R/  Rá  R1  RE  R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_panel_selectt  s     $	c   	   	   C   sF  t  j ƒ  } t |  j ƒ %} | j d | d d ƒ| j t | ƒ d } t d ƒ } | j j	 d | k ss t
 ‚ d } d } | j d | | g ƒ } | j | d  … d	 d
 g f } t  j | | ƒ | j d | g ƒ } | j d  d  … d	 g f } t  j | | ƒ t  j ƒ  } | j d | ƒ t j t | j d d ƒ Wd  QXd  S(   NRr   Ra   Rb   i   s   index>=dateRá  s   columns=['A', 'D']s	   columns=ARu   R`  t   df_times   index>0(   RR   RÈ   RF   R3   R–   R~   RC   R(   t   envt   scopeRh   R†   R¼   R   Rw   Rc   Rd   RM   (	   RY   R€   R7   Rá  R1  RE  RI  R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_frame_select  s$    c         C   s¡  t  j ƒ  } d | d <d | j | j d d !d f <t |  j ƒ Y} | j d | d d d	 d g ƒ| j d d
 ƒ } | j | j | j d k | j d k @} t  j	 | | ƒ | j d d ƒ } | j | j | j d k | j d k @} t  j	 | | ƒ | j d d ƒ } | j | j | j d k | j d k B} t  j	 | | ƒ | j d d ƒ } | j | j | j d k | j | j d k @| j d k B} t  j	 | | ƒ | j d d ƒ } | j | j d k } t  j	 | | ƒ t
 j t | j d d ƒ | j d d ƒ } | j d  d  … | j j d d g ƒ f } t  j	 | | ƒ | j d d ƒ } | j | j | j d k j d d d g ƒ } t  j	 | | ƒ Wd  QXd  S(   NR‰   R“  RŠ   i    i   R€   Ra   Rb   R„   s    index>df.index[3] & string="bar"i   s    index>df.index[3] & string="foo"s    index>df.index[3] | string="bar"s7   (index>df.index[3] & index<=df.index[6]) | string="bar"i   s   string!="bar"s   ~(string="bar")s   ~(columns=['A','B'])Ru   Rv   s(   index>df.index[3] & columns in ['A','B']R6  (   RR   RÈ   R¼   R~   RF   R3   R–   R†   R“  R   Rc   Rd   RR  R6  R=  R)  (   RY   R€   R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_frame_select_complex®  s>    
***%	+ c         C   sÁ  t  d d g ƒ ©} | \ } } t i d d d d d g d 6ƒ } | j | d d d	 d
 d d d g ƒt | d d d ƒ} t t j j d d ƒ d d g d t j g  t	 d ƒ D]% } t	 d ƒ D] } | | f ^ qÁ q± d d d g ƒƒ} | j | d d d	 d
 d ƒt | d d d ƒ}	 | j
 j ƒ  }
 t | ƒ } | j d d d ƒ} t | |	 ƒ | j ƒ  t | d d d ƒ} t | |	 ƒ | j
 } t | d d d ƒ} t | |	 ƒ t | d d d ƒ} t | |	 ƒ t | d d d ƒ} t | |	 ƒ t | d d d ƒ} t | |	 ƒ t | ƒ } | j d d d ƒ} t | |	 ƒ | j d d d ƒ} t | |	 ƒ | j d d d ƒ} t | |	 ƒ | j d d d ƒ} t | |	 ƒ | j ƒ  Wd  QXd  S(   Ns	   parms.hdfs   hist.hdfi   i   i   Ru   R€   R>   RB   Ra   Rb   R„   Rx   s   A=[2,3]i   R6  R   R~   i   R×  t   l1t   l2s   l1=[2, 3, 4]s   l1=ls   l1=indexs   l1=selection.indexs   l1=selection.index.tolist()s   l1=list(selection.index)(   RL   R   Rl   R)   Rº   R  R  R   RÝ  R   R~   t   tolistR&   R†   R   R5   (   RY   t   pathst   ppt   hht   parmst	   selectionR   t   jt   histRŸ   Rl  R7   R   R~   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_frame_select_complex2á  sP    "	%
	c      	   C   sp   t  j ƒ  } t |  j ƒ O } | j d | d d ƒt j t | j d d ƒ t j t | j d d ƒ Wd  QXd  S(   NR€   Ra   Rb   s   columns=['A'] | columns=['B']s!   columns=['A','B'] & columns=['C'](	   RR   RÈ   RF   R3   R–   Rc   Rd   RR  R†   (   RY   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_invalid_filtering!  s    
c      	   C   s  t  |  j ƒ 
} t j ƒ  } d | d <d | j d d … d f <| j d | d d g ƒ| j d d ƒ } | | j d k } t | | ƒ y6 | j d d	 ƒ } | | j d k } t | | ƒ Wn: t	 k
 rþ } t
 d
 j | ƒ ƒ t
 | ƒ t
 | ƒ n X| j ƒ  } t j | j | j d k d f <| j d | d d g ƒ| j d d	 ƒ } | t | j ƒ } t | | ƒ d | d <d | j d d … d f <| j d | d d g ƒ| j d d ƒ } | | j d k } t | | ƒ | j d d ƒ } | | j d k } t | | ƒ Wd  QXd  S(   Nt   noneRú   R‹   i   i   R€   R„   s   x=nones   x!=nones   [{0}]R‘   i   R²  R’   s   int=2s   int!=2(   RF   R3   RR   RÈ   R¼   Rw   R†   Rú   R   RÌ   R$   Ra   Rc  Rº   R»   R   R²  (   RY   R7   R€   R   RŸ   t   detailR‘   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_string_select2  s>    


c            s˜  t  j ƒ  } t |  j ƒ w‰  t ˆ  d ƒ t j t d d ƒ ˆ  j d d ƒ Wd  QXˆ  j	 d | ƒ t j t ˆ  j d d ƒ ‡  f d †  } t j t
 | ƒ ˆ  j d d ƒ } t  j | j t | j ƒ j ƒ t | t ƒ så t ‚ t j t ˆ  j d d ƒ | j ƒ  } d | d <ˆ  j	 d	 | d
 d g ƒˆ  j d	 d ƒ } t  j | j | d j ƒ | j ƒ  } d | d <t j | j d d … d f <ˆ  j	 d | d
 d g ƒˆ  j d d ƒ } t  j | j | d j ƒ ˆ  j d d d d ƒ} t  j | j | d j d ƒ ˆ  j d d d d ƒ} t  j | j | d j d ƒ ˆ  j d d d d ƒ} t  j | j | d j d  ƒ ˆ  j d d d d ƒ} t  j | j | d j d  ƒ ˆ  j d d d d d d ƒ} t  j | j | d j d d !ƒ ˆ  j d d d d d d ƒ} t  j | j | d j d d !ƒ t i t j j d ƒ d 6d d 6ƒ } ˆ  j	 d | d
 t ƒ| d } ˆ  j d d ƒ } t  j | | ƒ Wd  QXd  S(   NR€   RP  s   No object named df in the fileR~   R‰   c              s   ˆ  j  d d d d g ƒd  S(   NR€   R~   Rx   s   index>5(   t   select_column(    (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRK   s  s    R–  R“  R‘   R„   i   i   R’   R4  i   iþÿÿÿR6  i
   Ru   Rv   R“   (   RR   RÈ   RF   R3   RP   Rc   Rd   RN   RÑ  Rw   RÌ   t   assert_almost_equalRW  R   R~   RG   Rh   RM   Rc  Rº   R»   R¼   R   R  R  R{   R!   (   RY   R€   RK   R   R‘   R’   R“   RŸ   (    (   R7   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_columna  sV    


!!&
c         C   sÃ  t  j ƒ  } t |  j ƒ Ã} t | d ƒ | j d | ƒ | j d ƒ } | j t j	 t
 | j ƒ ƒ k j ƒ  sw t ‚ t | d ƒ t t d t d ƒ d t d ƒ ƒ ƒ } | j d | ƒ | j d d g ƒ } | j t j	 d ƒ k j ƒ  sô t ‚ | j d d | ƒ} | j d d	 … d  d  … f } t  j | | ƒ | j d d
 d g ƒ } | j t j	 d	 ƒ d k j ƒ  sxt ‚ | j d d | ƒ} | j d d … d  d  … f } t  j | | ƒ t | t ƒ sÑt ‚ t | d ƒ t | d ƒ t  j ƒ  } t  j ƒ  j d d „  ƒ } | j d | d d d g ƒ| j d | ƒ | j d d d g ƒ } | j d | ƒ } | j d | ƒ }	 t | |	 g d d ƒ} t | | g d d ƒ} | | j d k | j d k @} t  j | | ƒ Wd  QXt |  j ƒ Î} t t j j d d	 ƒ d t d d d ƒƒ} | j d | ƒ | j d d ƒ } | t | ƒ j d k j }
 | j  |
 } | j d d |
 ƒ} t  j | | ƒ | j d d |
 ƒ} t  j | | ƒ t! j" t# | j d d t j	 t
 | ƒ d d ƒƒt! j" t# | j d d t j	 t
 | ƒ d ƒ ƒt! j" t# | j d d t j	 t
 | ƒ ƒ d d ƒt! j" t# | j d d t j	 t
 | ƒ ƒ d d d d ƒt d d d ƒ} | j d d d  ƒ} | | j j$ | ƒ } t  j | | ƒ t t j j d d	 ƒ ƒ } | j d | ƒ | j d d d d d g ƒ} | j  d d d g } t  j | | ƒ t% g d }
 t& |
 d! <| j d d |
 ƒ} | j |
 } t  j | | ƒ | j d d d d d ƒ} | d d !} t  j | | ƒ Wd  QXd  S("   NR€   Ru   i   Rv   s   index<3i   Rx   i    i   s   index>=3s   index<=4i   RÇ   R‘   R6  c         S   s   d |  S(   Ns   %s_2(    (   Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  Ë  s    R„   s   A>0s   B>0R  i   iè  R~   t   20000101R¯  Rè   Rw  R4  R6  i
   iô  s   index in selectioniþÿÿÿ('   RR   RÈ   RF   R3   RP   Rw   t   select_as_coordinatesRW  Rº   Rÿ   RC   R~   t   allRh   R   R}   R
   R†   R¼   R   RG   R   Rš  R   Ru   Rv   R  R  R   RÑ  R   t   monthRŒ   Rc   Rd   RM   R»  R{   RE   (   RY   R€   R7   R›   R   RŸ   RÇ   R‘   t
   df1_resultt
   df2_resultRx   RÉ  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_coordinates©  sŠ    -'$( "
c         C   sb  t  j ƒ  } t  j ƒ  j d d „  ƒ } d | d <t | | g d d ƒ} t |  j ƒ } t j t | j	 i d d g d	 6d  d
 6| d d ƒt j t | j	 i d  d	 6d  d
 6| d d ƒt j t | j	 d	 | d	 ƒ | j	 i d d g d	 6d  d
 6| d d	 ƒ| j d	 d
 g d d d g d d	 ƒ} | | j d k | j d k @} t  j | | ƒ Wd  QXd  S(   NR6  c         S   s   d |  S(   Ns   %s_2(    (   Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm    s    RŠ   R‰   R  i   Ru   Rv   RÇ   R‘   R¥  R’   Rx   s   A>0s   B>0i    (   RR   RÈ   Rš  R   RF   R3   Rc   Rd   RM   t   append_to_multipleR/   R©  Ru   Rv   R   (   RY   RÇ   R‘   R€   R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_to_multiple  s$    
$! c         C   s  t  j ƒ  } t  j ƒ  j d d „  ƒ } t j | j d | j j d d g ƒ f <t | | g d d ƒ} t	 |  j
 ƒ  } | j i d d g d 6d  d 6| d	 d d
 t ƒ| j d d g ƒ } | j ƒ  } t  j | | ƒ t  j | j d ƒ j | j d ƒ j ƒ Wd  QXd  S(   NR6  c         S   s   d |  S(   Ns   %s_2(    (   Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  (  s    i   Ru   Rv   R  RÇ   R‘   R¥  Re  (   RR   RÈ   Rš  Rº   R»   RŒ   R6  RÎ  R   RF   R3   RÛ  R/   R{   R©  Re  R   t   assert_index_equalR†   R~   (   RY   RÇ   R‘   R€   R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_to_multiple_dropna&  s    (#t   runs8   append_to_multiple_dropna_false is not raising as failedc         C   s
  t  j ƒ  } t  j ƒ  j d d „  ƒ } t j | j d | j j d d g ƒ f <t | | g d d ƒ} t	 |  j
 ƒ Ž } | j i d d g d 6d  d 6| d	 d d
 t ƒt j t ƒ  | j d d g ƒ Wd  QX| j d ƒ j j | j d ƒ j ƒ s t ‚ Wd  QXd  S(   NR6  c         S   s   d |  S(   Ns   %s_2(    (   Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  =  s    i   Ru   Rv   R  t   df1at   df2aR¥  Re  (   RR   RÈ   Rš  Rº   R»   RŒ   R6  RÎ  R   RF   R3   RÛ  R/   RE   Rc   Rd   RM   R©  R†   R~   t   equalsRh   (   RY   RÇ   R‘   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt$   test_append_to_multiple_dropna_false8  s    (#c         C   s  t  j ƒ  } t  j ƒ  j d d „  ƒ } d | d <t |  j ƒ ¾} t j t | j d  d d d g d d	 ƒ| j
 d	 | d
 d d g ƒ| j
 d | ƒ t j t | j d  d d d g d d	 ƒt j t | j d  g d d d g d d	 ƒt j t | j d	 d g d d d g d d	 ƒt j t | j d g d d d g d d	 ƒt j t | j d	 d g d d d g d d ƒ| j d	 d d g ƒ } | j d	 g d d d g d d	 ƒ} t  j | | ƒ | j d	 d d d g d d	 ƒ} t  j | | ƒ | j d	 d g d d d g d d	 ƒ} t | | g d d ƒ} | | j d k | j d k @} t  j | | ƒ | j d	 d g d d d d ƒ} t | | g d d ƒ} | d } t  j | | ƒ | j
 d t  j d d ƒ ƒ t j t | j d	 d g d d d g d d	 ƒWd  QXd  S(   NR6  c         S   s   d |  S(   Ns   %s_2(    (   Rú   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  Q  s    RŠ   R‰   Rx   s   A>0s   B>0R¥  RÇ   R„   Ru   Rv   R‘   R’   R“   R  i   i    s   index>df2.index[4]i   t   nperi2   (   RR   RÈ   Rš  RF   R3   Rc   Rd   RÌ   R©  R/   Rw   RN   R†   R   R   Ru   Rv   RM   (   RY   RÇ   R‘   R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_as_multipleN  sR    
! 
s   3.1.0sB   tables version does not support fix for nan selection bug: GH 4858c         C   sñ   t  |  j ƒ Ü } t t d t d ƒ d t d ƒ ƒ d d ƒ} | d d j t ƒ | d <t j | j	 d <t t d d d	 d
 g d d d d g ƒ d d d d g ƒ} | j
 d | d t d d g ƒ| j d d d ƒ} t | | ƒ Wd  QXd  S(   NR¶  i   RW  Rè   Rw  i
   i    s   13.0s   14.0s   15.0g      @g      @g      @R~   i   i   i   R€   R„   Rx   s
   values>2.0(   RF   R3   R   R}   R   R   RÃ   Rº   R»   RŒ   Rw   R{   R†   R   (   RY   R7   R€   RŸ   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_nan_selection_bug_4858ˆ  s    $	$c         C   s  t  |  j ƒ ö } t t d t j j d ƒ d t j j d ƒ ƒ ƒ } | j d | ƒ | j d d d d d d	 ƒ} | j	 d d
 … d g f } t
 j | | ƒ | j d d d d d d ƒ} t | ƒ d k sÕ t ‚ | j	 d d … d g f } t
 j | | ƒ Wd  QXd  S(   NRu   i   Rv   R€   s   columns=['A']R4  i    R6  i   i   i   i(   (   RF   R3   R   R}   Rº   R  Rû  Rw   R†   R¼   RR   R   RC   Rh   (   RY   R7   R€   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_start_stop_table  s    3c         C   s¼   t  |  j ƒ § } t i d d g d 6d d g d 6ƒ } | j i d g d 6d  d 6| d d ƒ| j d d g d d d d d	 d ƒ} | j d g d d g f } t j | | ƒ Wd  QXd  S(
   Ni   i   R‰   RŠ   R¥  R   R4  i    R6  (	   RF   R3   R   RÛ  R/   R©  R¼   RR   R   (   RY   R7   R€   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_start_stop_multiple±  s    & 	c         C   sv  t  |  j ƒ a} t t d t j j d ƒ d t j j d ƒ ƒ d t j d d d ƒƒ} | j	 d | ƒ | j
 d d d	 d
 d ƒ} | j d	 d … d  d  … f } t j | | ƒ | j
 d d d d
 d ƒ} | j d d … d  d  … f } t j | | ƒ | j
 d d d d
 d ƒ} | j d d … d  d  … f } t j | | ƒ | j } | j	 d | ƒ | j
 d d d	 d
 d ƒ} | j d	 d !} t j | | ƒ | j
 d d d d
 d ƒ} | j d d !} t j | | ƒ t j ƒ  } t j | j d d … d d … f <t j | j d d … d f <| j ƒ  } | j	 d | ƒ t j t ƒ  | j
 d d d	 d
 d ƒWd  QXWd  QXd  S(   NRu   i   Rv   R~   Rö  R¯  R€   R4  i    R6  i   i
   i   i(   RÄ   i   i   i   iþÿÿÿt   dfs(   RF   R3   R   R}   Rº   R  Rû  R”   R   R–   R†   RŒ   RR   R   Ru   R!   Rg   R»   Rd  Rc   Rd   RR  (   RY   R7   R€   R   RŸ   RÄ   Ré  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_start_stop_fixedÀ  s@    	"c         C   s&  t  t j j d d ƒ ƒ } g  | j D] } d | ^ q% | _ g  | j D] } d | ^ qH | _ t |  j ƒ ° } | j d | d d ƒd } | j	 d | g ƒ } t
 j | | j d  d  … | j d  f ƒ d	 } | j	 d | g ƒ } t
 j | | j d  d  … | j d  d d
 … f ƒ Wd  QXd  S(   Ni2   id   s   %.3dRr   Ra   Rb   s   columns=df.columns[:75]iK   s   columns=df.columns[:75:2]i   (   R   Rº   R  R  R~   R6  RF   R3   R–   R†   RR   R   R¼   (   RY   R€   R›   R7   R>  R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_select_filter_cornerî  s    ##*c            s>   t  j ƒ  ‰  t  j ‡  f d †  d „  ƒ } t  j ˆ  | ƒ d  S(   Nc            s   ˆ  j  |  d ƒ S(   NR€   (   Rl   (   RI   (   R€   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm    s    c         S   s   t  j |  d ƒ S(   NR€   (   R”   R)   (   RI   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm    s    (   RR   Rg   t   round_trip_pathlibR   (   RY   R   (    (   R€   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_path_pathlibÿ  s
    s   start, stopi    i   i   c      
   C   s“   t  i t d d d g ƒ d 6t d d d g ƒ d 6ƒ } t |  j ƒ F } | j d | ƒ | j d d	 | d
 | ƒ} t | | | !| ƒ Wd  QXd  S(   Ni¢Þ2i£Þ2i¤Þ2R=   t   abt   cdRš   t   test_datasetR4  R6  (   R   R   RF   R3   Rw   R†   R   (   RY   R4  R6  R€   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt    test_contiguous_mixed_data_table  s    c            sJ   t  j ƒ  ‰  ‡  f d †  } d „  } t  j | | ƒ } t  j ˆ  | ƒ d  S(   Nc            s,   t  j |  ƒ  } ˆ  j | d ƒ Wd  QXd  S(   NR€   (   R”   R&   Rl   (   R3   R7   (   R€   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   writer  s    c         S   s,   t  j |  ƒ  } t  j | d ƒ SWd  QXd  S(   NR€   (   R”   R&   R)   (   R3   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   reader  s    (   RR   Rg   Rì  R   (   RY   Rò  Ró  R   (    (   R€   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_path_pathlib_hdfstore  s
    	c            s>   t  j ƒ  ‰  t  j ‡  f d †  d „  ƒ } t  j ˆ  | ƒ d  S(   Nc            s   ˆ  j  |  d ƒ S(   NR€   (   Rl   (   RI   (   R€   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  %  s    c         S   s   t  j |  d ƒ S(   NR€   (   R”   R)   (   RI   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  &  s    (   RR   Rg   Rì  R   (   RY   R   (    (   R€   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_pickle_path_localpath"  s
    c            sJ   t  j ƒ  ‰  ‡  f d †  } d „  } t  j | | ƒ } t  j ˆ  | ƒ d  S(   Nc            s,   t  j |  ƒ  } ˆ  j | d ƒ Wd  QXd  S(   NR€   (   R”   R&   Rl   (   R3   R7   (   R€   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRò  ,  s    c         S   s,   t  j |  ƒ  } t  j | d ƒ SWd  QXd  S(   NR€   (   R”   R&   R)   (   R3   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRó  0  s    (   RR   Rg   t   round_trip_localpathR   (   RY   Rò  Ró  R   (    (   R€   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_path_localpath_hdfstore)  s
    	c         K   s_   i  } | r t  | d <n  t |  j d |  + } | | d <| d } | | | |  Wd  QXd  S(   NR@   RB   Rm   (   t   _default_compressorRF   R3   (   RY   Rm   Rò  Rt  Rn   t   optionsR7   t	   retrieved(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyR  7  s    

c   	      K   s‰   i  } | r | p t  | d <n  t |  j d |  O } | | d <| d } | | | |  | | d <| d } | | | |  Wd  QXd  S(   NR@   RB   Rm   (   Rø  RF   R3   (	   RY   Rm   Rò  Rt  Rn   Rù  R7   Rú  t   again(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRg  B  s    



c      	   C   sh   i  } | r t  | d <n  t |  j d |  4 } | j d | d d ƒ| d } | | | ƒ Wd  QXd  S(   NR@   RB   Rm   Ra   Rb   (   Rø  RF   R3   R–   (   RY   Rm   Rò  Rt  Rù  R7   Rú  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRu  P  s    
c            sÏ  t  |  j ƒ ” ‰  t j ƒ  } | j ˆ  d d d d d ƒt ˆ  ƒ ‰ d ˆ j ƒ  k s^ t ‚ ˆ j sm t ‚ ˆ j	 ƒ  d ˆ j ƒ  k s t ‚ ˆ j sŸ t ‚ Wd  QXt  |  j ƒ •‰  t
 j rø t ˆ  ƒ } ‡  f d †  } t j t | ƒ | j	 ƒ  nMt ˆ  ƒ } t ˆ  ƒ } d | j ƒ  k s(t ‚ d | j ƒ  k s@t ‚ | j sOt ‚ | j s^t ‚ | j	 ƒ  d | j ƒ  k s€t ‚ | j st ‚ d | j ƒ  k s¨t ‚ | j s·t ‚ | j	 ƒ  d | j ƒ  k sÙt ‚ d | j ƒ  k sñt ‚ | j st ‚ | j st ‚ t ˆ  d d ƒ‰ ˆ j d | ƒ t ˆ  ƒ } | j d | ƒ | j	 ƒ  d | j ƒ  k sqt ‚ | j st ‚ ˆ j	 ƒ  d ˆ j ƒ  k s£t ‚ ˆ j s³t ‚ t ˆ  d d ƒ‰ ˆ j d | ƒ t ˆ  ƒ } ˆ j	 ƒ  d ˆ j ƒ  k st ‚ ˆ j st ‚ | j	 ƒ  d | j ƒ  k s5t ‚ | j sEt ‚ Wd  QXt  |  j ƒ o‰  t j ƒ  } | j ˆ  d d d d d ƒt ˆ  ƒ ‰ ˆ j	 ƒ  t j t ˆ j ƒ t j t ‡ f d	 †  ƒ t j t ‡ f d
 †  ƒ t j t ‡ f d †  ƒ t j t ‡ f d †  ƒ t j t ˆ j d ƒ t j t ˆ j d ƒ t j t ˆ j d | ƒ t j t ˆ j d | ƒ t j t ˆ j d ƒ t j t ˆ j d ƒ t j t d d ƒ ˆ j d ƒ Wd  QXWd  QXd  S(   NR€   R>   RB   Ra   Rb   t   CLOSEDc              s   t  ˆ  ƒ d  S(   N(   R&   (    (   R3   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRK   s  s    R‘   c              s
   d ˆ  k S(   NR€   (    (    (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  ´  s    c              s
   t  ˆ  ƒ S(   N(   RC   (    (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  µ  s    c              s   ˆ  d S(   NR€   (    (    (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  ¶  s    c              s   ˆ  j  S(   N(   R€   (    (   R7   (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  ·  s    R’   RP  s   file is not open(   RL   R3   RR   Rg   Rl   R&   R¹   Rh   RÓ   R5   R#   t!   _table_file_open_policy_is_strictRc   Rd   RM   Rw   R%   Rž   Rù   R†   RÞ   R–   R—   R1   (   RY   R€   t   store1RK   t   store2(    (   R3   R7   s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_multiple_open_close[  sˆ    
	






c         C   sJ   t  | d d d ƒ d d ƒ& } | d } t | t ƒ s@ t ‚ Wd  QXd  S(   Nt   ioR   s   legacy_hdf/pytables_native.h5R>   RÎ   s   detector/readout(   RF   RG   R   Rh   (   RY   t   datapathR7   t   d2(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_pytables_native_readÂ  s
    
s)   native2 read fails oddly on windows / 3.5c         C   sW   t  | d d d d ƒ d d ƒ0 } t | ƒ | d } t | t ƒ sM t ‚ Wd  QXd  S(   NR  R   t
   legacy_hdfs   pytables_native2.h5R>   RÎ   t   detector(   RF   RÃ   RG   R   Rh   (   RY   R  R7   t   d1(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_pytables_native2_readÉ  s    

c         C   s’   t  | d d d d ƒ d d ƒk } | j d ƒ } t j d d	 d
 d g g d d d d d g d t j d g d d ƒƒ} t | | ƒ Wd  QXd  S(   NR  R   R  s   legacy_table_fixed_py2.h5R>   RÎ   R€   i   i   i   R`  R6  Ru   Rv   R7  R~   Rú  R:  t
   INDEX_NAME(   RF   R†   R”   R   R   R   (   RY   R  R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt'   test_legacy_table_fixed_format_read_py2Ó  s    	c         C   ss   t  | d d d d ƒ d d ƒ } | j d ƒ } Wd  QXt j i d d	 g d 6d
 d g d	 6ƒ } t | | ƒ d  S(   NR  R   R  s   legacy_table_py2.h5R>   RÎ   Rb   R=   Rš   i   i   (   RF   R†   R”   R   R   (   RY   R  R7   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_legacy_table_read_py2â  s    		c         C   sï   t  | d d d d ƒ d d ƒÈ } t ƒ  ¶ t d t j j j ƒ | j d ƒ | j d	 ƒ | j d
 ƒ | j d	 d d ƒt j	 t
 | j d
 d ƒ | j d	 ƒ } | j d	 d ƒ } | | j | j d k } t | | ƒ Wd  QXWd  QXd  S(   NR  R   R  s   legacy_table.h5R>   RÎ   R¶   RÇ   R‘   R  t   typt   legacy_frames   minor_axis=Bs   index>df2.index[2]i   (   RF   R   R   R”   R  R#   t   IncompatibilityWarningR†   Rc   Rd   RÌ   R~   R   (   RY   R  R7   R‘   R   RŸ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_legacy_table_readñ  s    
c      	   C   s¨   t  d t ƒ “ d  d  t d „ } t j ƒ  } zb t |  j ƒ } t | ƒ } | j d | d d g ƒ| j	 ƒ  | d | ƒ | d | d t
 ƒ Wd  t | ƒ XWd  QXd  S(   NRs   c      	   [   s  z>t  |  d ƒ } | d  k r? d d  l } | j ƒ  \ } } n  | j | d | d | | } | d  k rx | j ƒ  } n  t | ƒ t | j ƒ  ƒ k sœ t ‚ xž | j ƒ  D] }	 | j |	 ƒ j	 r© | j |	 ƒ }
 | j |	 ƒ } | j
 |
 j
 k s÷ t ‚ | r9x6 | j D]( } | j r|
 | j j s/t ‚ qqWq9q© q© WWd  t | ƒ t | ƒ y t j | ƒ Wn t t f k
 rn Xt | ƒ Xd  S(   NRÎ   iÿÿÿÿRž   t   propindexes(   R&   R/   R:   t   mkstempRc  Rž   R   Rh   R—   R˜   t   nrowsRs  R·  R:  R8   R0   R5   R2   RM   R4   (   RK   t   new_fRž   R  Rn   R7   R:   t   fdt   tstoret   kt   new_tt   orig_tR=   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   do_copy  s4    $	+

R€   R„   Ru   RK   R  (   R   R{   R/   RR   Rg   R<   R3   R&   Rw   R5   RE   R4   (   RY   R  R€   R3   t   st(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt	   test_copy	  s    (
c         C   sy   t  |  j ƒ d } t j d d d d d d d ƒ } t d g | g ƒ } | | d	 <| d	 j d | k so t ‚ Wd  QXd  S(
   NiÜ  i   i   i   i   i   i@â i    R=   (   RF   R3   Rµ   R   R~   Rh   (   RY   R7   R#  Rp   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt#   test_store_datetime_fractional_secsB  s
    !
c      	   C   s8  t  |  j ƒ #} t j d ƒ } t t j j t | ƒ ƒ | ƒ } | | d <| d } t j	 | | ƒ | j
 j | j
 j k s„ t ‚ t j | j
 | j
 d d ƒt j d ƒ } t t j j t | ƒ ƒ | ƒ } | | d <| d } t j	 | | ƒ | j
 j | j
 j k st ‚ t j | j
 | j
 d d ƒWd  QXd  S(   Ni
   R=   Rm   s   series index(   RF   R3   RR   RC  R   Rº   R  R  RC   R!   R~   R  Rh   t   assert_class_equalRD  (   RY   R7   Rì  R¥  R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_tseries_indices_seriesJ  s    !

!

c      	   C   s;  t  |  j ƒ &} t j d ƒ } t t j j t | ƒ d ƒ d | ƒ} | | d <| d } t	 | | ƒ | j
 j | j
 j k s‡ t ‚ t j | j
 | j
 d d ƒt j d ƒ } t t j j t | ƒ d ƒ | ƒ } | | d <| d } t	 | | ƒ | j
 j | j
 j k st ‚ t j | j
 | j
 d d ƒWd  QXd  S(   Ni
   i   R~   R=   Rm   s   dataframe index(   RF   R3   RR   RC  R   Rº   R  R  RC   R   R~   R  Rh   R  RD  (   RY   R7   Rì  R€   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_tseries_indices_frame_  s"    '

$

c         C   sy   t  d ƒ t  d ƒ g } t d t ƒ L t d t j j ƒ t t j	 j
 t | ƒ ƒ | ƒ } |  j | t j ƒ Wd  QXd  S(   Ns   \u03c3s   \u03c3\u03c3Rs   R¶   (   R   R   R{   R   R”   R¿   RÀ   R   Rº   R  R  RC   R  RR   R!   (   RY   t   unicode_valuesRÄ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_unicode_indexv  s
    !c         C   sò   d } t  j i | g d 6ƒ } t |  j ƒ B } | j d | d d d d ƒ| j d ƒ } t j | | ƒ Wd  QXt  j i d | g d 6d	 d	 g d
 6ƒ } t |  j ƒ B } | j d | d d d d ƒ| j d ƒ } t j | | ƒ Wd  QXd  S(   Ns   \u0394Ru   R€   Ra   Rb   RH  s   utf-8R=   Rš   Rv   (   R”   R   RF   R3   R–   RÞ   RR   R   (   RY   t   charR€   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_unicode_longer_encoded€  s    )c         C   sp   t  i d d d g d 6d d d g d 6d d d	 g d	 6ƒ } t j ƒ  } | j d  | d
 <|  j | t j ƒ d  S(   Ni   i   i   R=   g      ð?g       @g      @Rš   R›   Rœ   (   R   RR   Ry   R~   R  R   (   RY   R€   Rü   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_datetime_mixed  s
    9c   	      C   s"  t  t j j d d ƒ ƒ } t  i t j j d ƒ d 6ƒ } t  i t j j d ƒ d 6ƒ } t  i t j j d ƒ d 6ƒ } t  i t j j d ƒ d d t f 6ƒ } t |  j ƒ m } d t j d ƒ } | j	 | | ƒ x@ | | | | f D], } t
 j t ƒ  | j	 | | ƒ Wd  QXqè WWd  QXd  S(	   Ni
   i   R=   i   t   1s   df_%s(   i   i   (   R%  i   (   R   Rº   R  R  RV  RF   R3   RR   RX   Rw   Rc   Rd   RM   (	   RY   R€   R‘   R’   R“   t   df5R7   R:  Rœ   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt7   test_append_with_diff_col_name_types_raises_value_error   s    (c         C   s·   t  i d d d d d d d d g d 6d d d d	 d
 d d d g d 6ƒ } | | j d k } t |  j ƒ 5 } | j d | d d d t ƒ| j d d ƒ } Wd  QXt j | | ƒ d  S(   NR=   R›   Rš   s   test & testR§   i   i   i   i   i   i   i   i   t   testRa   Rb   R„   s   a = "test & test"(	   R   R=   RF   R3   Rw   R{   R†   RR   R   (   RY   R€   RŸ   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt(   test_query_with_nested_special_character¯  s    %c   	      C   sš  t  |  j ƒ …} t | d ƒ t t d d d d d d g d d d d d g d t ƒƒ } | j d | d d	 ƒ| j d ƒ } t j	 | | ƒ t | d
 ƒ t t d d d d d d g d d d d d g d t
 ƒƒ } | j d
 | d d	 ƒ| j d
 ƒ } t j	 | | ƒ t | d ƒ t i | d 6d d d d d d g d 6ƒ } | j d | d d	 ƒ| j d ƒ } t j | | ƒ t | d ƒ t d d d d d d d g ƒ j d ƒ } | j d | ƒ | j d ƒ } t j	 | | ƒ t | d ƒ t d d t j d d d d g ƒ j d ƒ } | j d | ƒ | j d ƒ } t j	 | | ƒ t | d ƒ | j ƒ  } t t d ƒ ƒ j d ƒ | d <| j d | ƒ | j d ƒ } t j | | ƒ | j ƒ  } d | k sÐt ‚ d | k sât ‚ t | d ƒ t t d d d d d d g d d d d d g d t ƒƒ } | j d | d d	 ƒ| j d ƒ } t j	 | | ƒ t | d ƒ | j d | d d g ƒ| | j j d d g ƒ } | j d d d g ƒ} t j | | ƒ | | j j d d g ƒ } | j d d d g ƒ} t j | | ƒ | | j j d g ƒ } | j d d d  g ƒ} t j | | ƒ | | j j d! g ƒ } | j d d d" g ƒ} t j | | ƒ | j d | ƒ t | | g ƒ } | | j j d d g ƒ } | j d d d g ƒ} t j | | ƒ | j ƒ  } | d j j d# t
 ƒ t j t ƒ  | j d | ƒ Wd  QX| j d$ ƒ } | d  k	 s`t ‚ | j d ƒ t j t ƒ  | j d$ ƒ Wd  QXWd  QXd  S(%   NRÄ   R=   Rš   R›   t
   categoriesRœ   t   orderedRa   Rb   t	   s_orderedR€   i   i   i   i   i   i   t   valst   siRM  t   si2R‘   t   abcdefgR‚  s   /df2   s   /df2/meta/values_block_1/metaR’   R„   Rx   s   s in ["b","c"]s   s = ["b","c"]s
   s in ["d"]RK   s
   s in ["f"]R8  s   df3/meta/s/meta(   RF   R3   RP   R   R   RE   Rw   R†   RR   R!   R{   R   R   Rb  Rº   R»   Rc  RH   R¹   Rh   RÄ   R»  R   t   catt   remove_unused_categoriesRc   Rd   RM   R/   R1   RN   (	   RY   R7   RÄ   R   R€   R‘   R¹   RŸ   R’   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_categorical¹  sŽ    ,*-c         C   sW  d d g } d d g } d d g } t  t d | d | d	 | ƒ ƒ } | j g  d  d  … f } t |  j ƒ H } | j | d
 d d d t ƒt | d
 d d ƒ} t j	 | | ƒ Wd  QX| j
 j d ƒ | _
 | j j d ƒ | _ | j g  d  d  … f } t |  j ƒ H } | j | d
 d d d t ƒt | d
 d d ƒ} t j	 | | ƒ Wd  QXd  S(   Nt   ESP_012345_6789t   ESP_987654_3210t
   APF00006npt
   APF0001immg333333@gš™™™™™#@t   obsidst   imgidsR   R€   Ra   Rb   R„   Rx   s   obsids=BRM  (   R   R}   RŒ   RL   R3   Rl   R{   R)   RR   R   R8  Rb  R9  (   RY   R8  R9  R   R€   RŸ   R3   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_categorical_conversion   s     !c         C   s  t  j i d d d t j g d 6t j t j t j t j g d 6d d d d g d 6t  j d  g d d t ƒd	 6ƒ } | j j d
 ƒ | d <| j	 j d
 ƒ | d <| j	 j d
 ƒ | d	 <| } t
 |  j ƒ B } | j | d d d d t ƒt | d ƒ } t j | | ƒ Wd  QXd  S(   NR=   Rš   R›   i   i   i   i   Rè   Rœ   RM  R€   Ra   Rb   R„   (   R”   R   Rº   R»   R   R/   RV  R=   Rb  Rš   RL   R3   Rl   R{   R)   RR   R   (   RY   R€   RŸ   R3   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt!   test_categorical_nan_only_columns>  s    	#c         C   s¾   t  d d d g d d d g g ƒ } t |  j ƒ … } t j t | j | d d d ƒ| j | d d d ƒt | d ƒ } t j	 | | ƒ | j
 | ƒ sŸ t ‚ | j
 | ƒ s´ t ‚ Wd  QXd  S(	   NR6  R=   R   i    R€   Ra   Rˆ   Rb   (   R   RL   R3   Rc   Rd   RM   Rl   R)   RR   R   Râ  Rh   (   RY   R€   R3   t   other(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_duplicate_column_nameQ  s    $c      	   C   s¡   t  i d d g d 6d d g d 6ƒ } t |  j ƒ f } | j | d d d	 ƒt | d ƒ } t j | | ƒ | j | ƒ s‚ t ‚ | j | ƒ s— t ‚ Wd  QXd  S(
   Ni   i   Rv   Rú   RX  Ru   R€   Ra   Rb   (	   R   RL   R3   Rl   R)   RR   R   Râ  Rh   (   RY   R€   R3   R<  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_round_trip_equals_  s    &c      	   C   sv   t  t j j d d ƒ ƒ } t d d d d d d d	 d
 ƒ | _ t |  j ƒ " } | | d <t | d | ƒ Wd  QXd  S(   NRƒ   i
   i   R4  t   0sR¯  R  t   1sR:  t   exampleR€   (   i
   i   (	   R   Rº   R  t   normalR   R~   RF   R3   R   (   RY   R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt!   test_preserve_timedeltaindex_typej  s    
c         C   só   t  t j j d d ƒ d t d ƒ d t d ƒ ƒ} d | j _ | j d d	 d
 t ƒ } | j j	 | j
 j ƒ  } t |  j ƒ n } | j | d d d d
 t d | d t ƒt d ƒ } t | ƒ } t | d d | ƒ} | | k sé t ‚ Wd  QXd  S(   Ni   i   R~   t   abcdR6  t   ABCDEt   lettersRž   Ra  Rw   R€   R>   R=   R„   t   BCD(   R   Rº   R  Rû  RH   R~   R:  R;  R{   R×  R6  RÄ  RL   R3   Rl   RE   R)   Rh   (   RY   R€   R„   R3   t	   cols2loadt   cols2load_originalt	   df_loaded(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt    test_columns_multiindex_modifiedw  s     c         C   s¶  t  j t  j t  j t  j t  j g } t  j t  j g } t j	 rR | j
 t  j ƒ n  x¡ | D]™ } t t j j d d ƒ d | d ƒ ƒ} t |  j ƒ [ } t d t ƒ C d } t j t d | ƒ! | j | d d d	 d
 t ƒWd  QXWd  QXWd  QXqY Wx¹ | D]± } t t j j d d ƒ d | d ƒ ƒ} t |  j ƒ s } t d t ƒ [ | j | d d d	 d
 t ƒt j | d d d j | j d ƒ ƒ} t | ƒ s¢t ‚ Wd  QXWd  QXqý Wd  S(   Ni
   i   R6  Rs   s-   cannot have non-object label DataIndexableColRP  R€   Ra   Rb   R„   Rx   s   index = [{0}]i    (   RR   RB  R@  RC  t   makeTimedeltaIndexRD  RA  t   makeCategoricalIndexR   RF  Rw   RE  R   Rº   R  R  RL   R3   R   R{   Rc   Rd   RM   Rl   R”   R)   Ra   R~   RC   Rh   (   RY   t   types_should_failt   types_should_runR~   R€   R3   RU  R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt$   test_to_hdf_with_object_column_namesŽ  s,    	''"c      	   C   sâ   t  t j j d d ƒ d t d ƒ d t d ƒ ƒ} d | j _ | j d d	 d
 t ƒ } t	 |  j
 ƒ v } | j | d d d ƒt | d ƒ } t | d d ƒ} t | d ƒ } t j | | ƒ | j sÎ t ‚ | j ƒ  Wd  QXd  S(   Ni   i   R~   RD  R6  RE  RF  Rž   Ra  Rw   R€   R>   RB   RÎ   (   R   Rº   R  Rû  RH   R~   R:  R;  R{   RL   R3   Rl   R)   R&   RR   R   RÓ   Rh   R5   (   RY   R€   R3   t   directR7   t   indirect(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_hdf_open_store²  s    c         C   s÷   t  t j j d d ƒ d t d ƒ d t d ƒ ƒ} d | j _ | j d d	 d
 t ƒ } t	 |  j
 ƒ ‹ } | j | d d d d d ƒt | d ƒ } t | d d t ƒ} t | t ƒ s¾ t ‚ t | j ƒ  ƒ } t j | | ƒ | j j ƒ  Wd  QXd  S(   Ni   i   R~   RD  R6  RE  RF  Rž   Ra  Rw   R€   R>   RB   Ra   R¾  R§  (   R   Rº   R  Rû  RH   R~   R:  R;  R{   RL   R3   Rl   R)   RG   R*   Rh   t   nextt   __iter__RR   R   R7   R5   (   RY   R€   R3   RQ  R§  RR  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_hdf_iteratorÄ  s    c      	   C   s§   t  t j j d d ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ _ } t j t	 t
 | d ƒ | j | d ƒ t | d	 d
 ƒ} | j ƒ  t j t	 t
 | d ƒ Wd  QXd  S(   Ni   i   R~   RD  R6  RE  RO   R€   R>   RÎ   (   R   Rº   R  Rû  RH   RL   R3   Rc   Rd   R6   R)   Rl   R&   R5   (   RY   R€   R3   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_hdf_errorsÔ  s    
c         C   s    t  j t t t d ƒ d ƒ d  S(   NR‹   R€   (   Rc   Rd   RR  R)   R   (   RY   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt#   test_read_hdf_generic_buffer_errorsà  s    c         C   s{   t  t j j d d ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ 3 } t j t	 ƒ  | j
 | d d d	 ƒWd  QXWd  QXd  S(
   Ni   i   R~   RD  R6  RE  R€   R@   t   foolib(   R   Rº   R  Rû  RH   RL   R3   Rc   Rd   RM   Rl   (   RY   R€   R3   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_invalid_complibã  s    c      	   C   s§   t  t j j d d ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ _ } | j | d d d	 ƒt | ƒ } t	 | | ƒ | j | d
 d d	 ƒt
 j t t | ƒ Wd  QXd  S(   Ni   i   R~   RD  R6  RE  R€   R>   R=   R‘   (   R   Rº   R  Rû  RH   RL   R3   Rl   R)   R   Rc   Rd   RM   (   RY   R€   R3   t   reread(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_nokeyì  s    c         C   s²   t  i t d ƒ d 6t t d ƒ d d ƒd 6ƒ } t |  j ƒ k } | j | d d d	 d
 d ƒt | ƒ } t | | ƒ | j | d d d	 d
 d ƒt	 j
 t t | ƒ Wd  QXd  S(   Ni   R   t   abacdRè   RM  R›   R€   R>   R=   Ra   Rb   R‘   (   R   R   R   RH   RL   R3   Rl   R)   R   Rc   Rd   RM   (   RY   R€   R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_nokey_tableú  s    c         C   sE   t  |  j ƒ 0 } t | ƒ } | j ƒ  t j t t | ƒ Wd  QXd  S(   N(   RL   R3   R&   R5   Rc   Rd   RM   R)   (   RY   R3   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_nokey_empty  s    
t   pathlibc      	   C   s    d d l  m } t t j j d d ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ 8 } | | ƒ } | j	 | d	 d
 d ƒt
 | d	 ƒ } Wd  QXt j | | ƒ d  S(   Niÿÿÿÿ(   t   Pathi   i   R~   RD  R6  RE  R€   R>   R=   (   R`  Ra  R   Rº   R  Rû  RH   RL   R3   Rl   R)   RR   R   (   RY   Ra  RŸ   RÂ   t   path_objRí  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_from_pathlib_path  s    s   py.pathc      	   C   s    d d l  m } t t j j d d ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ 8 } | | ƒ } | j	 | d	 d
 d ƒt
 | d	 ƒ } Wd  QXt j | | ƒ d  S(   Niÿÿÿÿ(   t   locali   i   R~   RD  R6  RE  R€   R>   R=   (   t   py.pathRd  R   Rº   R  Rû  RH   RL   R3   Rl   R)   RR   R   (   RY   t	   LocalPathRŸ   RÂ   Rb  Rí  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_from_py_localpath  s    c         C   s  t  j i d d d g d 6ƒ } t |  j ƒ á } | j d | d d d t ƒd	 } | j d d
 | ƒ } | j sx t ‚ d } | j d d | ƒ } | j	 d d g d  d  … f } t
 j | | ƒ d } | j d d | ƒ } | j	 d g d  d  … f } t
 j | | ƒ Wd  QXd  S(   Ng~  eÍÍAg$  eÍÍAg'1  eÍÍARu   R(  Ra   Rb   R„   g©  eÍÍAs   A < %.4fgÅ   eÍÍAs   A > %.4fi   i   s	   A == %.4f(   R”   R   RF   R3   Rw   R{   R†   t   emptyRh   R¼   RR   R   (   RY   R€   R7   t   cutoffR   RŸ   t   exact(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_query_long_float_literal.  s     c   
      C   s©  t  j i d d g d 6t d d d ƒd 6d d g d	 6d
 d g d 6d d d d	 d g ƒ} t |  j ƒ 9} | j d | d d d t ƒt  j d ƒ } | j d d d ƒ} | j	 d
 g d  d  … f } t
 j | | ƒ xÃd d d g D]²} xj d t t  j d ƒ t  j d
 d ƒ g D]A } d j d | ƒ } t j t ƒ  | j d d | ƒWd  QXqWd } xX d d	 d g D]G }	 d j d | d |	 ƒ } t j t ƒ  | j d d | ƒWd  QXqrWxÛ t d d d g d d	 d g ƒ D]¸ \ } }	 d j d | d |	 ƒ } | j d d | ƒ} | d k rC| j	 d g d  d  … f } nD | d k rn| j	 d
 g d  d  … f } n | j	 g  d  d  … f } t
 j | | ƒ qßWqé WWd  QXd  S(    Ns
   2014-01-01s
   2014-01-02Rá  R¯  i   t	   real_dategš™™™™™ñ?g333333ó?t   floati   R²  R6  R(  Ra   Rb   R„   Rx   s   real_date > tst   <t   >s   ==gÍÌÌÌÌÌ @RÄ   s   date {op} vt   opR=   s   {col} {op} vRÀ  R%  s   1.1i    (   R”   R   R   RF   R3   Rw   R{   R   R†   R¼   RR   R   t	   TimedeltaRa   Rc   Rd   RŽ   RM   t   zip(
   RY   R€   R7   Rü   R   RŸ   Rp  R¡  t   queryRÀ  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_query_compare_column_typeE  s@    c      
   C   sl   t  j ƒ  } t |  j ƒ ; } | j | d d d | ƒt j | d d d d ƒ} Wd  QXt  j | | ƒ d  S(   NRO   R   Ra   R>   RÎ   (   RR   t   makeFloatSeriesRL   R3   Rl   R”   R)   R!   (   RY   Ra   Rp   R3   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_hdf_series_mode_rq  s
    !s   Need python 3.6c         C   sU   t  j d ƒ @ } t j | ƒ ( } t j | ƒ t | ƒ k sE t ‚ Wd  QXWd  QXd  S(   Ns   foo.h5(   RR   t   ensure_cleanR”   R&   R0   t   fspathRÃ   Rh   (   RY   R3   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_fspath|  s    c         C   s{   t  j d d d g d t  j d d d g d d	 ƒƒ} t | d
 d d d ƒ d d ƒ } | d } t | | ƒ Wd  QXd  S(   Ng      ð?i   i   R~   s
   2015-01-01s
   2015-01-02s
   2015-01-05R  Rv   R  R   R  s*   periodindex_0.20.1_x86_64_darwin_2.7.13.h5R>   RÎ   RI   (   R”   R   t   PeriodIndexRF   R   (   RY   R  RŸ   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_read_py2_hdf_file_in_py3‚  s    	
(   i    i   (   i   i   N(   NN(¾   R]   R^   Re   Rk   R‚   R‡   R   R™   R    R¥   R¦   RÅ   t   ignore_natural_naming_warningRÆ   RÍ   RÑ   RÕ   RÚ   RÝ   Rá   Rc   t   markt   parametrizeR   Rö   Rû   Rý   R  R  t   tdt   skip_if_windows_python_3R  R  R  R  t   xfail_non_writeableR  t   filterwarningsR3  R>  RG  t   skipifR   RJ  R[  Rd  Rr  Rt  R{  R   R¡  R¢  t   paramR¦  R½  RË  RÏ  RØ  Rß  Ræ  Ré  Rî  Rï  Rþ  R  R  R  R  R  R   Rº   t   __version__R%  R*  R.  R0  R3  R?  RJ  RM  RV  RY  R\  R`  Re  Rh  Ri  Rk  Rp  Rs  RE   R{   Ry  R}  Ru  Rw  RV  R~  R€  R‚  Rƒ  R†  R‹  RŒ  RŽ  R  R‘  R’  R•  R–  R™  Rš  R£  R¦  R«  R¯  R±  R³  R·  R¹  R¼  RÀ  RÁ  RÌ  RÍ  RÐ  RÓ  RÚ  RÜ  RÞ  t   xfailRã  Rå  R+   Ræ  Rç  Rè  Rê  Rë  Rí  R/   Rñ  Rô  Rõ  R÷  R  Rg  Ru  R   R  R   R	   R  R
  R  R  R  R  R  R  R!  R#  R$  R'  R)  R3  R:  R;  R=  R>  RC  RK  RP  RS  RV  RW  RX  RZ  R\  R^  R_  t
   skip_if_noRc  Rg  Rk  Rt  Rv  R   Ry  R{  (    (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyR`   ˜   s€  					Y	*				2		=	.			(*					5	%		M	.	(	0	)	c		*		
			±	=			2	7			
H	(	
	*	(				*	%	!	L	N	3	C	6					6		-	0					$		-"		=					 	D	m	/	B	J	8	=	,	"		!	3	@		/	H	d			:				.		'				g					9				
			
	g						$											,$"t   TestHDFComplexValuesc           B   sƒ   e  Z d  „  Z d „  Z e d „  ƒ Z d „  Z e j j	 d ƒ d „  ƒ Z
 e j j	 d ƒ d „  ƒ Z d „  Z d „  Z d	 „  Z RS(
   c         C   s
  t  t j j d d ƒ j t j ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ 3 } | j	 | d ƒ t
 | d ƒ } t | | ƒ Wd  QXt  t j j d d ƒ j t j ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ 3 } | j	 | d ƒ t
 | d ƒ } t | | ƒ Wd  QXd  S(   Ni   i   R~   RD  R6  RE  R€   (   R   Rº   R  Rû  Rb  t	   complex64RH   RL   R3   Rl   R)   R   t
   complex128(   RY   R€   R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_fixed›  s    $$c         C   s  t  t j j d d ƒ j t j ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ 9 } | j	 | d d d	 ƒt
 | d ƒ } t | | ƒ Wd  QXt  t j j d d ƒ j t j ƒ d t d ƒ d t d ƒ ƒ} t |  j ƒ ? } | j	 | d d d	 d
 d ƒt
 | d ƒ } t | | ƒ Wd  QXd  S(   Ni   i   R~   RD  R6  RE  R€   Ra   Rb   R>   RB   (   R   Rº   R  Rû  Rb  R‰  RH   RL   R3   Rl   R)   R   RŠ  (   RY   R€   R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_table­  s    $$c         C   sï   t  j d d d d g d t  j ƒ} t  j d d d d g d t  j ƒ} t i d d d d g d 6d	 d
 d d g d 6| d 6| d 6d d d d g d 6d t d ƒ ƒ} t |  j ƒ 3 } | j | d ƒ t	 | d ƒ } t
 | | ƒ Wd  QXd  S(   Ng      ð?y              ð?Rè   i   i   i   i   Ru   R=   Rš   R›   Rœ   Rv   R7  R`  g       @g      @g      @Ra  R~   RD  R€   y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?(   Rº   Rë   R‰  RŠ  R   RH   RL   R3   Rl   R)   R   (   RY   R‰  RŠ  R€   R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_mixed_fixedÀ  s    c      
   C   s[  t  j d d d d g d t  j ƒ} t  j d  d! d" d# g d t  j ƒ} t i d d d d g d 6d	 d
 d d g d 6| d 6| d 6d d d d g d 6d t d ƒ ƒ} t |  j ƒ U } | j d | d d d g ƒ| j	 d d d ƒ} t
 | j | j d k | ƒ Wd  QXt |  j ƒ 9 } | j | d d d ƒt | d ƒ } t
 | | ƒ Wd  QXd  S($   Ng      ð?y              ð?Rè   i   i   i   i   Ru   R=   Rš   R›   Rœ   Rv   R7  R`  g       @g      @g      @Ra  R~   RD  R€   R„   Rx   s   A>2Ra   Rb   y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?(   Rº   Rë   R‰  RŠ  R   RH   RF   R3   Rw   R†   R   R¼   Ru   RL   Rl   R)   (   RY   R‰  RŠ  R€   R7   R   R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_mixed_tableÑ  s$    #s   ignore:\nPanel:FutureWarningc         C   s  t  d t ƒ ý t j d d d d g ƒ } t | d t d ƒ ƒ} t i | d 6| d 6ƒ } t i | d 6| d	 6ƒ } | | | g } t j	 t j
 t j g } xg t | | ƒ D]V \ } } t |  j ƒ 9 }	 | j |	 d
 d d ƒt |	 d
 ƒ }
 | | |
 ƒ Wd  QXq® WWd  QXd  S(   NRs   g      ð?y              ð?R~   RD  Ru   Rv   t   Onet   TwoRm   Ra   Rˆ   y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?(   R   R{   Rº   Rë   R   RH   R   R   RR   R!   R   R    Rr  RL   R3   Rl   R)   (   RY   RŠ  RÄ   R€   RI   Rï   t   compsRm   t   compR3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt$   test_complex_across_dimensions_fixedç  s    c         C   s	  t  j d d d d g ƒ } t | d t d ƒ ƒ} t i | d 6| d 6ƒ } t d t ƒ § t i | d 6| d	 6ƒ } | | g } t j	 t j
 g } xg t | | ƒ D]V \ } } t |  j ƒ 9 }	 | j |	 d
 d d ƒt |	 d
 ƒ }
 | | |
 ƒ Wd  QXq¥ WWd  QXd  S(   Ng      ð?y              ð?R~   RD  Ru   Rv   Rs   R  R  Rm   Ra   Rb   y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?(   Rº   Rë   R   RH   R   R   R{   R   RR   R   R    Rr  RL   R3   Rl   R)   (   RY   RŠ  RÄ   R€   RI   Rï   R‘  Rm   R’  R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_across_dimensionsù  s    c         C   s§   t  j d d d d g d t  j ƒ} t i d d d d g d 6d	 d
 d d g d 6| d 6d t d ƒ ƒ} t |  j ƒ ) } t j t	 | j
 d | d d g ƒWd  QXd  S(   Ng      ð?y              ð?Rè   i   i   i   i   Ru   R=   Rš   R›   Rœ   Rv   R7  R~   RD  R€   R„   y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?(   Rº   Rë   RŠ  R   RH   RF   R3   Rc   Rd   RŽ   Rw   (   RY   RŠ  R€   R7   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_indexing_error
  s    
c         C   sÁ   t  j d d	 d
 d g ƒ } t | d t d ƒ ƒ} t |  j ƒ & } t j t | j	 | d d d ƒWd  QXt |  j ƒ B } | j	 | d d d d t
 ƒt | d ƒ } t j | | ƒ Wd  QXd  S(   Ng      ð?y              ð?R~   RD  Rm   Ra   R¾  y      ð?      ð?y      ð?      ð?y      ð?      ð?y      ð?      ð?(   Rº   Rë   R   RH   RL   R3   Rc   Rd   RŽ   Rl   RE   R)   RR   R!   (   RY   RŠ  RÄ   R3   R[  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_series_error  s    %c      	   C   s±   t  i t j j d ƒ j t j ƒ d 6t j j d ƒ d 6ƒ } t |  j ƒ ^ } | j d | d d g ƒ| j d | ƒ | j	 d ƒ } t
 t j | | g d ƒ | ƒ Wd  QXd  S(   Nid   R=   Rš   R€   R„   i    (   R   Rº   R  R  Rb  RŠ  RF   R3   Rw   R†   R   R”   R   (   RY   R€   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_complex_append!  s    %(   R]   R^   R‹  RŒ  R  R  RŽ  Rc   R}  R‚  R“  R”  R•  R–  R—  (    (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRˆ  ˜  s   					t   TestTimezonesc           B   sb   e  Z d  „  Z d „  Z d „  Z d „  Z d „  Z d „  Z e j	 d „  ƒ Z
 d „  Z d „  Z RS(	   c         C   s™   t  j | | ƒ x‚ | j D]w } xn | j D]c } | j | | f } | j | | f } | | k oq | j | j k s* t d | | f ƒ ‚ q* q* Wq Wd  S(   Ns   invalid tz comparison [%s] [%s](   RR   R   R6  R~   R¼   R&  Rh   (   RY   R=   Rš   R›   R   t   a_et   b_e(    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   _compare_with_tz.  s    c            sž  d d l  m } d d l m ‰  ‡  f d †  } t |  j ƒ ‹} t | d ƒ t t d g  t	 d ƒ D]/ } t
 d d	 | d
 ƒ ƒ| d d ƒ | ^ qd ƒ ƒ } | j d | d d g ƒ| d } |  j | | ƒ t | | ƒ | | j | j d k } | j d d d ƒ} |  j | | ƒ t | d ƒ t t d t
 d d	 | d
 ƒ ƒd t
 d d	 | d
 ƒ ƒƒ d t	 d ƒ ƒ} | j d | ƒ | d } |  j | | ƒ t | | ƒ t t d t
 d d	 | d
 ƒ ƒd t
 d d	 | d ƒ ƒƒ d t	 d ƒ ƒ} t j t | j d | ƒ t | d ƒ | j d | d d d g ƒ| d } |  j | | ƒ t | | ƒ t t d t
 d d	 | d
 ƒ ƒd t
 d d	 | d ƒ ƒƒ d t	 d ƒ ƒ} t j t | j d | ƒ Wd  QXt |  j ƒ ¾ } t t d t t d ƒ d t d d d d d d	 | d
 ƒ ƒƒƒ ƒ } t | d ƒ | j d | ƒ | j d ƒ } t | | ƒ t | d ƒ | j d | ƒ | j d ƒ } t | | ƒ Wd  QXd  S(   Niÿÿÿÿ(   R   (   t   maybe_get_tzc            s   ˆ  d |  ƒ S(   Ns	   dateutil/(    (   Rú   (   Rœ  (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyRm  A  s    t   df_tzRu   i   s   20130102 2:00:00R&  s
   US/Easternt   hoursi   R„   i   Rx   s
   A>=df.A[3]Rø  Rv   t   20130603R~   t   EETt   CETs   2000-1-1R¯  R  R´  R€   (   Rµ   R   t   pandas._libs.tslibs.timezonesRœ  RF   R3   RP   R   R}   R   R   Rw   R›  R   Ru   R†   Rc   Rd   RM   R   R
   R   R–   (   RY   R   t   gettzR7   R   R€   R   RŸ   (    (   Rœ  s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt#   test_append_with_timezones_dateutil:  sd    E
	

*c         C   sC  d d l  m } t |  j ƒ U} t | d ƒ t t d g  t d ƒ D]) } t d d d ƒ| d	 d
 ƒ | ^ qE ƒ ƒ } | j	 d | d d g ƒ| d } |  j
 | | ƒ t | | ƒ |  j
 | j d d d ƒ| | j | j d k ƒ t | d ƒ t t d t d d d ƒd t d d d ƒƒ d t d ƒ ƒ} | j	 d | ƒ | d } |  j
 | | ƒ t | | ƒ t t d t d d d ƒd t d d d ƒƒ d t d ƒ ƒ} t j t | j	 d | ƒ t | d ƒ | j	 d | d d d g ƒ| d } |  j
 | | ƒ t | | ƒ t t d t d d d ƒd t d d d ƒƒ d t d ƒ ƒ} t j t | j	 d | ƒ Wd  QXt |  j ƒ ¸ } t t d t t d ƒ d t d d d d d d d ƒƒƒ ƒ } t | d ƒ | j d | ƒ | j d ƒ } t | | ƒ t | d ƒ | j	 d | ƒ | j d ƒ } t | | ƒ Wd  QXd  S(   Niÿÿÿÿ(   R   R  Ru   i   s   20130102 2:00:00R&  s
   US/EasternRž  i   R„   Rx   s
   A>=df.A[3]i   Rø  Rv   RŸ  R~   R   R¡  s   2000-1-1R¯  R  R´  R€   (   Rµ   R   RF   R3   RP   R   R}   R   R   Rw   R›  R   R†   Ru   Rc   Rd   RM   R   R
   R   R–   (   RY   R   R7   R   R€   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_append_with_timezones_pytz…  sV    ?
'

$c      	   C   s·  t  d d ƒ } t t j j t | ƒ d ƒ d | ƒ} t |  j ƒ J } | j d | ƒ | j	 d d ƒ } | j
 t | j ƒ j
 k s‹ t ‚ Wd  QXt  d d d d ƒ} t t j j t | ƒ d ƒ d | ƒ} t |  j ƒ D } | j d | ƒ | j	 d d ƒ } | j
 | j j
 k st ‚ Wd  QXt  d d d d ƒ} t t j j t | ƒ d ƒ d | ƒ} t |  j ƒ D } | j d | ƒ | j	 d d ƒ } | j
 | j j
 k s­t ‚ Wd  QXd  S(	   Ns   1/1/2000s	   1/30/2000i   R~   Rr   R&  R„  s
   US/Eastern(   R   R   Rº   R  R  RC   RF   R3   Rw   RÑ  R&  R   RW  Rh   R#  (   RY   R  Rr   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt    test_tseries_select_index_columnÇ  s$    '''!'c      	   C   sü   t  |  j ƒ ç } t d d d d ƒ} t t j j t | ƒ d ƒ d | ƒ} | | d <| d } t | | ƒ t	 | d ƒ t i | d 6| j
 d	 ƒ j d  ƒ d
 6| j
 d ƒ d 6t t | ƒ ƒ d 6d | ƒ} | | d <| d } t | | ƒ Wd  QXd  S(   Ns   1/1/2000s	   1/30/2000R&  s
   US/Easterni   R~   R€   Ru   R„  Rv   R¡  R7  R`  (   RF   R3   R   R   Rº   R  R  RC   R   RP   t
   tz_convertR…  R/   R   (   RY   R7   R  R€   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_timezones_fixedç  s    '



c         C   s”   t  d d ƒ } t t j j t | ƒ d ƒ d | ƒ} t |  j ƒ I } | | d <| d } t j	 | j
 | ƒ | j | j
 j k sŠ t ‚ Wd  QXd  S(   Ns   1/1/2000 00:00:00-07:00s   1/30/2000 00:00:00-07:00i   R~   Rr   (   R   R   Rº   R  R  RC   RF   R3   RR   RÝ  R~   R&  Rh   (   RY   R  Rr   R7   R)  (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_fixed_offset_tzü  s    '

c         C   s  t  |  j ƒ a } t j d d d ƒ } t d d d g d | | | g ƒ} | | d <| d } t | | ƒ Wd  QXt  |  j ƒ ‡ } t d	 ƒ H t j d d d ƒ } t d d d g d | | | g ƒ} | | d <Wd  QXt d
 ƒ  | d } Wd  QXt | | ƒ Wd  QXd  S(   NiÝ  i	   i
   i   i   i   R~   R¨   t   EST5EDTt   CST6CDT(   RF   R3   Rµ   Rá  R   R   R"   (   RY   R7   Rn  R€   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_store_timezone  s    $

$c      	   C   s„   t  t d t d d d ƒd t d d d ƒƒ d t d	 ƒ ƒ} t | d
 d d d ƒ d d ƒ } | d } t | | ƒ Wd  QXd  S(   NRu   Rø  R&  s
   US/EasternRv   RŸ  R¡  R~   i   R  R   R  s   datetimetz_object.h5R>   RÎ   R€   (   R   R}   R   R   RF   R   (   RY   R  RŸ   R7   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_legacy_datetimetz_object"  s    
c         C   sÉ   t  |  j ƒ ´ } t j d d d d d d d d ƒ} x† | | t j d	 ƒ g D]k } t | d
 ƒ t i t t | ƒ ƒ d 6| d 6d | ƒ} | j	 d
 | ƒ | j
 d
 ƒ } t | | ƒ qP WWd  QXd  S(   Ns   2013-10-26 23:00s   2013-10-27 01:00R&  s   Europe/LondonR  R´  t	   ambiguoust   infert   10minR€   Ru   Rv   R~   (   RF   R3   R”   R   Rq  RP   R   R   RC   Rw   R†   R   (   RY   R7   t   timesR   R€   R   (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   test_dst_transitions.  s    	 ,(   R]   R^   R›  R¤  R¥  R¦  R¨  R©  R  t   skip_if_windowsR¬  R­  R²  (    (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyR˜  ,  s   		K	B	 		
	(]   t
   contextlibR    Rµ   R   t   distutils.versionR   R0   R:   t   warningsR   R   t   numpyRº   Rc   t   pandas.compatR   R   R   R   R	   R
   R   R   R   t   pandas.util._test_decoratorst   utilt   _test_decoratorsR  t   pandas.core.dtypes.commonR   R[  R”   R   R   R   R   R   R   R   R   R   R   R   R   R   R   R   R   t   pandas.util.testingR!  RR   R   R    R!   R"   t	   pandas.ioR#   t   pandas.io.formats.printingR$   t   pandas.io.pytablesR%   R&   R'   R(   R)   R*   t   importorskipR+   R}  R†  R…  R  Rø  R‚  R|  R4   R8   R<   R/   RE   RF   RL   t
   parameterst   MAX_NUMEXPR_THREADSt   MAX_BLOSC_THREADSt   MAX_THREADSRP   RV  RQ   t   singleR`   Rˆ  R˜  (    (    (    s<   lib/python2.7/site-packages/pandas/tests/io/test_pytables.pyt   <module>   s€   @j"(											ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ÿ ”