Sorting data in one column based on the time stamps in the alternate column

3 次查看（过去 30 天）

Krispy Scripts 2016-10-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307748-sorting-data-in-one-column-based-on-the-time-stamps-in-the-alternate-column

评论： Walter Roberson 2016-10-18

In one matrix, one column has data and the column next to it has time stamps. I have another matrix where the first column is start times and the second column is stop times of the interval. I would like to get the data from the first matrix based on the intervals of the second matrix, where the intervals correspond to the time stamps in the first matrix second column. I would like to output the data into a matrix, where the interval data is in individual columns in that matrix.

Does this make sense? I have attached example matrices. So from the first column dataset.mat, I want the data set that corresponds to the interval.mat (3 intervals) and output them into three different columns corresponding to each interval.

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

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2016-10-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307748-sorting-data-in-one-column-based-on-the-time-stamps-in-the-alternate-column#answer_239444

在 MATLAB Online 中打开

selected = arrayfun(@(ROW) dataset(dataset(:,2) >= intervals(ROW,1) & dataset(:,2) <= intervals(ROW,2), 1), 1:size(intervals,1), 'Uniform', 0);
if all(diff(cellfun(@length, selected)) == 0)
  selected = horzcat( selected{:} );
else
  fprintf('the intervals select different number of rows, had to leave selected as a cell array\n');
end

5 个评论
显示 3更早的评论隐藏 3更早的评论

Krispy Scripts 2016-10-18

Ah, thank you so much. My code was splitting different sets of intervals into intervals and adding extra intervals of 0 that were causing the problem you described above.