How to convert Nan to zero

912 次查看（过去 30 天）
Abdulaziz
Abdulaziz 2013-8-25
评论： Walter Roberson 2021-12-24
Hi guys; Please I need urgent help
I have matrix of experiment data in excel file, this excel matrix has some blank cells The problem is that the blank element shows as NaN when import the matrix to matlab for processing. Is there any function or .. to convert the Nan to zero
I appreciate your help.

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

采纳的回答

Laurent
Laurent 2013-8-25
To set all NaN in Q to zero:
Q(isnan(Q))=0;
Is that what you need?
  5 个评论
显示 3更早的评论

请先登录，再进行评论。

更多回答（2 个）

Santosh Shakya
Santosh Shakya 2021-12-24
i want to replace nan with 0 in an array
can you help me?
  1 个评论
Walter Roberson
Walter Roberson 2021-12-24
Ran in:
a = rand(5,5)
a = 5×5
0.9293 0.2265 0.4353 0.6769 0.2335 0.7836 0.5917 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 0.4922 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036
a([2, 7, 23]) = nan
a = 5×5
0.9293 0.2265 0.4353 0.6769 0.2335 NaN NaN 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 NaN 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036
b = fillmissing(a, 'constant', 0)
b = 5×5
0.9293 0.2265 0.4353 0.6769 0.2335 0 0 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 0 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036
%OR
c = a; c(isnan(c)) = 0
c = 5×5
0.9293 0.2265 0.4353 0.6769 0.2335 0 0 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 0 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036

请先登录，再进行评论。

Hernan Larriva
Hernan Larriva 2019-7-30
Great, Thank you from Barcelona

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by