readcell is filling cell locations with "1x1 missing"

101 次查看（过去 30 天）
David Teitge
David Teitge 2019-5-31
评论： Stephan Piotrowski 2022-1-21
I am using R2109a and it is recommended to use readcell instead of xlsread. Readcell is slower than xlsread and it is returning "1x1 missing" instead of an empty cell when reading an .xlsx file. I don't know what logical I can use to remove these cell locations without brute forcing the problem. Does anyone else know what I can do to fix this?
Capture.PNG
  2 个评论
Josef Shaoul
Josef Shaoul 2020-1-11
The other answers did not work for me. readtable was very slow, and the cellfun(missing...) solution gave empty columns.
The simple, stupid solution is use readcell (faster than xlsread) and just a double loop over the raw cell data to convert <missing> to NaN. That yielded the same result as xlsread.
Would be ven better if the next version would restore the result from xlsread to readcell, because now the cell array that is imported cannot be saved again in an Excel file!
Stephan Piotrowski
Stephan Piotrowski 2022-1-21
@Josef Shaoul I experienced extremely slow readtable, but found that calling it as readtable(input,'basic',true) greatly improved the performance.

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2019-6-4
If your data (excluding header) is purely numeric, you'd be better off using readmatrix instead of readcell. If your date is heterogeneous you'd be better off using readtable. The matrix/table will use less memory than a cell array and more crucially make it very easy to remove rows with <missing> entries with rmmissing.
t = rmmissing(readtable(youfile))
With a cell array, rmmissing will only work if the cell array only contain char vectors.

更多回答（1 个）

Jon Martinez
Jon Martinez 2019-6-4
I've had the same problem reading a CSV file and managed to substitute all missing cells with this command:
your_file = readcell(your_path);
your_file(cellfun(@(x) any(ismissing(x)), your_file)) = {''};
The cellfun command will give you a logical array that mantains the structure of the original cell array. Hope it helps.
  2 个评论
David Teitge
David Teitge 2019-6-6
Thanks! I did not try your answer because the other answer suggested using another function which works better than readcell. I still appreciate it!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by