Three columns (x,y,z) in table, Loop through table for each X plot Y vs Z

Question

Frederick Awuah-Gyasi 2022-5-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1722715-three-columns-x-y-z-in-table-loop-through-table-for-each-x-plot-y-vs-z

评论： Star Strider 2022-5-23

采纳的回答： Star Strider

table

X Y Z

A 1 3

A 2 4

A 3 10

B 1 4

B 2 4

B 4 6

C 0 1

C 1 4

C 2 5

C 3 7

C 4 8

in this scenario there will be three plots of Y vs Z. how do I structure the loop around

bar(table.Y,table.Z)

thank you.

2 个评论
显示无隐藏无

Frederick Awuah-Gyasi 2022-5-19

A separate plot for each group of A,B and C

Star Strider 2022-5-19

@Frederick Awuah-Gyasi — See my Answer.

请先登录，再进行评论。

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

Answer 1

Star Strider 2022-5-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1722715-three-columns-x-y-z-in-table-loop-through-table-for-each-x-plot-y-vs-z#answer_967390

在 MATLAB Online 中打开

Try this —

CA = {'A' 1 3

'A' 2 4

'A' 3 10

'B' 1 4

'B' 2 4

'B' 4 6

'C' 0 1

'C' 1 4

'C' 2 5

'C' 3 7

'C' 4 8};

T1 = cell2table(CA, 'VariableNames',{'X','Y','Z'})

T1 = 11×3 table

X Y Z _____ _ __ {'A'} 1 3 {'A'} 2 4 {'A'} 3 10 {'B'} 1 4 {'B'} 2 4 {'B'} 4 6 {'C'} 0 1 {'C'} 1 4 {'C'} 2 5 {'C'} 3 7 {'C'} 4 8

[U1,~,ix] = unique(T1.X);

L = numel(U1);

figure

for k = 1:L

subplot(L,1,k)

v = ix == k;

plot(T1.Y(v), T1.Z(v), '.-')

grid

xlabel('Y')

ylabel('Z')

title(U1{k})

ylim([0 10])

end

There are ways to do this that may be more efficient for large arrays, although they require more coding as well.

.

24 个评论
显示 22更早的评论隐藏 22更早的评论

Star Strider 2022-5-20

在 MATLAB Online 中打开

I may need to know what ‘T’ is (at least some representative rows of it).

The purpose of the unique call was to get numeric indices representing the first column. Conccatenating the first colum (with the alphanumeric indicators) with a numeric column will not work. That may be throwing the error, since I get the same error when I use your unique call with the existing table.

The findgroups function will work with ‘X’ and ‘Y’ to give a unique index (although here there are no duplicates in these data).

Other parts of the code change as well —

CA = {'A' 1 3

'A' 2 4

'A' 3 10

'B' 1 4

'B' 2 4

'B' 4 6

'C' 0 1

'C' 1 4

'C' 2 5

'C' 3 7

'C' 4 8};

T1 = cell2table(CA, 'VariableNames',{'X','Y','Z'})

T1 = 11×3 table

X Y Z _____ _ __ {'A'} 1 3 {'A'} 2 4 {'A'} 3 10 {'B'} 1 4 {'B'} 2 4 {'B'} 4 6 {'C'} 0 1 {'C'} 1 4 {'C'} 2 5 {'C'} 3 7 {'C'} 4 8

[ix,ID] = findgroups(T1(:,1:2))

ix = 11×1

1 2 3 4 5 6 7 8 9 10

ID = 11×2 table

X Y _____ _ {'A'} 1 {'A'} 2 {'A'} 3 {'B'} 1 {'B'} 2 {'B'} 4 {'C'} 0 {'C'} 1 {'C'} 2 {'C'} 3 {'C'} 4

L = numel(ix);

figure

for k = 1:L

subplot(L,1,k)

v = ix == k;

plot(T1.Y(v), T1.Z(v), '.-')

grid

xlabel('Y')

ylabel('Z')

% title(U1{k})

ylim([0 10])

end

.

Star Strider 2022-5-21

在 MATLAB Online 中打开

I have no recent experience with videoWriter, however I will do my best to see if I can get this to work.

I am eliminating the saveas call for the time being, since it may not work with the online Run feature here.

CA = {'A' 1 3

'A' 2 4

'A' 3 10

'B' 1 4

'B' 2 4

'B' 4 6

'C' 0 1

'C' 1 4

'C' 2 5

'C' 3 7

'C' 4 8};

T1 = cell2table(CA, 'VariableNames',{'X','Y','Z'})

T1 = 11×3 table

X Y Z _____ _ __ {'A'} 1 3 {'A'} 2 4 {'A'} 3 10 {'B'} 1 4 {'B'} 2 4 {'B'} 4 6 {'C'} 0 1 {'C'} 1 4 {'C'} 2 5 {'C'} 3 7 {'C'} 4 8

