MATLAB: How to treat NaN elements in a cell array as a string in any release of MATLAB

MATLABxlsread

I have a cell array that consists of both numeric and string data. Some of the numeric data are NaNs. I want to replace the NaN values by a string.

Best Answer

You may use the attached M-function for this purpose.

NAN2STRCELL accepts a cell array as input. It searches for NaN elements and replaces them with the string 'NaNstring'. The output is the modified cell array.

Related Solutions

MATLAB: Release structure

Staying at the structs has some benefits if you use dynamic field names:

param.eps = 6;
param.beta = 0.99;
param.theta = 0.7532;
param.gamma = 0.5;
fields = fieldnames(param);
for i = 1:length(fields)
  aField = fields{i};
  fprintf('%s = %g\n', aField, param.(aField));
end

If you assign the variable "eps" dynamically, you will overwrite the built-in function with the same name. Such tricks will impede the debugging dramatically!

But if you really have a really good reason to need this really:

function FieldToVar(S)
F = fieldnames(S)
for i = 1:length(F)
  aF = F{i};
  assignin('caller', aF, S.(aF));
end

This is faster than an equivalent EVAL approach and less dangerous. Nevertheless, I think, this method is worse than using the dynamic field names directly.

MATLAB: Can I convert empty strings to NaNs automatically in a cell array

The CELLFUN command provides this functionality:

% Return a boolean array named 'empties' (with same dimensions as cell array
% 'A') with true for each empty element and false otherwise
empties = cellfun('isempty',A);
% Now change all the empty cells in A from empty strings '' to double NaN
A(empties) = {NaN};

Best Answer

Related Solutions

MATLAB: Release structure

MATLAB: Can I convert empty strings to NaNs automatically in a cell array

Related Question