Select rows given a condition

86 次查看（过去 30 天）
Maria
Maria 2014-6-24
回答： 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:
1997 FD 89
1997 GD 65
1999 FDK 87
2010 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!

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

采纳的回答

Titus Edelhofer
Titus Edelhofer 2014-6-24
Hi Maria,
you need to convert the first column into a vector
firstColumn = cell2mat(A(:,1));
rows1997 = A(firstColumn==1997, :);
Titus
  1 个评论
Maria
Maria 2014-6-24
Yes! I just tried cell2mat and it worked perfectly! Thank you very much! :)

请先登录，再进行评论。

更多回答（2 个）

aneps
aneps 2014-6-24
编辑：aneps 2014-6-24
Try this:
B=A(any(A==1997,2),:)
  2 个评论
Maria
Maria 2014-6-24
Hey. It gives me exactly the same error!
'Undefined function 'eq' for input arguments of type 'cell'
:(
Maria
Maria 2014-6-24
Still the same problem! I cannot use '==', it's always giving an error!

请先登录，再进行评论。

Reda
Reda 2023-11-10
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

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by