Clear Filters
Clear Filters

finding and replacing problematic cells in a table

2 views (last 30 days)
Wesso
Wesso on 1 Jan 2021
Answered: Cris LaPierre on 1 Jan 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

Sign in to answer this question.

Answers (1)

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

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!