looping through rows one at a time putting each row through a set of if statements to create a table of outcomes

Question

M4L 2020-12-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/671833-looping-through-rows-one-at-a-time-putting-each-row-through-a-set-of-if-statements-to-create-a-table

评论： Rena Berman 2021-5-6

Hey Guys. I am looking help with some code I wish to write. I have used code to write a decision tree from weka and take data from an Excel file manually by typing in each variable when prompted.

I have done this code fine but I want to make this efficient and instead take the data from the Excel file, then row by row put it through my set of if and elseif statements of the tree. The aim is to determine the outcome of the patient based on numerous variables.

column 1 is age

column 2 is gender

column 3...etc for 13 columns

There are 90 patients so 90 rows.

Here is the start

file = uigetfile ('.csv'); 
table = readtable(file);
t = cell2mat(table2cell(table));

Then I assume I create variables from that matrix :

age = t(:,1);
gender = t(:,2);
chest_pain_type = t(:,3);

Here is where I get stuck. Also there are two possible outcomes T or F

patient_outcome = '';
for this_row = t.' %what do i do here i tried 
    if (chest_pain_type>3) & (serum_cholestoral>0) & (st_depression>0.8) & (gender>0)
        patient_outcome = 'T';
    elseif (chest_pain_type>3) & (serum_cholestoral>0) & (st_depression>0.8) & (gender<=0) & (heart_condition>3)
        patient_outcome = 'T';
    elseif (chest_pain_type>3) & (serum_cholestoral>0) & (st_depression>0.8) & (gender<=0) & (heart_condition<=3) & (exercise_induced_angina>0)
        patient_outcome = 'F';
    end
end

Lastly then I want it to make a list of the outcomes for each patient (row) either T or F.

4 个评论
显示 2更早的评论隐藏 2更早的评论

Rik 2020-12-3

在 MATLAB Online 中打开

Question originally posted by malachy magee retrieved from Google cache:

looping through rows one at a time putting each row through a set of if statements to create a table of outcomes

Hey Guys. I am looking help with some code I wish to write. I have used code to write a decision tree from weka and take data from an Excel file manually by typing in each variable when prompted.

I have done this code fine but I want to make this efficient and instead take the data from the Excel file, then row by row put it through my set of if and elseif statements of the tree. The aim is to determine the outcome of the patient based on numerous variables.

column 1 is age

column 2 is gender

column 3...etc for 13 columns

There are 90 patients so 90 rows.

Here is the start

file = uigetfile ('.csv'); 
table = readtable(file);
t = cell2mat(table2cell(table));

Then I assume I create variables from that matrix :

age = t(:,1);
gender = t(:,2);
chest_pain_type = t(:,3);

Here is where I get stuck. Also there are two possible outcomes T or F

patient_outcome = '';
for this_row = t.' %what do i do here i tried 
    if (chest_pain_type>3) & (serum_cholestoral>0) & (st_depression>0.8) & (gender>0)
        patient_outcome = 'T';
    elseif (chest_pain_type>3) & (serum_cholestoral>0) & (st_depression>0.8) & (gender<=0) & (heart_condition>3)
        patient_outcome = 'T';
    elseif (chest_pain_type>3) & (serum_cholestoral>0) & (st_depression>0.8) & (gender<=0) & (heart_condition<=3) & (exercise_induced_angina>0)
        patient_outcome = 'F';
    end
end

Rik 2020-12-3

You can edit your question to put back the original title and content (and add the csv you attached to the comment you deleted).

Deleting things and changing the username is not generally an indication of good intentions, so go ahead and prove my cynicism wrong.

Rena Berman 2021-5-6

(Answers Dev) Restored edit

请先登录，再进行评论。

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

Answer 1

Image Analyst 2020-12-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/671833-looping-through-rows-one-at-a-time-putting-each-row-through-a-set-of-if-statements-to-create-a-table#answer_562078

在 MATLAB Online 中打开

Attach a CSV file so we can get started helping you. In the meantime, you probably want to do something like

numRows = height(t); % or size(t, 1)
patient_outcome = false(numRows, 1);
for row = 1 : numRows
    if (chest_pain_type(row)>3) &&&& (serum_cholestoral(row)>0) && (st_depression(row)>0.8) && (gender(row)>0)
        patient_outcome(row) = true;
    elseif (chest_pain_type(row)>3) && (serum_cholestoral(row)>0) && (st_depression(row)>0.8) && (gender(row)<=0) && (heart_condition(row)>3)
        patient_outcome(row) = true;
    elseif (chest_pain_type(row)>3) && (serum_cholestora(row)l>0) && (st_depression(row)>0.8) && (gender(row)<=0) && (heart_condition(row)<=3) && (exercise_induced_angina(row)>0)
        patient_outcome(row) = false;
    end
end