Group Transpose and plot

2019 10 14
1 个回答
更新时间：2019 10 18
1 次查看（30 天）

0 个投票

Hi,
I want to group and transpose a set of data and then crpresent is as a plot.
Please see the attached excel file Graph.xlsx.
As given in sheet1 of the file,
Range A2:C108 contain the raw data. I want to group and transpose it to as given in the range F1:P14
And finally plot the transformed data.
Please help.
Thanks

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

回答（1 个）

Maneesh
Maneesh 2019-10-18

0 个投票

Got it
filename = 'Graph.xlsx';
sheet1 = 'Sheet1'; %All ISINs in the portfolio
xlRange1 = 'A2:C108';
scoreData = readtable(filename,'Sheet','Sheet1','Range','A2:C108','ReadVariableNames',true);
scoreData2cell = table2cell(scoreData);
M=cell2mat(scoreData2cell(:,2:3));
[~,Header]=ismember(scoreData2cell(:,1),unique(scoreData2cell(:,1)));
K=accumarray([M(:,1),Header],M(:,2));

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

产品

标签

提问:

Maneesh
Maneesh
2019-10-14

回答：

Maneesh
Maneesh
2019-10-18

Community Treasure Hunt

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

Start Hunting!

Translated by