Help reduce number of rows by grouping continous data

Question

Youssif Youssif 2022-11-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1866743-help-reduce-number-of-rows-by-grouping-continous-data

回答： David Hill 2022-11-29

Annotation 2022-11-29 115531.png

Hello,

as seen in the attached image, does anyone know how I can reduce the number of rows by grouping the first and last number of data that are squential. Ex) the first cell should say 20390-20400 because thats the first and last point in which continous data by differnce of 1 is present. the second row should say 22579-22588, then third row should say 25895-25904.

Thanks

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

请先登录，再进行评论。

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

Answer 1

David Hill 2022-11-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1866743-help-reduce-number-of-rows-by-grouping-continous-data#answer_1115478

在 MATLAB Online 中打开

d=find(diff(yourData)>1);
m=[yourData(1),yourData(d(1))];
for k=2:length(d)
   m(k,:)=[yourData(d(k-1)+1),yourData(d(k))];%generate matrix with beginning to end of each stream
end
m(end+1,:)=[yourData(d(end)+1),yourData(end)]