Conversion to double from cell is not possible.

2020 7 8
2 个回答
回答已采纳
更新时间：2020 7 10
40 次查看（30 天）

0 个投票

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.

2 个评论
显示 无 隐藏 无

madhan ravi
madhan ravi 2020-7-8
Mind sharing a screenshot/file of that table ?
Fabian Moreno
Fabian Moreno 2020-7-8
Hello Madhan, I don't mind here I attach the file and the screenshot. Thanks

请先登录，再进行评论。

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

 采纳的回答

Adam Danz
Adam Danz 2020-7-8
编辑：Adam Danz 2020-7-8

0 个投票

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更早的评论 隐藏 1更早的评论

Fabian Moreno
Fabian Moreno 2020-7-8
Hello Adam, I did it. But the answer in the first step "C(:,3) = strrep(C(:,3),',','.');" is the following
Warning: Inputs must be character vectors, cell arrays of character vectors, or string arrays.
Error using strrep
Conversion to double from table is not possible.
Fabian Moreno
Fabian Moreno 2020-7-8
Hi Adam, I did it. Thank you a lot :)
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

0 个投票

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更早的评论 隐藏 4更早的评论

Adam Danz
Adam Danz 2020-7-9
The zeros should go away after you convert to double. How are you doing that conversion? If your original question has been answered, please consider accepting the answer.
Fabian Moreno
Fabian Moreno 2020-7-9
The question has not been aswer, and I did the conversion in the same way that you taught me. Here is the way that I did
PADPE_Temp=readtable('PADPE_Temp.csv','Headerlines',8,'delimiter','/;');
>> PADPE_Temp.Var3 = strrep(PADPE_Temp.Var3,',','.');
PADPE_Temp.Var3 = str2double(PADPE_Temp.Var3);
The result is for example, 29.0000; 27.000...
I already tried "sprintfc('%0.1f',(x))", but It convert the number into a cell array again.
Adam Danz
Adam Danz 2020-7-9
Now I'm confused. I thought " Hi Adam, I did it. Thank you a lot :)" meant that the problem was solved.
The problem with the trailing 0s is a new problem.
The trailing 0s is likely a formatting issue.
https://www.mathworks.com/help/matlab/matlab_env/format-output.html
Fabian Moreno
Fabian Moreno 2020-7-9
Thank you Adam you helped me a lot. Everything was fine. :D

请先登录，再进行评论。

类别

在 帮助中心 和 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