Checking for conditions in Dataset

5 views (last 30 days)
Siddharth Jain
Siddharth Jain on 6 Jul 2019
Commented: Siddharth Jain on 6 Jul 2019
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?

Answers (1)

madhan ravi
madhan ravi on 6 Jul 2019
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 Comment
Siddharth Jain
Siddharth Jain on 6 Jul 2019
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.

Sign in to comment.

Categories

Find more on Loops and Conditional Statements in Help Center and File Exchange

Products


Release

R2015b

Community Treasure Hunt

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

Start Hunting!