Count elements not including blank entries in a cell array
43 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
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
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!