Merge table with different rows
显示 更早的评论
I have two files with different rows but with the same number of columns and I want to combine it together but I am getting an error * All tables in the bracketed expression must have the same number of rows. *
file1 = readtable('306K-268K.csv'); file2 = readtable('266K-228K.csv'); Com = [file1 file2];
Thanks a lot for the help
采纳的回答
Star Strider
2018-11-2
Com = outerjoin(file1,file2);
See if that does what you want.
4 个评论
Shelender Kumar
2018-11-2
Star Strider
2018-11-2
The outerjoin function has additional arguments that you can use that could provide the result you want. It appears to be the only one of that group of functions that is compatible with your data.
MattyK
2022-2-9
Thanks very much for this solution, have always wanted it. It works perfectly
Star Strider
2022-2-9
更多回答（4 个）
madhan ravi
2018-11-2
编辑：madhan ravi
2018-11-17
2 个投票
You can't merge table with different number of size dimensions , use structure instead
8 个评论
Shelender Kumar
2018-11-18
madhan ravi
2018-11-18
编辑：madhan ravi
2018-11-18
A = [1.38E-01 -1.02E-05 -8.81E-02
1.54E-01 NaN -5.51E-02
6.41E+01 7.83E-06 1.09E+02 ]
B = [1.38E-01 -1.02E-05 -8.81E-02
1.54E-01 NaN -5.51E-02 ;
zeros(1,size(A,2))] %PADDED WITH ZEROS because matrix dimensions should be the same when concatenated
side_by_side=[A B]
Shelender Kumar
2018-11-18
madhan ravi
2018-11-18
编辑：madhan ravi
2018-11-18
file1 = readtable('306K-268K.csv');
file2 = readtable('266K-228K.csv');
A=table2array(file1);
B=table2array(file2);
size(A)
size(B)
A=[A;zeros(size(B,1)-size(A,1),size(B,2))];
side_by_side = [A B]
size(side_by_side) %should be 681*80 if it is then we have achieved it
Shelender Kumar
2018-11-18
madhan ravi
2018-11-18
A=[A;zeros(abs(size(B,1)-size(A,1)),size(B,2))];
Shelender Kumar
2018-11-18
madhan ravi
2018-11-18
Glad to help :)
Stéphane Rainville
2018-11-16
You're missing a semi-colon to invoke vertical concatenation ('vertcat') rather than default horizontal concatenation ('horzcat').
For instance, two tables with different number of rows (but same number of columns), this does NOT work:
myBigTable = [myTable1 myTable2];
But this does:
myBigTable = [myTable1; myTable2];
I was facing a similar problem when storing tables of different lengths in a cell array.
myTables{1} = myTable1;
myTables{2} = myTable2;
and using
bigTable = [myTables{:}]
did not work because unwrapping and concatenating cell contents invoked horizontal concatenation. You can't just stick a semi-colon in there, so I had to explicitly invoke vertical concatenation like this:
bigTable = vertcat(myTables{:});
2 个评论
Shelender Kumar
2018-11-17
编辑：Shelender Kumar
2018-11-17
Stéphane Rainville
2018-11-17
Ah I see. Then yeah, tables of different length would be a problem.
Peter Perkins
2018-11-6
"Merge" is kind of vague. It may be that you just need to add a semicolon to vertically concatenate:
Com = [file1; file2]
3 个评论
Shelender Kumar
2018-11-17
Peter Perkins
2021-11-8
The current way to do this is to create the same number of rows in the smaller matrix/table/whatever. That's already been shown in an earlier reply.
类别
在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
