How to convert Nan to zero

2013 8 25
3 个回答
回答已采纳
更新时间：2021 12 24
137 次查看（30 天）

0 个投票

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

45 个投票

To set all NaN in Q to zero:
Q(isnan(Q))=0;
Is that what you need?

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

Abdulaziz
Abdulaziz 2013-8-25
easy,fast and smart I really appreciate your urgent respond . Thans
Walter Roberson
Walter Roberson 2017-6-11
Carlos Gamarra comments to Laurent:
Fast and simple
Ambati Sathvik
Ambati Sathvik 2020-5-22
Thank you so much!!

请先登录，再进行评论。

更多回答（2 个）

Santosh Shakya
Santosh Shakya 2021-12-24

2 个投票

i want to replace nan with 0 in an array
can you help me?

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

Walter Roberson
Walter Roberson 2021-12-24
Ran in:
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

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by