Converting byte array/MySQL BLOB to list/Numpy array of float32 in Python?

Question

I have a list of float32 numbers stored as BLOB on MySQL, I have the following script to read it from my database, it looks like mydata is of type bytearray, how can I convert it to a list or Numpy array of type float32?

query = ("SELECT mydata FROM mytable LIMIT 0,100")
cursor.execute(query)

for (mydata,) in cursor:
    print mydata  # bytearray(b"\xbe\xefe\x00#\xdf\x10\x...

Thanks!

dontloo · Accepted Answer · 2016-03-16 02:44:12Z

1

np.frombuffer(mydata, dtype=np.float32) seems to work.

answered Mar 16, 2016 at 2:44

dontloo

11.1k4 gold badges36 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

Converting byte array/MySQL BLOB to list/Numpy array of float32 in Python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related