Use of TreatAsEmpty to replace table values
36 views (last 30 days)
Hello, im trying to import a .xsl doc to matlab using the next code:
The file contains 3 columns with different values. The problem is that some random cells are empty so I been using 'TreatAsEmpty' to convert those empty spaces to NaN.
When I open the data, only column 3 shows with the NaN. Column 1 and 2 still have empty cells "". No matter what value or character I try to substitute, only the last column is always affected.
I'm missing something?
dpb on 23 Aug 2021
'TreatAsEmpty' — Placeholder text to treat as empty value
character vector | cell array of character vectors | string | string array
Placeholder text to treat as an empty value, specified as the comma-separated pair consisting of
'TreatAsEmpty' and a character vector, cell array of character vectors, string, or string array.
Table elements corresponding to these characters are set to NaN.
'TreatAsEmpty' only applies to numeric columns in the file, and readtable does not accept
numeric literals, such as '-99'.
Undoubtedly, the other columns are nonnumeric. It's possible they're supposed to be interpreted as numeric but owing to the missing values are not discerned as such by the default data type recognition logic built into readtable. Prior to R2020b readtable did not do as exhaustive a search as detectImportOptions does.
As @ChrisR notes, it's much easier if we can see the file itself, but you may need to get more explicit with the import options object.