Select columns from a table and add them into another table

Hey all,

I have C1 and C2. Each one is (1 x 2) means that containing 2 tables inside. I want to copy column numbers 5, 6, and 8 from all tables in C1 to the exact table in C2 (after the first column of C2 and before other columns).

I think I should use vertcat and then use groupsummary but unfortunately don't know how to do that.

As my C1 and C2 have a very large size I just cut part of them and attached them, original C1 and C2 are 1 x 85.

% This is not a code but I want something like this
%copy C1{1, 1}.column5,column6,column8
%paste to C2{1, 1}>>> in front of first existing column

%copy C1{1, 2}.column5,column6,column8
%paste to C2{1, 2}>>> in front of first existing column

Any advice is truly helpful

Thank you so much

Best regards

Answer 1

[fred ssemwogerere]

Hello, you don't need to use "groupsummary" or "vertcat" for this. Instead use; "addvars". I think this should do nicely:

% Taking "C2" to be the cell with tables you are copying into, using data from tables in cell "C1"
for i=1:size(C2,1)
    for j=1:size(C2,2)
        % Replace "Var5", "Var6", and "Var8" with names of your table column variables in cell "C1" at positions: 5,6,and 8 as you mentioned
        C2{i,j}=addvars(C2{i,j},C1{i,j}.Var5,C1{i,j}.Var6,C1{i,j}.Var8,'Before',2);
        % "2" specifies to insert the data after the first column
    end
end

[BN]

Thank you all is so perfect.

after that the added columns name replaced by var1, var2, var3, then I tried to rename them using this code:

varNames={'Station_Name', 'lat', 'lon', 'date','SPI_3month','SPI_6month','SPI_12month','SPI_24month'};
for k=1:size(C2,1)
    for y=1:size(C2,2)
        CEdit{k,y}.Properties.VariableNames=varNames;
    end
end

but it doesn't do anything. do you know is there any way to have C1 column name instead of var1, var2, ...?

Thank you again

[fred ssemwogerere]

Hello, all that is not required, just make this small edit to the code above on line 3 (I have added a field: "NewVariableNames"). Change the input arguments; "Var5","Var6", "Var8", according to the names you want to use

% Taking "C2" to be the cell with tables you are copying into, using data from tables in cell "C1"
for i=1:size(C2,1)
    for j=1:size(C2,2)
        % Replace "Var5", "Var6", and "Var8" with names of your table column variables in cell "C1" at positions: 5,6,and 8 as you mentioned
        C2{i,j}=addvars(C2{i,j},C1{i,j}.Var5,C1{i,j}.Var6,C1{i,j}.Var8,'Before',2,'NewVariableNames',{'Var5','Var6','Var8'});
        % "2" specifies to insert the data after the first column
    end
end

[BN]

Hello, Thank you. It works like a charm