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

Answer 1

[Peter Perkins]

The standardizemissing function should get you started.

Answer 2

[Ameer Hamza]

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.