Importing large files to double with a "." as a missing value

3 次查看（过去 30 天）
Danielle Leblance
Danielle Leblance 2016-11-20
评论： Danielle Leblance 2016-11-20
I have many large files in excel . I am using the excel import function but the issue is that it shows all columns as cell columns because whenever there is a missing value the cell has a dot "." instead of nan or empty cell. Changing them manually is very tedious. Is there a way to force matlab to import all columns as vector columns while replacing the "." with a nan value?
  2 个评论
Star Strider
Star Strider 2016-11-20
It would be much easier to give you a specific solution if we had your file (or a representative part of it) to work with.

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2016-11-20
编辑：Guillaume 2016-11-20
Nowadays, there's hardly any reason to use xlsread when readtable can also read excel files and is a lot more powerful.
In your particular case:
mytable = readtable('yourexcelfile.xlsx', 'TreatAsEmpty', '.')
will replace all the '.' by NaN.
edit: fixed typo
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2016-11-20
That was a typo, the parameter was 'TreatAsEmpty'. Note that I did link the doc, so you could just have looked it up.

请先登录，再进行评论。

更多回答（1 个）

Danielle Leblance
Danielle Leblance 2016-11-20
attached the file. the number of rows in the real file is large

类别

在 Help Center 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by