How to concatenate selected data of two .mat files

3 次查看（过去 30 天）
Hugo
Hugo 2022-1-20
回答： Image Analyst 2022-1-20
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,

请先登录，再回答此问题。

采纳的回答

KSSV
KSSV 2022-1-20
Let A, B be your tables.
C = A ;
C.last = B.(10) ; % instead of last you give your required name
  2 个评论
Hugo
Hugo 2022-1-20
Hi,
Thank you for your swift reply. How can I use your code if I would like to use .mat files for my tables A,B and C?
Best regards,
KSSV
KSSV 2022-1-20
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.

请先登录，再进行评论。

更多回答（1 个）

Image Analyst
Image Analyst 2022-1-20
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.

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by