loop indexing length of non zeroes

1 次查看(过去 30 天)
Hi, I'm trying to make a loop that finds the length of a sequence of numbers:
I want to find when x(:,4) is not equal to zero, and then find how long it's is the same number, I want to save the number and the start row, and the end row.
my output should look something like this:
Id start end length
10 1320 1331 11
9 1352 1354 3
Screenshot 2019-06-02 at 14.48.05.png
thanks for any help
  3 个评论
Morten Jørgensen
thanks a lot
Is it possible to igore when there i zero?
Adam Danz
Adam Danz 2019-6-5
编辑:Adam Danz 2019-6-10
Have you tried the answer I proposed below? It ignores 0s as you described.

请先登录,再进行评论。

回答(2 个)

Adam Danz
Adam Danz 2019-6-3
编辑:Adam Danz 2019-6-4
Here are the steps needed to build your table.
% Create fake data that looks like your example
x = rand(2000,5);
x(:,4) = 0;
x(1320:1331,4) = 10;
x(1352:1354,4) = 9;
% calculate table components
isZero = x(:,4)==0;
dz = [0;diff(isZero)];
start = find(dz == -1); %start column
endIdx = find(dz == 1)-1; %end column
ID = x(start,4); %ID column
len = endIdx - start; %Length column
% Create table
T = table(ID,start,endIdx,len,'VariableNames', {'Id','start','endIdx','length'});
Result
T =
2×4 table
Id start endIdx length
__ _____ ______ ______
10 1320 1331 11
9 1352 1354 2
* Note that 'end' is not a valid variable name nor a valid table column name.

Steven Lord
Steven Lord 2019-6-3
You can use the ischange function to identify abrupt changes in your data (the jump from 0 to 10 and the drop from 10 back down to 0.)

类别

Help CenterFile Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by