How to replace NaN in tables?

2 visualizaciones (últimos 30 días)
Hao Tang
Hao Tang el 21 de Feb. de 2018
Respondida: Peter Perkins el 22 de Feb. de 2018
So I have a large table with lots of NaNs when importing it from a text file. Is there any way to leave those cells blank when initially importing or delete the NaNs after importing? I've tried
HabExEnglishPropCopy(~any(~isnan(HabExEnglishPropCopy), :),:)=[];
but the errors say either "any" is not a defined variable or that isnan is not valid for "table" arguments. Any help?

Respuestas (1)

Peter Perkins
Peter Perkins el 22 de Feb. de 2018
You should look at ismissing, fillmissing, rmmissing, and at the various options in readtable and detectimportoptions.

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by