How to filter out rows from a very long table

Question

Reem RA 2022년 7월 14일

0
링크

이 질문에 대한 바로 가기 링크

https://kr.mathworks.com/matlabcentral/answers/1759525-how-to-filter-out-rows-from-a-very-long-table

댓글: Reem RA 2022년 7월 14일

How can I filter out rows for a huge table? I have pasted bellow a representative sample from the table (I would prefer if this could be done using loops?):

864.52	25	114.0714	-25.8369
864.56	26	114.1197	-26.0363
864.6	27	114.1688	-26.2351
864.64	28	114.2188	-26.4335
864.68	29	114.2697	-26.6313
864.72	30	114.3215	-26.8284
864.76	31	114.3742	-27.0249
864.8	32	114.4279	-27.2206
864.84	33	114.4826	-27.4155
864.88	34	114.5381	-27.6096
864.92	35	114.5943	-27.8027
864.96	36	114.6513	-27.9949
865.00	37  114.7092	-28.1861
865.04	38	114.7681	-28.3762
865.08	39	114.8279	-28.5653
865.12	40	114.8886	-28.7532
865.16	41	114.9503	-28.9399
865.2	42	115.0128	-29.1254
865.24	43	115.0763	-29.3097
865.28	44	115.1406	-29.4926
865.32	45	115.2058	-29.6742
865.36	46	115.2719	-29.8544
865.4	47	115.3387	-30.0332
865.44	48	115.4065	-30.2106
865.48	49	115.4751	-30.3866
865.52	50	115.5445	-30.5611
865.56	51	115.6146	-30.7339
865.6	52	115.6854	-30.9052
865.64	53	115.7568	-31.0749
865.68	54	115.8288	-31.2429
865.72	55	115.9013	-31.4091
%I want the code to say keep row 5, and row 10, and row 15, and row 20, ... and so on
%the table size is 31x5
%I want to have a new table with the resulted new filtered table

댓글 수: 0
이전 댓글 -2개 표시이전 댓글 -2개 숨기기

댓글을 달려면 로그인하십시오.

이 질문에 답변하려면 로그인하십시오.

Answer 1

Chunru 2022년 7월 14일

0
링크

이 답변에 대한 바로 가기 링크

https://kr.mathworks.com/matlabcentral/answers/1759525-how-to-filter-out-rows-from-a-very-long-table#answer_1006915

MATLAB Online에서 열기

a = [
864.52	25	114.0714	-25.8369
864.56	26	114.1197	-26.0363
864.6	27	114.1688	-26.2351
864.64	28	114.2188	-26.4335
864.68	29	114.2697	-26.6313
864.72	30	114.3215	-26.8284
864.76	31	114.3742	-27.0249
864.8	32	114.4279	-27.2206
864.84	33	114.4826	-27.4155
864.88	34	114.5381	-27.6096
864.92	35	114.5943	-27.8027
864.96	36	114.6513	-27.9949
865.00	37  114.7092	-28.1861
865.04	38	114.7681	-28.3762
865.08	39	114.8279	-28.5653
865.12	40	114.8886	-28.7532
865.16	41	114.9503	-28.9399
865.2	42	115.0128	-29.1254
865.24	43	115.0763	-29.3097
865.28	44	115.1406	-29.4926
865.32	45	115.2058	-29.6742
865.36	46	115.2719	-29.8544
865.4	47	115.3387	-30.0332
865.44	48	115.4065	-30.2106
865.48	49	115.4751	-30.3866
865.52	50	115.5445	-30.5611
865.56	51	115.6146	-30.7339
865.6	52	115.6854	-30.9052
865.64	53	115.7568	-31.0749
865.68	54	115.8288	-31.2429
865.72	55	115.9013	-31.4091];
whatyouwant = a(5:5:end, :)
whatyouwant = 6×5
0e+04 *

1617    0.0865    0.0029    0.0114   -0.0027
1622    0.0865    0.0034    0.0115   -0.0028
1627    0.0865    0.0039    0.0115   -0.0029
1632    0.0865    0.0044    0.0115   -0.0029
1637    0.0865    0.0049    0.0115   -0.0030
1642    0.0866    0.0054    0.0116   -0.0031