how to match data with 3 differnt datasets with different data sizes

1 次查看（过去 30 天）
andrew
andrew 2013-9-23
I currently have 2 sets of data and I am trying to find a match based off of it's name. For example in data1 it contains apple, banana, orange, pear,etc and data 2 contains apple-1, apple-2, apple-3, banana-1, banana-2, banana-3, orange, pear-1, pear-2, etc. data3 contains red, yellow, and orange. Ultimately, I would like to write a script to match for example apple with apple-1, apple-2, apple-3 etc and with the color red, yellow, orange etc and print out the corresponding data:
Col 1 Col 2 Col 3
apple apple-1 red
apple apple-2 red
apple apple-3 red
banana banana-1 yellow
banana banana-2 yellow
banana banana-3 yellow
orange orange orange
pear pear-1 green
pear pear-2 green

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

回答（1 个）

Matt J
Matt J 2013-9-23
编辑：Matt J 2013-9-23
One way,
Col2={'apple-1';'apple-2';'banana-5';'pear-3'}
S.apple='red';
S.banana='yellow';
S.pear='green';
Col1 = regexprep(Col2,'[\W\d]','');
Col3 = cellfun(@(c) S.(c), Col1,'uni',0);
C=[Col1,Col2,Col3]

类别

在 Help Center 和 File Exchange 中查找有关 Encryption / Cryptography 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by