erase a column that contains at least one zero

2 次查看（过去 30 天）
Sabbas
Sabbas 2012-7-5
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 个评论
显示 2更早的评论
Sabbas
Sabbas 2012-7-6
thanks imager. I was looking for something maybe without the if statement. But if you agree with my approach and you find it correct then it is fine for me!
thanks again
Geoff
Geoff 2012-7-6
Small syntax simplification....
cellfun(@(x)isnumeric(x),R2)
Can just be:
cellfun(@isnumeric,R2)

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2012-7-6
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by