Extracting a section of data with conditions/limits

1 visualización (últimos 30 días)
I have two data sets that correspond with one another:
altitude = [0; 1; 2; 3; 4; 5]
time = [08:05; 08:06; 08:07, 08:08, 08:09; 08:10]
I want to extract the section between time=08:06 and time=08:09 and it's corresponding altitude

Respuesta aceptada

Abolfazl Chaman Motlagh
Abolfazl Chaman Motlagh el 17 de Feb. de 2022
altitude = [0; 1; 2; 3; 4; 5];
time = ['08:05'; '08:06'; '08:07'; '08:08'; '08:09'; '08:10'];
hours = str2num(time(:,1:2));
minutes = str2num(time(:,4:5));
flag = and(minutes>6,minutes<9);
desired_data = table(altitude(flag) , time(flag,:) , 'VariableNames',{'Altitudes','Time'})
desired_data = 2×2 table
Altitudes Time _________ _____ 2 08:07 3 08:08
if your time in general could be more complex, convert it to minutes (or seconds) then create flag vector:
minutes = hours*60 + minutes ;
flag = and(minutes>485,minutes<489); % 08:05 is 485 minutes, 08:09 is 489 minutes

Más respuestas (0)

Categorías

Más información sobre Time Series Events en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by