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

Count number of rows without NaNs

4 次查看（过去 30 天）
Pinga
Pinga 2014-10-3
评论： Pinga 2014-10-3
Hi!
I have a 10x2 cell. Each of these cells contains a 10x8 double. I'd like to count all the rows from column 2 (so Data{1,1}(:,2)) which don't have the vale "NaN" and have the value "1" in its row 8 (Data{1,1}(:,8).
What I've tried:
for n = 1:10
Result(:,n) = sum(~isnanData{1,1}(n,2),1(find(Data{1,1}(n,8) == 1)))
end
This seems not to work ("Error: Unbalanced or unexpected parenthesis or bracket.").
Thank you for any help!

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

采纳的回答

Mohammad Abouali
Mohammad Abouali 2014-10-3
sum(and(~isnan(Data{1,1}(:,2)),Data{1,1}(:,8)==1))
gives you the count of rows that don't have NaN on the second column and have 1 on 8th column
if you want to run that on all elements of your cell array you can do this:
func=@(D) sum(and(~isnan(D(:,2)),D(:,8)==1));
rowCount=cellfun(func,Data);

更多回答（1 个）

Image Analyst
Image Analyst 2014-10-3
You can't have ,1(find. Why is there a ( right after the 1?????

类别

在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by