finding and replacing problematic cells in a table

6 visualizaciones (últimos 30 días)
Wesso
Wesso el 1 de En. de 2021
Respondida: Cris LaPierre el 1 de En. de 2021
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

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Cris LaPierre
Cris LaPierre el 1 de En. de 2021
Look into the standardizemissing,fillmissing, ismissing,and rmmissing functions

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by