Deleting data within row of cells

(Semi advanced beginner here)

I have a list of cells (1x18) that have subsequent tables. Each table has a varied number of rows, but they all have their first bunch of rows are "0" (like 80% of the data so I want to delete to be able to work with the nonzeroed values). Once the values change to nonzero, they never return to zero.

I'm trying to extract the values to delete all the zeros and I've tried different means and not having success, splitting subarrays, etc. Any ideas for how to continue? I want to be able to work with a set of columns for nonzero values to do some analysis.

Thanks!

Answer 1

[Image Analyst]

Did you try a for loop? Here is untested code (because you forgot to attach your data):

for k = 1 : numel(C)
    % Extract the table.
    thisCellContents = C{k};
    % Find the first non-zero item in the first column of the table.
    firstNonZeroRow = find(thisCellContents{:, 1} ~= 0, 1, 'first')
    if ~isempty(firstNonZeroRow)
        % Take rows from that point on.
        thisCellContents = thisCellContents((firstNonZeroRow + 1):end, :);
        % Stick updated table back into cell.
        C{k} = thisCellContents;
    end
end

If you still need more help, attach your cell array in a .mat file with the paperclip icon.

save('answers.mat', 'C');

[Marissa Gabriel]

Yes! 1 more question

That did help -- thank you btw!!

The end of that code leaves me with a 1x18 cell (with 251 consistent rows of nonzeroes, but I'm working on a generic code), if I wanted to work with the data inside by looping through the 18 cells, is there a good syntax to use?

I need to find:

• average
• stdev
• plot

of each 18 cells (datapoint 1-x, x-end)

[Marissa Gabriel]

here's everything beyond so far

% specify indexing

begin = 1;

ramp = 25;

last = size(C{k});

dim = [begin, ramp];

dim2 = [ramp,last];

% plot section graphs (1-3,4-6,etc)

for k = 1:3

vars = {'CofF'};

stackedplot([C{k}],vars)

end

xlabel('milliseconds')

% data analysis for each trial broken up before ramp and after ramp

for k = 1:numel(C)

rampMean = mean(C{k},dim)

oscillMean = mean(C{k},dim2)

end

[Image Analyst]

I can try to fix it after you attach C.

[Marissa Gabriel]

Attached!