How to import blanks cells as Nans

Question

Cristina 2015-4-27

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/213873-how-to-import-blanks-cells-as-nans

评论： Ahmed Nirjhar Alam 2020-7-23

I have a file (created in excel) with >100k rows and 22 columns. Many of the cells are blanks (not zeros). If I use csvread to import the data Matlab changes the banks to zeros. I cannot first change the blanks to 99999 because excel crashes. Is there a way to make Matlab import the blanks as Nan's?

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

请先登录，再进行评论。

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

Answer 1

Mohammad Abouali 2015-4-27

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/213873-how-to-import-blanks-cells-as-nans#answer_176913

在 MATLAB Online 中打开

sampledata.csv

use importdata():

a=importdata('sampledata.csv')
a =
       1     2     3     4     5
       1     2     3   NaN     5
       1   NaN     3     4     5
       1     2     3   NaN     5
       1     2     3     4     5
       1     2     3     4   NaN