find column from list then save cell

1 次查看（过去 30 天）
Vincent I
Vincent I 2014-6-23
评论： Vincent I 2014-6-24
Hi,
I have two cells:
A = {'One','Four','Five'};
B = {'One','Two','Three','Four','Five';1 2 3 4 5;6 7 8 9 10};
Find A in B = C
C = {'One','Four','Five';1 4 5;6 9 10}
As shown above, I would like find the columns from A in B and the save them to another cell C without using either a for or while loop.
Cell A can have different numbers so whats shown above its not always the same.
Thank you

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2014-6-23
C = B(:,ismember(B(1,:),A))

更多回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2014-6-23
A = {'One','Four','Five'};
B = {'One','Two','Three','Four','Five';1 2 3 4 5;6 7 8 9 10};
If you work with tables
BB=cell2table(B(2:end,:),'VariableNames',B(1,:))
C=BB(:,A)
  1 个评论
Vincent I
Vincent I 2014-6-24
cell2table did not work for me. I'm sure with some tweaking i could have worked.
Thank you very much for your help

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by