find out negative values and specific values, take it out, record those negative and specific values into a text file

Question

zhi cheng 2022-10-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1821833-find-out-negative-values-and-specific-values-take-it-out-record-those-negative-and-specific-values

评论： Image Analyst 2022-10-12

given a (52560 x 8 double)

I need to find out the negative values from the last 3 columns, and if the value is 70% more than the sum of last 3 values and next 3 values

then replace the value with the sum of last 3 values and next 3 values divided by 6.

then record those values into a log file(txt file) (X x 3 matrix)

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

zhi cheng 2022-10-11

I just started doing it, I just done combine data from 3 txt file into 1 matrix, and split the variables.

so far this part, I have no idea how to do it

Image Analyst 2022-10-12

If it's homework, see this:

How do I get help on homework questions on MATLAB Answers? - MATLAB Answers - MATLAB Central

请先登录，再进行评论。

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

Answer 1

Ghazwan 2022-10-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1821833-find-out-negative-values-and-specific-values-take-it-out-record-those-negative-and-specific-values#answer_1071083

在 MATLAB Online 中打开

The following code should do it. Note that because of the rules you have, you have to skip the first and the last three row.

A=[52560 x 8];
X=zeros(1,3);
for ii=4:length(A(:,1))-3
    NValues=zeros(1,3);
    for jj=1:3
        Sum1=sum(A(ii-3:ii-1,5+jj))+sum(A(ii+1:ii+3,5+jj));
        Value= (A(ii, 5+jj)-Sum1)/A(ii, 5+jj);
        if A(ii, 5+jj)<0 && Value>0.7
            NValues(1,jj)=A(ii,5+jj);
            A(ii,5+jj)=Sum1/6;
        end
    end
    if sum(abs(NValues))~=0,  X=[X;NValues]; end
end
if length(X(:,1))>1, X=X(2:end,:); end
xlswrite('Values.xlsx',X,1);