MATLAB: How to count the number of consecutive values

cell arrayconsecutivecount

Hi! I have Location(1,4).loc that is a 137×19 cell array. I want to find the number of time that first column have value '674' and the consecutive value in the second column is '673'. How can I do?

Best Answer

Use strcmp, which works well for cell arrays of strings. Compare the first column to the string '674' and the second column to '673'.

x = Location(1,4).loc;
sum(strcmp(x(:,1),'674') & strcmp(x(:,2),'673'))

When I ran the above code on the data you provided, I got a result of 13.

Related Solutions

MATLAB: Compare strings of different dimensions

s1={'1' '631' '618' '574' '678'} ;
s2={'1' '596' '674' '' '';
     '674' '631' '1' '631' '1';
     '641' '617' '674' '631' '654';
     '674' '673' '674' '673' '674';
     '674' '618' '1' '618' '631';
     '631' '1' '631' '674' '740';
     '739' '740' '733' '674' '631';
     '674' '673' '674' '1' '641';
     '618' '1' '631' '618' '631';
     '674' '631' '618' '631' '618';
     '674' '631' '1' '631' '625';
     '641' '642' '618' '631' '618';
     '618' '631' '1' '631' '1'} ;
[m,n] = size(s2) ;
comp = zeros(size(s2)) ;
 for i = 1:m
     comp(i,:) = strcmp(s1,s2(i,:)) ;
 end

Compare each row of s2 with s1.

MATLAB: Find how many times sequences are present in a string array

Here is one way to do it:

First, convert T into a matrix of number with str2double. The empty strings will be converted to NaNs, I assume NaN is never present in S anyway:

TT = str2double(T);

You can then iterate over the rows of S and use ismember or bsxfun(@eq...) to check for equality, only using the required numbers of columns from TT:

count = cellfun(@(s) sum(all(bsxfun(@eq, s, TT(:, 1:numel(s))), 2)), S)

note: in actually code, please use better variable names than S, T and TT.

Best Answer

Related Solutions

MATLAB: Compare strings of different dimensions

MATLAB: Find how many times sequences are present in a string array

Related Question