Count elements not including blank entries in a cell array

55 views (last 30 days)
I have a cell-array and I am trying to count the elements for each row that have a value and not 'Nan' or '[]'. For example:
Input: Output:
18 76 [] 76 28 28 5
22 [] [] 123 123 123 4
25 12 12 12 [] [] 4
The code I am using is the following, and I tried different variations:
output=numel(input(size(input(1,:),1),:))-sum(isnan(input(size(input(1,:),1),:))
I believe the functions themselves (numel, sum, isnan) are ok, at least they work, but the problem is that I only get the output either for the first row, or the last row, so something is wrong for sure. Can someone help? Thanks

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 19 Jul 2014
A={18 76 [] 76 28 28
22 [] [] 123 123 123
25 12 12 12 [] []}
idx=sum(~cellfun(@isempty,A),2)
  3 Comments
Maria
Maria on 20 Jul 2014
My bad, I was tired and I was doing a mistake in my code without noticing. Thanks!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!