Data Sorting (looking for a range that do not exist in a list of numbers)

Question

Curious Mind 2019-11-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494028-data-sorting-looking-for-a-range-that-do-not-exist-in-a-list-of-numbers

编辑： Stephen23 2019-11-30

Book1.xlsx

Hi All,

Assume I have a column vector (please see attached) and it contains numbers but its not contineous. That is, say I have the numbers 1,2,3,6,7,8,23,24,25, 76,77 etc. I want to list the point where there was a jump, so in this case it will be 3,6 and 8,23 and 25,76.

Also after that, if possible, I would like to add '1' to the first value identified and substract '1' from the second value. For an illustration, 3,6 has been identified, so it will become 4,5. Which means among the numbers listed, 4 to 5 does not exist in the data and likewise 9 and 22 (in the case for 8,23) does not exist. I need these ranges that do not exists in the list of the numbers.

Any ideas?

Thank you

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2019-11-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/494028-data-sorting-looking-for-a-range-that-do-not-exist-in-a-list-of-numbers#answer_404020

编辑：Stephen23 2019-11-30

在 MATLAB Online 中打开

>> V = [1,2,3,6,7,8,23,24,25,76,77];
>> X = diff(V)~=1;
>> B = V([X,false])+1 % missing range begin values
B =
    4    9   26
>> E = V([false,X])-1 % missing range end values
E =
    5   22   75