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

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

Answer 1

[KSSV]

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 ;

[Michael Seed]

Will that change the ID number? For example, in my excel file rows 2 through 47 belong to ID 50 and rows 48 through 93 belong to ID 51. I'm trying to write a script where if a data value in one of the rows is greater than 2 then the ID number will be on a list of true ID numbers and if an ID number isn't on the list of true ID numbers then it goes on a list of not true ID numbers.

[KSSV]

The indices of id and ID number will remain same; they wont change.

[Michael Seed]

I think maybe I haven't explained myself very well. Each row of the data reperesents 1 day's worth of measurements taken every 30 minutes. Each unit was monitored for 46 days. Which is why there are multiple rows and multiple columns belonging to each ID number. Im trying to write a script where if any value in any row is above 2 then the ID number at the end of the row goes on a list of true, and if an ID isn't on the true list it goes on the not true list. Not every row belonging to an ID number will be above 2 which is why I can't make a script where I sort by values less than 2. The ID numbers themselves can't be changed to new values.

[Michael Seed]

num1 = xlsread('Smart_meter_data.xlsx', 'B2:AW93');

data = num1;

num2 = xlsread('Smart_meter_data.xlsx', 'AX2:AX93');

id = num2;

if id = data > 2;
    disp ('EV: ')
    display (id)
else
    disp ('Not EV: ')
    display (id)
end

I'm getting an error saying the = needs to be ==

[KSSV]

Which line shows error?

[Stephen23]

@KSSV: this line, which is not valid MATLAB syntax:

if id = data > 2;

@Michael Seed: forget about IF, use logical indexing and FPRINTF.

[KSSV]

Check the class of data. It might be a string. Use readtable to load excel file data.