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

Convert a cell column of strings to doubles

6 次查看（过去 30 天）
Eli Dim
Eli Dim 2015-7-15
评论： Star Strider 2015-7-15
I have a cell column of strings which looks like the attached file. How can I convert the column to double-precision values?
  1 个评论
Stephen23
Stephen23 2015-7-15
Please try attaching your data again. Press then parperclip button, then both the Choose file and Attach file buttons.

请先登录，再进行评论。

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

采纳的回答

Star Strider
Star Strider 2015-7-15
See if this does what you want:
D = load('string_column.mat');
data = D.owner;
out = cellfun(@(x) str2num(char(x)), data);

更多回答（2 个）

Stephen23
Stephen23 2015-7-15
编辑：Stephen23 2015-7-15
If the data is a cell array of strings, then try using str2double:
>> A = {'1.2';'2.3';45.6789';'Inf'};
>> B = str2double(A);
B =
1.2000
2.3000
45.6789
Inf
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2015-7-15
编辑：Guillaume 2015-7-15
The column consists only of numeric values.
No! All but the last four cells of your cell arrays are actually cell arrays themselves.
Stephen23
Stephen23 2015-7-15
编辑：Stephen23 2015-7-15
The problem is that data is not a cell array of strings, as you think it is, but actually mostly it is a cell array of cells containing strings, except for the last four cells (which are strings):
>> iscellstr(owner)
ans =
0
>> owner(1:5)
ans =
{1x1 cell}
{1x1 cell}
{1x1 cell}
{1x1 cell}
{1x1 cell}
>> owner(end-6:end)
ans =
{1x1 cell}
{1x1 cell}
{1x1 cell}
'0'
'0'
'0'
'0'
You can solve this as follows:
>> idx = cellfun('isclass',owner,'cell');
>> owner(idx) = [owner{idx}];
>> out = str2double(owner);
>> out(1:5)
ans =
1
2
3
4
5
>> out(end-6:end)
ans =
2300
2301
2302
0
0
0
0
This is the data file that I used:

请先登录，再进行评论。

Guillaume
Guillaume 2015-7-15
str2double(vertcat(owner{:}))
works, because your each cell of your cell array (except for the last four) is actually itself a cell array which in turn contain the string.
The vertcat above convert your cell array of single cell arrays of strings into a cell array of strings.

类别

在 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