MATLAB: How to concat the cell matrix (containing text) to numeric array

cell arraysmatrixmatrix arraystrings

i have two matrix A = size(20*1) containing number rr matrix containing True' or 'False'

   if(A(i)<1)
          rr{i}=['True'];
      else
          rr{i}=['False'];
      end

i wanted to concate these two matrix such that

A
0.8 True
1   False
....

and so on

A= horzcat(A,rr')

i got the following error

Error using horzcat
CAT arguments dimensions are not consistent.
Error in sv 
A= horzcat(A,rr')

Best Answer

Perhaps simply merging the data into one cell array:

>> A = [0.8; 1];
>> rr = {'True', 'False'};
>> C = num2cell(A);
>> C(:,2) = rr
C = 
    [0.8]    'True' 
    [  1]    'False'

Note that because these numeric and char arrays are in a cell array they will be displayed with their own array markers, [] for numeric arrays and '' for char arrays.

If you want to print the data without those markers, then you can use fprintf:

>> D = num2cell(A');
>> D(2,:) = rr;
>> fprintf(' %-10g   %s\n',D{:})
 0.8          True
 1            False

Related Solutions

MATLAB: Does the cellfun fails

"...however if I try to apply the same command again as..."

You have failed to take into account that inbetween running these two commands you have changed the data. So while the first cell array only contained scalar numeric (which is a bad way to store numeric data), the second time you call cellfun the cell array now also contains char vectors (lots of 'false', to be precise). Of course when you compare 'false'==1 then the output will be a vector like this:

>> 'false'==1
ans =
     0     0     0     0     0

and that is clearly not a scalar value, so your cellfun usage will fail unless you use 'uni',false and some more complex processing, or wrap the first argument function in any or something similar. Your third example give this error message

Function 'subsindex' is not defined for values of class 'cell'

because when you use the option 'UniformOutput',false then cellfun outputs a cell array, which cannot be used for indexing. So your attempt to use the output as an index will fail.

Here is a simpler approach using a numeric array (which it should be anyway):

>> m = cell2mat(a);
>> id0 = m==0;
>> id1 = m==1;
>> a(id0) = {'false'};
>> a(id1) = {'true'};
>> a
a = 
    'false'    'true'     [    2]    [    3]    [    4]    [    5]    [    6]    [    7]    [    8]    [    9]    [   10]    [   11]
    'true'     'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'
    [    2]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    3]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    4]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    5]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    6]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    7]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    8]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [    9]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [   10]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    [   11]    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'true'     'false'    'false'    'false'

Note that your row and column headers indicate that you should perhaps be using a table, or only storing the actual data (not the headers) in a simple numeric array. Then you could do this task very simply with some basic indexing:

>> c = {'false','true'};
>> b = c(1+m(2:end,2:end))
b = 
    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'false'    'false'    'false'    'false'
    'true'     'true'     'true'     'false'    'false'    'true'     'false'    'true'     'false'    'false'    'false'

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: Does the cellfun fails

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

Related Question