How can I compare row by row to get rid if reciprocols and get corresponding indices
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
hello, I have a data matrix looks like below.
A=[4 5 0 0 0 10 0 15 0 0.19218
4 5 0 0 0 15 0 20 0 0.06548
4 5 0 0 0 20 0 25 0 0.02662
4 5 0 0 0 25 0 30 0 0.01446
4 5 0 0 0 30 0 35 0 0.00708
4 5 0 0 0 35 0 40 0 0.00487
4 15 0 10 0 20 0 25 0 0.31673
4 15 0 10 0 25 0 30 0 0.09447
4 15 0 10 0 30 0 35 0 0.03430
4 15 0 10 0 35 0 40 0 0.02008
4 15 0 10 0 40 0 45 0 0.01002
4 15 0 10 0 45 0 50 0 0.00502
4 15 0 10 0 50 0 5 0 0.33494
4 10 0 15 0 5 0 0 0 0.19150
4 20 0 15 0 25 0 30 0 0.43342
4 20 0 15 0 30 0 35 0 0.10293
4 20 0 15 0 35 0 40 0 0.04998
4 20 0 15 0 40 0 45 0 0.02261
4 20 0 15 0 45 0 50 0 0.01038
4 20 0 15 0 50 0 55 0 0.00523
4 20 0 15 0 55 0 10 0 0.54030
4 15 0 20 0 10 0 5 0 0.37795
4 15 0 20 0 5 0 0 0 0.06513
];
Basically,I want compare row by row based on column [ 2 4 6 8]. for example,first row column 2,4, 6,8 is 5,0,10,15. and the 14th row column 2,4,6,8 is 10,15,5,0. In this case, I need the index of the two rows since I only want one row. For a second example,please compare 2nd and 15th row,2nd row has 5,0,15,20 and 15th row has 15,20,5,0. This is just part of my data, I have many reciprocol measurements which is roughly the same as I showed above.If anyone knows how can I solve this problem,please let me know. I do not want change the order of my data. Thanks
0 Commenti
Risposta accettata
Sean de Wolski
il 29 Ott 2012
Look at using the various outputs from unique().
doc unique
3 Commenti
Sean de Wolski
il 29 Ott 2012
So use the 'rows' flag on the subset that you need. I.e. extract the columns you want to count and then look at unique rows of this. If you could make your example smaller with the expected results we might be able to help more. The matrix you show us is huge and we don't know what you expect.
Show us an example with a 5x4 matric and the results from it.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Matrix Indexing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!