Comparing 2 columns of a matrix
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Gautami Golani
am 23 Feb. 2019
Kommentiert: Star Strider
am 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 Kommentare
Akzeptierte Antwort
Star Strider
am 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 Kommentare
Weitere Antworten (1)
Image Analyst
am 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).
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!