erase a column that contains at least one zero
1 view (last 30 days)
Show older comments
Hi all,
I have
[N,T,R]=xlsread(name);
R(:,2) contains NaNs and string variables. But sometimes R(:,2) contains and zeros. I want to check if R(:,2) contains at least one zero . If yes, then I want to erase the first column of N, that is N(:,1).
So I try this
R2 = R(:,2);
R22 = R2(cellfun(@(x)isnumeric(x),R2));
if any(cell2mat(R22)==0)
N(:,1) = [];
end
Is there any alternative which is more compact ?
4 Comments
Geoff
on 6 Jul 2012
Small syntax simplification....
cellfun(@(x)isnumeric(x),R2)
Can just be:
cellfun(@isnumeric,R2)
Accepted Answer
Walter Roberson
on 6 Jul 2012
N(:, any(cellfun(@(C) eq(C,0), R(:,2))) = [];
Two parts are involved here: one is detecting the zero in a column in one array, and the other is deleting column 1 in another array if the zero was found.
The three steps you use for detection can be merged together by various methods; I show one of them above.
In the above I also managed to merge the deletion into the single step, by using an obscure trick. It would not have worked if it had been anything other than column 1 to be removed, and the adjustment to handle some other arbitrary column would pile obscurity on obscurity. Using an "if" would be much more readable:
if any(cellfun(@(C) eq(C,0), R(:,2)); N(:,7) = []; end %for example
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!