清空筛选条件
清空筛选条件

how to count the number of consecutive values

5 次查看（过去 30 天）
pamela sulis
pamela sulis 2016-3-29
评论： pamela sulis 2016-3-30
Hi! I have Location(1,4).loc that is a 137x19 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?

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

采纳的回答

Matthew Eicholtz
Matthew Eicholtz 2016-3-29
编辑：Matthew Eicholtz 2016-3-29
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.
  3 个评论
显示 1更早的评论
Matthew Eicholtz
Matthew Eicholtz 2016-3-29
I assume you mean something like this?
y = {'1' '256'; '674' '631'; '674' '673'}; %target values
for ii=1:size(y,1)
cnt(ii) = sum(strcmp(x(:,1),y{ii,1}) & strcmp(x(:,2),y{ii,2}));
end

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Title 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by