How to remove particular row

Question

Kanakaiah Jakkula 2015-12-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261619-how-to-remove-particular-row

评论： Kanakaiah Jakkula 2015-12-26

I have the folloing table:

    Tool1  Mek  Ar  10.0   40.5 
    Tool1  Lahi  BM2  13.0   89.4 
    Tool1  Ar  Ar  34.0   67.8 
    Tool1  Puni  Raj  41.0   89.9 
    Tool1  Jak  Ar  20.0   78.3 
    Tool1  Lahi  Lahi  12.0   99.0 
    Tool1  N2  BM2  14.0   89.0 
    Tool1  Ar  Mek  25.0   95.7 
    Tool1  Puni  Puni  17.0   90.6 
    Tool1  Raj  Jak  20.0   100.0

uncommon list:

Ar
BM2
N2
I want to remove a particular row if:
1. If the name in second column & third column (of any row) is equal (I mean same)
2. If the name in third column (of any row) belongs to uncommon list

Many thanks in advance.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Image Analyst 2015-12-26

Is it a table (hopefully), or a cell array? If it's a cell array, you should really use a table instead because they're easier to deal with, faster, and take up a lot less memory. Let me know if you don't even know the difference between a table (which was introduced in R2013b) and a cell array.

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2015-12-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261619-how-to-remove-particular-row#answer_204269

编辑：Azzi Abdelmalek 2015-12-25

在 MATLAB Online 中打开

If A is your cell array and b the uncomon list

A={'Tool1'  'Mek'  'Ar'  10.0   40.5 
  'Tool1'  'Lahi'  'BM2'  13.0   89.4 
  'Tool1'  'Ar'   'Ar'  34.0   67.8 
  'Tool1'  'Puni'  'Raj'  41.0   89.9 
  'Tool1'  'Jak'  'Ar'  20.0   78.3 
  'Tool1'  'Lahi'  'Lahi'  12.0   99.0 
  'Tool1'  'N2'  'BM2'  14.0   89.0 
  'Tool1'  'Ar'  'Mek'  25.0   95.7 
  'Tool1'  'Puni'  'Puni'  17.0   90.6 
  'Tool1'  'Raj'  'Jak'  20.0   100.0 }
b={'Ar';'BM2';'N2'}
ii=cellfun(@(x,y) isequal(x,y) & any(ismember(b,y)),A(:,2),A(:,3))
A(ii,:)=[]

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

Azzi Abdelmalek 2015-12-26

编辑：Azzi Abdelmalek 2015-12-26

在 MATLAB Online 中打开

In your last comment, we understand that the condition is (condition 1 | condition 2). The solution will be

ii=cellfun(@(x,y) isequal(x,y) | any(ismember(b,y)),A(:,2),A(:,3))
A(ii,:)=[]

Kanakaiah Jakkula 2015-12-26

Sir, it works, and this is I want. But, I am sorry to say that I did not quite understand about this code. One thing I want to ask, how does it working for condition 2 that if any of the row in column 3 belongs to uncommon list, to be removed. If I want to do this for any other column, then where should I modify this code.

Many thanks so far for your kind support.

请先登录，再进行评论。