finding and replacing problematic cells in a table

2 次查看(过去 30 天)
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

回答(1 个)

Cris LaPierre
Cris LaPierre 2021-1-1
Look into the standardizemissing,fillmissing, ismissing,and rmmissing functions

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by