how can I get together 2 tables containing different number of rows and colomns?

Question

Okan Erisen 2023-12-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2061662-how-can-i-get-together-2-tables-containing-different-number-of-rows-and-colomns

回答： Drishti 2024-9-20，11:42

I have 2 tables. One of them is 2160x7 table and the other one is 9444x9 table. Each colomn of the tables has a different name. How can I get them together?

3 个评论
显示 1更早的评论隐藏 1更早的评论

Eric Sofen 2023-12-18

We're going to need more detail about the contents of the tables and how you want to combine them. What are the commonalities between the tables? But, as @Stephen23 says, the join functions are a good place to start.

Cris LaPierre 2023-12-18

I would recommend using the Join Tables Live Task to perform your join interactively. Once you find the settings that get you the result you want, you can convert the task to code.

Otherwise, please attach your data using the paperclip icon, as well as an example of what the output should be.

请先登录，再进行评论。

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

Answer 1

Drishti 2024-9-20，11:42

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2061662-how-can-i-get-together-2-tables-containing-different-number-of-rows-and-colomns#answer_1520070

在 MATLAB Online 中打开

Hi Okan,

For combining tables with different number of rows and columns you can refer to the MATLAB ‘join’ function.

The ‘join’ function is applicable if you have common columns or key variables. If the tables do not have any common column and differ in size as well, you can use ‘NaN’ values to facilitate the merging of tables.

Refer to the below code snippet for better understanding:

% Determine the maximum number of rows
maxRows = max(height(table1), height(table2));
% Pad the shorter table with NaN rows
if height(table1) < maxRows
    % Extend table1 with NaN
    table1{end+1:maxRows, :} = NaN;
end
if height(table2) < maxRows
    % Extend table2 with NaN
    table2{end+1:maxRows, :} = NaN;
end
% Horizontally concatenate the tables
combinedTable = [table1, table2];