Replace 0 with nans in a table

50 次查看（过去 30 天）
Danielle Leblance
Danielle Leblance 2018-5-14
回答： Peter Perkins 2018-5-14
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
Peter Perkins 2018-5-14
The standardizemissing function should get you started.
Ameer Hamza
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.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by