How could I import an excel file with NAN value into MATLAB?

11 次查看（过去 30 天）
Bella
Bella 2020-6-28
编辑： Anjaneyulu Bairi 2024-1-31

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

回答（1 个）

Anjaneyulu Bairi
Anjaneyulu Bairi 2024-1-31
编辑：Anjaneyulu Bairi 2024-1-31
Hi,
I understand that you are trying to import an Excel file that has Nan values in it. You can use the "readtable" function to import an excel file in MATLAB, and if you have NaN as a string, then use the "TreatAsMissing" option while reading the excel file.
Here is the example :
dataTable = readtable(filename, 'TreatAsMissing', {'NaN'});
Here is the documentation link for "readtable" : https://in.mathworks.com/help/matlab/ref/readtable.html
Hop this helps.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by