Cell matrix

Question

Mate 2u 2012-2-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/28583-cell-matrix

编辑： Jeremiah 2013-10-7

采纳的回答： the cyclist

Hi there, I have a 37000 x 4 cell array. Columns are like for eg,

'01/02/2012 00:00:01' 'BEST_BID' 4.25000000000000 90

'01/02/2012 00:00:01' 'BEST_ASK' 4.26000000000000 90

'01/02/2012 00:00:01' 'BEST_BID' 4.25000000000000 90

'01/02/2012 00:00:01' 'BEST_ASK' 4.26000000000000 90

'01/02/2012 00:00:16' 'BEST_BID' 4.24000000000000 90

'01/02/2012 00:00:16' 'BEST_ASK' 4.26000000000000 90

'01/02/2012 00:00:17' 'BEST_BID' 4.25000000000000 90

'01/02/2012 00:00:17' 'BEST_ASK' 4.26000000000000 90

Ok now I want to create 2 matrices (separation) one with BEST_BID and one with BEST_ASK. Additionally they both would need to be in order with respect to their times in the first column and maintain the 3rd and 4th column information

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

请先登录，再进行评论。

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

Answer 1

the cyclist 2012-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/28583-cell-matrix#answer_36900

在 MATLAB Online 中打开

Here is one of many ways to do it. This is more geared toward maximum readability than maximum efficiency.

[tf,index] = ismember(CA(:,2),{'BEST_BID','BEST_ASK'});
bidArray = CA(index==1,:);
askArray = CA(index==2,:);
bidArray = sortrows(bidArray,1);
askArray = sortrows(askArray,1);
% % I didn't think sortrows worked on cell arrays, but the above seems to work. If not, use this:
% [~,bidTimeOrder] = sort(bidArray(:,1));
% [~,askTimeOrder] = sort(askArray(:,1));
% bidArray = bidArray(bidTimeOrder,:);
% askArray = askArray(askTimeOrder,:);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mate 2u 2012-2-9

Great the top one worked just fine

请先登录，再进行评论。

Answer 2

Kevin Holst 2012-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/28583-cell-matrix#answer_36899

在 MATLAB Online 中打开

For the first part, here's how to create two cell arrays that are BEST_BID and BEST_ASK:

BEST_BID = myArray(strcmp(n(:,2),'BEST_BID'),:);
BEST_ASK = myArray(strcmp(n(:,2),'BEST_ASK'),:);

You said you're wanting to create two matrices, were you actually wanting cell arrays or matrices of the last two columns of the cell?

The sorting thing will take a bit more work to get, I'll have to get back to you on it.

2 个评论
显示无隐藏无

Kevin Holst 2012-2-9

This function from the file exchange might help your sorting problem:

http://www.mathworks.com/matlabcentral/fileexchange/13770-sorting-a-cell-array

Mate 2u 2012-2-9

Thank you

请先登录，再进行评论。