Comparing 2 columns of a matrix

4 次查看（过去 30 天）
Gautami Golani
Gautami Golani 2019-2-23
评论： Star Strider 2019-2-24
I want to compare 2 columns of my matrix as shown below:
mat.png
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

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2019-2-23
Try this (using the accumarray (link) function):
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 个评论
显示 2更早的评论
Gautami Golani
Gautami Golani 2019-2-24
Thanks a lot for the explanation.

请先登录，再进行评论。

更多回答（1 个）

Image Analyst
Image Analyst 2019-2-23
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).
  1 个评论
Gautami Golani
Gautami Golani 2019-2-23
My code is as shown below. It's just a part of my entire program.
one.png
I'm trying to compare all the 3 values of the number 4.0000 in column 2 and find out the min of them.
Example: For 4.000 the corresponding values in column 2 are 0.0042, 0.0028 and 0.0015.
So my new matrix should have the min of these 3, which is 0.0015.
Thanks

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

产品


版本

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by