Replace 0 with nans in a table
显示 更早的评论
I am attaching a table,
for the first row , I would like to replace zeros with nans for columns 8 to 13. This problems is repetitive in my codes where many times i have to replace 0 with nans where sometimes columns are a combination of categorical , string and number values. I am wondering if there is any code that would assign these nans across all column types without a problem
回答（2 个）
Peter Perkins
2018-5-14
1 个投票
The standardizemissing function should get you started.
Ameer Hamza
2018-5-14
This will replace 0 from column 8 to 13 with nan,
Tb1{:,8:13}(Tb1{:,8:13}==0) = nan
nan belongs to double class, so you cannot add it to categorical or char columns. For those column you will have to choose an appropriate default value.
类别
在 帮助中心 和 File Exchange 中查找有关 NaNs 的更多信息
2018-5-14
2018-5-14
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
