extract multiple submatrices from a large matrix based on specific criterion

1 次查看（过去 30 天）
Priscilla Schmitz
Priscilla Schmitz 2019-5-14
评论： madhan ravi 2019-5-14
I have a Matrix A (162301x13 double) which first column contains 625 different ID numbers (they repeat that is why i have 162301 rows) and the other columns contain SL values for 12 different frequency values.
i need to extract submatrices from this large matrix for each unique ID value. For example (see attached), ID 23 contains 8 rows of values for the SLs columns and i want to extract this submatrix from the large matrix.
Any ideas?
Thanks

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

采纳的回答

madhan ravi
madhan ravi 2019-5-14
编辑：madhan ravi 2019-5-14
T=readtable('mydatfile.csv')% Note here it’s just your filename;
Wanted = T(T.id==23,:) %
  9 个评论
显示 7更早的评论
Priscilla Schmitz
Priscilla Schmitz 2019-5-14
Just one last question, how do I conver this multiple cell arrays (1x379) in multiple matrices?
madhan ravi
madhan ravi 2019-5-14
cat(3,Wanted{:}) % works only if each cell has same number of rows otherwise keeping it this way is the only option.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by