Mergin matrixes with multiple identifiers

1 回表示 (過去 30 日間)
Oskar Lund
Oskar Lund 2020 年 10 月 23 日
コメント済み: Peter Perkins 2020 年 11 月 20 日
Hi
I have two (or several matrices), which are datasets with an identifier for year and company, and then they have different data. One of the matrix have more data on each unique year and firm, and the other only has one observation for each year and firm, and some year / firm can be represented in only one of the matrixes.
So i need to link these matrixes together, so the year/firm that is not represented in both matrices are removed, and if there is more observations in matrix A with same year/firm it will have the data from matrix B repeated each time that year / firm is represented in matrix A.
Is there any function that can do this or do i have to run through alot of loops / if statements or what's the approach?
If needed i can provide the data :-)
Best regards,
Oskar

採用された回答

Ankriti Sachan
Ankriti Sachan 2020 年 10 月 29 日
Based on my understanding, you can do the following:
  1. Convert the matrices to the tables - https://www.mathworks.com/help/matlab/ref/array2table.html.
  2. Perform 'join' operation on the tables - https://www.mathworks.com/help/matlab/ref/table.join.html.
If this does not help, please provide an example to help me understand the query better.
  1 件のコメント
Peter Perkins
Peter Perkins 2020 年 11 月 20 日
It sounds like this would specificaly be innerjoin.

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeMultidimensional Arrays についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by