Plotting rows of a specific column of similar value on separate figures

Hi, I am trying to make a plot of column 3 of the table "zt" below/attached. However, I need one plot per column 1 value. i.e.Under column 1, I want a plot for 1, a plot for 2, a plot for 3...and finally a plot for 6. I want matlab to go through the table and look for similar values in column 1 and then plot its corresponding column 3 values then goes to the next. For example, for "1", it counts 8 rows then plots its column 3 data. Next for "2", it counts 4 rows then plots its column 3 data. Next for "3", it counts 3 rows then plots it column 3 data and so on till it gets to "6".

The problem with my code is that p is not iterating correctly and I don't know how to fix it. It should normally go from 1<->8 for "1", then 9<->12 for "2", then 13<->15 for "3"......till it gets to 6

close all;clc
for i=1:6
    p=0;
    p=sum(zt{:,1}==i)
    figure(i)
    i
%     [p]=p+p
    plot(zt{[1:p],3})
end

zt table below and attached

1	2	3
1	3	4
1	5	5
1	5	5
1	5	5
1	7	4
1	5	4
1	4	5
2	6	2
2	4	4
2	4	8
2	5	9
3	6	7
3	1	10
3	6	1
4	4	5
4	5	1
4	5	5
5	2	5
5	6	6
5	5	4
6	4	8
6	3	9
6	5	2
6	6	6

Answer 1

[dpb]

When you want a new figure for every one, that pretty-much means splitapply isn't going to be all that handy because you can't define an anonymous function that has more than one line --and you've got to have at least two for the new figure followed by plot. You can write a small inline function and call that, of course, but if doing that, may as well just do it inline -- but you can still use findgroups although as you've discovered, unique works as well or as well could discretize

D=table2array(B);
[g,id]=findgroups(D(:,1));
for i=1:numel(id)
  figure
  plot(D(D(:,1)==id(i),3),'DisplayName',"Group "+id(i))
end
legend

Virtually the same code you had; splitapply or rowfun for a table just do the lookup indexing for you -- but they're doing the same thing inside, it's just "syntactic sugar" to save you the trouble writing the indexing expression. But, the price for ease is the above -- you can't include more code than one line in an anonymous function so if your needs are more than can be done that way, you have to write another function anyway.

Answer 2

[dpb]

Try something like

g=findgroups(zt(:,1));
hAx=axes;hold on
splitapply(@(y)plot(y),zt(:,3),g)
legend("Group "+unique(g))

If you really, really want each on a totally separate figure/axes, then you'll have to use a loop and extract those for which

plot(zt(zt(:,1)==g(i),3))

for the loop construct over g.

[mpz]

@dpb thanks. I do want them seperate because the data I'm analyzing is alot. I tried using a loop but I get the errors below. Could you please show how?

Operator '==' is not supported for operands of type 'table'.

[dpb]

You attached an ordinary array and gave no info about the table -- what does

whos zt

tell us about what variable names are to refer to?

Or, attach a .mat file that contains a representative sample.

Anyways, where refer to zt(:,1) above, you'll need the reference to the associated variable in the table instead...

zt.Var1

where substitute whatever is the actual column name for 'Var1'

Give the loop a try -- it's not that difficult and learning by doing is a lot more effective than just being handed code on a platter. We'll coach/answer specific issues, of course, but we're also lacking the above critical details you didn't provide to be able to write actual running code.

[mpz]

I did convert the table to a matrix. Error is gone. However, I'm still getting a single plot for all the data

clc;close all
D=table2array(B);
C = unique(D(:,1));
for i=1:numel(C)
g=findgroups(D(:,1));
hAx=axes;hold on
splitapply(@(y)plot(y),D(:,3),g)
legend("Group "+unique(g))
figure(i)
plot(D(D(:,1)==g(i),3))
end

[mpz]

@dpb I was able to come up with a different method which is different from what I wanted. See below. I would still like to know how to do it the way you showing.

clc;close all
D=table2array(B);
une = unique(D(:,1)); % identifies all the unique elements in column 1 of D
sep = cell(numel(une), 1); % sums all the elements identified above and builds a cell 
for i=1:numel(une)
    index = D(:,1)==une(i);
    sep{i} = D(index, 2:3);
    ans=sep{i,1};
    figure(i)
    plot(ans(:,2))
end