How to concatenate selected data of two .mat files

1 view (last 30 days)
Hugo
Hugo on 20 Jan 2022
Answered: Image Analyst on 20 Jan 2022
Hi,
I have two .mat files, named A.mat and B.mat. Those files have 1000 lines and 10 columns. they are both in format "Table".
I would like to create a new table, name C.mat, which is the file A.mat but has the last column of file B.mat added as an additional column.
Size(A.mat)=1000*10
Size(B.mat)=1000*10
Size(C.mat)=1000*11
The column 11 of the file C.mat is the column 10 of the file B.mat. The rest of the file C.mat is equal to the file A.mat
The file C.mat must be in the format double, as I have float numbers in all cells. Table2cell will do?
I thank you all in advance,
Best regards,

Accepted Answer

KSSV
KSSV on 20 Jan 2022
Let A, B be your tables.
C = A ;
C.last = B.(10) ; % instead of last you give your required name
  2 Comments
KSSV
KSSV on 20 Jan 2022
You said the mat files have tables. Load the mat files and instead of A and B use the respective file's table array variable.

Sign in to comment.

More Answers (1)

Image Analyst
Image Analyst on 20 Jan 2022
If t1 and t2 are your tables, how about just tacking on the right column?
t3 = [t1, t2(:, end)]
t1 and t2 both need to have the same number of rows. If not, look into the join() function.

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!