Checking for conditions in Dataset

2019 7 6
1 个回答
更新时间：2019 7 6
2 次查看（30 天）

0 个投票

I have a dataset of a few rows and columns. I need to find out top 5 numbers from a particular column and check if the sum of these 5 numbers is greater than 50. Also, I have to check if any of the number in entire column if greater than 5?

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

回答（1 个）

madhan ravi
madhan ravi 2019-7-6

0 个投票

M = sort(matrix(:,specific_column));
top_5 = M(1:5);
top_5_greater_than_50 = sum(top_5) > 50;
There_exist = any(matrix(:,specific_column) > 5)

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Siddharth Jain
Siddharth Jain 2019-7-6
As per attached, the dataset named "Getcompo" has the data. I want to perform following operation on 5th column,i.e, weight. Also, if the sum of top 5 weights is greater than 50 or if there is a weight greater than 5, then the output of the operation should be stored as 1 else it should be zero. I need to perform this on a number of different datasets with unique index_id(column1).
Could you please help me out with that? Thanks.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Whos 的更多信息

产品

版本

R2015b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by