MATLAB: Round in a cell array that also contains string

cell arraysMATLAB

Hello everyone,

I am trying to round figures in a cell array however in that same array I also have string types. round changes the value of the string therfore I can't use formulas like

cellfun(@(x)round(x,N),c)

I mean I don't how to integrate `isnumeric` to this formula.

Is there a fomula that knows to round only numeric number?

Thank you in advance.

Best Answer

idx = cellfun(@isnumeric,C);
C(idx) = cellfun(@(x)round(x,N),C(idx),'uni',0)

Related Solutions

MATLAB: Neat stacking of array and cell array

Where C is your cell array:

D = C.';
D(cellfun(@isempty,D)) = []; % not actually required: try without it!
M = vertcat(D{:})

MATLAB: Reading cell array from excel table, which contains different sizes of doubles

There might be a smoother method but this works with the data from your image.

file = 'Book1.xlsx';
opts = detectImportOptions(file);
opts = setvartype(opts, 'char');  
C = readcell(file,opts);   % you can also try readtable()
numIdx = cellfun(@isnumeric,C); 
C(numIdx) = cellfun(@num2str,C(numIdx),'UniformOutput',false);
Cnum = cellfun(@str2num,C,'UniformOutput',false)

Cnum =

3×4 cell array

{1×3 double} {1×3 double} {[ 1]} {[ 1]}

{[ 2]} {[ 2]} {1×2 double} {1×2 double}

{[ 3]} {[ 2]} {1×2 double} {1×2 double}

Cnum{1,1}

ans =

1 2 3

Best Answer

Related Solutions

MATLAB: Neat stacking of array and cell array

MATLAB: Reading cell array from excel table, which contains different sizes of doubles

Related Question