MATLAB: How to append matrix value from lookup list

lookup listmatrix manipulation

I have the following matrix A =

           0        34.5          10           3      22.753      8.9632
           0        34.5          10           7      22.753      8.9632
           0        68.9          10           3      22.753      8.9632
           0        68.9          10           7      22.753      8.9632
           0       137.9          10           3      22.753      8.9632
           0       137.9          10           7      22.753      8.9632
           0       206.8          10           3      22.753      8.9632
           0       206.8          10           7      22.753      8.9632
           0       275.8          10           3      22.753      8.9632
           0       275.8          10           7      22.753      8.9632
          10        34.5          10           3      22.753      8.9632
          10        34.5          10           7      22.753      8.9632
          10        68.9          10           3      22.753      8.9632
          10        68.9          10           7      22.753      8.9632
          10       137.9          10           3      22.753      8.9632
          10       137.9          10           7      22.753      8.9632
          10       206.8          10           3      22.753      8.9632
          10       206.8          10           7      22.753      8.9632
          10       275.8          10           3      22.753      8.9632
          10       275.8          10           7      22.753      8.9632

I want to insert a new column to the right containing values from the following lookup list

B =

           0        34.5       328.5
           0        68.9       415.6
           0       137.9       589.6
           0       206.8       727.9
           0       275.8       856.1
          10        34.5       307.4
          10        68.9         362
          10       137.9       541.6
          10       206.8       695.6
          10       275.8       856.1
          20        34.5       263.9
          20        68.9       337.5
          20       137.9       503.8
          20       206.8       635.3
          20       275.8         749
          30        34.5       224.9
          30        68.9       297.4
          30       137.9       437.9
          30       206.8       573.9
          30       275.8       673.1

The values in the new columns in A is based on the lookup list of B.

Manually, I would expect something like this

C =

           0        34.5          10           3      22.753      8.9632   328.5
           0        34.5          10           7      22.753      8.9632   328.5
           0        68.9          10           3      22.753      8.9632   415.6
           0        68.9          10           7      22.753      8.9632   415.6
           0       137.9          10           3      22.753      8.9632   589.6
           0       137.9          10           7      22.753      8.9632   589.6
           0       206.8          10           3      22.753      8.9632   727.9
           0       206.8          10           7      22.753      8.9632   727.9
           etc...

Notice the last column of C is based on the values in A column 1 and 2 which is matched with the lookup list in B column 1 and 2.

Can anyone help me.

Best Answer

Perhaps:

[LiA, LocB] = ismember(A(:, 1:2), B(:, 1:2), 'rows');
C           = [A, B(LocB, 3)]

Use ismembertol to consider numerical rounding errors.

Related Solutions

MATLAB: How can i classify the data

a = [ 0.47  15.905  8.434  14.018  1010.803  1458.32  148.46
0.34  18.346  8.282  16.443  1012.711  1460.69  140.41
0.4  17.459  8.355  15.547  1012.004  1459.89  132.98
0.82  15.881  8.441  13.991  1010.783  1458.32  124.75
1.52  17.944  8.262  16.059  1012.419  1460.16  117
2.29  20.022  8.169  18.144  1014.062  1462.37  109.74
3.07  20.03  8.163  18.154  1014.074  1462.37  109.74
3.9  20.033  8.165  18.156  1014.08  1462.4  102.94
4.69  20.033  8.158  18.16  1014.087  1462.38  96.59
5.53  20.036  8.157  18.163  1014.093  1462.4  90.6
6.3  20.036  8.154  18.164  1014.098  1462.4  84.98
7.13  20.039  8.152  18.168  1014.106  1462.41  79.68
7.94  20.038  8.149  18.169  1014.11  1462.41  74.73
8.74  20.046  8.147  18.178  1014.121  1462.43  70.09
9.45  20.045  8.147  18.176  1014.123  1462.44  65.75
10.03  20.051  8.151  18.18  1014.128  1462.47  61.75
10.56  20.051  8.151  18.179  1014.13  1462.48  61.75
10.89  20.051  8.151  18.179  1014.132  1462.48  57.93
11.3  20.051  8.153  18.178  1014.133  1462.49  54.35
11.72  20.052  8.154  18.178  1014.135  1462.51  51.01
11.8  20.052  8.155  18.178  1014.135  1462.51  50.33
11.9  20.054  8.154  18.181  1014.137  1462.51  47.7
12.15  20.053  8.155  18.179  1014.138  1462.52  45.66
12.25  20.042  8.155  18.168  1014.129  1462.51  42.84 ];

EDIT 2

a = sortrows(a,1);% THIS is added

