Matlab adding rows to a table from another table with different dimensions

Question

I have a table with dimensions 6x2. I have other table with dimensions 4x1, I tried to append the little table into the larger one but I couldn't do it because of the differences in dimensions. Do you have any suggestion to tackle this?

Code example:

id = {'AB';'ZX';'DF4';'CA';'AC';'FG'}
mean = [1.5;2;3;1.15;3.06;1]
table1 = table(id,mean);

id2 = {'ZZ';'ZB';'FG';'4FA'};
table2 = table(id2);
table2.Properties.VariableNames = {'id'};

I will then calculate the mean of the last 4 rows using an average of the first 6.

Finn · Accepted Answer · 2016-06-23 08:36:22Z

First of all and this is really important: dont call a variable "mean" as that is the average function in MATLAB.

i would recommend you to calculate them first and then concatenate the tables, but if you want it this way its possiible too. You just have to fill in something until you have the actual values

id = {'AB';'ZX';'DF4';'CA';'AC';'FG'};
mean_values = [1.5;2;3;1.15;3.06;1]; %way better than 'mean'
table1 = table(id,mean_values);

id2 = {'ZZ';'ZB';'FG';'4FA'};
table2 = table(id2);
table2.Properties.VariableNames = {'id'};
%add some sort of data like NaN 
table3=[table1;[table2 table(nan(height(table2),1),'Variablenames',{'mean_values'})]];

you could also use zeros or ones or any other number, but they maybe inflluence your calculation of the average(mean) while NaN does not:

mean([3 5 nan],'omitnan')

if you get an error while using mean saying 'Subscript indices must either be real positive integers or logicals.' you have to use

clear mean

or delete it manually from the workspace

Collectives™ on Stack Overflow

Matlab adding rows to a table from another table with different dimensions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related