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

조회 수: 2 (최근 30일)
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일
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
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개)

카테고리

Help CenterFile Exchange에서 Numeric Types에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by