Hi, Attached a data file that I am working on. I want to replace N/A cells with -999. I also want to find empty cells (they appear as "" and NaN values or in the data file depending on the type of the column and replace them with -998. How can I identify these codes and replace them in a table? your help is greatly appreciated

finding and replacing problematic cells in a table

Wesso

2021 1 1

1 个回答

10 次查看（30 天）

0 个投票

matlab.zip

Hi,

Attached a data file that I am working on. I want to replace N/A cells with -999. I also want to find empty cells (they appear as "" and NaN values or <undefined> in the data file depending on the type of the column and replace them with -998. How can I identify these codes and replace them in a table? your help is greatly appreciated