Changing values in a table

6 views (last 30 days)
Wesso
Wesso on 14 Jan 2021
Answered: Walter Roberson on 14 Jan 2021
M is a table where if a specific column in M is =1 the respective rows in the subsequent columns (starting at cl1 and ending at cl2) should be 1 as well. I tried something like this but it didn't work
X=table2array(M(:,cl1-1)); % where cl1 is the first column that i want to change its values
x0=find(X==1);
for i=1:length(x0)
for j=cl1:cl2 %cl2 is the last column that I want to change
M(x0(i),j)=1;
end
end
Any help is greatly appreciated

Accepted Answer

Walter Roberson
Walter Roberson on 14 Jan 2021
No loop should be needed.
X = M{:,cl1-1};
M{X == 1, cl1:cl2} = 1;

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!