Plot data according to different ID

조회 수: 6 (최근 30일)
Soso
Soso 2021년 3월 9일
댓글: 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
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
Rik 2021년 3월 9일
What did you try so far? Did you already Google how to read a csv file?

댓글을 달려면 로그인하십시오.

채택된 답변

Nora Khaled
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');
  댓글 수: 1
Soso
Soso 2021년 3월 9일
Thank you very much for your help

댓글을 달려면 로그인하십시오.

추가 답변 (2개)

Soso
Soso 2021년 3월 9일
Yes I want to plot measurement vs time/date for each ID.
Thanks

Soso
Soso 2021년 3월 9일
Yes, I know how to upload the file, I just need to know how I could call the data per ID and plot it over time.

카테고리

Help CenterFile 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