清空筛选条件
清空筛选条件

Conversion to double from cell is not possible.

287 次查看（过去 30 天）
Fabian Moreno
Fabian Moreno 2020-7-8
评论： Adam Danz 2020-7-10
Hi there, I am new in MATLAB and I have this problem "Conversion to double from cell is not possible", I uploaded a matrix with readtable and I delimited with (;). Then It made a matrix of 10200x3, in the third column I have values with "comma" decimal (25,7). I used str2double to change from cell array to double array, but the new value is (257). I would like to get the same value (25,7). Somebody could help me please.

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

采纳的回答

Adam Danz
Adam Danz 2020-7-8
编辑：Adam Danz 2020-7-8
There might be an option in readtable() or within the opts input that can specify what decimal character to use when reading in the data. I looked briefly but couldn't find what I'm imagining but I do recall that such an option exists. That would be the best solution, if possible.
To fix the data described in your question, first replace the commas in column 3 with periods.
% "C" is your cell array
C(:,3) = strrep(C(:,3),',','.');
then proceed with str2double.
d = str2double(C(:,3));
For tables
T.Var3 = strrep(T.Var3,',','.');
T.Var3 = str2double(T.Var3);
  3 个评论
显示 1更早的评论
Adam Danz
Adam Danz 2020-7-8
That's because your data is not a cell array. It's a table.
I've updated my answer.

请先登录，再进行评论。

更多回答（1 个）

Fabian Moreno
Fabian Moreno 2020-7-8
I have one more question, when I Convert strings to double precision values, the result is a number like this (23.700). I'm trying to take out the extra zeros with (round). But the zeros continue there. Any suggestion to eliminate the zeros?.
  6 个评论
显示 4更早的评论

请先登录，再进行评论。

类别

在 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