- Convert the matrices to the tables - https://www.mathworks.com/help/matlab/ref/array2table.html.
- Perform 'join' operation on the tables - https://www.mathworks.com/help/matlab/ref/table.join.html.
Mergin matrixes with multiple identifiers
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Oskar Lund
il 23 Ott 2020
Commentato: Peter Perkins
il 20 Nov 2020
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
0 Commenti
Risposta accettata
Ankriti Sachan
il 29 Ott 2020
Based on my understanding, you can do the following:
If this does not help, please provide an example to help me understand the query better.
1 Commento
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Matrices and Arrays in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!