Find the number of non-empty cells in each row of a cell array

8 views (last 30 days)
I have a cell array of tables where each row contains data for one specimen and each column of that row contains results of repeated tests for that specimen. There are different numbers of tests in each row.
I would like to process each row based on the number of tests. How can I determine the number of cells in each row that contain tables? For example, the first row contains 12 cells, the second contains 14, etc.

Accepted Answer

Adam Danz
Adam Danz on 17 Nov 2022
Edited: Adam Danz on 17 Nov 2022
Here's a demo that
  1. creates a cell array of tables and empty cells
  2. determines which cells contain a table
  3. counts the number of tables per row
c = cell(3,4);
c([1,2,3,4,6,10,12]) = {array2table(rand(5))}
c = 3×4 cell array
{5×5 table} {5×5 table } {0×0 double} {5×5 table } {5×5 table} {0×0 double} {0×0 double} {0×0 double} {5×5 table} {5×5 table } {0×0 double} {5×5 table }
y = cellfun(@istable, c)
y = 3×4 logical array
1 1 0 1 1 0 0 0 1 1 0 1
nTablesPerRow = sum(y,2)
nTablesPerRow = 3×1
3 1 3
If you'd rather count any cell that is not empty,
y2 = ~cellfun(@isempty, c)
y2 = 3×4 logical array
1 1 0 1 1 0 0 0 1 1 0 1
nNonEmptiesPerRow = sum(y2,2)
nNonEmptiesPerRow = 3×1
3 1 3
  12 Comments
Adam Danz
Adam Danz on 30 Nov 2022
Ah, of course. Thanks @Jim McIntyre. That's what I get for running code in my head rather than actually testing it 😊
I'll update my previous comment to avoid confusions for any future visitors.

Sign in to comment.

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by