Extracting data cell that match specific strings in different columns

Question

Nina Perf 2021-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1572938-extracting-data-cell-that-match-specific-strings-in-different-columns

评论： Jon 2021-11-12

采纳的回答： Jon

在 MATLAB Online 中打开

Hello!

I have a table, T, with the following variable names: Type, Ta, Sub, Day, Try, Data

I ask the person for these different inputs: inType, inTa, inSub, inDay, inTry.

% Example:
inType = 'aa';
inTa = '1';
inSub = '001';
inDay = 'ape';

I want to grab and save the cell Data, for the Table row that has the specific variable inputs in the Example (need to search for the matching strings).

More table, T, information:

Type: 90x2 % char
Ta: 90x1 % double
Sub: 90x1 % cell array of character vectors
Day: 90x1  % cell array of character vectors
Try: 90x1 % double
Data: 90x1 % cell

Can you please help?

Thank you in advance!

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

请先登录，再进行评论。

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

Answer 1

Jon 2021-10-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1572938-extracting-data-cell-that-match-specific-strings-in-different-columns#answer_817998

编辑：Jon 2021-10-27

在 MATLAB Online 中打开

If I understand your problem correctly I think you could adapt the approach I show in the simple example below

% make example table
animal = {'cat' 'cat' 'dog' 'fish' 'cat' 'hamster'}'
size = {'large' 'small' 'large' 'small','large','large'}'
color = {'black','brown','white','red','striped','brown'}'
weight= [2.2,1.3,5,0.5, 1.75,0.2]'
T = table(animal,size,color,weight)
% find weight of large,striped, cat
query = table
query.animal = 'cat'
query.size = 'large'
query.color = 'striped'
% find the correct row in table
[found,idx] = ismember(query,T(:,1:3),'rows')% just use columns that need to be matched
% get the corresponding weight
w = T.weight(idx)