How to plot graphs with looping through string variables?

Question

Chang seok Ma 2021-8-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1440679-how-to-plot-graphs-with-looping-through-string-variables

评论： Chang seok Ma 2021-9-3

采纳的回答： Dave B

在 MATLAB Online 中打开

Hello,

I have one question about plotting graphs.

I want to use loop with string variables as below.

Basically, I want to read the sheet of the excel and also put the title of the graph using string variables.

But with the code I wrote as below, I am using 'specification' which is a number not a string.

Is there any way I can deal with this?

Thank you.

group = {'r_new_car' 'r_used_car' 'r_used_truck'};
for member = 1:length(group)
    
specification = member;
figcount = 1;
horizon = xlsread('results.xlsx',specification,'C2:K2');
coefficients = xlsread('results.xlsx',specification,'C4:K4');
ses = xlsread('results.xlsx',specification,'C5:K5');
h_to_plot = linspace(1,9,9);
%,'LineSpec','-'
errorbar(horizon(h_to_plot),coefficients(h_to_plot),quant*ses(h_to_plot),'o','Linewidth',1.5)
line([-4,7],[0,0],'Color',black,'LineStyle','-')
xlim([-4 6])
grid on
xticks(-3:1:5)
title(specification)
set(figure(figcount), 'PaperUnits', 'inches');
scale = 3;
x_width=scale*3; y_width=scale*2;
set(figure(figcount), 'PaperPosition', [0 0 x_width y_width]); 
%print(strcat('result','_',specification),'-dpng','-r300')
figcount = figcount + 1;
hold off
end

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

Stephen23 2021-8-25

Probably you should import the file as a table:

https://www.mathworks.com/help/matlab/ref/readtable.html

then you can just loop over the column/variable names:

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html

请先登录，再进行评论。

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

Answer 1

Dave B 2021-8-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1440679-how-to-plot-graphs-with-looping-through-string-variables#answer_774674

编辑：Dave B 2021-8-26

在 MATLAB Online 中打开

I agree with @Stephen, your life will be much easier if you use readtable.

Are you saying you want to use specification and find the corresponding values in group?

group = {'r_new_car' 'r_used_car' 'r_used_truck'};
for member = 1:length(group)
    specification = member; % not sure what this line does, you could just use write specification above instead of member
    groupname = group{specification};
end