How to get matlab to automatically read csv data with a manual input?

6 次查看（过去 30 天）

brian donnelly 2016-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309539-how-to-get-matlab-to-automatically-read-csv-data-with-a-manual-input

编辑： Walter Roberson 2016-10-28

I have a piece of code written that analyses (numerical) patient data e.g. age. I am using an if statement with a number of sub elseif statements to generate an output. The data to be analysed will ultimately produce a False / Positive output. The code is working but i want matlab to read the data automatically. I have used csvread and am attempting to introduce a for loop but this is where i get stuck. Any help would be grateful.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2016-10-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309539-how-to-get-matlab-to-automatically-read-csv-data-with-a-manual-input#answer_241053

在 MATLAB Online 中打开

Example:

num = csvread('YourFile.txt');
numrows = size(num, 1);
ticket_prices = zeros(numrow, 1);    %the output variable
for rownum = 1 : numrows
  thisrow = num(rownum, :);
    age = thisrow(7);    %for example, if the age were in column 7 of the row
    if age < 3
      ticket_price = 0;
    elseif age <= 5
      ticket_price = 4.99;
    elseif age <= 13
      ticket_price = 10.99;
    elseif age <= 18
      ticket_price = 15.84;
    else
      ticket_price = 206.18;
    end
    ticket_prices(thisrow) = ticket_price;
  end

13 个评论
显示 11更早的评论隐藏 11更早的评论

brian donnelly 2016-10-27

编辑：Walter Roberson 2016-10-27

在 MATLAB Online 中打开

Hi Walter,

Thanks for the reply.

This is an abstract of what i have. The complete code is much longer.

m = csvread ('TestDataSheet.csv');
for loop_m = 36:14
val1 = m(:,1);   %%Age in years
val2 = m(:,2);   %%Gender 
val3 = m(:,3);     %%Chest pain type
val4 = m(:,4);   %%Resting blood pressure
val5 = m(:,5);   %%Serum cholesterol in mg/dl
val6 = m (:,6);  %%Fasting blood sugar
val7 = m (:,7);   %%Resting electrocardiographic results
val10 = m (:,10);   %%ST depression induced by exercise relative to reset
val11 = m (:,11);  %%The slope of the peak exercise ST segment
val12 = m (:,12);    %%Number of major vessels coloured by flourosopy
val13 = m (:,13);    %%Heart condition
if val3 (n) <= 3 && val13 (n) <= 3 && val10 (n) <= 1.6 % top of tree, down far left hand side to far left value 
    result = 'F(86.69/4.0)';
        display (result)
elseif val3 (n) > 3 && val12 (n) > 0
    result = 'T(69.54/4.0)';
        display (result)
end
end

Can you tell for that where i have went wrong. Again i appreciate the help, I am quite new to matlab.

Walter Roberson 2016-10-27

在 MATLAB Online 中打开

m = csvread ('TestDataSheet.csv');
rows_to_examine = 36 : 36 + 14 - 1;   %14 rows
num_rows = length(rows_to_examine);
result = cell(num_rows, 1);
for row_idx = 1 : num_rows
    loop_m = rows_to_examine(row_idx);
    val1 = m(loop_m,1);   %%Age in years
    val2 = m(loop_m,2);   %%Gender 
    val3 = m(loop_m,3);     %%Chest pain type
    val4 = m(loop_m,4);   %%Resting blood pressure
    val5 = m(loop_m,5);   %%Serum cholesterol in mg/dl
    val6 = m(loop_m,6);  %%Fasting blood sugar
    val7 = m(loop_m,7);   %%Resting electrocardiographic results
    val10 = m(loop_m,10);   %%ST depression induced by exercise relative to reset
    val11 = m(loop_m,11);  %%The slope of the peak exercise ST segment
    val12 = m(loop_m,12);    %%Number of major vessels coloured by flourosopy
    val13 = m(loop_m,13);    %%Heart condition
    if val3 <= 3 && val13 <= 3 && val10 <= 1.6 % top of tree, down far left hand side to far left value 
        result{row_idx} = 'F(86.69/4.0)';
    elseif val3 > 3 && val12 > 0
        result{row_idx} = 'T(69.54/4.0)';
    else
        result{row_idx} = '???';
    end
end
fprintf('%s\n', result{:});