How do you count how many values are in an array until a given number?

9 Ansichten (letzte 30 Tage)
I have an array of values, it starts with integers then some zeros appear before finally more integers and then more zeros. I am looking to find a way to cut the array short before the second set of zeros appear.
The minimum value always occurs in column 5 of the second set of integers so I thought I could find the minimum value and cut if off there, however to do this I need to know how what row this minimum number occurs at. Ive seen in some forums that the find function may be able to be used however I cant get it to work. An extract of my script is posted below.
data = csvread(['groupC0',num2str(i),'.CSV'],6,0);
limit = find(data,min(data(:,5)))
truedata = data(1:limit,3:8);
  1 Kommentar
Jan
Jan am 24 Apr. 2013
The text description of the inputs is not clear. Are you talking about a vector or a matrix? If it is a matrix, do the zero blocks have the same position in each row (or column?)?

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Jan
Jan am 24 Apr. 2013
x = [1,2,3,4,5,0,0,0,0,4,3,2,4,2,0,0,0,0,4,3,2]; % Does this match your data?!
zeroBlockStart = strfind(x == 0, [false, true]) + 1;
Now you have the indices, where the blocks of zeros start. Does this help already?
  1 Kommentar
Dave
Dave am 24 Apr. 2013
Thanks for your response, it was imported as a matrix but I was only looking for the maximum value in one column. I made it work by using:
data = csvread(['groupC0',num2str(i),'.CSV'],6,0);
[r minloc] = find(data==min(data(:,5)));
truedata = data(1:r,3:8);

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Operators and Elementary Operations finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by