TreatAsMissing must be a character vector or a cell array of character vectors containing nonnumeric text

Post Reply
matlab1
Site Admin
Posts: 4797
Joined: Thu Dec 15, 2016 9:30 am
Contact:

TreatAsMissing must be a character vector or a cell array of character vectors containing nonnumeric text

Post by matlab1 »

TreatAsMissing must be a character vector or a cell array of character vectors containing nonnumeric text
matlab1
Site Admin
Posts: 4797
Joined: Thu Dec 15, 2016 9:30 am
Contact:

Re: TreatAsMissing must be a character vector or a cell array of character vectors containing nonnumeric text

Post by matlab1 »

spreadsheetDatastore
Datastore for spreadsheet filesexpand


Description
Use a SpreadsheetDatastore object to manage large collections of spreadsheet files where the collection does not necessarily fit in memory. You can create a SpreadsheetDatastore object using the spreadsheetDatastore function, specify its properties, and then import the data using object functions.





TreatAsMissing — Text to treat as missing values
'' (default) | character vector | cell array of character vectors | string scalar | string array
Text to treat as missing values, specified as a single character vector, cell array of character vectors, string scalar, or string array. Values specified as TreatAsMissing are substituted with the value defined in the MissingValue property. For instance, if MissingValue is defined to be a NaN, and the TreatAsMissing is specified as 'NA'. Then, in the imported data, all occurrences of 'NA' are replaced by NaN.

This option only applies to numeric fields. Also, this property is equivalent to the TreatAsEmpty name-value pair argument for the textscan function.

When you change the value of this property, the datastore function reevaluates the values of the TabularTextDatastore properties.

Example: 'NA'

Example: {'-',''}

Data Types: char | cell | string





For more information,

https://www.mathworks.com/help/matlab/ref/matlab.io.datastore.tabulartextdatastore.html
Post Reply

Who is online

Users browsing this forum: No registered users and 17 guests