add a string column to integer matrix
3 次查看(过去 30 天)
显示 更早的评论
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!
0 个评论
回答(1 个)
the cyclist
2016-6-5
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]
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!