matching based on a condtion cell table

1 次查看（过去 30 天）
sensation
sensation 2017-10-19
评论： Cam Salzberger 2017-10-19
Hi, I have a cell with:
'ABA1'
'ABO1'
'ACE3'
'ACE4'
Then I have a table with:
'AAYUC01' 3.7
'ABA1' 4.5
'ABA2' 4.5
'ABENVD1' 4360
'ABO1' 7521.3
How I can find the matching between my table and cell so that result is:
'ABA1' 4.5
'ABO1' 7521.3
Thanks a lot!
  1 个评论
Jan
Jan 2017-10-19
It is easier to write an answer, if you provide the inputs, such that they can be used by copy&paste. Otherwise all readers have to do this by their own and remove the tedious empty lines.

请先登录，再进行评论。

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

采纳的回答

Cam Salzberger
Cam Salzberger 2017-10-19
编辑：Cam Salzberger 2017-10-19
Hello,
I believe that ismember is your friend here. It will produce a logical array indicating which rows' elements are contained within your first set. You can then use that to index into the table.
C = {'A' ; 'B' ; 'C'};
T = table({'A' ; 'X' ; 'C' ; 'Y'}, (1:4).');
whichRows = ismember(T{:, 1}, C);
T(whichRows, :)
This is just a simple example, but easily adapted to your data.
-Cam
  2 个评论
sensation
sensation 2017-10-19
Hi Cam,
I was trying to do that but have always the eror msg eventhough I have C being 205x1 cell and T being 900x2 table:
Error using cell/ismember (line 34) Input A of class cell and input B of class cell must be cell arrays of strings, unless one is a string.
Cam Salzberger
Cam Salzberger 2017-10-19
What I thought you wanted was only the rows of the table who have their first column values present in the cell array. Which means you want to have the table as the first input argument to ismember.
If it's giving you an error about "cell/ismember", that means your first input argument is a cell array. Try switching them.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by