% [U1,~,ix] = unique(T1.X);

%

% L = numel(U1);

%

% figure

% for k = 1:L

% subplot(L,1,k)

% v = ix == k;

% plot(T1.Y(v), T1.Z(v), '.-')

% grid

% xlabel('Y')

% ylabel('Z')

% title(U1{k})

% ylim([0 10])

% end

[U1,~,ix] = unique(T1.X);

L = numel(U1);

figure

for k = 1:L

subplot(L,1,k)

v = ix == k;

plot(T1.Y(v), T1.Z(v), '.-')

grid

xlabel('Y')

ylabel('Z')

title(U1{k})

ylim([0 10])

% saveas(gcf,name)

GF = getframe(gcf) % Test

animeVector(k) = getframe(gcf);

end

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

myWriter = VideoWriter('LevelMovie');

myWriter.FrameRate = 20;

open(myWriter);

writeVideo(myWriter,animeVector);

close(myWriter);

Using:

animeVector(k) = getframe(gcf);

appears to run without error.

.

Star Strider 2022-5-22

在 MATLAB Online 中打开

I have no idea if it looks right, however with a few changes in the code, it runs without error —

CA = {'A' 1 0 3

'A' 1 2 3

'A' 1 3 3

'A' 2 0 5

'A' 2 2 7

'A' 2 3 8

'B' 1 0 3

'B' 1 1 3

'B' 1 3 3

'B' 2 0 12

'B' 2 2 1

'B' 2 3 3

'C' 1 0 2

'C' 1 1 1

'C' 1 2 3

'C' 2 0 4

'C' 2 1 3

'C' 2 2 6};

T1 = cell2table(CA,'VariableNames',{'X','W','Y','Z'})

T1 = 18×4 table

X W Y Z _____ _ _ __ {'A'} 1 0 3 {'A'} 1 2 3 {'A'} 1 3 3 {'A'} 2 0 5 {'A'} 2 2 7 {'A'} 2 3 8 {'B'} 1 0 3 {'B'} 1 1 3 {'B'} 1 3 3 {'B'} 2 0 12 {'B'} 2 2 1 {'B'} 2 3 3 {'C'} 1 0 2 {'C'} 1 1 1 {'C'} 1 2 3 {'C'} 2 0 4

[ix,ID] = findgroups(T1(:,1:2))

ix = 18×1

1 1 1 2 2 2 3 3 3 4

ID = 6×2 table

X W _____ _ {'A'} 1 {'A'} 2 {'B'} 1 {'B'} 2 {'C'} 1 {'C'} 2

L = size(ID,1);

figure

for k = 1:L

figure(k) %subplot(L,1,k)

v = ix == k;

plot(T1.Y(v), T1.Z(v), '.-')

grid

xlabel('Y')

ylabel('Z')

title(sprintf('%s %d',ID{k,1}{:},ID{k,2}))

ylim([0 10])

GF = getframe(gcf) % Test

animeVector(k) = getframe(gcf);

end

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

myWriter = VideoWriter('LevelMovie');

myWriter.FrameRate = 20;

open(myWriter);

writeVideo(myWriter,animeVector);

close(myWriter);

I have no idea how this relates to your other post Cross product of two tables without common key so I will leave that alone.

.

Star Strider 2022-5-22

在 MATLAB Online 中打开

I have no idea how you want to combine them.

Try this —

CA = {'A' 1 0 3

'A' 1 2 3

'A' 1 3 3

'A' 2 0 5

'A' 2 2 7

'A' 2 3 8

'B' 1 0 3

'B' 1 1 3

'B' 1 3 3

'B' 2 0 12

'B' 2 2 1

'B' 2 3 3

'C' 1 0 2

'C' 1 1 1

'C' 1 2 3

'C' 2 0 4

'C' 2 1 3

'C' 2 2 6};

T1 = cell2table(CA,'VariableNames',{'X','W','Y','Z'})

T1 = 18×4 table

X W Y Z _____ _ _ __ {'A'} 1 0 3 {'A'} 1 2 3 {'A'} 1 3 3 {'A'} 2 0 5 {'A'} 2 2 7 {'A'} 2 3 8 {'B'} 1 0 3 {'B'} 1 1 3 {'B'} 1 3 3 {'B'} 2 0 12 {'B'} 2 2 1 {'B'} 2 3 3 {'C'} 1 0 2 {'C'} 1 1 1 {'C'} 1 2 3 {'C'} 2 0 4

[ix,ID] = findgroups(T1(:,1:2))

ix = 18×1

1 1 1 2 2 2 3 3 3 4

ID = 6×2 table

X W _____ _ {'A'} 1 {'A'} 2 {'B'} 1 {'B'} 2 {'C'} 1 {'C'} 2

L = size(ID,1);

