Import struct with different data type to python dataframe

Question

rodologie 2023-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2009682-import-struct-with-different-data-type-to-python-dataframe

编辑： Daniele Sportillo 2023-8-21

采纳的回答： Daniele Sportillo

file.mat

在 MATLAB Online 中打开

Hi,

I tried using python to load the data stored in a matlab struct - the struct i in a file attached.

Here is what I tried:

import scipy.io
import pandas as pd
mat = scipy.io.loadmat("file.mat")
data = mat["struct"]

Then, when I look to what is inside of 'data' I have this:

array([[(MatlabOpaque([(b'', b'MCOS', b'string', array([[3707764736],
                             [         2],
                             [         1],
                             [         1],
                             [         1],
                             [         1]], dtype=uint32))          ],
                     dtype=[('s0', 'O'), ('s1', 'O'), ('s2', 'O'), ('arr', 'O')]), MatlabOpaque([(b'', b'MCOS', b'datetime', array([[3707764736],
                             [         2],
                             [         1],
                             [         1],
                             [         2],
                             [         2]], dtype=uint32))            ],
                     dtype=[('s0', 'O'), ('s1', 'O'), ('s2', 'O'), ('arr', 'O')]), MatlabOpaque([(b'', b'MCOS', b'duration', array([[3707764736],
                             [         2],
                             [         1],
                             [         1],
                             [         3],
                             [         3]], dtype=uint32))            ],
                     dtype=[('s0', 'O'), ('s1', 'O'), ('s2', 'O'), ('arr', 'O')]), array([[1.0082, 1.0102, 1.01  ]]))                            ]],
      dtype=[('Name', 'O'), ('init', 'O'), ('age', 'O'), ('measure', 'O')])

Hoy can I get the data stored in the mat file then?

Thanks in advance for your help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Daniele Sportillo 2023-8-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2009682-import-struct-with-different-data-type-to-python-dataframe#answer_1290272

编辑：Daniele Sportillo 2023-8-21

在 MATLAB Online 中打开

Hi,

first of all, I suggest you rename the variable struct in your file: struct is a MATLAB data type, and that may create problems with your code.

Then, you can use the MATLAB Engine API for Python (Call MATLAB from Python - MATLAB & Simulink (mathworks.com)) to load your .mat file.

import matlab.engine
eng = matlab.engine.start_matlab()
s = eng.load('file.mat')

You'll be able to directly use some of the fields in your structure. For other fields (e.g., datetime) you would need to first convert them

import matlab.engine
from datetime import datetime
eng = matlab.engine.start_matlab()
s = eng.load('file.mat')
print(s['struct']['measure'])
print(datetime.strptime(eng.string(s['struct']['init']),'%d-%b-%Y %H:%M:%S'))