Plotting variables of continuously array with different colors

Question

Adi Purwandana 2023-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2031769-plotting-variables-of-continuously-array-with-different-colors

编辑： Adi Purwandana 2023-10-11

采纳的回答： Star Strider

datax.xlsx

Hello everyone,

Is it possible to :

(1) Change the value of Station column of this array (excel attached) into ordered rank Station? Anyone knows the code to do this? FYI, the number of stations is in hundreds (I put here for example only 3 stations) so, doing this in loop is preferable solution.

(2) Plot those three Station's profile of variable "s" vs depth from those three stations with different colors of line plots? Anyone knows the code to do this also?

Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-10-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2031769-plotting-variables-of-continuously-array-with-different-colors#answer_1330329

编辑：Star Strider 2023-10-10

在 MATLAB Online 中打开

datax.xlsx

You can use either unique or findgroups for this to get serial indices —

T1 = readtable('datax.xlsx')

T1 = 17×5 table

Station lon lat depth salinity _______ ______ _____ _____ ________ 2 114.64 -8.16 0 33.995 2 114.64 -8.16 2 33.994 2 114.64 -8.16 4 33.994 2 114.64 -8.16 6 33.993 2 114.64 -8.16 8 33.993 2 114.64 -8.16 10 33.992 7 114.72 -8.16 0 33.976 7 114.72 -8.16 2 33.978 7 114.72 -8.16 4 33.977 7 114.72 -8.16 6 33.977 31 114.8 -8.16 0 33.983 31 114.8 -8.16 2 33.981 31 114.8 -8.16 4 33.981 31 114.8 -8.16 6 33.981 31 114.8 -8.16 8 33.981 31 114.8 -8.16 10 33.98

[Us,ix1,ix2] = unique(T1.Station, 'stable');

T1.Station = ix2

T1 = 17×5 table

Station lon lat depth salinity _______ ______ _____ _____ ________ 1 114.64 -8.16 0 33.995 1 114.64 -8.16 2 33.994 1 114.64 -8.16 4 33.994 1 114.64 -8.16 6 33.993 1 114.64 -8.16 8 33.993 1 114.64 -8.16 10 33.992 2 114.72 -8.16 0 33.976 2 114.72 -8.16 2 33.978 2 114.72 -8.16 4 33.977 2 114.72 -8.16 6 33.977 3 114.8 -8.16 0 33.983 3 114.8 -8.16 2 33.981 3 114.8 -8.16 4 33.981 3 114.8 -8.16 6 33.981 3 114.8 -8.16 8 33.981 3 114.8 -8.16 10 33.98

figure

stem3(T1.Station, T1.depth, T1.salinity, ':k', 'Marker','none')

hold on

scatter3(T1.Station, T1.depth, T1.salinity, 150, T1.salinity, 'p', 'filled')

hold off

xlabel('Station')

ylabel('Depth')

zlabel('Salinity')

xticks(1:3)

This uses the third output of unique to get serial indices (note that I use the 'stable' argument to avoid sorting the results). The findgroups function works similarly to produce a grouping variable. The grouping variable vector is used here as the new value for ‘Station’.

EDIT — Added plots.

.

12 个评论
显示 10更早的评论隐藏 10更早的评论

Star Strider 2023-10-11

在 MATLAB Online 中打开

datax.xlsx

I am not certain what you want to plot.

Plotting ‘salinity’ here —

T1 = readtable('datax.xlsx')

T1 = 17×5 table

Station lon lat depth salinity _______ ______ _____ _____ ________ 2 114.64 -8.16 0 33.995 2 114.64 -8.16 2 33.994 2 114.64 -8.16 4 33.994 2 114.64 -8.16 6 33.993 2 114.64 -8.16 8 33.993 2 114.64 -8.16 10 33.992 7 114.72 -8.16 0 33.976 7 114.72 -8.16 2 33.978 7 114.72 -8.16 4 33.977 7 114.72 -8.16 6 33.977 31 114.8 -8.16 0 33.983 31 114.8 -8.16 2 33.981 31 114.8 -8.16 4 33.981 31 114.8 -8.16 6 33.981 31 114.8 -8.16 8 33.981 31 114.8 -8.16 10 33.98

[Us,ix1,ix2] = unique(T1.Station, 'stable');

T1.Station = ix2

T1 = 17×5 table

Station lon lat depth salinity _______ ______ _____ _____ ________ 1 114.64 -8.16 0 33.995 1 114.64 -8.16 2 33.994 1 114.64 -8.16 4 33.994 1 114.64 -8.16 6 33.993 1 114.64 -8.16 8 33.993 1 114.64 -8.16 10 33.992 2 114.72 -8.16 0 33.976 2 114.72 -8.16 2 33.978 2 114.72 -8.16 4 33.977 2 114.72 -8.16 6 33.977 3 114.8 -8.16 0 33.983 3 114.8 -8.16 2 33.981 3 114.8 -8.16 4 33.981 3 114.8 -8.16 6 33.981 3 114.8 -8.16 8 33.981 3 114.8 -8.16 10 33.98

