Replace some column values depending on a condition, MATLAB
- by darkcminor
I have a matrix like
A=
4.0000 120.0000 92.0000 0 0 37.6000 0.1910 30.0000
10.0000 168.0000 74.0000 0 0 38.0000 0.5370 34.0000
10.0000 139.0000 80.0000 0 0 27.1000 1.4410 57.0000
1.0000 139.0000 60.0000 23.0000 846.0000 30.1000 0.3980 59.0000
5.0000 136.0000 72.0000 19.0000 175.0000 25.8000 0.5870 51.0000
7.0000 121.0000 0 0 0 30.0000 0.4840 32.0000
I want to replace the values of the first column that are greater than '5' to 0, also in the second column if the values are in range 121-130 replace them by 0, if they are in range 131-140 replece by 1, 141-150 by 2, 151-160 by 3... so the result matrix would be
A=
4.0000 0.0000 92.0000 0 0 37.6000 0.1910 30.0000
0.0000 4.0000 74.0000 0 0 38.0000 0.5370 34.0000
0.0000 1.0000 80.0000 0 0 27.1000 1.4410 57.0000
1.0000 1.0000 60.0000 23.0000 846.0000 30.1000 0.3980 59.0000
5.0000 1.0000 72.0000 19.0000 175.0000 25.8000 0.5870 51.0000
0.0000 0.0000 0 0 0 30.0000 0.4840 32.0000
How to acomplish this?
I was trying something like
counter=1;
for i = 1: rows
if A(i,1) > 5
A(i ,1) = 0;
end
if A(i,2) > 120 && A(i,2) < 130
A(i ,2) = 0;
end
counter = counter+1;
end
Using a case could do the trick?