hello
this is my first attempt , I hope I didn't make any mistake in your requirements interpretation
still there is one case which is maybe not exactly treated as you wish : what are we suppose to do if we have for example one flag ("flag sunglint (Lw)") which has one 1 and the other flag ("flag sunglint (Rrs)") has two 1's ? for the time being my code keep both rows as valid . Only if both rows has both falgs having two 1's we do the min value search in the 13th column
this maybe needs a further improvement of the code
dataArray = Lw;
dataArray = table2array(dataArray);
%add code which at each timepoint, pics the first or second row based
%on if it passes first the sunlight flags and then the sunglint flags
[m,n] = size(dataArray);
out = []; % init
for k = 1:floor(m/2) % loop over 2 lines (rows) of data
r = (1:2)+(k-1)*2; % current 2 rows index
array = dataArray(r,:);
% I need to at each time point pick one of these rows to use and omit the other based on the"flag" columns.
% I want to first apply the "flag light availability" (C7) and "flag
% light quality" (C8) so that only rows which pass both of these (has a 1 in both of these columns)
% are included.
flag_light_availability = array(:,7); % 7th column
flag_light_quality = array(:,8); % 8th column
ind_rows1 = (flag_light_availability>0) & (flag_light_quality>0); % NB I prefer >0 instead of == 1 , it's more robust to round off / precision error
% keep the valid rows
array = array(ind_rows1,:);
% Then I want to use the "flag sunglint (Lw)" (C10) and "flag sunglint (Rrs)" (C11) columns
% the row with a 1 in at least one flag column should be used, if both rows have 1's in both flag columns
% then the row with the lowest value in column 13 should be used.
% If both rows show all 0s then both rows should be excluded.
flag_sunglint_Lw = array(:,10); % 10th column
flag_sunglint_Rrs = array(:,11); % 11th column
ind_rows2 = (flag_sunglint_Lw>0);
ind_rows3 = (flag_sunglint_Rrs>0);
% find if both rows have 1's in both flag columns
ind_rows_common = ind_rows2 & ind_rows3;
if all(ind_rows_common) % case 1 : both rows have 1's in both flag columns
% get corresponding values of column13
C13_data = array(ind_rows_common,13); % 13th column
% find which row has the lowest value in 13th col
[val,ind] = min(C13_data);
array = array(ind,:);
else % case 1 : we have only one flag == 1 => simply keep the data where one flag is == 1 (logical OR)
array = array(ind_rows2>0 | ind_rows3>0 ,:);
end
l(k) = size(array,1); % for debug only (shows how many of the 2 initial rows have been finally stored in the output)
out = [out; array]; % concat all valid data
end
% % Extract relevant data for plotting
% x = 320:2:950;
% y = dataArray(2:end, 13:328);
% L = y(1:2:end, :);
% R = y(2:2:end, :);
%
% % Plot the data
% subplot(2, 1, 1);
% plot(x, L);
% subplot(2, 1, 2);
% plot(x, R);
