HDF5 dataset from MATLAB to Pandas DataFrame in Python

Question

I have .mat files with HDF5 data and I want to load it into Python (Pandas DataFrame). I can load the file:

f2 = h5py.File("file.mat")
f2['data']

which is an HDF5 dataset:

<HDF5 dataset "data": shape (9999999, 32), type "<f8">

If I read it with Pandas:

g = pd.read_hdf("file.mat",'data')

I get the following error:

cannot create a storer if the object is not existing nor a value are passed

How do I convert this to a Pandas DataFrame?

MaxU - stand with Ukraine · Accepted Answer · 2017-05-26 22:50:40Z

1

AFAIK you can't read HDF5 files using Pandas methods, that have NOT been written using Pandas.

You can read them using one of the following approaches:

answered May 26, 2017 at 22:50

212k37 gold badges402 silver badges436 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I suppose knowing it can't be done is the answer I'll have to settle for. I'll probably go the numpy array route. Thanks for the info.