# How to remove zeros from an element in a cell array

7 views (last 30 days)
Ebtesam Farid on 11 Jul 2021
Commented: Ebtesam Farid on 12 Jul 2021
Hi all,
I have two cell arrays each contain 12 cells, each cell contains different matrix size (31,1) or (30,1) or (28,1), each cell in the array contains a bunch of zeros, and I need to remove these zeros, because it indicates that there is no data at this day
here are an example of my data,
A = {[1 0 1], [2 0 2], ......., [12 0 12]}
B = {[0 2 1], [1 2 0], ........, [12 0 12]}
my purpose is to compare A with B, and to do that I have to remove the zeros and the coincident index in the other cell
A(1,1){2} and B(1,1){2} = []; aslo A(1,1){1} and B(1,1){1}=[];

Walter Roberson on 11 Jul 2021
monthlengths = [28 30 31];
C = arrayfun(@(x) randi([0 9], 1, monthlengths(randi(3))), 1:12, 'uniform', 0)
C = 1×12 cell array
{[5 3 1 4 6 4 6 8 7 0 9 1 5 7 9 3 7 3 4 9 5 2 0 3 5 6 1 0 5 0]} {[2 9 1 7 5 2 6 8 1 6 2 6 1 3 3 3 0 1 7 1 4 3 6 0 2 7 1 8 9 4]} {[4 8 6 4 8 7 1 0 5 7 3 1 9 1 1 8 2 0 7 9 8 6 1 9 6 5 5 9 4 0 8]} {[4 1 0 6 7 0 0 7 9 9 3 1 3 5 6 5 2 3 7 1 4 0 7 4 7 1 9 5]} {[7 0 5 7 7 2 3 3 9 8 7 3 9 6 5 3 0 0 0 3 5 3 9 2 2 9 6 9]} {[7 3 3 1 2 5 0 0 8 4 9 9 8 0 7 5 0 7 0 2 6 1 4 8 0 2 1 0 6 7 4]} {[1 8 7 3 9 7 3 1 1 6 7 7 6 9 4 3 4 2 9 8 7 6 0 6 1 8 6 7 4 3]} {[1 9 4 2 2 9 8 9 3 9 9 6 3 7 0 3 8 1 7 5 0 9 0 3 9 6 8 7 9 9]} {[7 1 5 9 9 9 8 7 0 5 6 0 7 2 0 1 1 8 5 2 1 2 4 0 5 1 7 9]} {[8 5 2 2 7 3 5 9 1 5 7 2 1 2 9 6 0 9 3 9 9 2 1 2 8 2 0 1 8 5 0]} {[9 5 2 0 8 1 3 5 6 5 3 4 9 2 6 9 7 0 5 2 6 7 0 6 2 1 4 3 0 9]} {[7 1 3 2 3 7 8 4 0 4 0 9 2 8 9 3 7 6 4 9 6 9 4 5 7 7 5 2 0 0 9]}
reduced_C = cellfun(@(c) c(c~=0), C, 'uniform', 0)
reduced_C = 1×12 cell array
{[5 3 1 4 6 4 6 8 7 9 1 5 7 9 3 7 3 4 9 5 2 3 5 6 1 5]} {[2 9 1 7 5 2 6 8 1 6 2 6 1 3 3 3 1 7 1 4 3 6 2 7 1 8 9 4]} {[4 8 6 4 8 7 1 5 7 3 1 9 1 1 8 2 7 9 8 6 1 9 6 5 5 9 4 8]} {[4 1 6 7 7 9 9 3 1 3 5 6 5 2 3 7 1 4 7 4 7 1 9 5]} {[7 5 7 7 2 3 3 9 8 7 3 9 6 5 3 3 5 3 9 2 2 9 6 9]} {[7 3 3 1 2 5 8 4 9 9 8 7 5 7 2 6 1 4 8 2 1 6 7 4]} {[1 8 7 3 9 7 3 1 1 6 7 7 6 9 4 3 4 2 9 8 7 6 6 1 8 6 7 4 3]} {[1 9 4 2 2 9 8 9 3 9 9 6 3 7 3 8 1 7 5 9 3 9 6 8 7 9 9]} {[7 1 5 9 9 9 8 7 5 6 7 2 1 1 8 5 2 1 2 4 5 1 7 9]} {[8 5 2 2 7 3 5 9 1 5 7 2 1 2 9 6 9 3 9 9 2 1 2 8 2 1 8 5]} {[9 5 2 8 1 3 5 6 5 3 4 9 2 6 9 7 5 2 6 7 6 2 1 4 3 9]} {[7 1 3 2 3 7 8 4 4 9 2 8 9 3 7 6 4 9 6 9 4 5 7 7 5 2 9]}
Ebtesam Farid on 12 Jul 2021
it works well, Thanks @Walter Roberson so much :)

dpb on 11 Jul 2021
yourarray=cellfun(@(c)c(~-0),yourarray,'UniformOutput',false);
Walter Roberson on 12 Jul 2021
Yes, but this is different code; your posted code had c(~-0) not c(c~=0)

R2021a

### Community Treasure Hunt

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

Start Hunting!