MATLAB: Reshape Cell to Matrix

accumarraycell arrayslogical?MATLABmatrix

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.

Best Answer

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];
Related Question