Plot data according to different ID

6 visualizaciones (últimos 30 días)
Soso
Soso el 9 de Mzo. de 2021
Comentada: Soso el 9 de Mzo. de 2021
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 comentarios
Nora Khaled
Nora Khaled el 9 de Mzo. de 2021
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 el 9 de Mzo. de 2021
What did you try so far? Did you already Google how to read a csv file?

Iniciar sesión para comentar.

Respuesta aceptada

Nora Khaled
Nora Khaled el 9 de Mzo. de 2021
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');

Más respuestas (2)

Soso
Soso el 9 de Mzo. de 2021
Yes I want to plot measurement vs time/date for each ID.
Thanks

Soso
Soso el 9 de Mzo. de 2021
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.

Categorías

Más información sobre Data Distribution Plots en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by