How to use if statements to compare data from matlab with excel data?

Question

Kenny Chintama 2016-5-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283131-how-to-use-if-statements-to-compare-data-from-matlab-with-excel-data

编辑： Kenny Chintama 2016-5-11

Hey there guys, I'm new here and I'm doing a research for my thesis about eye detection. I've got the exact eye position in a .csv file as shown in this picture:

problem is, there are some of the frames that is not detected and needed to be skipped from the frameNum as you can see in this excel file, there is no frame 9, 10, 11, 12, 13 and many more.

    BB = step(EyeDetectKanan,muka); %in this line, the frameNum should be compared with the Frame column in excel.  
    boxRightEye = BB;

My proposed algorithm for this problem is: 1. If frameNum = Frame, then show the value of right x, right y, right w, right h (without the commas like in this picture)

2. If frameNum isn't in Frame, then skip into the next frameNum 3. This process will be continued until the end of the file.

My questions are, is it possible to use if statements between matlab and excel? and how can I do these algorithms I made?

Thanks. Sorry for the bad view and english...

3 个评论
显示 1更早的评论隐藏 1更早的评论

Kenny Chintama 2016-5-8

I think that's not the case here as I don't know how to use if statements between them.

Weird Rando 2016-5-8

在 MATLAB Online 中打开

Maybe something like in MATLAB?

for i = 1:10
      if i ~= 5
          continue
      end
      disp(i)
end

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-5-8

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283131-how-to-use-if-statements-to-compare-data-from-matlab-with-excel-data#answer_221306

在 MATLAB Online 中打开

for fn = 1 : frameNum
  [tf, idx] = ismember(fn, Frame);
  if tf
    rx = rightx(idx); ry = righty(idx); rw = rightw(idx); rh = righth(idx);
    lx = leftx(idx); ly = lefty(idx); lw = leftw(idx); lh = lefth(idx);
    ...
  end
end

7 个评论
显示 5更早的评论隐藏 5更早的评论

Walter Roberson 2016-5-9

在 MATLAB Online 中打开

for fn = 1 : frameNum
  [tf, idx] = ismember(fn, T.Frame);
  if tf
    thisrow = T(idx,:);
    rx = thisrow.rightX; ry = thisrow.rightY; rw = thisrow.rightW; rh = thisrow.rightH;
    lx = thisrow.leftX; ly = thisrow.leftY; lw = thisrow.leftW; lh = thisrow.leftH;
    ...
  end
end

Kenny Chintama 2016-5-11

编辑：Kenny Chintama 2016-5-11

It works. Big thanks mate. It still has one flaw though: some of the missing Frame in the .csv file is still shown in the result. It is shown as a direct copy-paste from the Frame before as you can see in this picture

There are no Frame 1319, 1320, 1324, and 1327 on this .csv

Meanwhile, there are in this result of the code. I tried to use continue but it shows only the missing Frame(s).

Big thanks for your help, mate.

请先登录，再进行评论。

Answer 2

Walter Roberson 2016-5-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/283131-how-to-use-if-statements-to-compare-data-from-matlab-with-excel-data#answer_221300

No, it is not possible to use "if" statements between excel and MATLAB.

You have two choices:

Read the entire file and discard what you do not need;
Read one line at a time and make decisions based upon the content.

To read the entire file at one time, xlsread(), readtable() and textscan() are all good routines.

To read one line at a time, textscan() can still be useful, but so can fgetl() together with strsplit()

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Kenny Chintama 2016-5-8

在 MATLAB Online 中打开

I've tried to use import data function in MATLAB and it does the job. now, i'm in a problem with loops.

 for x = 1:frameNum
    for y = 1:Frame
    if x == y
        fprintf('Sama dari %d\n', Frame);
    else fprintf('Kelaut aja\n');
    end
%     try
%         img = read(openVideo, x);
%     catch exception
%         continue;
    end
end