I need to remove every other 9 rows of a matrix

Question

Joseph 2013-6-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80246-i-need-to-remove-every-other-9-rows-of-a-matrix

评论： Massimiliano Tondi 2021-3-12

This should be simple but its giving me some trouble. I have a matrix of 57 rows and 3 columns. This matrix is a condensed set of data from 3 data sets with 19 rows of data each. The first 9 rows of each individual data sets are unneeded and need to be removed. So in the full matrix I need to remove the first 9 rows of data, move down 10 rows, remove the next 9 rows of data, move down another 10 rows, and the remove the next 9 rows of data. Does anyone know how I can do this?

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

请先登录，再进行评论。

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

Answer 1

Matthew Eicholtz 2013-6-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80246-i-need-to-remove-every-other-9-rows-of-a-matrix#answer_90092

在 MATLAB Online 中打开

How about this?

r = 57; % total rows
c = 3;  % total columns
d = 19; % rows in each data set 
n = 9;  % remove first n rows in each data set
A = cumsum(ones(r,c)); % example data
A(mod(1:r,d)<=n & mod(1:r,d)>0,:) = [];

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

ADITHYAN 2015-4-22

Very elegant answer. Thanks a lot, helped me as well.

Massimiliano Tondi 2021-3-12

helped me as well, thanks a lot !

请先登录，再进行评论。

Answer 2

Andrei Bobrov 2013-6-26

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80246-i-need-to-remove-every-other-9-rows-of-a-matrix#answer_89955

编辑：Andrei Bobrov 2013-6-27

在 MATLAB Online 中打开

A  = randi(100,57,5); % your data
a = 19*ones(size(A,1)/19,1);
A(bsxfun(@plus,cumsum(a) - a + 1,0:8),:) = [];

2 个评论
显示无隐藏无

Joseph 2013-6-26

Thank you for your help. This works great for my data set of 57 rows but what if I had an increased data size.So for example say I had a data set of 190 rows or even more. How would I change this to accommodate for additional data? I attempted to run the code for a 190 row set and it didn't quite work.

Andrei Bobrov 2013-6-27

corrected

请先登录，再进行评论。

Answer 3

Jan 2013-6-26

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80246-i-need-to-remove-every-other-9-rows-of-a-matrix#answer_89961

在 MATLAB Online 中打开

A  = rand(57,5);
s1 = size(A, 1);
index           = zeros(1, s1);
index(1:19:s1)  = 1;
index(10:19:s1) = -1;
R = A(logical(cumsum(index)), :);

(not tested)

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

请先登录，再进行评论。

Answer 4

Matt Kindig 2013-6-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80246-i-need-to-remove-every-other-9-rows-of-a-matrix#answer_89947

编辑：Matt Kindig 2013-6-26

在 MATLAB Online 中打开

So, to confirm, you need to do the following:

remove rows 1-9 (9 rows)
retain rows 10-19 (10 rows)
remove rows 20-28 (9 rows)
retain rows 29-38 (10 rows)
remove rows 39-47 (9 rows)
retain rows 48-57 (10 rows)

I think this should do it:

M = [(1:57)', rand(57,2)];  %random data for illustration
npts = size(M,1);
nremove = 9;   %number of rows to remove at once
nretain = 10;  %number of rows to retain at once
%which removes to remove
removeRows = cell2mat(arrayfun(@(k) k:(k+nremove-1), 1:(nremove+nretain):npts, 'UniformOutput', false));
removeRows(removeRows>npts)=[];  %ignore rows beyond size of M
M(removeRows,:) = [];  %remove these rows