Extracting data from .mat file

Question

Usman Ali 2012-11-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55041-extracting-data-from-mat-file

Hi everyone, I have received a *.mat file from my supervisor that contains 4 tables. every table is constructed on hourly based data from a power generator, 24 hours a day and 365 days a year. so it (24*365)= 8760x1 table. that the properties of the table ''Time vector characteristics

      Length                8760
      Start date            01-Jan-2006 01:00:00
      End date              01-Jan-2007 00:00:00
''

I need to extract data from the table in such form that I re-arrange it into 365x24 matrix so that every row show data for 1 day with 24 hours.

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

请先登录，再进行评论。

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

Answer 1

Mitch Martelli 2012-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55041-extracting-data-from-mat-file#answer_66857

在 MATLAB Online 中打开

Sorry i dont understand well your question

to extract the data you can try to use getEntry, documentation are reported in the link below :

http://www.mathworks.it/it/help/slvnv/ref/modeladvisor.tableclass.html.

Moreover if i understand well your aim reshape(xxx,365,24) dont give you what you want.

B = reshape(xxx,24,365);
B=B';

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Usman Ali 2012-12-6

Actually I had a time series data with time stamp and data in the array that's why reshape is not working. NOw I extracted the data and time seperately from the file and save to another variable. and then applied the reshape, it works now.

请先登录，再进行评论。

Answer 2

Mitch Martelli 2012-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55041-extracting-data-from-mat-file#answer_66784

在 MATLAB Online 中打开

Hi, You can use the reshape function.

Example :

data=rand(8760,1)
B = reshape(data,24,365);
B=B';

Regards

M1tC4

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

请先登录，再进行评论。

Answer 3

Image Analyst 2012-11-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/55041-extracting-data-from-mat-file#answer_66786

在 MATLAB Online 中打开

What is stored in the mat file? Is it a structure with a cell array with 4 cells, and inside each cell is another cell array that is the table? So basically in other words there are 4 tables. And each table is an (N rows) by (3 columns) cell array where each of those cells contains a string? Because that's what you're showing. Can you do this and tell us what shows up in the command window:

storedStructure = load(yourMatFileName);
whos storedStructure
storedStructure

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Usman Ali 2012-11-28

Sorry I am newbie to matlab so not clear about structures etc. the .mat file contains 4 arrays (tables). if I check the size of each array it show (8760x1), but when i double click on the table, shows format like times series. u can see that in attached picture. https://www.dropbox.com/s/7dllq5alm0zuffr/test.jpg

I would like to extract data from last table zr513..

I tried it with reshape(zr513,365,24); but it give this error, 'To RESHAPE the number of elements must not change'

请先登录，再进行评论。