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

1 次查看（过去 30 天）
Krispy Scripts
Krispy Scripts 2016-10-17
评论： 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.

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

采纳的回答

Walter Roberson
Walter Roberson 2016-10-17
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更早的评论
Krispy Scripts
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.
Walter Roberson
Walter Roberson 2016-10-18
I would need to recheck the code for the case where there was only one interval
Okay I checked and the code will work for that case.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by