add a string column to integer matrix

I have a Data matrix of 5 columns and many rows, all integers.

I wish to add a 6th column of strings, using a condition on the value of one of the columns (Lets say the 3rd):

If Data(:,3) == 1 , add 6th column string value 'Upper', and else- add it as 'Lower'.

the type of the finished array may be cell or table, because I will export it as a txt file.

Thanks!

Answer 1

[the cyclist]

Here's one way:

data = round(rand(7,5));

[m,n] = size(data);

textCol = cell(m,1);

upperIndex = data(:,3)==1;

textCol(upperIndex) = {'Upper'};
textCol(not(upperIndex)) = {'Lower'};

outputCell = [num2cell(data),textCol]

[yaniv friedman]

great! thanks