<jupyter_start><jupyter_text>HDF5 API:list usefull HDF5 methods<jupyter_code>import sys
import wltp
from pathlib import Path

## Add tests/ into `sys.path` to import `vehdb` module.
#
proj_dir = str(Path(wltp.__file__).parents[1] / "tests")
if proj_dir not in sys.path:
    sys.path.insert(0, proj_dir)

import vehdb
def print_h5API(displaywidth=160):
    from columnize import columnize
    from pandas import HDFStore

    with vehdb.openh5('WltpCars.h5') as h5db:
        print('HDFStore:', 
              columnize([f for f in dir(h5db) if not f.startswith('__')], displaywidth=displaywidth),
              '%s (accessed by `<HDFStore-instance>._handle`):' % type(h5db._handle), 
              columnize([f for f in dir(h5db._handle) if not f.startswith('__')], displaywidth=displaywidth),
              '%s:' % type(h5db.root), 
              columnize([f for f in dir(h5db.root) if not f.startswith('__')], displaywidth=displaywidth),
              '%s:' % type(h5db.root._v_attrs), 
              columnize([f for f in dir(h5db.root._v_attrs) if not f.startswith('__')], displaywidth=displaywidth),
             sep='\n')
print_h5API()<jupyter_output>HDFStore:
_check_if_open  _filters     _path             append              create_table_index  get_node    is_open    open    select                 walk
_complevel      _fletcher32  _read_group       append_to_multiple  filename            get_storer  items      put     select_as_coordinates
_complib        _handle      _validate_format  close               flush               groups      iteritems  remove  select_as_multiple   
_create_storer  _mode        _write_to_group   copy                get                 info        keys       root    select_column        

<class 'tables.file.File'> (accessed by `<HDFStore-instance>._handle`):
_File__get_root_group      _doundo              _log                    copy_children         create_soft_link  format_version      isopen       rename_node  
_check_group               _flush_file          _node_kinds             copy_file             create_table      get_current_mark    iter_nodes   root         
_check_open                _g_new[...]<jupyter_text>Help on extracting tables from excel:<jupyter_code>pip install pandalone -U 

from pandalone import xleash 
xleash?<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.08139534883720931, 'fraction_numerical': 0.00904392764857881, 'mean_word_length': 2.3185714285714285, 'pattern_counts': {'":': 0, '<': 11, '<?xml version=': 0, '>': 11, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '2', 'dir': 'jupyter-structured-clean-dedup', 'id': '312254', 'license': 'Apache-2.0', 'n_tokens_mistral': 741, 'n_tokens_neox': 725, 'n_words': 167, 'path': 'Notebooks/HDF5-API-help.ipynb', 'repo_name': 'qinfeng2011/wltp', 'size': '2322'}