Fill missing cells NANs

5 views (last 30 days)
Sarah Yun
Sarah Yun on 28 Dec 2019
Answered: Cris LaPierre on 31 Jan 2020
Hi,
I imported data from textfile using data editor.
Some cells are <missing data>
This is string data.
All cells must be numerical or NAN
How can I fill the missing data cells with NAN?

Answers (1)

Cris LaPierre
Cris LaPierre on 31 Jan 2020
<missing> is the appropriate value for missing string data. From the doc:
Standard missing values depend on the data type:
  • NaN for double, single, duration, and calendarDuration
  • NaT for datetime
  • <missing> for string
  • <undefined> for categorical
  • ' ' for char
  • {''} for cell of character arrays
If you need NaN, read in your data as numbers instead of strings.

Tags

Community Treasure Hunt

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

Start Hunting!