Comparing matrices and filling in the gaps

So,

I've got two matrices

a = [A;B;C;D;E;F]; %% The entire list of variables

b = [B;D;F, 5;13;6]; %% A set of data with missing variables and amounts of occurances in second coulmn

How can i get something that gives me something like this...

c = [A;B;C;D;E;F, 0;5;0;16;0;6]

[KSSV]

Read about fillmissing.

[Sam Fortescue]

i had a look at it but my data isnt showing NaN its just the data was not recorded at that location at that time period.

[Rik]

So the B vector describes that B, D, F are 5, 13, 6?

I think you should create an example with valid Matlab syntax and with a better description of what those letters are. It sounds like something I would use a struct for.

[Sam Fortescue]

yes thats correct. The basis of the syntax is that the letters are different suburbs within a area and I've deducted how many food complaints each suburb gets. However, the data that i recieved is quartly over 4.5 years. So, thats why i founnd out every location which recived a complaint (A). And my end goal would be able to put the occurances of complaints for each location for each time period into a graph to represent trends.

[Rik]

And what is the content of ABCDEF? Can you give a small example? Fake data is fine, as long as things like size and class are correct.

[Sam Fortescue]

it is just a table of strings:

a = {'Brisbane City'; 'Kelvin Grove', 'Fortitude Valley'}

[Rik]

That is not a table of strings, but a cell array of char arrays. These specifics matter. It also isn't valid Matlab syntax, as you have only 1 char array on the first line, and two on the second line.

Please provide correct examples for a and b. We will probably be able to help your create something. The ismember function or the containers.Map data type might be what you're looking for.

Answer 1

[Peter Perkins]

There are just so many things you can do with joins:

>> a = table(["A";"B";"C";"D";"E";"F"]);
>> b = table(["B";"D";"F"], [5;13;6]);
>> outerjoin(a,b,'Key','Var1','Type','left','RightVariables','Var2')
ans =
  6×2 table
    Var1    Var2
    ____    ____
    "A"     NaN 
    "B"       5 
    "C"     NaN 
    "D"      13 
    "E"     NaN 
    "F"       6