Plot data according to different ID

Question

Soso 2021-3-9

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/767246-plot-data-according-to-different-id

评论： Soso 2021-3-9

Hi

I have csv file that have 3 culomns, first is IDs, second is date/time and third is the actual data. The data includs measrments that occured at specific date/time for each ID, so that all measurments are displayed for eah ID one by one. I need to plot the data per ID and I need help on how to ask MATLAB to call data that belong to each ID and subplot them.

2 个评论
显示无隐藏无

Nora Khaled 2021-3-9

can you please give us a sample data to work with?

also, you mean that you want to plot measurement vs time/date for each ID, right ?

Rik 2021-3-9

What did you try so far? Did you already Google how to read a csv file?

请先登录，再进行评论。

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

Answer 1

Nora Khaled 2021-3-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/767246-plot-data-according-to-different-id#answer_643122

在 MATLAB Online 中打开

This might work

t = readtable('samle_data.xlsx');
% devide table into groups using ID
G = findgroups(t(:,1));    
dataByID = splitapply( @(varargin) varargin, t, G);
%use dataByID to plot 
[nID,~]=size(dataByID); % number of different IDs
figure;
hold on; 
for i=1:1:nID
    plot(dataByID{i,2},dataByID{i,3}); 
end 
xlabel('time/date');
ylabel('measurements'); 