Effective way to convert/create matrix from mixed cell/string

Question

JB 2018-4-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/398057-effective-way-to-convert-create-matrix-from-mixed-cell-string

评论： JB 2018-4-29

I have a cell array like the one below and I need a fast and effective way to 1) remove the empty columns, 2) convert the cells containing a string with "#" to the number after the "#" (6.504), and finally 3) create or convert the whole cell array to a data matrix like "data" below. Is there a smart way to do all this? Sometimes there might be more that one string located somewhere else, so I need a way to find everyone in the cell array. Any suggestions are highly appreciated.

array ={ 
    [47.4500]    ''    [23.9530]    ''    [12.4590]
    [34.1540]    ''    [15.1730]    ''    [ 9.6840]
    [45.2510]    ''    [23.3770]    ''    [13.0670]
    [29.9350]    ''    [14.8680]    ''    '# 6.504'}
data =[
    47.4500   23.9530   12.4590
    34.1540   15.1730    9.6840
    45.2510   23.3770   13.0670
    29.9350   14.8680    6.5040]

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Rik 2018-4-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/398057-effective-way-to-convert-create-matrix-from-mixed-cell-string#answer_317807

在 MATLAB Online 中打开

array ={
    [47.4500]    ''    [23.9530]    ''    [12.4590]
    [34.1540]    ''    [15.1730]    ''    [ 9.6840]
    [45.2510]    ''    [23.3770]    ''    [13.0670]
    [29.9350]    ''    [14.8680]    ''    '# 6.504'};
array=cellfun(@convert_to_value,array,'UniformOutput',false);
data=cell2mat(array);
function out=convert_to_value(in)
if ischar(in) && ~isempty(in) && strcmp(in(1),'#')
    out=str2double(in(2:end));
elseif isempty(in)
    out=[];
else
    out=in;
end
end