How do i filter out certain values in a cell matrix using conditions for strings ?

Question

Rusty Rudolph 2018-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/423208-how-do-i-filter-out-certain-values-in-a-cell-matrix-using-conditions-for-strings

评论： ANKUR KUMAR 2018-10-10

I have a cell matrix-

x = { 1 2 'a' 'q' ; 2 3 'a' 'p'; 3 4 'a' 'q'; 5 6 'b' 'p' ; 7 8 'b' 'q' ;9 8 'b' 'q';};
or x =
2  a  q
3  a  p
4  a  q
6  b  p
8  b  q
8  b  q

I want to filter out all rows that have 'a' in the 3rd column and 'q' in the fourth. My result matrix should be-

result=
1  2  a  q
3  4  a  q

How do I do this?

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

请先登录，再进行评论。

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

Answer 1

ANKUR KUMAR 2018-10-10

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/423208-how-do-i-filter-out-certain-values-in-a-cell-matrix-using-conditions-for-strings#answer_340653

编辑：ANKUR KUMAR 2018-10-10

在 MATLAB Online 中打开

You can use contains to find the required letter. contains gives true if the part of search string contains in the main string.

x(contains(x(:,3),'a') & contains(x(:,4),'q'),(3:4))

Better to use strcmp, as it check for complete string. strcmp checks for the complete strings. It gives true only when the complete string is present.

x(strcmp(x(:,3),'a') & strcmp(x(:,4),'q'),(3:4))

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

ANKUR KUMAR 2018-10-10

在 MATLAB Online 中打开

"(3:4) " is used because you wish to extract 3rd and fourth column as output. If you wish all, then use

x(strcmp(x(:,3),'a') & strcmp(x(:,4),'q'),:)

ans =

2×4 cell array
    [1]    [2]    'a'    'q'
    [3]    [4]    'a'    'q'

If data is on 3rd and 6th column, then use

x(strcmp(x(:,3),'a') & strcmp(x(:,6),'q'),:)

The above one gives output for complete columns.

ANKUR KUMAR 2018-10-10

在 MATLAB Online 中打开

For more clarification, refer this,

x = { 1 2 'a' 6 8 'q' ; 2 3 'a' 2 5 'p'; 3 4 'a' 2 1 'q'; 5 6 'b' 1 2 'p' ; 7 8 'b' 1 1 'q' ;9 8 'b' 1 1 'q';}

x =

    6×6 cell array
      [1]    [2]    'a'    [6]    [8]    'q'
      [2]    [3]    'a'    [2]    [5]    'p'
      [3]    [4]    'a'    [2]    [1]    'q'
      [5]    [6]    'b'    [1]    [2]    'p'
      [7]    [8]    'b'    [1]    [1]    'q'
      [9]    [8]    'b'    [1]    [1]    'q'

1)

x(strcmp(x(:,3),'a') & strcmp(x(:,6),'q'),:)

ans =

    2×6 cell array
      [1]    [2]    'a'    [6]    [8]    'q'
      [3]    [4]    'a'    [2]    [1]    'q'

2)

x(strcmp(x(:,3),'a') & strcmp(x(:,6),'q'),[3,6])

ans =

    2×2 cell array
      'a'    'q'
      'a'    'q'

请先登录，再进行评论。

How do i filter out certain values in a cell matrix using conditions for strings ?

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

How do i filter out certain values in a cell matrix using conditions for strings ?

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

WeChat

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

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