Delete values from different columns depending on a value from a specific column

2014 4 28
1 个回答
回答已采纳
更新时间：2014 5 18
7 次查看（30 天）

0 个投票

I have a double variable with 3 columns. Sometimes, in the second column I obtain the value zero. In case it happens I want to completely erase that line. For instance:
12346 67 89
1245 0 765
56 0 99
19862 8 675
What I would like to get:
12346 67 89
19862 8 675
Thanks in advance for your help.

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

 采纳的回答

Star Strider
Star Strider 2014-4-28

1 个投票

This works:
a = [12346 67 89; 1245 0 765; 56 0 99; 19862 8 675];
a((a(:,2) == 0),:) = [];
It uses ‘logical indexing’ to eliminate the entire row with a zero in the second column.

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Maria
Maria 2014-4-28
Thank you very much. It worked perfectly. :)
Star Strider
Star Strider 2014-4-28
编辑：Star Strider 2014-4-28
My pleasure!
The sincerest form of appreciation here on MATLAB Answers is to Accept the answer that solves your problem. It also helps others find it if they have similar questions.
Maria
Maria 2014-5-18
Do you know how can I do the same, but considering the fact that some elements of the cell array are words (strings)? Thank you!
Star Strider
Star Strider 2014-5-18
Here you go:
MCA = {1 2 3; 4 'ab' 6; 7 8 'bc'; 4 3 8; 7 2 1; 'yz' 10 pi}; % Mixed Cell Array
FS = cellfun(@ischar,MCA); % Find string elements
SR = find(sum(FS,2)); % Find rows containing string elements
NSR = setdiff(1:size(MCA,1), SR)'; % Find rows NOT containing string elements
MCAnew = MCA(NSR,:) % Create new array
Have fun!

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by