Select rows given a condition

Question

Maria 2014-6-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137316-select-rows-given-a-condition

回答： Reda 2023-11-10

I have a big- cell variable and I want to select it, considering the first row. So for instance if I have

 A:
FD 89
GD 65
FDK 87
UY 123

I would like to get

 B:
 1997 FD 89
 1997 GD 65

I tried to use the '==1997' function but it is not working because the input is a cell. An when I use 'isequal' I get B but it's a '0x0 cell' variable. Can anyone help me? Thanks a lot!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Titus Edelhofer 2014-6-24

6
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137316-select-rows-given-a-condition#answer_142207

在 MATLAB Online 中打开

Hi Maria,

you need to convert the first column into a vector

firstColumn = cell2mat(A(:,1));
rows1997 = A(firstColumn==1997, :);

Titus

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

Maria 2014-6-24

Yes! I just tried cell2mat and it worked perfectly! Thank you very much! :)

请先登录，再进行评论。

Answer 2

aneps 2014-6-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137316-select-rows-given-a-condition#answer_142204

编辑：aneps 2014-6-24

在 MATLAB Online 中打开

Try this:

B=A(any(A==1997,2),:)

2 个评论
显示无隐藏无

Maria 2014-6-24

在 MATLAB Online 中打开

Hey. It gives me exactly the same error!

'Undefined function 'eq' for input arguments of type 'cell'

:(

Maria 2014-6-24

Still the same problem! I cannot use '==', it's always giving an error!

请先登录，再进行评论。

Answer 3

Reda 2023-11-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/137316-select-rows-given-a-condition#answer_1350215

Dear sir,

I have a file name(metadat) which have 3 column and no of rows. My question is how to select all rows from the file with specific condition such as PP=0. I try allot of salutions but i didnt get the wright one. Thanks alot