0

I have this file: Mat file

I would like to convert this file to dataframe (6 columns). I have tried many methods on the internet but I did not get the dataframe I wish. The most effective code I have tried up to now: Code example

With that code, I expected that I would get a simple 2D array but actually I got this:

[[(array([[(array(['MINA-AL-AHMADIIHO'], dtype='<U17'), array([[722816. ], [722816.02083333], [722816.04166667], ..., [738520.95833333], [738520.97916667], [738521. ]]), array([[ 0.48548031], [ 0.1852848 ], [-0.13867281], ..., [-0.73255387], [-0.84586626], [-0.9156132 ]]), array(['scalar'], dtype='<U6'), array([[753841, 0, 0, 0, 0]]))]], dtype=[('name', 'O'), ('time', 'O'), ('val', 'O'), ('quantity', 'O'), ('size', 'O')]),)]]

With that I only create a dataframe 2 columns (I expect to get a dataframe 6 columns) like this: enter image description here

Anyone has ideas please help me, thank in advance!

Jakhanh
  • 11
  • 3

0 Answers0