plotting data from multiple sheets by ID and day

Question

Sophia 2023-2-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1915370-plotting-data-from-multiple-sheets-by-id-and-day

评论： Sophia 2023-2-20

RLC_AD.xlsx

Hi there,

I have data from multiple sheets of a workbook that I am looking to plot separately by ID (first column) and day (sheet name)

The data to plot from each sheet is column 6 (x) and column 5 (y)

The IDs run 1:48 - so 48 separate tiled plots, and within each plot is (up) to 8 lines (days or sheets - which would be the legend)

I am wondering whether this is possible for separate sheets

So far i have used splitapply to group the data by ID but this still plots all the IDs on one graph - not sure how I can separate this and also include the other sheets

B = findgroups(RLCAD(:,1));

dataByID = splitapply( @(varargin) varargin, RLCAD, B);

[nID, ~]=size(dataByID);

figure;

hold on;

for i=1:1:nID

plot(dataByID{i,6},dataByID{i,14});

end

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

请先登录，再进行评论。

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

Answer 1

KSSV 2023-2-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1915370-plotting-data-from-multiple-sheets-by-id-and-day#answer_1175190

编辑：KSSV 2023-2-20

在 MATLAB Online 中打开

fname = 'https://in.mathworks.com/matlabcentral/answers/uploaded_files/1300500/RLC_AD.xlsx' ; 
sheets = sheetnames(fname) ;
h = cell(8,48) ; 
figure
for i = 1:length(sheets)
    T = readtable(fname,'Sheet',sheets(i)) ;
    id = T.(1) ; 
    F = T.(6) ; % This is x-axes data 
    Yield = T.(4) ; % This is y-axes data 
    for j = 1:48
        fprintf('%s sheet of %d id\n',sheets(i),j) ;
        hold on
        h{i,j} = subplot(8,6,j) ;
                         
        plot(h{i,j},F(id==j),Yield(id==j))               
        title(sprintf('id=%d',j))                  
        drawnow
        if i == length(sheets)
            legend(sheets)
        end
    end    
end