How can I select n rows every m rows

Question

QuanCCC 2018-8-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415758-how-can-i-select-n-rows-every-m-rows

评论： QuanCCC 2018-8-23

It's a select several rows/extract rows in data question. My data looks like this:

a1 b1 c1
a2 b2 c2
a3 b3 c3
a10 b10 c10
a20 b20 c20
a30 b30 c30
a1 b1 c1
a2 b2 c2
a3 b3 c3
a10 b10 c10
a20 b20 c20
a30 b30 c30
a1 b1 c1
a2 b2 c2
a3 b3 c3
a10 b10 c10
a20 b20 c20
a30 b30 c30

I need to extract into a new data which only includes

a10 b10 c10
a20 b20 c20
a30 b30 c30
a10 b10 c10
a20 b20 c20
a30 b30 c30
a10 b10 c10
a20 b20 c20
a30 b30 c30

How can I do that? Thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Matt J 2018-8-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415758-how-can-i-select-n-rows-every-m-rows#answer_333721

编辑：Matt J 2018-8-22

在 MATLAB Online 中打开

This will work for any m,n.

m=3;
n=3;
e=1:size(yourdata,1);
idx=e(  (m+n):(m+n):end  ) - (n-1:-1:0).'  ;
newdata = yourdata(idx,:);

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

QuanCCC 2018-8-23

This is perfect. Thank you so much.

请先登录，再进行评论。

Answer 2

Matt J 2018-8-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415758-how-can-i-select-n-rows-every-m-rows#answer_333652

编辑：Matt J 2018-8-22

在 MATLAB Online 中打开

One way is by downloading MAT2TILES,

A=mat2tiles(yourdata,[3,3]);
newdata=cell2mat(A(2:2:end));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

QuanCCC 2018-8-22

Thank you Matt for editing my question. Now it looks better. But I just happened to give an example of every 3*3 subarray data. The actual data I have is: 27060 lines I don't need, then the next 12 lines I need to select, then the next 27060 lines I don't need, then the 12 lines I need. This doesn't sound like a sub-arrays.

请先登录，再进行评论。