How to do multiple replacements in a cell array

2 次查看（过去 30 天）
012786534
012786534 2020-1-31
评论： 012786534 2020-1-31
Hi,
I am wondering what is the most efficient way in Matlab to do multiple replacements in a cell array based on the content of a differentt cell array ?
More specifically, I am trying to transform cell1 into cell3 based on the associations defined in cell2 in the most efficient way possible (in other words cell1(:,2) becomes cell3(:,2))
% Cell array data
cell1 = {1, 2, 3, 4, 5; 'A', 'A', 'B', 'C', 'B'; 'AA', 'BB', 'CC', 'DD', 'JJ'}'
% Cell array reference
cell2 = {'C', 'B', 'A'; 'FFFF', 'GGGG', 'HHHH'}'
% Desired output
cell3 = {1, 2, 3, 4, 5; 'HHHH', 'HHHH', 'GGGG', 'FFFF', 'GGGG'; 'AA', 'BB', 'CC', 'DD', 'JJ'}'
Thank you,
  2 个评论
James Tursa
James Tursa 2020-1-31
Are the letters in cell1 column 2 always 'A', 'B', or 'C'?
Stephen23
Stephen23 2020-1-31
Bluegin's "Answer" moved here:
No, unfortunately. There's about 50 differents codes in reality.

请先登录，再进行评论。

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

采纳的回答

Stephen23
Stephen23 2020-1-31
编辑：Stephen23 2020-1-31
>> [idx,idy] = ismember(cell1(:,2),cell2(:,1));
>> cell3 = cell1;
>> cell3(idx,2) = cell2(idy(idx),2)
  1 个评论
012786534
012786534 2020-1-31
Neat, thank you. Could the same thing be accomplished with intersect ?
Something along the lines of :[C,ia,ib] = intersect(A,B, 'stable'); ?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Get Started with MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by