Get list of HDF5 contents (Pandas HDFStore)

python pandas hdf5 hdfstore
bcollins picture bcollins · Feb 27, 2015 · Viewed 16.6k times · Source

I have no problem selecting content from a table within an HDF5 Store:

with pandas.HDFStore(data_store) as hdf:
    df_reader = hdf.select('my_table_id', chunksize=10000)

How can I get a list of all the tables to select from using pandas?

Answer

kalu picture kalu · Sep 28, 2015

hdf.keys() returns a (potentially unordered) list of the keys corresponding to the objects stored in the HDFStore (link)

Related questions

pandas - How to save only selected columns of a DataFrame to HDF5

I'm reading a csv sample file and store it on .h5 database. The .csv is structured as follows: User_ID;Longitude;Latitude;Year;Month;String 267261661;-3.86580025;40.32170825;2013;12;hello world 171255468;-3.83879575;40.05035005;2013;12;hello world 343588169;-3.70759531;40.4055946;2014;2;hello world 908779052;-3.8356385;40.1249459;2013;8;hello world 289540518;-3.6723114;40.3801642;2013;11;hello world 635876313;…

Read More
Get column names (headers) from hdf file

I was wondering how to get the column names (seemingly stored in the hdf header) of an hdf file; for example, a file might have columns named [a,b,c,d] while another file has columns [a,b,c] and …

Read More
"Large data" work flows using pandas

I have tried to puzzle out an answer to this question for many months while learning pandas. I use SAS for my day-to-day work and it is great for it's out-of-core support. However, SAS is horrible as a piece of …

Read More