Extracting a section of data with conditions/limits

1 view (last 30 days)
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

Accepted Answer

Abolfazl Chaman Motlagh
Abolfazl Chaman Motlagh on 17 Feb 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

More Answers (0)

Categories

Find more on MATLAB 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!