How could I import an excel file with NAN value into MATLAB?
조회 수: 5 (최근 30일)
이전 댓글 표시
답변 (1개)
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.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!