Dataset intersection

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.

 Accepted Answer

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,:);

More Answers (0)

Categories

Find more on Statistics and Machine Learning Toolbox 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!