Fill missing cells NANs

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?

Answer 1

[Cris LaPierre]

<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.