How to efficiently arrange a FOR-LOOP if we have two condition with different nValue

Question

balandong 2017-7-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347867-how-to-efficiently-arrange-a-for-loop-if-we-have-two-condition-with-different-nvalue

关闭： MATLAB Answer Bot 2021-8-20

Dear Matlab coder,

The objective is to execute a function depending to the three different variable state (i.e., Condition_Cond, Condition_TTDay & CONDITION_3). The function will find the index location if it fulfill the 3 conditions. State of each of the 3 condition are: Condition_Cond: Acond & Bcond; Condition_TTDay: BL, SS1 & SS2:. However, the state of the CONDITION_3 is depending to the Condition_TTDay. In other word, CONDITION_3 will have 2 or 3 state if the Condition_TTDay is either BL or (SS1 & SS2).

To realize this, a 3 level FOR-LOOP is constructed. Since the number of execution times at the most inner FOR-LOOP (i.e., CONDITION_3) is dependent on the second level FOR-LOOP (i.e., Condition_TTDay), a SWITCH is introduced. The following code and expected figure are shown below. The excel file can be download thru this link excelFile

My question is, how can I avoid the usage of SWITCH, is there any other alternative to make this code more compact? In addition, it is difficult to assign the output of Valindex, since the inner loop (Condition3) have two different values!.

Thanks in advance for the wisdom

filename = 'DataExcel.xlsx'; 
[~,~,raw] = xlsread(filename,'Sheet1','','basic');
Condition_Cond = {'ACond' 'BCond'};
Condition_TTDay = {'BL' 'SS1' 'SS2'};
c= 1;
for i=1:2
    for j =1:3
        condition_1 = Condition_Cond {i};
        condition_2 = Condition_TTDay {j};
        switch condition_2
            case  'BL'
                for k =1:2
                    condition_3 = k;
                    Valindex (:,c) = calMean (raw,condition_1, condition_2, condition_3)
                c=c+1
end
            otherwise
                for k =1:3
                    condition_3 = k;
                    Valindex (:,c) = calMean (raw, condition_1, condition_2, condition_3)
                c=c+1
end
        end
    end
end
function Valindex = calMean (raw,condition_1, condition_2, condition_3)
valid    = find(cellfun('isclass', raw(:, 2), 'char') & ...
    cellfun('isclass', raw(:, 3), 'char') & ...
    cellfun('isclass', raw(:, 7),'double'));
Valindex    = valid((strcmp(raw(valid,2), condition_1)) & ...
    (strcmp(raw(valid,3), condition_2)) & ...
    ([raw{valid,7}].' == condition_3));
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Joshua 2017-7-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347867-how-to-efficiently-arrange-a-for-loop-if-we-have-two-condition-with-different-nvalue#answer_273389

编辑：Joshua 2017-7-8

在 MATLAB Online 中打开

I think this answers your first question at least. Might take care of the second question as well since there is just one loop now.

filename = 'DataExcel.xlsx';
[~,~,raw] = xlsread(filename,'Sheet1','','basic');
Condition_Cond = {'ACond' 'BCond'};
Condition_TTDay = {'BL' 'SS1' 'SS2'};
c= 1;
for i=1:2
    for j =1:3
        condition_1 = Condition_Cond {i};
        condition_2 = Condition_TTDay {j};
          for k =1:length(condition_2)
              condition_3 = k;
              Valindex (:,c) = calMean (raw,condition_1, condition_2, condition_3)
              c=c+1
          end
      end
  end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 2

balandong 2017-7-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/347867-how-to-efficiently-arrange-a-for-loop-if-we-have-two-condition-with-different-nvalue#answer_273408

编辑：balandong 2017-7-9

Hi Joshua, Thanks for the response. I am afraid your solution does not produce the intended result. Some of the index is missing. In additio, the proposed solution cannot be generalized if, say, the condition_TTday have more than 3 possible state, for example Condition_TTday = 'BL' 'SS1'' SS2' 'SS3' 'SS4'.

Thanks for the response