StaData = accumarray(T1.Station, (1:size(T1,1)).', [], @(x){T1(x,:)})

StaData = 3×1 cell array

{6×5 table} {4×5 table} {7×5 table}

n = numel(StaData);

colororder(jet(n))

cm = colormap(jet(n));

figure

hold on

for k = 1:n

% StaData{k}

scatter(StaData{k}.Station, StaData{k}.salinity, 50, cm(k,:), 's', 'filled')

end

% scatter3(T1.Station, T1.depth, T1.salinity, 150, T1.salinity, 'p', 'filled')

hold off

xlabel('Station')

ylabel('Salinity')

% ylabel('Depth')

% zlabel('Salinity')

xticks(1:3)

xlim([min(xticks)-1 max(xticks)+1])

colormap(jet(n))

hcb = colorbar;

hcb.Ticks = (1:n)/(n);

hcb.TickLabels = 1:n;

hcb.Label.String = 'Stations';

This approach creates individual table arrays for each station in the file, and plots them in a scatter plot.

.

Star Strider 2023-10-11

在 MATLAB Online 中打开

datax.xlsx

I do not know what you want to do.

Using my code, it is relatively straightforward to plot anything against anything —

T1 = readtable('datax.xlsx')

T1 = 17×5 table

Station lon lat depth salinity _______ ______ _____ _____ ________ 2 114.64 -8.16 0 33.995 2 114.64 -8.16 2 33.994 2 114.64 -8.16 4 33.994 2 114.64 -8.16 6 33.993 2 114.64 -8.16 8 33.993 2 114.64 -8.16 10 33.992 7 114.72 -8.16 0 33.976 7 114.72 -8.16 2 33.978 7 114.72 -8.16 4 33.977 7 114.72 -8.16 6 33.977 31 114.8 -8.16 0 33.983 31 114.8 -8.16 2 33.981 31 114.8 -8.16 4 33.981 31 114.8 -8.16 6 33.981 31 114.8 -8.16 8 33.981 31 114.8 -8.16 10 33.98

[Us,ix1,ix2] = unique(T1.Station, 'stable');

T1.Station = ix2

T1 = 17×5 table

Station lon lat depth salinity _______ ______ _____ _____ ________ 1 114.64 -8.16 0 33.995 1 114.64 -8.16 2 33.994 1 114.64 -8.16 4 33.994 1 114.64 -8.16 6 33.993 1 114.64 -8.16 8 33.993 1 114.64 -8.16 10 33.992 2 114.72 -8.16 0 33.976 2 114.72 -8.16 2 33.978 2 114.72 -8.16 4 33.977 2 114.72 -8.16 6 33.977 3 114.8 -8.16 0 33.983 3 114.8 -8.16 2 33.981 3 114.8 -8.16 4 33.981 3 114.8 -8.16 6 33.981 3 114.8 -8.16 8 33.981 3 114.8 -8.16 10 33.98

StaData = accumarray(T1.Station, (1:size(T1,1)).', [], @(x){T1(x,:)})

StaData = 3×1 cell array

{6×5 table} {4×5 table} {7×5 table}

n = numel(StaData);

colororder(jet(n))

cm = colormap(jet(n));

figure

hold on

for k = 1:n

% StaData{k}

plot(StaData{k}.depth, StaData{k}.salinity, '-s', 'Color',cm(k,:), 'MarkerSize',10, 'MarkerEdgeColor',cm(k,:), 'MarkerFaceColor',cm(k,:))

end

% scatter3(T1.Station, T1.depth, T1.salinity, 150, T1.salinity, 'p', 'filled')

hold off

xlabel('Depth')

ylabel('Salinity')

% ylabel('Depth')

% zlabel('Salinity')

% xticks(1:3)

xlim([min(xticks)-1 max(xticks)+1])

colormap(jet(n))

xlim([min(xlim)-1 max(xlim)+1])

hcb = colorbar;

hcb.Ticks = (1:n)/(n)-(1/(2*n));

hcb.TickLabels = 1:n;

hcb.Label.String = 'Stations';

.

Adi Purwandana 2023-10-11

编辑：Adi Purwandana 2023-10-11

I think I solved it...

LON(k,:) = StaData{k}.long(1);

Star Strider 2023-10-11

That is correct.

Actually:

LON = StaData{k}.lon(1);

or:

LON(k) = StaData{k}.lon(1);

depending on the result you want.

(I was away for a few minutes running errands.)

请先登录，再进行评论。

Answer 2

Sulaymon Eshkabilov 2023-10-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2031769-plotting-variables-of-continuously-array-with-different-colors#answer_1330314

在 MATLAB Online 中打开

datax.xlsx

Logical indexing would be an easy way of sorting the data and assigning new values to column 'station'. Then use the sorted data indecies to plot the data: s vs. depth

Here is one of the ways of doing it:

F = readmatrix('datax.xlsx');

Idx1=F(:,1)==2;

Idx2=F(:,1)==7;

Idx3=F(:,1)==31;

F(Idx1,1) = 1;

F(Idx2,1) = 2;

F(Idx3,1) = 3;

% Plotting the data

plot(F(Idx1, 5),F(Idx1, 4), '-o','linewidth', 2), hold all

plot(F(Idx2, 5),F(Idx2, 4), '-s','linewidth', 2)

plot(F(Idx3, 5),F(Idx3, 4), '-d','linewidth', 2)

legend('Station: 1', 'Station: 2', 'Station: 3', 'location', 'best')

grid on

xlabel('s')

ylabel('depth')

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

Adi Purwandana 2023-10-10

Thank you @Sulaymon Eshkabilov. It's solved if the number of station is not much. In my case, the number of stations is in hundreds and even thousands. Do you know to do that in something like looping lines to do this?

请先登录，再进行评论。

Plotting variables of continuously array with different colors

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

12 个评论
显示 10更早的评论隐藏 10更早的评论

更多回答（1 个）

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

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

Plotting variables of continuously array with different colors

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

12 个评论 显示 10更早的评论隐藏 10更早的评论

更多回答（1 个）

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

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

12 个评论
显示 10更早的评论隐藏 10更早的评论

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