z = a([1,end],1)/.5;
ii = (floor(z(1)):ceil(z(2)))';
T = array2table(a);
T.(char(string('a')+(size(a,2)+1))) = discretize(a(:,1),ii*.5);
T_out = varfun(@mean,T,...
                  'GroupingVariables','a8','InputVariables',2:size(T,2)-1);
n = numel(ii)-1;% THIS is added
lo = ismember((1:n)',T_out.a8);% HERE fixed
Z = nan(n,width(T_out));
Z(lo,:) = T_out{:,:};
Tout_out = array2table(Z,'VariableNames',T_out.Properties.VariableNames);

MATLAB: How to mirror a function vertically

close all; clear all; clc;

depth=[ 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.6 1.8 2 2.2 2.4 2.6 2.7 2.8 2.9 3 3.2 3.3 3.4 3.5 3.6 3.7 3.8 4 4.2 4.4 4.6 4.8 4.9 5 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 6 6.2 6.3 6.4 6.5 6.6 6.8 6.9 7 7.1 7.2 7.3 7.4 7.5 7.6 7.7 7.8 8 8.2 8.4 8.6 8.8 9 9.2 9.4 9.6 9.8 10 10.2 10.4 10.6 10.8 11 11.2 11.4 11.6 11.8 12 12.2 12.4 12.6 12.8 13 13.2 13.4 13.6 13.8 14 14.2 14.4 14.6 14.8 15 15.2 15.4 15.6 15.8 16 16.2 16.4 16.6 16.8 17 17.2 17.4 17.6 17.8 18 18.2 18.4 18.6 18.8 19 19.2 19.4 19.6 19.8 20 20.2 20.4 20.6 20.8 21 21.2 21.4 21.6 21.8 22 22.2 22.4 22.6 22.8 23 23.2 23.4 23.6 23.8 24 24.2 24.4 24.6 24.8 25 25.2 25.4 25.6 25.8 26 26.2 26.4 26.6 26.8 27 27.2 27.4 27.6 27.8 28 28.2 28.4 28.6 28.8 29 29.2 29.4 29.6 29.8 30]; rel_dose=[ 61.8 63.2 66 73.8 81.3 86.4 90.5 93.9 96 97.4 98.6 99.2 99.9 99.8 100.7 100 99.2 98.9 98 97.2 96.3 96.1 95.7 95.2 94.7 94.1 93.8 92.8 92.4 92.2 91.7 91.1 90.2 89.6 88.9 88.1 87.2 87.1 86 85.3 85 84.4 84 83.8 83.4 83 82.5 82.1 81.3 81.1 80.3 80.4 79.7 78.7 78.7 77.9 78 77.3 77.2 76.4 76.3 75.6 75.2 74.8 74.1 73.2 72.4 71.9 71.1 70.4 69.7 68.9 68 67.4 66.6 65.9 65.3 64.6 64 63.1 62.4 61.9 61.3 60.5 59.6 59.2 58.5 58 57.4 56.7 56.1 55.5 54.7 54.1 53.8 53 52.4 51.6 51.2 50.8 50.1 49.5 49 48.3 47.8 47.6 46.8 46.3 45.8 45.5 45.1 44.4 43.8 43.5 42.9 42.5 42 41.4 41 40.4 40.3 39.8 39.3 38.9 38.4 38 37.5 37.1 36.6 36.3 35.9 35.4 35.1 34.9 34.4 34.1 33.8 33.4 33 32.6 32.2 31.9 31.5 31.1 30.8 30.4 30.1 29.7 29.5 29.2 28.8 28.4 28.2 27.9 27.5 27.2 26.9 26.6 26.4 25.9 25.9 25.5 25.3 25.1 24.7 24.5 24.2 23.9 23.7 23.3 23.1 22.9 22.7 22.4 22.2];

Seperation_pt = find(depth==10); depth_1=depth(1:Seperation_pt); depth_2=zeros(1,length(depth_1)); depth_2(1)=depth_1(length(depth_1));

for i = 2:length(depth_1) increment=depth_1(i)-depth_1(i-1); depth_2(i)=depth_2(i-1)-increment; end

rel_dose_1=rel_dose(1:Seperation_pt);

figure; plot(depth_1,rel_dose_1, 'r', 'linewidth', 3);

xlabel('Depth (cm)'); ylabel('Relative Dose (%)'); title('(Normalized Relative Dose as a Function of Depth for a 6 MV POP; FS=10x10 cm2; separation=10 cm'); hold on

plot(depth_2,rel_dose_1, 'b', 'linewidth', 3);

Best Answer

Related Solutions

MATLAB: How can i classify the data

MATLAB: How to mirror a function vertically

Related Question