extract multiple submatrices from a large matrix based on specific criterion
1 view (last 30 days)
Show older comments
Priscilla Schmitz
on 14 May 2019
Commented: madhan ravi
on 14 May 2019
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
0 Comments
Accepted Answer
madhan ravi
on 14 May 2019
Edited: madhan ravi
on 14 May 2019
T=readtable('mydatfile.csv')% Note here it’s just your filename;
Wanted = T(T.id==23,:) %
9 Comments
madhan ravi
on 14 May 2019
cat(3,Wanted{:}) % works only if each cell has same number of rows otherwise keeping it this way is the only option.
More Answers (0)
See Also
Categories
Find more on Data Distribution Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!