Convert a cell column of strings to doubles
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Eli Dim
el 15 de Jul. de 2015
Comentada: Star Strider
el 15 de Jul. de 2015
I have a cell column of strings which looks like the attached file. How can I convert the column to double-precision values?
1 comentario
Stephen23
el 15 de Jul. de 2015
Please try attaching your data again. Press then parperclip button, then both the Choose file and Attach file buttons.
Respuesta aceptada
Star Strider
el 15 de Jul. de 2015
See if this does what you want:
D = load('string_column.mat');
data = D.owner;
out = cellfun(@(x) str2num(char(x)), data);
2 comentarios
Más respuestas (2)
Stephen23
el 15 de Jul. de 2015
Editada: Stephen23
el 15 de Jul. de 2015
>> A = {'1.2';'2.3';45.6789';'Inf'};
>> B = str2double(A);
B =
1.2000
2.3000
45.6789
Inf
3 comentarios
Stephen23
el 15 de Jul. de 2015
Editada: Stephen23
el 15 de Jul. de 2015
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
el 15 de Jul. de 2015
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.
0 comentarios
Ver también
Categorías
Más información sobre Data Type Conversion en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!