MATLAB Answers

How can I sort data from an excel file and assign ID's to binary classes?

1 view (last 30 days)
Michael Seed
Michael Seed on 16 Sep 2021
Commented: KSSV on 16 Sep 2021
num1 = xlsread('Smart_meter_data.xlsx', 'B2:AW93');
data = num1;
num2 = xlsread('Smart_meter_data.xlsx', 'AX2:AX93');
id = num2;
I have an excel file that is 92 rows of 48 columns of measured values, and the 49th column are the ID numbers for what is being measured in each row. How do I write an 'if statement' to see if each row contains measurements above a certain value, and if it does then the corresponding ID number in the last column is true? Logically I'm trying to do something like this, but this obviously isn't a working syntax.
if (data > 2)
id = yes
elseif (id~=yes)
id = no
end

Answers (1)

KSSV
KSSV on 16 Sep 2021
Edited: KSSV on 16 Sep 2021
You need not to use a loop. You can go by inequalities, where you will get logical indices as output. The logical indices have 1 where condition is true and 0 where condition is false. You can convert the logical to double using the function double.
id = data > 2 ;
  7 Comments
KSSV
KSSV on 16 Sep 2021
Check the class of data. It might be a string. Use readtable to load excel file data.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!