Reshape Cell to Matrix

Question

Brian 2011-12-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/24812-reshape-cell-to-matrix

So I'm having an issue adjusting this function to work with my actual dataset and it may be because I still don't understand the function quite right. (See answer to my original question here - http://www.mathworks.com/matlabcentral/answers/24527-reshape-cell-to-matrix)

My actual dataset format is as follows....

data = {'06/03/2011','00163T10' 
'06/06/2011','00163T10' 
'06/07/2011','00163T10' 
'06/03/2011','ABCDEFGH' 
'06/06/2011','ABCDEFGH' 
'06/07/2011','ABCDEFGH' 
'06/03/2011','ABCDWXYZ' 
'06/06/2011','ABCDWXYZ'};

How would I go about using the arguments above with a dataset in this format. Ultimately, I am attempting to create a logical matrix of whether the ticker was in or out (1 or 0) for each given day using the accumarray function that Andrei began to help me with in the example posted above.

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

请先登录，再进行评论。

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

Answer 1

Andrei Bobrov 2011-12-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/24812-reshape-cell-to-matrix#answer_32621

在 MATLAB Online 中打开

try this cod (small corrected, typo)

d1 = datenum(data(:,1),'mm/dd/yyyy');
[a1,c1,c1] = unique(d1);
[a2,c2,c2] = unique(data(:,2));
out1 = accumarray([c1,c2],ones(numel(c1),1),[max(c1),max(c2)],@(x){x},{0});
out = [{NaN}, a2'; cellstr(datestr(a1,'mm/dd/yyyy')),out1];