清空筛选条件
清空筛选条件

plot every column in an excel sheet and the corresponding column in the second sheet in same box plot with header name as chart title.

4 次查看（过去 30 天）
Anonyms
Anonyms 2023-1-9
回答： J. Alex Lee 2023-1-10
I have excel book with two sheet, both sheet have same headernames for each column, I want each column to be plotteed against it's corresponding similar colum from next sheet with the title of the chart as head name. Is there a small code to call read everycolumn and plot them?
Like below for all the columns in the sheet

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

回答（1 个）

J. Alex Lee
J. Alex Lee 2023-1-10
Ran in:
T1 = readtable("example.xlsx","Sheet","TF off TS","NumHeaderLines",1);
T2 = readtable("example.xlsx","Sheet","No twist free off 31st TS","NumHeaderLines",1);
VarNames = T1.Properties.VariableNames;
fig = figure();
tl = tiledlayout(fig,"flow");
for k = 1:9
nexttile
x = T1.(VarNames{k});
y = T2.(VarNames{k});
c = categorical("sheet" + [ones(size(x));2*ones(size(y))]);
boxchart(c,[x;y])
title(VarNames{k})
end
fig = figure();
tl = tiledlayout(fig,"flow");
for k = 1:numel(VarNames)
nexttile
x = T1.(VarNames{k});
y = T2.(VarNames{k});
c = categorical("sheet" + [ones(size(x));2*ones(size(y))]);
boxchart(c,[x;y])
title(VarNames{k})
end

类别

在 Help Center 和 File Exchange 中查找有关 Data Distribution Plots 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by