How to import blanks cells as Nans

17 次查看（过去 30 天）
Cristina
Cristina 2015-4-27
评论： 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?

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

采纳的回答

Mohammad Abouali
Mohammad Abouali 2015-4-27
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
  3 个评论
显示 1更早的评论
Ahmed Nirjhar Alam
Ahmed Nirjhar Alam 2020-7-23
Is there any equivalent substitute for when I have a file with multiple datatypes(such as integers, doubles, strings) in different columns?

请先登录，再进行评论。

更多回答（1 个）

Stephen23
Stephen23 2015-4-28
编辑：Stephen23 2015-4-28
Here is a list of some functions that can import blank/missing data as NaN:
http://www.mathworks.com/help/matlab/ref/textscan.html
http://www.mathworks.com/help/matlab/ref/importdata.html
http://www.mathworks.com/help/matlab/ref/readtable.html
and you can find comprehensive lists of all file reading functions in the documentation:
http://www.mathworks.com/help/matlab/import_export/supported-file-formats.html

类别

在 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