applying timerange to a number of .mat files containing timetables

Question

minomi 2018-4-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393895-applying-timerange-to-a-number-of-mat-files-containing-timetables

评论： minomi 2018-7-3

I have a series of .mat files containing timetables that I have created by creating a table fist and then converting that to timetables using table2timetable. I then save the timetables in a location.

I then want to be able to create a datastore for the folder with all the timetables (.mat files), then create tall arrays, and then convert the tall array to timetables so that I can apply the timerange function to select data from all the files in the folder corresponding to the start and end time of the timerange.

Every method that I try has an issue somewhere along the steps described above. Either I am not able to use timerange with .mat files, or writetable does not create timetables, etc ...

2 个评论
显示无隐藏无

Hatem Helal 2018-4-12

How are you importing the data into matlab? Are you using datastore or readtable or something else? I think you might be able to bypass writing an intermediate copy of the data but some additional details would be helpful.

minomi 2018-5-2

I'm using datastore.

请先登录，再进行评论。

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

Answer 1

Anandan Rangasamy 2018-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393895-applying-timerange-to-a-number-of-mat-files-containing-timetables#answer_314640

编辑：Anandan Rangasamy 2018-4-11

在 MATLAB Online 中打开

I think the right way to do this is to begin with tall timetables first, that way you don't mess up the way timetables are formatted differently from different .mat files.

Did you try to create tall timetables and call write on the tall timetable you have? I think this will help you streamline your workflow. Here is the documentation for tall/write: tall/write

Note that you can create tall timetables from in-memory timetables, as well:

>> MeasurementTime = datetime({'2015-12-18 08:03:05';'2015-12-18 10:03:17';'2015-12-18 12:03:13'});
>> Temp = [37.3;39.1;42.3];
>> Pressure = [30.1;30.03;29.9];
>> WindSpeed = [13.4;6.5;7.3];
>> TT = timetable(MeasurementTime,Temp,Pressure,WindSpeed);
>> TT = retime(TT,'hourly','linear');
>> tallTT = tall(TT)
>> write('./myTimeTables', tallTT);

Later on, you can recreate the same tall timetable from the snapshot:

>> recreatedTallTT = tall(datastore('./myTimeTables'))

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

minomi 2018-7-3

thanks and sorry for the late reply. I think one main issue I have is that using "write" or "writetable" seems to be very slow but in order to use "timerange" I would need to save the tables in ".txt" and hence I need to use the "write" functions as oppose to saving timetables as ".mat files.

请先登录，再进行评论。