how to split values in a cell

Hi!

I have 'out' (attached) and I want to divide the phrases in the first columns based on the

numerical value in the second columns.

I want to obtain three arrays: in the first I want to put the phrases with numerical value

in the second columns <0, in the second I want to put the phrases with numerical value

in the second columns = 0 and in the third I want to put the phrases with numerical value

in the second columns >0

Can you help me?

[Shivam Raikundalia]

Hello,

So if you do not know how large your 3 arrays are going to be and you want them to be exact size I suggest you do something like this:

firstarray={};
secondarray={};
thirdarray={};
for i=1:size(out,1)
    if out{i,2}<0
        firstarray{end+1}=out(i,1);
    elseif out{i,2}==0
        secondarray{end+1}=out(i,1);
    else
        thirdarray{end+1}=out(i,1);
    end
end

This method is a little slow however since one of the arrays change size on every iteration. Hope this helps!

[elisa ewin]

thanks, it runs and it's helpful

Answer 1

[Star Strider]

If you have R2015b or later, use splitapply:

D = load('matlab.mat');
out = D.out;
[G, ID] = findgroups([out{:,2}]);
Result = splitapply(@(x){x}, out(:,1), G');

[elisa ewin]

The code gives an error:

Undefined function 'findgroups' for input arguments of type 'double'.

[Walter Roberson]

As Star Strider indicated, findgroups requires R2015b or later.