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

2 次查看（过去 30 天）
Kenny Chintama
Kenny Chintama 2016-5-8
编辑： 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更早的评论
Kenny Chintama
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.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2016-5-8
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更早的评论
Walter Roberson
Walter Roberson 2016-5-9
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
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.

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2016-5-8
No, it is not possible to use "if" statements between excel and MATLAB.
You have two choices:
  1. Read the entire file and discard what you do not need;
  2. 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 个评论
Kenny Chintama
Kenny Chintama 2016-5-8
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
This code returns the exact Frame that is on the excel file, but it seems that y isn't increasing.
Oh yea, here is the excel data that I've imported to MATLAB
Thanks in advance.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by