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

2 ビュー (過去 30 日間)
Moustafa Abedel Fattah
Moustafa Abedel Fattah 2023 年 2 月 2 日
コメント済み: Voss 2023 年 2 月 9 日
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 件のコメント
Moustafa Abedel Fattah
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 日
編集済み: Voss 2023 年 2 月 2 日
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');
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;
Plot again, with new M for comparison:
You can use similar steps on your data.
  8 件のコメント
Voss 2023 年 2 月 9 日
You can substitute "another value" you want to use in place of the NaN in the code above.



Find more on Numeric Types in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by