Clear Filters
Clear Filters

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

9 views (last 30 days)

Answers (1)

Anjaneyulu Bairi
Anjaneyulu Bairi on 31 Jan 2024
Edited: Anjaneyulu Bairi on 31 Jan 2024
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.

Tags

Community Treasure Hunt

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

Start Hunting!