figure

for k = 1:2:L

figure(k) %subplot(L,1,k)

v = find(ix == k);

v2 = v:v+5;

plot(T1.Y(v2(1:3)), T1.Z(v2(1:3)), '.-')

hold on

plot(T1.Y(v2(1:3)+3), T1.Z(v2(1:3)+3), '.-')

hold off

grid

xlabel('Y')

ylabel('Z')

title(sprintf('%s',ID{k,1}{:}))

ylim([0 10])

GF = getframe(gcf) % Test

animeVector(k) = getframe(gcf);

end

v = 3×1

1 2 3

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

v = 3×1

7 8 9

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

v = 3×1

13 14 15

GF = struct with fields:

cdata: [433×577×3 uint8] colormap: []

myWriter = VideoWriter('LevelMovie');

myWriter.FrameRate = 20;

open(myWriter);

writeVideo(myWriter,animeVector);

Error using VideoWriter/writeVideo
The 'cdata' field of FRAME must not be empty

close(myWriter);

This combines the plots.

I defer to you to solve the writeVideo error.

.

Frederick Awuah-Gyasi 2022-5-23

@Star Strider this code produces 3 .mp4 files which I want. but Level_1_Movie_A.mp4 for instanfce should be just for A(show only A1 and A2) same for B and C. somehow the if condition is not working. Any ideas?

CA = {'A' 1 0 3

'A' 1 2 3

'A' 1 3 3

'A' 2 0 5

'A' 2 2 7

'A' 2 3 8

'B' 1 0 3

'B' 1 1 3

'B' 1 3 3

'B' 2 0 12

'B' 2 2 1

'B' 2 3 3

'C' 1 0 2

'C' 1 1 1

'C' 1 2 3

'C' 2 0 4

'C' 2 1 3

'C' 2 2 6};

T1 = cell2table(CA,'VariableNames',{'X','W','Y','Z'});

[ix,ID] = findgroups(T1(:,1:2));

[U1,~,ixx] = unique(T1.X);

L = size(ID,1);

Names = unique(T1.X)

M = numel(U1);

for b = 1:length(Names)

for k = 1:L

figure(k) %subplot(L,1,k)

%

v = find(ix == k);

data=unique(T1.X(v))

Names(b)

ismember( Names(b), data )

if ismember( Names(b), data )

T1.X(v)

plot(T1.Y(v), T1.Z(v), '.-')

grid

xlabel('Y')

ylabel('Z')

title(sprintf('%s %d',ID{k,1}{:},ID{k,2}))

ylim([0 10])

GF = getframe(gcf) % Test

Vector(k) = getframe(gcf);

end

moviename = strcat('Level_1_Movie_', Names(b))

myWriter = VideoWriter(moviename{1},'MPEG-4');

myWriter.FrameRate = 20;

open(myWriter);

writeVideo(myWriter,Vector);

close(myWriter);

end

Frederick Awuah-Gyasi 2022-5-23

Thanks @Star Strider. I will try posting it as a question. Let's see if anyone comes to help. I will keep trying too. Now I'm getting the 3 animations except each animation should be exclusive to a group from column X

Star Strider 2022-5-23

As always, my pleasure!

Perhaps someone else has some new insights that I do have not at this point.

请先登录，再进行评论。

Answer 2

KSSV 2022-5-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1722715-three-columns-x-y-z-in-table-loop-through-table-for-each-x-plot-y-vs-z#answer_967105

在 MATLAB Online 中打开

Let data be your three column matrix.

x = data(:,1) ;
y = data(:,2) ;
z = data(:,3) ; 
xi = unique(x) ;
yi = unique(y) ;
nx = length(xi) ; 
ny = length(yi) ;
% Matrices
[X,Y] = meshgrid(x,y) ; 
Z = reshape(z,[ny,nx]) ;

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Frederick Awuah-Gyasi 2022-5-19

Thank you. I will try this out. But was hoping for example

For X in list (X) :

plot(Y,Z)

For if X = A

the data to plot will beb

Y Z

1 3

2 4

3 10

请先登录，再进行评论。

Three columns (x,y,z) in table, Loop through table for each X plot Y vs Z

2 个评论
显示无隐藏无

采纳的回答

24 个评论
显示 22更早的评论隐藏 22更早的评论

更多回答（1 个）

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

另请参阅

类别

标签

Community Treasure Hunt

Three columns (x,y,z) in table, Loop through table for each X plot Y vs Z

2 个评论 显示 无隐藏 无

采纳的回答

24 个评论 显示 22更早的评论隐藏 22更早的评论

更多回答（1 个）

1 个评论 显示 -1更早的评论隐藏 -1更早的评论

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

24 个评论
显示 22更早的评论隐藏 22更早的评论

1 个评论
显示 -1更早的评论隐藏 -1更早的评论