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

17 visualizzazioni (ultimi 30 giorni)
Zeynab Mousavikhamene
Zeynab Mousavikhamene il 8 Ott 2019
Risposto: the cyclist il 8 Ott 2019
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 Commenti
Rik
Rik il 8 Ott 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 il 8 Ott 2019
Modificato: Zeynab Mousavikhamene il 8 Ott 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.

Accedi per commentare.

Accedi per rispondere a questa domanda.

Risposta accettata

the cyclist
the cyclist il 8 Ott 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.

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by