Accessing and synchronizing timetables in cell array?

Question

Mikaela Martiros 2023-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907335-accessing-and-synchronizing-timetables-in-cell-array

评论： Mikaela Martiros 2023-2-7

salinity_code_troubleshoot.mat

I've been working on a script to examine salinity around specific time ranges around high tide (e.g. +/- 30 min, 1 hour, 2 hours, etc), and I'm trying to keep it as systematic as possible so that I can import different dates/locations and run it without any changes. Right now I'm at the point where I have a 296x1 cell array (mr2), with a 5x1 timetable in each cell. Essentially, I'm trying to extract the timetables from this cell array to create one combined timetable. Each timetable has the same variable, and the timestamps are chronological going through cells 1:296. I've been attempting this through a for loop, although I think I'm having an issue with the indexing.

%% Convert cell array to timetable
lengthmr = length(mr2).*5;
iterations = zeros(lengthmr,1);
sz = [lengthmr 2];
varTypes = ["datetime","double"];
varNames = ["Timestamp","Sal_psu"];
T = table('Size',sz,'VariableTypes',varTypes,'VariableNames',varNames);
for i = 1:length(iterations)
    T(i,"Sal_psu") = mr2{i,1}(i,1);
end

The error message I receive is:

Error using ()

Row index exceeds table dimensions.

Error in COMPARE_salinity_model_MRB_v2m (line 46)

T(i,"Sal_psu") = mr2{i,1}(i,1);

So I know the indexing I'm doing is quite off, but I've been trying to troubleshoot for a few days now and thought I'd reach out to the community. I will also attach the variables to run this bit of code.

TIA!

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

Mikaela Martiros 2023-2-6

Also, apologies if this is a bit clunky! I tend to write scripts by working through my logic step by step, so I often have a lot of variables or a lot of steps for fairly simple processes. I usually work these out after getting what I need from the code, but yeah, be gentle!

请先登录，再进行评论。

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

Answer 1

Stephen23 2023-2-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907335-accessing-and-synchronizing-timetables-in-cell-array#answer_1165360

编辑：Stephen23 2023-2-7

在 MATLAB Online 中打开

salinity_code_troubleshoot.mat

Do not use a loop for this! The simple MATLAB approach is to use a comma-separated list:

https://www.mathworks.com/help/matlab/matlab_prog/comma-separated-lists.html

https://www.mathworks.com/matlabcentral/answers/1656435-tutorial-comma-separated-lists-and-how-to-use-them

For example:

S = load('salinity_code_troubleshoot.mat');
mr2 = S.mr2
mr2 = 296×1 cell array
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
    {5×1 timetable}
T = vertcat(mr2{:}) % comma-separated list
T = 1480×1 timetable
TimestampSal_psu__________________________2022-05-12 19:30:00      6.25 
    2022-05-12 19:45:00      7.09 
    2022-05-12 20:00:00      7.78 
    2022-05-12 20:15:00       8.2 
    2022-05-12 20:30:00      8.37 
    2022-05-13 08:00:00      6.54 
    2022-05-13 08:15:00      7.13 
    2022-05-13 08:30:00      7.82 
    2022-05-13 08:45:00      8.04 
    2022-05-13 09:00:00       8.1 
    2022-05-13 20:30:00      8.63 
    2022-05-13 20:45:00      9.38 
    2022-05-13 21:00:00      9.82 
    2022-05-13 21:15:00     10.08 
    2022-05-13 21:30:00     10.22 
    2022-05-14 08:45:00      6.32 