Dataset intersection

Giorgos

2011 7 10

1 个回答

回答已采纳

3 次查看（30 天）

显示更早的评论

0 个投票

Hello , i have two datasets with stocks , a large one that contains all the stocks at my disposal (and also has their monthly returns) and a smaller one which contains few of the stocks of the large one. I want to take those few stocks from the large set along with their returns. I have tried newset=largeset(largeset.Stock==smallset.Stock,{'Stock','July'}) to get the stocks along with their July returns but i get the : Undefined function or method 'eq' for input arguments of type 'cell' error. Any help would be appreciated.

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

请先登录，再进行评论。

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

请先登录再关注

采纳的回答

Fangjun Jiang 2011-7-10

在 MATLAB Online 中打开

0 个投票

LargeStock={'a',0.1;'b',0.2;'c',0.3;'d',0.4;'e',0.5};
MyStock={'b','d'};
Index=ismember(LargeStock(:,1),MyStock);
MyStockAndReturn=LargeStock(Index,:);