How to replace NaN in tables?

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

0 votos

You should look at ismissing, fillmissing, rmmissing, and at the various options in readtable and detectimportoptions.

Categorías

Etiquetas

Preguntada:

el 21 de Feb. de 2018

Respondida:

el 22 de Feb. de 2018

Community Treasure Hunt

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

Start Hunting!

Translated by