How to do multiple replacements in a cell array

1 view (last 30 days)
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 Comments
James Tursa
James Tursa on 31 Jan 2020
Are the letters in cell1 column 2 always 'A', 'B', or 'C'?
Stephen23
Stephen23 on 31 Jan 2020
Bluegin's "Answer" moved here:
No, unfortunately. There's about 50 differents codes in reality.

Sign in to comment.

Accepted Answer

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

Sign in to comment.

More Answers (0)

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!