Comparing 2 columns of a matrix
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Gautami Golani
il 23 Feb 2019
Commentato: Star Strider
il 24 Feb 2019
I want to compare 2 columns of my matrix as shown below:
For example, I have the number 4 in the first column occurring thrice. I need to compare it's corresponding values in column 2 and obtain the minimum value among them. I then need to store that value in another matrix.
Could someone suggest me a way to get this desired result.
Thanks and regards
0 Commenti
Risposta accettata
Star Strider
il 23 Feb 2019
A = [randi(10, 20, 1) rand(20,1)] % Create Data
[A1u,~,idx] = unique(A(:,1)); % Unique Values & Indices
MinVals = accumarray(idx, A(:,2), [], @(x)min(x)); % Find Minimum Of Each
Result = [A1u, MinVals] % Desired Result
Use your own matrix for ‘A’.
4 Commenti
Più risposte (1)
Image Analyst
il 23 Feb 2019
You can do this easily with unique() and histogram() or histcounts(). Since you didn't include your data in a way that's easy for us to code up, I assume you'd prefer to do it yourself, so give it a try. If you run into problems, attach your data and explain the problem(s).
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!