How to filter out rows from a very long table

Question

Reem RA il 14 Lug 2022

0
Link

Link diretto a questa domanda

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

Commentato: Reem RA il 14 Lug 2022

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 Commenti
Mostra -2 commenti meno recentiNascondi -2 commenti meno recenti

Accedi per commentare.

Accedi per rispondere a questa domanda.

Answer 1

Chunru il 14 Lug 2022

0
Link

Link diretto a questa risposta

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

Apri in 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