Cell array data to double conversion

95 次查看（过去 30 天）
Wouter Wizard
Wouter Wizard 2019-11-7
评论： Guillaume 2019-11-8
Hi all,
I have a cell array that I want to transform to a double array. Then I would like to fill in the double array with data from cell arrays. To solve this problem I have tried two things:
  • I have tried cell2mat, which gave a result that I couldent interpret and didnt work.
  • I tried str2double, this does not give an error, but it writes only NaN values in the double array.
The names of the variables are
  • Comp_all: cell array
  • dat: translate cell to double
  • dat2013: double array which I would like to fill in
How can I transfer both numeric and non-numeric data from cel arrays to double arrays?
The code is used to do this looks like:
dat = str2double(Com_all);
dat2013 = zeros(length(dat),5);
dat2013(1:end,1) = dat(1:end,1);
  7 个评论
显示 5更早的评论
Wouter Wizard
Wouter Wizard 2019-11-7
Another problem that I face is that I have the right information filtered in one of the cell arrays. I want to use that array as index for other cell arrays to extract the right data from it. However, I get an error that I cannot use a cell array for indexing.
To create input for the table I need the extracted data from the cell arrays. But I cannot translate the cell arrays into double arrays which allow indexing.
Guillaume
Guillaume 2019-11-8
Stephen's advice: "Use a table. A table is probably the best way to [work with your type of data"
Note that I already gave you that advice (and plenty more...) several days ago in a question that you then deleted (so I completely wasted my time helping you).

请先登录，再进行评论。

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

采纳的回答

CAM
CAM 2019-11-7
Assuming each cell has only one entry, try using cellfun with str2double to convert the cell array of strings to a cell array of doubles, then use cell2mat.
Air code (untested; may need adjustment):
dblComp_all = cellfun(@str2double, Comp_all);
dat = cell2mat(dblComp_all);
  3 个评论
显示 1更早的评论
Wouter Wizard
Wouter Wizard 2019-11-7
Thank you for replying CAM7, and providing a new code that I can test.
I tried to run the code and it gave this error:
Error in cell2mat (line 42)
cellclass = class(c{1});
Error in Assignment (line 55)
dat = cell2mat(dblCom_all);
Wouter Wizard
Wouter Wizard 2019-11-8
With a fresh look and some modifications in my data your answer results in the correct solution. The lines that work for me are:
data = cellfun(@(s) strrep(s, ' ', ''), data, 'UniformOutput', false);
dbldata = cellfun(@str2double, data);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by