how to ignore a value and jumps to next row for calculation?

1 次查看（过去 30 天）

ellora 2016-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/291023-how-to-ignore-a-value-and-jumps-to-next-row-for-calculation

评论： ellora 2016-6-20

New Microsoft Excel Worksheet.xlsx

in the matrix i have an strange number 999, I need to perform an averaging between two numbers to get a new value of u(i) u(i)=(u(i+1)-u(i-1))/2 but if u(i),or u(i+1) or u(i-1) comes 999 then it should skip this row and jump to next value in the table u(i). so that when i will get the new value of u(i), the value 999 remain undisturbed in it position and other value should not get affected by this value.

2 个评论
显示无隐藏无

Guillaume 2016-6-20

ellora, could you please give a short example of input and expected output.

Are you sure you want (u(i+1) - u(i-1))/2 and not (u(i+1) + u(i-1))/2, note the + instead of -?

ellora 2016-6-20

yeah sure, it is (u(i+1) - u(i-1))/2

请先登录，再进行评论。

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

采纳的回答

Guillaume 2016-6-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/291023-how-to-ignore-a-value-and-jumps-to-next-row-for-calculation#answer_226063

在 MATLAB Online 中打开

Probably the simplest thing, is to store the location of the 999, remove them, perform your averaging (which is then very straightforward as you don't have special cases anymore) and finally put back the 999:

v = [1 2 3 999 5 6 7 10 999 20 40 80 160] %example data
isspecial = v == 999; %logical array indicating the position of 999
filteredv = v(~isspecial);  %remove 999 from vector
%do your averaging any way you want. Not sure what you want to do at the edges
filteredv = conv(filteredv, [0.5 0 0.5], 'same'); %does u(i)=(u(i+1)-u(i-1))/2, use zero-padding at the edges
%now create a vector with filtered values and 999 in their original location
finalv = zeros(size(v));
finalv(~isspecial) = filteredv;
finalv(isspecial) = v(isspecial)

7 个评论
显示 5更早的评论隐藏 5更早的评论

Guillaume 2016-6-20

" my columns do not have equal number of 999 values". I assumed as much, the code above does not assume that there is the same number of 999 in each column.

Yes, please attach your matrix (as a mat file please), and show what output you expect for the first few values.

ellora 2016-6-20

u_inst2.mat

here is the file. the procedure you have used is correct, but i am unable to do it for all the columns at a time.

请先登录，再进行评论。

更多回答（2 个）

KSSV 2016-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/291023-how-to-ignore-a-value-and-jumps-to-next-row-for-calculation#answer_226060

在 MATLAB Online 中打开

You can get the indices of 999 using find..

idx = find(mymatrix==999)

Now you can do averaging by excluding idx..or make idx to zero and get avarage...

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

Guillaume 2016-6-20

find is not required most of the time and is usually a waste of time. You can use the logical array directly.

请先登录，再进行评论。

Shameer Parmar 2016-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/291023-how-to-ignore-a-value-and-jumps-to-next-row-for-calculation#answer_226062

在 MATLAB Online 中打开

Let us consider, you have values as follows as example:

u = [112, 54, 86, 547, 999, 458, 657, 999, 56, 422, 100];
for i = 2:(length(u)-1)
    if (u(i) ~= 999)
        u(i) = (u(i+1)-u(i-1))/2;
    else
        u(i) = 999;
    end
end