How to replace NaN in tables?
2 views (last 30 days)
Show older comments
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?
0 Comments
Answers (1)
Peter Perkins
on 22 Feb 2018
You should look at ismissing, fillmissing, rmmissing, and at the various options in readtable and detectimportoptions.
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!