How to replace NaN in tables?

2 次查看（过去 30 天）
Hao Tang
Hao Tang 2018-2-21
回答： Peter Perkins 2018-2-22
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?

请先登录，再回答此问题。

回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by