I need to replace some values with NaN and some values with zeros

1 次查看（过去 30 天）

Moustafa Abedel Fattah 2023-2-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1905586-i-need-to-replace-some-values-with-nan-and-some-values-with-zeros

评论： Voss 2023-2-9

Big_Test2023.jpg

Hi every one can help

in annexed figure I have table in left handside gives its corresponding curves and I want to replace some values in z1, z2, and z3 to be NaN and replace some values of zb to be zeros by using Matlab If -Condition ro get the right handside that gives the corresponding curves

Thanks in advance

M. Dahab

2 个评论
显示无隐藏无

Arif Hoq 2023-2-2

在 MATLAB Online 中打开

what is the condition?

if gBt >= any value
    z1= ????
elseif gBt == any value
    z2= ????
end

Moustafa Abedel Fattah 2023-2-3

Can you please use the excel file attached with Voss answer and write the complite code

请先登录，再进行评论。

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

回答（1 个）

Voss 2023-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1905586-i-need-to-replace-some-values-with-nan-and-some-values-with-zeros#answer_1162711

编辑：Voss 2023-2-2

在 MATLAB Online 中打开

data.xlsx

I've entered the values from your left-hand table into Excel and saved the attached xlsx file.

Read the file into a matrix and plot z1, z2, z3, and zb vs xc:

M = readmatrix('data.xlsx');

figure();

plot(M(:,1),M(:,3:end))

set(gca(),'YDir','reverse');

Modify the matrix by replacing certain elements with 0 or NaN:

% where gBt is not close to 0.808269 ...
idx = abs(M(:,2) - 0.808269) > 1e-6;
% ... replace z1, z2, z3 with NaN ...
M(idx,3:end-1) = NaN;
% ... and replace zb with 0
M(idx,end) = 0;