Plot data according to different ID
13 ビュー (過去 30 日間)
表示 古いコメント
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 日
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');
その他の回答 (2 件)
参考
カテゴリ
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!