How to merge or combine 2 datasets with different number of rows and different name of columns

4 次查看（过去 30 天）

显示更早的评论

Ngoc Nguyen 2022-5-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1712710-how-to-merge-or-combine-2-datasets-with-different-number-of-rows-and-different-name-of-columns

评论： Ngoc Nguyen 2022-5-10

2 个评论
显示无隐藏无

Raju 2022-5-6

在 MATLAB Online 中打开

Hi Ngoc,

You can make use of the table & joindata commands. Below is the similar example which you can useto achieve the same. Make sure you maintain the common id to join the data, In this case 151.04 & 151.08 have the same id 1 & 2 in both the table before joining it

table1=table([1;2;3],[151.04;151.08;151.11], [3.2634e+05;1.6518e+05;1.1548e+05], 'VariableNames', ["id", "mz", "sp58"]);
table2=table([0;1;2;4],[150.09;151.04;151.08;151.09], [217504.6;122152.8;561438.7;88868.3], 'VariableNames', ["id", "mz", "sp59"]);
table12 = joindata(table2,table1, 'Keys', ["id", "mz"]);

Thanks & Regards,

Raju

Ngoc Nguyen 2022-5-10

Dear Raju,

Thank you very much for your comment!

I tried the codes you suggested but the outcome has an error:

>> table1=table([1;2;3],[151.04;151.08;151.11], [3.2634e+05;1.6518e+05;1.1548e+05], 'VariableNames', ["id", "mz", "sp58"]);

table2=table([0;1;2;4],[150.09;151.04;151.08;151.09], [217504.6;122152.8;561438.7;88868.3], 'VariableNames', ["id", "mz", "sp59"]);

table12 = joindata(table2,table1, 'Keys', ["id", "mz"]);

Undefined function or variable 'joindata'.

I am using MATLAB (individual) version 2018b for academic use. I am still struggling with this error and trying to understand the reason before successfully applying your solution.

Thank you for your consideration!

Best regards,

Ngoc

请先登录，再进行评论。

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