Change value in Matlab table in multiple columns

17 ビュー (過去 30 日間)
YaaW 2022 年 10 月 11 日
コメント済み: Ghazwan 2022 年 10 月 11 日
I have a large table and want to change the values in specific columns (columns 16:41) to a different number. So for example if the number 3 is given in one of the 26 columns, this needs to be changed to 0, a number 2 to a 1 and a number 1 to a 2. I tried to do it with a loop but it didn't work and I can write a code for each of the 26 columns separately, but there must be an easier way. I also tried what I typed below where m is my dataset, but got an error 'incorrect use of '=' operator.'
(m{:,16:41} == 3) = 0;
Anyone who knows how to do this?

回答 (1 件)

Ghazwan 2022 年 10 月 11 日
編集済み: Ghazwan 2022 年 10 月 11 日
Say you matrix is A
for ii=1:length(A(:,1))
for jj=16:41
if A(ii, jj)==3, A(ii, jj)=0; end
if A(ii, jj)==1, A(ii, jj)=2; end
if A(ii, jj)==2, A(ii, jj)=1; end
  4 件のコメント
Ghazwan 2022 年 10 月 11 日
we would not know what the issue is without looking at the data.


Community Treasure Hunt

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

Start Hunting!

Translated by