extract multiple submatrices from a large matrix based on specific criterion

1 次查看（过去 30 天）

Priscilla Schmitz 2019-5-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462067-extract-multiple-submatrices-from-a-large-matrix-based-on-specific-criterion

评论： madhan ravi 2019-5-14

Screen Shot 2019-05-14 at 1.27.56 PM.png

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

madhan ravi 2019-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/462067-extract-multiple-submatrices-from-a-large-matrix-based-on-specific-criterion#answer_374987

编辑：madhan ravi 2019-5-14

在 MATLAB Online 中打开

T=readtable('mydatfile.csv')% Note here it’s just your filename;
Wanted = T(T.id==23,:) %

9 个评论
显示 7更早的评论隐藏 7更早的评论

Priscilla Schmitz 2019-5-14

Just one last question, how do I conver this multiple cell arrays (1x379) in multiple matrices?

madhan ravi 2019-5-14

在 MATLAB Online 中打开

cat(3,Wanted{:}) % works only if each cell has same number of rows otherwise keeping it this way is the only option.

请先登录，再进行评论。

类别

Signal Processing Signal Processing Toolbox Transforms, Correlation, and Modeling Correlation and Convolution

在 Help Center 和 File Exchange 中查找有关 Correlation and Convolution 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by