Matlab - How to plot 2 different columns of excel data for 2 boxplot under 1 x-axis label?

Question

Zhan An 2022-12-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1879332-matlab-how-to-plot-2-different-columns-of-excel-data-for-2-boxplot-under-1-x-axis-label

评论： Voss 2023-1-16

I m trying to plot 2 different columns of excelsheet data (.xls) "Data1" & "Data2" under 1 x-axis label "Jan" to compare them side by side visually. How do i do it? Would be really happy if someone could advise me on how to do it.

My excel data:

https://i.stack.imgur.com/5w3DI.png

This is what i m trying to attempt but i do not know what to add in my code to do it:

https://i.stack.imgur.com/KhYwu.png

clear all
clc
surveyData = readtable("surveydata_16Dec2022.xlsx");
surveyData(1:447,["SceneCode", "Data1", "Data2"])
tiledlayout(1,2)
ScoreS = [-3, -2, -1, 0, 1, 2, 3];
mnthOrder = ["Jan","Feb","Mar"];
surveyData.SceneCode = categorical(surveyData.SceneCode, mnthOrder);
surveyData.SceneQuestionCompare = categorical(surveyData.SceneCode, mnthOrder);
% Left axes
ax1 = nexttile
boxchart(surveyData.SceneCode, surveyData.Data1);
xlabel(ax1,'Scenes 1~12')
yt = get(gca, 'YTick');   
ytx = linspace(min(yt), max(yt), numel(ScoreS));
ytl = sprintfc('%.0f',ScoreS);   
ylabel(ax1,'Qn1')
legend('Physical (N=36)')
% Right axes
ax2 = nexttile
boxchart(surveyData.SceneCode, [surveyData.Data2])
xlabel(ax2,'Scenes 1~12')
yt = get(gca, 'YTick');                                                         % Get Y-Tick Values
ytx = linspace(min(yt), max(yt), numel(ScoreS));                                     % New Y-Tick Values
ytl = sprintfc('%.0f',ScoreS);                                                       % New Y-Tick Labels
set(gca, 'YTick',ytx, 'YTickLabel',ytl) 
ylabel(ax2,'Qn2')
legend('VR (N=36)')

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

请先登录，再进行评论。

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

Answer 1

Chaitanya Krishna Kantambhatla 2022-12-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1879332-matlab-how-to-plot-2-different-columns-of-excel-data-for-2-boxplot-under-1-x-axis-label#answer_1137122

Hello Zhan

I understand that you are trying to plot 2 different columns under 1 x-axis label using ‘boxchart’.

Please refer to the examples in this documentation or execute the following command to open the example

>> openExample('graphics/UseCombinationOfGroupingVariablesExample')

This example shows how to plot boxchat for 2 variables on same x- axis, considering Temperature data for the years 2015 and 2016.

I hope the above example was helpful.

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

Zhan An 2023-1-4

Hello Chaitanya Krishna Kantambhatla,

The boxplot function takes in boxplot(xdata, ydata, groupByData). I wanted to put in 2 different columns of data (e.g. cause1, cause2) into the ydata (y-axis) but apparently it only limits me to put in 1 column of data. I do not want the grouping option.

Would appreciate if you have any solution to go around with that!

请先登录，再进行评论。

Answer 2

Voss 2023-1-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1879332-matlab-how-to-plot-2-different-columns-of-excel-data-for-2-boxplot-under-1-x-axis-label#answer_1141547

@Zhan An: This answer is essentially the same as what you're trying to do (plot two boxcharts for each x-tick):

https://www.mathworks.com/matlabcentral/answers/1888377-i-want-to-move-up-my-boxchart#answer_1141527

The idea is to create one boxchart per column of data, and specify the x-location of each boxchart so that one can be a little to the left and one can be a little to the right of the x-tick location.

See if you can adapt it to work with your data. If you have problems, upload your data here (using the paperclip icon).

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

Voss 2023-1-12

在 MATLAB Online 中打开

surveydata_16Dec2022.xlsx

clear all

clc

surveyData = readtable("surveydata_16Dec2022.xlsx");

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

mnthOrder = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];

surveyData.SceneCode = categorical(surveyData.SceneCode, mnthOrder);

G1 = surveyData.HowDoYouFeelAboutTheIntensityOfTheWorkout1_;

G2 = surveyData.HowDoYouFeelAboutTheIntensityOfTheWorkout2_;

figure%(1)

hold on

% convert categorical array to double, to be able to compare it to loop ii below:

codes = double(surveyData.SceneCode);

% also, we'll need to specify the colors, so I grab them from the axes in

% order to use the same as what would've been used in a boxchart with

% multiple boxes, like you had before:

colors = get(gca(),'ColorOrder');

for ii = 1:12

% indices of the ii-th category in the data set:

idx = codes == ii;

% x-coordinate of this category (it's ii, but it has to be a vector the

% same size as idx):

x = ii + zeros(nnz(idx),1);

% plot two boxcharts for this category:

boxchart(x-0.15, G1(idx), 'BoxWidth', 0.3, 'BoxFaceColor',colors(1,:))

boxchart(x+0.15, G2(idx), 'BoxWidth', 0.3, 'BoxFaceColor',colors(2,:))

end

ylabel('Question A')

xlabel('Scenes 1~12')

title("Physical VS VR")

legend('Physical (N=50)', 'VR (N=50)')

Voss 2023-1-16

在 MATLAB Online 中打开

surveydata_16Dec2022.xlsx

You're welcome!

To get the month names on the x-axis, setting the XTick and XTickLabels, as you are doing, is the right way. The XTicks won't align with any bar but instead will be between the two bars for each month.

You can also set the angle at which the x-tick labels are rotated (below I'm using XTickLabelRotation 0 to have horizontal labels).

clear all

clc

surveyData = readtable("surveydata_16Dec2022.xlsx");

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

mnthOrder = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];

surveyData.SceneCode = categorical(surveyData.SceneCode, mnthOrder);

G1 = surveyData.HowDoYouFeelAboutTheIntensityOfTheWorkout1_;

G2 = surveyData.HowDoYouFeelAboutTheIntensityOfTheWorkout2_;

figure%(1)

hold on

% convert categorical array to double, to be able to compare it to loop ii below:

codes = double(surveyData.SceneCode);

% also, we'll need to specify the colors, so I grab them from the axes in

% order to use the same as what would've been used in a boxchart with

% multiple boxes, like you had before:

colors = get(gca(),'ColorOrder');

for ii = 1:12

% indices of the ii-th category in the data set:

idx = codes == ii;

% x-coordinate of this category (it's ii, but it has to be a vector the

% same size as idx):

x = ii + zeros(nnz(idx),1);

% plot two boxcharts for this category:

boxchart(x-0.15, G1(idx), 'BoxWidth', 0.3, 'BoxFaceColor',colors(1,:))

boxchart(x+0.15, G2(idx), 'BoxWidth', 0.3, 'BoxFaceColor',colors(2,:))

end

set(gca(), ...

'XTick',1:12, ...

'XTickLabel',mnthOrder, ...

'XTickLabelRotation',0)

ylabel('Question A')

xlabel('Scenes 1~12')

title("Physical VS VR")

legend('Physical (N=50)', 'VR (N=50)')

Zhan An 2023-1-16

Thanks alot @Voss! You really are a big help for this!

Voss 2023-1-16

You're welcome! Any other questions, let me know. Otherwise, please "Accept This Answer". Thanks!

请先登录，再进行评论。