Import Options Missing Variable Flexibility Between Missing Record and Variables

Question

dpb 2023-5-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1959084-import-options-missing-variable-flexibility-between-missing-record-and-variables

回答： Piyush Dubey 2023-7-27

The import options object has the 'MissingValue' rule, but as far as I can tell it's an "all or none" affair, one either fills everything or leaves out a variable or record.

>> opt.MissingRule='omit'
Expected input to match one of these values:
'fill', 'error', 'omitrow', 'omitvar'

The real case often is there are blank records that should follow 'omitrow', but there may also be missing variable values that shouldn't omit the variable for that record but fill

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Piyush Dubey 2023-7-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1959084-import-options-missing-variable-flexibility-between-missing-record-and-variables#answer_1279452

Hi dbp,

While defining the import options object, there are multiple parameters that may be directly or indirectly linked with each other and a proper combination of these might help in attaining possible workarounds. ‘omitrow’ and ‘omitvar’ are options that exist and can be followed when an error is committed a particular sort of data type entry (including NULL) can be defined as error. To exercise other use cases different table options can be explored. Documentation for the same are attached below:

https://www.mathworks.com/help/matlab/import_export/importing-tabular-data-into-a-matlab-table-with-customized-options.html

https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html

https://www.mathworks.com/help/matlab/ref/matlab.io.text.delimitedtextimportoptions.html

Hope this helps.