MATLAB: How to add a column to a cell array based on existing values in another column

if statementloop

Hi,

Only a beginner so forgive me for the basic question… but I have a cell array (x) of dimensions 1310×2. Column 1 is a unique identifier; there are two possible values of the second column, either "A" or "B". I want to add a third column which I want to be "1" if Column 2 is "A" and "0" otherwise.

What is the most efficient way to carry this out?

Should I be using an 'if' statement with a loop?

If so, should I be adding a third (blank) column before carrying out the if statement and populating this with 1's or 0's?

Thanks!

Best Answer

One option is:

x(:,3) = deal({0});
x(ismember(x(:,2),'A'),3) = deal({1});

Related Solutions

MATLAB: How to change the entries in one column of a cell array based on the previous columns

To accomplish this I would suggest using a for loop to go through each row, and then an if statement inside the loop to determine the value of the fourth column. It looks like you don't need to stack your if statements in any way, so you should be fine with a single if statement and multiple elseifs.

for k = 1:size(data,1);
 if data(k,2)==0 && data(k,3)==0;
  data(k,4) = 1;
 elseif ...

MATLAB: Search string array column for a specific string

Have you tried ismember? You only need column 5, but you fed first argument of strcmp with the whole string array.

rowIdx = find(ismember(X(:, 5), search)); % row indices of X which contain any of search elements

Best Answer

Related Solutions

MATLAB: How to change the entries in one column of a cell array based on the previous columns

MATLAB: Search string array column for a specific string

Related Question