Check all values in a table if any is "NAN"

17 views (last 30 days)
I have a table that has multiple column and rows. I want to say if any value in the table was "NAN" then change the value from "NAN" to 1.
Any suggestion?
  2 Comments
Rik
Rik on 8 Oct 2019
This is not your first question. What have you tried so far on your own? And are you aware of the isnan function?
Zeynab Mousavikhamene
Zeynab Mousavikhamene on 8 Oct 2019
Edited: Zeynab Mousavikhamene on 8 Oct 2019
@Rik Yeah I know isnan. The problem I have is that I dont want to use for loop to search each element of the table.

Sign in to comment.

Accepted Answer

the cyclist
the cyclist on 8 Oct 2019
This may work for your case
tbl = fillmissing(tbl,'constant',1);
assuming the NaNs are the only values that count as missing for you.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!