Sorting data in one column based on the time stamps in the alternate column
조회 수: 3 (최근 30일)
이전 댓글 표시
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
채택된 답변
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
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!