How to sort .txt files according to their content (number values) with an if-else-condition?

Question

Tim K 2022-8-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1783525-how-to-sort-txt-files-according-to-their-content-number-values-with-an-if-else-condition

评论： Tim K 2022-8-26

Dear all,

I have a Results.txt file, which contains a table with 13 columns with parameter-values. My goal is to loop through this table rows and give the Results.txt file an ending (_P1 or _P2 according to the if-condition). Right now I believe Matlab is going through the table and adding the ending P1 or P2 depending on which of the two if-conditions are met first.

Is there a way to collect all rows from the table which matches the conditions and give an ending according to the condition that matches with more rows than the other condition?

Thanks!

    for x = 1 : size(Results,1)
    
        if (Results(x,2) > limA2) && (Results(x,12) < limAR) && (Results(x,13) > limR2)
            Type = [name + '_P1'];
            
        elseif (Results(x,2) > limA1) && (Results(x,12) > limAR) && (Results(x,13) < limR1)
            Type = [name + '_P2'];    
            
        end
        
end

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mathieu NOE 2022-8-23

hello

do you have an issue with your code or what is the issue ?

do you have a working exmaple (with the txt file) to provide ?

tx

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kartikay Sapra 2022-8-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1783525-how-to-sort-txt-files-according-to-their-content-number-values-with-an-if-else-condition#answer_1033035

编辑：Kartikay Sapra 2022-8-25

在 MATLAB Online 中打开

Creating 2 variables which store the numbers of rows for each condition would help in finding the condition which makes up the majority:

count_1 = 0;
count_2 = 0;
for x = 1 : size(Results,1)
    
        if (Results(x,2) > limA2) && (Results(x,12) < limAR) && (Results(x,13) > limR2)
            count_1 = count_1+1;
            
        elseif (Results(x,2) > limA1) && (Results(x,12) > limAR) && (Results(x,13) < limR1)
            count_2 = count_2+1;    
            
        end
        
end
if (count1>count2)
%     More rows satisfy the first condition
      Type = [name + '_P1'];
elseif (count1<count2)
%     More rows satisfy the second condition    
      Type = [name + '_P2'];
end
% Faster vectorised approach 
col_2 = Results(:,2);
col_12 = Results(:,12);
col_13 = Results(:,13);
count1 = sum(any(Results((col_2 > limA2) & (col_12 < limAR) & (col_13 > limR2),:),2));
count2 = sum(any(Results((col_2 > limA1) & (col_12 > limAR) & (col_13 < limR1),:),2));
if (count1>count2)
%     More rows satisfy the first condition
      Type = [name + '_P1'];
elseif (count1<count2)
%     More rows satisfy the second condition    
      Type = [name + '_P2'];
end