How to convert Nan to zero
823 views (last 30 days)
Show older comments
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.
0 Comments
Accepted Answer
More Answers (2)
Santosh Shakya
on 24 Dec 2021
i want to replace nan with 0 in an array
can you help me?
1 Comment
Walter Roberson
on 24 Dec 2021
a = rand(5,5)
a([2, 7, 23]) = nan
b = fillmissing(a, 'constant', 0)
%OR
c = a; c(isnan(c)) = 0
See Also
Categories
Find more on Spreadsheets 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!