Borrar filtros
Borrar filtros

Duration of time values for separate datasets and plotting on x-axis

2 visualizaciones (últimos 30 días)
I have the following data sets that have in the x-axis time in "HH:mm:ss". Each data set has different numbers of "times" but they are all within a 2hr duration.
I want to plot this data in terms of duration on the same axes.
Sorry this is the update data.
set0_time=["085440","091530","092000","093020","100000","100020","101325"];
set0_ydata=[30 50 60 72 82 85 88];
H_set0 = str2double(extractBefore(set0_time(:),3));
M_set0 = str2double(extractBetween(set0_time(:),3,4));
S_set0 = str2double(extractAfter(set0_time(:),4));
D_set0 = duration(H_set0,M_set0,S_set0);
t_minutes_set0 = minutes(D_set0);
set1_time = ["121101","121105","130001","133025","140000"];
set1_ydata=[40 50 60 70 89];
H_set1 = str2double(extractBefore(set1_time(:),3));
M_set1 = str2double(extractBetween(set1_time(:),3,4));
S_set1 = str2double(extractAfter(set1_time(:),4));
D_set1 = duration(H_set1,M_set1,S_set1);
t_minutes_set1 = minutes(D_set1);
tdiff_minutes_set1 = t_minutes_set1 - t_minutes_set0(1:5); %There is an issue selecting the first five of set0 as the shift is not accurate
tdiff_shift_set1 = t_minutes_set1-tdiff_minutes_set1;
set2_time = ["103235","110010","120000","130130"];
set2_ydata=[37.8 70 85.7 93.6];
H_set2 = str2double(extractBefore(set2_time(:),3));
M_set2 = str2double(extractBetween(set2_time(:),3,4));
S_set2 = str2double(extractAfter(set2_time(:),4));
D_set2 = duration(H_set2,M_set2,S_set2);
t_minutes_set2 = minutes(D_set2);
tdiff_minutes_set2 = t_minutes_set2 - t_minutes_set0(1:4); %There is an issue selecting the first four of set0 as the shift is not accurate
tdiff_shift_set2 = t_minutes_set2-tdiff_minutes_set2;
figure(15)
scatter(t_minutes_set0,set0_ydata,'Marker','o', 'DisplayName','set0') %updated this line
hold on;
scatter(tdiff_shift_set1,set1_ydata,'Marker','*', 'DisplayName','set1')
scatter(tdiff_shift_set2,set2_ydata,'Marker','+', 'DisplayName','set2')
hold off
xlabel('Duration');
ylabel('Data');
legend
I'm not sure how to get all the data on the same plot but in the same "duration" of time.
Any help is appreciated.

Respuesta aceptada

Steven Lord
Steven Lord el 24 de Sept. de 2024
set0_time=["085440","091530","092000","093020","100000","100020","101325"];
set0 = set0_time;
set0_ydata=[30 50 60 72 82 85 88];
H_set0 = str2double(extractBefore(set0(:),3));
M_set0 = str2double(extractBetween(set0(:),3,4));
S_set0 = str2double(extractAfter(set0(:),4));
D_set0 = duration(H_set0,M_set0,S_set0);
t_minutes_set0 = minutes(D_set0);
% *snip the other data sets*
figure(1)
% scatter(set0_time,set0_ydata,'Marker','o', 'DisplayName','set0')
You didn't intend to use the string array set0_time in this scatter call, did you? I'll show what that would do after what I believe is the correct code.
scatter(D_set0, set0_ydata, 'Marker', 'o', 'DisplayName', 'set0') % Changed first input
figure
scatter(set0_time,set0_ydata,'Marker','o', 'DisplayName','set0') % won't work
Error using scatter (line 68)
Input arguments must be numeric, datetime, duration, or categorical.
  5 comentarios
Steven Lord
Steven Lord el 24 de Sept. de 2024
Okay, so do you mean you want each of set0, set1, and set2 to start at 0? In that case don't combine the data sets. Just subtract the first element of each set from the rest of that same set.
set0_time=["085440","091530","092000","093020","100000","100020","101325"];
d0 = convert(set0_time)
d0 = 1x7 duration array
08:54:40 09:15:30 09:20:00 09:30:20 10:00:00 10:00:20 10:13:25
d0_start = d0 - d0(1)
d0_start = 1x7 duration array
00:00:00 00:20:50 00:25:20 00:35:40 01:05:20 01:05:40 01:18:45
Note that the first element is 0.
d0_minutesElapsed = minutes(d0_start)
d0_minutesElapsed = 1×7
0 20.8333 25.3333 35.6667 65.3333 65.6667 78.7500
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
Do the same for the second set.
set1_time = ["121101","121105","130001","133025","140000"];
d1 = convert(set1_time)
d1 = 1x5 duration array
12:11:01 12:11:05 13:00:01 13:30:25 14:00:00
d1_start = d1 - d1(1)
d1_start = 1x5 duration array
00:00:00 00:00:04 00:49:00 01:19:24 01:48:59
d1_minutesElapsed = minutes(d1_start)
d1_minutesElapsed = 1×5
0 0.0667 49.0000 79.4000 108.9833
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
And the third.
set2_time = ["103235","110010","120000","130130"];
d2 = convert(set2_time)
d2 = 1x4 duration array
10:32:35 11:00:10 12:00:00 13:01:30
d2_start = d2 - d2(1)
d2_start = 1x4 duration array
00:00:00 00:27:35 01:27:25 02:28:55
d2_minutesElapsed = minutes(d2_start)
d2_minutesElapsed = 1×4
0 27.5833 87.4167 148.9167
<mw-icon class=""></mw-icon>
<mw-icon class=""></mw-icon>
Or were you looking more for the difference between corresponding elements of the same set?
d0 % Reminder of the values from d0
d0 = 1x7 duration array
08:54:40 09:15:30 09:20:00 09:30:20 10:00:00 10:00:20 10:13:25
d0_spacing = [0, diff(d0)]
d0_spacing = 1x7 duration array
00:00:00 00:20:50 00:04:30 00:10:20 00:29:40 00:00:20 00:13:05
By this, the second element of d0 is just under 21 minutes after the first element and the third element is 4 and a half minutes after the second. I added the 0 at the start because the output of diff for many types is one element shorter than the input and the first element of d0 is 0 minutes after the first element.
function dt = convert(t)
hms = double(t);
s = mod(hms, 100); % least significant two digits
hm = (hms-s)/100; % hm is an integer after the division
m = mod(hm, 100); % middle two significant digits of hms
h = (hm-m)/100; % again, by the way m was constructed h is an integer after division
dt = duration(h, m, s);
end
James
James el 24 de Sept. de 2024
Thank you! This is what I needed.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Productos


Versión

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by