MATLAB: How to merge two tables when the key variables are not common

merge

I have two tables A and B with key variables. Most variables are the same.

A = [X,Y,K;
  100,200,1;
  300,400,2;
  500,600,3]
B = [P,Q,K;
  1000,2000,1;
  3000,4000,2;
  5000,6000,3;
  7000,8000,4]

how could I get

C = [X,Y,K,P,Q;
  100,200,1,1000,2000;
  300,400,2,3000,4000;
  500,600,3,5000,6000;
  Nah,Nah,4,7000,8000]

Best Answer

This is called an outerjoin:

A = array2table([100 200 1; 300 400 2; 500 600 3], 'VariableNames', {'X', 'Y', 'K'});
B = array2table([1000 2000 1; 3000 4000 2; 5000 6000 3; 7000 8000 4], 'VariableNames', {'P', 'Q', 'K'});
C = outerjoin(A, B, 'MergeKeys', true)

Other types of joins are innerjoin and just plain join.

Related Solutions

MATLAB: Adding labels to a matrix number

T=array2table(T);
T.CLASS=repmat(['b1';'b2'],3,1);
T.Properties.VariableNames={'A','B','C','D','CLASS'}

MATLAB: How to compare the elements of a matrix and fill another matrix with the elements of a vector

Since your t matrix is full of 0 and 1 you can take advantage of that and just do this

a = [0.9 0.8 0.7 0.6 0.5];
b = [0.1 0.2 0.3 0.4 0.5];
t = ff2n(n);
t1 = t.*a
t1 =
         0         0         0         0         0
         0         0         0         0    0.5000
         0         0         0    0.6000         0
         0         0         0    0.6000    0.5000
         0         0    0.7000         0         0
         0         0    0.7000         0    0.5000
         0         0    0.7000    0.6000         0
         0         0    0.7000    0.6000    0.5000
         0    0.8000         0         0         0
         0    0.8000         0         0    0.5000
         0    0.8000         0    0.6000         0
         0    0.8000         0    0.6000    0.5000
         0    0.8000    0.7000         0         0
         0    0.8000    0.7000         0    0.5000
         0    0.8000    0.7000    0.6000         0
         0    0.8000    0.7000    0.6000    0.5000
    0.9000         0         0         0         0
    0.9000         0         0         0    0.5000
    0.9000         0         0    0.6000         0
    0.9000         0         0    0.6000    0.5000
    0.9000         0    0.7000         0         0
    0.9000         0    0.7000         0    0.5000
    0.9000         0    0.7000    0.6000         0
    0.9000         0    0.7000    0.6000    0.5000
    0.9000    0.8000         0         0         0
    0.9000    0.8000         0         0    0.5000
    0.9000    0.8000         0    0.6000         0
    0.9000    0.8000         0    0.6000    0.5000
    0.9000    0.8000    0.7000         0         0
    0.9000    0.8000    0.7000         0    0.5000
    0.9000    0.8000    0.7000    0.6000         0
    0.9000    0.8000    0.7000    0.6000    0.5000
t2 = not(t.*a).*b
t2 =
    0.1000    0.2000    0.3000    0.4000    0.5000
    0.1000    0.2000    0.3000    0.4000         0
    0.1000    0.2000    0.3000         0    0.5000
    0.1000    0.2000    0.3000         0         0
    0.1000    0.2000         0    0.4000    0.5000
    0.1000    0.2000         0    0.4000         0
    0.1000    0.2000         0         0    0.5000
    0.1000    0.2000         0         0         0
    0.1000         0    0.3000    0.4000    0.5000
    0.1000         0    0.3000    0.4000         0
    0.1000         0    0.3000         0    0.5000
    0.1000         0    0.3000         0         0
    0.1000         0         0    0.4000    0.5000
    0.1000         0         0    0.4000         0
    0.1000         0         0         0    0.5000
    0.1000         0         0         0         0
         0    0.2000    0.3000    0.4000    0.5000
         0    0.2000    0.3000    0.4000         0
         0    0.2000    0.3000         0    0.5000
         0    0.2000    0.3000         0         0
         0    0.2000         0    0.4000    0.5000
         0    0.2000         0    0.4000         0
         0    0.2000         0         0    0.5000
         0    0.2000         0         0         0
         0         0    0.3000    0.4000    0.5000
         0         0    0.3000    0.4000         0
         0         0    0.3000         0    0.5000
         0         0    0.3000         0         0
         0         0         0    0.4000    0.5000
         0         0         0    0.4000         0
         0         0         0         0    0.5000
         0         0         0         0         0
t1+t2
ans =
    0.1000    0.2000    0.3000    0.4000    0.5000
    0.1000    0.2000    0.3000    0.4000    0.5000
    0.1000    0.2000    0.3000    0.6000    0.5000
    0.1000    0.2000    0.3000    0.6000    0.5000
    0.1000    0.2000    0.7000    0.4000    0.5000
    0.1000    0.2000    0.7000    0.4000    0.5000
    0.1000    0.2000    0.7000    0.6000    0.5000
    0.1000    0.2000    0.7000    0.6000    0.5000
    0.1000    0.8000    0.3000    0.4000    0.5000
    0.1000    0.8000    0.3000    0.4000    0.5000
    0.1000    0.8000    0.3000    0.6000    0.5000
    0.1000    0.8000    0.3000    0.6000    0.5000
    0.1000    0.8000    0.7000    0.4000    0.5000
    0.1000    0.8000    0.7000    0.4000    0.5000
    0.1000    0.8000    0.7000    0.6000    0.5000
    0.1000    0.8000    0.7000    0.6000    0.5000
    0.9000    0.2000    0.3000    0.4000    0.5000
    0.9000    0.2000    0.3000    0.4000    0.5000
    0.9000    0.2000    0.3000    0.6000    0.5000
    0.9000    0.2000    0.3000    0.6000    0.5000
    0.9000    0.2000    0.7000    0.4000    0.5000
    0.9000    0.2000    0.7000    0.4000    0.5000
    0.9000    0.2000    0.7000    0.6000    0.5000
    0.9000    0.2000    0.7000    0.6000    0.5000
    0.9000    0.8000    0.3000    0.4000    0.5000
    0.9000    0.8000    0.3000    0.4000    0.5000
    0.9000    0.8000    0.3000    0.6000    0.5000
    0.9000    0.8000    0.3000    0.6000    0.5000
    0.9000    0.8000    0.7000    0.4000    0.5000
    0.9000    0.8000    0.7000    0.4000    0.5000
    0.9000    0.8000    0.7000    0.6000    0.5000
    0.9000    0.8000    0.7000    0.6000    0.5000

Best Answer

Related Solutions

MATLAB: Adding labels to a matrix number

MATLAB: How to compare the elements of a matrix and fill another matrix with the elements of a vector

Related Question