Asked by johnson saldanha
on 7 Dec 2018

suppose i have a cell C where

C{1,1}= ( 2 2 2 2 3 3 4 4 5);

C{2,1}=(3 4 4 4 5);

C{3,1}=(4 5);

and so on

i want the output as

x = (2 2 2 2 3 3 4 4 5);

the output should be the value which occurs the mean number of times of the occurances in the input. if the value is a decimal then it can rounded to a greater whole number for ex: the value 3 occurs twice in first cell and once in second cell. 2+1/2= 1.5 can be rounded to 2. so it occurs twice in the output.

Answer by dpb
on 7 Dec 2018

Accepted Answer

u=unique([C{:}]);

n=cell2mat(cellfun(@(x) histc(x,u),C,'uni',0));

n(n==0)=nan;

x=cell2mat(arrayfun(@(x,n) repmat(x,1,n),u,round(nanmean(n)),'uni',0));

>> x =

2 2 2 2 3 3 4 4 5

>>

dpb
on 9 Dec 2018

Yeah, again (still?) you've got one array as a row vector (#3) while the previous two were column vectors (size 16 in dimension 1).

You must pick an orientation for your cell array content organization and be consistent--otherwise, you'll have to write all kinds of patchwork code to correct such orienation mismatches going forward.

johnson saldanha
on 9 Dec 2018

all are column vectors. theres no row vector

dpb
on 9 Dec 2018

That's not what the error message says... :)

If the vectors inside the initial cell array are columns instead of rows as your initial example, then as above you'll have to first cat(1,...) them, but then the counts array will end up being a column vector instead of the 2D array because cellfun will just concatenate those columns into one long (column) vector instead of concatenating the rows vertically and you've thus lost the orientation that lets nanmean know how to average across the cells as is the whole end objective.

Probably the easiest way to code it would be to transpose the argument of the histc function inside the anonymous function so it is again a row vector there as needs must be...otherwise, you've got much more painful gyrations to build the necessary array shape.

Step through each step at the command line for a (smallish) example so you can see the results of each operation and get the proper orientation for the job.

Sign in to comment.

Opportunities for recent engineering grads.

Apply Today
## 0 Comments

Sign in to comment.