Removing NaN from matrix

I am trying to import an excel but the blank cells are coming through as NaN if I class them as a number which I need to do. I have attached a photo. I need the empty cells to be recognised as nothing, not 0 or NaN.

回答(1 个)

Sulaymon Eshkabilov
Sulaymon Eshkabilov 2020-11-27

0 个投票

Use isnan() and assign the value you want or remove the points containing NaNs. See help how to employ it: mathworks.com/help/matlab/ref/isnan.html?searchHighlight=isnan&s_tid=srchtitle

类别

帮助中心File Exchange 中查找有关 NaNs 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by