Replace 0 with nans in a table

68 vues (au cours des 30 derniers jours)
Danielle Leblance
Danielle Leblance le 14 Mai 2018
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

Réponses (2)

Peter Perkins
Peter Perkins le 14 Mai 2018
The standardizemissing function should get you started.

Ameer Hamza
Ameer Hamza le 14 Mai 2018
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.

Catégories

En savoir plus sur Numeric Types dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by